Values changed after converting object type column to string column type Python

Question

I have two columns in my pandas dataframe

Current selling price      New selling price
  0.0374                         0.03927
  0.1154                         0.12117
  0.0424                         0.04452
  0.1154                         0.12117
  0.1062                         0.11151
  0.035                          0.03675

Both the column are of type object. To do some analysis I want to convert them to string type so I used the below code.

df['Current selling price'] = df['Current selling price'].astype('string')
df['New selling price'] = df['New selling price'].astype('string')

After conversion some of the values in the column changed with long decimal values.

 Current selling price           New selling price
   0.0374                        0.039270000000000006
   0.1154                        0.12117000000000001    
   0.0424                        0.044520000000000004
   0.1154                        0.12117000000000001
   0.1062                        0.11151000000000001
   0.035                         0.036750000000000005

Can anyone help me to solve this issue.

jezrael · Accepted Answer · 2022-08-18 10:49:28Z

1

It is precision float problem, you can try round values:

df['New selling price'] = df['New selling price'].astype(float).round(5).astype('string')

edited Aug 18, 2022 at 10:49

answered Aug 18, 2022 at 10:32

jezrael

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

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

Collectives™ on Stack Overflow

Values changed after converting object type column to string column type Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related