如何将可能格式错误的xml解析为数据框？

自从您更新了问题以来，我决定用新的xml发布另一个答案。from bs4 import BeautifulSoup import pandas as pdxml = """    <?xml version="1.0" encoding="utf-8"?>    <Leads>      <Lead Id="123" LeadTitle="test, test.,  , (123) 456-7890, " CreateDate="01/01/2017 11:11:11" ModifyDate="01/04/2017 03:03:03" ACount="1" LCount="4" RCount="0" ROnly="false" Flagged="false" LastDistributionDate="01/01/2017 10:10:10" LeadFormType="test test">    <Campaign CampaignId="123" CampaignTitle="abc" />    <Status StatusId="123" StatusTitle="test" />    <Agent AgentId="123" AgentName="test, test" AgentEmail="a@a.com">      <AgentCustomFields custom1="test test, test" custom2="test" custom3="" custom4="" />    </Agent>    <Fields>      <Field FieldId="7" Value="a@a.com" FieldTitle="test" FieldType="test" />      <Field FieldId="8" Value="test" FieldTitle="test 1" FieldType="test" />      <Field FieldId="9" Value="test" FieldTitle="City" FieldType="Text" />      <Field FieldId="10" Value="test" FieldTitle="State" FieldType="State" />      <Field FieldId="11" Value="test" FieldTitle="test" FieldType="Zip" />      <Field FieldId="950" Value="test." FieldTitle="Business Name" FieldType="Text" />      <Field FieldId="1261" Value="Intuit Desktop" FieldTitle="test" FieldType="Text" />      <Field FieldId="1262" Value="test" FieldTitle="test" FieldType="Text" />      <Field FieldId="1263" Value="test" FieldTitle="test" FieldType="Number" />      <Field FieldId="1267" Value="test" FieldTitle="test" FieldType="Text" />      <Field FieldId="1310" Value="test" FieldTitle="test" FieldType="Phone" />      <Field FieldId="1319" Value="test" FieldTitle="test" FieldType="Number" />      <Field FieldId="1485" Value="test" FieldTitle="tst" FieldType="State" />    </Fields>    <Logs>      <StatusLog>        <Status LogId="123" LogDate="01/04/2017 03:08:44" StatusId="28" StatusTitle="test" AgentId="19" AgentName="test" AgentEmail="test@test.com" />      </StatusLog>      <ActionLog>        <Action LogId="123" ActionTypeId="73" ActionTypeName="test" MilestoneId="1" ActionDate="01/04/2017 03:08:44" ActionNote="test" AgentId="19" AgentName="test,test" AgentEmail="test@test.com" />      </ActionLog>      <EmailLog>        <Email LogId="123" SendDate="01/01/2017 20:53:39" EmailTemplateId="1" EmailTemplateName="test " AgentId="1" AgentName="test" AgentEmail="test@test.com" />      </EmailLog>      <DistributionLog>        <Distribution LogId="1" LogDate="01/01/2017 10:10:08" DistributionProgramId="1" DistributionProgramName="test" AssignedAgentId="1" AssignedAgentName="test,test" AssignedAgentEmail="test@test.com" />      </DistributionLog>      <CreationLog LogId="1" LogDate="01/01/2017 10:10:05" Imported="true" CreatedByAgentId="1" CreatedByAgentName="test, test" CreatedByAgentEmail="test@test.com" />    </Logs>  </Lead></Leads>"""soup = BeautifulSoup(xml, "xml")# Get Attributes from all nodesattrs = []for elm in soup():  # soup() is equivalent to soup.find_all()    attrs.append(elm.attrs)# Since you want the data in a dataframe, it makes sense for each field to be a new row consisting of all the other node attributesfields_attribute_list= [x for x in attrs if 'FieldId' in x.keys()]other_attribute_list = [x for x in attrs if 'FieldId' not in x.keys() and x != {}]# Make a single dictionary with the attributes of all nodes except for the `Field` nodes.attribute_dict = {}for d in other_attribute_list:    for k, v in d.items():          attribute_dict.setdefault(k, v)# Update each field row with attributes from all other nodes.full_list = []for field in fields_attribute_list:    field.update(attribute_dict)    full_list.append(field)# Make Dataframedf = pd.DataFrame(full_list)但是，请注意，此方法会使用相同的名称（例如LogId您的xml中的名称）覆盖属性ID 。无论如何，这段代码应该可以帮助您入门。

如何将可能格式错误的xml解析为数据框？

2回答