Calculate average by group and starting in an specific date, in R

Asked Aug 31 '20 at 22:07

Active Sep 01 '20 at 10:57

Viewed 50 times

Here we have a panel data of "pessoas contadas" (counted people) in the city of Rio de Janeiro, by "dia" (day) and "bairro" (neighborhood). I want to calculate the average of counted people, by "bairro", in the last n days, according to the day 24/03/2020. The result must be repeated along the role panel, by "bairro". How can I do it?

You can download the dataset here: https://www.dropbox.com/s/yz5fkgs0vuyoi8s/teste.xlsx?dl=0

edited Sep 01 '20 at 10:57

Z.Lin

28,055
6
54
94

asked Aug 31 '20 at 22:07

Mateus Maciel

3

What do you mean by "The result must be repeated along the role panel, by 'bairro'"? Do you want to calculate a rolling mean? – sabacherli Sep 01 '20 at 06:25
No, I want the same result calculated to be repeated along the. – Mateus Maciel Sep 03 '20 at 18:46
1

Could you post your desired output? It might help us to understand what you're trying to do to get an answer – stlba Sep 09 '20 at 13:05
I've found the answer in this post: https://stackoverflow.com/questions/26291988/how-to-create-a-lag-variable-within-each-group. – Mateus Maciel Sep 12 '20 at 18:58

Calculate average by group and starting in an specific date, in R

0 Answers0