Converting a pandas dataframe column values from string to float [duplicate]

Question

I have a data frame with columns A, B, and C as follows:

df:

A    B    C

1990 1  1,00,000
2000 2  2,00,000
2001 3  3,00,000

I want to convert the column C from object to float. For that, I run the following command:

df["C"].astype(float)

It gives the error:

ValueError: could not convert string to float: '1,00,000'

How do I convert the column to float or int?

Serial Lazer · Accepted Answer · 2020-11-17 06:51:34Z

1

Try this:

df["C"].str.replace(",", "").astype(float)

answered Nov 17, 2020 at 6:51

Serial Lazer

1,6691 gold badge9 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1