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