MovieLens Dataset for SQL Project

Summary

This project utilizes the MovieLens (ml-32m) dataset, which comprises over 32 million ratings and 2 million tag applications across 87,585 movies. The data was generated by 200,948 users between January 9, 1995, and October 12, 2023, and made publicly available on October 13, 2023. The dataset includes the following files:

• links.csv
• movies.csv
• ratings.csv
• tags.csv

Dataset Overview

• Ratings: 32,000,204 ratings on a 5-star scale (with half-star increments).
• Tags: 2,000,072 user-generated tags.
• Users: All included users have rated at least 20 movies; no demographic data is provided. For further details and access to the dataset, visit https://grouplens.org/.

Project Structure

This project consists of SQL scripts that facilitate data analysis on the MovieLens dataset. The primary components include:

• SQL Queries: A collection of SQL scripts to extract insights from the dataset, such as average ratings, movie popularity, and tag usage.

Getting Started

1. A SQL database (e.g., PostgreSQL, MySQL) set up on your machine.
2. Create a new database and tables in your machine.
3. Import Dataset: Use your SQL database tools to import the CSV files into corresponding tables. Ensure the following table structure:
   • links: Contains columns movieId, imdbId, tmdbId
   • movies: Contains columns movieId, title, genres
   • ratings: Contains columns userId, movieId, rating, timestamp
   • tags: Contains columns userId, movieId, tag, timestamp
4. Run SQL Queries: Execute the SQL scripts in the queries/ directory using your SQL client to analyze the dataset.

Queries are uploaded in pdf format : "Analysis of Movie Lens Dataset.pdf"