12345678910111213141516 |
- import csv
- import dataset
- # 開啟 CSV 檔案
- db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/microfilm?charset=utf8mb4')
- with open('youtubeReport.csv', newline='',encoding='UTF-8') as csvfile:
- # 讀取 CSV 檔案內容
- rows = csv.reader(csvfile)
- # 以迴圈輸出每一列
- for row in rows:
- print(row[5])
- db['ytVideos'].insert({'channelTitle':row[0],'subscribes':row[1],'description':row[2]
- ,'videoTitle':row[3],'publishedAt':row[4],'viewCount':row[5],'likeCount':row[6],'favoriteCount':row[7]})
- db.close()
|