from pymongo import MongoClient
import json
def mongoimport(csv_path, db_name, coll_name, db_url='localhost', db_port=27000)
""" Imports a csv file at path csv_name to a mongo colection
returns: count of the documants in the new collection
"""
client = MongoClient(db_url, db_port)
db = client[db_name]
coll = db[coll_name]
data = pd.read_csv(csv_path)
payload = json.loads(data.to_json(orient='records'))
coll.remove()
coll.insert(payload)
return coll.count()
我认为失败是因为你的数据不是json。如果要从csv文件插入数据,可以尝试以下操作:
将熊猫作为pd导入
此代码易于理解,此代码来自https://gist.github.com/jxub/f722e0856ed461bf711684b0960c8458
相关问题 更多 >
编程相关推荐