Pandas send email containing dataframe as a visual table

by

Try:

  • Using str.format to append your DF html to the email body html.

Ex:

from email.mime.text import MIMEText
from email.mime.application import MIMEApplication
from email.mime.multipart import MIMEMultipart
from smtplib import SMTP
import smtplib
import sys


recipients = ['[email protected]'] 
emaillist = [elem.strip().split(',') for elem in recipients]
msg = MIMEMultipart()
msg['Subject'] = "Your Subject"
msg['From'] = '[email protected]'


html = """\
<html>
  <head></head>
  <body>
    {0}
  </body>
</html>
""".format(df_test.to_html())

part1 = MIMEText(html, 'html')
msg.attach(part1)

server = smtplib.SMTP('smtp.gmail.com', 587)
server.sendmail(msg['From'], emaillist , msg.as_string())

More Related Contents:

  1. How to change the location of the column name in pandas?
  2. finding values in pandas series – Python3
  3. Importing pandas shows ImportError: cannot import name hashtable
  4. How to extract first 8 characters from a string in pandas
  5. Convert object data type to string issue in python
  6. SKLearn warning “valid feature names” in version 1.0
  7. converting a pandas date to week number
  8. Pandas pd.cut() – binning datetime column / series
  9. pandas multiindex – how to select second level when using columns?
  10. How to combine multiple columns in a DataFrame to Pandas datetime
  11. How do I find the number of fridays between two dates(including both the dates) [closed]
  12. selenium.common.exceptions.ElementNotInteractableException: Message: element not interactable when clicking on an element using Selenium Python
  13. Pygame window freezes when it opens
  14. How to deal with multi-level column names downloaded with yfinance
  15. python 3.x ImportError: No module named ‘cStringIO’
  16. Run a python script in virtual environment from windows task scheduler
  17. Installing modules to Anaconda from .tar.gz
  18. python random.getstate() and random.setstate()
  19. How to output x265 compressed video with cv2.VideoWriter
  20. Python SSL certificate verify error
  21. How do I integrate custom exception handling with the FastAPI exception handling?
  22. pandas.read_csv from string or package data
  23. Fit sigmoid function (“S” shape curve) to data using Python
  24. Python making combined bar and line plot with secondary y-axis
  25. How to install pip for Python 3.6 on Ubuntu 16.10?
  26. sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table
  27. Google Cloud Functions Python Logging issue
  28. itertools.cycle().next()?
  29. WinError 10061 – No Connection Could be made
  30. using Subprocess to avoid long-running task from disconnecting discord.py bot?

Leave a Comment