Assignment Question:

Choose six recent popular movies. Ask at least five people that you know (friends, family, classmates, imaginary friends) to rate each of these movie that they have seen on a scale of 1 to 5. Take the results (observations) and store them in a SQL database. Load the information into an R dataframe.

Movie Ratings

## [1] "The 2 tables in movies MySQL database ( movies and ratings ) are inner joined and sorted in descending order by the rating value column."

Chosen Movie List

Table

movie_id movie_title rating_value rating_owner
3 Dunkirk 5.0 Hovig
1 Wormwood 5.0 Raffi
5 Columbus 4.5 Hagop
6 Her 4.5 Garo
3 Dunkirk 4.5 Natalie
1 Wormwood 3.5 John
5 Columbus 3.5 Kevo
4 Marjorie Prime 3.0 Ghazo
6 Her 3.0 Ani
4 Marjorie Prime 3.0 Margo
2 Lady Macbeth 2.0 Caroline
2 Lady Macbeth 1.0 Daron

Analysis

Summarise the db table
movie_id movie_title rating_value rating_owner
Min. :1.0 Length:12 Min. :1.000 Length:12
1st Qu.:2.0 Class :character 1st Qu.:3.000 Class :character
Median :3.5 Mode :character Median :3.500 Mode :character
Mean :3.5 NA Mean :3.542 NA
3rd Qu.:5.0 NA 3rd Qu.:4.500 NA
Max. :6.0 NA Max. :5.000 NA
Split duplicates with their ratings
Rating_1of2 Movies_1of2 Rating_2of2 Movies_2of2
5.0 Dunkirk 4.5 Dunkirk
5.0 Wormwood 3.5 Wormwood
4.5 Columbus 3.5 Columbus
4.5 Her 3.0 Her
3.0 Marjorie Prime 3.0 Marjorie Prime
2.0 Lady Macbeth 1.0 Lady Macbeth
Add ratings of duplicates to list high and low rated movies
Highest_rated_movie Lowest_rated_movie
Dunkirk Lady Macbeth

Plot the db table