Currently, the movement metrics spreadsheets (readers and editors and content) are updated by code in the movement-metrics notebooks which using a Python library to write new cells using the API. We can completely remove all this complexity by just using the IMPORTDATA function to load the data from the TSVs on GitHub.
We should also probably just make it a single spreadsheet with separate tabs for each source file.
| Title | Reference | Author | Source Branch | Dest Branch | |
|---|---|---|---|---|---|
| Remove Google spreadsheets integration | repos/movement-insights/movement-metrics!17 | nshahquinn-wmf | work/nshahquinn-wmf/remove-spreadsheets-integration | main |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | nshahquinn-wmf | T359207 Improve the delivery of the movement movements (SDS 2.6.2) | |||
| Resolved | nshahquinn-wmf | T359699 Update movement metrics spreadsheets to load data automatically | |||
| Resolved | nshahquinn-wmf | T359692 Remove any unnecessary metrics and charts from the movement-metrics notebooks | |||
| Resolved | nshahquinn-wmf | T359687 Determine which metrics and charts can be eliminated from the movement-metrics repository | |||
| Resolved | Hghani | T362207 Rename metrics and reorganize them into more logical groups |
nshahquinn-wmf opened https://gitlab.wikimedia.org/repos/movement-insights/movement-metrics/-/merge_requests/17
Remove Google spreadsheets integration
hghani merged https://gitlab.wikimedia.org/repos/movement-insights/movement-metrics/-/merge_requests/17
Remove Google spreadsheets integration