1.忽略第一行标题的基础上
Python2.7
# coding:utf-8
import csv
csv_reader = csv.reader(open(r'C:\Users\thinkPad\Desktop\tweets.csv'))
for row in csv_reader:
# 条件语句忽略第一行文件数据
if csv_reader.line_num == 1:
continue
print row
print type(row)
break
python3
with open(r'D:\PythonFiles\2018second\csv\csvFile1.csv', "r") as csvfile:
reader = csv.reader(csvfile)
# 这里不需要readlines
for line in reader:
print(line, type(line)) # ['1', '2', '3', 'w'] <class 'list'>
2.写入csv文件
print('开始写入')
csvFile2 = open(r'csvFile1.csv', 'w', newline='') # 设置newline,否则两行之间会空一行
writer = csv.writer(csvFile2)
data = [[1, 2, 3, 'w'], [1, 2, 3, 'e'], [1, 2, 3, 'r'], [1, 2, 3, 't']]
m = len(data)
for i in range(m):
writer.writerow(data[i])
csvFile2.close()
如果data[i]只有一个元素会报错的。
with open(r'D:\PythonFiles\2018second\csv\test.csv',"w",newline='') as csvfile:
writer = csv.writer(csvfile)
#先写入columns_name
writer.writerow(["index","a_name","b_name"])
#写入多行用writerows
writer.writerows([[0,1,3],[1,2,3],[2,3,4]])
这个如果写入文件已创建啦,再次报错哈。