csv文件简单读写

创建一个csv文件，将【列表】数据写入

import csv
content = [['Jack','23','m'],['Tom','32','m'],['Rose','18','f'],['Master','24','m'],['Servant','20','m'],['Ernst','30','m']]
with open('content.csv','wt') as f:
  csvco = csv.writer(f)
  csvco.writerows(content)

读取上面创建的content.csv文件

with open("content.csv",'rt') as fin:
  cin = csv.reader(fin)
  content = [row for row in cin] #推导式
  print(content)

with open("content.csv",'rt') as fin:
  cin = csv.reader(fin)
  for row in cin:  #for循环
    print(row)

创建一个csv文件，将【dict】数据写入

content = [
  {'name': 'Jack','age': '23','gender': 'm'},
  {'name': 'Tom', 'age': '32','gender': 'm'},
  {'name': 'Rose', 'age': '18','gender': 'f'},
  {'name': 'Master', 'age': '24','gender': 'm'},
]
with open('content.csv','wt') as fout:
  count = csv.DictWriter(fout,['name','age','gender'])
  count.writeheader()
  count.writerows(content)

读取上面创建的content.csv文件

with open('content.csv','rt') as fin:
  cin = csv.DictReader(fin)
  content = [row for row in cin]
  print(content)

with open('content.csv','rt') as fin:
  cin = csv.DictReader(fin)
  for row in cin:
    print(row)