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.
Your deliverables should include your SQL scripts and your R Markdown code, posted to GitHub.
This is by design a very open ended assignment. A variety of reasonable approaches are acceptable. You can (and should) blank out your SQL password if your solution requires it; otherwise, full credit requires that your code is “reproducible,” with the assumption that I have the same database server and R software.
#install.packages("RMySQL")
#install.packages("dbConnect")
library(RMySQL)## Loading required package: DBIlibrary(dbConnect)## Loading required package: gWidgetscon=dbConnect(MySQL(),user='root', password='password',dbname='movie_rate',host='127.0.0.1')
dbListTables(con)## [1] "movie_rate"myQuery<-"select * from movie_rate;"
df<-dbGetQuery(con,myQuery)
show(df)## Movie Rate Genre Sex Age
## 1 War for the Planet of the Apes 3 action f 38
## 2 War for the Planet of the Apes 2 action m 33
## 3 War for the Planet of the Apes 5 action m 28
## 4 War for the Planet of the Apes 3 action m 34
## 5 War for the Planet of the Apes 1 action f 27
## 6 War for the Planet of the Apes 4 action m 38
## 7 War for the Planet of the Apes 3 action f 33
## 8 War for the Planet of the Apes 4 action m 41
## 9 Wonder Woman 5 action f 38
## 10 Wonder Woman 3 action m 33
## 11 Wonder Woman 4 action m 28
## 12 Wonder Woman 5 action m 34
## 13 Wonder Woman 4 action f 27
## 14 Wonder Woman 5 action m 38
## 15 Wonder Woman 5 action f 33
## 16 Wonder Woman 3 action m 41
## 17 Spider-Man: Homecoming 4 action f 38
## 18 Spider-Man: Homecoming 3 action m 33
## 19 Spider-Man: Homecoming 4 action m 28
## 20 Spider-Man: Homecoming 5 action m 34
## 21 Spider-Man: Homecoming 4 action f 27
## 22 Spider-Man: Homecoming 4 action m 38
## 23 Spider-Man: Homecoming 3 action f 33
## 24 Spider-Man: Homecoming 3 action f 41
## 25 Beauty and the Beast 4 romantic f 38
## 26 Beauty and the Beast 1 romantic m 33
## 27 Beauty and the Beast 5 romantic m 28
## 28 Beauty and the Beast 4 romantic m 34
## 29 Beauty and the Beast 3 romantic f 27
## 30 Beauty and the Beast 3 romantic m 38
## 31 Beauty and the Beast 2 romantic m 41
## 32 Alien: Covenant 3 horror f 38
## 33 Alien: Covenant 3 horror m 33
## 34 Alien: Covenant 2 horror m 28
## 35 Alien: Covenant 2 horror m 34
## 36 Alien: Covenant 1 horror f 27
## 37 Alien: Covenant 3 horror m 38
## 38 Alien: Covenant 2 horror f 33
## 39 Alien: Covenant 4 horror m 41
## 40 John Wick: Chapter 2 3 action f 38
## 41 John Wick: Chapter 2 1 action m 33
## 42 John Wick: Chapter 2 5 action m 28
## 43 John Wick: Chapter 2 5 action m 34
## 44 John Wick: Chapter 2 4 action f 27
## 45 John Wick: Chapter 2 4 action m 38
## 46 John Wick: Chapter 2 4 action m 41
## 47 Pirates of the Caribbean: Dead Men Tell No Tales 3 action f 38
## 48 Pirates of the Caribbean: Dead Men Tell No Tales 3 action m 33
## 49 Pirates of the Caribbean: Dead Men Tell No Tales 3 action m 28
## 50 Pirates of the Caribbean: Dead Men Tell No Tales 3 action m 34
## 51 Pirates of the Caribbean: Dead Men Tell No Tales 3 action f 27
## 52 Pirates of the Caribbean: Dead Men Tell No Tales 2 action m 38
## 53 Pirates of the Caribbean: Dead Men Tell No Tales 3 action f 33
## 54 Pirates of the Caribbean: Dead Men Tell No Tales 3 action m 41
## FamilySize
## 1 2
## 2 2
## 3 3
## 4 1
## 5 1
## 6 3
## 7 3
## 8 4
## 9 2
## 10 2
## 11 3
## 12 1
## 13 1
## 14 3
## 15 3
## 16 4
## 17 2
## 18 2
## 19 3
## 20 1
## 21 1
## 22 3
## 23 3
## 24 4
## 25 2
## 26 2
## 27 3
## 28 1
## 29 1
## 30 3
## 31 4
## 32 2
## 33 2
## 34 3
## 35 1
## 36 1
## 37 3
## 38 3
## 39 4
## 40 2
## 41 2
## 42 3
## 43 1
## 44 1
## 45 3
## 46 4
## 47 2
## 48 2
## 49 3
## 50 1
## 51 1
## 52 3
## 53 3
## 54 4