How to apply a style to a Python DataFrame for all rows except the last one?

Question

I am trying to apply a Bar Style to all of the data in the dataframe, except the last row, which is supposed to be the Total row.

import pandas as pd
import numpy as np
data =  pd.DataFrame(np.random.randn(5, 2), columns=list('AB'))
data.loc['Total'] = data.sum()

           A                B
0      -1.224620    -0.373898
1       0.75568      0.997875
2      -1.284663    -0.211903
3      -0.274813    -0.871816
4       1.256267    -0.742521
Total  -0.772143    -1.202263

Something similar to df.stlye.bar(...) pandas.pydata.org/pandas-docs/stable/user_guide/…. — soky
– soky, Commented Jun 18, 2019 at 12:16

Cyriel Mallart · Accepted Answer · 2019-06-18 13:22:43Z

2

It was explained in the docs, that

A tuple is treated as (row_indexer, column_indexer)

You just need to twist a bit the subset option.

On your data

import pandas as pd
import numpy as np
data =  pd.DataFrame(np.random.randn(5, 2), columns=list('AB'))
data.loc['Total'] = data.sum()

data.style.bar(subset = ([0,1,2,3,4], ['A', 'B']))

it gives

edited Jun 18, 2019 at 13:22

answered Jun 18, 2019 at 13:01

Cyriel Mallart

1265 bronze badges

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

Collectives™ on Stack Overflow

How to apply a style to a Python DataFrame for all rows except the last one?

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