Python project

1. (100 points) Write a python program that fetches movie reviews from 3 major websites: IMDB, Metacritics, and Rotten Tomatoes. On these websites, there is an option to show the top movies. On IMDB, it is called “Top rated movies” On Rotten Tomatoes, it is called “BEST MOVIES OF ALL TIME” On Metacritics, it is called “Movies of All Time” You will first write python script that collect the movie reviews for the top 50 movies from each website and store them in a comma separated file (called [your name][login to view URL]). In addition to the csv file, the data should also be stored in a SQLite database called MovieReviewDatabase in the directory that your Jupyter Notebook code will be executed from. The MovieReviewDatabase should have a table called MovieReviewTable. Next, analyze the data you have collected, remove all punctuations and lower all cases to avoid counting the same word multiple times. There are 2 tasks you need to complete: 1. Compare the review style across the 3 websites. After removing stop words (e.g. a, the, of, and, etc.), find out what are the top 50 most frequent keyword that is used in each of the websites. Using simple word embedding technique, your program should also show the similarity score between the keywords used in these 3 websites. (An example is given below) 2. Compare the top 50 movies that are considered top rated across the 3 websites. Construct a dictionary that uses the movie name as the key, and their genre information as the value. For example: dictionary = {Black panther: [Adventure, Action, Fantasy], Casablanca:[Drama]} Use similar technique like word embedding, your program should show the similarity score between the genres of movies ranked as top 50 across these 3 websites. (An example is given below). Combine your finding with those in point 1, write a short report to make inference on the audience demography their preferences on these 3 websites