Python计算机视觉编程练习10：csv 模块学习

来源：互联网发布：php权限管理系统编辑：程序博客网时间：2024/06/07 17:30

备忘~~~

#!/usr/bin/env python# -*- coding:utf-8 -*-import csv#结果为5列with open('egg1.csv', 'wb') as csvfile:    spamwriter = csv.writer(csvfile, dialect='excel')    spamwriter.writerow(['a', '1', '1', '2', '2'])    spamwriter.writerow(['b', '3', '3', '6', '4'])    spamwriter.writerow(['c', '7', '7', '10', '4'])    spamwriter.writerow(['d', '11', '11', '11', '1'])    spamwriter.writerow(['e', '12', '12', '14', '3'])print u'结束！'#结果为1列with open('egg2.csv', 'wb') as csvfile:    spamwriter = csv.writer(csvfile, delimiter=' ',                            quotechar='|', quoting=csv.QUOTE_MINIMAL)    spamwriter.writerow(['a', '1', '1', '2', '2'])    spamwriter.writerow(['b', '3', '3', '6', '4'])    spamwriter.writerow(['c', '7', '7', '10', '4'])    spamwriter.writerow(['d', '11', '11', '11', '1'])    spamwriter.writerow(['e', '12', '12', '14', '3'])print u'结束'#5x5with open('egg1.csv', 'rb') as f:    reader = csv.reader(f)    for row in reader:        print row#5x1with open('egg2.csv', 'rb') as f:    reader = csv.reader(f)    for row in reader:        print row

结果

D:\Software\Python\anaconda\python.exe D:/vacation-image-search-engine/test1.py结束！结束['a', '1', '1', '2', '2']['b', '3', '3', '6', '4']['c', '7', '7', '10', '4']['d', '11', '11', '11', '1']['e', '12', '12', '14', '3']['a 1 1 2 2']['b 3 3 6 4']['c 7 7 10 4']['d 11 11 11 1']['e 12 12 14 3']Process finished with exit code 0

Tips:

csv是逗号分隔符格式。
这里写图片描述

一般我们用的execl生成的格式是xls和xlsx 直接重命名为csv的话会报错。
解决方案：出错原因是直接是把后缀为xls的execl文件重命名为csv的正常的要是另存为csv文件就不会报错了。

0 0