Skip to content

Instantly share code, notes, and snippets.

@zhuang-hao-ming

zhuang-hao-ming/main.ipynb

Last active July 15, 2018 14:29
Show Gist options
  • Save zhuang-hao-ming/5205dac69558f5a0f84ec6f07c8d8988 to your computer and use it in GitHub Desktop.
Save zhuang-hao-ming/5205dac69558f5a0f84ec6f07c8d8988 to your computer and use it in GitHub Desktop.
Download ZIP
pandas备忘
Display the source blob
Display the rendered blob
Raw
main.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>score_phrase</th>\n",
" <th>title</th>\n",
" <th>url</th>\n",
" <th>platform</th>\n",
" <th>score</th>\n",
" <th>genre</th>\n",
" <th>editors_choice</th>\n",
" <th>release_year</th>\n",
" <th>release_month</th>\n",
" <th>release_day</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>17137</th>\n",
" <td>Amazing</td>\n",
" <td>Gone Home</td>\n",
" <td>/games/gone-home/xbox-one-20014361</td>\n",
" <td>Xbox One</td>\n",
" <td>9.5</td>\n",
" <td>Simulation</td>\n",
" <td>Y</td>\n",
" <td>2013</td>\n",
" <td>8</td>\n",
" <td>15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17197</th>\n",
" <td>Amazing</td>\n",
" <td>Rayman Legends</td>\n",
" <td>/games/rayman-legends/xbox-one-20008449</td>\n",
" <td>Xbox One</td>\n",
" <td>9.5</td>\n",
" <td>Platformer</td>\n",
" <td>Y</td>\n",
" <td>2013</td>\n",
" <td>8</td>\n",
" <td>26</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17295</th>\n",
" <td>Amazing</td>\n",
" <td>LEGO Marvel Super Heroes</td>\n",
" <td>/games/lego-marvel-super-heroes/xbox-one-20000826</td>\n",
" <td>Xbox One</td>\n",
" <td>9.0</td>\n",
" <td>Action</td>\n",
" <td>Y</td>\n",
" <td>2013</td>\n",
" <td>10</td>\n",
" <td>22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17313</th>\n",
" <td>Great</td>\n",
" <td>Dead Rising 3</td>\n",
" <td>/games/dead-rising-3/xbox-one-124306</td>\n",
" <td>Xbox One</td>\n",
" <td>8.3</td>\n",
" <td>Action</td>\n",
" <td>N</td>\n",
" <td>2013</td>\n",
" <td>11</td>\n",
" <td>18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17317</th>\n",
" <td>Great</td>\n",
" <td>Killer Instinct</td>\n",
" <td>/games/killer-instinct-2013/xbox-one-20000538</td>\n",
" <td>Xbox One</td>\n",
" <td>8.4</td>\n",
" <td>Fighting</td>\n",
" <td>N</td>\n",
" <td>2013</td>\n",
" <td>11</td>\n",
" <td>18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17328</th>\n",
" <td>Great</td>\n",
" <td>Call of Duty: Ghosts</td>\n",
" <td>/games/call-of-duty-ghosts/xbox-one-163214</td>\n",
" <td>Xbox One</td>\n",
" <td>8.8</td>\n",
" <td>Shooter</td>\n",
" <td>N</td>\n",
" <td>2013</td>\n",
" <td>11</td>\n",
" <td>5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17335</th>\n",
" <td>Good</td>\n",
" <td>Madden NFL 25</td>\n",
" <td>/games/madden-nfl-2014/xbox-one-169583</td>\n",
" <td>Xbox One</td>\n",
" <td>7.6</td>\n",
" <td>Sports</td>\n",
" <td>N</td>\n",
" <td>2013</td>\n",
" <td>11</td>\n",
" <td>15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17358</th>\n",
" <td>Great</td>\n",
" <td>Assassin's Creed IV: Black Flag</td>\n",
" <td>/games/assassins-creed-black-flag/xbox-one-161677</td>\n",
" <td>Xbox One</td>\n",
" <td>8.5</td>\n",
" <td>Action, Adventure</td>\n",
" <td>N</td>\n",
" <td>2013</td>\n",
" <td>10</td>\n",
" <td>29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17361</th>\n",
" <td>Great</td>\n",
" <td>Battlefield 4</td>\n",
" <td>/games/battlefield-4/xbox-one-161397</td>\n",
" <td>Xbox One</td>\n",
" <td>8.5</td>\n",
" <td>Shooter</td>\n",
" <td>N</td>\n",
" <td>2013</td>\n",
" <td>11</td>\n",
" <td>26</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17367</th>\n",
" <td>Great</td>\n",
" <td>NBA 2K14</td>\n",
" <td>/games/nba-2k14/xbox-one-20000632</td>\n",
" <td>Xbox One</td>\n",
" <td>8.9</td>\n",
" <td>Sports</td>\n",
" <td>N</td>\n",
" <td>2013</td>\n",
" <td>11</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17391</th>\n",
" <td>Great</td>\n",
" <td>Need for Speed Rivals</td>\n",
" <td>/games/need-for-speed-rivals/xbox-one-170808</td>\n",
" <td>Xbox One</td>\n",
" <td>8.0</td>\n",
" <td>Racing</td>\n",
" <td>N</td>\n",
" <td>2013</td>\n",
" <td>11</td>\n",
" <td>20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17393</th>\n",
" <td>Great</td>\n",
" <td>Forza Motorsport 5</td>\n",
" <td>/games/forza-motorsport-5/xbox-one-169062</td>\n",
" <td>Xbox One</td>\n",
" <td>8.8</td>\n",
" <td>Racing</td>\n",
" <td>Y</td>\n",
" <td>2013</td>\n",
" <td>11</td>\n",
" <td>20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17445</th>\n",
" <td>Amazing</td>\n",
" <td>FIFA 14</td>\n",
" <td>/games/fifa-2014/xbox-one-169061</td>\n",
" <td>Xbox One</td>\n",
" <td>9.1</td>\n",
" <td>Sports</td>\n",
" <td>Y</td>\n",
" <td>2013</td>\n",
" <td>12</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17451</th>\n",
" <td>Amazing</td>\n",
" <td>Tomb Raider: Definitive Edition</td>\n",
" <td>/games/tomb-raider-definitive-edition/xbox-one...</td>\n",
" <td>Xbox One</td>\n",
" <td>9.1</td>\n",
" <td>Action</td>\n",
" <td>Y</td>\n",
" <td>2014</td>\n",
" <td>1</td>\n",
" <td>25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17463</th>\n",
" <td>Great</td>\n",
" <td>The Walking Dead: A Telltale Game Series -- Se...</td>\n",
" <td>/games/the-walking-dead-a-telltale-game-series...</td>\n",
" <td>Xbox One</td>\n",
" <td>8.0</td>\n",
" <td>Adventure</td>\n",
" <td>N</td>\n",
" <td>2013</td>\n",
" <td>12</td>\n",
" <td>17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17487</th>\n",
" <td>Good</td>\n",
" <td>Zumba Fitness World Party</td>\n",
" <td>/games/zumba-fitness-world-party/xbox-one-2000...</td>\n",
" <td>Xbox One</td>\n",
" <td>7.2</td>\n",
" <td>Sports, Other</td>\n",
" <td>N</td>\n",
" <td>2014</td>\n",
" <td>1</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17501</th>\n",
" <td>Amazing</td>\n",
" <td>Peggle 2</td>\n",
" <td>/games/peggle-2/xbox-one-20000567</td>\n",
" <td>Xbox One</td>\n",
" <td>9.0</td>\n",
" <td>Puzzle, Action</td>\n",
" <td>Y</td>\n",
" <td>2013</td>\n",
" <td>12</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17537</th>\n",
" <td>Good</td>\n",
" <td>Strider</td>\n",
" <td>/games/strider-next-gen/xbox-one-20002503</td>\n",
" <td>Xbox One</td>\n",
" <td>7.5</td>\n",
" <td>Action</td>\n",
" <td>N</td>\n",
" <td>2014</td>\n",
" <td>2</td>\n",
" <td>18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17594</th>\n",
" <td>Good</td>\n",
" <td>Plants vs. Zombies: Garden Warfare</td>\n",
" <td>/games/plants-vs-zombies-garden-warfare/xbox-o...</td>\n",
" <td>Xbox One</td>\n",
" <td>7.8</td>\n",
" <td>Shooter</td>\n",
" <td>N</td>\n",
" <td>2014</td>\n",
" <td>2</td>\n",
" <td>25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17610</th>\n",
" <td>Great</td>\n",
" <td>Metal Gear Solid V: Ground Zeroes</td>\n",
" <td>/games/metal-gear-solid-ground-zeroes/xbox-one...</td>\n",
" <td>Xbox One</td>\n",
" <td>8.0</td>\n",
" <td>Action, Adventure</td>\n",
" <td>N</td>\n",
" <td>2014</td>\n",
" <td>3</td>\n",
" <td>18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17622</th>\n",
" <td>Great</td>\n",
" <td>Titanfall</td>\n",
" <td>/games/titanfall/xbox-one-20000422</td>\n",
" <td>Xbox One</td>\n",
" <td>8.9</td>\n",
" <td>Shooter, First-Person</td>\n",
" <td>Y</td>\n",
" <td>2014</td>\n",
" <td>3</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17624</th>\n",
" <td>Great</td>\n",
" <td>Titanfall (Collector's Edition)</td>\n",
" <td>/games/titanfall/xbox-one-20007506</td>\n",
" <td>Xbox One</td>\n",
" <td>8.9</td>\n",
" <td>Shooter, First-Person</td>\n",
" <td>Y</td>\n",
" <td>2014</td>\n",
" <td>3</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17629</th>\n",
" <td>Good</td>\n",
" <td>Kinect Sports Rivals</td>\n",
" <td>/games/kinect-sports-rivals/xbox-one-20000535</td>\n",
" <td>Xbox One</td>\n",
" <td>7.3</td>\n",
" <td>Sports, Party</td>\n",
" <td>N</td>\n",
" <td>2014</td>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17675</th>\n",
" <td>Amazing</td>\n",
" <td>Child of Light</td>\n",
" <td>/games/child-of-light/xbox-one-20005405</td>\n",
" <td>Xbox One</td>\n",
" <td>9.3</td>\n",
" <td>RPG</td>\n",
" <td>Y</td>\n",
" <td>2014</td>\n",
" <td>4</td>\n",
" <td>29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17703</th>\n",
" <td>Great</td>\n",
" <td>Trials Fusion</td>\n",
" <td>/games/trials-fusion/xbox-one-20000604</td>\n",
" <td>Xbox One</td>\n",
" <td>8.2</td>\n",
" <td>Racing, Action</td>\n",
" <td>N</td>\n",
" <td>2014</td>\n",
" <td>4</td>\n",
" <td>16</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17720</th>\n",
" <td>Good</td>\n",
" <td>LEGO: The Hobbit</td>\n",
" <td>/games/lego-the-hobbit/xbox-one-20008977</td>\n",
" <td>Xbox One</td>\n",
" <td>7.4</td>\n",
" <td>Adventure</td>\n",
" <td>N</td>\n",
" <td>2014</td>\n",
" <td>4</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17750</th>\n",
" <td>Amazing</td>\n",
" <td>Guacamelee! Super Turbo Championship Edition</td>\n",
" <td>/games/guacamelee/xbox-one-20014215</td>\n",
" <td>Xbox One</td>\n",
" <td>9.1</td>\n",
" <td>Platformer, Action</td>\n",
" <td>N</td>\n",
" <td>2014</td>\n",
" <td>7</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17767</th>\n",
" <td>Great</td>\n",
" <td>Watch Dogs</td>\n",
" <td>/games/watchdogs/xbox-one-169679</td>\n",
" <td>Xbox One</td>\n",
" <td>8.4</td>\n",
" <td>Action</td>\n",
" <td>N</td>\n",
" <td>2014</td>\n",
" <td>5</td>\n",
" <td>27</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17780</th>\n",
" <td>Good</td>\n",
" <td>Wolfenstein: The New Order</td>\n",
" <td>/games/wolfenstein-the-new-order/xbox-one-167463</td>\n",
" <td>Xbox One</td>\n",
" <td>7.8</td>\n",
" <td>Shooter</td>\n",
" <td>N</td>\n",
" <td>2014</td>\n",
" <td>5</td>\n",
" <td>20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17786</th>\n",
" <td>Good</td>\n",
" <td>Super TIME Force</td>\n",
" <td>/games/super-time-force/xbox-one-20009623</td>\n",
" <td>Xbox One</td>\n",
" <td>7.5</td>\n",
" <td>Shooter</td>\n",
" <td>N</td>\n",
" <td>2014</td>\n",
" <td>5</td>\n",
" <td>14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18369</th>\n",
" <td>Great</td>\n",
" <td>Disney Infinity: 3.0 Edition</td>\n",
" <td>/games/disney-infinity-3/xbox-one-20040693</td>\n",
" <td>Xbox One</td>\n",
" <td>8.9</td>\n",
" <td>Action</td>\n",
" <td>N</td>\n",
" <td>2015</td>\n",
" <td>8</td>\n",
" <td>28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18370</th>\n",
" <td>Great</td>\n",
" <td>Dishonored: Definitive Edition</td>\n",
" <td>/games/dishonored-definitive-edition/xbox-one-...</td>\n",
" <td>Xbox One</td>\n",
" <td>8.0</td>\n",
" <td>Action</td>\n",
" <td>N</td>\n",
" <td>2015</td>\n",
" <td>8</td>\n",
" <td>28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18377</th>\n",
" <td>Good</td>\n",
" <td>Transformers: Devastation</td>\n",
" <td>/games/transformers-devastation/xbox-one-20038682</td>\n",
" <td>Xbox One</td>\n",
" <td>7.7</td>\n",
" <td>Action</td>\n",
" <td>N</td>\n",
" <td>2015</td>\n",
" <td>10</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18386</th>\n",
" <td>Great</td>\n",
" <td>Rocket League</td>\n",
" <td>/games/rocket-league/xbox-one-20046670</td>\n",
" <td>Xbox One</td>\n",
" <td>8.0</td>\n",
" <td>Sports</td>\n",
" <td>N</td>\n",
" <td>2016</td>\n",
" <td>2</td>\n",
" <td>23</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18401</th>\n",
" <td>Amazing</td>\n",
" <td>Forza Motorsport 6</td>\n",
" <td>/games/forza-motorsport-6/xbox-one-20029964</td>\n",
" <td>Xbox One</td>\n",
" <td>9.0</td>\n",
" <td>Racing</td>\n",
" <td>Y</td>\n",
" <td>2015</td>\n",
" <td>9</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18404</th>\n",
" <td>Amazing</td>\n",
" <td>Mega Man Legacy Collection</td>\n",
" <td>/games/mega-man-legacy-collection/xbox-one-200...</td>\n",
" <td>Xbox One</td>\n",
" <td>9.0</td>\n",
" <td>Action</td>\n",
" <td>Y</td>\n",
" <td>2015</td>\n",
" <td>8</td>\n",
" <td>25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18408</th>\n",
" <td>Great</td>\n",
" <td>Madden NFL 16</td>\n",
" <td>/games/madden-nfl-2016/xbox-one-20036695</td>\n",
" <td>Xbox One</td>\n",
" <td>8.8</td>\n",
" <td>Sports</td>\n",
" <td>N</td>\n",
" <td>2015</td>\n",
" <td>8</td>\n",
" <td>25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18410</th>\n",
" <td>Great</td>\n",
" <td>Gears of War: Ultimate Edition</td>\n",
" <td>/games/gears-of-war-ultimate-edition/xbox-one-...</td>\n",
" <td>Xbox One</td>\n",
" <td>8.5</td>\n",
" <td>Shooter</td>\n",
" <td>N</td>\n",
" <td>2015</td>\n",
" <td>8</td>\n",
" <td>24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18426</th>\n",
" <td>Amazing</td>\n",
" <td>Firewatch</td>\n",
" <td>/games/firewatch/xbox-one-20058352</td>\n",
" <td>Xbox One</td>\n",
" <td>9.3</td>\n",
" <td>Adventure</td>\n",
" <td>Y</td>\n",
" <td>2016</td>\n",
" <td>2</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18432</th>\n",
" <td>Masterpiece</td>\n",
" <td>Metal Gear Solid V: The Phantom Pain</td>\n",
" <td>/games/metal-gear-solid-5/xbox-one-20000541</td>\n",
" <td>Xbox One</td>\n",
" <td>10.0</td>\n",
" <td>Action</td>\n",
" <td>Y</td>\n",
" <td>2015</td>\n",
" <td>8</td>\n",
" <td>24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18435</th>\n",
" <td>Good</td>\n",
" <td>Zombi</td>\n",
" <td>/games/zombi-u/xbox-one-20040940</td>\n",
" <td>Xbox One</td>\n",
" <td>7.5</td>\n",
" <td>Shooter</td>\n",
" <td>N</td>\n",
" <td>2015</td>\n",
" <td>8</td>\n",
" <td>20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18438</th>\n",
" <td>Great</td>\n",
" <td>Smite</td>\n",
" <td>/games/smite-hi-rez-studios/xbox-one-20022966</td>\n",
" <td>Xbox One</td>\n",
" <td>8.5</td>\n",
" <td>Strategy</td>\n",
" <td>Y</td>\n",
" <td>2015</td>\n",
" <td>8</td>\n",
" <td>19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18452</th>\n",
" <td>Great</td>\n",
" <td>FIFA 17</td>\n",
" <td>/games/fifa-2017/xbox-one-20052734</td>\n",
" <td>Xbox One</td>\n",
" <td>8.4</td>\n",
" <td>Sports</td>\n",
" <td>N</td>\n",
" <td>2016</td>\n",
" <td>9</td>\n",
" <td>22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18455</th>\n",
" <td>Amazing</td>\n",
" <td>Forza Horizon 3</td>\n",
" <td>/games/forza-horizon-3/xbox-one-20054783</td>\n",
" <td>Xbox One</td>\n",
" <td>9.5</td>\n",
" <td>Racing</td>\n",
" <td>Y</td>\n",
" <td>2016</td>\n",
" <td>9</td>\n",
" <td>20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18459</th>\n",
" <td>Great</td>\n",
" <td>BioShock: The Collection</td>\n",
" <td>/games/bioshock-the-collection/xbox-one-20043280</td>\n",
" <td>Xbox One</td>\n",
" <td>8.2</td>\n",
" <td>Shooter</td>\n",
" <td>N</td>\n",
" <td>2016</td>\n",
" <td>9</td>\n",
" <td>14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18464</th>\n",
" <td>Amazing</td>\n",
" <td>Pro Evolution Soccer 2017</td>\n",
" <td>/games/pro-evolution-soccer-2017/xbox-one-2005...</td>\n",
" <td>Xbox One</td>\n",
" <td>9.5</td>\n",
" <td>Sports</td>\n",
" <td>Y</td>\n",
" <td>2016</td>\n",
" <td>9</td>\n",
" <td>13</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18466</th>\n",
" <td>Good</td>\n",
" <td>ReCore</td>\n",
" <td>/games/recore/xbox-one-20038726</td>\n",
" <td>Xbox One</td>\n",
" <td>7.3</td>\n",
" <td>Adventure</td>\n",
" <td>N</td>\n",
" <td>2016</td>\n",
" <td>9</td>\n",
" <td>13</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18468</th>\n",
" <td>Great</td>\n",
" <td>NHL 17</td>\n",
" <td>/games/nhl-17/xbox-one-20052732</td>\n",
" <td>Xbox One</td>\n",
" <td>8.4</td>\n",
" <td>Sports</td>\n",
" <td>N</td>\n",
" <td>2016</td>\n",
" <td>9</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18482</th>\n",
" <td>Great</td>\n",
" <td>TrackMania Turbo</td>\n",
" <td>/games/trackmania-turbo/xbox-one-20038797</td>\n",
" <td>Xbox One</td>\n",
" <td>8.4</td>\n",
" <td>Racing</td>\n",
" <td>N</td>\n",
" <td>2016</td>\n",
" <td>3</td>\n",
" <td>24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18510</th>\n",
" <td>Great</td>\n",
" <td>Quantum Break</td>\n",
" <td>/games/quantum-break/xbox-one-169587</td>\n",
" <td>Xbox One</td>\n",
" <td>8.0</td>\n",
" <td>Action</td>\n",
" <td>N</td>\n",
" <td>2016</td>\n",
" <td>4</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18517</th>\n",
" <td>Good</td>\n",
" <td>Hitman: Episode 1</td>\n",
" <td>/games/hitman-episode-1/xbox-one-20050607</td>\n",
" <td>Xbox One</td>\n",
" <td>7.9</td>\n",
" <td>Shooter</td>\n",
" <td>N</td>\n",
" <td>2016</td>\n",
" <td>3</td>\n",
" <td>10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18548</th>\n",
" <td>Great</td>\n",
" <td>Plants vs. Zombies: Garden Warfare 2</td>\n",
" <td>/games/plants-vs-zombies-garden-warfare-2/xbox...</td>\n",
" <td>Xbox One</td>\n",
" <td>8.2</td>\n",
" <td>Shooter</td>\n",
" <td>N</td>\n",
" <td>2016</td>\n",
" <td>2</td>\n",
" <td>24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18551</th>\n",
" <td>Good</td>\n",
" <td>Battleborn</td>\n",
" <td>/games/battleborn/xbox-one-20021223</td>\n",
" <td>Xbox One</td>\n",
" <td>7.1</td>\n",
" <td>Shooter</td>\n",
" <td>N</td>\n",
" <td>2016</td>\n",
" <td>5</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18556</th>\n",
" <td>Great</td>\n",
" <td>Hitman: Episode 2</td>\n",
" <td>/games/hitman-episode-2/xbox-one-20051631</td>\n",
" <td>Xbox One</td>\n",
" <td>8.5</td>\n",
" <td>Shooter</td>\n",
" <td>N</td>\n",
" <td>2016</td>\n",
" <td>4</td>\n",
" <td>29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18571</th>\n",
" <td>Amazing</td>\n",
" <td>Overwatch</td>\n",
" <td>/games/overwatch/xbox-one-20045579</td>\n",
" <td>Xbox One</td>\n",
" <td>9.4</td>\n",
" <td>Shooter</td>\n",
" <td>Y</td>\n",
" <td>2016</td>\n",
" <td>5</td>\n",
" <td>28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18582</th>\n",
" <td>Great</td>\n",
" <td>Fru</td>\n",
" <td>/games/fru/xbox-one-20014934</td>\n",
" <td>Xbox One</td>\n",
" <td>8.5</td>\n",
" <td>Platformer</td>\n",
" <td>N</td>\n",
" <td>2016</td>\n",
" <td>7</td>\n",
" <td>25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18588</th>\n",
" <td>Great</td>\n",
" <td>F1 2016</td>\n",
" <td>/games/f1-2016/xbox-one-20054150</td>\n",
" <td>Xbox One</td>\n",
" <td>8.8</td>\n",
" <td>Racing</td>\n",
" <td>N</td>\n",
" <td>2016</td>\n",
" <td>8</td>\n",
" <td>24</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18591</th>\n",
" <td>Amazing</td>\n",
" <td>Deus Ex: Mankind Divided</td>\n",
" <td>/games/deus-ex-mankind-divided/xbox-one-20035498</td>\n",
" <td>Xbox One</td>\n",
" <td>9.2</td>\n",
" <td>Action, RPG</td>\n",
" <td>Y</td>\n",
" <td>2016</td>\n",
" <td>8</td>\n",
" <td>19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18602</th>\n",
" <td>Good</td>\n",
" <td>Hitman: Episode 4</td>\n",
" <td>/games/hitman-episode-4/xbox-one-20051639</td>\n",
" <td>Xbox One</td>\n",
" <td>7.4</td>\n",
" <td>Shooter</td>\n",
" <td>N</td>\n",
" <td>2016</td>\n",
" <td>8</td>\n",
" <td>19</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18623</th>\n",
" <td>Masterpiece</td>\n",
" <td>Inside</td>\n",
" <td>/games/inside-playdead/xbox-one-121435</td>\n",
" <td>Xbox One</td>\n",
" <td>10.0</td>\n",
" <td>Adventure</td>\n",
" <td>Y</td>\n",
" <td>2016</td>\n",
" <td>6</td>\n",
" <td>28</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>140 rows × 10 columns</p>\n",
"</div>"
],
"text/plain": [
" score_phrase title \\\n",
"17137 Amazing Gone Home \n",
"17197 Amazing Rayman Legends \n",
"17295 Amazing LEGO Marvel Super Heroes \n",
"17313 Great Dead Rising 3 \n",
"17317 Great Killer Instinct \n",
"17328 Great Call of Duty: Ghosts \n",
"17335 Good Madden NFL 25 \n",
"17358 Great Assassin's Creed IV: Black Flag \n",
"17361 Great Battlefield 4 \n",
"17367 Great NBA 2K14 \n",
"17391 Great Need for Speed Rivals \n",
"17393 Great Forza Motorsport 5 \n",
"17445 Amazing FIFA 14 \n",
"17451 Amazing Tomb Raider: Definitive Edition \n",
"17463 Great The Walking Dead: A Telltale Game Series -- Se... \n",
"17487 Good Zumba Fitness World Party \n",
"17501 Amazing Peggle 2 \n",
"17537 Good Strider \n",
"17594 Good Plants vs. Zombies: Garden Warfare \n",
"17610 Great Metal Gear Solid V: Ground Zeroes \n",
"17622 Great Titanfall \n",
"17624 Great Titanfall (Collector's Edition) \n",
"17629 Good Kinect Sports Rivals \n",
"17675 Amazing Child of Light \n",
"17703 Great Trials Fusion \n",
"17720 Good LEGO: The Hobbit \n",
"17750 Amazing Guacamelee! Super Turbo Championship Edition \n",
"17767 Great Watch Dogs \n",
"17780 Good Wolfenstein: The New Order \n",
"17786 Good Super TIME Force \n",
"... ... ... \n",
"18369 Great Disney Infinity: 3.0 Edition \n",
"18370 Great Dishonored: Definitive Edition \n",
"18377 Good Transformers: Devastation \n",
"18386 Great Rocket League \n",
"18401 Amazing Forza Motorsport 6 \n",
"18404 Amazing Mega Man Legacy Collection \n",
"18408 Great Madden NFL 16 \n",
"18410 Great Gears of War: Ultimate Edition \n",
"18426 Amazing Firewatch \n",
"18432 Masterpiece Metal Gear Solid V: The Phantom Pain \n",
"18435 Good Zombi \n",
"18438 Great Smite \n",
"18452 Great FIFA 17 \n",
"18455 Amazing Forza Horizon 3 \n",
"18459 Great BioShock: The Collection \n",
"18464 Amazing Pro Evolution Soccer 2017 \n",
"18466 Good ReCore \n",
"18468 Great NHL 17 \n",
"18482 Great TrackMania Turbo \n",
"18510 Great Quantum Break \n",
"18517 Good Hitman: Episode 1 \n",
"18548 Great Plants vs. Zombies: Garden Warfare 2 \n",
"18551 Good Battleborn \n",
"18556 Great Hitman: Episode 2 \n",
"18571 Amazing Overwatch \n",
"18582 Great Fru \n",
"18588 Great F1 2016 \n",
"18591 Amazing Deus Ex: Mankind Divided \n",
"18602 Good Hitman: Episode 4 \n",
"18623 Masterpiece Inside \n",
"\n",
" url platform score \\\n",
"17137 /games/gone-home/xbox-one-20014361 Xbox One 9.5 \n",
"17197 /games/rayman-legends/xbox-one-20008449 Xbox One 9.5 \n",
"17295 /games/lego-marvel-super-heroes/xbox-one-20000826 Xbox One 9.0 \n",
"17313 /games/dead-rising-3/xbox-one-124306 Xbox One 8.3 \n",
"17317 /games/killer-instinct-2013/xbox-one-20000538 Xbox One 8.4 \n",
"17328 /games/call-of-duty-ghosts/xbox-one-163214 Xbox One 8.8 \n",
"17335 /games/madden-nfl-2014/xbox-one-169583 Xbox One 7.6 \n",
"17358 /games/assassins-creed-black-flag/xbox-one-161677 Xbox One 8.5 \n",
"17361 /games/battlefield-4/xbox-one-161397 Xbox One 8.5 \n",
"17367 /games/nba-2k14/xbox-one-20000632 Xbox One 8.9 \n",
"17391 /games/need-for-speed-rivals/xbox-one-170808 Xbox One 8.0 \n",
"17393 /games/forza-motorsport-5/xbox-one-169062 Xbox One 8.8 \n",
"17445 /games/fifa-2014/xbox-one-169061 Xbox One 9.1 \n",
"17451 /games/tomb-raider-definitive-edition/xbox-one... Xbox One 9.1 \n",
"17463 /games/the-walking-dead-a-telltale-game-series... Xbox One 8.0 \n",
"17487 /games/zumba-fitness-world-party/xbox-one-2000... Xbox One 7.2 \n",
"17501 /games/peggle-2/xbox-one-20000567 Xbox One 9.0 \n",
"17537 /games/strider-next-gen/xbox-one-20002503 Xbox One 7.5 \n",
"17594 /games/plants-vs-zombies-garden-warfare/xbox-o... Xbox One 7.8 \n",
"17610 /games/metal-gear-solid-ground-zeroes/xbox-one... Xbox One 8.0 \n",
"17622 /games/titanfall/xbox-one-20000422 Xbox One 8.9 \n",
"17624 /games/titanfall/xbox-one-20007506 Xbox One 8.9 \n",
"17629 /games/kinect-sports-rivals/xbox-one-20000535 Xbox One 7.3 \n",
"17675 /games/child-of-light/xbox-one-20005405 Xbox One 9.3 \n",
"17703 /games/trials-fusion/xbox-one-20000604 Xbox One 8.2 \n",
"17720 /games/lego-the-hobbit/xbox-one-20008977 Xbox One 7.4 \n",
"17750 /games/guacamelee/xbox-one-20014215 Xbox One 9.1 \n",
"17767 /games/watchdogs/xbox-one-169679 Xbox One 8.4 \n",
"17780 /games/wolfenstein-the-new-order/xbox-one-167463 Xbox One 7.8 \n",
"17786 /games/super-time-force/xbox-one-20009623 Xbox One 7.5 \n",
"... ... ... ... \n",
"18369 /games/disney-infinity-3/xbox-one-20040693 Xbox One 8.9 \n",
"18370 /games/dishonored-definitive-edition/xbox-one-... Xbox One 8.0 \n",
"18377 /games/transformers-devastation/xbox-one-20038682 Xbox One 7.7 \n",
"18386 /games/rocket-league/xbox-one-20046670 Xbox One 8.0 \n",
"18401 /games/forza-motorsport-6/xbox-one-20029964 Xbox One 9.0 \n",
"18404 /games/mega-man-legacy-collection/xbox-one-200... Xbox One 9.0 \n",
"18408 /games/madden-nfl-2016/xbox-one-20036695 Xbox One 8.8 \n",
"18410 /games/gears-of-war-ultimate-edition/xbox-one-... Xbox One 8.5 \n",
"18426 /games/firewatch/xbox-one-20058352 Xbox One 9.3 \n",
"18432 /games/metal-gear-solid-5/xbox-one-20000541 Xbox One 10.0 \n",
"18435 /games/zombi-u/xbox-one-20040940 Xbox One 7.5 \n",
"18438 /games/smite-hi-rez-studios/xbox-one-20022966 Xbox One 8.5 \n",
"18452 /games/fifa-2017/xbox-one-20052734 Xbox One 8.4 \n",
"18455 /games/forza-horizon-3/xbox-one-20054783 Xbox One 9.5 \n",
"18459 /games/bioshock-the-collection/xbox-one-20043280 Xbox One 8.2 \n",
"18464 /games/pro-evolution-soccer-2017/xbox-one-2005... Xbox One 9.5 \n",
"18466 /games/recore/xbox-one-20038726 Xbox One 7.3 \n",
"18468 /games/nhl-17/xbox-one-20052732 Xbox One 8.4 \n",
"18482 /games/trackmania-turbo/xbox-one-20038797 Xbox One 8.4 \n",
"18510 /games/quantum-break/xbox-one-169587 Xbox One 8.0 \n",
"18517 /games/hitman-episode-1/xbox-one-20050607 Xbox One 7.9 \n",
"18548 /games/plants-vs-zombies-garden-warfare-2/xbox... Xbox One 8.2 \n",
"18551 /games/battleborn/xbox-one-20021223 Xbox One 7.1 \n",
"18556 /games/hitman-episode-2/xbox-one-20051631 Xbox One 8.5 \n",
"18571 /games/overwatch/xbox-one-20045579 Xbox One 9.4 \n",
"18582 /games/fru/xbox-one-20014934 Xbox One 8.5 \n",
"18588 /games/f1-2016/xbox-one-20054150 Xbox One 8.8 \n",
"18591 /games/deus-ex-mankind-divided/xbox-one-20035498 Xbox One 9.2 \n",
"18602 /games/hitman-episode-4/xbox-one-20051639 Xbox One 7.4 \n",
"18623 /games/inside-playdead/xbox-one-121435 Xbox One 10.0 \n",
"\n",
" genre editors_choice release_year release_month \\\n",
"17137 Simulation Y 2013 8 \n",
"17197 Platformer Y 2013 8 \n",
"17295 Action Y 2013 10 \n",
"17313 Action N 2013 11 \n",
"17317 Fighting N 2013 11 \n",
"17328 Shooter N 2013 11 \n",
"17335 Sports N 2013 11 \n",
"17358 Action, Adventure N 2013 10 \n",
"17361 Shooter N 2013 11 \n",
"17367 Sports N 2013 11 \n",
"17391 Racing N 2013 11 \n",
"17393 Racing Y 2013 11 \n",
"17445 Sports Y 2013 12 \n",
"17451 Action Y 2014 1 \n",
"17463 Adventure N 2013 12 \n",
"17487 Sports, Other N 2014 1 \n",
"17501 Puzzle, Action Y 2013 12 \n",
"17537 Action N 2014 2 \n",
"17594 Shooter N 2014 2 \n",
"17610 Action, Adventure N 2014 3 \n",
"17622 Shooter, First-Person Y 2014 3 \n",
"17624 Shooter, First-Person Y 2014 3 \n",
"17629 Sports, Party N 2014 4 \n",
"17675 RPG Y 2014 4 \n",
"17703 Racing, Action N 2014 4 \n",
"17720 Adventure N 2014 4 \n",
"17750 Platformer, Action N 2014 7 \n",
"17767 Action N 2014 5 \n",
"17780 Shooter N 2014 5 \n",
"17786 Shooter N 2014 5 \n",
"... ... ... ... ... \n",
"18369 Action N 2015 8 \n",
"18370 Action N 2015 8 \n",
"18377 Action N 2015 10 \n",
"18386 Sports N 2016 2 \n",
"18401 Racing Y 2015 9 \n",
"18404 Action Y 2015 8 \n",
"18408 Sports N 2015 8 \n",
"18410 Shooter N 2015 8 \n",
"18426 Adventure Y 2016 2 \n",
"18432 Action Y 2015 8 \n",
"18435 Shooter N 2015 8 \n",
"18438 Strategy Y 2015 8 \n",
"18452 Sports N 2016 9 \n",
"18455 Racing Y 2016 9 \n",
"18459 Shooter N 2016 9 \n",
"18464 Sports Y 2016 9 \n",
"18466 Adventure N 2016 9 \n",
"18468 Sports N 2016 9 \n",
"18482 Racing N 2016 3 \n",
"18510 Action N 2016 4 \n",
"18517 Shooter N 2016 3 \n",
"18548 Shooter N 2016 2 \n",
"18551 Shooter N 2016 5 \n",
"18556 Shooter N 2016 4 \n",
"18571 Shooter Y 2016 5 \n",
"18582 Platformer N 2016 7 \n",
"18588 Racing N 2016 8 \n",
"18591 Action, RPG Y 2016 8 \n",
"18602 Shooter N 2016 8 \n",
"18623 Adventure Y 2016 6 \n",
"\n",
" release_day \n",
"17137 15 \n",
"17197 26 \n",
"17295 22 \n",
"17313 18 \n",
"17317 18 \n",
"17328 5 \n",
"17335 15 \n",
"17358 29 \n",
"17361 26 \n",
"17367 12 \n",
"17391 20 \n",
"17393 20 \n",
"17445 2 \n",
"17451 25 \n",
"17463 17 \n",
"17487 10 \n",
"17501 9 \n",
"17537 18 \n",
"17594 25 \n",
"17610 18 \n",
"17622 10 \n",
"17624 10 \n",
"17629 7 \n",
"17675 29 \n",
"17703 16 \n",
"17720 10 \n",
"17750 9 \n",
"17767 27 \n",
"17780 20 \n",
"17786 14 \n",
"... ... \n",
"18369 28 \n",
"18370 28 \n",
"18377 9 \n",
"18386 23 \n",
"18401 8 \n",
"18404 25 \n",
"18408 25 \n",
"18410 24 \n",
"18426 8 \n",
"18432 24 \n",
"18435 20 \n",
"18438 19 \n",
"18452 22 \n",
"18455 20 \n",
"18459 14 \n",
"18464 13 \n",
"18466 13 \n",
"18468 12 \n",
"18482 24 \n",
"18510 1 \n",
"18517 10 \n",
"18548 24 \n",
"18551 6 \n",
"18556 29 \n",
"18571 28 \n",
"18582 25 \n",
"18588 24 \n",
"18591 19 \n",
"18602 19 \n",
"18623 28 \n",
"\n",
"[140 rows x 10 columns]"
]
},
"execution_count": 1,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"import pandas as pd\n",
"\n",
"# 读入csv变为data frame\n",
"reviews = pd.read_csv('ign.csv')\n",
"# 查看data frame的前几行，默认为5\n",
"reviews.head()\n",
"# 查看data frame的形状\n",
"reviews.shape\n",
"\n",
"# 使用数值索引访问 dataframe, 用法和numpy的tuple索引一致\n",
"# 元组的第一项对应行，第二项对应列\n",
"# 项可以是数值，也可以是slice\n",
"# 缺省的项，默认为全部( : )\n",
"reviews.iloc[:5,]\n",
"reviews = reviews.iloc[:,1:]\n",
"\n",
"reviews.head()\n",
"reviews.loc[0:5,]\n",
"some_reviews = reviews.iloc[10:20,]\n",
"some_reviews.head()\n",
"\n",
"# 用label来访问dataframe\n",
"# 元组的第一项为行label即index\n",
"# 第二项为列label\n",
"\n",
"some_reviews.loc[11:12,]\n",
"reviews.loc[:5, 'score']\n",
"reviews.loc[0:5, ['score', 'release_year']]\n",
"\n",
"# 获得列的方法\n",
"# 使用中括号列名或列名数组\n",
"# 使用iloc获得所有行\n",
"# 使用loc获得所有行\n",
"reviews['score']\n",
"reviews.iloc[:, 4]\n",
"reviews.loc[:, 'score']\n",
"reviews[['score', 'release_year']]\n",
"\n",
"type(reviews['score'])\n",
"\n",
"# 新建series，\n",
"\n",
"s1 = pd.Series([1,2])\n",
"s2 = pd.Series(['a', 'b'])\n",
"s2\n",
"\n",
"# 新建dataframe\n",
"# s1, s2是行\n",
"pd.DataFrame([s1,s2])\n",
"\n",
"# 新建dataframe\n",
"# list of row\n",
"a = pd.DataFrame([\n",
" [1,2],\n",
" ['a','b']\n",
"])\n",
"a\n",
"\n",
"# 新建dataframe\n",
"# 可以指定index和column label\n",
"a = pd.DataFrame([\n",
" ['haoming', 1],\n",
" ['bb',2]\n",
"],\n",
" columns=['name','score'],\n",
" index=[4,5]\n",
" \n",
")\n",
"\n",
"\n",
"\n",
"a.loc[4:5, 'name']\n",
"\n",
"\n",
"b = pd.DataFrame({\n",
" 'name': ['haoming', 'bb'],\n",
" 'score': [1,2]\n",
"})\n",
"\n",
"a\n",
"b['name'].head()\n",
"\n",
"# 计算series的平均值，只处理数值\n",
"b['score'].mean()\n",
"reviews.head()\n",
"\n",
"# 计算列的平均值\n",
"review_mean = reviews.mean()\n",
"type(review_mean)\n",
"review_mean\n",
"# 计算行的平均值，只处理数值\n",
"a=reviews.mean(axis=1)\n",
"type(a)\n",
"a\n",
"reviews.corr()\n",
"\n",
"# 算术操作\n",
"reviews['score'] / 2\n",
"\n",
"# 比较操作\n",
"score_filter = reviews['score'] > 7\n",
"score_filter\n",
"\n",
"# 使用中括号传入boolean series过滤的是列\n",
"# 传入list of label取回列\n",
"reviews[score_filter]\n",
"\n",
"\n",
"xbox_one_filter = (reviews['score'] > 7) & (reviews['platform'] == 'Xbox One')\n",
"reviews[xbox_one_filter]\n",
"\n",
"\n"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"<matplotlib.axes._subplots.AxesSubplot at 0x1c6a9040b00>"
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAYIAAAD8CAYAAAB6paOMAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4yLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvhp/UCwAAFdFJREFUeJzt3X2MXfV95/H3N3YSHgZqHsysYx5M\nWovg4oXgu4iW3WoGh92kiWJXDVqiLHIj2tnOZh3SdrV1olXpH63WkaI8lFbeeEPaaZoyJS6p2ZAm\n67hMokotqW3YNRkHOSWUGLvYde3CkCYU97t/3GPtyMyde+y5555rn/dLGt17zj3n/L78dC8fn/M7\nD5GZSJKa63V1FyBJqpdBIEkNZxBIUsMZBJLUcAaBJDWcQSBJDWcQSFLDGQSS1HAGgSQ13OK6Cyjj\n8ssvzxUrVtRaw8svv8yFF15Yaw2DzP7pzL6Zn/3T2UL7Zvfu3X+XmUu7LXdWBMGKFSvYtWtXrTVM\nTU0xMjJSaw2DzP7pzL6Zn/3T2UL7JiL+psxyHhqSpIYzCCSp4QwCSWo4g0CSGs4gkKSGqzQIIuKX\nIuJbEfFURDwYEedFxLUR8XhE7I+IP4qIN1RZgyRpfpUFQUQsBz4ItDLzBmARcBfwUeATmbkSOAbc\nU1UNkqTuqj40tBg4PyIWAxcAh4DbgW3F5xPA+oprkCTNo7IgyMzngY8Bz9EOgH8AdgPHM/PVYrED\nwPKqapAkdVfZlcURcQmwDrgWOA58AXjHHItmh/XHgDGA4eFhpqamqim0pJmZmdprGGT2T2f2zfxO\np3+mj05XW0wHqy5bVUu7/fruVHmLibcB383MIwAR8TDwk8CSiFhc7BVcCRyca+XM3ApsBWi1Wln3\nJeheBj8/+6cz+2Z+p9M/Gyc2VltMB3t/dm8t7fbru1PlGMFzwK0RcUFEBLAWmAYeA95TLLMB2F5h\nDZKkLqocI3ic9qDwHmBv0dZW4FeBX46I7wCXAQ9UVYMkqbtK7z6amfcB950y+xnglirblSSV55XF\nktRwBoEkNZxBIEkNZxBIUsMZBJLUcGfFM4slDY7VE6t7ur3xofHaLhRTm3sEktRwBoEkNZxBIEkN\nZxBIUsMZBJLUcAaBJDWcQSBJDWcQSFLDGQSS1HAGgSQ1nEEgSQ1XWRBExHUR8eSsvxcj4kMRcWlE\n7IiI/cXrJVXVIEnqrspnFj+dmTdl5k3AGuD7wBeBTcDOzFwJ7CymJUk16dehobXAX2fm3wDrgIli\n/gSwvk81SJLm0K8guAt4sHg/nJmHAIrXK/pUgyRpDpGZ1TYQ8QbgIPDjmflCRBzPzCWzPj+Wma8Z\nJ4iIMWAMYHh4eM3k5GSldXYzMzPD0NBQrTUMMvuns3Otb6aPTvd0e0sXLeXIiSM93WavrbpsVS3t\nLvS7Mzo6ujszW92W68eDad4B7MnMF4rpFyJiWWYeiohlwOG5VsrMrcBWgFarlSMjI30otbOpqSnq\nrmGQ2T+dnWt90+uHyIwPjbNlZktPt9lre392by3t9uu7049DQ+/l/x8WAngE2FC83wBs70MNkqQO\nKg2CiLgAuAN4eNbszcAdEbG/+GxzlTVIkuZX6aGhzPw+cNkp847SPotIkjQAvLJYkhrOIJCkhjMI\nJKnhDAJJajiDQJIaziCQpIYzCCSp4QwCSWo4g0CSGs4gkKSGMwgkqeEMAklqOINAkhrOIJCkhjMI\nJKnhDAJJajiDQJIarupHVS6JiG0R8e2I2BcRPxERl0bEjojYX7xeUmUNkqT5Vb1H8CngK5n5FuBG\nYB+wCdiZmSuBncW0JKkmlQVBRFwM/BTwAEBmvpKZx4F1wESx2ASwvqoaJEndRWZWs+GIm4CtwDTt\nvYHdwL3A85m5ZNZyxzLzNYeHImIMGAMYHh5eMzk5WUmdZc3MzDA0NFRrDYPM/unsXOub6aPTPd3e\n0kVLOXLiSE+32WurLltVS7sL/e6Mjo7uzsxWt+WqDIIW8JfAbZn5eER8CngR2FgmCGZrtVq5a9eu\nSuosa2pqipGRkVprGGT2T2fnWt+snljd0+2ND42zZWZLT7fZa3s37K2l3YV+dyKiVBBUOUZwADiQ\nmY8X09uAm4EXImIZQPF6uMIaJEldVBYEmfm3wPci4rpi1lrah4keATYU8zYA26uqQZLU3eKKt78R\n+HxEvAF4Bng/7fB5KCLuAZ4D7qy4BknSPCoNgsx8Epjr+NTaKtuVJJXnlcWS1HAGgSQ1nEEgSQ1n\nEEhSwxkEktRwBoEkNZxBIEkNZxBIUhcrNj3Kik2P1l1GZQwCSWo4g0CSGs4gkKSGMwgkqeEMAklq\nOINAkhrOIJCkhjMIJKnhDAJJarhSQRARN5zJxiPi2YjYGxFPRsSuYt6lEbEjIvYXr5ecybYlSb1R\ndo/gf0TENyPiP0XEktNsYzQzb8rMk4+s3ATszMyVwM5iWpJUk1JBkJn/GngfcBWwKyL+MCLuOMM2\n1wETxfsJYP0ZbkeS1AORmeUXjlhE+3/cvwW8CATwkcx8uMPy3wWOAQl8OjO3RsTxzFwya5ljmfma\nw0MRMQaMAQwPD6+ZnJws/19VgZmZGYaGhmqtYZDZP52da30zfXS6p9tbumgpR04c6ek2e+3ED5YD\nsHr5j/S13YV+d0ZHR3fPOhrTUakgiIh/CbwfeCewA3ggM/dExJuAv8jMazqs96bMPBgRVxTrbQQe\nKRMEs7Vardy1a1fXOqs0NTXFyMhIrTUMMvuns3Otb1ZPrO7p9saHxtkys6Wn2+y1l/ZtBuDZze/s\na7sL/e5ERKkgKDtG8NvAHuDGzPxAZu4ByMyDwH/rtFLxOZl5GPgicAvwQkQsK4pcBhwuWYMkqQJl\ng+CngT/MzH8EiIjXRcQFAJn5ublWiIgLI+Kik++Bfws8BTwCbCgW2wBsP/PyJUkLVTYIvgacP2v6\ngmLefIaBP4+I/wN8E3g0M78CbAbuiIj9wB3FtCSpJotLLndeZs6cnMjMmZN7BJ1k5jPAjXPMPwqs\nPa0qJUmVKbtH8HJE3HxyIiLWAP9YTUmSpH4qu0fwIeALEXGwmF4G/PtqSpIk9VOpIMjMv4qItwDX\n0b524NuZ+U+VViZJ6ouyewQA/wpYUazz1oggM3+/kqokSX1TKggi4nPAjwJPAieK2QkYBJJ0liu7\nR9ACVuXp3I9CknRWKHvW0FPAv6iyEElSPcruEVwOTEfEN4EfnpyZme+upCpJUt+UDYJfr7IISVJ9\nyp4++vWIuAZYmZlfK64qXlRtaZKkfij7qMpfALYBny5mLQf+pKqiJEn9U3aw+APAbbQfRkNm7geu\nqKooSVL/lA2CH2bmKycnImIx7esIJElnubJB8PWI+AhwfvGs4i8A/6u6siRJ/VI2CDYBR4C9wH8E\nvsw8TyaTJJ09yp419M/A/yz+JEnnkLL3Gvouc4wJZOabe16RJKmvTudeQyedB9wJXFpmxYhYBOwC\nns/Md0XEtcBksf4e4O7ZA9GSpP4qNUaQmUdn/T2fmZ8Ebi/Zxr3AvlnTHwU+kZkrgWPAPadVsSSp\np8peUHbzrL9WRPwicFGJ9a4E3gl8ppgO2gGyrVhkAlh/RpVLknoiytxZOiIemzX5KvAs8LHMfLrL\netuA/047NP4L8HPAX2bmjxWfXwX8aWbeMMe6Y8AYwPDw8JrJyckS/znVmZmZYWhoqNYaBpn909m5\n1jfTR6d7ur2li5Zy5MSRnm6z1078YDkAq5f/SF/bXeh3Z3R0dHdmtrotV/asodHTLSAi3gUczszd\nETFycvZcm+/Q5lZgK0Cr1cqRkZG5Fuubqakp6q5hkNk/nZ1rfbNxYmNPtzc+NM6WmS093WavvbRv\nMwDPvm+kr+3267tT9qyhX57v88z8+ByzbwPeHRE/TXuA+WLgk8CSiFicma8CVwIHT69kSVIvlb2g\nrAWM077Z3HLgF4FVtA/5zDlWkJkfzswrM3MFcBfwZ5n5PuAx4D3FYhuA7WdcvSRpwU7nwTQ3Z+ZL\nABHx68AXMvPnz6DNXwUmI+I3gCeAB85gG5KkHikbBFcDs8/1fwVYUbaRzJwCpor3zwC3lF1XklSt\nskHwOeCbEfFF2oO7PwP8fmVVSZL6puxZQ78ZEX8K/Jti1vsz84nqypIk9UvZwWKAC4AXM/NTwIHi\nVhGSpLNc2SuL76M9yPvhYtbrgT+oqihJUv+U3SP4GeDdwMsAmXmQEreYkCQNvrKDxa9kZkZEAkTE\nhRXWJGmBVmx6tLJtX3R9ZZtWTcruETwUEZ+mfVXwLwBfw4fUSNI5oexZQx8rnlX8InAd8GuZuaPS\nyiRJfdE1CIoHy3w1M98G+D9/STrHdD00lJkngO9HRH/vvypJ6ouyg8U/APZGxA6KM4cAMvODlVQl\nqavVE6s7fuaArk5H2SB4tPiTJJ1j5g2CiLg6M5/LzIl+FSRJ6q9uYwR/cvJNRPxxxbVIkmrQLQhm\nP1ryzVUWIkmqR7cxguzwXhLzD9ieND403vPn/Eq91C0IboyIF2nvGZxfvKeYzsy8uNOKEXEe8A3g\njUU72zLzvuKupZPApcAe4O7MfKXTdiRJ1Zr30FBmLsrMizPzosxcXLw/Od0xBAo/BG7PzBuBm4C3\nR8StwEeBT2TmSuAYcE8v/kMkSWfmdJ5HcFqybaaYfH3xl8DtwLZi/gSwvqoaJEndVRYE0L49RUQ8\nCRymfXuKvwaOZ+arxSIHgOVV1iBJml9kVj8GHBFLgC8Cvwb8bmb+WDH/KuDLmfmaEbeIGAPGAIaH\nh9dMTk5WXud8ZmZmGBoaqrWGQdbU/pk+Ot11maWLlnLkxJE+VHN2Ohv658QP2v9eXb28v3faWejv\nanR0dHdmtrotV/bK4gXJzOMRMQXcSvtW1ouLvYIrgYMd1tkKbAVotVo5MjLSj1I7mpqaou4aBllT\n+6fM2UDjQ+NsmdnSh2rOTmdD/7y0bzMAz75vpK/t9ut3VdmhoYhYWuwJEBHnA28D9gGPAe8pFtsA\nbK+qBklSd1XuESwDJorbWL8OeCgzvxQR08BkRPwG8ATwQIU1SNKCXXT9JgBWT2zqa7v3X3N/X9qp\nLAgy8/8Cb51j/jPALVW1K0k6PZWeNSRJGnwGgSQ1nEEgSQ1nEEhSwxkEktRwBoEkNZxBIEkNZxBI\nUsMZBJLUcAaBJDWcQSBJDWcQSFLDGQSS1HAGgSQ1nEEgSQ1nEEhSwxkEktRwVT6z+KqIeCwi9kXE\ntyLi3mL+pRGxIyL2F6+XVFWDJKm7KvcIXgV+JTOvB24FPhARq4BNwM7MXAnsLKYlSTWpLAgy81Bm\n7inevwTsA5YD64CJYrEJYH1VNUiSuuvLGEFErKD9IPvHgeHMPATtsACu6EcNkqS5RWZW20DEEPB1\n4Dcz8+GIOJ6ZS2Z9fiwzXzNOEBFjwBjA8PDwmsnJyUrr7GZmZoahoaFaaxhkTe2f6aPTXZdZumgp\nR04c6UM1Zyf7p7Or33j1gn5Xo6OjuzOz1W25SoMgIl4PfAn4amZ+vJj3NDCSmYciYhkwlZnXzbed\nVquVu3btqqzOMqamphgZGam1hkHW1P5ZPbG66zLjQ+NsmdnSh2rOTvZPZ/dfc/+CflcRUSoIqjxr\nKIAHgH0nQ6DwCLCheL8B2F5VDZKk7hZXuO3bgLuBvRHxZDHvI8Bm4KGIuAd4DrizwhokSV1UFgSZ\n+edAdPh4bVXtSpJOj1cWS1LDGQSS1HAGgSQ1nEEgSQ1nEEhSwxkEktRwBoEkNZxBIEkNZxBIUsMZ\nBJLUcAaBJDVclTedk/qmzO2gJc3NPQJJajiDQJIaziCQpIYzCCSp4QwCSWq4Kp9Z/NmIOBwRT82a\nd2lE7IiI/cXrJVW1L0kqp8o9gt8D3n7KvE3AzsxcCewspiVJNaosCDLzG8DfnzJ7HTBRvJ8A1lfV\nviSpnH6PEQxn5iGA4vWKPrcvSTpFZGZ1G49YAXwpM28opo9n5pJZnx/LzDnHCSJiDBgDGB4eXjM5\nOVlZnWXMzMwwNDRUaw2DrO7+mT46XVvb3SxdtJQjJ47UXcbAsn86u/qNVy/odzU6Oro7M1vdluv3\nLSZeiIhlmXkoIpYBhzstmJlbga0ArVYrR0ZG+lTi3Kampqi7hkFWd/9snNhYW9vdjA+Ns2VmS91l\nDCz7p7P7L7u/L7+rfh8aegTYULzfAGzvc/uSpFNUefrog8BfANdFxIGIuAfYDNwREfuBO4ppSVKN\nKjs0lJnv7fDR2qralCSdPq8slqSGMwgkqeEMAklqOINAkhrOIJCkhvOZxarVik2P9mQ7F13fk81I\njeQegSQ1nEEgSQ1nEEhSwxkEktRwDharZ1ZPrD7tdRzklernHoEkNZxBIEkN56GhipzJYZKz2fjQ\neN0lSDpD7hFIUsMZBJLUcOf8oaFeHaIZHxof6OfiStKZqmWPICLeHhFPR8R3ImJTHTVIktr6HgQR\nsQj4HeAdwCrgvRGxqt91SJLa6tgjuAX4TmY+k5mvAJPAuhrqkCRRTxAsB743a/pAMU+SVIPIzP42\nGHEn8O8y8+eL6buBWzJz4ynLjQFjxeR1wNN9LfS1Lgf+ruYaBpn905l9Mz/7p7OF9s01mbm020J1\nnDV0ALhq1vSVwMFTF8rMrcDWfhXVTUTsysxW3XUMKvunM/tmfvZPZ/3qmzoODf0VsDIiro2INwB3\nAY/UUIckiRr2CDLz1Yj4z8BXgUXAZzPzW/2uQ5LUVssFZZn5ZeDLdbS9AANzmGpA2T+d2Tfzs386\n60vf9H2wWJI0WLzXkCQ1nEHQRURcFRGPRcS+iPhWRNxbd02DJiIWRcQTEfGlumsZNBGxJCK2RcS3\ni+/QT9Rd06CIiF8qflNPRcSDEXFe3TXVKSI+GxGHI+KpWfMujYgdEbG/eL2kirYNgu5eBX4lM68H\nbgU+4C0xXuNeYF/dRQyoTwFfycy3ADdiPwEQEcuBDwKtzLyB9okjd9VbVe1+D3j7KfM2ATszcyWw\ns5juOYOgi8w8lJl7ivcv0f4heyV0ISKuBN4JfKbuWgZNRFwM/BTwAEBmvpKZx+utaqAsBs6PiMXA\nBcxxPVGTZOY3gL8/ZfY6YKJ4PwGsr6Jtg+A0RMQK4K3A4/VWMlA+CfxX4J/rLmQAvRk4Avxucejs\nMxFxYd1FDYLMfB74GPAccAj4h8z83/VWNZCGM/MQtP9RClxRRSMGQUkRMQT8MfChzHyx7noGQUS8\nCzicmbvrrmVALQZuBrZk5luBl6lo1/5sUxzrXgdcC7wJuDAi/kO9VTWXQVBCRLyedgh8PjMfrrue\nAXIb8O6IeJb2XWRvj4g/qLekgXIAOJCZJ/cgt9EOBsHbgO9m5pHM/CfgYeAna65pEL0QEcsAitfD\nVTRiEHQREUH7GO++zPx43fUMksz8cGZemZkraA/0/Vlm+q+6Qmb+LfC9iLiumLUWmK6xpEHyHHBr\nRFxQ/MbW4kD6XB4BNhTvNwDbq2jknH9UZQ/cBtwN7I2IJ4t5Hymujpa62Qh8vriv1jPA+2uuZyBk\n5uMRsQ3YQ/vMvCdo+BXGEfEgMAJcHhEHgPuAzcBDEXEP7fC8s5K2vbJYkprNQ0OS1HAGgSQ1nEEg\nSQ1nEEhSwxkEktRwBoEkNZxBIEkNZxBIUsP9P9mPf7pt49zQAAAAAElFTkSuQmCC\n",
"text/plain": [
"<Figure size 432x288 with 1 Axes>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"%matplotlib inline\n",
"\n",
"reviews.head()\n",
"\n",
"# 绘图\n",
"reviews[reviews['platform'] == 'Xbox One']['score'].plot(kind='hist')\n",
"reviews[reviews['platform'] == 'PlayStation 4']['score'].plot(kind='hist')\n",
"# 绘制柱状图\n",
"reviews[reviews['platform'] == 'PlayStation 4']['score'].hist()"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"score_phrase Good\n",
"title Total War Battles: Shogun\n",
"url /games/total-war-battles-shogun/mac-142565\n",
"platform Macintosh\n",
"score 7\n",
"genre Strategy\n",
"editors_choice N\n",
"release_year 2012\n",
"release_month 9\n",
"release_day 11\n",
"Name: 5, dtype: object"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"reviews.loc[5]"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.6.3"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Display the source blob
Display the rendered blob
Raw
main2.ipynb
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment