COVID 14 day rolling average

Looking for data
#1

Can anyone please help me find the COVID stats for the 14 day rolling average of locally acquired cases in NSW. Thanks

#2

@Blue how confident are you with R or Python (pandas)?

The dataset NSW COVID-19 cases by location and likely source of infection provides daily stats. You should be able to use a windowing function to calculate the 14 day rolling average.

For example, in Python pandas, I would use something like:

# You will need to install pandas if you don't already have it installed.
import pandas as pd

# You will need to provide the correct path to this file.
df = pd.read_csv("confirmed_cases_table4_location_likely_source.csv",
                 dtype=str, parse_dates=["notification_date"])
cases_by_date = (df.set_index('notification_date', drop=False)
                   .resample('1d')['notification_date']
                   .count())
rolling_14_day_average = cases_by_date.rolling('14d').mean()
rolling_14_day_average.to_csv("rolling_14_day_average.csv")
© Data.NSW