什么是更好的為什么要遍歷這個項目列表并保存它if cursor: for row in cursor: date = str(row[0]) servicelevel = str(row[1]) power = str(row[2]) rebootime = str(row[3]) result = str(row[4]) result_two = str(row[5]) moredata = str(row[6]) data_Rows.append({'date': date, 'servicelevel': servicelevel, 'power': power, 'rebootime': rebootime, 'result': result, 'result_two': result_two, 'moredata': moredata})
3 回答
翻過高山走不出你
TA貢獻1875條經驗 獲得超3個贊
您可以將字段名稱字典用于行索引。例如：
cursor = [(1, 2, 3), (4, 5, 6)]
fields = { 'date' : 0 , 'servicelevel' : 1, 'power' : 2 }
data_Rows = []
for row in cursor:
data_Rows.append({ f : str(row[v]) for f, v in fields.items() })
print(data_Rows)
輸出：
[{'power': '3', 'servicelevel': '2', 'date': '1'}, {'power': '6', 'servicelevel': '5', 'date': '4'}]
qq_花開花謝_0
TA貢獻1835條經驗 獲得超7個贊
您可以使用每行的列標題來使用構造函數zip為每一行創建一個字典：dict
headers = 'date', 'servicelevel', 'power', 'rebootime', 'result', 'result_two', 'moredata'
data_Rows.extend(dict(zip(headers, map(str, row))) for row in cursor)
米脂
TA貢獻1836條經驗 獲得超3個贊
也許是這樣：
if cursor:
for row in cursor:
data_Rows.append({'date': str(row[0]), 'servicelevel': str(row[1]), 'power': str(row[2]), 'rebootime': str(row[3]),
'result': str(row[4]), 'result_two': str(row[5]), 'moredata': str(row[6])})
添加回答
舉報
0/150
提交
取消