1) Create source sound collection.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 1) Create source sound collection\n",
    "\n",
    "This notebook includes the code to create the collection of sounds that will later be used as source material for our audio mosaicing application. The collection of sounds is created by defining a number of queries to be performed using the Freesound API and concatenanting the results of each query. A number of metadata fields are stored for each sound in the collection and saved into a Pandas DataFrame object and CSV file in disk. For each sound in the collection, we also download an OGG preview and store it in disk.\n",
    "\n",
    "This notebook uses the `freesound` Python package for interacting with the Freesound API. The source code for this package can be found here: https://github.com/mtg/freesound-python. In this repository you'll find a Python script with [examples](https://github.com/MTG/freesound-python/blob/master/examples.py) to learn how to interact with the API. Nevertheless, if you are further interested in the Freesound API, check the [API documentation](http://freesound.org/docs/api/) which provides more information.\n",
    "\n",
    "**NOTE**: A Freesound API key is provided in this notebook, but you should make a Freesound account and get your own key. You can get a key here: https://freesound.org/apiv2/apply/"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import freesound\n",
    "from IPython.display import display\n",
    "\n",
    "FREESOUND_API_KEY = 'KOZVZUGTaASpXbqEDs3AY195hM61GbyJYoPX7TBP'  # Replaced by my own Freesound API key\n",
    "FILES_DIR = 'files'  # Place where to store the downloaded diles. Will be relative to the current folder.\n",
    "DATAFRAME_FILENAME = 'dataframe.csv'  # File where we'll store the metadata of our sounds collection\n",
    "FREESOUND_STORE_METADATA_FIELDS = ['id', 'name', 'username', 'previews', 'license', 'tags', 'duration']  # Freesound metadata properties to store\n",
    "\n",
    "freesound_client = freesound.FreesoundClient()\n",
    "freesound_client.set_token(FREESOUND_API_KEY)\n",
    "if not os.path.exists(FILES_DIR): os.mkdir(FILES_DIR)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Define some util functions\n",
    "\n",
    "def query_freesound(query, filter, num_results=10):\n",
    "    \"\"\"Queries freesound with the given query and filter values.\n",
    "    If no filter is given, a default filter is added to only get sounds shorter than 30 seconds.\n",
    "    \"\"\"\n",
    "    if filter is None:\n",
    "        filter = 'duration:[0 TO 20]'  # Set default filter\n",
    "    pager = freesound_client.text_search(\n",
    "        query = query,\n",
    "        filter = filter,\n",
    "        fields = ','.join(FREESOUND_STORE_METADATA_FIELDS),\n",
    "        group_by_pack = 1,\n",
    "        page_size = num_results\n",
    "    )\n",
    "    return [sound for sound in pager]\n",
    "\n",
    "def retrieve_sound_preview(sound, directory):\n",
    "    \"\"\"Download the high-quality OGG sound preview of a given Freesound sound object to the given directory.\n",
    "    \"\"\"\n",
    "    return freesound.FSRequest.retrieve(\n",
    "        sound.previews.preview_hq_ogg,\n",
    "        freesound_client,\n",
    "        os.path.join(directory, sound.previews.preview_hq_ogg.split('/')[-1])\n",
    "    )\n",
    "\n",
    "def make_pandas_record(sound):\n",
    "    \"\"\"Create a dictionary with the metadata that we want to store for each sound.\n",
    "    \"\"\"\n",
    "    record = {key: sound.as_dict()[key] for key in FREESOUND_STORE_METADATA_FIELDS}\n",
    "    del record['previews']  # Don't store previews dict in record\n",
    "    record['freesound_id'] = record['id']  # Rename 'id' to 'freesound_id'\n",
    "    del record['id']\n",
    "    record['path'] = \"files/\" + sound.previews.preview_hq_ogg.split(\"/\")[-1]  # Store path of downloaded file\n",
    "    return record"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Downloading sound with id 333693 [1/60]\n",
      "Downloading sound with id 30160 [2/60]\n",
      "Downloading sound with id 216305 [3/60]\n",
      "Downloading sound with id 173000 [4/60]\n",
      "Downloading sound with id 318193 [5/60]\n",
      "Downloading sound with id 383593 [6/60]\n",
      "Downloading sound with id 434818 [7/60]\n",
      "Downloading sound with id 323129 [8/60]\n",
      "Downloading sound with id 258179 [9/60]\n",
      "Downloading sound with id 456565 [10/60]\n",
      "Downloading sound with id 254758 [11/60]\n",
      "Downloading sound with id 235265 [12/60]\n",
      "Downloading sound with id 121099 [13/60]\n",
      "Downloading sound with id 335090 [14/60]\n",
      "Downloading sound with id 425536 [15/60]\n",
      "Downloading sound with id 133043 [16/60]\n",
      "Downloading sound with id 171482 [17/60]\n",
      "Downloading sound with id 180278 [18/60]\n",
      "Downloading sound with id 366128 [19/60]\n",
      "Downloading sound with id 10430 [20/60]\n",
      "Downloading sound with id 381353 [21/60]\n",
      "Downloading sound with id 410516 [22/60]\n",
      "Downloading sound with id 331589 [23/60]\n",
      "Downloading sound with id 191633 [24/60]\n",
      "Downloading sound with id 139501 [25/60]\n",
      "Downloading sound with id 270090 [26/60]\n",
      "Downloading sound with id 232014 [27/60]\n",
      "Downloading sound with id 190613 [28/60]\n",
      "Downloading sound with id 16469 [29/60]\n",
      "Downloading sound with id 132580 [30/60]\n",
      "Downloading sound with id 84478 [31/60]\n",
      "Downloading sound with id 460259 [32/60]\n",
      "Downloading sound with id 106552 [33/60]\n",
      "Downloading sound with id 64651 [34/60]\n",
      "Downloading sound with id 321132 [35/60]\n",
      "Downloading sound with id 460089 [36/60]\n",
      "Downloading sound with id 168311 [37/60]\n",
      "Downloading sound with id 111202 [38/60]\n",
      "Downloading sound with id 98988 [39/60]\n",
      "Downloading sound with id 264285 [40/60]\n",
      "Downloading sound with id 100981 [41/60]\n",
      "Downloading sound with id 341507 [42/60]\n",
      "Downloading sound with id 131753 [43/60]\n",
      "Downloading sound with id 176067 [44/60]\n",
      "Downloading sound with id 172213 [45/60]\n",
      "Downloading sound with id 395737 [46/60]\n",
      "Downloading sound with id 420717 [47/60]\n",
      "Downloading sound with id 343675 [48/60]\n",
      "Downloading sound with id 2821 [49/60]\n",
      "Downloading sound with id 233453 [50/60]\n",
      "Downloading sound with id 349317 [51/60]\n",
      "Downloading sound with id 259894 [52/60]\n",
      "Downloading sound with id 121230 [53/60]\n",
      "Downloading sound with id 329072 [54/60]\n",
      "Downloading sound with id 258156 [55/60]\n",
      "Downloading sound with id 329042 [56/60]\n",
      "Downloading sound with id 255877 [57/60]\n",
      "Downloading sound with id 256528 [58/60]\n",
      "Downloading sound with id 394630 [59/60]\n",
      "Downloading sound with id 87635 [60/60]\n",
      "Saved DataFrame with 60 entries! dataframe.csv\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>duration</th>\n",
       "      <th>freesound_id</th>\n",
       "      <th>license</th>\n",
       "      <th>name</th>\n",
       "      <th>path</th>\n",
       "      <th>tags</th>\n",
       "      <th>username</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2.316190</td>\n",
       "      <td>333693</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>Thin bell ding 4</td>\n",
       "      <td>files/333693_1187042-hq.ogg</td>\n",
       "      <td>[ding, chime, short, dong, bell]</td>\n",
       "      <td>Khrinx</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.536463</td>\n",
       "      <td>30160</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>BellTinyShake.wav</td>\n",
       "      <td>files/30160_129090-hq.ogg</td>\n",
       "      <td>[bell, small]</td>\n",
       "      <td>HerbertBoland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.999600</td>\n",
       "      <td>216305</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>Calling_Bell_03.wav</td>\n",
       "      <td>files/216305_3761494-hq.ogg</td>\n",
       "      <td>[Antique, Plate, Ringing, Bell]</td>\n",
       "      <td>RSilveira_88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.334650</td>\n",
       "      <td>173000</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>Bicycle bell 2.wav</td>\n",
       "      <td>files/173000_2193194-hq.ogg</td>\n",
       "      <td>[chime, bicycle, bell]</td>\n",
       "      <td>KeyKrusher</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.477170</td>\n",
       "      <td>318193</td>\n",
       "      <td>http://creativecommons.org/licenses/by-nc/3.0/</td>\n",
       "      <td>05969 common bicycle bell.wav</td>\n",
       "      <td>files/318193_321967-hq.ogg</td>\n",
       "      <td>[bicycle, bell, warn, bike, common, ring]</td>\n",
       "      <td>Robinhood76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2.917150</td>\n",
       "      <td>383593</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>bicycle-bell_04.wav</td>\n",
       "      <td>files/383593_4067257-hq.ogg</td>\n",
       "      <td>[contact, metal, glockenspiel, clang, high-pit...</td>\n",
       "      <td>newagesoup</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2.213250</td>\n",
       "      <td>434818</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>Bike bell</td>\n",
       "      <td>files/434818_1992856-hq.ogg</td>\n",
       "      <td>[bells, ring, bike, bell, ringing, bicycle, go...</td>\n",
       "      <td>dersuperanton</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2.673990</td>\n",
       "      <td>323129</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>Bicycle_Bell_from_BikeKitchen_Augsburg_09.wav</td>\n",
       "      <td>files/323129_4438201-hq.ogg</td>\n",
       "      <td>[bicycle, bell, street, metallic, bike, mechan...</td>\n",
       "      <td>geraldfiebig</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1.109190</td>\n",
       "      <td>258179</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>BellPing2.flac</td>\n",
       "      <td>files/258179_4486188-hq.ogg</td>\n",
       "      <td>[ding, ringing, bell, 706, ping, telephone, ri...</td>\n",
       "      <td>kwahmah_02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1.088210</td>\n",
       "      <td>456565</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>bell1.wav</td>\n",
       "      <td>files/456565_5052309-hq.ogg</td>\n",
       "      <td>[bell, electronic, chime]</td>\n",
       "      <td>bumpelsnake</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2.997050</td>\n",
       "      <td>254758</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>Ceramic Bell 08</td>\n",
       "      <td>files/254758_4062622-hq.ogg</td>\n",
       "      <td>[groovy, drum, bell, ceramic, metal, percussio...</td>\n",
       "      <td>Jagadamba</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2.127120</td>\n",
       "      <td>235265</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>bell2.wav</td>\n",
       "      <td>files/235265_1662097-hq.ogg</td>\n",
       "      <td>[phone, rotary, Telephone, bell]</td>\n",
       "      <td>Godowan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2.037551</td>\n",
       "      <td>121099</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>sleigh bells.wav</td>\n",
       "      <td>files/121099_2193266-hq.ogg</td>\n",
       "      <td>[bell, bells, rhythm, sample, samples]</td>\n",
       "      <td>Thirsk</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2.836170</td>\n",
       "      <td>335090</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>bell.wav</td>\n",
       "      <td>files/335090_4960771-hq.ogg</td>\n",
       "      <td>[ring, bells, ringing, bell]</td>\n",
       "      <td>rnl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2.130050</td>\n",
       "      <td>425536</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>bell.mp3</td>\n",
       "      <td>files/425536_8477087-hq.ogg</td>\n",
       "      <td>[bell, ring, beeping, school, beep]</td>\n",
       "      <td>MiaE012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1.898050</td>\n",
       "      <td>133043</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>Bell 1.wav</td>\n",
       "      <td>files/133043_920451-hq.ogg</td>\n",
       "      <td>[chime, ring, bell]</td>\n",
       "      <td>temawas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1.500000</td>\n",
       "      <td>171482</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>Savannah Bell.wav</td>\n",
       "      <td>files/171482_2565043-hq.ogg</td>\n",
       "      <td>[Savannah, Cymbal, Ride, Bell]</td>\n",
       "      <td>xIceCoffeex</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1.335150</td>\n",
       "      <td>180278</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>surreal bell</td>\n",
       "      <td>files/180278_284829-hq.ogg</td>\n",
       "      <td>[surreal, dirty, bell]</td>\n",
       "      <td>rodny5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2.500000</td>\n",
       "      <td>366128</td>\n",
       "      <td>http://creativecommons.org/licenses/by-nc/3.0/</td>\n",
       "      <td>Bike Bell</td>\n",
       "      <td>files/366128_6034770-hq.ogg</td>\n",
       "      <td>[OWI, Bell, Ringing, toy, Memories, Kids-toy]</td>\n",
       "      <td>Twiggie2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2.185896</td>\n",
       "      <td>10430</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>gbell_7-2_pp.aif</td>\n",
       "      <td>files/10430_186-hq.ogg</td>\n",
       "      <td>[bell, double-bell, ghana, gogo, metalic, perc...</td>\n",
       "      <td>batchku</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2.016830</td>\n",
       "      <td>381353</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>120 BPM Basic Drum loop</td>\n",
       "      <td>files/381353_1676145-hq.ogg</td>\n",
       "      <td>[loop, electronic, electro, dance, Basic, rhyt...</td>\n",
       "      <td>waveplay_old</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2.718910</td>\n",
       "      <td>410516</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>Snare Drum, Multi Hits, A (H1).wav</td>\n",
       "      <td>files/410516_5121236-hq.ogg</td>\n",
       "      <td>[snare, Snare, Drum, percussion, Drumstick, dr...</td>\n",
       "      <td>InspectorJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2.243790</td>\n",
       "      <td>331589</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>Kick J.Zealous Hard Club.aif</td>\n",
       "      <td>files/331589_5820980-hq.ogg</td>\n",
       "      <td>[Drum, free, kickdrum, drum, kick-drum, kick, ...</td>\n",
       "      <td>J_Zealous</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1.451610</td>\n",
       "      <td>191633</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>jhd_cym_1.wav</td>\n",
       "      <td>files/191633_2394245-hq.ogg</td>\n",
       "      <td>[drums, demo, deep, Roland, claps, mpc60, vox,...</td>\n",
       "      <td>DWSD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>139501</td>\n",
       "      <td>http://creativecommons.org/licenses/by-nc/3.0/</td>\n",
       "      <td>Big Hit 1.wav</td>\n",
       "      <td>files/139501_2481923-hq.ogg</td>\n",
       "      <td>[sound, big, Drum, drum]</td>\n",
       "      <td>robertmcdonald</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1.015080</td>\n",
       "      <td>270090</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>Drumsticks [Dave Weckl Evolution] simple one №...</td>\n",
       "      <td>files/270090_1125482-hq.ogg</td>\n",
       "      <td>[drum, shot, metronome, turks, Cooper, wenge, ...</td>\n",
       "      <td>Theriavirra</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1.066110</td>\n",
       "      <td>232014</td>\n",
       "      <td>http://creativecommons.org/licenses/by-nc/3.0/</td>\n",
       "      <td>Ambassador-6.wav - Saturated</td>\n",
       "      <td>files/232014_736471-hq.ogg</td>\n",
       "      <td>[GS, drum, Drum, 96-24, MIDI, Custom, percussi...</td>\n",
       "      <td>Seidhepriest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1.850950</td>\n",
       "      <td>190613</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>Drums</td>\n",
       "      <td>files/190613_3172867-hq.ogg</td>\n",
       "      <td>[Drum, Hi-Hats, J-Lee, Hi, 4x4-Records, Drums,...</td>\n",
       "      <td>Goup_1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2.278435</td>\n",
       "      <td>16469</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>Basic Easy-100-drum.wav</td>\n",
       "      <td>files/16469_52391-hq.ogg</td>\n",
       "      <td>[drum, house, loop]</td>\n",
       "      <td>visual</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1.440000</td>\n",
       "      <td>132580</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>Kick Drum C0</td>\n",
       "      <td>files/132580_2409787-hq.ogg</td>\n",
       "      <td>[shot, one, sample, Basic, Drum, Kick]</td>\n",
       "      <td>Rob10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1.050000</td>\n",
       "      <td>84478</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>DRUM FX 2.wav</td>\n",
       "      <td>files/84478_377011-hq.ogg</td>\n",
       "      <td>[drum, fx]</td>\n",
       "      <td>zgump</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>1.490700</td>\n",
       "      <td>460259</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>Bass Drum MiniMoog 004</td>\n",
       "      <td>files/460259_4448255-hq.ogg</td>\n",
       "      <td>[kick, kick-drum, minimoog, kickdrum, bass-dru...</td>\n",
       "      <td>ANARKYA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1.612494</td>\n",
       "      <td>106552</td>\n",
       "      <td>http://creativecommons.org/licenses/sampling+/...</td>\n",
       "      <td>DrumLoop1.wav</td>\n",
       "      <td>files/106552_1826123-hq.ogg</td>\n",
       "      <td>[beat, drum, jazz, loop]</td>\n",
       "      <td>Th3R3m1x3d</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>1.714292</td>\n",
       "      <td>64651</td>\n",
       "      <td>http://creativecommons.org/licenses/sampling+/...</td>\n",
       "      <td>drum_loops_12.wav</td>\n",
       "      <td>files/64651_846180-hq.ogg</td>\n",
       "      <td>[drum, loop]</td>\n",
       "      <td>casualsamples</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2.347390</td>\n",
       "      <td>321132</td>\n",
       "      <td>http://creativecommons.org/licenses/by-nc/3.0/</td>\n",
       "      <td>Shaman's drum</td>\n",
       "      <td>files/321132_1337335-hq.ogg</td>\n",
       "      <td>[shaman, s, drum]</td>\n",
       "      <td>meisterjaan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2.837960</td>\n",
       "      <td>460089</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>African Drum6.WAV</td>\n",
       "      <td>files/460089_1764667-hq.ogg</td>\n",
       "      <td>[african, percussion, skindrum, drum, handdrum...</td>\n",
       "      <td>eyenorth</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2.032000</td>\n",
       "      <td>168311</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>EH CRASH DRUM3.wav</td>\n",
       "      <td>files/168311_599528-hq.ogg</td>\n",
       "      <td>[drum, electro, crash, harmonix]</td>\n",
       "      <td>likeclockwork</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>1.231000</td>\n",
       "      <td>111202</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>Bass.wav</td>\n",
       "      <td>files/111202_1853660-hq.ogg</td>\n",
       "      <td>[bass, drum, kick, lo-fi]</td>\n",
       "      <td>CorrodedMaster</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2.400000</td>\n",
       "      <td>98988</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>100 Crisp Classic Drums 01.wav</td>\n",
       "      <td>files/98988_1603602-hq.ogg</td>\n",
       "      <td>[808, 909, crisp, drum, drums, free, machine, ...</td>\n",
       "      <td>gunnbladez</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>1.500000</td>\n",
       "      <td>264285</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>Deep House Kick Drum 1</td>\n",
       "      <td>files/264285_1126957-hq.ogg</td>\n",
       "      <td>[Heavy, Electric-Dance-Music, Matt, Hit, Sub, ...</td>\n",
       "      <td>Mattc90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>1.004694</td>\n",
       "      <td>100981</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>Atari Speech.wav</td>\n",
       "      <td>files/100981_1234256-hq.ogg</td>\n",
       "      <td>[8-bit, atari, engine, speech, steem, texttosp...</td>\n",
       "      <td>mo_damage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>1.846060</td>\n",
       "      <td>341507</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>Speech_Signal_Processing_Male.wav</td>\n",
       "      <td>files/341507_5871007-hq.ogg</td>\n",
       "      <td>[DPSA, Male, Speech]</td>\n",
       "      <td>dpsa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>2.711000</td>\n",
       "      <td>131753</td>\n",
       "      <td>http://creativecommons.org/licenses/by-nc/3.0/</td>\n",
       "      <td>HazMat or Substances</td>\n",
       "      <td>files/131753_450294-hq.ogg</td>\n",
       "      <td>[hazmat, emergency, danger, text, spill, accen...</td>\n",
       "      <td>JohnLaVine333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>1.595000</td>\n",
       "      <td>176067</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>Hi, how are you doing (COMPUTER)</td>\n",
       "      <td>files/176067_3230914-hq.ogg</td>\n",
       "      <td>[computer, greeting, robot, hi, speech, hello]</td>\n",
       "      <td>xxxTruthxxx</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2.997800</td>\n",
       "      <td>172213</td>\n",
       "      <td>http://creativecommons.org/licenses/by-nc/3.0/</td>\n",
       "      <td>MerryChristmasDarling.wav</td>\n",
       "      <td>files/172213_37876-hq.ogg</td>\n",
       "      <td>[female, woman, speech, Christmas, talk]</td>\n",
       "      <td>acclivity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>2.899980</td>\n",
       "      <td>395737</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>Gotowe</td>\n",
       "      <td>files/395737_4492939-hq.ogg</td>\n",
       "      <td>[tada, male, polish, speech, vocal, spoken, vo...</td>\n",
       "      <td>krzysiunet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>1.413470</td>\n",
       "      <td>420717</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>exterminate.wav</td>\n",
       "      <td>files/420717_1015240-hq.ogg</td>\n",
       "      <td>[exterminate, Atari, speech, computer, robotic]</td>\n",
       "      <td>Timbre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>2.514370</td>\n",
       "      <td>343675</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>sp07.wav</td>\n",
       "      <td>files/343675_5871007-hq.ogg</td>\n",
       "      <td>[dpsa, speech, Clean]</td>\n",
       "      <td>dpsa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>1.313107</td>\n",
       "      <td>2821</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>attgirl1stretch.wav</td>\n",
       "      <td>files/2821_4948-hq.ogg</td>\n",
       "      <td>[female, free, girl, robot, sample, sound, spe...</td>\n",
       "      <td>NoiseCollector</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>2.477980</td>\n",
       "      <td>233453</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>Teacher speech.wav</td>\n",
       "      <td>files/233453_4217287-hq.ogg</td>\n",
       "      <td>[woman, students, roc-boronat, vocal, teacher,...</td>\n",
       "      <td>dmadridp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>2.019210</td>\n",
       "      <td>349317</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>ALL-YOUR-BASE-ARE-BELONG-TO-US_ROBOT_VOICE_ZAR...</td>\n",
       "      <td>files/349317_4067257-hq.ogg</td>\n",
       "      <td>[hundred, word, synthesized, spoken, robotic, ...</td>\n",
       "      <td>newagesoup</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>2.380050</td>\n",
       "      <td>259894</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>speech-transformed-1.wav</td>\n",
       "      <td>files/259894_4435335-hq.ogg</td>\n",
       "      <td>[hps-model, ASPMA, sms-tools, woman, speech, f...</td>\n",
       "      <td>Soundatic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>2.996417</td>\n",
       "      <td>121230</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>allthepeople1.wav</td>\n",
       "      <td>files/121230_81909-hq.ogg</td>\n",
       "      <td>[1-bit, lo-fi, rave, retro, sinclair, speech, ...</td>\n",
       "      <td>irrlicht</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>2.391660</td>\n",
       "      <td>329072</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>speech-female_hpsModelTransformation.wav</td>\n",
       "      <td>files/329072_5702398-hq.ogg</td>\n",
       "      <td>[Week8, ASPMA, Speech, Female]</td>\n",
       "      <td>Thomas1090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>1.561540</td>\n",
       "      <td>258156</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>speech-transformed-1.wav</td>\n",
       "      <td>files/258156_4819188-hq.ogg</td>\n",
       "      <td>[speech, time-scaling, 44100, female, Hammer0nZ]</td>\n",
       "      <td>Hammer0nZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>1.706670</td>\n",
       "      <td>329042</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>ave maria speech.wav</td>\n",
       "      <td>files/329042_5701156-hq.ogg</td>\n",
       "      <td>[male, talking, speech, human, voice, talk]</td>\n",
       "      <td>islijepcevic</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>1.622470</td>\n",
       "      <td>255877</td>\n",
       "      <td>http://creativecommons.org/licenses/by/3.0/</td>\n",
       "      <td>Female Voice whispering Lab Geaks</td>\n",
       "      <td>files/255877_4062622-hq.ogg</td>\n",
       "      <td>[male, vocal-sample, spoken, voice, vocal, mal...</td>\n",
       "      <td>Jagadamba</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>2.295870</td>\n",
       "      <td>256528</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>speech-female_hpsModelTransformation.wav</td>\n",
       "      <td>files/256528_4756180-hq.ogg</td>\n",
       "      <td>[vocal, sms-tools, speech, female, voice, tran...</td>\n",
       "      <td>WantingChen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>2.992470</td>\n",
       "      <td>394630</td>\n",
       "      <td>http://creativecommons.org/publicdomain/zero/1.0/</td>\n",
       "      <td>speech-female_hpsModelTransformation.wav</td>\n",
       "      <td>files/394630_7394089-hq.ogg</td>\n",
       "      <td>[female, transformation, speech, aspma-16-resu...</td>\n",
       "      <td>skvortsovg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>1.147052</td>\n",
       "      <td>87635</td>\n",
       "      <td>http://creativecommons.org/licenses/sampling+/...</td>\n",
       "      <td>o_oberta.wav</td>\n",
       "      <td>files/87635_1266174-hq.ogg</td>\n",
       "      <td>[catalan, male, o, open, sexy, speech, voice]</td>\n",
       "      <td>kornuman</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    duration  freesound_id                                            license  \\\n",
       "0   2.316190        333693  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "1   2.536463         30160        http://creativecommons.org/licenses/by/3.0/   \n",
       "2   1.999600        216305        http://creativecommons.org/licenses/by/3.0/   \n",
       "3   1.334650        173000        http://creativecommons.org/licenses/by/3.0/   \n",
       "4   1.477170        318193     http://creativecommons.org/licenses/by-nc/3.0/   \n",
       "5   2.917150        383593  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "6   2.213250        434818        http://creativecommons.org/licenses/by/3.0/   \n",
       "7   2.673990        323129  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "8   1.109190        258179        http://creativecommons.org/licenses/by/3.0/   \n",
       "9   1.088210        456565        http://creativecommons.org/licenses/by/3.0/   \n",
       "10  2.997050        254758        http://creativecommons.org/licenses/by/3.0/   \n",
       "11  2.127120        235265  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "12  2.037551        121099        http://creativecommons.org/licenses/by/3.0/   \n",
       "13  2.836170        335090  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "14  2.130050        425536  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "15  1.898050        133043  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "16  1.500000        171482  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "17  1.335150        180278  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "18  2.500000        366128     http://creativecommons.org/licenses/by-nc/3.0/   \n",
       "19  2.185896         10430  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "20  2.016830        381353        http://creativecommons.org/licenses/by/3.0/   \n",
       "21  2.718910        410516        http://creativecommons.org/licenses/by/3.0/   \n",
       "22  2.243790        331589  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "23  1.451610        191633        http://creativecommons.org/licenses/by/3.0/   \n",
       "24  2.000000        139501     http://creativecommons.org/licenses/by-nc/3.0/   \n",
       "25  1.015080        270090        http://creativecommons.org/licenses/by/3.0/   \n",
       "26  1.066110        232014     http://creativecommons.org/licenses/by-nc/3.0/   \n",
       "27  1.850950        190613        http://creativecommons.org/licenses/by/3.0/   \n",
       "28  2.278435         16469  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "29  1.440000        132580  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "30  1.050000         84478  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "31  1.490700        460259  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "32  1.612494        106552  http://creativecommons.org/licenses/sampling+/...   \n",
       "33  1.714292         64651  http://creativecommons.org/licenses/sampling+/...   \n",
       "34  2.347390        321132     http://creativecommons.org/licenses/by-nc/3.0/   \n",
       "35  2.837960        460089        http://creativecommons.org/licenses/by/3.0/   \n",
       "36  2.032000        168311  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "37  1.231000        111202        http://creativecommons.org/licenses/by/3.0/   \n",
       "38  2.400000         98988        http://creativecommons.org/licenses/by/3.0/   \n",
       "39  1.500000        264285  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "40  1.004694        100981  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "41  1.846060        341507        http://creativecommons.org/licenses/by/3.0/   \n",
       "42  2.711000        131753     http://creativecommons.org/licenses/by-nc/3.0/   \n",
       "43  1.595000        176067  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "44  2.997800        172213     http://creativecommons.org/licenses/by-nc/3.0/   \n",
       "45  2.899980        395737        http://creativecommons.org/licenses/by/3.0/   \n",
       "46  1.413470        420717  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "47  2.514370        343675        http://creativecommons.org/licenses/by/3.0/   \n",
       "48  1.313107          2821        http://creativecommons.org/licenses/by/3.0/   \n",
       "49  2.477980        233453        http://creativecommons.org/licenses/by/3.0/   \n",
       "50  2.019210        349317  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "51  2.380050        259894        http://creativecommons.org/licenses/by/3.0/   \n",
       "52  2.996417        121230        http://creativecommons.org/licenses/by/3.0/   \n",
       "53  2.391660        329072        http://creativecommons.org/licenses/by/3.0/   \n",
       "54  1.561540        258156        http://creativecommons.org/licenses/by/3.0/   \n",
       "55  1.706670        329042  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "56  1.622470        255877        http://creativecommons.org/licenses/by/3.0/   \n",
       "57  2.295870        256528  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "58  2.992470        394630  http://creativecommons.org/publicdomain/zero/1.0/   \n",
       "59  1.147052         87635  http://creativecommons.org/licenses/sampling+/...   \n",
       "\n",
       "                                                 name  \\\n",
       "0                                    Thin bell ding 4   \n",
       "1                                   BellTinyShake.wav   \n",
       "2                                 Calling_Bell_03.wav   \n",
       "3                                  Bicycle bell 2.wav   \n",
       "4                       05969 common bicycle bell.wav   \n",
       "5                                 bicycle-bell_04.wav   \n",
       "6                                           Bike bell   \n",
       "7       Bicycle_Bell_from_BikeKitchen_Augsburg_09.wav   \n",
       "8                                      BellPing2.flac   \n",
       "9                                           bell1.wav   \n",
       "10                                    Ceramic Bell 08   \n",
       "11                                          bell2.wav   \n",
       "12                                   sleigh bells.wav   \n",
       "13                                           bell.wav   \n",
       "14                                           bell.mp3   \n",
       "15                                         Bell 1.wav   \n",
       "16                                  Savannah Bell.wav   \n",
       "17                                       surreal bell   \n",
       "18                                          Bike Bell   \n",
       "19                                   gbell_7-2_pp.aif   \n",
       "20                            120 BPM Basic Drum loop   \n",
       "21                 Snare Drum, Multi Hits, A (H1).wav   \n",
       "22                       Kick J.Zealous Hard Club.aif   \n",
       "23                                      jhd_cym_1.wav   \n",
       "24                                      Big Hit 1.wav   \n",
       "25  Drumsticks [Dave Weckl Evolution] simple one №...   \n",
       "26                       Ambassador-6.wav - Saturated   \n",
       "27                                              Drums   \n",
       "28                            Basic Easy-100-drum.wav   \n",
       "29                                       Kick Drum C0   \n",
       "30                                      DRUM FX 2.wav   \n",
       "31                             Bass Drum MiniMoog 004   \n",
       "32                                      DrumLoop1.wav   \n",
       "33                                  drum_loops_12.wav   \n",
       "34                                      Shaman's drum   \n",
       "35                                  African Drum6.WAV   \n",
       "36                                 EH CRASH DRUM3.wav   \n",
       "37                                           Bass.wav   \n",
       "38                     100 Crisp Classic Drums 01.wav   \n",
       "39                             Deep House Kick Drum 1   \n",
       "40                                   Atari Speech.wav   \n",
       "41                  Speech_Signal_Processing_Male.wav   \n",
       "42                               HazMat or Substances   \n",
       "43                   Hi, how are you doing (COMPUTER)   \n",
       "44                          MerryChristmasDarling.wav   \n",
       "45                                             Gotowe   \n",
       "46                                    exterminate.wav   \n",
       "47                                           sp07.wav   \n",
       "48                                attgirl1stretch.wav   \n",
       "49                                 Teacher speech.wav   \n",
       "50  ALL-YOUR-BASE-ARE-BELONG-TO-US_ROBOT_VOICE_ZAR...   \n",
       "51                           speech-transformed-1.wav   \n",
       "52                                  allthepeople1.wav   \n",
       "53           speech-female_hpsModelTransformation.wav   \n",
       "54                           speech-transformed-1.wav   \n",
       "55                               ave maria speech.wav   \n",
       "56                  Female Voice whispering Lab Geaks   \n",
       "57           speech-female_hpsModelTransformation.wav   \n",
       "58           speech-female_hpsModelTransformation.wav   \n",
       "59                                       o_oberta.wav   \n",
       "\n",
       "                           path  \\\n",
       "0   files/333693_1187042-hq.ogg   \n",
       "1     files/30160_129090-hq.ogg   \n",
       "2   files/216305_3761494-hq.ogg   \n",
       "3   files/173000_2193194-hq.ogg   \n",
       "4    files/318193_321967-hq.ogg   \n",
       "5   files/383593_4067257-hq.ogg   \n",
       "6   files/434818_1992856-hq.ogg   \n",
       "7   files/323129_4438201-hq.ogg   \n",
       "8   files/258179_4486188-hq.ogg   \n",
       "9   files/456565_5052309-hq.ogg   \n",
       "10  files/254758_4062622-hq.ogg   \n",
       "11  files/235265_1662097-hq.ogg   \n",
       "12  files/121099_2193266-hq.ogg   \n",
       "13  files/335090_4960771-hq.ogg   \n",
       "14  files/425536_8477087-hq.ogg   \n",
       "15   files/133043_920451-hq.ogg   \n",
       "16  files/171482_2565043-hq.ogg   \n",
       "17   files/180278_284829-hq.ogg   \n",
       "18  files/366128_6034770-hq.ogg   \n",
       "19       files/10430_186-hq.ogg   \n",
       "20  files/381353_1676145-hq.ogg   \n",
       "21  files/410516_5121236-hq.ogg   \n",
       "22  files/331589_5820980-hq.ogg   \n",
       "23  files/191633_2394245-hq.ogg   \n",
       "24  files/139501_2481923-hq.ogg   \n",
       "25  files/270090_1125482-hq.ogg   \n",
       "26   files/232014_736471-hq.ogg   \n",
       "27  files/190613_3172867-hq.ogg   \n",
       "28     files/16469_52391-hq.ogg   \n",
       "29  files/132580_2409787-hq.ogg   \n",
       "30    files/84478_377011-hq.ogg   \n",
       "31  files/460259_4448255-hq.ogg   \n",
       "32  files/106552_1826123-hq.ogg   \n",
       "33    files/64651_846180-hq.ogg   \n",
       "34  files/321132_1337335-hq.ogg   \n",
       "35  files/460089_1764667-hq.ogg   \n",
       "36   files/168311_599528-hq.ogg   \n",
       "37  files/111202_1853660-hq.ogg   \n",
       "38   files/98988_1603602-hq.ogg   \n",
       "39  files/264285_1126957-hq.ogg   \n",
       "40  files/100981_1234256-hq.ogg   \n",
       "41  files/341507_5871007-hq.ogg   \n",
       "42   files/131753_450294-hq.ogg   \n",
       "43  files/176067_3230914-hq.ogg   \n",
       "44    files/172213_37876-hq.ogg   \n",
       "45  files/395737_4492939-hq.ogg   \n",
       "46  files/420717_1015240-hq.ogg   \n",
       "47  files/343675_5871007-hq.ogg   \n",
       "48       files/2821_4948-hq.ogg   \n",
       "49  files/233453_4217287-hq.ogg   \n",
       "50  files/349317_4067257-hq.ogg   \n",
       "51  files/259894_4435335-hq.ogg   \n",
       "52    files/121230_81909-hq.ogg   \n",
       "53  files/329072_5702398-hq.ogg   \n",
       "54  files/258156_4819188-hq.ogg   \n",
       "55  files/329042_5701156-hq.ogg   \n",
       "56  files/255877_4062622-hq.ogg   \n",
       "57  files/256528_4756180-hq.ogg   \n",
       "58  files/394630_7394089-hq.ogg   \n",
       "59   files/87635_1266174-hq.ogg   \n",
       "\n",
       "                                                 tags        username  \n",
       "0                    [ding, chime, short, dong, bell]          Khrinx  \n",
       "1                                       [bell, small]   HerbertBoland  \n",
       "2                     [Antique, Plate, Ringing, Bell]    RSilveira_88  \n",
       "3                              [chime, bicycle, bell]      KeyKrusher  \n",
       "4           [bicycle, bell, warn, bike, common, ring]     Robinhood76  \n",
       "5   [contact, metal, glockenspiel, clang, high-pit...      newagesoup  \n",
       "6   [bells, ring, bike, bell, ringing, bicycle, go...   dersuperanton  \n",
       "7   [bicycle, bell, street, metallic, bike, mechan...    geraldfiebig  \n",
       "8   [ding, ringing, bell, 706, ping, telephone, ri...      kwahmah_02  \n",
       "9                           [bell, electronic, chime]     bumpelsnake  \n",
       "10  [groovy, drum, bell, ceramic, metal, percussio...       Jagadamba  \n",
       "11                   [phone, rotary, Telephone, bell]         Godowan  \n",
       "12             [bell, bells, rhythm, sample, samples]          Thirsk  \n",
       "13                       [ring, bells, ringing, bell]             rnl  \n",
       "14                [bell, ring, beeping, school, beep]         MiaE012  \n",
       "15                                [chime, ring, bell]         temawas  \n",
       "16                     [Savannah, Cymbal, Ride, Bell]     xIceCoffeex  \n",
       "17                             [surreal, dirty, bell]          rodny5  \n",
       "18      [OWI, Bell, Ringing, toy, Memories, Kids-toy]     Twiggie2000  \n",
       "19  [bell, double-bell, ghana, gogo, metalic, perc...         batchku  \n",
       "20  [loop, electronic, electro, dance, Basic, rhyt...    waveplay_old  \n",
       "21  [snare, Snare, Drum, percussion, Drumstick, dr...      InspectorJ  \n",
       "22  [Drum, free, kickdrum, drum, kick-drum, kick, ...       J_Zealous  \n",
       "23  [drums, demo, deep, Roland, claps, mpc60, vox,...            DWSD  \n",
       "24                           [sound, big, Drum, drum]  robertmcdonald  \n",
       "25  [drum, shot, metronome, turks, Cooper, wenge, ...     Theriavirra  \n",
       "26  [GS, drum, Drum, 96-24, MIDI, Custom, percussi...    Seidhepriest  \n",
       "27  [Drum, Hi-Hats, J-Lee, Hi, 4x4-Records, Drums,...          Goup_1  \n",
       "28                                [drum, house, loop]          visual  \n",
       "29             [shot, one, sample, Basic, Drum, Kick]           Rob10  \n",
       "30                                         [drum, fx]           zgump  \n",
       "31  [kick, kick-drum, minimoog, kickdrum, bass-dru...         ANARKYA  \n",
       "32                           [beat, drum, jazz, loop]      Th3R3m1x3d  \n",
       "33                                       [drum, loop]   casualsamples  \n",
       "34                                  [shaman, s, drum]     meisterjaan  \n",
       "35  [african, percussion, skindrum, drum, handdrum...        eyenorth  \n",
       "36                   [drum, electro, crash, harmonix]   likeclockwork  \n",
       "37                          [bass, drum, kick, lo-fi]  CorrodedMaster  \n",
       "38  [808, 909, crisp, drum, drums, free, machine, ...      gunnbladez  \n",
       "39  [Heavy, Electric-Dance-Music, Matt, Hit, Sub, ...         Mattc90  \n",
       "40  [8-bit, atari, engine, speech, steem, texttosp...       mo_damage  \n",
       "41                               [DPSA, Male, Speech]            dpsa  \n",
       "42  [hazmat, emergency, danger, text, spill, accen...   JohnLaVine333  \n",
       "43     [computer, greeting, robot, hi, speech, hello]     xxxTruthxxx  \n",
       "44           [female, woman, speech, Christmas, talk]       acclivity  \n",
       "45  [tada, male, polish, speech, vocal, spoken, vo...      krzysiunet  \n",
       "46    [exterminate, Atari, speech, computer, robotic]          Timbre  \n",
       "47                              [dpsa, speech, Clean]            dpsa  \n",
       "48  [female, free, girl, robot, sample, sound, spe...  NoiseCollector  \n",
       "49  [woman, students, roc-boronat, vocal, teacher,...        dmadridp  \n",
       "50  [hundred, word, synthesized, spoken, robotic, ...      newagesoup  \n",
       "51  [hps-model, ASPMA, sms-tools, woman, speech, f...       Soundatic  \n",
       "52  [1-bit, lo-fi, rave, retro, sinclair, speech, ...        irrlicht  \n",
       "53                     [Week8, ASPMA, Speech, Female]      Thomas1090  \n",
       "54   [speech, time-scaling, 44100, female, Hammer0nZ]       Hammer0nZ  \n",
       "55        [male, talking, speech, human, voice, talk]    islijepcevic  \n",
       "56  [male, vocal-sample, spoken, voice, vocal, mal...       Jagadamba  \n",
       "57  [vocal, sms-tools, speech, female, voice, tran...     WantingChen  \n",
       "58  [female, transformation, speech, aspma-16-resu...      skvortsovg  \n",
       "59      [catalan, male, o, open, sexy, speech, voice]        kornuman  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Build our collection of sounds\n",
    "\n",
    "# Our collection of sounds is made by appending the results of a number of different queries to freesound\n",
    "# The query terms, query filters and the number of results per query are all defined here.\n",
    "# Information about how to define filters can be found in the Freesound API documentation: https://freesound.org/docs/api/resources_apiv2.html#request-parameters-text-search-parameters\n",
    "freesound_queries = [\n",
    "    {\n",
    "        'query': 'bell',\n",
    "        'filter': 'duration:[1 TO 3]',\n",
    "        'num_results': 20, \n",
    "    },\n",
    "    {\n",
    "        'query': 'drum',\n",
    "        'filter': 'duration:[1 TO 3]',\n",
    "        'num_results': 20, \n",
    "    },\n",
    "    {\n",
    "        'query': 'speech',\n",
    "        'filter': 'duration:[1 TO 3]',\n",
    "        'num_results': 20, \n",
    "    },\n",
    "]\n",
    "\n",
    "# Do all queries and concatenate the results in a single list of sounds\n",
    "sounds = sum([query_freesound(query['query'], query['filter'], query['num_results']) for query in freesound_queries],[])\n",
    "\n",
    "# Download the sounds and save them to FILES_DIR folder\n",
    "for count, sound in enumerate(sounds):\n",
    "    print('Downloading sound with id {0} [{1}/{2}]'.format(sound.id, count + 1, len(sounds)))\n",
    "    retrieve_sound_preview(sound, 'files/')\n",
    "    \n",
    "# Make a Pandas DataFrame with the metadata of our sound collection and save it\n",
    "df =  pd.DataFrame([make_pandas_record(s) for s in sounds])\n",
    "df.to_csv(DATAFRAME_FILENAME)\n",
    "print('Saved DataFrame with {0} entries! {1}'.format(len(df), DATAFRAME_FILENAME))\n",
    "\n",
    "# Show the contents of our DataFrame (the metadata of our source collection)\n",
    "display(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}