標準のcsvモジュールでcsvファイルを扱う
csvファイルの書き込み
fruits = ['apple', 'banana', 'cherry', 'kiwi', 'orange', 'peach', 'pineapple']
with open('Python_Library/m_csv/fruits_list.csv', 'w',
encoding='utf-8', newline='') as f:
fieldnames = ['fruit_cord', 'fruit_name']
writer = csv.DictWriter(f, fieldnames=fieldnames)
writer.writeheader()
for i, v in enumerate(fruits):
writer.writerow({'fruit_cord': i+1, 'fruit_name': v}) # fruit_cordは1から
fruit_cord,fruit_name
1,apple
2,banana
3,cherry
4,kiwi
5,orange
6,peach
7,pineapple
csvファイルの読み込み
with open('Python_Library/m_csv/fruits_list.csv', 'r',
encoding='utf-8', newline='') as f:
reader = csv.DictReader(f)
for row in reader:
print(row['fruit_cord'], row['fruit_name'])
1 apple
2 banana
3 cherry
4 kiwi
5 orange
6 peach
7 pineapple