using DataFrames, DataFramesMeta x = ["a", "b", "c", "a", "c", "d"] df = DataFrame(x=x, y = 1:length(x)) z = ["a", "c"] How do I query the items in z in df using DataFramesMeta? @where(df, in(z, :x)) didn’t work. It’s a similar to @where how to select mulit-rows. · Issue #77 · JuliaData/DataFrame…

How to select multiple items using DataFramesMeta?

kdyrhage October 12, 2018, 1:57pm 2

@where(df, map(c -> c in z, :x))
# or
@where(df, in.(:x, Ref{Array}(z)))

1 Like

Topic		Replies	Views
How to use `in` with @where [DataFramesMeta]? Data question	6	2012	December 3, 2020
DataFrames: obtaining the subset of rows by a set of values New to Julia dataframes	45	23705	April 27, 2024
Using . on a function where one of the parameters should not be iterated New to Julia	2	176	August 2, 2023
DataFramesMeta selecting multiple columns New to Julia question	5	1506	October 18, 2018
DataFramesMeta conditionals General Usage	8	857	March 29, 2018