Convert dataset into mp3.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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_id</th>\n",
       "      <th>song_id</th>\n",
       "      <th>title</th>\n",
       "      <th>preview_file</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>TRAAAAW128F429D538</td>\n",
       "      <td>SOMZWCG12A8C13C480</td>\n",
       "      <td>I Didn't Mean To - Casual</td>\n",
       "      <td>TRAAAAW128F429D538-mzm.jmksdiul.aac.p.m4a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TRAAABD128F429CF47</td>\n",
       "      <td>SOCIWDW12A8C13D406</td>\n",
       "      <td>The Letter - The Box Tops</td>\n",
       "      <td>TRAAABD128F429CF47-mzm.maejowgk.aac.p.m4a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>TRAAAEF128F4273421</td>\n",
       "      <td>SONHOTT12A8C13493C</td>\n",
       "      <td>Something Girls - Adam Ant</td>\n",
       "      <td>TRAAAEF128F4273421-mzm.wvrnqeth.aac.p.m4a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>TRAAAFD128F92F423A</td>\n",
       "      <td>SOFSOCN12A8C143F5D</td>\n",
       "      <td>Face the Ashes - Gob</td>\n",
       "      <td>TRAAAFD128F92F423A-mzaf_7872227378043099108.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>TRAABLR128F423B7E3</td>\n",
       "      <td>SOHUOAP12A8AE488E9</td>\n",
       "      <td>Floating - Blue Rodeo</td>\n",
       "      <td>TRAABLR128F423B7E3-mzi.hrspqvdo.aac.p.m4a</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             track_id             song_id                       title  \\\n",
       "0  TRAAAAW128F429D538  SOMZWCG12A8C13C480   I Didn't Mean To - Casual   \n",
       "1  TRAAABD128F429CF47  SOCIWDW12A8C13D406   The Letter - The Box Tops   \n",
       "2  TRAAAEF128F4273421  SONHOTT12A8C13493C  Something Girls - Adam Ant   \n",
       "3  TRAAAFD128F92F423A  SOFSOCN12A8C143F5D        Face the Ashes - Gob   \n",
       "4  TRAABLR128F423B7E3  SOHUOAP12A8AE488E9       Floating - Blue Rodeo   \n",
       "\n",
       "                                        preview_file  \n",
       "0          TRAAAAW128F429D538-mzm.jmksdiul.aac.p.m4a  \n",
       "1          TRAAABD128F429CF47-mzm.maejowgk.aac.p.m4a  \n",
       "2          TRAAAEF128F4273421-mzm.wvrnqeth.aac.p.m4a  \n",
       "3  TRAAAFD128F92F423A-mzaf_7872227378043099108.pl...  \n",
       "4          TRAABLR128F423B7E3-mzi.hrspqvdo.aac.p.m4a  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_file_path = 'dataset/main_song_labels.csv'\n",
    "song_dir = 'dataset/song_preview'\n",
    "song_df = pandas.read_csv(main_file_path, sep='\\t')\n",
    "song_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "converting to m4a dataset into mp3:: 2703it [1:02:42,  1.39s/it]\n"
     ]
    },
    {
     "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_id</th>\n",
       "      <th>song_id</th>\n",
       "      <th>title</th>\n",
       "      <th>preview_file</th>\n",
       "      <th>mp3_file</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>TRAAAAW128F429D538</td>\n",
       "      <td>SOMZWCG12A8C13C480</td>\n",
       "      <td>I Didn't Mean To - Casual</td>\n",
       "      <td>TRAAAAW128F429D538-mzm.jmksdiul.aac.p.m4a</td>\n",
       "      <td>dataset/song_mp3/TRAAAAW128F429D538-mzm.jmksdi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TRAAABD128F429CF47</td>\n",
       "      <td>SOCIWDW12A8C13D406</td>\n",
       "      <td>The Letter - The Box Tops</td>\n",
       "      <td>TRAAABD128F429CF47-mzm.maejowgk.aac.p.m4a</td>\n",
       "      <td>dataset/song_mp3/TRAAABD128F429CF47-mzm.maejow...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>TRAAAEF128F4273421</td>\n",
       "      <td>SONHOTT12A8C13493C</td>\n",
       "      <td>Something Girls - Adam Ant</td>\n",
       "      <td>TRAAAEF128F4273421-mzm.wvrnqeth.aac.p.m4a</td>\n",
       "      <td>dataset/song_mp3/TRAAAEF128F4273421-mzm.wvrnqe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>TRAAAFD128F92F423A</td>\n",
       "      <td>SOFSOCN12A8C143F5D</td>\n",
       "      <td>Face the Ashes - Gob</td>\n",
       "      <td>TRAAAFD128F92F423A-mzaf_7872227378043099108.pl...</td>\n",
       "      <td>dataset/song_mp3/TRAAAFD128F92F423A-mzaf_78722...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>TRAABLR128F423B7E3</td>\n",
       "      <td>SOHUOAP12A8AE488E9</td>\n",
       "      <td>Floating - Blue Rodeo</td>\n",
       "      <td>TRAABLR128F423B7E3-mzi.hrspqvdo.aac.p.m4a</td>\n",
       "      <td>dataset/song_mp3/TRAABLR128F423B7E3-mzi.hrspqv...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>TRAABNV128F425CEE1</td>\n",
       "      <td>SOUQQEA12A8C134B1B</td>\n",
       "      <td>High Tide - Richard Souther</td>\n",
       "      <td>TRAABNV128F425CEE1-mzaf_1138184835533468619.pl...</td>\n",
       "      <td>dataset/song_mp3/TRAABNV128F425CEE1-mzaf_11381...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>TRAABVM128F92CA9DC</td>\n",
       "      <td>SOXLBJT12A8C140925</td>\n",
       "      <td>Caught In a Dream - Tesla</td>\n",
       "      <td>TRAABVM128F92CA9DC-mzaf_6533586203788207814.pl...</td>\n",
       "      <td>dataset/song_mp3/TRAABVM128F92CA9DC-mzaf_65335...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>TRAACER128F4290F96</td>\n",
       "      <td>SOBBUGU12A8C13E95D</td>\n",
       "      <td>Setting Fire to Sleeping Giants - The Dillinge...</td>\n",
       "      <td>TRAACER128F4290F96-mzaf_8264859982335743323.pl...</td>\n",
       "      <td>dataset/song_mp3/TRAACER128F4290F96-mzaf_82648...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>TRAACFV128F935E50B</td>\n",
       "      <td>SOBLGCN12AB0183212</td>\n",
       "      <td>James (Hold the Ladder Steady) - Sue Thompson</td>\n",
       "      <td>TRAACFV128F935E50B-mzaf_3214719693783324092.pl...</td>\n",
       "      <td>dataset/song_mp3/TRAACFV128F935E50B-mzaf_32147...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>TRAACHN128F1489601</td>\n",
       "      <td>SOPSWQW12A6D4F8781</td>\n",
       "      <td>Made Like This (Live) - Five.Bolt.Main</td>\n",
       "      <td>TRAACHN128F1489601-mzaf_7393058876293345106.pl...</td>\n",
       "      <td>dataset/song_mp3/TRAACHN128F1489601-mzaf_73930...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             track_id             song_id  \\\n",
       "0  TRAAAAW128F429D538  SOMZWCG12A8C13C480   \n",
       "1  TRAAABD128F429CF47  SOCIWDW12A8C13D406   \n",
       "2  TRAAAEF128F4273421  SONHOTT12A8C13493C   \n",
       "3  TRAAAFD128F92F423A  SOFSOCN12A8C143F5D   \n",
       "4  TRAABLR128F423B7E3  SOHUOAP12A8AE488E9   \n",
       "5  TRAABNV128F425CEE1  SOUQQEA12A8C134B1B   \n",
       "6  TRAABVM128F92CA9DC  SOXLBJT12A8C140925   \n",
       "7  TRAACER128F4290F96  SOBBUGU12A8C13E95D   \n",
       "8  TRAACFV128F935E50B  SOBLGCN12AB0183212   \n",
       "9  TRAACHN128F1489601  SOPSWQW12A6D4F8781   \n",
       "\n",
       "                                               title  \\\n",
       "0                          I Didn't Mean To - Casual   \n",
       "1                          The Letter - The Box Tops   \n",
       "2                         Something Girls - Adam Ant   \n",
       "3                               Face the Ashes - Gob   \n",
       "4                              Floating - Blue Rodeo   \n",
       "5                        High Tide - Richard Souther   \n",
       "6                          Caught In a Dream - Tesla   \n",
       "7  Setting Fire to Sleeping Giants - The Dillinge...   \n",
       "8      James (Hold the Ladder Steady) - Sue Thompson   \n",
       "9             Made Like This (Live) - Five.Bolt.Main   \n",
       "\n",
       "                                        preview_file  \\\n",
       "0          TRAAAAW128F429D538-mzm.jmksdiul.aac.p.m4a   \n",
       "1          TRAAABD128F429CF47-mzm.maejowgk.aac.p.m4a   \n",
       "2          TRAAAEF128F4273421-mzm.wvrnqeth.aac.p.m4a   \n",
       "3  TRAAAFD128F92F423A-mzaf_7872227378043099108.pl...   \n",
       "4          TRAABLR128F423B7E3-mzi.hrspqvdo.aac.p.m4a   \n",
       "5  TRAABNV128F425CEE1-mzaf_1138184835533468619.pl...   \n",
       "6  TRAABVM128F92CA9DC-mzaf_6533586203788207814.pl...   \n",
       "7  TRAACER128F4290F96-mzaf_8264859982335743323.pl...   \n",
       "8  TRAACFV128F935E50B-mzaf_3214719693783324092.pl...   \n",
       "9  TRAACHN128F1489601-mzaf_7393058876293345106.pl...   \n",
       "\n",
       "                                            mp3_file  \n",
       "0  dataset/song_mp3/TRAAAAW128F429D538-mzm.jmksdi...  \n",
       "1  dataset/song_mp3/TRAAABD128F429CF47-mzm.maejow...  \n",
       "2  dataset/song_mp3/TRAAAEF128F4273421-mzm.wvrnqe...  \n",
       "3  dataset/song_mp3/TRAAAFD128F92F423A-mzaf_78722...  \n",
       "4  dataset/song_mp3/TRAABLR128F423B7E3-mzi.hrspqv...  \n",
       "5  dataset/song_mp3/TRAABNV128F425CEE1-mzaf_11381...  \n",
       "6  dataset/song_mp3/TRAABVM128F92CA9DC-mzaf_65335...  \n",
       "7  dataset/song_mp3/TRAACER128F4290F96-mzaf_82648...  \n",
       "8  dataset/song_mp3/TRAACFV128F935E50B-mzaf_32147...  \n",
       "9  dataset/song_mp3/TRAACHN128F1489601-mzaf_73930...  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import subprocess\n",
    "import os\n",
    "from tqdm import tqdm\n",
    "\n",
    "OUTPUT_DIR = 'dataset/song_mp3'\n",
    "song_df['mp3_file']=''\n",
    "\n",
    "for idx,row in tqdm(song_df.iterrows(), 'converting to m4a dataset into mp3:'):\n",
    "    filename = row['preview_file']\n",
    "    output = os.path.join(OUTPUT_DIR, '%s.mp3' % filename[:-4])\n",
    "    subprocess.call([\n",
    "        \"ffmpeg\", \"-i\",\n",
    "        os.path.join(song_dir, filename),\n",
    "        \"-acodec\", \"libmp3lame\", \"-ab\", \"256k\",\n",
    "        output\n",
    "        ])\n",
    "    song_df.mp3_file.loc[idx] = output\n",
    "song_df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "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_id</th>\n",
       "      <th>song_id</th>\n",
       "      <th>title</th>\n",
       "      <th>preview_file</th>\n",
       "      <th>mp3_file</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>TRAAAAW128F429D538</td>\n",
       "      <td>SOMZWCG12A8C13C480</td>\n",
       "      <td>I Didn't Mean To - Casual</td>\n",
       "      <td>TRAAAAW128F429D538-mzm.jmksdiul.aac.p.m4a</td>\n",
       "      <td>TRAAAAW128F429D538-mzm.jmksdiul.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TRAAABD128F429CF47</td>\n",
       "      <td>SOCIWDW12A8C13D406</td>\n",
       "      <td>The Letter - The Box Tops</td>\n",
       "      <td>TRAAABD128F429CF47-mzm.maejowgk.aac.p.m4a</td>\n",
       "      <td>TRAAABD128F429CF47-mzm.maejowgk.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>TRAAAEF128F4273421</td>\n",
       "      <td>SONHOTT12A8C13493C</td>\n",
       "      <td>Something Girls - Adam Ant</td>\n",
       "      <td>TRAAAEF128F4273421-mzm.wvrnqeth.aac.p.m4a</td>\n",
       "      <td>TRAAAEF128F4273421-mzm.wvrnqeth.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>TRAAAFD128F92F423A</td>\n",
       "      <td>SOFSOCN12A8C143F5D</td>\n",
       "      <td>Face the Ashes - Gob</td>\n",
       "      <td>TRAAAFD128F92F423A-mzaf_7872227378043099108.pl...</td>\n",
       "      <td>TRAAAFD128F92F423A-mzaf_7872227378043099108.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>TRAABLR128F423B7E3</td>\n",
       "      <td>SOHUOAP12A8AE488E9</td>\n",
       "      <td>Floating - Blue Rodeo</td>\n",
       "      <td>TRAABLR128F423B7E3-mzi.hrspqvdo.aac.p.m4a</td>\n",
       "      <td>TRAABLR128F423B7E3-mzi.hrspqvdo.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>TRAABNV128F425CEE1</td>\n",
       "      <td>SOUQQEA12A8C134B1B</td>\n",
       "      <td>High Tide - Richard Souther</td>\n",
       "      <td>TRAABNV128F425CEE1-mzaf_1138184835533468619.pl...</td>\n",
       "      <td>TRAABNV128F425CEE1-mzaf_1138184835533468619.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>TRAABVM128F92CA9DC</td>\n",
       "      <td>SOXLBJT12A8C140925</td>\n",
       "      <td>Caught In a Dream - Tesla</td>\n",
       "      <td>TRAABVM128F92CA9DC-mzaf_6533586203788207814.pl...</td>\n",
       "      <td>TRAABVM128F92CA9DC-mzaf_6533586203788207814.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>TRAACER128F4290F96</td>\n",
       "      <td>SOBBUGU12A8C13E95D</td>\n",
       "      <td>Setting Fire to Sleeping Giants - The Dillinge...</td>\n",
       "      <td>TRAACER128F4290F96-mzaf_8264859982335743323.pl...</td>\n",
       "      <td>TRAACER128F4290F96-mzaf_8264859982335743323.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>TRAACFV128F935E50B</td>\n",
       "      <td>SOBLGCN12AB0183212</td>\n",
       "      <td>James (Hold the Ladder Steady) - Sue Thompson</td>\n",
       "      <td>TRAACFV128F935E50B-mzaf_3214719693783324092.pl...</td>\n",
       "      <td>TRAACFV128F935E50B-mzaf_3214719693783324092.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>TRAACHN128F1489601</td>\n",
       "      <td>SOPSWQW12A6D4F8781</td>\n",
       "      <td>Made Like This (Live) - Five.Bolt.Main</td>\n",
       "      <td>TRAACHN128F1489601-mzaf_7393058876293345106.pl...</td>\n",
       "      <td>TRAACHN128F1489601-mzaf_7393058876293345106.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>TRAACNS128F14A2DF5</td>\n",
       "      <td>SOBZBAZ12A6D4F8742</td>\n",
       "      <td>Spanish Grease (Dorfmeister Con Madrid De Los ...</td>\n",
       "      <td>TRAACNS128F14A2DF5-mzaf_6517470788455498392.pl...</td>\n",
       "      <td>TRAACNS128F14A2DF5-mzaf_6517470788455498392.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>TRAACPE128F421C1B9</td>\n",
       "      <td>SOGNCJP12A58A80271</td>\n",
       "      <td>Do You Finally Need a Friend - Terry Callier</td>\n",
       "      <td>TRAACPE128F421C1B9-mzm.xbprxedn.aac.p.m4a</td>\n",
       "      <td>TRAACPE128F421C1B9-mzm.xbprxedn.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>TRAACQT128F9331780</td>\n",
       "      <td>SOLLHMX12AB01846DC</td>\n",
       "      <td>The Emperor Falls - John Wesley</td>\n",
       "      <td>TRAACQT128F9331780-mzaf_2431111848429032316.pl...</td>\n",
       "      <td>TRAACQT128F9331780-mzaf_2431111848429032316.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>TRAACTB12903CAAF15</td>\n",
       "      <td>SOGXHEG12AB018653E</td>\n",
       "      <td>It Makes No Difference Now - Billie Jo Spears</td>\n",
       "      <td>TRAACTB12903CAAF15-mzaf_1357965832882525971.pl...</td>\n",
       "      <td>TRAACTB12903CAAF15-mzaf_1357965832882525971.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>TRAADMH128F9343E59</td>\n",
       "      <td>SOTWVQT12A58A79650</td>\n",
       "      <td>Glory Be - R.L. Burnside</td>\n",
       "      <td>TRAADMH128F9343E59-mzaf_6887659447567650264.pl...</td>\n",
       "      <td>TRAADMH128F9343E59-mzaf_6887659447567650264.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>TRAADNA128F9331246</td>\n",
       "      <td>SOTSEJY12AB0180F56</td>\n",
       "      <td>Crossfire - Stevie Ray Vaughan &amp; Double Trouble</td>\n",
       "      <td>TRAADNA128F9331246-mzaf_5529499503176410095.pl...</td>\n",
       "      <td>TRAADNA128F9331246-mzaf_5529499503176410095.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>TRAADQX128F422B4CF</td>\n",
       "      <td>SOTUNMH12A6D4FA3E6</td>\n",
       "      <td>Nashville Parthenon - Casiotone for the Painfu...</td>\n",
       "      <td>TRAADQX128F422B4CF-mzaf_5963144006393207479.pl...</td>\n",
       "      <td>TRAADQX128F422B4CF-mzaf_5963144006393207479.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>TRAADRN128F932D607</td>\n",
       "      <td>SOEPPKB12AB018418B</td>\n",
       "      <td>Cocain Ducks - Ec8or</td>\n",
       "      <td>TRAADRN128F932D607-mzaf_3996120766883587517.pl...</td>\n",
       "      <td>TRAADRN128F932D607-mzaf_3996120766883587517.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>TRAADVH128EF34DE7A</td>\n",
       "      <td>SOGKIWV12A6D4F86C4</td>\n",
       "      <td>Human Being - New York Dolls</td>\n",
       "      <td>TRAADVH128EF34DE7A-mzaf_7302566818660604243.pl...</td>\n",
       "      <td>TRAADVH128EF34DE7A-mzaf_7302566818660604243.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>TRAADYB128F92D7E73</td>\n",
       "      <td>SOPHYIS12AAF3B35A3</td>\n",
       "      <td>The More I See You - Eliane Elias</td>\n",
       "      <td>TRAADYB128F92D7E73-mzaf_3703539341397611665.pl...</td>\n",
       "      <td>TRAADYB128F92D7E73-mzaf_3703539341397611665.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>TRAAEAM128F934B199</td>\n",
       "      <td>SOCPRKM12AB018A2FD</td>\n",
       "      <td>Forming - Germs</td>\n",
       "      <td>TRAAEAM128F934B199-mzaf_6470112318373573099.pl...</td>\n",
       "      <td>TRAAEAM128F934B199-mzaf_6470112318373573099.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>TRAAEEH128E0795DFE</td>\n",
       "      <td>SODHVES12A6701CE6B</td>\n",
       "      <td>Driving Home for Christmas - Chris Rea</td>\n",
       "      <td>TRAAEEH128E0795DFE-mzaf_3050587434373134442.pl...</td>\n",
       "      <td>TRAAEEH128E0795DFE-mzaf_3050587434373134442.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>TRAAELO128F9302DD1</td>\n",
       "      <td>SOXIATP12AAF3B2184</td>\n",
       "      <td>Spooks In Space - Perrey &amp; Kingsley</td>\n",
       "      <td>TRAAELO128F9302DD1-mzaf_4294576211001020467.pl...</td>\n",
       "      <td>TRAAELO128F9302DD1-mzaf_4294576211001020467.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>TRAAENC128F1451DE9</td>\n",
       "      <td>SOYQOFI12A6D4F76E1</td>\n",
       "      <td>Too Much Saturn - Francis Dunnery</td>\n",
       "      <td>TRAAENC128F1451DE9-mzm.ocsvdopt.aac.p.m4a</td>\n",
       "      <td>TRAAENC128F1451DE9-mzm.ocsvdopt.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>TRAAEOU128F9309DE0</td>\n",
       "      <td>SOMZCVH12AB0182B8E</td>\n",
       "      <td>Stream - Suzanne Ciani</td>\n",
       "      <td>TRAAEOU128F9309DE0-mzm.yqyybnkh.aac.p.m4a</td>\n",
       "      <td>TRAAEOU128F9309DE0-mzm.yqyybnkh.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>TRAAEWG128F930B3A4</td>\n",
       "      <td>SOLGHDZ12AB0183B11</td>\n",
       "      <td>Wicker Chair - Kings of Leon</td>\n",
       "      <td>TRAAEWG128F930B3A4-mzm.thttooxs.aac.p.m4a</td>\n",
       "      <td>TRAAEWG128F930B3A4-mzm.thttooxs.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>TRAAFJW128F428A424</td>\n",
       "      <td>SOPIKEG12A58291636</td>\n",
       "      <td>Stickin In My Eye - NOFX</td>\n",
       "      <td>TRAAFJW128F428A424-mzm.sxksrwuo.aac.p.m4a</td>\n",
       "      <td>TRAAFJW128F428A424-mzm.sxksrwuo.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>TRAAFMS128F933AB23</td>\n",
       "      <td>SOSBDSF12AB0189007</td>\n",
       "      <td>Entre Caníbales - Soda Stereo</td>\n",
       "      <td>TRAAFMS128F933AB23-mzm.bajhmajr.aac.p.m4a</td>\n",
       "      <td>TRAAFMS128F933AB23-mzm.bajhmajr.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>TRAAFRU128F9339158</td>\n",
       "      <td>SOHMMMC12AB0181C42</td>\n",
       "      <td>Sudanese Dance - Xcultures</td>\n",
       "      <td>TRAAFRU128F9339158-mzaf_3631144973000780792.pl...</td>\n",
       "      <td>TRAAFRU128F9339158-mzaf_3631144973000780792.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>TRAAGCZ128F93210FD</td>\n",
       "      <td>SOCHRXB12A8AE48069</td>\n",
       "      <td>Let's Get It Started (Spike Mix) [Bonus Track]...</td>\n",
       "      <td>TRAAGCZ128F93210FD-mzm.hmjgsjhx.aac.p.m4a</td>\n",
       "      <td>TRAAGCZ128F93210FD-mzm.hmjgsjhx.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2673</th>\n",
       "      <td>TRBIBLJ12903CCF436</td>\n",
       "      <td>SOMNXCC12AB0187BE7</td>\n",
       "      <td>Papa Don't Preach - Madonna</td>\n",
       "      <td>TRBIBLJ12903CCF436-mzm.frfuxowi.aac.p.m4a</td>\n",
       "      <td>TRBIBLJ12903CCF436-mzm.frfuxowi.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2674</th>\n",
       "      <td>TRBIBTE128E078E882</td>\n",
       "      <td>SOQAFSW12A67021430</td>\n",
       "      <td>Start the Jam - Wayside DSP</td>\n",
       "      <td>TRBIBTE128E078E882-mzm.ehrygolm.aac.p.m4a</td>\n",
       "      <td>TRBIBTE128E078E882-mzm.ehrygolm.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2675</th>\n",
       "      <td>TRBIBTU128F92FDC9D</td>\n",
       "      <td>SOQENPJ12AB0180997</td>\n",
       "      <td>Fortress - Tim Exile</td>\n",
       "      <td>TRBIBTU128F92FDC9D-mzaf_4493041305409170086.pl...</td>\n",
       "      <td>TRBIBTU128F92FDC9D-mzaf_4493041305409170086.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2676</th>\n",
       "      <td>TRBICGT128E0792473</td>\n",
       "      <td>SOSBXWX12A6701D235</td>\n",
       "      <td>Patience - Guns N' Roses</td>\n",
       "      <td>TRBICGT128E0792473-mzaf_698476640989287263.plu...</td>\n",
       "      <td>TRBICGT128E0792473-mzaf_698476640989287263.plu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2677</th>\n",
       "      <td>TRBICRP128F42882BB</td>\n",
       "      <td>SOCHDXC12A8C13837F</td>\n",
       "      <td>Follow the Light - Dungeon Family</td>\n",
       "      <td>TRBICRP128F42882BB-mzm.oqakbaoj.aac.p.m4a</td>\n",
       "      <td>TRBICRP128F42882BB-mzm.oqakbaoj.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2678</th>\n",
       "      <td>TRBICVB128F9326B65</td>\n",
       "      <td>SOKASWV12AB01857B5</td>\n",
       "      <td>Night Falls (The Weight of It) - Strata</td>\n",
       "      <td>TRBICVB128F9326B65-mzaf_4633364308863248771.pl...</td>\n",
       "      <td>TRBICVB128F9326B65-mzaf_4633364308863248771.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2679</th>\n",
       "      <td>TRBICWI128F4234787</td>\n",
       "      <td>SOOJXKD12A58A7AB3C</td>\n",
       "      <td>It Hurts Me Too - Jeremy Spencer</td>\n",
       "      <td>TRBICWI128F4234787-mzaf_6973918210066872643.pl...</td>\n",
       "      <td>TRBICWI128F4234787-mzaf_6973918210066872643.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2680</th>\n",
       "      <td>TRBIDUK128F42806A4</td>\n",
       "      <td>SODRBBP12A8C1385AF</td>\n",
       "      <td>No Matter How She Done It - Georgia Tom &amp; Tamp...</td>\n",
       "      <td>TRBIDUK128F42806A4-mzm.lzueetma.aac.p.m4a</td>\n",
       "      <td>TRBIDUK128F42806A4-mzm.lzueetma.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2681</th>\n",
       "      <td>TRBIEIZ128F148D778</td>\n",
       "      <td>SOQMFYZ12A6D4F9C4A</td>\n",
       "      <td>Diamonds from Sierra Leone (Remix) [feat. Jay-...</td>\n",
       "      <td>TRBIEIZ128F148D778-mzm.dkphvilp.aac.p.m4a</td>\n",
       "      <td>TRBIEIZ128F148D778-mzm.dkphvilp.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2682</th>\n",
       "      <td>TRBIFGK128F92F23A2</td>\n",
       "      <td>SOTEFFR12A8C144765</td>\n",
       "      <td>A Dustland Fairytale - The Killers</td>\n",
       "      <td>TRBIFGK128F92F23A2-mzaf_5196817349599310073.pl...</td>\n",
       "      <td>TRBIFGK128F92F23A2-mzaf_5196817349599310073.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2683</th>\n",
       "      <td>TRBIFUD128F1495AE2</td>\n",
       "      <td>SOIDEZW12A6D4F9655</td>\n",
       "      <td>Young Riders - Hot Boys</td>\n",
       "      <td>TRBIFUD128F1495AE2-mzm.vddydlrk.aac.p.m4a</td>\n",
       "      <td>TRBIFUD128F1495AE2-mzm.vddydlrk.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2684</th>\n",
       "      <td>TRBIFUV12903D07374</td>\n",
       "      <td>SOSJSMZ12AB0187EB3</td>\n",
       "      <td>Lovin' You - Minnie Riperton</td>\n",
       "      <td>TRBIFUV12903D07374-mzaf_2743043085160897058.pl...</td>\n",
       "      <td>TRBIFUV12903D07374-mzaf_2743043085160897058.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2685</th>\n",
       "      <td>TRBIFWB128F1460D8C</td>\n",
       "      <td>SONBMJI12A6D4F82B7</td>\n",
       "      <td>Merry-Go-Round - Mötley Crüe</td>\n",
       "      <td>TRBIFWB128F1460D8C-mzaf_5804891440160606013.pl...</td>\n",
       "      <td>TRBIFWB128F1460D8C-mzaf_5804891440160606013.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2686</th>\n",
       "      <td>TRBIGRY128F42597B3</td>\n",
       "      <td>SOPGYHQ12A8AE47B30</td>\n",
       "      <td>All About Our Love - Sade</td>\n",
       "      <td>TRBIGRY128F42597B3-mzm.jwnrcien.aac.p.m4a</td>\n",
       "      <td>TRBIGRY128F42597B3-mzm.jwnrcien.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2687</th>\n",
       "      <td>TRBIGRZ128E0792329</td>\n",
       "      <td>SONQTUE12B0B80BA5A</td>\n",
       "      <td>Gammer Gerten's Needle - Deep Blue Something</td>\n",
       "      <td>TRBIGRZ128E0792329-mzm.gdounyrh.aac.p.m4a</td>\n",
       "      <td>TRBIGRZ128E0792329-mzm.gdounyrh.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2688</th>\n",
       "      <td>TRBIGUJ128F92D674F</td>\n",
       "      <td>SOVZNGE12AAF3B1E2A</td>\n",
       "      <td>Leave My Kitten Alone - Little Willie John</td>\n",
       "      <td>TRBIGUJ128F92D674F-mzaf_5508151763893264690.pl...</td>\n",
       "      <td>TRBIGUJ128F92D674F-mzaf_5508151763893264690.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2689</th>\n",
       "      <td>TRBIHAU128F425C317</td>\n",
       "      <td>SOOAMWT12A8C13B479</td>\n",
       "      <td>Does It Float - Dinosaur Jr.</td>\n",
       "      <td>TRBIHAU128F425C317-mzaf_2003727183422313643.pl...</td>\n",
       "      <td>TRBIHAU128F425C317-mzaf_2003727183422313643.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2690</th>\n",
       "      <td>TRBIHKT128F4290554</td>\n",
       "      <td>SOIRKJL12A8C13A2AA</td>\n",
       "      <td>Give U My Heart (feat. Babyface) - Toni Braxton</td>\n",
       "      <td>TRBIHKT128F4290554-mzaf_4731498200943530522.pl...</td>\n",
       "      <td>TRBIHKT128F4290554-mzaf_4731498200943530522.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2691</th>\n",
       "      <td>TRBIHVW128F4233965</td>\n",
       "      <td>SOLYUTF12A8C133225</td>\n",
       "      <td>Crayon Sharpener - Themselves</td>\n",
       "      <td>TRBIHVW128F4233965-mzaf_5155438272661375192.pl...</td>\n",
       "      <td>TRBIHVW128F4233965-mzaf_5155438272661375192.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2692</th>\n",
       "      <td>TRBIICD128F14553D8</td>\n",
       "      <td>SOEEPYY12A58A7B1C8</td>\n",
       "      <td>Le precipice - Daara J</td>\n",
       "      <td>TRBIICD128F14553D8-mzaf_3629547233284430126.pl...</td>\n",
       "      <td>TRBIICD128F14553D8-mzaf_3629547233284430126.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2693</th>\n",
       "      <td>TRBIIEU128F9307C88</td>\n",
       "      <td>SOPHMRL12AB017E87B</td>\n",
       "      <td>Don't Let Her Pull You Down - New Found Glory</td>\n",
       "      <td>TRBIIEU128F9307C88-mzm.yhutfroh.aac.p.m4a</td>\n",
       "      <td>TRBIIEU128F9307C88-mzm.yhutfroh.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2694</th>\n",
       "      <td>TRBIIJY12903CE4755</td>\n",
       "      <td>SOPHKAI12AB018873D</td>\n",
       "      <td>Ten Thousand Angels - Mindy McCready</td>\n",
       "      <td>TRBIIJY12903CE4755-mzm.wocalmug.aac.p.m4a</td>\n",
       "      <td>TRBIIJY12903CE4755-mzm.wocalmug.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2695</th>\n",
       "      <td>TRBIIOT128F423C594</td>\n",
       "      <td>SOLHMRA12A8C13234A</td>\n",
       "      <td>Leaders of Men - Joy Division</td>\n",
       "      <td>TRBIIOT128F423C594-mzm.ockwagel.aac.p.m4a</td>\n",
       "      <td>TRBIIOT128F423C594-mzm.ockwagel.aac.p.mp3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2696</th>\n",
       "      <td>TRBIJES12903CF5B12</td>\n",
       "      <td>SOQSJJL12AC46874BC</td>\n",
       "      <td>Harboring An Apparition - Mouth of the Architect</td>\n",
       "      <td>TRBIJES12903CF5B12-mzaf_3792419090439509674.pl...</td>\n",
       "      <td>TRBIJES12903CF5B12-mzaf_3792419090439509674.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2697</th>\n",
       "      <td>TRBIJFB128F92ED124</td>\n",
       "      <td>SOFOBSK12A8C1447C4</td>\n",
       "      <td>One the Road (To Damnation) - It Dies Today</td>\n",
       "      <td>TRBIJFB128F92ED124-mzaf_7136675420425028256.pl...</td>\n",
       "      <td>TRBIJFB128F92ED124-mzaf_7136675420425028256.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2698</th>\n",
       "      <td>TRBIJIA128F425F57D</td>\n",
       "      <td>SOBUUYV12A58A7DA27</td>\n",
       "      <td>The Forgotten Lands - David Arkenstone</td>\n",
       "      <td>TRBIJIA128F425F57D-mzaf_6215404625070131329.pl...</td>\n",
       "      <td>TRBIJIA128F425F57D-mzaf_6215404625070131329.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2699</th>\n",
       "      <td>TRBIJLT12903CE7070</td>\n",
       "      <td>SOVMTAW12A8C13B071</td>\n",
       "      <td>Keep Your Lamp Trimmed and Burning - Derek Tru...</td>\n",
       "      <td>TRBIJLT12903CE7070-mzaf_2065804340813921371.pl...</td>\n",
       "      <td>TRBIJLT12903CE7070-mzaf_2065804340813921371.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2700</th>\n",
       "      <td>TRBIJMU12903CF892B</td>\n",
       "      <td>SOLXXPY12A67ADABA0</td>\n",
       "      <td>The Hanged Man - Moonspell</td>\n",
       "      <td>TRBIJMU12903CF892B-mzaf_8248186866376864482.pl...</td>\n",
       "      <td>TRBIJMU12903CF892B-mzaf_8248186866376864482.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2701</th>\n",
       "      <td>TRBIJNF128F14815A7</td>\n",
       "      <td>SOAYONI12A6D4F85C8</td>\n",
       "      <td>The Wonderful World of the Young - Danny Williams</td>\n",
       "      <td>TRBIJNF128F14815A7-mzaf_8049693996804410051.pl...</td>\n",
       "      <td>TRBIJNF128F14815A7-mzaf_8049693996804410051.pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2702</th>\n",
       "      <td>TRBIJYB128F14AE326</td>\n",
       "      <td>SOFAOMI12A6D4FA2D8</td>\n",
       "      <td>Caroline - Seventh Day Slumber</td>\n",
       "      <td>TRBIJYB128F14AE326-mzaf_8375449016505959562.pl...</td>\n",
       "      <td>TRBIJYB128F14AE326-mzaf_8375449016505959562.pl...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2703 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                track_id             song_id  \\\n",
       "0     TRAAAAW128F429D538  SOMZWCG12A8C13C480   \n",
       "1     TRAAABD128F429CF47  SOCIWDW12A8C13D406   \n",
       "2     TRAAAEF128F4273421  SONHOTT12A8C13493C   \n",
       "3     TRAAAFD128F92F423A  SOFSOCN12A8C143F5D   \n",
       "4     TRAABLR128F423B7E3  SOHUOAP12A8AE488E9   \n",
       "5     TRAABNV128F425CEE1  SOUQQEA12A8C134B1B   \n",
       "6     TRAABVM128F92CA9DC  SOXLBJT12A8C140925   \n",
       "7     TRAACER128F4290F96  SOBBUGU12A8C13E95D   \n",
       "8     TRAACFV128F935E50B  SOBLGCN12AB0183212   \n",
       "9     TRAACHN128F1489601  SOPSWQW12A6D4F8781   \n",
       "10    TRAACNS128F14A2DF5  SOBZBAZ12A6D4F8742   \n",
       "11    TRAACPE128F421C1B9  SOGNCJP12A58A80271   \n",
       "12    TRAACQT128F9331780  SOLLHMX12AB01846DC   \n",
       "13    TRAACTB12903CAAF15  SOGXHEG12AB018653E   \n",
       "14    TRAADMH128F9343E59  SOTWVQT12A58A79650   \n",
       "15    TRAADNA128F9331246  SOTSEJY12AB0180F56   \n",
       "16    TRAADQX128F422B4CF  SOTUNMH12A6D4FA3E6   \n",
       "17    TRAADRN128F932D607  SOEPPKB12AB018418B   \n",
       "18    TRAADVH128EF34DE7A  SOGKIWV12A6D4F86C4   \n",
       "19    TRAADYB128F92D7E73  SOPHYIS12AAF3B35A3   \n",
       "20    TRAAEAM128F934B199  SOCPRKM12AB018A2FD   \n",
       "21    TRAAEEH128E0795DFE  SODHVES12A6701CE6B   \n",
       "22    TRAAELO128F9302DD1  SOXIATP12AAF3B2184   \n",
       "23    TRAAENC128F1451DE9  SOYQOFI12A6D4F76E1   \n",
       "24    TRAAEOU128F9309DE0  SOMZCVH12AB0182B8E   \n",
       "25    TRAAEWG128F930B3A4  SOLGHDZ12AB0183B11   \n",
       "26    TRAAFJW128F428A424  SOPIKEG12A58291636   \n",
       "27    TRAAFMS128F933AB23  SOSBDSF12AB0189007   \n",
       "28    TRAAFRU128F9339158  SOHMMMC12AB0181C42   \n",
       "29    TRAAGCZ128F93210FD  SOCHRXB12A8AE48069   \n",
       "...                  ...                 ...   \n",
       "2673  TRBIBLJ12903CCF436  SOMNXCC12AB0187BE7   \n",
       "2674  TRBIBTE128E078E882  SOQAFSW12A67021430   \n",
       "2675  TRBIBTU128F92FDC9D  SOQENPJ12AB0180997   \n",
       "2676  TRBICGT128E0792473  SOSBXWX12A6701D235   \n",
       "2677  TRBICRP128F42882BB  SOCHDXC12A8C13837F   \n",
       "2678  TRBICVB128F9326B65  SOKASWV12AB01857B5   \n",
       "2679  TRBICWI128F4234787  SOOJXKD12A58A7AB3C   \n",
       "2680  TRBIDUK128F42806A4  SODRBBP12A8C1385AF   \n",
       "2681  TRBIEIZ128F148D778  SOQMFYZ12A6D4F9C4A   \n",
       "2682  TRBIFGK128F92F23A2  SOTEFFR12A8C144765   \n",
       "2683  TRBIFUD128F1495AE2  SOIDEZW12A6D4F9655   \n",
       "2684  TRBIFUV12903D07374  SOSJSMZ12AB0187EB3   \n",
       "2685  TRBIFWB128F1460D8C  SONBMJI12A6D4F82B7   \n",
       "2686  TRBIGRY128F42597B3  SOPGYHQ12A8AE47B30   \n",
       "2687  TRBIGRZ128E0792329  SONQTUE12B0B80BA5A   \n",
       "2688  TRBIGUJ128F92D674F  SOVZNGE12AAF3B1E2A   \n",
       "2689  TRBIHAU128F425C317  SOOAMWT12A8C13B479   \n",
       "2690  TRBIHKT128F4290554  SOIRKJL12A8C13A2AA   \n",
       "2691  TRBIHVW128F4233965  SOLYUTF12A8C133225   \n",
       "2692  TRBIICD128F14553D8  SOEEPYY12A58A7B1C8   \n",
       "2693  TRBIIEU128F9307C88  SOPHMRL12AB017E87B   \n",
       "2694  TRBIIJY12903CE4755  SOPHKAI12AB018873D   \n",
       "2695  TRBIIOT128F423C594  SOLHMRA12A8C13234A   \n",
       "2696  TRBIJES12903CF5B12  SOQSJJL12AC46874BC   \n",
       "2697  TRBIJFB128F92ED124  SOFOBSK12A8C1447C4   \n",
       "2698  TRBIJIA128F425F57D  SOBUUYV12A58A7DA27   \n",
       "2699  TRBIJLT12903CE7070  SOVMTAW12A8C13B071   \n",
       "2700  TRBIJMU12903CF892B  SOLXXPY12A67ADABA0   \n",
       "2701  TRBIJNF128F14815A7  SOAYONI12A6D4F85C8   \n",
       "2702  TRBIJYB128F14AE326  SOFAOMI12A6D4FA2D8   \n",
       "\n",
       "                                                  title  \\\n",
       "0                             I Didn't Mean To - Casual   \n",
       "1                             The Letter - The Box Tops   \n",
       "2                            Something Girls - Adam Ant   \n",
       "3                                  Face the Ashes - Gob   \n",
       "4                                 Floating - Blue Rodeo   \n",
       "5                           High Tide - Richard Souther   \n",
       "6                             Caught In a Dream - Tesla   \n",
       "7     Setting Fire to Sleeping Giants - The Dillinge...   \n",
       "8         James (Hold the Ladder Steady) - Sue Thompson   \n",
       "9                Made Like This (Live) - Five.Bolt.Main   \n",
       "10    Spanish Grease (Dorfmeister Con Madrid De Los ...   \n",
       "11         Do You Finally Need a Friend - Terry Callier   \n",
       "12                      The Emperor Falls - John Wesley   \n",
       "13        It Makes No Difference Now - Billie Jo Spears   \n",
       "14                             Glory Be - R.L. Burnside   \n",
       "15      Crossfire - Stevie Ray Vaughan & Double Trouble   \n",
       "16    Nashville Parthenon - Casiotone for the Painfu...   \n",
       "17                                 Cocain Ducks - Ec8or   \n",
       "18                         Human Being - New York Dolls   \n",
       "19                    The More I See You - Eliane Elias   \n",
       "20                                      Forming - Germs   \n",
       "21               Driving Home for Christmas - Chris Rea   \n",
       "22                  Spooks In Space - Perrey & Kingsley   \n",
       "23                    Too Much Saturn - Francis Dunnery   \n",
       "24                               Stream - Suzanne Ciani   \n",
       "25                         Wicker Chair - Kings of Leon   \n",
       "26                             Stickin In My Eye - NOFX   \n",
       "27                        Entre Caníbales - Soda Stereo   \n",
       "28                           Sudanese Dance - Xcultures   \n",
       "29    Let's Get It Started (Spike Mix) [Bonus Track]...   \n",
       "...                                                 ...   \n",
       "2673                        Papa Don't Preach - Madonna   \n",
       "2674                        Start the Jam - Wayside DSP   \n",
       "2675                               Fortress - Tim Exile   \n",
       "2676                           Patience - Guns N' Roses   \n",
       "2677                  Follow the Light - Dungeon Family   \n",
       "2678            Night Falls (The Weight of It) - Strata   \n",
       "2679                   It Hurts Me Too - Jeremy Spencer   \n",
       "2680  No Matter How She Done It - Georgia Tom & Tamp...   \n",
       "2681  Diamonds from Sierra Leone (Remix) [feat. Jay-...   \n",
       "2682                 A Dustland Fairytale - The Killers   \n",
       "2683                            Young Riders - Hot Boys   \n",
       "2684                       Lovin' You - Minnie Riperton   \n",
       "2685                       Merry-Go-Round - Mötley Crüe   \n",
       "2686                          All About Our Love - Sade   \n",
       "2687       Gammer Gerten's Needle - Deep Blue Something   \n",
       "2688         Leave My Kitten Alone - Little Willie John   \n",
       "2689                       Does It Float - Dinosaur Jr.   \n",
       "2690    Give U My Heart (feat. Babyface) - Toni Braxton   \n",
       "2691                      Crayon Sharpener - Themselves   \n",
       "2692                             Le precipice - Daara J   \n",
       "2693      Don't Let Her Pull You Down - New Found Glory   \n",
       "2694               Ten Thousand Angels - Mindy McCready   \n",
       "2695                      Leaders of Men - Joy Division   \n",
       "2696   Harboring An Apparition - Mouth of the Architect   \n",
       "2697        One the Road (To Damnation) - It Dies Today   \n",
       "2698             The Forgotten Lands - David Arkenstone   \n",
       "2699  Keep Your Lamp Trimmed and Burning - Derek Tru...   \n",
       "2700                         The Hanged Man - Moonspell   \n",
       "2701  The Wonderful World of the Young - Danny Williams   \n",
       "2702                     Caroline - Seventh Day Slumber   \n",
       "\n",
       "                                           preview_file  \\\n",
       "0             TRAAAAW128F429D538-mzm.jmksdiul.aac.p.m4a   \n",
       "1             TRAAABD128F429CF47-mzm.maejowgk.aac.p.m4a   \n",
       "2             TRAAAEF128F4273421-mzm.wvrnqeth.aac.p.m4a   \n",
       "3     TRAAAFD128F92F423A-mzaf_7872227378043099108.pl...   \n",
       "4             TRAABLR128F423B7E3-mzi.hrspqvdo.aac.p.m4a   \n",
       "5     TRAABNV128F425CEE1-mzaf_1138184835533468619.pl...   \n",
       "6     TRAABVM128F92CA9DC-mzaf_6533586203788207814.pl...   \n",
       "7     TRAACER128F4290F96-mzaf_8264859982335743323.pl...   \n",
       "8     TRAACFV128F935E50B-mzaf_3214719693783324092.pl...   \n",
       "9     TRAACHN128F1489601-mzaf_7393058876293345106.pl...   \n",
       "10    TRAACNS128F14A2DF5-mzaf_6517470788455498392.pl...   \n",
       "11            TRAACPE128F421C1B9-mzm.xbprxedn.aac.p.m4a   \n",
       "12    TRAACQT128F9331780-mzaf_2431111848429032316.pl...   \n",
       "13    TRAACTB12903CAAF15-mzaf_1357965832882525971.pl...   \n",
       "14    TRAADMH128F9343E59-mzaf_6887659447567650264.pl...   \n",
       "15    TRAADNA128F9331246-mzaf_5529499503176410095.pl...   \n",
       "16    TRAADQX128F422B4CF-mzaf_5963144006393207479.pl...   \n",
       "17    TRAADRN128F932D607-mzaf_3996120766883587517.pl...   \n",
       "18    TRAADVH128EF34DE7A-mzaf_7302566818660604243.pl...   \n",
       "19    TRAADYB128F92D7E73-mzaf_3703539341397611665.pl...   \n",
       "20    TRAAEAM128F934B199-mzaf_6470112318373573099.pl...   \n",
       "21    TRAAEEH128E0795DFE-mzaf_3050587434373134442.pl...   \n",
       "22    TRAAELO128F9302DD1-mzaf_4294576211001020467.pl...   \n",
       "23            TRAAENC128F1451DE9-mzm.ocsvdopt.aac.p.m4a   \n",
       "24            TRAAEOU128F9309DE0-mzm.yqyybnkh.aac.p.m4a   \n",
       "25            TRAAEWG128F930B3A4-mzm.thttooxs.aac.p.m4a   \n",
       "26            TRAAFJW128F428A424-mzm.sxksrwuo.aac.p.m4a   \n",
       "27            TRAAFMS128F933AB23-mzm.bajhmajr.aac.p.m4a   \n",
       "28    TRAAFRU128F9339158-mzaf_3631144973000780792.pl...   \n",
       "29            TRAAGCZ128F93210FD-mzm.hmjgsjhx.aac.p.m4a   \n",
       "...                                                 ...   \n",
       "2673          TRBIBLJ12903CCF436-mzm.frfuxowi.aac.p.m4a   \n",
       "2674          TRBIBTE128E078E882-mzm.ehrygolm.aac.p.m4a   \n",
       "2675  TRBIBTU128F92FDC9D-mzaf_4493041305409170086.pl...   \n",
       "2676  TRBICGT128E0792473-mzaf_698476640989287263.plu...   \n",
       "2677          TRBICRP128F42882BB-mzm.oqakbaoj.aac.p.m4a   \n",
       "2678  TRBICVB128F9326B65-mzaf_4633364308863248771.pl...   \n",
       "2679  TRBICWI128F4234787-mzaf_6973918210066872643.pl...   \n",
       "2680          TRBIDUK128F42806A4-mzm.lzueetma.aac.p.m4a   \n",
       "2681          TRBIEIZ128F148D778-mzm.dkphvilp.aac.p.m4a   \n",
       "2682  TRBIFGK128F92F23A2-mzaf_5196817349599310073.pl...   \n",
       "2683          TRBIFUD128F1495AE2-mzm.vddydlrk.aac.p.m4a   \n",
       "2684  TRBIFUV12903D07374-mzaf_2743043085160897058.pl...   \n",
       "2685  TRBIFWB128F1460D8C-mzaf_5804891440160606013.pl...   \n",
       "2686          TRBIGRY128F42597B3-mzm.jwnrcien.aac.p.m4a   \n",
       "2687          TRBIGRZ128E0792329-mzm.gdounyrh.aac.p.m4a   \n",
       "2688  TRBIGUJ128F92D674F-mzaf_5508151763893264690.pl...   \n",
       "2689  TRBIHAU128F425C317-mzaf_2003727183422313643.pl...   \n",
       "2690  TRBIHKT128F4290554-mzaf_4731498200943530522.pl...   \n",
       "2691  TRBIHVW128F4233965-mzaf_5155438272661375192.pl...   \n",
       "2692  TRBIICD128F14553D8-mzaf_3629547233284430126.pl...   \n",
       "2693          TRBIIEU128F9307C88-mzm.yhutfroh.aac.p.m4a   \n",
       "2694          TRBIIJY12903CE4755-mzm.wocalmug.aac.p.m4a   \n",
       "2695          TRBIIOT128F423C594-mzm.ockwagel.aac.p.m4a   \n",
       "2696  TRBIJES12903CF5B12-mzaf_3792419090439509674.pl...   \n",
       "2697  TRBIJFB128F92ED124-mzaf_7136675420425028256.pl...   \n",
       "2698  TRBIJIA128F425F57D-mzaf_6215404625070131329.pl...   \n",
       "2699  TRBIJLT12903CE7070-mzaf_2065804340813921371.pl...   \n",
       "2700  TRBIJMU12903CF892B-mzaf_8248186866376864482.pl...   \n",
       "2701  TRBIJNF128F14815A7-mzaf_8049693996804410051.pl...   \n",
       "2702  TRBIJYB128F14AE326-mzaf_8375449016505959562.pl...   \n",
       "\n",
       "                                               mp3_file  \n",
       "0             TRAAAAW128F429D538-mzm.jmksdiul.aac.p.mp3  \n",
       "1             TRAAABD128F429CF47-mzm.maejowgk.aac.p.mp3  \n",
       "2             TRAAAEF128F4273421-mzm.wvrnqeth.aac.p.mp3  \n",
       "3     TRAAAFD128F92F423A-mzaf_7872227378043099108.pl...  \n",
       "4             TRAABLR128F423B7E3-mzi.hrspqvdo.aac.p.mp3  \n",
       "5     TRAABNV128F425CEE1-mzaf_1138184835533468619.pl...  \n",
       "6     TRAABVM128F92CA9DC-mzaf_6533586203788207814.pl...  \n",
       "7     TRAACER128F4290F96-mzaf_8264859982335743323.pl...  \n",
       "8     TRAACFV128F935E50B-mzaf_3214719693783324092.pl...  \n",
       "9     TRAACHN128F1489601-mzaf_7393058876293345106.pl...  \n",
       "10    TRAACNS128F14A2DF5-mzaf_6517470788455498392.pl...  \n",
       "11            TRAACPE128F421C1B9-mzm.xbprxedn.aac.p.mp3  \n",
       "12    TRAACQT128F9331780-mzaf_2431111848429032316.pl...  \n",
       "13    TRAACTB12903CAAF15-mzaf_1357965832882525971.pl...  \n",
       "14    TRAADMH128F9343E59-mzaf_6887659447567650264.pl...  \n",
       "15    TRAADNA128F9331246-mzaf_5529499503176410095.pl...  \n",
       "16    TRAADQX128F422B4CF-mzaf_5963144006393207479.pl...  \n",
       "17    TRAADRN128F932D607-mzaf_3996120766883587517.pl...  \n",
       "18    TRAADVH128EF34DE7A-mzaf_7302566818660604243.pl...  \n",
       "19    TRAADYB128F92D7E73-mzaf_3703539341397611665.pl...  \n",
       "20    TRAAEAM128F934B199-mzaf_6470112318373573099.pl...  \n",
       "21    TRAAEEH128E0795DFE-mzaf_3050587434373134442.pl...  \n",
       "22    TRAAELO128F9302DD1-mzaf_4294576211001020467.pl...  \n",
       "23            TRAAENC128F1451DE9-mzm.ocsvdopt.aac.p.mp3  \n",
       "24            TRAAEOU128F9309DE0-mzm.yqyybnkh.aac.p.mp3  \n",
       "25            TRAAEWG128F930B3A4-mzm.thttooxs.aac.p.mp3  \n",
       "26            TRAAFJW128F428A424-mzm.sxksrwuo.aac.p.mp3  \n",
       "27            TRAAFMS128F933AB23-mzm.bajhmajr.aac.p.mp3  \n",
       "28    TRAAFRU128F9339158-mzaf_3631144973000780792.pl...  \n",
       "29            TRAAGCZ128F93210FD-mzm.hmjgsjhx.aac.p.mp3  \n",
       "...                                                 ...  \n",
       "2673          TRBIBLJ12903CCF436-mzm.frfuxowi.aac.p.mp3  \n",
       "2674          TRBIBTE128E078E882-mzm.ehrygolm.aac.p.mp3  \n",
       "2675  TRBIBTU128F92FDC9D-mzaf_4493041305409170086.pl...  \n",
       "2676  TRBICGT128E0792473-mzaf_698476640989287263.plu...  \n",
       "2677          TRBICRP128F42882BB-mzm.oqakbaoj.aac.p.mp3  \n",
       "2678  TRBICVB128F9326B65-mzaf_4633364308863248771.pl...  \n",
       "2679  TRBICWI128F4234787-mzaf_6973918210066872643.pl...  \n",
       "2680          TRBIDUK128F42806A4-mzm.lzueetma.aac.p.mp3  \n",
       "2681          TRBIEIZ128F148D778-mzm.dkphvilp.aac.p.mp3  \n",
       "2682  TRBIFGK128F92F23A2-mzaf_5196817349599310073.pl...  \n",
       "2683          TRBIFUD128F1495AE2-mzm.vddydlrk.aac.p.mp3  \n",
       "2684  TRBIFUV12903D07374-mzaf_2743043085160897058.pl...  \n",
       "2685  TRBIFWB128F1460D8C-mzaf_5804891440160606013.pl...  \n",
       "2686          TRBIGRY128F42597B3-mzm.jwnrcien.aac.p.mp3  \n",
       "2687          TRBIGRZ128E0792329-mzm.gdounyrh.aac.p.mp3  \n",
       "2688  TRBIGUJ128F92D674F-mzaf_5508151763893264690.pl...  \n",
       "2689  TRBIHAU128F425C317-mzaf_2003727183422313643.pl...  \n",
       "2690  TRBIHKT128F4290554-mzaf_4731498200943530522.pl...  \n",
       "2691  TRBIHVW128F4233965-mzaf_5155438272661375192.pl...  \n",
       "2692  TRBIICD128F14553D8-mzaf_3629547233284430126.pl...  \n",
       "2693          TRBIIEU128F9307C88-mzm.yhutfroh.aac.p.mp3  \n",
       "2694          TRBIIJY12903CE4755-mzm.wocalmug.aac.p.mp3  \n",
       "2695          TRBIIOT128F423C594-mzm.ockwagel.aac.p.mp3  \n",
       "2696  TRBIJES12903CF5B12-mzaf_3792419090439509674.pl...  \n",
       "2697  TRBIJFB128F92ED124-mzaf_7136675420425028256.pl...  \n",
       "2698  TRBIJIA128F425F57D-mzaf_6215404625070131329.pl...  \n",
       "2699  TRBIJLT12903CE7070-mzaf_2065804340813921371.pl...  \n",
       "2700  TRBIJMU12903CF892B-mzaf_8248186866376864482.pl...  \n",
       "2701  TRBIJNF128F14815A7-mzaf_8049693996804410051.pl...  \n",
       "2702  TRBIJYB128F14AE326-mzaf_8375449016505959562.pl...  \n",
       "\n",
       "[2703 rows x 5 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# mp3_file = song_df['mp3_file'][0]\n",
    "# mp3_file = mp3_file[17:]\n",
    "# filename = song_df['preview_file']\n",
    "# song_df['mp3_file'] = ''\n",
    "# song_df['mp3_file'] = filename[:][:-4]+'.mp3'\n",
    "for idx,row in song_df.iterrows():\n",
    "    song_df.mp3_file.loc[idx]=(row['preview_file'])[:-4]+'.mp3'\n",
    "song_df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'TRAAAAW128F429D538-mzm.jmksdiul.aac.p.mp3'"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "song_df['mp3_file'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "song_df.to_csv(main_file_path, sep='\\t', encoding='utf-8', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2703"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(song_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2703"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(song_df.drop_duplicates())"
   ]
  },
  {
   "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_id</th>\n",
       "      <th>song_id</th>\n",
       "      <th>title</th>\n",
       "      <th>preview_file</th>\n",
       "      <th>mp3_file</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>TRAAAAW128F429D538</td>\n",
       "      <td>SOMZWCG12A8C13C480</td>\n",
       "      <td>I Didn't Mean To - Casual</td>\n",
       "      <td>TRAAAAW128F429D538-mzm.jmksdiul.aac.p.m4a</td>\n",
       "      <td>TRAAAAW128F429D538-mzm.jmksdiul.aac.p.mp3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             track_id             song_id                      title  \\\n",
       "0  TRAAAAW128F429D538  SOMZWCG12A8C13C480  I Didn't Mean To - Casual   \n",
       "\n",
       "                                preview_file  \\\n",
       "0  TRAAAAW128F429D538-mzm.jmksdiul.aac.p.m4a   \n",
       "\n",
       "                                    mp3_file  \n",
       "0  TRAAAAW128F429D538-mzm.jmksdiul.aac.p.mp3  "
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "song_df[song_df['track_id'] == 'TRAAAAW128F429D538']"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}