- 安装 pandas 和 pymongo
pip install pandas -i https://pypi.tuna.tsinghua.edu.cn/simple
pip install pymongo -i https://pypi.tuna.tsinghua.edu.cn/simple
import pandas as pd
from pymongo import MongoClient
# mongodb://localhost/ 数据库连接地址
client = MongoClient("mongodb://localhost/")
# user 数据库名称
db = client["user"]
# table 集合名称
product_summary = db["table"]
# table_name csv数据内容
data = pd.read_csv('table_name.csv')
for index, row in data.T.to_dict().items():
product_summary.insert_one(row)