CSV文件是数据处理中常见的格式之一,而Python中的`csv`库可以轻松实现读写操作。无论是初学者还是资深开发者,掌握它的用法都能事半功倍!👇
首先,使用`csv.reader()`可以读取CSV文件内容。例如:
```python
import csv
with open('data.csv', newline='') as file:
reader = csv.reader(file)
for row in reader:
print(row) 每行以列表形式输出
```
其次,若需要写入数据到CSV文件,可以用`csv.writer()`:
```python
with open('output.csv', 'w', newline='') as file:
writer = csv.writer(file)
writer.writerow(['Name', 'Age', 'City'])
writer.writerow(['Alice', 25, 'New York'])
```
此外,`csv.DictReader`和`csv.DictWriter`更适合处理键值对数据,结构更直观:
```python
使用 DictReader
with open('data.csv') as file:
reader = csv.DictReader(file)
for row in reader:
print(row['Name'], row['Age'])
使用 DictWriter
fields = ['Name', 'Age']
rows = [{'Name': 'Bob', 'Age': 30}, {'Name': 'Tom', 'Age': 28}]
with open('output.csv', 'w', newline='') as file:
writer = csv.DictWriter(file, fieldnames=fields)
writer.writeheader()
writer.writerows(rows)
```
掌握这些基础后,你就能高效处理CSV文件啦!💪✨