Filter dataframe in python using pandas based on partial string match

Question

My Input Dataframe is:

list_of_dicts1 = {"Filter":["abc",'def']}

test1 = pd.DataFrame(list_of_dicts1)

list_of_dicts2 = {"C":["a",'z']}

test2 = pd.DataFrame(list_of_dicts2)

Output Desired is

list_of_dicts3 = {"Filter":['abc']}

test3 = pd.DataFrame(list_of_dicts3)

How can I filter dataframe test1 based on "C" column of test2 dataframe using pandas

jezrael · Accepted Answer · 2020-12-07 11:06:46Z

1

Use Series.str.contains with join by | for regex or:

df = test1[test1['Filter'].str.contains('|'.join(test2['C']))]
print (df)
  Filter
0    abc

answered Dec 7, 2020 at 11:06

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Filter dataframe in python using pandas based on partial string match

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