Print pandas df with style.format in iPython

Question

Minimal working example:

import pandas as pd
df = pd.DataFrame({
    'letters':('A', 'B', 'C'),
    'numbers':(0.1111, 0.2222, 0.3333)
}).set_index('letters')
df.style.format('{:.2f}')

Result:

Out[4]: <pandas.io.formats.style.Styler at 0x7f963f826eb8>

What I want:

Something similar to the default Jupyter output:

Alex Huszagh · Accepted Answer · 2019-08-29 16:59:56Z

4

One way to do this is using the formatters or float_format keyword of df.to_string

>>> print(df.to_string(float_format=lambda x: '{:.2f}'.format(x)))
         numbers
letters         
A           0.11
B           0.22
C           0.33

float_format will apply a function to all floats to format, while formatters can accept a list or dict to format specific columns in the dataframe.

answered Aug 29, 2019 at 16:59

Alex Huszagh

14.8k3 gold badges42 silver badges70 bronze badges

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

Collectives™ on Stack Overflow

Print pandas df with style.format in iPython

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