Hi Stefano, What about this? df$months<-format(df$data_POSIX,"%Y-%m") snow_means<-by(df$value,df$months,mean)
Jim On Mon, Sep 14, 2020 at 8:19 PM Stefano Sofia <stefano.so...@regione.marche.it> wrote: > > Dear R-list users, > I know that this is a trivial question, but I already wasted quite a large > amount of time on that. > I have a data frame with daily data of snow fall. I need to evaluate the > monthly mean for each month and each year in the data frame. > Could you help me to find an eficient way for these calculations? > > Thank you for your help > Stefano > > Here a reproducibile code: > > first_day_1 <- as.POSIXct("2019-01-19-00-00", format="%Y-%m-%d-%H-%M") > last_day_1 <- as.POSIXct("2019-03-20-00-00", format="%Y-%m-%d-%H-%M") > df1 <- data.frame(data_POSIX=seq(first_day_1, last_day_1, by="1 days")) > df1$value <- runif(nrow(df1), 0, 10) > > > first_day_2 <- as.POSIXct("2020-02-19-00-00", format="%Y-%m-%d-%H-%M") > last_day_2 <- as.POSIXct("2020-04-20-00-00", format="%Y-%m-%d-%H-%M") > df2 <- data.frame(data_POSIX=seq(first_day_2, last_day_2, by="1 days")) > df2$value <- runif(nrow(df2), 0, 10) > > df <- rbind(df1, df2) > > > > > > (oo) > --oOO--( )--OOo---------------- > Stefano Sofia PhD > Civil Protection - Marche Region > Meteo Section > Snow Section > Via del Colle Ameno 5 > 60126 Torrette di Ancona, Ancona > Uff: 071 806 7743 > E-mail: stefano.so...@regione.marche.it > ---Oo---------oO---------------- > > ________________________________ > > AVVISO IMPORTANTE: Questo messaggio di posta elettronica può contenere > informazioni confidenziali, pertanto è destinato solo a persone autorizzate > alla ricezione. I messaggi di posta elettronica per i client di Regione > Marche possono contenere informazioni confidenziali e con privilegi legali. > Se non si è il destinatario specificato, non leggere, copiare, inoltrare o > archiviare questo messaggio. Se si è ricevuto questo messaggio per errore, > inoltrarlo al mittente ed eliminarlo completamente dal sistema del proprio > computer. Ai sensi dell’art. 6 della DGR n. 1394/2008 si segnala che, in caso > di necessità ed urgenza, la risposta al presente messaggio di posta > elettronica può essere visionata da persone estranee al destinatario. > IMPORTANT NOTICE: This e-mail message is intended to be received only by > persons entitled to receive the confidential information it may contain. > E-mail messages to clients of Regione Marche may contain information that is > confidential and legally privileged. Please do not read, copy, forward, or > store this message unless you are an intended recipient of it. If you have > received this message in error, please forward it to the sender and delete it > completely from your computer system. > > -- > Questo messaggio stato analizzato da Libra ESVA ed risultato non infetto. > This message was scanned by Libra ESVA and is believed to be clean. > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.