032_spa_formants.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "6187e961-9f05-4a43-9f11-97235f633720",
   "metadata": {},
   "source": [
    "# Get Spanish Formant trajectories"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "58422808-6120-47a4-af32-7a11cb9b210c",
   "metadata": {},
   "outputs": [],
   "source": [
    "import parselmouth\n",
    "from parselmouth.praat import call\n",
    "import os\n",
    "import re\n",
    "import csv\n",
    "import pandas as pd\n",
    "from audiolabel import read_label"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1b074dd9-96fb-4fe7-a1cb-952d16d63678",
   "metadata": {},
   "source": [
    "### First get data for female speakers with max Hz set to 5500 Hz"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "9039c3d7-51aa-4621-8a97-159096138951",
   "metadata": {},
   "outputs": [],
   "source": [
    "# directory of MFA'ed TextGrids\n",
    "tg_path = 'data/spanish/female/'\n",
    "# directory of wav files\n",
    "wav_path = 'data/spanish/female/'\n",
    "# directory to save vowel measurement data\n",
    "data_path = 'data/'\n",
    "\n",
    "\n",
    "# formant analysis parameters\n",
    "time_step = 0.1\n",
    "maximum_number_of_formants = 5\n",
    "maximum_formant = 5500 # Hz for adult female\n",
    "window_length = 0.025 # seconds\n",
    "preemphasis_from = 50\n",
    "\n",
    "# take formant measurements every X seconds?\n",
    "segment_window = 0.005 # 5 milliseconds"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "994f5fb5-e0e8-4f58-8da0-186fad2eb168",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1 Processing file p111_spanish1.wav\n",
      "2 Processing file p111_spanish2.wav\n",
      "3 Processing file p111_spanish3.wav\n",
      "4 Processing file p113_spanish1.wav\n",
      "5 Processing file p113_spanish2.wav\n",
      "6 Processing file p113_spanish3.wav\n",
      "7 Processing file p114_spanish1.wav\n",
      "8 Processing file p114_spanish2.wav\n",
      "9 Processing file p114_spanish3.wav\n",
      "10 Processing file p117_spanish1.wav\n",
      "11 Processing file p117_spanish2.wav\n",
      "12 Processing file p117_spanish3.wav\n",
      "13 Processing file p118_spanish1.wav\n",
      "14 Processing file p118_spanish2.wav\n",
      "15 Processing file p118_spanish3.wav\n",
      "16 Processing file p120_spanish1.wav\n",
      "17 Processing file p120_spanish2.wav\n",
      "18 Processing file p120_spanish3.wav\n",
      "19 Processing file p121_spanish1.wav\n",
      "20 Processing file p121_spanish2.wav\n",
      "21 Processing file p121_spanish3.wav\n",
      "22 Processing file p122_spanish1.wav\n",
      "23 Processing file p122_spanish2.wav\n",
      "24 Processing file p122_spanish3.wav\n",
      "25 Processing file p123_spanish1.wav\n",
      "26 Processing file p123_spanish2.wav\n",
      "27 Processing file p123_spanish3.wav\n",
      "28 Processing file p124_spanish1.wav\n",
      "29 Processing file p124_spanish2.wav\n",
      "30 Processing file p124_spanish3.wav\n",
      "31 Processing file p126_spanish1.wav\n",
      "32 Processing file p126_spanish2.wav\n",
      "33 Processing file p126_spanish3.wav\n",
      "34 Processing file s05101.wav\n",
      "35 Processing file s05102.wav\n",
      "36 Processing file s05103.wav\n",
      "37 Processing file s05104.wav\n",
      "38 Processing file s05105.wav\n",
      "39 Processing file s05106.wav\n",
      "40 Processing file s05107.wav\n",
      "41 Processing file s05108.wav\n",
      "42 Processing file s05109.wav\n",
      "43 Processing file s05110.wav\n",
      "44 Processing file s05111.wav\n",
      "45 Processing file s05112.wav\n",
      "46 Processing file s05113.wav\n",
      "47 Processing file s05114.wav\n",
      "48 Processing file s05115.wav\n",
      "49 Processing file s05116.wav\n",
      "50 Processing file s05117.wav\n",
      "51 Processing file s05118.wav\n",
      "52 Processing file s05119.wav\n",
      "53 Processing file s05120.wav\n",
      "54 Processing file s05121.wav\n",
      "55 Processing file s05122.wav\n",
      "56 Processing file s05123.wav\n",
      "57 Processing file s05124.wav\n",
      "58 Processing file s05125.wav\n",
      "59 Processing file s05126.wav\n",
      "60 Processing file s05127.wav\n",
      "61 Processing file s05128.wav\n",
      "62 Processing file s05129.wav\n",
      "63 Processing file s05130.wav\n",
      "64 Processing file s05131.wav\n",
      "65 Processing file s05132.wav\n",
      "66 Processing file s05133.wav\n",
      "67 Processing file s05134.wav\n",
      "68 Processing file s05135.wav\n",
      "69 Processing file s05136.wav\n",
      "70 Processing file s05137.wav\n",
      "71 Processing file s05138.wav\n",
      "72 Processing file s05139.wav\n",
      "73 Processing file s05140.wav\n",
      "74 Processing file s05141.wav\n",
      "75 Processing file s05142.wav\n",
      "76 Processing file s05143.wav\n",
      "77 Processing file s05144.wav\n",
      "78 Processing file s05145.wav\n",
      "79 Processing file s05146.wav\n",
      "80 Processing file s05147.wav\n",
      "81 Processing file s05148.wav\n",
      "82 Processing file s05149.wav\n",
      "83 Processing file s05150.wav\n",
      "84 Processing file s05301.wav\n",
      "85 Processing file s05302.wav\n",
      "86 Processing file s05303.wav\n",
      "87 Processing file s05304.wav\n",
      "88 Processing file s05305.wav\n",
      "89 Processing file s05306.wav\n",
      "90 Processing file s05307.wav\n",
      "91 Processing file s05308.wav\n",
      "92 Processing file s05309.wav\n",
      "93 Processing file s05310.wav\n",
      "94 Processing file s05311.wav\n",
      "95 Processing file s05312.wav\n",
      "96 Processing file s05313.wav\n",
      "97 Processing file s05314.wav\n",
      "98 Processing file s05315.wav\n",
      "99 Processing file s05316.wav\n",
      "100 Processing file s05317.wav\n",
      "101 Processing file s05318.wav\n",
      "102 Processing file s05319.wav\n",
      "103 Processing file s05320.wav\n",
      "104 Processing file s05321.wav\n",
      "105 Processing file s05322.wav\n",
      "106 Processing file s05323.wav\n",
      "107 Processing file s05324.wav\n",
      "108 Processing file s05325.wav\n",
      "109 Processing file s05326.wav\n",
      "110 Processing file s05327.wav\n",
      "111 Processing file s05328.wav\n",
      "112 Processing file s05329.wav\n",
      "113 Processing file s05330.wav\n",
      "114 Processing file s05331.wav\n",
      "115 Processing file s05332.wav\n",
      "116 Processing file s05333.wav\n",
      "117 Processing file s05334.wav\n",
      "118 Processing file s05335.wav\n",
      "119 Processing file s05336.wav\n",
      "120 Processing file s05337.wav\n",
      "121 Processing file s05338.wav\n",
      "122 Processing file s05339.wav\n",
      "123 Processing file s05340.wav\n",
      "124 Processing file s05341.wav\n",
      "125 Processing file s05342.wav\n",
      "126 Processing file s05343.wav\n",
      "127 Processing file s05344.wav\n",
      "128 Processing file s05345.wav\n",
      "129 Processing file s05346.wav\n",
      "130 Processing file s05347.wav\n",
      "131 Processing file s05348.wav\n",
      "132 Processing file s05349.wav\n",
      "133 Processing file s05350.wav\n",
      "134 Processing file s05501.wav\n",
      "135 Processing file s05502.wav\n",
      "136 Processing file s05503.wav\n",
      "137 Processing file s05504.wav\n",
      "138 Processing file s05505.wav\n",
      "139 Processing file s05506.wav\n",
      "140 Processing file s05507.wav\n",
      "141 Processing file s05508.wav\n",
      "142 Processing file s05509.wav\n",
      "143 Processing file s05510.wav\n",
      "144 Processing file s05511.wav\n",
      "145 Processing file s05512.wav\n",
      "146 Processing file s05513.wav\n",
      "147 Processing file s05514.wav\n",
      "148 Processing file s05515.wav\n",
      "149 Processing file s05516.wav\n",
      "150 Processing file s05517.wav\n",
      "151 Processing file s05518.wav\n",
      "152 Processing file s05519.wav\n",
      "153 Processing file s05520.wav\n",
      "154 Processing file s05521.wav\n",
      "155 Processing file s05522.wav\n",
      "156 Processing file s05523.wav\n",
      "157 Processing file s05524.wav\n",
      "158 Processing file s05525.wav\n",
      "159 Processing file s05526.wav\n",
      "160 Processing file s05527.wav\n",
      "161 Processing file s05528.wav\n",
      "162 Processing file s05529.wav\n",
      "163 Processing file s05530.wav\n",
      "164 Processing file s05531.wav\n",
      "165 Processing file s05532.wav\n",
      "166 Processing file s05533.wav\n",
      "167 Processing file s05534.wav\n",
      "168 Processing file s05535.wav\n",
      "169 Processing file s05536.wav\n",
      "170 Processing file s05537.wav\n",
      "171 Processing file s05538.wav\n",
      "172 Processing file s05539.wav\n",
      "173 Processing file s05540.wav\n",
      "174 Processing file s05541.wav\n",
      "175 Processing file s05542.wav\n",
      "176 Processing file s05543.wav\n",
      "177 Processing file s05544.wav\n",
      "178 Processing file s05545.wav\n",
      "179 Processing file s05546.wav\n",
      "180 Processing file s05547.wav\n",
      "181 Processing file s05548.wav\n",
      "182 Processing file s05549.wav\n",
      "183 Processing file s05550.wav\n",
      "184 Processing file s05601.wav\n",
      "185 Processing file s05602.wav\n",
      "186 Processing file s05603.wav\n",
      "187 Processing file s05604.wav\n",
      "188 Processing file s05605.wav\n",
      "189 Processing file s05606.wav\n",
      "190 Processing file s05607.wav\n",
      "191 Processing file s05608.wav\n",
      "192 Processing file s05609.wav\n",
      "193 Processing file s05610.wav\n",
      "194 Processing file s05611.wav\n",
      "195 Processing file s05612.wav\n",
      "196 Processing file s05613.wav\n",
      "197 Processing file s05614.wav\n",
      "198 Processing file s05615.wav\n",
      "199 Processing file s05616.wav\n",
      "200 Processing file s05617.wav\n",
      "201 Processing file s05618.wav\n",
      "202 Processing file s05619.wav\n",
      "203 Processing file s05620.wav\n",
      "204 Processing file s05621.wav\n",
      "205 Processing file s05622.wav\n",
      "206 Processing file s05623.wav\n",
      "207 Processing file s05624.wav\n",
      "208 Processing file s05625.wav\n",
      "209 Processing file s05626.wav\n",
      "210 Processing file s05627.wav\n",
      "211 Processing file s05628.wav\n",
      "212 Processing file s05629.wav\n",
      "213 Processing file s05630.wav\n",
      "214 Processing file s05631.wav\n",
      "215 Processing file s05632.wav\n",
      "216 Processing file s05633.wav\n",
      "217 Processing file s05634.wav\n",
      "218 Processing file s05635.wav\n",
      "219 Processing file s05636.wav\n",
      "220 Processing file s05637.wav\n",
      "221 Processing file s05638.wav\n",
      "222 Processing file s05639.wav\n",
      "223 Processing file s05640.wav\n",
      "224 Processing file s05641.wav\n",
      "225 Processing file s05642.wav\n",
      "226 Processing file s05643.wav\n",
      "227 Processing file s05644.wav\n",
      "228 Processing file s05645.wav\n",
      "229 Processing file s05646.wav\n",
      "230 Processing file s05647.wav\n",
      "231 Processing file s05648.wav\n",
      "232 Processing file s05649.wav\n",
      "233 Processing file s05650.wav\n",
      "Done\n"
     ]
    }
   ],
   "source": [
    "# list (of dictionaries) to save results to\n",
    "data = []\n",
    "\n",
    "# counter to keep track of how long this script takes to run\n",
    "file_counter = 1\n",
    "\n",
    "for file in os.listdir(wav_path):\n",
    "    if file.endswith('.wav'):\n",
    "        \n",
    "        # Check if corresponding TextGrid exists\n",
    "        if os.path.exists(tg_path + file[:-4] + '.TextGrid'):\n",
    "            \n",
    "            # Print out which file we're currently working on\n",
    "            print(file_counter, 'Processing file', file)\n",
    "            file_counter += 1\n",
    "            \n",
    "            if file.startswith(\"s\"):\n",
    "                # names of tiers with phonemes of interest\n",
    "                phones_tiers = ['phone']\n",
    "            \n",
    "            else:\n",
    "                # names of tiers with phonemes of interest\n",
    "                phones_tiers = ['default - phones']\n",
    "            \n",
    "            # Create sound object\n",
    "            wav = parselmouth.Sound(wav_path + file)\n",
    "            \n",
    "            # Create formant object\n",
    "            formant = wav.to_formant_burg(time_step, maximum_number_of_formants, maximum_formant, window_length, preemphasis_from)\n",
    "            \n",
    "            # Open textgrid\n",
    "            tg = parselmouth.Data.read(tg_path + file[:-4] + '.TextGrid')\n",
    "            \n",
    "            # Iterate over the tiers and find the ones w/ phonemes\n",
    "            numTiers = call(tg, 'Get number of tiers')\n",
    "            for tierIdx in range(1, numTiers + 1): # Praat counts from 1, not 0\n",
    "                tierName = call(tg, 'Get tier name', tierIdx)\n",
    "                \n",
    "                if tierName in phones_tiers:\n",
    "                    numIntervals = call(tg, 'Get number of intervals', tierIdx)\n",
    "                    \n",
    "                    for intervalIdx in range(1, numIntervals + 1):\n",
    "                        label = call(tg, 'Get label of interval', tierIdx, intervalIdx)\n",
    "                        \n",
    "                        # check if interval label is a vowel,\n",
    "                        # i.e., it is not blank, and it ends in a digit\n",
    "                        vowel_list = [\"a\", \"a+\", \"e\", \"e+\", \"i\", \"i+\", \"o\", \"o+\", \"u\", \"u+\", \"aI\", \"aU\", \"oI\", \"j\", \"w\"]\n",
    "                        if label and label in vowel_list:\n",
    "                            start = call(tg, 'Get starting point', tierIdx, intervalIdx)\n",
    "                            end = call(tg, 'Get end point', tierIdx, intervalIdx)\n",
    "                            dur = end - start\n",
    "                            \n",
    "                            # number of X millisecond segments to take measurements from\n",
    "                            numSegments = int(dur / segment_window) # note: this must be an integer\n",
    "                            \n",
    "                            # loop over segments and calculate F1/F2\n",
    "                            for segmentIdx in range(1, numSegments + 1):\n",
    "                                spot = start + (segmentIdx * segment_window)\n",
    "                                tim_int = spot - start\n",
    "                                \n",
    "                                f1 = call(formant, 'Get value at time', 1, spot, 'Hertz', 'Linear')\n",
    "                                f2 = call(formant, 'Get value at time', 2, spot, 'Hertz', 'Linear')\n",
    "                                f3 = call(formant, 'Get value at time', 3, spot, 'Hertz', 'Linear')\n",
    "                                \n",
    "                                # add to our data set\n",
    "                                data.append({'Video ID': file[:-4],\n",
    "                                             'Vowel': label,\n",
    "                                             't1_ph': start,\n",
    "                                             'Time_of_formant_measurements': spot,\n",
    "                                             'Time_from_vowel_onset': tim_int,\n",
    "                                             'F1': f1,\n",
    "                                             'F2': f2,\n",
    "                                             'F3': f3,\n",
    "                                             'Tier': tierName,\n",
    "                                            })\n",
    "        \n",
    "print('Done')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5cbbe5cc-160f-4a3c-8705-a8785d5d9aee",
   "metadata": {},
   "source": [
    "Make sure to rename data for males so they can be run separately"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "ccf89e69-2cd1-41e1-8862-8c6e42435c3b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Video ID': 'p111_spanish1',\n",
       " 'Vowel': 'a',\n",
       " 't1_ph': 8.178,\n",
       " 'Time_of_formant_measurements': 8.183000000000002,\n",
       " 'Time_from_vowel_onset': 0.005000000000000782,\n",
       " 'F1': 579.9256822556335,\n",
       " 'F2': 1318.6660546903286,\n",
       " 'F3': 2603.4668149064714,\n",
       " 'Tier': 'default - phones'}"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "dcbe0d77-b788-4a5b-98c7-7d565e3fe6c3",
   "metadata": {},
   "source": [
    "### Now the male data, where max Hz set to 5000"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "f4074089-71e4-4199-b6de-69994aa352e7",
   "metadata": {},
   "outputs": [],
   "source": [
    "# directory of MFA'ed TextGrids\n",
    "tg_path = 'data/spanish/male/'\n",
    "# directory of wav files\n",
    "wav_path = 'data/spanish/male/'\n",
    "# directory to save vowel measurement data\n",
    "data_path = 'data/'\n",
    "\n",
    "\n",
    "# formant analysis parameters\n",
    "time_step = 0.1\n",
    "maximum_number_of_formants = 5\n",
    "maximum_formant = 5000 # Hz for adult male\n",
    "window_length = 0.025 # seconds\n",
    "preemphasis_from = 50\n",
    "\n",
    "# take formant measurements every X seconds?\n",
    "segment_window = 0.005 # 5 milliseconds"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "9545abf0-e4af-4973-b016-5d24a88e5511",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1 Processing file p119_spanish1.wav\n",
      "2 Processing file p119_spanish2.wav\n",
      "3 Processing file p119_spanish3.wav\n",
      "4 Processing file s00101.wav\n",
      "5 Processing file s00102.wav\n",
      "6 Processing file s00103.wav\n",
      "7 Processing file s00104.wav\n",
      "8 Processing file s00105.wav\n",
      "9 Processing file s00106.wav\n",
      "10 Processing file s00107.wav\n",
      "11 Processing file s00108.wav\n",
      "12 Processing file s00109.wav\n",
      "13 Processing file s00110.wav\n",
      "14 Processing file s00111.wav\n",
      "15 Processing file s00112.wav\n",
      "16 Processing file s00113.wav\n",
      "17 Processing file s00114.wav\n",
      "18 Processing file s00115.wav\n",
      "19 Processing file s00116.wav\n",
      "20 Processing file s00117.wav\n",
      "21 Processing file s00118.wav\n",
      "22 Processing file s00119.wav\n",
      "23 Processing file s00120.wav\n",
      "24 Processing file s00121.wav\n",
      "25 Processing file s00122.wav\n",
      "26 Processing file s00123.wav\n",
      "27 Processing file s00124.wav\n",
      "28 Processing file s00125.wav\n",
      "29 Processing file s00126.wav\n",
      "30 Processing file s00127.wav\n",
      "31 Processing file s00128.wav\n",
      "32 Processing file s00129.wav\n",
      "33 Processing file s00130.wav\n",
      "34 Processing file s00131.wav\n",
      "35 Processing file s00132.wav\n",
      "36 Processing file s00133.wav\n",
      "37 Processing file s00134.wav\n",
      "38 Processing file s00135.wav\n",
      "39 Processing file s00136.wav\n",
      "40 Processing file s00137.wav\n",
      "41 Processing file s00138.wav\n",
      "42 Processing file s00139.wav\n",
      "43 Processing file s00140.wav\n",
      "44 Processing file s00141.wav\n",
      "45 Processing file s00142.wav\n",
      "46 Processing file s00143.wav\n",
      "47 Processing file s00144.wav\n",
      "48 Processing file s00145.wav\n",
      "49 Processing file s00146.wav\n",
      "50 Processing file s00147.wav\n",
      "51 Processing file s00148.wav\n",
      "52 Processing file s00149.wav\n",
      "53 Processing file s00150.wav\n",
      "54 Processing file s00201.wav\n",
      "55 Processing file s00202.wav\n",
      "56 Processing file s00203.wav\n",
      "57 Processing file s00204.wav\n",
      "58 Processing file s00205.wav\n",
      "59 Processing file s00206.wav\n",
      "60 Processing file s00207.wav\n",
      "61 Processing file s00208.wav\n",
      "62 Processing file s00209.wav\n",
      "63 Processing file s00210.wav\n",
      "64 Processing file s00211.wav\n",
      "65 Processing file s00212.wav\n",
      "66 Processing file s00213.wav\n",
      "67 Processing file s00214.wav\n",
      "68 Processing file s00215.wav\n",
      "69 Processing file s00216.wav\n",
      "70 Processing file s00217.wav\n",
      "71 Processing file s00218.wav\n",
      "72 Processing file s00219.wav\n",
      "73 Processing file s00220.wav\n",
      "74 Processing file s00221.wav\n",
      "75 Processing file s00222.wav\n",
      "76 Processing file s00223.wav\n",
      "77 Processing file s00224.wav\n",
      "78 Processing file s00225.wav\n",
      "79 Processing file s00226.wav\n",
      "80 Processing file s00227.wav\n",
      "81 Processing file s00228.wav\n",
      "82 Processing file s00229.wav\n",
      "83 Processing file s00230.wav\n",
      "84 Processing file s00231.wav\n",
      "85 Processing file s00232.wav\n",
      "86 Processing file s00233.wav\n",
      "87 Processing file s00234.wav\n",
      "88 Processing file s00235.wav\n",
      "89 Processing file s00236.wav\n",
      "90 Processing file s00237.wav\n",
      "91 Processing file s00238.wav\n",
      "92 Processing file s00239.wav\n",
      "93 Processing file s00240.wav\n",
      "94 Processing file s00241.wav\n",
      "95 Processing file s00242.wav\n",
      "96 Processing file s00243.wav\n",
      "97 Processing file s00244.wav\n",
      "98 Processing file s00245.wav\n",
      "99 Processing file s00246.wav\n",
      "100 Processing file s00247.wav\n",
      "101 Processing file s00248.wav\n",
      "102 Processing file s00249.wav\n",
      "103 Processing file s00250.wav\n",
      "Done\n"
     ]
    }
   ],
   "source": [
    "# list (of dictionaries) to save results to\n",
    "data_male = []\n",
    "\n",
    "# counter to keep track of how long this script takes to run\n",
    "file_counter = 1\n",
    "\n",
    "for file in os.listdir(wav_path):\n",
    "    if file.endswith('.wav'):\n",
    "        \n",
    "        # Check if corresponding TextGrid exists\n",
    "        if os.path.exists(tg_path + file[:-4] + '.TextGrid'):\n",
    "            \n",
    "            # Print out which file we're currently working on\n",
    "            print(file_counter, 'Processing file', file)\n",
    "            file_counter += 1\n",
    "            \n",
    "            if file.startswith(\"s\"):\n",
    "                # names of tiers with phonemes of interest\n",
    "                phones_tiers = ['phone']\n",
    "            \n",
    "            else:\n",
    "                # names of tiers with phonemes of interest\n",
    "                phones_tiers = ['default - phones']\n",
    "            \n",
    "            # Create sound object\n",
    "            wav = parselmouth.Sound(wav_path + file)\n",
    "            \n",
    "            # Create formant object\n",
    "            formant = wav.to_formant_burg(time_step, maximum_number_of_formants, maximum_formant, window_length, preemphasis_from)\n",
    "            \n",
    "            # Open textgrid\n",
    "            tg = parselmouth.Data.read(tg_path + file[:-4] + '.TextGrid')\n",
    "            \n",
    "            # Iterate over the tiers and find the ones w/ phonemes\n",
    "            numTiers = call(tg, 'Get number of tiers')\n",
    "            for tierIdx in range(1, numTiers + 1): # Praat counts from 1, not 0\n",
    "                tierName = call(tg, 'Get tier name', tierIdx)\n",
    "                \n",
    "                if tierName in phones_tiers:\n",
    "                    numIntervals = call(tg, 'Get number of intervals', tierIdx)\n",
    "                    \n",
    "                    for intervalIdx in range(1, numIntervals + 1):\n",
    "                        label = call(tg, 'Get label of interval', tierIdx, intervalIdx)\n",
    "                        \n",
    "                        # check if interval label is a vowel,\n",
    "                        # i.e., it is not blank, and it ends in a digit\n",
    "                        vowel_list = [\"a\", \"a+\", \"e\", \"e+\", \"i\", \"i+\", \"o\", \"o+\", \"u\", \"u+\", \"aI\", \"aU\", \"oI\", \"j\", \"w\"]\n",
    "                        if label and label in vowel_list:\n",
    "                            start = call(tg, 'Get starting point', tierIdx, intervalIdx)\n",
    "                            end = call(tg, 'Get end point', tierIdx, intervalIdx)\n",
    "                            dur = end - start\n",
    "                            \n",
    "                            # number of X millisecond segments to take measurements from\n",
    "                            numSegments = int(dur / segment_window) # note: this must be an integer\n",
    "                            \n",
    "                            # loop over segments and calculate F1/F2\n",
    "                            for segmentIdx in range(1, numSegments + 1):\n",
    "                                spot = start + (segmentIdx * segment_window)\n",
    "                                tim_int = spot - start\n",
    "                                \n",
    "                                f1 = call(formant, 'Get value at time', 1, spot, 'Hertz', 'Linear')\n",
    "                                f2 = call(formant, 'Get value at time', 2, spot, 'Hertz', 'Linear')\n",
    "                                f3 = call(formant, 'Get value at time', 3, spot, 'Hertz', 'Linear')\n",
    "                                \n",
    "                                # add to our data set\n",
    "                                data_male.append({'Video ID': file[:-4],\n",
    "                                             'Vowel': label,\n",
    "                                             't1_ph': start,\n",
    "                                             'Time_of_formant_measurements': spot,\n",
    "                                             'Time_from_vowel_onset': tim_int,\n",
    "                                             'F1': f1,\n",
    "                                             'F2': f2,\n",
    "                                             'F3': f3,\n",
    "                                             'Tier': tierName,\n",
    "                                            })\n",
    "        \n",
    "print('Done')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "b99e8cc1-ed68-4cc9-a07a-d7e3e8114328",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Video ID': 'p119_spanish1',\n",
       " 'Vowel': 'a',\n",
       " 't1_ph': 64.827,\n",
       " 'Time_of_formant_measurements': 64.832,\n",
       " 'Time_from_vowel_onset': 0.0049999999999954525,\n",
       " 'F1': 638.6783281436159,\n",
       " 'F2': 1223.5057006037123,\n",
       " 'F3': 2640.21525844693,\n",
       " 'Tier': 'default - phones'}"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_male[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3b5308eb-6e02-4d93-85b4-ed30e8373b89",
   "metadata": {},
   "source": [
    "### Combine formant data and create DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "51bb456a-e0d1-47da-82f0-858730bb3731",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Video ID</th>\n",
       "      <th>Vowel</th>\n",
       "      <th>t1_ph</th>\n",
       "      <th>Time_of_formant_measurements</th>\n",
       "      <th>Time_from_vowel_onset</th>\n",
       "      <th>F1</th>\n",
       "      <th>F2</th>\n",
       "      <th>F3</th>\n",
       "      <th>Tier</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>98961</th>\n",
       "      <td>p118_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>76.198</td>\n",
       "      <td>76.243</td>\n",
       "      <td>0.045</td>\n",
       "      <td>659.990375</td>\n",
       "      <td>1506.636368</td>\n",
       "      <td>2657.549528</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>351577</th>\n",
       "      <td>s00128</td>\n",
       "      <td>i</td>\n",
       "      <td>1.463</td>\n",
       "      <td>1.503</td>\n",
       "      <td>0.040</td>\n",
       "      <td>293.938955</td>\n",
       "      <td>2055.809116</td>\n",
       "      <td>2901.571643</td>\n",
       "      <td>phone</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165402</th>\n",
       "      <td>p121_spanish3</td>\n",
       "      <td>a</td>\n",
       "      <td>275.024</td>\n",
       "      <td>275.089</td>\n",
       "      <td>0.065</td>\n",
       "      <td>853.630167</td>\n",
       "      <td>1714.294645</td>\n",
       "      <td>2789.465939</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254936</th>\n",
       "      <td>p126_spanish3</td>\n",
       "      <td>j</td>\n",
       "      <td>185.428</td>\n",
       "      <td>185.453</td>\n",
       "      <td>0.025</td>\n",
       "      <td>679.285254</td>\n",
       "      <td>2310.842689</td>\n",
       "      <td>2962.021673</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>353844</th>\n",
       "      <td>s00138</td>\n",
       "      <td>o</td>\n",
       "      <td>0.522</td>\n",
       "      <td>0.532</td>\n",
       "      <td>0.010</td>\n",
       "      <td>426.420652</td>\n",
       "      <td>1432.112157</td>\n",
       "      <td>2642.818171</td>\n",
       "      <td>phone</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>346199</th>\n",
       "      <td>s00104</td>\n",
       "      <td>a</td>\n",
       "      <td>1.424</td>\n",
       "      <td>1.499</td>\n",
       "      <td>0.075</td>\n",
       "      <td>1055.060125</td>\n",
       "      <td>2335.000175</td>\n",
       "      <td>2953.909775</td>\n",
       "      <td>phone</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151828</th>\n",
       "      <td>p121_spanish2</td>\n",
       "      <td>e</td>\n",
       "      <td>151.401</td>\n",
       "      <td>151.516</td>\n",
       "      <td>0.115</td>\n",
       "      <td>517.968364</td>\n",
       "      <td>1735.031739</td>\n",
       "      <td>2369.876739</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325357</th>\n",
       "      <td>p119_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>128.789</td>\n",
       "      <td>129.009</td>\n",
       "      <td>0.220</td>\n",
       "      <td>1019.400107</td>\n",
       "      <td>1878.236408</td>\n",
       "      <td>2931.310383</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77251</th>\n",
       "      <td>p117_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>115.374</td>\n",
       "      <td>115.449</td>\n",
       "      <td>0.075</td>\n",
       "      <td>601.960162</td>\n",
       "      <td>943.709018</td>\n",
       "      <td>2359.306308</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137410</th>\n",
       "      <td>p120_spanish3</td>\n",
       "      <td>o</td>\n",
       "      <td>273.987</td>\n",
       "      <td>274.127</td>\n",
       "      <td>0.140</td>\n",
       "      <td>786.945541</td>\n",
       "      <td>1786.270180</td>\n",
       "      <td>2238.905263</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68038</th>\n",
       "      <td>p114_spanish3</td>\n",
       "      <td>i</td>\n",
       "      <td>71.297</td>\n",
       "      <td>71.317</td>\n",
       "      <td>0.020</td>\n",
       "      <td>339.570096</td>\n",
       "      <td>2599.518627</td>\n",
       "      <td>3151.898373</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198500</th>\n",
       "      <td>p123_spanish2</td>\n",
       "      <td>e</td>\n",
       "      <td>123.019</td>\n",
       "      <td>123.054</td>\n",
       "      <td>0.035</td>\n",
       "      <td>719.308882</td>\n",
       "      <td>2205.722615</td>\n",
       "      <td>2470.836841</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98971</th>\n",
       "      <td>p118_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>76.198</td>\n",
       "      <td>76.293</td>\n",
       "      <td>0.095</td>\n",
       "      <td>659.895772</td>\n",
       "      <td>1563.369074</td>\n",
       "      <td>2741.882208</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33458</th>\n",
       "      <td>p113_spanish1</td>\n",
       "      <td>e</td>\n",
       "      <td>443.920</td>\n",
       "      <td>443.940</td>\n",
       "      <td>0.020</td>\n",
       "      <td>545.017144</td>\n",
       "      <td>1733.209620</td>\n",
       "      <td>2722.734463</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>369010</th>\n",
       "      <td>s00244</td>\n",
       "      <td>a</td>\n",
       "      <td>0.598</td>\n",
       "      <td>0.663</td>\n",
       "      <td>0.065</td>\n",
       "      <td>781.972300</td>\n",
       "      <td>1708.580538</td>\n",
       "      <td>2698.827255</td>\n",
       "      <td>phone</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127266</th>\n",
       "      <td>p120_spanish2</td>\n",
       "      <td>i</td>\n",
       "      <td>143.264</td>\n",
       "      <td>143.319</td>\n",
       "      <td>0.055</td>\n",
       "      <td>423.252344</td>\n",
       "      <td>2211.122558</td>\n",
       "      <td>2884.346090</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74691</th>\n",
       "      <td>p114_spanish3</td>\n",
       "      <td>a</td>\n",
       "      <td>307.226</td>\n",
       "      <td>307.236</td>\n",
       "      <td>0.010</td>\n",
       "      <td>724.419778</td>\n",
       "      <td>1691.343238</td>\n",
       "      <td>2774.642240</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175272</th>\n",
       "      <td>p122_spanish2</td>\n",
       "      <td>a</td>\n",
       "      <td>105.009</td>\n",
       "      <td>105.049</td>\n",
       "      <td>0.040</td>\n",
       "      <td>786.173041</td>\n",
       "      <td>1472.690901</td>\n",
       "      <td>2846.881957</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229185</th>\n",
       "      <td>p124_spanish3</td>\n",
       "      <td>o</td>\n",
       "      <td>281.298</td>\n",
       "      <td>281.383</td>\n",
       "      <td>0.085</td>\n",
       "      <td>789.235311</td>\n",
       "      <td>1487.412089</td>\n",
       "      <td>3195.033671</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223959</th>\n",
       "      <td>p124_spanish3</td>\n",
       "      <td>o</td>\n",
       "      <td>4.789</td>\n",
       "      <td>4.819</td>\n",
       "      <td>0.030</td>\n",
       "      <td>639.684400</td>\n",
       "      <td>1273.052191</td>\n",
       "      <td>3232.226906</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265334</th>\n",
       "      <td>s05124</td>\n",
       "      <td>e</td>\n",
       "      <td>0.703</td>\n",
       "      <td>0.748</td>\n",
       "      <td>0.045</td>\n",
       "      <td>624.237154</td>\n",
       "      <td>1949.597524</td>\n",
       "      <td>3063.786508</td>\n",
       "      <td>phone</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1212</th>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>53.303</td>\n",
       "      <td>53.328</td>\n",
       "      <td>0.025</td>\n",
       "      <td>838.815372</td>\n",
       "      <td>1698.782177</td>\n",
       "      <td>2600.576007</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6961</th>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>295.588</td>\n",
       "      <td>295.628</td>\n",
       "      <td>0.040</td>\n",
       "      <td>670.223427</td>\n",
       "      <td>1525.558831</td>\n",
       "      <td>1721.342765</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135624</th>\n",
       "      <td>p120_spanish3</td>\n",
       "      <td>o+</td>\n",
       "      <td>188.921</td>\n",
       "      <td>188.926</td>\n",
       "      <td>0.005</td>\n",
       "      <td>606.550195</td>\n",
       "      <td>1925.228503</td>\n",
       "      <td>2943.787770</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227796</th>\n",
       "      <td>p124_spanish3</td>\n",
       "      <td>o</td>\n",
       "      <td>216.190</td>\n",
       "      <td>216.195</td>\n",
       "      <td>0.005</td>\n",
       "      <td>404.245697</td>\n",
       "      <td>1619.159711</td>\n",
       "      <td>2966.490566</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Video ID Vowel    t1_ph  Time_of_formant_measurements  \\\n",
       "98961   p118_spanish1     a   76.198                        76.243   \n",
       "351577         s00128     i    1.463                         1.503   \n",
       "165402  p121_spanish3     a  275.024                       275.089   \n",
       "254936  p126_spanish3     j  185.428                       185.453   \n",
       "353844         s00138     o    0.522                         0.532   \n",
       "346199         s00104     a    1.424                         1.499   \n",
       "151828  p121_spanish2     e  151.401                       151.516   \n",
       "325357  p119_spanish1     o  128.789                       129.009   \n",
       "77251   p117_spanish1     a  115.374                       115.449   \n",
       "137410  p120_spanish3     o  273.987                       274.127   \n",
       "68038   p114_spanish3     i   71.297                        71.317   \n",
       "198500  p123_spanish2     e  123.019                       123.054   \n",
       "98971   p118_spanish1     a   76.198                        76.293   \n",
       "33458   p113_spanish1     e  443.920                       443.940   \n",
       "369010         s00244     a    0.598                         0.663   \n",
       "127266  p120_spanish2     i  143.264                       143.319   \n",
       "74691   p114_spanish3     a  307.226                       307.236   \n",
       "175272  p122_spanish2     a  105.009                       105.049   \n",
       "229185  p124_spanish3     o  281.298                       281.383   \n",
       "223959  p124_spanish3     o    4.789                         4.819   \n",
       "265334         s05124     e    0.703                         0.748   \n",
       "1212    p111_spanish1     a   53.303                        53.328   \n",
       "6961    p111_spanish1     a  295.588                       295.628   \n",
       "135624  p120_spanish3    o+  188.921                       188.926   \n",
       "227796  p124_spanish3     o  216.190                       216.195   \n",
       "\n",
       "        Time_from_vowel_onset           F1           F2           F3  \\\n",
       "98961                   0.045   659.990375  1506.636368  2657.549528   \n",
       "351577                  0.040   293.938955  2055.809116  2901.571643   \n",
       "165402                  0.065   853.630167  1714.294645  2789.465939   \n",
       "254936                  0.025   679.285254  2310.842689  2962.021673   \n",
       "353844                  0.010   426.420652  1432.112157  2642.818171   \n",
       "346199                  0.075  1055.060125  2335.000175  2953.909775   \n",
       "151828                  0.115   517.968364  1735.031739  2369.876739   \n",
       "325357                  0.220  1019.400107  1878.236408  2931.310383   \n",
       "77251                   0.075   601.960162   943.709018  2359.306308   \n",
       "137410                  0.140   786.945541  1786.270180  2238.905263   \n",
       "68038                   0.020   339.570096  2599.518627  3151.898373   \n",
       "198500                  0.035   719.308882  2205.722615  2470.836841   \n",
       "98971                   0.095   659.895772  1563.369074  2741.882208   \n",
       "33458                   0.020   545.017144  1733.209620  2722.734463   \n",
       "369010                  0.065   781.972300  1708.580538  2698.827255   \n",
       "127266                  0.055   423.252344  2211.122558  2884.346090   \n",
       "74691                   0.010   724.419778  1691.343238  2774.642240   \n",
       "175272                  0.040   786.173041  1472.690901  2846.881957   \n",
       "229185                  0.085   789.235311  1487.412089  3195.033671   \n",
       "223959                  0.030   639.684400  1273.052191  3232.226906   \n",
       "265334                  0.045   624.237154  1949.597524  3063.786508   \n",
       "1212                    0.025   838.815372  1698.782177  2600.576007   \n",
       "6961                    0.040   670.223427  1525.558831  1721.342765   \n",
       "135624                  0.005   606.550195  1925.228503  2943.787770   \n",
       "227796                  0.005   404.245697  1619.159711  2966.490566   \n",
       "\n",
       "                    Tier  \n",
       "98961   default - phones  \n",
       "351577             phone  \n",
       "165402  default - phones  \n",
       "254936  default - phones  \n",
       "353844             phone  \n",
       "346199             phone  \n",
       "151828  default - phones  \n",
       "325357  default - phones  \n",
       "77251   default - phones  \n",
       "137410  default - phones  \n",
       "68038   default - phones  \n",
       "198500  default - phones  \n",
       "98971   default - phones  \n",
       "33458   default - phones  \n",
       "369010             phone  \n",
       "127266  default - phones  \n",
       "74691   default - phones  \n",
       "175272  default - phones  \n",
       "229185  default - phones  \n",
       "223959  default - phones  \n",
       "265334             phone  \n",
       "1212    default - phones  \n",
       "6961    default - phones  \n",
       "135624  default - phones  \n",
       "227796  default - phones  "
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "formant_list = data + data_male\n",
    "formantdf = pd.DataFrame(formant_list)\n",
    "formantdf.sample(25)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "8d11e33a-7f09-4c29-a8db-bf5d21f3773e",
   "metadata": {},
   "outputs": [],
   "source": [
    "# save formants to csv\n",
    "formantdf.to_csv(\"data/formants_spa.csv\", index = False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "19e90bcd-b4eb-4ecc-bb00-8dc745b513b7",
   "metadata": {},
   "source": [
    "### Merge with tg df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "4ccacb21-f5bc-4877-930f-c0ed4501caf1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>t1_ph</th>\n",
       "      <th>t2_ph</th>\n",
       "      <th>fname</th>\n",
       "      <th>dur_ph</th>\n",
       "      <th>Participant</th>\n",
       "      <th>Corpus</th>\n",
       "      <th>t1_wd</th>\n",
       "      <th>t2_wd</th>\n",
       "      <th>word</th>\n",
       "      <th>is_wdinit_ph</th>\n",
       "      <th>is_wdfin_ph</th>\n",
       "      <th>is_stress</th>\n",
       "      <th>GP_ph</th>\n",
       "      <th>is_vowel</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>8.068</td>\n",
       "      <td>8.178</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.11</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>b</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>8.278</td>\n",
       "      <td>8.368</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.09</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>x</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>10.477</td>\n",
       "      <td>10.567</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.09</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>10.477</td>\n",
       "      <td>10.957</td>\n",
       "      <td>zombi</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>s</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    t1_ph   t2_ph                            fname  dur_ph Participant Corpus  \\\n",
       "0   8.068   8.178  data/tgs/p111_spanish1.TextGrid    0.11        p111   CBAS   \n",
       "1   8.178   8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "2   8.278   8.368  data/tgs/p111_spanish1.TextGrid    0.09        p111   CBAS   \n",
       "3   8.368   8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "4  10.477  10.567  data/tgs/p111_spanish1.TextGrid    0.09        p111   CBAS   \n",
       "\n",
       "    t1_wd   t2_wd   word  is_wdinit_ph  is_wdfin_ph  is_stress GP_ph  is_vowel  \n",
       "0   8.068   8.558   bajo          True        False          1     b         0  \n",
       "1   8.068   8.558   bajo         False        False          1     a         1  \n",
       "2   8.068   8.558   bajo         False        False          0     x         0  \n",
       "3   8.068   8.558   bajo         False         True          0     o         1  \n",
       "4  10.477  10.957  zombi          True        False          1     s         0  "
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tgdf = pd.read_csv(\"data/tg_data.csv\")\n",
    "tgdf.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0fef152e-9120-46ff-a233-e87046f2d989",
   "metadata": {},
   "source": [
    "Create new column `Video ID` that has rows of form `p111_spanish1`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "0ffbfb2c-39bb-4684-8e0c-7c15ff873725",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>t1_ph</th>\n",
       "      <th>t2_ph</th>\n",
       "      <th>fname</th>\n",
       "      <th>dur_ph</th>\n",
       "      <th>Participant</th>\n",
       "      <th>Corpus</th>\n",
       "      <th>t1_wd</th>\n",
       "      <th>t2_wd</th>\n",
       "      <th>word</th>\n",
       "      <th>is_wdinit_ph</th>\n",
       "      <th>is_wdfin_ph</th>\n",
       "      <th>is_stress</th>\n",
       "      <th>GP_ph</th>\n",
       "      <th>is_vowel</th>\n",
       "      <th>Video ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>8.068</td>\n",
       "      <td>8.178</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.11</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>b</td>\n",
       "      <td>0</td>\n",
       "      <td>p111_spanish1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>8.278</td>\n",
       "      <td>8.368</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.09</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>x</td>\n",
       "      <td>0</td>\n",
       "      <td>p111_spanish1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>10.477</td>\n",
       "      <td>10.567</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.09</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>10.477</td>\n",
       "      <td>10.957</td>\n",
       "      <td>zombi</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>s</td>\n",
       "      <td>0</td>\n",
       "      <td>p111_spanish1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    t1_ph   t2_ph                            fname  dur_ph Participant Corpus  \\\n",
       "0   8.068   8.178  data/tgs/p111_spanish1.TextGrid    0.11        p111   CBAS   \n",
       "1   8.178   8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "2   8.278   8.368  data/tgs/p111_spanish1.TextGrid    0.09        p111   CBAS   \n",
       "3   8.368   8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "4  10.477  10.567  data/tgs/p111_spanish1.TextGrid    0.09        p111   CBAS   \n",
       "\n",
       "    t1_wd   t2_wd   word  is_wdinit_ph  is_wdfin_ph  is_stress GP_ph  \\\n",
       "0   8.068   8.558   bajo          True        False          1     b   \n",
       "1   8.068   8.558   bajo         False        False          1     a   \n",
       "2   8.068   8.558   bajo         False        False          0     x   \n",
       "3   8.068   8.558   bajo         False         True          0     o   \n",
       "4  10.477  10.957  zombi          True        False          1     s   \n",
       "\n",
       "   is_vowel       Video ID  \n",
       "0         0  p111_spanish1  \n",
       "1         1  p111_spanish1  \n",
       "2         0  p111_spanish1  \n",
       "3         1  p111_spanish1  \n",
       "4         0  p111_spanish1  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tgdf['Video ID'] = tgdf['fname'].apply(lambda x: x[9:-9])\n",
    "tgdf.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8ed6db81-8d16-488c-b82d-33bc65b366a0",
   "metadata": {},
   "source": [
    "Now the two dataframes can be merged on `Video ID` and `t1_ph`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "8c11f6d7-e70b-4f18-b45e-3d66626e7ef2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>t1_ph</th>\n",
       "      <th>t2_ph</th>\n",
       "      <th>fname</th>\n",
       "      <th>dur_ph</th>\n",
       "      <th>Participant</th>\n",
       "      <th>Corpus</th>\n",
       "      <th>t1_wd</th>\n",
       "      <th>t2_wd</th>\n",
       "      <th>word</th>\n",
       "      <th>is_wdinit_ph</th>\n",
       "      <th>...</th>\n",
       "      <th>GP_ph</th>\n",
       "      <th>is_vowel</th>\n",
       "      <th>Video ID</th>\n",
       "      <th>Vowel</th>\n",
       "      <th>Time_of_formant_measurements</th>\n",
       "      <th>Time_from_vowel_onset</th>\n",
       "      <th>F1</th>\n",
       "      <th>F2</th>\n",
       "      <th>F3</th>\n",
       "      <th>Tier</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.183</td>\n",
       "      <td>0.005</td>\n",
       "      <td>579.925682</td>\n",
       "      <td>1318.666055</td>\n",
       "      <td>2603.466815</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.188</td>\n",
       "      <td>0.010</td>\n",
       "      <td>610.155201</td>\n",
       "      <td>1308.964840</td>\n",
       "      <td>2600.082277</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.193</td>\n",
       "      <td>0.015</td>\n",
       "      <td>640.384720</td>\n",
       "      <td>1299.263625</td>\n",
       "      <td>2596.697739</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.198</td>\n",
       "      <td>0.020</td>\n",
       "      <td>670.614239</td>\n",
       "      <td>1289.562411</td>\n",
       "      <td>2593.313201</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.203</td>\n",
       "      <td>0.025</td>\n",
       "      <td>700.843758</td>\n",
       "      <td>1279.861196</td>\n",
       "      <td>2589.928663</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.208</td>\n",
       "      <td>0.030</td>\n",
       "      <td>731.073276</td>\n",
       "      <td>1270.159981</td>\n",
       "      <td>2586.544125</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.213</td>\n",
       "      <td>0.035</td>\n",
       "      <td>761.302795</td>\n",
       "      <td>1260.458767</td>\n",
       "      <td>2583.159587</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.218</td>\n",
       "      <td>0.040</td>\n",
       "      <td>791.532314</td>\n",
       "      <td>1250.757552</td>\n",
       "      <td>2579.775049</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.223</td>\n",
       "      <td>0.045</td>\n",
       "      <td>821.761833</td>\n",
       "      <td>1241.056337</td>\n",
       "      <td>2576.390511</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.228</td>\n",
       "      <td>0.050</td>\n",
       "      <td>851.991352</td>\n",
       "      <td>1231.355123</td>\n",
       "      <td>2573.005973</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.233</td>\n",
       "      <td>0.055</td>\n",
       "      <td>832.989352</td>\n",
       "      <td>1225.132234</td>\n",
       "      <td>2579.897774</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.238</td>\n",
       "      <td>0.060</td>\n",
       "      <td>813.942657</td>\n",
       "      <td>1218.912503</td>\n",
       "      <td>2586.798903</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.243</td>\n",
       "      <td>0.065</td>\n",
       "      <td>794.895963</td>\n",
       "      <td>1212.692772</td>\n",
       "      <td>2593.700033</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.248</td>\n",
       "      <td>0.070</td>\n",
       "      <td>775.849268</td>\n",
       "      <td>1206.473042</td>\n",
       "      <td>2600.601162</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.253</td>\n",
       "      <td>0.075</td>\n",
       "      <td>756.802574</td>\n",
       "      <td>1200.253311</td>\n",
       "      <td>2607.502292</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.258</td>\n",
       "      <td>0.080</td>\n",
       "      <td>737.755879</td>\n",
       "      <td>1194.033580</td>\n",
       "      <td>2614.403421</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.263</td>\n",
       "      <td>0.085</td>\n",
       "      <td>718.709185</td>\n",
       "      <td>1187.813849</td>\n",
       "      <td>2621.304551</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.268</td>\n",
       "      <td>0.090</td>\n",
       "      <td>699.662490</td>\n",
       "      <td>1181.594118</td>\n",
       "      <td>2628.205681</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>8.178</td>\n",
       "      <td>8.278</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>a</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>8.273</td>\n",
       "      <td>0.095</td>\n",
       "      <td>680.615796</td>\n",
       "      <td>1175.374388</td>\n",
       "      <td>2635.106810</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.373</td>\n",
       "      <td>0.005</td>\n",
       "      <td>504.958975</td>\n",
       "      <td>1022.121142</td>\n",
       "      <td>2652.368114</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.378</td>\n",
       "      <td>0.010</td>\n",
       "      <td>508.723143</td>\n",
       "      <td>1012.694574</td>\n",
       "      <td>2645.849970</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.383</td>\n",
       "      <td>0.015</td>\n",
       "      <td>512.487311</td>\n",
       "      <td>1003.268006</td>\n",
       "      <td>2639.331827</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.388</td>\n",
       "      <td>0.020</td>\n",
       "      <td>516.251479</td>\n",
       "      <td>993.841437</td>\n",
       "      <td>2632.813683</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.393</td>\n",
       "      <td>0.025</td>\n",
       "      <td>520.015647</td>\n",
       "      <td>984.414869</td>\n",
       "      <td>2626.295539</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.398</td>\n",
       "      <td>0.030</td>\n",
       "      <td>523.779814</td>\n",
       "      <td>974.988301</td>\n",
       "      <td>2619.777396</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.403</td>\n",
       "      <td>0.035</td>\n",
       "      <td>527.543982</td>\n",
       "      <td>965.561732</td>\n",
       "      <td>2613.259252</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.408</td>\n",
       "      <td>0.040</td>\n",
       "      <td>531.308150</td>\n",
       "      <td>956.135164</td>\n",
       "      <td>2606.741108</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.413</td>\n",
       "      <td>0.045</td>\n",
       "      <td>535.072318</td>\n",
       "      <td>946.708596</td>\n",
       "      <td>2600.222965</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.418</td>\n",
       "      <td>0.050</td>\n",
       "      <td>538.836486</td>\n",
       "      <td>937.282027</td>\n",
       "      <td>2593.704821</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.423</td>\n",
       "      <td>0.055</td>\n",
       "      <td>542.600653</td>\n",
       "      <td>927.855459</td>\n",
       "      <td>2587.186677</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.428</td>\n",
       "      <td>0.060</td>\n",
       "      <td>546.364821</td>\n",
       "      <td>918.428890</td>\n",
       "      <td>2580.668534</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.433</td>\n",
       "      <td>0.065</td>\n",
       "      <td>573.043622</td>\n",
       "      <td>970.349578</td>\n",
       "      <td>2608.711802</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.438</td>\n",
       "      <td>0.070</td>\n",
       "      <td>599.743225</td>\n",
       "      <td>1022.325960</td>\n",
       "      <td>2636.786447</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.443</td>\n",
       "      <td>0.075</td>\n",
       "      <td>626.442829</td>\n",
       "      <td>1074.302342</td>\n",
       "      <td>2664.861093</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.448</td>\n",
       "      <td>0.080</td>\n",
       "      <td>653.142433</td>\n",
       "      <td>1126.278725</td>\n",
       "      <td>2692.935738</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.453</td>\n",
       "      <td>0.085</td>\n",
       "      <td>679.842037</td>\n",
       "      <td>1178.255107</td>\n",
       "      <td>2721.010383</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.458</td>\n",
       "      <td>0.090</td>\n",
       "      <td>706.541640</td>\n",
       "      <td>1230.231489</td>\n",
       "      <td>2749.085028</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.463</td>\n",
       "      <td>0.095</td>\n",
       "      <td>733.241244</td>\n",
       "      <td>1282.207871</td>\n",
       "      <td>2777.159674</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.468</td>\n",
       "      <td>0.100</td>\n",
       "      <td>759.940848</td>\n",
       "      <td>1334.184253</td>\n",
       "      <td>2805.234319</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.473</td>\n",
       "      <td>0.105</td>\n",
       "      <td>786.640451</td>\n",
       "      <td>1386.160635</td>\n",
       "      <td>2833.308964</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.478</td>\n",
       "      <td>0.110</td>\n",
       "      <td>813.340055</td>\n",
       "      <td>1438.137017</td>\n",
       "      <td>2861.383609</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.483</td>\n",
       "      <td>0.115</td>\n",
       "      <td>840.039659</td>\n",
       "      <td>1490.113399</td>\n",
       "      <td>2889.458255</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.488</td>\n",
       "      <td>0.120</td>\n",
       "      <td>866.739262</td>\n",
       "      <td>1542.089781</td>\n",
       "      <td>2917.532900</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.493</td>\n",
       "      <td>0.125</td>\n",
       "      <td>893.438866</td>\n",
       "      <td>1594.066163</td>\n",
       "      <td>2945.607545</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.498</td>\n",
       "      <td>0.130</td>\n",
       "      <td>920.138470</td>\n",
       "      <td>1646.042545</td>\n",
       "      <td>2973.682190</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.503</td>\n",
       "      <td>0.135</td>\n",
       "      <td>946.838074</td>\n",
       "      <td>1698.018927</td>\n",
       "      <td>3001.756836</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.508</td>\n",
       "      <td>0.140</td>\n",
       "      <td>973.537677</td>\n",
       "      <td>1749.995310</td>\n",
       "      <td>3029.831481</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.513</td>\n",
       "      <td>0.145</td>\n",
       "      <td>1000.237281</td>\n",
       "      <td>1801.971692</td>\n",
       "      <td>3057.906126</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.518</td>\n",
       "      <td>0.150</td>\n",
       "      <td>1026.936885</td>\n",
       "      <td>1853.948074</td>\n",
       "      <td>3085.980771</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>8.368</td>\n",
       "      <td>8.558</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.19</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>8.068</td>\n",
       "      <td>8.558</td>\n",
       "      <td>bajo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>o</td>\n",
       "      <td>8.523</td>\n",
       "      <td>0.155</td>\n",
       "      <td>1053.636488</td>\n",
       "      <td>1905.924456</td>\n",
       "      <td>3114.055417</td>\n",
       "      <td>default - phones</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>50 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    t1_ph  t2_ph                            fname  dur_ph Participant Corpus  \\\n",
       "0   8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "1   8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "2   8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "3   8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "4   8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "5   8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "6   8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "7   8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "8   8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "9   8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "10  8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "11  8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "12  8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "13  8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "14  8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "15  8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "16  8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "17  8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "18  8.178  8.278  data/tgs/p111_spanish1.TextGrid    0.10        p111   CBAS   \n",
       "19  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "20  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "21  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "22  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "23  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "24  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "25  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "26  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "27  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "28  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "29  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "30  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "31  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "32  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "33  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "34  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "35  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "36  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "37  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "38  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "39  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "40  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "41  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "42  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "43  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "44  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "45  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "46  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "47  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "48  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "49  8.368  8.558  data/tgs/p111_spanish1.TextGrid    0.19        p111   CBAS   \n",
       "\n",
       "    t1_wd  t2_wd  word  is_wdinit_ph  ...  GP_ph  is_vowel       Video ID  \\\n",
       "0   8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "1   8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "2   8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "3   8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "4   8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "5   8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "6   8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "7   8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "8   8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "9   8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "10  8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "11  8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "12  8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "13  8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "14  8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "15  8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "16  8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "17  8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "18  8.068  8.558  bajo         False  ...      a         1  p111_spanish1   \n",
       "19  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "20  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "21  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "22  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "23  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "24  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "25  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "26  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "27  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "28  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "29  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "30  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "31  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "32  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "33  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "34  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "35  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "36  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "37  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "38  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "39  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "40  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "41  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "42  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "43  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "44  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "45  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "46  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "47  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "48  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "49  8.068  8.558  bajo         False  ...      o         1  p111_spanish1   \n",
       "\n",
       "    Vowel Time_of_formant_measurements Time_from_vowel_onset           F1  \\\n",
       "0       a                        8.183                 0.005   579.925682   \n",
       "1       a                        8.188                 0.010   610.155201   \n",
       "2       a                        8.193                 0.015   640.384720   \n",
       "3       a                        8.198                 0.020   670.614239   \n",
       "4       a                        8.203                 0.025   700.843758   \n",
       "5       a                        8.208                 0.030   731.073276   \n",
       "6       a                        8.213                 0.035   761.302795   \n",
       "7       a                        8.218                 0.040   791.532314   \n",
       "8       a                        8.223                 0.045   821.761833   \n",
       "9       a                        8.228                 0.050   851.991352   \n",
       "10      a                        8.233                 0.055   832.989352   \n",
       "11      a                        8.238                 0.060   813.942657   \n",
       "12      a                        8.243                 0.065   794.895963   \n",
       "13      a                        8.248                 0.070   775.849268   \n",
       "14      a                        8.253                 0.075   756.802574   \n",
       "15      a                        8.258                 0.080   737.755879   \n",
       "16      a                        8.263                 0.085   718.709185   \n",
       "17      a                        8.268                 0.090   699.662490   \n",
       "18      a                        8.273                 0.095   680.615796   \n",
       "19      o                        8.373                 0.005   504.958975   \n",
       "20      o                        8.378                 0.010   508.723143   \n",
       "21      o                        8.383                 0.015   512.487311   \n",
       "22      o                        8.388                 0.020   516.251479   \n",
       "23      o                        8.393                 0.025   520.015647   \n",
       "24      o                        8.398                 0.030   523.779814   \n",
       "25      o                        8.403                 0.035   527.543982   \n",
       "26      o                        8.408                 0.040   531.308150   \n",
       "27      o                        8.413                 0.045   535.072318   \n",
       "28      o                        8.418                 0.050   538.836486   \n",
       "29      o                        8.423                 0.055   542.600653   \n",
       "30      o                        8.428                 0.060   546.364821   \n",
       "31      o                        8.433                 0.065   573.043622   \n",
       "32      o                        8.438                 0.070   599.743225   \n",
       "33      o                        8.443                 0.075   626.442829   \n",
       "34      o                        8.448                 0.080   653.142433   \n",
       "35      o                        8.453                 0.085   679.842037   \n",
       "36      o                        8.458                 0.090   706.541640   \n",
       "37      o                        8.463                 0.095   733.241244   \n",
       "38      o                        8.468                 0.100   759.940848   \n",
       "39      o                        8.473                 0.105   786.640451   \n",
       "40      o                        8.478                 0.110   813.340055   \n",
       "41      o                        8.483                 0.115   840.039659   \n",
       "42      o                        8.488                 0.120   866.739262   \n",
       "43      o                        8.493                 0.125   893.438866   \n",
       "44      o                        8.498                 0.130   920.138470   \n",
       "45      o                        8.503                 0.135   946.838074   \n",
       "46      o                        8.508                 0.140   973.537677   \n",
       "47      o                        8.513                 0.145  1000.237281   \n",
       "48      o                        8.518                 0.150  1026.936885   \n",
       "49      o                        8.523                 0.155  1053.636488   \n",
       "\n",
       "             F2           F3              Tier  \n",
       "0   1318.666055  2603.466815  default - phones  \n",
       "1   1308.964840  2600.082277  default - phones  \n",
       "2   1299.263625  2596.697739  default - phones  \n",
       "3   1289.562411  2593.313201  default - phones  \n",
       "4   1279.861196  2589.928663  default - phones  \n",
       "5   1270.159981  2586.544125  default - phones  \n",
       "6   1260.458767  2583.159587  default - phones  \n",
       "7   1250.757552  2579.775049  default - phones  \n",
       "8   1241.056337  2576.390511  default - phones  \n",
       "9   1231.355123  2573.005973  default - phones  \n",
       "10  1225.132234  2579.897774  default - phones  \n",
       "11  1218.912503  2586.798903  default - phones  \n",
       "12  1212.692772  2593.700033  default - phones  \n",
       "13  1206.473042  2600.601162  default - phones  \n",
       "14  1200.253311  2607.502292  default - phones  \n",
       "15  1194.033580  2614.403421  default - phones  \n",
       "16  1187.813849  2621.304551  default - phones  \n",
       "17  1181.594118  2628.205681  default - phones  \n",
       "18  1175.374388  2635.106810  default - phones  \n",
       "19  1022.121142  2652.368114  default - phones  \n",
       "20  1012.694574  2645.849970  default - phones  \n",
       "21  1003.268006  2639.331827  default - phones  \n",
       "22   993.841437  2632.813683  default - phones  \n",
       "23   984.414869  2626.295539  default - phones  \n",
       "24   974.988301  2619.777396  default - phones  \n",
       "25   965.561732  2613.259252  default - phones  \n",
       "26   956.135164  2606.741108  default - phones  \n",
       "27   946.708596  2600.222965  default - phones  \n",
       "28   937.282027  2593.704821  default - phones  \n",
       "29   927.855459  2587.186677  default - phones  \n",
       "30   918.428890  2580.668534  default - phones  \n",
       "31   970.349578  2608.711802  default - phones  \n",
       "32  1022.325960  2636.786447  default - phones  \n",
       "33  1074.302342  2664.861093  default - phones  \n",
       "34  1126.278725  2692.935738  default - phones  \n",
       "35  1178.255107  2721.010383  default - phones  \n",
       "36  1230.231489  2749.085028  default - phones  \n",
       "37  1282.207871  2777.159674  default - phones  \n",
       "38  1334.184253  2805.234319  default - phones  \n",
       "39  1386.160635  2833.308964  default - phones  \n",
       "40  1438.137017  2861.383609  default - phones  \n",
       "41  1490.113399  2889.458255  default - phones  \n",
       "42  1542.089781  2917.532900  default - phones  \n",
       "43  1594.066163  2945.607545  default - phones  \n",
       "44  1646.042545  2973.682190  default - phones  \n",
       "45  1698.018927  3001.756836  default - phones  \n",
       "46  1749.995310  3029.831481  default - phones  \n",
       "47  1801.971692  3057.906126  default - phones  \n",
       "48  1853.948074  3085.980771  default - phones  \n",
       "49  1905.924456  3114.055417  default - phones  \n",
       "\n",
       "[50 rows x 22 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "spa_tgformants = tgdf.merge(formantdf, on=['Video ID', 't1_ph'])\n",
    "spa_tgformants.head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "80c72517-6dad-41f4-bd3f-f011601c0619",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(355115, 22)"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "spa_tgformants.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0bd7c0ec-a603-4967-a69d-29d3ddf83a07",
   "metadata": {},
   "source": [
    "Add in language dominance information."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "098b16ae-35dd-45f8-ad0f-ac4a8248b92b",
   "metadata": {},
   "outputs": [],
   "source": [
    "langdom = pd.DataFrame({\"Participant\": ['p111', 'p113', 'p114', 'p117','p118', 'p119', 'p120', 'p121', 'p122', 'p123', 'p124', 'p126', 's051', 's053', 's055', 's056', 's001', 's002'],\n",
    "                       \"Dom\": [\"L2\", \"biling\", \"biling\", \"L2\", \"biling\", \"biling\", \"biling\", \"L2\", \"biling\", \"L2\", \"biling\", \"L2\", \"mono\", \"mono\", \"mono\", \"mono\", \"mono\", \"mono\"]})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "fdc00515-46ce-4a14-9dd5-de41facd8eb4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>t1_ph</th>\n",
       "      <th>t2_ph</th>\n",
       "      <th>fname</th>\n",
       "      <th>dur_ph</th>\n",
       "      <th>Participant</th>\n",
       "      <th>Corpus</th>\n",
       "      <th>t1_wd</th>\n",
       "      <th>t2_wd</th>\n",
       "      <th>word</th>\n",
       "      <th>is_wdinit_ph</th>\n",
       "      <th>...</th>\n",
       "      <th>is_vowel</th>\n",
       "      <th>Video ID</th>\n",
       "      <th>Vowel</th>\n",
       "      <th>Time_of_formant_measurements</th>\n",
       "      <th>Time_from_vowel_onset</th>\n",
       "      <th>F1</th>\n",
       "      <th>F2</th>\n",
       "      <th>F3</th>\n",
       "      <th>Tier</th>\n",
       "      <th>Dom</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>254678</th>\n",
       "      <td>159.417</td>\n",
       "      <td>159.607</td>\n",
       "      <td>data/tgs/p126_spanish1.TextGrid</td>\n",
       "      <td>0.190</td>\n",
       "      <td>p126</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>159.037</td>\n",
       "      <td>159.607</td>\n",
       "      <td>convoy</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>p126_spanish1</td>\n",
       "      <td>oI</td>\n",
       "      <td>159.472</td>\n",
       "      <td>0.055</td>\n",
       "      <td>656.511153</td>\n",
       "      <td>1224.573849</td>\n",
       "      <td>2948.632876</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>L2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258575</th>\n",
       "      <td>37.840</td>\n",
       "      <td>38.140</td>\n",
       "      <td>data/tgs/p126_spanish2.TextGrid</td>\n",
       "      <td>0.300</td>\n",
       "      <td>p126</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>37.840</td>\n",
       "      <td>38.140</td>\n",
       "      <td>hoy</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>p126_spanish2</td>\n",
       "      <td>oI</td>\n",
       "      <td>38.025</td>\n",
       "      <td>0.185</td>\n",
       "      <td>585.120140</td>\n",
       "      <td>1601.267958</td>\n",
       "      <td>2748.333918</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>L2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140663</th>\n",
       "      <td>146.172</td>\n",
       "      <td>146.272</td>\n",
       "      <td>data/tgs/p120_spanish1.TextGrid</td>\n",
       "      <td>0.100</td>\n",
       "      <td>p120</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>145.902</td>\n",
       "      <td>146.612</td>\n",
       "      <td>baliza</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>p120_spanish1</td>\n",
       "      <td>i</td>\n",
       "      <td>146.242</td>\n",
       "      <td>0.070</td>\n",
       "      <td>302.370388</td>\n",
       "      <td>2245.727048</td>\n",
       "      <td>3090.625502</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>biling</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79545</th>\n",
       "      <td>291.280</td>\n",
       "      <td>291.350</td>\n",
       "      <td>data/tgs/p117_spanish1.TextGrid</td>\n",
       "      <td>0.070</td>\n",
       "      <td>p117</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>291.280</td>\n",
       "      <td>291.970</td>\n",
       "      <td>amargas</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>p117_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>291.290</td>\n",
       "      <td>0.010</td>\n",
       "      <td>601.696188</td>\n",
       "      <td>1366.345256</td>\n",
       "      <td>2954.026484</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>L2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176518</th>\n",
       "      <td>292.738</td>\n",
       "      <td>292.978</td>\n",
       "      <td>data/tgs/p121_spanish2.TextGrid</td>\n",
       "      <td>0.240</td>\n",
       "      <td>p121</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>292.398</td>\n",
       "      <td>292.978</td>\n",
       "      <td>llave</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>p121_spanish2</td>\n",
       "      <td>e</td>\n",
       "      <td>292.903</td>\n",
       "      <td>0.165</td>\n",
       "      <td>764.375014</td>\n",
       "      <td>2326.820500</td>\n",
       "      <td>2972.874795</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>L2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89227</th>\n",
       "      <td>43.200</td>\n",
       "      <td>43.410</td>\n",
       "      <td>data/tgs/p117_spanish3.TextGrid</td>\n",
       "      <td>0.210</td>\n",
       "      <td>p117</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>42.860</td>\n",
       "      <td>43.410</td>\n",
       "      <td>harto</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>p117_spanish3</td>\n",
       "      <td>o</td>\n",
       "      <td>43.345</td>\n",
       "      <td>0.145</td>\n",
       "      <td>804.705760</td>\n",
       "      <td>1846.427142</td>\n",
       "      <td>3384.405734</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>L2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117830</th>\n",
       "      <td>144.852</td>\n",
       "      <td>144.902</td>\n",
       "      <td>data/tgs/p119_spanish1.TextGrid</td>\n",
       "      <td>0.050</td>\n",
       "      <td>p119</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>144.742</td>\n",
       "      <td>145.302</td>\n",
       "      <td>águilas</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>p119_spanish1</td>\n",
       "      <td>i</td>\n",
       "      <td>144.867</td>\n",
       "      <td>0.015</td>\n",
       "      <td>451.552872</td>\n",
       "      <td>2060.199878</td>\n",
       "      <td>2458.221435</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>biling</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201378</th>\n",
       "      <td>85.322</td>\n",
       "      <td>85.492</td>\n",
       "      <td>data/tgs/p122_spanish3.TextGrid</td>\n",
       "      <td>0.170</td>\n",
       "      <td>p122</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>84.862</td>\n",
       "      <td>85.492</td>\n",
       "      <td>convicto</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>p122_spanish3</td>\n",
       "      <td>o</td>\n",
       "      <td>85.482</td>\n",
       "      <td>0.160</td>\n",
       "      <td>778.399504</td>\n",
       "      <td>1679.287926</td>\n",
       "      <td>2757.961692</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>biling</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>292736</th>\n",
       "      <td>1.326</td>\n",
       "      <td>1.375</td>\n",
       "      <td>data/tgs/s00233.TextGrid</td>\n",
       "      <td>0.049</td>\n",
       "      <td>s002</td>\n",
       "      <td>DIMEx100</td>\n",
       "      <td>1.255</td>\n",
       "      <td>1.375</td>\n",
       "      <td>no</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>s00233</td>\n",
       "      <td>o</td>\n",
       "      <td>1.361</td>\n",
       "      <td>0.035</td>\n",
       "      <td>640.010069</td>\n",
       "      <td>1490.404080</td>\n",
       "      <td>2788.383900</td>\n",
       "      <td>phone</td>\n",
       "      <td>mono</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15237</th>\n",
       "      <td>189.200</td>\n",
       "      <td>189.360</td>\n",
       "      <td>data/tgs/p111_spanish2.TextGrid</td>\n",
       "      <td>0.160</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>188.720</td>\n",
       "      <td>189.360</td>\n",
       "      <td>alfombra</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>p111_spanish2</td>\n",
       "      <td>a</td>\n",
       "      <td>189.240</td>\n",
       "      <td>0.040</td>\n",
       "      <td>699.419593</td>\n",
       "      <td>1619.674360</td>\n",
       "      <td>2678.488907</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>L2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          t1_ph    t2_ph                            fname  dur_ph Participant  \\\n",
       "254678  159.417  159.607  data/tgs/p126_spanish1.TextGrid   0.190        p126   \n",
       "258575   37.840   38.140  data/tgs/p126_spanish2.TextGrid   0.300        p126   \n",
       "140663  146.172  146.272  data/tgs/p120_spanish1.TextGrid   0.100        p120   \n",
       "79545   291.280  291.350  data/tgs/p117_spanish1.TextGrid   0.070        p117   \n",
       "176518  292.738  292.978  data/tgs/p121_spanish2.TextGrid   0.240        p121   \n",
       "89227    43.200   43.410  data/tgs/p117_spanish3.TextGrid   0.210        p117   \n",
       "117830  144.852  144.902  data/tgs/p119_spanish1.TextGrid   0.050        p119   \n",
       "201378   85.322   85.492  data/tgs/p122_spanish3.TextGrid   0.170        p122   \n",
       "292736    1.326    1.375         data/tgs/s00233.TextGrid   0.049        s002   \n",
       "15237   189.200  189.360  data/tgs/p111_spanish2.TextGrid   0.160        p111   \n",
       "\n",
       "          Corpus    t1_wd    t2_wd      word  is_wdinit_ph  ...  is_vowel  \\\n",
       "254678      CBAS  159.037  159.607    convoy         False  ...         1   \n",
       "258575      CBAS   37.840   38.140       hoy          True  ...         1   \n",
       "140663      CBAS  145.902  146.612    baliza         False  ...         1   \n",
       "79545       CBAS  291.280  291.970   amargas          True  ...         1   \n",
       "176518      CBAS  292.398  292.978     llave         False  ...         1   \n",
       "89227       CBAS   42.860   43.410     harto         False  ...         1   \n",
       "117830      CBAS  144.742  145.302   águilas         False  ...         1   \n",
       "201378      CBAS   84.862   85.492  convicto         False  ...         1   \n",
       "292736  DIMEx100    1.255    1.375        no         False  ...         1   \n",
       "15237       CBAS  188.720  189.360  alfombra         False  ...         1   \n",
       "\n",
       "             Video ID Vowel  Time_of_formant_measurements  \\\n",
       "254678  p126_spanish1    oI                       159.472   \n",
       "258575  p126_spanish2    oI                        38.025   \n",
       "140663  p120_spanish1     i                       146.242   \n",
       "79545   p117_spanish1     a                       291.290   \n",
       "176518  p121_spanish2     e                       292.903   \n",
       "89227   p117_spanish3     o                        43.345   \n",
       "117830  p119_spanish1     i                       144.867   \n",
       "201378  p122_spanish3     o                        85.482   \n",
       "292736         s00233     o                         1.361   \n",
       "15237   p111_spanish2     a                       189.240   \n",
       "\n",
       "       Time_from_vowel_onset          F1           F2           F3  \\\n",
       "254678                 0.055  656.511153  1224.573849  2948.632876   \n",
       "258575                 0.185  585.120140  1601.267958  2748.333918   \n",
       "140663                 0.070  302.370388  2245.727048  3090.625502   \n",
       "79545                  0.010  601.696188  1366.345256  2954.026484   \n",
       "176518                 0.165  764.375014  2326.820500  2972.874795   \n",
       "89227                  0.145  804.705760  1846.427142  3384.405734   \n",
       "117830                 0.015  451.552872  2060.199878  2458.221435   \n",
       "201378                 0.160  778.399504  1679.287926  2757.961692   \n",
       "292736                 0.035  640.010069  1490.404080  2788.383900   \n",
       "15237                  0.040  699.419593  1619.674360  2678.488907   \n",
       "\n",
       "                    Tier     Dom  \n",
       "254678  default - phones      L2  \n",
       "258575  default - phones      L2  \n",
       "140663  default - phones  biling  \n",
       "79545   default - phones      L2  \n",
       "176518  default - phones      L2  \n",
       "89227   default - phones      L2  \n",
       "117830  default - phones  biling  \n",
       "201378  default - phones  biling  \n",
       "292736             phone    mono  \n",
       "15237   default - phones      L2  \n",
       "\n",
       "[10 rows x 23 columns]"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "spa_tgformants = spa_tgformants.merge(langdom, on = [\"Participant\"])\n",
    "spa_tgformants.sample(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cf04e9bd-9a5a-43c5-ad63-e57dd8aef238",
   "metadata": {},
   "source": [
    "Create column for average vowel duration, by Participant."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "67e9abe3-e250-4e40-b652-d63ad8059e94",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Participant</th>\n",
       "      <th>avg_dur</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>p111</td>\n",
       "      <td>0.120470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>p113</td>\n",
       "      <td>0.136585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>p114</td>\n",
       "      <td>0.158571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>p117</td>\n",
       "      <td>0.110605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>p118</td>\n",
       "      <td>0.113432</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Participant   avg_dur\n",
       "0        p111  0.120470\n",
       "1        p113  0.136585\n",
       "2        p114  0.158571\n",
       "3        p117  0.110605\n",
       "4        p118  0.113432"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "avg_dur = pd.DataFrame(spa_tgformants.groupby([\"Participant\"])[\"dur_ph\"].mean())\n",
    "avg_dur = avg_dur.rename(columns={\"dur_ph\": \"avg_dur\"})\n",
    "avg_dur = avg_dur.reset_index(drop = False)\n",
    "avg_dur.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "b8f12107-6c0b-4127-b18b-120134db97a0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>t1_ph</th>\n",
       "      <th>t2_ph</th>\n",
       "      <th>fname</th>\n",
       "      <th>dur_ph</th>\n",
       "      <th>Participant</th>\n",
       "      <th>Corpus</th>\n",
       "      <th>t1_wd</th>\n",
       "      <th>t2_wd</th>\n",
       "      <th>word</th>\n",
       "      <th>is_wdinit_ph</th>\n",
       "      <th>...</th>\n",
       "      <th>Video ID</th>\n",
       "      <th>Vowel</th>\n",
       "      <th>Time_of_formant_measurements</th>\n",
       "      <th>Time_from_vowel_onset</th>\n",
       "      <th>F1</th>\n",
       "      <th>F2</th>\n",
       "      <th>F3</th>\n",
       "      <th>Tier</th>\n",
       "      <th>Dom</th>\n",
       "      <th>avg_dur</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>11470</th>\n",
       "      <td>460.377</td>\n",
       "      <td>460.417</td>\n",
       "      <td>data/tgs/p111_spanish1.TextGrid</td>\n",
       "      <td>0.04</td>\n",
       "      <td>p111</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>460.167</td>\n",
       "      <td>460.897</td>\n",
       "      <td>presidente</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>p111_spanish1</td>\n",
       "      <td>i</td>\n",
       "      <td>460.387</td>\n",
       "      <td>0.010</td>\n",
       "      <td>391.273433</td>\n",
       "      <td>1689.053077</td>\n",
       "      <td>2819.876091</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>L2</td>\n",
       "      <td>0.120470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45525</th>\n",
       "      <td>64.528</td>\n",
       "      <td>64.608</td>\n",
       "      <td>data/tgs/p113_spanish3.TextGrid</td>\n",
       "      <td>0.08</td>\n",
       "      <td>p113</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>64.378</td>\n",
       "      <td>64.608</td>\n",
       "      <td>muy</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>p113_spanish3</td>\n",
       "      <td>j</td>\n",
       "      <td>64.583</td>\n",
       "      <td>0.055</td>\n",
       "      <td>475.978958</td>\n",
       "      <td>2018.910884</td>\n",
       "      <td>2896.605957</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>biling</td>\n",
       "      <td>0.136585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154925</th>\n",
       "      <td>156.273</td>\n",
       "      <td>156.423</td>\n",
       "      <td>data/tgs/p120_spanish3.TextGrid</td>\n",
       "      <td>0.15</td>\n",
       "      <td>p120</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>156.193</td>\n",
       "      <td>156.873</td>\n",
       "      <td>limbo</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>p120_spanish3</td>\n",
       "      <td>i</td>\n",
       "      <td>156.373</td>\n",
       "      <td>0.100</td>\n",
       "      <td>319.632891</td>\n",
       "      <td>632.412420</td>\n",
       "      <td>2693.291462</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>biling</td>\n",
       "      <td>0.140621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178923</th>\n",
       "      <td>74.600</td>\n",
       "      <td>74.700</td>\n",
       "      <td>data/tgs/p121_spanish3.TextGrid</td>\n",
       "      <td>0.10</td>\n",
       "      <td>p121</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>73.890</td>\n",
       "      <td>74.890</td>\n",
       "      <td>alumbrador</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>p121_spanish3</td>\n",
       "      <td>o</td>\n",
       "      <td>74.655</td>\n",
       "      <td>0.055</td>\n",
       "      <td>615.236577</td>\n",
       "      <td>1140.460094</td>\n",
       "      <td>2825.200258</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>L2</td>\n",
       "      <td>0.153949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206334</th>\n",
       "      <td>33.016</td>\n",
       "      <td>33.086</td>\n",
       "      <td>data/tgs/p123_spanish1.TextGrid</td>\n",
       "      <td>0.07</td>\n",
       "      <td>p123</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>32.946</td>\n",
       "      <td>33.586</td>\n",
       "      <td>carbono</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>p123_spanish1</td>\n",
       "      <td>a</td>\n",
       "      <td>33.036</td>\n",
       "      <td>0.020</td>\n",
       "      <td>677.317915</td>\n",
       "      <td>1696.055083</td>\n",
       "      <td>2488.443460</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>L2</td>\n",
       "      <td>0.131626</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128441</th>\n",
       "      <td>242.877</td>\n",
       "      <td>242.927</td>\n",
       "      <td>data/tgs/p119_spanish2.TextGrid</td>\n",
       "      <td>0.05</td>\n",
       "      <td>p119</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>242.667</td>\n",
       "      <td>243.367</td>\n",
       "      <td>revocar</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>p119_spanish2</td>\n",
       "      <td>e</td>\n",
       "      <td>242.892</td>\n",
       "      <td>0.015</td>\n",
       "      <td>363.574930</td>\n",
       "      <td>1827.486108</td>\n",
       "      <td>2252.279105</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>biling</td>\n",
       "      <td>0.141896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102074</th>\n",
       "      <td>257.162</td>\n",
       "      <td>257.292</td>\n",
       "      <td>data/tgs/p118_spanish1.TextGrid</td>\n",
       "      <td>0.13</td>\n",
       "      <td>p118</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>256.812</td>\n",
       "      <td>257.492</td>\n",
       "      <td>vainilla</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>p118_spanish1</td>\n",
       "      <td>i</td>\n",
       "      <td>257.207</td>\n",
       "      <td>0.045</td>\n",
       "      <td>377.417689</td>\n",
       "      <td>1651.281411</td>\n",
       "      <td>3155.685305</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>biling</td>\n",
       "      <td>0.113432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214343</th>\n",
       "      <td>36.210</td>\n",
       "      <td>36.280</td>\n",
       "      <td>data/tgs/p123_spanish2.TextGrid</td>\n",
       "      <td>0.07</td>\n",
       "      <td>p123</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>35.610</td>\n",
       "      <td>36.610</td>\n",
       "      <td>ubicaciones</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>p123_spanish2</td>\n",
       "      <td>o</td>\n",
       "      <td>36.255</td>\n",
       "      <td>0.045</td>\n",
       "      <td>737.614428</td>\n",
       "      <td>1510.343168</td>\n",
       "      <td>2620.050315</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>L2</td>\n",
       "      <td>0.131626</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70070</th>\n",
       "      <td>171.659</td>\n",
       "      <td>171.859</td>\n",
       "      <td>data/tgs/p114_spanish3.TextGrid</td>\n",
       "      <td>0.20</td>\n",
       "      <td>p114</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>171.419</td>\n",
       "      <td>171.859</td>\n",
       "      <td>pedí</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>p114_spanish3</td>\n",
       "      <td>i+</td>\n",
       "      <td>171.859</td>\n",
       "      <td>0.200</td>\n",
       "      <td>458.005003</td>\n",
       "      <td>2357.068575</td>\n",
       "      <td>3236.598929</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>biling</td>\n",
       "      <td>0.158571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263400</th>\n",
       "      <td>192.196</td>\n",
       "      <td>192.266</td>\n",
       "      <td>data/tgs/p126_spanish2.TextGrid</td>\n",
       "      <td>0.07</td>\n",
       "      <td>p126</td>\n",
       "      <td>CBAS</td>\n",
       "      <td>191.726</td>\n",
       "      <td>192.616</td>\n",
       "      <td>labios</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>p126_spanish2</td>\n",
       "      <td>o</td>\n",
       "      <td>192.231</td>\n",
       "      <td>0.035</td>\n",
       "      <td>537.481546</td>\n",
       "      <td>1859.949349</td>\n",
       "      <td>2884.633526</td>\n",
       "      <td>default - phones</td>\n",
       "      <td>L2</td>\n",
       "      <td>0.165465</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          t1_ph    t2_ph                            fname  dur_ph Participant  \\\n",
       "11470   460.377  460.417  data/tgs/p111_spanish1.TextGrid    0.04        p111   \n",
       "45525    64.528   64.608  data/tgs/p113_spanish3.TextGrid    0.08        p113   \n",
       "154925  156.273  156.423  data/tgs/p120_spanish3.TextGrid    0.15        p120   \n",
       "178923   74.600   74.700  data/tgs/p121_spanish3.TextGrid    0.10        p121   \n",
       "206334   33.016   33.086  data/tgs/p123_spanish1.TextGrid    0.07        p123   \n",
       "128441  242.877  242.927  data/tgs/p119_spanish2.TextGrid    0.05        p119   \n",
       "102074  257.162  257.292  data/tgs/p118_spanish1.TextGrid    0.13        p118   \n",
       "214343   36.210   36.280  data/tgs/p123_spanish2.TextGrid    0.07        p123   \n",
       "70070   171.659  171.859  data/tgs/p114_spanish3.TextGrid    0.20        p114   \n",
       "263400  192.196  192.266  data/tgs/p126_spanish2.TextGrid    0.07        p126   \n",
       "\n",
       "       Corpus    t1_wd    t2_wd         word  is_wdinit_ph  ...  \\\n",
       "11470    CBAS  460.167  460.897   presidente         False  ...   \n",
       "45525    CBAS   64.378   64.608          muy         False  ...   \n",
       "154925   CBAS  156.193  156.873        limbo         False  ...   \n",
       "178923   CBAS   73.890   74.890   alumbrador         False  ...   \n",
       "206334   CBAS   32.946   33.586      carbono         False  ...   \n",
       "128441   CBAS  242.667  243.367      revocar         False  ...   \n",
       "102074   CBAS  256.812  257.492     vainilla         False  ...   \n",
       "214343   CBAS   35.610   36.610  ubicaciones         False  ...   \n",
       "70070    CBAS  171.419  171.859         pedí         False  ...   \n",
       "263400   CBAS  191.726  192.616       labios         False  ...   \n",
       "\n",
       "             Video ID  Vowel Time_of_formant_measurements  \\\n",
       "11470   p111_spanish1      i                      460.387   \n",
       "45525   p113_spanish3      j                       64.583   \n",
       "154925  p120_spanish3      i                      156.373   \n",
       "178923  p121_spanish3      o                       74.655   \n",
       "206334  p123_spanish1      a                       33.036   \n",
       "128441  p119_spanish2      e                      242.892   \n",
       "102074  p118_spanish1      i                      257.207   \n",
       "214343  p123_spanish2      o                       36.255   \n",
       "70070   p114_spanish3     i+                      171.859   \n",
       "263400  p126_spanish2      o                      192.231   \n",
       "\n",
       "        Time_from_vowel_onset          F1           F2           F3  \\\n",
       "11470                   0.010  391.273433  1689.053077  2819.876091   \n",
       "45525                   0.055  475.978958  2018.910884  2896.605957   \n",
       "154925                  0.100  319.632891   632.412420  2693.291462   \n",
       "178923                  0.055  615.236577  1140.460094  2825.200258   \n",
       "206334                  0.020  677.317915  1696.055083  2488.443460   \n",
       "128441                  0.015  363.574930  1827.486108  2252.279105   \n",
       "102074                  0.045  377.417689  1651.281411  3155.685305   \n",
       "214343                  0.045  737.614428  1510.343168  2620.050315   \n",
       "70070                   0.200  458.005003  2357.068575  3236.598929   \n",
       "263400                  0.035  537.481546  1859.949349  2884.633526   \n",
       "\n",
       "                    Tier     Dom   avg_dur  \n",
       "11470   default - phones      L2  0.120470  \n",
       "45525   default - phones  biling  0.136585  \n",
       "154925  default - phones  biling  0.140621  \n",
       "178923  default - phones      L2  0.153949  \n",
       "206334  default - phones      L2  0.131626  \n",
       "128441  default - phones  biling  0.141896  \n",
       "102074  default - phones  biling  0.113432  \n",
       "214343  default - phones      L2  0.131626  \n",
       "70070   default - phones  biling  0.158571  \n",
       "263400  default - phones      L2  0.165465  \n",
       "\n",
       "[10 rows x 24 columns]"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "spa_tgformants = spa_tgformants.merge(avg_dur, on = [\"Participant\"])\n",
    "spa_tgformants.sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "da5a24d7-a89f-4069-9a70-b2145eabdd8e",
   "metadata": {},
   "outputs": [],
   "source": [
    "spa_tgformants.to_csv(\"data/spanish_vowels.csv\", index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "24c731b3-da27-4180-b557-04b3a5a4da8e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(17608,)"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "df = pd.read_csv(\"data/spanish_vowels.csv\")\n",
    "#df_cbas = df[df['Corpus']=='CBAS'].copy()\n",
    "df_no126 = df[df[\"Participant\"]!=\"p126\"].copy()\n",
    "df_no126.groupby(['Participant','t1_ph'])[\"Vowel\"].count().shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "aee895ca-ae06-4a4a-b86b-9226cdc93c1a",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}