"text/plain": " app_id app_name \\\n6417086 99910 Puzzle Pirates \n6417087 99910 Puzzle Pirates \n6417088 99910 Puzzle Pirates \n6417089 99910 Puzzle Pirates \n6417090 99910 Puzzle Pirates \n6417091 99910 Puzzle Pirates \n6417092 99910 Puzzle Pirates \n6417093 99910 Puzzle Pirates \n6417094 99910 Puzzle Pirates \n6417095 99910 Puzzle Pirates \n6417096 99910 Puzzle Pirates \n6417097 99910 Puzzle Pirates \n6417098 99910 Puzzle Pirates \n6417099 99910 Puzzle Pirates \n6417100 99910 Puzzle Pirates \n6417101 99910 Puzzle Pirates \n6417102 99910 Puzzle Pirates \n6417103 99910 Puzzle Pirates \n6417104 99910 Puzzle Pirates \n6417105 99910 Puzzle Pirates \n\n review_text review_score \\\n6417086 Reminds me of the games I played in elementary... -1 \n6417087 I dont like this game -1 \n6417088 The actual game play of Puzzle Pirates is grea... -1 \n6417089 Rating based on current state of play, as per ... -1 \n6417090 This is just appalling. -1 \n6417091 Set my age as less than 5 by mistake. Apparent... -1 \n6417092 It is terrible because I cant ge on because of... -1 \n6417093 Was fun for the first 30 minutes or so, got bo... -1 \n6417094 The game is very awefull and strange. I think ... -1 \n6417095 A very good game, got sick of it after a while... -1 \n6417096 Imagine Bejeweled with a heavy grind based eco... -1 \n6417097 This game has some serious problems. First of ... -1 \n6417098 This game is good but also horrible. Its fun t... -1 \n6417099 A very good game, got sick of it after a while... -1 \n6417100 This game is good but also horrible. Its fun t... -1 \n6417101 I really ove this game but it needs somethings... -1 \n6417102 Used to play Puzzel Pirates 'way back when', b... -1 \n6417103 This game was aright, though a bit annoying. W... -1 \n6417104 I had a nice review to recommend this game, bu... -1 \n6417105 The puzzles in this game are fun, but you have... -1 \n\n review_votes \n6417086 0 \n6417087 0 \n6417088 0 \n6417089 0 \n6417090 0 \n6417091 0 \n6417092 0 \n6417093 0 \n6417094 0 \n6417095 1 \n6417096 0 \n6417097 0 \n6417098 0 \n6417099 1 \n6417100 0 \n6417101 0 \n6417102 0 \n6417103 0 \n6417104 0 \n6417105 0 ",
"text/html": "<div>\n<style scoped>\n .dataframe tbody tr th:only-of-type {\n vertical-align: middle;\n }\n\n .dataframe tbody tr th {\n vertical-align: top;\n }\n\n .dataframe thead th {\n text-align: right;\n }\n</style>\n<table border=\"1\" class=\"dataframe\">\n <thead>\n <tr style=\"text-align: right;\">\n <th></th>\n <th>app_id</th>\n <th>app_name</th>\n <th>review_text</th>\n <th>review_score</th>\n <th>review_votes</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>6417086</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>Reminds me of the games I played in elementary...</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417087</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>I dont like this game</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417088</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>The actual game play of Puzzle Pirates is grea...</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417089</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>Rating based on current state of play, as per ...</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417090</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>This is just appalling.</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417091</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>Set my age as less than 5 by mistake. Apparent...</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417092</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>It is terrible because I cant ge on because of...</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417093</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>Was fun for the first 30 minutes or so, got bo...</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417094</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>The game is very awefull and strange. I think ...</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417095</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>A very good game, got sick of it after a while...</td>\n <td>-1</td>\n <td>1</td>\n </tr>\n <tr>\n <th>6417096</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>Imagine Bejeweled with a heavy grind based eco...</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417097</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>This game has some serious problems. First of ...</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417098</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>This game is good but also horrible. Its fun t...</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417099</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>A very good game, got sick of it after a while...</td>\n <td>-1</td>\n <td>1</td>\n </tr>\n <tr>\n <th>6417100</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>This game is good but also horrible. Its fun t...</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417101</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>I really ove this game but it needs somethings...</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417102</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>Used to play Puzzel Pirates 'way back when', b...</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417103</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>This game was aright, though a bit annoying. W...</td>\n <td>-1</td>\n <td>0</t
"text/plain": " app_id app_name \\\n0 10 Counter-Strike \n1 10 Counter-Strike \n2 10 Counter-Strike \n3 10 Counter-Strike \n4 10 Counter-Strike \n... ... ... \n6417101 99910 Puzzle Pirates \n6417102 99910 Puzzle Pirates \n6417103 99910 Puzzle Pirates \n6417104 99910 Puzzle Pirates \n6417105 99910 Puzzle Pirates \n\n review_text review_score \\\n0 Ruined my life. 1 \n1 This will be more of a ''my experience with th... 1 \n2 This game saved my virginity. 1 \n3 • Do you like original games? • Do you like ga... 1 \n4 Easy to learn, hard to master. 1 \n... ... ... \n6417101 I really ove this game but it needs somethings... -1 \n6417102 Used to play Puzzel Pirates 'way back when', b... -1 \n6417103 This game was aright, though a bit annoying. W... -1 \n6417104 I had a nice review to recommend this game, bu... -1 \n6417105 The puzzles in this game are fun, but you have... -1 \n\n review_votes \n0 0 \n1 1 \n2 0 \n3 0 \n4 1 \n... ... \n6417101 0 \n6417102 0 \n6417103 0 \n6417104 0 \n6417105 0 \n\n[6226728 rows x 5 columns]",
"text/html": "<div>\n<style scoped>\n .dataframe tbody tr th:only-of-type {\n vertical-align: middle;\n }\n\n .dataframe tbody tr th {\n vertical-align: top;\n }\n\n .dataframe thead th {\n text-align: right;\n }\n</style>\n<table border=\"1\" class=\"dataframe\">\n <thead>\n <tr style=\"text-align: right;\">\n <th></th>\n <th>app_id</th>\n <th>app_name</th>\n <th>review_text</th>\n <th>review_score</th>\n <th>review_votes</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>0</th>\n <td>10</td>\n <td>Counter-Strike</td>\n <td>Ruined my life.</td>\n <td>1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>1</th>\n <td>10</td>\n <td>Counter-Strike</td>\n <td>This will be more of a ''my experience with th...</td>\n <td>1</td>\n <td>1</td>\n </tr>\n <tr>\n <th>2</th>\n <td>10</td>\n <td>Counter-Strike</td>\n <td>This game saved my virginity.</td>\n <td>1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>3</th>\n <td>10</td>\n <td>Counter-Strike</td>\n <td>• Do you like original games? • Do you like ga...</td>\n <td>1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>4</th>\n <td>10</td>\n <td>Counter-Strike</td>\n <td>Easy to learn, hard to master.</td>\n <td>1</td>\n <td>1</td>\n </tr>\n <tr>\n <th>...</th>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n <td>...</td>\n </tr>\n <tr>\n <th>6417101</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>I really ove this game but it needs somethings...</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417102</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>Used to play Puzzel Pirates 'way back when', b...</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417103</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>This game was aright, though a bit annoying. W...</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417104</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>I had a nice review to recommend this game, bu...</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n <tr>\n <th>6417105</th>\n <td>99910</td>\n <td>Puzzle Pirates</td>\n <td>The puzzles in this game are fun, but you have...</td>\n <td>-1</td>\n <td>0</td>\n </tr>\n </tbody>\n</table>\n<p>6226728 rows × 5 columns</p>\n</div>"
"text/plain": "review_text\n Early Access Review 977399\n Early Access Review 10571\n10/10 6050\n. 4769\nGreat game 3662\ngreat game 3554\nGreat game! 2440\n:) 2093\nNice game 1793\nGreat Game 1659\n♥♥♥♥ 1645\nGreat game. 1633\ncool 1502\n... 1247\nits good 974\nGreat Game! 924\n9/10 889\n8/10 747\nGreat 746\ni love this game 720\nName: count, dtype: int64"
"text/plain": " review_text review_score\n0 I'm the biggest fan you will ever meet of tile... -1\n1 Really an improvement on the old game (Which w... 1\n2 celebrating the four year birthday of payday w... -1\n3 Only fun when playing with friends. Can't join... -1\n4 While smashing planets together can be fun, th... -1",
"text/html": "<div>\n<style scoped>\n .dataframe tbody tr th:only-of-type {\n vertical-align: middle;\n }\n\n .dataframe tbody tr th {\n vertical-align: top;\n }\n\n .dataframe thead th {\n text-align: right;\n }\n</style>\n<table border=\"1\" class=\"dataframe\">\n <thead>\n <tr style=\"text-align: right;\">\n <th></th>\n <th>review_text</th>\n <th>review_score</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>0</th>\n <td>I'm the biggest fan you will ever meet of tile...</td>\n <td>-1</td>\n </tr>\n <tr>\n <th>1</th>\n <td>Really an improvement on the old game (Which w...</td>\n <td>1</td>\n </tr>\n <tr>\n <th>2</th>\n <td>celebrating the four year birthday of payday w...</td>\n <td>-1</td>\n </tr>\n <tr>\n <th>3</th>\n <td>Only fun when playing with friends. Can't join...</td>\n <td>-1</td>\n </tr>\n <tr>\n <th>4</th>\n <td>While smashing planets together can be fun, th...</td>\n <td>-1</td>\n </tr>\n </tbody>\n</table>\n</div>"
},
"execution_count": 148,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"train.head()"
],
"metadata": {
"collapsed": false
}
},
{
"cell_type": "code",
"execution_count": 149,
"outputs": [
{
"data": {
"text/plain": " review_text review_score\n1265039 I love the Fact you can do what EVER you want ... 1\n3132003 Tony Hawk's without the Pro Skater. Finding ou... 1\n880195 It's pretty good. 1\n717128 This the best dungeon game I have played since... 1\n5221356 Totally awesome game alone or with a friend. I... 1",
"text/html": "<div>\n<style scoped>\n .dataframe tbody tr th:only-of-type {\n vertical-align: middle;\n }\n\n .dataframe tbody tr th {\n vertical-align: top;\n }\n\n .dataframe thead th {\n text-align: right;\n }\n</style>\n<table border=\"1\" class=\"dataframe\">\n <thead>\n <tr style=\"text-align: right;\">\n <th></th>\n <th>review_text</th>\n <th>review_score</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>1265039</th>\n <td>I love the Fact you can do what EVER you want ...</td>\n <td>1</td>\n </tr>\n <tr>\n <th>3132003</th>\n <td>Tony Hawk's without the Pro Skater. Finding ou...</td>\n <td>1</td>\n </tr>\n <tr>\n <th>880195</th>\n <td>It's pretty good.</td>\n <td>1</td>\n </tr>\n <tr>\n <th>717128</th>\n <td>This the best dungeon game I have played since...</td>\n <td>1</td>\n </tr>\n <tr>\n <th>5221356</th>\n <td>Totally awesome game alone or with a friend. I...</td>\n <td>1</td>\n </tr>\n </tbody>\n</table>\n</div>"
},
"execution_count": 149,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"test.head()"
],
"metadata": {
"collapsed": false
}
},
{
"cell_type": "code",
"execution_count": 150,
"outputs": [
{
"data": {
"text/plain": " review_text review_score\n5012153 ..it's like nights into dreams and treasures o... 1\n5818758 As someone who mostly just likes making cool s... 1\n4582102 What can I say about this game the story is sh... 1\n5242842 A very unique and enjoyable puzzle solving str... 1\n5400923 A very adorable, charming game. 1",
"text/html": "<div>\n<style scoped>\n .dataframe tbody tr th:only-of-type {\n vertical-align: middle;\n }\n\n .dataframe tbody tr th {\n vertical-align: top;\n }\n\n .dataframe thead th {\n text-align: right;\n }\n</style>\n<table border=\"1\" class=\"dataframe\">\n <thead>\n <tr style=\"text-align: right;\">\n <th></th>\n <th>review_text</th>\n <th>review_score</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>5012153</th>\n <td>..it's like nights into dreams and treasures o...</td>\n <td>1</td>\n </tr>\n <tr>\n <th>5818758</th>\n <td>As someone who mostly just likes making cool s...</td>\n <td>1</td>\n </tr>\n <tr>\n <th>4582102</th>\n <td>What can I say about this game the story is sh...</td>\n <td>1</td>\n </tr>\n <tr>\n <th>5242842</th>\n <td>A very unique and enjoyable puzzle solving str...</td>\n <td>1</td>\n </tr>\n <tr>\n <th>5400923</th>\n <td>A very adorable, charming game.</td>\n <td>1</td>\n </tr>\n </tbody>\n</table>\n</div>"
