Hello, Another thing to consider is to use Variable1 = NA, not '=='. With '==' it will probably return TRUE/FALSE/NA.
Hope this helps, Rui Barradas Citando Ivan Calandra <ivan.calan...@univ-reims.fr>: > This might not be the whole story, but part of the problem is that > you want to select a _*character string*_ greater/smaller than > another. That doesn't make much sense! > > I am not sure how to best compare two dates, but if you convert the > Date values into numeric, then that would work. The problem is that > it seems your Date values are character, and the comparison in your > ifelse is also a character. > > So something like this might work (untested because no reproducible example): > transform(Df1, ifelse(as.numeric(Date) > numeric.value1 && > as.numeric(Date) < numeric.value2, Variable1 ==NA, Variable1)) > > HTH, > Ivan > > -- > Ivan Calandra, PhD > Scientific Mediator > University of Reims Champagne-Ardenne > GEGENAA - EA 3795 > CREA - 2 esplanade Roland Garros > 51100 Reims, France > +33(0)3 26 77 36 89 > ivan.calan...@univ-reims.fr > -- > https://www.researchgate.net/profile/Ivan_Calandra > https://publons.com/author/705639/ > > Le 21/07/2016 à 03:00, Bhaskar Mitra a écrit : >> Hello Everyone, >> >> I am trying to replace the values in the 2nd column (Variable 1) >> corresponding to certain dates (Date) >> >> with NAs as shown below. Both Date and Variable1 are numeric vectors . I am >> trying to use the transform function >> >> as shown below but it doesn’t seem to work even though if I am not getting >> any error >> >> Any suggestions/help in this regard? >> >> regards, >> >> --------------------------------------------------------------------------------------------------------------------------------------------------------- >> >> Df1 <- data.frame(Date, Variable1) >> >> a1 <- transform(Df1, ifelse(Date > "010301000300 " && Date < >> "010501000300", Variable1 ==NA, Variable1)) >> >> Original Data frame >> >> Date Variable1 >> >> 010101000300 1 >> >> 010201000300 2 >> >> 010301000300 3 >> >> 010401000300 4 >> >> 010501000300 5 >> >> 010601000300 6 >> >> 010701000300 7 >> >> . >> >> . >> >> . >> >> ………. >> >> Transformed data frame (i hope to transform) >> >> Date Variable1 >> >> 010101000300 1 >> >> 010201000300 2 >> >> 010301000300 NA >> >> 010401000300 NA >> >> 010501000300 NA >> >> 010601000300 6 >> >> 010701000300 7 >> >> ………. >> >> [[alternative HTML version deleted]] >> >> ______________________________________________ >> 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. > > ______________________________________________ > 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.htmland provide commented, > minimal, self-contained, reproducible code. [[alternative HTML version deleted]] ______________________________________________ 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.
