Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- import csv
- from tabulate import tabulate
- from email.mime.multipart import MIMEMultipart
- from email.mime.text import MIMEText
- import smtplib
- me = 'myemailaddress@gmail.com'
- password = 'password'
- server = 'smtp.gmail.com:587'
- you = 'myemailaddress@gmail.com'
- text = """
- Hello, Friend.
- Here is your data:
- {table}
- Regards,
- Me"""
- html = """
- <html>
- <head>
- <style>
- table, th, td {{ border: 1px solid black; border-collapse: collapse; }}
- th, td {{ padding: 5px; }}
- </style>
- </head>
- <body><p>Hello, Friend This data is from a data frame.</p>
- <p>Here is your data:</p>
- {table}
- <p>Regards,</p>
- <p>Me</p>
- </body></html>
- """
- # with open('input.csv') as input_file:
- # reader = csv.reader(input_file)
- # data = list(reader)
- data = pd.read_csv("MySampleFile.csv")
- text = text.format(table=tabulate(data, headers="firstrow", tablefmt="grid"))
- html = html.format(table=tabulate(data, headers="firstrow", tablefmt="html"))
- message = MIMEMultipart(
- "alternative", None, [MIMEText(text), MIMEText(html,'html')])
- message['Subject'] = "First Attempt"
- message['From'] = me
- message['To'] = you
- server = smtplib.SMTP(server)
- server.ehlo()
- server.starttls()
- server.login(me, password)
- server.sendmail(me, you, message.as_string())
- server.quit()
Add Comment
Please, Sign In to add comment