Exporting pandas table as pdf

Question

I found quite a nice way to export a table generated with pandas here to PDF, the part about converting it to a png file is uninteresting to me.

The problem is, that I get the following error message:

---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
<ipython-input-10-9818a71c26bb> in <module>()
     13 
     14 with open(filename, 'wb') as f:
---> 15     f.write(template.format(z.to_latex()))
     16 
     17 subprocess.call(['pdflatex', filename])

TypeError: a bytes-like object is required, not 'str'

I'm not really understanding the code in the first place which makes it quite hard to correct the error. My code looks like this:

import subprocess

filename = 'out.tex'
pdffile = 'out.pdf'

template = r'''\documentclass[preview]{{standalone}}
\usepackage{{booktabs}}
\begin{{document}}
{}
\end{{document}}
'''

with open(filename, 'wb') as f:
    f.write(template.format(z.to_latex()))

subprocess.call(['pdflatex', filename])

where z is a DataFrame generated with pandas.

Hope someone can help out. Thank you in advance, Sito.

charlesreid1 · Accepted Answer · 2017-10-12 23:33:33Z

1

The problem is that you're opening a file to write in bytes mode - that's what the "b" character means in the call to open() - and then passing it string data. Change this:

with open(filename, 'wb') as f:
    f.write(template.format(z.to_latex()))

to this:

with open(filename, 'w') as f:
    f.write(template.format(z.to_latex()))

answered Oct 12, 2017 at 23:33

charlesreid1

4,9114 gold badges35 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

Exporting pandas table as pdf

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related