Filter Factor Levels in R Using Dplyr
This Is the Glimpse() of My Dataframe Df: Observations: 221184 Variables: $ Epsilon (Fctr) 96002. Txt, 96002. Txt, 96004. Txt, 96004. Txt, 96005. Txt, 960...
This is the glimpse() of my dataframe DF:
Observations: 221184
Variables:
$ Epsilon (fctr) 96002.txt, 96002.txt, 96004.txt, 96004.txt, 96005.txt, 960...
$ Value (int) 61914, 61887, 61680, 61649, 61776, 61800, 61753, 61725, 616...
I want to filter (remove) all the observations with the first two levels of Epsilon using dplyr.
I mean:
DF %>% filter(Epsilon != "96002.txt" & Epsilon != "96004.txt")
However, I don't want to use the string values (i.e., "96002.txt" and "96004.txt") but the level orders (i.e., 1 and 2), because it should be a general instruction independent of the level values.
1 Answer
You can easily convert a factor into an integer and then use conditions on it. Just replace your filter statement with:
filter(as.integer(Epsilon)>2)
More generally, if you have a vector of indices level you want to eliminate, you can try:
#some random levels we don't want
nonWantedLevels<-c(5,6,9,12,13)
#just the filter part
filter(!as.integer(Epsilon) %in% nonWantedLevels)
Sarah Jenkins is a veteran tech journalist with over 12 years of experience covering artificial intelligence, mobile innovations, and digital ethics. Her insights have appeared in leading technology publications worldwide.
