pandas cant replace commas with dots-CodePudding

Help me plz.

I have this dataset:

i cant replace commas (',') with dots ('.')

When i load this dataset with:

df = pd.read_csv('/content/drive/MyDrive/data.csv', sep=',', decimal=',')

it still contains commas, for example in the value ''0,20'

when i try this code:

df = df.replace(',', '.')

it runs without errors, but the commas still remain, although other values in the dataset can be changed this way...

CodePudding user response：

You can do it like this:

df = df.replace(',', '.', regex=True)

But keep in mind that you need to convert the columns to integer type (the ones that have the issues) because as for now they are as of type object.

You can check for those cases with the below command:

df.dtypes