本文实例讲述了Python实现读取及写入csv文件的方法。分享给大家供大家参考,具体如下:
新建csvData.csv文件,数据如下:
具体代码如下:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
# coding:utf-8
import csv
# 读取csv文件方式1
csvFile = open ( "csvData.csv" , "r" )
reader = csv.reader(csvFile) # 返回的是迭代类型
data = []
for item in reader:
print (item)
data.append(item)
print (data)
csvFile.close()
# 读取csv文件方式2
with open ( "csvData.csv" , "r" ) as csvfile:
reader2 = csv.reader(csvfile) # 读取csv文件,返回的是迭代类型
for item2 in reader2:
print (item2)
csvFile.close()
# 从列表写入csv文件
csvFile2 = open ( 'csvFile2.csv' , 'w' , newline = '') # 设置newline,否则两行之间会空一行
writer = csv.writer(csvFile2)
m = len (data)
for i in range (m):
writer.writerow(data[i])
csvFile2.close()
# 从字典写入csv文件
dic = { '张三' : 123 , '李四' : 456 , '王二娃' : 789 }
csvFile3 = open ( 'csvFile3.csv' , 'w' , newline = '')
writer2 = csv.writer(csvFile3)
for key in dic:
writer2.writerow([key, dic[key]])
csvFile3.close()
|
希望本文所述对大家Python程序设计有所帮助。
原文链接:https://www.cnblogs.com/liutongqing/p/6892099.html