Showing posts with label Netflix. Show all posts
Showing posts with label Netflix. Show all posts

Monday, December 10, 2012

Quickly install software bundle after installing Ubuntu

Here is a quick way to install the most commonly used software easily after installing Ubuntu from scratch. This can save you some time. What’s currently in the bundle: VLC, Texmaker, Terminator, nautilus-open-terminal, Filezila, Shutter, Wine, Spotify, unrar, zip, oracle java 7, compiz, Chromium, Dropbox, Open ssh, Netflix,  Adobe Reader

The credit actually goes to Sigurgrímur Jónsson for building this script. You can read more about it here:


If you don’t need something in the package, you can certainly modify the script and add or remove it. I have Ubuntu 12.04 LTS and it seems to work.


  1. Download the script from here
  2. Rename the script from gimsi_install.txt to gimsi_install
  3. Grant execute permission (chomod 755) and run it

Here is a quick video:

Monday, February 20, 2012

Extracting Netflix Data using PowerPivot

Today I played around with Netflix data after extracting it using PowerPivot for Excel addin.

Netflix OData feed:

I wasn’t able to create a relationship between the entities Titles, Genres, People, TitleAudioFormats etc. The Titles data apparently contains duplicates in its TitleId column and the entities were missing the key attributes required for setting up a relationship.

Anyway, here is a shot at it:


Drill to detail:


You can download the file here. You’ll need Excel 2010 for the slicers to work. Due to the volume of the data, I only extracted Titles with release date greater than or equal to 1997.!704&parid=D3AFF4F279DFF93D!701&authkey=!AD-0WHa9FqcIU3U

You may be prompted to download this file as the file is ~40MB.