日basic恢复

#基础信息，主要要用到换手率\PE\PB等
sqlcmd2 = "select * from a_hisdata.basic order by ts_code,trade_date ASC"
df2 = pd.read_sql(sqlcmd2, dbconn)
df2 = df2.sort_values(by=['ts_code','trade_date'],ascending=True)
#填充空值
df2 = df2.fillna(value=9999)
df2['trade_date'] = df2['trade_date'].map(lambda x:x if str(x)=='nan' else int(x))#日期转数字，为了后面可以按日期排序，形成rownum

#把数据1和2合并起来到1里面,
df1 = pd.merge(df1,df2,on=['ts_code','trade_date'])
df1.rename(columns={'trade_date': 'date'},inplace=True)
df1.rename(columns={'turnover_rate': 'volume'},inplace=True)