Remove bold formatting on Dataframe index

Question

I have a dataframe as below, with date as Index

Date           Count
01/01/2020       10
02/01/2020       14
03/01/2020        7

When writing the dataframe to excel, the index is always in bold. how do I remove the bold formatting on the index?

What do you mean by "removing the bold formatting"? It isn't obvious to me what you mean. — sujanay
– sujanay, Commented Nov 17, 2020 at 5:38
I mean when it's written to an excel file, the index in a dataframe is always bold. I'm wondering if it's possible to have it without the bold formatting — Arlowest
– Arlowest, Commented Nov 17, 2020 at 10:17
How working df.reset_index().to_excel(file, index=False) ? — jezrael
– jezrael, Commented Nov 17, 2020 at 10:19

jezrael · Accepted Answer · 2020-11-17 10:42:29Z

4

You can use trick - convert index to column and then not write index to file like:

df.reset_index().to_excel(file, index=False)

answered Nov 17, 2020 at 10:42

jezrael

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

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

1 Answer 1