Python 读取XML, CSV 文件

1. 读取xml文件
   my_xml.xml

<?xml version="1.0" encoding="UTF-8"?>
<calc>
    <num>
        <num1>23</num1>
        <num2>2</num2>
    </num>
    <operator>
        <opt1>"+"</opt1>
        <opt2>"-"</opt2>
    </operator>
</calc>

python 读取文件代码

from xml.dom import minidom

xml_content = minidom.parse("my_xml.xml")
print(xml_content)
num1 = xml_content.getElementsByTagName("num1")[0].firstChild.data
print(num1)
num2 = xml_content.getElementsByTagName("num2")[0].firstChild.data
print(num2)
opt = xml_content.getElementsByTagName("opt1")[0].firstChild.data
print(opt)

输出：

"D:\python 3.8.2 install\python.exe" "D:/python programe files/Selenium_tests/readXml.py"
<xml.dom.minidom.Document object at 0x037C18F8>
23
2
"+"

进程已结束,退出代码0

2. 读取CSV 文件

1）创建csv文件

打开wps工作表–>文件另存为—>文件类型中选择"CSV逗号分离.csv"

test.csv

A,B,C
3,"""X""","""X"""
4,"""/""","""/"""
"""+""",0,0
"""-""",1,1
"""X""",2,2
"""/""",3,3
,4,4

python 读取CSV文件代码

import csv

csv_content = csv.reader(open("test.csv"))
print(csv_content)
print(type(csv_content))
for line in csv_content:
    print(line)