python怎么用pandas查找指定字符串,从python pandas的dataframe列中搜索匹配的字符串模式...

i have a data-frame like below

name genre

satya |ACTION|DRAMA|IC|

satya |COMEDY|BIOPIC|SOCIAL|

abc |CLASSICAL|

xyz |ROMANCE|ACTION|DARMA|

def |DISCOVERY|SPORT|COMEDY|IC|

ghj |IC|

Now I want to query the dataframe so that i can get row 1,5 and 6.i:e i want to find |IC| with alone or with any combination of other genres.

Upto now i am able to do either a exact search using

df[df['genre'] == '|ACTION|DRAMA|IC|'] ######exact value yields row 1

or a string contains search by

df[df['genre'].str.contains('IC')] ####yields row 1,2,3,5,6

# as BIOPIC has IC in that same for CLASSICAL also

But i don't want these two.

#df[df['genre'].str.contains('|IC|')] #### row 6

# This also not satisfying my need as i am missing r