Doing some Coronavirus work.
I've seen some models that peg the local start date to when there are three days in a row with new cases identified. What I see in many counties is they get the first case and then a period of days, sometimes a month, goes by before they get the next case.
How do I filter out the rows in a county that were before there were three continuous days of cases.
I'm only showing one county for brevity but I would want this to go through the entire dataset and do it for every county. In this case all of the rows with ttl_cases == 1 would be removed.
"index","id","date","ttl_cases"
"1","Jefferson_Colorado",2020-03-05,1
"2","Jefferson_Colorado",2020-03-06,1
"3","Jefferson_Colorado",2020-03-07,1
"4","Jefferson_Colorado",2020-03-08,1
"5","Jefferson_Colorado",2020-03-09,1
"6","Jefferson_Colorado",2020-03-10,2
"7","Jefferson_Colorado",2020-03-11,4
"8","Jefferson_Colorado",2020-03-12,5
"9","Jefferson_Colorado",2020-03-13,7
"10","Jefferson_Colorado",2020-03-14,9
Thanks for any help.