Re: [R] data load from excel files

2019-11-13 Thread Rui Barradas
Hello, Try which.max? Hope this helps, Rui Barradas Às 14:10 de 13/11/19, ani jaya escreveu: Thank you very much Mr. Rui, but for delete the duplicated row I use: ... library(tidyverse) alldata<-data.frame(Reduce(rbind, pon1)) c<-(which(duplicated(alldata$Tanggal))) #duplicate alldata<-allda

Re: [R] data load from excel files

2019-11-13 Thread ani jaya
Thank you very much Mr. Rui, but for delete the duplicated row I use: ... library(tidyverse) alldata<-data.frame(Reduce(rbind, pon1)) c<-(which(duplicated(alldata$Tanggal))) #duplicate alldata<-alldata[-c,] attach(alldata) because not every last row from every df is bad one. Another problem

Re: [R] data load from excel files

2019-11-13 Thread Rui Barradas
Hello, Maybe the following will get you close to what you want. # remove the last row from every df pon1 <- lapply(pon1, function(DF){ DF[[1]] <- as.Date(DF[["Tanggal"]], "%d-%m-%Y") DF[-nrow(DF), ] }) # order the list by year-month inx_ym <- sapply(pon1, function(DF){ format(DF[["Tangg

[R] data load from excel files

2019-11-12 Thread ani jaya
Dear R-Help, I have 30 of year-based excel files and each file contain month sheets. I have some problem here. My data is daily rainfall but there is extra 1 day (first date of next month) for several sheets. My main goal is to get the minimum value for every month. First, how to extract those da