mysql - 如何获得每月发布或评论的唯一活跃用户数？

import pandas as pd
import numpy as np

# 加载数据
data = pd.read_csv('monthly_publishers.csv')

# 数据清理
data = data.drop_duplicates()
data = data.dropna()

# 用户识别
user_identifers = pd.read_csv('user_identifiers.csv')

# 发布或评论识别
text_analysis = pd.read_csv('text_analysis.csv')

# 唯一活跃用户识别
unique_users = pd.read_csv('unique_users.csv')

# 结果计算
monthly_publishers = pd.read_csv('monthly_publishers.csv')
monthly_publishers['unique_users'] = monthly_publishers['total_users'] - monthly_publishers['duplicate_users']

# 结果可视化
plt.plot(monthly_publishers['date'], monthly_publishers['unique_users'])
plt.xlabel('Date')
plt.ylabel('Unique Users')
plt.title('Monthly Unique Publishers')
plt.show()