Movies Analysis

movies_analysis.ipynb · October 23, 2023 · portfolio / projects

PythonpandasEDACase study

I enjoy watching films, so I did a data analysis project about IMDb's Top 1000 movies.

Let's imagine that you are a data analyst for a film studio. The studio wants to make a film, but they are not sure what type of film they should make. They asked your team to analyze the IMDb Movies Dataset. The studio wants us to find patterns and trends in the dataset and present them to the stakeholders.

You can find out more about this project on my Medium page, and the code is on my GitHub repository. Below you can run your own questions against the full dataset.

Read on Medium ↗Code on GitHub ↗📓 View notebook

SELECT primary_genre AS genre, COUNT(*) AS films, ROUND(AVG(imdb_rating),2) AS avg_rating
FROM movies
GROUP BY primary_genre
ORDER BY avg_rating DESC;