Extracting data and saving in excel
Hello,
First coerce the column birth to class Date, then subset.
data$birth <- as.Date(data$birth)
i <- data$birth > as.Date("1979-01-01")
subdata <- data[i, ]
To write back to Excel, use write.csv or a package able to write Excel
files directly.
Hope this helps,
Rui Barradas
?s 12:23 de 23/10/20, bgnumis bgnum escreveu:
Hi all, I have a dataframe call "data", and have lots of rows. One of them is data$`birth` my data has been imported from an excel file in RSTUDIO I want to obtain in a function all rows (with the names) where data$`birth` is bigger than 1979/01/01 and extract in a excel file as an output (a sub-excel of the original). Can you guide with the functions I need to use? I have been many time out of programming and I need a bit of help to get in fit. [[alternative HTML version deleted]]
______________________________________________ R-help at 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.