Hello, I am trying to filter a dataframe based on values in certain column. This works fine when I use subset() with ByRow(in([“mytext”])). But I get problems with regular expressions: df = subset(df, :mycol => x -> ByRow(occursin(r"mytext", x) )) ERROR: MethodError: no method matching occursin(:…

Filter dataframe with regular expression

bkamins February 22, 2022, 8:34am 2

subset(df, :mycol => ByRow(x -> occursin(r"mytext", x) ))

should work, or using DataFramesMeta.jl:

@rsubset(df, occursin(r"mytext", :mycol))

5 Likes

Topic		Replies	Views
How would I write this Pandas column filter code in Julia? General Usage	5	1174	February 8, 2020
Function occursin() needs a method that accepts Union{String, Missing} General Usage	12	1861	August 28, 2018
Filtering a DataFrame column using Regex Data dataframes	2	1682	June 4, 2020
Count number of substrings in dataframe column Data	8	2529	February 13, 2018
How to filter out missings (using DataFramesMeta @where) New to Julia dataframes	2	712	July 22, 2019