- Assignment 2: Recommend movies. SQL & R
- by Bharani Nittala
- Last updated almost 4 years ago
- Hide Comments (–) Share Hide Toolbars
Twitter Facebook Google+
Or copy & paste this link into an email or IM:
Navigation Menu
Search code, repositories, users, issues, pull requests..., provide feedback.
We read every piece of feedback, and take your input very seriously.
Saved searches
Use saved searches to filter your results more quickly.
To see all available qualifiers, see our documentation .
- Notifications You must be signed in to change notification settings
RSVP IMDB Movies Case Study
SriHarshaRomp/RSVP-Movies-Case-Study
Folders and files.
| Name | Name | |||
|---|---|---|---|---|
| 5 Commits | ||||
Repository files navigation
Rsvp-movies-case-study.
Problem Introduction
RSVP Movies is an Indian film production company which has produced many super-hit movies. They have usually released movies for the Indian audience but for their next project, they are planning to release a movie for the global audience in 2022.
The production company wants to plan their every move analytically based on data and have approached you for help with this new project. You have been provided with the data of the movies that have been released in the past three years. You have to analyse the data set and draw meaningful insights that can help them start their new project.
You are a data analyst and an SQL expert. You have to use SQL to analyse the given data and give recommendations to RSVP Movies based on the insights. For your convenience, the entire analytics process has been divided into four segments, where each segment leads to significant insights from different combinations of tables. The questions in each segment with business objectives are written in the script given below. You have to write the solution code below every question and submit the same SQL script file with the solution in the 'Submission' segment.
About the assignment Where do I get the data from?
You can get detailed information about the dataset and database creation in the next segment.
Where do I write the code?
The SQL script file given above contains all the tasks you need to perform. You are required to write the code for each task/question below the question itself.
How do I submit the assignment?
Once you are done with writing the codes in the question script file, the same script file should be submitted in the 'submission' segment.
Some tips before starting the assignment
Go through the data thoroughly before starting with the assignment. It will give you a good sense of what all the columns represent which is a good practice to follow before proceeding with the analysis. You should download the database script and run it in your local system. Read through each of the instructions carefully, identify the task to be performed, and only then proceed to write the required code. Don’t perform any incorrect analysis or look for information that isn’t required for the assignment. The solution output should be in the expected format if given in the question. Try using appropriate aliases for the variable names. Avoid using names: ABC, abc, etc. Always try to write optimized codes. Use appropriate tables and joins as per the questions asked. There are some checkpoints given in the question SQL script provided. Keep your eye out for them as they're useful pieces of information you can use to check if the result you have obtained after performing a particular task is correct or not.
Submissions Required SQL Script File: The question SQL script file given with the final codes (answers) written in it. This will be your solution file. Executive Summary: Write the executive summary consisting of the important insights derived from the data and some recommendations to be given to RSVP movies for their project. Make sure this summary doesn't exceed 250 words. Save this writeup as a PDF. Put both these files in a zip folder and submit the final zipped file in the 'Submission' segment.
Data Set and Database Creation You were already introduced to the dataset in the optional practice assignment of the Data Modelling module. You might have created the tables and inserted all the values for the entire schema. If you have completed this, you can verify your code and database from the SQL script file given at the bottom of the page.
For those who didn't attempt the optional Data Modelling Assignment, download the dataset given below and follow the given steps to insert all the values for the entire schema.
Note: It is highly recommended to create the SQL database on your local machine using the below dataset. However, note that this part is completely optional and will not carry any grades and if you wish, you can directly run the SQL script given at the end of this segment to load the dataset.
IMDb Dataset Download Steps to follow:
Download the IMDb dataset from above. The first tab contains the ERD and the table details. Study that carefully and understand the relationships between the table. Inspect each table given in the subsequent tabs and understand the features associated with each of them. Open your MySQL Workbench and start writing the DDL and DML commands to create the database.
If you don't wish to perform the data loading part, you can directly download the SQL script file given below containing all the commands and data required for the database creation and start directly with the querying.
IMAGES
COMMENTS
Something went wrong and this page crashed! If the issue persists, it's likely a problem on our side. Unexpected token < in JSON at position 4. keyboard_arrow_up. content_copy. SyntaxError: Unexpected token < in JSON at position 4. Refresh. Explore and run machine learning code with Kaggle Notebooks | Using data from multiple data sources.
RSVP Movies assignment based upon IMDb dataset. Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more. OK, Got it. Something went wrong and this page crashed! If the issue persists, it's likely a problem on our side.
Explore and run machine learning code with Kaggle Notebooks | Using data from RSVP Movies
RSVP-Movies-SQL-Assignment. RSVP Movies is an Indian film production company which has produced many super-hit movies. They have usually released movies for the Indian audience but for their next project, they are planning to release a movie for the global audience in 2022. The production company wants to plan their every move analytically ...
RSVP-Movies-SQL-Assignment. RSVP Movies is an Indian film production company which has produced many super-hit movies. They have usually released movies for the Indian audience but for their next project, they are planning to release a movie for the global audience in 2022. We have been provided with the data of the movies that has been ...
You have been provided with the data of the movies that have been released in the past three years. You must analyze the data set and draw meaningful insights that can help them start their new project. You are a data analyst and an SQL expert. You must use SQL to analyze the given data and give recommendations to RSVP Movies based on the insights.
Domain: Movies Tech Stack: SQLObjective: RSVP Movies plans to produce next movie based on data of highest rated movies released in the past three yearsKey Ac...
Kaggle is the world's largest data science community with powerful tools and resources to help you achieve your data science goals. code. New Notebook. table_chart. New Dataset. tenancy. New Model. emoji_events. New Competition. corporate_fare. New Organization. No Active Events.
The top 5 actresses are 1. Taapsee Pannu, 2. Kriti Sanon, 3. Divya Dutta, 4. Shraddha Kapoor, and 5. Kriti Kharbanda. Q24. Select thriller movies as per avg rating and classify them in the ...
SQL-Data-Analysis-RSVP-Movies. Kaggle Dataset Analysis. RSVP Movies is an Indian film production company which has produced many super-hit movies. They have usually released movies for the Indian audience but for their next project, they are planning to release a movie for the global audience in 2022.
SQL-RSVP MOVIES CASE STUDY EXECUTIVE SUMMARY & RECOMMENDATIONS: Based on the insights listed in the IMDB dataset, we can make the following conclusions: In the 'Drama' genre, a total of 1078 films were released in 2019. As a result, RSVP Movies' next project should be in the 'Drama' genre.
And in order to analyze this structured data we need SQL (Structured query language). SQL is used to extract data from databases that data scientists/ analysts use for data wrangling and ...
RSVP Movies is an Indian film production company which has produced many super-hit movies. They have usually released movies for the Indian audience but for their next project, they are planning to release a movie for the global audience in 2022. You are a data analyst and an SQL expert. You have to use SQL to analyse the given data and give
Analyzing IMDB dataset for RSVP movies case study. Analyzing IMDB dataset for RSVP movies case study. code. New Notebook. table_chart. New Dataset. tenancy. New Model. emoji_events. ... Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more. OK, Got it.
So we tried to find out the top director and the top production house who will going to direct the movie and the top 3 actor. As this movie is released by India so top three Indian Actor and Actress also required. Suggestion to RSVP: 1) James Mangold can be hired as the director for RSVP's next project. 2) Mammootty & Vijay Sethupathi Should ...
However, note that this part is completely optional and will not carry any grades and if you wish, you can directly run the SQL script given at the end of this segment to load the dataset. Steps to follow: Download the IMDb dataset from above. The first tab contains the ERD and the table details. Study that carefully and understand the ...
Assignment 2: Recommend movies. SQL & R; by Bharani Nittala; Last updated almost 4 years ago; Hide Comments (-) Share Hide Toolbars
Something went wrong and this page crashed! If the issue persists, it's likely a problem on our side. Unexpected token < in JSON at position 4. keyboard_arrow_up. content_copy. SyntaxError: Unexpected token < in JSON at position 4. Refresh. 📽📝 RSVP Movies Case Study - MYSQL 📝📽.
Kaggle is the world's largest data science community with powerful tools and resources to help you achieve your data science goals. code. New Notebook. table_chart. New Dataset. tenancy. New Model. emoji_events. New Competition. corporate_fare. New Organization. No Active Events.
RSVP-Movies-Case-Study. RSVP IMDB Movies Case Study. Problem Introduction. RSVP Movies is an Indian film production company which has produced many super-hit movies. They have usually released movies for the Indian audience but for their next project, they are planning to release a movie for the global audience in 2022.