读取数据到sql

#encoding:utf-8
import tushare as ts
import pandas as pd
import xlrd
import pymssql  
import datetime
import sys
from pandas import DataFrame, Series
from sqlalchemy import create_engine
from tushare.stock.cons import ALL_STOCK_BASICS_FILE
from pandas.io.sql import pandasSQL_builder
from stock_in import m_stock_basic
start_time =datetime.datetime.now()
pro = ts.pro_api('wwwwwwwwwwwwwwwww')
conn = pymssql.connect(server = "DESKTOP-IHH4MRQ" , user = "sa" , password = "123qwe", database = "STOCK086")
data = pro.stock_basic(exchange='', list_status='L', fields='ts_code, symbol, name, area, industry, fullname, enname, market, exchange, curr_type, list_status, list_date, delist_date, is_hs')
data2=pd.DataFrame(data = data,columns = ["ts_code","symbol", "name", "area", "industry", "fullname", "enname", "market", "exchange", "curr_type", "list_status", "list_date", "delist_date", "is_hs"])
m_stock_basic=data2.fillna(0)
cs1 = conn.cursor()
sql="wwwwwwwwwwww"
for i in range(1,len(m_stock_basic),1):
    sql = "insert into stock_basic (ts_code, symbol, name, area, industry, market, exchange, curr_type, list_status, list_date, delist_date, is_hs) values(" +  \
                      "'" + str(m_stock_basic.iat[i,0]) + "'" + "," \
                    + "'" + str(m_stock_basic.iat[i,1])  + "'"+"," \
                    + "'" + str(m_stock_basic.iat[i,2])  + "'"+"," \
                    + "'" + str(m_stock_basic.iat[i,3] ) + "'"+"," \
                    +"'" +  str(m_stock_basic.iat[i,4]) + "'"  +","\
                    + "'" + str(m_stock_basic.iat[i,7] )+ "'" + ","\
                    + "'" + str(m_stock_basic.iat[i,8]) + "'"+"," \
                    + "'" +str( m_stock_basic.iat[i,9] ) + "'" +","\
                    + "'" + str(m_stock_basic.iat[i,10])  + "'"+"," \
                    + "'" + str(m_stock_basic.iat[i,11] ) + "'"+"," \
                    +"'" + str( m_stock_basic.iat[i,12] )+ "'"  +","\
                    +"'" +  str(m_stock_basic.iat[i,13]) + "'"  +")"  
    print(sql)
    count = cs1.execute(sql)  
    conn.commit()
   

print(len(m_stock_basic))
print (m_stock_basic.columns.size)

#        结束时间
end_time = datetime.datetime.now()
speed = end_time - start_time
# 打印花费时间
print(speed)