bias_nonparametric.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import json\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import pickle\n",
    "from scipy.stats import binom, norm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018\n"
     ]
    }
   ],
   "source": [
    "with open('seasons.pickle') as f:\n",
    "    seasons = pickle.load(f)\n",
    "for year, season in seasons.iteritems():\n",
    "    print year,\n",
    "    season.load_scores()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "scores = pd.read_csv('pd_data/judge_scores.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "scores['same_country'] = scores.apply(lambda row: 1 if row.country == row.judge_country else 0, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "scores['is_larger'] = scores.apply(lambda row: 1 if row.judge_score > row.med_score else 0, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "scores['dist_med'] = scores.apply(lambda row: row.judge_score - row.med_score, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "scores_not_med = scores[scores.judge_score != scores.med_score]\n",
    "scores_med     = scores[scores.judge_score == scores.med_score]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def critical_values(n, cv=1.96):\n",
    "    lower = -cv * np.sqrt(n*0.25) + 0.5*n + 0.5\n",
    "    upper =  cv * np.sqrt(n*0.25) + 0.5*n - 0.5\n",
    "    return (lower, upper)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/anaconda/lib/python2.7/site-packages/ipykernel/__main__.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  if __name__ == '__main__':\n"
     ]
    }
   ],
   "source": [
    "scores_not_med['judge_n'] = scores_not_med.apply(lambda row: 1 if row.country == row.judge_country else -1, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/anaconda/lib/python2.7/site-packages/ipykernel/__main__.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  if __name__ == '__main__':\n"
     ]
    }
   ],
   "source": [
    "scores_not_med['u'] = scores_not_med.apply(lambda row: 1 if row.is_larger == row.same_country else 0, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "244"
      ]
     },
     "execution_count": 160,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(scores_not_med.judge.unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 170,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "nation_count = {}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 180,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "significant_judges = set()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 183,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(104, 244)"
      ]
     },
     "execution_count": 183,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(significant_judges), len(scores_not_med.judge.unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 181,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1.11022302463e-16 0.769616026711 461 599\n",
      "Cynthia BENSON CAN *\n",
      "\n",
      "0.999999999997 0.282258064516 70 248\n",
      "Franco BENINI ITA\n",
      "\n",
      "1.11022302463e-16 0.740776699029 763 1030\n",
      "Tianyi ZHANG CHN *\n",
      "\n",
      "0.00117111841519 0.542426645519 684 1261\n",
      "Masako KUBOTA JPN\n",
      "\n",
      "0.00207532339854 0.545086119554 538 987\n",
      "Alexei BELETSKI ISR\n",
      "\n",
      "0.999999997482 0.428141912207 712 1663\n",
      "Yuri GUSKOV KAZ\n",
      "\n",
      "0.0957479675601 0.55652173913 64 115\n",
      "Kristina LUNDGREN USA\n",
      "\n",
      "1.11022302463e-16 0.725609756098 476 656\n",
      "Lisa JELINEK AUS *\n",
      "\n",
      "1.11022302463e-16 0.644903397735 968 1501\n",
      "Maira ABASOVA RUS *\n",
      "\n",
      "1.55431223448e-15 0.712121212121 235 330\n",
      "Robert ROSENBLUTH USA *\n",
      "\n",
      "1.88490112407e-10 0.633644859813 339 535\n",
      "Mayumi KATO JPN *\n",
      "\n",
      "1.01030295241e-14 0.642857142857 450 700\n",
      "Sviatoslav BABENKO RUS *\n",
      "\n",
      "0.000138639812114 0.547819971871 779 1422\n",
      "Tanay OZKAN TUR *\n",
      "\n",
      "1.11022302463e-16 0.621473354232 793 1276\n",
      "Chihee RHEE KOR *\n",
      "\n",
      "0.95737936475 0.480519480519 962 2002\n",
      "Agita ABELE LAT\n",
      "\n",
      "0.00637960593868 0.53732718894 583 1085\n",
      "Anthony LEROY FRA\n",
      "\n",
      "3.93934496077e-05 0.600536193029 224 373\n",
      "Andre-Marc ALLAIN CAN *\n",
      "\n",
      "8.61921506634e-05 0.672727272727 74 110\n",
      "Taffy HOLLIDAY USA *\n",
      "\n",
      "9.96134286169e-11 0.609696969697 503 825\n",
      "Massimo ORLANDINI ITA *\n",
      "\n",
      "1.11022302463e-16 0.73461823573 991 1349\n",
      "Sharon ROGERS USA *\n",
      "\n",
      "2.09275508034e-09 0.644278606965 259 402\n",
      "Anne CAMMETT USA *\n",
      "\n",
      "0.296188085216 0.511848341232 216 422\n",
      "Wei SHI CHN\n",
      "\n",
      "4.77395900589e-15 0.64776119403 434 670\n",
      "Lynne DEY CAN *\n",
      "\n",
      "7.19602852236e-05 0.598337950139 216 361\n",
      "Marco BUTTARELLI ITA *\n",
      "\n",
      "8.04635913454e-10 0.615615615616 410 666\n",
      "Igor OBRAZTSOV RUS *\n",
      "\n",
      "1.11022302463e-16 0.70297029703 497 707\n",
      "Vera TAUCHMANOVA CZE *\n",
      "\n",
      "1.0 0.39306640625 805 2048\n",
      "Saodat NUMANOVA UZB\n",
      "\n",
      "2.44714831545e-05 0.578947368421 374 646\n",
      "Kenji AMAKO JPN *\n",
      "\n",
      "1.09085956723e-06 0.674285714286 118 175\n",
      "Natan KFIR ISR *\n",
      "\n",
      "0.737069009116 0.484599589322 236 487\n",
      "Katarina HENRIKSSON SWE\n",
      "\n",
      "1.11022302463e-16 0.628592483419 853 1357\n",
      "Feng HUANG CHN *\n",
      "\n",
      "0.999887683365 0.392739273927 119 303\n",
      "Karen HOWARD CAN\n",
      "\n",
      "3.20853343894e-11 0.70325203252 173 246\n",
      "Andreas WALDECK GER *\n",
      "\n",
      "0.99754609075 0.446629213483 318 712\n",
      "Lolita LABUNSKAIYA RUS\n",
      "\n",
      "1.11022302463e-16 0.684738955823 341 498\n",
      "Andrea DERBY CAN *\n",
      "\n",
      "0.000341277083286 0.586956521739 216 368\n",
      "Jeroen PRINS NED\n",
      "\n",
      "4.10470102352e-10 0.675767918089 198 293\n",
      "Michela CESARO ITA *\n",
      "\n",
      "1.11022302463e-16 0.790035587189 222 281\n",
      "Sylvain GUIBORD CAN *\n",
      "\n",
      "1.11022302463e-16 0.711670480549 311 437\n",
      "Richard DALLEY USA *\n",
      "\n",
      "0.999999616334 0.333333333333 74 222\n",
      "Leo  LENKOLA FIN\n",
      "\n",
      "1.11022302463e-16 0.662782727896 967 1459\n",
      "Anna KANTOR ISR *\n",
      "\n",
      "0.999986879732 0.427218934911 361 845\n",
      "Philippe MERIGUET FRA\n",
      "\n",
      "9.58244877558e-07 0.596314907873 356 597\n",
      "Wendy ENZMANN USA *\n",
      "\n",
      "0.999690960193 0.440334128878 369 838\n",
      "Nobuhiko YOSHIOKA JPN\n",
      "\n",
      "1.33881317144e-09 0.607764390897 454 747\n",
      "Janice HUNTER CAN *\n",
      "\n",
      "0.00370327518297 0.582995951417 144 247\n",
      "Emilie BILLOW SWE\n",
      "\n",
      "0.00811020481099 0.57196969697 151 264\n",
      "Tatiana SHARKINA RUS\n",
      "\n",
      "0.995465762892 0.440404040404 218 495\n",
      "David MUNOZ ESP\n",
      "\n",
      "0.00343020747419 0.568733153639 211 371\n",
      "Igor DOLGUSHIN RUS\n",
      "\n",
      "0.00443679518991 0.6 96 160\n",
      "Aigul KUANISHEVA KAZ\n",
      "\n",
      "0.0367878600406 0.530177514793 448 845\n",
      "Dan FANG CHN\n",
      "\n",
      "0.000369727460869 0.557971014493 462 828\n",
      "Paolo PIZZOCARI ITA\n",
      "\n",
      "1.11022302463e-16 0.676511954993 481 711\n",
      "Leslie KEEN CAN *\n",
      "\n",
      "0.988009528356 0.427450980392 109 255\n",
      "Lenka BOHUNICKA SVK\n",
      "\n",
      "2.55351295664e-15 0.630385487528 556 882\n",
      "Elke TREITZ GER *\n",
      "\n",
      "0.233985817328 0.513821138211 316 615\n",
      "Laimute KRAUZIENE LTU\n",
      "\n",
      "1.11022302463e-16 0.602010644589 1018 1691\n",
      "Elena FOMINA RUS *\n",
      "\n",
      "0.050232011684 0.533687943262 301 564\n",
      "Alexandre GOROJDANOV BLR\n",
      "\n",
      "0.000389034472819 0.553169734151 541 978\n",
      "Julia ANDREEVA RUS\n",
      "\n",
      "4.84961621305e-07 0.739583333333 71 96\n",
      "Rossella CECCATTINI ITA *\n",
      "\n",
      "0.000169572519734 0.559863169897 491 877\n",
      "Elisabeth LOUESDON FRA *\n",
      "\n",
      "5.00904133727e-08 0.56703014753 884 1559\n",
      "Daniel DELFA ESP *\n",
      "\n",
      "9.3913765653e-13 0.666666666667 288 432\n",
      "Steve WINKLER USA *\n",
      "\n",
      "3.55802780474e-05 0.559633027523 610 1090\n",
      "Francoise DE RAPPARD BEL *\n",
      "\n",
      "1.11022302463e-16 0.717831482691 1099 1531\n",
      "Olga KOZHEMIAKINA RUS *\n",
      "\n",
      "1.11022302463e-16 0.749486652977 730 974\n",
      "Richard KOSINA CZE *\n",
      "\n",
      "0.999507677166 0.421633554084 191 453\n",
      "Christiane MOERTH AUT\n",
      "\n",
      "7.77156117238e-16 0.726962457338 213 293\n",
      "Dagmar LURZ-PROTT GER *\n",
      "\n",
      "1.11022302463e-16 0.704383282365 691 981\n",
      "So-Young AN KOR *\n",
      "\n",
      "0.999838689885 0.410628019324 170 414\n",
      "Veronique VERRUE FRA\n",
      "\n",
      "0.393085379669 0.505112474438 247 489\n",
      "Jodi ABBOTT CAN\n",
      "\n",
      "1.11022302463e-16 0.766519823789 174 227\n",
      "Sissy KRICK GER *\n",
      "\n",
      "0.945571517795 0.393939393939 26 66\n",
      "Helene CUCUPHAT FRA\n",
      "\n",
      "1.11022302463e-16 0.66757493188 490 734\n",
      "Christine HURTH FRA *\n",
      "\n",
      "0.888561172708 0.432989690722 42 97\n",
      "Elena LISOVA UKR\n",
      "\n",
      "2.6781910023e-12 0.687116564417 224 326\n",
      "John MILLIER USA *\n",
      "\n",
      "1.11022302463e-16 0.677852348993 707 1043\n",
      "Jeff LUKASIK CAN *\n",
      "\n",
      "1.11022302463e-16 0.636682242991 1090 1712\n",
      "Weiguang CHEN CHN *\n",
      "\n",
      "5.55111512313e-16 0.704918032787 258 366\n",
      "Samuel AUXIER USA *\n",
      "\n",
      "1.11022302463e-16 0.676075268817 503 744\n",
      "Malgorzata SOBKOW POL *\n",
      "\n",
      "0.999896884759 0.440763052209 439 996\n",
      "Albert ZAYDMAN ISR\n",
      "\n",
      "0.621490893525 0.494089834515 418 846\n",
      "Shizuko UGAKI JPN\n",
      "\n",
      "0.94454082517 0.415841584158 42 101\n",
      "Marketa HORKLOVA CZE\n",
      "\n",
      "0.999987383078 0.422459893048 316 748\n",
      "Sandra WILLIAMSON-LEADLEY NZL\n",
      "\n",
      "4.37427649574e-05 0.587991718427 284 483\n",
      "Karen BUTCHER CAN *\n",
      "\n",
      "0.000561452598117 0.625 100 160\n",
      "Guona ZHAO CHN\n",
      "\n",
      "0.998199395655 0.427184466019 176 412\n",
      "Claudia BRAMBATI ITA\n",
      "\n",
      "0.999592041294 0.405572755418 131 323\n",
      "Patricia MORITZ AUS\n",
      "\n",
      "0.60172004081 0.492021276596 185 376\n",
      "Mona JONSSON SWE\n",
      "\n",
      "1.52100554374e-14 0.74449339207 169 227\n",
      "Melody Tan Tan YIP HKG *\n",
      "\n",
      "0.00921667646573 0.614583333333 59 96\n",
      "Yu WANG CHN\n",
      "\n",
      "1.11022302463e-16 0.688218390805 479 696\n",
      "Kerstin KIMMINUS GER *\n",
      "\n",
      "1.0 0.181818181818 22 121\n",
      "Evgeni ROKHIN UZB\n",
      "\n",
      "0.000508110475674 0.670588235294 57 85\n",
      "Jennifer MAST USA\n",
      "\n",
      "1.11022302463e-16 0.664095972579 775 1167\n",
      "Leanna CARON CAN *\n",
      "\n",
      "0.188843392909 0.52972972973 98 185\n",
      "Tomiko YAMADA JPN\n",
      "\n",
      "7.12923619384e-06 0.582959641256 390 669\n",
      "Roger GLENN USA *\n",
      "\n",
      "0.69088750407 0.484662576687 158 326\n",
      "Irina KOMARNICKA LAT\n",
      "\n",
      "0.99752828553 0.412639405204 111 269\n",
      "Allan BOEHM SVK\n",
      "\n",
      "1.11022302463e-16 0.691721132898 635 918\n",
      "Walter TOIGO ITA *\n",
      "\n",
      "2.51607779056e-09 0.731543624161 109 149\n",
      "Makoto KANO JPN *\n",
      "\n",
      "0.00100820664639 0.577836411609 219 379\n",
      "Danuta DUBROWKO POL\n",
      "\n",
      "0.990331985513 0.446464646465 221 495\n",
      "Reaghan FAWCETT CAN\n",
      "\n",
      "1.0 0.329218106996 160 486\n",
      "Elizabeth RYAN AUS\n",
      "\n",
      "4.70623540139e-13 0.676844783715 266 393\n",
      "Kathleen HARMON USA *\n",
      "\n",
      "1.16645564741e-06 0.581032412965 484 833\n",
      "Sakae YAMAMOTO JPN *\n",
      "\n",
      "1.11022302463e-16 0.696065128901 513 737\n",
      "Ulla FAIG GER *\n",
      "\n",
      "0.999999999886 0.339331619537 132 389\n",
      "Kaoru TAKINO JPN\n",
      "\n",
      "1.11022302463e-16 0.705989110708 389 551\n",
      "Isabella MICHELI ITA *\n",
      "\n",
      "0.000498911807847 0.61421319797 121 197\n",
      "Jezabel DABOUIS FRA\n",
      "\n",
      "1.11022302463e-16 0.652232746955 482 739\n",
      "Ayumi KOZUKA JPN *\n",
      "\n",
      "0.0595447866396 0.550458715596 120 218\n",
      "Beth CRANE CAN\n",
      "\n",
      "1.11022302463e-16 0.671428571429 376 560\n",
      "Jung-Sue LEE KOR *\n",
      "\n",
      "0.193404953767 0.511004126547 743 1454\n",
      "Marta OLOZAGARRE ESP\n",
      "\n",
      "0.779059354952 0.489451476793 696 1422\n",
      "Lorrie PARKER USA\n",
      "\n",
      "0.210969416506 0.529032258065 82 155\n",
      "Tomie FUKUDOME JPN\n",
      "\n",
      "3.33488941129e-07 0.755813953488 65 86\n",
      "Francis BETSCH FRA *\n",
      "\n",
      "6.57358611988e-11 0.639534883721 330 516\n",
      "Guangying QIN CHN *\n",
      "\n",
      "0.989449624413 0.449908925319 247 549\n",
      "Jana BAUDYSOVA CZE\n",
      "\n",
      "0.952760415504 0.468956406869 355 757\n",
      "Angelique CLYDE-SMITH AUS\n",
      "\n",
      "0.0037843581544 0.538726333907 626 1162\n",
      "Deveny DECK USA\n",
      "\n",
      "1.11022302463e-16 0.649659863946 573 882\n",
      "Nicole LEBLANC-RICHARD CAN *\n",
      "\n",
      "0.037890597386 0.55421686747 138 249\n",
      "David MOLINA FRA\n",
      "\n",
      "1.11022302463e-16 0.751807228916 624 830\n",
      "Kari-Anne OLSEN NOR *\n",
      "\n",
      "0.983949663053 0.459754433834 337 733\n",
      "Ebru ANILDI TUR\n",
      "\n",
      "0.999999996791 0.346368715084 124 358\n",
      "Karin EHRHARDT AUT\n",
      "\n",
      "1.4930880754e-08 0.62660944206 292 466\n",
      "Ekaterina SEROVA BLR *\n",
      "\n",
      "0.989344228097 0.412087912088 75 182\n",
      "Agnieszka SWIDERSKA POL\n",
      "\n",
      "0.00861317097204 0.556603773585 236 424\n",
      "Bettina MEIER SUI\n",
      "\n",
      "3.33066907388e-16 0.725490196078 222 306\n",
      "Kristina HOUWING SWE *\n",
      "\n",
      "0.999999970686 0.301075268817 56 186\n",
      "Matjaz KRUSEC SLO\n",
      "\n",
      "0.129040740003 0.535398230088 121 226\n",
      "Stanislava SMIDOVA CZE\n",
      "\n",
      "0.98089751257 0.445040214477 166 373\n",
      "Kadi ZVIRIK EST\n",
      "\n",
      "0.999982617448 0.35175879397 70 199\n",
      "Lise ROSTO JENSEN NOR\n",
      "\n",
      "0.00103003153206 0.584375 187 320\n",
      "Andrea GMELIN ROM\n",
      "\n",
      "0.738234341603 0.486486486486 306 629\n",
      "Zanna KULIK EST\n",
      "\n",
      "0.996148197506 0.421404682274 126 299\n",
      "Tarja RISTANEN FIN\n",
      "\n",
      "1.11022302463e-16 0.739413680782 227 307\n",
      "Ernestien BAKKER NED *\n",
      "\n",
      "1.00025370842e-06 0.636054421769 187 294\n",
      "Kvetoslava MATEJOVA SVK *\n",
      "\n",
      "0.14997208117 0.526785714286 177 336\n",
      "Osman SIRVAN TUR\n",
      "\n",
      "0.0325225066782 0.562814070352 112 199\n",
      "Teri SEDEJ SLO\n",
      "\n",
      "0.000878279473132 0.624161073826 93 149\n",
      "Vessela POPOVA BGR\n",
      "\n",
      "4.00768085385e-10 0.703703703704 152 216\n",
      "Alice WALDER SUI *\n",
      "\n",
      "1.51627599365e-11 0.72864321608 145 199\n",
      "Lone AMSTRUP LINNEMANN DEN *\n",
      "\n",
      "0.996459362971 0.4140625 106 256\n",
      "Elisabeth BINDER AUT\n",
      "\n",
      "2.28663088464e-10 0.657824933687 248 377\n",
      "Katalin BALCZO HUN *\n",
      "\n",
      "1.0 0.165789473684 63 380\n",
      "Irina MEDVEDEVA AZE\n",
      "\n",
      "2.0278667634e-11 0.625368731563 424 678\n",
      "Nicholas RUSSELL GBR *\n",
      "\n",
      "0.0469241102431 0.55 143 260\n",
      "Ludmila MIKHAILOVSKAYA UKR\n",
      "\n",
      "1.0 0.220543806647 73 331\n",
      "Roland MAEDER SUI\n",
      "\n",
      "1.11022302463e-16 0.848249027237 218 257\n",
      "Vladimir CUCHRAN SVK *\n",
      "\n",
      "5.90340174522e-08 0.752475247525 76 101\n",
      "Roberts KRUTKRAMELIS LAT *\n",
      "\n",
      "0.905576640096 0.428571428571 42 98\n",
      "Szilard TOTH HUN\n",
      "\n",
      "0.00270836079112 0.578595317726 173 299\n",
      "Ko-Man TING TWN\n",
      "\n",
      "0.997833747506 0.447916666667 344 768\n",
      "Sung-Hee KOH KOR\n",
      "\n",
      "1.11022302463e-16 0.803625377644 266 331\n",
      "Jia YAO CHN *\n",
      "\n",
      "0.794326875727 0.48596112311 450 926\n",
      "Sasha MARTINEZ MEX\n",
      "\n",
      "2.41690611968e-09 0.613953488372 396 645\n",
      "Neil GARRARD ZAF *\n",
      "\n",
      "0.422933226415 0.504201680672 120 238\n",
      "Lone VILLEFRANCE DEN\n",
      "\n",
      "1.11022302463e-16 0.726744186047 250 344\n",
      "Peter RANKIN AUS *\n",
      "\n",
      "0.999947006731 0.371794871795 87 234\n",
      "Eddy WU TPE\n",
      "\n",
      "0.999999999985 0.377867746289 280 741\n",
      "Na Young AHN KOR\n",
      "\n",
      "4.86687923906e-06 0.650485436893 134 206\n",
      "Joanna MILLER AUS *\n",
      "\n",
      "0.00132133185616 0.580357142857 195 336\n",
      "Susan PETRICEVIC NZL\n",
      "\n",
      "0.183805408748 0.522471910112 186 356\n",
      "Ariadna MORONES NEGRETE MEX\n",
      "\n",
      "6.66133814775e-16 0.639650872818 513 802\n",
      "Hailan JIANG CHN *\n",
      "\n",
      "0.986129001769 0.460975609756 378 820\n",
      "Mark STORTON AUS\n",
      "\n",
      "0.853750886472 0.470914127424 170 361\n",
      "Raia BISSEROVA-BAKALOVA BUL\n",
      "\n",
      "8.45630103408e-06 0.619047619048 195 315\n",
      "Miroslav MISUREC CZE *\n",
      "\n",
      "1.0 0.220414201183 149 676\n",
      "Deborah NOYES AUS\n",
      "\n",
      "0.00358578539639 0.559118236473 279 499\n",
      "Margaret WORSFOLD GBR\n",
      "\n",
      "0.5 0.496932515337 81 163\n",
      "Gloria MORANDI ITA\n",
      "\n",
      "1.0 0.246575342466 90 365\n",
      "Igor FEDCHENKO UKR\n",
      "\n",
      "0.999991358377 0.38961038961 150 385\n",
      "Edith SCHILLER AUT\n",
      "\n",
      "3.82291531764e-09 0.695652173913 144 207\n",
      "Richard GRAINGE GBR *\n",
      "\n",
      "0.00141797295247 0.573979591837 225 392\n",
      "Mona ADOLFSEN NOR\n",
      "\n",
      "0.43667235178 0.502824858757 178 354\n",
      "Christiane MILES SUI\n",
      "\n",
      "0.5 0.496855345912 79 159\n",
      "Darja GABROVSEK-POLAJNAR SLO\n",
      "\n",
      "7.47877709184e-05 0.584178498986 288 493\n",
      "Tamie K. CAMPBELL USA *\n",
      "\n",
      "0.996569792526 0.428571428571 159 371\n",
      "Florence VUYLSTEKER FRA\n",
      "\n",
      "0.999997825583 0.407936507937 257 630\n",
      "Thomas BIEGLER AUT\n",
      "\n",
      "0.999994950276 0.340206185567 66 194\n",
      "Beatrice PFISTER SUI\n",
      "\n",
      "2.33338045552e-07 0.625641025641 244 390\n",
      "Nadezhda FIODOROVA BLR *\n",
      "\n",
      "9.14764871278e-05 0.591584158416 239 404\n",
      "Sally REHORICK CAN *\n",
      "\n",
      "2.43529317823e-07 0.70802919708 97 137\n",
      "Vladislav PETUKHOV UKR *\n",
      "\n",
      "0.999220914695 0.358778625954 47 131\n",
      "Garry HOPPE GBR\n",
      "\n",
      "6.03593415224e-05 0.609427609428 181 297\n",
      "Christian BAUMANN GER *\n",
      "\n",
      "0.99999936547 0.349809885932 92 263\n",
      "Etsuko AZUMA JPN\n",
      "\n",
      "0.0146511114858 0.598214285714 67 112\n",
      "Ece ESEN TUR\n",
      "\n",
      "1.83186799063e-14 0.818897637795 104 127\n",
      "Simona SPALLUTO ITA *\n",
      "\n",
      "0.0190897207899 0.582191780822 85 146\n",
      "Deborah ISLAM CAN\n",
      "\n",
      "0.916470152806 0.46335078534 177 382\n",
      "Alison RYAN AUS\n",
      "\n",
      "0.999991222822 0.376623376623 116 308\n",
      "Tae Ri LEE KOR\n",
      "\n",
      "0.682833046858 0.477987421384 76 159\n",
      "Xixia LIU CHN\n",
      "\n",
      "0.00272140023848 0.581818181818 160 275\n",
      "Akos PETHES HUN\n",
      "\n",
      "0.000507957498851 0.624242424242 103 165\n",
      "Zuzana PLESNIKOVA CZE\n",
      "\n",
      "3.5527136788e-15 0.731343283582 196 268\n",
      "Igor PROKOP SVK *\n",
      "\n",
      "0.0042655773073 0.604026845638 90 149\n",
      "Tetsuo ABE JPN\n",
      "\n",
      "0.936712758253 0.451492537313 121 268\n",
      "Jitka MOKRA CZE\n",
      "\n",
      "0.997395640133 0.397959183673 78 196\n",
      "Akira YOSHIZAWA JPN\n",
      "\n",
      "0.00400236775733 0.558467741935 277 496\n",
      "Anastassia MAKAROVA UKR\n",
      "\n",
      "0.0267418127974 0.561946902655 127 226\n",
      "Mami MAEDA JPN\n",
      "\n",
      "8.39075620096e-09 0.673228346457 171 254\n",
      "Yuko OGAWA JPN *\n",
      "\n",
      "5.77795256085e-10 0.616892911011 409 663\n",
      "Peggy GRAHAM USA *\n",
      "\n",
      "0.00903254693504 0.548109965636 319 582\n",
      "Salome CHIGOGIDZE GEO\n",
      "\n",
      "0.999998454022 0.354961832061 93 262\n",
      "Daniela TACCANI ITA\n",
      "\n",
      "1.50981782632e-10 0.686131386861 188 274\n",
      "Jean SENFT CAN *\n",
      "\n",
      "1.92091342832e-10 0.765625 98 128\n",
      "Ingrid Charlotte WOLTER GER *\n",
      "\n",
      "6.66133814775e-16 0.731448763251 207 283\n",
      "Walter ZUCCARO ITA *\n",
      "\n",
      "0.976515094308 0.434426229508 106 244\n",
      "Yoko KUNO JPN\n",
      "\n",
      "5.73146795579e-08 0.674208144796 149 221\n",
      "Akiko KOBAYASHI JPN *\n",
      "\n",
      "1.0 0.334776334776 232 693\n",
      "Adriana DOMANSKA SVK\n",
      "\n",
      "3.96127575186e-13 0.764705882353 130 170\n",
      "Kersten BELLMANN GER *\n",
      "\n",
      "0.00697866706242 0.6 84 140\n",
      "Elizabeth ALEXANDRE AUS\n",
      "\n",
      "2.54215759554e-10 0.697872340426 164 235\n",
      "Mary CHAPMAN GBR *\n",
      "\n",
      "0.00027461669362 0.582547169811 247 424\n",
      "Hege ROSTO JENSEN NOR\n",
      "\n",
      "0.120485445806 0.527446300716 221 419\n",
      "Senem AHISKAL TUR\n",
      "\n",
      "2.99105185064e-12 0.748603351955 134 179\n",
      "Marjo KANKAANRANTA FIN *\n",
      "\n",
      "0.999999994958 0.290322580645 54 186\n",
      "Hanna THEN POL\n",
      "\n",
      "0.88949437568 0.450292397661 77 171\n",
      "Claudia FASSORA SUI\n",
      "\n",
      "0.999651042806 0.358108108108 53 148\n",
      "Natalia KRUGLOVA UKR\n",
      "\n",
      "0.973176534694 0.431279620853 91 211\n",
      "Donatella LEONELLI SUI\n",
      "\n",
      "0.757740181616 0.481296758105 193 401\n",
      "Attila SOOS HUN\n",
      "\n",
      "0.819802479003 0.465346534653 94 202\n",
      "Adrienn SCHADENBAUER AUT\n",
      "\n",
      "6.56141807553e-14 0.685863874346 262 382\n",
      "Ann FINDLAY GBR *\n",
      "\n",
      "0.103751698509 0.543956043956 99 182\n",
      "Saioa SANCHO ESP\n",
      "\n",
      "0.32227110603 0.514792899408 87 169\n",
      "Merja KOSONEN FIN\n",
      "\n",
      "1.1932425048e-09 0.710526315789 135 190\n",
      "Josip CEROVAC CRO *\n",
      "\n",
      "0.80368697766 0.467005076142 92 197\n",
      "Asa NORDBACK SWE\n",
      "\n",
      "0.724645543201 0.465346534653 47 101\n",
      "Prisca BINZ-MOSER SUI\n",
      "\n",
      "0.0615572352085 0.539548022599 191 354\n",
      "Virpi KUNNAS-HELMINEN FIN\n",
      "\n",
      "0.995964613902 0.410480349345 94 229\n",
      "Csaba BALINT HUN\n",
      "\n",
      "1.11022302463e-16 0.74375 238 320\n",
      "Magdalena RUSIECKA POL *\n",
      "\n",
      "0.985745538046 0.4296875 110 256\n",
      "Deborah CURRIE USA\n",
      "\n",
      "0.669897438798 0.486404833837 161 331\n",
      "Nadezhda PARETSKAIA KAZ\n",
      "\n",
      "5.27133892092e-12 0.698924731183 195 279\n",
      "Kylie Anne YACOPETTI AUS *\n",
      "\n",
      "0.0527611498406 0.556756756757 103 185\n",
      "Doug WILLIAMS USA\n",
      "\n",
      "0.0521019332027 0.569105691057 70 123\n",
      "Anja RIST GER\n",
      "\n",
      "0.353441130746 0.513274336283 58 113\n",
      "Rebecca ANDREW AUS\n",
      "\n",
      "1.11022302463e-16 0.721556886228 241 334\n",
      "Olga KOZHEMYAKINA RUS *\n",
      "\n",
      "1.0 0.266666666667 100 375\n",
      "Yuriy GUSKOV KAZ\n",
      "\n",
      "0.983499246986 0.424528301887 90 212\n",
      "Zsuzsanna VIKARNE-HOMOLYA HUN\n",
      "\n",
      "1.11022302463e-16 0.769516728625 207 269\n",
      "Pekka LESKINEN FIN *\n",
      "\n",
      "0.784989558012 0.461538461538 60 130\n",
      "Anastassiya MAKAROVA UKR\n",
      "\n"
     ]
    }
   ],
   "source": [
    "for judge in scores_not_med.judge.unique():\n",
    "    p = test_bias(scores_not_med[scores_not_med.judge == judge])\n",
    "    if p <= 0.05/244:\n",
    "        if nations[judge] not in nation_count:\n",
    "            nation_count[nations[judge]] = 1\n",
    "        else:\n",
    "            nation_count[nations[judge]] += 1\n",
    "        print judge, nations[judge], '*'\n",
    "        significant_judges.add(judge)\n",
    "    else:\n",
    "        print judge, nations[judge]\n",
    "    print"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 178,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "BEL 1 1\n",
      "ISR 2 4\n",
      "NED 1 2\n",
      "SWE 1 5\n",
      "AZE None 1\n",
      "SUI 1 8\n",
      "BGR None 1\n",
      "GBR 4 6\n",
      "CAN 13 18\n",
      "DEN 1 2\n",
      "KOR 3 6\n",
      "CRO 1 1\n",
      "TPE None 1\n",
      "GER 9 10\n",
      "USA 13 19\n",
      "HUN 1 6\n",
      "UZB None 2\n",
      "POL 2 5\n",
      "BUL None 1\n",
      "GEO None 1\n",
      "HKG 1 1\n",
      "FRA 3 10\n",
      "EST None 2\n",
      "SVK 3 6\n",
      "LTU None 1\n",
      "ESP 1 4\n",
      "TWN None 1\n",
      "CHN 6 11\n",
      "UKR 1 7\n",
      "ROM None 1\n",
      "AUS 4 12\n",
      "SLO None 3\n",
      "AUT None 6\n",
      "KAZ None 4\n",
      "BLR 2 3\n",
      "FIN 2 6\n",
      "NZL None 2\n",
      "JPN 7 18\n",
      "ZAF 1 1\n",
      "TUR 1 5\n",
      "ITA 8 13\n",
      "LAT 1 3\n",
      "RUS 6 10\n",
      "MEX None 2\n",
      "NOR 1 4\n",
      "CZE 3 8\n"
     ]
    }
   ],
   "source": [
    "#from collections import Counter\n",
    "# counter = Counter([nation for judge, nation in nations.iteritems() if judge in scores_not_med.judge.unique()])\n",
    "# for nation in counter:\n",
    "#     print nation, nation_count.get(nation), counter[nation]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 177,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "({u'AUS': 4,\n",
       "  u'BEL': 1,\n",
       "  u'BLR': 2,\n",
       "  u'CAN': 13,\n",
       "  u'CHN': 6,\n",
       "  u'CRO': 1,\n",
       "  u'CZE': 3,\n",
       "  u'DEN': 1,\n",
       "  u'ESP': 1,\n",
       "  u'FIN': 2,\n",
       "  u'FRA': 3,\n",
       "  u'GBR': 4,\n",
       "  u'GER': 9,\n",
       "  u'HKG': 1,\n",
       "  u'HUN': 1,\n",
       "  u'ISR': 2,\n",
       "  u'ITA': 8,\n",
       "  u'JPN': 7,\n",
       "  u'KOR': 3,\n",
       "  u'LAT': 1,\n",
       "  u'NED': 1,\n",
       "  u'NOR': 1,\n",
       "  u'POL': 2,\n",
       "  u'RUS': 6,\n",
       "  u'SUI': 1,\n",
       "  u'SVK': 3,\n",
       "  u'SWE': 1,\n",
       "  u'TUR': 1,\n",
       "  u'UKR': 1,\n",
       "  u'USA': 13,\n",
       "  u'ZAF': 1},\n",
       " Counter({u'AUS': 12,\n",
       "          u'AUT': 6,\n",
       "          u'AZE': 1,\n",
       "          u'BEL': 1,\n",
       "          u'BGR': 1,\n",
       "          u'BLR': 3,\n",
       "          u'BUL': 1,\n",
       "          u'CAN': 18,\n",
       "          u'CHN': 11,\n",
       "          u'CRO': 1,\n",
       "          u'CZE': 8,\n",
       "          u'DEN': 2,\n",
       "          u'ESP': 4,\n",
       "          u'EST': 2,\n",
       "          u'FIN': 6,\n",
       "          u'FRA': 10,\n",
       "          u'GBR': 6,\n",
       "          u'GEO': 1,\n",
       "          u'GER': 10,\n",
       "          u'HKG': 1,\n",
       "          u'HUN': 6,\n",
       "          u'ISR': 4,\n",
       "          u'ITA': 13,\n",
       "          u'JPN': 18,\n",
       "          u'KAZ': 4,\n",
       "          u'KOR': 6,\n",
       "          u'LAT': 3,\n",
       "          u'LTU': 1,\n",
       "          u'MEX': 2,\n",
       "          u'NED': 2,\n",
       "          u'NOR': 4,\n",
       "          u'NZL': 2,\n",
       "          u'POL': 5,\n",
       "          u'ROM': 1,\n",
       "          u'RUS': 10,\n",
       "          u'SLO': 3,\n",
       "          u'SUI': 8,\n",
       "          u'SVK': 6,\n",
       "          u'SWE': 5,\n",
       "          u'TPE': 1,\n",
       "          u'TUR': 5,\n",
       "          u'TWN': 1,\n",
       "          u'UKR': 7,\n",
       "          u'USA': 19,\n",
       "          u'UZB': 2,\n",
       "          u'ZAF': 1}))"
      ]
     },
     "execution_count": 177,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nation_count, Counter([nation for judge, nation in nations.iteritems() if judge in scores_not_med.judge.unique()])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "owg_scores_not_med = scores_not_med[scores_not_med.segment_name.str.startswith('owg2018')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 223,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(10078, 13457)"
      ]
     },
     "execution_count": 223,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(owg_scores_not_med), len(scores_med[scores_med.segment_name.str.startswith('owg2018')])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 210,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "def test_bias(df):\n",
    "    s = sum(df.u)\n",
    "    n = len(df)\n",
    "    print (1-binom.cdf(s, n, 0.5)), '%.3f %d %d' % (float(s) / n, s, n)\n",
    "    return 1-binom.cdf(s, n, 0.5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 194,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index([u'Unnamed: 0', u'Unnamed: 0.1', u'all_scores', u'country',\n",
       "       u'discipline', u'elt_bonus', u'elt_bv', u'elt_info', u'elt_name',\n",
       "       u'elt_number', u'elt_points', u'elt_score', u'is_comp', u'judge',\n",
       "       u'judge_num', u'judge_score', u'med_score', u'num_entries',\n",
       "       u'overall_rank', u'season', u'segment_name', u'segment_rank', u'skater',\n",
       "       u'start_order', u'trimmed_mean', u'judge_country', u'same_country',\n",
       "       u'is_larger', u'dist_med', u'judge_n', u'u'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 194,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "owg_scores_not_med.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 221,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "men 1.61546491739e-08 0.550 1645 2989\n",
      " top6 1.30417898703e-12 0.632 437 692\n",
      " bottom 0.133253895541 0.520 379 729\n",
      " elt 0.00059304840887 0.542 806 1488\n",
      " comp 2.11687584728e-06 0.559 839 1501\n",
      "short 0.170347335209 0.512 772 1508\n",
      "top6 7.21421617278e-06 0.623 188 302\n",
      "bottom 0.570904711993 0.495 248 501\n",
      " elt 0.531625746865 0.498 316 635\n",
      "  top6 0.000833756942951 0.629 88 140\n",
      "  bottom 0.444476172415 0.502 103 205\n",
      " comp 0.0878837578065 0.522 456 873\n",
      "  top6 0.00104326174383 0.617 100 162\n",
      "  bottom 0.614299872637 0.490 145 296\n",
      "free 2.09809947194e-12 0.589 873 1481\n",
      "top6 1.38647370251e-08 0.638 249 390\n",
      "bottom 0.0101254897756 0.575 131 228\n",
      " elt 5.65461029534e-06 0.574 490 853\n",
      "  top6 4.00561918568e-06 0.640 155 242\n",
      "  bottom 0.0506838267665 0.570 69 121\n",
      " comp 1.28095489771e-08 0.610 383 628\n",
      "  top6 0.000348957193755 0.635 94 148\n",
      "  bottom 0.040676524103 0.579 62 107\n",
      "\n",
      "ladies 2.51032528098e-12 0.565 1583 2802\n",
      " top6 1.81696004531e-06 0.592 367 620\n",
      " bottom 0.119976291301 0.522 363 696\n",
      " elt 4.16261174319e-06 0.562 717 1276\n",
      " comp 5.57592889638e-08 0.567 866 1526\n",
      "short 3.86264686902e-10 0.581 830 1429\n",
      "top6 2.59297999738e-08 0.662 180 272\n",
      "bottom 0.0186998205032 0.546 267 489\n",
      " elt 5.7159561172e-06 0.592 328 554\n",
      "  top6 2.63366546853e-05 0.678 82 121\n",
      "  bottom 0.034668512065 0.566 99 175\n",
      " comp 5.3498038205e-06 0.574 502 875\n",
      "  top6 8.12145801965e-05 0.649 98 151\n",
      "  bottom 0.0971092970329 0.535 168 314\n",
      "free 0.000147870438808 0.548 753 1373\n",
      "top6 0.0738461438102 0.537 187 348\n",
      "bottom 0.834734266634 0.464 96 207\n",
      " elt 0.0169113580446 0.539 389 722\n",
      "  top6 0.164090979802 0.532 109 205\n",
      "  bottom 0.955686959943 0.410 41 100\n",
      " comp 0.00110541570691 0.559 364 651\n",
      "  top6 0.120802097623 0.545 78 143\n",
      "  bottom 0.349587492004 0.514 55 107\n",
      "\n",
      "pairs 2.74655520549e-10 0.566 1224 2161\n",
      " top6 3.59617216116e-05 0.578 368 637\n",
      " bottom 0.0674041642552 0.531 291 548\n",
      " elt 1.33099184846e-05 0.564 593 1051\n",
      " comp 2.11986173815e-06 0.568 631 1110\n",
      "short 4.37171698842e-09 0.585 655 1119\n",
      "top6 5.31110565088e-05 0.615 169 275\n",
      "bottom 0.0567354528089 0.538 220 409\n",
      " elt 2.42818982354e-06 0.605 280 463\n",
      "  top6 9.91184992772e-05 0.670 75 112\n",
      "  bottom 0.592015860196 0.488 81 166\n",
      " comp 0.00010152800163 0.572 375 656\n",
      "  top6 0.0206862114997 0.577 94 163\n",
      "  bottom 0.0103652315172 0.572 139 243\n",
      "free 0.00131967635603 0.546 569 1042\n",
      "top6 0.0258318366785 0.550 199 362\n",
      "bottom 0.367269658636 0.511 71 139\n",
      " elt 0.0538415562397 0.532 313 588\n",
      "  top6 0.162904428138 0.532 108 203\n",
      "  bottom 0.587843392447 0.481 39 81\n",
      " comp 0.00278209278595 0.564 256 454\n",
      "  top6 0.0283279984169 0.572 91 159\n",
      "  bottom 0.179071650903 0.552 32 58\n",
      "\n",
      "dance 1.11022302463e-16 0.607 1291 2126\n",
      " top6 4.24993373827e-13 0.661 316 478\n",
      " bottom 8.3226609231e-06 0.586 357 609\n",
      " elt 1.32893696048e-13 0.617 590 956\n",
      " comp 4.12414546958e-12 0.599 701 1170\n",
      "short 2.31841235099e-09 0.591 605 1024\n",
      "top6 3.78721062955e-06 0.650 139 214\n",
      "bottom 0.000123981395064 0.594 218 367\n",
      " elt 1.21428425526e-06 0.622 224 360\n",
      "  top6 0.000220142503257 0.700 49 70\n",
      "  bottom 0.000377945136228 0.643 83 129\n",
      " comp 5.93892048371e-05 0.574 381 664\n",
      "  top6 0.00097126598504 0.625 90 144\n",
      "  bottom 0.0161061492563 0.567 135 238\n",
      "free 1.11022302463e-16 0.623 686 1102\n",
      "top6 7.71093622287e-09 0.670 177 264\n",
      "bottom 0.00860257459905 0.574 139 242\n",
      " elt 8.6955720402e-09 0.614 366 596\n",
      "  top6 1.47895236002e-06 0.690 98 142\n",
      "  bottom 0.215010441988 0.531 69 130\n",
      " comp 7.84951104116e-10 0.632 320 506\n",
      "  top6 0.000370397613706 0.648 79 122\n",
      "  bottom 0.00294508649021 0.625 70 112\n",
      "\n"
     ]
    }
   ],
   "source": [
    "for discipline in ('men', 'ladies', 'pairs', 'dance'):\n",
    "    print discipline,\n",
    "    df = owg_scores_not_med[owg_scores_not_med.segment_name.str.contains(discipline)]\n",
    "    test_bias(df)\n",
    "    df_top6 = df[df.segment_rank <= 6]\n",
    "    print ' top6',\n",
    "    test_bias(df_top6)\n",
    "    df_bottom = df[df.segment_rank > df.num_entries * 2/3]\n",
    "    print ' bottom',\n",
    "    test_bias(df_bottom)\n",
    "    df_elt = df[df.is_comp == 0]\n",
    "    print ' elt',\n",
    "    test_bias(df_elt)\n",
    "    df_comp = df[df.is_comp == 1]\n",
    "    print ' comp',\n",
    "    test_bias(df_comp)\n",
    "    for segment in ('short', 'free'):\n",
    "        print segment,\n",
    "        df = owg_scores_not_med[owg_scores_not_med.segment_name.str.contains(discipline + '_' + segment)]\n",
    "        test_bias(df)\n",
    "        df_top6 = df[df.segment_rank <= 6]\n",
    "        print 'top6',\n",
    "        test_bias(df_top6)\n",
    "        df_bottom = df[df.segment_rank > df.num_entries * 2/3]\n",
    "        print 'bottom',\n",
    "        test_bias(df_bottom)\n",
    "        \n",
    "        print ' elt',\n",
    "        df_elt = df[df.is_comp == 0]\n",
    "        test_bias(df_elt)\n",
    "        df_elt_top6 = df_top6[df_top6.is_comp == 0]\n",
    "        print '  top6',\n",
    "        test_bias(df_elt_top6)\n",
    "        df_elt_bottom = df_bottom[df_bottom.is_comp == 0]\n",
    "        print '  bottom',\n",
    "        test_bias(df_elt_bottom)\n",
    "        \n",
    "        print ' comp',\n",
    "        df_comp = df[df.is_comp == 1]\n",
    "        test_bias(df_comp)\n",
    "        df_comp_top6 = df_top6[df_top6.is_comp == 1]\n",
    "        print '  top6',\n",
    "        test_bias(df_comp_top6)\n",
    "        df_comp_bottom = df_bottom[df_bottom.is_comp == 1]\n",
    "        print '  bottom',\n",
    "        test_bias(df_comp_bottom)\n",
    "    print"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2.8519058187e-05 0.764705882353 39 51\n"
     ]
    }
   ],
   "source": [
    "test_bias(ladies_short[ladies_short.skater == 'Evgenia MEDVEDEVA'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index([u'Unnamed: 0', u'Unnamed: 0.1', u'all_scores', u'country',\n",
       "       u'discipline', u'elt_bonus', u'elt_bv', u'elt_info', u'elt_name',\n",
       "       u'elt_number', u'elt_points', u'elt_score', u'is_comp', u'judge',\n",
       "       u'judge_num', u'judge_score', u'med_score', u'num_entries',\n",
       "       u'overall_rank', u'season', u'segment_name', u'segment_rank', u'skater',\n",
       "       u'start_order', u'trimmed_mean', u'judge_country', u'same_country',\n",
       "       u'is_larger', u'dist_med', u'judge_n', u'u'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 153,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ladies_short.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.0120464538492 0.647058823529 33 51\n"
     ]
    }
   ],
   "source": [
    "test_bias(ladies_short[ladies_short.skater == 'Evgenia MEDVEDEVA'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.063173537907 0.596153846154 31 52\n"
     ]
    }
   ],
   "source": [
    "test_bias(ladies_short[ladies_short.skater == 'Kaetlyn OSMOND'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1.11022302463e-16 0.56588608851 5703 10078\n"
     ]
    }
   ],
   "source": [
    "s = sum(owg_scores_not_med.u)\n",
    "n = len(owg_scores_not_med)\n",
    "print 1-binom.cdf(s, n, 0.5), float(s) / n, s, n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(66809, 66809)"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sum(scores_not_med.country_high_low), sum(scores_not_med.u)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(108447, 247278, 138831)"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(scores_not_med), len(scores), len(scores_med)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1.1102230246251565e-16, 0.5634641806596771)"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "n = len(scores_not_med)\n",
    "1-binom.cdf(61106, n, 0.5), 61106./108447"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(0.00025132609080258383, 0.5175411680474583, 5060, 9777)"
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "relscores = scores_not_med[scores_not_med.segment_rank]\n",
    "s = sum(relscores.country_high_low)\n",
    "n = len(relscores)\n",
    "1-binom.cdf(s, n, 0.5), float(s)/n, s, n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " short elts\n",
      "11069 19841 0.00000000000000011102 0.557885187239\n",
      "1321 1672 0.00000000000000011102 0.790071770335\n",
      "short comp\n",
      "17744 31391 0.00000000000000011102 0.565257557899\n",
      "2367 2772 0.00000000000000011102 0.853896103896\n",
      "free elts\n",
      "17140 30704 0.00000000000000011102 0.558233454924\n",
      "2151 2763 0.00000000000000011102 0.778501628664\n",
      "free comp\n",
      "15153 26511 0.00000000000000011102 0.571574063596\n",
      "2147 2532 0.00000000000000011102 0.84794628752\n"
     ]
    }
   ],
   "source": [
    "for description, is_comp, segment_name in (('short elts', 0, 'short'), ('short comp', 1, 'short'),\n",
    "                                           ('free elts', 0, 'free'), ('free comp', 1, 'free')):\n",
    "    print description\n",
    "    relscores = scores_not_med[scores_not_med.is_comp == is_comp]\n",
    "    relscores = relscores[relscores.segment_name.str.contains(segment_name)]\n",
    "    N = len(relscores)\n",
    "    S = sum(relscores.country_high_low)\n",
    "    print S, N, '%.20f' % (1 - binom.cdf(S, N, 0.5)), float(S) / N\n",
    "    relscores = relscores[relscores.same_country == 1]\n",
    "    N = len(relscores)\n",
    "    S = sum(relscores.country_high_low)\n",
    "    print S, N, '%.20f' % (1 - binom.cdf(S, N, 0.5)), float(S) / N"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['men', 'ladies', 'pairs', 'ice_dance'], dtype=object)"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "scores_not_med.discipline.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "men\n",
      "17958 32992 0.00000000000000011102 0.544313773036\n",
      "7489 13323 0.99999999999999988898 0.562110635743\n",
      "ladies\n",
      "17497 31510 0.00000000000000011102 0.555284036814\n",
      "7472 13071 0.99999999999999988898 0.57164715783\n",
      "pairs\n",
      "11794 20807 0.00000000000000011102 0.566828471188\n",
      "7729 13200 0.99999999999999988898 0.58553030303\n",
      "ice_dance\n",
      "13857 23138 0.00000000000000011102 0.598884951163\n",
      "6673 10697 0.99999999999999988898 0.62381976255\n"
     ]
    }
   ],
   "source": [
    "for discipline in scores_not_med.discipline.unique():\n",
    "    print discipline\n",
    "    relscores = scores_not_med[scores_not_med.discipline == discipline]\n",
    "#     relscores = relscores[relscores.same_country == 1]\n",
    "    N = len(relscores)\n",
    "    S = sum(relscores.country_high_low)\n",
    "    print S, N, '%.20f' % (1-binom.cdf(S, N, 0.5)), float(S) / N\n",
    "    relscores = relscores[relscores.segment_rank <= 6]\n",
    "    N = len(relscores)\n",
    "    S = sum(relscores.country_high_low)\n",
    "    print S, N, '%.20f' % binom.cdf(S, N, 0.5), float(S) / N"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "((53901.273337327082, 54545.726662672918), 54223.5)"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "critical_values(n), n * 0.5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(108447, 138831)"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(scores_not_med), len(scores_med)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 173,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "scores_low = {}\n",
    "scores_high = {}\n",
    "for judge in elts_rus.judge.unique():\n",
    "    elts = elts_rus[elts_rus.judge == judge]\n",
    "    comp = comp_rus[comp_rus.judge == judge]\n",
    "    n = len(elts) + len(comp)\n",
    "    lower, upper = critical_values(n, 3.646383)\n",
    "    obs = sum(elts.is_larger) + sum(comp.is_larger)\n",
    "    if obs <= lower:\n",
    "        scores_low[judge] = norm.cdf(obs, loc=n*0.5, scale=np.sqrt(n*0.25))\n",
    "    elif obs >= upper:\n",
    "        scores_high[judge] = 1 - norm.cdf(obs, loc=n*0.5, scale=np.sqrt(n*0.25))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 174,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(188, 30, 26)"
      ]
     },
     "execution_count": 174,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(elts_rus.judge.unique()), len(scores_low), len(scores_high)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 168,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(220, 48, 34)"
      ]
     },
     "execution_count": 168,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(elts_rus.judge.unique()), len(scores_low), len(scores_high)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 193,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "nations['Virpi KUNNAS-HELMINEN'] = 'FIN'\n",
    "nations['Vessela POPOVA'] = 'BGR'\n",
    "nations['Yuko OGAWA'] = 'JPN'\n",
    "nations['Kvetoslava MATEJOVA'] = 'SVK'\n",
    "nations['Vladimir CUCHRAN'] = 'SVK'\n",
    "nations['Thomas BIEGLER'] = 'AUT'\n",
    "nations['Yoko KUNO'] = 'JPN'\n",
    "nations['Rebecca ANDREW'] = 'AUS'\n",
    "nations['Hege ROSTO JENSEN'] = 'NOR'\n",
    "nations['Igor PROKOP'] = 'SVK'\n",
    "nations['Senem AHISKAL'] = 'TUR'\n",
    "nations['Margaret WORSFOLD'] = 'GBR'\n",
    "nations['Ann FINDLAY'] = 'GBR'\n",
    "nations['Elisabeth BINDER'] = 'AUT'\n",
    "nations['Elizabeth ALEXANDRE'] = 'AUS'\n",
    "nations['Tetsuo ABE'] = 'JPN'\n",
    "nations['Deborah NOYES'] = 'AUS'\n",
    "nations['Magdalena RUSIECKA'] = 'POL'\n",
    "nations['Hanna THEN'] = 'POL'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 195,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "nations['Simona SPALLUTO'] = 'ITA'\n",
    "nations['Agnieszka SWIDERSKA'] = 'POL'\n",
    "nations['Osman SIRVAN'] = 'TUR'\n",
    "nations['Ariadna MORONES NEGRETE'] = 'MEX'\n",
    "nations['Susan PETRICEVIC'] = 'NZL'\n",
    "nations['Mona ADOLFSEN'] = 'NOR'\n",
    "nations['Darja GABROVSEK-POLAJNAR'] = 'SLO'\n",
    "nations['Nadezhda FIODOROVA'] = 'BLR'\n",
    "nations['Alison RYAN'] = 'AUS'\n",
    "nations['Donatella LEONELLI'] = 'SUI'\n",
    "nations['Adrienn SCHADENBAUER'] = 'AUT'\n",
    "nations['Neil GARRARD'] = 'ZAF'\n",
    "nations['Ernestien BAKKER'] = 'NED'\n",
    "nations['Joanna MILLER'] = 'AUS'\n",
    "nations['Ebru ANILDI'] = 'TUR'\n",
    "nations['Edith SCHILLER'] = 'AUT'\n",
    "nations['Ekaterina SEROVA'] = 'BLR'\n",
    "nations['Ko-Man TING'] = 'TWN'\n",
    "nations['Jitka MOKRA'] = 'CZE'\n",
    "nations['Etsuko AZUMA'] = 'JPN'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 197,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "nations['Tae Ri LEE'] = 'KOR'\n",
    "nations['Akiko KOBAYASHI'] = 'JPN'\n",
    "nations['Ece ESEN'] = 'TUR'\n",
    "nations['Kersten BELLMANN'] = 'GER'\n",
    "nations['Roberts KRUTKRAMELIS'] = 'LAT'\n",
    "nations['Mary CHAPMAN'] = 'GBR'\n",
    "nations['Josip CEROVAC'] = 'CRO'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 199,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "with open('pd_data/judge_nations.json', 'w') as f:\n",
    "    json.dump(nations, f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "279"
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sum(elts_not_med[elts_not_med.judge == 'Weiguang CHEN'].is_larger)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "629"
      ]
     },
     "execution_count": 110,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(elts_not_med[elts_not_med.judge == 'Weiguang CHEN'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "gpusa2016 gpusa2016 pairs_short -\n"
     ]
    }
   ],
   "source": [
    "panels = {}  # map segment name to judging panel\n",
    "judge_names = set()\n",
    "for season in seasons.values():\n",
    "    for event in season.events:\n",
    "        for discipline in event.disciplines:\n",
    "            for segment in discipline.segments:\n",
    "                if 'Function' in segment.panel.officials:\n",
    "                    del segment.panel.officials['Function']\n",
    "                    print event, segment\n",
    "                panel = {}\n",
    "                for function, official in segment.panel.officials.iteritems():\n",
    "                    name = remove_mr_ms(official.name)\n",
    "                    name = all_name_fixes.get(name, name)\n",
    "                    panel[function] = name\n",
    "                    if len(name) < 5:\n",
    "                        print event, segment, name\n",
    "                    if 'Judge' in official.function and season.champ_year in (2017, 2018):\n",
    "                        judge_names.add(name)\n",
    "                panels[event.name + '_' + segment.name] = panel"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "judge_names.remove('-')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "judges = {k: ','.join([v['Judge No.{0}'.format(judge_num+1)] for judge_num in xrange(len(v)-6)])\n",
    "          for k, v in panels.iteritems()}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "elts_df['judges'] = elts_df.apply(lambda row: judges[row.segment_name], axis=1)\n",
    "comp_df['judges'] = comp_df.apply(lambda row: judges[row.segment_name], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "elts_df['elt_goes'] = elts_df.apply(lambda row: row.elt_goes if row.segment_name != 'gpusa2016_pairs_short'\n",
    "              else ','.join([goe for goe in row.elt_goes.split(',') if goe != '-']), axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "comp_df['comp_scores'] = comp_df.apply(lambda row: row.comp_scores if row.segment_name != 'gpusa2016_pairs_short'\n",
    "              else ','.join([goe for goe in row.comp_scores.split(',') if goe != '-']), axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "elts_df['median_goe'] = elts_df.apply(lambda row: np.median(map(float, row.elt_goes.split(','))), axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "comp_df['median_score'] = comp_df.apply(lambda row: np.median(map(float, row.comp_scores.split(','))), axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {
    "collapsed": false
   },
   "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>country</th>\n",
       "      <th>discipline</th>\n",
       "      <th>elt_bonus</th>\n",
       "      <th>elt_bv</th>\n",
       "      <th>elt_finalgoe</th>\n",
       "      <th>elt_goes</th>\n",
       "      <th>elt_info</th>\n",
       "      <th>elt_name</th>\n",
       "      <th>elt_number</th>\n",
       "      <th>elt_points</th>\n",
       "      <th>season</th>\n",
       "      <th>segment_name</th>\n",
       "      <th>segment_rank</th>\n",
       "      <th>skater</th>\n",
       "      <th>start_order</th>\n",
       "      <th>judges</th>\n",
       "      <th>median_goe</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>JPN</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>12.30</td>\n",
       "      <td>-0.51</td>\n",
       "      <td>-1.0,0.0,0.0,-1.0,-1.0,0.0,1.0,-1.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>4F</td>\n",
       "      <td>1</td>\n",
       "      <td>11.79</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>1</td>\n",
       "      <td>Shoma UNO</td>\n",
       "      <td>9</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>JPN</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>13.30</td>\n",
       "      <td>-4.00</td>\n",
       "      <td>-3.0,-3.0,-3.0,-3.0,-3.0,-2.0,-3.0,-3.0,-3.0</td>\n",
       "      <td>&lt;</td>\n",
       "      <td>4T+3T&lt;</td>\n",
       "      <td>2</td>\n",
       "      <td>9.30</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>1</td>\n",
       "      <td>Shoma UNO</td>\n",
       "      <td>9</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>-3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>JPN</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>3.20</td>\n",
       "      <td>0.86</td>\n",
       "      <td>1.0,2.0,2.0,2.0,0.0,2.0,2.0,2.0,1.0</td>\n",
       "      <td></td>\n",
       "      <td>FCSp4</td>\n",
       "      <td>3</td>\n",
       "      <td>4.06</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>1</td>\n",
       "      <td>Shoma UNO</td>\n",
       "      <td>9</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>JPN</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>3.00</td>\n",
       "      <td>0.64</td>\n",
       "      <td>1.0,1.0,1.0,1.0,0.0,2.0,1.0,2.0,2.0</td>\n",
       "      <td></td>\n",
       "      <td>CSSp4</td>\n",
       "      <td>4</td>\n",
       "      <td>3.64</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>1</td>\n",
       "      <td>Shoma UNO</td>\n",
       "      <td>9</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>JPN</td>\n",
       "      <td>men</td>\n",
       "      <td>True</td>\n",
       "      <td>9.35</td>\n",
       "      <td>-0.14</td>\n",
       "      <td>1.0,-1.0,-1.0,0.0,0.0,0.0,0.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>3A</td>\n",
       "      <td>5</td>\n",
       "      <td>9.21</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>1</td>\n",
       "      <td>Shoma UNO</td>\n",
       "      <td>9</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>JPN</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>3.30</td>\n",
       "      <td>0.93</td>\n",
       "      <td>2.0,1.0,2.0,2.0,1.0,3.0,2.0,2.0,2.0</td>\n",
       "      <td></td>\n",
       "      <td>StSq3</td>\n",
       "      <td>6</td>\n",
       "      <td>4.23</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>1</td>\n",
       "      <td>Shoma UNO</td>\n",
       "      <td>9</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>JPN</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>3.50</td>\n",
       "      <td>1.14</td>\n",
       "      <td>2.0,1.0,3.0,3.0,1.0,2.0,2.0,3.0,3.0</td>\n",
       "      <td></td>\n",
       "      <td>CCoSp4</td>\n",
       "      <td>7</td>\n",
       "      <td>4.64</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>1</td>\n",
       "      <td>Shoma UNO</td>\n",
       "      <td>9</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>USA</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>9.60</td>\n",
       "      <td>0.90</td>\n",
       "      <td>2.0,1.0,1.0,1.0,0.0,1.0,2.0,1.0,2.0</td>\n",
       "      <td></td>\n",
       "      <td>3F+3T</td>\n",
       "      <td>1</td>\n",
       "      <td>10.50</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>2</td>\n",
       "      <td>Adam RIPPON</td>\n",
       "      <td>10</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>USA</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>8.50</td>\n",
       "      <td>1.29</td>\n",
       "      <td>1.0,1.0,2.0,2.0,0.0,1.0,1.0,1.0,2.0</td>\n",
       "      <td></td>\n",
       "      <td>3A</td>\n",
       "      <td>2</td>\n",
       "      <td>9.79</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>2</td>\n",
       "      <td>Adam RIPPON</td>\n",
       "      <td>10</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>USA</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>3.50</td>\n",
       "      <td>1.07</td>\n",
       "      <td>2.0,1.0,3.0,2.0,0.0,3.0,2.0,2.0,3.0</td>\n",
       "      <td></td>\n",
       "      <td>CCoSp4</td>\n",
       "      <td>3</td>\n",
       "      <td>4.57</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>2</td>\n",
       "      <td>Adam RIPPON</td>\n",
       "      <td>10</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>USA</td>\n",
       "      <td>men</td>\n",
       "      <td>True</td>\n",
       "      <td>6.60</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.0,0.0,1.0,2.0,1.0,2.0,1.0,2.0,2.0</td>\n",
       "      <td></td>\n",
       "      <td>3Lz</td>\n",
       "      <td>4</td>\n",
       "      <td>7.60</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>2</td>\n",
       "      <td>Adam RIPPON</td>\n",
       "      <td>10</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>USA</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>3.20</td>\n",
       "      <td>0.79</td>\n",
       "      <td>2.0,1.0,2.0,2.0,0.0,2.0,1.0,1.0,2.0</td>\n",
       "      <td></td>\n",
       "      <td>FCSp4</td>\n",
       "      <td>5</td>\n",
       "      <td>3.99</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>2</td>\n",
       "      <td>Adam RIPPON</td>\n",
       "      <td>10</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>USA</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>3.30</td>\n",
       "      <td>1.14</td>\n",
       "      <td>2.0,1.0,3.0,3.0,0.0,3.0,2.0,2.0,3.0</td>\n",
       "      <td></td>\n",
       "      <td>StSq3</td>\n",
       "      <td>6</td>\n",
       "      <td>4.44</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>2</td>\n",
       "      <td>Adam RIPPON</td>\n",
       "      <td>10</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>USA</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>2.60</td>\n",
       "      <td>0.93</td>\n",
       "      <td>2.0,1.0,2.0,2.0,1.0,2.0,2.0,2.0,3.0</td>\n",
       "      <td></td>\n",
       "      <td>CSSp3</td>\n",
       "      <td>7</td>\n",
       "      <td>3.53</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>2</td>\n",
       "      <td>Adam RIPPON</td>\n",
       "      <td>10</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>USA</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>10.30</td>\n",
       "      <td>-4.00</td>\n",
       "      <td>-3.0,-3.0,-3.0,-3.0,-3.0,-3.0,-3.0,-3.0,-3.0</td>\n",
       "      <td></td>\n",
       "      <td>4T</td>\n",
       "      <td>1</td>\n",
       "      <td>6.30</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>3</td>\n",
       "      <td>Jason BROWN</td>\n",
       "      <td>8</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>-3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>USA</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>8.50</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.0,2.0,2.0,3.0,1.0,2.0,2.0,2.0,2.0</td>\n",
       "      <td></td>\n",
       "      <td>3A</td>\n",
       "      <td>2</td>\n",
       "      <td>10.50</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>3</td>\n",
       "      <td>Jason BROWN</td>\n",
       "      <td>8</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>USA</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>3.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2.0,2.0,2.0,2.0,1.0,3.0,2.0,2.0,2.0</td>\n",
       "      <td></td>\n",
       "      <td>FSSp4</td>\n",
       "      <td>3</td>\n",
       "      <td>4.00</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>3</td>\n",
       "      <td>Jason BROWN</td>\n",
       "      <td>8</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>USA</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>CCSp</td>\n",
       "      <td>4</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>3</td>\n",
       "      <td>Jason BROWN</td>\n",
       "      <td>8</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>USA</td>\n",
       "      <td>men</td>\n",
       "      <td>True</td>\n",
       "      <td>11.33</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2.0,0.0,1.0,2.0,0.0,2.0,2.0,2.0,1.0</td>\n",
       "      <td></td>\n",
       "      <td>3Lz+3T</td>\n",
       "      <td>5</td>\n",
       "      <td>12.33</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>3</td>\n",
       "      <td>Jason BROWN</td>\n",
       "      <td>8</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>USA</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>3.90</td>\n",
       "      <td>2.00</td>\n",
       "      <td>3.0,2.0,3.0,3.0,1.0,3.0,3.0,3.0,3.0</td>\n",
       "      <td></td>\n",
       "      <td>StSq4</td>\n",
       "      <td>6</td>\n",
       "      <td>5.90</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>3</td>\n",
       "      <td>Jason BROWN</td>\n",
       "      <td>8</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>USA</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>3.50</td>\n",
       "      <td>0.79</td>\n",
       "      <td>2.0,1.0,2.0,2.0,0.0,1.0,2.0,1.0,2.0</td>\n",
       "      <td></td>\n",
       "      <td>CCoSp4</td>\n",
       "      <td>7</td>\n",
       "      <td>4.29</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>3</td>\n",
       "      <td>Jason BROWN</td>\n",
       "      <td>8</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>CAN</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>14.80</td>\n",
       "      <td>1.14</td>\n",
       "      <td>2.0,1.0,1.0,2.0,0.0,1.0,1.0,1.0,1.0</td>\n",
       "      <td></td>\n",
       "      <td>4S+3T</td>\n",
       "      <td>1</td>\n",
       "      <td>15.94</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>4</td>\n",
       "      <td>Nam NGUYEN</td>\n",
       "      <td>5</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>CAN</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>8.50</td>\n",
       "      <td>0.29</td>\n",
       "      <td>0.0,0.0,1.0,1.0,0.0,0.0,2.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>3A</td>\n",
       "      <td>2</td>\n",
       "      <td>8.79</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>4</td>\n",
       "      <td>Nam NGUYEN</td>\n",
       "      <td>5</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>CAN</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>2.80</td>\n",
       "      <td>0.07</td>\n",
       "      <td>0.0,0.0,0.0,0.0,-1.0,1.0,1.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>FCSp3</td>\n",
       "      <td>3</td>\n",
       "      <td>2.87</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>4</td>\n",
       "      <td>Nam NGUYEN</td>\n",
       "      <td>5</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>CAN</td>\n",
       "      <td>men</td>\n",
       "      <td>True</td>\n",
       "      <td>6.60</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1.0,0.0,0.0,1.0,0.0,0.0,1.0,1.0,1.0</td>\n",
       "      <td></td>\n",
       "      <td>3Lz</td>\n",
       "      <td>4</td>\n",
       "      <td>7.00</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>4</td>\n",
       "      <td>Nam NGUYEN</td>\n",
       "      <td>5</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>CAN</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>3.30</td>\n",
       "      <td>0.64</td>\n",
       "      <td>2.0,2.0,1.0,2.0,0.0,1.0,2.0,1.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>StSq3</td>\n",
       "      <td>5</td>\n",
       "      <td>3.94</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>4</td>\n",
       "      <td>Nam NGUYEN</td>\n",
       "      <td>5</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>CAN</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>CSSp</td>\n",
       "      <td>6</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>4</td>\n",
       "      <td>Nam NGUYEN</td>\n",
       "      <td>5</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>CAN</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>3.50</td>\n",
       "      <td>0.14</td>\n",
       "      <td>0.0,0.0,1.0,1.0,0.0,0.0,1.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>CCoSp4</td>\n",
       "      <td>7</td>\n",
       "      <td>3.64</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>4</td>\n",
       "      <td>Nam NGUYEN</td>\n",
       "      <td>5</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>RUS</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>10.30</td>\n",
       "      <td>-4.00</td>\n",
       "      <td>-3.0,-3.0,-3.0,-3.0,-3.0,-3.0,-3.0,-3.0,-3.0</td>\n",
       "      <td></td>\n",
       "      <td>4T</td>\n",
       "      <td>1</td>\n",
       "      <td>6.30</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>5</td>\n",
       "      <td>Sergei VORONOV</td>\n",
       "      <td>4</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>-3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>RUS</td>\n",
       "      <td>men</td>\n",
       "      <td>False</td>\n",
       "      <td>3.20</td>\n",
       "      <td>0.36</td>\n",
       "      <td>0.0,1.0,1.0,2.0,0.0,1.0,0.0,1.0,1.0</td>\n",
       "      <td></td>\n",
       "      <td>FCSp4</td>\n",
       "      <td>2</td>\n",
       "      <td>3.56</td>\n",
       "      <td>2017</td>\n",
       "      <td>gpusa2016_men_short</td>\n",
       "      <td>5</td>\n",
       "      <td>Sergei VORONOV</td>\n",
       "      <td>4</td>\n",
       "      <td>Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17551</th>\n",
       "      <td>JPN</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>5.60</td>\n",
       "      <td>0.16</td>\n",
       "      <td>0.0,0.0,0.0,1.0,0.0,0.0,0.0,1.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>DiSt2</td>\n",
       "      <td>7</td>\n",
       "      <td>5.76</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>11</td>\n",
       "      <td>Rikako FUKASE / Aru TATENO</td>\n",
       "      <td>3</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17552</th>\n",
       "      <td>JPN</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>4.50</td>\n",
       "      <td>0.86</td>\n",
       "      <td>2.0,2.0,1.0,1.0,2.0,1.0,1.0,2.0,1.0</td>\n",
       "      <td></td>\n",
       "      <td>RoLi4</td>\n",
       "      <td>8</td>\n",
       "      <td>5.36</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>11</td>\n",
       "      <td>Rikako FUKASE / Aru TATENO</td>\n",
       "      <td>3</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17553</th>\n",
       "      <td>JPN</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.50</td>\n",
       "      <td>1.0,1.0,1.0,1.0,0.0,1.0,0.0,1.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>ChSp1</td>\n",
       "      <td>9</td>\n",
       "      <td>1.50</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>11</td>\n",
       "      <td>Rikako FUKASE / Aru TATENO</td>\n",
       "      <td>3</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17554</th>\n",
       "      <td>CHN</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>4.50</td>\n",
       "      <td>0.60</td>\n",
       "      <td>1.0,1.0,2.0,1.0,0.0,1.0,1.0,1.0,1.0</td>\n",
       "      <td></td>\n",
       "      <td>StaLi4</td>\n",
       "      <td>1</td>\n",
       "      <td>5.10</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>12</td>\n",
       "      <td>Linshu SONG / Zhuoming SUN</td>\n",
       "      <td>1</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17555</th>\n",
       "      <td>CHN</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.50</td>\n",
       "      <td>1.0,1.0,1.0,1.0,0.0,1.0,1.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>ChSp1</td>\n",
       "      <td>2</td>\n",
       "      <td>1.50</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>12</td>\n",
       "      <td>Linshu SONG / Zhuoming SUN</td>\n",
       "      <td>1</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17556</th>\n",
       "      <td>CHN</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>5.60</td>\n",
       "      <td>0.47</td>\n",
       "      <td>1.0,1.0,0.0,0.0,-1.0,1.0,1.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>SeSt2</td>\n",
       "      <td>3</td>\n",
       "      <td>6.07</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>12</td>\n",
       "      <td>Linshu SONG / Zhuoming SUN</td>\n",
       "      <td>1</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17557</th>\n",
       "      <td>CHN</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>3.60</td>\n",
       "      <td>-0.21</td>\n",
       "      <td>1.0,-1.0,0.0,0.0,-1.0,0.0,-1.0,0.0,-1.0</td>\n",
       "      <td></td>\n",
       "      <td>CoSp2</td>\n",
       "      <td>4</td>\n",
       "      <td>3.39</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>12</td>\n",
       "      <td>Linshu SONG / Zhuoming SUN</td>\n",
       "      <td>1</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17558</th>\n",
       "      <td>CHN</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>4.50</td>\n",
       "      <td>0.34</td>\n",
       "      <td>1.0,0.0,1.0,0.0,0.0,1.0,0.0,1.0,1.0</td>\n",
       "      <td></td>\n",
       "      <td>SlLi4</td>\n",
       "      <td>5</td>\n",
       "      <td>4.84</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>12</td>\n",
       "      <td>Linshu SONG / Zhuoming SUN</td>\n",
       "      <td>1</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17559</th>\n",
       "      <td>CHN</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>6.60</td>\n",
       "      <td>0.10</td>\n",
       "      <td>-1.0,0.0,1.0,1.0,0.0,0.0,0.0,-1.0,1.0</td>\n",
       "      <td></td>\n",
       "      <td>STw4</td>\n",
       "      <td>6</td>\n",
       "      <td>6.70</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>12</td>\n",
       "      <td>Linshu SONG / Zhuoming SUN</td>\n",
       "      <td>1</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17560</th>\n",
       "      <td>CHN</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>5.60</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>DiSt2</td>\n",
       "      <td>7</td>\n",
       "      <td>5.60</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>12</td>\n",
       "      <td>Linshu SONG / Zhuoming SUN</td>\n",
       "      <td>1</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17561</th>\n",
       "      <td>CHN</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>4.00</td>\n",
       "      <td>0.51</td>\n",
       "      <td>0.0,1.0,1.0,1.0,1.0,1.0,1.0,0.0,1.0</td>\n",
       "      <td></td>\n",
       "      <td>RoLi3</td>\n",
       "      <td>8</td>\n",
       "      <td>4.51</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>12</td>\n",
       "      <td>Linshu SONG / Zhuoming SUN</td>\n",
       "      <td>1</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17562</th>\n",
       "      <td>CHN</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>ChTw1</td>\n",
       "      <td>9</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>12</td>\n",
       "      <td>Linshu SONG / Zhuoming SUN</td>\n",
       "      <td>1</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17563</th>\n",
       "      <td>AUS</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>4.50</td>\n",
       "      <td>0.34</td>\n",
       "      <td>1.0,0.0,1.0,1.0,0.0,0.0,0.0,1.0,1.0</td>\n",
       "      <td></td>\n",
       "      <td>StaLi4</td>\n",
       "      <td>1</td>\n",
       "      <td>4.84</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>13</td>\n",
       "      <td>Chantelle KERRY / Andrew DODDS</td>\n",
       "      <td>2</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17564</th>\n",
       "      <td>AUS</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>4.50</td>\n",
       "      <td>0.51</td>\n",
       "      <td>1.0,1.0,1.0,1.0,0.0,1.0,1.0,1.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>CuLi4</td>\n",
       "      <td>2</td>\n",
       "      <td>5.01</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>13</td>\n",
       "      <td>Chantelle KERRY / Andrew DODDS</td>\n",
       "      <td>2</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17565</th>\n",
       "      <td>AUS</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>4.60</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0,1.0,-1.0,1.0,0.0,-1.0,0.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>CoSp3</td>\n",
       "      <td>3</td>\n",
       "      <td>4.61</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>13</td>\n",
       "      <td>Chantelle KERRY / Andrew DODDS</td>\n",
       "      <td>2</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17566</th>\n",
       "      <td>AUS</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>5.60</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0,1.0,0.0,0.0,-1.0,0.0,0.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>CiSt2</td>\n",
       "      <td>4</td>\n",
       "      <td>5.60</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>13</td>\n",
       "      <td>Chantelle KERRY / Andrew DODDS</td>\n",
       "      <td>2</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17567</th>\n",
       "      <td>AUS</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>4.50</td>\n",
       "      <td>0.60</td>\n",
       "      <td>1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0</td>\n",
       "      <td></td>\n",
       "      <td>SlLi4</td>\n",
       "      <td>5</td>\n",
       "      <td>5.10</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>13</td>\n",
       "      <td>Chantelle KERRY / Andrew DODDS</td>\n",
       "      <td>2</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17568</th>\n",
       "      <td>AUS</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>4.10</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0,0.0,-1.0,0.0,0.0,0.0,0.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>DiSt1</td>\n",
       "      <td>6</td>\n",
       "      <td>4.10</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>13</td>\n",
       "      <td>Chantelle KERRY / Andrew DODDS</td>\n",
       "      <td>2</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17569</th>\n",
       "      <td>AUS</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>6.60</td>\n",
       "      <td>-0.20</td>\n",
       "      <td>-1.0,-1.0,1.0,-1.0,0.0,-1.0,1.0,-1.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>STw4</td>\n",
       "      <td>7</td>\n",
       "      <td>6.40</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>13</td>\n",
       "      <td>Chantelle KERRY / Andrew DODDS</td>\n",
       "      <td>2</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17570</th>\n",
       "      <td>AUS</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.60</td>\n",
       "      <td>1.0,1.0,1.0,1.0,1.0,1.0,1.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>ChTw1</td>\n",
       "      <td>8</td>\n",
       "      <td>1.60</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>13</td>\n",
       "      <td>Chantelle KERRY / Andrew DODDS</td>\n",
       "      <td>2</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17571</th>\n",
       "      <td>AUS</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1.0,1.0,1.0,1.0,0.0,0.0,1.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>ChLi1</td>\n",
       "      <td>9</td>\n",
       "      <td>1.40</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>13</td>\n",
       "      <td>Chantelle KERRY / Andrew DODDS</td>\n",
       "      <td>2</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17572</th>\n",
       "      <td>AUS</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>3.10</td>\n",
       "      <td>-0.27</td>\n",
       "      <td>-2.0,1.0,-1.0,0.0,0.0,-1.0,-1.0,-2.0,-1.0</td>\n",
       "      <td></td>\n",
       "      <td>STw1</td>\n",
       "      <td>1</td>\n",
       "      <td>2.83</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>14</td>\n",
       "      <td>Matilda FRIEND / William BADAOUI</td>\n",
       "      <td>4</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17573</th>\n",
       "      <td>AUS</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>4.50</td>\n",
       "      <td>0.09</td>\n",
       "      <td>1.0,0.0,0.0,0.0,-1.0,0.0,1.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>SlLi4</td>\n",
       "      <td>2</td>\n",
       "      <td>4.59</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>14</td>\n",
       "      <td>Matilda FRIEND / William BADAOUI</td>\n",
       "      <td>4</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17574</th>\n",
       "      <td>AUS</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>4.10</td>\n",
       "      <td>-0.14</td>\n",
       "      <td>0.0,-1.0,0.0,0.0,-1.0,0.0,0.0,0.0,-2.0</td>\n",
       "      <td></td>\n",
       "      <td>CiSt1</td>\n",
       "      <td>3</td>\n",
       "      <td>3.96</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>14</td>\n",
       "      <td>Matilda FRIEND / William BADAOUI</td>\n",
       "      <td>4</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17575</th>\n",
       "      <td>AUS</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>5.60</td>\n",
       "      <td>-0.14</td>\n",
       "      <td>0.0,0.0,0.0,1.0,-1.0,-1.0,0.0,0.0,-1.0</td>\n",
       "      <td></td>\n",
       "      <td>CoSp4</td>\n",
       "      <td>4</td>\n",
       "      <td>5.46</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>14</td>\n",
       "      <td>Matilda FRIEND / William BADAOUI</td>\n",
       "      <td>4</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17576</th>\n",
       "      <td>AUS</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>4.50</td>\n",
       "      <td>0.34</td>\n",
       "      <td>1.0,1.0,2.0,0.0,0.0,1.0,1.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>CuLi4</td>\n",
       "      <td>5</td>\n",
       "      <td>4.84</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>14</td>\n",
       "      <td>Matilda FRIEND / William BADAOUI</td>\n",
       "      <td>4</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17577</th>\n",
       "      <td>AUS</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>4.10</td>\n",
       "      <td>-0.21</td>\n",
       "      <td>0.0,-1.0,0.0,0.0,-1.0,-1.0,0.0,0.0,-1.0</td>\n",
       "      <td></td>\n",
       "      <td>DiSt1</td>\n",
       "      <td>6</td>\n",
       "      <td>3.89</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>14</td>\n",
       "      <td>Matilda FRIEND / William BADAOUI</td>\n",
       "      <td>4</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17578</th>\n",
       "      <td>AUS</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>4.50</td>\n",
       "      <td>-0.14</td>\n",
       "      <td>-1.0,1.0,0.0,0.0,0.0,-1.0,-1.0,0.0,0.0</td>\n",
       "      <td>&gt;</td>\n",
       "      <td>RoLi4</td>\n",
       "      <td>7</td>\n",
       "      <td>4.36</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>14</td>\n",
       "      <td>Matilda FRIEND / William BADAOUI</td>\n",
       "      <td>4</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17579</th>\n",
       "      <td>AUS</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0,0.0,0.0,1.0,0.0,-1.0,0.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>ChLi1</td>\n",
       "      <td>8</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>14</td>\n",
       "      <td>Matilda FRIEND / William BADAOUI</td>\n",
       "      <td>4</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17580</th>\n",
       "      <td>AUS</td>\n",
       "      <td>ice_dance</td>\n",
       "      <td>False</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.30</td>\n",
       "      <td>1.0,1.0,1.0,1.0,0.0,-1.0,0.0,0.0,0.0</td>\n",
       "      <td></td>\n",
       "      <td>ChSp1</td>\n",
       "      <td>9</td>\n",
       "      <td>1.30</td>\n",
       "      <td>2018</td>\n",
       "      <td>fc2018_ice_dance_free</td>\n",
       "      <td>14</td>\n",
       "      <td>Matilda FRIEND / William BADAOUI</td>\n",
       "      <td>4</td>\n",
       "      <td>Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17581 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      country discipline  elt_bonus  elt_bv  elt_finalgoe  \\\n",
       "0         JPN        men      False   12.30         -0.51   \n",
       "1         JPN        men      False   13.30         -4.00   \n",
       "2         JPN        men      False    3.20          0.86   \n",
       "3         JPN        men      False    3.00          0.64   \n",
       "4         JPN        men       True    9.35         -0.14   \n",
       "5         JPN        men      False    3.30          0.93   \n",
       "6         JPN        men      False    3.50          1.14   \n",
       "7         USA        men      False    9.60          0.90   \n",
       "8         USA        men      False    8.50          1.29   \n",
       "9         USA        men      False    3.50          1.07   \n",
       "10        USA        men       True    6.60          1.00   \n",
       "11        USA        men      False    3.20          0.79   \n",
       "12        USA        men      False    3.30          1.14   \n",
       "13        USA        men      False    2.60          0.93   \n",
       "14        USA        men      False   10.30         -4.00   \n",
       "15        USA        men      False    8.50          2.00   \n",
       "16        USA        men      False    3.00          1.00   \n",
       "17        USA        men      False    0.00          0.00   \n",
       "18        USA        men       True   11.33          1.00   \n",
       "19        USA        men      False    3.90          2.00   \n",
       "20        USA        men      False    3.50          0.79   \n",
       "21        CAN        men      False   14.80          1.14   \n",
       "22        CAN        men      False    8.50          0.29   \n",
       "23        CAN        men      False    2.80          0.07   \n",
       "24        CAN        men       True    6.60          0.40   \n",
       "25        CAN        men      False    3.30          0.64   \n",
       "26        CAN        men      False    0.00          0.00   \n",
       "27        CAN        men      False    3.50          0.14   \n",
       "28        RUS        men      False   10.30         -4.00   \n",
       "29        RUS        men      False    3.20          0.36   \n",
       "...       ...        ...        ...     ...           ...   \n",
       "17551     JPN  ice_dance      False    5.60          0.16   \n",
       "17552     JPN  ice_dance      False    4.50          0.86   \n",
       "17553     JPN  ice_dance      False    1.00          0.50   \n",
       "17554     CHN  ice_dance      False    4.50          0.60   \n",
       "17555     CHN  ice_dance      False    1.00          0.50   \n",
       "17556     CHN  ice_dance      False    5.60          0.47   \n",
       "17557     CHN  ice_dance      False    3.60         -0.21   \n",
       "17558     CHN  ice_dance      False    4.50          0.34   \n",
       "17559     CHN  ice_dance      False    6.60          0.10   \n",
       "17560     CHN  ice_dance      False    5.60          0.00   \n",
       "17561     CHN  ice_dance      False    4.00          0.51   \n",
       "17562     CHN  ice_dance      False    1.00          0.00   \n",
       "17563     AUS  ice_dance      False    4.50          0.34   \n",
       "17564     AUS  ice_dance      False    4.50          0.51   \n",
       "17565     AUS  ice_dance      False    4.60          0.01   \n",
       "17566     AUS  ice_dance      False    5.60          0.00   \n",
       "17567     AUS  ice_dance      False    4.50          0.60   \n",
       "17568     AUS  ice_dance      False    4.10          0.00   \n",
       "17569     AUS  ice_dance      False    6.60         -0.20   \n",
       "17570     AUS  ice_dance      False    1.00          0.60   \n",
       "17571     AUS  ice_dance      False    1.00          0.40   \n",
       "17572     AUS  ice_dance      False    3.10         -0.27   \n",
       "17573     AUS  ice_dance      False    4.50          0.09   \n",
       "17574     AUS  ice_dance      False    4.10         -0.14   \n",
       "17575     AUS  ice_dance      False    5.60         -0.14   \n",
       "17576     AUS  ice_dance      False    4.50          0.34   \n",
       "17577     AUS  ice_dance      False    4.10         -0.21   \n",
       "17578     AUS  ice_dance      False    4.50         -0.14   \n",
       "17579     AUS  ice_dance      False    1.00          0.00   \n",
       "17580     AUS  ice_dance      False    1.00          0.30   \n",
       "\n",
       "                                           elt_goes elt_info elt_name  \\\n",
       "0           -1.0,0.0,0.0,-1.0,-1.0,0.0,1.0,-1.0,0.0                4F   \n",
       "1      -3.0,-3.0,-3.0,-3.0,-3.0,-2.0,-3.0,-3.0,-3.0        <   4T+3T<   \n",
       "2               1.0,2.0,2.0,2.0,0.0,2.0,2.0,2.0,1.0             FCSp4   \n",
       "3               1.0,1.0,1.0,1.0,0.0,2.0,1.0,2.0,2.0             CSSp4   \n",
       "4             1.0,-1.0,-1.0,0.0,0.0,0.0,0.0,0.0,0.0                3A   \n",
       "5               2.0,1.0,2.0,2.0,1.0,3.0,2.0,2.0,2.0             StSq3   \n",
       "6               2.0,1.0,3.0,3.0,1.0,2.0,2.0,3.0,3.0            CCoSp4   \n",
       "7               2.0,1.0,1.0,1.0,0.0,1.0,2.0,1.0,2.0             3F+3T   \n",
       "8               1.0,1.0,2.0,2.0,0.0,1.0,1.0,1.0,2.0                3A   \n",
       "9               2.0,1.0,3.0,2.0,0.0,3.0,2.0,2.0,3.0            CCoSp4   \n",
       "10              1.0,0.0,1.0,2.0,1.0,2.0,1.0,2.0,2.0               3Lz   \n",
       "11              2.0,1.0,2.0,2.0,0.0,2.0,1.0,1.0,2.0             FCSp4   \n",
       "12              2.0,1.0,3.0,3.0,0.0,3.0,2.0,2.0,3.0             StSq3   \n",
       "13              2.0,1.0,2.0,2.0,1.0,2.0,2.0,2.0,3.0             CSSp3   \n",
       "14     -3.0,-3.0,-3.0,-3.0,-3.0,-3.0,-3.0,-3.0,-3.0                4T   \n",
       "15              2.0,2.0,2.0,3.0,1.0,2.0,2.0,2.0,2.0                3A   \n",
       "16              2.0,2.0,2.0,2.0,1.0,3.0,2.0,2.0,2.0             FSSp4   \n",
       "17              0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0              CCSp   \n",
       "18              2.0,0.0,1.0,2.0,0.0,2.0,2.0,2.0,1.0            3Lz+3T   \n",
       "19              3.0,2.0,3.0,3.0,1.0,3.0,3.0,3.0,3.0             StSq4   \n",
       "20              2.0,1.0,2.0,2.0,0.0,1.0,2.0,1.0,2.0            CCoSp4   \n",
       "21              2.0,1.0,1.0,2.0,0.0,1.0,1.0,1.0,1.0             4S+3T   \n",
       "22              0.0,0.0,1.0,1.0,0.0,0.0,2.0,0.0,0.0                3A   \n",
       "23             0.0,0.0,0.0,0.0,-1.0,1.0,1.0,0.0,0.0             FCSp3   \n",
       "24              1.0,0.0,0.0,1.0,0.0,0.0,1.0,1.0,1.0               3Lz   \n",
       "25              2.0,2.0,1.0,2.0,0.0,1.0,2.0,1.0,0.0             StSq3   \n",
       "26              0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0              CSSp   \n",
       "27              0.0,0.0,1.0,1.0,0.0,0.0,1.0,0.0,0.0            CCoSp4   \n",
       "28     -3.0,-3.0,-3.0,-3.0,-3.0,-3.0,-3.0,-3.0,-3.0                4T   \n",
       "29              0.0,1.0,1.0,2.0,0.0,1.0,0.0,1.0,1.0             FCSp4   \n",
       "...                                             ...      ...      ...   \n",
       "17551           0.0,0.0,0.0,1.0,0.0,0.0,0.0,1.0,0.0             DiSt2   \n",
       "17552           2.0,2.0,1.0,1.0,2.0,1.0,1.0,2.0,1.0             RoLi4   \n",
       "17553           1.0,1.0,1.0,1.0,0.0,1.0,0.0,1.0,0.0             ChSp1   \n",
       "17554           1.0,1.0,2.0,1.0,0.0,1.0,1.0,1.0,1.0            StaLi4   \n",
       "17555           1.0,1.0,1.0,1.0,0.0,1.0,1.0,0.0,0.0             ChSp1   \n",
       "17556          1.0,1.0,0.0,0.0,-1.0,1.0,1.0,0.0,0.0             SeSt2   \n",
       "17557       1.0,-1.0,0.0,0.0,-1.0,0.0,-1.0,0.0,-1.0             CoSp2   \n",
       "17558           1.0,0.0,1.0,0.0,0.0,1.0,0.0,1.0,1.0             SlLi4   \n",
       "17559         -1.0,0.0,1.0,1.0,0.0,0.0,0.0,-1.0,1.0              STw4   \n",
       "17560          -1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0             DiSt2   \n",
       "17561           0.0,1.0,1.0,1.0,1.0,1.0,1.0,0.0,1.0             RoLi3   \n",
       "17562           0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0             ChTw1   \n",
       "17563           1.0,0.0,1.0,1.0,0.0,0.0,0.0,1.0,1.0            StaLi4   \n",
       "17564           1.0,1.0,1.0,1.0,0.0,1.0,1.0,1.0,0.0             CuLi4   \n",
       "17565         0.0,1.0,-1.0,1.0,0.0,-1.0,0.0,0.0,0.0             CoSp3   \n",
       "17566          0.0,1.0,0.0,0.0,-1.0,0.0,0.0,0.0,0.0             CiSt2   \n",
       "17567           1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0             SlLi4   \n",
       "17568          1.0,0.0,-1.0,0.0,0.0,0.0,0.0,0.0,0.0             DiSt1   \n",
       "17569      -1.0,-1.0,1.0,-1.0,0.0,-1.0,1.0,-1.0,0.0              STw4   \n",
       "17570           1.0,1.0,1.0,1.0,1.0,1.0,1.0,0.0,0.0             ChTw1   \n",
       "17571           1.0,1.0,1.0,1.0,0.0,0.0,1.0,0.0,0.0             ChLi1   \n",
       "17572     -2.0,1.0,-1.0,0.0,0.0,-1.0,-1.0,-2.0,-1.0              STw1   \n",
       "17573          1.0,0.0,0.0,0.0,-1.0,0.0,1.0,0.0,0.0             SlLi4   \n",
       "17574        0.0,-1.0,0.0,0.0,-1.0,0.0,0.0,0.0,-2.0             CiSt1   \n",
       "17575        0.0,0.0,0.0,1.0,-1.0,-1.0,0.0,0.0,-1.0             CoSp4   \n",
       "17576           1.0,1.0,2.0,0.0,0.0,1.0,1.0,0.0,0.0             CuLi4   \n",
       "17577       0.0,-1.0,0.0,0.0,-1.0,-1.0,0.0,0.0,-1.0             DiSt1   \n",
       "17578        -1.0,1.0,0.0,0.0,0.0,-1.0,-1.0,0.0,0.0        >    RoLi4   \n",
       "17579          0.0,0.0,0.0,1.0,0.0,-1.0,0.0,0.0,0.0             ChLi1   \n",
       "17580          1.0,1.0,1.0,1.0,0.0,-1.0,0.0,0.0,0.0             ChSp1   \n",
       "\n",
       "       elt_number  elt_points  season           segment_name  segment_rank  \\\n",
       "0               1       11.79    2017    gpusa2016_men_short             1   \n",
       "1               2        9.30    2017    gpusa2016_men_short             1   \n",
       "2               3        4.06    2017    gpusa2016_men_short             1   \n",
       "3               4        3.64    2017    gpusa2016_men_short             1   \n",
       "4               5        9.21    2017    gpusa2016_men_short             1   \n",
       "5               6        4.23    2017    gpusa2016_men_short             1   \n",
       "6               7        4.64    2017    gpusa2016_men_short             1   \n",
       "7               1       10.50    2017    gpusa2016_men_short             2   \n",
       "8               2        9.79    2017    gpusa2016_men_short             2   \n",
       "9               3        4.57    2017    gpusa2016_men_short             2   \n",
       "10              4        7.60    2017    gpusa2016_men_short             2   \n",
       "11              5        3.99    2017    gpusa2016_men_short             2   \n",
       "12              6        4.44    2017    gpusa2016_men_short             2   \n",
       "13              7        3.53    2017    gpusa2016_men_short             2   \n",
       "14              1        6.30    2017    gpusa2016_men_short             3   \n",
       "15              2       10.50    2017    gpusa2016_men_short             3   \n",
       "16              3        4.00    2017    gpusa2016_men_short             3   \n",
       "17              4        0.00    2017    gpusa2016_men_short             3   \n",
       "18              5       12.33    2017    gpusa2016_men_short             3   \n",
       "19              6        5.90    2017    gpusa2016_men_short             3   \n",
       "20              7        4.29    2017    gpusa2016_men_short             3   \n",
       "21              1       15.94    2017    gpusa2016_men_short             4   \n",
       "22              2        8.79    2017    gpusa2016_men_short             4   \n",
       "23              3        2.87    2017    gpusa2016_men_short             4   \n",
       "24              4        7.00    2017    gpusa2016_men_short             4   \n",
       "25              5        3.94    2017    gpusa2016_men_short             4   \n",
       "26              6        0.00    2017    gpusa2016_men_short             4   \n",
       "27              7        3.64    2017    gpusa2016_men_short             4   \n",
       "28              1        6.30    2017    gpusa2016_men_short             5   \n",
       "29              2        3.56    2017    gpusa2016_men_short             5   \n",
       "...           ...         ...     ...                    ...           ...   \n",
       "17551           7        5.76    2018  fc2018_ice_dance_free            11   \n",
       "17552           8        5.36    2018  fc2018_ice_dance_free            11   \n",
       "17553           9        1.50    2018  fc2018_ice_dance_free            11   \n",
       "17554           1        5.10    2018  fc2018_ice_dance_free            12   \n",
       "17555           2        1.50    2018  fc2018_ice_dance_free            12   \n",
       "17556           3        6.07    2018  fc2018_ice_dance_free            12   \n",
       "17557           4        3.39    2018  fc2018_ice_dance_free            12   \n",
       "17558           5        4.84    2018  fc2018_ice_dance_free            12   \n",
       "17559           6        6.70    2018  fc2018_ice_dance_free            12   \n",
       "17560           7        5.60    2018  fc2018_ice_dance_free            12   \n",
       "17561           8        4.51    2018  fc2018_ice_dance_free            12   \n",
       "17562           9        1.00    2018  fc2018_ice_dance_free            12   \n",
       "17563           1        4.84    2018  fc2018_ice_dance_free            13   \n",
       "17564           2        5.01    2018  fc2018_ice_dance_free            13   \n",
       "17565           3        4.61    2018  fc2018_ice_dance_free            13   \n",
       "17566           4        5.60    2018  fc2018_ice_dance_free            13   \n",
       "17567           5        5.10    2018  fc2018_ice_dance_free            13   \n",
       "17568           6        4.10    2018  fc2018_ice_dance_free            13   \n",
       "17569           7        6.40    2018  fc2018_ice_dance_free            13   \n",
       "17570           8        1.60    2018  fc2018_ice_dance_free            13   \n",
       "17571           9        1.40    2018  fc2018_ice_dance_free            13   \n",
       "17572           1        2.83    2018  fc2018_ice_dance_free            14   \n",
       "17573           2        4.59    2018  fc2018_ice_dance_free            14   \n",
       "17574           3        3.96    2018  fc2018_ice_dance_free            14   \n",
       "17575           4        5.46    2018  fc2018_ice_dance_free            14   \n",
       "17576           5        4.84    2018  fc2018_ice_dance_free            14   \n",
       "17577           6        3.89    2018  fc2018_ice_dance_free            14   \n",
       "17578           7        4.36    2018  fc2018_ice_dance_free            14   \n",
       "17579           8        1.00    2018  fc2018_ice_dance_free            14   \n",
       "17580           9        1.30    2018  fc2018_ice_dance_free            14   \n",
       "\n",
       "                                 skater  start_order  \\\n",
       "0                             Shoma UNO            9   \n",
       "1                             Shoma UNO            9   \n",
       "2                             Shoma UNO            9   \n",
       "3                             Shoma UNO            9   \n",
       "4                             Shoma UNO            9   \n",
       "5                             Shoma UNO            9   \n",
       "6                             Shoma UNO            9   \n",
       "7                           Adam RIPPON           10   \n",
       "8                           Adam RIPPON           10   \n",
       "9                           Adam RIPPON           10   \n",
       "10                          Adam RIPPON           10   \n",
       "11                          Adam RIPPON           10   \n",
       "12                          Adam RIPPON           10   \n",
       "13                          Adam RIPPON           10   \n",
       "14                          Jason BROWN            8   \n",
       "15                          Jason BROWN            8   \n",
       "16                          Jason BROWN            8   \n",
       "17                          Jason BROWN            8   \n",
       "18                          Jason BROWN            8   \n",
       "19                          Jason BROWN            8   \n",
       "20                          Jason BROWN            8   \n",
       "21                           Nam NGUYEN            5   \n",
       "22                           Nam NGUYEN            5   \n",
       "23                           Nam NGUYEN            5   \n",
       "24                           Nam NGUYEN            5   \n",
       "25                           Nam NGUYEN            5   \n",
       "26                           Nam NGUYEN            5   \n",
       "27                           Nam NGUYEN            5   \n",
       "28                       Sergei VORONOV            4   \n",
       "29                       Sergei VORONOV            4   \n",
       "...                                 ...          ...   \n",
       "17551        Rikako FUKASE / Aru TATENO            3   \n",
       "17552        Rikako FUKASE / Aru TATENO            3   \n",
       "17553        Rikako FUKASE / Aru TATENO            3   \n",
       "17554        Linshu SONG / Zhuoming SUN            1   \n",
       "17555        Linshu SONG / Zhuoming SUN            1   \n",
       "17556        Linshu SONG / Zhuoming SUN            1   \n",
       "17557        Linshu SONG / Zhuoming SUN            1   \n",
       "17558        Linshu SONG / Zhuoming SUN            1   \n",
       "17559        Linshu SONG / Zhuoming SUN            1   \n",
       "17560        Linshu SONG / Zhuoming SUN            1   \n",
       "17561        Linshu SONG / Zhuoming SUN            1   \n",
       "17562        Linshu SONG / Zhuoming SUN            1   \n",
       "17563    Chantelle KERRY / Andrew DODDS            2   \n",
       "17564    Chantelle KERRY / Andrew DODDS            2   \n",
       "17565    Chantelle KERRY / Andrew DODDS            2   \n",
       "17566    Chantelle KERRY / Andrew DODDS            2   \n",
       "17567    Chantelle KERRY / Andrew DODDS            2   \n",
       "17568    Chantelle KERRY / Andrew DODDS            2   \n",
       "17569    Chantelle KERRY / Andrew DODDS            2   \n",
       "17570    Chantelle KERRY / Andrew DODDS            2   \n",
       "17571    Chantelle KERRY / Andrew DODDS            2   \n",
       "17572  Matilda FRIEND / William BADAOUI            4   \n",
       "17573  Matilda FRIEND / William BADAOUI            4   \n",
       "17574  Matilda FRIEND / William BADAOUI            4   \n",
       "17575  Matilda FRIEND / William BADAOUI            4   \n",
       "17576  Matilda FRIEND / William BADAOUI            4   \n",
       "17577  Matilda FRIEND / William BADAOUI            4   \n",
       "17578  Matilda FRIEND / William BADAOUI            4   \n",
       "17579  Matilda FRIEND / William BADAOUI            4   \n",
       "17580  Matilda FRIEND / William BADAOUI            4   \n",
       "\n",
       "                                                  judges  median_goe  \n",
       "0      Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         0.0  \n",
       "1      Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...        -3.0  \n",
       "2      Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         2.0  \n",
       "3      Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         1.0  \n",
       "4      Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         0.0  \n",
       "5      Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         2.0  \n",
       "6      Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         2.0  \n",
       "7      Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         1.0  \n",
       "8      Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         1.0  \n",
       "9      Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         2.0  \n",
       "10     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         1.0  \n",
       "11     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         2.0  \n",
       "12     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         2.0  \n",
       "13     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         2.0  \n",
       "14     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...        -3.0  \n",
       "15     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         2.0  \n",
       "16     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         2.0  \n",
       "17     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         0.0  \n",
       "18     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         2.0  \n",
       "19     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         3.0  \n",
       "20     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         2.0  \n",
       "21     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         1.0  \n",
       "22     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         0.0  \n",
       "23     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         0.0  \n",
       "24     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         1.0  \n",
       "25     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         1.0  \n",
       "26     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         0.0  \n",
       "27     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         0.0  \n",
       "28     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...        -3.0  \n",
       "29     Cynthia BENSON,Lisa JELINEK,Maira ABASOVA,Fran...         1.0  \n",
       "...                                                  ...         ...  \n",
       "17551  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         0.0  \n",
       "17552  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         1.0  \n",
       "17553  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         1.0  \n",
       "17554  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         1.0  \n",
       "17555  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         1.0  \n",
       "17556  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         0.0  \n",
       "17557  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         0.0  \n",
       "17558  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         1.0  \n",
       "17559  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         0.0  \n",
       "17560  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         0.0  \n",
       "17561  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         1.0  \n",
       "17562  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         0.0  \n",
       "17563  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         1.0  \n",
       "17564  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         1.0  \n",
       "17565  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         0.0  \n",
       "17566  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         0.0  \n",
       "17567  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         1.0  \n",
       "17568  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         0.0  \n",
       "17569  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...        -1.0  \n",
       "17570  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         1.0  \n",
       "17571  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         1.0  \n",
       "17572  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...        -1.0  \n",
       "17573  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         0.0  \n",
       "17574  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         0.0  \n",
       "17575  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         0.0  \n",
       "17576  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         1.0  \n",
       "17577  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         0.0  \n",
       "17578  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         0.0  \n",
       "17579  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         0.0  \n",
       "17580  Sandra WILLIAMSON-LEADLEY,Mark STORTON,Tianyi ...         0.0  \n",
       "\n",
       "[17581 rows x 17 columns]"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "elts_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(158173, 89105)"
      ]
     },
     "execution_count": 103,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(elts_df), len(comp_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "judge_not_med = {}\n",
    "judge_med = {}\n",
    "for judge in judge_names:\n",
    "    obs = len(elts_not_med[elts_not_med.judge == judge])\n",
    "    obs += len(comp_not_med[comp_not_med.judge == judge])\n",
    "    judge_not_med[judge] = obs\n",
    "    \n",
    "    obs = len(elts_med[elts_med.judge == judge])\n",
    "    obs += len(comp_med[comp_med.judge == judge])\n",
    "    judge_med[judge] = obs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[(u'Helene CUCUPHAT', 66),\n",
       " (u'Jennifer MAST', 85),\n",
       " (u'Francis BETSCH', 86),\n",
       " (u'Rossella CECCATTINI', 96),\n",
       " (u'Yu WANG', 96),\n",
       " (u'Elena LISOVA', 97),\n",
       " (u'Szilard TOTH', 98),\n",
       " (u'Marketa HORKLOVA', 101),\n",
       " (u'Prisca BINZ-MOSER', 101),\n",
       " (u'Roberts KRUTKRAMELIS', 101),\n",
       " (u'Taffy HOLLIDAY', 110),\n",
       " (u'Ece ESEN', 112),\n",
       " (u'Rebecca ANDREW', 113),\n",
       " (u'Kristina LUNDGREN', 115),\n",
       " (u'Evgeni ROKHIN', 121),\n",
       " (u'Anja RIST', 123),\n",
       " (u'Simona SPALLUTO', 127),\n",
       " (u'Ingrid Charlotte WOLTER', 128),\n",
       " (u'Garry HOPPE', 131),\n",
       " (u'Vladimir CUCHRAN', 136),\n",
       " (u'Vladislav PETUKHOV', 137),\n",
       " (u'Kaoru TAKINO', 140),\n",
       " (u'Elizabeth ALEXANDRE', 140),\n",
       " (u'Deborah ISLAM', 146),\n",
       " (u'Natalia KRUGLOVA', 148),\n",
       " (u'Vessela POPOVA', 149),\n",
       " (u'Makoto KANO', 149),\n",
       " (u'Tetsuo ABE', 149),\n",
       " (u'Tomie FUKUDOME', 155),\n",
       " (u'Xixia LIU', 159),\n",
       " (u'Darja GABROVSEK-POLAJNAR', 159),\n",
       " (u'Aigul KUANISHEVA', 160),\n",
       " (u'Guona ZHAO', 160),\n",
       " (u'Kvetoslava MATEJOVA', 162),\n",
       " (u'Walter ZUCCARO', 162),\n",
       " (u'Gloria MORANDI', 163),\n",
       " (u'Zuzana PLESNIKOVA', 165),\n",
       " (u'Merja KOSONEN', 169),\n",
       " (u'Kersten BELLMANN', 170),\n",
       " (u'Claudia FASSORA', 171),\n",
       " (u'Natan KFIR', 175),\n",
       " (u'Marjo KANKAANRANTA', 179),\n",
       " (u'Saioa SANCHO', 182),\n",
       " (u'Agnieszka SWIDERSKA', 182),\n",
       " (u'Tomiko YAMADA', 185),\n",
       " (u'Doug WILLIAMS', 185),\n",
       " (u'Hanna THEN', 186),\n",
       " (u'Matjaz KRUSEC', 186),\n",
       " (u'Josip CEROVAC', 190),\n",
       " (u'Beatrice PFISTER', 194),\n",
       " (u'Akira YOSHIZAWA', 196),\n",
       " (u'Jezabel DABOUIS', 197),\n",
       " (u'Asa NORDBACK', 197),\n",
       " (u'Lone AMSTRUP LINNEMANN', 199),\n",
       " (u'Teri SEDEJ', 199),\n",
       " (u'Lise ROSTO JENSEN', 199),\n",
       " (u'Adrienn SCHADENBAUER', 202),\n",
       " (u'Katalin BALCZO', 206),\n",
       " (u'Joanna MILLER', 206),\n",
       " (u'Richard GRAINGE', 207),\n",
       " (u'Donatella LEONELLI', 211),\n",
       " (u'Alice WALDER', 216),\n",
       " (u'Beth CRANE', 218),\n",
       " (u'Akiko KOBAYASHI', 221),\n",
       " (u'Leo  LENKOLA', 222),\n",
       " (u'Mami MAEDA', 226),\n",
       " (u'Stanislava SMIDOVA', 226),\n",
       " (u'Sissy KRICK', 227),\n",
       " (u'Melody Tan Tan YIP', 227),\n",
       " (u'Csaba BALINT', 229),\n",
       " (u'Eddy WU', 234),\n",
       " (u'Mary CHAPMAN', 235),\n",
       " (u'Lone VILLEFRANCE', 238),\n",
       " (u'Yoko KUNO', 244),\n",
       " (u'Andreas WALDECK', 246),\n",
       " (u'Emilie BILLOW', 247),\n",
       " (u'Franco BENINI', 248),\n",
       " (u'David MOLINA', 249),\n",
       " (u'Yuko OGAWA', 254),\n",
       " (u'Lenka BOHUNICKA', 255),\n",
       " (u'Elisabeth BINDER', 256),\n",
       " (u'Deborah CURRIE', 256),\n",
       " (u'Ludmila MIKHAILOVSKAYA', 260),\n",
       " (u'Daniela TACCANI', 262),\n",
       " (u'Etsuko AZUMA', 263),\n",
       " (u'Tatiana SHARKINA', 264),\n",
       " (u'Igor PROKOP', 268),\n",
       " (u'Jitka MOKRA', 268),\n",
       " (u'Allan BOEHM', 269),\n",
       " (u'Jean SENFT', 274),\n",
       " (u'Akos PETHES', 275),\n",
       " (u'Kylie Anne YACOPETTI', 279),\n",
       " (u'Sylvain GUIBORD', 281),\n",
       " (u'Dagmar LURZ-PROTT', 293),\n",
       " (u'Michela CESARO', 293),\n",
       " (u'Elizabeth RYAN', 295),\n",
       " (u'Christian BAUMANN', 297),\n",
       " (u'Tarja RISTANEN', 299),\n",
       " (u'Ko-Man TING', 299),\n",
       " (u'Karen HOWARD', 303),\n",
       " (u'Kristina HOUWING', 306),\n",
       " (u'Ernestien BAKKER', 307),\n",
       " (u'Tae Ri LEE', 308),\n",
       " (u'Miroslav MISUREC', 315),\n",
       " (u'Magdalena RUSIECKA', 320),\n",
       " (u'Andrea GMELIN', 320),\n",
       " (u'Patricia MORITZ', 323),\n",
       " (u'Irina KOMARNICKA', 326),\n",
       " (u'John MILLIER', 326),\n",
       " (u'Robert ROSENBLUTH', 330),\n",
       " (u'Jia YAO', 331),\n",
       " (u'Roland MAEDER', 331),\n",
       " (u'Nadezhda PARETSKAIA', 331),\n",
       " (u'Osman SIRVAN', 336),\n",
       " (u'Susan PETRICEVIC', 336),\n",
       " (u'Peter RANKIN', 344),\n",
       " (u'Virpi KUNNAS-HELMINEN', 354),\n",
       " (u'Christiane MILES', 354),\n",
       " (u'Ariadna MORONES NEGRETE', 356),\n",
       " (u'Karin EHRHARDT', 358),\n",
       " (u'Raia BISSEROVA-BAKALOVA', 361),\n",
       " (u'Marco BUTTARELLI', 361),\n",
       " (u'Igor FEDCHENKO', 365),\n",
       " (u'Samuel AUXIER', 366),\n",
       " (u'Jeroen PRINS', 368),\n",
       " (u'Tamie K. CAMPBELL', 369),\n",
       " (u'Igor DOLGUSHIN', 371),\n",
       " (u'Florence VUYLSTEKER', 371),\n",
       " (u'Andre-Marc ALLAIN', 373),\n",
       " (u'Kadi ZVIRIK', 373),\n",
       " (u'Mona JONSSON', 376),\n",
       " (u'Danuta DUBROWKO', 379),\n",
       " (u'Irina MEDVEDEVA', 380),\n",
       " (u'Alison RYAN', 382),\n",
       " (u'Ann FINDLAY', 382),\n",
       " (u'Edith SCHILLER', 385),\n",
       " (u'Nadezhda FIODOROVA', 390),\n",
       " (u'Mona ADOLFSEN', 392),\n",
       " (u'Kathleen HARMON', 393),\n",
       " (u'Attila SOOS', 401),\n",
       " (u'Anne CAMMETT', 402),\n",
       " (u'Sally REHORICK', 404),\n",
       " (u'Deborah NOYES', 408),\n",
       " (u'Claudia BRAMBATI', 412),\n",
       " (u'Veronique VERRUE', 414),\n",
       " (u'Senem AHISKAL', 419),\n",
       " (u'Wei SHI', 422),\n",
       " (u'Bettina MEIER', 424),\n",
       " (u'Hege ROSTO JENSEN', 424),\n",
       " (u'Steve WINKLER', 432),\n",
       " (u'Richard DALLEY', 437),\n",
       " (u'Sung-Hee KOH', 445),\n",
       " (u'Jana BAUDYSOVA', 448),\n",
       " (u'Hailan JIANG', 450),\n",
       " (u'Christiane MOERTH', 453),\n",
       " (u'Ekaterina SEROVA', 466),\n",
       " (u'Karen BUTCHER', 483),\n",
       " (u'Katarina HENRIKSSON', 487),\n",
       " (u'Jodi ABBOTT', 489),\n",
       " (u'David MUNOZ', 495),\n",
       " (u'Reaghan FAWCETT', 495),\n",
       " (u'Anastassia MAKAROVA', 496),\n",
       " (u'Andrea DERBY', 498),\n",
       " (u'Margaret WORSFOLD', 499),\n",
       " (u'Sakae YAMAMOTO', 505),\n",
       " (u'Thomas BIEGLER', 516),\n",
       " (u'Guangying QIN', 516),\n",
       " (u'Mayumi KATO', 535),\n",
       " (u'Kerstin KIMMINUS', 546),\n",
       " (u'Isabella MICHELI', 551),\n",
       " (u'Jung-Sue LEE', 560),\n",
       " (u'Alexandre GOROJDANOV', 564),\n",
       " (u'Janice HUNTER', 571),\n",
       " (u'Salome CHIGOGIDZE', 582),\n",
       " (u'Ayumi KOZUKA', 583),\n",
       " (u'Wendy ENZMANN', 597),\n",
       " (u'Cynthia BENSON', 599),\n",
       " (u'Laimute KRAUZIENE', 615),\n",
       " (u'Zanna KULIK', 629),\n",
       " (u'Christine HURTH', 630),\n",
       " (u'Philippe MERIGUET', 643),\n",
       " (u'Neil GARRARD', 645),\n",
       " (u'Kenji AMAKO', 646),\n",
       " (u'Malgorzata SOBKOW', 648),\n",
       " (u'Lisa JELINEK', 656),\n",
       " (u'Peggy GRAHAM', 663),\n",
       " (u'Igor OBRAZTSOV', 666),\n",
       " (u'Roger GLENN', 669),\n",
       " (u'Lynne DEY', 670),\n",
       " (u'Nicholas RUSSELL', 678),\n",
       " (u'Adriana DOMANSKA', 693),\n",
       " (u'Sviatoslav BABENKO', 700),\n",
       " (u'Vera TAUCHMANOVA', 707),\n",
       " (u'Leslie KEEN', 711),\n",
       " (u'Lolita LABUNSKAIYA', 712),\n",
       " (u'Nicole LEBLANC-RICHARD', 733),\n",
       " (u'Ebru ANILDI', 733),\n",
       " (u'Elisabeth LOUESDON', 735),\n",
       " (u'Ulla FAIG', 737),\n",
       " (u'Na Young AHN', 741),\n",
       " (u'Elke TREITZ', 743),\n",
       " (u'Sandra WILLIAMSON-LEADLEY', 748),\n",
       " (u'Albert ZAYDMAN', 751),\n",
       " (u'Angelique CLYDE-SMITH', 757),\n",
       " (u'Walter TOIGO', 788),\n",
       " (u'Richard KOSINA', 818),\n",
       " (u'Mark STORTON', 820),\n",
       " (u'Massimo ORLANDINI', 825),\n",
       " (u'Paolo PIZZOCARI', 828),\n",
       " (u'Kari-Anne OLSEN', 830),\n",
       " (u'Nobuhiko YOSHIOKA', 838),\n",
       " (u'Dan FANG', 845),\n",
       " (u'Shizuko UGAKI', 846),\n",
       " (u'Deveny DECK', 854),\n",
       " (u'Anthony LEROY', 875),\n",
       " (u'Tianyi ZHANG', 879),\n",
       " (u'Leanna CARON', 901),\n",
       " (u'Jeff LUKASIK', 920),\n",
       " (u'Sasha MARTINEZ', 926),\n",
       " (u'Francoise DE RAPPARD', 933),\n",
       " (u'Julia ANDREEVA', 978),\n",
       " (u'So-Young AN', 981),\n",
       " (u'Alexei BELETSKI', 987),\n",
       " (u'Sharon ROGERS', 1086),\n",
       " (u'Feng HUANG', 1099),\n",
       " (u'Tanay OZKAN', 1232),\n",
       " (u'Lorrie PARKER', 1249),\n",
       " (u'Masako KUBOTA', 1261),\n",
       " (u'Elena FOMINA', 1263),\n",
       " (u'Chihee RHEE', 1276),\n",
       " (u'Maira ABASOVA', 1283),\n",
       " (u'Marta OLOZAGARRE', 1342),\n",
       " (u'Anna KANTOR', 1356),\n",
       " (u'Daniel DELFA', 1383),\n",
       " (u'Weiguang CHEN', 1390),\n",
       " (u'Agita ABELE', 1454),\n",
       " (u'Olga KOZHEMIAKINA', 1531),\n",
       " (u'Yuri GUSKOV', 1663),\n",
       " (u'Saodat NUMANOVA', 1736)]"
      ]
     },
     "execution_count": 121,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sorted(judge_not_med.iteritems(), key=lambda (k, v): v)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}