Amanda's avatar
Amanda
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Amanda's Netflix Data

This report shows my watch data on Netflix from when I joined through November 5th.  eyJrIjoiNDY4ZWQ5ODUtNjEwNi00OWMxLWE1ZDEtOWQwZDc4MzdlNDkzIiwidCI6IjcyZjk4OGJmLTg2ZjEtNDFhZi05MWFiLTJkN2NkMDExZGI0...
Entertainment
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Amanda!

Yes I downloaded my Viewing Data from Netflix. But that .csv file just had two columns: 'Title' and 'Date'. 

As I had few records, I manually entered the Genre and Duration fields. (But that's not the most optimal solution to do it right?)

I was wondering how you got the '#of Times Watched","Genre" and "Time Watched(min) data for your report.

Below is the snippet of the report that I prepared.

 

Amanda's avatar
Amanda
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

For that I used this API since Netflix won't give you that information: https://www.omdbapi.com/

 

IMDB and Netflix don't always use the same name for shows and movies so I did need to do some data cleansing to get everything to align perfectly.