How can I format index text data using pandas.styler

Question

Looking to create a table like this in Jupiter Notebook based on a pandas DataFrame. While styler has much on how to format data, much typically done in excel/word is formatting text to make it quickly readable. I'm aiming to cut excel/word out of process entirely and use pandas styler to summarize entire workflow. I have found limited documentation on how to format the text values/column widths/etc of data in index. I'm not familiar with HTML/CSS and am winging it. What I've tried seemed to have no impact on display of table. This is my data and some of code I've tried:

from faker import Faker
faker = Faker()
Faker.seed(4321)
dat = pd.DataFrame(
{'WorkFlow':[ 'Macro Economic Changes'
             ,'Industry Changes'
             ,'Federal Legislative Changes'
             ,'Model Development'
             ,'Model Validation'
             ,'Model Production Testing'
             ,'Market Research'
             ,'Marketing Plan'
             ,'Marketing Material'
             ,'Client Solicitation']})

choices    = ['Marketing','Management','Research']
conditions = [dat['WorkFlow'].str.find('Market')>-1
             ,dat['WorkFlow'].str.find('Change')>-1
             ,dat['WorkFlow'].str.find('Model' )>-1]
dat['Dept']= np.select(conditions,choices,'BusinessDev')
dat['AssignedAssociate'] =dat['WorkFlow'].apply(lambda x: faker.name())
dat['StatusReport']=np.array(['Green']*5+['Yellow']+['Green']*3+['Red'])
dat['StatusReport']= dat['StatusReport']+": Due to ...sdf asdfasf asdfasdfas asdgfasdfasdfsadfsadf. asdfsafsaf asdfsafsadf"

dat.set_index(['Dept','WorkFlow'],inplace=True)
dat

dat.style.set_table_styles(
#     { 'selector': 'th.col_heading'
#      , 'props'  : 'text-align: center;'                   },   
    {'selector' : 'th.index_name.'           
     , 'props'  : [('text-align','center')
                   ,('font-weight','bold')
                   ,('font-style','italic')
                   ,('width','2%')
                   ,('overflow-wrap','break-word')]} )

What do you want the output to look like? Can you mock something demonstrative of the format you're looking for? — Henry Ecker
– Henry Ecker ♦, Commented Jul 17, 2021 at 0:31
I added an image link. Basically merging cells, centering, text wrapping and such. Not clear how to apply such formatting to pandas.Styler instances. Appreciate the help. — Jaime
– Jaime, Commented Jul 18, 2021 at 4:39

Attack68 · Accepted Answer · 2021-07-18 10:44:31Z

0

Merging of cells only happens for multiindexes:

e.g.:

df = pd.DataFrame(index=pd.MultiIndex.from_product([["Unit 1", "Unit 2"], ["Some Value", "Another"]], names=["Dept", "Workflow"]),
                  columns=["Comment 1", "Comment 2"],
                  data=[["Green", "Red"], ["Yellow", "Yellow"], ["Green", "Red"], ["Yellow", "Yellow"]])
styler = df.style
styler

You can do some basic styling of the data cells and index cells like this:

styler.set_table_styles([{'selector': 'td', 'props': 'text-align: left;'},
                         {'selector': 'th.level1', 'props': 'text-align: left;'}])\
      .applymap(lambda x: f"color: {x.lower()}")

answered Jul 18, 2021 at 10:44

Attack68

4,8114 gold badges26 silver badges48 bronze badges

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

Collectives™ on Stack Overflow

How can I format index text data using pandas.styler

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