import pymongo
import json
def df2bson(df):
"""DataFrame类型转化为Bson类型"""
data = json.loads(df.T.to_json()).values()
return data
def database(df_data,s):
client = pymongo.MongoClient("mongodb://xx.xxx.xxx.xxx:27017/")
client.admin.authenticate('root', '123456')
db = client["db_name"]
col = db[s]
bson_data = df2bson(df_data)
result = col.insert_many(bson_data)
database(df,'col_name')