import csv
with open('test.csv','w',newline='')as fp:
test_writer=csv.writer(fp,delimiter=' ',quotechar='"') #创建writer对象
test_writer.writerow(['red','blue','green']) #写入一行内容
test_writer.writerow(['test_string']*5) with open('test.csv',newline='')as fp:
test_reader=csv.reader(fp,delimiter=' ',quotechar='"') #创建reader对象
for row in test_reader: #遍历所有行
print(row) #每行作为一个列表返回
# ['red', 'blue', 'green']
# ['test_string', 'test_string', 'test_string', 'test_string', 'test_string'] with open('test.csv',newline='')as fp:
test_reader=csv.reader(fp,delimiter=':',quotechar='"') #使用不同的分隔符
for row in test_reader:
print(row) #与上面的输出不同
# ['red blue green']
# ['test_string test_string test_string test_string test_string'] with open('test.csv',newline='')as fp:
test_reader=csv.reader(fp,delimiter=' ',quotechar='"')
for row in test_reader:
print(','.join(row)) #重新组织数据形式
# red, blue, green
# test_string, test_string, test_string, test_string, test_string with open('name.csv','w')as fp:
headers=['姓氏','名字']
test_dictWrite=csv.DictWriter(fp,fieldnames=headers) #创建DictWriter对象
test_dictWrite.writeheader() #写入表头信息
test_dictWrite.writerow({'姓氏':'张','名字':'山'}) #写入数据
test_dictWrite.writerow({'姓氏':'刘','名字':'蛤蟆'})
test_dictWrite.writerow({'姓氏': '赖', '名字': '天鹅'}) with open('name.csv')as fp:
test_dictReader=csv.DictReader(fp) #创建DictReader对象
print(','.join(test_dictReader.fieldnames)) #读取表头信息
for row in test_dictReader:
print(row['姓氏'],',',row['名字'])
# 姓氏,名字
# 张 , 山
# 刘 , 蛤蟆
# 赖 , 天鹅
用MAC电脑内的Numbers打开name.csv文件效果图