Games Sort Example 1
Getting a sorted list of games by review score
User input is in bold.
$ python3 search-games.py
This program helps the user explore a data set of
over a thousand video games released between
2004 and 2008.
In particular, you can:
1. Search by console and release year
2. Search by game title
3. Rank best reviewed games by console and genre
4. Find top selling games by year
5. Help: list possible Genres
6. Quit
Choice: 5
List of game genres in the data set:
------------------------------------
Action
Adventure
Driving
Educational
Racing
Role-Playing(RPG)
Simulation
Sports
Strategy
1. Search by console and release year
2. Search by game title
3. Rank best reviewed games by console and genre
4. Find top selling games by year
5. Help: list possible Genres
6. Quit
Choice: 3
Enter console (or 'Any'): Wii
Enter genre (or 'Any'): Sports
TITLE REVIEW SALES PRICE CONSOLE YEAR PLAYTIME
------------------------------ ------ ----- ----- ------- ---- --------
MLB Power Pros 2008 83 0.12 22.95 Wii 2008 -1.0
Pro Evolution Soccer 2008 83 0.1 17.95 Wii 2008 70.0
WarioWare: Smooth Moves 83 0.9 39.95 Wii 2006 3.0
Madden NFL 07 81 0.48 9.95 Wii 2006 -1.0
Wii Fit 80 9.6 24.95 Wii 2007 4.0
Mario Strikers Charged 79 0.93 29.95 Wii 2007 12.0
Shaun White Snowboarding: Road 78 0.95 14.95 Wii 2008 -1.0
Madden NFL 08 76 0.86 12.95 Wii 2007 17.0
SSX Blur 74 0.31 17.95 Wii 2007 10.0
Rayman Raving Rabbids TV Party 73 0.74 17.95 Wii 2008 -1.0
Super Swing Golf 72 0.14 16.95 Wii 2006 -1.0
Tiger Woods PGA Tour 08 72 1 17.95 Wii 2007 -1.0
Sega Superstars Tennis 71 0.28 12.95 Wii 2008 8.0
Tiger Woods PGA Tour 07 71 0.46 17.95 Wii 2007 10.0
skate it 70 0.5 39.95 Wii 2008 -1.0
Super Swing Golf Season 2 70 0.07 19.95 Wii 2007 -1.0
Mario & Sonic at the Olympic G 67 2.74 29.95 Wii 2007 9.0
EA Playground 66 0.72 17.95 Wii 2007 -1.0
The BIGS 66 0.36 17.95 Wii 2007 10.13
NHL 2K9 65 0.06 14.95 Wii 2008 -1.0
Surf's Up 64 0.16 16.95 Wii 2007 1.28
SEGA Bass Fishing 59 0.34 17.95 Wii 2008 7.0
Victorious Boxers: Revolution 59 0.08 24.95 Wii 2007 -1.0
WWE Smackdown vs. Raw 2008 59 0.39 12.95 Wii 2007 13.1
Wii Play 58 14.66 14.95 Wii 2006 4.0
25 matches found
1. Search by console and release year
2. Search by game title
3. Rank best reviewed games by console and genre
4. Find top selling games by year
5. Help: list possible Genres
6. Quit
Choice: 3
Enter console (or 'Any'): Any
Enter genre (or 'Any'): Any
TITLE REVIEW SALES PRICE CONSOLE YEAR PLAYTIME
------------------------------ ------ ----- ----- ------- ---- --------
Grand Theft Auto IV 98 5.76 24.95 X360 2008 32.0
Grand Theft Auto IV 98 3.91 24.95 PS3 2008 32.0
Super Mario Galaxy 97 4.94 39.95 Wii 2007 20.0
BioShock 96 1.52 16.95 X360 2007 13.5
The Orange Box 96 1.06 17.95 X360 2007 29.0
LittleBigPlanet 95 2.46 24.95 PS3 2008 10.0
The Legend of Zelda: Twilight 95 3.33 39.95 Wii 2006 43.0
BioShock 94 0.53 17.95 PS3 2008 13.5
Call of Duty 4: Modern Warfare 94 5.77 29.95 X360 2007 7.0
Call of Duty 4: Modern Warfare 94 2.91 24.95 PS3 2007 7.0
Gears of War 94 3.7 19.95 X360 2006 9.43
Halo 3 94 8.03 24.95 X360 2007 9.08
Metal Gear Solid 4: Guns of th 94 2.58 22.95 PS3 2008 18.9
The Elder Scrolls IV: Oblivion 94 2.12 19.95 X360 2006 80.0
Fallout 3 93 2.44 17.95 X360 2008 45.0
Gears of War 2 93 3.9 24.95 X360 2008 10.0
Super Smash Bros.: Brawl 93 5.71 39.95 Wii 2008 15.0
The Elder Scrolls IV: Oblivion 93 1.2 17.95 PS3 2007 80.0
Chrono Trigger 92 0.51 17.95 DS 2008 25.0
Guitar Hero II 92 2.04 17.95 X360 2007 9.5
Rock Band 92 2.02 14.95 X360 2007 8.0
Rock Band 92 1.01 14.95 PS3 2007 8.0
Rock Band 92 1.4 17.95 Wii 2008 8.0
Rock Band 2 92 1.85 19.95 X360 2008 12.5
God of War: Chains of Olympus 91 1.54 17.95 PSP 2008 5.67
25 matches found
1. Search by console and release year
2. Search by game title
3. Rank best reviewed games by console and genre
4. Find top selling games by year
5. Help: list possible Genres
6. Quit
Choice: 3
Enter console (or 'Any'): Any
Enter genre (or 'Any'): Racing
TITLE REVIEW SALES PRICE CONSOLE YEAR PLAYTIME
------------------------------ ------ ----- ----- ------- ---- --------
Grand Theft Auto IV 98 5.76 24.95 X360 2008 32.0
Grand Theft Auto IV 98 3.91 24.95 PS3 2008 32.0
Mario Kart DS 91 9.99 29.95 DS 2005 9.08
Forza Motorsport 2 90 2.48 12.95 X360 2007 58.22
Grand Theft Auto: Liberty City 88 2.97 17.95 PSP 2005 14.97
Ridge Racer 88 0.36 19.95 PSP 2004 0.88
WipEout Pure 88 0.45 12.95 PSP 2005 8.8
Burnout Paradise 87 1.01 17.95 PS3 2008 20.0
GRID 87 0.35 19.95 X360 2008 23.13
GRID 87 0.31 24.95 PS3 2008 23.13
Burnout Legends 86 0.68 14.95 PSP 2005 12.0
Grand Theft Auto: Vice City St 86 1.72 17.95 PSP 2006 17.23
Pure 85 1.43 12.95 X360 2008 13.0
Crackdown 83 1.02 14.95 X360 2007 12.33
DiRT 83 0.39 17.95 X360 2007 13.0
DiRT 83 0.16 17.95 PS3 2007 13.0
Need for Speed: Most Wanted 83 0.95 17.95 X360 2005 12.0
No More Heroes 83 0.29 17.95 Wii 2007 13.0
Pure 83 0.36 17.95 PS3 2008 13.0
WarioWare: Smooth Moves 83 0.9 39.95 Wii 2006 3.0
Mario Kart Wii 82 12.39 29.95 Wii 2008 9.12
Midnight Club: Los Angeles 82 1.09 22.95 PS3 2008 31.03
MotorStorm 82 1.58 16.95 PS3 2006 15.0
MotorStorm: Pacific Rift 82 0.37 29.95 PS3 2008 32.5
OutRun 2006: Coast 2 Coast 82 0.03 17.95 PSP 2006 4.0
25 matches found
1. Search by console and release year
2. Search by game title
3. Rank best reviewed games by console and genre
4. Find top selling games by year
5. Help: list possible Genres
6. Quit
Choice: 3
Enter console (or 'Any'): Wii
Enter genre (or 'Any'): Role-Playing (RPG)
TITLE REVIEW SALES PRICE CONSOLE YEAR PLAYTIME
------------------------------ ------ ----- ----- ------- ---- --------
The Legend of Zelda: Twilight 95 3.33 39.95 Wii 2006 43.0
Super Paper Mario 85 1.5 29.95 Wii 2007 19.77
Fire Emblem: Radiant Dawn 78 0.26 34.95 Wii 2007 47.83
Final Fantasy Fables: Chocobo' 76 0.09 17.95 Wii 2008 25.0
Marvel Ultimate Alliance 73 0.38 17.95 Wii 2006 14.0
Dokapon Kingdom 72 0.12 17.95 Wii 2008 25.0
Harvest Moon: Magical Melody 69 0.18 23.95 Wii 2008 30.37
Tales of Symphonia: Dawn of th 68 0.2 24.95 Wii 2008 36.77
Harvest Moon: Tree of Tranquil 65 0.62 34.95 Wii 2008 38.5
The Chronicles of Narnia: Prin 63 0.33 16.95 Wii 2008 11.65
Neopets Puzzle Adventure 52 0.14 14.95 Wii 2008 3.0
Baroque 50 0.04 19.95 Wii 2008 7.78
12 matches found
1. Search by console and release year
2. Search by game title
3. Rank best reviewed games by console and genre
4. Find top selling games by year
5. Help: list possible Genres
6. Quit
Choice: 3
Enter console (or 'Any'): X360
Enter genre (or 'Any'): Computer Science
TITLE REVIEW SALES PRICE CONSOLE YEAR PLAYTIME
------------------------------ ------ ----- ----- ------- ---- --------
0 matches found
1. Search by console and release year
2. Search by game title
3. Rank best reviewed games by console and genre
4. Find top selling games by year
5. Help: list possible Genres
6. Quit
Choice: 6
Goodbye!