如何用Python实现CMS系统的用户访问分析功能

from flask import Flask, request
from datetime import datetime

app = Flask(__name__)

@app.route('/')
def home():
    user_id = request.args.get('user_id')
    page = request.url
    access_time = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
    
    # 将用户访问记录存储到数据库或文件中
    record = f"{user_id},{access_time},{page}
"
    with open('access_log.txt', 'a') as f:
        f.write(record)
    
    return 'Welcome to CMS home page!'

if __name__ == '__main__':
    app.run()

import pandas as pd

df = pd.read_csv('access_log.txt', names=['user_id', 'access_time', 'page'])

# 统计每个用户的访问次数
visit_count = df['user_id'].value_counts()

# 统计独立访问用户数
unique_users = df['user_id'].nunique()

# 统计每个页面的访问次数
page_count = df['page'].value_counts()

print("用户访问统计：")
print(visit_count)
print("
独立访问用户数：", unique_users)
print("
页面访问统计：")
print(page_count)

import matplotlib.pyplot as plt

# 绘制用户访问次数的柱状图
plt.figure(figsize=(10, 6))
visit_count.plot(kind='bar', rot=0)
plt.xlabel('User ID')
plt.ylabel('Visit Count')
plt.title('User Visit Count')
plt.show()

# 绘制页面访问次数的饼图
plt.figure(figsize=(10, 6))
page_count.plot(kind='pie', autopct='%1.1f%%')
plt.ylabel('')
plt.title('Page Visit Count')
plt.show()