Send pandas dataframe data as html e-mail

Question

I want to send a pandas dataframe data as an HTML e-mail. Based on this post I could create an html with the dataframe. Code

import pandas as pd
import numpy as np

HEADER = '''
<html>
    <head>

    </head>
    <body>
'''
FOOTER = '''
    </body>
</html>
'''

df = pd.DataFrame([[1.1, 1.1, 1.1, 2.6, 2.5, 3.4,2.6,2.6,3.4,3.4,2.6,1.1,1.1,3.3], list('AAABBBBABCBDDD')]).T
with open('test.html', 'w') as f:
    f.write(HEADER)
    f.write(df.to_html(classes='df'))
    f.write(FOOTER)

Now I want to send this as a html e-mail. I tried this. Can not figure out how to attach the html file?

Look into ipyhon notebooks, very handy for this type of work — Woody Pride
– Woody Pride, Commented Oct 30, 2013 at 10:36

KT12 · Accepted Answer · 2020-01-03 23:38:30Z

13

Pandas has a function for this.

This will give the the html code for the table, after which you can embed it into an email with:

df = DataFrame(data)

email = " some html {df} lah lah"

email = email.format(df=df.to_html())

edited Jan 3, 2020 at 23:38

KT12

62314 silver badges25 bronze badges

answered May 13, 2016 at 15:36

Johnny V

1,23817 silver badges23 bronze badges

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

Comments

Nilani Algiriyage · Accepted Answer · 2013-10-30 11:02:47Z

4

Finally found. This is the way it should be done.

filename = "test.html"
f = file(filename)
attachment = MIMEText(f.read(),'html')
msg.attach(attachment)

answered Oct 30, 2013 at 11:02

Nilani Algiriyage

36.1k33 gold badges97 silver badges123 bronze badges

1 Comment

johan855 Over a year ago

stackoverflow.com/questions/882712/…

Collectives™ on Stack Overflow

Send pandas dataframe data as html e-mail

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related