remove rows by reference to column values in data.table r

Question

I have a data.table with 47 variables looking at 5007 PhD student outcomes that looks something like this

sample<-data.table(PHD_STUDENT_ID=c(101:120),STUDY_LOCATION=c("Sydney","Canberra","Sydney","Sydney", 
    "Malaysia", "Malaysia", "CLF", "DRR", "GHS", "HMS", "DRJD", "KLS", "Malaysia",
    "Singapore", "Melbourne", "RD3S", "South Africa", "RME", "Sydney", "Canberra"),
    GRADE=c(51:70))

So the data.table looks something like this

PHD_STUDENT_ID      STUDY_LOCATION  GRADE
1   101             Sydney          51 
2   102             Canberra        52
3   103             Sydney          53
4   104             Sydney          54
5   105             Malaysia        55
6   106             Malaysia        56
7   107             CLF             57
8   108             DRR             58
.........

I need to retain all the rows except for the rows where the Study location is "Malaysia", "South Africa" or "Singapore". So basically all the values that are not at the Campuses in those countries. I have hundreds of unique values where the study location is just a code for a lab eg "CLF" and "DRR" which I want to retain so I can't just subset by Australia cities.

Any advice on how to subset this data table by reference to the values in STUDY_LOCATION are not "Malaysia", "South Africa" or "Singapore" would be greatly appreciated.

KFB · Accepted Answer · 2014-12-07 09:32:25Z

3

I assume you're learning data.table. Thus a data.table way is

setkey(sample, STUDY_LOCATION)
sample[!c('Malaysia', 'South Africa', 'Singapore')]

answered Dec 7, 2014 at 9:32

KFB

3,5013 gold badges17 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Arun Over a year ago

Since 1.9.4, data.table uses secondary keys for automatically indexing columns to fast subset using binary search. This is a new feature. and currently implemented for DT[x == ...] and DT[X %in% ...].

akrun · Accepted Answer · 2014-12-07 03:40:10Z

3

You could try

   sample[!STUDY_LOCATION %in% c('Malaysia', 'South Africa', 'Singapore')]

answered Dec 7, 2014 at 3:40

akrun

891k38 gold badges590 silver badges700 bronze badges

Collectives™ on Stack Overflow

remove rows by reference to column values in data.table r

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related