Apply background color to a row in excel using pandas in python

Question

I have a simple test sheet and I want to give the title row a grey background color using pandas. After the change, save the result as a new file.

I tried to use the following code.

df_test = pd.read_excel(r'...\test.xlsx')
df_test = df_test.loc[1:1].style.apply('background-color: grey', axis = 1)
df_test.to_excel(r'...\test_1.xlsx', sheet_name='asdf', index = False)

But I only receive AttributeError: 'background-color : grey' is not a valid function for 'DataFrame' object. I already tried a few other variations of this to no avail.

@NicoCaldo I already saw this before posting but I struggled with applying the solution given there. I would still consider myself quite the beginner. — Squary94
– Squary94, Commented May 3, 2022 at 9:05
Solution was wrongly reopened - stackoverflow.com/questions/62783783/… — jezrael
– jezrael, Commented May 3, 2022 at 9:42

Corralien · Accepted Answer · 2022-05-03 09:30:55Z

4

You can use Styler.applymap_index

def bg_header(x):
    return "background-color: grey"
    
df.style.applymap_index(bg_header, axis=1).to_excel('output.xlsx', index=False)

Note: you need Pandas>=1.4.0

answered May 3, 2022 at 9:30

Corralien

121k8 gold badges44 silver badges69 bronze badges

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

11 Comments

jezrael Over a year ago

Why you reopen question?

jezrael Over a year ago

Why not post answer to dupe?

Corralien Over a year ago

applymap_index a dupe?

jezrael Over a year ago

no, stackoverflow.com/questions/62783783/…

Corralien Over a year ago

cells / rows are not headers, no? I don't understand how your link solves the OP problem.

|

Collectives™ on Stack Overflow

Apply background color to a row in excel using pandas in python

1 Answer 1

11 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related