How to clean the dataset? (avoid semi colons)

[lulu43366]

Good morning to the community.
I would like to know how to clean the dataset. I don'yt know if my excel sheet "Santé3" is not well formatted or my code.

from pandas import read_csv
import matplotlib.pyplot as plt
import seaborn as sns
import numpy as np
import numpy.ma as ma

dataset = pd.read_csv('Santé3.csv', encoding='latin-1')
dataset

[deanhystad]

The separator in your CSV file is ';'. The default separator for the pandas read_csv command is ','. You have to tell pandas that your CSV file uses a different separator.

[lulu43366]

Thank you for your reply deanhystad. What could be a good line of program to tell pandas that my CSV file uses a different separator?

[deanhystad]

Read the documentation for pandas read_csv().

[Yoriz]

https://pandas.pydata.org/pandas-docs/st...d_csv.html
sep

[lulu43366]

As you recommended to me, I read the delimiters in pandas read_csv function and I explained that ; is the delimited used in my Excel sheet.

from pandas import read_csv
import matplotlib.pyplot as plt
import seaborn as sns
import numpy as np
import numpy.ma as ma

dataset = pd.read_csv('Santé3.csv', sep= ';', encoding='latin-1')
dataset

And now, it is in a better format. Thank you!