Using astype(int) for strings with thousand separator

[Barry Scott]

> On 14 Nov 2021, at 15:41, Mahmood Naderan via Python-list <python-list at python.org> 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)

remove the "," from the sting seems the simplest things to do.

Use string's replace() to remove the comma.

Barry

> 
> I get the following error
> 
>   ValueError: invalid literal for int() with base 10: '1,024'
> 
> 
> How can I fix that? Any idea?
> 
> 
> 
> Regards,
> Mahmood
> -- 
> https://mail.python.org/mailman/listinfo/python-list