from pathlib import Path
import json
import pandas as pd
R=Path(__file__).resolve().parent
def load_games():
    g=pd.read_parquet(R.parent/'analysis-2026-09-05/games.parquet')
    for appid,record in json.loads((R/'date_overrides.json').read_text()).items():
        date=pd.Timestamp(record['date'],tz='UTC');mask=g.appid.eq(int(appid))
        g.loc[mask,'first_date']=date
        g.loc[mask,'year']=date.year;g.loc[mask,'month']=date.month
        g.loc[mask,'quarter']=f'{date.year}-Q{date.quarter}'
    return g