Top 500 Movies Data Analysis: Exploring Quality, Popularity, Critics & Audience Trends

By abhishek.verma75000 · June 3, 2026

A comprehensive data-driven analysis of 500 acclaimed films examining director performance, genre rankings, streaming platform quality, critic-audience…

Among directors with at least 2 films, Charlie Chaplin tops the rankings with an average Custom Score of 91.00, followed closely by Akira Kurosawa (90.39) and Francis Ford Coppola (89.96). A horizontal bar chart and supporting data tables have been generated to visualize the full top 10.

Higher IMDb Votes and Audience Reviews do NOT strongly correlate with higher Critic Ratings on Rotten Tomatoes. The analysis found only weak or very weak negative relationships between these metrics. Three scatter plots and a correlation heatmap were generated to visualize these relationships clearly.

The bar chart and data tables reveal which streaming platforms host the highest-rated films by average Custom Score. HBO tops the list with an impressive average score of 86.52 across 18 films, followed closely by HBM (85.0, 96 films), Paramount (84.87, 30 films), Amazon Video/AmzVid (84.39, 358 films), and iTunes (84.37, 354 films). Only platforms with at least 3 films were included to ensure meaningful comparisons.

The analysis produced a dual-axis chart and data tables showing how average Custom Score and average IMDb Votes have changed across movie release decades. The visualization displays Custom Score as a line (left axis) and IMDb Votes as bars (right axis), making it easy to compare both trends side by side across decades.

The analysis produced two bar charts and supporting tables showing which genres achieve the highest average IMDb and Metacritic scores (among genres with at least 3 movies). Family tops the IMDb rankings with an impressive average score of 8.25 across 4 movies. The visualizations make it easy to compare the top 10 genres side by side for both scoring systems.

The analysis identified the films with the largest discrepancies between Rotten Tomatoes Critic scores and Audience ratings. Two charts were generated: a diverging bar chart showing the direction and size of each gap, and a grouped bar chart comparing critic vs. audience scores side by side for the top 10 films.

The analysis successfully identified the top 15 films by Oscar wins and produced a bubble chart comparing Oscar wins against a combined critic/audience score. The bubble chart (artifact 1) plots each film's Oscar win count on the x-axis against its average of Custom Score, Audience Rating, and Critic RT Rating on the y-axis, with bubble size representing IMDb Votes and color indicating Custom Score. This gives a clear visual picture of whether films that win more Oscars also tend to score higher with critics and audiences. Additional data tables (artifacts 2-4) provide supporting breakdowns of the films and their ratings.

The analysis produced two grouped bar charts and supporting data tables breaking down film performance by language. The first chart compares Average Custom Score vs. Average Audience Rating across the top 10 languages by film count, while the second chart contrasts Critics (Metacritic) scores against Audience Ratings for the same language groups. English ('en') dominates the dataset by film count, but the visualizations reveal how non-English language films stack up on both critic and audience metrics.

The analysis calculated a popularity-to-quality ratio (Total Votes ÷ Custom Score) for each film and applied the IQR method to detect outliers. The scatter plot shows all movies plotted by Custom Score (x-axis) vs. Total Votes (y-axis), with over-hyped films highlighted in red and hidden gems in green. The IQR method flagged 20 over-hyped films — those receiving disproportionately high votes relative to their quality score. The tables generated provide detailed breakdowns of the top over-hyped and underrated films, including their scores, vote counts, and popularity-to-quality ratios.

Two multi-line charts and supporting data tables were generated showing how Metacritic, IMDb, and Letterboxd scores have trended across decades for the Top 500 movies. The first chart plots all three platform scores over time, while the second compares critic (Metacritic) vs. audience scores by decade. The 1920s emerged as the highest-rated decade on average, with a composite score of 86.83 — driven by a Metacritic average of 98.0, IMDb of 80.5, and Letterboxd of 82.0 — though this is based on very few films. The charts reveal how scoring patterns shift across eras and where critic and audience opinions diverge in more recent decades.

The sentiment analysis of the 'Plot' column reveals a fairly balanced distribution across all three sentiment categories. The dataset leans slightly positive overall, with an average polarity score of 0.051. A bar chart has been generated showing the full sentiment distribution across all 449 entries.

A word cloud has been generated from the 'Plot' column of the dataset, visually representing the most frequently occurring words in the movie/show plot descriptions. The larger and more prominent words appear more frequently across all plots.