top_5000_exploration.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "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>Ranking</th>\n",
       "      <th>Album</th>\n",
       "      <th>Artist</th>\n",
       "      <th>Release Date</th>\n",
       "      <th>Genres</th>\n",
       "      <th>Descriptors</th>\n",
       "      <th>Average Rating</th>\n",
       "      <th>Number of Ratings</th>\n",
       "      <th>Number of Reviews</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>OK Computer</td>\n",
       "      <td>Radiohead</td>\n",
       "      <td>16 June 1997</td>\n",
       "      <td>Alternative Rock, Art Rock</td>\n",
       "      <td>melancholic, anxious, futuristic, alienation, ...</td>\n",
       "      <td>4.23</td>\n",
       "      <td>70,382</td>\n",
       "      <td>1531</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.0</td>\n",
       "      <td>Wish You Were Here</td>\n",
       "      <td>Pink Floyd</td>\n",
       "      <td>12 September 1975</td>\n",
       "      <td>Progressive Rock, Art Rock</td>\n",
       "      <td>melancholic, atmospheric, progressive, male vo...</td>\n",
       "      <td>4.29</td>\n",
       "      <td>48,662</td>\n",
       "      <td>983</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3.0</td>\n",
       "      <td>In the Court of the Crimson King</td>\n",
       "      <td>King Crimson</td>\n",
       "      <td>10 October 1969</td>\n",
       "      <td>Progressive Rock, Art Rock</td>\n",
       "      <td>fantasy, epic, progressive, philosophical, com...</td>\n",
       "      <td>4.30</td>\n",
       "      <td>44,943</td>\n",
       "      <td>870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4.0</td>\n",
       "      <td>Kid A</td>\n",
       "      <td>Radiohead</td>\n",
       "      <td>3 October 2000</td>\n",
       "      <td>Art Rock, Experimental Rock, Electronic</td>\n",
       "      <td>cold, melancholic, futuristic, atmospheric, an...</td>\n",
       "      <td>4.21</td>\n",
       "      <td>58,590</td>\n",
       "      <td>734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.0</td>\n",
       "      <td>To Pimp a Butterfly</td>\n",
       "      <td>Kendrick Lamar</td>\n",
       "      <td>15 March 2015</td>\n",
       "      <td>Conscious Hip Hop, West Coast Hip Hop, Jazz Rap</td>\n",
       "      <td>political, conscious, poetic, protest, concept...</td>\n",
       "      <td>4.27</td>\n",
       "      <td>44,206</td>\n",
       "      <td>379</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6.0</td>\n",
       "      <td>Loveless</td>\n",
       "      <td>My Bloody Valentine</td>\n",
       "      <td>4 November 1991</td>\n",
       "      <td>Shoegaze, Noise Pop</td>\n",
       "      <td>noisy, ethereal, atmospheric, romantic, dense,...</td>\n",
       "      <td>4.24</td>\n",
       "      <td>49,887</td>\n",
       "      <td>1223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7.0</td>\n",
       "      <td>The Dark Side of the Moon</td>\n",
       "      <td>Pink Floyd</td>\n",
       "      <td>23 March 1973</td>\n",
       "      <td>Art Rock, Progressive Rock</td>\n",
       "      <td>philosophical, atmospheric, introspective, exi...</td>\n",
       "      <td>4.20</td>\n",
       "      <td>57,622</td>\n",
       "      <td>1549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8.0</td>\n",
       "      <td>Abbey Road</td>\n",
       "      <td>The Beatles</td>\n",
       "      <td>26 September 1969</td>\n",
       "      <td>Pop Rock</td>\n",
       "      <td>melodic, warm, male vocals, bittersweet, summe...</td>\n",
       "      <td>4.25</td>\n",
       "      <td>44,544</td>\n",
       "      <td>961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9.0</td>\n",
       "      <td>The Velvet Underground &amp; Nico</td>\n",
       "      <td>The Velvet Underground &amp; Nico</td>\n",
       "      <td>12 March 1967</td>\n",
       "      <td>Art Rock, Experimental Rock</td>\n",
       "      <td>drugs, sexual, raw, urban, noisy, nihilistic, ...</td>\n",
       "      <td>4.23</td>\n",
       "      <td>45,570</td>\n",
       "      <td>929</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10.0</td>\n",
       "      <td>The Rise and Fall of Ziggy Stardust and the Sp...</td>\n",
       "      <td>David Bowie</td>\n",
       "      <td>16 June 1972</td>\n",
       "      <td>Glam Rock, Pop Rock</td>\n",
       "      <td>science fiction, melodic, anthemic, concept al...</td>\n",
       "      <td>4.26</td>\n",
       "      <td>39,501</td>\n",
       "      <td>721</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Ranking                                              Album  \\\n",
       "0      1.0                                        OK Computer   \n",
       "1      2.0                                 Wish You Were Here   \n",
       "2      3.0                   In the Court of the Crimson King   \n",
       "3      4.0                                              Kid A   \n",
       "4      5.0                                To Pimp a Butterfly   \n",
       "5      6.0                                           Loveless   \n",
       "6      7.0                          The Dark Side of the Moon   \n",
       "7      8.0                                         Abbey Road   \n",
       "8      9.0                      The Velvet Underground & Nico   \n",
       "9     10.0  The Rise and Fall of Ziggy Stardust and the Sp...   \n",
       "\n",
       "                          Artist       Release Date  \\\n",
       "0                      Radiohead       16 June 1997   \n",
       "1                     Pink Floyd  12 September 1975   \n",
       "2                   King Crimson    10 October 1969   \n",
       "3                      Radiohead     3 October 2000   \n",
       "4                 Kendrick Lamar      15 March 2015   \n",
       "5            My Bloody Valentine    4 November 1991   \n",
       "6                     Pink Floyd      23 March 1973   \n",
       "7                    The Beatles  26 September 1969   \n",
       "8  The Velvet Underground & Nico      12 March 1967   \n",
       "9                    David Bowie       16 June 1972   \n",
       "\n",
       "                                            Genres  \\\n",
       "0                       Alternative Rock, Art Rock   \n",
       "1                       Progressive Rock, Art Rock   \n",
       "2                       Progressive Rock, Art Rock   \n",
       "3          Art Rock, Experimental Rock, Electronic   \n",
       "4  Conscious Hip Hop, West Coast Hip Hop, Jazz Rap   \n",
       "5                              Shoegaze, Noise Pop   \n",
       "6                       Art Rock, Progressive Rock   \n",
       "7                                         Pop Rock   \n",
       "8                      Art Rock, Experimental Rock   \n",
       "9                              Glam Rock, Pop Rock   \n",
       "\n",
       "                                         Descriptors  Average Rating  \\\n",
       "0  melancholic, anxious, futuristic, alienation, ...            4.23   \n",
       "1  melancholic, atmospheric, progressive, male vo...            4.29   \n",
       "2  fantasy, epic, progressive, philosophical, com...            4.30   \n",
       "3  cold, melancholic, futuristic, atmospheric, an...            4.21   \n",
       "4  political, conscious, poetic, protest, concept...            4.27   \n",
       "5  noisy, ethereal, atmospheric, romantic, dense,...            4.24   \n",
       "6  philosophical, atmospheric, introspective, exi...            4.20   \n",
       "7  melodic, warm, male vocals, bittersweet, summe...            4.25   \n",
       "8  drugs, sexual, raw, urban, noisy, nihilistic, ...            4.23   \n",
       "9  science fiction, melodic, anthemic, concept al...            4.26   \n",
       "\n",
       "  Number of Ratings  Number of Reviews  \n",
       "0            70,382               1531  \n",
       "1            48,662                983  \n",
       "2            44,943                870  \n",
       "3            58,590                734  \n",
       "4            44,206                379  \n",
       "5            49,887               1223  \n",
       "6            57,622               1549  \n",
       "7            44,544                961  \n",
       "8            45,570                929  \n",
       "9            39,501                721  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_top = pd.read_csv('rym_top_5000_all_time.csv')\n",
    "#Rename for column name for merging\n",
    "df_top = df_top.rename(columns = {\"Artist Name\":\"Artist\"})\n",
    "df_top.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(5000, 9)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_top.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "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>Artist</th>\n",
       "      <th>Title</th>\n",
       "      <th>Release Month</th>\n",
       "      <th>Release Day</th>\n",
       "      <th>Release Year</th>\n",
       "      <th>Format</th>\n",
       "      <th>Label</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Metacritic Critic Score</th>\n",
       "      <th>Metacritic Reviews</th>\n",
       "      <th>Metacritic User Score</th>\n",
       "      <th>Metacritic User Reviews</th>\n",
       "      <th>AOTY Critic Score</th>\n",
       "      <th>AOTY Critic Reviews</th>\n",
       "      <th>AOTY User Score</th>\n",
       "      <th>AOTY User Reviews</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Neko Case</td>\n",
       "      <td>Middle Cyclone</td>\n",
       "      <td>March</td>\n",
       "      <td>3</td>\n",
       "      <td>2009</td>\n",
       "      <td>LP</td>\n",
       "      <td>ANTI-</td>\n",
       "      <td>Alt-Country</td>\n",
       "      <td>79.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>8.7</td>\n",
       "      <td>31.0</td>\n",
       "      <td>79</td>\n",
       "      <td>25</td>\n",
       "      <td>78</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jason Isbell &amp; The 400 Unit</td>\n",
       "      <td>Jason Isbell &amp; The 400 Unit</td>\n",
       "      <td>February</td>\n",
       "      <td>17</td>\n",
       "      <td>2009</td>\n",
       "      <td>LP</td>\n",
       "      <td>Thirty Tigers</td>\n",
       "      <td>Country Rock</td>\n",
       "      <td>70.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>8.4</td>\n",
       "      <td>7.0</td>\n",
       "      <td>73</td>\n",
       "      <td>11</td>\n",
       "      <td>73</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Animal Collective</td>\n",
       "      <td>Merriweather Post Pavilion</td>\n",
       "      <td>January</td>\n",
       "      <td>20</td>\n",
       "      <td>2009</td>\n",
       "      <td>LP</td>\n",
       "      <td>Domino</td>\n",
       "      <td>Psychedelic Pop</td>\n",
       "      <td>89.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>8.5</td>\n",
       "      <td>619.0</td>\n",
       "      <td>92</td>\n",
       "      <td>30</td>\n",
       "      <td>87</td>\n",
       "      <td>1335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bruce Springsteen</td>\n",
       "      <td>Working on a Dream</td>\n",
       "      <td>January</td>\n",
       "      <td>27</td>\n",
       "      <td>2009</td>\n",
       "      <td>LP</td>\n",
       "      <td>Columbia Records</td>\n",
       "      <td>Rock</td>\n",
       "      <td>72.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>7.9</td>\n",
       "      <td>101.0</td>\n",
       "      <td>70</td>\n",
       "      <td>23</td>\n",
       "      <td>66</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Andrew Bird</td>\n",
       "      <td>Noble Beast</td>\n",
       "      <td>January</td>\n",
       "      <td>20</td>\n",
       "      <td>2009</td>\n",
       "      <td>LP</td>\n",
       "      <td>Fat Possum</td>\n",
       "      <td>Singer-Songwriter</td>\n",
       "      <td>79.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>8.7</td>\n",
       "      <td>47.0</td>\n",
       "      <td>74</td>\n",
       "      <td>24</td>\n",
       "      <td>78</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Bon Iver</td>\n",
       "      <td>Blood Bank EP</td>\n",
       "      <td>January</td>\n",
       "      <td>20</td>\n",
       "      <td>2009</td>\n",
       "      <td>EP</td>\n",
       "      <td>Jagjaguwar</td>\n",
       "      <td>Indie Folk</td>\n",
       "      <td>72.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>8.4</td>\n",
       "      <td>71.0</td>\n",
       "      <td>74</td>\n",
       "      <td>14</td>\n",
       "      <td>80</td>\n",
       "      <td>241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>M. Ward</td>\n",
       "      <td>Hold Time</td>\n",
       "      <td>February</td>\n",
       "      <td>17</td>\n",
       "      <td>2009</td>\n",
       "      <td>LP</td>\n",
       "      <td>Merge Records</td>\n",
       "      <td>Folk</td>\n",
       "      <td>79.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>8.8</td>\n",
       "      <td>23.0</td>\n",
       "      <td>76</td>\n",
       "      <td>24</td>\n",
       "      <td>76</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Lily Allen</td>\n",
       "      <td>It's Not Me, It's You</td>\n",
       "      <td>February</td>\n",
       "      <td>10</td>\n",
       "      <td>2009</td>\n",
       "      <td>LP</td>\n",
       "      <td>EMI/Parlophone</td>\n",
       "      <td>Pop</td>\n",
       "      <td>71.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>8.1</td>\n",
       "      <td>155.0</td>\n",
       "      <td>68</td>\n",
       "      <td>29</td>\n",
       "      <td>79</td>\n",
       "      <td>209</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Morrissey</td>\n",
       "      <td>Years of Refusal</td>\n",
       "      <td>February</td>\n",
       "      <td>17</td>\n",
       "      <td>2009</td>\n",
       "      <td>LP</td>\n",
       "      <td>Attack/Lost Highway</td>\n",
       "      <td>Alternative Rock</td>\n",
       "      <td>79.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>76</td>\n",
       "      <td>26</td>\n",
       "      <td>74</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>The Decemberists</td>\n",
       "      <td>The Hazards of Love</td>\n",
       "      <td>March</td>\n",
       "      <td>24</td>\n",
       "      <td>2009</td>\n",
       "      <td>LP</td>\n",
       "      <td>Capitol Records</td>\n",
       "      <td>Indie Rock</td>\n",
       "      <td>73.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>8.5</td>\n",
       "      <td>98.0</td>\n",
       "      <td>73</td>\n",
       "      <td>29</td>\n",
       "      <td>76</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Artist                        Title Release Month  \\\n",
       "0                    Neko Case               Middle Cyclone         March   \n",
       "1  Jason Isbell & The 400 Unit  Jason Isbell & The 400 Unit      February   \n",
       "2            Animal Collective   Merriweather Post Pavilion       January   \n",
       "3            Bruce Springsteen           Working on a Dream       January   \n",
       "4                  Andrew Bird                  Noble Beast       January   \n",
       "5                     Bon Iver                Blood Bank EP       January   \n",
       "6                      M. Ward                    Hold Time      February   \n",
       "7                   Lily Allen        It's Not Me, It's You      February   \n",
       "8                    Morrissey             Years of Refusal      February   \n",
       "9             The Decemberists          The Hazards of Love         March   \n",
       "\n",
       "  Release Day  Release Year Format                Label              Genre  \\\n",
       "0           3          2009     LP                ANTI-        Alt-Country   \n",
       "1          17          2009     LP        Thirty Tigers       Country Rock   \n",
       "2          20          2009     LP               Domino    Psychedelic Pop   \n",
       "3          27          2009     LP     Columbia Records               Rock   \n",
       "4          20          2009     LP           Fat Possum  Singer-Songwriter   \n",
       "5          20          2009     EP           Jagjaguwar         Indie Folk   \n",
       "6          17          2009     LP        Merge Records               Folk   \n",
       "7          10          2009     LP       EMI/Parlophone                Pop   \n",
       "8          17          2009     LP  Attack/Lost Highway   Alternative Rock   \n",
       "9          24          2009     LP      Capitol Records         Indie Rock   \n",
       "\n",
       "   Metacritic Critic Score  Metacritic Reviews  Metacritic User Score  \\\n",
       "0                     79.0                31.0                    8.7   \n",
       "1                     70.0                14.0                    8.4   \n",
       "2                     89.0                36.0                    8.5   \n",
       "3                     72.0                29.0                    7.9   \n",
       "4                     79.0                29.0                    8.7   \n",
       "5                     72.0                15.0                    8.4   \n",
       "6                     79.0                31.0                    8.8   \n",
       "7                     71.0                32.0                    8.1   \n",
       "8                     79.0                32.0                    8.0   \n",
       "9                     73.0                31.0                    8.5   \n",
       "\n",
       "   Metacritic User Reviews  AOTY Critic Score  AOTY Critic Reviews  \\\n",
       "0                     31.0                 79                   25   \n",
       "1                      7.0                 73                   11   \n",
       "2                    619.0                 92                   30   \n",
       "3                    101.0                 70                   23   \n",
       "4                     47.0                 74                   24   \n",
       "5                     71.0                 74                   14   \n",
       "6                     23.0                 76                   24   \n",
       "7                    155.0                 68                   29   \n",
       "8                     37.0                 76                   26   \n",
       "9                     98.0                 73                   29   \n",
       "\n",
       "   AOTY User Score  AOTY User Reviews  \n",
       "0               78                 55  \n",
       "1               73                  8  \n",
       "2               87               1335  \n",
       "3               66                 38  \n",
       "4               78                 44  \n",
       "5               80                241  \n",
       "6               76                 22  \n",
       "7               79                209  \n",
       "8               74                 45  \n",
       "9               76                 66  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ratings = pd.read_csv('album_ratings.csv')\n",
    "df_ratings.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(32358, 16)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ratings.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "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>Artist</th>\n",
       "      <th>Album</th>\n",
       "      <th>Release Month</th>\n",
       "      <th>Release Day</th>\n",
       "      <th>Release Year</th>\n",
       "      <th>Format</th>\n",
       "      <th>Label</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Metacritic Critic Score</th>\n",
       "      <th>Metacritic Reviews</th>\n",
       "      <th>Metacritic User Score</th>\n",
       "      <th>Metacritic User Reviews</th>\n",
       "      <th>AOTY Critic Score</th>\n",
       "      <th>AOTY Critic Reviews</th>\n",
       "      <th>AOTY User Score</th>\n",
       "      <th>AOTY User Reviews</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Neko Case</td>\n",
       "      <td>Middle Cyclone</td>\n",
       "      <td>March</td>\n",
       "      <td>3</td>\n",
       "      <td>2009</td>\n",
       "      <td>LP</td>\n",
       "      <td>ANTI-</td>\n",
       "      <td>Alt-Country</td>\n",
       "      <td>79.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>8.7</td>\n",
       "      <td>31.0</td>\n",
       "      <td>79</td>\n",
       "      <td>25</td>\n",
       "      <td>78</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jason Isbell &amp; The 400 Unit</td>\n",
       "      <td>Jason Isbell &amp; The 400 Unit</td>\n",
       "      <td>February</td>\n",
       "      <td>17</td>\n",
       "      <td>2009</td>\n",
       "      <td>LP</td>\n",
       "      <td>Thirty Tigers</td>\n",
       "      <td>Country Rock</td>\n",
       "      <td>70.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>8.4</td>\n",
       "      <td>7.0</td>\n",
       "      <td>73</td>\n",
       "      <td>11</td>\n",
       "      <td>73</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Animal Collective</td>\n",
       "      <td>Merriweather Post Pavilion</td>\n",
       "      <td>January</td>\n",
       "      <td>20</td>\n",
       "      <td>2009</td>\n",
       "      <td>LP</td>\n",
       "      <td>Domino</td>\n",
       "      <td>Psychedelic Pop</td>\n",
       "      <td>89.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>8.5</td>\n",
       "      <td>619.0</td>\n",
       "      <td>92</td>\n",
       "      <td>30</td>\n",
       "      <td>87</td>\n",
       "      <td>1335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bruce Springsteen</td>\n",
       "      <td>Working on a Dream</td>\n",
       "      <td>January</td>\n",
       "      <td>27</td>\n",
       "      <td>2009</td>\n",
       "      <td>LP</td>\n",
       "      <td>Columbia Records</td>\n",
       "      <td>Rock</td>\n",
       "      <td>72.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>7.9</td>\n",
       "      <td>101.0</td>\n",
       "      <td>70</td>\n",
       "      <td>23</td>\n",
       "      <td>66</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Andrew Bird</td>\n",
       "      <td>Noble Beast</td>\n",
       "      <td>January</td>\n",
       "      <td>20</td>\n",
       "      <td>2009</td>\n",
       "      <td>LP</td>\n",
       "      <td>Fat Possum</td>\n",
       "      <td>Singer-Songwriter</td>\n",
       "      <td>79.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>8.7</td>\n",
       "      <td>47.0</td>\n",
       "      <td>74</td>\n",
       "      <td>24</td>\n",
       "      <td>78</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Artist                        Album Release Month  \\\n",
       "0                    Neko Case               Middle Cyclone         March   \n",
       "1  Jason Isbell & The 400 Unit  Jason Isbell & The 400 Unit      February   \n",
       "2            Animal Collective   Merriweather Post Pavilion       January   \n",
       "3            Bruce Springsteen           Working on a Dream       January   \n",
       "4                  Andrew Bird                  Noble Beast       January   \n",
       "\n",
       "  Release Day  Release Year Format             Label              Genre  \\\n",
       "0           3          2009     LP             ANTI-        Alt-Country   \n",
       "1          17          2009     LP     Thirty Tigers       Country Rock   \n",
       "2          20          2009     LP            Domino    Psychedelic Pop   \n",
       "3          27          2009     LP  Columbia Records               Rock   \n",
       "4          20          2009     LP        Fat Possum  Singer-Songwriter   \n",
       "\n",
       "   Metacritic Critic Score  Metacritic Reviews  Metacritic User Score  \\\n",
       "0                     79.0                31.0                    8.7   \n",
       "1                     70.0                14.0                    8.4   \n",
       "2                     89.0                36.0                    8.5   \n",
       "3                     72.0                29.0                    7.9   \n",
       "4                     79.0                29.0                    8.7   \n",
       "\n",
       "   Metacritic User Reviews  AOTY Critic Score  AOTY Critic Reviews  \\\n",
       "0                     31.0                 79                   25   \n",
       "1                      7.0                 73                   11   \n",
       "2                    619.0                 92                   30   \n",
       "3                    101.0                 70                   23   \n",
       "4                     47.0                 74                   24   \n",
       "\n",
       "   AOTY User Score  AOTY User Reviews  \n",
       "0               78                 55  \n",
       "1               73                  8  \n",
       "2               87               1335  \n",
       "3               66                 38  \n",
       "4               78                 44  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Change column name so we can merge\n",
    "df_ratings = df_ratings.rename(columns = {'Title':'Album'})\n",
    "df_ratings.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(32358, 16)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ratings.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "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>Ranking</th>\n",
       "      <th>Album</th>\n",
       "      <th>Artist</th>\n",
       "      <th>Release Date</th>\n",
       "      <th>Genres</th>\n",
       "      <th>Descriptors</th>\n",
       "      <th>Average Rating</th>\n",
       "      <th>Number of Ratings</th>\n",
       "      <th>Number of Reviews</th>\n",
       "      <th>Release Month</th>\n",
       "      <th>...</th>\n",
       "      <th>Label</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Metacritic Critic Score</th>\n",
       "      <th>Metacritic Reviews</th>\n",
       "      <th>Metacritic User Score</th>\n",
       "      <th>Metacritic User Reviews</th>\n",
       "      <th>AOTY Critic Score</th>\n",
       "      <th>AOTY Critic Reviews</th>\n",
       "      <th>AOTY User Score</th>\n",
       "      <th>AOTY User Reviews</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>OK Computer</td>\n",
       "      <td>Radiohead</td>\n",
       "      <td>16 June 1997</td>\n",
       "      <td>Alternative Rock, Art Rock</td>\n",
       "      <td>melancholic, anxious, futuristic, alienation, ...</td>\n",
       "      <td>4.23</td>\n",
       "      <td>70,382</td>\n",
       "      <td>1531</td>\n",
       "      <td>June</td>\n",
       "      <td>...</td>\n",
       "      <td>Parlophone, Capitol</td>\n",
       "      <td>Alternative Rock</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>91</td>\n",
       "      <td>12</td>\n",
       "      <td>93</td>\n",
       "      <td>3204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.0</td>\n",
       "      <td>Wish You Were Here</td>\n",
       "      <td>Pink Floyd</td>\n",
       "      <td>12 September 1975</td>\n",
       "      <td>Progressive Rock, Art Rock</td>\n",
       "      <td>melancholic, atmospheric, progressive, male vo...</td>\n",
       "      <td>4.29</td>\n",
       "      <td>48,662</td>\n",
       "      <td>983</td>\n",
       "      <td>September</td>\n",
       "      <td>...</td>\n",
       "      <td>Harvest</td>\n",
       "      <td>Progressive Rock</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100</td>\n",
       "      <td>4</td>\n",
       "      <td>91</td>\n",
       "      <td>1607</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4.0</td>\n",
       "      <td>Kid A</td>\n",
       "      <td>Radiohead</td>\n",
       "      <td>3 October 2000</td>\n",
       "      <td>Art Rock, Experimental Rock, Electronic</td>\n",
       "      <td>cold, melancholic, futuristic, atmospheric, an...</td>\n",
       "      <td>4.21</td>\n",
       "      <td>58,590</td>\n",
       "      <td>734</td>\n",
       "      <td>October</td>\n",
       "      <td>...</td>\n",
       "      <td>Capitol / EMI</td>\n",
       "      <td>Experimental Rock</td>\n",
       "      <td>80.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>8.9</td>\n",
       "      <td>1129.0</td>\n",
       "      <td>85</td>\n",
       "      <td>13</td>\n",
       "      <td>92</td>\n",
       "      <td>2862</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5.0</td>\n",
       "      <td>To Pimp a Butterfly</td>\n",
       "      <td>Kendrick Lamar</td>\n",
       "      <td>15 March 2015</td>\n",
       "      <td>Conscious Hip Hop, West Coast Hip Hop, Jazz Rap</td>\n",
       "      <td>political, conscious, poetic, protest, concept...</td>\n",
       "      <td>4.27</td>\n",
       "      <td>44,206</td>\n",
       "      <td>379</td>\n",
       "      <td>March</td>\n",
       "      <td>...</td>\n",
       "      <td>Aftermath / Interscope</td>\n",
       "      <td>Hip Hop</td>\n",
       "      <td>96.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>8.8</td>\n",
       "      <td>3616.0</td>\n",
       "      <td>95</td>\n",
       "      <td>42</td>\n",
       "      <td>93</td>\n",
       "      <td>4530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6.0</td>\n",
       "      <td>Loveless</td>\n",
       "      <td>My Bloody Valentine</td>\n",
       "      <td>4 November 1991</td>\n",
       "      <td>Shoegaze, Noise Pop</td>\n",
       "      <td>noisy, ethereal, atmospheric, romantic, dense,...</td>\n",
       "      <td>4.24</td>\n",
       "      <td>49,887</td>\n",
       "      <td>1223</td>\n",
       "      <td>November</td>\n",
       "      <td>...</td>\n",
       "      <td>Creation</td>\n",
       "      <td>Shoegaze</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>94</td>\n",
       "      <td>9</td>\n",
       "      <td>91</td>\n",
       "      <td>1634</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Ranking                Album               Artist       Release Date  \\\n",
       "0      1.0          OK Computer            Radiohead       16 June 1997   \n",
       "1      2.0   Wish You Were Here           Pink Floyd  12 September 1975   \n",
       "2      4.0                Kid A            Radiohead     3 October 2000   \n",
       "3      5.0  To Pimp a Butterfly       Kendrick Lamar      15 March 2015   \n",
       "4      6.0             Loveless  My Bloody Valentine    4 November 1991   \n",
       "\n",
       "                                            Genres  \\\n",
       "0                       Alternative Rock, Art Rock   \n",
       "1                       Progressive Rock, Art Rock   \n",
       "2          Art Rock, Experimental Rock, Electronic   \n",
       "3  Conscious Hip Hop, West Coast Hip Hop, Jazz Rap   \n",
       "4                              Shoegaze, Noise Pop   \n",
       "\n",
       "                                         Descriptors  Average Rating  \\\n",
       "0  melancholic, anxious, futuristic, alienation, ...            4.23   \n",
       "1  melancholic, atmospheric, progressive, male vo...            4.29   \n",
       "2  cold, melancholic, futuristic, atmospheric, an...            4.21   \n",
       "3  political, conscious, poetic, protest, concept...            4.27   \n",
       "4  noisy, ethereal, atmospheric, romantic, dense,...            4.24   \n",
       "\n",
       "  Number of Ratings  Number of Reviews Release Month  ...  \\\n",
       "0            70,382               1531          June  ...   \n",
       "1            48,662                983     September  ...   \n",
       "2            58,590                734       October  ...   \n",
       "3            44,206                379         March  ...   \n",
       "4            49,887               1223      November  ...   \n",
       "\n",
       "                    Label              Genre Metacritic Critic Score  \\\n",
       "0     Parlophone, Capitol   Alternative Rock                     NaN   \n",
       "1                 Harvest   Progressive Rock                     NaN   \n",
       "2           Capitol / EMI  Experimental Rock                    80.0   \n",
       "3  Aftermath / Interscope            Hip Hop                    96.0   \n",
       "4                Creation           Shoegaze                     NaN   \n",
       "\n",
       "  Metacritic Reviews Metacritic User Score  Metacritic User Reviews  \\\n",
       "0                NaN                   NaN                      NaN   \n",
       "1                NaN                   NaN                      NaN   \n",
       "2               24.0                   8.9                   1129.0   \n",
       "3               44.0                   8.8                   3616.0   \n",
       "4                NaN                   NaN                      NaN   \n",
       "\n",
       "   AOTY Critic Score  AOTY Critic Reviews  AOTY User Score  AOTY User Reviews  \n",
       "0                 91                   12               93               3204  \n",
       "1                100                    4               91               1607  \n",
       "2                 85                   13               92               2862  \n",
       "3                 95                   42               93               4530  \n",
       "4                 94                    9               91               1634  \n",
       "\n",
       "[5 rows x 23 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_merged = df_top.merge(df_ratings,on=['Album','Artist']).reset_index(drop=True)\n",
    "df_merged.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(Index(['Ranking', 'Album', 'Artist', 'Release Date', 'Genres', 'Descriptors',\n",
       "        'Average Rating', 'Number of Ratings', 'Number of Reviews',\n",
       "        'Release Month', 'Release Day', 'Release Year', 'Format', 'Label',\n",
       "        'Genre', 'Metacritic Critic Score', 'Metacritic Reviews',\n",
       "        'Metacritic User Score', 'Metacritic User Reviews', 'AOTY Critic Score',\n",
       "        'AOTY Critic Reviews', 'AOTY User Score', 'AOTY User Reviews'],\n",
       "       dtype='object'), (2308, 23))"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_merged.columns,df_merged.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(<matplotlib.axes._subplots.AxesSubplot at 0x1a560c75be0>,\n",
       " <matplotlib.axes._subplots.AxesSubplot at 0x1a560c75be0>)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_merged['AOTY Critic Score'].hist(), df_merged['Metacritic Critic Score'].hist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1a56309a9e8>"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAD8CAYAAAB5Pm/hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvnQurowAAET1JREFUeJzt3X+s3XV9x/HnW+5QoJFC0TvW1hVngxqaOXuHqAm5tS4KLBYX2VhQC8F1P9CBdJHqP25/mGEiY7gsmI7q6mK8YEdCY9FpKnfTZDRaQQtWQ8UObqkFR6m7iNPO9/44n4bL5dx7Tttzer7nw/ORNPd8v9/POd/X/eZ7X/d7Pvec08hMJEn1etGgA0iS+suil6TKWfSSVDmLXpIqZ9FLUuUsekmqnEUvSZWz6CWpcha9JFVuZNABAM4666xctmxZ221PP/00p5122okNdIyGKSsMV95hygrDldes/dPvvDt37vxJZr6s48DMHPi/lStX5lzuueeeObc1zTBlzRyuvMOUNXO48pq1f/qdF/hWdtGxTt1IUuUsekmqnEUvSZWz6CWpcha9JFXOopekyln0klQ5i16SKmfRS1LlGvERCJKeb9mGbSdkP+tXHObKGfvae+MlJ2S/OnG8opekyln0klQ5i16SKmfRS1LlLHpJqpxFL0mVs+glqXIWvSRVzqKXpMpZ9JJUOYtekipn0UtS5Sx6SaqcRS9JlbPoJalyFr0kVc6il6TKdVX0EfHBiHgwIh6IiM9HxEsi4pyI2BERD0XE7RFxchn74rK8p2xf1s9vQJI0v45FHxGLgb8ExjLzPOAk4HLg48DNmbkcOAhcXe5yNXAwM18F3FzGSZIGpNupmxHglIgYAU4F9gNvAbaU7ZuBS8vtNWWZsn11RERv4kqSjlZkZudBEdcCHwOeAb4CXAvcW67aiYilwJcy87yIeAB4e2ZOlW0/BN6QmT+Z9ZjrgHUAo6OjKycmJtrue3p6mgULFhzjt3diDVNWGK68w5QVepN3175DPUozv9FT4MAzzy6vWHz6CdnvsXghngfzWbVq1c7MHOs0bqTTgIg4g9ZV+jnAU8AXgIvaDD3yG6Pd1fvzfptk5kZgI8DY2FiOj4+33f/k5CRzbWuaYcoKw5V3mLJCb/JeuWFbb8J0sH7FYW7a9WwV7L1i/ITs91i8EM+DXuhm6uatwI8y84nM/CVwJ/AmYGGZygFYAjxWbk8BSwHK9tOBJ3uaWpLUtW6K/hHggog4tcy1rwa+B9wDvKuMWQvcVW5vLcuU7V/LbuaHJEl90bHoM3MHrT+qfhvYVe6zEbgBuD4i9gCLgE3lLpuARWX99cCGPuSWJHWp4xw9QGZ+FPjorNUPA+e3Gftz4LLjjyZJ6gXfGStJlbPoJalyFr0kVc6il6TKWfSSVDmLXpIqZ9FLUuUsekmqnEUvSZWz6CWpcha9JFXOopekyln0klQ5i16SKmfRS1LlLHpJqpxFL0mVs+glqXIWvSRVzqKXpMpZ9JJUOYtekipn0UtS5Sx6SaqcRS9JlbPoJalyFr0kVc6il6TKWfSSVDmLXpIqNzLoAFKTLduw7Zjut37FYa48xvtKveYVvSRVzqKXpMpZ9JJUOYtekipn0UtS5Sx6SapcV0UfEQsjYktEfD8idkfEGyPizIj4akQ8VL6eUcZGRHwyIvZExHcj4vX9/RYkSfPp9or+FuDLmflq4LeB3cAGYHtmLge2l2WAi4Dl5d864NaeJpYkHZWORR8RLwUuBDYBZOYvMvMpYA2wuQzbDFxabq8BPpst9wILI+LsnieXJHWlmyv6VwJPAJ+JiPsi4raIOA0Yzcz9AOXry8v4xcCjM+4/VdZJkgYgMnP+ARFjwL3AmzNzR0TcAvwU+EBmLpwx7mBmnhER24C/zcxvlPXbgQ9l5s5Zj7uO1tQOo6OjKycmJtruf3p6mgULFhzzN3giDVNWGK68g8q6a9+hY7rf6Clw4Jkeh+mT2VlXLD59cGE6GKZzFvqfd9WqVTszc6zTuG4+62YKmMrMHWV5C635+AMRcXZm7i9TM4/PGL90xv2XAI/NftDM3AhsBBgbG8vx8fG2O5+cnGSubU0zTFlhuPIOKuuxfl7N+hWHuWnXcHyU1Oyse68YH1yYDobpnIXm5O04dZOZPwYejYhzy6rVwPeArcDasm4tcFe5vRV4b3n1zQXAoSNTPJKkE6/bS44PAJ+LiJOBh4GraP2SuCMirgYeAS4rY+8GLgb2AD8rYyVJA9JV0Wfm/UC7eaDVbcYmcM1x5pIk9YjvjJWkyln0klQ5i16SKmfRS1LlLHpJqpxFL0mVs+glqXIWvSRVzqKXpMpZ9JJUOYtekipn0UtS5Sx6SaqcRS9JlbPoJalyFr0kVc6il6TKWfSSVDmLXpIqZ9FLUuUsekmqnEUvSZWz6CWpcha9JFXOopekyln0klQ5i16SKmfRS1LlLHpJqpxFL0mVs+glqXIWvSRVzqKXpMpZ9JJUOYtekipn0UtS5Sx6Sapc10UfESdFxH0R8cWyfE5E7IiIhyLi9og4uax/cVneU7Yv6090SVI3juaK/lpg94zljwM3Z+Zy4CBwdVl/NXAwM18F3FzGSZIGpKuij4glwCXAbWU5gLcAW8qQzcCl5faaskzZvrqMlyQNQLdX9H8PfAj4VVleBDyVmYfL8hSwuNxeDDwKULYfKuMlSQMQmTn/gIjfBy7OzL+IiHHgr4CrgP8s0zNExFLg7sxcEREPAm/LzKmy7YfA+Zn537Medx2wDmB0dHTlxMRE2/1PT0+zYMGC4/gWT5xhygrDlXdQWXftO3RM9xs9BQ480+MwfTI764rFpw8uTAfDdM5C//OuWrVqZ2aOdRo30sVjvRl4R0RcDLwEeCmtK/yFETFSrtqXAI+V8VPAUmAqIkaA04EnZz9oZm4ENgKMjY3l+Ph4251PTk4y17amGaasMFx5B5X1yg3bjul+61cc5qZd3fx4Dd7srHuvGB9cmA6G6ZyF5uTtOHWTmR/OzCWZuQy4HPhaZl4B3AO8qwxbC9xVbm8ty5TtX8tOTxskSX1zPK+jvwG4PiL20JqD31TWbwIWlfXXAxuOL6Ik6Xgc1XPLzJwEJsvth4Hz24z5OXBZD7JJknrAd8ZKUuUsekmqnEUvSZUbjtd/6QVv175Dx/xSR+mFzit6SaqcRS9JlbPoJalyFr0kVc6il6TKWfSSVDmLXpIqZ9FLUuUsekmqnEUvSZWz6CWpcha9JFXOopekyln0klQ5i16SKmfRS1LlLHpJqpxFL0mVs+glqXIWvSRVzqKXpMpZ9JJUOYtekipn0UtS5Sx6SaqcRS9JlbPoJalyFr0kVc6il6TKWfSSVDmLXpIqZ9FLUuUsekmqnEUvSZUb6TQgIpYCnwV+HfgVsDEzb4mIM4HbgWXAXuAPM/NgRARwC3Ax8DPgysz8dn/iS+q1ZRu2DWzfe2+8ZGD7rlk3V/SHgfWZ+RrgAuCaiHgtsAHYnpnLge1lGeAiYHn5tw64teepJUld61j0mbn/yBV5Zv4PsBtYDKwBNpdhm4FLy+01wGez5V5gYUSc3fPkkqSuRGZ2PzhiGfAfwHnAI5m5cMa2g5l5RkR8EbgxM79R1m8HbsjMb816rHW0rvgZHR1dOTEx0Xaf09PTLFiw4Gi+p4EZpqwwXHkff/IQB54ZdIrujZ7C0ORtUtYVi0+fd/swnbPQ/7yrVq3amZljncZ1nKM/IiIWAP8KXJeZP21Nxbcf2mbd836bZOZGYCPA2NhYjo+Pt32wyclJ5trWNMOUFYYr7z987i5u2tX16Tpw61ccHpq8Tcq694rxebcP0zkLzcnb1atuIuLXaJX85zLzzrL6wJEpmfL18bJ+Clg64+5LgMd6E1eSdLQ6Fn15Fc0mYHdm/t2MTVuBteX2WuCuGevfGy0XAIcyc38PM0uSjkI3z9feDLwH2BUR95d1HwFuBO6IiKuBR4DLyra7ab20cg+tl1de1dPEkqSj0rHoyx9V55qQX91mfALXHGcuSVKP+M5YSaqcRS9JlbPoJalyFr0kVc6il6TKWfSSVDmLXpIqZ9FLUuUsekmqnEUvSZWz6CWpcha9JFXOopekyln0klQ5i16SKmfRS1LlLHpJqpxFL0mVs+glqXIWvSRVzqKXpMpZ9JJUuZFBB9BwWbZh20D2u37FQHYrVcErekmqnEUvSZWz6CWpcs7RS2qMTn8DWr/iMFf24e9Ee2+8pOeP2SRe0UtS5Sx6SaqcRS9JlbPoJalyFr0kVc6il6TKWfSSVDlfRz+EevV5M/16TbKkZvGKXpIqZ9FLUuX6UvQR8faI+EFE7ImIDf3YhySpOz2fo4+Ik4B/BH4PmAK+GRFbM/N7vd7XoM2eK3fOW1IT9eOPsecDezLzYYCImADWAH0p+kH9RxiSNCz6UfSLgUdnLE8Bb+jDfiSpJ/p1wdjNs/wT8cmZkZm9fcCIy4C3Zeb7yvJ7gPMz8wOzxq0D1pXFc4EfzPGQZwE/6WnI/hmmrDBceYcpKwxXXrP2T7/z/mZmvqzToH5c0U8BS2csLwEemz0oMzcCGzs9WER8KzPHehevf4YpKwxX3mHKCsOV16z905S8/XjVzTeB5RFxTkScDFwObO3DfiRJXej5FX1mHo6I9wP/BpwEfDozH+z1fiRJ3enLRyBk5t3A3T16uI7TOw0yTFlhuPIOU1YYrrxm7Z9G5O35H2MlSc3iRyBIUuUaVfQRsTAitkTE9yNid0S8MSLOjIivRsRD5esZg84Jc2b964jYFxH3l38XDzonQEScOyPT/RHx04i4ronHdp6sjTy2ABHxwYh4MCIeiIjPR8RLyosRdpRje3t5YcLAzZH1nyPiRzOO7esGnfOIiLi2ZH0wIq4r6xp33sKcWRtx3jZq6iYiNgNfz8zbyg/GqcBHgCcz88byuTlnZOYNAw3KnFmvA6Yz8xODTTe38hEV+2i9ie0aGnhsj5iV9SoaeGwjYjHwDeC1mflMRNxB6+9TFwN3ZuZERHwK+E5m3trQrOPAFzNzyyDzzRYR5wETtN5t/wvgy8CfA39Cw87bebJeQQPO28Zc0UfES4ELgU0AmfmLzHyK1scnbC7DNgOXDibhs+bJOgxWAz/MzP+igcd2lplZm2wEOCUiRmj9wt8PvAU4UpxNOrazsz7vPS4N8hrg3sz8WWYeBv4deCfNPG/nytoIjSl64JXAE8BnIuK+iLgtIk4DRjNzP0D5+vJBhizmygrw/oj4bkR8uilPKWe5HPh8ud3EYzvTzKzQwGObmfuATwCP0Cr4Q8BO4KnyAw+tNxEuHkzCZ7XLmplfKZs/Vo7tzRHx4oGFfK4HgAsjYlFEnErrWdJSmnnezpUVGnDeNqnoR4DXA7dm5u8ATwNN/YjjubLeCvwW8DpaP0g3DSxhG2WK6R3AFwadpZM2WRt5bMsP7hrgHOA3gNOAi9oMHfgcabusEfFu4MPAq4HfBc4EGjF9l5m7gY8DX6U1FfId4PC8dxqQebI24rxtUtFPAVOZuaMsb6FVpgci4myA8vXxAeWbqW3WzDyQmf+Xmb8C/onWfF2TXAR8OzMPlOUmHtsjnpO1wcf2rcCPMvOJzPwlcCfwJmBhmR6BOT4GZADaZs3M/dnyv8BnaM6xJTM3ZebrM/NC4EngIRp63rbL2pTztjFFn5k/Bh6NiHPLqtW0Ptp4K7C2rFsL3DWAeM8xV9YjJ1/xTlpP55rkj3nuVEjjju0Mz8na4GP7CHBBRJwaEcGz5+09wLvKmKYc23ZZd88ozaA1392UY0tEvLx8fQXwB7TOiUaet+2yNuW8bdqrbl4H3AacDDxM65UWLwLuAF5B60S9LDOfHFjIYo6sn6T1FC2BvcCfHplLHLQyb/go8MrMPFTWLaKZx7Zd1n+hucf2b4A/ovVU/T7gfbTm5CdoTYXcB7y7XDEP1BxZvwS8DAjgfuDPMnN6YCFniIivA4uAXwLXZ+b2Bp+37bI24rxtVNFLknqvMVM3kqT+sOglqXIWvSRVzqKXpMpZ9JJUOYtekipn0UtS5Sx6Sarc/wM8LWF8KYNBQwAAAABJRU5ErkJggg==",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_merged['AOTY User Score'].hist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1a56309a278>"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAD8CAYAAAB5Pm/hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvnQurowAAFhxJREFUeJzt3X+QXeV93/H3N2BshY0lAWZHlVTLqRXX1Kox2lJ1PJPsIrcBkUG0RR0YHASjRm1CaDpWiuW2M206zViphxIz46HRgGPhxl4TGhcNEKeM0LZDxyKxDJaMiYNMVVikSjEWcteQpHK+/eM+Ipdlf9zl3r338OT9mrmz5zzn2Xs/d6/02bPnnj0bmYkkqV4/MugAkqTFZdFLUuUsekmqnEUvSZWz6CWpcha9JFXOopekyln0klQ5i16SKnfuoAMAXHTRRblmzZpBx5jRD37wA84///xBx5iV+brT9HzQ/Izm6043+Q4ePPjdzHzXvBMzc+C39evXZ1Pt379/0BHmZL7uND1fZvMzmq873eQDvpYddKyHbiSpcha9JFXOopekyln0klQ5i16SKmfRS1LlLHpJqpxFL0mVs+glqXKNuASCFmbNzodfW96x7gw3t60vtqO7ru7bY0nqDffoJalyFr0kVc6il6TKWfSSVDmLXpIqZ9FLUuUsekmqnEUvSZWz6CWpcvMWfUS8LyKeart9PyL+eURcEBGPRsSz5ePyMj8i4q6IOBIRhyLissV/GpKk2cxb9Jn57cy8NDMvBdYDrwBfBnYC+zJzLbCvrANcBawtt+3A3YsRXJLUmYUeutkIfCcz/zewGdhTxvcA15blzcB95Y+UHwCWRcSKnqSVJC3YQov+euCLZXk4M48DlI8Xl/GVwAttnzNZxiRJAxCZ2dnEiPOAY8DfyMwTEfFyZi5r234qM5dHxMPAJzPz8TK+D7g9Mw9Ou7/ttA7tMDw8vH58fLw3z6jHpqamGBoaGnSM1zn84unXloeXwIlX+/fY61YuXdD8Jn792jU9HzQ/o/m6002+sbGxg5k5Mt+8hVym+Crg65l5oqyfiIgVmXm8HJo5WcYngdVtn7eK1jeI18nM3cBugJGRkRwdHV1AlP6ZmJigadlunnaZ4jsO9+9q00dvHF3Q/CZ+/do1PR80P6P5utOPfAs5dHMDf3HYBmAvsLUsbwUebBu/qZx9swE4ffYQjySp/zraFYyIHwX+LvBP2oZ3AfdHxDbgeWBLGX8E2AQcoXWGzi09SytJWrCOij4zXwEunDb2Eq2zcKbPTeDWnqSTJHXN34yVpMpZ9JJUOYtekipn0UtS5Sx6SaqcRS9JlbPoJalyFr0kVc6il6TKWfSSVDmLXpIqZ9FLUuUsekmqnEUvSZWz6CWpcha9JFXOopekyln0klQ5i16SKtdR0UfEsoh4ICL+MCKeiYi/ExEXRMSjEfFs+bi8zI2IuCsijkTEoYi4bHGfgiRpLp3u0X8a+Epm/nXgg8AzwE5gX2auBfaVdYCrgLXlth24u6eJJUkLMm/RR8Q7gZ8E7gXIzD/LzJeBzcCeMm0PcG1Z3gzcly0HgGURsaLnySVJHelkj/7HgT8GfjMinoyIeyLifGA4M48DlI8Xl/krgRfaPn+yjEmSBiAyc+4JESPAAeDDmflERHwa+D5wW2Yua5t3KjOXR8TDwCcz8/Eyvg+4PTMPTrvf7bQO7TA8PLx+fHy8l8+rZ6amphgaGhp0jNc5/OLp15aHl8CJV/v32OtWLl3Q/CZ+/do1PR80P6P5utNNvrGxsYOZOTLfvHM7uK9JYDIznyjrD9A6Hn8iIlZk5vFyaOZk2/zVbZ+/Cjg2/U4zczewG2BkZCRHR0c7iNJ/ExMTNC3bzTsffm15x7oz3HG4k5exN47eOLqg+U38+rVrej5ofkbzdacf+eY9dJOZ/wd4ISLeV4Y2At8C9gJby9hW4MGyvBe4qZx9swE4ffYQjySp/zrdFbwN+K2IOA94DriF1jeJ+yNiG/A8sKXMfQTYBBwBXilzJUkD0lHRZ+ZTwEzHgTbOMDeBW7vMJUnqEX8zVpIqZ9FLUuX6d7qGqrCm7YyfTuxYd+Z1Zwm9WUd3Xd31fUh/WblHL0mVs+glqXIWvSRVzqKXpMpZ9JJUOYtekipn0UtS5Sx6SaqcRS9JlbPoJalyFr0kVc6il6TKWfSSVDmLXpIqZ9FLUuU6KvqIOBoRhyPiqYj4Whm7ICIejYhny8flZTwi4q6IOBIRhyLissV8ApKkuS1kj34sMy/NzLN/O3YnsC8z1wL7yjrAVcDactsO3N2rsJKkhevm0M1mYE9Z3gNc2zZ+X7YcAJZFxIouHkeS1IVOiz6B/xYRByNiexkbzszjAOXjxWV8JfBC2+dOljFJ0gBEZs4/KeKvZOaxiLgYeBS4Ddibmcva5pzKzOUR8TDwycx8vIzvA27PzIPT7nM7rUM7DA8Prx8fH+/Zk+qlqakphoaGBh3jdQ6/ePq15eElcOLVAYaZR6/yrVu5tPs7mUETX9/pmp7RfN3pJt/Y2NjBtsPps+roj4Nn5rHy8WREfBm4HDgRESsy83g5NHOyTJ8EVrd9+irg2Az3uRvYDTAyMpKjo6OdROm7iYkJmpat/Y9t71h3hjsON/dvvPcq39EbR7sPM4Mmvr7TNT2j+brTj3zzHrqJiPMj4sfOLgN/D/gmsBfYWqZtBR4sy3uBm8rZNxuA02cP8UiS+q+TXa1h4MsRcXb+FzLzKxHxB8D9EbENeB7YUuY/AmwCjgCvALf0PLUkqWPzFn1mPgd8cIbxl4CNM4wncGtP0kmSuuZvxkpS5Sx6Sapcc0/XeAtY03b2iyQ1lXv0klQ5i16SKmfRS1LlLHpJqpxFL0mVs+glqXIWvSRVzqKXpMpZ9JJUOYtekipn0UtS5Sx6SaqcRS9JlbPoJalyFr0kVc6il6TKdVz0EXFORDwZEQ+V9fdExBMR8WxEfCkizivjby/rR8r2NYsTXZLUiYXs0f8S8Ezb+q8Bd2bmWuAUsK2MbwNOZeZ7gTvLPEnSgHRU9BGxCrgauKesB3AF8ECZsge4tixvLuuU7RvLfEnSAHS6R//rwO3An5f1C4GXM/NMWZ8EVpbllcALAGX76TJfkjQAkZlzT4j4GWBTZv5CRIwCvwzcAny1HJ4hIlYDj2Tmuoh4GvjpzJws274DXJ6ZL0273+3AdoDh4eH14+PjvX1mPTI1NcXQ0NCM2w6/eLrPad5oeAmceHXQKWbXq3zrVi7t/k5mMNfr2xRNz2i+7nSTb2xs7GBmjsw379wO7uvDwDURsQl4B/BOWnv4yyLi3LLXvgo4VuZPAquByYg4F1gKfG/6nWbmbmA3wMjISI6OjnYQpf8mJiaYLdvNOx/ub5gZ7Fh3hjsOd/IyDkav8h29cbT7MDOY6/VtiqZnNF93+pFv3kM3mfmJzFyVmWuA64HHMvNGYD9wXZm2FXiwLO8t65Ttj+V8PzZIkhZNN+fRfxz4WEQcoXUM/t4yfi9wYRn/GLCzu4iSpG4s6GfqzJwAJsryc8DlM8z5E2BLD7JJknrA34yVpMpZ9JJUOYtekipn0UtS5Sx6SaqcRS9JlbPoJalyFr0kVc6il6TKWfSSVDmLXpIqZ9FLUuUsekmqnEUvSZWz6CWpcha9JFXOopekyln0klQ5i16SKjdv0UfEOyLi9yPiGxHxdET8Shl/T0Q8ERHPRsSXIuK8Mv72sn6kbF+zuE9BkjSXTvbo/xS4IjM/CFwKXBkRG4BfA+7MzLXAKWBbmb8NOJWZ7wXuLPMkSQMyb9Fny1RZfVu5JXAF8EAZ3wNcW5Y3l3XK9o0RET1LLElakMjM+SdFnAMcBN4LfAb4FHCg7LUTEauB383MD0TEN4ErM3OybPsO8Lcz87vT7nM7sB1geHh4/fj4eO+eVQ9NTU0xNDQ047bDL57uc5o3Gl4CJ14ddIrZ9SrfupVLu7+TGcz1+jZF0zOarzvd5BsbGzuYmSPzzTu3kzvLzB8Cl0bEMuDLwPtnmlY+zrT3/obvJpm5G9gNMDIykqOjo51E6buJiQlmy3bzzof7G2YGO9ad4Y7DHb2MA9GrfEdvHO0+zAzmen2boukZzdedfuRb0Fk3mfkyMAFsAJZFxNn/wauAY2V5ElgNULYvBb7Xi7CSpIXr5Kybd5U9eSJiCfAR4BlgP3BdmbYVeLAs7y3rlO2PZSfHhyRJi6KTn6lXAHvKcfofAe7PzIci4lvAeET8e+BJ4N4y/17g8xFxhNae/PWLkFuS1KF5iz4zDwEfmmH8OeDyGcb/BNjSk3SSpK75m7GSVDmLXpIqZ9FLUuUsekmqnEUvSZWz6CWpcha9JFXOopekyln0klQ5i16SKtfc69tKbdYs0iWhd6w7M+flpo/uunpRHlfqJ/foJalyFr0kVc6il6TKWfSSVDmLXpIqZ9FLUuUsekmqXCd/HHx1ROyPiGci4umI+KUyfkFEPBoRz5aPy8t4RMRdEXEkIg5FxGWL/SQkSbPrZI/+DLAjM98PbABujYhLgJ3AvsxcC+wr6wBXAWvLbTtwd89TS5I6Nm/RZ+bxzPx6Wf6/wDPASmAzsKdM2wNcW5Y3A/dlywFgWUSs6HlySVJHFnSMPiLWAB8CngCGM/M4tL4ZABeXaSuBF9o+bbKMSZIGIDKzs4kRQ8B/B341M38nIl7OzGVt209l5vKIeBj4ZGY+Xsb3Abdn5sFp97ed1qEdhoeH14+Pj/fmGfXY1NQUQ0NDM247/OLpPqd5o+ElcOLVQaeY3Vs937qVS/sXZhZz/RtsAvN1p5t8Y2NjBzNzZL55HV3ULCLeBvwX4Lcy83fK8ImIWJGZx8uhmZNlfBJY3fbpq4Bj0+8zM3cDuwFGRkZydHS0kyh9NzExwWzZ5roYVr/sWHeGOw4399p0b/V8R28c7V+YWcz1b7AJzNedfuTr5KybAO4FnsnM/9i2aS+wtSxvBR5sG7+pnH2zATh99hCPJKn/OtnV+jDws8DhiHiqjP1LYBdwf0RsA54HtpRtjwCbgCPAK8AtPU0sSVqQeYu+HGuPWTZvnGF+Ard2mUuS1CP+ZqwkVc6il6TKWfSSVDmLXpIqZ9FLUuUsekmqnEUvSZWz6CWpcha9JFXOopekyln0klQ5i16SKmfRS1LlLHpJqpxFL0mVa+7feJMaYM0A/1zk0V1XD+yxVRf36CWpcha9JFXOopekys1b9BHx2Yg4GRHfbBu7ICIejYhny8flZTwi4q6IOBIRhyLissUML0maXyd79J8Drpw2thPYl5lrgX1lHeAqYG25bQfu7k1MSdKbNW/RZ+b/AL43bXgzsKcs7wGubRu/L1sOAMsiYkWvwkqSFi4yc/5JEWuAhzLzA2X95cxc1rb9VGYuj4iHgF2Z+XgZ3wd8PDO/NsN9bqe118/w8PD68fHxHjyd3puammJoaGjGbYdfPN3nNG80vAROvDroFLMz35u3buVSYO5/g01gvu50k29sbOxgZo7MN6/X59HHDGMzfifJzN3AboCRkZEcHR3tcZTemJiYYLZsNw/wHOuzdqw7wx2Hm/vrEOZ7847eOArM/W+wCczXnX7ke7Nn3Zw4e0imfDxZxieB1W3zVgHH3nw8SVK33mzR7wW2luWtwINt4zeVs282AKcz83iXGSVJXZj3Z9aI+CIwClwUEZPAvwF2AfdHxDbgeWBLmf4IsAk4ArwC3LIImSVJCzBv0WfmDbNs2jjD3ARu7TaUJKl3/M1YSaqcRS9JlbPoJalyFr0kVc6il6TKWfSSVDmLXpIq18yLfEh67e/V7lh3pq/XVfJv1dbHPXpJqpxFL0mVs+glqXIWvSRVzjdjJb3OmgW+8dvLN4t9I3hxuEcvSZWz6CWpcha9JFXuLX+MfqHHExeq37+sIkm99pYvekn1WIwdt0521mp/E3hRij4irgQ+DZwD3JOZuxbjcSSpFxb7yMBcPnfl+Yv+GD0/Rh8R5wCfAa4CLgFuiIhLev04kqTOLMabsZcDRzLzucz8M2Ac2LwIjyNJ6sBiFP1K4IW29ckyJkkagMjM3t5hxBbgpzPzH5f1nwUuz8zbps3bDmwvq+8Dvt3TIL1zEfDdQYeYg/m60/R80PyM5utON/nenZnvmm/SYrwZOwmsbltfBRybPikzdwO7F+HxeyoivpaZI4POMRvzdafp+aD5Gc3XnX7kW4xDN38ArI2I90TEecD1wN5FeBxJUgd6vkefmWci4heB36N1euVnM/PpXj+OJKkzi3IefWY+AjyyGPc9AE0/vGS+7jQ9HzQ/o/m6s+j5ev5mrCSpWbyomSRVzqIHIuIdEfH7EfGNiHg6In5llnn/KCK+VeZ8oUn5IuLOiHiq3P4oIl5uWL6/GhH7I+LJiDgUEZsalu/dEbGvZJuIiFX9yteW4Zzy9Xlohm1vj4gvRcSRiHgiItY0LN9PRsTXI+JMRFzX72wd5PtY+b97qLzO725Yvn8aEYfL/9/He341gcz8S38DAhgqy28DngA2TJuzFngSWF7WL25Svmnzb6P1Jnhj8tE6DvnzZfkS4GjD8v02sLUsXwF8vp//Bsvjfgz4AvDQDNt+AfhPZfl64EsNy7cG+JvAfcB1/c7WQb4x4EfL8s838Ov3zrbla4Cv9PKx3aMHsmWqrL6t3Ka/efFzwGcy81T5nJMNy9fuBuCLix6s6DBfAu8sy0uZ4XcrFkuH+S4B9pXl/fT5sh3lJ4irgXtmmbIZ2FOWHwA2RkT0IxvMny8zj2bmIeDP+5WpXQf59mfmK2X1AK3f7+mbDvJ9v231fOb+/71gFn1Rfqx6CjgJPJqZT0yb8hPAT0TE/4yIA+UKnU3Kd3beu4H3AI81LN+/BT4aEZO0zsi6jT7qIN83gH9Ylv8+8GMRcWEfI/46cDuzF+VrlxbJzDPAaaBJ+QZtIfm2Ab+7uHHeYN58EXFrRHwH+A/AP+vlg1v0RWb+MDMvpfWd/vKI+MC0KefSOnwzSmuP+Z6IWNagfGddDzyQmT/sVzboKN8NwOcycxWwCfh8RPTt318H+X4Z+KmIeBL4KeBF4Ew/skXEzwAnM/PgXNNmGOvLKXMd5huYheSLiI8CI8CnFj3YXzxmR/ky8zOZ+deAjwP/upcZLPppMvNlYAKYvsc+CTyYmf8vM/8XrWvzrO1zvLnynXU9fTxsM90c+bYB95c5XwXeQesaH301W77MPJaZ/yAzPwT8qzJ2uk+xPgxcExFHaV3t9YqI+M/T5rx2aZGIOJfW4a/vNSjfIHWULyI+Quu1vSYz/7Rp+dqMA9f2MoBFD0TEu87unUfEEuAjwB9Om/Zfab2hQ0RcROtQznMNykdEvA9YDny1H7kWmO95YGOZ835aRf/HTckXERe1/YTxCeCz/cgGkJmfyMxVmbmG1jfqxzLzo9Om7QW2luXrypy+7NF3mG9gOskXER8CfoNWyfft/bUF5GvfabwaeLaXGSz6lhXA/og4ROtaPY9m5kMR8e8i4poy5/eAlyLiW7TerPsXmflSg/JB6/DIeL8KYIH5dgA/FxHfoPUTx819zNlJvlHg2xHxR8Aw8Kt9yjarafnuBS6MiCO0zt7YObhkLe35IuJvlfdftgC/EREDv+zJtK/fp4Ah4LfLKYwDv/7WtHy/GK1Tf5+i9fpuneNTF/5Y/e8ESVI/uUcvSZWz6CWpcha9JFXOopekyln0klQ5i16SKmfRS1LlLHpJqtz/B8g//JSqa2RyAAAAAElFTkSuQmCC",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_merged['Average Rating'].hist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(2265,)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Number of albums, number of rows\n",
    "df_merged['Album'].unique().shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "It looks like we went from 5000 to 2265 ratings after merging. The ratings dataset has 32k+ rows in it, so I'm guessing there are some repeats or something that dont get included in the merge."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_merged.to_csv(\"merged_features.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0                                             OK Computer\n",
       "1                                      Wish You Were Here\n",
       "2                                                   Kid A\n",
       "3                                     To Pimp a Butterfly\n",
       "4                                                Loveless\n",
       "5                               The Dark Side of the Moon\n",
       "6                                              Abbey Road\n",
       "7                           The Velvet Underground & Nico\n",
       "8       The Rise and Fall of Ziggy Stardust and the Sp...\n",
       "9                                                Revolver\n",
       "10                                            Madvillainy\n",
       "11                                        Remain in Light\n",
       "12                                            In Rainbows\n",
       "13                                         A Love Supreme\n",
       "14                                               Paranoid\n",
       "15                                           Kind of Blue\n",
       "16                                             Pet Sounds\n",
       "17                                               Illmatic\n",
       "18                          In the Aeroplane Over the Sea\n",
       "19                  Sgt. Pepper's Lonely Hearts Club Band\n",
       "20                                                    Red\n",
       "21                      My Beautiful Dark Twisted Fantasy\n",
       "22                                              Pink Moon\n",
       "23                                             Spiderland\n",
       "24                                         Disintegration\n",
       "25                                      Unknown Pleasures\n",
       "26                                                Animals\n",
       "27                                   Highway 61 Revisited\n",
       "28                                              Doolittle\n",
       "29                                        In a Silent Way\n",
       "                              ...                        \n",
       "2278                                      The Black Light\n",
       "2279                                 Twilight of the Gods\n",
       "2280                                            Character\n",
       "2281                                    Shine On Brightly\n",
       "2282                                              Visions\n",
       "2283                                                 Isla\n",
       "2284                                      On Avery Island\n",
       "2285                                               So Far\n",
       "2286                                           Blood Lust\n",
       "2287                                             End Hits\n",
       "2288                                           From Sleep\n",
       "2289                             Sunrise on the Sufferbus\n",
       "2290                                              My Life\n",
       "2291                                            Embryonic\n",
       "2292                                         Gentle Giant\n",
       "2293                                           The End...\n",
       "2294                                  Secondhand Daylight\n",
       "2295                                                 Pure\n",
       "2296                    From Gardens Where We Feel Secure\n",
       "2297                                        Soviet Kitsch\n",
       "2298                                              Vheissu\n",
       "2299                                       Ancient Dreams\n",
       "2300                                 Like Gods of the Sun\n",
       "2301                                   Demons Dance Alone\n",
       "2302                                     The True Meaning\n",
       "2303                                     Abandon All Life\n",
       "2304                          Little Dominiques Nosebleed\n",
       "2305                                                 I Am\n",
       "2306                                     Bring the Family\n",
       "2307                               Adventures in Paradise\n",
       "Name: Album, Length: 2308, dtype: object"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_merged['Album']"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.10.8 64-bit (microsoft store)",
   "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.10.8"
  },
  "vscode": {
   "interpreter": {
    "hash": "8032a63ce2432f84457a3c84e7fa27621980d8193dc3146d83373a4ae272cba9"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}