first question here so apologies if there are any mistakes or unclear points!
I am trying to develop a sort of search engine to look through some tabular data in a pandas dataframe, but am getting partial matches included in the search.
For example, I have a table with the following values:
style
release_id
7306 House, Deep House
37759 House, Tech House
38319 House, Techno
39202 House
And I want to highlight the columns where the style only matches my input eg: 'House' with the code:
df_search_2 = df_search[(df_search['style'].str.match('House'))]
however this also returns all the other rows where the style contains the word House:
style
release_id
7306 House, Deep House
37759 House, Tech House
39202 House
Furthermore, when I try to run a search with multiple tags eg: 'House, Deep House', I end up with an empty dataframe, even if the string is in fact contained in a row.
any help on the matter would be greatly appreciated.