Using astype(int) for strings with thousand separator

[Thomas Jollans]

On 14.11.21 16:41, Mahmood Naderan via Python-list wrote:
> Hi
>
> While reading a csv file, some cells have values like '1,024' which I mean they contains thousand separator ','. Therefore, when I want to process them with
>
>    row = df.iloc[0].astype(int)


If you are reading a CSV with pandas.read_csv, that function takes a 
parameter 'thousands' that should do what you're looking for (see 
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_csv.html)

>
> I get the following error
>
>    ValueError: invalid literal for int() with base 10: '1,024'
>
>
> How can I fix that? Any idea?
>