0
Is it possible to index the data using two variables (while using indexing and splicing data tool)?

I was working on the assignment given in the indexing and splincing data tutorial and wanted to do the following:

  1. captaincy[c("names","played","lost")]
  2. subData <- subset(captaincy, played>20, select = c("names","played","lost"))
  3. print(subData)
  4. subData2 <- subset(captaincy, lost<14, select = c("names","played","lost"))
  5. print(subData2)
  6. subData3 <- subset(captaincy, played>20, lost<14, select = c("names","played","lost"))
  7. print(subData3)

It worked for point number 1-5 but I got an error when I tried points 6 and 7. The results are as follows:

> subData2 <- subset(captaincy, lost<14, select = c("names","played","lost"))
> print(subData2)
names played lost
1 Mahi 45 12
2 Sourav 49 13
4 Sunny 47 8
6 Dravid 25 6
> subData3 <- subset(captaincy, played>20, lost<14, select = c("names","played","lost"))
Error in `[.data.frame`(x, r, vars, drop = drop) :
object 'lost' not found

Kindly guide.


R 09-11-19, 3:34 p.m. MandarKulkarni
0

Thanks for trying the assignment. Please rewrite the line 6 of your code as given below:

subData3 <- subset(captaincy, played>20 & lost < 14, select = c("names","played","lost"))

Please note that we have added one & between the conditionsplayed>20 andlost < 14.

11-11-19, 12:19 a.m. SudhakarK

Login to add comment

Log-in to answer to this question.