0

I have a very large dataframe and I can write it as a table to a pdf using matplotlib but it's put on one large page. As a result the format is not good. It takes a long time to load because it's one large page and as a result the writing is very small in each row on the pdf.

I would like it to format to multiple pages so this dataframe for example should be on 70 pages so it is be formatted.

Is there anyway for matplotlib to know how many pages it should write to so better formatted. So some dataframes be put to one page and others to 100 pages if required.

   fig, ax = plt.subplots(figsize=(11, 4))

    ax.axis('tight')
    ax.axis('off')
    ax.set_title(title)
    ax.table(cellText=pandas_df.values, colLabels=pandas_df.columns, loc='center')

    pdf.savefig(fig, bbox_inches='tight')
    plt.close()
Koedlt
  • 4,286
  • 8
  • 15
  • 33
lunbox
  • 331
  • 3
  • 11
  • Why go through matplotlib? You could export your df as html then to pdf. See https://stackoverflow.com/a/66047116/13525512 – Tranbi Mar 07 '23 at 11:57

0 Answers0