import sys, pandas as pd
pd.set_option('display.width',250,'display.max_rows',500)
p=pd.read_parquet(f'{sys.argv[1]}/people.parquet'); e=pd.read_parquet(f'{sys.argv[1]}/events.parquet')
G='84422f7c'
days=set(e[(e.pid==G)&(e.zone=='BER-AAREFORUM')].ts.dt.date)
r=e[(e['mode']=='reservation')&(e.zone=='BER-AAREFORUM')]
r=r.assign(d=r.ts.dt.date)
k=r[r.d.isin(days)].groupby('pid').d.nunique().sort_values(ascending=False)
print(k.head(8))
top=k.index[0]
print(p[p.pid==top]); print(e[e.pid==top].to_string())
print(r[r.pid==top].groupby('group_name').size())
print('autres resas de ce nom:', r[r.group_name.isin(r[r.pid==top].group_name)].pid.unique())