"""Write the dataset's CSV tables from the FARS tables built in analyze.py. Usage: python -I export.py (run from this folder)""" import runpy, io, contextlib, csv, json, datetime as dt, statistics as st, sys with contextlib.redirect_stdout(io.StringIO()): g = runpy.run_path('analyze.py', run_name='x') ai, al, nights, rank, rows, tg = g['ai_by_hour'], g['all_by_hour'], g['nights'], g['rank'], g['rows'], g['thanksgiving'] nth, last = g['nth_weekday'], g['last_weekday'] out = 'data' with open(f'{out}/nights.csv', 'w', newline='') as f: w = csv.writer(f); w.writerow(['night_start_date', 'weekday', 'alcohol_impaired_deaths', 'all_traffic_deaths', 'rank_in_year', 'nights_in_year']) for d, a, t in nights: w.writerow([d.isoformat(), d.strftime('%A'), f'{a:.1f}', int(t), rank[d][0], rank[d][1]]) with open(f'{out}/named-nights.csv', 'w', newline='') as f: w = csv.writer(f); w.writerow(['night', 'year', 'night_start_date', 'weekday', 'alcohol_impaired_deaths', 'all_traffic_deaths', 'rank_in_year', 'nights_in_year']) for r in rows: for p in r['per_year']: w.writerow([r['night'], p['year'], p['date'], p['weekday'], f"{p['ai']:.1f}", p['all'], p['rank'], p['nights_in_year']]) def period(start, hours, t): return sum(t.get(((start+dt.timedelta(hours=k)).date(), (start+dt.timedelta(hours=k)).hour), 0) for k in range(hours)) at6 = lambda d: dt.datetime.combine(d, dt.time(18)) with open(f'{out}/holiday-periods.csv', 'w', newline='') as f: w = csv.writer(f); w.writerow(['holiday_period', 'year', 'start', 'hours', 'alcohol_impaired_deaths', 'all_traffic_deaths']) for y in range(2015, 2025): for name, s in [('Thanksgiving (Wed 6 p.m. to Mon 6 a.m.)', at6(tg(y)-dt.timedelta(days=1))), ('Memorial Day (Fri 6 p.m. to Tue 6 a.m.)', at6(last(y,5,0)-dt.timedelta(days=3))), ('Labor Day (Fri 6 p.m. to Tue 6 a.m.)', at6(nth(y,9,0,1)-dt.timedelta(days=3)))]: w.writerow([name, y, s.isoformat(timespec='minutes'), 108, f'{period(s,108,ai):.1f}', int(period(s,108,al))]) print('ok')