如何根据一个列值的一个单词过滤数据?

问题描述

我有一个简化的数据框，看起来只有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

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