Video demo: https://youtu.be/Q6ecN9GK7x8
A Python program that reads your Netflix viewing and billing data and shows you fun stats. Built for CS50P at Harvard.
Netflix lets you download all your data - every show you have watched, every dollar you have spent. But the files are just raw CSVs. This program makes them readable.
You pick a profile (or all of them), then choose from a menu:
- Total Spent - how much you have paid since joining. Asks if you want PYG conversion too.
- Most Watched Series - top 5 shows ranked by watch time.
- Most Watched Movies - same thing, but for films.
- Total Watch Time - all your hours combined in one number.
- Cost Per Hour - total spent divided by total hours.
It automatically skips trailers, hooks, and autoplay previews so your real watch time is not inflated.
- Netflix -> Account -> Download your personal information
- Wait for the email (usually less than a day)
- Download and unzip the file
- You will get a folder with a name like
1343059170 - Inside it, the program uses two folders: CONTENT_INTERACTION/ViewingActivity.csv PAYMENT_AND_BILLING/BillingHistory.csv
pip install -r requirements.txt
python project.py C:\Users\you\Downloads\1343059170Or just python project.py and type the path when asked.
project.py - the whole program. Menu, analysis functions, everything. test_project.py - tests for the main functions. requirements.txt - the libraries needed: pandas and requests.
The sample_data/ folder contains fake example data. Try it out:
python project.py sample_data