1、讀取 csv 檔案中的資料
- reader() 回傳一個 reader 物件，利用該物件遍歷 csv 檔案中的行
- 從 csv 檔案中讀取的每一行都作為字串串列回傳
import csv # data_info.csv 是檔案名稱 with open("data_info.csv","r") as f: data = csv.reader(f) for d in data: if d[0] == "username": # 過濾第一行 title continue print(d) # 結果如下 ['admin', '123456'] ['guest', '234567']
2、寫入 csv 檔案資料
- writer(myFile) 回傳 writer 物件 myWriter
- writerow() 方法是一行一行寫入，writerows 方法是一次寫入多行
- 注意：如果檔案 'data_info.csv' 事先存在，呼叫 writer 函式會先清空原檔案中的文本，再執行 writerow/writerows 方法，
# 使用 writerow() 逐行寫入 import csv # newline="" 消除每寫入一行就出現一行空單元格效果 with open("data_info.csv","w",newline="") as f: myWrite = csv.writer(f) myWrite.writerow(["username","password"]) myWrite.writerow(["admin","123456"]) myWrite.writerow(["guest","234567"])
# 使用 writerows() 批量寫入 import csv with open("data_info.csv","w",newline="") as f: myWrite = csv.writer(f) # 每行資料放在一個陣列中 data_list = [["username","password"],["admin","123456"],["guest","234567"]] myWrite.writerows(data_list)
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/147656.html
標籤：Python
上一篇：python基礎一