{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Importing the libraries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import json\n",
    "import spotipy\n",
    "import spotipy.oauth2 as oauth2\n",
    "from spotipy.oauth2 import SpotifyOAuth,SpotifyClientCredentials\n",
    "import yaml\n",
    "import re\n",
    "from tqdm import tqdm\n",
    "import multiprocessing as mp\n",
    "import time\n",
    "import random\n",
    "import datetime\n",
    "import pickle\n",
    "from sklearn.feature_extraction.text import TfidfVectorizer\n",
    "from sklearn.metrics.pairwise import cosine_similarity\n",
    "from sklearn.preprocessing import MinMaxScaler\n",
    "import matplotlib.pyplot as plt\n",
    "from skimage import io\n",
    "from sklearn.preprocessing import OneHotEncoder"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "stream= open(\"spotify/spotify.yaml\")\n",
    "spotify_details = yaml.safe_load(stream)\n",
    "auth_manager = SpotifyClientCredentials(client_id=spotify_details['Client_id'],\n",
    "                                        client_secret=spotify_details['client_secret'])\n",
    "sp = spotipy.client.Spotify(auth_manager=auth_manager)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Importing the dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "dtypes = {'track_uri': 'object', 'artist_uri': 'object', 'album_uri': 'object', 'danceability': 'float16', 'energy': 'float16', 'key': 'float16',\n",
    "               'loudness': 'float16', 'mode': 'float16', 'speechiness': 'float16', 'acousticness': 'float16', 'instrumentalness': 'float16',\n",
    "               'liveness': 'float16', 'valence': 'float16', 'tempo': 'float16', 'duration_ms': 'float32', 'time_signature': 'float16',\n",
    "               'Track_release_date': 'int8', 'Track_pop': 'int8', 'Artist_pop': 'int8', 'Artist_genres': 'object'}\n",
    "try:\n",
    "    df=pd.read_csv('Data/1M_unique_processed_data_grow.csv',dtype=dtypes)\n",
    "except:\n",
    "    print('Failed to load grow')\n",
    "    df=pd.read_csv('Data/1M_unique_processed_data.csv',dtype=dtypes)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Test"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Extract playlist tracks and artist uri"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "80\n",
      "80\n"
     ]
    }
   ],
   "source": [
    "def get_IDs (user, playlist_id):\n",
    " track_ids = []\n",
    " artist_id = []\n",
    " playlist=sp.user_playlist (user, playlist_id)\n",
    " for item in playlist['tracks']['items']:\n",
    "  track=item['track']\n",
    "  track_ids.append(track['id'])\n",
    "  artist=item['track']['artists']\n",
    "  artist_id.append(artist[0]['id'])\n",
    " return track_ids,artist_id\n",
    "\n",
    "\n",
    "track_ids,artist_id = get_IDs ('Ruby', 'spotify:playlist:37i9dQZF1DX8FwnYE6PRvL') \n",
    "print (len(track_ids))\n",
    "print (len(artist_id))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "getting the unique URI and repeating the extraction features and preprocessing steps for the user's playlist (input)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "artist_id_uni=list(set(artist_id))\n",
    "track_ids_uni=list(set(track_ids))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|██████████| 4/4 [00:00<00:00, 12.20it/s]\n"
     ]
    }
   ],
   "source": [
    "audio_features=pd.DataFrame()\n",
    "for i in tqdm(range(0,len(track_ids_uni),25)):\n",
    "    try:\n",
    "     track_feature = sp.audio_features(track_ids_uni[i:i+25])\n",
    "     track_df = pd.DataFrame(track_feature)\n",
    "     audio_features=pd.concat([audio_features,track_df],axis=0)\n",
    "    except Exception as e:\n",
    "        print(e)\n",
    "        continue"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|██████████| 4/4 [00:00<00:00,  4.37it/s]"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "list index out of range\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\n"
     ]
    }
   ],
   "source": [
    "track_=pd.DataFrame()\n",
    "for i in tqdm(range(0,len(track_ids_uni),25)):\n",
    "    try:\n",
    "        track_features = sp.tracks(track_ids_uni[i:i+25])\n",
    "        for x in range(25):\n",
    "            track_pop=pd.DataFrame([track_ids_uni[i+x]],columns=['Track_uri'])\n",
    "            track_pop['Track_release_date']=track_features['tracks'][x]['album']['release_date']\n",
    "            track_pop['Track_pop'] = track_features['tracks'][x][\"popularity\"]\n",
    "            track_pop['Artist_uri']=track_features['tracks'][x]['artists'][0]['id']\n",
    "            track_pop['Album_uri']=track_features['tracks'][x]['album']['id']\n",
    "            track_=pd.concat([track_,track_pop],axis=0)\n",
    "    except Exception as e:\n",
    "        print(e)\n",
    "        continue"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|██████████| 3/3 [00:00<00:00,  9.76it/s]"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "list index out of range\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\n"
     ]
    }
   ],
   "source": [
    "artist_=pd.DataFrame()\n",
    "for i in tqdm(range(0,len(artist_id_uni),25)):\n",
    "    try:\n",
    "        artist_features = sp.artists(artist_id_uni[i:i+25])\n",
    "        for x in range(25):\n",
    "            artist_df=pd.DataFrame([artist_id_uni[i+x]],columns=['Artist_uri'])\n",
    "            artist_pop = artist_features['artists'][x][\"popularity\"]\n",
    "            artist_genres = artist_features['artists'][x][\"genres\"]\n",
    "            artist_df[\"Artist_pop\"] = artist_pop\n",
    "            if artist_genres: \n",
    "                artist_df[\"genres\"] = \" \".join([re.sub(' ','_',i) for i in artist_genres])\n",
    "            else:\n",
    "              artist_df[\"genres\"] = \"unknown\"\n",
    "            artist_=pd.concat([artist_,artist_df],axis=0)\n",
    "    except Exception as e:\n",
    "        print(e)\n",
    "        continue"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "test=pd.DataFrame(track_,columns=['Track_uri','Artist_uri','Album_uri'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "test.rename(columns = {'Track_uri':'track_uri','Artist_uri':'artist_uri','Album_uri':'album_uri'}, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "audio_features.drop(columns=['type','uri','track_href','analysis_url'],axis=1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "test = pd.merge(test,audio_features, left_on = \"track_uri\", right_on= \"id\",how = 'outer')\n",
    "test = pd.merge(test,track_, left_on = \"track_uri\", right_on= \"Track_uri\",how = 'outer')\n",
    "test = pd.merge(test,artist_, left_on = \"artist_uri\", right_on= \"Artist_uri\",how = 'outer')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "del audio_features,track_,artist_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "test.rename(columns = {'genres':'Artist_genres'}, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "test.drop(columns=['Track_uri','Artist_uri_x','Artist_uri_y','Album_uri','id'],axis=1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "test.dropna(axis=0,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "test['Track_pop'] = test['Track_pop'].apply(lambda x: int(x/5))\n",
    "test['Artist_pop'] = test['Artist_pop'].apply(lambda x: int(x/5))\n",
    "test['Track_release_date'] = test['Track_release_date'].apply(lambda x: x.split('-')[0])\n",
    "test['Track_release_date']=test['Track_release_date'].astype('int16')\n",
    "test['Track_release_date'] = test['Track_release_date'].apply(lambda x: int(x/50))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "test[['danceability', 'energy', 'key','loudness', 'mode', 'speechiness', 'acousticness', 'instrumentalness','liveness', 'valence', 'tempo', 'time_signature']]=test[['danceability', 'energy', 'key','loudness', 'mode', 'speechiness', 'acousticness', 'instrumentalness','liveness', 'valence', 'tempo','time_signature']].astype('float16')\n",
    "test[['duration_ms']]=test[['duration_ms']].astype('float32')\n",
    "test[['Track_release_date', 'Track_pop', 'Artist_pop']]=test[['Track_release_date', 'Track_pop', 'Artist_pop']].astype('int8')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "currentdf=len(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.concat([df,test],axis=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop_duplicates(subset=['track_uri'],inplace=True,keep='last') ## keep last to keep the dataset updated "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.dropna(axis=0,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "36 New Tracks Found\n"
     ]
    }
   ],
   "source": [
    "print('{} New Tracks Found'.format(len(df)-currentdf))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "36 New Found\n"
     ]
    }
   ],
   "source": [
    "#saving the tracks if they weren't found in the dataset\n",
    "if len(df)>currentdf:   \n",
    "    df.to_csv('data/1M_unique_processed_data_grow.csv',index=False)\n",
    "    print('{} New Found'.format(len(df)-currentdf))\n",
    "    streamlit=df[df.Track_pop >0]             # dropped track with 0 popularity score to save space and ram for the final model\n",
    "    streamlit.to_csv('data/streamlit.csv',index=False)\n",
    "    del streamlit"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df[~df['track_uri'].isin(test['track_uri'].values)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "test['Artist_genres'] = test['Artist_genres'].apply(lambda x: x.split(\" \"))\n",
    "tfidf = TfidfVectorizer(max_features=3) #max_features=5 \n",
    "tfidf_matrix = tfidf.fit_transform(test['Artist_genres'].apply(lambda x: \" \".join(x)))\n",
    "genre_df = pd.DataFrame(tfidf_matrix.toarray())\n",
    "genre_df.columns = ['genre' + \"|\" + i for i in tfidf.get_feature_names_out()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "genre_df=genre_df.astype('float16')\n",
    "test.drop(columns=['Artist_genres'],axis=1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "test = pd.concat([test.reset_index(drop=True), genre_df.reset_index(drop=True)],axis = 1)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test.isna().sum().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Artist_genres'] = df['Artist_genres'].apply(lambda x: x.split(\" \"))\n",
    "tfidf_matrix = tfidf.transform(df['Artist_genres'].apply(lambda x: \" \".join(x)))\n",
    "genre_df = pd.DataFrame(tfidf_matrix.toarray())\n",
    "genre_df.columns = ['genre' + \"|\" + i for i in tfidf.get_feature_names_out()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "genre_df=genre_df.astype('float16')\n",
    "df.drop(columns=['Artist_genres'],axis=1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.concat([df.reset_index(drop=True), genre_df.reset_index(drop=True)],axis = 1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# pred"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "genre|unknown not found\n"
     ]
    }
   ],
   "source": [
    "try:\n",
    "    df.drop(columns=['genre|unknown'],axis=1,inplace=True)\n",
    "    test.drop(columns=['genre|unknown'],axis=1,inplace=True)\n",
    "except:\n",
    "    print('genre|unknown not found')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['track_uri', 'artist_uri', 'album_uri', 'danceability', 'energy', 'key',\n",
       "       'loudness', 'mode', 'speechiness', 'acousticness', 'instrumentalness',\n",
       "       'liveness', 'valence', 'tempo', 'duration_ms', 'time_signature',\n",
       "       'Track_release_date', 'Track_pop', 'Artist_pop', 'genre|modern_rock',\n",
       "       'genre|permanent_wave', 'genre|rock'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['track_uri', 'artist_uri', 'album_uri', 'danceability', 'energy', 'key',\n",
       "       'loudness', 'mode', 'speechiness', 'acousticness', 'instrumentalness',\n",
       "       'liveness', 'valence', 'tempo', 'duration_ms', 'time_signature',\n",
       "       'Track_release_date', 'Track_pop', 'Artist_pop', 'genre|modern_rock',\n",
       "       'genre|permanent_wave', 'genre|rock'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "I was first using OneHotEncoder for \"Track_release_date\", \"Track_pop\", and \"Artist_pop,\" but I found no difference in the final result other than high memory usage."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\" ohe = OneHotEncoder(handle_unknown='ignore')\\ndummies = pd.DataFrame(ohe.fit_transform(test[['Track_release_date', 'Track_pop', 'Artist_pop']]).toarray(), index=test.index,dtype=int)\\ncolumn_name = ohe.get_feature_names_out(['Track_release_date', 'Track_pop', 'Artist_pop'])\\ndummies.columns=column_name\\ntest = pd.concat([test.drop(['Track_release_date', 'Track_pop', 'Artist_pop'], axis=1), dummies], axis=1) \""
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\"\"\" ohe = OneHotEncoder(handle_unknown='ignore')\n",
    "dummies = pd.DataFrame(ohe.fit_transform(test[['Track_release_date', 'Track_pop', 'Artist_pop']]).toarray(), index=test.index,dtype=int)\n",
    "column_name = ohe.get_feature_names_out(['Track_release_date', 'Track_pop', 'Artist_pop'])\n",
    "dummies.columns=column_name\n",
    "test = pd.concat([test.drop(['Track_release_date', 'Track_pop', 'Artist_pop'], axis=1), dummies], axis=1) \"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\" ohe2 = OneHotEncoder(categories=ohe.categories_,handle_unknown='ignore')\\ndummies = pd.DataFrame(ohe2.fit_transform(df[['Track_release_date', 'Track_pop', 'Artist_pop']]).toarray(), index=df.index, dtype=int)\\ncolumn_name = ohe2.get_feature_names_out(['Track_release_date', 'Track_pop', 'Artist_pop'])\\ndummies.columns=column_name\\ndf=pd.concat([df.drop(['Track_release_date', 'Track_pop', 'Artist_pop'], axis=1), dummies], axis=1)\\n \""
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\"\"\" ohe2 = OneHotEncoder(categories=ohe.categories_,handle_unknown='ignore')\n",
    "dummies = pd.DataFrame(ohe2.fit_transform(df[['Track_release_date', 'Track_pop', 'Artist_pop']]).toarray(), index=df.index, dtype=int)\n",
    "column_name = ohe2.get_feature_names_out(['Track_release_date', 'Track_pop', 'Artist_pop'])\n",
    "dummies.columns=column_name\n",
    "df=pd.concat([df.drop(['Track_release_date', 'Track_pop', 'Artist_pop'], axis=1), dummies], axis=1)\n",
    " \"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "#df.info(memory_usage = \"deep\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "#test.loc[:,test.columns.str.startswith('genre')]=test.loc[:,test.columns.str.startswith('genre')].astype('bool')\n",
    "#df.loc[:,df.columns.str.startswith('genre')]=df.loc[:,df.columns.str.startswith('genre')].astype('bool')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "sc=MinMaxScaler()\n",
    "df.iloc[:,3:19]=sc.fit_transform(df.iloc[:,3:19])\n",
    "pickle.dump(sc, open('data/sc.sav', 'wb'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "test.iloc[:,3:19]=sc.transform(test.iloc[:,3:19])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>track_uri</th>\n",
       "      <th>artist_uri</th>\n",
       "      <th>album_uri</th>\n",
       "      <th>danceability</th>\n",
       "      <th>energy</th>\n",
       "      <th>key</th>\n",
       "      <th>loudness</th>\n",
       "      <th>mode</th>\n",
       "      <th>speechiness</th>\n",
       "      <th>acousticness</th>\n",
       "      <th>...</th>\n",
       "      <th>valence</th>\n",
       "      <th>tempo</th>\n",
       "      <th>duration_ms</th>\n",
       "      <th>time_signature</th>\n",
       "      <th>Track_release_date</th>\n",
       "      <th>Track_pop</th>\n",
       "      <th>Artist_pop</th>\n",
       "      <th>genre|modern_rock</th>\n",
       "      <th>genre|permanent_wave</th>\n",
       "      <th>genre|rock</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2AT8iROs4FQueDv2c8q2KE69uxyAqqPIsUyTO8txoP2M37...</td>\n",
       "      <td>7Ln80lUS6He07XvHI8qqHH4gzpq5DPGxSnKTe4SA8HAU58...</td>\n",
       "      <td>78bpIziExqiI9qztvNFlQu3cfAM8b8KqJRoIzt3zLKqw0k...</td>\n",
       "      <td>44.138238</td>\n",
       "      <td>66.62793</td>\n",
       "      <td>36.363637</td>\n",
       "      <td>66.575184</td>\n",
       "      <td>57.0</td>\n",
       "      <td>5.761925</td>\n",
       "      <td>4.38462</td>\n",
       "      <td>...</td>\n",
       "      <td>51.553955</td>\n",
       "      <td>38.882252</td>\n",
       "      <td>2.999022</td>\n",
       "      <td>64.000001</td>\n",
       "      <td>78.950001</td>\n",
       "      <td>67.777777</td>\n",
       "      <td>56.650001</td>\n",
       "      <td>16.453125</td>\n",
       "      <td>17.1875</td>\n",
       "      <td>43.09375</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           track_uri  \\\n",
       "0  2AT8iROs4FQueDv2c8q2KE69uxyAqqPIsUyTO8txoP2M37...   \n",
       "\n",
       "                                          artist_uri  \\\n",
       "0  7Ln80lUS6He07XvHI8qqHH4gzpq5DPGxSnKTe4SA8HAU58...   \n",
       "\n",
       "                                           album_uri danceability    energy  \\\n",
       "0  78bpIziExqiI9qztvNFlQu3cfAM8b8KqJRoIzt3zLKqw0k...    44.138238  66.62793   \n",
       "\n",
       "         key   loudness  mode speechiness acousticness  ...    valence  \\\n",
       "0  36.363637  66.575184  57.0    5.761925      4.38462  ...  51.553955   \n",
       "\n",
       "       tempo duration_ms time_signature Track_release_date  Track_pop  \\\n",
       "0  38.882252    2.999022      64.000001          78.950001  67.777777   \n",
       "\n",
       "  Artist_pop genre|modern_rock genre|permanent_wave genre|rock  \n",
       "0  56.650001         16.453125              17.1875   43.09375  \n",
       "\n",
       "[1 rows x 22 columns]"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "playvec=pd.DataFrame(test.sum(axis=0)).T\n",
    "playvec"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>track_name</th>\n",
       "      <th>artist_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Don't Stop Me Now - Remastered 2011</td>\n",
       "      <td>Queen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Another One Bites The Dust - Remastered 2011</td>\n",
       "      <td>Queen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>It's My Life</td>\n",
       "      <td>Bon Jovi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3</td>\n",
       "      <td>Can You Feel My Heart</td>\n",
       "      <td>Bring Me The Horizon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4</td>\n",
       "      <td>Sweet Child O' Mine</td>\n",
       "      <td>Guns N' Roses</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5</td>\n",
       "      <td>Welcome To The Jungle</td>\n",
       "      <td>Guns N' Roses</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6</td>\n",
       "      <td>Highway to Hell</td>\n",
       "      <td>AC/DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7</td>\n",
       "      <td>Can't Help Falling in Love</td>\n",
       "      <td>Elvis Presley</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>8</td>\n",
       "      <td>Have You Ever Seen The Rain</td>\n",
       "      <td>Creedence Clearwater Revival</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9</td>\n",
       "      <td>Fortunate Son</td>\n",
       "      <td>Creedence Clearwater Revival</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10</td>\n",
       "      <td>Dreams - 2004 Remaster</td>\n",
       "      <td>Fleetwood Mac</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11</td>\n",
       "      <td>Dream On</td>\n",
       "      <td>Aerosmith</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12</td>\n",
       "      <td>Change (In the House of Flies)</td>\n",
       "      <td>Deftones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>13</td>\n",
       "      <td>Under Pressure - Remastered 2011</td>\n",
       "      <td>Queen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>14</td>\n",
       "      <td>Crazy Little Thing Called Love - Remastered 2011</td>\n",
       "      <td>Queen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>15</td>\n",
       "      <td>We Will Rock You - Remastered 2011</td>\n",
       "      <td>Queen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>16</td>\n",
       "      <td>T.N.T.</td>\n",
       "      <td>AC/DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17</td>\n",
       "      <td>Suspicious Minds</td>\n",
       "      <td>Elvis Presley</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>18</td>\n",
       "      <td>Paradise City</td>\n",
       "      <td>Guns N' Roses</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>19</td>\n",
       "      <td>Hotel California - 2013 Remaster</td>\n",
       "      <td>Eagles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20</td>\n",
       "      <td>Africa</td>\n",
       "      <td>TOTO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>21</td>\n",
       "      <td>Go Your Own Way - 2004 Remaster</td>\n",
       "      <td>Fleetwood Mac</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>22</td>\n",
       "      <td>We Didn't Start the Fire</td>\n",
       "      <td>Billy Joel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>23</td>\n",
       "      <td>Uptown Girl</td>\n",
       "      <td>Billy Joel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>24</td>\n",
       "      <td>Take It Easy - 2013 Remaster</td>\n",
       "      <td>Eagles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>25</td>\n",
       "      <td>Freak On a Leash</td>\n",
       "      <td>Korn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>26</td>\n",
       "      <td>Everywhere - 2017 Remaster</td>\n",
       "      <td>Fleetwood Mac</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>27</td>\n",
       "      <td>My Own Summer (Shove It)</td>\n",
       "      <td>Deftones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>28</td>\n",
       "      <td>Another Brick in the Wall, Pt. 2</td>\n",
       "      <td>Pink Floyd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>29</td>\n",
       "      <td>Crazy</td>\n",
       "      <td>Aerosmith</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>30</td>\n",
       "      <td>Vienna</td>\n",
       "      <td>Billy Joel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>31</td>\n",
       "      <td>Be Quiet and Drive (Far Away)</td>\n",
       "      <td>Deftones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>32</td>\n",
       "      <td>Wish You Were Here</td>\n",
       "      <td>Pink Floyd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>33</td>\n",
       "      <td>Stairway to Heaven - Remaster</td>\n",
       "      <td>Led Zeppelin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>34</td>\n",
       "      <td>Landslide</td>\n",
       "      <td>Fleetwood Mac</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>35</td>\n",
       "      <td>Rock N Roll Train</td>\n",
       "      <td>AC/DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>36</td>\n",
       "      <td>The Rock Show</td>\n",
       "      <td>blink-182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>37</td>\n",
       "      <td>I Miss You</td>\n",
       "      <td>blink-182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>38</td>\n",
       "      <td>Bulls On Parade</td>\n",
       "      <td>Rage Against The Machine</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>39</td>\n",
       "      <td>Man in the Box</td>\n",
       "      <td>Alice In Chains</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40</td>\n",
       "      <td>Brown Eyed Girl</td>\n",
       "      <td>Van Morrison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>41</td>\n",
       "      <td>You Make My Dreams (Come True)</td>\n",
       "      <td>Daryl Hall &amp; John Oates</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>42</td>\n",
       "      <td>Free Bird</td>\n",
       "      <td>Lynyrd Skynyrd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>43</td>\n",
       "      <td>Hold the Line</td>\n",
       "      <td>TOTO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>44</td>\n",
       "      <td>Mrs. Robinson - From \"The Graduate\" Soundtrack</td>\n",
       "      <td>Simon &amp; Garfunkel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>45</td>\n",
       "      <td>Stand by Me</td>\n",
       "      <td>Ben E. King</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>46</td>\n",
       "      <td>Sweet Dreams (Are Made of This) - Remastered</td>\n",
       "      <td>Eurythmics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>47</td>\n",
       "      <td>Cherry Waves</td>\n",
       "      <td>Deftones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>48</td>\n",
       "      <td>Rosemary</td>\n",
       "      <td>Deftones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>49</td>\n",
       "      <td>It's a Long Way to the Top (If You Wanna Rock ...</td>\n",
       "      <td>AC/DC</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    0                                         track_name  \\\n",
       "0   0                Don't Stop Me Now - Remastered 2011   \n",
       "0   1       Another One Bites The Dust - Remastered 2011   \n",
       "0   2                                       It's My Life   \n",
       "0   3                              Can You Feel My Heart   \n",
       "0   4                                Sweet Child O' Mine   \n",
       "0   5                              Welcome To The Jungle   \n",
       "0   6                                    Highway to Hell   \n",
       "0   7                         Can't Help Falling in Love   \n",
       "0   8                        Have You Ever Seen The Rain   \n",
       "0   9                                      Fortunate Son   \n",
       "0  10                             Dreams - 2004 Remaster   \n",
       "0  11                                           Dream On   \n",
       "0  12                     Change (In the House of Flies)   \n",
       "0  13                   Under Pressure - Remastered 2011   \n",
       "0  14   Crazy Little Thing Called Love - Remastered 2011   \n",
       "0  15                 We Will Rock You - Remastered 2011   \n",
       "0  16                                             T.N.T.   \n",
       "0  17                                   Suspicious Minds   \n",
       "0  18                                      Paradise City   \n",
       "0  19                   Hotel California - 2013 Remaster   \n",
       "0  20                                             Africa   \n",
       "0  21                    Go Your Own Way - 2004 Remaster   \n",
       "0  22                           We Didn't Start the Fire   \n",
       "0  23                                        Uptown Girl   \n",
       "0  24                       Take It Easy - 2013 Remaster   \n",
       "0  25                                   Freak On a Leash   \n",
       "0  26                         Everywhere - 2017 Remaster   \n",
       "0  27                           My Own Summer (Shove It)   \n",
       "0  28                   Another Brick in the Wall, Pt. 2   \n",
       "0  29                                              Crazy   \n",
       "0  30                                             Vienna   \n",
       "0  31                      Be Quiet and Drive (Far Away)   \n",
       "0  32                                 Wish You Were Here   \n",
       "0  33                      Stairway to Heaven - Remaster   \n",
       "0  34                                          Landslide   \n",
       "0  35                                  Rock N Roll Train   \n",
       "0  36                                      The Rock Show   \n",
       "0  37                                         I Miss You   \n",
       "0  38                                    Bulls On Parade   \n",
       "0  39                                     Man in the Box   \n",
       "0  40                                    Brown Eyed Girl   \n",
       "0  41                     You Make My Dreams (Come True)   \n",
       "0  42                                          Free Bird   \n",
       "0  43                                      Hold the Line   \n",
       "0  44     Mrs. Robinson - From \"The Graduate\" Soundtrack   \n",
       "0  45                                        Stand by Me   \n",
       "0  46       Sweet Dreams (Are Made of This) - Remastered   \n",
       "0  47                                       Cherry Waves   \n",
       "0  48                                           Rosemary   \n",
       "0  49  It's a Long Way to the Top (If You Wanna Rock ...   \n",
       "\n",
       "                    artist_name  \n",
       "0                         Queen  \n",
       "0                         Queen  \n",
       "0                      Bon Jovi  \n",
       "0          Bring Me The Horizon  \n",
       "0                 Guns N' Roses  \n",
       "0                 Guns N' Roses  \n",
       "0                         AC/DC  \n",
       "0                 Elvis Presley  \n",
       "0  Creedence Clearwater Revival  \n",
       "0  Creedence Clearwater Revival  \n",
       "0                 Fleetwood Mac  \n",
       "0                     Aerosmith  \n",
       "0                      Deftones  \n",
       "0                         Queen  \n",
       "0                         Queen  \n",
       "0                         Queen  \n",
       "0                         AC/DC  \n",
       "0                 Elvis Presley  \n",
       "0                 Guns N' Roses  \n",
       "0                        Eagles  \n",
       "0                          TOTO  \n",
       "0                 Fleetwood Mac  \n",
       "0                    Billy Joel  \n",
       "0                    Billy Joel  \n",
       "0                        Eagles  \n",
       "0                          Korn  \n",
       "0                 Fleetwood Mac  \n",
       "0                      Deftones  \n",
       "0                    Pink Floyd  \n",
       "0                     Aerosmith  \n",
       "0                    Billy Joel  \n",
       "0                      Deftones  \n",
       "0                    Pink Floyd  \n",
       "0                  Led Zeppelin  \n",
       "0                 Fleetwood Mac  \n",
       "0                         AC/DC  \n",
       "0                     blink-182  \n",
       "0                     blink-182  \n",
       "0      Rage Against The Machine  \n",
       "0               Alice In Chains  \n",
       "0                  Van Morrison  \n",
       "0       Daryl Hall & John Oates  \n",
       "0                Lynyrd Skynyrd  \n",
       "0                          TOTO  \n",
       "0             Simon & Garfunkel  \n",
       "0                   Ben E. King  \n",
       "0                    Eurythmics  \n",
       "0                      Deftones  \n",
       "0                      Deftones  \n",
       "0                         AC/DC  "
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['sim']=cosine_similarity(df.drop(['track_uri', 'artist_uri', 'album_uri'], axis = 1),playvec.drop(['track_uri', 'artist_uri', 'album_uri'], axis = 1))\n",
    "df['sim2']=cosine_similarity(df.iloc[:,16:-1],playvec.iloc[:,16:])\n",
    "df['sim3']=cosine_similarity(df.iloc[:,19:-2],playvec.iloc[:,19:])\n",
    "df = df.sort_values(['sim3','sim2','sim'],ascending = False,kind='stable')\n",
    "qq=df.groupby('artist_uri').head(5).track_uri.head(50)     #to limit recmmendation by same artist\n",
    "aa=sp.tracks(qq[0:50])\n",
    "Fresult=pd.DataFrame()\n",
    "for i in range(50):\n",
    "    result=pd.DataFrame([i])\n",
    "    result['track_name']=aa['tracks'][i]['name']\n",
    "    result['artist_name']=aa['tracks'][i]['artists'][0]['name']\n",
    "    #result['url']=aa['tracks'][i]['external_urls']['spotify']\n",
    "    #result['image']=aa['tracks'][i]['album']['images'][1]['url']\n",
    "    Fresult=pd.concat([Fresult,result],axis=0)\n",
    "Fresult"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>track_name</th>\n",
       "      <th>artist_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Go Your Own Way - 2004 Remaster</td>\n",
       "      <td>Fleetwood Mac</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>We Didn't Start the Fire</td>\n",
       "      <td>Billy Joel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>Gimme All Your Lovin'</td>\n",
       "      <td>ZZ Top</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3</td>\n",
       "      <td>Thorn in My Side - Remastered</td>\n",
       "      <td>Eurythmics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4</td>\n",
       "      <td>Any Way You Want It</td>\n",
       "      <td>Journey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5</td>\n",
       "      <td>I Don't Wanna Stop</td>\n",
       "      <td>Ozzy Osbourne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6</td>\n",
       "      <td>Semi-Charmed Life</td>\n",
       "      <td>Third Eye Blind</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7</td>\n",
       "      <td>Sweet Child O' Mine</td>\n",
       "      <td>Guns N' Roses</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>8</td>\n",
       "      <td>Old Time Rock &amp; Roll</td>\n",
       "      <td>Bob Seger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9</td>\n",
       "      <td>Lump</td>\n",
       "      <td>The Presidents Of The United States Of America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10</td>\n",
       "      <td>Run-Around</td>\n",
       "      <td>Blues Traveler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11</td>\n",
       "      <td>Kyouran Hey Kids!!</td>\n",
       "      <td>THE ORAL CIGARETTES</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12</td>\n",
       "      <td>We're Not Gonna Take It</td>\n",
       "      <td>Twisted Sister</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>13</td>\n",
       "      <td>Legs - 2008 Remaster</td>\n",
       "      <td>ZZ Top</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>14</td>\n",
       "      <td>Highway Tune</td>\n",
       "      <td>Greta Van Fleet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>15</td>\n",
       "      <td>Sharp Dressed Man - 2008 Remaster</td>\n",
       "      <td>ZZ Top</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>16</td>\n",
       "      <td>Owner of a Lonely Heart</td>\n",
       "      <td>Yes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17</td>\n",
       "      <td>Mighty Wings - From \"Top Gun\" Original Soundtrack</td>\n",
       "      <td>Cheap Trick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>18</td>\n",
       "      <td>Living After Midnight</td>\n",
       "      <td>Judas Priest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>19</td>\n",
       "      <td>I Believe in a Thing Called Love</td>\n",
       "      <td>The Darkness</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20</td>\n",
       "      <td>Dance the Night Away - 2015 Remaster</td>\n",
       "      <td>Van Halen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>21</td>\n",
       "      <td>Pink Houses</td>\n",
       "      <td>John Mellencamp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>22</td>\n",
       "      <td>How I Could Just Kill a Man</td>\n",
       "      <td>Rage Against The Machine</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>23</td>\n",
       "      <td>Stiff Upper Lip</td>\n",
       "      <td>AC/DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>24</td>\n",
       "      <td>More Than This</td>\n",
       "      <td>Roxy Music</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>25</td>\n",
       "      <td>Black Smoke Rising</td>\n",
       "      <td>Greta Van Fleet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>26</td>\n",
       "      <td>We're An American Band - Remastered 2002</td>\n",
       "      <td>Grand Funk Railroad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>27</td>\n",
       "      <td>Never Let You Go - 2008 Remaster</td>\n",
       "      <td>Third Eye Blind</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>28</td>\n",
       "      <td>White Wedding - Pt. 1</td>\n",
       "      <td>Billy Idol</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>29</td>\n",
       "      <td>Hey Tonight</td>\n",
       "      <td>Creedence Clearwater Revival</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>30</td>\n",
       "      <td>Shot in the Dark</td>\n",
       "      <td>Ozzy Osbourne</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>31</td>\n",
       "      <td>Rock And Roll Never Forgets</td>\n",
       "      <td>Bob Seger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>32</td>\n",
       "      <td>Peace of Mind</td>\n",
       "      <td>Boston</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>33</td>\n",
       "      <td>Carry on Wayward Son</td>\n",
       "      <td>Kansas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>34</td>\n",
       "      <td>Hollywood Nights</td>\n",
       "      <td>Bob Seger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>35</td>\n",
       "      <td>Against The Wind</td>\n",
       "      <td>Bob Seger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>36</td>\n",
       "      <td>Bad Medicine</td>\n",
       "      <td>Bon Jovi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>37</td>\n",
       "      <td>Have A Nice Day</td>\n",
       "      <td>Bon Jovi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>38</td>\n",
       "      <td>Touch Too Much</td>\n",
       "      <td>AC/DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>39</td>\n",
       "      <td>Come Undone</td>\n",
       "      <td>Duran Duran</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40</td>\n",
       "      <td>All I Wanna Do Is Make Love To You</td>\n",
       "      <td>Heart</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>41</td>\n",
       "      <td>No Excuses</td>\n",
       "      <td>Alice In Chains</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>42</td>\n",
       "      <td>Walk This Way</td>\n",
       "      <td>Aerosmith</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>43</td>\n",
       "      <td>Two Princes</td>\n",
       "      <td>Spin Doctors</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>44</td>\n",
       "      <td>Girls on Film - 2010 Remaster</td>\n",
       "      <td>Duran Duran</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>45</td>\n",
       "      <td>Jamie's Cryin' - 2015 Remaster</td>\n",
       "      <td>Van Halen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>46</td>\n",
       "      <td>Who Says You Can't Go Home</td>\n",
       "      <td>Bon Jovi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>47</td>\n",
       "      <td>Anna Molly</td>\n",
       "      <td>Incubus</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>48</td>\n",
       "      <td>Ace of Spades</td>\n",
       "      <td>Motörhead</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>49</td>\n",
       "      <td>Fallen Angel - Remastered</td>\n",
       "      <td>Poison</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    0                                         track_name  \\\n",
       "0   0                    Go Your Own Way - 2004 Remaster   \n",
       "0   1                           We Didn't Start the Fire   \n",
       "0   2                              Gimme All Your Lovin'   \n",
       "0   3                      Thorn in My Side - Remastered   \n",
       "0   4                                Any Way You Want It   \n",
       "0   5                                 I Don't Wanna Stop   \n",
       "0   6                                  Semi-Charmed Life   \n",
       "0   7                                Sweet Child O' Mine   \n",
       "0   8                               Old Time Rock & Roll   \n",
       "0   9                                               Lump   \n",
       "0  10                                         Run-Around   \n",
       "0  11                                 Kyouran Hey Kids!!   \n",
       "0  12                            We're Not Gonna Take It   \n",
       "0  13                               Legs - 2008 Remaster   \n",
       "0  14                                       Highway Tune   \n",
       "0  15                  Sharp Dressed Man - 2008 Remaster   \n",
       "0  16                            Owner of a Lonely Heart   \n",
       "0  17  Mighty Wings - From \"Top Gun\" Original Soundtrack   \n",
       "0  18                              Living After Midnight   \n",
       "0  19                   I Believe in a Thing Called Love   \n",
       "0  20               Dance the Night Away - 2015 Remaster   \n",
       "0  21                                        Pink Houses   \n",
       "0  22                        How I Could Just Kill a Man   \n",
       "0  23                                    Stiff Upper Lip   \n",
       "0  24                                     More Than This   \n",
       "0  25                                 Black Smoke Rising   \n",
       "0  26           We're An American Band - Remastered 2002   \n",
       "0  27                   Never Let You Go - 2008 Remaster   \n",
       "0  28                              White Wedding - Pt. 1   \n",
       "0  29                                        Hey Tonight   \n",
       "0  30                                   Shot in the Dark   \n",
       "0  31                        Rock And Roll Never Forgets   \n",
       "0  32                                      Peace of Mind   \n",
       "0  33                               Carry on Wayward Son   \n",
       "0  34                                   Hollywood Nights   \n",
       "0  35                                   Against The Wind   \n",
       "0  36                                       Bad Medicine   \n",
       "0  37                                    Have A Nice Day   \n",
       "0  38                                     Touch Too Much   \n",
       "0  39                                        Come Undone   \n",
       "0  40                 All I Wanna Do Is Make Love To You   \n",
       "0  41                                         No Excuses   \n",
       "0  42                                      Walk This Way   \n",
       "0  43                                        Two Princes   \n",
       "0  44                      Girls on Film - 2010 Remaster   \n",
       "0  45                     Jamie's Cryin' - 2015 Remaster   \n",
       "0  46                         Who Says You Can't Go Home   \n",
       "0  47                                         Anna Molly   \n",
       "0  48                                      Ace of Spades   \n",
       "0  49                          Fallen Angel - Remastered   \n",
       "\n",
       "                                      artist_name  \n",
       "0                                   Fleetwood Mac  \n",
       "0                                      Billy Joel  \n",
       "0                                          ZZ Top  \n",
       "0                                      Eurythmics  \n",
       "0                                         Journey  \n",
       "0                                   Ozzy Osbourne  \n",
       "0                                 Third Eye Blind  \n",
       "0                                   Guns N' Roses  \n",
       "0                                       Bob Seger  \n",
       "0  The Presidents Of The United States Of America  \n",
       "0                                  Blues Traveler  \n",
       "0                             THE ORAL CIGARETTES  \n",
       "0                                  Twisted Sister  \n",
       "0                                          ZZ Top  \n",
       "0                                 Greta Van Fleet  \n",
       "0                                          ZZ Top  \n",
       "0                                             Yes  \n",
       "0                                     Cheap Trick  \n",
       "0                                    Judas Priest  \n",
       "0                                    The Darkness  \n",
       "0                                       Van Halen  \n",
       "0                                 John Mellencamp  \n",
       "0                        Rage Against The Machine  \n",
       "0                                           AC/DC  \n",
       "0                                      Roxy Music  \n",
       "0                                 Greta Van Fleet  \n",
       "0                             Grand Funk Railroad  \n",
       "0                                 Third Eye Blind  \n",
       "0                                      Billy Idol  \n",
       "0                    Creedence Clearwater Revival  \n",
       "0                                   Ozzy Osbourne  \n",
       "0                                       Bob Seger  \n",
       "0                                          Boston  \n",
       "0                                          Kansas  \n",
       "0                                       Bob Seger  \n",
       "0                                       Bob Seger  \n",
       "0                                        Bon Jovi  \n",
       "0                                        Bon Jovi  \n",
       "0                                           AC/DC  \n",
       "0                                     Duran Duran  \n",
       "0                                           Heart  \n",
       "0                                 Alice In Chains  \n",
       "0                                       Aerosmith  \n",
       "0                                    Spin Doctors  \n",
       "0                                     Duran Duran  \n",
       "0                                       Van Halen  \n",
       "0                                        Bon Jovi  \n",
       "0                                         Incubus  \n",
       "0                                       Motörhead  \n",
       "0                                          Poison  "
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['sim']=cosine_similarity(df.iloc[:,3:16],playvec.iloc[:,3:16])\n",
    "df['sim2']=cosine_similarity(df.loc[:, df.columns.str.startswith('T')|df.columns.str.startswith('A')],playvec.loc[:, playvec.columns.str.startswith('T')|playvec.columns.str.startswith('A')])\n",
    "df['sim3']=cosine_similarity(df.loc[:, df.columns.str.startswith('genre')],playvec.loc[:, playvec.columns.str.startswith('genre')])\n",
    "df['sim4']=(df['sim']+df['sim2']+df['sim3'])/3\n",
    "df = df.sort_values(['sim4'],ascending = False,kind='stable')\n",
    "# genra>audio>pop\n",
    "qq=df.groupby('artist_uri').head(5).track_uri.head(50)\n",
    "aa=sp.tracks(qq[0:50])\n",
    "Fresult=pd.DataFrame()\n",
    "for i in range(50):\n",
    "    result=pd.DataFrame([i])\n",
    "    result['track_name']=aa['tracks'][i]['name']\n",
    "    result['artist_name']=aa['tracks'][i]['artists'][0]['name']\n",
    "    #result['url']=aa['tracks'][i]['external_urls']['spotify']\n",
    "    #result['image']=aa['tracks'][i]['album']['images'][1]['url']\n",
    "    Fresult=pd.concat([Fresult,result],axis=0)\n",
    "Fresult"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>track_name</th>\n",
       "      <th>artist_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>R.O.C.K. In The U.S.A. (A Salute To 60's Rock)</td>\n",
       "      <td>John Mellencamp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>Blood On Blood</td>\n",
       "      <td>Bon Jovi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3</td>\n",
       "      <td>T.N.T.</td>\n",
       "      <td>AC/DC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4</td>\n",
       "      <td>Warning</td>\n",
       "      <td>Green Day</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5</td>\n",
       "      <td>Turn The Page</td>\n",
       "      <td>Metallica</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6</td>\n",
       "      <td>Forever Now</td>\n",
       "      <td>Green Day</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7</td>\n",
       "      <td>Duality</td>\n",
       "      <td>Slipknot</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>8</td>\n",
       "      <td>Lit Up</td>\n",
       "      <td>Buckcherry</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9</td>\n",
       "      <td>Plug in Baby</td>\n",
       "      <td>Muse</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10</td>\n",
       "      <td>Wheel in the Sky</td>\n",
       "      <td>Journey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11</td>\n",
       "      <td>Start Me Up - Remastered 2009</td>\n",
       "      <td>The Rolling Stones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12</td>\n",
       "      <td>I Was Made For Lovin' You</td>\n",
       "      <td>KISS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>13</td>\n",
       "      <td>Since You've Been Gone</td>\n",
       "      <td>The Outfield</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>14</td>\n",
       "      <td>ERA</td>\n",
       "      <td>The Faim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>15</td>\n",
       "      <td>King Of Wishful Thinking</td>\n",
       "      <td>New Found Glory</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>16</td>\n",
       "      <td>PMA (feat. Pale Waves)</td>\n",
       "      <td>All Time Low</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17</td>\n",
       "      <td>Re-Education (Through Labor)</td>\n",
       "      <td>Rise Against</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>18</td>\n",
       "      <td>Situations</td>\n",
       "      <td>Escape the Fate</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>19</td>\n",
       "      <td>Lost</td>\n",
       "      <td>Charlotte Sands</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20</td>\n",
       "      <td>Way Away</td>\n",
       "      <td>Yellowcard</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>21</td>\n",
       "      <td>Way Away</td>\n",
       "      <td>Yellowcard</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>22</td>\n",
       "      <td>Can't Fight This Feeling</td>\n",
       "      <td>REO Speedwagon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>23</td>\n",
       "      <td>Rock America</td>\n",
       "      <td>Danger Danger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>24</td>\n",
       "      <td>Until the Day I Die</td>\n",
       "      <td>Story Of The Year</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>25</td>\n",
       "      <td>Where Is My Mind? - Remastered</td>\n",
       "      <td>Pixies</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>26</td>\n",
       "      <td>You Don't Mess Around with Jim</td>\n",
       "      <td>Jim Croce</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>27</td>\n",
       "      <td>Maneater</td>\n",
       "      <td>Daryl Hall &amp; John Oates</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>28</td>\n",
       "      <td>The Price</td>\n",
       "      <td>Twisted Sister</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>29</td>\n",
       "      <td>Heartbreaker - 1990 Remaster</td>\n",
       "      <td>Led Zeppelin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>30</td>\n",
       "      <td>The Hardest Button to Button</td>\n",
       "      <td>The White Stripes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>31</td>\n",
       "      <td>Ain't Talkin' 'Bout Love - 2015 Remaster</td>\n",
       "      <td>Van Halen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>32</td>\n",
       "      <td>Where Is My Mind? - Remastered</td>\n",
       "      <td>Pixies</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>33</td>\n",
       "      <td>All Systems Go</td>\n",
       "      <td>Box Car Racer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>34</td>\n",
       "      <td>May 16</td>\n",
       "      <td>Lagwagon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>35</td>\n",
       "      <td>Creepin Up The Backstairs - Composite Edit (do...</td>\n",
       "      <td>The Fratellis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>36</td>\n",
       "      <td>Animal</td>\n",
       "      <td>Neon Trees</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>37</td>\n",
       "      <td>Watch The World</td>\n",
       "      <td>Box Car Racer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>38</td>\n",
       "      <td>All My Fault</td>\n",
       "      <td>Fenix TX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>39</td>\n",
       "      <td>Pork And Beans</td>\n",
       "      <td>Weezer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>40</td>\n",
       "      <td>Mixtape 2003</td>\n",
       "      <td>The Academic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>41</td>\n",
       "      <td>1+1</td>\n",
       "      <td>Scouting For Girls</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>42</td>\n",
       "      <td>Be Still</td>\n",
       "      <td>The Killers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>43</td>\n",
       "      <td>Only The Horses</td>\n",
       "      <td>Scissor Sisters</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>44</td>\n",
       "      <td>Mardy Bum</td>\n",
       "      <td>Arctic Monkeys</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>45</td>\n",
       "      <td>Blue Orchid</td>\n",
       "      <td>The White Stripes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>46</td>\n",
       "      <td>Holy Wars...The Punishment Due - Remastered</td>\n",
       "      <td>Megadeth</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>47</td>\n",
       "      <td>Lucifer Sam</td>\n",
       "      <td>Pink Floyd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>48</td>\n",
       "      <td>What Is and What Should Never Be - 29/6/69 Top...</td>\n",
       "      <td>Led Zeppelin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>49</td>\n",
       "      <td>Peace of Mind</td>\n",
       "      <td>Boston</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>50</td>\n",
       "      <td>Alive</td>\n",
       "      <td>Pearl Jam</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    0                                         track_name  \\\n",
       "0   1     R.O.C.K. In The U.S.A. (A Salute To 60's Rock)   \n",
       "0   2                                     Blood On Blood   \n",
       "0   3                                             T.N.T.   \n",
       "0   4                                            Warning   \n",
       "0   5                                      Turn The Page   \n",
       "0   6                                        Forever Now   \n",
       "0   7                                            Duality   \n",
       "0   8                                             Lit Up   \n",
       "0   9                                       Plug in Baby   \n",
       "0  10                                   Wheel in the Sky   \n",
       "0  11                      Start Me Up - Remastered 2009   \n",
       "0  12                          I Was Made For Lovin' You   \n",
       "0  13                             Since You've Been Gone   \n",
       "0  14                                                ERA   \n",
       "0  15                           King Of Wishful Thinking   \n",
       "0  16                             PMA (feat. Pale Waves)   \n",
       "0  17                       Re-Education (Through Labor)   \n",
       "0  18                                         Situations   \n",
       "0  19                                               Lost   \n",
       "0  20                                           Way Away   \n",
       "0  21                                           Way Away   \n",
       "0  22                           Can't Fight This Feeling   \n",
       "0  23                                       Rock America   \n",
       "0  24                                Until the Day I Die   \n",
       "0  25                     Where Is My Mind? - Remastered   \n",
       "0  26                     You Don't Mess Around with Jim   \n",
       "0  27                                           Maneater   \n",
       "0  28                                          The Price   \n",
       "0  29                       Heartbreaker - 1990 Remaster   \n",
       "0  30                       The Hardest Button to Button   \n",
       "0  31           Ain't Talkin' 'Bout Love - 2015 Remaster   \n",
       "0  32                     Where Is My Mind? - Remastered   \n",
       "0  33                                     All Systems Go   \n",
       "0  34                                             May 16   \n",
       "0  35  Creepin Up The Backstairs - Composite Edit (do...   \n",
       "0  36                                             Animal   \n",
       "0  37                                    Watch The World   \n",
       "0  38                                       All My Fault   \n",
       "0  39                                     Pork And Beans   \n",
       "0  40                                       Mixtape 2003   \n",
       "0  41                                                1+1   \n",
       "0  42                                           Be Still   \n",
       "0  43                                    Only The Horses   \n",
       "0  44                                          Mardy Bum   \n",
       "0  45                                        Blue Orchid   \n",
       "0  46        Holy Wars...The Punishment Due - Remastered   \n",
       "0  47                                        Lucifer Sam   \n",
       "0  48  What Is and What Should Never Be - 29/6/69 Top...   \n",
       "0  49                                      Peace of Mind   \n",
       "0  50                                              Alive   \n",
       "\n",
       "               artist_name  \n",
       "0          John Mellencamp  \n",
       "0                 Bon Jovi  \n",
       "0                    AC/DC  \n",
       "0                Green Day  \n",
       "0                Metallica  \n",
       "0                Green Day  \n",
       "0                 Slipknot  \n",
       "0               Buckcherry  \n",
       "0                     Muse  \n",
       "0                  Journey  \n",
       "0       The Rolling Stones  \n",
       "0                     KISS  \n",
       "0             The Outfield  \n",
       "0                 The Faim  \n",
       "0          New Found Glory  \n",
       "0             All Time Low  \n",
       "0             Rise Against  \n",
       "0          Escape the Fate  \n",
       "0          Charlotte Sands  \n",
       "0               Yellowcard  \n",
       "0               Yellowcard  \n",
       "0           REO Speedwagon  \n",
       "0            Danger Danger  \n",
       "0        Story Of The Year  \n",
       "0                   Pixies  \n",
       "0                Jim Croce  \n",
       "0  Daryl Hall & John Oates  \n",
       "0           Twisted Sister  \n",
       "0             Led Zeppelin  \n",
       "0        The White Stripes  \n",
       "0                Van Halen  \n",
       "0                   Pixies  \n",
       "0            Box Car Racer  \n",
       "0                 Lagwagon  \n",
       "0            The Fratellis  \n",
       "0               Neon Trees  \n",
       "0            Box Car Racer  \n",
       "0                 Fenix TX  \n",
       "0                   Weezer  \n",
       "0             The Academic  \n",
       "0       Scouting For Girls  \n",
       "0              The Killers  \n",
       "0          Scissor Sisters  \n",
       "0           Arctic Monkeys  \n",
       "0        The White Stripes  \n",
       "0                 Megadeth  \n",
       "0               Pink Floyd  \n",
       "0             Led Zeppelin  \n",
       "0                   Boston  \n",
       "0                Pearl Jam  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Spotifyresult=pd.DataFrame()\n",
    "for i in range(len(test)-1):\n",
    "    if len(Spotifyresult)>=50:\n",
    "        break\n",
    "    ff=sp.recommendations(seed_tracks=list(test.track_uri[1+i:5+i]),limit=2)\n",
    "    for z in range(2):\n",
    "        result=pd.DataFrame([z+(2*i)+1])\n",
    "        result['track_name']=ff['tracks'][z]['name']\n",
    "        result['artist_name']=ff['tracks'][z]['artists'][0]['name']\n",
    "        #result['uri']=ff['tracks'][z]['id']\n",
    "        #result['url']=ff['tracks'][z]['external_urls']['spotify']\n",
    "        #result['image']=ff['tracks'][z]['album']['images'][1]['url']\n",
    "        Spotifyresult=pd.concat([Spotifyresult,result],axis=0)\n",
    "Spotifyresult"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "sorry ur playlist must have atleast 5 tracks for this method to work"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.9.13 ('base')",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "e246d2215c418239c9316a1ebf2d8abb44dc50b2e5b0e29defd87143398aa387"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}