r - Using regex and subset to extract a subset of a data frame -
i have 1 column inside dataframe contains different kinds of text within it, example follows:
column                 column b               column c kuala lumpur 2 new        7                      old jakarta 3             6                      c 7 hong kong               3                      jakarta new 22            2                      b   my goal extract rows of dataframe corresponding word 'jakarta' somewhere in aforementioned column. imagine regex capable of finding word, not sure how 1 combine extract info via subset. note sheet large, prefer use command subset rather loop if possible. desired output be:
column                 column b               column c old jakarta 3             6                      c jakarta new 22            2                      b   many in advance help
you grepl
data
df <- data.frame(columna=c("kuala lumpur 2 new", "old jakarta 3", "7 hong kong", "jakarta new 22"),              columnb=c(7, 6, 3, 2), columnc=c("a", "c", "a", "b"))   code
df[grepl("jakarta ", df$columna), ]      
Comments
Post a Comment