We have to obtain a movie id as input from the user . After obtaining the user input how to fetch all movies from the database which have at least one genre common with user input and have at least one rating identical to that of one of user input's ratings.(using python pandas dataframe).

eg: if A is the movie id obtained from the user and A has genres "Romantic|Comedy" and has fetched ratings "4.5, 3.0, 2.5", all Romantic or Comedy movie that have obtained at least one rating of 4.5 or 3.0 or 2.5 would be output. There are 2 csv files - movies.csv , ratings.csv which have movie_id as the common column.

movies.csv ----> movie_id, movie_name, genre

ratings.csv ----> movie_id, ratings_given

The solution in the above question gives a large number of movies in response to the user input. We have to find a way to use the data from tags.csv to generate a list of tag-based similar smaller sets of the results in the above question to highlight to the user. Generate a python code to identify the tag-based similar subset of similar movies.

tags.csv ----> movie_id, tags,

Ps : we have to use python pandas library