Filter pandas dataframe with SequenceMatcher

Question

When I filter the data frame using the the code below, it works fine

my_df.loc[lambda x:x["name"]=="space"]

When I filter using the following code, it gives an error

my_df.loc[lambda x: difflib.SequenceMatcher(None,"email",x["name"]).ratio()>0.8]

I want to filter using SequenceMatcher and maybe using more complex condition than the above one

Here is the full code:

import pandas as pd
import difflib
my_df=pd.DataFrame({"name":["space","mapp","eemail","daata"],"id":[9,12,13,14]})
my_df.loc[lambda x:x["name"]=="space"] #this line works
my_df.loc[lambda x: difflib.SequenceMatcher(None,"email",x["name"]).ratio()>0.8] #this doesn't

gyx-hh · Accepted Answer · 2018-07-09 15:38:33Z

2

Try the following:

my_df.loc[my_df['name'].apply(lambda x: difflib.SequenceMatcher(None,"email",x).ratio()) > 0.8]

Output:

    id  name
2   13  eemail

answered Jul 9, 2018 at 15:38

gyx-hh

1,4411 gold badge12 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Filter pandas dataframe with SequenceMatcher

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related