R help - Oct 2020 - Extracting data and saving in excel

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]]

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.
>