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])

score 1 · Answer 1 · answered Dec 10 '16 at 22:04

1

Just add following style:

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

answered Dec 10 '16 at 22:04

HYRY

94,853
25
187
187

Thank you. I was not aware you can have more than one styles dict in set_table_styles. – CarlosE Dec 10 '16 at 23:43

score 0 · Answer 2 · answered Dec 10 '16 at 23:50

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])

Pandas DataFrames in Jupyter: formatting index and columns separately

2 Answers2