X-Git-Url: https://plomlompom.com/repos/?p=berlin-corona-table;a=blobdiff_plain;f=enhance_table.py;h=2b6bb8dc8ff7fcc4f51cb279a44671294f4a0d79;hp=d9ca849c4901232bc12e501b462714c749a9bf12;hb=d90d54eb25c326364575d062543664a214506210;hpb=2724a3abcb796cf91bbcac204569594765ae6eb7 diff --git a/enhance_table.py b/enhance_table.py index d9ca849..2b6bb8d 100755 --- a/enhance_table.py +++ b/enhance_table.py @@ -1,5 +1,11 @@ #!//usr/bin/env python3 +import sys +if len(sys.argv) != 2: + print('Expecting infections table file path as only argument.') + exit(1) +infections_table = sys.argv[1] + # District population numbers as per Wikipedia. district_pops = { 'CW': 342332, @@ -17,11 +23,11 @@ district_pops = { 'sum': 3754418, } -f = open('daily_infections_table.txt', 'r') +f = open(infections_table, 'r') lines = f.readlines() f.close() -# Parse first table file line for the names and order of districts. +# Parse first table file line for the names and order of districts. db = {} sorted_districts = [] for header in lines[0].split(): @@ -40,11 +46,14 @@ for line in lines[1:]: db[district][date] = {'new_infections': int(district_data)} sorted_dates.sort() +# In LaGeSo's data, the last "district" is actually the sum of all districts / +# the whole of Berlin. +# # Fail on any day where the "sum" district's new infections are not the proper # sum of the individual districts new infections. Yes, sometimes Lageso sends # data that is troubled in this way. It will then have to be fixed manually in # the table file, since we should have a human look at what mistake was -# probably made. +# probably made. for date in sorted_dates: sum_district = sorted_districts[-1] day_sum = 0 @@ -60,9 +69,9 @@ for i in range(len(sorted_dates)): if i < 6: continue date = sorted_dates[i] - week_dates = [] + week_dates = [] for j in range(7): - week_dates += [sorted_dates[i - j]] + week_dates += [sorted_dates[i - j]] for district in sorted_districts: district_pop = district_pops[district] week_sum = 0 @@ -109,9 +118,9 @@ for date in sorted_dates: if weekday_count == 0: print(' '*11, ' '.join(sorted_districts[:-1]), sorted_districts[-1], 'wsum', ' wavg', 'winc') - week_start_date = date + week_start_date = date - # Day data line. + # Day data line. new_infections = [] for district in sorted_districts: new_infections += [db[district][date]['new_infections']] @@ -119,13 +128,13 @@ for date in sorted_dates: sum_district = sorted_districts[-1] sum_district_data = db[sum_district][date] if 'week_sum' in sum_district_data: - week_sum = '%4s' % sum_district_data['week_sum'] + week_sum = '%4s' % sum_district_data['week_sum'] if 'week_average' in sum_district_data: - week_avg = '%5.1f' % sum_district_data['week_average'] + week_avg = '%5.1f' % sum_district_data['week_average'] if 'week_incidence' in sum_district_data: - week_inc = '%4.1f' % sum_district_data['week_incidence'] + week_inc = '%4.1f' % sum_district_data['week_incidence'] print(date, ' '.join(['%3s' % infections for infections in new_infections]), - week_sum, week_avg, week_inc) + week_sum, week_avg, week_inc) # Maintain 7-day cycle. weekday_count += 1