商务网站开发报告,张家港做外贸网站,软文营销的写作技巧有哪些,温州瓯海区营销型网站建设概念#xff1a;CSV是逗号分隔值或者字符分割值#xff0c;其文件以纯文本形式存储表格数据。CSV文件可以用文本文件或者转换成EXCEL(直接用EXCEL也可以#xff0c;但是可能会有一些问题)打开。因此更适合通过CSV文件进行程序之间转移表格数据。应用场景#xff1a;需要进行…概念CSV是逗号分隔值或者字符分割值其文件以纯文本形式存储表格数据。CSV文件可以用文本文件或者转换成EXCEL(直接用EXCEL也可以但是可能会有一些问题)打开。因此更适合通过CSV文件进行程序之间转移表格数据。应用场景需要进行取数分析(将数据库数据拉取下来给产品)、保存爬虫数据时借助CSV文件更便利一些同时也可以用该文件记录脚本的操作日志。下面演示如何通过Python进行CSV文件的读写操作。import csvwith open(test.csv, w) as f:writer csv.writer(f)writer.writerow([id, name, phone])writer.writerow([01, zhangsan, 13600000001])writer.writerow([02, lisi, 13600000002])writer.writerow([03, wangwu, 13600000003])用记事本打开可以看到如下内容默认每行数据之间是通过逗号隔开的(可以再理解一下这个Comma-Separated Values)实例1-1.png用EXCEL打开的话数据长这样实例1-2.pngemmmm让我们把每行下面的空格去掉加上newline参数import csvwith open(test.csv, w, newline) as f:writer csv.writer(f)writer.writerow([id, name, phone])writer.writerow([01, zhangsan, 13600000001])writer.writerow([02, lisi, 13600000002])writer.writerow([03, wangwu, 13600000003])看空格没有了实例2-1.png如果想用其它符号代替数据间的逗号设置delimiter参数import csvwith open(test.csv, w) as f:writer csv.writer(f, delimiter -)writer.writerow([id, name, phone])writer.writerow([01, zhangsan, 13600000001])writer.writerow([02, lisi, 13600000002])writer.writerow([03, wangwu, 13600000003])实例3-1.png还有一种实现方式先写入表头再用writerows插入数据import csvwith open(test.csv, w) as f:writer csv.writer(f)writer.writerow([id, name, phone])writer.writerows([[01, zhangsan, 13600000004],[02, lisi, 13600000005],[03, wangwu, 13600000006]])实例4-1.png或者将表头抽离出来通过字典的方式写入with open(test.csv, w) as f:header [id, name, phone]writer csv.DictWriter(f, fieldnamesheader)writer.writeheader()writer.writerow({id: 01, name: zhangsan, phone: 13600000007})writer.writerow({id: 02, name: lisi, phone: 13600000008})writer.writerow({id: 03, name: wangwu, phone: 13600000009})实例5-1.png还可以用for循环将数据依次写入import csvdata [(zhangsan,13600000001),(lisi,13600000002),(wangwu,13600000003)]with open(test.csv,w) as f:writer csv.writer(f)for i in data:writer.writerow(i)如果需要写入中文数据为了避免编码错误文件操作时加上编码格式import csvwith open(test.csv, w, encodingutf-8) as f:writer csv.writer(f)writer.writerow([id, name, phone])writer.writerow([01, 张三, 13600000001])writer.writerow([02, 李四, 13600000002])writer.writerow([03, 王五, 13600000003])文件读取操作import csvwith open(test.csv,r,encoding utf-8) as f:reader csv.reader(f)for row in reader:print(row)实例6-1.png
