Displaying 3 results from an estimated 3 matches for "7cbf182d25cae845ec841c08d4ea3a7139".
2017 Aug 23
2
Comparing 2 dale columns
...ersion deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstat.ethz.ch%2Fmailman%2Flistinfo%2Fr-help&data=02%7C01%7Cpatrcasi%40nova.edu%7Cbf182d25cae845ec841c08d4ea3a7139%7C2c2b2d312e3e4df1b571fb37c042ff1b%7C0%7C0%7C636390984126927971&sdata=Tait17GF8fuEBwFnDZHCgnc7v88yXqAxpTX7W76O1cA%3D&reserved=0
> PLEASE do read the posting guide https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.R-project.org%2Fposting-guide.html&data=02%7C01%7Cpat...
2017 Aug 23
0
Comparing 2 dale columns
Hi
your code is wrong.
I get
> test<-read.table("clipboard", header=T)
> str(test)
'data.frame': 2 obs. of 2 variables:
$ COL1: Factor w/ 2 levels "6/1/14","7/1/14": 1 2
$ COL2: Factor w/ 1 level "5/1/15": 1 1
> test$COL2<- as.Date(as.character(test$COL2, format="%y/%m/%d"))
> test$COL1<-
2017 Aug 23
2
Comparing 2 dale columns
Dear R fellows,
I created a new column Date_flag to compare the dates of COL1 and COL2 using the code
below. But it showed that 5/1/15 is greater than 6/1/2014 and 5/1/2015 greater than
7/1/2014 despite the year is greater. How do I fix that? I did try to format as %y/%m/%d
but it does not fix that.
data$Date_Flag <- ifelse(data$COL2 > data$COL1, 0,1)
COL1 COL2
6/1/14