文件操作疑云：Python处理CSV、JSON和XML的案例？

原创悠悠 2024-12-22 06:30 21阅读 0赞

在Python中，处理常见的数据格式如CSV、JSON和XML，都很容易。以下是一些具体案例：

1. CSV处理：
```python
import csv

# 打开并读取CSV文件
with open('example.csv', 'r') as file:
    reader = csv.reader(file)
    for row in reader:
        print(row)

# 写入CSV文件
data_to_write = [
    ['Name', 'Age', 'City'],
    ['John Doe', 30, 'New York'],
    ['Jane Smith', 25, 'Chicago']
]
with open('example.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    for row in data_to_write:
        writer.writerow(row)

```
2. JSON处理：
```python
import json

# 读取JSON文件
with open('example.json', 'r') as file:
    data = json.load(file)
    print(data)

# 写入JSON文件
data_to_write = {
    "name": "John Doe",
    "age": 30,
    "city": "New York"
}
with open('example.json', 'w') as file:
    json.dump(data_to_write, file, indent=4))

```
3. XML处理：
Python有一个名为`xml.etree.ElementTree`（简称`ET`）的库，可以方便地读写XML文件。

```python
import xml.etree.ElementTree as ET

# 读取XML文件
tree = ET.parse('example.xml')
root = tree.getroot()
for child in root:
    print(child.tag, child.text))

# 写入XML文件
data_to_write = {
    "person": {
        "name": "John Doe",
        "age": 30,
        "city": "New York"
    }
}
xml_data = ET.tostring(data_to_write.get('person'), encoding='utf-8', method='xml')
with open('example.xml', 'w') as file:
    file.write(xml_data.decode())

```
以上是Python处理CSV、JSON和XML的常见操作。在实际使用中，可能需要根据具体需求进行更复杂的操作。