MongoDB導入CSV文件

02-10

import pymongo

import pandas as pd

import json

client = pymongo.MongoClient("mongodb://localhost:27017")

db=client["Neo"]

name="CompustatName"
collection=db[name]

CompustatName = pd.read_csv("compustat_name.csv")

data = json.loads(CompustatName.to_json(orient="records"))

collection.insert(data)

還是寫代碼快....shell整了一天沒結果寫代碼解決...