csv(逗号分隔符)，它是一种通用的文件格式，它可以非常轻易的被导入到Excel表格或者数据库中。csv文件，一行代表一条数据
rows = [['张三', '男', '20'], ['李四', '女', '25'], ['王五', '男', '18'], ['赵六', '女', '17']]
with open('用户信息.csv', 'w', encoding='utf-8', newline='') as f:
# 通过csv模块创建一个用于写入数据的对象write
write = csv.writer(f)
# 先写入表头
write.writerow(['姓名', '性别', '年龄'])
for row in rows:
print(row)
# writerow() 写入一维列表
write.writerow(row)
with open('用户信息2.csv', 'w', encoding='utf-8', newline='') as f:
# 通过csv模块创建一个用于写入数据的对象write
write = csv.writer(f)
# 先写入表头
write.writerow(['姓名', '性别', '年龄'])
# writerows() 写入二维列表
write.writerows(rows) with open('用户信息.csv', 'r', encoding='utf-8') as f:
# 通过csv模块创建一个用于大区数据的对象reader
reader = csv.reader(f)
print(reader)
for row in reader:
print(row) rows = [
{'name': '张三', 'sex': '男', 'age': 20},
{'name': '李四', 'sex': '女', 'age': 19},
{'name': '王五', 'sex': '男', 'age': 17},
{'name': '赵六', 'sex': '女', 'age': 15},
]
with open('用户信息字典.csv', 'w', encoding='utf-8', newline='') as f:
# 创建一个用于写入字典数据的对象
write = csv.DictWriter(f, fieldnames=[key for key in rows[0]])
# 写入表头内容
write.writeheader()
# 将字典数据写入文件
write.writerows(rows)with open('用户信息字典.csv', 'r', encoding='utf-8') as f:
reader = csv.DictReader(f)
for row in reader:
print(row)
print(type(row))
print(row['name'], row['age'], row['sex'])