Looking for and Arcade expression to calculate a running (moving) average of COVID-19 daily new cases

696
2
05-12-2020 07:06 AM
JohnEsch
New Contributor II

Many states or counties are reporting daily new COVID-19 cases and new COVID-19 deaths. This data charted either on a statewide or county level is often erratic. But a 3 or 5 or 7 day running (moving) average of the data plotted on top of the daily new cases or deaths does a better job of presenting the overall trend in the data. I am looking for a Python script or Arcade expression that I an use to quickly calculate a 3,5, or 7 day average of the data to use in ArcGIS Pro, AGOL, or a Dashboard. I am also looking for a way to keep the data up to date.

Thanks

0 Kudos
2 Replies
XanderBakker
Esri Esteemed Contributor

Hi John Esch ,

I guess Python would be the right way to go in this case. For instance Pandas in Python has the rolling window you could apply (as described here: Moving Averages in pandas - DataCamp😞

df.rolling(window=size).mean()

... and to keep the data up to date you could schedule the script using ArcGIS Pro: Schedule geoprocessing tools—ArcGIS Pro | Documentation . 

0 Kudos
JeremiahLindemann
Esri Contributor

Hi John-

Take a look at the Coronavirus Recovery Dashboard solution:

Coronavirus Recovery Dashboard | ArcGIS Solutions 
Included is a pro package to help with the trend lines.

Jer