python之pandas的dataframe用sqlalchemy导入mysql数据库

1 导包

import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns
from statsmodels.tsa.arima_model import  ARMA
from sqlalchemy import create_engine
import warnings

2 连接数据库

conn = create_engine('mysql+mysqldb://用户名:密码@127.0.0.1:端口号3306/数据库名?charset=utf8')

3 创建一个dataframe演示插入mysql

df=pd.DataFrame({
   
'Name':['Alen','Bob','Cidy','Daniel&