Python provides Pandas library to make it easy to work with data. It allows you to import/export data to/from files. Sometimes you may need to export Pandas dataframe to PDF. In this article, we will learn how to export Pandas Dataframe to PDF.
How to Export Pandas Dataframe to PDF
We will use matplotlib library to export Pandas dataframe to a table first and then use its functionality to export the table to PDF.
1. Import Required Modules
Create an empty python file using a text editor.
$ vi pd_to_pdf.py
Add the following lines to it.
#!/bin/python import pandas as pd import numpy as np import matplotlib.pyplot as plt from matplotlib.backends.backend_pdf import PdfPages
We basically set the execution environment and import required modules into our code.
2. Create Dataframe
Next, we create a pandas dataframe and populate it with random data, which we will convert into a table and export as PDF.
df = pd.DataFrame(np.random.random((10,3)), columns = ("col 1", "col 2", "col 3"))
3. Plot Table in Matplotlib
Next, plot the dataframe as a table in matplotlib.
fig, ax =plt.subplots(figsize=(12,4)) ax.axis('tight') ax.axis('off') the_table = ax.table(cellText=df.values,colLabels=df.columns,loc='center')
4. Export Matplotlib table to PDF
Finally, we export matplotlib table to PDF document table.pdf.
pp = PdfPages("table.pdf") pp.savefig(fig, bbox_inches='tight') pp.close()
In this article, we will learn how to export Pandas Dataframe to PDF. You can customize it as per your requirement.
Also read:
How to Run Python Script in Apache Web Server
Shell Script to Clear/Delete Log Files
How to Exclude Requests from Apache Log
How to Exclude Requests from NGINX Log
How to Pass Variable in cURL Command
Related posts:
Sreeram has more than 10 years of experience in web development, Python, Linux, SQL and database programming.