在tushare上提取数据并写入mysql中

import numpy as np
import tushare as ts
import MySQLdb as mdb

con=mdb.connect(host=“localhost”,user=“root”,passwd=“password”,db=“lqj”,use_unicode=True,charset=“utf8”)
pro=ts.pro_api()

data=pro.stock_basic(exchange="",list_status=“L”,fields=“ts_code,symbol,name,area,industry,list_date”)

r_num=len(data)

para=[]

for i in range(r_num):
para.append((i+1,data.loc[i][“ts_code”],data.loc[i][“symbol”],data.loc[i][“name”],data.loc[i][“area”],
data.loc[i][“industry”],data.loc[i][“list_date”]))

cur=con.cursor()
sql=""“insert into stock(id,ts_code,symbol,name,area,industry,list_date) values(%s,%s,%s,%s,%s,%s,%s)”""

cur.executemany(sql,para)

con.commit()

可以用我的邀请链接注册tushare：https://tushare.pro/register?reg=231221