Home / Questions / 268854
Accepted
kev
Asked: 2020-06-02 16:49:42 +0800 CST 2020-06-02 16:49:42 +0800 CST

Add variable for two months in R

  • 772

I have the following dataframe and I need to obtain the bimonthly sums for January and February for the rainfall variable. I did it for years. This is the code I used

df.mensual <- df %>%
group_by(anio,mes,codigo) %>%
summarise(precip.mensual = sum(lluvia,na.rm="TRUE"))

filtering = filter(df.mensual, mes<3)

What I need is to add the months of filtering for each year and code. Then make a table that looks like this:


         1980 1981 1982 1983
----------------------------------------------------
codigo1   A    A    A    A
codigo2   A    A    A    A
codigo3   A    A    A    A

where are the A that are the bimonthly sums of January and February for each year and code.

r

1 Answers

  1. Best Answer

    The problem can be solved like this

    #Se filtran los meses de interés
filtering = filter(df.mensual, mes<3) 

#Se crea un dataframe bimestre que agrupa el filtro anterior por año, luego los suma.
df.bimestral<- filtering %>%
    group_by(anio,codigo) %>%
    summarise(precip.bim = sum(precip.mensual,na.rm="TRUE"))

    Then the result is the following

     anio codigo precip.bim
1   1910  87585        160
2   1911  87585        124
3   1912  87585        161
4   1913  87585         21
5   1914  87585        202
    • 1