[R] compare different data-formats

arun smartpink111 at yahoo.com
Fri Sep 14 14:46:32 CEST 2012


HI,
Try this:
vec1<-c("14.Aug.2012-16:32","3.Sep.2012-16:50")
vec2<-c(c("2012.08.14", "2012.09.3"))
vec1DateF<-as.Date(vec1,format="%d.%b.%Y-%H:%M")
vec2DateF<-as.Date(vec2,format="%Y.%m.%d")
 ifelse(difftime(vec1DateF,vec2DateF)==0,TRUE,FALSE)
#[1] TRUE TRUE
A.K.




----- Original Message -----
From: Martin Batholdy <batholdy at googlemail.com>
To: "r-help at r-project.org" <r-help at r-project.org>
Cc: 
Sent: Friday, September 14, 2012 5:44 AM
Subject: [R] compare different data-formats

Hi,

I have two data-frames which I want to match by a date-variable.

The problem now is, that the date-variable has a different format in this two data-frames.
So simply matching by this variable wouldn't work.

In the one data-frame the date-variable contains strings that look like this:

14.Aug.2012-16:32
3.Sep.2012-16:50

etc.

in the other data-frame the date-variable looks like this:

2012.08.14
2012.09.3


is there an easy way to compare these two vectors?
Or is there an easy way to transform

14.Aug.2012-16:32 
into
2012.08.14 ?


thanks!
______________________________________________
R-help at r-project.org mailing list
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.





More information about the R-help mailing list