import csv
import pymssql
connection = pymssql.connect( '(local)', 'sa', '123456', 'phm_data') # 建立连接
for t in range(2803):
s = str(t+1).zfill(4)
with open(('./PHM/Learning_set/Bearing1_1/acc_0'+s+'.csv'), 'r') as f:
reader = csv.reader(f)
data = next(reader)
print('data',data[0])
print('data',data)
query = 'insert into Bearing1_1 values ({data[0]},{data[1]},{data[2]},{data[3]},{data[4]},{data[5]})'
query = query.format(','.join('?' * 10))#这个地方浮点数的位数好像不固定
cursor = connection.cursor()
cursor.execute(query, data)
for data in reader:
cursor.execute(query, data)
cursor.commit()
图中是data列表的内容,后面是错误提示。列表最后两位是浮点数,所以目前设计的数据类型是浮点数,但len(float)不存在,请问如何修改来将列表内容存入数据库?