在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