Hi,
I hope this isn't a really simple question, I've been struggling with it
for a while.
I'm looking for a way to get a function to go through a data frame line by
line, compare fields, and produce a result, kind of a transform and an if
statement combined (I tried to put them together and it didn't work).
So, consider data Sales:
House number Inspected Sold
1 9/2/2011 10/10/2011
2 9/4/2011 10/20/2011
3 10/31/2011 8/28/2011
4 8/3/2011 11/1/2011
I want to find all the records which were inspected after they were sold.
Ideally, this code would create a fourth field that would be a logical.
I tried
Sales<-transform(Sales, Checked=if(Sales$Inspected <= Sales$Sold) "OK")
But that busted. I've bent over backward to make these kinds of comparisons
work, but there has to be a better way. Any help would be most welcome.
Thanks,
Eric
[[alternative HTML version deleted]]
______________________________________________
R-help@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.
