csv文件的读取_写入

csv文件读取
import csv
with open(r'aa.csv','r',encoding='utf-8') as f:
    aa_csv=csv.reader(f)
    print(aa_csv)       #结果：<_csv.reader object at 0x0000022F5DBF11E8>
    print(list(aa_csv)) #结果：[['ID', '姓名', '年龄', '薪资'], ['1001', 'Vince', '18', '3500'], ['1002', 'Tom', '19', '4000'], ['1003', 'Bob', '20', '4500']]
    a_list=list(aa_csv)
    for row in a_list:
        print(row)
    #结果：
['ID', '姓名', '年龄', '薪资']
['1001', 'Vince', '18', '3500']
['1002', 'Tom', '19', '4000']
['1003', 'Bob', '20', '4500']



写csv文件
with open(r'bb.csv','w',encoding='utf-8') as f:
    b_csv=csv.writer(f)
    #单行列表写入csv文件
    b_csv.writerow(['ID','姓名','年龄'])
    b_csv.writerow(['1001','Jer','28'])
    
    #二维列表写入csv文件
    lists=[['1002','Tom','29'],['1003','Bob','30']]
    b_csv.writerows(lists)

查看bb.csv:
ID,姓名,年龄

1001,Jer,28

1002,Tom,29

1003,Bob,30