I have a data frame with the following columns:
Date Price Buy Sell
The Buy and Sell variables are binary. They are either zero or 1.
Additionally, they are mutually exclusive. Either Buy is 1, Sell is 1 or
they are both 0. But they are never both 1 for a given observation.
I want to see observations for either either Buy == 1 or Sell ==1 (but not
the ones where Buy == 0 and Sell ==0). How can I do this WITHOUT explicitly
looping using a for loop.
The options I have tried so far are:
my.data.frame[my.data.frame$Buy==1 || my.data.frame$Sell ==1, ]
This just prints the column headers with no observation:
[1] Date Price Buy Sell
<0 rows> (or 0-length row.names)
I also tried passing argument as a vector
my.data.frame[c(my.data.frame$Buy==1, my.data.frame$Sell ==1),]
Interestingly enough, this returns all the rows where $Buy ==1. And then it
returns a bunch of rows with NAs:
NA <NA> NA NA NA
NA.1 <NA> NA NA NA
NA.2 <NA> NA NA NA
NA.3 <NA> NA NA NA
NA.4 <NA> NA NA NA
NA.5 <NA> NA NA NA
NA.6 <NA> NA NA NA
NA.7 <NA> NA NA NA
NA.8 <NA> NA NA NA
Any help on how I can make this happen?
[[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.
