Wednesday, August 6, 2014

Delete a list of elements from data frame in R

This might be an easy question but i still need some help for using R.
I have a data.frame (main_data), lets say..

NAMES   AGE     LOC
Jyo     23      Hyd
Abid    27      Kar
Ras     24      Pun
Poo     25      Goa
Sus     28      Kar
 
I wish to remove a few rows based on a list of names. So lets say I have another list of table as follows:

NAMES_list
Jyo
Ras
Poo
 
So based on this list, if any of the names match to my above "main_data" table, then I would like to remove the whole row contianing them, so the result should be as follows

NAMES   AGE     LOC
Abid    27      Kar
Sus     28      Kar
 
Solution:

Use %in%:

main_data2 <- main_data[ ! main_data$NAMES %in% NAMES_list, ]




No comments:

Post a Comment