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 ?

Adrien Logut · Accepted Answer · 2017-09-29 17:29:52Z

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, 2017 at 17:29

Adrien Logut

8205 silver badges13 bronze badges

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

1 Comment

Adrien Logut Over a year ago

that's perfect!

jmcnamara · Accepted Answer · 2017-10-02 15:56:12Z

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 2, 2017 at 15:56

jmcnamara

42.1k7 gold badges98 silver badges114 bronze badges

1 Comment

ProgSky Over a year ago

Great. Thanks for the link. I will try it out.

Collectives™ on Stack Overflow

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

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related