Как добавить данные в один и тот же индекс строки, но в разные ячейки каждого столбца ⇐ Python

[Anonymous]

У меня есть список словарей:

Код: Выделить всё

data_list = [
{"ID":id},
{"HomeOwnersDwellingCoverageALimitof":HomeOwnersDwellingCoverageALimitof},
{"HomeOwnersPersonalPropetyReplacemntCostOpt":HomeOwnersPersonalPropetyReplacemntCostOpt},
{"HomeOwnersLossOfUserCoverageDeduc":HomeOwnersLossOfUserCoverageDeduc},
{"HomeOwnersOtherStructuresCoverageBLimit":HomeOwnersOtherStructuresCoverageBLimit},
{"HomeOwnersPersonalpropety":HomeOwnersPersonalpropety},
{"HomeOwnersLossOfUserCoverageD":HomeOwnersLossOfUserCoverageD},
{"HomeOwnersPersonalLiabilityCovarageE":HomeOwnersPersonalLiabilityCovarageE},
{"HomeOwnersMedicalPayments":HomeOwnersMedicalPayments},
{"HomeOwnersOtherStructuresCoverageBLimitDeduc":HomeOwnersOtherStructuresCoverageBLimitDeduc},
{"HomeOwnersPersonalpropetyDeduc":HomeOwnersPersonalpropetyDeduc},
{"HomeOwnersPersonalLiabilityCovarageEDeduc":HomeOwnersPersonalLiabilityCovarageEDeduc},
{"HomeOwnersMedicalPaymentsDeduc":HomeOwnersMedicalPaymentsDeduc},
{"HomeOwnersFullValueReplacementCostOpt":HomeOwnersFullValueReplacementCostOpt},
{"HomeOwnersInflationGuardOpt":HomeOwnersInflationGuardOpt},
{"HomeOwnersLossAssessmentOpt":HomeOwnersLossAssessmentOpt},
{"HomeOwnersUnscheduledJewerlyOpt":HomeOwnersUnscheduledJewerlyOpt},
{"HomeOwnersServiceLineOpt":HomeOwnersServiceLineOpt},
{"HomeOwnersIdentityFreaudExpenseOpt":HomeOwnersIdentityFreaudExpenseOpt},
{"HomeOwnersMechanicalBreakdownOpt":HomeOwnersMechanicalBreakdownOpt},
{"HomeOwnersBuildingOrdinanceOpt":HomeOwnersBuildingOrdinanceOpt},
{"HomeOwnersFullValueReplacementCostLimit":HomeOwnersFullValueReplacementCostLimit},
{"HomeOwnersPersonalPropetyReplacemntCostLimit":HomeOwnersPersonalPropetyReplacemntCostLimit},
{"HomeOwnersInflationGuardLimit":HomeOwnersInflationGuardLimit},
{"HomeOwnersLossAssessmentLimit":HomeOwnersLossAssessmentLimit},
{"HomeOwnersUnscheduledJewerlyLimit":HomeOwnersUnscheduledJewerlyLimit},
{"HomeOwnersServiceLineLimit":HomeOwnersServiceLineLimit},
{"HomeOwnersIdentityFreaudExpenseLimit":HomeOwnersIdentityFreaudExpenseLimit},
{"HomeOwnersMechanicalBreakdownLimit":HomeOwnersMechanicalBreakdownLimit},
{"HomeOwnersBuildingOrdinanceLimit":HomeOwnersBuildingOrdinanceLimit},
{"HomeOwnersFullValueReplacementCostDeduc": HomeOwnersFullValueReplacementCostDeduc},
{"HomeOwnersPersonalPropetyReplacemntCostDeduc": HomeOwnersPersonalPropetyReplacemntCostDeduc},
{"HomeOwnersInflationGuardDeduc": HomeOwnersInflationGuardDeduc},]

Я добавил это в файл Excel, проблема в том, что данные не находятся под каждым столбцом, добавляются на одну строку вниз. Поделюсь снимком экрана Excel:


Для этого метода , я использую эту строку кода:

Код: Выделить всё

df = pd.DataFrame(data_list)
name_exel = 'HomeOwners_results.xlsx'

df.to_excel(name_exel,index=False, header=True,startrow=0,startcol=0)

Я пробовал другие решения, например:

Код: Выделить всё

df = pd.DataFrame(columns=['Column'])

for item in data_list:
for key, value in item.items():
df = df.append({'Column': value}, ignore_index=True)

name_excel = 'HomeOwners_results.xlsx'
df.to_excel(name_excel, index=False, header=False)

print(df)

Но теперь дата добавляется в столбец А и в строки от 1 до 10 или от того, сколько данных я получил в списке.
И у меня нет идей, как получить такие данные:



Подробнее здесь: https://stackoverflow.com/questions/773 ... ach-column