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](http://stackoverflow.com/questions/18096748/pandas-dataframes-to-html-
highlighting-table-rows) 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](http://stackoverflow.com/questions/882712/sending-html-email-using-
python). Can not figure out how to attach the html file?


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

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

