У меня есть список словарей:
data_list = [ {"Я сделал}, {"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(список_данных) name_exel = 'HomeOwners_results.xlsx' df.to_excel(name_exel,index=False, header=True,startrow=0,startcol=0) Я пробовал другие решения, например:
df = pd.DataFrame(columns=['Column']) для элемента в data_list: для ключа значение в item.items(): df = df.append({'Столбец': значение}, ignore_index=True) name_excel = 'HomeOwners_results.xlsx' df.to_excel(name_excel, индекс=False, заголовок=False) печать (дф) но теперь дата добавляется в столбец А и в строки от 1 до 10 или от того, сколько данных я получил в списке.
И у меня нет идей, как получить такие данные:
