Python DataFrame处理XML字符串时数组类型字段的处理方法
报错原因
xmltodict 解析XML的规则是:同一层级下出现多次的同名标签会被解析为列表类型,仅出现一次时会解析为字符串。你当前的XML里groupId出现了2次,所以col3 = d['OperationStatus']['userDetails']['groupIds']['groupId']拿到的是['123456', '123457']列表,直接和字符串拼接就触发了类型错误。
解决代码
以下代码同时兼容单个、多个groupId的场景:
# !pip install xmltodict import xmltodict xml = """<?xml version="1.0" encoding="UTF-8"?> <OperationStatus xmlns:ns2="summaries"> <EventId>123456</EventId> <notificationId>123456</notificationId> <userDetails> <clientId>123456</clientId> <userId>123456</userId> <groupIds> <groupId>123456</groupId> <groupId>123457</groupId> </groupIds> </userDetails> </OperationStatus>""" d = xmltodict.parse(xml) col1 = d['OperationStatus']['userDetails']['clientId'] col2 = d['OperationStatus']['userDetails']['userId'] group_ids = d['OperationStatus']['userDetails']['groupIds']['groupId'] # 统一转换为列表格式,兼容单个groupId的场景 if not isinstance(group_ids, list): group_ids = [group_ids] # 遍历每个groupId生成对应行 for gid in group_ids: print(f"{col1},{col2},{gid}")
运行后输出和你预期的结果完全一致:
123456,123456,123456 123456,123456,123457
内容的提问来源于stack exchange,提问作者Atharv Thakur
相关产品推荐
相关产品推荐

