MongoDB中的聚合操作和Python的数据可视化

# 导入MongoDB驱动和数据可视化库
import pymongo
import matplotlib.pyplot as plt

# 连接MongoDB数据库
client = pymongo.MongoClient("mongodb://localhost:27017/")
db = client["mydatabase"]
collection = db["mycollection"]

# 进行聚合操作，统计“pidancode.com”和“皮蛋编程”的文章数量
pipeline = [
    {"$match": {"$or": [{"title": {"$regex": ".*pidancode.com.*"}}, {"title": {"$regex": ".*皮蛋编程.*"}}]}},
    {"$group": {"_id": "$author", "count": {"$sum": 1}}},
    {"$sort": {"count": -1}},
]

result = collection.aggregate(pipeline)

# 将结果转换为列表
labels = []
sizes = []
for doc in result:
    labels.append(doc["_id"])
    sizes.append(doc["count"])

# 绘制饼图
plt.pie(sizes, labels=labels, autopct='%1.1f%%', startangle=90)
plt.axis('equal')  # Equal aspect ratio ensures that pie is drawn as a circle.
plt.title("文章作者统计")
plt.show()