This report will consist of:
1) Single Spike SNV frequencies, both global and regional
2) Co-occurring Spike SNV frequencies, both global and regional
3) PANGO lineage frequencies, both global and regional
Fetch the more complex data (regional data) from the database,
and then from this compute the global counts in python.
Format the regional tables as pivot tables, and do this in python,
since crosstab() in Postgres makes me sad
Generate a Spike mutation and lineage report
This report will consist of: 1) Single Spike SNV frequencies, both global and regional 2) Co-occurring Spike SNV frequencies, both global and regional 3) PANGO lineage frequencies, both global and regional
Fetch the more complex data (regional data) from the database, and then from this compute the global counts in python. Format the regional tables as pivot tables, and do this in python, since crosstab() in Postgres makes me sad
Start and end dates are passed via. URL query params Download the full excel file with: curl http://[host]/az_report?start_date=YYYY-MM-DD&end_date=YYYY-MM-DD -o out.xlsx Dates are in ISO format "YYYY-MM-DD"