Rafa1986/Data-Analytics-Class
0
1{2 "cells": [3 {4 "cell_type": "markdown",5 "metadata": {},6 "source": [7 "### Lab3 - 2 - Data Transformations"8 ]9 },10 {11 "cell_type": "code",12 "execution_count": 12,13 "metadata": {},14 "outputs": [15 {16 "data": {17 "text/html": [18 "<style>.container { width:80% !important; }</style>"19 ],20 "text/plain": [21 "<IPython.core.display.HTML object>"22 ]23 },24 "metadata": {},25 "output_type": "display_data"26 }27 ],28 "source": [29 "from IPython.display import display, HTML\n",30 "display(HTML(\"<style>.container { width:80% !important; }</style>\"))"31 ]32 },33 {34 "cell_type": "markdown",35 "metadata": {},36 "source": [37 "When preparing data for input to machine learning algorithms you may have to perform certain types of data preparation.\n",38 "\n",39 "In most enterprise solutions all or most of these tasks are automated for you, but in many languages they aren’t. The enterprise solutions are about ‘automating the boring stuff’ so that you don’t have to worry about it and waste valuable time doing boring, repetitive things.\n",40 "\n",41 "The following examples illustrates a number of ways to record categorical variables into numeric. There are a number of approaches available, and it is up to you to decide which one might work best for your problem, your data, etc.\n",42 "\n",43 "Let’s begin by loading the data set to be used in these examples. It is a Video Games reviews data set.\n",44 "Useful : This website has a list of useful and typical data transformations. Some of these are covered below.\n",45 "https://www.kdnuggets.com/2020/07/easy-guide-data-preprocessing-python.html"46 ]47 },48 {49 "cell_type": "code",50 "execution_count": 13,51 "metadata": {},52 "outputs": [53 {54 "data": {55 "text/html": [56 "<div>\n",57 "<style scoped>\n",58 " .dataframe tbody tr th:only-of-type {\n",59 " vertical-align: middle;\n",60 " }\n",61 "\n",62 " .dataframe tbody tr th {\n",63 " vertical-align: top;\n",64 " }\n",65 "\n",66 " .dataframe thead th {\n",67 " text-align: right;\n",68 " }\n",69 "</style>\n",70 "<table border=\"1\" class=\"dataframe\">\n",71 " <thead>\n",72 " <tr style=\"text-align: right;\">\n",73 " <th></th>\n",74 " <th>Name</th>\n",75 " <th>Platform</th>\n",76 " <th>Year_of_Release</th>\n",77 " <th>Genre</th>\n",78 " <th>Publisher</th>\n",79 " <th>NA_Sales</th>\n",80 " <th>EU_Sales</th>\n",81 " <th>JP_Sales</th>\n",82 " <th>Other_Sales</th>\n",83 " <th>Global_Sales</th>\n",84 " <th>Critic_Score</th>\n",85 " <th>Critic_Count</th>\n",86 " <th>User_Score</th>\n",87 " <th>User_Count</th>\n",88 " <th>Developer</th>\n",89 " <th>Rating</th>\n",90 " </tr>\n",91 " </thead>\n",92 " <tbody>\n",93 " <tr>\n",94 " <th>0</th>\n",95 " <td>Wii Sports</td>\n",96 " <td>Wii</td>\n",97 " <td>2006.0</td>\n",98 " <td>Sports</td>\n",99 " <td>Nintendo</td>\n",100 " <td>41.36</td>\n",101 " <td>28.96</td>\n",102 " <td>3.77</td>\n",103 " <td>8.45</td>\n",104 " <td>82.53</td>\n",105 " <td>76.0</td>\n",106 " <td>51.0</td>\n",107 " <td>8</td>\n",108 " <td>322.0</td>\n",109 " <td>Nintendo</td>\n",110 " <td>E</td>\n",111 " </tr>\n",112 " <tr>\n",113 " <th>1</th>\n",114 " <td>Super Mario Bros.</td>\n",115 " <td>NES</td>\n",116 " <td>1985.0</td>\n",117 " <td>Platform</td>\n",118 " <td>Nintendo</td>\n",119 " <td>29.08</td>\n",120 " <td>3.58</td>\n",121 " <td>6.81</td>\n",122 " <td>0.77</td>\n",123 " <td>40.24</td>\n",124 " <td>NaN</td>\n",125 " <td>NaN</td>\n",126 " <td>NaN</td>\n",127 " <td>NaN</td>\n",128 " <td>NaN</td>\n",129 " <td>NaN</td>\n",130 " </tr>\n",131 " <tr>\n",132 " <th>2</th>\n",133 " <td>Mario Kart Wii</td>\n",134 " <td>Wii</td>\n",135 " <td>2008.0</td>\n",136 " <td>Racing</td>\n",137 " <td>Nintendo</td>\n",138 " <td>15.68</td>\n",139 " <td>12.76</td>\n",140 " <td>3.79</td>\n",141 " <td>3.29</td>\n",142 " <td>35.52</td>\n",143 " <td>82.0</td>\n",144 " <td>73.0</td>\n",145 " <td>8.3</td>\n",146 " <td>709.0</td>\n",147 " <td>Nintendo</td>\n",148 " <td>E</td>\n",149 " </tr>\n",150 " <tr>\n",151 " <th>3</th>\n",152 " <td>Wii Sports Resort</td>\n",153 " <td>Wii</td>\n",154 " <td>2009.0</td>\n",155 " <td>Sports</td>\n",156 " <td>Nintendo</td>\n",157 " <td>15.61</td>\n",158 " <td>10.93</td>\n",159 " <td>3.28</td>\n",160 " <td>2.95</td>\n",161 " <td>32.77</td>\n",162 " <td>80.0</td>\n",163 " <td>73.0</td>\n",164 " <td>8</td>\n",165 " <td>192.0</td>\n",166 " <td>Nintendo</td>\n",167 " <td>E</td>\n",168 " </tr>\n",169 " <tr>\n",170 " <th>4</th>\n",171 " <td>Pokemon Red/Pokemon Blue</td>\n",172 " <td>GB</td>\n",173 " <td>1996.0</td>\n",174 " <td>Role-Playing</td>\n",175 " <td>Nintendo</td>\n",176 " <td>11.27</td>\n",177 " <td>8.89</td>\n",178 " <td>10.22</td>\n",179 " <td>1.00</td>\n",180 " <td>31.37</td>\n",181 " <td>NaN</td>\n",182 " <td>NaN</td>\n",183 " <td>NaN</td>\n",184 " <td>NaN</td>\n",185 " <td>NaN</td>\n",186 " <td>NaN</td>\n",187 " </tr>\n",188 " <tr>\n",189 " <th>5</th>\n",190 " <td>Tetris</td>\n",191 " <td>GB</td>\n",192 " <td>1989.0</td>\n",193 " <td>Puzzle</td>\n",194 " <td>Nintendo</td>\n",195 " <td>23.20</td>\n",196 " <td>2.26</td>\n",197 " <td>4.22</td>\n",198 " <td>0.58</td>\n",199 " <td>30.26</td>\n",200 " <td>NaN</td>\n",201 " <td>NaN</td>\n",202 " <td>NaN</td>\n",203 " <td>NaN</td>\n",204 " <td>NaN</td>\n",205 " <td>NaN</td>\n",206 " </tr>\n",207 " <tr>\n",208 " <th>6</th>\n",209 " <td>New Super Mario Bros.</td>\n",210 " <td>DS</td>\n",211 " <td>2006.0</td>\n",212 " <td>Platform</td>\n",213 " <td>Nintendo</td>\n",214 " <td>11.28</td>\n",215 " <td>9.14</td>\n",216 " <td>6.50</td>\n",217 " <td>2.88</td>\n",218 " <td>29.80</td>\n",219 " <td>89.0</td>\n",220 " <td>65.0</td>\n",221 " <td>8.5</td>\n",222 " <td>431.0</td>\n",223 " <td>Nintendo</td>\n",224 " <td>E</td>\n",225 " </tr>\n",226 " <tr>\n",227 " <th>7</th>\n",228 " <td>Wii Play</td>\n",229 " <td>Wii</td>\n",230 " <td>2006.0</td>\n",231 " <td>Misc</td>\n",232 " <td>Nintendo</td>\n",233 " <td>13.96</td>\n",234 " <td>9.18</td>\n",235 " <td>2.93</td>\n",236 " <td>2.84</td>\n",237 " <td>28.92</td>\n",238 " <td>58.0</td>\n",239 " <td>41.0</td>\n",240 " <td>6.6</td>\n",241 " <td>129.0</td>\n",242 " <td>Nintendo</td>\n",243 " <td>E</td>\n",244 " </tr>\n",245 " <tr>\n",246 " <th>8</th>\n",247 " <td>New Super Mario Bros. Wii</td>\n",248 " <td>Wii</td>\n",249 " <td>2009.0</td>\n",250 " <td>Platform</td>\n",251 " <td>Nintendo</td>\n",252 " <td>14.44</td>\n",253 " <td>6.94</td>\n",254 " <td>4.70</td>\n",255 " <td>2.24</td>\n",256 " <td>28.32</td>\n",257 " <td>87.0</td>\n",258 " <td>80.0</td>\n",259 " <td>8.4</td>\n",260 " <td>594.0</td>\n",261 " <td>Nintendo</td>\n",262 " <td>E</td>\n",263 " </tr>\n",264 " <tr>\n",265 " <th>9</th>\n",266 " <td>Duck Hunt</td>\n",267 " <td>NES</td>\n",268 " <td>1984.0</td>\n",269 " <td>Shooter</td>\n",270 " <td>Nintendo</td>\n",271 " <td>26.93</td>\n",272 " <td>0.63</td>\n",273 " <td>0.28</td>\n",274 " <td>0.47</td>\n",275 " <td>28.31</td>\n",276 " <td>NaN</td>\n",277 " <td>NaN</td>\n",278 " <td>NaN</td>\n",279 " <td>NaN</td>\n",280 " <td>NaN</td>\n",281 " <td>NaN</td>\n",282 " </tr>\n",283 " </tbody>\n",284 "</table>\n",285 "</div>"286 ],287 "text/plain": [288 " Name Platform Year_of_Release Genre \\\n",289 "0 Wii Sports Wii 2006.0 Sports \n",290 "1 Super Mario Bros. NES 1985.0 Platform \n",291 "2 Mario Kart Wii Wii 2008.0 Racing \n",292 "3 Wii Sports Resort Wii 2009.0 Sports \n",293 "4 Pokemon Red/Pokemon Blue GB 1996.0 Role-Playing \n",294 "5 Tetris GB 1989.0 Puzzle \n",295 "6 New Super Mario Bros. DS 2006.0 Platform \n",296 "7 Wii Play Wii 2006.0 Misc \n",297 "8 New Super Mario Bros. Wii Wii 2009.0 Platform \n",298 "9 Duck Hunt NES 1984.0 Shooter \n",299 "\n",300 " Publisher NA_Sales EU_Sales JP_Sales Other_Sales Global_Sales \\\n",301 "0 Nintendo 41.36 28.96 3.77 8.45 82.53 \n",302 "1 Nintendo 29.08 3.58 6.81 0.77 40.24 \n",303 "2 Nintendo 15.68 12.76 3.79 3.29 35.52 \n",304 "3 Nintendo 15.61 10.93 3.28 2.95 32.77 \n",305 "4 Nintendo 11.27 8.89 10.22 1.00 31.37 \n",306 "5 Nintendo 23.20 2.26 4.22 0.58 30.26 \n",307 "6 Nintendo 11.28 9.14 6.50 2.88 29.80 \n",308 "7 Nintendo 13.96 9.18 2.93 2.84 28.92 \n",309 "8 Nintendo 14.44 6.94 4.70 2.24 28.32 \n",310 "9 Nintendo 26.93 0.63 0.28 0.47 28.31 \n",311 "\n",312 " Critic_Score Critic_Count User_Score User_Count Developer Rating \n",313 "0 76.0 51.0 8 322.0 Nintendo E \n",314 "1 NaN NaN NaN NaN NaN NaN \n",315 "2 82.0 73.0 8.3 709.0 Nintendo E \n",316 "3 80.0 73.0 8 192.0 Nintendo E \n",317 "4 NaN NaN NaN NaN NaN NaN \n",318 "5 NaN NaN NaN NaN NaN NaN \n",319 "6 89.0 65.0 8.5 431.0 Nintendo E \n",320 "7 58.0 41.0 6.6 129.0 Nintendo E \n",321 "8 87.0 80.0 8.4 594.0 Nintendo E \n",322 "9 NaN NaN NaN NaN NaN NaN "323 ]324 },325 "execution_count": 13,326 "metadata": {},327 "output_type": "execute_result"328 }329 ],330 "source": [331 "# perform some Statistics on the items in a panda\n",332 "import pandas as pd\n",333 "import numpy as np\n",334 "import matplotlib as plt\n",335 "videoReview = pd.read_csv('/Users/brendan.tierney/Dropbox/4-Datasets/Video_Games_Sales_as_at_22_Dec_2016.csv') \n",336 "videoReview.head(10)"337 ]338 },339 {340 "cell_type": "code",341 "execution_count": 14,342 "metadata": {},343 "outputs": [344 {345 "data": {346 "text/plain": [347 "Name object\n",348 "Platform object\n",349 "Year_of_Release float64\n",350 "Genre object\n",351 "Publisher object\n",352 "NA_Sales float64\n",353 "EU_Sales float64\n",354 "JP_Sales float64\n",355 "Other_Sales float64\n",356 "Global_Sales float64\n",357 "Critic_Score float64\n",358 "Critic_Count float64\n",359 "User_Score object\n",360 "User_Count float64\n",361 "Developer object\n",362 "Rating object\n",363 "dtype: object"364 ]365 },366 "execution_count": 14,367 "metadata": {},368 "output_type": "execute_result"369 }370 ],371 "source": [372 "#What are the data types of each variable\n",373 "videoReview.dtypes"374 ]375 },376 {377 "cell_type": "code",378 "execution_count": 15,379 "metadata": {},380 "outputs": [381 {382 "data": {383 "text/plain": [384 "['Nintendo',\n",385 " nan,\n",386 " 'Good Science Studio',\n",387 " 'Rockstar North',\n",388 " 'Polyphony Digital',\n",389 " 'Infinity Ward, Sledgehammer Games',\n",390 " 'Treyarch',\n",391 " 'Infinity Ward',\n",392 " 'DMA Design',\n",393 " 'Game Arts',\n",394 " 'Retro Studios, Entertainment Analysis & Development Division',\n",395 " 'Bungie Software, Bungie',\n",396 " 'Ubisoft',\n",397 " 'Bungie',\n",398 " 'SquareSoft',\n",399 " '343 Industries',\n",400 " 'Hudson Soft',\n",401 " 'Bethesda Game Studios',\n",402 " 'EA Sports',\n",403 " 'Bungie Software',\n",404 " 'Nd Cube',\n",405 " 'Hudson',\n",406 " 'Electronic Arts',\n",407 " 'The Sims Studio',\n",408 " 'Game Freak',\n",409 " 'Rockstar Leeds',\n",410 " 'Sledgehammer Games',\n",411 " 'EA Sports, EA Vancouver',\n",412 " 'Nintendo EAD Tokyo',\n",413 " 'EA DICE',\n",414 " 'EA Black Box',\n",415 " 'Ubisoft Paris',\n",416 " 'Namco',\n",417 " 'Naughty Dog',\n",418 " 'HAL Labs',\n",419 " 'EA Canada',\n",420 " 'EA LA',\n",421 " 'Epic Games',\n",422 " 'Pipeworks Software, Inc.',\n",423 " 'Rockstar San Diego',\n",424 " 'Retro Studios',\n",425 " 'Blizzard Entertainment',\n",426 " 'Reflections Interactive',\n",427 " 'Rare Ltd.',\n",428 " 'KCEJ',\n",429 " 'Kojima Productions',\n",430 " 'Square Enix',\n",431 " 'SCE/WWS, Media Molecule',\n",432 " 'Capcom',\n",433 " 'Level 5',\n",434 " \"Traveller's Tales\",\n",435 " 'Taito Corporation',\n",436 " 'Ubisoft Montreal',\n",437 " 'Turn 10',\n",438 " 'Rocksteady Studios',\n",439 " 'Intelligent Systems',\n",440 " 'Core Design Ltd.',\n",441 " 'EA Tiburon',\n",442 " 'Harmonix Music Systems',\n",443 " 'Lionhead Studios',\n",444 " 'Neversoft Entertainment',\n",445 " 'Neversoft Entertainment, BudCat',\n",446 " 'Naughty Dog, SCE/WWS',\n",447 " 'SCE Santa Monica',\n",448 " 'TT Fusion',\n",449 " 'Stormfront Studios',\n",450 " 'Bluepoint Games',\n",451 " 'Vicarious Visions',\n",452 " 'Next Level Games',\n",453 " 'Konami',\n",454 " 'Bethesda Softworks',\n",455 " 'Ubisoft Paris, Ubisoft Montpellier',\n",456 " 'High Moon Studios',\n",457 " 'Insomniac Games',\n",458 " 'Mass Media',\n",459 " 'Ready at Dawn',\n",460 " 'SCEE, Zoe Mode',\n",461 " 'Valve Software',\n",462 " 'Obsidian Entertainment',\n",463 " 'Cat Daddy Games',\n",464 " 'Digital Eclipse',\n",465 " 'CD Projekt Red Studio',\n",466 " 'Ubisoft, Ubisoft Montreal',\n",467 " 'Visual Concepts',\n",468 " 'Evolution Studios',\n",469 " 'KCET',\n",470 " 'SCEA, Zindagi Games',\n",471 " 'Nintendo, Namco Bandai Games',\n",472 " 'Massive Entertainment',\n",473 " 'Maxis',\n",474 " 'Argonaut Games',\n",475 " 'TOSE',\n",476 " 'Zipper Interactive',\n",477 " 'Pandemic Studios',\n",478 " 'Fox Interactive',\n",479 " 'Office Create',\n",480 " 'Team Soho',\n",481 " 'EA Redwood Shores',\n",482 " 'Certain Affinity',\n",483 " 'Agenda',\n",484 " 'Gearbox Software',\n",485 " 'Kojima Productions, Moby Dick Studio',\n",486 " 'Media Molecule',\n",487 " 'Eurocom Entertainment Software',\n",488 " 'Ubisoft Quebec',\n",489 " 'Double Helix Games',\n",490 " 'Rockstar Toronto',\n",491 " 'EA Games',\n",492 " 'Splash Damage, The Coalition',\n",493 " 'Luxoflux, Inc.',\n",494 " 'Shiny Entertainment',\n",495 " 'Team Bondi',\n",496 " '1st Playable Productions',\n",497 " 'Dimps Corporation, Sonic Team',\n",498 " 'Indies Zero',\n",499 " '4J Studios',\n",500 " 'BioWare',\n",501 " 'Dimps Corporation',\n",502 " 'Quantic Dream',\n",503 " 'Volition Inc.',\n",504 " 'Guerrilla',\n",505 " 'Junction Point',\n",506 " 'Spike, Namco Bandai Games',\n",507 " 'LucasArts, BioWare',\n",508 " 'Monolith Productions',\n",509 " 'Sonic Team',\n",510 " 'Io Interactive',\n",511 " 'Respawn Entertainment',\n",512 " 'Sucker Punch',\n",513 " 'Sumo Digital',\n",514 " 'Clap Hanz',\n",515 " 'OfficeCreate',\n",516 " 'Spark Unlimited',\n",517 " 'NetherRealm Studios',\n",518 " 'Irrational Games, 2K Marin',\n",519 " 'Majesco Games, Majesco',\n",520 " 'EA DICE, Danger Close',\n",521 " 'Virtual Toys',\n",522 " 'NuFX',\n",523 " 'Criterion Games',\n",524 " 'Toys for Bob',\n",525 " 'Warner Bros. Interactive Entertainment, NetherRealm Studios',\n",526 " 'Edge of Reality',\n",527 " 'LucasArts',\n",528 " 'Artoon',\n",529 " 'Namco Bandai Games',\n",530 " 'Dreamworks Interactive',\n",531 " 'Big Blue Box',\n",532 " 'DC Studios',\n",533 " 'Ubisoft Shanghai',\n",534 " 'Slightly Mad Studios',\n",535 " 'Team Fusion',\n",536 " 'Angel Studios',\n",537 " 'Ensemble Studios',\n",538 " 'Dice, Danger Close',\n",539 " 'syn Sophia',\n",540 " \"Yuke's\",\n",541 " 'Genius Sonority Inc.',\n",542 " 'Acclaim Studios Cheltenham',\n",543 " 'Headstrong Games',\n",544 " 'CAProduction',\n",545 " 'Raven Software',\n",546 " 'Midway',\n",547 " 'From Software',\n",548 " 'Black Rock Studio',\n",549 " 'Cyan Worlds',\n",550 " 'THQ',\n",551 " 'Rainbow Studios',\n",552 " 'Black Box',\n",553 " 'Bullfrog Productions',\n",554 " 'Konami Computer Entertainment Hawaii',\n",555 " 'Techland',\n",556 " 'Heavy Iron Studios',\n",557 " 'Frontier Developments',\n",558 " 'GREZZO',\n",559 " 'Rare Ltd., BigPark',\n",560 " 'ArenaNet',\n",561 " 'WB Games Montreal',\n",562 " 'HAL Labs, Creatures Inc.',\n",563 " 'Backbone Entertainment',\n",564 " 'Sega',\n",565 " 'Exakt',\n",566 " 'TT Games',\n",567 " '2K Marin',\n",568 " '5TH Cell',\n",569 " 'Beenox',\n",570 " 'Amaze Entertainment',\n",571 " 'Bizarre Creations',\n",572 " 'Omega Force',\n",573 " 'Visceral Games',\n",574 " 'Blue Planet Software',\n",575 " 'Matrix Software',\n",576 " 'Full Fat',\n",577 " 'Helixe',\n",578 " 'EA Vancouver',\n",579 " 'Ubisoft Montpellier',\n",580 " 'ChunSoft',\n",581 " 'Midway Studios - San Diego',\n",582 " 'Acquire',\n",583 " 'h.a.n.d. Inc.',\n",584 " 'Ghost Games',\n",585 " 'Check Six Games',\n",586 " 'PLAYGROUND, Playground Games',\n",587 " 'Aki Corp.',\n",588 " 'Flagship, HAL Labs',\n",589 " 'Jellyvision',\n",590 " 'Art',\n",591 " 'Irrational Games',\n",592 " 'Nintendo, Nd Cube',\n",593 " 'NanaOn-Sha',\n",594 " 'Factor 5',\n",595 " 'Papaya Studios',\n",596 " 'SCEI',\n",597 " 'Krome Studios',\n",598 " 'Avalanche Studios',\n",599 " 'Jupiter Corporation',\n",600 " 'Rockstar Studios',\n",601 " 'Altron',\n",602 " 'Creative Assembly',\n",603 " 'Sega AM2',\n",604 " 'Hangar 13',\n",605 " 'BudCat',\n",606 " 'Tango Gameworks',\n",607 " 'SCEE London Studio',\n",608 " 'Genuine Games',\n",609 " 'Team Ninja',\n",610 " 'Camelot Software Planning',\n",611 " 'Red Storm Entertainment',\n",612 " 'VIS Entertainment',\n",613 " 'Realtime Worlds',\n",614 " 'Monolith Soft',\n",615 " 'Terminal Reality',\n",616 " 'Ready at Dawn, SCE Santa Monica',\n",617 " 'SCE Japan Studio',\n",618 " 'ArtePiazza',\n",619 " 'Ubisoft Reflections, Ivory Tower',\n",620 " 'Tri-Ace',\n",621 " 'Arkane Studios',\n",622 " '3d6 Games',\n",623 " 'Magic Pockets',\n",624 " 'Artefacts Studio',\n",625 " 'Hello Games',\n",626 " 'Activision',\n",627 " 'Griptonite Games',\n",628 " 'Webfoot Technologies',\n",629 " 'Farsight Studios',\n",630 " 'Firaxis Games',\n",631 " 'Bandai Namco Games',\n",632 " 'Rebellion',\n",633 " 'Shaba Games',\n",634 " 'Artificial Mind and Movement',\n",635 " 'Paradigm Entertainment',\n",636 " 'EA Chicago',\n",637 " 'SuperMassive Games',\n",638 " 'HB Studios Multimedia',\n",639 " 'EA Sports Big',\n",640 " 'Spike',\n",641 " 'Ninja Theory',\n",642 " 'EA Montreal',\n",643 " 'id Software',\n",644 " 'Avalanche Software',\n",645 " 'Capcom Vancouver',\n",646 " 'Pivotal Games',\n",647 " 'MachineGames',\n",648 " '2K Czech',\n",649 " 'Mind Candy',\n",650 " 'Naughty Dog, Sony Bend',\n",651 " 'Cavia Inc.',\n",652 " 'The Code Monkeys',\n",653 " 'Amusement Vision',\n",654 " 'Genius Sonority Inc., Disney Interactive Studios',\n",655 " 'Sports Interactive',\n",656 " 'Genki',\n",657 " 'Blue Castle Games',\n",658 " 'Barking Lizards',\n",659 " 'Zoe Mode',\n",660 " 'Kush Games',\n",661 " 'Nihilistic',\n",662 " 'WayForward',\n",663 " 'Kaos Studios',\n",664 " 'Hellbent Games',\n",665 " 'Blitz Games',\n",666 " 'BigPark',\n",667 " 'Planet Moon Studios',\n",668 " 'Blue Byte, Related Designs',\n",669 " 'EA Bright Light',\n",670 " 'Digital Extremes, 2K Marin',\n",671 " 'Sand Grain Studios',\n",672 " 'Flagship',\n",673 " 'PlatinumGames',\n",674 " 'Danger Close',\n",675 " 'Barnstorm Games',\n",676 " 'Incognito Inc.',\n",677 " 'Exient Entertainment',\n",678 " 'Codemasters',\n",679 " 'Playground Games',\n",680 " 'Arzest',\n",681 " 'Crytek',\n",682 " 'Crystal Dynamics',\n",683 " 'Sega, Sonic Team',\n",684 " 'Z-Axis, Ltd.',\n",685 " 'Now Production',\n",686 " 'Eidos Montreal',\n",687 " 'Square Enix, Think and Feel',\n",688 " 'The Coalition',\n",689 " 'Pitbull Syndicate',\n",690 " 'Codemasters Birmingham',\n",691 " 'Rockstar Vienna',\n",692 " 'Remedy Entertainment',\n",693 " 'Steel Monkeys',\n",694 " 'Acclaim',\n",695 " 'Radical Entertainment',\n",696 " 'Good-Feel',\n",697 " 'SCEA',\n",698 " 'Namco Bandai Games America, Namco Bandai Games',\n",699 " 'Creatures Inc.',\n",700 " 'Pocket Studios',\n",701 " 'M2',\n",702 " 'Melbourne House',\n",703 " 'Ubisoft Sofia',\n",704 " 'ZeniMax Media',\n",705 " 'Snowblind Studios',\n",706 " 'Lexis Numerique, Virtual Toys',\n",707 " 'Opus, Project Sora',\n",708 " 'Nintendo, Spike Chunsoft',\n",709 " 'CyberConnect2',\n",710 " '3G Studios',\n",711 " 'Tamsoft',\n",712 " \"THQ, Yuke's\",\n",713 " 'Virtuos',\n",714 " 'Nixxes Software',\n",715 " 'Slant Six',\n",716 " 'Tarsier Studios, Double Eleven',\n",717 " 'Spike Chunsoft Co. Ltd., Spike Chunsoft',\n",718 " 'Chris Sawyer',\n",719 " '49Games',\n",720 " 'Oddworld Inhabitants',\n",721 " 'High Voltage Software',\n",722 " 'neo Software',\n",723 " 'Savage Entertainment',\n",724 " 'Nex Entertainment',\n",725 " 'Surreal Software',\n",726 " 'Climax Group',\n",727 " 'Locomotive Games',\n",728 " 'Nintendo, Nintendo Software Technology',\n",729 " 'Omega Force, Tecmo Koei Games',\n",730 " 'Light Weight',\n",731 " 'City Interactive',\n",732 " 'Vingt-et-un Systems',\n",733 " 'K2 LLC',\n",734 " 'Ambrella',\n",735 " 'Day 1 Studios',\n",736 " 'Level 5, Brownie Brown',\n",737 " 'United Front Games',\n",738 " 'Ryu ga Gotoku Studios',\n",739 " 'Atlus',\n",740 " 'Ruffian Games',\n",741 " 'Mercury Steam',\n",742 " 'MTO',\n",743 " 'EA Redwood Shores, EA Salt Lake',\n",744 " 'Sony Online Entertainment',\n",745 " 'Big Sky Software',\n",746 " 'Visual Impact',\n",747 " 'Ubisoft Shanghai/Paris',\n",748 " 'PopCap',\n",749 " 'Electronic Arts, Rebellion',\n",750 " 'SCEE',\n",751 " 'Page 44 Studios',\n",752 " 'FreeStyleGames',\n",753 " 'Mad Doc Software, Rockstar Vancouver',\n",754 " 'Blizzard North',\n",755 " 'Arika',\n",756 " 'Barnhouse Effect',\n",757 " 'Vigil Games',\n",758 " 'n-Space',\n",759 " 'Black Lantern Studios',\n",760 " 'Microsoft Game Studios',\n",761 " 'Sega AM3',\n",762 " 'Tecmo',\n",763 " '8ing/Raizing',\n",764 " 'Electronic Arts, EA Redwood Shores',\n",765 " 'Splash Damage',\n",766 " 'Studio Liverpool',\n",767 " 'Red Storm Entertainment, Ubisoft Paris',\n",768 " 'Tantalus Interactive, Tantatus, Nintendo',\n",769 " 'Crystal Dynamics, Nixxes Software',\n",770 " 'Avanquest Software',\n",771 " 'Bigbig Studios',\n",772 " 'EA Salt Lake',\n",773 " 'Longtail Studios',\n",774 " 'Powerhead Games',\n",775 " 'Epic Games, People Can Fly',\n",776 " 'Sega, Dimps Corporation',\n",777 " 'Koei',\n",778 " 'Hyde',\n",779 " 'Project Aces',\n",780 " 'Team Ninja, Tecmo',\n",781 " 'Razorworks Studios',\n",782 " '989 Sports',\n",783 " 'UBlart Montpellier',\n",784 " 'Free Radical Design',\n",785 " 'DreamFactory',\n",786 " 'Incinerator Games',\n",787 " 'Route 1 Games',\n",788 " 'Rockstar London',\n",789 " 'Ubisoft Toronto',\n",790 " 'Double Fine Productions',\n",791 " 'Turtle Rock Studios',\n",792 " 'Giants Software',\n",793 " 'Vicarious Visions, Neversoft Entertainment',\n",794 " 'Blue Tongue Entertainment',\n",795 " 'Overworks',\n",796 " 'Monster Games Inc.',\n",797 " 'Atari',\n",798 " 'Coresoft',\n",799 " 'SuperBot Entertainment',\n",800 " 'Ubisoft Reflections',\n",801 " 'Monkey Bar Games',\n",802 " 'Alfa System',\n",803 " 'Buzz Monkey',\n",804 " 'Rockstar Vancouver',\n",805 " 'SCEA San Diego Studios',\n",806 " 'Neko Entertainment',\n",807 " 'Square Enix, h.a.n.d. Inc.',\n",808 " 'UDS',\n",809 " 'KCE Studios',\n",810 " 'Titus Software',\n",811 " 'Black Ops Entertainment',\n",812 " 'ImaginEngine',\n",813 " 'Tantalus Interactive',\n",814 " 'Mistwalker, Artoon',\n",815 " 'Marvelous AQL',\n",816 " 'Xpec',\n",817 " 'Mistwalker',\n",818 " 'Blitz Games Studios',\n",819 " 'KCEK',\n",820 " 'Sony Bend',\n",821 " 'RED Entertainment',\n",822 " 'FASA Studio',\n",823 " 'Runecraft',\n",824 " 'Big Huge Games',\n",825 " 'Media Molecule, United Front Games',\n",826 " 'SCi',\n",827 " 'Cooking Mama Limited',\n",828 " 'Disney Interactive Studios',\n",829 " 'Red Fly Studio',\n",830 " 'Cygames',\n",831 " 'Rage Software',\n",832 " 'Toolbox Design',\n",833 " 'Team 17',\n",834 " 'Dimps Corporation, Namco Bandai Games',\n",835 " 'Land Ho!',\n",836 " 'Asobo Studio',\n",837 " 'Eutechnyx',\n",838 " 'Gearbox Software, 3D Realms',\n",839 " 'Digital Anvil',\n",840 " 'Treyarch, Sledgehammer Games',\n",841 " 'Marvelous Entertainment',\n",842 " 'EA Seattle',\n",843 " 'Big Blue Bubble Inc.',\n",844 " 'Indie Built',\n",845 " 'Ludia Inc.',\n",846 " 'Evolution Games',\n",847 " 'Atlus Co.',\n",848 " 'Capcom, Pipeworks Software, Inc.',\n",849 " 'Gevo Entertainment',\n",850 " 'Gorilla Systems',\n",851 " 'Guerilla Cambridge',\n",852 " 'Marvelous',\n",853 " 'Gorilla Games',\n",854 " 'Deibus Studios',\n",855 " 'Square Enix, Tri-Ace',\n",856 " 'Novarama',\n",857 " 'Sumo Digital, Playground Games',\n",858 " 'Trilobyte',\n",859 " 'Silicon Knights',\n",860 " 'Digital Illusions',\n",861 " 'Kush Games, Visual Concepts',\n",862 " 'iNiS',\n",863 " 'EA Canada, Nihilistic',\n",864 " 'Eden Studios',\n",865 " 'David A. Palmer Productions',\n",866 " 'Artificial Mind and Movement, Polygon Magic',\n",867 " 'Acclaim Studios Austin',\n",868 " 'Tetris Online, Inc',\n",869 " 'Dancing Dots',\n",870 " 'Piranha Games',\n",871 " 'LucasArts, Red Fly Studio',\n",872 " 'Game Republic',\n",873 " 'Project Soul',\n",874 " 'Kouyousha',\n",875 " 'Propaganda Games',\n",876 " 'JGI Entertainment',\n",877 " 'Digital Extremes',\n",878 " 'Brownie Brown',\n",879 " 'Natsume',\n",880 " 'Arc System Works',\n",881 " 'Takara',\n",882 " 'CyberConnect2, Racjin',\n",883 " 'Dearsoft',\n",884 " 'Paradox Development',\n",885 " '2K Australia',\n",886 " 'Realism Ltd',\n",887 " 'Bandai',\n",888 " 'Human Soft',\n",889 " 'Jester Interactive',\n",890 " 'Equinoxe',\n",891 " 'Pacific Coast Power & Light',\n",892 " 'Koei, Omega Force',\n",893 " 'id Software, Nerve Software',\n",894 " 'Eighting, Genius Sonority Inc.',\n",895 " 'Reality Pump',\n",896 " 'Virtucraft',\n",897 " 'Illusion Softworks',\n",898 " 'SCEA, Sims',\n",899 " 'Kalypso',\n",900 " 'Midway Studios - Los Angeles',\n",901 " 'Ubisoft Milan',\n",902 " 'Fuse Games Limited',\n",903 " 'Pyramid',\n",904 " 'Hypnos Entertainment',\n",905 " 'Black Isle Studios',\n",906 " 'Gaijin Entertainment',\n",907 " 'Eden',\n",908 " 'Blue Fang Games',\n",909 " 'Sanzaru Games',\n",910 " 'Tomy Corporation',\n",911 " 'Secret Level',\n",912 " 'Nerve Software',\n",913 " 'Trion Worlds',\n",914 " 'BioWare, Demiurge Studios',\n",915 " 'Engine Software',\n",916 " 'RED Entertainment, Artdink',\n",917 " 'Cunning Developments',\n",918 " 'Starbreeze',\n",919 " 'Delphine Software International',\n",920 " 'Gameloft',\n",921 " 'Grasshopper Manufacture',\n",922 " 'Shift, Bandai Namco Games',\n",923 " 'Dimps Corporation, SCE Japan Studio',\n",924 " 'Krome Studios, Screenlife Games',\n",925 " 'Suzak',\n",926 " 'Iron Galaxy Studios',\n",927 " 'GenePool',\n",928 " 'Ubisoft Casablanca',\n",929 " 'Epicenter Studios',\n",930 " 'KCEA',\n",931 " 'Adrenium',\n",932 " 'Juice Games',\n",933 " 'id Software, Raven Software',\n",934 " 'SEGA Racing Studio',\n",935 " 'Clover Studio',\n",936 " 'SuperVillain Studios',\n",937 " 'EA Sports, EA Canada',\n",938 " 'MagicWand',\n",939 " 'Media Vision, Contrail',\n",940 " 'Paon Corporation',\n",941 " 'Lab Rats Games',\n",942 " 'Vicious Cycle',\n",943 " 'Cinegroupe',\n",944 " 'High Impact Games',\n",945 " 'Skyworks Technologies',\n",946 " 'Robomodo',\n",947 " 'Ascaron Entertainment GmbH, Ascaron Entertainment',\n",948 " '2K Sports',\n",949 " 'FUN Labs',\n",950 " 'Appaloosa Interactive',\n",951 " 'Vanillaware',\n",952 " 'Endemol',\n",953 " 'Dreamworks Games',\n",954 " 'Atomic Planet Entertainment',\n",955 " 'Coldwood Interactive',\n",956 " 'Valuewave Co.,Ltd.',\n",957 " 'Pam Development',\n",958 " 'Ubisoft Romania',\n",959 " 'Spicy Horse',\n",960 " 'Overkill Software',\n",961 " 'Midway Studios - Austin',\n",962 " 'Bunkasha Publishing',\n",963 " 'Nippon Ichi Software',\n",964 " 'Neverland',\n",965 " 'Silicon Studio',\n",966 " 'Namco Bandai Games, Bandai Namco Games',\n",967 " 'Vanilla Ware',\n",968 " 'Full-Fat',\n",969 " 'Etranges Libellules',\n",970 " 'Relic',\n",971 " 'Collision Studios',\n",972 " 'Anchor',\n",973 " 'Racjin',\n",974 " 'Magenta Software',\n",975 " 'Awesome Studios',\n",976 " 'Behaviour Interactive',\n",977 " 'Pipe Dream Interactive',\n",978 " 'Bullets',\n",979 " 'Aspect',\n",980 " 'Deep Space',\n",981 " 'Inti',\n",982 " 'Bam Entertainment',\n",983 " 'THQ Digital Studio Phoenix',\n",984 " 'Brain Toys',\n",985 " 'Hothouse Creations',\n",986 " 'Nuevo Retro Games',\n",987 " 'Digital Kids',\n",988 " 'Yager',\n",989 " 'Omega Force, Koei Tecmo Games',\n",990 " '4A Games',\n",991 " 'Cing',\n",992 " 'WXP',\n",993 " 'Cerasus Media',\n",994 " 'Inevitable Entertainment',\n",995 " 'Destineer',\n",996 " 'Eighting',\n",997 " 'SCEA Sports Studio',\n",998 " 'Keen Games',\n",999 " 'Storm City Games',\n",1000 " 'ValuSoft',\n",1001 " 'High Voltage Software, Ubisoft Paris',\n",1002 " 'GRIN',\n",1003 " 'Q-Games',\n",1004 " 'Raster',\n",1005 " 'Vivarium',\n",1006 " 'VU Games',\n",1007 " 'Machatin, Inc.',\n",1008 " 'Point of View',\n",1009 " 'City Interactive, Deck 13',\n",1010 " 'T&E Soft',\n",1011 " 'Climax Group, Climax Studios',\n",1012 " 'HexaDrive',\n",1013 " 'Jupiter Corporation, Jupiter Multimedia',\n",1014 " 'Blade Interactive',\n",1015 " 'Factor 5, SCE/WWS',\n",1016 " 'SCE Japan Studio, comcept',\n",1017 " 'WBIE',\n",1018 " 'Warthog',\n",1019 " 'AWE Games',\n",1020 " 'Contraband Entertainment',\n",1021 " 'Eugen Systems',\n",1022 " 'Quest',\n",1023 " 'Kuusou Kagaku',\n",1024 " 'HandMade Game',\n",1025 " '7 Studios',\n",1026 " 'Blue Tongue',\n",1027 " 'SCS Software',\n",1028 " 'Humongous Entertainment',\n",1029 " 'Pocketeers',\n",1030 " 'Harmonix Music Systems, Backbone Entertainment',\n",1031 " 'Scholastic, Inc.',\n",1032 " 'Screenlife Games, WXP',\n",1033 " 'Totally Games',\n",1034 " 'Ratbag',\n",1035 " 'SCEJ',\n",1036 " 'Razorworks',\n",1037 " 'New',\n",1038 " 'Beyond Games',\n",1039 " 'Teyon',\n",1040 " 'Ubisoft Barcelona, Ubisoft Reflections',\n",1041 " 'Eurocom Entertainment Software, Visceral Games',\n",1042 " 'Nintendo, Headstrong Games',\n",1043 " \"Shin'en\",\n",1044 " 'Creations',\n",1045 " 'Crave',\n",1046 " 'Vatra',\n",1047 " 'Treasure',\n",1048 " 'Human Soft, Ivolgamus',\n",1049 " 'Eighting/Raizing',\n",1050 " '505 Games',\n",1051 " 'Studio Gigante',\n",1052 " 'Wideload Games Inc.',\n",1053 " 'Farsight Studios, Crave',\n",1054 " 'Computer Artworks',\n",1055 " 'Saffire',\n",1056 " 'Nintendo, Camelot Software Planning',\n",1057 " 'Team 17, Two Tribes',\n",1058 " 'Square Enix, TOSE',\n",1059 " 'Kuju Entertainment',\n",1060 " 'Humagade',\n",1061 " 'Q Entertainment',\n",1062 " 'Tri-Crescendo',\n",1063 " 'Tenyo',\n",1064 " 'LucasArts, Krome Studios',\n",1065 " 'Idea Factory, Compile Heart',\n",1066 " 'Kamui',\n",1067 " 'Ubisoft, Sensory Sweep',\n",1068 " 'War Drum Studios',\n",1069 " 'TOYBOX',\n",1070 " 'Sunrise Interactive',\n",1071 " 'Hijinx Studios',\n",1072 " 'Game Machine Studios',\n",1073 " 'Mastiff',\n",1074 " 'Gust',\n",1075 " 'Ritual Entertainment, Avalanche Software',\n",1076 " 'D3Publisher',\n",1077 " 'Psygnosis',\n",1078 " 'Armature Studio',\n",1079 " 'RedLynx',\n",1080 " 'Creat Studios',\n",1081 " 'Phoenix Games Studio',\n",1082 " 'Nintendo, Intelligent Systems',\n",1083 " 'Telegames',\n",1084 " 'Bluehole Studio',\n",1085 " 'Spike Chunsoft',\n",1086 " 'Red Storm Entertainment, Ubisoft Montreal',\n",1087 " 'Saber Interactive',\n",1088 " 'Idol Minds',\n",1089 " 'Maximum Games',\n",1090 " 'Knowledge Adventure Inc.',\n",1091 " 'Harmonix Music Systems, Demiurge Studios',\n",1092 " 'Shift',\n",1093 " 'Torus Games',\n",1094 " 'Triumph Studios',\n",1095 " 'DONTNOD Entertainment',\n",1096 " 'Twisted Pixel Games',\n",1097 " 'Zoo Games',\n",1098 " 'Zen Studios',\n",1099 " 'Victor Interactive Software',\n",1100 " 'Frogwares, Mistic Software',\n",1101 " 'Firebrand Games',\n",1102 " 'Prope',\n",1103 " 'Wow Entertainment',\n",1104 " 'Monolith Soft, Banpresto',\n",1105 " 'Sega Studios San Francisco',\n",1106 " 'Ganbarion',\n",1107 " 'Milestone S.r.l',\n",1108 " 'Red Tribe',\n",1109 " 'Red Zone Entertainment',\n",1110 " 'Amuze',\n",1111 " 'Uacari',\n",1112 " 'Bugbear',\n",1113 " 'Cyberlore Studios',\n",1114 " 'Lightning Fish Games',\n",1115 " 'Crafts & Meister',\n",1116 " 'Open Sesame',\n",1117 " '3DO',\n",1118 " 'Blueside',\n",1119 " 'Arcade Moon',\n",1120 " 'Noise Inc.',\n",1121 " '2K Games',\n",1122 " 'Psyonix',\n",1123 " 'Playbox Limited',\n",1124 " 'Takara Tomy',\n",1125 " 'KCEO',\n",1126 " 'Zombie Studios',\n",1127 " 'Bandai Namco Games, Artdink',\n",1128 " 'Pax Softonica',\n",1129 " 'Zener Works',\n",1130 " 'RED Entertainment, Spike Chunsoft',\n",1131 " 'Cattle Call',\n",1132 " 'Inland Productions',\n",1133 " 'Take-Two Interactive',\n",1134 " 'CokeM Interactive',\n",1135 " 'ITL',\n",1136 " 'Sandlot',\n",1137 " 'Hypnotix',\n",1138 " 'Vir2L Studios',\n",1139 " 'Airtight Games',\n",1140 " 'Deep Silver Dambuster Studios',\n",1141 " 'WildTangent',\n",1142 " 'Destination Software',\n",1143 " 'Brash Entertainment',\n",1144 " 'Haemimont',\n",1145 " 'High Voltage Software, Backbone Entertainment',\n",1146 " 'Nadeo',\n",1147 " 'Impulse Games',\n",1148 " 'Sennari Interactive',\n",1149 " 'Gas Powered Games',\n",1150 " 'Tantatus',\n",1151 " 'Starfish',\n",1152 " 'Buena Vista Interactive',\n",1153 " 'Cohort Studios',\n",1154 " 'Ubisoft, Powerhead Games',\n",1155 " 'EA Canada, EA Vancouver',\n",1156 " 'Inti Creates',\n",1157 " 'Fizz Factor',\n",1158 " 'Ion Storm',\n",1159 " 'SNK Playmore',\n",1160 " 'Smart Bomb Interactive',\n",1161 " 'Amaze Entertainment, Griptonite Games',\n",1162 " 'SunSoft',\n",1163 " 'Lancarse, Atlus',\n",1164 " 'Capcom, Klein Computer Entertainment',\n",1165 " 'Terminal Reality, 4mm Games',\n",1166 " 'AI',\n",1167 " 'Eidos Interactive',\n",1168 " 'Smack Down Productions',\n",1169 " 'Nobilis',\n",1170 " 'Polygon Magic',\n",1171 " 'Buzz Monkey, EA Montreal',\n",1172 " 'Atlus, Dingo Inc.',\n",1173 " 'Opus',\n",1174 " 'Venom Games',\n",1175 " 'Game Republic, JapanStudio',\n",1176 " 'CodeFire',\n",1177 " 'Phantagram',\n",1178 " 'Mercury Steam, Alchemic Productions',\n",1179 " 'SScholastic Media',\n",1180 " 'Access Games',\n",1181 " 'Image Epoch, Imageepoch',\n",1182 " 'Human Head Studios',\n",1183 " 'Big Red Button Entertainment',\n",1184 " 'Blue Byte',\n",1185 " 'Wildfire Studios',\n",1186 " 'MumboJumbo',\n",1187 " 'Sidhe Interactive',\n",1188 " 'Inti, Inti Creates',\n",1189 " 'Magix',\n",1190 " 'Mucky Foot Productions',\n",1191 " 'Denyu-Sha',\n",1192 " 'Ronin Entertainment',\n",1193 " 'Disney Interactive',\n",1194 " 'Artdink',\n",1195 " 'Shade',\n",1196 " 'Prolific',\n",1197 " 'SCE Studio Cambridge',\n",1198 " 'Sinister Games',\n",1199 " 'Banpresto, SoftMax',\n",1200 " 'Mahou',\n",