首页 > 编程语言 > 详细

Python读写CSV

时间:2017-09-12 18:21:03      阅读:321      评论:0      收藏:0      [点我收藏+]

简单记录下,关于这两种文件的读写:

读写csv:

import csv
#读取数据
def getCsv(filename="xxxxxxxx"):
    rows=[]
    with open(filename,‘rb‘) as f:
        readers=csv.reader(f,delimiter=‘,‘,quotechar=‘|‘)
        next(readers,None)
        for row in readers:
            rows.append(row)
        print rows
#写入数据
def  writeCsv(filename="xxxxxxxxx"):
    with open(filename,‘wb‘) as f:
        write =csv.writer(f)
        write.writerow("Element","system")
        data={
            (‘selenium‘,‘webdriver python‘),
            (‘appnium‘,‘android python‘),
            (‘appnium‘,‘ios‘)
            }
        write.writerows(data)
        f.close()
if __name__==‘__main__‘:
    writeCsv()
    getCsv()

  关于with的用法,可以参考别人的解释:

http://blog.csdn.net/suwei19870312/article/details/23258495/
关于readers=csv.reader(f,delimiter=‘,‘,quotechar=‘|‘)这句的解释可以参考别人的解释:
http://blog.csdn.net/kaka_yidian/article/details/13000235
读取到某一列:
 1 def getCsv(value1,value2,filename="xxxxxxxx"):
 2     rows=[]
 3     with open(filename,rb) as f:
 4         readers=csv.reader(f,delimiter=,,quotechar=|)
 5         next(readers,None)
 6         for row in readers:
 7             rows.append(row)
 8         return rows(value1,value2)
 9 if __name__==__main__:
10     print getCsv(0,0)

Python读写CSV

原文:http://www.cnblogs.com/yang1208/p/7511494.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!