CODEWITHSUNDEEP
python
nikhil dasoju
nikhil dasoju

Reputation: 31

How to send python code output over email?

I have an output of df['sentiments'] as sentiment output of twitter tweets. I want to mail that sentiment output over email to another person automatically.

Upvotes: 1

Views: 1569

Answers (2)

paradocslover
paradocslover

Reputation: 3294

Store it in a file using df['sentiments'].to_csv('sentiment.csv'). And send the file sentiment.csv via mail.

More details about to_csv function can be found here in the official docs.

EDIT: Expanding the answer for the sake of making it less troublesome. Credits for this part

import smtplib
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from email.mime.base import MIMEBase
from email import encoders
mail_content = '''Sample message'''

#The mail addresses and password
sender_address = '[email protected]'
sender_pass = 'xxxxxxxxxxx'
receiver_address = '[email protected]'

#Setup the MIME
message = MIMEMultipart()
message['From'] = sender_address
message['To'] = receiver_address
message['Subject'] = 'A test mail sent by Python. It has an attachment.'  

#The body and the attachments for the mail 
message.attach(MIMEText(mail_content, 'plain'))

filename = "database.txt" #- Attach the sentiment.csv and metadata file here

# Open PDF file in binary mode
with open(filename, "rb") as attachment:
    # Add file as application/octet-stream
    # Email client can usually download this automatically as attachment
    part = MIMEBase("application", "octet-stream")
    part.set_payload(attachment.read())

# Encode file in ASCII characters to send by email    
encoders.encode_base64(part)

# Add header as key/value pair to attachment part
part.add_header(
    "Content-Disposition",
    f"attachment; filename= {filename}",
)

# Add attachment to message and convert message to string
message.attach(part)

#Create SMTP session for sending the mail
session = smtplib.SMTP('smtp.gmail.com', 587) #use gmail with port
session.ehlo()
session.starttls() #enable security
session.login(sender_address, sender_pass) #login with mail_id and password
text = message.as_string()
session.sendmail(sender_address, receiver_address, text)
session.quit()
print('Mail Sent')

If you get an error as follows:

(535, b'5.7.8 Username and Password not accepted. Learn more at\n5.7.8 https://support.google.com/mail/?p=BadCredentials y186sm1525057pfy.66 - gsmtp')

Follow this thread

Upvotes: 1

Serbitar
Serbitar

Reputation: 2224

You can use the python built in library smtplib:

https://docs.python.org/3/library/smtplib.html to send emails.

You can use, for example the GMAIL mail server to send it.

https://www.tutorialspoint.com/send-mail-from-your-gmail-account-using-python

Upvotes: 0

Related Questions