How to properly create a csv file in Excel to upload and read correctly in a Python DataFrame?

Question

Python

In Excel there is an array
saved as CSV (comma delimited).
Loading into Python using DataFrame.
The information is unloaded, but only in a SINGLE column, instead of the 12 columns that were originally in the Excel file.
I have already downloaded and read csv files many times (not made by me), everything was in order, I saw the columns.
As a result, I have the following unpleasant picture at the output
. Help with advice on how to fix everything?

Answer 1

Use settings before saving
Or script before using in dataframe

Answer 2

where does Excel work if you work with CSV?
specify separators correctly, everything will work out
pandas-docs.github.io/pandas-docs-travis/io.html#i...

Answer 3

Save as CSV (comma delimited).

In Excel, semicolon when exporting to csv. In python, the csv module has an option to set a delimiter other than comma.