episodes_n rating_mean rating_median rating_min rating_max reviews_mean
1 255 8.076471 8.1 4.1 9.8 26676.47
reviews_median airdate_start airdate_end
1 3400 2000-01-12 2025-12-28Final Project - One Piece Data
Introduction
Over the last year I have been watching a show called One Piece, it has over 1160 episodes. It is one of the highest rated TV shows on IMDb and is still making new episodes weekly. I wanted to scrape through IMDb and look through the shows data from their first three full years of episodes (2000-2002) and the three most recent full years (2023-2025).
How to find my data
You can access the data I scraped, in separate code, through this URL. https://myxavier-my.sharepoint.com/:x:/g/personal/kovacf_xavier_edu/IQDWg5DbeL5tSbmgJ-tI1jwvATnz8zcJBPon-b2SO0w2yiE?download=1
Variables
Here are the variables of the data frame.
| Name | Description |
|---|---|
| episode_name | The name and the number of episode. |
| episode_date | The date the episode came out. |
| episode_description | The description of the episode (plot). |
| episode_rating | The official IMDb rating the episode got (#/10). |
| episode_review_count | The total amount of reviewers that submitted a review (thousands). |
Some Summary Statistics
These are a few summary statistics for these six years of data. Looking at how many episodes are in the data, the average, median, min and max rating. Also looking at review count average and median. Finally looking at the start and end date of the data.
Creating Visualizations
My goal was to create visualizations to see how much more popular One Piece has become over the last 27 years. I created graphs for ratings over the years, the average reviews for each year, the distribution of ratings through those years,
1. Average Ratings Over The Years
We see that over these six years the show consistently gets rated around 8.09. However in 2023-25 the average rating is 8.47 and the first three years of the show is 7.69. So this shows us that even though the show has been going on for 27 years, it keeps up the consistency of the content.
2. The Average Reviews for Each Year
In this graph we can clearly see the popularity of One Piece sky rocket. In the first three years of the show the average amount of reviews is less than half of the three most recent years.
3. Distributions of Ratings
This graph shows us that the median rating is rising each year proving that the quality of the episodes improves over the years. The boxes and whiskers get smaller meaning the ratings become more consistent, fewer highs and lows. The outliers decrease which means they are producing less lower-rated episodes.
4. Number of Episodes per Year
This graph shows the consistency of One Piece episode production over the years. The first three years on average produced more episodes than the last three years. This is a case of quality over quantity, with the previous graphs proving that One Piece is consistently good even though there are less episodes per year.
5. Highest Rated Episodes
I wanted to list out the top 10 rated episodes during these 6 years. The average rating of these episodes is 9.73/10. All of these episodes are from 2023-2025.
# A tibble: 10 × 3
episode_name episode_date episode_rating
<chr> <date> <dbl>
1 S1.E1136 ∙ Kuma's Life 2025-07-13 9.8
2 S1.E1153 ∙ The Upheaval of an Era! The Color of … 2025-12-14 9.8
3 S1.E1062 ∙ The Three-Sword Style of the Supreme … 2023-05-21 9.7
4 S1.E1089 ∙ Entering a New Chapter! Luffy and Sab… 2024-01-07 9.7
5 S1.E1100 ∙ Powers on a Different Level! Luffy vs… 2024-04-07 9.7
6 S1.E1112 ∙ Clash! Shanks vs. Eustass Kid 2024-07-14 9.7
7 S1.E1114 ∙ For the Beloved Pupil - The Fist of V… 2024-08-04 9.7
8 S1.E1115 ∙ The Navy Surprised! The Navy Headquar… 2024-08-11 9.7
9 S1.E1122 ∙ The Last Lesson! Impact Inherited 2024-10-13 9.7
10 S1.E1128 ∙ The Nightmare Strikes - Warrior God o… 2025-05-04 9.7Data Set Two (Jikan API)
Jikan API is one of the most active online anime + manga community and database. I wanted to look into this data set and grab every single episode from the show. Since IMDb is a little restrictive with scraping this data set give me ratings of every episode and also a list of episodes that are filler or not. In anime filler is unique compared to other shows. Filler episodes are not apart of the original manga story line but are typically produced to prevent the anime from catching up to the source material. Especially for shows that have been on a weekly release schedule over the last 27 years there is a good amount of filler.
Where to Find this Data
You can access the data I scraped, in separate code, through this URL. https://myxavier-my.sharepoint.com/:x:/g/personal/kovacf_xavier_edu/IQDKast2WJVUSLYmm8st4DG5AXmnYv1QeF2SflHjVC1gcnM?download=1
Variables
Here are the variables of the data frame.
| Name | Description |
|---|---|
| Aired | The Year-Month-Day the episode released |
| Filler | A boolean of if the episode is a filler or not according to JIKAN API |
| Title | The title of the episode |
| Score | The score of the episode (#/5) |
Summary Stats from JIKAN
This summary shows every single year of the show, their average score out of five, the number of episodes that year, a number of episodes that are filler or not, and the filler percentage per year.
# A tibble: 28 × 7
year avg_mal_score episodes filler_eps non_filler total filler_pct
<dbl> <dbl> <int> <int> <int> <int> <dbl>
1 1999 4.15 8 0 8 8 0
2 2000 4.26 44 2 42 44 4.5
3 2001 4.26 42 7 35 42 16.7
4 2002 4.26 44 11 33 44 25
5 2003 4.31 37 5 32 37 13.5
6 2004 4.37 39 13 26 39 33.3
7 2005 4.36 39 8 31 39 20.5
8 2006 4.40 38 1 37 38 2.6
9 2007 4.40 45 16 29 45 35.6
10 2008 4.46 47 2 45 47 4.3
# ℹ 18 more rowsFiller Episodes per Year
This is a line graph of looking at the trends of filler episodes per year. With 2007 being having the most filler episodes 16 out of 29 total episodes that year. Through the 1156 total episodes the show only consists of 8.39% of filler.
Conclusion
Through this analysis it proved that One Piece is only getting better with time. Even though I am a little biased towards the show, we can see just how popular this show has become over the last 27 years. One Piece has done an excellent job with being consistent and not having a lot of filler compared to other Animes. The show has about 1160 episodes at the time of writing this and they are still projected to go on for about 5-8 years. I am curious to see if One Piece stays on this upward trend for the rest of the show.