Python Pandas Error: AttributeError: 'module' object has no attribute 'formats'

Question

I have 0.20.3 version of pandas install. I am trying to set header_style to false so that i can format the header row. xlsxwriter not applying format to header row of dataframe - Python Pandas

I keep getting error : AttributeError: 'module' object has no attribute 'formats'

I have tried

pd.formats.format.header_style = None

and

pd.core.format.header_style = None

Any idea what am I doing wrong ?

score 3 · Accepted Answer · answered Sep 29 '17 at 17:29

3

As you can see in the API, the module pandas.formats and pandas.core.format do not exist : https://pandas.pydata.org/pandas-docs/stable/api.html It is normal that you have this error.

If you read new API changes with 0.20, pandas.formats has become pandas.io.formats. Try to check the API.

answered Sep 29 '17 at 17:29

Adrien Logut

812
5
13

that's perfect! – Adrien Logut Sep 29 '17 at 17:45

score 1 · Answer 2 · answered Oct 02 '17 at 15:56

1

Another way to do this, suggested by @Martin Evans, is to write the headers directly, outside of Pandas. This avoids issues like above with different Pandas versions.

See also this example in the XlsxWriter docs.

answered Oct 02 '17 at 15:56

jmcnamara

38,196
6
90
108

Great. Thanks for the link. I will try it out. – ProgSky Oct 02 '17 at 16:50

Python Pandas Error: AttributeError: 'module' object has no attribute 'formats'

2 Answers2