model.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "FILE_ATTRIBUTES = \"attributes.csv\"\n",
    "FILE_LABELS = \"labels_with_audio_path.csv\""
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Processing Acoustic Attributes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "columns = ['item',\n",
    " 'duration',\n",
    " 'meanfreq',\n",
    " 'sd',\n",
    " 'median',\n",
    " 'Q25',\n",
    " 'Q75',\n",
    " 'IQR',\n",
    " 'skew',\n",
    " 'kurt',\n",
    " 'sp.ent',\n",
    " 'sfm',\n",
    " 'mode',\n",
    " 'centroid',\n",
    " 'meanfun',\n",
    " 'minfun',\n",
    " 'maxfun',\n",
    " 'meandom',\n",
    " 'mindom',\n",
    " 'maxdom',\n",
    " 'dfrange',\n",
    " 'modindx']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>item</th>\n",
       "      <th>duration</th>\n",
       "      <th>meanfreq</th>\n",
       "      <th>sd</th>\n",
       "      <th>median</th>\n",
       "      <th>Q25</th>\n",
       "      <th>Q75</th>\n",
       "      <th>IQR</th>\n",
       "      <th>skew</th>\n",
       "      <th>kurt</th>\n",
       "      <th>...</th>\n",
       "      <th>mode</th>\n",
       "      <th>centroid</th>\n",
       "      <th>meanfun</th>\n",
       "      <th>minfun</th>\n",
       "      <th>maxfun</th>\n",
       "      <th>meandom</th>\n",
       "      <th>mindom</th>\n",
       "      <th>maxdom</th>\n",
       "      <th>dfrange</th>\n",
       "      <th>modindx</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_10.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.171924</td>\n",
       "      <td>0.084798</td>\n",
       "      <td>0.191168</td>\n",
       "      <td>0.097835</td>\n",
       "      <td>0.251890</td>\n",
       "      <td>0.154055</td>\n",
       "      <td>2.158582</td>\n",
       "      <td>8.769025</td>\n",
       "      <td>...</td>\n",
       "      <td>0.255091</td>\n",
       "      <td>0.171924</td>\n",
       "      <td>0.118349</td>\n",
       "      <td>0.043151</td>\n",
       "      <td>0.279114</td>\n",
       "      <td>1.370654</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.007764</td>\n",
       "      <td>6.007764</td>\n",
       "      <td>0.140773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_11.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.119687</td>\n",
       "      <td>0.084263</td>\n",
       "      <td>0.100236</td>\n",
       "      <td>0.044716</td>\n",
       "      <td>0.184466</td>\n",
       "      <td>0.139750</td>\n",
       "      <td>0.832820</td>\n",
       "      <td>3.587928</td>\n",
       "      <td>...</td>\n",
       "      <td>0.102637</td>\n",
       "      <td>0.119687</td>\n",
       "      <td>0.122129</td>\n",
       "      <td>0.043793</td>\n",
       "      <td>0.279114</td>\n",
       "      <td>0.730685</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.306641</td>\n",
       "      <td>4.306641</td>\n",
       "      <td>0.119247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_12.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.151992</td>\n",
       "      <td>0.079224</td>\n",
       "      <td>0.147153</td>\n",
       "      <td>0.092833</td>\n",
       "      <td>0.228382</td>\n",
       "      <td>0.135548</td>\n",
       "      <td>2.086398</td>\n",
       "      <td>11.305400</td>\n",
       "      <td>...</td>\n",
       "      <td>0.102537</td>\n",
       "      <td>0.151992</td>\n",
       "      <td>0.113303</td>\n",
       "      <td>0.043235</td>\n",
       "      <td>0.277358</td>\n",
       "      <td>1.324179</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.103369</td>\n",
       "      <td>5.103369</td>\n",
       "      <td>0.182165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_13.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.165107</td>\n",
       "      <td>0.086021</td>\n",
       "      <td>0.176763</td>\n",
       "      <td>0.096534</td>\n",
       "      <td>0.249389</td>\n",
       "      <td>0.152855</td>\n",
       "      <td>2.787841</td>\n",
       "      <td>15.209603</td>\n",
       "      <td>...</td>\n",
       "      <td>0.102537</td>\n",
       "      <td>0.165107</td>\n",
       "      <td>0.114948</td>\n",
       "      <td>0.043151</td>\n",
       "      <td>0.279114</td>\n",
       "      <td>1.379196</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.050830</td>\n",
       "      <td>6.050830</td>\n",
       "      <td>0.146071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_14.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.177831</td>\n",
       "      <td>0.087909</td>\n",
       "      <td>0.206274</td>\n",
       "      <td>0.102537</td>\n",
       "      <td>0.257892</td>\n",
       "      <td>0.155355</td>\n",
       "      <td>3.057116</td>\n",
       "      <td>15.071552</td>\n",
       "      <td>...</td>\n",
       "      <td>0.278199</td>\n",
       "      <td>0.177831</td>\n",
       "      <td>0.119130</td>\n",
       "      <td>0.043320</td>\n",
       "      <td>0.279114</td>\n",
       "      <td>1.276547</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.050830</td>\n",
       "      <td>6.050830</td>\n",
       "      <td>0.137097</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    item  duration  meanfreq        sd  \\\n",
       "0  11Ayg   Indo Afgan-dU8fP5CqClw_10.wav      10.0  0.171924  0.084798   \n",
       "1  11Ayg   Indo Afgan-dU8fP5CqClw_11.wav      10.0  0.119687  0.084263   \n",
       "2  11Ayg   Indo Afgan-dU8fP5CqClw_12.wav      10.0  0.151992  0.079224   \n",
       "3  11Ayg   Indo Afgan-dU8fP5CqClw_13.wav      10.0  0.165107  0.086021   \n",
       "4  11Ayg   Indo Afgan-dU8fP5CqClw_14.wav      10.0  0.177831  0.087909   \n",
       "\n",
       "     median       Q25       Q75       IQR      skew       kurt    ...     \\\n",
       "0  0.191168  0.097835  0.251890  0.154055  2.158582   8.769025    ...      \n",
       "1  0.100236  0.044716  0.184466  0.139750  0.832820   3.587928    ...      \n",
       "2  0.147153  0.092833  0.228382  0.135548  2.086398  11.305400    ...      \n",
       "3  0.176763  0.096534  0.249389  0.152855  2.787841  15.209603    ...      \n",
       "4  0.206274  0.102537  0.257892  0.155355  3.057116  15.071552    ...      \n",
       "\n",
       "       mode  centroid   meanfun    minfun    maxfun   meandom  mindom  \\\n",
       "0  0.255091  0.171924  0.118349  0.043151  0.279114  1.370654     0.0   \n",
       "1  0.102637  0.119687  0.122129  0.043793  0.279114  0.730685     0.0   \n",
       "2  0.102537  0.151992  0.113303  0.043235  0.277358  1.324179     0.0   \n",
       "3  0.102537  0.165107  0.114948  0.043151  0.279114  1.379196     0.0   \n",
       "4  0.278199  0.177831  0.119130  0.043320  0.279114  1.276547     0.0   \n",
       "\n",
       "     maxdom   dfrange   modindx  \n",
       "0  6.007764  6.007764  0.140773  \n",
       "1  4.306641  4.306641  0.119247  \n",
       "2  5.103369  5.103369  0.182165  \n",
       "3  6.050830  6.050830  0.146071  \n",
       "4  6.050830  6.050830  0.137097  \n",
       "\n",
       "[5 rows x 22 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "attributes = pd.read_csv(FILE_ATTRIBUTES, names = columns)\n",
    "attributes.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Processing Labels"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "labels = pd.read_csv(FILE_LABELS)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>search term</th>\n",
       "      <th>sex or gender</th>\n",
       "      <th>place of birth</th>\n",
       "      <th>occupation</th>\n",
       "      <th>country of residence</th>\n",
       "      <th>religion</th>\n",
       "      <th>voice_type</th>\n",
       "      <th>ethnic group</th>\n",
       "      <th>native language</th>\n",
       "      <th>age</th>\n",
       "      <th>filename</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>KATY+PERRY</td>\n",
       "      <td>female</td>\n",
       "      <td>Santa Barbara</td>\n",
       "      <td>singer</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>NaN</td>\n",
       "      <td>contralto</td>\n",
       "      <td>English American</td>\n",
       "      <td>English</td>\n",
       "      <td>33.0</td>\n",
       "      <td>Katy Perry speech at Human Rights Campaign (Ma...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Justin+Bieber</td>\n",
       "      <td>male</td>\n",
       "      <td>London</td>\n",
       "      <td>singer-songwriter</td>\n",
       "      <td>Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>English</td>\n",
       "      <td>23.0</td>\n",
       "      <td>Roast of Justin Bieber - Justin Bieber - Let's...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Taylor+Swift</td>\n",
       "      <td>female</td>\n",
       "      <td>Reading</td>\n",
       "      <td>singer-songwriter</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>NaN</td>\n",
       "      <td>mezzo-soprano</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "      <td>Taylor Swift | Album of the Year | 58th GRAMMYs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Rihanna</td>\n",
       "      <td>female</td>\n",
       "      <td>Saint Michael</td>\n",
       "      <td>singer</td>\n",
       "      <td>Barbados</td>\n",
       "      <td>Christianity</td>\n",
       "      <td>mezzo-soprano</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.0</td>\n",
       "      <td>Rihanna at Harvard Receiving their 2017 Humani...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The+Countess</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Countess of Wessex Speech</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     search term sex or gender place of birth         occupation  \\\n",
       "0     KATY+PERRY        female  Santa Barbara             singer   \n",
       "1  Justin+Bieber          male         London  singer-songwriter   \n",
       "2   Taylor+Swift        female        Reading  singer-songwriter   \n",
       "3        Rihanna        female  Saint Michael             singer   \n",
       "4   The+Countess           NaN            NaN                NaN   \n",
       "\n",
       "       country of residence      religion     voice_type      ethnic group  \\\n",
       "0  United States of America           NaN      contralto  English American   \n",
       "1                    Canada           NaN          tenor               NaN   \n",
       "2  United States of America           NaN  mezzo-soprano               NaN   \n",
       "3                  Barbados  Christianity  mezzo-soprano               NaN   \n",
       "4                       NaN           NaN            NaN               NaN   \n",
       "\n",
       "  native language   age                                           filename  \n",
       "0         English  33.0  Katy Perry speech at Human Rights Campaign (Ma...  \n",
       "1         English  23.0  Roast of Justin Bieber - Justin Bieber - Let's...  \n",
       "2             NaN  28.0    Taylor Swift | Album of the Year | 58th GRAMMYs  \n",
       "3             NaN  29.0  Rihanna at Harvard Receiving their 2017 Humani...  \n",
       "4             NaN   NaN                          Countess of Wessex Speech  "
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "labels.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Select the label (Improve)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sex or gender</th>\n",
       "      <th>filename</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Katy Perry speech at Human Rights Campaign (Ma...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>Roast of Justin Bieber - Justin Bieber - Let's...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>Taylor Swift | Album of the Year | 58th GRAMMYs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>Rihanna at Harvard Receiving their 2017 Humani...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0</td>\n",
       "      <td>Justin Timberlake Innovator Award Acceptance S...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  sex or gender                                           filename\n",
       "0             1  Katy Perry speech at Human Rights Campaign (Ma...\n",
       "1             0  Roast of Justin Bieber - Justin Bieber - Let's...\n",
       "2             1    Taylor Swift | Album of the Year | 58th GRAMMYs\n",
       "3             1  Rihanna at Harvard Receiving their 2017 Humani...\n",
       "5             0  Justin Timberlake Innovator Award Acceptance S..."
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gender_label = labels.iloc[:,[1,-1]].copy().dropna(axis=0, how='any').replace({\"female\": 1, \"male\":0})\n",
    "gender_label.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>item</th>\n",
       "      <th>duration</th>\n",
       "      <th>meanfreq</th>\n",
       "      <th>sd</th>\n",
       "      <th>median</th>\n",
       "      <th>Q25</th>\n",
       "      <th>Q75</th>\n",
       "      <th>IQR</th>\n",
       "      <th>skew</th>\n",
       "      <th>kurt</th>\n",
       "      <th>...</th>\n",
       "      <th>meanfun</th>\n",
       "      <th>minfun</th>\n",
       "      <th>maxfun</th>\n",
       "      <th>meandom</th>\n",
       "      <th>mindom</th>\n",
       "      <th>maxdom</th>\n",
       "      <th>dfrange</th>\n",
       "      <th>modindx</th>\n",
       "      <th>filename_length</th>\n",
       "      <th>filename</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_10.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.171924</td>\n",
       "      <td>0.084798</td>\n",
       "      <td>0.191168</td>\n",
       "      <td>0.097835</td>\n",
       "      <td>0.251890</td>\n",
       "      <td>0.154055</td>\n",
       "      <td>2.158582</td>\n",
       "      <td>8.769025</td>\n",
       "      <td>...</td>\n",
       "      <td>0.118349</td>\n",
       "      <td>0.043151</td>\n",
       "      <td>0.279114</td>\n",
       "      <td>1.370654</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.007764</td>\n",
       "      <td>6.007764</td>\n",
       "      <td>0.140773</td>\n",
       "      <td>30</td>\n",
       "      <td>11Ayg   Indo Afgan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_11.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.119687</td>\n",
       "      <td>0.084263</td>\n",
       "      <td>0.100236</td>\n",
       "      <td>0.044716</td>\n",
       "      <td>0.184466</td>\n",
       "      <td>0.139750</td>\n",
       "      <td>0.832820</td>\n",
       "      <td>3.587928</td>\n",
       "      <td>...</td>\n",
       "      <td>0.122129</td>\n",
       "      <td>0.043793</td>\n",
       "      <td>0.279114</td>\n",
       "      <td>0.730685</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.306641</td>\n",
       "      <td>4.306641</td>\n",
       "      <td>0.119247</td>\n",
       "      <td>30</td>\n",
       "      <td>11Ayg   Indo Afgan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_12.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.151992</td>\n",
       "      <td>0.079224</td>\n",
       "      <td>0.147153</td>\n",
       "      <td>0.092833</td>\n",
       "      <td>0.228382</td>\n",
       "      <td>0.135548</td>\n",
       "      <td>2.086398</td>\n",
       "      <td>11.305400</td>\n",
       "      <td>...</td>\n",
       "      <td>0.113303</td>\n",
       "      <td>0.043235</td>\n",
       "      <td>0.277358</td>\n",
       "      <td>1.324179</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.103369</td>\n",
       "      <td>5.103369</td>\n",
       "      <td>0.182165</td>\n",
       "      <td>30</td>\n",
       "      <td>11Ayg   Indo Afgan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_13.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.165107</td>\n",
       "      <td>0.086021</td>\n",
       "      <td>0.176763</td>\n",
       "      <td>0.096534</td>\n",
       "      <td>0.249389</td>\n",
       "      <td>0.152855</td>\n",
       "      <td>2.787841</td>\n",
       "      <td>15.209603</td>\n",
       "      <td>...</td>\n",
       "      <td>0.114948</td>\n",
       "      <td>0.043151</td>\n",
       "      <td>0.279114</td>\n",
       "      <td>1.379196</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.050830</td>\n",
       "      <td>6.050830</td>\n",
       "      <td>0.146071</td>\n",
       "      <td>30</td>\n",
       "      <td>11Ayg   Indo Afgan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_14.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.177831</td>\n",
       "      <td>0.087909</td>\n",
       "      <td>0.206274</td>\n",
       "      <td>0.102537</td>\n",
       "      <td>0.257892</td>\n",
       "      <td>0.155355</td>\n",
       "      <td>3.057116</td>\n",
       "      <td>15.071552</td>\n",
       "      <td>...</td>\n",
       "      <td>0.119130</td>\n",
       "      <td>0.043320</td>\n",
       "      <td>0.279114</td>\n",
       "      <td>1.276547</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.050830</td>\n",
       "      <td>6.050830</td>\n",
       "      <td>0.137097</td>\n",
       "      <td>30</td>\n",
       "      <td>11Ayg   Indo Afgan</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    item  duration  meanfreq        sd  \\\n",
       "0  11Ayg   Indo Afgan-dU8fP5CqClw_10.wav      10.0  0.171924  0.084798   \n",
       "1  11Ayg   Indo Afgan-dU8fP5CqClw_11.wav      10.0  0.119687  0.084263   \n",
       "2  11Ayg   Indo Afgan-dU8fP5CqClw_12.wav      10.0  0.151992  0.079224   \n",
       "3  11Ayg   Indo Afgan-dU8fP5CqClw_13.wav      10.0  0.165107  0.086021   \n",
       "4  11Ayg   Indo Afgan-dU8fP5CqClw_14.wav      10.0  0.177831  0.087909   \n",
       "\n",
       "     median       Q25       Q75       IQR      skew       kurt  \\\n",
       "0  0.191168  0.097835  0.251890  0.154055  2.158582   8.769025   \n",
       "1  0.100236  0.044716  0.184466  0.139750  0.832820   3.587928   \n",
       "2  0.147153  0.092833  0.228382  0.135548  2.086398  11.305400   \n",
       "3  0.176763  0.096534  0.249389  0.152855  2.787841  15.209603   \n",
       "4  0.206274  0.102537  0.257892  0.155355  3.057116  15.071552   \n",
       "\n",
       "          ...           meanfun    minfun    maxfun   meandom  mindom  \\\n",
       "0         ...          0.118349  0.043151  0.279114  1.370654     0.0   \n",
       "1         ...          0.122129  0.043793  0.279114  0.730685     0.0   \n",
       "2         ...          0.113303  0.043235  0.277358  1.324179     0.0   \n",
       "3         ...          0.114948  0.043151  0.279114  1.379196     0.0   \n",
       "4         ...          0.119130  0.043320  0.279114  1.276547     0.0   \n",
       "\n",
       "     maxdom   dfrange   modindx  filename_length            filename  \n",
       "0  6.007764  6.007764  0.140773               30  11Ayg   Indo Afgan  \n",
       "1  4.306641  4.306641  0.119247               30  11Ayg   Indo Afgan  \n",
       "2  5.103369  5.103369  0.182165               30  11Ayg   Indo Afgan  \n",
       "3  6.050830  6.050830  0.146071               30  11Ayg   Indo Afgan  \n",
       "4  6.050830  6.050830  0.137097               30  11Ayg   Indo Afgan  \n",
       "\n",
       "[5 rows x 24 columns]"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# attributes['filename_length'] = attributes['item'].str.rfind(\"_\")\n",
    "attributes['filename'] = attributes['item'].apply(lambda x: x[:x.rfind('-')])\n",
    "attributes.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Join the attributes and labels\n",
    "Many rows in Attributes Dataframe correspond to one row in labels Dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>item</th>\n",
       "      <th>duration</th>\n",
       "      <th>meanfreq</th>\n",
       "      <th>sd</th>\n",
       "      <th>median</th>\n",
       "      <th>Q25</th>\n",
       "      <th>Q75</th>\n",
       "      <th>IQR</th>\n",
       "      <th>skew</th>\n",
       "      <th>kurt</th>\n",
       "      <th>...</th>\n",
       "      <th>search term</th>\n",
       "      <th>sex or gender</th>\n",
       "      <th>place of birth</th>\n",
       "      <th>occupation</th>\n",
       "      <th>country of residence</th>\n",
       "      <th>religion</th>\n",
       "      <th>voice_type</th>\n",
       "      <th>ethnic group</th>\n",
       "      <th>native language</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_10.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.171924</td>\n",
       "      <td>0.084798</td>\n",
       "      <td>0.191168</td>\n",
       "      <td>0.097835</td>\n",
       "      <td>0.251890</td>\n",
       "      <td>0.154055</td>\n",
       "      <td>2.158582</td>\n",
       "      <td>8.769025</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_11.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.119687</td>\n",
       "      <td>0.084263</td>\n",
       "      <td>0.100236</td>\n",
       "      <td>0.044716</td>\n",
       "      <td>0.184466</td>\n",
       "      <td>0.139750</td>\n",
       "      <td>0.832820</td>\n",
       "      <td>3.587928</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_12.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.151992</td>\n",
       "      <td>0.079224</td>\n",
       "      <td>0.147153</td>\n",
       "      <td>0.092833</td>\n",
       "      <td>0.228382</td>\n",
       "      <td>0.135548</td>\n",
       "      <td>2.086398</td>\n",
       "      <td>11.305400</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_13.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.165107</td>\n",
       "      <td>0.086021</td>\n",
       "      <td>0.176763</td>\n",
       "      <td>0.096534</td>\n",
       "      <td>0.249389</td>\n",
       "      <td>0.152855</td>\n",
       "      <td>2.787841</td>\n",
       "      <td>15.209603</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_14.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.177831</td>\n",
       "      <td>0.087909</td>\n",
       "      <td>0.206274</td>\n",
       "      <td>0.102537</td>\n",
       "      <td>0.257892</td>\n",
       "      <td>0.155355</td>\n",
       "      <td>3.057116</td>\n",
       "      <td>15.071552</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_15.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.170651</td>\n",
       "      <td>0.083036</td>\n",
       "      <td>0.186267</td>\n",
       "      <td>0.106238</td>\n",
       "      <td>0.247688</td>\n",
       "      <td>0.141451</td>\n",
       "      <td>1.894721</td>\n",
       "      <td>8.187635</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_16.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.177675</td>\n",
       "      <td>0.082694</td>\n",
       "      <td>0.194369</td>\n",
       "      <td>0.112640</td>\n",
       "      <td>0.252190</td>\n",
       "      <td>0.139550</td>\n",
       "      <td>2.578510</td>\n",
       "      <td>12.320142</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_17.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.085512</td>\n",
       "      <td>0.071645</td>\n",
       "      <td>0.052319</td>\n",
       "      <td>0.033712</td>\n",
       "      <td>0.119743</td>\n",
       "      <td>0.086031</td>\n",
       "      <td>2.163633</td>\n",
       "      <td>7.578299</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_18.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.157162</td>\n",
       "      <td>0.076614</td>\n",
       "      <td>0.175963</td>\n",
       "      <td>0.098735</td>\n",
       "      <td>0.211476</td>\n",
       "      <td>0.112740</td>\n",
       "      <td>3.180201</td>\n",
       "      <td>17.678196</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_19.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.164562</td>\n",
       "      <td>0.074225</td>\n",
       "      <td>0.185466</td>\n",
       "      <td>0.114241</td>\n",
       "      <td>0.210375</td>\n",
       "      <td>0.096134</td>\n",
       "      <td>3.205119</td>\n",
       "      <td>16.807585</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_1.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.088671</td>\n",
       "      <td>0.059938</td>\n",
       "      <td>0.073526</td>\n",
       "      <td>0.047617</td>\n",
       "      <td>0.111340</td>\n",
       "      <td>0.063723</td>\n",
       "      <td>2.241660</td>\n",
       "      <td>9.162199</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_20.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.173783</td>\n",
       "      <td>0.079212</td>\n",
       "      <td>0.201372</td>\n",
       "      <td>0.114941</td>\n",
       "      <td>0.236685</td>\n",
       "      <td>0.121743</td>\n",
       "      <td>3.290993</td>\n",
       "      <td>17.607427</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_21.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.188955</td>\n",
       "      <td>0.075374</td>\n",
       "      <td>0.206774</td>\n",
       "      <td>0.152154</td>\n",
       "      <td>0.250289</td>\n",
       "      <td>0.098135</td>\n",
       "      <td>2.276455</td>\n",
       "      <td>9.232635</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_22.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.176628</td>\n",
       "      <td>0.076471</td>\n",
       "      <td>0.195770</td>\n",
       "      <td>0.124745</td>\n",
       "      <td>0.237685</td>\n",
       "      <td>0.112940</td>\n",
       "      <td>1.445067</td>\n",
       "      <td>5.701284</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_23.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.142446</td>\n",
       "      <td>0.084406</td>\n",
       "      <td>0.165759</td>\n",
       "      <td>0.060322</td>\n",
       "      <td>0.208574</td>\n",
       "      <td>0.148253</td>\n",
       "      <td>2.591789</td>\n",
       "      <td>13.346531</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_24.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.158610</td>\n",
       "      <td>0.075901</td>\n",
       "      <td>0.180665</td>\n",
       "      <td>0.102737</td>\n",
       "      <td>0.206374</td>\n",
       "      <td>0.103637</td>\n",
       "      <td>3.281104</td>\n",
       "      <td>18.056568</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_25.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.125560</td>\n",
       "      <td>0.064513</td>\n",
       "      <td>0.108239</td>\n",
       "      <td>0.083530</td>\n",
       "      <td>0.151954</td>\n",
       "      <td>0.068424</td>\n",
       "      <td>2.024710</td>\n",
       "      <td>7.966154</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_26.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.130490</td>\n",
       "      <td>0.067902</td>\n",
       "      <td>0.120343</td>\n",
       "      <td>0.085631</td>\n",
       "      <td>0.162458</td>\n",
       "      <td>0.076827</td>\n",
       "      <td>2.024118</td>\n",
       "      <td>8.137803</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_27.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.139661</td>\n",
       "      <td>0.066014</td>\n",
       "      <td>0.136149</td>\n",
       "      <td>0.096635</td>\n",
       "      <td>0.177663</td>\n",
       "      <td>0.081029</td>\n",
       "      <td>1.781161</td>\n",
       "      <td>6.819555</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_28.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.134083</td>\n",
       "      <td>0.071801</td>\n",
       "      <td>0.123144</td>\n",
       "      <td>0.086831</td>\n",
       "      <td>0.171561</td>\n",
       "      <td>0.084730</td>\n",
       "      <td>1.986468</td>\n",
       "      <td>7.810926</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_29.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.121855</td>\n",
       "      <td>0.080677</td>\n",
       "      <td>0.111540</td>\n",
       "      <td>0.048217</td>\n",
       "      <td>0.170961</td>\n",
       "      <td>0.122744</td>\n",
       "      <td>1.078188</td>\n",
       "      <td>3.996824</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_2.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.170221</td>\n",
       "      <td>0.081364</td>\n",
       "      <td>0.191068</td>\n",
       "      <td>0.081529</td>\n",
       "      <td>0.243787</td>\n",
       "      <td>0.162258</td>\n",
       "      <td>3.706370</td>\n",
       "      <td>26.137786</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_30.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.149683</td>\n",
       "      <td>0.065427</td>\n",
       "      <td>0.145352</td>\n",
       "      <td>0.100636</td>\n",
       "      <td>0.189968</td>\n",
       "      <td>0.089332</td>\n",
       "      <td>1.689114</td>\n",
       "      <td>6.738237</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_31.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.146451</td>\n",
       "      <td>0.069037</td>\n",
       "      <td>0.140150</td>\n",
       "      <td>0.095934</td>\n",
       "      <td>0.198471</td>\n",
       "      <td>0.102537</td>\n",
       "      <td>1.530655</td>\n",
       "      <td>5.827122</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_32.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.149419</td>\n",
       "      <td>0.069533</td>\n",
       "      <td>0.141350</td>\n",
       "      <td>0.097335</td>\n",
       "      <td>0.196270</td>\n",
       "      <td>0.098935</td>\n",
       "      <td>1.390251</td>\n",
       "      <td>4.890157</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_33.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.141763</td>\n",
       "      <td>0.067671</td>\n",
       "      <td>0.137649</td>\n",
       "      <td>0.093333</td>\n",
       "      <td>0.188667</td>\n",
       "      <td>0.095334</td>\n",
       "      <td>1.769770</td>\n",
       "      <td>7.118689</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_34.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.140172</td>\n",
       "      <td>0.069813</td>\n",
       "      <td>0.128446</td>\n",
       "      <td>0.090732</td>\n",
       "      <td>0.187867</td>\n",
       "      <td>0.097135</td>\n",
       "      <td>1.826498</td>\n",
       "      <td>7.575114</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_35.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.135407</td>\n",
       "      <td>0.070132</td>\n",
       "      <td>0.130447</td>\n",
       "      <td>0.087231</td>\n",
       "      <td>0.183466</td>\n",
       "      <td>0.096234</td>\n",
       "      <td>1.817284</td>\n",
       "      <td>7.042419</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_36.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.138157</td>\n",
       "      <td>0.062617</td>\n",
       "      <td>0.131747</td>\n",
       "      <td>0.092733</td>\n",
       "      <td>0.183866</td>\n",
       "      <td>0.091133</td>\n",
       "      <td>1.643143</td>\n",
       "      <td>6.094835</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>11Ayg   Indo Afgan-dU8fP5CqClw_37.wav</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.151858</td>\n",
       "      <td>0.070368</td>\n",
       "      <td>0.152855</td>\n",
       "      <td>0.097335</td>\n",
       "      <td>0.198671</td>\n",
       "      <td>0.101336</td>\n",
       "      <td>1.641876</td>\n",
       "      <td>5.645966</td>\n",
       "      <td>...</td>\n",
       "      <td>afgansyah+reza</td>\n",
       "      <td>male</td>\n",
       "      <td>Bandung</td>\n",
       "      <td>actor</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>tenor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.192190</td>\n",
       "      <td>0.052425</td>\n",
       "      <td>0.206074</td>\n",
       "      <td>0.172862</td>\n",
       "      <td>0.219278</td>\n",
       "      <td>0.046417</td>\n",
       "      <td>3.728881</td>\n",
       "      <td>21.315729</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.182775</td>\n",
       "      <td>0.073792</td>\n",
       "      <td>0.206074</td>\n",
       "      <td>0.136949</td>\n",
       "      <td>0.235684</td>\n",
       "      <td>0.098735</td>\n",
       "      <td>2.237815</td>\n",
       "      <td>10.076710</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.200430</td>\n",
       "      <td>0.051750</td>\n",
       "      <td>0.210075</td>\n",
       "      <td>0.186467</td>\n",
       "      <td>0.233984</td>\n",
       "      <td>0.047517</td>\n",
       "      <td>3.136022</td>\n",
       "      <td>14.854590</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.194473</td>\n",
       "      <td>0.046486</td>\n",
       "      <td>0.207174</td>\n",
       "      <td>0.184466</td>\n",
       "      <td>0.220079</td>\n",
       "      <td>0.035613</td>\n",
       "      <td>3.602620</td>\n",
       "      <td>19.589410</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.200199</td>\n",
       "      <td>0.050661</td>\n",
       "      <td>0.208975</td>\n",
       "      <td>0.184966</td>\n",
       "      <td>0.229582</td>\n",
       "      <td>0.044616</td>\n",
       "      <td>2.683906</td>\n",
       "      <td>12.261520</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.196998</td>\n",
       "      <td>0.051822</td>\n",
       "      <td>0.200972</td>\n",
       "      <td>0.184366</td>\n",
       "      <td>0.228181</td>\n",
       "      <td>0.043816</td>\n",
       "      <td>2.834166</td>\n",
       "      <td>13.519056</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.202600</td>\n",
       "      <td>0.053460</td>\n",
       "      <td>0.211576</td>\n",
       "      <td>0.181265</td>\n",
       "      <td>0.246588</td>\n",
       "      <td>0.065323</td>\n",
       "      <td>2.968574</td>\n",
       "      <td>15.765607</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.192134</td>\n",
       "      <td>0.057672</td>\n",
       "      <td>0.201272</td>\n",
       "      <td>0.176463</td>\n",
       "      <td>0.225981</td>\n",
       "      <td>0.049518</td>\n",
       "      <td>2.733824</td>\n",
       "      <td>12.376633</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.199053</td>\n",
       "      <td>0.058375</td>\n",
       "      <td>0.208574</td>\n",
       "      <td>0.173962</td>\n",
       "      <td>0.238285</td>\n",
       "      <td>0.064323</td>\n",
       "      <td>2.104472</td>\n",
       "      <td>7.960328</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.196290</td>\n",
       "      <td>0.053615</td>\n",
       "      <td>0.210075</td>\n",
       "      <td>0.172862</td>\n",
       "      <td>0.231183</td>\n",
       "      <td>0.058321</td>\n",
       "      <td>2.363085</td>\n",
       "      <td>8.978364</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.198165</td>\n",
       "      <td>0.054835</td>\n",
       "      <td>0.209675</td>\n",
       "      <td>0.186066</td>\n",
       "      <td>0.228282</td>\n",
       "      <td>0.042215</td>\n",
       "      <td>2.704262</td>\n",
       "      <td>11.488453</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.212879</td>\n",
       "      <td>0.053980</td>\n",
       "      <td>0.224780</td>\n",
       "      <td>0.200872</td>\n",
       "      <td>0.247488</td>\n",
       "      <td>0.046617</td>\n",
       "      <td>2.537771</td>\n",
       "      <td>10.906139</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.190986</td>\n",
       "      <td>0.054897</td>\n",
       "      <td>0.198671</td>\n",
       "      <td>0.171761</td>\n",
       "      <td>0.223380</td>\n",
       "      <td>0.051618</td>\n",
       "      <td>2.514536</td>\n",
       "      <td>10.394633</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.195839</td>\n",
       "      <td>0.048857</td>\n",
       "      <td>0.201172</td>\n",
       "      <td>0.184466</td>\n",
       "      <td>0.222179</td>\n",
       "      <td>0.037713</td>\n",
       "      <td>3.171081</td>\n",
       "      <td>15.341098</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.192821</td>\n",
       "      <td>0.051560</td>\n",
       "      <td>0.199971</td>\n",
       "      <td>0.174062</td>\n",
       "      <td>0.225280</td>\n",
       "      <td>0.051218</td>\n",
       "      <td>2.704497</td>\n",
       "      <td>13.411244</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.202402</td>\n",
       "      <td>0.048288</td>\n",
       "      <td>0.209275</td>\n",
       "      <td>0.192869</td>\n",
       "      <td>0.231683</td>\n",
       "      <td>0.038814</td>\n",
       "      <td>2.687863</td>\n",
       "      <td>11.229005</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.199234</td>\n",
       "      <td>0.051535</td>\n",
       "      <td>0.208274</td>\n",
       "      <td>0.185066</td>\n",
       "      <td>0.227281</td>\n",
       "      <td>0.042215</td>\n",
       "      <td>2.551235</td>\n",
       "      <td>10.732216</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.188146</td>\n",
       "      <td>0.057691</td>\n",
       "      <td>0.196570</td>\n",
       "      <td>0.152054</td>\n",
       "      <td>0.233683</td>\n",
       "      <td>0.081629</td>\n",
       "      <td>1.860975</td>\n",
       "      <td>6.592661</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.214958</td>\n",
       "      <td>0.054736</td>\n",
       "      <td>0.223080</td>\n",
       "      <td>0.199571</td>\n",
       "      <td>0.251390</td>\n",
       "      <td>0.051819</td>\n",
       "      <td>2.197430</td>\n",
       "      <td>8.208940</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.183794</td>\n",
       "      <td>0.054083</td>\n",
       "      <td>0.198471</td>\n",
       "      <td>0.149553</td>\n",
       "      <td>0.222379</td>\n",
       "      <td>0.072826</td>\n",
       "      <td>2.598913</td>\n",
       "      <td>11.936542</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.172201</td>\n",
       "      <td>0.055039</td>\n",
       "      <td>0.185066</td>\n",
       "      <td>0.128646</td>\n",
       "      <td>0.211776</td>\n",
       "      <td>0.083130</td>\n",
       "      <td>2.099249</td>\n",
       "      <td>8.994313</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.170879</td>\n",
       "      <td>0.059636</td>\n",
       "      <td>0.175463</td>\n",
       "      <td>0.134848</td>\n",
       "      <td>0.212376</td>\n",
       "      <td>0.077528</td>\n",
       "      <td>1.684351</td>\n",
       "      <td>7.353757</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.177482</td>\n",
       "      <td>0.065962</td>\n",
       "      <td>0.175163</td>\n",
       "      <td>0.132247</td>\n",
       "      <td>0.235984</td>\n",
       "      <td>0.103737</td>\n",
       "      <td>1.373205</td>\n",
       "      <td>5.205767</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.190665</td>\n",
       "      <td>0.056251</td>\n",
       "      <td>0.201772</td>\n",
       "      <td>0.174462</td>\n",
       "      <td>0.225781</td>\n",
       "      <td>0.051318</td>\n",
       "      <td>2.644992</td>\n",
       "      <td>11.693421</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.201392</td>\n",
       "      <td>0.050226</td>\n",
       "      <td>0.210375</td>\n",
       "      <td>0.187167</td>\n",
       "      <td>0.230682</td>\n",
       "      <td>0.043516</td>\n",
       "      <td>2.362277</td>\n",
       "      <td>9.199835</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.215434</td>\n",
       "      <td>0.062646</td>\n",
       "      <td>0.236484</td>\n",
       "      <td>0.198871</td>\n",
       "      <td>0.254191</td>\n",
       "      <td>0.055320</td>\n",
       "      <td>3.064312</td>\n",
       "      <td>13.342430</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.184965</td>\n",
       "      <td>0.054446</td>\n",
       "      <td>0.195270</td>\n",
       "      <td>0.168860</td>\n",
       "      <td>0.219378</td>\n",
       "      <td>0.050518</td>\n",
       "      <td>2.531994</td>\n",
       "      <td>10.623250</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.192331</td>\n",
       "      <td>0.054893</td>\n",
       "      <td>0.204573</td>\n",
       "      <td>0.171461</td>\n",
       "      <td>0.224880</td>\n",
       "      <td>0.053419</td>\n",
       "      <td>2.458305</td>\n",
       "      <td>10.138366</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.212257</td>\n",
       "      <td>0.061269</td>\n",
       "      <td>0.230582</td>\n",
       "      <td>0.199071</td>\n",
       "      <td>0.251190</td>\n",
       "      <td>0.052119</td>\n",
       "      <td>2.941393</td>\n",
       "      <td>13.973115</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>2012 USC Annenberg School for Communication Co...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.194186</td>\n",
       "      <td>0.055399</td>\n",
       "      <td>0.206974</td>\n",
       "      <td>0.175763</td>\n",
       "      <td>0.225681</td>\n",
       "      <td>0.049918</td>\n",
       "      <td>2.772640</td>\n",
       "      <td>13.118316</td>\n",
       "      <td>...</td>\n",
       "      <td>Maria+Shriver</td>\n",
       "      <td>female</td>\n",
       "      <td>Chicago</td>\n",
       "      <td>journalist</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Catholicism</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>62.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>235 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  item  duration  meanfreq  \\\n",
       "0                11Ayg   Indo Afgan-dU8fP5CqClw_10.wav      10.0  0.171924   \n",
       "1                11Ayg   Indo Afgan-dU8fP5CqClw_11.wav      10.0  0.119687   \n",
       "2                11Ayg   Indo Afgan-dU8fP5CqClw_12.wav      10.0  0.151992   \n",
       "3                11Ayg   Indo Afgan-dU8fP5CqClw_13.wav      10.0  0.165107   \n",
       "4                11Ayg   Indo Afgan-dU8fP5CqClw_14.wav      10.0  0.177831   \n",
       "5                11Ayg   Indo Afgan-dU8fP5CqClw_15.wav      10.0  0.170651   \n",
       "6                11Ayg   Indo Afgan-dU8fP5CqClw_16.wav      10.0  0.177675   \n",
       "7                11Ayg   Indo Afgan-dU8fP5CqClw_17.wav      10.0  0.085512   \n",
       "8                11Ayg   Indo Afgan-dU8fP5CqClw_18.wav      10.0  0.157162   \n",
       "9                11Ayg   Indo Afgan-dU8fP5CqClw_19.wav      10.0  0.164562   \n",
       "10                11Ayg   Indo Afgan-dU8fP5CqClw_1.wav      10.0  0.088671   \n",
       "11               11Ayg   Indo Afgan-dU8fP5CqClw_20.wav      10.0  0.173783   \n",
       "12               11Ayg   Indo Afgan-dU8fP5CqClw_21.wav      10.0  0.188955   \n",
       "13               11Ayg   Indo Afgan-dU8fP5CqClw_22.wav      10.0  0.176628   \n",
       "14               11Ayg   Indo Afgan-dU8fP5CqClw_23.wav      10.0  0.142446   \n",
       "15               11Ayg   Indo Afgan-dU8fP5CqClw_24.wav      10.0  0.158610   \n",
       "16               11Ayg   Indo Afgan-dU8fP5CqClw_25.wav      10.0  0.125560   \n",
       "17               11Ayg   Indo Afgan-dU8fP5CqClw_26.wav      10.0  0.130490   \n",
       "18               11Ayg   Indo Afgan-dU8fP5CqClw_27.wav      10.0  0.139661   \n",
       "19               11Ayg   Indo Afgan-dU8fP5CqClw_28.wav      10.0  0.134083   \n",
       "20               11Ayg   Indo Afgan-dU8fP5CqClw_29.wav      10.0  0.121855   \n",
       "21                11Ayg   Indo Afgan-dU8fP5CqClw_2.wav      10.0  0.170221   \n",
       "22               11Ayg   Indo Afgan-dU8fP5CqClw_30.wav      10.0  0.149683   \n",
       "23               11Ayg   Indo Afgan-dU8fP5CqClw_31.wav      10.0  0.146451   \n",
       "24               11Ayg   Indo Afgan-dU8fP5CqClw_32.wav      10.0  0.149419   \n",
       "25               11Ayg   Indo Afgan-dU8fP5CqClw_33.wav      10.0  0.141763   \n",
       "26               11Ayg   Indo Afgan-dU8fP5CqClw_34.wav      10.0  0.140172   \n",
       "27               11Ayg   Indo Afgan-dU8fP5CqClw_35.wav      10.0  0.135407   \n",
       "28               11Ayg   Indo Afgan-dU8fP5CqClw_36.wav      10.0  0.138157   \n",
       "29               11Ayg   Indo Afgan-dU8fP5CqClw_37.wav      10.0  0.151858   \n",
       "..                                                 ...       ...       ...   \n",
       "205  2012 USC Annenberg School for Communication Co...      10.0  0.192190   \n",
       "206  2012 USC Annenberg School for Communication Co...      10.0  0.182775   \n",
       "207  2012 USC Annenberg School for Communication Co...      10.0  0.200430   \n",
       "208  2012 USC Annenberg School for Communication Co...      10.0  0.194473   \n",
       "209  2012 USC Annenberg School for Communication Co...      10.0  0.200199   \n",
       "210  2012 USC Annenberg School for Communication Co...      10.0  0.196998   \n",
       "211  2012 USC Annenberg School for Communication Co...      10.0  0.202600   \n",
       "212  2012 USC Annenberg School for Communication Co...      10.0  0.192134   \n",
       "213  2012 USC Annenberg School for Communication Co...      10.0  0.199053   \n",
       "214  2012 USC Annenberg School for Communication Co...      10.0  0.196290   \n",
       "215  2012 USC Annenberg School for Communication Co...      10.0  0.198165   \n",
       "216  2012 USC Annenberg School for Communication Co...      10.0  0.212879   \n",
       "217  2012 USC Annenberg School for Communication Co...      10.0  0.190986   \n",
       "218  2012 USC Annenberg School for Communication Co...      10.0  0.195839   \n",
       "219  2012 USC Annenberg School for Communication Co...      10.0  0.192821   \n",
       "220  2012 USC Annenberg School for Communication Co...      10.0  0.202402   \n",
       "221  2012 USC Annenberg School for Communication Co...      10.0  0.199234   \n",
       "222  2012 USC Annenberg School for Communication Co...      10.0  0.188146   \n",
       "223  2012 USC Annenberg School for Communication Co...      10.0  0.214958   \n",
       "224  2012 USC Annenberg School for Communication Co...      10.0  0.183794   \n",
       "225  2012 USC Annenberg School for Communication Co...      10.0  0.172201   \n",
       "226  2012 USC Annenberg School for Communication Co...      10.0  0.170879   \n",
       "227  2012 USC Annenberg School for Communication Co...      10.0  0.177482   \n",
       "228  2012 USC Annenberg School for Communication Co...      10.0  0.190665   \n",
       "229  2012 USC Annenberg School for Communication Co...      10.0  0.201392   \n",
       "230  2012 USC Annenberg School for Communication Co...      10.0  0.215434   \n",
       "231  2012 USC Annenberg School for Communication Co...      10.0  0.184965   \n",
       "232  2012 USC Annenberg School for Communication Co...      10.0  0.192331   \n",
       "233  2012 USC Annenberg School for Communication Co...      10.0  0.212257   \n",
       "234  2012 USC Annenberg School for Communication Co...      10.0  0.194186   \n",
       "\n",
       "           sd    median       Q25       Q75       IQR      skew       kurt  \\\n",
       "0    0.084798  0.191168  0.097835  0.251890  0.154055  2.158582   8.769025   \n",
       "1    0.084263  0.100236  0.044716  0.184466  0.139750  0.832820   3.587928   \n",
       "2    0.079224  0.147153  0.092833  0.228382  0.135548  2.086398  11.305400   \n",
       "3    0.086021  0.176763  0.096534  0.249389  0.152855  2.787841  15.209603   \n",
       "4    0.087909  0.206274  0.102537  0.257892  0.155355  3.057116  15.071552   \n",
       "5    0.083036  0.186267  0.106238  0.247688  0.141451  1.894721   8.187635   \n",
       "6    0.082694  0.194369  0.112640  0.252190  0.139550  2.578510  12.320142   \n",
       "7    0.071645  0.052319  0.033712  0.119743  0.086031  2.163633   7.578299   \n",
       "8    0.076614  0.175963  0.098735  0.211476  0.112740  3.180201  17.678196   \n",
       "9    0.074225  0.185466  0.114241  0.210375  0.096134  3.205119  16.807585   \n",
       "10   0.059938  0.073526  0.047617  0.111340  0.063723  2.241660   9.162199   \n",
       "11   0.079212  0.201372  0.114941  0.236685  0.121743  3.290993  17.607427   \n",
       "12   0.075374  0.206774  0.152154  0.250289  0.098135  2.276455   9.232635   \n",
       "13   0.076471  0.195770  0.124745  0.237685  0.112940  1.445067   5.701284   \n",
       "14   0.084406  0.165759  0.060322  0.208574  0.148253  2.591789  13.346531   \n",
       "15   0.075901  0.180665  0.102737  0.206374  0.103637  3.281104  18.056568   \n",
       "16   0.064513  0.108239  0.083530  0.151954  0.068424  2.024710   7.966154   \n",
       "17   0.067902  0.120343  0.085631  0.162458  0.076827  2.024118   8.137803   \n",
       "18   0.066014  0.136149  0.096635  0.177663  0.081029  1.781161   6.819555   \n",
       "19   0.071801  0.123144  0.086831  0.171561  0.084730  1.986468   7.810926   \n",
       "20   0.080677  0.111540  0.048217  0.170961  0.122744  1.078188   3.996824   \n",
       "21   0.081364  0.191068  0.081529  0.243787  0.162258  3.706370  26.137786   \n",
       "22   0.065427  0.145352  0.100636  0.189968  0.089332  1.689114   6.738237   \n",
       "23   0.069037  0.140150  0.095934  0.198471  0.102537  1.530655   5.827122   \n",
       "24   0.069533  0.141350  0.097335  0.196270  0.098935  1.390251   4.890157   \n",
       "25   0.067671  0.137649  0.093333  0.188667  0.095334  1.769770   7.118689   \n",
       "26   0.069813  0.128446  0.090732  0.187867  0.097135  1.826498   7.575114   \n",
       "27   0.070132  0.130447  0.087231  0.183466  0.096234  1.817284   7.042419   \n",
       "28   0.062617  0.131747  0.092733  0.183866  0.091133  1.643143   6.094835   \n",
       "29   0.070368  0.152855  0.097335  0.198671  0.101336  1.641876   5.645966   \n",
       "..        ...       ...       ...       ...       ...       ...        ...   \n",
       "205  0.052425  0.206074  0.172862  0.219278  0.046417  3.728881  21.315729   \n",
       "206  0.073792  0.206074  0.136949  0.235684  0.098735  2.237815  10.076710   \n",
       "207  0.051750  0.210075  0.186467  0.233984  0.047517  3.136022  14.854590   \n",
       "208  0.046486  0.207174  0.184466  0.220079  0.035613  3.602620  19.589410   \n",
       "209  0.050661  0.208975  0.184966  0.229582  0.044616  2.683906  12.261520   \n",
       "210  0.051822  0.200972  0.184366  0.228181  0.043816  2.834166  13.519056   \n",
       "211  0.053460  0.211576  0.181265  0.246588  0.065323  2.968574  15.765607   \n",
       "212  0.057672  0.201272  0.176463  0.225981  0.049518  2.733824  12.376633   \n",
       "213  0.058375  0.208574  0.173962  0.238285  0.064323  2.104472   7.960328   \n",
       "214  0.053615  0.210075  0.172862  0.231183  0.058321  2.363085   8.978364   \n",
       "215  0.054835  0.209675  0.186066  0.228282  0.042215  2.704262  11.488453   \n",
       "216  0.053980  0.224780  0.200872  0.247488  0.046617  2.537771  10.906139   \n",
       "217  0.054897  0.198671  0.171761  0.223380  0.051618  2.514536  10.394633   \n",
       "218  0.048857  0.201172  0.184466  0.222179  0.037713  3.171081  15.341098   \n",
       "219  0.051560  0.199971  0.174062  0.225280  0.051218  2.704497  13.411244   \n",
       "220  0.048288  0.209275  0.192869  0.231683  0.038814  2.687863  11.229005   \n",
       "221  0.051535  0.208274  0.185066  0.227281  0.042215  2.551235  10.732216   \n",
       "222  0.057691  0.196570  0.152054  0.233683  0.081629  1.860975   6.592661   \n",
       "223  0.054736  0.223080  0.199571  0.251390  0.051819  2.197430   8.208940   \n",
       "224  0.054083  0.198471  0.149553  0.222379  0.072826  2.598913  11.936542   \n",
       "225  0.055039  0.185066  0.128646  0.211776  0.083130  2.099249   8.994313   \n",
       "226  0.059636  0.175463  0.134848  0.212376  0.077528  1.684351   7.353757   \n",
       "227  0.065962  0.175163  0.132247  0.235984  0.103737  1.373205   5.205767   \n",
       "228  0.056251  0.201772  0.174462  0.225781  0.051318  2.644992  11.693421   \n",
       "229  0.050226  0.210375  0.187167  0.230682  0.043516  2.362277   9.199835   \n",
       "230  0.062646  0.236484  0.198871  0.254191  0.055320  3.064312  13.342430   \n",
       "231  0.054446  0.195270  0.168860  0.219378  0.050518  2.531994  10.623250   \n",
       "232  0.054893  0.204573  0.171461  0.224880  0.053419  2.458305  10.138366   \n",
       "233  0.061269  0.230582  0.199071  0.251190  0.052119  2.941393  13.973115   \n",
       "234  0.055399  0.206974  0.175763  0.225681  0.049918  2.772640  13.118316   \n",
       "\n",
       "     ...      search term  sex or gender  place of birth  occupation  \\\n",
       "0    ...   afgansyah+reza           male         Bandung       actor   \n",
       "1    ...   afgansyah+reza           male         Bandung       actor   \n",
       "2    ...   afgansyah+reza           male         Bandung       actor   \n",
       "3    ...   afgansyah+reza           male         Bandung       actor   \n",
       "4    ...   afgansyah+reza           male         Bandung       actor   \n",
       "5    ...   afgansyah+reza           male         Bandung       actor   \n",
       "6    ...   afgansyah+reza           male         Bandung       actor   \n",
       "7    ...   afgansyah+reza           male         Bandung       actor   \n",
       "8    ...   afgansyah+reza           male         Bandung       actor   \n",
       "9    ...   afgansyah+reza           male         Bandung       actor   \n",
       "10   ...   afgansyah+reza           male         Bandung       actor   \n",
       "11   ...   afgansyah+reza           male         Bandung       actor   \n",
       "12   ...   afgansyah+reza           male         Bandung       actor   \n",
       "13   ...   afgansyah+reza           male         Bandung       actor   \n",
       "14   ...   afgansyah+reza           male         Bandung       actor   \n",
       "15   ...   afgansyah+reza           male         Bandung       actor   \n",
       "16   ...   afgansyah+reza           male         Bandung       actor   \n",
       "17   ...   afgansyah+reza           male         Bandung       actor   \n",
       "18   ...   afgansyah+reza           male         Bandung       actor   \n",
       "19   ...   afgansyah+reza           male         Bandung       actor   \n",
       "20   ...   afgansyah+reza           male         Bandung       actor   \n",
       "21   ...   afgansyah+reza           male         Bandung       actor   \n",
       "22   ...   afgansyah+reza           male         Bandung       actor   \n",
       "23   ...   afgansyah+reza           male         Bandung       actor   \n",
       "24   ...   afgansyah+reza           male         Bandung       actor   \n",
       "25   ...   afgansyah+reza           male         Bandung       actor   \n",
       "26   ...   afgansyah+reza           male         Bandung       actor   \n",
       "27   ...   afgansyah+reza           male         Bandung       actor   \n",
       "28   ...   afgansyah+reza           male         Bandung       actor   \n",
       "29   ...   afgansyah+reza           male         Bandung       actor   \n",
       "..   ...              ...            ...             ...         ...   \n",
       "205  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "206  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "207  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "208  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "209  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "210  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "211  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "212  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "213  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "214  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "215  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "216  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "217  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "218  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "219  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "220  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "221  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "222  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "223  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "224  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "225  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "226  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "227  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "228  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "229  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "230  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "231  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "232  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "233  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "234  ...    Maria+Shriver         female         Chicago  journalist   \n",
       "\n",
       "         country of residence     religion  voice_type  ethnic group  \\\n",
       "0                    Malaysia          NaN       tenor           NaN   \n",
       "1                    Malaysia          NaN       tenor           NaN   \n",
       "2                    Malaysia          NaN       tenor           NaN   \n",
       "3                    Malaysia          NaN       tenor           NaN   \n",
       "4                    Malaysia          NaN       tenor           NaN   \n",
       "5                    Malaysia          NaN       tenor           NaN   \n",
       "6                    Malaysia          NaN       tenor           NaN   \n",
       "7                    Malaysia          NaN       tenor           NaN   \n",
       "8                    Malaysia          NaN       tenor           NaN   \n",
       "9                    Malaysia          NaN       tenor           NaN   \n",
       "10                   Malaysia          NaN       tenor           NaN   \n",
       "11                   Malaysia          NaN       tenor           NaN   \n",
       "12                   Malaysia          NaN       tenor           NaN   \n",
       "13                   Malaysia          NaN       tenor           NaN   \n",
       "14                   Malaysia          NaN       tenor           NaN   \n",
       "15                   Malaysia          NaN       tenor           NaN   \n",
       "16                   Malaysia          NaN       tenor           NaN   \n",
       "17                   Malaysia          NaN       tenor           NaN   \n",
       "18                   Malaysia          NaN       tenor           NaN   \n",
       "19                   Malaysia          NaN       tenor           NaN   \n",
       "20                   Malaysia          NaN       tenor           NaN   \n",
       "21                   Malaysia          NaN       tenor           NaN   \n",
       "22                   Malaysia          NaN       tenor           NaN   \n",
       "23                   Malaysia          NaN       tenor           NaN   \n",
       "24                   Malaysia          NaN       tenor           NaN   \n",
       "25                   Malaysia          NaN       tenor           NaN   \n",
       "26                   Malaysia          NaN       tenor           NaN   \n",
       "27                   Malaysia          NaN       tenor           NaN   \n",
       "28                   Malaysia          NaN       tenor           NaN   \n",
       "29                   Malaysia          NaN       tenor           NaN   \n",
       "..                        ...          ...         ...           ...   \n",
       "205  United States of America  Catholicism         NaN           NaN   \n",
       "206  United States of America  Catholicism         NaN           NaN   \n",
       "207  United States of America  Catholicism         NaN           NaN   \n",
       "208  United States of America  Catholicism         NaN           NaN   \n",
       "209  United States of America  Catholicism         NaN           NaN   \n",
       "210  United States of America  Catholicism         NaN           NaN   \n",
       "211  United States of America  Catholicism         NaN           NaN   \n",
       "212  United States of America  Catholicism         NaN           NaN   \n",
       "213  United States of America  Catholicism         NaN           NaN   \n",
       "214  United States of America  Catholicism         NaN           NaN   \n",
       "215  United States of America  Catholicism         NaN           NaN   \n",
       "216  United States of America  Catholicism         NaN           NaN   \n",
       "217  United States of America  Catholicism         NaN           NaN   \n",
       "218  United States of America  Catholicism         NaN           NaN   \n",
       "219  United States of America  Catholicism         NaN           NaN   \n",
       "220  United States of America  Catholicism         NaN           NaN   \n",
       "221  United States of America  Catholicism         NaN           NaN   \n",
       "222  United States of America  Catholicism         NaN           NaN   \n",
       "223  United States of America  Catholicism         NaN           NaN   \n",
       "224  United States of America  Catholicism         NaN           NaN   \n",
       "225  United States of America  Catholicism         NaN           NaN   \n",
       "226  United States of America  Catholicism         NaN           NaN   \n",
       "227  United States of America  Catholicism         NaN           NaN   \n",
       "228  United States of America  Catholicism         NaN           NaN   \n",
       "229  United States of America  Catholicism         NaN           NaN   \n",
       "230  United States of America  Catholicism         NaN           NaN   \n",
       "231  United States of America  Catholicism         NaN           NaN   \n",
       "232  United States of America  Catholicism         NaN           NaN   \n",
       "233  United States of America  Catholicism         NaN           NaN   \n",
       "234  United States of America  Catholicism         NaN           NaN   \n",
       "\n",
       "     native language   age  \n",
       "0                NaN  28.0  \n",
       "1                NaN  28.0  \n",
       "2                NaN  28.0  \n",
       "3                NaN  28.0  \n",
       "4                NaN  28.0  \n",
       "5                NaN  28.0  \n",
       "6                NaN  28.0  \n",
       "7                NaN  28.0  \n",
       "8                NaN  28.0  \n",
       "9                NaN  28.0  \n",
       "10               NaN  28.0  \n",
       "11               NaN  28.0  \n",
       "12               NaN  28.0  \n",
       "13               NaN  28.0  \n",
       "14               NaN  28.0  \n",
       "15               NaN  28.0  \n",
       "16               NaN  28.0  \n",
       "17               NaN  28.0  \n",
       "18               NaN  28.0  \n",
       "19               NaN  28.0  \n",
       "20               NaN  28.0  \n",
       "21               NaN  28.0  \n",
       "22               NaN  28.0  \n",
       "23               NaN  28.0  \n",
       "24               NaN  28.0  \n",
       "25               NaN  28.0  \n",
       "26               NaN  28.0  \n",
       "27               NaN  28.0  \n",
       "28               NaN  28.0  \n",
       "29               NaN  28.0  \n",
       "..               ...   ...  \n",
       "205              NaN  62.0  \n",
       "206              NaN  62.0  \n",
       "207              NaN  62.0  \n",
       "208              NaN  62.0  \n",
       "209              NaN  62.0  \n",
       "210              NaN  62.0  \n",
       "211              NaN  62.0  \n",
       "212              NaN  62.0  \n",
       "213              NaN  62.0  \n",
       "214              NaN  62.0  \n",
       "215              NaN  62.0  \n",
       "216              NaN  62.0  \n",
       "217              NaN  62.0  \n",
       "218              NaN  62.0  \n",
       "219              NaN  62.0  \n",
       "220              NaN  62.0  \n",
       "221              NaN  62.0  \n",
       "222              NaN  62.0  \n",
       "223              NaN  62.0  \n",
       "224              NaN  62.0  \n",
       "225              NaN  62.0  \n",
       "226              NaN  62.0  \n",
       "227              NaN  62.0  \n",
       "228              NaN  62.0  \n",
       "229              NaN  62.0  \n",
       "230              NaN  62.0  \n",
       "231              NaN  62.0  \n",
       "232              NaN  62.0  \n",
       "233              NaN  62.0  \n",
       "234              NaN  62.0  \n",
       "\n",
       "[235 rows x 34 columns]"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.merge(attributes,labels, on=\"filename\", how=\"inner\" )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "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.14"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}