将dataframe数据加载到impala表时出错
DB = conn.cursor()
for row in fourth_set:
SQL = ('''Insert into Boots_retailer(sale_date, product, Assessment, weekno, store_Number, volume, turnover, turnover_missing, Inv_Cubic, XGB, KNN)
values(?,?,?,?,?,?,?,?,?,?,?)''' )
Values = row['Sale_date'], row['product'], row['Assessment'], row['weekno'],row['store_number'],
row['volume'],row['turnover'],row['turnover_missing'],row['Inv_Cubic'],row['XGB'],row['KNN']
har = DB.execute(SQL, Values)
connection.commit()
错误在线 Values = row['Sale_date'], ...
:
TypeError: string indices must be integers, not str
1条答案
按热度按时间vxbzzdmp1#
得到typeerror是因为您在遍历行的标签,而不是行本身。将第二行替换为