How do I search for specific text in a string using python

Question

I am using this dataset to try and make a dynamic bubble graph but I came across an issue. When I search for the genre eg Western it searches for exactly that string. The problem is that 'dataset_by_year["genre"]' holds genres with multiple genres (e.g. western, comedy, action), which is not matched.

for genre in genres:
    dataset_by_year = BubbleGV[BubbleGV["year"] == year1]
    dataset_by_year_and_cont = dataset_by_year[
        dataset_by_year["genre"] == genre]

All I want to do is to search for the genre within the multiple genres and match the string.

Any help would be greatly appreciated.

So how exactly are those stored? Is it a list of strings, a string containing comma-separated values, or something else? — tripleee
– tripleee, Commented Nov 1, 2020 at 12:12

vvvvv · Accepted Answer · 2020-11-01 14:16:56Z

1

Sorry didn't check with your full data try this, it might work:

dataset_by_year_and_cont = dataset_by_year[dataset_by_year["genre"].str.contains(genre)]

edited Nov 1, 2020 at 14:16

vvvvv

32.9k19 gold badges70 silver badges103 bronze badges

answered Nov 1, 2020 at 12:09

sordnay

1312 bronze badges

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

Collectives™ on Stack Overflow

How do I search for specific text in a string using python

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