Worked a good amount on this today and spent some time troubleshooting with Dhrumil. As it stands now, if you run the csv file through the python script in your terminal ($ cat OxCGRT_latest_01092021_0100.csv | python3 ./country_data.py), it will return the row with the latest date (right now still hard-coded on Aruba). Dhrumil said that it's unfortunately not possible to make the python script dynamic with a value selected by the user since our site will be static. He mentioned we'll want to create a new table using dictionary and key-value pairs that contains (1) a country and (2) the most recent date that has data for it, and our site will read off of that table. If you have an idea how to implement this @nkhlgeorge, maybe this should be our next direction?
Worked a good amount on this today and spent some time troubleshooting with Dhrumil. As it stands now, if you run the csv file through the python script in your terminal ($ cat OxCGRT_latest_01092021_0100.csv | python3 ./country_data.py), it will return the row with the latest date (right now still hard-coded on Aruba). Dhrumil said that it's unfortunately not possible to make the python script dynamic with a value selected by the user since our site will be static. He mentioned we'll want to create a new table using dictionary and key-value pairs that contains (1) a country and (2) the most recent date that has data for it, and our site will read off of that table. If you have an idea how to implement this @nkhlgeorge, maybe this should be our next direction?