How to get filter based data rows from Genre column coming from another dataframe?

I have dataframe movies as follows:

I have dataframe user as follows:

Output that i want like this :

Because user like horror, thriller, and drama genres. How to make the code to get the output like above?

CodePudding user response：

try this:

pattern = user['Genre'].str.replace(', ', '|')[0]
result = movies.query('Genre.str.contains(@pattern)')
print(result)

CodePudding user response：

The example use a for loop to get a list for each user on df2

import pandas as pd
df=pd.read_csv("db1.csv",header=[0]) # movies
df2=pd.read_csv("db2.csv",header=[0]) # users

for ir,row in df2.iterrows():
    gen=row["Genre"].replace(",","|").replace(" ","")
    filtereddf=print(df[df["Genre"].str.contains(gen)])