Convert string to float64 in Python DataFrame [duplicate]

Question

I have a dataframe (df) like the following

I'm trying to convert the values in dataframe to int and float64 types.

df['poiid'] = df['poiid'].astype(int)
df['lng'] = df['lng'].astype('float64')
df['lat'] = df['lat'].astype('float64')

The code above does not work properly for float64, it only takes 6 decimal values after comma for lng and lat attributes. ( Please see the Output below)

Output

My expectation is 10 digits after the comma

my expectation output:

8904  -94.6074986458, 39.0523183095

...

Are you sure it's not just a limit in the displayed precision, while the dataframe actually holds what you expect? — couka
– couka, Commented Jan 26, 2021 at 14:02
what you see is just the default string representation with 6 decimal places, the number may have more decimal places — Stef
– Stef, Commented Jan 26, 2021 at 14:02
just try pd.options.display.float_format = '{:.10f}'.format — Stef
– Stef, Commented Jan 26, 2021 at 14:03

Stef · Accepted Answer · 2021-01-26 14:09:48Z

2

What you see is just the default string representation with 6 decimal places. You can set you own display format option with

pd.options.display.float_format = '{:.10f}'.format

to show 10 places. Alternatively you can confirm the number if you look at the result of say df.loc[1,'lng'].

To set the option only temporarily you can use an option context:

with pd.option_context('display.float_format', '{:.10f}'.format):
    print(df)

answered Jan 26, 2021 at 14:09

Stef

30.9k3 gold badges34 silver badges60 bronze badges

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

Collectives™ on Stack Overflow

Convert string to float64 in Python DataFrame [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related