我有一個(gè)數(shù)據(jù)框，我正在嘗試使用 xlsxwriter 模塊將其寫入 Excel 工作表。下面給出的是我的數(shù)據(jù)框的樣子：prod_id,prod_name,price,unitsprod_a,apple,100,10prod_b,mango,10,123prod_c,orange,12,14我正在嘗試將上述數(shù)據(jù)框編寫為如下所示：# Pulling data for the sheetrow = 1col = 0# Iterate through the array you have and unpack the tuple at each indexfor elm1, elm2, elm3, elm4 in df: worksheet.write(row, col, elm1, number_format) worksheet.write(row, col + 1, elm2, number_format) worksheet.write(row, col + 2, elm3, number_format) worksheet.write(row, col + 3, elm4, number_format) row += 1它拋出一個(gè)錯(cuò)誤for elm1, elm2, elm3, elm4 in df:ValueError: too many values to unpack (expected 4)
1 回答
Cats萌萌
TA貢獻(xiàn)1805條經(jīng)驗(yàn) 獲得超9個(gè)贊
錯(cuò)誤是因?yàn)椋谘h(huán)df使用多個(gè)變量。相反，您應(yīng)該只有一個(gè)變量。
如果我理解正確，您可以像這樣調(diào)整循環(huán)：
for row in df.itertuples():
elm1,elm2,elm3,elm4 = row[1], row[2], row[3], row[4]
worksheet.write(row, col, elm1, number_format)
worksheet.write(row, col + 1, elm2, number_format)
worksheet.write(row, col + 2, elm3, number_format)
worksheet.write(row, col + 3, elm4, number_format)
row += 1
這應(yīng)該有效。
添加回答
舉報(bào)
0/150
提交
取消