Pandas Dataframe.to_csv decimal=',' doesn't work

Question

In Python, I'm writing my Pandas Dataframe to a csv file and want to change the decimal delimiter to a comma (,). Like this:

results.to_csv('D:/Data/Kaeashi/BigData/ProcessMining/Voorbeelden/Voorbeeld/CaseEventsCel.csv', sep=';', decimal=',')

But the decimal delimiter in the csv file still is a . Why? What do I do wrong?

Answer 1

If the decimal parameter doesn't work, maybe it's because the type of the column is object. (check the dtype value in the last line when you do df[column_name])

That can happen if some rows have values that couldn't be parsed as numbers.

You can force the column to change type: Change data type of columns in Pandas. But that can make you lose non numerical data in that column.