需要以迭代形式在excel中添加数据帧

Question

我已经从dictionary创建了一个pandas数据框，我需要将唯一的列数据复制到同一个工作表中的excel中，但它只编写一个数据框，在帮助之后不编写任何内容！ 代码如下：

import pandas
import csv
import os

act_dict = {'bmc': [], 'adc': [], 'volume': []}
with open('/home/laxmi/Downloads/chadaLookuptablevalueWithAdcreferenceAndBmcid.csv','r') as fp:    
contents=csv.reader(fp)
total_count=0
i=0
for row in contents:
    if contents.line_num == 1:
        continue
    data=row
    act_dict['bmc'].append(data[0])
    act_dict['adc'].append(data[1])
    act_dict['volume'].append(data[2])
    total_count+=1
os.chdir("/home/laxmi/Documents/volume_analyser_project")
bmc_data = pandas.DataFrame(act_dict)
count=len(bmc_data.bmc.unique())
l1 = bmc_data.bmc.unique()
writer = pandas.ExcelWriter('pandas_multiple.xlsx', engine='xlsxwriter')
count1=(len(l1))
startrow=startcol=0
for i in range(count1):
    df_i=bmc_data[bmc_data.bmc==l1[i]]
    df_i.to_excel(writer,startrow=0,startcol=startcol+2,sheet_name='Sheet1')
    writer.save()

Answer 1

l1 = bmc_data.bmc.unique()
print(l1)
startcol=startrow = 0
file_name='/home/laxmi/Documents/volume_analyser_project/idmc.xlsx'
writer = pandas.ExcelWriter('idmc.xlsx', engine='xlsxwriter')
count1=(len(l1))
print(count1)
for i in range(count1):
    df_i=bmc_data[bmc_data.bmc==l1[i]]
    df_i = df_i.sort_values("adc", axis = 0, ascending = True)
    df_i.to_excel(writer,sheet_name='Sheet1',startrow=0,startcol=startcol,index=False)
    startcol=startcol+4
    print(startrow,startcol)
writer.save()