Quickly turn pandas dataframes into shareable Excel reports.
pandas-excel writes easy-to-read, ready-to-share multi-sheet Excel workbooks from pandas dataframes. It fixes some of the problems with
DataFrame.to_excel, including its annoying habit of writing an empty line below multiindex columns, and implements several features not currently present in any existing excel writing libraries, including:
- Creation of multi-sheet report workbooks with a table of contents
- Commonly-used Excel number formats (e.g. Percentage, Accounting, etc.)
- Auto-fitting columns
Instead of writing using
DataFrame.to_excel, create an
ExcelReport object, either by instantiating directly or using
import excel import pandas as pd df = pd.read_csv("input_file.csv") report = excel.ExcelReport("output/basic-example.xlsx") # do some analysis here report.add_table(df, sheet_name="my-sheet") # more analysis report.add_table(some_other_df, sheet_name="other sheet") report.write()
import excel import pandas as pd df = pd.read_csv("input_file.csv") # do some analysis here with excel.ExcelReport("output/basic-example.xlsx") as report: report.add_table(df, sheet_name="my-sheet")
There are several examples of
pandas-excel‘s capabilities in here.
pandas-excel is available on PyPi here: https://pypi.org/project/pandas-excel
Install the latest release using
pip install pandas-excel