Python Journey - Day12 - CSV文件操作

CSV文件的读取

注意:

在开始位置打印结果会出现 \ufeff, 读取文件把 UTF-8 编码 改成 UTF-8-sig .

import csv
with open('book1.csv','r',encoding='utf-8') as f:
    readcsv = csv.reader(f)
    #print(list(f))
    for row in readcsv:
        print(row)

['\ufeffNo', '位置', '', '梯度', '', '位移向量', '', '函数值']
['i', 'xi', 'yi', '∂z/∂x', '∂z/∂y', '⊿x', '⊿y', 'z']
['0', '3.00 ', '2.00 ', '6.00 ', '4.00 ', '-12.00 ', '-8.00 ', '13.00 ']
['1', '-9.00 ', '-6.00 ', '-18.00 ', '-12.00 ', '36.00 ', '24.00 ', '117.00 ']
['2', '27.00 ', '18.00 ', '54.00 ', '36.00 ', '-108.00 ', '-72.00 ', '1053.00 ']

CSV文件的写入

import csv
with open('book1.csv','r',encoding='utf-8') as f:
    readcsv = csv.reader(f)
    #print(list(f))
    for row in readcsv:
        print(row)

with open('book2.csv','w',encoding='utf-8') as f:
    writecsv = csv.writer(f)
    writecsv.writerow(['ID','Name','Number'])
    writecsv.writerow(['01','HHVIC','1号'])
    c = [['02','HH','2号'],['03','VV','3号']]
    writecsv.writerows(c)

ID,Name,Number

01,HHVIC,1号

02,HH,2号

03,VV,3号