Fun Project #2: Behind the Screens - My Netflix Watch Hours Exposed by Python
So this week, I decided to do something fun and go all detective on my love for watching movies on Netflix by working on a cool side project with Python Pandas. I must say, I am incredibly impressed with how many hours I have sunk into Netflix. Can you take a wild guess?
Before I drop the numbers, a sidenote is that I'm not going to dive into a code breakdown in this post, but I'm dropping a link to the source code. I tried to explain the code with comments as much as possible, so I'm sure you'll be good to go.
Oh and one more thing: for your own data, you will need to request it from Netflix. Takes a couple of days or just a few hours if you are lucky. You can use this link to request a copy of your Netflix data: https://www.netflix.com/account/getmyinfo – You'll receive a zip file with a bunch of folders in there. The file you are looking for is called ViewingActivity.csv in the Content_Interaction folder
ekowamoonuNetflixWatchTime
With that out of the way, did you make a wild guess of how many hours I have sunk into Netflix since 2020 (the year I actually started watching Netflix)? Here we go:
I don't know how this compares to yours but I'm sure you'd want to find out..lol.
Also, I was able to extract some other interesting information like the days of the week I have watched the most: Sunday. Next is Saturday. That definitely sounds right.
The next chart also showed me some pretty interesting stuff.
Who would have thought that I would watch more movies at 7 p.m. than at any other time of the day? So if you try to reach me around the times of 7 p.m. to 9 p.m. and I'm unavailable, then you already know what I'm probably up to..lol.
Hopefully, you had a bit of fun rampaging through my bad watch habits. Don't judge me.
I learned a lot from this project. Faced some bugs here and there, but I sailed through. One thing I couldn't figure out though is how to get a chart of which movies I have spent the most hours on. The CSV file breaks down the movies into episodes so that made it tricky.
Well, maybe you'll figure that out and tell me about it 😊
Member discussion