r - Subset data.frame based on a column that matches a separate vector -
this question has answer here:
- filtering data.frame 5 answers
 
once again stumped here.
i have data.frame of 4 columns:
col1      col2      col3      col4 1         1.lsm     0.43      0.34 2         1.lsm     0.47      0.30 3         1.lsm     0.27      0.85 1         2.lsm     0.35      0.55 2         2.lsm     0.71      0.46 3         2.lsm     0.53      0.37 4         2.lsm     0.63      0.34   col1 cell number cells have been tracked on time.
i have vector containing integers pertaining cells want keep:
keep=c(3, 4)   now, want use vector "keep" decide rows of data.frame kept , output new data.frame columns keep relevant rows.
i.e. ideal output here be:
col1      col2      col3      col4 3         1.lsm     0.27      0.85 3         2.lsm     0.53      0.37 4         2.lsm     0.63      0.34      
you can try
 df[df$col1 %in% keep, ]  #   col1  col2 col3 col4  # 3    3 1.lsm 0.27 0.85  # 6    3 2.lsm 0.53 0.37  # 7    4 2.lsm 0.63 0.34      
Comments
Post a Comment