Python-csv

import csv

#newline=‘’ : 可以避免一些不必要的空行
with open("E:\Code\study_test\csv_test.csv",newline='') as files:
    #reader：一行一行的讀取
    csv_reader = csv.reader(files)
    for i in csv_reader:
        print(i)

with open("E:\Code\study_test\csv_test.csv", newline='') as files:
    #DictReader：会将读取到的信息转换为字典形式
    csv_DictReader = csv.DictReader(files)
    #獲取表頭
    csv_header = csv_DictReader.fieldnames
    print(csv_header)
    for i in csv_DictReader:
        print(i)

with open("E:\Code\study_test\csv_test.csv","w",newline='') as files:
    csv_writer = csv.writer(files)
    #writerow寫入一行
    csv_writer.writerow(['Wang', '22'])
    #writerows寫入多行
    csv_writer.writerows([('Li', '20'),('Zhang', '18')])

with open("E:\Code\study_test\csv_test.csv","w",newline='') as files:
    fieldnames = ["name","age"]
    csv_DictWriter = csv.DictWriter(files,fieldnames=fieldnames)
    csv_DictWriter.writerow({'name': 'Zhang', 'age': "20"})

    csv_DictWriter.writerows([{'name': "Wang", 'age': "22"},{'name': "Li", 'age': "24"}])