0

I'm extracting data from my database and trying to write it into a dataframe, but I'm getting scientific notation 0E-8 instead of decimal values in every line :

df columns

I've tried :

df_rts24['Displayed quantity'].apply(lambda x: '{:.8f}'.format(x))
df_rts24['Traded quantity'].apply(lambda x: '{:.8f}'.format(x))

But no changes. Any help please?

AmyB
  • 25
  • 4
  • I tried with `pd.set_option('display.float_format', lambda x: '%.3f' % x)` to supress scientific notations globaly but no help. Still 0E-8 :( – AmyB May 18 '22 at 16:52

0 Answers0