build3_modeltesting.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "build3_modeltesting.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "machine_shape": "hm"
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "accelerator": "GPU"
  },
  "cells": [
    {
      "cell_type": "code",
      "metadata": {
        "id": "QQJKHm7MBPzp",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import json\n",
        "import pandas as pd"
      ],
      "execution_count": 36,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "IhN7nKQ1FlDN",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import random\n",
        "p = 0.01  # 1% of the lines\n",
        "# keep the header, then take only 1% of lines\n",
        "# if random from [0,1] interval is greater than 0.01 the row will be skipped\n",
        "df = pd.read_csv(\n",
        "         '/content/data.csv', \n",
        "         skiprows=lambda i: i>0 and random.random() > p)"
      ],
      "execution_count": 37,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "gikTOuyYqv7r",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 233
        },
        "outputId": "da0e19ed-f9cd-4d59-af03-92183f64fb91"
      },
      "source": [
        "df.head(2)"
      ],
      "execution_count": 38,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>acousticness</th>\n",
              "      <th>artists</th>\n",
              "      <th>danceability</th>\n",
              "      <th>duration_ms</th>\n",
              "      <th>energy</th>\n",
              "      <th>explicit</th>\n",
              "      <th>id</th>\n",
              "      <th>instrumentalness</th>\n",
              "      <th>key</th>\n",
              "      <th>liveness</th>\n",
              "      <th>loudness</th>\n",
              "      <th>mode</th>\n",
              "      <th>name</th>\n",
              "      <th>popularity</th>\n",
              "      <th>release_date</th>\n",
              "      <th>speechiness</th>\n",
              "      <th>tempo</th>\n",
              "      <th>valence</th>\n",
              "      <th>year</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0.992</td>\n",
              "      <td>['Francisco Canaro', 'Charlo']</td>\n",
              "      <td>0.373</td>\n",
              "      <td>204000</td>\n",
              "      <td>0.239</td>\n",
              "      <td>0</td>\n",
              "      <td>43aHhXYKEQ6iitIbfFdUWI</td>\n",
              "      <td>0.848</td>\n",
              "      <td>4</td>\n",
              "      <td>0.179</td>\n",
              "      <td>-9.449</td>\n",
              "      <td>1</td>\n",
              "      <td>Nunca Jamás - Remasterizado</td>\n",
              "      <td>0</td>\n",
              "      <td>1930-11-13</td>\n",
              "      <td>0.079</td>\n",
              "      <td>83.856</td>\n",
              "      <td>0.589</td>\n",
              "      <td>1930</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>0.491</td>\n",
              "      <td>['Эрнест Хемингуэй']</td>\n",
              "      <td>0.729</td>\n",
              "      <td>101745</td>\n",
              "      <td>0.136</td>\n",
              "      <td>1</td>\n",
              "      <td>4q6G3SMiRzm5udxGEw6jyx</td>\n",
              "      <td>0.000</td>\n",
              "      <td>11</td>\n",
              "      <td>0.118</td>\n",
              "      <td>-16.814</td>\n",
              "      <td>0</td>\n",
              "      <td>Часть 8.4 &amp; Часть 9.1 - Зеленые холмы Африки</td>\n",
              "      <td>0</td>\n",
              "      <td>1935</td>\n",
              "      <td>0.936</td>\n",
              "      <td>83.848</td>\n",
              "      <td>0.510</td>\n",
              "      <td>1935</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   acousticness                         artists  ...  valence  year\n",
              "0         0.992  ['Francisco Canaro', 'Charlo']  ...    0.589  1930\n",
              "1         0.491            ['Эрнест Хемингуэй']  ...    0.510  1935\n",
              "\n",
              "[2 rows x 19 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 38
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "C1TbmbHa6Lse",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "df['artists'] = df['artists'].apply(lambda x: x[1:-1].split(', ')) # makes the string lists in artists column into actual lists\n",
        "\n",
        "df = df.explode('artists') # opens the lists so that each artist is on a song has his own row with the song\n",
        "\n",
        "df['artists'] = df['artists'].apply(lambda x: x.strip(\"'\")) #  we want to take off the quotes on the artists"
      ],
      "execution_count": 39,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "7J7sc6tPdsWy",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "#using only these three to test \n",
        "raw_data =  df.loc[:,['artists','name','popularity','year']] "
      ],
      "execution_count": 40,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "WDcQ08LI56nh",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "outputId": "8a23e8a3-aa16-4194-e5e1-238344e3c12d"
      },
      "source": [
        "raw_data"
      ],
      "execution_count": 41,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>artists</th>\n",
              "      <th>name</th>\n",
              "      <th>popularity</th>\n",
              "      <th>year</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Francisco Canaro</td>\n",
              "      <td>Nunca Jamás - Remasterizado</td>\n",
              "      <td>0</td>\n",
              "      <td>1930</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Charlo</td>\n",
              "      <td>Nunca Jamás - Remasterizado</td>\n",
              "      <td>0</td>\n",
              "      <td>1930</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Эрнест Хемингуэй</td>\n",
              "      <td>Часть 8.4 &amp; Часть 9.1 - Зеленые холмы Африки</td>\n",
              "      <td>0</td>\n",
              "      <td>1935</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Jeanette MacDonald</td>\n",
              "      <td>Dinah, Some of These Days</td>\n",
              "      <td>0</td>\n",
              "      <td>1936</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Gilda Gray</td>\n",
              "      <td>Dinah, Some of These Days</td>\n",
              "      <td>0</td>\n",
              "      <td>1936</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1635</th>\n",
              "      <td>The National</td>\n",
              "      <td>Don't Swallow the Cap</td>\n",
              "      <td>58</td>\n",
              "      <td>2013</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1636</th>\n",
              "      <td>Dimitri Vegas &amp; Like Mike</td>\n",
              "      <td>Tremor - Sensation 2014 Anthem</td>\n",
              "      <td>58</td>\n",
              "      <td>2014</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1636</th>\n",
              "      <td>Martin Garrix</td>\n",
              "      <td>Tremor - Sensation 2014 Anthem</td>\n",
              "      <td>58</td>\n",
              "      <td>2014</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1637</th>\n",
              "      <td>Imagine Dragons</td>\n",
              "      <td>Walking The Wire</td>\n",
              "      <td>70</td>\n",
              "      <td>2017</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1638</th>\n",
              "      <td>Mitski</td>\n",
              "      <td>Nobody</td>\n",
              "      <td>65</td>\n",
              "      <td>2018</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>2130 rows × 4 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                        artists  ...  year\n",
              "0              Francisco Canaro  ...  1930\n",
              "0                        Charlo  ...  1930\n",
              "1              Эрнест Хемингуэй  ...  1935\n",
              "2            Jeanette MacDonald  ...  1936\n",
              "2                    Gilda Gray  ...  1936\n",
              "...                         ...  ...   ...\n",
              "1635               The National  ...  2013\n",
              "1636  Dimitri Vegas & Like Mike  ...  2014\n",
              "1636              Martin Garrix  ...  2014\n",
              "1637            Imagine Dragons  ...  2017\n",
              "1638                     Mitski  ...  2018\n",
              "\n",
              "[2130 rows x 4 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 41
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ag-hoEbh6fqW",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 221
        },
        "outputId": "1f5152ed-50e1-4952-ba1b-b3a67ca86e35"
      },
      "source": [
        "raw_data['artists'].value_counts()"
      ],
      "execution_count": 42,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Эрнест Хемингуэй                    24\n",
              "Francisco Canaro                    22\n",
              "Wolfgang Amadeus Mozart             10\n",
              "Johnny Cash                          9\n",
              "Ludwig van Beethoven                 9\n",
              "                                    ..\n",
              "Victorious Cast                      1\n",
              "Richard Himber and his Orchestra     1\n",
              "Ahmad Jamal                          1\n",
              "Cher                                 1\n",
              "Citizen                              1\n",
              "Name: artists, Length: 1557, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 42
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "xj4Uju8v7GqQ",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import plotly.express as px\n",
        "\n",
        "def top_n_artists_by_song_count(data, lower_bound, upper_bound):\n",
        "    \n",
        "    reindex_order = data['artists'].value_counts()[lower_bound:upper_bound].index[::-1]     \n",
        "    # order of index to make right values in right places\n",
        "        \n",
        "    total_value_of_songs = data['artists'].value_counts()[lower_bound:upper_bound].reindex(reindex_order)\n",
        "    \n",
        "    total_value_of_popularity =  data.groupby(['artists']).sum()['popularity'].reindex(reindex_order)   # so we can see their popularity too\n",
        "    \n",
        "    df = pd.DataFrame({('Artist ') :total_value_of_songs.index, \n",
        "                        ('Total Song Count '): total_value_of_songs.values,\n",
        "                        ('Total Artist Popularity '): total_value_of_popularity.values}) \n",
        "  \n",
        "    fig = px.bar(df, x = ('Total Song Count ') , y = ('Artist '),\n",
        "                    \n",
        "                     hover_data = [('Total Song Count '), ('Total Artist Popularity ')],\n",
        "                                       \n",
        "                     color = ('Total Song Count ') , title= f'Artists Song Count Ranked ({lower_bound+1},{upper_bound}) ',\n",
        "               \n",
        "                     height = 700  )\n",
        "\n",
        "    return fig.show()"
      ],
      "execution_count": 43,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "AkPW6WwW7Lu2",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 717
        },
        "outputId": "f04d3eb3-cdbe-4266-82fe-3f82d8d6ceee"
      },
      "source": [
        "top_n_artists_by_song_count(raw_data,0,20)"
      ],
      "execution_count": 44,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<html>\n",
              "<head><meta charset=\"utf-8\" /></head>\n",
              "<body>\n",
              "    <div>\n",
              "            <script src=\"https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.5/MathJax.js?config=TeX-AMS-MML_SVG\"></script><script type=\"text/javascript\">if (window.MathJax) {MathJax.Hub.Config({SVG: {font: \"STIX-Web\"}});}</script>\n",
              "                <script type=\"text/javascript\">window.PlotlyConfig = {MathJaxConfig: 'local'};</script>\n",
              "        <script src=\"https://cdn.plot.ly/plotly-latest.min.js\"></script>    \n",
              "            <div id=\"31aeefe9-eed4-4b0d-a421-79c054205808\" class=\"plotly-graph-div\" style=\"height:700px; width:100%;\"></div>\n",
              "            <script type=\"text/javascript\">\n",
              "                \n",
              "                    window.PLOTLYENV=window.PLOTLYENV || {};\n",
              "                    \n",
              "                if (document.getElementById(\"31aeefe9-eed4-4b0d-a421-79c054205808\")) {\n",
              "                    Plotly.newPlot(\n",
              "                        '31aeefe9-eed4-4b0d-a421-79c054205808',\n",
              "                        [{\"alignmentgroup\": \"True\", \"customdata\": [[5, 19], [5, 0], [6, 140], [6, 350], [6, 42], [6, 175], [6, 71], [6, 151], [6, 90], [6, 222], [7, 57], [8, 358], [8, 0], [8, 219], [8, 99], [9, 78], [9, 257], [10, 132], [22, 0], [24, 0]], \"hoverlabel\": {\"namelength\": 0}, \"hovertemplate\": \"Total Song Count =%{marker.color}<br>Artist =%{y}<br>Total Artist Popularity =%{customdata[1]}\", \"legendgroup\": \"\", \"marker\": {\"color\": [5, 5, 6, 6, 6, 6, 6, 6, 6, 6, 7, 8, 8, 8, 8, 9, 9, 10, 22, 24], \"coloraxis\": \"coloraxis\"}, \"name\": \"\", \"offsetgroup\": \"\", \"orientation\": \"v\", \"showlegend\": false, \"textposition\": \"auto\", \"type\": \"bar\", \"x\": [5, 5, 6, 6, 6, 6, 6, 6, 6, 6, 7, 8, 8, 8, 8, 9, 9, 10, 22, 24], \"xaxis\": \"x\", \"y\": [\"Lata Mangeshkar\", \"Bruno Walter\", \"London Symphony Orchestra\", \"Bob Marley & The Wailers\", \"Johann Sebastian Bach\", \"Bob Dylan\", \"Leonard Bernstein\", \"Elvis Presley\", \"Glenn Gould\", \"Willie Nelson\", \"Fr\\u00e9d\\u00e9ric Chopin\", \"Queen\", \"Ignacio Corsini\", \"The Beach Boys\", \"Billie Holiday\", \"Ludwig van Beethoven\", \"Johnny Cash\", \"Wolfgang Amadeus Mozart\", \"Francisco Canaro\", \"\\u042d\\u0440\\u043d\\u0435\\u0441\\u0442 \\u0425\\u0435\\u043c\\u0438\\u043d\\u0433\\u0443\\u044d\\u0439\"], \"yaxis\": \"y\"}],\n",
              "                        {\"barmode\": \"relative\", \"coloraxis\": {\"colorbar\": {\"title\": {\"text\": \"Total Song Count \"}}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]]}, \"height\": 700, \"legend\": {\"tracegroupgap\": 0}, \"template\": {\"data\": {\"bar\": [{\"error_x\": {\"color\": \"#2a3f5f\"}, \"error_y\": {\"color\": \"#2a3f5f\"}, \"marker\": {\"line\": {\"color\": \"#E5ECF6\", \"width\": 0.5}}, \"type\": \"bar\"}], \"barpolar\": [{\"marker\": {\"line\": {\"color\": \"#E5ECF6\", \"width\": 0.5}}, \"type\": \"barpolar\"}], \"carpet\": [{\"aaxis\": {\"endlinecolor\": \"#2a3f5f\", \"gridcolor\": \"white\", \"linecolor\": \"white\", \"minorgridcolor\": \"white\", \"startlinecolor\": \"#2a3f5f\"}, \"baxis\": {\"endlinecolor\": \"#2a3f5f\", \"gridcolor\": \"white\", \"linecolor\": \"white\", \"minorgridcolor\": \"white\", \"startlinecolor\": \"#2a3f5f\"}, \"type\": \"carpet\"}], \"choropleth\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"choropleth\"}], \"contour\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"contour\"}], \"contourcarpet\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"contourcarpet\"}], \"heatmap\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"heatmap\"}], \"heatmapgl\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"heatmapgl\"}], \"histogram\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"histogram\"}], \"histogram2d\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"histogram2d\"}], \"histogram2dcontour\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"histogram2dcontour\"}], \"mesh3d\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"mesh3d\"}], \"parcoords\": [{\"line\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"parcoords\"}], \"pie\": [{\"automargin\": true, \"type\": \"pie\"}], \"scatter\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatter\"}], \"scatter3d\": [{\"line\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatter3d\"}], \"scattercarpet\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattercarpet\"}], \"scattergeo\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattergeo\"}], \"scattergl\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattergl\"}], \"scattermapbox\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattermapbox\"}], \"scatterpolar\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterpolar\"}], \"scatterpolargl\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterpolargl\"}], \"scatterternary\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterternary\"}], \"surface\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"surface\"}], \"table\": [{\"cells\": {\"fill\": {\"color\": \"#EBF0F8\"}, \"line\": {\"color\": \"white\"}}, \"header\": {\"fill\": {\"color\": \"#C8D4E3\"}, \"line\": {\"color\": \"white\"}}, \"type\": \"table\"}]}, \"layout\": {\"annotationdefaults\": {\"arrowcolor\": \"#2a3f5f\", \"arrowhead\": 0, \"arrowwidth\": 1}, \"coloraxis\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"colorscale\": {\"diverging\": [[0, \"#8e0152\"], [0.1, \"#c51b7d\"], [0.2, \"#de77ae\"], [0.3, \"#f1b6da\"], [0.4, \"#fde0ef\"], [0.5, \"#f7f7f7\"], [0.6, \"#e6f5d0\"], [0.7, \"#b8e186\"], [0.8, \"#7fbc41\"], [0.9, \"#4d9221\"], [1, \"#276419\"]], \"sequential\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"sequentialminus\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]]}, \"colorway\": [\"#636efa\", \"#EF553B\", \"#00cc96\", \"#ab63fa\", \"#FFA15A\", \"#19d3f3\", \"#FF6692\", \"#B6E880\", \"#FF97FF\", \"#FECB52\"], \"font\": {\"color\": \"#2a3f5f\"}, \"geo\": {\"bgcolor\": \"white\", \"lakecolor\": \"white\", \"landcolor\": \"#E5ECF6\", \"showlakes\": true, \"showland\": true, \"subunitcolor\": \"white\"}, \"hoverlabel\": {\"align\": \"left\"}, \"hovermode\": \"closest\", \"mapbox\": {\"style\": \"light\"}, \"paper_bgcolor\": \"white\", \"plot_bgcolor\": \"#E5ECF6\", \"polar\": {\"angularaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"bgcolor\": \"#E5ECF6\", \"radialaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}}, \"scene\": {\"xaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}, \"yaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}, \"zaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}}, \"shapedefaults\": {\"line\": {\"color\": \"#2a3f5f\"}}, \"ternary\": {\"aaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"baxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"bgcolor\": \"#E5ECF6\", \"caxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}}, \"title\": {\"x\": 0.05}, \"xaxis\": {\"automargin\": true, \"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\", \"title\": {\"standoff\": 15}, \"zerolinecolor\": \"white\", \"zerolinewidth\": 2}, \"yaxis\": {\"automargin\": true, \"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\", \"title\": {\"standoff\": 15}, \"zerolinecolor\": \"white\", \"zerolinewidth\": 2}}}, \"title\": {\"text\": \"Artists Song Count Ranked (1,20) \"}, \"xaxis\": {\"anchor\": \"y\", \"domain\": [0.0, 1.0], \"title\": {\"text\": \"Total Song Count \"}}, \"yaxis\": {\"anchor\": \"x\", \"domain\": [0.0, 1.0], \"title\": {\"text\": \"Artist \"}}},\n",
              "                        {\"responsive\": true}\n",
              "                    ).then(function(){\n",
              "                            \n",
              "var gd = document.getElementById('31aeefe9-eed4-4b0d-a421-79c054205808');\n",
              "var x = new MutationObserver(function (mutations, observer) {{\n",
              "        var display = window.getComputedStyle(gd).display;\n",
              "        if (!display || display === 'none') {{\n",
              "            console.log([gd, 'removed!']);\n",
              "            Plotly.purge(gd);\n",
              "            observer.disconnect();\n",
              "        }}\n",
              "}});\n",
              "\n",
              "// Listen for the removal of the full notebook cells\n",
              "var notebookContainer = gd.closest('#notebook-container');\n",
              "if (notebookContainer) {{\n",
              "    x.observe(notebookContainer, {childList: true});\n",
              "}}\n",
              "\n",
              "// Listen for the clearing of the current output cell\n",
              "var outputEl = gd.closest('.output');\n",
              "if (outputEl) {{\n",
              "    x.observe(outputEl, {childList: true});\n",
              "}}\n",
              "\n",
              "                        })\n",
              "                };\n",
              "                \n",
              "            </script>\n",
              "        </div>\n",
              "</body>\n",
              "</html>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "yM13A70t71fk",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 391
        },
        "outputId": "584db4b4-c0da-4003-e396-10c874c64f6e"
      },
      "source": [
        "#top artist by popularity\n",
        "df.groupby(\"artists\")[\"popularity\"].sum().sort_values(ascending=False).head(20)"
      ],
      "execution_count": 45,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "artists\n",
              "Queen                       358\n",
              "Bob Marley & The Wailers    350\n",
              "Eminem                      308\n",
              "Johnny Cash                 257\n",
              "Willie Nelson               222\n",
              "Red Hot Chili Peppers       220\n",
              "The Beach Boys              219\n",
              "The Smiths                  218\n",
              "Nickelback                  215\n",
              "Kanye West                  204\n",
              "Young Thug                  198\n",
              "Vampire Weekend             181\n",
              "Waylon Jennings             178\n",
              "Drake                       176\n",
              "Bob Dylan                   175\n",
              "Bad Bunny                   174\n",
              "Lana Del Rey                169\n",
              "Breaking Benjamin           166\n",
              "David Bowie                 164\n",
              "Elvis Presley               151\n",
              "Name: popularity, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 45
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "wt31Uo6678S-",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "def top_n_artists_by_popularity(data, lower_bound, upper_bound):\n",
        "    \n",
        "\n",
        "    reindex_order =  data.groupby(['artists']).sum()['popularity'].sort_values(ascending = False)[lower_bound:upper_bound].index[::-1]     \n",
        "    # order of index to make right values in right places\n",
        "        \n",
        "    total_value_of_popularity =  data.groupby(['artists']).sum()['popularity'].sort_values(ascending = False)[\n",
        "        lower_bound:upper_bound].reindex(reindex_order)\n",
        "    \n",
        "    total_songs = data['artists'].value_counts().round(0).reindex(reindex_order)   \n",
        "    \n",
        "    df = pd.DataFrame({('Artist ') :total_value_of_popularity.index, \n",
        "                        ('Total Artist Popularity '): total_value_of_popularity.values,\n",
        "                        ('Total Song Count '): total_songs.values}) \n",
        "  \n",
        "    fig = px.bar(df, x = ('Total Artist Popularity ') , y = ('Artist '),\n",
        "                    \n",
        "                     hover_data = [('Total Artist Popularity '), ('Total Song Count ')],\n",
        "                                       \n",
        "                     color = ('Total Artist Popularity ') , title= f'Artists Popularity Ranked ({lower_bound +1},{upper_bound})',\n",
        "               \n",
        "                     height = 700  )\n",
        "\n",
        "    return fig.show()"
      ],
      "execution_count": 46,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "y6GIHjX88BAf",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 717
        },
        "outputId": "d17553f8-4024-4e29-e271-6b3d880b3234"
      },
      "source": [
        "top_n_artists_by_popularity(raw_data, 0, 20)"
      ],
      "execution_count": 47,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<html>\n",
              "<head><meta charset=\"utf-8\" /></head>\n",
              "<body>\n",
              "    <div>\n",
              "            <script src=\"https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.5/MathJax.js?config=TeX-AMS-MML_SVG\"></script><script type=\"text/javascript\">if (window.MathJax) {MathJax.Hub.Config({SVG: {font: \"STIX-Web\"}});}</script>\n",
              "                <script type=\"text/javascript\">window.PlotlyConfig = {MathJaxConfig: 'local'};</script>\n",
              "        <script src=\"https://cdn.plot.ly/plotly-latest.min.js\"></script>    \n",
              "            <div id=\"3dce4fc5-4c60-4bfc-981e-f611d87f5d11\" class=\"plotly-graph-div\" style=\"height:700px; width:100%;\"></div>\n",
              "            <script type=\"text/javascript\">\n",
              "                \n",
              "                    window.PLOTLYENV=window.PLOTLYENV || {};\n",
              "                    \n",
              "                if (document.getElementById(\"3dce4fc5-4c60-4bfc-981e-f611d87f5d11\")) {\n",
              "                    Plotly.newPlot(\n",
              "                        '3dce4fc5-4c60-4bfc-981e-f611d87f5d11',\n",
              "                        [{\"alignmentgroup\": \"True\", \"customdata\": [[151, 6], [164, 4], [166, 3], [169, 3], [174, 2], [175, 6], [176, 3], [178, 4], [181, 4], [198, 3], [204, 3], [215, 4], [218, 4], [219, 8], [220, 4], [222, 6], [257, 9], [308, 5], [350, 6], [358, 8]], \"hoverlabel\": {\"namelength\": 0}, \"hovertemplate\": \"Total Artist Popularity =%{marker.color}<br>Artist =%{y}<br>Total Song Count =%{customdata[1]}\", \"legendgroup\": \"\", \"marker\": {\"color\": [151, 164, 166, 169, 174, 175, 176, 178, 181, 198, 204, 215, 218, 219, 220, 222, 257, 308, 350, 358], \"coloraxis\": \"coloraxis\"}, \"name\": \"\", \"offsetgroup\": \"\", \"orientation\": \"v\", \"showlegend\": false, \"textposition\": \"auto\", \"type\": \"bar\", \"x\": [151, 164, 166, 169, 174, 175, 176, 178, 181, 198, 204, 215, 218, 219, 220, 222, 257, 308, 350, 358], \"xaxis\": \"x\", \"y\": [\"Elvis Presley\", \"David Bowie\", \"Breaking Benjamin\", \"Lana Del Rey\", \"Bad Bunny\", \"Bob Dylan\", \"Drake\", \"Waylon Jennings\", \"Vampire Weekend\", \"Young Thug\", \"Kanye West\", \"Nickelback\", \"The Smiths\", \"The Beach Boys\", \"Red Hot Chili Peppers\", \"Willie Nelson\", \"Johnny Cash\", \"Eminem\", \"Bob Marley & The Wailers\", \"Queen\"], \"yaxis\": \"y\"}],\n",
              "                        {\"barmode\": \"relative\", \"coloraxis\": {\"colorbar\": {\"title\": {\"text\": \"Total Artist Popularity \"}}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]]}, \"height\": 700, \"legend\": {\"tracegroupgap\": 0}, \"template\": {\"data\": {\"bar\": [{\"error_x\": {\"color\": \"#2a3f5f\"}, \"error_y\": {\"color\": \"#2a3f5f\"}, \"marker\": {\"line\": {\"color\": \"#E5ECF6\", \"width\": 0.5}}, \"type\": \"bar\"}], \"barpolar\": [{\"marker\": {\"line\": {\"color\": \"#E5ECF6\", \"width\": 0.5}}, \"type\": \"barpolar\"}], \"carpet\": [{\"aaxis\": {\"endlinecolor\": \"#2a3f5f\", \"gridcolor\": \"white\", \"linecolor\": \"white\", \"minorgridcolor\": \"white\", \"startlinecolor\": \"#2a3f5f\"}, \"baxis\": {\"endlinecolor\": \"#2a3f5f\", \"gridcolor\": \"white\", \"linecolor\": \"white\", \"minorgridcolor\": \"white\", \"startlinecolor\": \"#2a3f5f\"}, \"type\": \"carpet\"}], \"choropleth\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"choropleth\"}], \"contour\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"contour\"}], \"contourcarpet\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"contourcarpet\"}], \"heatmap\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"heatmap\"}], \"heatmapgl\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"heatmapgl\"}], \"histogram\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"histogram\"}], \"histogram2d\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"histogram2d\"}], \"histogram2dcontour\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"histogram2dcontour\"}], \"mesh3d\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"mesh3d\"}], \"parcoords\": [{\"line\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"parcoords\"}], \"pie\": [{\"automargin\": true, \"type\": \"pie\"}], \"scatter\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatter\"}], \"scatter3d\": [{\"line\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatter3d\"}], \"scattercarpet\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattercarpet\"}], \"scattergeo\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattergeo\"}], \"scattergl\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattergl\"}], \"scattermapbox\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattermapbox\"}], \"scatterpolar\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterpolar\"}], \"scatterpolargl\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterpolargl\"}], \"scatterternary\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterternary\"}], \"surface\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"surface\"}], \"table\": [{\"cells\": {\"fill\": {\"color\": \"#EBF0F8\"}, \"line\": {\"color\": \"white\"}}, \"header\": {\"fill\": {\"color\": \"#C8D4E3\"}, \"line\": {\"color\": \"white\"}}, \"type\": \"table\"}]}, \"layout\": {\"annotationdefaults\": {\"arrowcolor\": \"#2a3f5f\", \"arrowhead\": 0, \"arrowwidth\": 1}, \"coloraxis\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"colorscale\": {\"diverging\": [[0, \"#8e0152\"], [0.1, \"#c51b7d\"], [0.2, \"#de77ae\"], [0.3, \"#f1b6da\"], [0.4, \"#fde0ef\"], [0.5, \"#f7f7f7\"], [0.6, \"#e6f5d0\"], [0.7, \"#b8e186\"], [0.8, \"#7fbc41\"], [0.9, \"#4d9221\"], [1, \"#276419\"]], \"sequential\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"sequentialminus\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]]}, \"colorway\": [\"#636efa\", \"#EF553B\", \"#00cc96\", \"#ab63fa\", \"#FFA15A\", \"#19d3f3\", \"#FF6692\", \"#B6E880\", \"#FF97FF\", \"#FECB52\"], \"font\": {\"color\": \"#2a3f5f\"}, \"geo\": {\"bgcolor\": \"white\", \"lakecolor\": \"white\", \"landcolor\": \"#E5ECF6\", \"showlakes\": true, \"showland\": true, \"subunitcolor\": \"white\"}, \"hoverlabel\": {\"align\": \"left\"}, \"hovermode\": \"closest\", \"mapbox\": {\"style\": \"light\"}, \"paper_bgcolor\": \"white\", \"plot_bgcolor\": \"#E5ECF6\", \"polar\": {\"angularaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"bgcolor\": \"#E5ECF6\", \"radialaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}}, \"scene\": {\"xaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}, \"yaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}, \"zaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}}, \"shapedefaults\": {\"line\": {\"color\": \"#2a3f5f\"}}, \"ternary\": {\"aaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"baxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"bgcolor\": \"#E5ECF6\", \"caxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}}, \"title\": {\"x\": 0.05}, \"xaxis\": {\"automargin\": true, \"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\", \"title\": {\"standoff\": 15}, \"zerolinecolor\": \"white\", \"zerolinewidth\": 2}, \"yaxis\": {\"automargin\": true, \"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\", \"title\": {\"standoff\": 15}, \"zerolinecolor\": \"white\", \"zerolinewidth\": 2}}}, \"title\": {\"text\": \"Artists Popularity Ranked (1,20)\"}, \"xaxis\": {\"anchor\": \"y\", \"domain\": [0.0, 1.0], \"title\": {\"text\": \"Total Artist Popularity \"}}, \"yaxis\": {\"anchor\": \"x\", \"domain\": [0.0, 1.0], \"title\": {\"text\": \"Artist \"}}},\n",
              "                        {\"responsive\": true}\n",
              "                    ).then(function(){\n",
              "                            \n",
              "var gd = document.getElementById('3dce4fc5-4c60-4bfc-981e-f611d87f5d11');\n",
              "var x = new MutationObserver(function (mutations, observer) {{\n",
              "        var display = window.getComputedStyle(gd).display;\n",
              "        if (!display || display === 'none') {{\n",
              "            console.log([gd, 'removed!']);\n",
              "            Plotly.purge(gd);\n",
              "            observer.disconnect();\n",
              "        }}\n",
              "}});\n",
              "\n",
              "// Listen for the removal of the full notebook cells\n",
              "var notebookContainer = gd.closest('#notebook-container');\n",
              "if (notebookContainer) {{\n",
              "    x.observe(notebookContainer, {childList: true});\n",
              "}}\n",
              "\n",
              "// Listen for the clearing of the current output cell\n",
              "var outputEl = gd.closest('.output');\n",
              "if (outputEl) {{\n",
              "    x.observe(outputEl, {childList: true});\n",
              "}}\n",
              "\n",
              "                        })\n",
              "                };\n",
              "                \n",
              "            </script>\n",
              "        </div>\n",
              "</body>\n",
              "</html>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "exsxYl2mlPSl",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "data_w_genres = pd.read_csv('data_w_genres.csv')"
      ],
      "execution_count": 48,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1c-DcVEloVmp",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 343
        },
        "outputId": "8c37c3e1-a826-45c0-adab-93a911afe9c9"
      },
      "source": [
        "data_w_genres.sample(5)"
      ],
      "execution_count": 49,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>artists</th>\n",
              "      <th>acousticness</th>\n",
              "      <th>danceability</th>\n",
              "      <th>duration_ms</th>\n",
              "      <th>energy</th>\n",
              "      <th>instrumentalness</th>\n",
              "      <th>liveness</th>\n",
              "      <th>loudness</th>\n",
              "      <th>speechiness</th>\n",
              "      <th>tempo</th>\n",
              "      <th>valence</th>\n",
              "      <th>popularity</th>\n",
              "      <th>key</th>\n",
              "      <th>mode</th>\n",
              "      <th>count</th>\n",
              "      <th>genres</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>26931</th>\n",
              "      <td>Yuri Bashmet</td>\n",
              "      <td>0.925000</td>\n",
              "      <td>0.241000</td>\n",
              "      <td>209373.000000</td>\n",
              "      <td>0.1220</td>\n",
              "      <td>0.660000</td>\n",
              "      <td>0.126000</td>\n",
              "      <td>-22.411000</td>\n",
              "      <td>0.049700</td>\n",
              "      <td>66.325000</td>\n",
              "      <td>0.187000</td>\n",
              "      <td>54.0</td>\n",
              "      <td>7</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>['classical performance', 'viola']</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2911</th>\n",
              "      <td>Bob Baldwin</td>\n",
              "      <td>0.049700</td>\n",
              "      <td>0.705000</td>\n",
              "      <td>346267.000000</td>\n",
              "      <td>0.8540</td>\n",
              "      <td>0.877000</td>\n",
              "      <td>0.097700</td>\n",
              "      <td>-8.167000</td>\n",
              "      <td>0.041700</td>\n",
              "      <td>89.015000</td>\n",
              "      <td>0.673000</td>\n",
              "      <td>43.0</td>\n",
              "      <td>4</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>['jazz funk', 'smooth jazz']</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24382</th>\n",
              "      <td>The Originals</td>\n",
              "      <td>0.467640</td>\n",
              "      <td>0.377400</td>\n",
              "      <td>223330.800000</td>\n",
              "      <td>0.4542</td>\n",
              "      <td>0.000725</td>\n",
              "      <td>0.211600</td>\n",
              "      <td>-10.795600</td>\n",
              "      <td>0.034320</td>\n",
              "      <td>153.692000</td>\n",
              "      <td>0.521600</td>\n",
              "      <td>37.8</td>\n",
              "      <td>5</td>\n",
              "      <td>1</td>\n",
              "      <td>10</td>\n",
              "      <td>['doo-wop']</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27338</th>\n",
              "      <td>Γιώργος Μπάτης</td>\n",
              "      <td>0.919286</td>\n",
              "      <td>0.648429</td>\n",
              "      <td>195063.857143</td>\n",
              "      <td>0.4090</td>\n",
              "      <td>0.087918</td>\n",
              "      <td>0.217729</td>\n",
              "      <td>-9.810857</td>\n",
              "      <td>0.124857</td>\n",
              "      <td>116.964714</td>\n",
              "      <td>0.668571</td>\n",
              "      <td>0.0</td>\n",
              "      <td>11</td>\n",
              "      <td>0</td>\n",
              "      <td>14</td>\n",
              "      <td>[]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27135</th>\n",
              "      <td>dark cat</td>\n",
              "      <td>0.182000</td>\n",
              "      <td>0.753000</td>\n",
              "      <td>243375.000000</td>\n",
              "      <td>0.6690</td>\n",
              "      <td>0.077400</td>\n",
              "      <td>0.442000</td>\n",
              "      <td>-7.390000</td>\n",
              "      <td>0.050500</td>\n",
              "      <td>159.994000</td>\n",
              "      <td>0.660000</td>\n",
              "      <td>61.0</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>['future funk', 'kawaii future bass']</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "              artists  ...                                 genres\n",
              "26931    Yuri Bashmet  ...     ['classical performance', 'viola']\n",
              "2911      Bob Baldwin  ...           ['jazz funk', 'smooth jazz']\n",
              "24382   The Originals  ...                            ['doo-wop']\n",
              "27338  Γιώργος Μπάτης  ...                                     []\n",
              "27135        dark cat  ...  ['future funk', 'kawaii future bass']\n",
              "\n",
              "[5 rows x 16 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 49
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Enc_VxR38VS4",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 359
        },
        "outputId": "bf5ed94e-816d-4c3c-aa4d-ce2e09110fb7"
      },
      "source": [
        "pd.options.mode.chained_assignment = None \n",
        "\n",
        "data_genre = data_w_genres.loc[:,['artists','count','genres','popularity']] # lets explore these columns for now\n",
        "# makes it into actual list instead of string list\n",
        "data_genre['genres'] = data_genre['genres'].apply(lambda x: x[1:-1].split(', '))  \n",
        "\n",
        "for i in data_genre.index:\n",
        "# filters out empty values in each list\n",
        "    data_genre['genres'].loc[i] = list(filter(None, data_genre['genres'][i]))  \n",
        "    \n",
        "\n",
        "data_genre.head(10)"
      ],
      "execution_count": 50,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>artists</th>\n",
              "      <th>count</th>\n",
              "      <th>genres</th>\n",
              "      <th>popularity</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>\"Cats\" 1981 Original London Cast</td>\n",
              "      <td>12</td>\n",
              "      <td>['show tunes']</td>\n",
              "      <td>38.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>\"Cats\" 1983 Broadway Cast</td>\n",
              "      <td>26</td>\n",
              "      <td>[]</td>\n",
              "      <td>33.076923</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>\"Fiddler On The Roof” Motion Picture Chorus</td>\n",
              "      <td>7</td>\n",
              "      <td>[]</td>\n",
              "      <td>34.285714</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>\"Fiddler On The Roof” Motion Picture Orchestra</td>\n",
              "      <td>27</td>\n",
              "      <td>[]</td>\n",
              "      <td>34.444444</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>\"Joseph And The Amazing Technicolor Dreamcoat\"...</td>\n",
              "      <td>9</td>\n",
              "      <td>[]</td>\n",
              "      <td>42.555556</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>\"Joseph And The Amazing Technicolor Dreamcoat\"...</td>\n",
              "      <td>36</td>\n",
              "      <td>[]</td>\n",
              "      <td>34.166667</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>\"Mama\" Helen Teagarden</td>\n",
              "      <td>2</td>\n",
              "      <td>[]</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>\"Mista Dj Paul</td>\n",
              "      <td>1</td>\n",
              "      <td>[]</td>\n",
              "      <td>36.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>\"Test for Victor Young\"</td>\n",
              "      <td>2</td>\n",
              "      <td>[]</td>\n",
              "      <td>2.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>\"Weird Al\" Yankovic</td>\n",
              "      <td>132</td>\n",
              "      <td>['antiviral pop', 'comedy rock', 'comic', 'par...</td>\n",
              "      <td>33.681818</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                             artists  ...  popularity\n",
              "0                   \"Cats\" 1981 Original London Cast  ...   38.000000\n",
              "1                          \"Cats\" 1983 Broadway Cast  ...   33.076923\n",
              "2        \"Fiddler On The Roof” Motion Picture Chorus  ...   34.285714\n",
              "3     \"Fiddler On The Roof” Motion Picture Orchestra  ...   34.444444\n",
              "4  \"Joseph And The Amazing Technicolor Dreamcoat\"...  ...   42.555556\n",
              "5  \"Joseph And The Amazing Technicolor Dreamcoat\"...  ...   34.166667\n",
              "6                             \"Mama\" Helen Teagarden  ...    0.000000\n",
              "7                                     \"Mista Dj Paul  ...   36.000000\n",
              "8                            \"Test for Victor Young\"  ...    2.000000\n",
              "9                                \"Weird Al\" Yankovic  ...   33.681818\n",
              "\n",
              "[10 rows x 4 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 50
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "N4GzakH389ir",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 221
        },
        "outputId": "4f9463e7-ec31-4a71-96e3-bb17fd95c9d4"
      },
      "source": [
        "genre_counts = data_w_genres.groupby('genres')['artists'].count().sort_values(ascending=False)  \n",
        "genre_counts.head(10)"
      ],
      "execution_count": 51,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "genres\n",
              "[]                                         9530\n",
              "['movie tunes']                              78\n",
              "['show tunes']                               63\n",
              "['classical piano']                          57\n",
              "['sleep']                                    56\n",
              "['broadway', 'hollywood', 'show tunes']      53\n",
              "['hollywood']                                52\n",
              "['background music']                         49\n",
              "['disney', 'movie tunes']                    49\n",
              "['orchestral performance']                   46\n",
              "Name: artists, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 51
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ZQKiH_0F9ywc",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "outputId": "83b61610-8160-48e6-f6de-372745f10c8c"
      },
      "source": [
        "missing_genre_artists = data_genre[data_genre['genres'].map(lambda x: len(x)) < 1]\n",
        "missing_genre_artists"
      ],
      "execution_count": 52,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>artists</th>\n",
              "      <th>count</th>\n",
              "      <th>genres</th>\n",
              "      <th>popularity</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>\"Cats\" 1983 Broadway Cast</td>\n",
              "      <td>26</td>\n",
              "      <td>[]</td>\n",
              "      <td>33.076923</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>\"Fiddler On The Roof” Motion Picture Chorus</td>\n",
              "      <td>7</td>\n",
              "      <td>[]</td>\n",
              "      <td>34.285714</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>\"Fiddler On The Roof” Motion Picture Orchestra</td>\n",
              "      <td>27</td>\n",
              "      <td>[]</td>\n",
              "      <td>34.444444</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>\"Joseph And The Amazing Technicolor Dreamcoat\"...</td>\n",
              "      <td>9</td>\n",
              "      <td>[]</td>\n",
              "      <td>42.555556</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>\"Joseph And The Amazing Technicolor Dreamcoat\"...</td>\n",
              "      <td>36</td>\n",
              "      <td>[]</td>\n",
              "      <td>34.166667</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27613</th>\n",
              "      <td>霜華雪華</td>\n",
              "      <td>104</td>\n",
              "      <td>[]</td>\n",
              "      <td>23.153846</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27614</th>\n",
              "      <td>韋綺珊</td>\n",
              "      <td>1</td>\n",
              "      <td>[]</td>\n",
              "      <td>40.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27615</th>\n",
              "      <td>高慧君</td>\n",
              "      <td>2</td>\n",
              "      <td>[]</td>\n",
              "      <td>52.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27618</th>\n",
              "      <td>黃國隆</td>\n",
              "      <td>11</td>\n",
              "      <td>[]</td>\n",
              "      <td>20.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27619</th>\n",
              "      <td>黃蜀娟</td>\n",
              "      <td>42</td>\n",
              "      <td>[]</td>\n",
              "      <td>23.000000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>9530 rows × 4 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                 artists  ...  popularity\n",
              "1                              \"Cats\" 1983 Broadway Cast  ...   33.076923\n",
              "2            \"Fiddler On The Roof” Motion Picture Chorus  ...   34.285714\n",
              "3         \"Fiddler On The Roof” Motion Picture Orchestra  ...   34.444444\n",
              "4      \"Joseph And The Amazing Technicolor Dreamcoat\"...  ...   42.555556\n",
              "5      \"Joseph And The Amazing Technicolor Dreamcoat\"...  ...   34.166667\n",
              "...                                                  ...  ...         ...\n",
              "27613                                               霜華雪華  ...   23.153846\n",
              "27614                                                韋綺珊  ...   40.000000\n",
              "27615                                                高慧君  ...   52.000000\n",
              "27618                                                黃國隆  ...   20.000000\n",
              "27619                                                黃蜀娟  ...   23.000000\n",
              "\n",
              "[9530 rows x 4 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 52
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "gxAVxwDq99cp",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "outputId": "587ce4a9-3481-4d76-c74c-cb0cfaebf603"
      },
      "source": [
        "missing_genre_artists_split = missing_genre_artists.copy()\n",
        "missing_genre_artists_split['artists'] = missing_genre_artists_split['artists'].apply(lambda x: x.split())  # split into words\n",
        "missing_genre_artists_split"
      ],
      "execution_count": 53,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>artists</th>\n",
              "      <th>count</th>\n",
              "      <th>genres</th>\n",
              "      <th>popularity</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>[\"Cats\", 1983, Broadway, Cast]</td>\n",
              "      <td>26</td>\n",
              "      <td>[]</td>\n",
              "      <td>33.076923</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>[\"Fiddler, On, The, Roof”, Motion, Picture, Ch...</td>\n",
              "      <td>7</td>\n",
              "      <td>[]</td>\n",
              "      <td>34.285714</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>[\"Fiddler, On, The, Roof”, Motion, Picture, Or...</td>\n",
              "      <td>27</td>\n",
              "      <td>[]</td>\n",
              "      <td>34.444444</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>[\"Joseph, And, The, Amazing, Technicolor, Drea...</td>\n",
              "      <td>9</td>\n",
              "      <td>[]</td>\n",
              "      <td>42.555556</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>[\"Joseph, And, The, Amazing, Technicolor, Drea...</td>\n",
              "      <td>36</td>\n",
              "      <td>[]</td>\n",
              "      <td>34.166667</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27613</th>\n",
              "      <td>[霜華雪華]</td>\n",
              "      <td>104</td>\n",
              "      <td>[]</td>\n",
              "      <td>23.153846</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27614</th>\n",
              "      <td>[韋綺珊]</td>\n",
              "      <td>1</td>\n",
              "      <td>[]</td>\n",
              "      <td>40.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27615</th>\n",
              "      <td>[高慧君]</td>\n",
              "      <td>2</td>\n",
              "      <td>[]</td>\n",
              "      <td>52.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27618</th>\n",
              "      <td>[黃國隆]</td>\n",
              "      <td>11</td>\n",
              "      <td>[]</td>\n",
              "      <td>20.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27619</th>\n",
              "      <td>[黃蜀娟]</td>\n",
              "      <td>42</td>\n",
              "      <td>[]</td>\n",
              "      <td>23.000000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>9530 rows × 4 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                 artists  ...  popularity\n",
              "1                         [\"Cats\", 1983, Broadway, Cast]  ...   33.076923\n",
              "2      [\"Fiddler, On, The, Roof”, Motion, Picture, Ch...  ...   34.285714\n",
              "3      [\"Fiddler, On, The, Roof”, Motion, Picture, Or...  ...   34.444444\n",
              "4      [\"Joseph, And, The, Amazing, Technicolor, Drea...  ...   42.555556\n",
              "5      [\"Joseph, And, The, Amazing, Technicolor, Drea...  ...   34.166667\n",
              "...                                                  ...  ...         ...\n",
              "27613                                             [霜華雪華]  ...   23.153846\n",
              "27614                                              [韋綺珊]  ...   40.000000\n",
              "27615                                              [高慧君]  ...   52.000000\n",
              "27618                                              [黃國隆]  ...   20.000000\n",
              "27619                                              [黃蜀娟]  ...   23.000000\n",
              "\n",
              "[9530 rows x 4 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 53
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "gU_gEe09-Gos",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 714
        },
        "outputId": "c72625b7-fd5a-4e5c-e510-4a29a10f2af8"
      },
      "source": [
        "def word_count(data):\n",
        "\n",
        "    all_words = []  \n",
        "    for elmnt in data['artists']:  \n",
        "        all_words += elmnt  \n",
        "\n",
        "    val_counts = pd.Series(all_words).value_counts()\n",
        "\n",
        "    return val_counts.head(40)\n",
        "\n",
        "word_count(missing_genre_artists_split)"
      ],
      "execution_count": 54,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "The          486\n",
              "Orchestra    373\n",
              "&            270\n",
              "His          145\n",
              "and          104\n",
              "Ensemble      94\n",
              "John          83\n",
              "de            82\n",
              "De            67\n",
              "of            59\n",
              "David         57\n",
              "And           56\n",
              "Paul          55\n",
              "Band          55\n",
              "Chorus        54\n",
              "Robert        54\n",
              "George        51\n",
              "James         47\n",
              "the           47\n",
              "Of            46\n",
              "Cast          45\n",
              "-             44\n",
              "Michael       43\n",
              "Lee           41\n",
              "Richard       41\n",
              "with          39\n",
              "di            39\n",
              "Choir         37\n",
              "Los           36\n",
              "Original      35\n",
              "Broadway      35\n",
              "Peter         35\n",
              "Orchestre     34\n",
              "Orquesta      34\n",
              "Jack          34\n",
              "La            32\n",
              "Bob           32\n",
              "Jimmy         32\n",
              "Trio          32\n",
              "Martin        31\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 54
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "zhqQ6sbJ-OV6",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 669
        },
        "outputId": "09ff4ae7-616f-42ce-fc36-f36a9ebf686d"
      },
      "source": [
        "data_genre[data_genre['genres'].map(lambda x: len(x)) < 1].sort_values(ascending = False,by = 'count').head(20)"
      ],
      "execution_count": 55,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>artists</th>\n",
              "      <th>count</th>\n",
              "      <th>genres</th>\n",
              "      <th>popularity</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>27524</th>\n",
              "      <td>Эрнест Хемингуэй</td>\n",
              "      <td>2430</td>\n",
              "      <td>[]</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27523</th>\n",
              "      <td>Эрих Мария Ремарк</td>\n",
              "      <td>1562</td>\n",
              "      <td>[]</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18014</th>\n",
              "      <td>Orchestra Studio 7</td>\n",
              "      <td>476</td>\n",
              "      <td>[]</td>\n",
              "      <td>0.012605</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25726</th>\n",
              "      <td>Unspecified</td>\n",
              "      <td>456</td>\n",
              "      <td>[]</td>\n",
              "      <td>1.192982</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8933</th>\n",
              "      <td>Giorgos Papasideris</td>\n",
              "      <td>320</td>\n",
              "      <td>[]</td>\n",
              "      <td>0.015625</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18009</th>\n",
              "      <td>Orchestra Sinfonica di Roma della RAI</td>\n",
              "      <td>314</td>\n",
              "      <td>[]</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20221</th>\n",
              "      <td>Rita Ampatzi</td>\n",
              "      <td>263</td>\n",
              "      <td>[]</td>\n",
              "      <td>0.003802</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18156</th>\n",
              "      <td>Oscar Levant</td>\n",
              "      <td>239</td>\n",
              "      <td>[]</td>\n",
              "      <td>0.569038</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4492</th>\n",
              "      <td>Christoph Waltz</td>\n",
              "      <td>218</td>\n",
              "      <td>[]</td>\n",
              "      <td>15.082569</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21803</th>\n",
              "      <td>Sinclair Lewis</td>\n",
              "      <td>212</td>\n",
              "      <td>[]</td>\n",
              "      <td>0.014151</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18660</th>\n",
              "      <td>Paul Weston And His Orchestra</td>\n",
              "      <td>205</td>\n",
              "      <td>[]</td>\n",
              "      <td>14.458537</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27065</th>\n",
              "      <td>Zofia Dromlewiczowa</td>\n",
              "      <td>192</td>\n",
              "      <td>[]</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7470</th>\n",
              "      <td>Eugene Istomin</td>\n",
              "      <td>170</td>\n",
              "      <td>[]</td>\n",
              "      <td>0.488235</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18513</th>\n",
              "      <td>Patricia St. John</td>\n",
              "      <td>168</td>\n",
              "      <td>[]</td>\n",
              "      <td>1.333333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13180</th>\n",
              "      <td>Klarino</td>\n",
              "      <td>161</td>\n",
              "      <td>[]</td>\n",
              "      <td>0.012422</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21444</th>\n",
              "      <td>Seweryn Goszczyński</td>\n",
              "      <td>152</td>\n",
              "      <td>[]</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21831</th>\n",
              "      <td>Sir Malcolm Sargent</td>\n",
              "      <td>151</td>\n",
              "      <td>[]</td>\n",
              "      <td>3.125828</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20671</th>\n",
              "      <td>Roy Fox</td>\n",
              "      <td>150</td>\n",
              "      <td>[]</td>\n",
              "      <td>0.853333</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12559</th>\n",
              "      <td>K.C.Dey</td>\n",
              "      <td>145</td>\n",
              "      <td>[]</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18004</th>\n",
              "      <td>Orchestra Sinfonica Di Torino Della Rai</td>\n",
              "      <td>138</td>\n",
              "      <td>[]</td>\n",
              "      <td>3.115942</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                       artists  count genres  popularity\n",
              "27524                         Эрнест Хемингуэй   2430     []    0.000000\n",
              "27523                        Эрих Мария Ремарк   1562     []    0.000000\n",
              "18014                       Orchestra Studio 7    476     []    0.012605\n",
              "25726                              Unspecified    456     []    1.192982\n",
              "8933                       Giorgos Papasideris    320     []    0.015625\n",
              "18009    Orchestra Sinfonica di Roma della RAI    314     []    0.000000\n",
              "20221                             Rita Ampatzi    263     []    0.003802\n",
              "18156                             Oscar Levant    239     []    0.569038\n",
              "4492                           Christoph Waltz    218     []   15.082569\n",
              "21803                           Sinclair Lewis    212     []    0.014151\n",
              "18660            Paul Weston And His Orchestra    205     []   14.458537\n",
              "27065                      Zofia Dromlewiczowa    192     []    0.000000\n",
              "7470                            Eugene Istomin    170     []    0.488235\n",
              "18513                        Patricia St. John    168     []    1.333333\n",
              "13180                                  Klarino    161     []    0.012422\n",
              "21444                      Seweryn Goszczyński    152     []    0.000000\n",
              "21831                      Sir Malcolm Sargent    151     []    3.125828\n",
              "20671                                  Roy Fox    150     []    0.853333\n",
              "12559                                  K.C.Dey    145     []    0.000000\n",
              "18004  Orchestra Sinfonica Di Torino Della Rai    138     []    3.115942"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 55
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "tW76gCAc_CDl",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 421
        },
        "outputId": "3c1bf5f3-5033-4490-d6ac-b6957a65cb7c"
      },
      "source": [
        "pd.options.mode.chained_assignment = None \n",
        "\n",
        "for i in data_genre.index:\n",
        "    \n",
        "    if 'Broadway' in data_genre['artists'].loc[i]:\n",
        "        data_genre['genres'].loc[i].append(\"'broadway'\")\n",
        "    if 'Motion Picture' in data_genre['artists'].loc[i]:\n",
        "        data_genre['genres'].loc[i].append(\"'movie tunes'\")\n",
        "    if 'Cast' in data_genre['artists'].loc[i]:\n",
        "        data_genre['genres'].loc[i].append(\"'ensemble'\")     # we will put any cast artists under ensemble genre \n",
        "    if 'Ensemble' in data_genre['artists'].loc[i]:\n",
        "        data_genre['genres'].loc[i].append(\"'ensemble'\")  \n",
        "    if 'Orchestra' in data_genre['artists'].loc[i]:\n",
        "        data_genre['genres'].loc[i].append(\"'orchestra'\")\n",
        "    if 'Orquesta' in data_genre['artists'].loc[i]:              # these are just vara\n",
        "        data_genre['genres'].loc[i].append(\"'orchestra'\")\n",
        "    if 'Orchestre' in data_genre['artists'].loc[i]:\n",
        "        data_genre['genres'].loc[i].append(\"'orchestra'\")\n",
        "    if 'Chorus' in data_genre['artists'].loc[i]:\n",
        "        data_genre['genres'].loc[i].append(\"'chorus'\")\n",
        "    if 'Choir' in data_genre['artists'].loc[i]:\n",
        "        data_genre['genres'].loc[i].append(\"'choir'\")\n",
        "        \n",
        "    data_genre['genres'].loc[i] = list(dict.fromkeys(data_genre['genres'].loc[i])) # removes duplicates\n",
        "    \n",
        "\n",
        "data_genre.head(12)"
      ],
      "execution_count": 56,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>artists</th>\n",
              "      <th>count</th>\n",
              "      <th>genres</th>\n",
              "      <th>popularity</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>\"Cats\" 1981 Original London Cast</td>\n",
              "      <td>12</td>\n",
              "      <td>['show tunes', 'ensemble']</td>\n",
              "      <td>38.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>\"Cats\" 1983 Broadway Cast</td>\n",
              "      <td>26</td>\n",
              "      <td>['broadway', 'ensemble']</td>\n",
              "      <td>33.076923</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>\"Fiddler On The Roof” Motion Picture Chorus</td>\n",
              "      <td>7</td>\n",
              "      <td>['movie tunes', 'chorus']</td>\n",
              "      <td>34.285714</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>\"Fiddler On The Roof” Motion Picture Orchestra</td>\n",
              "      <td>27</td>\n",
              "      <td>['movie tunes', 'orchestra']</td>\n",
              "      <td>34.444444</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>\"Joseph And The Amazing Technicolor Dreamcoat\"...</td>\n",
              "      <td>9</td>\n",
              "      <td>['ensemble']</td>\n",
              "      <td>42.555556</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>\"Joseph And The Amazing Technicolor Dreamcoat\"...</td>\n",
              "      <td>36</td>\n",
              "      <td>['ensemble']</td>\n",
              "      <td>34.166667</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>\"Mama\" Helen Teagarden</td>\n",
              "      <td>2</td>\n",
              "      <td>[]</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>\"Mista Dj Paul</td>\n",
              "      <td>1</td>\n",
              "      <td>[]</td>\n",
              "      <td>36.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>\"Test for Victor Young\"</td>\n",
              "      <td>2</td>\n",
              "      <td>[]</td>\n",
              "      <td>2.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>\"Weird Al\" Yankovic</td>\n",
              "      <td>132</td>\n",
              "      <td>['antiviral pop', 'comedy rock', 'comic', 'par...</td>\n",
              "      <td>33.681818</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>$IMEON</td>\n",
              "      <td>6</td>\n",
              "      <td>[]</td>\n",
              "      <td>62.666667</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>$NOT</td>\n",
              "      <td>8</td>\n",
              "      <td>['east coast hip hop', 'gangster rap', 'hardco...</td>\n",
              "      <td>64.625000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                                              artists  ...  popularity\n",
              "0                    \"Cats\" 1981 Original London Cast  ...   38.000000\n",
              "1                           \"Cats\" 1983 Broadway Cast  ...   33.076923\n",
              "2         \"Fiddler On The Roof” Motion Picture Chorus  ...   34.285714\n",
              "3      \"Fiddler On The Roof” Motion Picture Orchestra  ...   34.444444\n",
              "4   \"Joseph And The Amazing Technicolor Dreamcoat\"...  ...   42.555556\n",
              "5   \"Joseph And The Amazing Technicolor Dreamcoat\"...  ...   34.166667\n",
              "6                              \"Mama\" Helen Teagarden  ...    0.000000\n",
              "7                                      \"Mista Dj Paul  ...   36.000000\n",
              "8                             \"Test for Victor Young\"  ...    2.000000\n",
              "9                                 \"Weird Al\" Yankovic  ...   33.681818\n",
              "10                                             $IMEON  ...   62.666667\n",
              "11                                               $NOT  ...   64.625000\n",
              "\n",
              "[12 rows x 4 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 56
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "XYsPZgQK_ax7",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "outputId": "1872abe4-d981-4a45-b4eb-67c42305d675"
      },
      "source": [
        "final_data_genre = data_genre[data_genre['genres'].map(lambda x: len(x)) > 0] # removes empty lists\n",
        "final_data_genre = final_data_genre.reset_index(drop=True)\n",
        "final_data_genre = final_data_genre.drop('count', axis =1 )\n",
        "final_data_genre.rename(columns={'popularity': 'Artist Popularity'}, inplace=True)\n",
        "final_data_genre['Artist Popularity'] = final_data_genre['Artist Popularity'].astype(int)\n",
        "final_data_genre"
      ],
      "execution_count": 57,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>artists</th>\n",
              "      <th>genres</th>\n",
              "      <th>Artist Popularity</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>\"Cats\" 1981 Original London Cast</td>\n",
              "      <td>['show tunes', 'ensemble']</td>\n",
              "      <td>38</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>\"Cats\" 1983 Broadway Cast</td>\n",
              "      <td>['broadway', 'ensemble']</td>\n",
              "      <td>33</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>\"Fiddler On The Roof” Motion Picture Chorus</td>\n",
              "      <td>['movie tunes', 'chorus']</td>\n",
              "      <td>34</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>\"Fiddler On The Roof” Motion Picture Orchestra</td>\n",
              "      <td>['movie tunes', 'orchestra']</td>\n",
              "      <td>34</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>\"Joseph And The Amazing Technicolor Dreamcoat\"...</td>\n",
              "      <td>['ensemble']</td>\n",
              "      <td>42</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18801</th>\n",
              "      <td>陳秀男</td>\n",
              "      <td>['taiwan campus folk']</td>\n",
              "      <td>44</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18802</th>\n",
              "      <td>陳蘭麗</td>\n",
              "      <td>['taiwan campus folk']</td>\n",
              "      <td>34</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18803</th>\n",
              "      <td>鳳飛飛</td>\n",
              "      <td>['c-pop', 'classic mandopop', 'vintage chinese...</td>\n",
              "      <td>35</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18804</th>\n",
              "      <td>黃品源</td>\n",
              "      <td>['c-pop', 'classic cantopop', 'classic mandopop']</td>\n",
              "      <td>47</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18805</th>\n",
              "      <td>黑豹</td>\n",
              "      <td>['chinese indie', 'chinese indie rock']</td>\n",
              "      <td>34</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>18806 rows × 3 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                                                 artists  ... Artist Popularity\n",
              "0                       \"Cats\" 1981 Original London Cast  ...                38\n",
              "1                              \"Cats\" 1983 Broadway Cast  ...                33\n",
              "2            \"Fiddler On The Roof” Motion Picture Chorus  ...                34\n",
              "3         \"Fiddler On The Roof” Motion Picture Orchestra  ...                34\n",
              "4      \"Joseph And The Amazing Technicolor Dreamcoat\"...  ...                42\n",
              "...                                                  ...  ...               ...\n",
              "18801                                                陳秀男  ...                44\n",
              "18802                                                陳蘭麗  ...                34\n",
              "18803                                                鳳飛飛  ...                35\n",
              "18804                                                黃品源  ...                47\n",
              "18805                                                 黑豹  ...                34\n",
              "\n",
              "[18806 rows x 3 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 57
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "K8Qh652J_f-O",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "def rank_artist_similarity(data, artist, genre_parameter):\n",
        "    artist_data = data[data.artists == artist]\n",
        "    artist_genres = set(*artist_data.genres)\n",
        "    similarity_data = data.drop(artist_data.index)\n",
        "    similarity_data.genres = similarity_data.genres.apply(lambda genres: list(set(genres).intersection(artist_genres)))\n",
        "    similarity_lengths = similarity_data.genres.str.len()\n",
        "    similarity_data = similarity_data.reindex(similarity_lengths[similarity_lengths >= genre_parameter].sort_values(ascending=False).index)\n",
        "    similarity_data.rename(columns={'artists': f'Similar Artists to {artist}', 'genres': 'Similar Genres', 'popularity': 'Artist Popularity'}, inplace=True)\n",
        "    return similarity_data"
      ],
      "execution_count": 58,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "w6TYn5T8_32b",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 328
        },
        "outputId": "e0f02978-ee5e-4eda-fcb5-75e2fcb456f5"
      },
      "source": [
        "rank_artist_similarity(final_data_genre, 'Eminem',3)"
      ],
      "execution_count": 59,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Similar Artists to Eminem</th>\n",
              "      <th>Similar Genres</th>\n",
              "      <th>Artist Popularity</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>18335</th>\n",
              "      <td>Xzibit</td>\n",
              "      <td>['detroit hip hop', 'hip hop', 'rap']</td>\n",
              "      <td>51</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15761</th>\n",
              "      <td>Tee Grizzley</td>\n",
              "      <td>['detroit hip hop', 'hip hop', 'rap']</td>\n",
              "      <td>65</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12102</th>\n",
              "      <td>Obie Trice</td>\n",
              "      <td>['detroit hip hop', 'hip hop', 'rap']</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5878</th>\n",
              "      <td>GRiZ</td>\n",
              "      <td>['detroit hip hop', 'hip hop', 'rap']</td>\n",
              "      <td>53</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3865</th>\n",
              "      <td>Danny Brown</td>\n",
              "      <td>['detroit hip hop', 'hip hop', 'rap']</td>\n",
              "      <td>55</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3674</th>\n",
              "      <td>D12</td>\n",
              "      <td>['detroit hip hop', 'hip hop', 'rap']</td>\n",
              "      <td>50</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1743</th>\n",
              "      <td>Big Sean</td>\n",
              "      <td>['detroit hip hop', 'hip hop', 'rap']</td>\n",
              "      <td>58</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1700</th>\n",
              "      <td>Big B</td>\n",
              "      <td>['detroit hip hop', 'hip hop', 'rap']</td>\n",
              "      <td>41</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1336</th>\n",
              "      <td>Bad Meets Evil</td>\n",
              "      <td>['detroit hip hop', 'hip hop', 'rap']</td>\n",
              "      <td>55</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "      Similar Artists to Eminem  ... Artist Popularity\n",
              "18335                    Xzibit  ...                51\n",
              "15761              Tee Grizzley  ...                65\n",
              "12102                Obie Trice  ...                50\n",
              "5878                       GRiZ  ...                53\n",
              "3865                Danny Brown  ...                55\n",
              "3674                        D12  ...                50\n",
              "1743                   Big Sean  ...                58\n",
              "1700                      Big B  ...                41\n",
              "1336             Bad Meets Evil  ...                55\n",
              "\n",
              "[9 rows x 3 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 59
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "VG2CBa92Ab3C",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 521
        },
        "outputId": "346e1fbd-1dff-4015-9e9c-47f12b42533d"
      },
      "source": [
        "merged_df = raw_data.merge(final_data_genre, how = 'inner', on = ['artists'])\n",
        "merged_df_copy = merged_df.copy()\n",
        "merged_df_copy.rename(columns={'artists': 'Artist', 'name':'Song Name','popularity':'Song Popularity','year':'Year','genres':'Genres'}, inplace=True)\n",
        "\n",
        "merged_df_copy"
      ],
      "execution_count": 60,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Song Name</th>\n",
              "      <th>Song Popularity</th>\n",
              "      <th>Year</th>\n",
              "      <th>Genres</th>\n",
              "      <th>Artist Popularity</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Francisco Canaro</td>\n",
              "      <td>Nunca Jamás - Remasterizado</td>\n",
              "      <td>0</td>\n",
              "      <td>1930</td>\n",
              "      <td>['tango', 'vintage tango']</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Francisco Canaro</td>\n",
              "      <td>Sin Palabras - Remasterizado</td>\n",
              "      <td>0</td>\n",
              "      <td>1946</td>\n",
              "      <td>['tango', 'vintage tango']</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Francisco Canaro</td>\n",
              "      <td>Te Espero en Rodriguez Peña - Remasterizado</td>\n",
              "      <td>0</td>\n",
              "      <td>1946</td>\n",
              "      <td>['tango', 'vintage tango']</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Francisco Canaro</td>\n",
              "      <td>Camel - Remasterizado</td>\n",
              "      <td>0</td>\n",
              "      <td>1923</td>\n",
              "      <td>['tango', 'vintage tango']</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Francisco Canaro</td>\n",
              "      <td>Oh Mujer Mujer - Remasterizado</td>\n",
              "      <td>0</td>\n",
              "      <td>1924</td>\n",
              "      <td>['tango', 'vintage tango']</td>\n",
              "      <td>0</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1831</th>\n",
              "      <td>J. Cole</td>\n",
              "      <td>God's Gift</td>\n",
              "      <td>50</td>\n",
              "      <td>2011</td>\n",
              "      <td>['conscious hip hop', 'hip hop', 'nc hip hop',...</td>\n",
              "      <td>61</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1832</th>\n",
              "      <td>The National</td>\n",
              "      <td>Don't Swallow the Cap</td>\n",
              "      <td>58</td>\n",
              "      <td>2013</td>\n",
              "      <td>['indie rock', 'modern rock']</td>\n",
              "      <td>49</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1833</th>\n",
              "      <td>Dimitri Vegas &amp; Like Mike</td>\n",
              "      <td>Tremor - Sensation 2014 Anthem</td>\n",
              "      <td>58</td>\n",
              "      <td>2014</td>\n",
              "      <td>['belgian dance', 'belgian edm', 'big room', '...</td>\n",
              "      <td>48</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1834</th>\n",
              "      <td>Martin Garrix</td>\n",
              "      <td>Tremor - Sensation 2014 Anthem</td>\n",
              "      <td>58</td>\n",
              "      <td>2014</td>\n",
              "      <td>['big room', 'edm', 'pop', 'progressive house'...</td>\n",
              "      <td>67</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1835</th>\n",
              "      <td>Mitski</td>\n",
              "      <td>Nobody</td>\n",
              "      <td>65</td>\n",
              "      <td>2018</td>\n",
              "      <td>['art pop', 'brooklyn indie', 'dance pop', 'es...</td>\n",
              "      <td>58</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1836 rows × 6 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                         Artist  ... Artist Popularity\n",
              "0              Francisco Canaro  ...                 0\n",
              "1              Francisco Canaro  ...                 0\n",
              "2              Francisco Canaro  ...                 0\n",
              "3              Francisco Canaro  ...                 0\n",
              "4              Francisco Canaro  ...                 0\n",
              "...                         ...  ...               ...\n",
              "1831                    J. Cole  ...                61\n",
              "1832               The National  ...                49\n",
              "1833  Dimitri Vegas & Like Mike  ...                48\n",
              "1834              Martin Garrix  ...                67\n",
              "1835                     Mitski  ...                58\n",
              "\n",
              "[1836 rows x 6 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 60
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "nExERRxlRvC3",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 674
        },
        "outputId": "f79daec3-e187-44a0-bc15-7ebda449451c"
      },
      "source": [
        "merged_df_copy['Genres_cleaned'] = [','.join(map(str, l)) for l in merged_df_copy['Genres']]\n",
        "merged_df_copy"
      ],
      "execution_count": 61,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Song Name</th>\n",
              "      <th>Song Popularity</th>\n",
              "      <th>Year</th>\n",
              "      <th>Genres</th>\n",
              "      <th>Artist Popularity</th>\n",
              "      <th>Genres_cleaned</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Francisco Canaro</td>\n",
              "      <td>Nunca Jamás - Remasterizado</td>\n",
              "      <td>0</td>\n",
              "      <td>1930</td>\n",
              "      <td>['tango', 'vintage tango']</td>\n",
              "      <td>0</td>\n",
              "      <td>'tango','vintage tango'</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Francisco Canaro</td>\n",
              "      <td>Sin Palabras - Remasterizado</td>\n",
              "      <td>0</td>\n",
              "      <td>1946</td>\n",
              "      <td>['tango', 'vintage tango']</td>\n",
              "      <td>0</td>\n",
              "      <td>'tango','vintage tango'</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Francisco Canaro</td>\n",
              "      <td>Te Espero en Rodriguez Peña - Remasterizado</td>\n",
              "      <td>0</td>\n",
              "      <td>1946</td>\n",
              "      <td>['tango', 'vintage tango']</td>\n",
              "      <td>0</td>\n",
              "      <td>'tango','vintage tango'</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Francisco Canaro</td>\n",
              "      <td>Camel - Remasterizado</td>\n",
              "      <td>0</td>\n",
              "      <td>1923</td>\n",
              "      <td>['tango', 'vintage tango']</td>\n",
              "      <td>0</td>\n",
              "      <td>'tango','vintage tango'</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Francisco Canaro</td>\n",
              "      <td>Oh Mujer Mujer - Remasterizado</td>\n",
              "      <td>0</td>\n",
              "      <td>1924</td>\n",
              "      <td>['tango', 'vintage tango']</td>\n",
              "      <td>0</td>\n",
              "      <td>'tango','vintage tango'</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1831</th>\n",
              "      <td>J. Cole</td>\n",
              "      <td>God's Gift</td>\n",
              "      <td>50</td>\n",
              "      <td>2011</td>\n",
              "      <td>['conscious hip hop', 'hip hop', 'nc hip hop',...</td>\n",
              "      <td>61</td>\n",
              "      <td>'conscious hip hop','hip hop','nc hip hop','po...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1832</th>\n",
              "      <td>The National</td>\n",
              "      <td>Don't Swallow the Cap</td>\n",
              "      <td>58</td>\n",
              "      <td>2013</td>\n",
              "      <td>['indie rock', 'modern rock']</td>\n",
              "      <td>49</td>\n",
              "      <td>'indie rock','modern rock'</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1833</th>\n",
              "      <td>Dimitri Vegas &amp; Like Mike</td>\n",
              "      <td>Tremor - Sensation 2014 Anthem</td>\n",
              "      <td>58</td>\n",
              "      <td>2014</td>\n",
              "      <td>['belgian dance', 'belgian edm', 'big room', '...</td>\n",
              "      <td>48</td>\n",
              "      <td>'belgian dance','belgian edm','big room','edm'...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1834</th>\n",
              "      <td>Martin Garrix</td>\n",
              "      <td>Tremor - Sensation 2014 Anthem</td>\n",
              "      <td>58</td>\n",
              "      <td>2014</td>\n",
              "      <td>['big room', 'edm', 'pop', 'progressive house'...</td>\n",
              "      <td>67</td>\n",
              "      <td>'big room','edm','pop','progressive house','tr...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1835</th>\n",
              "      <td>Mitski</td>\n",
              "      <td>Nobody</td>\n",
              "      <td>65</td>\n",
              "      <td>2018</td>\n",
              "      <td>['art pop', 'brooklyn indie', 'dance pop', 'es...</td>\n",
              "      <td>58</td>\n",
              "      <td>'art pop','brooklyn indie','dance pop','escape...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1836 rows × 7 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                         Artist  ...                                     Genres_cleaned\n",
              "0              Francisco Canaro  ...                            'tango','vintage tango'\n",
              "1              Francisco Canaro  ...                            'tango','vintage tango'\n",
              "2              Francisco Canaro  ...                            'tango','vintage tango'\n",
              "3              Francisco Canaro  ...                            'tango','vintage tango'\n",
              "4              Francisco Canaro  ...                            'tango','vintage tango'\n",
              "...                         ...  ...                                                ...\n",
              "1831                    J. Cole  ...  'conscious hip hop','hip hop','nc hip hop','po...\n",
              "1832               The National  ...                         'indie rock','modern rock'\n",
              "1833  Dimitri Vegas & Like Mike  ...  'belgian dance','belgian edm','big room','edm'...\n",
              "1834              Martin Garrix  ...  'big room','edm','pop','progressive house','tr...\n",
              "1835                     Mitski  ...  'art pop','brooklyn indie','dance pop','escape...\n",
              "\n",
              "[1836 rows x 7 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 61
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Mm0U4vruE2eE",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 504
        },
        "outputId": "31edbe8b-5899-4091-c7b4-83e39e8c7f77"
      },
      "source": [
        "from sklearn.preprocessing import LabelEncoder\n",
        "labelencoder = LabelEncoder()\n",
        "merged_df_copy['Artist'] = labelencoder.fit_transform(merged_df_copy['Artist'])\n",
        "merged_df_copy['Genres_cleaned'] = labelencoder.fit_transform(merged_df_copy['Genres_cleaned'].values)\n",
        "merged_df_copy['Song Name'] = labelencoder.fit_transform(merged_df_copy['Song Name'])\n",
        "merged_df_copy"
      ],
      "execution_count": 62,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Song Name</th>\n",
              "      <th>Song Popularity</th>\n",
              "      <th>Year</th>\n",
              "      <th>Genres</th>\n",
              "      <th>Artist Popularity</th>\n",
              "      <th>Genres_cleaned</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>373</td>\n",
              "      <td>852</td>\n",
              "      <td>0</td>\n",
              "      <td>1930</td>\n",
              "      <td>['tango', 'vintage tango']</td>\n",
              "      <td>0</td>\n",
              "      <td>1120</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>373</td>\n",
              "      <td>1049</td>\n",
              "      <td>0</td>\n",
              "      <td>1946</td>\n",
              "      <td>['tango', 'vintage tango']</td>\n",
              "      <td>0</td>\n",
              "      <td>1120</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>373</td>\n",
              "      <td>1166</td>\n",
              "      <td>0</td>\n",
              "      <td>1946</td>\n",
              "      <td>['tango', 'vintage tango']</td>\n",
              "      <td>0</td>\n",
              "      <td>1120</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>373</td>\n",
              "      <td>182</td>\n",
              "      <td>0</td>\n",
              "      <td>1923</td>\n",
              "      <td>['tango', 'vintage tango']</td>\n",
              "      <td>0</td>\n",
              "      <td>1120</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>373</td>\n",
              "      <td>859</td>\n",
              "      <td>0</td>\n",
              "      <td>1924</td>\n",
              "      <td>['tango', 'vintage tango']</td>\n",
              "      <td>0</td>\n",
              "      <td>1120</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1831</th>\n",
              "      <td>492</td>\n",
              "      <td>446</td>\n",
              "      <td>50</td>\n",
              "      <td>2011</td>\n",
              "      <td>['conscious hip hop', 'hip hop', 'nc hip hop',...</td>\n",
              "      <td>61</td>\n",
              "      <td>678</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1832</th>\n",
              "      <td>1151</td>\n",
              "      <td>309</td>\n",
              "      <td>58</td>\n",
              "      <td>2013</td>\n",
              "      <td>['indie rock', 'modern rock']</td>\n",
              "      <td>49</td>\n",
              "      <td>968</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1833</th>\n",
              "      <td>274</td>\n",
              "      <td>1291</td>\n",
              "      <td>58</td>\n",
              "      <td>2014</td>\n",
              "      <td>['belgian dance', 'belgian edm', 'big room', '...</td>\n",
              "      <td>48</td>\n",
              "      <td>408</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1834</th>\n",
              "      <td>735</td>\n",
              "      <td>1291</td>\n",
              "      <td>58</td>\n",
              "      <td>2014</td>\n",
              "      <td>['big room', 'edm', 'pop', 'progressive house'...</td>\n",
              "      <td>67</td>\n",
              "      <td>418</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1835</th>\n",
              "      <td>784</td>\n",
              "      <td>842</td>\n",
              "      <td>65</td>\n",
              "      <td>2018</td>\n",
              "      <td>['art pop', 'brooklyn indie', 'dance pop', 'es...</td>\n",
              "      <td>58</td>\n",
              "      <td>296</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1836 rows × 7 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "      Artist  Song Name  ...  Artist Popularity  Genres_cleaned\n",
              "0        373        852  ...                  0            1120\n",
              "1        373       1049  ...                  0            1120\n",
              "2        373       1166  ...                  0            1120\n",
              "3        373        182  ...                  0            1120\n",
              "4        373        859  ...                  0            1120\n",
              "...      ...        ...  ...                ...             ...\n",
              "1831     492        446  ...                 61             678\n",
              "1832    1151        309  ...                 49             968\n",
              "1833     274       1291  ...                 48             408\n",
              "1834     735       1291  ...                 67             418\n",
              "1835     784        842  ...                 58             296\n",
              "\n",
              "[1836 rows x 7 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 62
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "e6E9UdKahamX",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 221
        },
        "outputId": "57aa0487-ff05-4f42-f354-72cbab2157b4"
      },
      "source": [
        "merged_df_copy['Genres_cleaned'].value_counts()"
      ],
      "execution_count": 63,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "1059    30\n",
              "1120    30\n",
              "645     18\n",
              "643     14\n",
              "642     14\n",
              "        ..\n",
              "712      1\n",
              "711      1\n",
              "710      1\n",
              "709      1\n",
              "0        1\n",
              "Name: Genres_cleaned, Length: 1134, dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 63
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "xn8LI94sBJDm",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "from sklearn.model_selection import train_test_split\n",
        "X = merged_df_copy[['Artist', 'Song Popularity', 'Year', 'Song Name', 'Artist Popularity']].values\n",
        "y = merged_df_copy['Genres_cleaned'].values\n",
        "X_train, X_test, y_train, y_test = train_test_split(X, y, test_size=0.2, random_state=42)"
      ],
      "execution_count": 64,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fLMEP87yTmGh",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "b8b95a6a-4fc8-46f1-de2e-69e23473c0a8"
      },
      "source": [
        "X_train.shape, X_test.shape, y_train.shape, y_test.shape"
      ],
      "execution_count": 65,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "((1468, 5), (368, 5), (1468,), (368,))"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 65
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "GkWIxpCDJpmv",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "from tensorflow.keras.models import Sequential\n",
        "from tensorflow.keras.layers import Dense\n",
        "import numpy as np"
      ],
      "execution_count": 80,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "cXQfCI0_Le6c",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 119
        },
        "outputId": "c3417c0c-5480-4aaa-8259-7632755f0e6a"
      },
      "source": [
        "# Instantiating Model\n",
        "model2 = Sequential()\n",
        "# Input Layer\n",
        "model2.add(Dense(2, input_dim=5, activation=\"selu\"))\n",
        "# Hidden Layer 1 \n",
        "model2.add(Dense(16, activation=\"relu\"))\n",
        "# Hidden Layer 2\n",
        "model2.add(Dense(8, activation=\"relu\"))\n",
        "# Output Layer\n",
        "model2.add(Dense(1, activation=\"softmax\"))\n",
        "# Compiler\n",
        "model2.compile(loss=\"categorical_crossentropy\", optimizer=\"nadam\", metrics=[\"accuracy\"])\n",
        "# Fit\n",
        "h2 = model2.fit(X_train, y_train, epochs=3)"
      ],
      "execution_count": 81,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Epoch 1/3\n",
            "46/46 [==============================] - 0s 3ms/step - loss: 0.0000e+00 - accuracy: 0.0014\n",
            "Epoch 2/3\n",
            "46/46 [==============================] - 0s 3ms/step - loss: 0.0000e+00 - accuracy: 0.0014\n",
            "Epoch 3/3\n",
            "46/46 [==============================] - 0s 3ms/step - loss: 0.0000e+00 - accuracy: 0.0014\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "35Vto81_TxBN",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "#think about combining knn with nn \n",
        "#1 i need to figure out which nn i should use for recommender system? \n",
        "# WHAT I KNOW: \n",
        "## I know that i am running a categorical nn using the genre numbers as the output"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "YGdttawyHpaA",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import numpy as np\n",
        "import pandas as pd\n",
        "from sklearn.model_selection import train_test_split"
      ],
      "execution_count": 22,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "oddu4OyAHTOd",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "# Split train into train & val\n",
        "\n",
        "\n",
        "X = df[['acousticness', 'danceability', 'duration_ms', 'energy',\n",
        "       'explicit', 'instrumentalness', 'key', 'liveness', 'loudness',\n",
        "       'mode', 'popularity', 'speechiness', 'tempo',\n",
        "       'valence']]\n",
        "\n",
        "y = df['name']\n",
        "\n",
        "\n",
        "X_train, X_test, y_train, y_test = train_test_split(X,y, train_size=0.80, test_size=0.20)"
      ],
      "execution_count": 58,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "lcO-ZOOee2h_",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 122
        },
        "outputId": "d9e8a029-bdae-4633-f1b3-4c99ff97b78d"
      },
      "source": [
        "pip install sklearn"
      ],
      "execution_count": 67,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Requirement already satisfied: sklearn in /usr/local/lib/python3.6/dist-packages (0.0)\n",
            "Requirement already satisfied: scikit-learn in /usr/local/lib/python3.6/dist-packages (from sklearn) (0.22.2.post1)\n",
            "Requirement already satisfied: numpy>=1.11.0 in /usr/local/lib/python3.6/dist-packages (from scikit-learn->sklearn) (1.18.5)\n",
            "Requirement already satisfied: joblib>=0.11 in /usr/local/lib/python3.6/dist-packages (from scikit-learn->sklearn) (0.16.0)\n",
            "Requirement already satisfied: scipy>=0.17.0 in /usr/local/lib/python3.6/dist-packages (from scikit-learn->sklearn) (1.4.1)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "XeqsxhfgcmXP",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 68
        },
        "outputId": "9668664a-1a1c-4709-c832-d150b68acfc9"
      },
      "source": [
        "from sklearn.neighbors import KNeighborsClassifier\n",
        "from sklearn import metrics\n",
        "\n",
        "classifier = KNeighborsClassifier(n_neighbors=1000)\n",
        "classifier.fit(X_train, y_train)"
      ],
      "execution_count": 94,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "KNeighborsClassifier(algorithm='auto', leaf_size=30, metric='minkowski',\n",
              "                     metric_params=None, n_jobs=None, n_neighbors=1000, p=2,\n",
              "                     weights='uniform')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 94
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "NvSHsmIcqnQn",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "6275e7c0-1da4-4de8-ce4b-188bad9aed39"
      },
      "source": [
        "y_pred = classifier.predict(X_test)\n",
        "print(metrics.accuracy_score(y_test, y_pred))"
      ],
      "execution_count": 95,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "0.0\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "dy196lXPtAXN",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 54
        },
        "outputId": "efe140d3-e743-47b7-aa69-968124acd8bc"
      },
      "source": [
        "# try K=1 through K=25 and record testing accuracy\n",
        "k_range = range(1, 1000)\n",
        "\n",
        "# We can create Python dictionary using [] or dict()\n",
        "scores = []\n",
        "\n",
        "# We use a loop through the range 1 to 26\n",
        "# We append the scores in the dictionary\n",
        "for k in k_range:\n",
        "    knn = KNeighborsClassifier(n_neighbors=k)\n",
        "    knn.fit(X_train, y_train)\n",
        "    y_pred = knn.predict(X_test)\n",
        "    scores.append(metrics.accuracy_score(y_test, y_pred))\n",
        "\n",
        "print(scores)"
      ],
      "execution_count": 97,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0]\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "lwU2ZkBStKTL",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 296
        },
        "outputId": "46d15b9b-e673-4ef5-960f-91074339cef0"
      },
      "source": [
        "# import Matplotlib (scientific plotting library)\n",
        "import matplotlib.pyplot as plt\n",
        "\n",
        "# allow plots to appear within the notebook\n",
        "%matplotlib inline\n",
        "\n",
        "# plot the relationship between K and testing accuracy\n",
        "# plt.plot(x_axis, y_axis)\n",
        "plt.plot(k_range, scores)\n",
        "plt.xlabel('Value of K for KNN')\n",
        "plt.ylabel('Testing Accuracy')"
      ],
      "execution_count": 98,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Text(0, 0.5, 'Testing Accuracy')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 98
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZAAAAEGCAYAAABLgMOSAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAXQklEQVR4nO3de7hldX3f8fcHRiBquI8IjDqoGDsmFswOeEu9gAjesIZG0NYxoSX28QZoLNY+ctEnlSigREMlYkSTcAlqnWoVEdFY9UHOoFGGizOilEGEQS4+aItQv/1jrYPbwz5n9qxz9tnn8n49z37OXr/123t91yw4n7PWb11SVUiStK22G3cBkqTFyQCRJHVigEiSOjFAJEmdGCCSpE5WjLuA+bTnnnvW6tWrx12GJC0q69evv6OqVk5tX1YBsnr1aiYmJsZdhiQtKkluGtTuISxJUicGiCSpEwNEktSJASJJ6sQAkSR1YoBIkjoxQCRJnRggkqRODBBJUicGiCSpEwNEktSJASJJ6sQAkSR1YoBIkjoxQCRJnRggkqRODBBJUicGiCSpEwNEktSJASJJ6sQAkSR1YoBIkjoxQCRJnRggkqRODBBJUidjDZAkhye5IcmmJCcNmL9jkova+VcmWT1l/mOT3JvkrfNVsySpMbYASbI98CHgCGANcEySNVO6HQvcVVVPBM4CTp8y/0zg86OuVZL0UOPcAzkI2FRVN1bVL4ELgSOn9DkSOL99fwlwSJIAJHk58ENgwzzVK0nqM84A2Re4uW96c9s2sE9VPQDcA+yR5JHAfwJO3dpCkhyXZCLJxJYtW+akcEnS4h1EPwU4q6ru3VrHqjq3qnpV1Vu5cuXoK5OkZWLFGJd9C/CYvulVbdugPpuTrAB2AX4KHAwcleQvgV2BXyX5v1X1wdGXLUmC8QbIVcD+SfajCYqjgVdN6bMOWAt8EzgK+HJVFfCHkx2SnALca3hI0vwaW4BU1QNJ3gBcCmwPfLSqNiQ5DZioqnXAecAnkmwC7qQJGUnSApDmD/rlodfr1cTExLjLkKRFJcn6qupNbV+sg+iSpDEzQCRJnRggkqRODBBJUicGiCSpEwNEktSJASJJ6sQAkSR1YoBIkjoxQCRJnRggkqRODBBJUicGiCSpEwNEktSJASJJ6sQAkSR1YoBIkjoxQCRJnRggkqRODBBJUicGiCSpEwNEktSJASJJ6sQAkSR1YoBIkjoxQCRJnRggkqRODBBJUicGiCSpEwNEktTJWAMkyeFJbkiyKclJA+bvmOSidv6VSVa37S9Isj7J99qfz5/v2iVpuRtbgCTZHvgQcASwBjgmyZop3Y4F7qqqJwJnAae37XcAL62q3wPWAp+Yn6olSZPGuQdyELCpqm6sql8CFwJHTulzJHB++/4S4JAkqapvV9WP2/YNwG8l2XFeqpYkAUMESJIzkjxlBMveF7i5b3pz2zawT1U9ANwD7DGlzx8BV1fVfSOoUZI0jWH2QK4Dzm3HIF6XZJdRFzWsNthOB/5shj7HJZlIMrFly5b5K06SlritBkhVfaSqngW8BlgNfDfJPyR53iyXfQvwmL7pVW3bwD5JVgC7AD9tp1cBnwZeU1U/mKH+c6uqV1W9lStXzrJkSdKkocZA2gHvJ7evO4B/Bk5McuEsln0VsH+S/ZLsABwNrJvSZx3NIDnAUcCXq6qS7Ap8Djipqr4+ixokSR0NMwZyFnA98CLgL6rq96vq9Kp6KXBg1wW3YxpvAC6lOUx2cVVtSHJakpe13c4D9kiyCTgRmDzV9w3AE4F3JvlO+3pU11okSdsuVTVzh+RPaH65/3zAvF2q6p5RFTfXer1eTUxMjLsMSVpUkqyvqt7U9mEOYd0NrOj7ol2TvBxgMYWHJGluDRMgJ/cHRVXdDZw8upIkSYvBMAEyqM+KAW2SpGVkmACZSHJmkie0rzOB9aMuTJK0sA0TIG8Efglc1L7uA14/yqIkSQvfVg9FtWdfPeROuZKk5W2rAZJkJfA24CnATpPtVeUt1CVpGRvmENbf01xIuB9wKvAjmqvIJUnL2DABskdVnQfcX1Vfrao/Bdz7kKRlbpjTce9vf96a5MXAj4HdR1eSJGkxGCZA3t3ewv0twF8BOwMnjLQqSdKCN2OAtHfh3b+qPkvzMKfZ3sJdkrREzDgGUlX/DzhmnmqRJC0iwxzC+nqSD9JcRPjgHXmr6uqRVSVJWvCGCZAD2p+n9bUVnoklScvaMFeiO+4hSXqIYa5Ef+eg9qo6bVC7JGl5GOYQVv+TCHcCXkLzCFpJ0jI2zCGsM/qnk7yP5jnmkqRlbJhbmUz1cGDVXBciSVpchhkD+R7NWVcA2wMr+c0zsiRJy9AwYyAv6Xv/AHBbVT0wonokSYvEMIew9gburKqbquoW4LeSHDziuiRJC9wwAXIOcG/f9M/bNknSMjZMgKSqJsdAqKpfMdyhL0nSEjZMgNyY5E1JHta+3gzcOOrCJEkL2zAB8jrgmcAtwGbgYOC4URYlSVr4hrmQ8Hbg6HmoRZK0iGx1DyTJ+Ul27ZveLclHR1uWJGmhG+YQ1lOr6u7Jiaq6CzhwdCVJkhaDYQJkuyS7TU4k2R3PwpKkZW+YADkD+GaSdyV5N/AN4L1zsfAkhye5IcmmJCcNmL9jkova+VcmWd037+1t+w1JXjgX9UiShjfMIPrHk0zw6ycQvqKqrp3tgpNsD3wIeAHN2V1XJVk35buPBe6qqicmORo4HXhlkjU0A/tPAfYBvpTkSe0z3CVJ82CoQ1HtL/VrkzwBeFWSf6yqp8xy2QcBm6rqRoAkFwJHAv0BciRwSvv+EuCDSdK2X1hV9wE/TLKp/b5vzrKmgU79Hxu49sc/G8VXS9LIrdlnZ05+6Wx/ZT/UMGdh7ZPkhCRXARvaz8zFab37Ajf3TW9u2wb2aW/geA+wx5Cfnaz/uCQTSSa2bNkyB2VLkmCGPZAkxwHH0PxivpjmcNJnqurUeaptTlTVucC5AL1er7bSfaBRJLckLXYzHcL6IM0hoVdV1QRAkk6/gKdxC/CYvulVbdugPpuTrAB2AX465GclSSM00yGsvYELgDPaM53eBTxsDpd9FbB/kv2S7EBzWGzdlD7rgLXt+6OAL7c3dlwHHN2epbUfsD/wrTmsTZK0FdMGSFX9tKr+W1U9BzgEuBu4Lcl1Sf5itgtuxzTeQPN89euAi6tqQ5LTkrys7XYesEc7SH4icFL72Q00h9WuBb4AvN4zsCRpfqXvTu3DfSB5EnB0VS26x9r2er2amJgYdxmStKgkWV9Vvant23xFeVV9H5+JLknL3jBXokuS9BAGiCSpk60ewkrytAHN9wA3tQPhkqRlaJgxkL8GngZ8FwjwuzRXpO+S5D9W1RdHWJ8kaYEa5hDWj4EDq6pXVb9P8yyQG2lugviXoyxOkrRwDRMgT2qvuwAevLHikydvgihJWp6GOYS1Ick5wIXt9Ctp7sy7I3D/yCqTJC1ow+yBvBbYBBzfvm5s2+4HnjeqwiRJC9swD5T6PzRPJTxjwOx757wiSdKiMMxpvM+ieajT4/r7V9XjR1eWJGmhG2YM5DzgBGA94A0LJUnAcAFyT1V9fuSVSJIWlWEC5Iok7wU+Bdw32VhVV4+sKknSgjdMgBzc/uy/lW8Bz5/7ciRJi8UwZ2F5qq4k6SGmDZAk/7aq/i7JiYPmV9WZoytLkrTQzbQH8oj2528PmLdtjzGUJC050wZIVX24ffulqvp6/7z22hBJ0jI2zK1M/mrINknSMjLTGMgzgGcCK6eMg+wMbD/qwiRJC9tMYyA7AI9s+/SPg/wMOGqURUmSFr6ZxkC+Cnw1yceq6iaAJNsBj6yqn81XgZKkhWmYMZD/mmTnJI8ArqF5Fsifj7guSdICN0yArGn3OF4OfB7YD/h3I61KkrTgDRMgD0vyMJoAWVdV9+N1IJK07A0TIB8GfkRzYeE/JXkczUC6JGkZG+ZeWGcDZ/c13ZTE+2NJ0jK31T2QJHslOS/J59vpNcDakVcmSVrQhjmE9THgUmCfdvr7wPGjKkiStDhMGyBJJg9v7VlVFwO/AqiqB5jlo22T7J7ksiQb25+7TdNvbdtnY5K1bdvDk3wuyfVJNiR5z2xqkSR1M9MeyLfanz9PsgftmVdJng7cM8vlngRcXlX7A5e3078hye7AyTQPtDoIOLkvaN5XVU8GDgSeleSIWdYjSdpGMwVI2p8nAuuAJyT5OvBx4I2zXO6RwPnt+/NpThGe6oXAZVV1Z1XdBVwGHF5Vv6iqKwCq6pfA1cCqWdYjSdpGM52F1X8TxU8D/5MmVO4DDgW+O4vl7lVVt7bvfwLsNaDPvsDNfdOb27YHJdkVeCnwgVnUIknqYKYA2Z7mZoqZ0v7wYb44yZeARw+Y9Y7+iaqqJNt8YWI7RnMBcHZV3ThDv+OA4wAe+9jHbutiJEnTmClAbq2q07p+cVUdOt28JLcl2buqbk2yN3D7gG63AM/tm14FfKVv+lxgY1W9fyt1nNv2pdfreQW9JM2RYcZARmEdv76WZC3wmQF9LgUOS7JbO3h+WNtGkncDu+DpxJI0NjMFyCEjXO57gBck2UgznvIegCS9JB8BqKo7gXcBV7Wv06rqziSraA6DrQGuTvKdJP9+hLVKkgZI1fI5qtPr9WpiYmLcZUjSopJkfVX1prYPcyW6JEkPYYBIkjoxQCRJnRggkqRODBBJUicGiCSpEwNEktSJASJJ6sQAkSR1YoBIkjoxQCRJnRggkqRODBBJUicGiCSpEwNEktSJASJJ6sQAkSR1YoBIkjoxQCRJnRggkqRODBBJUicGiCSpEwNEktSJASJJ6sQAkSR1YoBIkjoxQCRJnRggkqRODBBJUicGiCSpEwNEktTJWAIkye5JLkuysf252zT91rZ9NiZZO2D+uiTXjL5iSdJU49oDOQm4vKr2By5vp39Dkt2Bk4GDgYOAk/uDJskrgHvnp1xJ0lTjCpAjgfPb9+cDLx/Q54XAZVV1Z1XdBVwGHA6Q5JHAicC756FWSdIA4wqQvarq1vb9T4C9BvTZF7i5b3pz2wbwLuAM4BdbW1CS45JMJJnYsmXLLEqWJPVbMaovTvIl4NEDZr2jf6KqKkltw/ceADyhqk5Isnpr/avqXOBcgF6vN/RyJEkzG1mAVNWh081LcluSvavq1iR7A7cP6HYL8Ny+6VXAV4BnAL0kP6Kp/1FJvlJVz0WSNG/GdQhrHTB5VtVa4DMD+lwKHJZkt3bw/DDg0qo6p6r2qarVwLOB7xsekjT/xhUg7wFekGQjcGg7TZJeko8AVNWdNGMdV7Wv09o2SdICkKrlMyzQ6/VqYmJi3GVI0qKSZH1V9aa2eyW6JKkTA0SS1IkBIknqxACRJHVigEiSOjFAJEmdGCCSpE4MEElSJwaIJKkTA0SS1IkBIknqxACRJHVigEiSOjFAJEmdGCCSpE4MEElSJwaIJKkTA0SS1IkBIknqxACRJHVigEiSOjFAJEmdGCCSpE4MEElSJ6mqcdcwb5JsAW7q+PE9gTvmsJzFwHVeHlzn5WE26/y4qlo5tXFZBchsJJmoqt6465hPrvPy4DovD6NYZw9hSZI6MUAkSZ0YIMM7d9wFjIHrvDy4zsvDnK+zYyCSpE7cA5EkdWKASJI6MUC2IsnhSW5IsinJSeOuZ64keUySK5Jcm2RDkje37bsnuSzJxvbnbm17kpzd/jt8N8nTxrsG3SXZPsm3k3y2nd4vyZXtul2UZIe2fcd2elM7f/U46+4qya5JLklyfZLrkjxjqW/nJCe0/11fk+SCJDstte2c5KNJbk9yTV/bNm/XJGvb/huTrN2WGgyQGSTZHvgQcASwBjgmyZrxVjVnHgDeUlVrgKcDr2/X7STg8qraH7i8nYbm32D/9nUccM78lzxn3gxc1zd9OnBWVT0RuAs4tm0/FrirbT+r7bcYfQD4QlU9GfiXNOu+ZLdzkn2BNwG9qvpdYHvgaJbedv4YcPiUtm3arkl2B04GDgYOAk6eDJ2hVJWvaV7AM4BL+6bfDrx93HWNaF0/A7wAuAHYu23bG7ihff9h4Ji+/g/2W0wvYFX7P9bzgc8Cobk6d8XUbQ5cCjyjfb+i7Zdxr8M2ru8uwA+n1r2UtzOwL3AzsHu73T4LvHApbmdgNXBN1+0KHAN8uK/9N/pt7eUeyMwm/0OctLltW1LaXfYDgSuBvarq1nbWT4C92vdL5d/i/cDbgF+103sAd1fVA+10/3o9uM7t/Hva/ovJfsAW4G/bw3YfSfIIlvB2rqpbgPcB/xu4lWa7rWdpb+dJ27pdZ7W9DZBlLskjgU8Cx1fVz/rnVfMnyZI5zzvJS4Dbq2r9uGuZRyuApwHnVNWBwM/59WENYElu592AI2nCcx/gETz0UM+SNx/b1QCZ2S3AY/qmV7VtS0KSh9GEx99X1afa5tuS7N3O3xu4vW1fCv8WzwJeluRHwIU0h7E+AOyaZEXbp3+9Hlzndv4uwE/ns+A5sBnYXFVXttOX0ATKUt7OhwI/rKotVXU/8Cmabb+Ut/Okbd2us9reBsjMrgL2b8/e2IFmIG7dmGuaE0kCnAdcV1Vn9s1aB0yeibGWZmxksv017dkcTwfu6dtVXhSq6u1VtaqqVtNsyy9X1auBK4Cj2m5T13ny3+Kotv+i+ku9qn4C3Jzkd9qmQ4BrWcLbmebQ1dOTPLz973xynZfsdu6zrdv1UuCwJLu1e26HtW3DGfcg0EJ/AS8Cvg/8AHjHuOuZw/V6Ns3u7XeB77SvF9Ec+70c2Ah8Cdi97R+aM9J+AHyP5gyXsa/HLNb/ucBn2/ePB74FbAL+Edixbd+pnd7Uzn/8uOvuuK4HABPttv7vwG5LfTsDpwLXA9cAnwB2XGrbGbiAZoznfpo9zWO7bFfgT9t13wT8ybbU4K1MJEmdeAhLktSJASJJ6sQAkSR1YoBIkjoxQCRJnRggWlLS3GH4hVPajk8y7U0Bk3wlSW/EdV3Q3gX1hCntpyR5a/t+p/YOqqcM+Py/ae+ke8Usari37/2Lknw/yePaGn6R5FHT9K0kZ/RNv3VQjVp+DBAtNRfQXCTY7+i2fSySPBr4g6p6alWdNU2fHWjuCrC+qk4Z0OVY4D9U1fOGXOaKGeYdApwNHFFVN7XNdwBvmeYj9wGvSLLnMMvW8mGAaKm5BHhx37MeVtPcD+lrSc5JMtE+J+LUQR+e8pf3UUk+1r5fmeSTSa5qX88a8Nmdkvxtku+1Ny6c/GX/RWDfJN9J8ocDFrsCuAjYWFUPeeZMknfSXPh5XpL3TrecJK9Nsi7Jl2kuJhu0fv8K+BvgJVX1g75ZHwVe2d7ee6oHaJ6nfcKAeVrGDBAtKVV1J83VxEe0TUcDF1dzxew7qqoHPBV4TpKnbsNXf4DmWRJ/APwR8JEBfV7flFC/R3Ob7POT7AS8DPhBVR1QVV8b8Lm3Ab+squOnWafTaK4kf3VV/fkMy4HmPldHVdVzBnzVjjRXor+8qq6fMu9emhB58zTr/yHg1Ul2mWa+liEDREtR/2Gs/sNXf5zkauDbwFNoHhI2rEOBDyb5Ds19hXZu72Tc79nA3wG0v6BvAp40xHf/L+CZSYbpu7XlXNaG6CD3A9/g1w9SmupsYG2S3546o5o7NX+c5kFNEmCAaGn6DHBImsd2Pryq1ifZD3grcEhVPRX4HM09kKbqv7dP//ztgKe3exEHVNW+VXUvc+OfgOOBz0/eSXUWfj7DvF8BfwwclOQ/T51ZVXcD/0CzhzPI+2nC5xGzrFFLhAGiJaf9xX4FzSGZyb2PnWl+ud6TZC9+fYhrqtuS/Isk2wH/uq/9i8AbJyeSHDDgs18DXt3OfxLwWJonvw1T8ydpHoL0hSS7bqX7bJbzC+DFNIejBu2JnAn8Gc24zNTP3glczPR7MFpmDBAtVRfQPP/7AoCq+meaQ1fX0/yV/fVpPncSzSNQv0Fzp9NJbwJ67am41wKvG/DZvwa2S/I9mkHx11bVfcMWXFXnAJ8G1vWNaQwy2+XcSfOApf+S5GVT5t3R1rDjNB8/A/BsLAF4N15JUjfugUiSOjFAJEmdGCCSpE4MEElSJwaIJKkTA0SS1IkBIknq5P8DWn5ZtYsjkRMAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "whIQbJVfuc-M",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "x = ['Midnight Hour Blues']\n",
        "a = np.reshape(x,(-1,1))"
      ],
      "execution_count": 105,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "qvsGRlI6ux_L",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 34
        },
        "outputId": "5ac23759-d10b-4835-f590-5f28d9764fa8"
      },
      "source": [
        "a"
      ],
      "execution_count": 106,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array([['Midnight Hour Blues']], dtype='<U19')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 106
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "EOImv_gMtjUI",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 395
        },
        "outputId": "c8334abe-b3df-42de-b6f4-1c18dc6a34d8"
      },
      "source": [
        "knn.predict(a)"
      ],
      "execution_count": 107,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.6/dist-packages/sklearn/neighbors/_classification.py:171: FutureWarning: Beginning in version 0.22, arrays of bytes/strings will be converted to decimal numbers if dtype='numeric'. It is recommended that you convert the array to a float dtype before using it in scikit-learn, for example by using your_array = your_array.astype(np.float64).\n",
            "  X = check_array(X, accept_sparse='csr')\n",
            "/usr/local/lib/python3.6/dist-packages/sklearn/neighbors/_base.py:605: FutureWarning: Beginning in version 0.22, arrays of bytes/strings will be converted to decimal numbers if dtype='numeric'. It is recommended that you convert the array to a float dtype before using it in scikit-learn, for example by using your_array = your_array.astype(np.float64).\n",
            "  X = check_array(X, accept_sparse='csr')\n"
          ],
          "name": "stderr"
        },
        {
          "output_type": "error",
          "ename": "ValueError",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mValueError\u001b[0m                                Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-107-721b789499ef>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mknn\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mpredict\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ma\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/sklearn/neighbors/_classification.py\u001b[0m in \u001b[0;36mpredict\u001b[0;34m(self, X)\u001b[0m\n\u001b[1;32m    171\u001b[0m         \u001b[0mX\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mcheck_array\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mX\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maccept_sparse\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'csr'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    172\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 173\u001b[0;31m         \u001b[0mneigh_dist\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mneigh_ind\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mkneighbors\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mX\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    174\u001b[0m         \u001b[0mclasses_\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mclasses_\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    175\u001b[0m         \u001b[0m_y\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_y\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/sklearn/neighbors/_base.py\u001b[0m in \u001b[0;36mkneighbors\u001b[0;34m(self, X, n_neighbors, return_distance)\u001b[0m\n\u001b[1;32m    641\u001b[0m                 \u001b[0mX\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_fit_X\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mreduce_func\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mreduce_func\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    642\u001b[0m                 \u001b[0mmetric\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0meffective_metric_\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mn_jobs\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mn_jobs\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 643\u001b[0;31m                 **kwds))\n\u001b[0m\u001b[1;32m    644\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    645\u001b[0m         \u001b[0;32melif\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_fit_method\u001b[0m \u001b[0;32min\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0;34m'ball_tree'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m'kd_tree'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/sklearn/metrics/pairwise.py\u001b[0m in \u001b[0;36mpairwise_distances_chunked\u001b[0;34m(X, Y, reduce_func, metric, n_jobs, working_memory, **kwds)\u001b[0m\n\u001b[1;32m   1593\u001b[0m             \u001b[0mX_chunk\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mX\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0msl\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1594\u001b[0m         D_chunk = pairwise_distances(X_chunk, Y, metric=metric,\n\u001b[0;32m-> 1595\u001b[0;31m                                      n_jobs=n_jobs, **kwds)\n\u001b[0m\u001b[1;32m   1596\u001b[0m         if ((X is Y or Y is None)\n\u001b[1;32m   1597\u001b[0m                 \u001b[0;32mand\u001b[0m \u001b[0mPAIRWISE_DISTANCE_FUNCTIONS\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mmetric\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/sklearn/metrics/pairwise.py\u001b[0m in \u001b[0;36mpairwise_distances\u001b[0;34m(X, Y, metric, n_jobs, force_all_finite, **kwds)\u001b[0m\n\u001b[1;32m   1750\u001b[0m         \u001b[0mfunc\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpartial\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdistance\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcdist\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mmetric\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mmetric\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1751\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1752\u001b[0;31m     \u001b[0;32mreturn\u001b[0m \u001b[0m_parallel_pairwise\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mX\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mY\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mfunc\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mn_jobs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1753\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1754\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/sklearn/metrics/pairwise.py\u001b[0m in \u001b[0;36m_parallel_pairwise\u001b[0;34m(X, Y, func, n_jobs, **kwds)\u001b[0m\n\u001b[1;32m   1346\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1347\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0meffective_n_jobs\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mn_jobs\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m==\u001b[0m \u001b[0;36m1\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1348\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0mfunc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mX\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mY\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1349\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1350\u001b[0m     \u001b[0;31m# enforce a threading backend to prevent data communication overhead\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/sklearn/metrics/pairwise.py\u001b[0m in \u001b[0;36meuclidean_distances\u001b[0;34m(X, Y, Y_norm_squared, squared, X_norm_squared)\u001b[0m\n\u001b[1;32m    260\u001b[0m     \u001b[0mpaired_distances\u001b[0m \u001b[0;34m:\u001b[0m \u001b[0mdistances\u001b[0m \u001b[0mbetweens\u001b[0m \u001b[0mpairs\u001b[0m \u001b[0mof\u001b[0m \u001b[0melements\u001b[0m \u001b[0mof\u001b[0m \u001b[0mX\u001b[0m \u001b[0;32mand\u001b[0m \u001b[0mY\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    261\u001b[0m     \"\"\"\n\u001b[0;32m--> 262\u001b[0;31m     \u001b[0mX\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mY\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mcheck_pairwise_arrays\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mX\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mY\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    263\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    264\u001b[0m     \u001b[0;31m# If norms are passed as float32, they are unused. If arrays are passed as\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/sklearn/metrics/pairwise.py\u001b[0m in \u001b[0;36mcheck_pairwise_arrays\u001b[0;34m(X, Y, precomputed, dtype, accept_sparse, force_all_finite, copy)\u001b[0m\n\u001b[1;32m    139\u001b[0m         X = check_array(X, accept_sparse=accept_sparse, dtype=dtype,\n\u001b[1;32m    140\u001b[0m                         \u001b[0mcopy\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mcopy\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mforce_all_finite\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mforce_all_finite\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 141\u001b[0;31m                         estimator=estimator)\n\u001b[0m\u001b[1;32m    142\u001b[0m         Y = check_array(Y, accept_sparse=accept_sparse, dtype=dtype,\n\u001b[1;32m    143\u001b[0m                         \u001b[0mcopy\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mcopy\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mforce_all_finite\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mforce_all_finite\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/sklearn/utils/validation.py\u001b[0m in \u001b[0;36mcheck_array\u001b[0;34m(array, accept_sparse, accept_large_sparse, dtype, order, copy, force_all_finite, ensure_2d, allow_nd, ensure_min_samples, ensure_min_features, warn_on_dtype, estimator)\u001b[0m\n\u001b[1;32m    529\u001b[0m                     \u001b[0marray\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0marray\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mastype\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdtype\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcasting\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m\"unsafe\"\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcopy\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mFalse\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    530\u001b[0m                 \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 531\u001b[0;31m                     \u001b[0marray\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mnp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0masarray\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0marray\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0morder\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0morder\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdtype\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mdtype\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    532\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mComplexWarning\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    533\u001b[0m                 raise ValueError(\"Complex data not supported\\n\"\n",
            "\u001b[0;32m/usr/local/lib/python3.6/dist-packages/numpy/core/_asarray.py\u001b[0m in \u001b[0;36masarray\u001b[0;34m(a, dtype, order)\u001b[0m\n\u001b[1;32m     83\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     84\u001b[0m     \"\"\"\n\u001b[0;32m---> 85\u001b[0;31m     \u001b[0;32mreturn\u001b[0m \u001b[0marray\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ma\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdtype\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcopy\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mFalse\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0morder\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0morder\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     86\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     87\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;31mValueError\u001b[0m: could not convert string to float: 'Midnight Hour Blues'"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "8pcQrIOmcu3x",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "e761b99b-2973-4bd5-cf36-55d595c6c569"
      },
      "source": [
        "from sklearn.metrics import classification_report, confusion_matrix\n",
        "print(confusion_matrix(y_test, y_pred))\n",
        "print(classification_report(y_test, y_pred))"
      ],
      "execution_count": 64,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "[[0 0 1 ... 0 0 0]\n",
            " [0 0 0 ... 0 0 0]\n",
            " [0 0 0 ... 0 0 0]\n",
            " ...\n",
            " [0 0 0 ... 0 0 0]\n",
            " [0 0 0 ... 0 0 0]\n",
            " [0 0 0 ... 0 0 0]]\n",
            "                                                                                                                       precision    recall  f1-score   support\n",
            "\n",
            "                                                         \"Chi il bel sogno di Doretta\" from La rondine, Act I - Voice       0.00      0.00      0.00       1.0\n",
            "                                                                                                   '97 Bonnie & Clyde       0.00      0.00      0.00       0.0\n",
            "                                                                    (Is Anybody Going To) San Antone - Single Version       0.00      0.00      0.00       0.0\n",
            "                                                                                            (Love Is) The Tender Trap       0.00      0.00      0.00       0.0\n",
            "                                                                   10 Preludes, Op. 23: No. 10 in G-Flat Major: Largo       0.00      0.00      0.00       0.0\n",
            "                                                                                                            100 Years       0.00      0.00      0.00       0.0\n",
            "                                                                        12 Years Later - From \"Treasure Planet\"/Score       0.00      0.00      0.00       0.0\n",
            "                                                                 12 Études, Op. 10: No. 12 in C Minor \"Revolutionary\"       0.00      0.00      0.00       1.0\n",
            "                                                                                  12 Études, Op. 10: No. 9 in F Minor       0.00      0.00      0.00       0.0\n",
            "                                                                                                              200 Mph       0.00      0.00      0.00       0.0\n",
            "                                                                                                          24/7=Heaven       0.00      0.00      0.00       0.0\n",
            "                                                                 3 Morceaux en forme de poire, IES 38: III. Morceau I       0.00      0.00      0.00       1.0\n",
            "                                                                                                             3 Nights       0.00      0.00      0.00       1.0\n",
            "                                                                                                   33 Años - 33 Years       0.00      0.00      0.00       0.0\n",
            "                                                                                      4 AM - Adam K & Soha Radio Edit       0.00      0.00      0.00       0.0\n",
            "                                                                                                                4-2-0       0.00      0.00      0.00       0.0\n",
            "                                                                                    41 Mosquitoes Flying In Formation       0.00      0.00      0.00       0.0\n",
            "                                                                                          50 Ways to Leave Your Lover       0.00      0.00      0.00       0.0\n",
            "                                                                                                                 5:15       0.00      0.00      0.00       1.0\n",
            "                                                                                                            900 Miles       0.00      0.00      0.00       0.0\n",
            "                                                                                                A Corpse Without Soul       0.00      0.00      0.00       1.0\n",
            "                                                                                                           A Fly Girl       0.00      0.00      0.00       0.0\n",
            "                                                                                                 A Good Hearted Woman       0.00      0.00      0.00       1.0\n",
            "                                                                                                       A Light Groove       0.00      0.00      0.00       1.0\n",
            "                                                                                     A New Day Has Come - Radio Remix       0.00      0.00      0.00       0.0\n",
            "                                                                                A Nightingale Sang In Berkeley Square       0.00      0.00      0.00       1.0\n",
            "                                                                                                    A Song For Europe       0.00      0.00      0.00       1.0\n",
            "                                                                                                           A Sus Pies       0.00      0.00      0.00       0.0\n",
            "                                                                                                Aaj Dujanar Duti Path       0.00      0.00      0.00       0.0\n",
            "                                                                                                 Aankhon Mein Intezar       0.00      0.00      0.00       0.0\n",
            "                                                                                                   Aao Pardesi Saajan       0.00      0.00      0.00       0.0\n",
            "                                                                                                        Aao Sathi Aao       0.00      0.00      0.00       0.0\n",
            "                                                                                                          Actin Crazy       0.00      0.00      0.00       1.0\n",
            "                                                                                                Ae Saba Unse Kah Zara       0.00      0.00      0.00       1.0\n",
            "                                                                                                    Afotou gennithika       0.00      0.00      0.00       0.0\n",
            "                                                                                                      After The Dance       0.00      0.00      0.00       0.0\n",
            "                                                                                                                Alfie       0.00      0.00      0.00       1.0\n",
            "                                                                                         All Of You - Live - (take 3)       0.00      0.00      0.00       1.0\n",
            "                                                                                                 All the Pretty Girls       0.00      0.00      0.00       1.0\n",
            "                                                                                                  All the Wild Horses       0.00      0.00      0.00       1.0\n",
            "                                                                                                                Amiga       0.00      0.00      0.00       1.0\n",
            "                                                                                                     Among The Living       0.00      0.00      0.00       1.0\n",
            "                                                                                                          Amphetamine       0.00      0.00      0.00       1.0\n",
            "                                                                                                                 Angi       0.00      0.00      0.00       1.0\n",
            "                                                                                                              Animals       0.00      0.00      0.00       1.0\n",
            "                                                                                                    Apradh Meech Kela       0.00      0.00      0.00       1.0\n",
            "                                                                                                                Arena       0.00      0.00      0.00       1.0\n",
            "                                                                                                       At This Moment       0.00      0.00      0.00       1.0\n",
            "                                                                                                            Available       0.00      0.00      0.00       1.0\n",
            "                                                                                                    Baan Na Taan Gori       0.00      0.00      0.00       1.0\n",
            "                                                                                                              Bam Bam       0.00      0.00      0.00       1.0\n",
            "                                                                                                         Best Mistake       0.00      0.00      0.00       1.0\n",
            "                                                                                      Bhulnewale Tujhe Apni Jafaon Ki       0.00      0.00      0.00       1.0\n",
            "                                                                                                         Big Long Now       0.00      0.00      0.00       1.0\n",
            "                                                                                                            Big Mouth       0.00      0.00      0.00       1.0\n",
            "                                                                                                      Billie's Bounce       0.00      0.00      0.00       1.0\n",
            "                                                                                Bird on a Wire - Digitally Remastered       0.00      0.00      0.00       1.0\n",
            "                                                                                  Black Mountain Side - 2014 Remaster       0.00      0.00      0.00       1.0\n",
            "                                                                                                             Bluehawk       0.00      0.00      0.00       1.0\n",
            "                                                                                                          Body 2 Body       0.00      0.00      0.00       1.0\n",
            "                                                                                                        Body And Soul       0.00      0.00      0.00       1.0\n",
            "                                                                                                       Bohemian Polka       0.00      0.00      0.00       1.0\n",
            "                                                                                                  Bring Em Back Alive       0.00      0.00      0.00       1.0\n",
            "                                                                                                     Brush Your Teeth       0.00      0.00      0.00       1.0\n",
            "                                                                                                   Bus Drivers School       0.00      0.00      0.00       1.0\n",
            "                                                                                                           Butterbean       0.00      0.00      0.00       1.0\n",
            "                                                                                                       Buy You a Rose       0.00      0.00      0.00       1.0\n",
            "                                                                                             Call Me - Single Version       0.00      0.00      0.00       1.0\n",
            "                                                                                                  Can You Do Without?       0.00      0.00      0.00       1.0\n",
            "                                                                                                        Can't Believe       0.00      0.00      0.00       1.0\n",
            "                                                                                                    Capullo y Sorullo       0.00      0.00      0.00       1.0\n",
            "                                                                                              Cavatine: IV. Barcarole       0.00      0.00      0.00       1.0\n",
            "                                                                                                              Chained       0.00      0.00      0.00       1.0\n",
            "                                                                                                               Change       0.00      0.00      0.00       1.0\n",
            "                                                                      Chapter 2.6 - Dziewczynka z Luna Parku: Część 1       0.00      0.00      0.00       1.0\n",
            "                                                                                                        Clinging Vine       0.00      0.00      0.00       1.0\n",
            "                                                                                                          Coco Babaçu       0.00      0.00      0.00       1.0\n",
            "                                                                                     Come Rain Or Come Shine (Take 4)       0.00      0.00      0.00       1.0\n",
            "                                                                                                         Common Sense       0.00      0.00      0.00       1.0\n",
            "                                                                                                         Consummation       0.00      0.00      0.00       1.0\n",
            "                                                                                                      Corona And Lime       0.00      0.00      0.00       1.0\n",
            "                                                                                                          Cry No More       0.00      0.00      0.00       1.0\n",
            "                                                                                                        Cuando Cuando       0.00      0.00      0.00       1.0\n",
            "                                                                                                  Cuando Sale la Luna       0.00      0.00      0.00       1.0\n",
            "                                                                                                        D-I-V-O-R-C-E       0.00      0.00      0.00       1.0\n",
            "                                                                                                           Daisy Jane       0.00      0.00      0.00       1.0\n",
            "                                                                           Das ist bei uns nicht möglich, Kapitel 209       0.00      0.00      0.00       1.0\n",
            "                                                                                     Day of the Lords - 2007 Remaster       0.00      0.00      0.00       1.0\n",
            "                                                                                                               Desire       0.00      0.00      0.00       1.0\n",
            "                                                                                                 Di Que No Me Dejaras       0.00      0.00      0.00       1.0\n",
            "                                                                                                          Dirty Boots       0.00      0.00      0.00       1.0\n",
            "                                                                                                       Do What I Want       0.00      0.00      0.00       1.0\n",
            "                                                                                                          Dog Barking       0.00      0.00      0.00       1.0\n",
            "                                                                               Don't Let Our Love Start Slippin' Away       0.00      0.00      0.00       1.0\n",
            "                                                                                                         Dov'è Lucia?       0.00      0.00      0.00       1.0\n",
            "                                                                                                  Down Came the World       0.00      0.00      0.00       1.0\n",
            "                                                                                                       Dream Catch Me       0.00      0.00      0.00       1.0\n",
            "                                                                                                      Dreams - Take 2       0.00      0.00      0.00       1.0\n",
            "                                                                                                                Drown       0.00      0.00      0.00       1.0\n",
            "                                                                                                              Duchess       0.00      0.00      0.00       1.0\n",
            "                                                                                                                 Dude       0.00      0.00      0.00       1.0\n",
            "                                           Ein Heldenleben, Op. 40: The Hero's Retreat from the World and Fulfillment       0.00      0.00      0.00       1.0\n",
            "                                                                                                     El Amor En Carro       0.00      0.00      0.00       1.0\n",
            "                                                                                   El Chino Pantaleón - Remasterizado       0.00      0.00      0.00       1.0\n",
            "                                                                         El Tiempo No Es Pa' Casorios - Remasterizado       0.00      0.00      0.00       1.0\n",
            "                                                                                                    Elusive Butterfly       0.00      0.00      0.00       1.0\n",
            "                                                                                                          Everlasting       0.00      0.00      0.00       1.0\n",
            "                                                                                                                 Ewan       0.00      0.00      0.00       1.0\n",
            "                                                                                                  Eyes Without A Face       0.00      0.00      0.00       1.0\n",
            "                                                                                                             Falsaria       0.00      0.00      0.00       1.0\n",
            "                                                                                                             Fantasma       0.00      0.00      0.00       1.0\n",
            "                                                                                                        Fantastic Day       0.00      0.00      0.00       1.0\n",
            "                                                                                                         Feel You Now       0.00      0.00      0.00       1.0\n",
            "                                                                                                     Florita Del Alma       0.00      0.00      0.00       1.0\n",
            "                                                                                                              Flowers       0.00      0.00      0.00       1.0\n",
            "                                                                                                  For Miles And Miles       0.00      0.00      0.00       1.0\n",
            "                                                                                                               Framed       0.00      0.00      0.00       2.0\n",
            "                                                                                       Funny Face - Alternate Version       0.00      0.00      0.00       1.0\n",
            "                                                                                                             Gardenia       0.00      0.00      0.00       1.0\n",
            "                                                                                                     Gavilán o Paloma       0.00      0.00      0.00       1.0\n",
            "                                                                                             Get Up! (feat. Skrillex)       0.00      0.00      0.00       1.0\n",
            "                                                                          Gimme! Gimme! Gimme! (A Man After Midnight)       0.00      0.00      0.00       1.0\n",
            "                                                                                           Give It All We Got Tonight       0.00      0.00      0.00       1.0\n",
            "                                                                                          Give It Back to the Indians       0.00      0.00      0.00       1.0\n",
            "                                                                                                         Go Li'l Liza       0.00      0.00      0.00       1.0\n",
            "                                                                                                        Green Peppers       0.00      0.00      0.00       1.0\n",
            "                                                                                                             Guitarra       0.00      0.00      0.00       1.0\n",
            "                                                                                                    Hallelujah Chorus       0.00      0.00      0.00       1.0\n",
            "                                                                                                           Happy Jack       0.00      0.00      0.00       1.0\n",
            "                                                                                                             Hard Row       0.00      0.00      0.00       1.0\n",
            "                                                                                                  Hasta Que Dios Diga       0.00      0.00      0.00       1.0\n",
            "                                                                               Have Yourself A Merry Little Christmas       0.00      0.00      0.00       1.0\n",
            "                                                                                                                  Hay       0.00      0.00      0.00       1.0\n",
            "                                                                                                    Hey Joe (Hey Moe)       0.00      0.00      0.00       1.0\n",
            "                                                                                                     Hey Pretty Momma       0.00      0.00      0.00       1.0\n",
            "                                                                                            His Eye Is on the Sparrow       0.00      0.00      0.00       1.0\n",
            "                                                                                                              History       0.00      0.00      0.00       1.0\n",
            "                                                                                                    Hit the Road Jack       0.00      0.00      0.00       1.0\n",
            "                                                                                          Hold Me, Thrill Me, Kiss Me       0.00      0.00      0.00       1.0\n",
            "                                                                                                             Hot Girl       0.00      0.00      0.00       1.0\n",
            "                                                                                              House of the Rising Sun       0.00      0.00      0.00       1.0\n",
            "                                                                           How Long Will It Take (To Stop Loving You)       0.00      0.00      0.00       1.0\n",
            "                                                                                                                H•A•M       0.00      0.00      0.00       1.0\n",
            "                                                                          I Can't Believe That You're In Love With Me       0.00      0.00      0.00       1.0\n",
            "                                                                                         I Can't Get Started - Take 1       0.00      0.00      0.00       1.0\n",
            "                                                                                                     I Don't Need You       0.00      0.00      0.00       1.0\n",
            "                                                                                         I Get Lifted - 2004 Remaster       0.00      0.00      0.00       1.0\n",
            "                                                                                                       I Got the Chop       0.00      0.00      0.00       1.0\n",
            "                                                                                                  I Heard You Looking       0.00      0.00      0.00       1.0\n",
            "                                                                                                 I Thought It Was You       0.00      0.00      0.00       1.0\n",
            "                                                                                                      I Wish I Wasn't       0.00      0.00      0.00       1.0\n",
            "                                                                                           I'm Not Alone - Radio Edit       0.00      0.00      0.00       1.0\n",
            "                                                                                        I'm a Player - Street Version       0.00      0.00      0.00       1.0\n",
            "                                                                                           If I Had A Rocket Launcher       0.00      0.00      0.00       1.0\n",
            "                                                                                                           In My Head       0.00      0.00      0.00       1.0\n",
            "                       Incidental Music to A Midsummer Night's Dream, Op. 61: No. 5, Intermezzo. Allegro appassionato       0.00      0.00      0.00       1.0\n",
            "                                                                                                              Indiana       0.00      0.00      0.00       1.0\n",
            "                                                                                            Into the Woods (Prologue)       0.00      0.00      0.00       1.0\n",
            "                                                                                                      Invisible Tears       0.00      0.00      0.00       1.0\n",
            "                                                                                            It Ain't Me Babe (Stereo)       0.00      0.00      0.00       1.0\n",
            "                                                                                                          It's A Fire       0.00      0.00      0.00       1.0\n",
            "                                                                                                         It's My Life       0.00      0.00      0.00       1.0\n",
            "                                                                                        Jody's Got Your Girl And Gone       0.00      0.00      0.00       1.0\n",
            "                                                                                                      José Pérez León       0.00      0.00      0.00       1.0\n",
            "                                                                                        Just Coolin' (feat. Heavy D.)       0.00      0.00      0.00       1.0\n",
            "                                                                                                               Kangna       0.00      0.00      0.00       1.0\n",
            "                                                                                                                Kaper       0.00      0.00      0.00       1.0\n",
            "                                                                                                    Keep Myself Alive       0.00      0.00      0.00       1.0\n",
            "                                                                          King Porter Stomp - 2014 Remastered Version       0.00      0.00      0.00       1.0\n",
            "                                                                                                    La edad del cielo       0.00      0.00      0.00       1.0\n",
            "                                                                                                     Lamento No Morro       0.00      0.00      0.00       1.0\n",
            "                                                                                                   Land of the Snakes       0.00      0.00      0.00       1.0\n",
            "           Layla - Acoustic; Live at MTV Unplugged, Bray Film Studios, Windsor, England, UK, 1/16/1992; 1999 Remaster       0.00      0.00      0.00       1.0\n",
            "                                          Le sacre du printemps: Part 1 \"Adoration of the Earth\", Ritual of Abduction       0.00      0.00      0.00       1.0\n",
            "                                                                                                          Let's Do It       0.00      0.00      0.00       1.0\n",
            "                                                                                           Let's Take It to the Stage       0.00      0.00      0.00       1.0\n",
            "                                                                                                         Life of Pain       0.00      0.00      0.00       1.0\n",
            "                                                                                                          Lil' Homies       0.00      0.00      0.00       1.0\n",
            "                                                                                            Little Child Runnin' Wild       0.00      0.00      0.00       1.0\n",
            "                                                                                                            Locked Up       0.00      0.00      0.00       1.0\n",
            "                                                                           Long Gone - Live At Hammersmith Odeon/1985       0.00      0.00      0.00       1.0\n",
            "                                                                                                  Look on Yonder Wall       0.00      0.00      0.00       1.0\n",
            "                                                                                             Louisiana Saturday Night       0.00      0.00      0.00       1.0\n",
            "                                                                                              Love Has Taken Its Toll       0.00      0.00      0.00       1.0\n",
            "                                                                                                Love Is A Battlefield       0.00      0.00      0.00       1.0\n",
            "                                                                                            Love Is A Many-Splendored       0.00      0.00      0.00       1.0\n",
            "                                                                                                         Love Letters       0.00      0.00      0.00       1.0\n",
            "                                                                                                     Love Me, Love Me       0.00      0.00      0.00       1.0\n",
            "                                                                             Loving You Keeps Getting Better Everyday       0.00      0.00      0.00       1.0\n",
            "                                                                                             Maar Gayo Ek Tir Hae Ram       0.00      0.00      0.00       1.0\n",
            "                                                                                            Mad (feat. Devon Baldwin)       0.00      0.00      0.00       1.0\n",
            "                                                                                                                Magic       0.00      0.00      0.00       1.0\n",
            "                                                                             Malvaloca - Instrumental (Remasterizado)       0.00      0.00      0.00       1.0\n",
            "                                                                                                       Mama Nantucket       0.00      0.00      0.00       1.0\n",
            "                                                                                                    Mama Say a Prayer       0.00      0.00      0.00       1.0\n",
            "                                                                                                    Manhattan Skyline       0.00      0.00      0.00       1.0\n",
            "                                                                                            Margarita - Remasterizado       0.00      0.00      0.00       1.0\n",
            "                                                                                                        Me Encantaría       0.00      0.00      0.00       1.0\n",
            "                                                                                             Mere Bhaiya Ko Meri Umar       0.00      0.00      0.00       1.0\n",
            "                                                                                         Messa da Requiem: 4. Sanctus       0.00      0.00      0.00       1.0\n",
            "                                                                                                             Mi Reina       0.00      0.00      0.00       1.0\n",
            "                                                                                                          Mind Reader       0.00      0.00      0.00       1.0\n",
            "                                                                                                    Miss Amanda Jones       0.00      0.00      0.00       1.0\n",
            "                                                                                   Misty Mountain Hop - 2012 Remaster       0.00      0.00      0.00       1.0\n",
            "                                                                                                           Moonshiner       0.00      0.00      0.00       1.0\n",
            "                                                                                                           Moreno Soy       0.00      0.00      0.00       1.0\n",
            "                                                                                                              Moritat       0.00      0.00      0.00       1.0\n",
            "                                                    Mozart: Horn Concerto No. 3 in E-Flat Major, K. 447: III. Allegro       0.00      0.00      0.00       1.0\n",
            "                                                                                                           Murder Rap       0.00      0.00      0.00       1.0\n",
            "                                                                                            My Baby's Just Like Money       0.00      0.00      0.00       1.0\n",
            "                                                                                                     My Foolish Heart       0.00      0.00      0.00       1.0\n",
            "                                                                                                     My Kind of Woman       0.00      0.00      0.00       1.0\n",
            "                                                                   My Last Affair (with Teddy Wilson & His Orchestra)       0.00      0.00      0.00       1.0\n",
            "                                                                           My Little Suede Shoes - Remastered Version       0.00      0.00      0.00       1.0\n",
            "                                                                                                     Música Romántica       0.00      0.00      0.00       1.0\n",
            "                                                                                           Never in My Wildest Dreams       0.00      0.00      0.00       1.0\n",
            "                                                                                                  Người Tình Mùa Đông       0.00      0.00      0.00       1.0\n",
            "                                       No One Mourns The Wicked - From \"Wicked\" Original Broadway Cast Recording/2003       0.00      0.00      0.00       1.0\n",
            "                                                                            No Se Si Es Amor (It Must Have Been Love)       0.00      0.00      0.00       1.0\n",
            "                                                                                               No Trash in My Trailer       0.00      0.00      0.00       1.0\n",
            "                                                                                                             Ntalania       0.00      0.00      0.00       1.0\n",
            "                                                                                                   Nunca Pense Llorar       0.00      0.00      0.00       1.0\n",
            "                                                                                                                Nutty       0.00      0.00      0.00       1.0\n",
            "                                                                                                            O Ntoulas       0.00      0.00      0.00       1.0\n",
            "                                                                      Oh, What a Beautiful Mornin' (From \"Oklahoma!\")       0.00      0.00      0.00       1.0\n",
            "                                                                                                           Old Hippie       0.00      0.00      0.00       1.0\n",
            "                                                                                         One Man Can Change The World       0.00      0.00      0.00       1.0\n",
            "                                                                                              Only the Strong Survive       0.00      0.00      0.00       1.0\n",
            "                                                                                                             Oo Debut       0.00      0.00      0.00       1.0\n",
            "                                                                                         Otello / Act 2: Ciò m'accora       0.00      0.00      0.00       1.0\n",
            "                                                                                                               Outlaw       0.00      0.00      0.00       1.0\n",
            "                                                                                     Outside the Rain - 2016 Remaster       0.00      0.00      0.00       1.0\n",
            "                                                                                                        Outta Control       0.00      0.00      0.00       1.0\n",
            "                                                                                                     Over The Rainbow       0.00      0.00      0.00       1.0\n",
            "                                                                                                  Pagliacci: Prologue       0.00      0.00      0.00       1.0\n",
            "                                                                                                           Papai Noel       0.00      0.00      0.00       1.0\n",
            "                                                                                                                Paris       0.00      0.00      0.00       1.0\n",
            "                                                                                     Part-Time Lover - Single Version       0.00      0.00      0.00       1.0\n",
            "                                                                                      Pavane, Op. 50 - 1929 Recording       0.00      0.00      0.00       1.0\n",
            "                                                                         Peter and the Wolf, Op. 67: The Story Begins       0.00      0.00      0.00       1.0\n",
            "                                                                           Piano Sonata No.18 in D, K.576: 1. Allegro       0.00      0.00      0.00       1.0\n",
            "                                                                                                    Por Favor Corazon       0.00      0.00      0.00       1.0\n",
            "                                                                                                         Preservation       0.00      0.00      0.00       1.0\n",
            "                                                                                                                Rambo       0.00      0.00      0.00       1.0\n",
            "                                                                                                         Raq El Habeb       0.00      0.00      0.00       1.0\n",
            "                                                                                                             Rat Race       0.00      0.00      0.00       1.0\n",
            "                                                                                           Read All About It, Pt. III       0.00      0.00      0.00       1.0\n",
            "                                                                                                            Remind Me       0.00      0.00      0.00       1.0\n",
            "                                                                                                           Rip It Out       0.00      0.00      0.00       1.0\n",
            "                                                                                                  Running Out Of Lies       0.00      0.00      0.00       1.0\n",
            "                                                                                                         Rush Over Me       0.00      0.00      0.00       1.0\n",
            "                                                                                                         Sabato notte       0.00      0.00      0.00       1.0\n",
            "                                                                                Say Something (feat. Chris Stapleton)       0.00      0.00      0.00       1.0\n",
            "                                                                                                               Scoops       0.00      0.00      0.00       1.0\n",
            "                                                           Second Rhapsody for Piano & Orchestra \"Rhapsody in Rivets\"       0.00      0.00      0.00       1.0\n",
            "                                                                                                       Secret Journey       0.00      0.00      0.00       1.0\n",
            "                                                                                                         Sensee Party       0.00      0.00      0.00       1.0\n",
            "                                                                                                                Seven       0.00      0.00      0.00       1.0\n",
            "                                                                                                 She's a Heartbreaker       0.00      0.00      0.00       1.0\n",
            "                                                                                     She’s Got It - Alternate Version       0.00      0.00      0.00       1.0\n",
            "                                                                                                         Si Tienes Fe       0.00      0.00      0.00       1.0\n",
            "                                                                                                 Siento Que Te Quiero       0.00      0.00      0.00       1.0\n",
            "                                                                                         Singing Winds, Crying Beasts       0.00      0.00      0.00       1.0\n",
            "                                                                                                          Skin I'm In       0.00      0.00      0.00       1.0\n",
            "                                                                                                                Sleep       0.00      0.00      0.00       1.0\n",
            "                                                                                                                Smash       0.00      0.00      0.00       1.0\n",
            "                                                                                                          Smoke Again       0.00      0.00      0.00       1.0\n",
            "                                                                                  Smoke the Weed (feat. Collie Buddz)       0.00      0.00      0.00       1.0\n",
            "                                                                                                              So Fine       0.00      0.00      0.00       1.0\n",
            "                                                                                                   Somebody Else Will       0.00      0.00      0.00       1.0\n",
            "                                                                                         Somebody That I Used To Know       0.00      0.00      0.00       1.0\n",
            "                                                                                             Someone To Watch Over Me       0.00      0.00      0.00       1.0\n",
            "                                                                                            Someplace Else - 2004 Mix       0.00      0.00      0.00       1.0\n",
            "                                                                                  Something's Gotten Hold of My Heart       0.00      0.00      0.00       1.0\n",
            "                                                          Sonatas and Interludes for Prepared Piano: Fourth Interlude       0.00      0.00      0.00       1.0\n",
            "                                                                                                   Songs Of Yesterday       0.00      0.00      0.00       1.0\n",
            "                                                                                                    Sorry, I Like You       0.00      0.00      0.00       1.0\n",
            "                                                                                                           Southbound       0.00      0.00      0.00       1.0\n",
            "                                                                                                      Spirit In Black       0.00      0.00      0.00       1.0\n",
            "                                                                             Spirits Drifting - 2004 Digital Remaster       0.00      0.00      0.00       1.0\n",
            "                                                                                                      Spiritual Cramp       0.00      0.00      0.00       1.0\n",
            "                                                                                                            Star Dust       0.00      0.00      0.00       1.0\n",
            "                                                                                           Start Wit Me (feat. Gunna)       0.00      0.00      0.00       1.0\n",
            "                                                                                                       Stay the Night       0.00      0.00      0.00       1.0\n",
            "                                                                                       Stories of Old - 2006 Remaster       0.00      0.00      0.00       1.0\n",
            "                                          String Quartet No. 7 in F Major, Op. 59 No. 1: II. Allegretto vivace (Live)       0.00      0.00      0.00       1.0\n",
            "                                                                                                              Strings       0.00      0.00      0.00       1.0\n",
            "                                                                                                            Sunflower       0.00      0.00      0.00       1.0\n",
            "                                                                                         Sunny - Digitally Remastered       0.00      0.00      0.00       1.0\n",
            "                                                                                                            SuperStar       0.00      0.00      0.00       1.0\n",
            "                                                                                                     Superficial Love       0.00      0.00      0.00       1.0\n",
            "                                                                                                            Superstar       0.00      0.00      0.00       1.0\n",
            "                                                                                                     Sweet and Gentle       0.00      0.00      0.00       1.0\n",
            "                                                      Symphony No. 41 in C Major, K. 551 \"Jupiter\": I. Allegro vivace       0.00      0.00      0.00       1.0\n",
            "                                                                                                           Sărută-mă!       0.00      0.00      0.00       1.0\n",
            "                                                                                                    Take Me to Church       0.00      0.00      0.00       1.0\n",
            "                                                                                                 Talking Cuban Crisis       0.00      0.00      0.00       1.0\n",
            "Tchaikovsky: The Sleeping Beauty, Op. 66, Prologue \"The Christening\": No. 2, Entrance of the Fairies - Scène dansante       0.00      0.00      0.00       1.0\n",
            "                                                                                                     Te Voy a Olvidar       0.00      0.00      0.00       1.0\n",
            "                                                                                                   That's Not My Name       0.00      0.00      0.00       1.0\n",
            "                                                                                                         The Distance       0.00      0.00      0.00       1.0\n",
            "                                                                                                  The Feeling Of Jazz       0.00      0.00      0.00       1.0\n",
            "                                                                                  The Goin' Gets Tough From The Getgo       0.00      0.00      0.00       1.0\n",
            "                                                                                          The Lady's In Love With You       0.00      0.00      0.00       1.0\n",
            "                                                                                           The Shepherd's Cradle Song       0.00      0.00      0.00       1.0\n",
            "                                                                                                   The Skaters' Waltz       0.00      0.00      0.00       1.0\n",
            "                                                                                             The Trance Is the Motion       0.00      0.00      0.00       1.0\n",
            "                                                                                              The Years Without Light       0.00      0.00      0.00       1.0\n",
            "                                                                                                      Therapy Session       0.00      0.00      0.00       1.0\n",
            "                                                                                  There's Nothing the Matter With Me!       0.00      0.00      0.00       1.0\n",
            "                                                                              These Dreams of You - Alternate Version       0.00      0.00      0.00       1.0\n",
            "                                                                                              Third Rock from the Sun       0.00      0.00      0.00       1.0\n",
            "                                                                                                           This Is Me       0.00      0.00      0.00       1.0\n",
            "                                                                           This Photograph Is Proof (I Know You Know)       0.00      0.00      0.00       1.0\n",
            "                                                                                                Thuggish Ruggish Bone       0.00      0.00      0.00       1.0\n",
            "                                                                                       To Live Is to Die (Remastered)       0.00      0.00      0.00       1.0\n",
            "                                                                                                   To kokkino mantili       0.00      0.00      0.00       1.0\n",
            "                                                                                                             Too Cool       0.00      0.00      0.00       1.0\n",
            "                                                                                                         Torpedo Girl       0.00      0.00      0.00       1.0\n",
            "                                                                                                                 Trap       0.00      0.00      0.00       1.0\n",
            "                                                                 Trio avec piano No. 2 in G Major, K. 496: I. Allegro       0.00      0.00      0.00       1.0\n",
            "                                                                                              Try a Little Tenderness       0.00      0.00      0.00       1.0\n",
            "                                                                                          Tu Voudrais Me Voir Pleurer       0.00      0.00      0.00       1.0\n",
            "                                                                                      Turandot, Act III: Nessun dorma       0.00      0.00      0.00       1.0\n",
            "                                                                                                Turn Your Love Around       0.00      0.00      0.00       1.0\n",
            "                                                                                Tutte 'e ssere - Musical base Version       0.00      0.00      0.00       1.0\n",
            "                                                                                                   Twelfth Street Rag       0.00      0.00      0.00       1.0\n",
            "                                                                                                    Un-Break My Heart       0.00      0.00      0.00       1.0\n",
            "                                                                                                      Under My Wheels       0.00      0.00      0.00       1.0\n",
            "                                                                                                               Urgent       0.00      0.00      0.00       1.0\n",
            "                                                                                          Violence (Enough Is Enough)       0.00      0.00      0.00       1.0\n",
            "                                                              Violin Concerto in D Minor, Op. 47: II. Adagio di molto       0.00      0.00      0.00       1.0\n",
            "                                                                                                                Vixen       0.00      0.00      0.00       1.0\n",
            "                                                                                     Waking The Witch - 2018 Remaster       0.00      0.00      0.00       1.0\n",
            "                                                                                                        Waste of Time       0.00      0.00      0.00       1.0\n",
            "                                                                                                       Watch Her Ride       0.00      0.00      0.00       1.0\n",
            "                                                                                              We Can't Go On This Way       0.00      0.00      0.00       1.0\n",
            "                                                                                               We Do It For Fun Pt. 2       0.00      0.00      0.00       1.0\n",
            "                                                                                   We Will All Go Together When We Go       0.00      0.00      0.00       1.0\n",
            "                                Welcome Home (Sanitarium) (Live at the Aragon Ballroom, Chicago, IL - May 25th, 1986)       0.00      0.00      0.00       1.0\n",
            "                                                                                                  Welcome To The 60's       0.00      0.00      0.00       1.0\n",
            "                                                                                      Whatever Lola Wants (Lola Gets)       0.00      0.00      0.00       1.0\n",
            "                                        Whatever Will Be, Will Be (Que Sera, Sera) (with Frank DeVol & His Orchestra)       0.00      0.00      0.00       2.0\n",
            "                                                                                            When You Wish Upon a Star       0.00      0.00      0.00       1.0\n",
            "                                                                                       Whenever (feat. Conor Maynard)       0.00      0.00      0.00       1.0\n",
            "                                                                                                     Where Do I Begin       0.00      0.00      0.00       1.0\n",
            "                                                                                      Who Needs You - Remastered 2011       0.00      0.00      0.00       1.0\n",
            "                                                                                        Whole Lot of Shakin' Going On       0.00      0.00      0.00       1.0\n",
            "                                                                                       Wifey - Club Mix/Dirty Version       0.00      0.00      0.00       1.0\n",
            "                                                                                                             Wild One       0.00      0.00      0.00       1.0\n",
            "                                                                                                           Wilson rag       0.00      0.00      0.00       1.0\n",
            "                                                                                                          Wind Spirit       0.00      0.00      0.00       1.0\n",
            "                                                                                                           Witchcraft       0.00      0.00      0.00       1.0\n",
            "                                                                                                                Women       0.00      0.00      0.00       1.0\n",
            "                                                                                                           Ya Te Vele       0.00      0.00      0.00       1.0\n",
            "                                                                                                    Yesterday - Vocal       0.00      0.00      0.00       1.0\n",
            "                                                                                                         You Gotta Be       0.00      0.00      0.00       1.0\n",
            "                                                                                                   You Never Can Tell       0.00      0.00      0.00       1.0\n",
            "                                                                                          You're Cute When You Scream       0.00      0.00      0.00       1.0\n",
            "                                                                                         You're The Only World I Know       0.00      0.00      0.00       1.0\n",
            "                                                                   You're the Nearest Thing to Heaven (2017 Remaster)       0.00      0.00      0.00       1.0\n",
            "                                                                                                       You're the One       0.00      0.00      0.00       1.0\n",
            "                                                                                 You've Still Got a Place in My Heart       0.00      0.00      0.00       1.0\n",
            "                                                        Your Auntie Grizelda - Original Stereo Version; 2006 Remaster       0.00      0.00      0.00       1.0\n",
            "                                                                            Your Heart Belongs To Me - Stereo Version       0.00      0.00      0.00       1.0\n",
            "                                                                                        Your Love Is Driving Me Crazy       0.00      0.00      0.00       1.0\n",
            "                                                                                                  seoul (prod. HONNE)       0.00      0.00      0.00       1.0\n",
            "                                                                                                 Γιατί μου το 'κρυψες       0.00      0.00      0.00       1.0\n",
            "                                                                          Часть 13.3 - На Западном фронте без перемен       0.00      0.00      0.00       1.0\n",
            "                                                                        Часть 160.4 & Часть 161.1 - Триумфальная арка       0.00      0.00      0.00       1.0\n",
            "                                                             Часть 75.2 & Часть 76.1 - На Западном фронте без перемен       0.00      0.00      0.00       1.0\n",
            "                                                  Часть 77.3 & Часть 78 & Часть 79.1 - На Западном фронте без перемен       0.00      0.00      0.00       1.0\n",
            "                                                                                                                偏偏喜歡你       0.00      0.00      0.00       1.0\n",
            "\n",
            "                                                                                                             accuracy                           0.00     351.0\n",
            "                                                                                                            macro avg       0.00      0.00      0.00     351.0\n",
            "                                                                                                         weighted avg       0.00      0.00      0.00     351.0\n",
            "\n"
          ],
          "name": "stdout"
        },
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.6/dist-packages/sklearn/metrics/_classification.py:1272: UndefinedMetricWarning: Precision and F-score are ill-defined and being set to 0.0 in labels with no predicted samples. Use `zero_division` parameter to control this behavior.\n",
            "  _warn_prf(average, modifier, msg_start, len(result))\n",
            "/usr/local/lib/python3.6/dist-packages/sklearn/metrics/_classification.py:1272: UndefinedMetricWarning: Recall and F-score are ill-defined and being set to 0.0 in labels with no true samples. Use `zero_division` parameter to control this behavior.\n",
            "  _warn_prf(average, modifier, msg_start, len(result))\n"
          ],
          "name": "stderr"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "sIoz7706eb_a",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}