pandas 读取写入mysql数据库

pandas读取并写入mysql数据库简单示例：

import pandas as pd
import numpy as np
from sqlalchemy import create_engine

# 连接数据库
conn = create_engine('mysql+pymysql://{}:{}@{}:{}/{}'.format('root', "314159", 'localhost', 3306, 'cainiao'))
# r = requests.get('https://www.bilibili.com/video/BV1Aq4y1Y7Fe?spm_id_from=333.934.0.0')
sql = 'select * from runoob_tbl;'
#读取数据
data = pd.read_sql(sql, conn)
# 修改索引
data['runoob_id'] = data['runoob_id'].apply(lambda x:x+1000)
print(data)
# index 索引不做为存入mysql的数据，index=False
data.to_sql(name = 'runoob_tbl', con = conn, if_exists= 'append', index=False)