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, Feb 14 '17 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, Feb 14 '17 at 19:36

score 11 · Accepted Answer · edited Oct 26 '21 at 18:30

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 '21 at 18:30

Oskar Austegard

4,599
4
36
50

answered Feb 14 '17 at 19:40

miradulo

28,857
6
80
93

3

Yep that is what it is. Don't you just love it when stuff gets moved around. – James Draper Feb 14 '17 at 19:42
1

you are using a non public property. since this is not part of any guarantee you should following the changes very closely. – Jeff Feb 14 '17 at 20:09
I'm sorry I don't understand what you mean. Could you please rephrase and/or expand on this? – James Draper Mar 09 '17 at 16:17
@measure_theory Correct, I updated the answer, thanks. – miradulo Oct 11 '17 at 17:57
1

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 – Jan 22 '19 at 12:17

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

1 Answers1

Linked