將整個 CSV 寫入 MongoDB,使用Python Code 實現
將整張CSV 直接倒入Mongo DB 內?!可以不用手動一筆筆輸入DB,是不是一件令人興奮的事情呢….
CSV 表範例
Python Example Code
import csv
import pandas as pd
from pymongo import MongoClient
client = MongoClient("192.168.50.208",27017)
db = client ["Your DB NAME"]
collection = db ["Your Collection Name"]
data = pd.read_csv('example.csv',encoding = 'UTF-8')
data_json = json.loads(data.to_json(orient='records'))
collection.insert(data_json)
自MongoDB上面查看
成功將數據寫入MongoDB 內
Python3 需求套件列表:
pandas
pymongo