Marks find the hotspot and coldspot districts per week

The district data of India is available as a JSON file from neighbor-districts.json. It is in an adjacency list format. The file is available at the resources tab of the course webpage as well as the resources section of the hello.iitk.ac.in portal.

Submit all the necessary components of your data as a single zip file named rollno-assign1.zip in the hello.iitk.ac.in portal within the deadline.

Output the new data as neighbor-districts-modified.json. Arrange all the districts in alphabetical order, and give them ids starting from 101 (yes, 101 and not 1).

2. (20 marks) For every district i, find the number of cases from the Covid-19 portal. Take the time-period of analysis from 15th March, 2020 to 5th September, 2020.

1. Find these for every week. A week is from Sunday to Saturday.

2. Find these for every month.

Repeat finding these for every week/month/overall as in the earlier question. If a district is the only one in its state, consider its standard deviation to be 0.

The output format is: districtid, timeid, statemean, statestdev where the mean and standard deviation values are rounded to 2 places of decimal digits. Call this output file state-time.csv and the script/program to generate this state-generator.sh where time is week, month, and overall.

8. (15 marks) For every month and overall, find the top-5 hotspot and top-5 coldspot districts using the z-score values according to both the neighborhood and state methods.

The output format is: timeid, method, spot, districtid1, . . . , districtid5 where method indi-cates the comparison method used (neighborhood/state) and spot indicates hot/cold. Call this output file top-time.csv and the script/program to generate this top-generator.sh where time is week, month, and overall.

Page 2