create nice tables in excel with Python

Question

So i have this script that outputs a pandas dataframe which i can save to a notebook. These tables however arent professional looking and i was wondering if there was a way in pandas/excel writing modules that would allow me to add column headers to my columns , a legend, merge cells, add a title, etc.

This is what i get from python as a pandas dataframe:

with this script:

excel_df=pd.DataFrame(closeended_all_counts).T
excel_df.columns=all_columns

writer=pd.ExcelWriter('L:\OMIZ\March_2018.xlsx',engine='xlsxwriter')
excel_df.to_excel(writer,'Final Tables')

workbook = writer.book
worksheet = writer.sheets['Final Tables']
writer.save()

whereas i need this output:

any documentation or modules would be amazing!

Yuca · Accepted Answer · 2018-07-02 17:03:28Z

2

Since you're looking for documentation, here you go:

https://xlsxwriter.readthedocs.io/example_tables.html?highlight=tables

answered Jul 2, 2018 at 17:03

Yuca

6,1114 gold badges26 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

create nice tables in excel with Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related