Home / Questions / 485614
Accepted
kev
Asked: 2022-09-22 09:02:54 +0800 CST 2022-09-22 09:02:54 +0800 CST

How to filter a Data Frame by a vector of numbers?

  • 772

I have a data frame with 4 variables, month, year, code and rainfall. I need to get the data frame according to the code variable that are not equal to the following values.

vector = c(87553, 87568, 87569, 87570, 87571, 87572, 87573, 87574, 87576, 87582, 87593, 87596)

The data frame is

enter image description here

I tried to make df.mensual <- df.mensual %>% filter(codigo != vector)

But I got the following error In codigo != vector : longer object length is not a multiple of shorter object length

r

1 Answers

  1. Best Answer

    The == or != operator works only for unique values ​​and in your case you are trying to filter a vector, the solution is to use the %in%

    df.mensual <- df.mensual %>% filter(!codigo %in% vector)

    We add the ! (negation) to indicate that it filters the values ​​that are not contained in the vector

    • 1