Process 2021 config data

[TaiWilkin]

Overview

Updates the data processing script to handle the new 2021 column names and use the 2021 config data.

Updates the categories to: Norms, Access, and Agency (A); Time Spent and Care (B ); COVID's impact (C); and Demographics (D).

Note that the full 2021 data is not yet available, so selecting 2021 in the app will currently result in no data being displayed. There will also be null values for some questions when 2020 is selected, because some questions weren't asked in 2020. However, the application has been updated to handle null data gracefully, and this will be followed by #113, which will hide questions in the selector which are invalid for current year/location selections.

Connects #112

Demo

Notes

We will still need to update to use the full 2021 dataset once it is available - see #119. However, proceeding with this task prior to the full dataset becoming available unblocks multiple other tasks, and the future data update should be quick (assuming no additional structural changes).

Testing Instructions

• Download the two .xlsx files from 2021 data, and place them in /src/dataproc
• Follow the steps under Data and Updating application with new data in the Readme. The data processing script should succeed.
• Run ./scripts/server and confirm that the app runs as before without errors.
• Confirm that both years display in the year selection screen.
• Confirm that the new categories and questions are displayed on the questions page.
• Confirm that questions can be selected and their charts can be viewed as before (where data is available), and that null data doesn't cause the app to break.

[rajadain]

Taking a look now

[TaiWilkin]

Thank you for reviewing!