python/pandas : Pandas changing the value adding extra digits in values

Asked Oct 12 '20 at 02:33

Active Oct 12 '20 at 02:33

Viewed 57 times

I am reading a csv file thru pandas which is like below -

Country, Longitude, Latitude
Netherland,48.436252,-124.068561
Netherland,48.436252,-124.068561
Netherland,48.436252,-124.068561

After doing the processing it is changing the values of Latitude for 2 of the rows like below.

Country, Longitude, Latitude
Netherland,48.436252,-124.068561
Netherland,48.436252,-124.06856100000002
Netherland,48.436252,-124.06856100000002

here is the read statement

input_file = pd.read_csv("country.csv",encoding = 'ISO-8859-1')

I am not doing any processing related to longitude or latitude column. Not sure why is changing the values in two of rows and what I can do to fix it.

asked Oct 12 '20 at 02:33

Codegator

1

would this df['Latitude'].round(decimals=6) be acceptable? – adhg Oct 12 '20 at 02:51
I added this to fix the issue input_file = pd.read_csv("country.csv",encoding = 'ISO-8859-1',dtype = {'Latitude' : 'str', 'Longitude' : 'str'}) – Codegator Oct 12 '20 at 06:22
yes it works too – Codegator Oct 12 '20 at 15:19

python/pandas : Pandas changing the value adding extra digits in values

0 Answers0