Mongo入门基础（三）csv数据上传到mongo上

• 思路：把每行的数据换成dict，然后合成一个大dict，再一行行加入进去

import pandas as pd
import numpy as np
from pymongo import MongoClient

#登录mongo
host = ['localhost:27017']
client = MongoClient(host=host)

#读取数据，转置后转为dict
df = pd.read_csv("FactorReturn_2021009-20211029.csv")
df = df.rename({'Unnamed: 0':"_id"},axis = 'columns')
df = df.T.to_dict()

#一行行insert
for i in range(len(df)):
    client.mydb.test_set.remove({"_id":df[i]["_id"]})
    client.mydb.test_set.insert_one(df[i])