pandas基础__之__对获取mongodb数据

import pandas as pdfrom pymongo import MongoClient#建立MongoDB数据库连接client = MongoClient('192.168.248.52',12000)#连接所需数据库,locateInfo为数据库名db = client.locateInfodb.authenticate("me", "me")#连接所用集合collection = db.dataCollect#从mongodb获取数据gpsData = pd.DataFrame(list(collection.find({"deviceId":"05792"})))#删除数据Id字段del gpsData['_id']# 选择需要显示的字段gpsData = gpsData[['deviceId','lating','lnging','gnssTime','locateType']]#对数据按照时间的升序排序gpsData = gpsData.sort('gnssTime')print(gpsData)