{ "cells": [ { "cell_type": "code", "execution_count": 4, "metadata": { "collapsed": false }, "outputs": [], "source": [ "from __future__ import print_function\n", "\n", "import numpy as np\n", "import pandas as pd\n", "from collections import OrderedDict #sorting participant df dict before pd.concat()\n", "import matplotlib.pylab as plt\n", "%matplotlib inline\n", "pd.options.display.mpl_style = 'default'\n", "\n", "import cPickle as pickle\n", "\n", "non_english_fluent = ['023', '031', '045', '050', '070', '106',]\n", "left_handed = ['042', '088',]\n", "pro_inst_skill = ['026', '037']\n", "\n", "excluded_all_tasks = non_english_fluent + left_handed + pro_inst_skill" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": false }, "outputs": [], "source": [ "def col_matches(df, regex):\n", " 'returns a list of columns in a df that match a regex string.'\n", " import re\n", " cols = list(enumerate(df.columns))\n", " matches = [c for (i, c) in cols \n", " if re.findall(regex, c)]\n", " return matches\n", "\n", "\n", "def compare_transformations(df, columns, functions, **kwargs):\n", " \n", " print('raw')\n", " df[columns].hist(**kwargs)\n", " plt.show()\n", " \n", " for name, func in functions.items():\n", " \n", " print(name)\n", " \n", " df[columns].apply(func).hist(**kwargs)\n", " plt.show()\n", " \n", " \n", "def quickcompare(r, df, size=(15,7)): \n", " inverse = lambda x: 1.0/x\n", " return compare_transformations(df, col_matches(df, r),\n", " {'inverse': inverse,\n", " 'log1p': np.log1p,\n", " 'sqrt': np.sqrt, \n", " 'log': np.log,\n", " },\n", " figsize=size)" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "collapsed": false }, "outputs": [], "source": [ "# using this for inline documentation so that it's clear\n", "# that the printing statement isn't part of the necessary\n", "# transformation code.\n", "def html_print(df):\n", " try:\n", " out = df.to_html()\n", " except AttributeError:\n", " out = pd.DataFrame(df).to_html()\n", " return HTML(out)\n", "\n", "\n", "def htmljoin(df_list, delimiter=''): \n", " return HTML(delimiter.join([x.to_html() for x in df_list]))\n", "\n", "\n", "def col_matches(df, regex): \n", " import re \n", " cols = list(enumerate(df.columns)) \n", " matches = [c for (i, c) in cols \n", " if re.findall(regex, c)] \n", " return matches\n", "\n", "\n", "def concat_matches(df, *args): \n", " assert all([len(r) for r in args])\n", " import re \n", " col_match_lists = [col_matches(df, regex) for regex in args] \n", " col_set = [df[matches] for matches in col_match_lists] \n", " \n", " if len(col_set) == 0:\n", " return None \n", " elif len(col_set) == 1:\n", " return col_set[0] \n", " else:\n", " return pd.concat(col_set, axis=1)\n", "\n", " \n", "def show_frames(frame_list, delimiter=''):\n", " \n", " from IPython.display import HTML\n", " \n", " if len(frame_list) == len(delimiter): \n", " html_out = \"\"\n", " item_template = '
{}
{}\n", " | 015 | \n", "016 | \n", "017 | \n", "018 | \n", "019 | \n", "020 | \n", "021 | \n", "022 | \n", "024 | \n", "025 | \n", "... | \n", "112 | \n", "113 | \n", "114 | \n", "115 | \n", "116 | \n", "117 | \n", "118 | \n", "119 | \n", "120 | \n", "121 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SCAL_session_day | \n", "20140228 | \n", "20140303 | \n", "20140303 | \n", "20140303 | \n", "20140303 | \n", "20140303 | \n", "20140304 | \n", "20140304 | \n", "20140304 | \n", "20140304 | \n", "... | \n", "20140508 | \n", "20140508 | \n", "20140508 | \n", "20140508 | \n", "20140509 | \n", "20140509 | \n", "20140509 | \n", "20140509 | \n", "20140509 | \n", "20140509 | \n", "
SCAL_calc_bfi_openness | \n", "2.8 | \n", "3.7 | \n", "3.7 | \n", "3.6 | \n", "3.3 | \n", "2.5 | \n", "2.7 | \n", "4.7 | \n", "4.2 | \n", "3.2 | \n", "... | \n", "4.3 | \n", "3.6 | \n", "3.6 | \n", "4.3 | \n", "4.4 | \n", "3 | \n", "3.9 | \n", "4.3 | \n", "4.9 | \n", "4.2 | \n", "
SCAL_notes_bfi | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | ... | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
SCAL_wasivocab_itemscore02_shovel | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "... | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
SCAL_wasivocab_itemscore17_decade | \n", "2 | \n", "2 | \n", "2 | \n", "2 | \n", "2 | \n", "2 | \n", "2 | \n", "2 | \n", "1 | \n", "2 | \n", "... | \n", "1 | \n", "2 | \n", "2 | \n", "2 | \n", "2 | \n", "1 | \n", "2 | \n", "2 | \n", "2 | \n", "2 | \n", "
SCAL_wasimatrix_itemscore01 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "... | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
SCAL_wasimatrix_itemscore16 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "... | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "
SCAL_qbasic_isfemale | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "... | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "
SCAL_qbasic_relationshipyears | \n", "2 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "1 | \n", "2 | \n", "0 | \n", "3 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
SCAL_qbasic_exerciseyn | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
SCAL_qmusic_gamehoursall | \n", "5 | \n", "0 | \n", "0 | \n", "0 | \n", "10 | \n", "5 | \n", "0 | \n", "0 | \n", "10 | \n", "28 | \n", "... | \n", "3 | \n", "2 | \n", "8 | \n", "0 | \n", "1 | \n", "8 | \n", "0 | \n", "10 | \n", "0 | \n", "2 | \n", "
SCAL_bfi_item02 | \n", "2 | \n", "3 | \n", "4 | \n", "2 | \n", "2 | \n", "1 | \n", "3 | \n", "4 | \n", "1 | \n", "3 | \n", "... | \n", "1 | \n", "3 | \n", "2 | \n", "3 | \n", "4 | \n", "2 | \n", "5 | \n", "3 | \n", "3 | \n", "3 | \n", "
SCAL_bfi_item17 | \n", "1 | \n", "5 | \n", "2 | \n", "4 | \n", "4 | \n", "5 | \n", "4 | \n", "3 | \n", "5 | \n", "3 | \n", "... | \n", "5 | \n", "5 | \n", "5 | \n", "4 | \n", "4 | \n", "4 | \n", "5 | \n", "5 | \n", "4 | \n", "3 | \n", "
SCAL_bfi_item32 | \n", "3 | \n", "5 | \n", "3 | \n", "5 | \n", "5 | \n", "4 | \n", "4 | \n", "4 | \n", "5 | \n", "2 | \n", "... | \n", "5 | \n", "5 | \n", "5 | \n", "2 | \n", "4 | \n", "5 | \n", "5 | \n", "5 | \n", "3 | \n", "4 | \n", "
SCAL_qmusic_dancehours_nonzero | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "... | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "
SCAL_orders_phase | \n", "2 | \n", "2 | \n", "2 | \n", "0 | \n", "2 | \n", "0 | \n", "2 | \n", "0 | \n", "2 | \n", "1 | \n", "... | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "2 | \n", "0 | \n", "0 | \n", "0 | \n", "2 | \n", "0 | \n", "
SCAL_order_lin8j | \n", "9 | \n", "12 | \n", "10 | \n", "14 | \n", "10 | \n", "11 | \n", "11 | \n", "11 | \n", "12 | \n", "13 | \n", "... | \n", "13 | \n", "13 | \n", "13 | \n", "13 | \n", "10 | \n", "12 | \n", "14 | \n", "12 | \n", "11 | \n", "12 | \n", "
SMSR_iso8t1_DPm | \n", "-3.198754 | \n", "-2.827224 | \n", "-13.31115 | \n", "-0.5532028 | \n", "-2.3272 | \n", "-3.092538 | \n", "-1.458121 | \n", "0.9686097 | \n", "-2.741571 | \n", "0.3546706 | \n", "... | \n", "-5.737524 | \n", "0.2056869 | \n", "-0.8263522 | \n", "-2.226755 | \n", "-1.372491 | \n", "-1.247007 | \n", "1.162443 | \n", "-0.06084488 | \n", "-9.056157 | \n", "-3.304496 | \n", "
SMSR_iso5t2_ints_mean | \n", "497.7625 | \n", "500.7283 | \n", "499.561 | \n", "500.0639 | \n", "500.2271 | \n", "500.4319 | \n", "499.6852 | \n", "499.952 | \n", "499.9137 | \n", "502.1116 | \n", "... | \n", "499.2338 | \n", "500.8816 | \n", "500.1932 | \n", "499.4348 | \n", "500.5344 | \n", "499.8039 | \n", "500.2396 | \n", "499.958 | \n", "500.086 | \n", "499.497 | \n", "
SMSR_lin5t_dev_mean | \n", "-56.08282 | \n", "-29.30826 | \n", "-54.49151 | \n", "-32.42488 | \n", "-17.69265 | \n", "-50.66523 | \n", "-50.73567 | \n", "-19.21868 | \n", "-15.79687 | \n", "-5.572805 | \n", "... | \n", "-90.36823 | \n", "-7.757573 | \n", "-73.42938 | \n", "-27.87748 | \n", "-21.62065 | \n", "-38.02459 | \n", "-12.0379 | \n", "-29.42216 | \n", "-41.91985 | \n", "-51.97161 | \n", "
SMSR_phase5t_DPm | \n", "-8.176227 | \n", "-2.727189 | \n", "-4.037511 | \n", "-3.222491 | \n", "-0.05654191 | \n", "-3.009335 | \n", "-4.691215 | \n", "-0.8777716 | \n", "-1.028469 | \n", "2.607912 | \n", "... | \n", "-7.511362 | \n", "2.75177 | \n", "-4.86865 | \n", "-0.9072752 | \n", "-1.493659 | \n", "-7.582498 | \n", "3.159855 | \n", "2.719712 | \n", "-6.585747 | \n", "-2.178178 | \n", "
SMSR_phase8t_ints_mean | \n", "854.141 | \n", "799.6398 | \n", "799.1124 | \n", "800.6056 | \n", "800.2841 | \n", "799.3914 | \n", "800.748 | \n", "799.8787 | \n", "799.9338 | \n", "805.9211 | \n", "... | \n", "800.5021 | \n", "801.6799 | \n", "800.7783 | \n", "800.6417 | \n", "800.7478 | \n", "801.5609 | \n", "800.0165 | \n", "801.3236 | \n", "799.9278 | \n", "808.1808 | \n", "
SMSR_iso8j_dev_mean | \n", "-88.09475 | \n", "-49.75272 | \n", "-80.51963 | \n", "-39.90446 | \n", "-77.28071 | \n", "-63.80611 | \n", "-71.43951 | \n", "13.19332 | \n", "-55.40579 | \n", "-17.78908 | \n", "... | \n", "-96.03697 | \n", "-17.07073 | \n", "-95.44311 | \n", "-47.41177 | \n", "-47.15015 | \n", "-37.05709 | \n", "0.4706038 | \n", "-41.18913 | \n", "-59.59362 | \n", "-85.35649 | \n", "
SMSR_lin8j_DPm | \n", "-2.533303 | \n", "-2.792467 | \n", "2.636454 | \n", "-0.01542999 | \n", "4.258314 | \n", "-5.878196 | \n", "2.467047 | \n", "0.5887284 | \n", "-2.485666 | \n", "0.5191878 | \n", "... | \n", "-9.6238 | \n", "3.214722 | \n", "-10.07283 | \n", "-1.967341 | \n", "-0.026768 | \n", "-9.894439 | \n", "0.8668867 | \n", "1.388157 | \n", "-2.93977 | \n", "-2.640397 | \n", "
SMSR_phase5j_ints_mean | \n", "506.8288 | \n", "499.9173 | \n", "502.1424 | \n", "499.1505 | \n", "500.969 | \n", "499.8378 | \n", "499.8912 | \n", "499.5976 | \n", "500.2107 | \n", "499.647 | \n", "... | \n", "500.6447 | \n", "499.4388 | \n", "500.236 | \n", "500.3357 | \n", "500.1026 | \n", "502.6973 | \n", "500.2303 | \n", "500.3979 | \n", "500.0319 | \n", "499.8732 | \n", "
SMSR_phase8j_mpk_dev_mean | \n", "-79.62756 | \n", "-36.40628 | \n", "-81.11475 | \n", "-2.749477 | \n", "-13.86751 | \n", "-91.65142 | \n", "-78.06689 | \n", "-7.354462 | \n", "-42.08086 | \n", "-4.122462 | \n", "... | \n", "-95.79649 | \n", "-33.15391 | \n", "-99.04375 | \n", "-64.691 | \n", "-65.41613 | \n", "-17.4071 | \n", "-28.808 | \n", "-28.49723 | \n", "-78.43963 | \n", "-94.47895 | \n", "
SMSR_phase8tp_mpk_DPm | \n", "-7.140225 | \n", "-3.235273 | \n", "-11.71376 | \n", "4.041789 | \n", "-0.5309412 | \n", "-2.577912 | \n", "-2.118466 | \n", "-0.9703458 | \n", "-2.596259 | \n", "1.407291 | \n", "... | \n", "-9.201369 | \n", "0.6187495 | \n", "-5.925623 | \n", "-2.968792 | \n", "-2.300928 | \n", "0.5214794 | \n", "0.9848873 | \n", "-0.6199092 | \n", "-4.715839 | \n", "-2.282429 | \n", "
SMSR_phase8t_mpr_ints_mean | \n", "860.2441 | \n", "798.0705 | \n", "794.8977 | \n", "792.7024 | \n", "802.1488 | \n", "803.5191 | \n", "800.7006 | \n", "792.727 | \n", "796.321 | \n", "811.0014 | \n", "... | \n", "800.3062 | \n", "802.3016 | \n", "799.1497 | \n", "797.8899 | \n", "798.3463 | \n", "802.1358 | \n", "800.9553 | \n", "801.6578 | \n", "795.8792 | \n", "805.1593 | \n", "
SMSR_phase5j_mpr_dev_mean | \n", "-50.26178 | \n", "-14.76985 | \n", "-8.999873 | \n", "-32.08286 | \n", "-28.65655 | \n", "-42.44111 | \n", "-27.44129 | \n", "-48.19151 | \n", "-10.88 | \n", "-24.22806 | \n", "... | \n", "-57.69003 | \n", "19.43637 | \n", "-51.56131 | \n", "-16.02781 | \n", "-24.93797 | \n", "-17.4806 | \n", "-29.83729 | \n", "-19.30714 | \n", "-46.16006 | \n", "-8.326523 | \n", "
SMSR_phase5t_mpr_DPm | \n", "-12.23243 | \n", "-3.513054 | \n", "-5.154859 | \n", "-2.50175 | \n", "0.2565294 | \n", "-5.129334 | \n", "-5.860247 | \n", "-1.669478 | \n", "-3.13251 | \n", "1.938041 | \n", "... | \n", "-5.24474 | \n", "1.745637 | \n", "-3.206258 | \n", "-2.324636 | \n", "-1.114924 | \n", "-8.193405 | \n", "8.807288 | \n", "2.862179 | \n", "-6.574524 | \n", "-5.232282 | \n", "
SMSR_phase8j_psk_ints_mean | \n", "784.9812 | \n", "799.4197 | \n", "805.6947 | \n", "802.441 | \n", "544.9198 | \n", "713.3414 | \n", "805.3557 | \n", "810.4893 | \n", "799.2237 | \n", "586.9541 | \n", "... | \n", "583.3398 | \n", "803.537 | \n", "671.0698 | \n", "805.7653 | \n", "784.7367 | \n", "678.0739 | \n", "791.1003 | \n", "797.979 | \n", "809.8003 | \n", "748.8567 | \n", "
SMSR_phase8tp_psk_dev_mean | \n", "-50.91143 | \n", "-39.09818 | \n", "-50.33416 | \n", "58.50181 | \n", "-6.125333 | \n", "-44.83719 | \n", "-0.1602748 | \n", "-5.275 | \n", "-20.88967 | \n", "-5.535 | \n", "... | \n", "-43.32022 | \n", "-15.734 | \n", "-55.33533 | \n", "-2.387 | \n", "-19.805 | \n", "-43.359 | \n", "30.537 | \n", "-9.380667 | \n", "-35.2106 | \n", "-22.77448 | \n", "
SMSR_phase5j_psk_DPm | \n", "-9.344384 | \n", "-1.153378 | \n", "-3.226146 | \n", "-1.629408 | \n", "-6.722491 | \n", "-10.10705 | \n", "-4.234703 | \n", "-6.802409 | \n", "-0.8209128 | \n", "-4.411202 | \n", "... | \n", "-11.40426 | \n", "1.375 | \n", "-10.93867 | \n", "0.682929 | \n", "-4.114753 | \n", "-4.736637 | \n", "-3.420041 | \n", "-1.031487 | \n", "-8.463048 | \n", "-2.845095 | \n", "
SMSR_phase5j_psr_ints_mean | \n", "424.6862 | \n", "496.433 | \n", "370.9547 | \n", "495.8177 | \n", "451.8123 | \n", "347.7508 | \n", "500.6287 | \n", "456.572 | \n", "459.4063 | \n", "462.9783 | \n", "... | \n", "404.6119 | \n", "382.4583 | \n", "421.5708 | \n", "461.0163 | \n", "492.9083 | \n", "505.074 | \n", "505.492 | \n", "507.864 | \n", "502.129 | \n", "501.7723 | \n", "
SMSR_phase5t_psr_dev_mean | \n", "-10.77273 | \n", "-23.94733 | \n", "-16.24867 | \n", "22.54767 | \n", "10.64733 | \n", "-8.098464 | \n", "-17.88367 | \n", "2.382921 | \n", "-5.860746 | \n", "7.635087 | \n", "... | \n", "-36.13908 | \n", "7.519333 | \n", "-17.80067 | \n", "-15.92233 | \n", "0.6186667 | \n", "-24.97372 | \n", "37.26721 | \n", "12.706 | \n", "-22.69108 | \n", "5.455534 | \n", "
SMSR_phase8t_nrm_DPm | \n", "-5.078323 | \n", "-3.202527 | \n", "-11.17975 | \n", "0.8494247 | \n", "-0.6688233 | \n", "-2.777164 | \n", "-2.903466 | \n", "-0.2268467 | \n", "-2.632887 | \n", "0.8131526 | \n", "... | \n", "-5.441476 | \n", "1.11521 | \n", "-7.397457 | \n", "-3.748128 | \n", "-1.774755 | \n", "-1.543361 | \n", "2.506108 | \n", "0.04823645 | \n", "-5.629138 | \n", "-3.905582 | \n", "
SMSR_phase5j_nrm_ints_mean | \n", "501.0488 | \n", "500.4317 | \n", "497.811 | \n", "497.976 | \n", "499.3087 | \n", "501.4147 | \n", "500.0498 | \n", "498.73 | \n", "499.6319 | \n", "499.6477 | \n", "... | \n", "501.6538 | \n", "500.1294 | \n", "499.322 | \n", "498.9119 | \n", "500.7787 | \n", "499.4885 | \n", "500.1757 | \n", "498.786 | \n", "498.9888 | \n", "499.419 | \n", "
SMSR_lint_610690_dev_mean | \n", "-43.56383 | \n", "-23.69982 | \n", "-34.07529 | \n", "-13.36782 | \n", "-6.537333 | \n", "-41.06354 | \n", "-27.31262 | \n", "-7.483244 | \n", "-16.6308 | \n", "9.663867 | \n", "... | \n", "-95.22391 | \n", "2.222044 | \n", "-41.00091 | \n", "-16.31708 | \n", "-13.41098 | \n", "-23.47564 | \n", "7.974311 | \n", "-17.76238 | \n", "-25.82191 | \n", "-17.1446 | \n", "
SMSR_lint_700800_DPm | \n", "-3.457716 | \n", "-2.836999 | \n", "-5.324347 | \n", "-2.588808 | \n", "-0.5348895 | \n", "-3.920463 | \n", "-2.249709 | \n", "-1.423945 | \n", "-3.538202 | \n", "2.053367 | \n", "... | \n", "-6.206299 | \n", "-0.2037628 | \n", "-2.421917 | \n", "-3.037278 | \n", "-3.049772 | \n", "-3.185119 | \n", "0.8063814 | \n", "-1.259571 | \n", "-4.405488 | \n", "-6.258277 | \n", "
SMSR_lint_500600_ints_mean | \n", "589.4669 | \n", "556.8507 | \n", "559.6688 | \n", "556.4262 | \n", "556.9577 | \n", "557.5166 | \n", "557.2973 | \n", "557.415 | \n", "555.6666 | \n", "563.1187 | \n", "... | \n", "565.8739 | \n", "563.6617 | \n", "557.8447 | \n", "558.8867 | \n", "559.3468 | \n", "562.4424 | \n", "560.3478 | \n", "558.3712 | \n", "556.7481 | \n", "559.5265 | \n", "
SMSR_linj_500600_dev_mean | \n", "-53.02957 | \n", "-24.77545 | \n", "-38.33945 | \n", "NaN | \n", "-42.62447 | \n", "-52.70923 | \n", "-26.50805 | \n", "-32.03333 | \n", "-20.17362 | \n", "-20.1902 | \n", "... | \n", "-96.46904 | \n", "-5.09497 | \n", "-85.95285 | \n", "-29.80226 | \n", "-12.3015 | \n", "-68.68218 | \n", "-14.45013 | \n", "-9.628119 | \n", "-23.82299 | \n", "-18.08722 | \n", "
I5P4_lagdev_local | \n", "2.918599 | \n", "2.692996 | \n", "2.764646 | \n", "2.080451 | \n", "1.397983 | \n", "3.357435 | \n", "3.454273 | \n", "2.634599 | \n", "2.834259 | \n", "2.568266 | \n", "... | \n", "2.629085 | \n", "1.89882 | \n", "4.873864 | \n", "2.944964 | \n", "2.272517 | \n", "2.884701 | \n", "3.168178 | \n", "1.649012 | \n", "2.400801 | \n", "2.143469 | \n", "
I8L2_ints_variance | \n", "2173.496 | \n", "887.7761 | \n", "1740.214 | \n", "1034.252 | \n", "676.3646 | \n", "2114.371 | \n", "1388.896 | \n", "511.8083 | \n", "903.3189 | \n", "2234.78 | \n", "... | \n", "1722.752 | \n", "830.9859 | \n", "1941.435 | \n", "492.8784 | \n", "431.2057 | \n", "1463.46 | \n", "1311.735 | \n", "550.8182 | \n", "666.7421 | \n", "1675.055 | \n", "
I5L2_lag2devsq_count | \n", "114 | \n", "105 | \n", "111 | \n", "115 | \n", "114 | \n", "106 | \n", "115 | \n", "116 | \n", "113 | \n", "104 | \n", "... | \n", "111 | \n", "113 | \n", "113 | \n", "109 | \n", "111 | \n", "106 | \n", "111 | \n", "106 | \n", "118 | \n", "113 | \n", "
44 rows × 97 columns
\n", "\n", " | mean | \n", "std | \n", "
---|---|---|
session_day | \n", "20140411.371134 | \n", "74.619032 | \n", "
session_isfemale | \n", "0.608247 | \n", "0.490678 | \n", "
sex_femalezero | \n", "0.391753 | \n", "0.490678 | \n", "
participant_age | \n", "20.979381 | \n", "5.055895 | \n", "
calc_wasivocab_totalrawscore | \n", "38.412371 | \n", "5.448151 | \n", "
calc_wasivocab_tscore | \n", "52.360825 | \n", "9.084311 | \n", "
calc_bfi_extraversion | \n", "3.518041 | \n", "0.877227 | \n", "
calc_bfi_agreeableness | \n", "3.914089 | \n", "0.626388 | \n", "
calc_bfi_conscientiousness | \n", "3.663230 | \n", "0.640588 | \n", "
calc_bfi_neuroticism | \n", "2.854566 | \n", "0.735095 | \n", "
calc_bfi_openness | \n", "3.791753 | \n", "0.604440 | \n", "
calc_qmusic_socialimportance | \n", "4.295533 | \n", "1.464769 | \n", "
order_500ms_first | \n", "0.556701 | \n", "0.499355 | \n", "
order_rhythmfirst | \n", "0.515464 | \n", "0.502357 | \n", "
wasivocab_itemscore01_fish | \n", "1.000000 | \n", "0.000000 | \n", "
wasivocab_itemscore02_shovel | \n", "1.000000 | \n", "0.000000 | \n", "
wasivocab_itemscore03_shell | \n", "1.000000 | \n", "0.000000 | \n", "
wasivocab_itemscore04_shirt | \n", "2.000000 | \n", "0.000000 | \n", "
wasivocab_itemscore05_car | \n", "1.958763 | \n", "0.285684 | \n", "
wasivocab_itemscore06_lamp | \n", "1.989691 | \n", "0.101535 | \n", "
wasivocab_itemscore07_bird | \n", "1.927835 | \n", "0.297469 | \n", "
wasivocab_itemscore08_tongue | \n", "1.783505 | \n", "0.413995 | \n", "
wasivocab_itemscore09_pet | \n", "1.742268 | \n", "0.462744 | \n", "
wasivocab_itemscore10_lunch | \n", "1.876289 | \n", "0.414772 | \n", "
wasivocab_itemscore11_bell | \n", "1.731959 | \n", "0.489801 | \n", "
wasivocab_itemscore12_calendar | \n", "1.793814 | \n", "0.431522 | \n", "
wasivocab_itemscore13_alligator | \n", "1.896907 | \n", "0.338025 | \n", "
wasivocab_itemscore14_dance | \n", "1.711340 | \n", "0.499140 | \n", "
wasivocab_itemscore15_summer | \n", "1.567010 | \n", "0.720347 | \n", "
wasivocab_itemscore16_reveal | \n", "1.876289 | \n", "0.388848 | \n", "
... | \n", "... | \n", "... | \n", "
qmusic_gamehoursall_nonzero | \n", "0.484536 | \n", "0.502357 | \n", "
qmusic_gamehoursdrumsticks_nonzero | \n", "0.195876 | \n", "0.398935 | \n", "
qmusic_behaviors_08_otherprs_ln1p | \n", "1.846726 | \n", "0.954699 | \n", "
qmusic_behaviors_09_danceprv_ln1p | \n", "0.938295 | \n", "0.989376 | \n", "
qmusic_dancelevel_ln1p | \n", "0.625159 | \n", "0.645580 | \n", "
qmusic_dancelevel_tophalf | \n", "0.402062 | \n", "0.492861 | \n", "
orders_500 | \n", "0.443299 | \n", "0.499355 | \n", "
orders_800 | \n", "0.556701 | \n", "0.499355 | \n", "
orders_iso | \n", "0.989691 | \n", "0.810026 | \n", "
orders_phase | \n", "0.969072 | \n", "0.883337 | \n", "
orders_linear | \n", "1.041237 | \n", "0.762637 | \n", "
order_iso5t1 | \n", "1.443299 | \n", "0.499355 | \n", "
order_iso8t1 | \n", "1.556701 | \n", "0.499355 | \n", "
order_iso5t2 | \n", "5.422680 | \n", "1.676026 | \n", "
order_iso8t2 | \n", "5.536082 | \n", "1.714290 | \n", "
order_psh5t | \n", "5.381443 | \n", "1.862141 | \n", "
order_psh8t | \n", "5.494845 | \n", "1.809257 | \n", "
order_lin5t | \n", "5.525773 | \n", "1.594867 | \n", "
order_lin8t | \n", "5.639175 | \n", "1.614940 | \n", "
order_iso5j | \n", "11.422680 | \n", "1.676026 | \n", "
order_iso8j | \n", "11.536082 | \n", "1.714290 | \n", "
order_psh5j | \n", "11.381443 | \n", "1.862141 | \n", "
order_psh8j | \n", "11.494845 | \n", "1.809257 | \n", "
order_lin5j | \n", "11.525773 | \n", "1.594867 | \n", "
order_lin8j | \n", "11.639175 | \n", "1.614940 | \n", "
order_isip5 | \n", "15.443299 | \n", "0.499355 | \n", "
order_isip8 | \n", "15.556701 | \n", "0.499355 | \n", "
orderc_iso_before_lin | \n", "0.484536 | \n", "0.502357 | \n", "
orderc_iso_before_phase | \n", "0.525773 | \n", "0.501929 | \n", "
orderc_phase_before_lin | \n", "0.556701 | \n", "0.499355 | \n", "
162 rows × 2 columns
\n", "\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
qmusic_instrumenthours | \n", "97 | \n", "7.927835 | \n", "27.719107 | \n", "0 | \n", "0 | \n", "0 | \n", "4 | \n", "250 | \n", "
qmusic_gamehoursall | \n", "97 | \n", "5.569072 | \n", "25.235418 | \n", "0 | \n", "0 | \n", "0 | \n", "3 | \n", "240 | \n", "
qmusic_gamehoursdrumsticks | \n", "97 | \n", "0.432990 | \n", "1.396385 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "10 | \n", "
qmusic_singinghours_nonzero | \n", "97 | \n", "0.206186 | \n", "0.406667 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "
qmusic_dancehours_nonzero | \n", "97 | \n", "0.432990 | \n", "0.498063 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "
qmusic_instrumenthours_nonzero | \n", "97 | \n", "0.422680 | \n", "0.496552 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "
qmusic_drumhours_nonzero | \n", "97 | \n", "0.061856 | \n", "0.242145 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "
qmusic_gamehoursall_nonzero | \n", "97 | \n", "0.484536 | \n", "0.502357 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "
qmusic_gamehoursdrumsticks_nonzero | \n", "97 | \n", "0.195876 | \n", "0.398935 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "
\n", " | isip500local | \n", "isip800local | \n", "
---|---|---|
019 | \n", "1.458044 | \n", "2.409286 | \n", "
075 | \n", "1.512254 | \n", "2.097847 | \n", "
040 | \n", "1.520219 | \n", "2.595587 | \n", "
032 | \n", "1.713234 | \n", "1.580831 | \n", "
119 | \n", "1.736570 | \n", "2.134176 | \n", "
030 | \n", "1.882929 | \n", "2.266210 | \n", "
054 | \n", "1.924084 | \n", "2.853508 | \n", "
110 | \n", "1.988980 | \n", "2.310470 | \n", "
113 | \n", "2.020436 | \n", "1.798715 | \n", "
057 | \n", "2.115470 | \n", "2.445437 | \n", "
048 | \n", "2.126246 | \n", "1.826718 | \n", "
018 | \n", "2.180362 | \n", "3.365396 | \n", "
081 | \n", "2.205461 | \n", "2.434559 | \n", "
078 | \n", "2.206225 | \n", "2.207061 | \n", "
013 | \n", "2.230631 | \n", "1.679067 | \n", "
121 | \n", "2.288308 | \n", "3.344639 | \n", "
038 | \n", "2.323221 | \n", "3.113442 | \n", "
041 | \n", "2.336903 | \n", "2.582472 | \n", "
066 | \n", "2.344056 | \n", "2.374577 | \n", "
059 | \n", "2.374586 | \n", "3.266615 | \n", "
034 | \n", "2.412615 | \n", "2.204436 | \n", "
116 | \n", "2.422717 | \n", "2.186702 | \n", "
120 | \n", "2.472802 | \n", "2.712842 | \n", "
098 | \n", "2.520819 | \n", "2.484190 | \n", "
027 | \n", "2.545177 | \n", "2.032936 | \n", "
112 | \n", "2.548912 | \n", "3.962077 | \n", "
107 | \n", "2.553538 | \n", "3.174529 | \n", "
011 | \n", "2.561063 | \n", "2.819736 | \n", "
091 | \n", "2.575460 | \n", "2.433766 | \n", "
061 | \n", "2.584169 | \n", "2.327133 | \n", "
... | \n", "... | \n", "... | \n", "
108 | \n", "3.266065 | \n", "2.781837 | \n", "
102 | \n", "3.287046 | \n", "1.881973 | \n", "
092 | \n", "3.349463 | \n", "2.871268 | \n", "
026 | \n", "3.356011 | \n", "1.784634 | \n", "
118 | \n", "3.365157 | \n", "3.464296 | \n", "
085 | \n", "3.379907 | \n", "3.044101 | \n", "
020 | \n", "3.411905 | \n", "4.007090 | \n", "
097 | \n", "3.421431 | \n", "2.735617 | \n", "
062 | \n", "3.432983 | \n", "4.354812 | \n", "
086 | \n", "3.493859 | \n", "3.497730 | \n", "
037 | \n", "3.518156 | \n", "2.877774 | \n", "
055 | \n", "3.520752 | \n", "2.811153 | \n", "
090 | \n", "3.530500 | \n", "2.866428 | \n", "
044 | \n", "3.543828 | \n", "3.340074 | \n", "
046 | \n", "3.574300 | \n", "3.018440 | \n", "
021 | \n", "3.592341 | \n", "2.720564 | \n", "
087 | \n", "3.655366 | \n", "2.490506 | \n", "
012 | \n", "3.720961 | \n", "2.964895 | \n", "
079 | \n", "3.901361 | \n", "5.243465 | \n", "
094 | \n", "4.091857 | \n", "2.603532 | \n", "
071 | \n", "4.112043 | \n", "4.450198 | \n", "
072 | \n", "4.185346 | \n", "3.492831 | \n", "
067 | \n", "4.214285 | \n", "3.106370 | \n", "
073 | \n", "4.296935 | \n", "4.520292 | \n", "
065 | \n", "4.406004 | \n", "4.210819 | \n", "
036 | \n", "4.641768 | \n", "5.366874 | \n", "
114 | \n", "4.898744 | \n", "4.989202 | \n", "
069 | \n", "4.905948 | \n", "4.665402 | \n", "
077 | \n", "4.959826 | \n", "4.180945 | \n", "
049 | \n", "5.224991 | \n", "7.989958 | \n", "
102 rows × 2 columns
\n", "\n", " | session_day | \n", "session_time | \n", "session_isfemale | \n", "exclusion_jitterlinearmissing | \n", "exclusion_rhythmadminerror | \n", "sex_femalezero | \n", "participant_age | \n", "calc_wasivocab_totalrawscore | \n", "calc_wasimatrix_totalscore | \n", "calc_agecolumn | \n", "... | \n", "ints_count | \n", "ints_mean | \n", "ints_variance | \n", "ints_stdev | \n", "lag2devsq_sum | \n", "lag2devsq_count | \n", "lag2devsq_mean | \n", "lag2devsq_local_sq_abs | \n", "lag2devsq_local | \n", "lag2devsq_drift | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
011 | \n", "20140226 | \n", "2:40pm | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "19 | \n", "40 | \n", "24 | \n", "2 | \n", "... | \n", "128 | \n", "776.994000 | \n", "883.209799 | \n", "29.718846 | \n", "208781.623552 | \n", "126 | \n", "1656.997012 | \n", "828.498506 | \n", "3.704488 | \n", "0.951965 | \n", "
012 | \n", "20140226 | \n", "4:00pm | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "57 | \n", "33 | \n", "18 | \n", "8 | \n", "... | \n", "120 | \n", "831.791733 | \n", "986.297632 | \n", "31.405376 | \n", "176171.441216 | \n", "118 | \n", "1492.978315 | \n", "746.489158 | \n", "3.284711 | \n", "1.861734 | \n", "
013 | \n", "20140227 | \n", "8:00am | \n", "0 | \n", "1 | \n", "1 | \n", "1 | \n", "21 | \n", "42 | \n", "20 | \n", "3 | \n", "... | \n", "114 | \n", "834.087930 | \n", "338.276056 | \n", "18.392283 | \n", "60632.582384 | \n", "106 | \n", "572.005494 | \n", "286.002747 | \n", "2.027558 | \n", "0.866818 | \n", "
015 | \n", "20140228 | \n", "1:00pm | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "21 | \n", "37 | \n", "15 | \n", "3 | \n", "... | \n", "137 | \n", "702.533956 | \n", "2430.437702 | \n", "49.299470 | \n", "302872.981344 | \n", "131 | \n", "2312.007491 | \n", "1156.003746 | \n", "4.839632 | \n", "5.081493 | \n", "
016 | \n", "20140303 | \n", "9:10am | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "19 | \n", "48 | \n", "22 | \n", "2 | \n", "... | \n", "112 | \n", "811.894107 | \n", "887.776090 | \n", "29.795572 | \n", "169532.034352 | \n", "108 | \n", "1569.741059 | \n", "784.870529 | \n", "3.450640 | \n", "1.249453 | \n", "
017 | \n", "20140303 | \n", "10:30am | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "23 | \n", "41 | \n", "23 | \n", "3 | \n", "... | \n", "109 | \n", "844.185541 | \n", "1740.213950 | \n", "41.715872 | \n", "222698.851904 | \n", "107 | \n", "2081.297681 | \n", "1040.648841 | \n", "3.821327 | \n", "3.133114 | \n", "
018 | \n", "20140303 | \n", "1:00pm | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "19 | \n", "37 | \n", "22 | \n", "2 | \n", "... | \n", "114 | \n", "807.715930 | \n", "1034.252108 | \n", "32.159790 | \n", "260203.336288 | \n", "112 | \n", "2323.244074 | \n", "1161.622037 | \n", "4.219624 | \n", "NaN | \n", "
019 | \n", "20140303 | \n", "2:20pm | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "19 | \n", "40 | \n", "23 | \n", "2 | \n", "... | \n", "116 | \n", "794.750414 | \n", "676.364586 | \n", "26.007010 | \n", "129798.102080 | \n", "114 | \n", "1138.579843 | \n", "569.289921 | \n", "3.002175 | \n", "1.302005 | \n", "
020 | \n", "20140303 | \n", "3:37pm | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "18 | \n", "41 | \n", "20 | \n", "2 | \n", "... | \n", "111 | \n", "819.063459 | \n", "2114.370996 | \n", "45.982290 | \n", "308034.627472 | \n", "107 | \n", "2878.828294 | \n", "1439.414147 | \n", "4.632072 | \n", "3.171907 | \n", "
021 | \n", "20140304 | \n", "9:40am | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "19 | \n", "39 | \n", "17 | \n", "2 | \n", "... | \n", "121 | \n", "761.102909 | \n", "1388.895981 | \n", "37.267895 | \n", "140437.019936 | \n", "119 | \n", "1180.143025 | \n", "590.071512 | \n", "3.191604 | \n", "3.713490 | \n", "
022 | \n", "20140304 | \n", "12:30nn | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "23 | \n", "42 | \n", "19 | \n", "3 | \n", "... | \n", "109 | \n", "823.375670 | \n", "511.808289 | \n", "22.623180 | \n", "66120.177264 | \n", "105 | \n", "629.715974 | \n", "314.857987 | \n", "2.155060 | \n", "1.704434 | \n", "
024 | \n", "20140304 | \n", "3:20pm | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "18 | \n", "33 | \n", "23 | \n", "2 | \n", "... | \n", "124 | \n", "741.422387 | \n", "903.318885 | \n", "30.055264 | \n", "147698.985472 | \n", "122 | \n", "1210.647422 | \n", "605.323711 | \n", "3.318396 | \n", "2.328300 | \n", "
025 | \n", "20140304 | \n", "4:50pm | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "21 | \n", "36 | \n", "20 | \n", "3 | \n", "... | \n", "105 | \n", "873.708838 | \n", "2234.780431 | \n", "47.273464 | \n", "125167.630608 | \n", "103 | \n", "1215.219715 | \n", "607.609857 | \n", "2.821277 | \n", "4.616893 | \n", "
026 | \n", "20140305 | \n", "8:00am | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "20 | \n", "35 | \n", "23 | \n", "3 | \n", "... | \n", "117 | \n", "787.017641 | \n", "326.880811 | \n", "18.079845 | \n", "59249.180048 | \n", "115 | \n", "515.210261 | \n", "257.605131 | \n", "2.039355 | \n", "1.057562 | \n", "
027 | \n", "20140305 | \n", "9:10am | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "19 | \n", "39 | \n", "22 | \n", "2 | \n", "... | \n", "112 | \n", "822.994571 | \n", "522.639055 | \n", "22.861300 | \n", "97856.858672 | \n", "110 | \n", "889.607806 | \n", "444.803903 | \n", "2.562638 | \n", "1.071990 | \n", "
028 | \n", "20140305 | \n", "3:40pm | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "18 | \n", "44 | \n", "23 | \n", "2 | \n", "... | \n", "122 | \n", "753.348820 | \n", "667.002049 | \n", "25.826383 | \n", "133482.370400 | \n", "120 | \n", "1112.353087 | \n", "556.176543 | \n", "3.130475 | \n", "1.397410 | \n", "
029 | \n", "20140306 | \n", "8:20am | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "20 | \n", "39 | \n", "24 | \n", "3 | \n", "... | \n", "115 | \n", "804.279235 | \n", "1867.368872 | \n", "43.213064 | \n", "394605.813712 | \n", "113 | \n", "3492.086847 | \n", "1746.043424 | \n", "5.195420 | \n", "1.369522 | \n", "
030 | \n", "20140306 | \n", "12:40nn | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "43 | \n", "46 | \n", "23 | \n", "6 | \n", "... | \n", "108 | \n", "853.777815 | \n", "806.482565 | \n", "28.398637 | \n", "120379.428128 | \n", "106 | \n", "1135.654982 | \n", "567.827491 | \n", "2.791023 | \n", "1.809425 | \n", "
032 | \n", "20140306 | \n", "3:30pm | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "18 | \n", "41 | \n", "23 | \n", "2 | \n", "... | \n", "117 | \n", "792.519453 | \n", "280.617415 | \n", "16.751639 | \n", "40211.747744 | \n", "115 | \n", "349.667372 | \n", "174.833686 | \n", "1.668409 | \n", "1.297775 | \n", "
033 | \n", "20140307 | \n", "1:00pm | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "19 | \n", "43 | \n", "24 | \n", "2 | \n", "... | \n", "116 | \n", "795.213966 | \n", "677.040070 | \n", "26.019994 | \n", "141114.364880 | \n", "114 | \n", "1237.845306 | \n", "618.922653 | \n", "3.128486 | \n", "0.958670 | \n", "
034 | \n", "20140307 | \n", "2:20pm | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "19 | \n", "39 | \n", "21 | \n", "2 | \n", "... | \n", "114 | \n", "812.306596 | \n", "513.101841 | \n", "22.651751 | \n", "98116.291088 | \n", "112 | \n", "876.038313 | \n", "438.019157 | \n", "2.576479 | \n", "1.066719 | \n", "
035 | \n", "20140310 | \n", "10:30am | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "20 | \n", "42 | \n", "22 | \n", "3 | \n", "... | \n", "116 | \n", "778.160310 | \n", "1199.769973 | \n", "34.637696 | \n", "236568.727616 | \n", "112 | \n", "2112.220782 | \n", "1056.110391 | \n", "4.176241 | \n", "1.540275 | \n", "
036 | \n", "20140310 | \n", "2:20pm | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "19 | \n", "32 | \n", "19 | \n", "2 | \n", "... | \n", "129 | \n", "703.468155 | \n", "2774.862029 | \n", "52.676959 | \n", "571834.011472 | \n", "125 | \n", "4574.672092 | \n", "2287.336046 | \n", "6.798617 | \n", "3.138733 | \n", "
037 | \n", "20140311 | \n", "9:40am | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "18 | \n", "41 | \n", "28 | \n", "2 | \n", "... | \n", "119 | \n", "775.521647 | \n", "1463.407121 | \n", "38.254505 | \n", "139151.014144 | \n", "117 | \n", "1189.324907 | \n", "594.662454 | \n", "3.144426 | \n", "3.800600 | \n", "
038 | \n", "20140311 | \n", "3:10pm | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "18 | \n", "41 | \n", "22 | \n", "2 | \n", "... | \n", "112 | \n", "807.224500 | \n", "981.703129 | \n", "31.332142 | \n", "141240.152480 | \n", "108 | \n", "1307.779190 | \n", "653.889595 | \n", "3.167801 | \n", "2.242947 | \n", "
039 | \n", "20140312 | \n", "12:00nn | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "21 | \n", "27 | \n", "25 | \n", "3 | \n", "... | \n", "120 | \n", "763.926033 | \n", "950.985383 | \n", "30.838051 | \n", "212786.534608 | \n", "118 | \n", "1803.275717 | \n", "901.637859 | \n", "3.930653 | \n", "0.919563 | \n", "
040 | \n", "20140325 | \n", "5:10pm | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "21 | \n", "39 | \n", "26 | \n", "3 | \n", "... | \n", "118 | \n", "765.104644 | \n", "914.416946 | \n", "30.239328 | \n", "109097.011056 | \n", "114 | \n", "956.991325 | \n", "478.495663 | \n", "2.859026 | \n", "2.728872 | \n", "
041 | \n", "20140326 | \n", "1:00pm | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "23 | \n", "40 | \n", "23 | \n", "3 | \n", "... | \n", "119 | \n", "770.669849 | \n", "579.816556 | \n", "24.079380 | \n", "102163.465424 | \n", "117 | \n", "873.192012 | \n", "436.596006 | \n", "2.711262 | \n", "1.552867 | \n", "
043 | \n", "20140328 | \n", "11:00am | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "19 | \n", "29 | \n", "15 | \n", "2 | \n", "... | \n", "132 | \n", "701.174636 | \n", "1999.840545 | \n", "44.719577 | \n", "188007.440288 | \n", "130 | \n", "1446.211079 | \n", "723.105540 | \n", "3.835082 | \n", "5.095939 | \n", "
044 | \n", "20140331 | \n", "10:30am | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "18 | \n", "40 | \n", "22 | \n", "2 | \n", "... | \n", "111 | \n", "827.880505 | \n", "1191.182247 | \n", "34.513508 | \n", "164717.853136 | \n", "109 | \n", "1511.172965 | \n", "755.586482 | \n", "3.320278 | \n", "2.521008 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
091 | \n", "20140430 | \n", "10:30am | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "23 | \n", "40 | \n", "23 | \n", "3 | \n", "... | \n", "131 | \n", "704.692244 | \n", "760.246930 | \n", "27.572576 | \n", "120765.580960 | \n", "129 | \n", "936.167294 | \n", "468.083647 | \n", "3.070169 | \n", "2.425567 | \n", "
092 | \n", "20140430 | \n", "12:00nn | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "20 | \n", "36 | \n", "21 | \n", "3 | \n", "... | \n", "120 | \n", "764.673100 | \n", "1090.989115 | \n", "33.030124 | \n", "146268.311696 | \n", "118 | \n", "1239.561964 | \n", "619.780982 | \n", "3.255692 | \n", "2.838772 | \n", "
093 | \n", "20140430 | \n", "1:30pm | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "19 | \n", "34 | \n", "20 | \n", "2 | \n", "... | \n", "117 | \n", "779.269573 | \n", "886.952485 | \n", "29.781748 | \n", "135531.019856 | \n", "113 | \n", "1199.389556 | \n", "599.694778 | \n", "3.142515 | \n", "2.174944 | \n", "
094 | \n", "20140501 | \n", "7:35am | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "22 | \n", "35 | \n", "20 | \n", "3 | \n", "... | \n", "81 | \n", "945.213432 | \n", "1126.350208 | \n", "33.561141 | \n", "103098.920160 | \n", "60 | \n", "1718.315336 | \n", "859.157668 | \n", "3.101034 | \n", "1.729348 | \n", "
095 | \n", "20140501 | \n", "9:00am | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "19 | \n", "43 | \n", "21 | \n", "2 | \n", "... | \n", "115 | \n", "795.117287 | \n", "774.746157 | \n", "27.834262 | \n", "103241.385440 | \n", "113 | \n", "913.640579 | \n", "456.820290 | \n", "2.688076 | \n", "2.242496 | \n", "
096 | \n", "20140501 | \n", "10:35am | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "22 | \n", "40 | \n", "26 | \n", "3 | \n", "... | \n", "105 | \n", "874.146171 | \n", "1060.140879 | \n", "32.559805 | \n", "154800.927216 | \n", "103 | \n", "1502.921623 | \n", "751.460812 | \n", "3.135950 | \n", "2.009880 | \n", "
097 | \n", "20140502 | \n", "9:00am | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "19 | \n", "39 | \n", "21 | \n", "2 | \n", "... | \n", "115 | \n", "800.441391 | \n", "824.802565 | \n", "28.719376 | \n", "168980.032944 | \n", "113 | \n", "1495.398522 | \n", "747.699261 | \n", "3.416126 | \n", "1.097001 | \n", "
098 | \n", "20140502 | \n", "10:25am | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "21 | \n", "38 | \n", "26 | \n", "3 | \n", "... | \n", "118 | \n", "777.291593 | \n", "567.512488 | \n", "23.822521 | \n", "130337.320464 | \n", "116 | \n", "1123.597590 | \n", "561.798795 | \n", "3.049344 | \n", "0.307521 | \n", "
099 | \n", "20140502 | \n", "1:00pm | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "19 | \n", "36 | \n", "18 | \n", "2 | \n", "... | \n", "124 | \n", "741.676419 | \n", "2017.520730 | \n", "44.916820 | \n", "287594.460320 | \n", "122 | \n", "2357.331642 | \n", "1178.665821 | \n", "4.628933 | \n", "3.905071 | \n", "
100 | \n", "20140502 | \n", "2:50pm | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "18 | \n", "39 | \n", "25 | \n", "2 | \n", "... | \n", "118 | \n", "775.535661 | \n", "1054.056078 | \n", "32.466230 | \n", "173694.763488 | \n", "116 | \n", "1497.368651 | \n", "748.684325 | \n", "3.528155 | \n", "2.253267 | \n", "
101 | \n", "20140502 | \n", "5:35pm | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "19 | \n", "40 | \n", "19 | \n", "2 | \n", "... | \n", "126 | \n", "726.387333 | \n", "1340.031487 | \n", "36.606441 | \n", "134605.189536 | \n", "124 | \n", "1085.525722 | \n", "542.762861 | \n", "3.207279 | \n", "3.887175 | \n", "
102 | \n", "20140503 | \n", "9:30am | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "18 | \n", "41 | \n", "21 | \n", "2 | \n", "... | \n", "114 | \n", "804.779053 | \n", "531.380717 | \n", "23.051697 | \n", "72300.804720 | \n", "112 | \n", "645.542899 | \n", "322.771450 | \n", "2.232394 | \n", "1.794693 | \n", "
103 | \n", "20140503 | \n", "10:50am | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "21 | \n", "41 | \n", "20 | \n", "3 | \n", "... | \n", "116 | \n", "790.648517 | \n", "869.395279 | \n", "29.485510 | \n", "160461.065344 | \n", "114 | \n", "1407.553205 | \n", "703.776602 | \n", "3.355320 | \n", "1.627688 | \n", "
104 | \n", "20140505 | \n", "1:30pm | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "21 | \n", "29 | \n", "21 | \n", "3 | \n", "... | \n", "113 | \n", "799.264850 | \n", "774.593421 | \n", "27.831518 | \n", "117943.966224 | \n", "109 | \n", "1082.054736 | \n", "541.027368 | \n", "2.910174 | \n", "1.912116 | \n", "
105 | \n", "20140505 | \n", "5:50pm | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "19 | \n", "37 | \n", "22 | \n", "2 | \n", "... | \n", "123 | \n", "744.315415 | \n", "1875.171194 | \n", "43.303247 | \n", "273473.501568 | \n", "121 | \n", "2260.111583 | \n", "1130.055792 | \n", "4.516406 | \n", "3.667370 | \n", "
107 | \n", "20140506 | \n", "12:00nn | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "20 | \n", "43 | \n", "21 | \n", "3 | \n", "... | \n", "113 | \n", "810.179221 | \n", "935.669667 | \n", "30.588718 | \n", "192996.431600 | \n", "111 | \n", "1738.706591 | \n", "869.353295 | \n", "3.639293 | \n", "1.005146 | \n", "
108 | \n", "20140507 | \n", "12:00nn | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "19 | \n", "37 | \n", "19 | \n", "2 | \n", "... | \n", "118 | \n", "779.401288 | \n", "886.402550 | \n", "29.772513 | \n", "160667.758368 | \n", "116 | \n", "1385.066882 | \n", "692.533441 | \n", "3.376442 | \n", "1.786460 | \n", "
109 | \n", "20140507 | \n", "1:30pm | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "21 | \n", "34 | \n", "22 | \n", "3 | \n", "... | \n", "122 | \n", "748.960230 | \n", "1078.115928 | \n", "32.834676 | \n", "232252.546624 | \n", "120 | \n", "1935.437889 | \n", "967.718944 | \n", "4.153516 | \n", "1.402878 | \n", "
110 | \n", "20140507 | \n", "3:00pm | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "19 | \n", "47 | \n", "21 | \n", "2 | \n", "... | \n", "114 | \n", "807.640421 | \n", "530.966500 | \n", "23.042710 | \n", "113958.267760 | \n", "112 | \n", "1017.484534 | \n", "508.742267 | \n", "2.792742 | \n", "0.583708 | \n", "
111 | \n", "20140507 | \n", "5:00pm | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "20 | \n", "41 | \n", "26 | \n", "3 | \n", "... | \n", "103 | \n", "896.778214 | \n", "1346.015472 | \n", "36.688084 | \n", "180413.440000 | \n", "101 | \n", "1786.271683 | \n", "893.135842 | \n", "3.332527 | \n", "2.373047 | \n", "
112 | \n", "20140508 | \n", "12:20nn | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "20 | \n", "30 | \n", "19 | \n", "3 | \n", "... | \n", "125 | \n", "730.919936 | \n", "2441.423644 | \n", "49.410764 | \n", "332315.308624 | \n", "123 | \n", "2701.750477 | \n", "1350.875238 | \n", "5.028493 | \n", "4.518067 | \n", "
113 | \n", "20140508 | \n", "2:00pm | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "19 | \n", "33 | \n", "20 | \n", "2 | \n", "... | \n", "114 | \n", "807.840737 | \n", "830.985874 | \n", "28.826826 | \n", "59596.038976 | \n", "112 | \n", "532.107491 | \n", "266.053745 | \n", "2.019105 | \n", "2.942201 | \n", "
114 | \n", "20140508 | \n", "5:00pm | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "19 | \n", "44 | \n", "25 | \n", "2 | \n", "... | \n", "117 | \n", "760.652444 | \n", "1941.435481 | \n", "44.061724 | \n", "309333.439024 | \n", "111 | \n", "2786.787739 | \n", "1393.393869 | \n", "4.907391 | \n", "3.077659 | \n", "
115 | \n", "20140508 | \n", "6:30pm | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "19 | \n", "47 | \n", "22 | \n", "2 | \n", "... | \n", "119 | \n", "777.876975 | \n", "492.878399 | \n", "22.200865 | \n", "108679.512016 | \n", "117 | \n", "928.884718 | \n", "464.442359 | \n", "2.770480 | \n", "0.685526 | \n", "
116 | \n", "20140509 | \n", "7:30am | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "20 | \n", "39 | \n", "27 | \n", "3 | \n", "... | \n", "113 | \n", "794.877381 | \n", "431.205669 | \n", "20.765492 | \n", "115885.327472 | \n", "109 | \n", "1063.168142 | \n", "531.584071 | \n", "2.900587 | \n", "NaN | \n", "
117 | \n", "20140509 | \n", "10:30am | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "19 | \n", "34 | \n", "20 | \n", "2 | \n", "... | \n", "78 | \n", "931.637744 | \n", "1463.459871 | \n", "38.255194 | \n", "127423.589056 | \n", "56 | \n", "2275.421233 | \n", "1137.710617 | \n", "3.620502 | \n", "1.937290 | \n", "
118 | \n", "20140509 | \n", "12:00nn | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "20 | \n", "42 | \n", "22 | \n", "3 | \n", "... | \n", "109 | \n", "831.885431 | \n", "1311.735249 | \n", "36.217886 | \n", "243292.114656 | \n", "105 | \n", "2317.067759 | \n", "1158.533879 | \n", "4.091578 | \n", "1.487880 | \n", "
119 | \n", "20140509 | \n", "3:00pm | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "19 | \n", "38 | \n", "23 | \n", "2 | \n", "... | \n", "111 | \n", "832.191856 | \n", "550.818229 | \n", "23.469517 | \n", "99282.943600 | \n", "109 | \n", "910.852694 | \n", "455.426347 | \n", "2.564399 | \n", "1.173633 | \n", "
120 | \n", "20140509 | \n", "4:30pm | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "24 | \n", "33 | \n", "24 | \n", "3 | \n", "... | \n", "121 | \n", "758.141686 | \n", "666.742129 | \n", "25.821350 | \n", "148368.920576 | \n", "119 | \n", "1246.797652 | \n", "623.398826 | \n", "3.293310 | \n", "0.868382 | \n", "
121 | \n", "20140509 | \n", "7:30pm | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "18 | \n", "36 | \n", "20 | \n", "2 | \n", "... | \n", "105 | \n", "870.896114 | \n", "1675.054895 | \n", "40.927435 | \n", "267651.276272 | \n", "103 | \n", "2598.556080 | \n", "1299.278040 | \n", "4.138898 | \n", "2.225864 | \n", "
102 rows × 235 columns
\n", "