如何使用SES随附的CSV将数据框和sendmail上的CSV转换为CSV

Question

我必须使用包含数据框的CSV在代码末尾发送MENDMAIL。

我使用BOTO3在AWS Lambda上进行此操作，以打电话给SES。

def sendMail1(value, df):
   subject = "Comission"
   client = boto3.client("ses")
   body = f"""
             Comission value is {value}.
           """
message = {"Subject": {"Data": subject}, "Body": {"Html": {"Data": body}}}
attachment = df.to_csv(f"Comission.csv", index=False)
response = client.send_email(Source = "[email protected]", Destination = {"ToAddresses": ["[email protected]"]}, Message = message, Attachment = attachment)

我没有IDEIA如何做，我尝试了DF.TO_CSV方法，并将其包含在附件。没有工作。

其余的代码无需附件零件工作，但是我需要将DF附加到电子邮件。

你们知道该怎么做吗？

Answer 1

df.to_csv(f"Comission.csv", index=False)

to_emails = [target_email1, target_email2]
ses = boto3.client('ses')
msg = MIMEMultipart()
msg['Subject'] = 'weekly report'

msg['From'] = from_email

msg['To'] = to_emails[0]


# what a recipient sees if they don't use an email reader
msg.preamble = 'Multipart message.\n'

# the message body
part = MIMEText('Howdy -- here is the data from last week.')
msg.attach(part)

# the attachment
part = MIMEApplication(open('Comission.csv', 'rb').read())
part.add_header('Content-Disposition', 'attachment', filename='Comission.csv')
msg.attach(part)

result = ses.send_raw_email(
             Source=msg['From'],
             Destinations=to_emails,
             RawMessage={'Data': msg.as_string()})                                                                                                       
# and send the message
print result