pandas reading CSV data formatted with comma for thousands separator
The answer to this question should be short:
df=pd.read_csv('filename.csv', thousands=',')
Pass param thousands=','
to read_csv
to read those values as thousands:
In [27]:
import pandas as pd
import io
t="""id;value
0;123,123
1;221,323,330
2;32,001"""
pd.read_csv(io.StringIO(t), thousands=r',', sep=';')
Out[27]:
id value
0 0 123123
1 1 221323330
2 2 32001