"""
dicWriter = csv.DictWriter(csvFile, fieldnames=fields)
"""
import csv
filename = 'test4.csv'
# 定义列表,里面的元素为字典
dictList = [
{'Name': 'Toms', 'Age': 27, 'City': 'New York'},
{'Name': 'Peter', 'Age': 26, 'City': 'London'},
{'Name': 'Joker', 'Age': 32, 'City': 'Tokyo'}
]
with open(file=filename, mode='w', newline='') as csvFile: # 打开csv文件
fields = ['Name', 'Age', 'City'] # 键名
dictWriter = csv.DictWriter(csvFile, fieldnames=fields) # 创建DictWriter对象
dictWriter.writeheader() # 写入fieldnames
# 写入内容
dictWriter.writerows(dictList)
直接ss.write(pp)试试
csv.DictWriter缺少了参数 filename
写入csv文件
import csv
with open('data.csv', 'w') as csvfile:
fieldnames = ['id', 'name', 'age']
writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
writer.writeheader()
writer.writerow({'id': '10001', 'name': 'Mike', 'age': 20})
writer.writerow({'id': '10002', 'name': 'Bob', 'age': 22})
writer.writerow({'id': '10003', 'name': 'Jordan', 'age': 21})