python连接mongodb进行查询_MongoDB聚合查询及Python连接MongoDB操作

今日内容概要

聚合查询

Python操作MongoDB

第三方可视化视图工具

今日内容详细

聚合查询

Python操作MongoDB

数据准备

from pymongo import MongoClient # 载入pymongo模块

import datetime # 载入datetime模块

client = MongoClient('mongodb://root:666@localhost:27017')# 连接MongoDB数据库(mongodb://用户名:密码@localhost(ip地址):port端口)

table = client['huangduoduo']['emp'] # client['数据库']['所形成的的表名']

l=[

('egon','male','男',18,'20170301','teacher',7300.33,401,1),

('alex','male','男',78,'20150302','teacher',1000000.31,401,1),

('wupeiqi','male','男',81,'20130305','teacher',8300,401,1),

('yuanhao','male','男',73,'20140701','teacher',3500,401,1),

('liwenzhou','male',28,'20121101','teacher',2100,401,1),

('jingliyang','female',18,'20110211','teacher',9000,401,1),

('jinxin','male',18,'19000301','teacher',30000,401,1),

('成龙','male',48,'20101111','teacher',10000,401,1),

('歪歪','female',48,'20150311','sale',3000.13,402,2),

('丫丫','female',38,'20101101','sale',2000.35,402,2),

('丁丁','female',18,'20110312','sale',1000.37,402,2),

('星星','female',18,'20160513','sale',3000.29,402,2),

('格格','female',28,'20170127','sale',4000.33,402,2),

('张野','male',28,'20160311','operation',10000.13,403,3),

('程咬金','male',18,'19970312','operation',20000,403,3),

('程咬银','female',18,'20130311','operation',19000,403,3),

('程咬铜','male',18,'20150411','operation',18000,403,3),

('程咬铁','female',18,'20140512','operation',17000,403,3)

]

for n,item in enumerate(l):

d={

"_id":n,

'name':item[0],

'sex':item[1],

'age':item[2],

'hire_date':datetime.datetime.strptime(item[3],'%Y%m%d'),

'post':item[4],

'salary':item[5]

}

table.save(d)

# 以sql语句为例

# 统计每个部门年龄大于20岁以上的员工的平均工资大于10000的部门和平均工资

select post,avg(salary) from emp where age>20 group by