如何根据列值的一个词过滤数据? [英] How to filter data based on one word of a column value?

问题描述

我有一个简化的数据框，看起来像这样只有 2k 行.我想知道是否有办法通过 LocationID 列中的值提取数据或过滤数据.我想提取其中包含Creek"或River"一词的行，而这些行会忽略其他名称(例如 Banana Forest 值).

I have a dataframe that simplified looks like this only it has 2k rows. I'm wondering if there's a way to either extract data or filter data by the values in the LocationID column. I would like to extract rows that have the word "Creek" or "River" in them which would leave out the other names (such as the Banana Forest value).

 LocationID, Code
 Alk River, 232
 Bala River, 4324
 Banana Forest, 344
 Cake River, 432
 Alk Creek, 6767
 Cake Creek, 766

谢谢！

推荐答案

我们可以用 tidyverse

library(dplyr)
library(stringr)
df1 %>% 
    filter(str_detect(LocationID, '\b(River|Creek)\b'))
#   LocationID Code
#1  Alk River  232
#2 Bala River 4324
#3 Cake River  432
#4  Alk Creek 6767
#5 Cake Creek  766

这篇关于如何根据列值的一个词过滤数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！