Pandas raising: AttributeError: module 'pandas.core' has no attribute 'format'

Question

I get the following error when running pd.core.format.header_style = None:

AttributeError                            Traceback (most recent call last)
<ipython-input-25-fb23b66754fa> in <module>()
     11 # df1.to_excel(writer, sheet_name='Sheet1')
     12 
---> 13 pd.core.format.header_style = None

AttributeError: module 'pandas.core' has no attribute 'format'

Does anybody know where format has moved to?

I never heard of that attribute in the first place. Where did you find out about it and what is it supposed to do? — BrenBarn
– BrenBarn, Commented Feb 14, 2017 at 19:31
@BrenBarn I have no idea where I heard about it but I use it to remove the formatting before writing dataframes to xlsx worksheets with xlsxwriter. — James Draper
– James Draper, Commented Feb 14, 2017 at 19:36

Oskar Austegard · Accepted Answer · 2021-10-26 18:30:37Z

11

You're now looking for

pd.formats.format.header_style = None

I believe, as of version 0.18.1. See the issue CLN & REORG core/common.py #12503.

Edit (version >= 0.20)

As mentioned by Jeff, this is not a public property and so is prone to move around. Now it is found in pandas.io.formats.excel, which you'll have to import.

If you wanted to handle accessing it from different versions thus far (again, susceptible to change), an adaptation from this incompatibility issue might look something like

import packaging.version
import pandas
import pandas.io.formats.excel

def get_format_module():
    version = packaging.version.parse(pandas.__version__)
    if version < packaging.version.parse('0.18'):
        return pandas.core.format
    elif version < packaging.version.parse('0.20'):
        return pandas.formats.format
    else:
        return pandas.io.formats.excel.ExcelFormatter

edited Oct 26, 2021 at 18:30

Oskar Austegard

4,6594 gold badges39 silver badges50 bronze badges

answered Feb 14, 2017 at 19:40

miradulo

29.8k7 gold badges86 silver badges97 bronze badges

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

5 Comments

James Draper Over a year ago

Yep that is what it is. Don't you just love it when stuff gets moved around.

Jeff Over a year ago

you are using a non public property. since this is not part of any guarantee you should following the changes very closely.

James Draper Over a year ago

I'm sorry I don't understand what you mean. Could you please rephrase and/or expand on this?

miradulo Over a year ago

@measure_theory Correct, I updated the answer, thanks.

user10417531 Over a year ago

I hope the panda devs will change it at least twice so I have to find it again every time I want to make a new excel dumper

Mello · Accepted Answer · 2024-02-12 17:48:03Z

0

More recent versions of pandas do not use pandas.core.format. You can find examples in this link.

import pandas as pd
df = pd.DataFrame({'A': [1, 2], 'B': [3, 4]})
df.style.to_html(df, precision=2, caption="My table")

answered Feb 12, 2024 at 17:48

Mello

711 silver badge6 bronze badges

Collectives™ on Stack Overflow

Pandas raising: AttributeError: module 'pandas.core' has no attribute 'format'

2 Answers 2

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related