python扁平化界面_使用python实现xml扁平化

我正在尝试将xml扁平化并写入csv，以便etl进程可以使用它。在

Location Name

Risk Address 1

Risk Address 2

我的代码如下

^{pr2}$

上面的代码提供了下面的输出。在AustraliaBizPackProposal.Answers.AnswersList.Entry[1].value = Location Name

AustraliaBizPackProposal.Answers.AnswersList.Entry[2].value = Risk Address 1

AustraliaBizPackProposal.Answers.AnswersList.Entry[3].value = Risk Address 2

我的预期产出如下，请告知AustraliaBizPackProposal.Answers.AnswersList.qs_location_name.value = Location Name

AustraliaBizPackProposal.Answers.AnswersList.qs_location_riskAddress1.value = Risk Address 1

AustraliaBizPackProposal.Answers.AnswersList.qs_location_riskAddress2.value = Risk Address 2