如何用Python通过利用Pandas读取CSV的数据，来增添和修改XML里面的元素？

用Python通过利用Pandas读取CSV的数据，来增添和修改XML里面的元素

<items>
    <item number="001" type="article">
        <mydocument>Data Analysis</mydocument>
        <ID>S1989</ID>
        <institutions>
            <institution id="1">
                <name>ABC</name>
                <city>GZ</city>
                <country>CHINA</country>
            </institution>
            <institution id="2">
                <name>DEF</name>
                <city>BJ</city>
                <country>CHINA</country>
            </institution>
        </institutions>
    </item>
    <item number="002" type="article">
        <mydocument>Data Analysis 2</mydocument>
        <ID>S1990</ID>
        <institutions>
            <institution id="1">
                <name>ABC</name>
                <city>GZ</city>
                <country>CHINA</country>
            </institution>
            <institution id="2">
                <name>DEF</name>
                <city>BJ</city>
                <country>CHINA</country>
            </institution>
        </institutions>
    </item>
</items>

import xml.etree.ElementTree as ET

updateTree = ET.parse("test.csv")
root = updateTree.getroot()
name = root[0][2][0].find("name")
name.text="ABCDEF"
updateTree.write("test.csv") 

https://blog.csdn.net/wsp_1138886114/article/details/86576900
对着打，如有帮助请采纳谢谢。

csv文件利用pandas进行处理，用变量接收值然后替换即可