python发送带表格的邮件_python中如何将表格式的pandas数据帧发送到邮件中

我试图通过邮件发送熊猫数据帧。我试过了，但没能弄到。我的代码是

编码import pandas as pd

import json

import requests

from requests.auth import HTTPBasicAuth

import datetime

import smtplib

from email.mime.multipart import MIMEMultipart

from email.mime.text import MIMEText

import pdb

ticket_details=pd.DataFrame(list_values,

columns['incident',"short_description","priority","assignment_group"])

#converting a datframe into html table

df=ticket_details.to_html()

send ="xxx@xxx.com"

reciever="xxx@xxx.com"

subject="incident details "

msg = MIMEMultipart('alternative')

msg['From'] = send

msg['To'] = reciever

msg['Subject'] =subject

html_body = str(df)

messagePlain = 'Look at the incident details'

msg.attach(MIMEText(messagePlain, 'plain'))

msg.attach(MIMEText(html_body, 'html')

server = smtplib.SMTP("xxx.com")

server.sendmail(send, reciever, msg.as_string())

server.quit()