PCI – Chapter Two – Recommending Items

Creating recommendations for Mario:

 userId     itemId     rating     weighted score     title
---------  ---------  ---------  -----------------  -----------------------------
 808        875        4          3.61813613493316   She's So Lovely (1997)
 808        872        5          4.52267016866645   Love Jones (1997)
 808        751        3          2.71360210119987   Tomorrow Never Dies (1997)
 808        750        5          4.52267016866645   Amistad (1997)
 808        748        4          3.61813613493316   Saint, The (1997)
 519        1617       5          4.76731294622795   Hugo Pool (1997)
 519        1612       5          4.76731294622795   Leading Man, The (1996)
 519        1592       5          4.76731294622795   Magic Hour, The (1998)
 519        1591       5          4.76731294622795   Duoluo tianshi (1995)
 519        1434       5          4.76731294622795   Shooting Fish (1997)
 317        879        3          2.75567596063107   Peacemaker, The (1997)
 317        748        5          4.59279326771845   Saint, The (1997)
 317        683        2          1.83711730708738   Rocket Man (1997)
 317        678        2          1.83711730708738   Volcano (1997)
 317        355        4          3.67423461417476   Sphere (1998)

This is a sample resultset from obtaining weighted scores for movies which might be of interest to me.

Queries for these will follow; I really have to figure out how to display neat code… yellow divs do not help much.

Very interesting exercise thou; more later.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s