如何从CSV文件中提取xml数据

Question

我有一个CSV文件格式：id，name…，他的一行包含如下XML文件

<?xml version=""1.0"" encoding=""UTF-8""?><session><appUsage packageName=""com.facebook.katana"" name=""Facebook"" startTime=""1603137470472""><state name=""[]"" className=""android.widget.FrameLayout"" duration=""1639"" interactionCount=""0"" orientation=""1""/><state name=""[Facebook]"" 

我正试图提取包装名称和状态名称。我该怎么办？请帮忙

Answer 1

使用XML解析器并提取要查找的数据

import xml.etree.ElementTree as ET

xml = '''<?xml version="1.0" encoding="UTF-8"?>
               <session>
                   <appUsage packageName="com.facebook.katana" name="Facebook" startTime="1603137470472">
                        <state name="[]" className="android.widget.FrameLayout" duration="1639" interactionCount="0" orientation="1"/>
                        <state name="[Facebook]"/>
                    </appUsage>
               </session>
'''
root = ET.fromstring(xml)
package_name = root.find('.//appUsage').attrib['packageName']
print(package_name)

输出

com.facebook.katana