Filter column by list of accepted valuesΒΆ
Example cut down mtcars to two named cars.
R:
mtcars = as.tibble(mtcars)
mtcars = rownames_to_column(mtcars)
mtcars %>% filter(rowname %in% c("Fiat 128", "Lotus Europa"))
pandas:
mtcars[mtcars.name.isin(["Fiat 128", "Lotus Europa"]]
plydata:
mtcars >> dp.query('name.isin(["Fiat 128", "Lotus Europa"])')
dplython:
dp.DplyFrame(mtcars) >> dp.arrange(X.cyl) >> dp.sift(X.name.isin(['Lotus Europa', 'Fiat 128']))
dfply:
mtcars >> dp.arrange(X.cyl) >>dp.filter_by(X.name.isin(['Lotus Europa', 'Fiat 128']))
pandas_ply:
mtcars.ply_where(X.name.isin(['Lotus Europa', 'Fiat 128']))
dppd:
dp(mtcars).arrange('cyl').filter_by(X.name.isin(['Lotus Europa', 'Fiat 128'])).pd