Export Pandas DataFrame into a PDF file using Python

by

First plot table with matplotlib then generate pdf 

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
from matplotlib.backends.backend_pdf import PdfPages

df = pd.DataFrame(np.random.random((10,3)), columns = ("col 1", "col 2", "col 3"))

#https://stackoverflow.com/questions/32137396/how-do-i-plot-only-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")

#https://stackoverflow.com/questions/4042192/reduce-left-and-right-margins-in-matplotlib-plot
pp = PdfPages("foo.pdf")
pp.savefig(fig, bbox_inches="tight")
pp.close()

reference:

How do I plot only a table in Matplotlib?

Reduce left and right margins in matplotlib plot

More Related Contents:

  1. How to provide a reproducible copy of your DataFrame with to_clipboard()
  2. Combine two columns of text in pandas dataframe
  3. How to apply a function to two columns of Pandas dataframe
  4. In pandas, is inplace = True considered harmful, or not?
  5. How do I convert a pandas Series or index to a Numpy array? [duplicate]
  6. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  7. Load data from txt with pandas
  8. Pandas convert dataframe to array of tuples
  9. How to create PDF files in Python [closed]
  10. Update row values where certain condition is met in pandas
  11. Coloring Cells in Pandas
  12. Python, Pandas : write content of DataFrame into text File
  13. extracting days from a numpy.timedelta64 value
  14. custom matplotlib plot : chess board like table with colored cells
  15. Adding calculated column(s) to a dataframe in pandas
  16. How do you plot a vertical line on a time series plot in Pandas?
  17. why does pandas rolling use single dimension ndarray
  18. pandas two dataframe cross join [duplicate]
  19. Bin pandas dataframe by every X rows
  20. pandas apply function that returns multiple values to rows in pandas dataframe
  21. return max value from pandas dataframe as a whole, not based on column or rows
  22. Convert dataframe index to datetime
  23. Set value of one Pandas column based on value in another column
  24. Python: Removing Rows on Count condition
  25. Get first row of dataframe in Python Pandas based on criteria
  26. Remove NaN/NULL columns in a Pandas dataframe?
  27. How to specify the type of pandas series elements in type hints?
  28. Group DataFrame in 5-minute intervals
  29. Load CSV to Pandas MultiIndex DataFrame
  30. bash: Python import – Command not found for pandas

Leave a Comment