Problem with converting a string that contains numbers to a numbers data type

Question

Currently, I'm working with a column called 'amount' that contains transaction amounts. This column is from the string datatype and I would like to convert it to a number data type.

The problem I ran into was that the code I wrote to convert the string data type to numbers worked but the only problem is that when I removed the ',' in the code below and changed it to numbers, the decimals were added which causes extremely high values in my data. So, 100000,95 became 10000095. I used the following code to convert my string data type to numbers:

df["amount"] = df["amount"].str.replace(',', '')
df['amount'] = pd.to_numeric(df['amount'], errors='coerce')

Can someone help me with this problem?

EDIT: Not all values contain decimals. I'm looking for a solution for only the values that contain a ','.

jezrael · Accepted Answer · 2021-11-19 10:05:22Z

2

You need repalce by comma if need floats:

df["amount"] = df["amount"].str.replace(',', '.')

edited Nov 19, 2021 at 10:05

answered Nov 19, 2021 at 9:59

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

1 Comment

MLP99 Over a year ago

This was the thing I was looking for, thanks!

Collectives™ on Stack Overflow

Problem with converting a string that contains numbers to a numbers data type

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related