Create a new column after dataframe gets df.style

Question

I'm trying to add a new column after dataframe gets df.style. However, I got an error message:

'Styler' object does not support item assignment

Below is my code:

import pandas as pd
df = pd.DataFrame([[10,3,1], [3,7,2], [2,4,4]], columns=list("ABC"))

subsets = pd.IndexSlice[:, 'A']
df2 = df.style.applymap(lambda x: 'background-color: yellow', subset = subsets)
df2['sum'] = None

Below is what I want to achieve:

Link

How can I convert df2 to a real dataframe that I can edit? Thank you!

jezrael · Accepted Answer · 2021-07-15 12:56:08Z

0

You cannot processing styler object by add data processing like add new column, you need add it before:

df2['sum'] = None
subsets = pd.IndexSlice[:, 'A']
df2 = df.style.applymap(lambda x: 'background-color: yellow', subset = subsets)

answered Jul 15, 2021 at 12:56

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Create a new column after dataframe gets df.style

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