Pandas DataFrames in Jupyter: formatting index and columns separately

Question

This is a variation of the question "Pandas DataFrames in Jupyter: columns of equal width and centered".

How can we display an indexed dataframe with all columns centered except the index, which should be aligned left? And also, how can we control the width and other attributes of the index?

import pandas as pd
raw_data = {'Regiment': ['Nighthawks', 'Raptors'], 
    'Company': ['1st', '2nd'], 
    'preTestScore': [4, 24],
    'postTestScore': [25, 94]}
df = pd.DataFrame(raw_data, columns = ['Regiment', 'Company', 'preTestScore', 'postTestScore']).set_index('Regiment')
d = dict(selector="th",
    props=[('text-align', 'center')])

df.style.set_properties(**{'width':'10em', 'text-align':'center'})\
        .set_table_styles([d])

HYRY · Accepted Answer · 2016-12-10 22:04:39Z

1

Just add following style:

style_index = dict(selector=".row_heading", props=[("text-align", "right")])

answered Dec 10, 2016 at 22:04

HYRY

97.8k28 gold badges197 silver badges192 bronze badges

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

1 Comment

CarlosE Over a year ago

Thank you. I was not aware you can have more than one styles dict in set_table_styles.

CarlosE · Accepted Answer · 2016-12-10 23:50:07Z

0

import pandas as pd
raw_data = {'Regiment': ['Nighthawks', 'Raptors'], 
    'Company': ['1st', '2nd'], 
    'preTestScore': [4, 24],
    'postTestScore': [25, 94]}
df = pd.DataFrame(raw_data, columns = ['Regiment', 'Company', 'preTestScore', 'postTestScore']).set_index('Regiment')
d1 = dict(selector="th", props=[('text-align', 'center')] )
d2 = dict(selector=".row_heading", props=[("text-align", "left")])

df.style.set_properties(**{'width':'10em', 'text-align':'center'})\
        .set_table_styles([d1,d2])

answered Dec 10, 2016 at 23:50

CarlosE

9703 gold badges11 silver badges23 bronze badges

Collectives™ on Stack Overflow

Pandas DataFrames in Jupyter: formatting index and columns separately

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related