Return rows that match a larger partial string of a string

Question

I have a dataframe df that looks like the following:

Type      Size
Biomass   12
Coal      15
Nuclear   23

And I have a string str such as the following: Biomass_wood I would like to return the following dataframe:

Type      Size
Biomass   12

This is because Biomass is partially matched by the first part of Biomass_wood.

This would effectively be the opposite of df[df.Type.str.contains(str)] as the bigger string is contained in str and not in the column Type

score 1 · Accepted Answer · answered Dec 12 '18 at 14:31

1

The following should do

df[df['Type'].map(lambda t: t in 'Biomass_wood')]

answered Dec 12 '18 at 14:31

ayorgo

This is a bad answer to an obvious duplicate question. – cs95 Dec 12 '18 at 14:32
Are you sure it's a duplicate? The OP clearly states that `df[df.Type.str.contains(str)]` is the opposite of what they need. – ayorgo Dec 12 '18 at 14:33
Oh, right... so maybe not a duplicate of that, but I've definitely seen this before. – cs95 Dec 12 '18 at 14:36
Thank you ayorgo, this worked well. – AKE Dec 12 '18 at 19:14

1 Answers1