pandas 数据迁移

mysql

import pandas as pd
import numpy as np
import pymysql
from sqlalchemy import create_engine
pymysql.install_as_MySQLdb()
import MySQLdb
# 读取数据库数据
sql = "select * from code_k_all"
mysql_cn = MySQLdb.connect(host='127.0.0.1', port=3306, user='root', passwd='123456', db='gupiao', charset='utf8')
df = pd.read_sql(sql, con=mysql_cn)
# 写入数据库
con_data = create_engine('mysql://root:123456@127.0.0.1/gupiao?charset=utf8')
df.to_sql('code_mo_all', con=con_data, if_exists='append', index=False)