python用pandas写入excel_使用Python / Pandas将多索引数据写入excel文件

这样的事情应该有效：

import xlwt, xlrd

import os

current_file = xlwt.Workbook()

write_table = current_file.add_sheet('Sheet1')

name_list = ["Jack", "David", "Andy"]

food_list = ["Ice-cream", "Mango", "Apple", "Cake"]

for i, name in enumerate(name_list):

write_table.write(i * len(food_list), 0, name_list[i])

for row, food in enumerate(food_list):

write_table.write(i * len(food_list) + row, 1, food)

current_file.save("c:\\name_food.xls")

重要的是

write_table.write(i * len(food_list), 0, name_list[i])

你说那个名字应该写成0,4,8,12行…

另外,部分

write_table.write(i * len(food_list) + row, 1, food)

将食物写入相应的部分,增加了行号.