csv文件操作

来源:互联网 发布:武汉必佳软件 编辑:程序博客网 时间:2024/06/07 22:46
  • 导入csv库
import csv
  • 写入csv文件中
with open('a.csv','w+') as csvfile:    writer = csv.writer(csvfile,lineterminator='\n',dialect='excel')    writer.writerow([1,2,3,4])  #注意,即使一列,也要写中括号[ ]    #或者writer.writerows([[1,2],[3,4],[5,6])#注意:lineterminator='\n'的意思是除去多余的空行

This version of the csv module doesn’t support Unicode input. Also, there are currently some issues regarding ASCII NUL characters. Accordingly, all input should be UTF-8 or printable ASCII to be safe

  • 读csv文件
 with open('a.csv','r') as csvfile:    reader = csv.reader(csvfile)    for row in reader:        print(row[0])  #打印第一列
0 0
原创粉丝点击