I've written a Python script that:
1) takes the COVID-19 confirmed cases (US) raw file from JHU's github here,
2) selects for a specific county, and
3) creates a new variable ("new_cases") to calculate the daily number of new cases.
I want to display the daily new cases data on a dashboard in ArcGIS Online. What is the best way to go from the variable in my Python script to an output in AGOL, where I can just run the script and the updates will sync?
Currently, I am outputting an excel file from the Python script, uploading that file to AGOL, and hosting it as a table. However, whenever I try to overwrite or append data, the time zone reverts to UTC, and it looks like I am a day behind (8/31/2020 shows up as 8/30/2020), etc. Thus, I am having to reupload the excel file every day so that I can establish the correct time zone.