On 26/03/2015 21:11, Simon Kiss wrote:
Hi there: normally I’m quite comfortable with as.Date(). But this data set is
causing problems.
The core of the data frame looks like the sample data frame below, but my
attempt to convert df$mydate to a date object returns only NA. Can anyone
provide a suggestion?
Thank you, Simon Kiss
#sample data frame
df<-data.frame(mydate=factor(c('Jan-15', 'Feb-13', 'Mar-11', 'Jul-12')),
other=rnorm(4, 3))
#Attempt to convert
as.Date(as.character(df$mydate), format='%b-%y')
You would be on surer ground with something like
as.Date(paste0('01-',as.character(df$mydate)), format='%d-%b-%y')
since it is unclear what dates you expected to get.
--
Brian D. Ripley, rip...@stats.ox.ac.uk
Emeritus Professor of Applied Statistics, University of Oxford
1 South Parks Road, Oxford OX1 3TG, UK
______________________________________________
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.