①首先用到的Python相关的包
from sqlalchemy import create_engine
from bson.objectid import ObjectId
from datetime import datetime
import pymongo
import pandas as pd
import numpy as np
import time import pymysql
②mongodb数据库身份验证(排版问题,请忽略)
def get_db():
client = pymongo.MongoClient(‘192.168.1.205’,20203)
db = client.xizi_backend_v2 db.authenticate(name=‘readAnyDatabase’,password=‘4g3UYka3bJec’,source=‘admin’,mechanism=‘SCRAM- SHA-1’)
return db
③连接mongodb并查询
collection = get_db().teacher
org_id = “5d12cdcd5f1d9a710aaff8b1”
find_data = collection.find({“orgnization”:ObjectId(org_id)},{"_id":1,“name”:1,“orgnization”:1,“user_id”:1})
④将查询到的json格式的数据转换成list然后再变成dataframe
#用来存储mogodb数据
g = []
for i in find_data:
g.append(i)
#用来存储ObjectID类型的数据转换成str类型的数据
m = []
for i in data["_id"]:
st