Pandas (47)

How to format or suppress scientific notations in a pandas dataframe?

# Input
df = pd.DataFrame(np.random.random(4)**10, columns=['random'])

# 1: Rounding
df.round(4)

# 2: Use apply to change format
df.apply(lambda x: '%.4f' % x, axis=1)
# or
df.applymap(lambda x: '%.4f' % x)

# 3: Use set_option
pd.set_option('display.float_format', lambda x: '%.4f' % x)

# 4: Assign display.float_format
pd.options.display.float_format = '{:.4f}'.format
print(df)

# Reset/undo float formatting
pd.options.display.float_format = None