import pandas as pd
import matplotlib.pyplot as plt

# ดึงข้อมูลจาก database
user_summary = (
    df_tx.groupby('member_id')
    .agg({
        'price': 'sum',
        'transaction_id': 'count'
    })
    .rename(columns={
        'price': 'total_spent',
        'transaction_id': 'purchase_count'
    })
)

# จัดกลุ่มผู้ใช้แบบง่าย
user_summary['segment'] = pd.cut(
    user_summary['total_spent'],
    bins=[0, 100, 500, 2000, 10000],
    labels=['Free', 'Casual', 'Regular', 'VIP']
)

# สร้างกราฟ
plt.bar(revenue_by_month['month'].astype(str),
        revenue_by_month['price'])
plt.title('Monthly Revenue (6M)')
plt.xlabel('Month')
plt.ylabel('Revenue (THB)')
plt.xticks(rotation=45)
plt.show()