import pandas as pd, sys
e=pd.read_parquet(sys.argv[1]+'/events.parquet'); p=pd.read_parquet(sys.argv[1]+'/people.parquet')
print(e['mode'].value_counts()); print(e['tap'].value_counts(dropna=False)); print(e.ts.min(), e.ts.max())
print(p.home_npa.value_counts())
CS={'ST-LUZ','ST-VITZ','ST-RIGI','ST-KALT','ST-PIL','ST-STH','ST-STO','ST-TIT','ST-ZUG','ST-CHA','P-ZUG-METALLI'}
g=p[p.home_npa==1422]; print('Grandson residents',len(g)); print(g.to_string())
eg=e[e.pid.isin(g.pid)]
cs=eg[eg.place_id.isin(CS)]
print(cs.sort_values('ts').to_string())