{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"See http://connectivity.brain-map.org/projection/experiment/168095756"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import json\n",
"from allensdk.api.api import Api\n",
"from allensdk.api.queries.rma_api import RmaApi\n",
"from allensdk.api.queries.mouse_connectivity_api import MouseConnectivityApi\n",
"import pandas as pd\n",
"import itertools as it\n",
"\n",
"rma = RmaApi()\n",
"mca = MouseConnectivityApi()\n",
"\n",
"def read_data(parsed_json):\n",
" return parsed_json['msg']\n",
"\n",
"def pretty(result):\n",
" print(json.dumps(result, indent=2))\n",
" \n",
"def tabular_dataframe(parsed_tabular_json):\n",
" df = pd.DataFrame.from_records(parsed_tabular_json,\n",
" columns=parsed_tabular_json[0].keys())\n",
" return df"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"section_data_set_id = 168095756"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Manual Injection Summary\n",
"Experiment: 168095756\n",
"Primary Structure: Agranular insular area, posterior part\n",
"Coords. (AP, ML, DV, L):\n",
"\tBregma(-0.340000, 3.750000, 3.250000, 0.000000)\n",
"\tBregma(-0.340000, 4.000000, 3.000000, 0.000000)\n",
"\tBregma(-0.340000, 3.750000, 3.250000, 0.000000)\n",
"\tBregma(-0.340000, 4.000000, 3.000000, 0.000000)\n",
"Transgenic Line: Syt6-Cre_KI148\n",
"Sparse, scattered expression in brain areas including the medulla, pons, and midbrain. Enriched in specific areas within thalamus, layer 6a cortex, and olfactory areas.\n"
]
}
],
"source": [
"# rma version from detail page\n",
"results = mca.get_manual_injection_summary(section_data_set_id)\n",
"\n",
"print('Manual Injection Summary')\n",
"print('Experiment: %d' % (results[0]['id']))\n",
"injections = results[0]['specimen']['injections']\n",
"print('Primary Structure: %s' % (injections[0]['structure']['name']))\n",
"\n",
"print('Coords. (AP, ML, DV, L):')\n",
"for injection in injections:\n",
" print ('\\t%s(%f, %f, %f, %f)' % (injection['registration_point'],\n",
" injection['coordinates_ap'],\n",
" injection['coordinates_ml'],\n",
" injection['coordinates_dv'],\n",
" injection['angle']))\n",
"print('Transgenic Line: %s' % (results[0]['specimen']['donor']['transgenic_mouse']['transgenic_lines'][0]['name']))\n",
"print(results[0]['specimen']['donor']['transgenic_mouse']['transgenic_lines'][0]['description'])\n",
"\n"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" projection_energy | \n",
" sum_pixels | \n",
" sum_projection_pixels | \n",
" projection_intensity | \n",
" is_injection | \n",
" max_voxel_density | \n",
" hemisphere_id | \n",
" sum_projection_pixel_intensity | \n",
" structure_id | \n",
" volume | \n",
" section_data_set_id | \n",
" projection_density | \n",
" sum_pixel_intensity | \n",
" projection_volume | \n",
" max_voxel_y | \n",
" max_voxel_x | \n",
" max_voxel_z | \n",
" id | \n",
" normalized_projection_volume | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 0.000000 | \n",
" 8.169300e+06 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 2 | \n",
" 0.000000e+00 | \n",
" 633 | \n",
" 0.010007 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 1.230126e+09 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630134710 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 1 | \n",
" 0.007004 | \n",
" 2.436300e+08 | \n",
" 1.083166e+04 | \n",
" 157.543863 | \n",
" False | \n",
" 0.074447 | \n",
" 3 | \n",
" 1.706462e+06 | \n",
" 802 | \n",
" 0.298447 | \n",
" 168095756 | \n",
" 4.445947e-05 | \n",
" 3.227097e+10 | \n",
" 1.326879e-05 | \n",
" 3250 | \n",
" 6100 | \n",
" 6300 | \n",
" 630137423 | \n",
" 0.016267 | \n",
"
\n",
" \n",
" 2 | \n",
" 0.313203 | \n",
" 8.831070e+07 | \n",
" 1.312917e+05 | \n",
" 210.669327 | \n",
" False | \n",
" 0.425909 | \n",
" 1 | \n",
" 2.765914e+07 | \n",
" 36 | \n",
" 0.108181 | \n",
" 168095756 | \n",
" 1.486702e-03 | \n",
" 1.257984e+10 | \n",
" 1.608324e-04 | \n",
" 4380 | \n",
" 4430 | \n",
" 1550 | \n",
" 630136438 | \n",
" 0.197175 | \n",
"
\n",
" \n",
" 3 | \n",
" 0.000000 | \n",
" 4.179285e+08 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 1 | \n",
" 0.000000e+00 | \n",
" 685 | \n",
" 0.511962 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 7.516711e+10 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630135976 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 4 | \n",
" 0.000000 | \n",
" 6.515100e+06 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 2 | \n",
" 0.000000e+00 | \n",
" 599626923 | \n",
" 0.007981 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 5.281697e+08 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630135291 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 5 | \n",
" 0.000120 | \n",
" 3.115813e+09 | \n",
" 4.945543e+03 | \n",
" 75.654840 | \n",
" False | \n",
" 0.041845 | \n",
" 3 | \n",
" 3.741543e+05 | \n",
" 1117 | \n",
" 3.816870 | \n",
" 168095756 | \n",
" 1.587240e-06 | \n",
" 3.708296e+11 | \n",
" 6.058290e-06 | \n",
" 5050 | \n",
" 9960 | \n",
" 5870 | \n",
" 630137684 | \n",
" 0.007427 | \n",
"
\n",
" \n",
" 6 | \n",
" 0.000000 | \n",
" 1.635264e+08 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 1 | \n",
" 0.000000e+00 | \n",
" 810 | \n",
" 0.200320 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 3.850220e+10 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630135861 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 7 | \n",
" 0.000000 | \n",
" 6.071310e+07 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 2 | \n",
" 0.000000e+00 | \n",
" 422 | \n",
" 0.074374 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 7.518789e+09 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630134576 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 8 | \n",
" 0.003357 | \n",
" 3.169627e+09 | \n",
" 8.306089e+04 | \n",
" 128.097563 | \n",
" False | \n",
" 0.194948 | \n",
" 1 | \n",
" 1.063990e+07 | \n",
" 991 | \n",
" 3.882793 | \n",
" 168095756 | \n",
" 2.620526e-05 | \n",
" 2.509975e+11 | \n",
" 1.017496e-04 | \n",
" 5090 | \n",
" 8690 | \n",
" 3470 | \n",
" 630135630 | \n",
" 0.124742 | \n",
"
\n",
" \n",
" 9 | \n",
" 0.000000 | \n",
" 3.570480e+07 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 1 | \n",
" 0.000000e+00 | \n",
" 312782594 | \n",
" 0.043738 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 8.247889e+09 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630134462 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 10 | \n",
" 0.000000 | \n",
" 7.937100e+06 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 1 | \n",
" 0.000000e+00 | \n",
" 456 | \n",
" 0.009723 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 1.291829e+09 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630136119 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 11 | \n",
" 0.000000 | \n",
" 4.081230e+07 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 1 | \n",
" 0.000000e+00 | \n",
" 189 | \n",
" 0.049995 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 9.011960e+09 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630136310 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 12 | \n",
" 0.000000 | \n",
" 1.303020e+07 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 3 | \n",
" 0.000000e+00 | \n",
" 599626923 | \n",
" 0.015962 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 1.034770e+09 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630137696 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 13 | \n",
" 0.000143 | \n",
" 9.480582e+08 | \n",
" 4.096307e+02 | \n",
" 331.532705 | \n",
" False | \n",
" 0.024892 | \n",
" 3 | \n",
" 1.358060e+05 | \n",
" 944 | \n",
" 1.161371 | \n",
" 168095756 | \n",
" 4.320733e-07 | \n",
" 3.170528e+11 | \n",
" 5.017976e-07 | \n",
" 3030 | \n",
" 13160 | \n",
" 6710 | \n",
" 630137544 | \n",
" 0.000615 | \n",
"
\n",
" \n",
" 14 | \n",
" 2.836290 | \n",
" 1.689381e+08 | \n",
" 6.630635e+05 | \n",
" 722.641785 | \n",
" False | \n",
" 0.516348 | \n",
" 2 | \n",
" 4.791574e+08 | \n",
" 448 | \n",
" 0.206949 | \n",
" 168095756 | \n",
" 3.924890e-03 | \n",
" 3.296932e+10 | \n",
" 8.122528e-04 | \n",
" 3780 | \n",
" 2410 | \n",
" 7050 | \n",
" 630134593 | \n",
" 0.995796 | \n",
"
\n",
" \n",
" 15 | \n",
" 0.023397 | \n",
" 1.060688e+09 | \n",
" 3.234718e+04 | \n",
" 767.213959 | \n",
" False | \n",
" 0.285881 | \n",
" 2 | \n",
" 2.481721e+07 | \n",
" 894 | \n",
" 1.299343 | \n",
" 168095756 | \n",
" 3.049642e-05 | \n",
" 2.092923e+11 | \n",
" 3.962530e-05 | \n",
" 1880 | \n",
" 10190 | \n",
" 8020 | \n",
" 630134900 | \n",
" 0.048579 | \n",
"
\n",
" \n",
" 16 | \n",
" 0.000000 | \n",
" 5.878890e+07 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 1 | \n",
" 0.000000e+00 | \n",
" 63 | \n",
" 0.072016 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 1.501206e+10 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630136418 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 17 | \n",
" 0.000000 | \n",
" 1.258209e+08 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 2 | \n",
" 0.000000e+00 | \n",
" 563807435 | \n",
" 0.154131 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 1.088741e+10 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630135296 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 18 | \n",
" 0.008695 | \n",
" 3.026599e+09 | \n",
" 9.358170e+04 | \n",
" 281.216598 | \n",
" False | \n",
" 0.221807 | \n",
" 1 | \n",
" 2.631673e+07 | \n",
" 928 | \n",
" 3.707584 | \n",
" 168095756 | \n",
" 3.091975e-05 | \n",
" 1.022736e+12 | \n",
" 1.146376e-04 | \n",
" 4350 | \n",
" 10140 | \n",
" 2940 | \n",
" 630135725 | \n",
" 0.140542 | \n",
"
\n",
" \n",
" 19 | \n",
" 0.000000 | \n",
" 5.039784e+08 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 3 | \n",
" 0.000000e+00 | \n",
" 226 | \n",
" 0.617374 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 8.828833e+10 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630136721 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 20 | \n",
" 0.000000 | \n",
" 1.928106e+08 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 1 | \n",
" 0.000000e+00 | \n",
" 998 | \n",
" 0.236193 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 4.311897e+10 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630135624 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 21 | \n",
" 0.000739 | \n",
" 3.293406e+08 | \n",
" 4.597708e+03 | \n",
" 52.923997 | \n",
" False | \n",
" 0.031263 | \n",
" 3 | \n",
" 2.433291e+05 | \n",
" 122 | \n",
" 0.403442 | \n",
" 168095756 | \n",
" 1.396034e-05 | \n",
" 2.564891e+10 | \n",
" 5.632192e-06 | \n",
" 7090 | \n",
" 9760 | \n",
" 4650 | \n",
" 630136604 | \n",
" 0.006905 | \n",
"
\n",
" \n",
" 22 | \n",
" 0.000000 | \n",
" 2.002680e+07 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 2 | \n",
" 0.000000e+00 | \n",
" 549009227 | \n",
" 0.024533 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 2.746888e+09 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630135374 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 23 | \n",
" 0.000039 | \n",
" 7.464294e+08 | \n",
" 3.523397e+02 | \n",
" 81.596546 | \n",
" False | \n",
" 0.014356 | \n",
" 3 | \n",
" 2.874970e+04 | \n",
" 1108 | \n",
" 0.914376 | \n",
" 168095756 | \n",
" 4.720335e-07 | \n",
" 3.434494e+10 | \n",
" 4.316161e-07 | \n",
" 2860 | \n",
" 4330 | \n",
" 7240 | \n",
" 630137677 | \n",
" 0.000529 | \n",
"
\n",
" \n",
" 24 | \n",
" 0.005193 | \n",
" 9.466486e+10 | \n",
" 2.533439e+06 | \n",
" 194.025469 | \n",
" False | \n",
" 0.448116 | \n",
" 1 | \n",
" 4.915517e+08 | \n",
" 695 | \n",
" 115.964452 | \n",
" 168095756 | \n",
" 2.676219e-05 | \n",
" 2.181537e+13 | \n",
" 3.103463e-03 | \n",
" 7070 | \n",
" 5880 | \n",
" 4000 | \n",
" 630135968 | \n",
" 3.804746 | \n",
"
\n",
" \n",
" 25 | \n",
" 0.000000 | \n",
" 2.629854e+08 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 3 | \n",
" 0.000000e+00 | \n",
" 41 | \n",
" 0.322157 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 5.066283e+10 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630136524 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 26 | \n",
" 0.000201 | \n",
" 8.978355e+08 | \n",
" 1.304619e+03 | \n",
" 138.539200 | \n",
" False | \n",
" 0.039381 | \n",
" 1 | \n",
" 1.807408e+05 | \n",
" 828 | \n",
" 1.099849 | \n",
" 168095756 | \n",
" 1.453071e-06 | \n",
" 2.263174e+11 | \n",
" 1.598158e-06 | \n",
" 1220 | \n",
" 10960 | \n",
" 4560 | \n",
" 630135840 | \n",
" 0.001959 | \n",
"
\n",
" \n",
" 27 | \n",
" 0.000063 | \n",
" 1.078533e+08 | \n",
" 4.727108e+01 | \n",
" 143.303085 | \n",
" False | \n",
" 0.004714 | \n",
" 2 | \n",
" 6.774092e+03 | \n",
" 312782550 | \n",
" 0.132120 | \n",
" 168095756 | \n",
" 4.382906e-07 | \n",
" 1.853269e+10 | \n",
" 5.790707e-08 | \n",
" 390 | \n",
" 6910 | \n",
" 7480 | \n",
" 630136225 | \n",
" 0.000071 | \n",
"
\n",
" \n",
" 28 | \n",
" 0.004572 | \n",
" 8.327067e+09 | \n",
" 1.588136e+05 | \n",
" 239.733852 | \n",
" False | \n",
" 0.272500 | \n",
" 1 | \n",
" 3.807299e+07 | \n",
" 822 | \n",
" 10.200657 | \n",
" 168095756 | \n",
" 1.907197e-05 | \n",
" 1.777963e+12 | \n",
" 1.945466e-04 | \n",
" 3770 | \n",
" 9570 | \n",
" 940 | \n",
" 630135847 | \n",
" 0.238508 | \n",
"
\n",
" \n",
" 29 | \n",
" 0.034559 | \n",
" 4.186842e+10 | \n",
" 8.611659e+06 | \n",
" 168.021380 | \n",
" False | \n",
" 0.716585 | \n",
" 3 | \n",
" 1.446943e+09 | \n",
" 1009 | \n",
" 51.288818 | \n",
" 168095756 | \n",
" 2.056839e-04 | \n",
" 2.105288e+12 | \n",
" 1.054928e-02 | \n",
" 5960 | \n",
" 9270 | \n",
" 3510 | \n",
" 630137602 | \n",
" 12.933080 | \n",
"
\n",
" \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
" ... | \n",
"
\n",
" \n",
" 2490 | \n",
" 0.000467 | \n",
" 9.670482e+08 | \n",
" 2.595247e+03 | \n",
" 174.145988 | \n",
" False | \n",
" 0.039255 | \n",
" 1 | \n",
" 4.519518e+05 | \n",
" 1002 | \n",
" 1.184634 | \n",
" 168095756 | \n",
" 2.683679e-06 | \n",
" 2.208165e+11 | \n",
" 3.179177e-06 | \n",
" 3030 | \n",
" 7970 | \n",
" 610 | \n",
" 630135621 | \n",
" 0.003898 | \n",
"
\n",
" \n",
" 2491 | \n",
" 0.003580 | \n",
" 1.683507e+09 | \n",
" 7.463941e+04 | \n",
" 80.756142 | \n",
" False | \n",
" 0.118260 | \n",
" 1 | \n",
" 6.027590e+06 | \n",
" 1016 | \n",
" 2.062296 | \n",
" 168095756 | \n",
" 4.433568e-05 | \n",
" 1.314584e+11 | \n",
" 9.143327e-05 | \n",
" 4730 | \n",
" 740 | \n",
" 5690 | \n",
" 630135604 | \n",
" 0.112094 | \n",
"
\n",
" \n",
" 2492 | \n",
" 0.000620 | \n",
" 1.698750e+08 | \n",
" 1.536338e+03 | \n",
" 68.547867 | \n",
" False | \n",
" 0.018999 | \n",
" 3 | \n",
" 1.053127e+05 | \n",
" 38 | \n",
" 0.208097 | \n",
" 168095756 | \n",
" 9.043933e-06 | \n",
" 3.266868e+10 | \n",
" 1.882014e-06 | \n",
" 5790 | \n",
" 6110 | \n",
" 5660 | \n",
" 630136521 | \n",
" 0.002307 | \n",
"
\n",
" \n",
" 2493 | \n",
" 0.000000 | \n",
" 8.855640e+07 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 1 | \n",
" 0.000000e+00 | \n",
" 374 | \n",
" 0.108482 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 1.957360e+10 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630136169 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 2494 | \n",
" 0.000004 | \n",
" 1.815714e+09 | \n",
" 9.701965e+01 | \n",
" 68.170074 | \n",
" False | \n",
" 0.009651 | \n",
" 3 | \n",
" 6.613836e+03 | \n",
" 444 | \n",
" 2.224250 | \n",
" 168095756 | \n",
" 5.343333e-08 | \n",
" 4.411985e+11 | \n",
" 1.188491e-07 | \n",
" 3940 | \n",
" 5880 | \n",
" 6110 | \n",
" 630136964 | \n",
" 0.000146 | \n",
"
\n",
" \n",
" 2495 | \n",
" 0.002780 | \n",
" 1.127772e+09 | \n",
" 8.810444e+03 | \n",
" 355.910767 | \n",
" False | \n",
" 0.158458 | \n",
" 2 | \n",
" 3.135732e+06 | \n",
" 1033 | \n",
" 1.381521 | \n",
" 168095756 | \n",
" 7.812257e-06 | \n",
" 4.001790e+11 | \n",
" 1.079279e-05 | \n",
" 4860 | \n",
" 12740 | \n",
" 8000 | \n",
" 630135088 | \n",
" 0.013232 | \n",
"
\n",
" \n",
" 2496 | \n",
" 0.000000 | \n",
" 8.551269e+08 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 2 | \n",
" 0.000000e+00 | \n",
" 295 | \n",
" 1.047530 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 1.964243e+11 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630134489 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 2497 | \n",
" 0.000000 | \n",
" 4.165020e+07 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 2 | \n",
" 0.000000e+00 | \n",
" 263 | \n",
" 0.051021 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 1.036625e+10 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630134468 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 2498 | \n",
" 0.000000 | \n",
" 3.229947e+08 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 1 | \n",
" 0.000000e+00 | \n",
" 334 | \n",
" 0.395668 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 6.719913e+10 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630136198 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 2499 | \n",
" 0.000000 | \n",
" 7.360200e+06 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 2 | \n",
" 0.000000e+00 | \n",
" 549009211 | \n",
" 0.009016 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 1.868418e+09 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630135364 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 2500 | \n",
" 0.000000 | \n",
" 3.338910e+07 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 1 | \n",
" 0.000000e+00 | \n",
" 759 | \n",
" 0.040902 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 8.952062e+09 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630135910 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 2501 | \n",
" 0.014828 | \n",
" 1.083838e+09 | \n",
" 6.662801e+04 | \n",
" 241.199978 | \n",
" False | \n",
" 0.255508 | \n",
" 1 | \n",
" 1.607067e+07 | \n",
" 48 | \n",
" 1.327701 | \n",
" 168095756 | \n",
" 6.147416e-05 | \n",
" 2.920324e+11 | \n",
" 8.161931e-05 | \n",
" 2100 | \n",
" 5830 | \n",
" 5670 | \n",
" 630136429 | \n",
" 0.100063 | \n",
"
\n",
" \n",
" 2502 | \n",
" 0.000000 | \n",
" 6.824016e+08 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 3 | \n",
" 0.000000e+00 | \n",
" 402 | \n",
" 0.835942 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 1.548432e+11 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630136926 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 2503 | \n",
" 0.011545 | \n",
" 1.129891e+09 | \n",
" 1.591356e+04 | \n",
" 819.721387 | \n",
" False | \n",
" 0.185156 | \n",
" 3 | \n",
" 1.304468e+07 | \n",
" 543 | \n",
" 1.384116 | \n",
" 168095756 | \n",
" 1.408416e-05 | \n",
" 2.280057e+11 | \n",
" 1.949411e-05 | \n",
" 3030 | \n",
" 10000 | \n",
" 9970 | \n",
" 630137121 | \n",
" 0.023899 | \n",
"
\n",
" \n",
" 2504 | \n",
" 0.005225 | \n",
" 4.618530e+07 | \n",
" 4.247548e+03 | \n",
" 56.817478 | \n",
" False | \n",
" 0.028530 | \n",
" 2 | \n",
" 2.413350e+05 | \n",
" 589508451 | \n",
" 0.056577 | \n",
" 168095756 | \n",
" 9.196754e-05 | \n",
" 2.355656e+09 | \n",
" 5.203247e-06 | \n",
" 5010 | \n",
" 12570 | \n",
" 7530 | \n",
" 630136337 | \n",
" 0.006379 | \n",
"
\n",
" \n",
" 2505 | \n",
" 0.000000 | \n",
" 2.983284e+08 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 3 | \n",
" 0.000000e+00 | \n",
" 182305697 | \n",
" 0.365452 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 7.699984e+10 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630137530 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 2506 | \n",
" 0.000000 | \n",
" 9.329166e+08 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 1 | \n",
" 0.000000e+00 | \n",
" 862 | \n",
" 1.142823 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 1.998740e+11 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630135802 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 2507 | \n",
" 0.000445 | \n",
" 8.584146e+08 | \n",
" 2.592787e+03 | \n",
" 147.176480 | \n",
" False | \n",
" 0.078671 | \n",
" 3 | \n",
" 3.815973e+05 | \n",
" 443 | \n",
" 1.051558 | \n",
" 168095756 | \n",
" 3.020437e-06 | \n",
" 4.008319e+10 | \n",
" 3.176164e-06 | \n",
" 1410 | \n",
" 7880 | \n",
" 4420 | \n",
" 630136963 | \n",
" 0.003894 | \n",
"
\n",
" \n",
" 2508 | \n",
" 0.000000 | \n",
" 3.840462e+08 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 3 | \n",
" 0.000000e+00 | \n",
" 312782554 | \n",
" 0.470457 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 8.502156e+10 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630136799 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 2509 | \n",
" 0.000000 | \n",
" 2.927880e+07 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 3 | \n",
" 0.000000e+00 | \n",
" 35 | \n",
" 0.035867 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 5.162894e+09 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630136518 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 2510 | \n",
" 0.000000 | \n",
" 4.271544e+08 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 2 | \n",
" 0.000000e+00 | \n",
" 289 | \n",
" 0.523264 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 9.787314e+10 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630134485 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 2511 | \n",
" 0.003388 | \n",
" 6.012653e+09 | \n",
" 7.170032e+04 | \n",
" 284.091858 | \n",
" False | \n",
" 0.190132 | \n",
" 3 | \n",
" 2.036948e+07 | \n",
" 864 | \n",
" 7.365500 | \n",
" 168095756 | \n",
" 1.192491e-05 | \n",
" 1.197024e+12 | \n",
" 8.783289e-05 | \n",
" 3440 | \n",
" 9020 | \n",
" 8100 | \n",
" 630137482 | \n",
" 0.107680 | \n",
"
\n",
" \n",
" 2512 | \n",
" 0.000014 | \n",
" 1.191422e+09 | \n",
" 9.495500e+01 | \n",
" 172.138800 | \n",
" False | \n",
" 0.012713 | \n",
" 3 | \n",
" 1.634544e+04 | \n",
" 820 | \n",
" 1.459492 | \n",
" 168095756 | \n",
" 7.969890e-08 | \n",
" 3.735597e+11 | \n",
" 1.163199e-07 | \n",
" 1390 | \n",
" 10170 | \n",
" 4420 | \n",
" 630137444 | \n",
" 0.000143 | \n",
"
\n",
" \n",
" 2513 | \n",
" 0.000000 | \n",
" 4.101876e+08 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 2 | \n",
" 0.000000e+00 | \n",
" 727 | \n",
" 0.502480 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 8.493145e+10 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630134777 | \n",
" 0.000000 | \n",
"
\n",
" \n",
" 2514 | \n",
" 0.006736 | \n",
" 7.519073e+09 | \n",
" 4.871011e+05 | \n",
" 103.986038 | \n",
" False | \n",
" 0.464752 | \n",
" 1 | \n",
" 5.065171e+07 | \n",
" 771 | \n",
" 9.210865 | \n",
" 168095756 | \n",
" 6.478206e-05 | \n",
" 8.528342e+11 | \n",
" 5.966988e-04 | \n",
" 6350 | \n",
" 8640 | \n",
" 5620 | \n",
" 630135901 | \n",
" 0.731534 | \n",
"
\n",
" \n",
" 2515 | \n",
" 0.000836 | \n",
" 1.222056e+08 | \n",
" 3.920502e+02 | \n",
" 260.567923 | \n",
" False | \n",
" 0.024297 | \n",
" 3 | \n",
" 1.021557e+05 | \n",
" 606826651 | \n",
" 0.149702 | \n",
" 168095756 | \n",
" 3.208120e-06 | \n",
" 2.519184e+10 | \n",
" 4.802616e-07 | \n",
" 6500 | \n",
" 7980 | \n",
" 5950 | \n",
" 630137769 | \n",
" 0.000589 | \n",
"
\n",
" \n",
" 2516 | \n",
" 0.001456 | \n",
" 2.112570e+07 | \n",
" 1.225830e+02 | \n",
" 250.942963 | \n",
" False | \n",
" 0.026424 | \n",
" 2 | \n",
" 3.076133e+04 | \n",
" 390 | \n",
" 0.025879 | \n",
" 168095756 | \n",
" 5.802552e-06 | \n",
" 3.043328e+09 | \n",
" 1.501641e-07 | \n",
" 6700 | \n",
" 6170 | \n",
" 7210 | \n",
" 630134560 | \n",
" 0.000184 | \n",
"
\n",
" \n",
" 2517 | \n",
" 0.007704 | \n",
" 2.187504e+08 | \n",
" 8.078372e+03 | \n",
" 208.612210 | \n",
" False | \n",
" 0.091234 | \n",
" 2 | \n",
" 1.685247e+06 | \n",
" 1083 | \n",
" 0.267969 | \n",
" 168095756 | \n",
" 3.692963e-05 | \n",
" 2.328922e+10 | \n",
" 9.896006e-06 | \n",
" 2640 | \n",
" 7640 | \n",
" 5800 | \n",
" 630135226 | \n",
" 0.012132 | \n",
"
\n",
" \n",
" 2518 | \n",
" 0.178399 | \n",
" 3.998038e+10 | \n",
" 1.019109e+07 | \n",
" 699.870497 | \n",
" False | \n",
" 0.754131 | \n",
" 3 | \n",
" 7.132443e+09 | \n",
" 698 | \n",
" 48.975971 | \n",
" 168095756 | \n",
" 2.549023e-04 | \n",
" 8.258442e+12 | \n",
" 1.248409e-02 | \n",
" 5440 | \n",
" 5750 | \n",
" 9630 | \n",
" 630137313 | \n",
" 15.305088 | \n",
"
\n",
" \n",
" 2519 | \n",
" 0.000000 | \n",
" 4.997340e+08 | \n",
" 0.000000e+00 | \n",
" 0.000000 | \n",
" False | \n",
" 0.000000 | \n",
" 3 | \n",
" 0.000000e+00 | \n",
" 1128 | \n",
" 0.612174 | \n",
" 168095756 | \n",
" 0.000000e+00 | \n",
" 1.545278e+11 | \n",
" 0.000000e+00 | \n",
" 0 | \n",
" 0 | \n",
" 0 | \n",
" 630137691 | \n",
" 0.000000 | \n",
"
\n",
" \n",
"
\n",
"
2520 rows × 19 columns
\n",
"
"
],
"text/plain": [
" projection_energy sum_pixels sum_projection_pixels \\\n",
"0 0.000000 8.169300e+06 0.000000e+00 \n",
"1 0.007004 2.436300e+08 1.083166e+04 \n",
"2 0.313203 8.831070e+07 1.312917e+05 \n",
"3 0.000000 4.179285e+08 0.000000e+00 \n",
"4 0.000000 6.515100e+06 0.000000e+00 \n",
"5 0.000120 3.115813e+09 4.945543e+03 \n",
"6 0.000000 1.635264e+08 0.000000e+00 \n",
"7 0.000000 6.071310e+07 0.000000e+00 \n",
"8 0.003357 3.169627e+09 8.306089e+04 \n",
"9 0.000000 3.570480e+07 0.000000e+00 \n",
"10 0.000000 7.937100e+06 0.000000e+00 \n",
"11 0.000000 4.081230e+07 0.000000e+00 \n",
"12 0.000000 1.303020e+07 0.000000e+00 \n",
"13 0.000143 9.480582e+08 4.096307e+02 \n",
"14 2.836290 1.689381e+08 6.630635e+05 \n",
"15 0.023397 1.060688e+09 3.234718e+04 \n",
"16 0.000000 5.878890e+07 0.000000e+00 \n",
"17 0.000000 1.258209e+08 0.000000e+00 \n",
"18 0.008695 3.026599e+09 9.358170e+04 \n",
"19 0.000000 5.039784e+08 0.000000e+00 \n",
"20 0.000000 1.928106e+08 0.000000e+00 \n",
"21 0.000739 3.293406e+08 4.597708e+03 \n",
"22 0.000000 2.002680e+07 0.000000e+00 \n",
"23 0.000039 7.464294e+08 3.523397e+02 \n",
"24 0.005193 9.466486e+10 2.533439e+06 \n",
"25 0.000000 2.629854e+08 0.000000e+00 \n",
"26 0.000201 8.978355e+08 1.304619e+03 \n",
"27 0.000063 1.078533e+08 4.727108e+01 \n",
"28 0.004572 8.327067e+09 1.588136e+05 \n",
"29 0.034559 4.186842e+10 8.611659e+06 \n",
"... ... ... ... \n",
"2490 0.000467 9.670482e+08 2.595247e+03 \n",
"2491 0.003580 1.683507e+09 7.463941e+04 \n",
"2492 0.000620 1.698750e+08 1.536338e+03 \n",
"2493 0.000000 8.855640e+07 0.000000e+00 \n",
"2494 0.000004 1.815714e+09 9.701965e+01 \n",
"2495 0.002780 1.127772e+09 8.810444e+03 \n",
"2496 0.000000 8.551269e+08 0.000000e+00 \n",
"2497 0.000000 4.165020e+07 0.000000e+00 \n",
"2498 0.000000 3.229947e+08 0.000000e+00 \n",
"2499 0.000000 7.360200e+06 0.000000e+00 \n",
"2500 0.000000 3.338910e+07 0.000000e+00 \n",
"2501 0.014828 1.083838e+09 6.662801e+04 \n",
"2502 0.000000 6.824016e+08 0.000000e+00 \n",
"2503 0.011545 1.129891e+09 1.591356e+04 \n",
"2504 0.005225 4.618530e+07 4.247548e+03 \n",
"2505 0.000000 2.983284e+08 0.000000e+00 \n",
"2506 0.000000 9.329166e+08 0.000000e+00 \n",
"2507 0.000445 8.584146e+08 2.592787e+03 \n",
"2508 0.000000 3.840462e+08 0.000000e+00 \n",
"2509 0.000000 2.927880e+07 0.000000e+00 \n",
"2510 0.000000 4.271544e+08 0.000000e+00 \n",
"2511 0.003388 6.012653e+09 7.170032e+04 \n",
"2512 0.000014 1.191422e+09 9.495500e+01 \n",
"2513 0.000000 4.101876e+08 0.000000e+00 \n",
"2514 0.006736 7.519073e+09 4.871011e+05 \n",
"2515 0.000836 1.222056e+08 3.920502e+02 \n",
"2516 0.001456 2.112570e+07 1.225830e+02 \n",
"2517 0.007704 2.187504e+08 8.078372e+03 \n",
"2518 0.178399 3.998038e+10 1.019109e+07 \n",
"2519 0.000000 4.997340e+08 0.000000e+00 \n",
"\n",
" projection_intensity is_injection max_voxel_density hemisphere_id \\\n",
"0 0.000000 False 0.000000 2 \n",
"1 157.543863 False 0.074447 3 \n",
"2 210.669327 False 0.425909 1 \n",
"3 0.000000 False 0.000000 1 \n",
"4 0.000000 False 0.000000 2 \n",
"5 75.654840 False 0.041845 3 \n",
"6 0.000000 False 0.000000 1 \n",
"7 0.000000 False 0.000000 2 \n",
"8 128.097563 False 0.194948 1 \n",
"9 0.000000 False 0.000000 1 \n",
"10 0.000000 False 0.000000 1 \n",
"11 0.000000 False 0.000000 1 \n",
"12 0.000000 False 0.000000 3 \n",
"13 331.532705 False 0.024892 3 \n",
"14 722.641785 False 0.516348 2 \n",
"15 767.213959 False 0.285881 2 \n",
"16 0.000000 False 0.000000 1 \n",
"17 0.000000 False 0.000000 2 \n",
"18 281.216598 False 0.221807 1 \n",
"19 0.000000 False 0.000000 3 \n",
"20 0.000000 False 0.000000 1 \n",
"21 52.923997 False 0.031263 3 \n",
"22 0.000000 False 0.000000 2 \n",
"23 81.596546 False 0.014356 3 \n",
"24 194.025469 False 0.448116 1 \n",
"25 0.000000 False 0.000000 3 \n",
"26 138.539200 False 0.039381 1 \n",
"27 143.303085 False 0.004714 2 \n",
"28 239.733852 False 0.272500 1 \n",
"29 168.021380 False 0.716585 3 \n",
"... ... ... ... ... \n",
"2490 174.145988 False 0.039255 1 \n",
"2491 80.756142 False 0.118260 1 \n",
"2492 68.547867 False 0.018999 3 \n",
"2493 0.000000 False 0.000000 1 \n",
"2494 68.170074 False 0.009651 3 \n",
"2495 355.910767 False 0.158458 2 \n",
"2496 0.000000 False 0.000000 2 \n",
"2497 0.000000 False 0.000000 2 \n",
"2498 0.000000 False 0.000000 1 \n",
"2499 0.000000 False 0.000000 2 \n",
"2500 0.000000 False 0.000000 1 \n",
"2501 241.199978 False 0.255508 1 \n",
"2502 0.000000 False 0.000000 3 \n",
"2503 819.721387 False 0.185156 3 \n",
"2504 56.817478 False 0.028530 2 \n",
"2505 0.000000 False 0.000000 3 \n",
"2506 0.000000 False 0.000000 1 \n",
"2507 147.176480 False 0.078671 3 \n",
"2508 0.000000 False 0.000000 3 \n",
"2509 0.000000 False 0.000000 3 \n",
"2510 0.000000 False 0.000000 2 \n",
"2511 284.091858 False 0.190132 3 \n",
"2512 172.138800 False 0.012713 3 \n",
"2513 0.000000 False 0.000000 2 \n",
"2514 103.986038 False 0.464752 1 \n",
"2515 260.567923 False 0.024297 3 \n",
"2516 250.942963 False 0.026424 2 \n",
"2517 208.612210 False 0.091234 2 \n",
"2518 699.870497 False 0.754131 3 \n",
"2519 0.000000 False 0.000000 3 \n",
"\n",
" sum_projection_pixel_intensity structure_id volume \\\n",
"0 0.000000e+00 633 0.010007 \n",
"1 1.706462e+06 802 0.298447 \n",
"2 2.765914e+07 36 0.108181 \n",
"3 0.000000e+00 685 0.511962 \n",
"4 0.000000e+00 599626923 0.007981 \n",
"5 3.741543e+05 1117 3.816870 \n",
"6 0.000000e+00 810 0.200320 \n",
"7 0.000000e+00 422 0.074374 \n",
"8 1.063990e+07 991 3.882793 \n",
"9 0.000000e+00 312782594 0.043738 \n",
"10 0.000000e+00 456 0.009723 \n",
"11 0.000000e+00 189 0.049995 \n",
"12 0.000000e+00 599626923 0.015962 \n",
"13 1.358060e+05 944 1.161371 \n",
"14 4.791574e+08 448 0.206949 \n",
"15 2.481721e+07 894 1.299343 \n",
"16 0.000000e+00 63 0.072016 \n",
"17 0.000000e+00 563807435 0.154131 \n",
"18 2.631673e+07 928 3.707584 \n",
"19 0.000000e+00 226 0.617374 \n",
"20 0.000000e+00 998 0.236193 \n",
"21 2.433291e+05 122 0.403442 \n",
"22 0.000000e+00 549009227 0.024533 \n",
"23 2.874970e+04 1108 0.914376 \n",
"24 4.915517e+08 695 115.964452 \n",
"25 0.000000e+00 41 0.322157 \n",
"26 1.807408e+05 828 1.099849 \n",
"27 6.774092e+03 312782550 0.132120 \n",
"28 3.807299e+07 822 10.200657 \n",
"29 1.446943e+09 1009 51.288818 \n",
"... ... ... ... \n",
"2490 4.519518e+05 1002 1.184634 \n",
"2491 6.027590e+06 1016 2.062296 \n",
"2492 1.053127e+05 38 0.208097 \n",
"2493 0.000000e+00 374 0.108482 \n",
"2494 6.613836e+03 444 2.224250 \n",
"2495 3.135732e+06 1033 1.381521 \n",
"2496 0.000000e+00 295 1.047530 \n",
"2497 0.000000e+00 263 0.051021 \n",
"2498 0.000000e+00 334 0.395668 \n",
"2499 0.000000e+00 549009211 0.009016 \n",
"2500 0.000000e+00 759 0.040902 \n",
"2501 1.607067e+07 48 1.327701 \n",
"2502 0.000000e+00 402 0.835942 \n",
"2503 1.304468e+07 543 1.384116 \n",
"2504 2.413350e+05 589508451 0.056577 \n",
"2505 0.000000e+00 182305697 0.365452 \n",
"2506 0.000000e+00 862 1.142823 \n",
"2507 3.815973e+05 443 1.051558 \n",
"2508 0.000000e+00 312782554 0.470457 \n",
"2509 0.000000e+00 35 0.035867 \n",
"2510 0.000000e+00 289 0.523264 \n",
"2511 2.036948e+07 864 7.365500 \n",
"2512 1.634544e+04 820 1.459492 \n",
"2513 0.000000e+00 727 0.502480 \n",
"2514 5.065171e+07 771 9.210865 \n",
"2515 1.021557e+05 606826651 0.149702 \n",
"2516 3.076133e+04 390 0.025879 \n",
"2517 1.685247e+06 1083 0.267969 \n",
"2518 7.132443e+09 698 48.975971 \n",
"2519 0.000000e+00 1128 0.612174 \n",
"\n",
" section_data_set_id projection_density sum_pixel_intensity \\\n",
"0 168095756 0.000000e+00 1.230126e+09 \n",
"1 168095756 4.445947e-05 3.227097e+10 \n",
"2 168095756 1.486702e-03 1.257984e+10 \n",
"3 168095756 0.000000e+00 7.516711e+10 \n",
"4 168095756 0.000000e+00 5.281697e+08 \n",
"5 168095756 1.587240e-06 3.708296e+11 \n",
"6 168095756 0.000000e+00 3.850220e+10 \n",
"7 168095756 0.000000e+00 7.518789e+09 \n",
"8 168095756 2.620526e-05 2.509975e+11 \n",
"9 168095756 0.000000e+00 8.247889e+09 \n",
"10 168095756 0.000000e+00 1.291829e+09 \n",
"11 168095756 0.000000e+00 9.011960e+09 \n",
"12 168095756 0.000000e+00 1.034770e+09 \n",
"13 168095756 4.320733e-07 3.170528e+11 \n",
"14 168095756 3.924890e-03 3.296932e+10 \n",
"15 168095756 3.049642e-05 2.092923e+11 \n",
"16 168095756 0.000000e+00 1.501206e+10 \n",
"17 168095756 0.000000e+00 1.088741e+10 \n",
"18 168095756 3.091975e-05 1.022736e+12 \n",
"19 168095756 0.000000e+00 8.828833e+10 \n",
"20 168095756 0.000000e+00 4.311897e+10 \n",
"21 168095756 1.396034e-05 2.564891e+10 \n",
"22 168095756 0.000000e+00 2.746888e+09 \n",
"23 168095756 4.720335e-07 3.434494e+10 \n",
"24 168095756 2.676219e-05 2.181537e+13 \n",
"25 168095756 0.000000e+00 5.066283e+10 \n",
"26 168095756 1.453071e-06 2.263174e+11 \n",
"27 168095756 4.382906e-07 1.853269e+10 \n",
"28 168095756 1.907197e-05 1.777963e+12 \n",
"29 168095756 2.056839e-04 2.105288e+12 \n",
"... ... ... ... \n",
"2490 168095756 2.683679e-06 2.208165e+11 \n",
"2491 168095756 4.433568e-05 1.314584e+11 \n",
"2492 168095756 9.043933e-06 3.266868e+10 \n",
"2493 168095756 0.000000e+00 1.957360e+10 \n",
"2494 168095756 5.343333e-08 4.411985e+11 \n",
"2495 168095756 7.812257e-06 4.001790e+11 \n",
"2496 168095756 0.000000e+00 1.964243e+11 \n",
"2497 168095756 0.000000e+00 1.036625e+10 \n",
"2498 168095756 0.000000e+00 6.719913e+10 \n",
"2499 168095756 0.000000e+00 1.868418e+09 \n",
"2500 168095756 0.000000e+00 8.952062e+09 \n",
"2501 168095756 6.147416e-05 2.920324e+11 \n",
"2502 168095756 0.000000e+00 1.548432e+11 \n",
"2503 168095756 1.408416e-05 2.280057e+11 \n",
"2504 168095756 9.196754e-05 2.355656e+09 \n",
"2505 168095756 0.000000e+00 7.699984e+10 \n",
"2506 168095756 0.000000e+00 1.998740e+11 \n",
"2507 168095756 3.020437e-06 4.008319e+10 \n",
"2508 168095756 0.000000e+00 8.502156e+10 \n",
"2509 168095756 0.000000e+00 5.162894e+09 \n",
"2510 168095756 0.000000e+00 9.787314e+10 \n",
"2511 168095756 1.192491e-05 1.197024e+12 \n",
"2512 168095756 7.969890e-08 3.735597e+11 \n",
"2513 168095756 0.000000e+00 8.493145e+10 \n",
"2514 168095756 6.478206e-05 8.528342e+11 \n",
"2515 168095756 3.208120e-06 2.519184e+10 \n",
"2516 168095756 5.802552e-06 3.043328e+09 \n",
"2517 168095756 3.692963e-05 2.328922e+10 \n",
"2518 168095756 2.549023e-04 8.258442e+12 \n",
"2519 168095756 0.000000e+00 1.545278e+11 \n",
"\n",
" projection_volume max_voxel_y max_voxel_x max_voxel_z id \\\n",
"0 0.000000e+00 0 0 0 630134710 \n",
"1 1.326879e-05 3250 6100 6300 630137423 \n",
"2 1.608324e-04 4380 4430 1550 630136438 \n",
"3 0.000000e+00 0 0 0 630135976 \n",
"4 0.000000e+00 0 0 0 630135291 \n",
"5 6.058290e-06 5050 9960 5870 630137684 \n",
"6 0.000000e+00 0 0 0 630135861 \n",
"7 0.000000e+00 0 0 0 630134576 \n",
"8 1.017496e-04 5090 8690 3470 630135630 \n",
"9 0.000000e+00 0 0 0 630134462 \n",
"10 0.000000e+00 0 0 0 630136119 \n",
"11 0.000000e+00 0 0 0 630136310 \n",
"12 0.000000e+00 0 0 0 630137696 \n",
"13 5.017976e-07 3030 13160 6710 630137544 \n",
"14 8.122528e-04 3780 2410 7050 630134593 \n",
"15 3.962530e-05 1880 10190 8020 630134900 \n",
"16 0.000000e+00 0 0 0 630136418 \n",
"17 0.000000e+00 0 0 0 630135296 \n",
"18 1.146376e-04 4350 10140 2940 630135725 \n",
"19 0.000000e+00 0 0 0 630136721 \n",
"20 0.000000e+00 0 0 0 630135624 \n",
"21 5.632192e-06 7090 9760 4650 630136604 \n",
"22 0.000000e+00 0 0 0 630135374 \n",
"23 4.316161e-07 2860 4330 7240 630137677 \n",
"24 3.103463e-03 7070 5880 4000 630135968 \n",
"25 0.000000e+00 0 0 0 630136524 \n",
"26 1.598158e-06 1220 10960 4560 630135840 \n",
"27 5.790707e-08 390 6910 7480 630136225 \n",
"28 1.945466e-04 3770 9570 940 630135847 \n",
"29 1.054928e-02 5960 9270 3510 630137602 \n",
"... ... ... ... ... ... \n",
"2490 3.179177e-06 3030 7970 610 630135621 \n",
"2491 9.143327e-05 4730 740 5690 630135604 \n",
"2492 1.882014e-06 5790 6110 5660 630136521 \n",
"2493 0.000000e+00 0 0 0 630136169 \n",
"2494 1.188491e-07 3940 5880 6110 630136964 \n",
"2495 1.079279e-05 4860 12740 8000 630135088 \n",
"2496 0.000000e+00 0 0 0 630134489 \n",
"2497 0.000000e+00 0 0 0 630134468 \n",
"2498 0.000000e+00 0 0 0 630136198 \n",
"2499 0.000000e+00 0 0 0 630135364 \n",
"2500 0.000000e+00 0 0 0 630135910 \n",
"2501 8.161931e-05 2100 5830 5670 630136429 \n",
"2502 0.000000e+00 0 0 0 630136926 \n",
"2503 1.949411e-05 3030 10000 9970 630137121 \n",
"2504 5.203247e-06 5010 12570 7530 630136337 \n",
"2505 0.000000e+00 0 0 0 630137530 \n",
"2506 0.000000e+00 0 0 0 630135802 \n",
"2507 3.176164e-06 1410 7880 4420 630136963 \n",
"2508 0.000000e+00 0 0 0 630136799 \n",
"2509 0.000000e+00 0 0 0 630136518 \n",
"2510 0.000000e+00 0 0 0 630134485 \n",
"2511 8.783289e-05 3440 9020 8100 630137482 \n",
"2512 1.163199e-07 1390 10170 4420 630137444 \n",
"2513 0.000000e+00 0 0 0 630134777 \n",
"2514 5.966988e-04 6350 8640 5620 630135901 \n",
"2515 4.802616e-07 6500 7980 5950 630137769 \n",
"2516 1.501641e-07 6700 6170 7210 630134560 \n",
"2517 9.896006e-06 2640 7640 5800 630135226 \n",
"2518 1.248409e-02 5440 5750 9630 630137313 \n",
"2519 0.000000e+00 0 0 0 630137691 \n",
"\n",
" normalized_projection_volume \n",
"0 0.000000 \n",
"1 0.016267 \n",
"2 0.197175 \n",
"3 0.000000 \n",
"4 0.000000 \n",
"5 0.007427 \n",
"6 0.000000 \n",
"7 0.000000 \n",
"8 0.124742 \n",
"9 0.000000 \n",
"10 0.000000 \n",
"11 0.000000 \n",
"12 0.000000 \n",
"13 0.000615 \n",
"14 0.995796 \n",
"15 0.048579 \n",
"16 0.000000 \n",
"17 0.000000 \n",
"18 0.140542 \n",
"19 0.000000 \n",
"20 0.000000 \n",
"21 0.006905 \n",
"22 0.000000 \n",
"23 0.000529 \n",
"24 3.804746 \n",
"25 0.000000 \n",
"26 0.001959 \n",
"27 0.000071 \n",
"28 0.238508 \n",
"29 12.933080 \n",
"... ... \n",
"2490 0.003898 \n",
"2491 0.112094 \n",
"2492 0.002307 \n",
"2493 0.000000 \n",
"2494 0.000146 \n",
"2495 0.013232 \n",
"2496 0.000000 \n",
"2497 0.000000 \n",
"2498 0.000000 \n",
"2499 0.000000 \n",
"2500 0.000000 \n",
"2501 0.100063 \n",
"2502 0.000000 \n",
"2503 0.023899 \n",
"2504 0.006379 \n",
"2505 0.000000 \n",
"2506 0.000000 \n",
"2507 0.003894 \n",
"2508 0.000000 \n",
"2509 0.000000 \n",
"2510 0.000000 \n",
"2511 0.107680 \n",
"2512 0.000143 \n",
"2513 0.000000 \n",
"2514 0.731534 \n",
"2515 0.000589 \n",
"2516 0.000184 \n",
"2517 0.012132 \n",
"2518 15.305088 \n",
"2519 0.000000 \n",
"\n",
"[2520 rows x 19 columns]"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"projection_results = mca.get_structure_unionizes([section_data_set_id], is_injection=False)\n",
"projection_df = tabular_dataframe(projection_results)\n",
"projection_df"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" st_level | \n",
" graph_id | \n",
" name | \n",
" weight | \n",
" acronym | \n",
" parent_structure_id | \n",
" graph_order | \n",
" sphinx_id | \n",
" hemisphere_id | \n",
" safe_name | \n",
" ... | \n",
" failed | \n",
" depth | \n",
" neuro_name_structure_id_path | \n",
" neuro_name_structure_id | \n",
" structure_name_facet | \n",
" failed_facet | \n",
" id | \n",
" ontology_id | \n",
" atlas_id | \n",
" structure_set_ancestor | \n",
"
\n",
" \n",
" \n",
" \n",
" 416 | \n",
" 8 | \n",
" 1 | \n",
" Piriform area | \n",
" 8690 | \n",
" PIR | \n",
" 698.0 | \n",
" 416 | \n",
" 417 | \n",
" 3 | \n",
" Piriform area | \n",
" ... | \n",
" False | \n",
" 6 | \n",
" None | \n",
" None | \n",
" 3867654445 | \n",
" 734881840 | \n",
" 961 | \n",
" 1 | \n",
" 261.0 | \n",
" [997, 8, 567, 688, 695, 698, 961] | \n",
"
\n",
" \n",
"
\n",
"
1 rows × 22 columns
\n",
"
"
],
"text/plain": [
" st_level graph_id name weight acronym parent_structure_id \\\n",
"416 8 1 Piriform area 8690 PIR 698.0 \n",
"\n",
" graph_order sphinx_id hemisphere_id safe_name \\\n",
"416 416 417 3 Piriform area \n",
"\n",
" ... failed depth \\\n",
"416 ... False 6 \n",
"\n",
" neuro_name_structure_id_path neuro_name_structure_id \\\n",
"416 None None \n",
"\n",
" structure_name_facet failed_facet id ontology_id atlas_id \\\n",
"416 3867654445 734881840 961 1 261.0 \n",
"\n",
" structure_set_ancestor \n",
"416 [997, 8, 567, 688, 695, 698, 961] \n",
"\n",
"[1 rows x 22 columns]"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"from allensdk.api.queries.ontologies_api import OntologiesApi\n",
"oa = OntologiesApi()\n",
"\n",
"atlases = tabular_dataframe(oa.get_atlases_table(brief=True))\n",
"mouse_p56_coronal_id = atlases[atlases.name == 'Mouse, P56, Coronal']['structure_graph'].iloc[0]['id'] # 1\n",
"\n",
"# calculate a list of only the ancestors that are in the limited structure set\n",
"structure_set_df = tabular_dataframe(oa.get_structures(mouse_p56_coronal_id))\n",
"\n",
"oa.unpack_structure_set_ancestors(structure_set_df)\n",
"\n",
"structure_set_df[structure_set_df.acronym == 'PIR']"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {
"scrolled": true
},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/home/nicholasc/anaconda2/lib/python2.7/site-packages/ipykernel_launcher.py:13: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
" del sys.path[0]\n"
]
},
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" hemisphere_id | \n",
" projection_volume | \n",
" id | \n",
" acronym | \n",
" graph_order | \n",
"
\n",
" \n",
" structure_id | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" 997 | \n",
" 1 | \n",
" 0.026879 | \n",
" 997 | \n",
" root | \n",
" 0 | \n",
"
\n",
" \n",
" 997 | \n",
" 2 | \n",
" 0.069915 | \n",
" 997 | \n",
" root | \n",
" 0 | \n",
"
\n",
" \n",
" 8 | \n",
" 1 | \n",
" 0.011054 | \n",
" 8 | \n",
" grey | \n",
" 1 | \n",
"
\n",
" \n",
" 8 | \n",
" 2 | \n",
" 0.054640 | \n",
" 8 | \n",
" grey | \n",
" 1 | \n",
"
\n",
" \n",
" 567 | \n",
" 2 | \n",
" 0.046495 | \n",
" 567 | \n",
" CH | \n",
" 2 | \n",
"
\n",
" \n",
" 688 | \n",
" 2 | \n",
" 0.045730 | \n",
" 688 | \n",
" CTX | \n",
" 3 | \n",
"
\n",
" \n",
" 695 | \n",
" 2 | \n",
" 0.043994 | \n",
" 695 | \n",
" CTXpl | \n",
" 4 | \n",
"
\n",
" \n",
" 315 | \n",
" 2 | \n",
" 0.028471 | \n",
" 315 | \n",
" Isocortex | \n",
" 5 | \n",
"
\n",
" \n",
" 95 | \n",
" 2 | \n",
" 0.017591 | \n",
" 95 | \n",
" AI | \n",
" 278 | \n",
"
\n",
" \n",
" 111 | \n",
" 2 | \n",
" 0.011202 | \n",
" 111 | \n",
" AIp | \n",
" 285 | \n",
"
\n",
" \n",
" 698 | \n",
" 2 | \n",
" 0.011256 | \n",
" 698 | \n",
" OLF | \n",
" 379 | \n",
"
\n",
" \n",
" 961 | \n",
" 2 | \n",
" 0.010141 | \n",
" 961 | \n",
" PIR | \n",
" 416 | \n",
"
\n",
" \n",
" 343 | \n",
" 2 | \n",
" 0.007112 | \n",
" 343 | \n",
" BS | \n",
" 639 | \n",
"
\n",
" \n",
" 343 | \n",
" 1 | \n",
" 0.006532 | \n",
" 343 | \n",
" BS | \n",
" 639 | \n",
"
\n",
" \n",
" 1065 | \n",
" 1 | \n",
" 0.005647 | \n",
" 1065 | \n",
" HB | \n",
" 882 | \n",
"
\n",
" \n",
" 1065 | \n",
" 2 | \n",
" 0.006438 | \n",
" 1065 | \n",
" HB | \n",
" 882 | \n",
"
\n",
" \n",
" 354 | \n",
" 2 | \n",
" 0.005571 | \n",
" 354 | \n",
" MY | \n",
" 935 | \n",
"
\n",
" \n",
" 354 | \n",
" 1 | \n",
" 0.005050 | \n",
" 354 | \n",
" MY | \n",
" 935 | \n",
"
\n",
" \n",
" 1009 | \n",
" 1 | \n",
" 0.005569 | \n",
" 1009 | \n",
" fiber tracts | \n",
" 1101 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" hemisphere_id projection_volume id acronym \\\n",
"structure_id \n",
"997 1 0.026879 997 root \n",
"997 2 0.069915 997 root \n",
"8 1 0.011054 8 grey \n",
"8 2 0.054640 8 grey \n",
"567 2 0.046495 567 CH \n",
"688 2 0.045730 688 CTX \n",
"695 2 0.043994 695 CTXpl \n",
"315 2 0.028471 315 Isocortex \n",
"95 2 0.017591 95 AI \n",
"111 2 0.011202 111 AIp \n",
"698 2 0.011256 698 OLF \n",
"961 2 0.010141 961 PIR \n",
"343 2 0.007112 343 BS \n",
"343 1 0.006532 343 BS \n",
"1065 1 0.005647 1065 HB \n",
"1065 2 0.006438 1065 HB \n",
"354 2 0.005571 354 MY \n",
"354 1 0.005050 354 MY \n",
"1009 1 0.005569 1009 fiber tracts \n",
"\n",
" graph_order \n",
"structure_id \n",
"997 0 \n",
"997 0 \n",
"8 1 \n",
"8 1 \n",
"567 2 \n",
"688 3 \n",
"695 4 \n",
"315 5 \n",
"95 278 \n",
"111 285 \n",
"698 379 \n",
"961 416 \n",
"343 639 \n",
"343 639 \n",
"1065 882 \n",
"1065 882 \n",
"354 935 \n",
"354 935 \n",
"1009 1101 "
]
},
"execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"cutoff = 0.0050\n",
"data_field = 'projection_volume'\n",
"\n",
"# projection joined to structures\n",
"table = pd.concat((\n",
" pd.merge(projection_df[projection_df.hemisphere_id == h]\n",
" [projection_df.projection_volume > cutoff].loc[:,['hemisphere_id',\n",
" 'structure_id',\n",
" data_field]],\n",
" structure_set_df[['id','acronym','graph_order']],\n",
" how='inner',\n",
" left_on='structure_id', right_on='id')\n",
" for h in [1, 2])).sort_values('graph_order').set_index('structure_id')\n",
" \n",
"# table[['acronym', 'hemisphere_id', 'projection_volume']]\n",
"\n",
"table"
]
},
{
"cell_type": "code",
"execution_count": 14,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" hemisphere_id | \n",
" L | \n",
" R | \n",
" L | \n",
" R | \n",
"
\n",
" \n",
" graph_order | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" root | \n",
" root | \n",
" 0.026879 | \n",
" 0.069915 | \n",
"
\n",
" \n",
" 1 | \n",
" grey | \n",
" grey | \n",
" 0.011054 | \n",
" 0.054640 | \n",
"
\n",
" \n",
" 2 | \n",
" NaN | \n",
" CH | \n",
" NaN | \n",
" 0.046495 | \n",
"
\n",
" \n",
" 3 | \n",
" NaN | \n",
" CTX | \n",
" NaN | \n",
" 0.045730 | \n",
"
\n",
" \n",
" 4 | \n",
" NaN | \n",
" CTXpl | \n",
" NaN | \n",
" 0.043994 | \n",
"
\n",
" \n",
" 5 | \n",
" NaN | \n",
" Isocortex | \n",
" NaN | \n",
" 0.028471 | \n",
"
\n",
" \n",
" 278 | \n",
" NaN | \n",
" AI | \n",
" NaN | \n",
" 0.017591 | \n",
"
\n",
" \n",
" 285 | \n",
" NaN | \n",
" AIp | \n",
" NaN | \n",
" 0.011202 | \n",
"
\n",
" \n",
" 379 | \n",
" NaN | \n",
" OLF | \n",
" NaN | \n",
" 0.011256 | \n",
"
\n",
" \n",
" 416 | \n",
" NaN | \n",
" PIR | \n",
" NaN | \n",
" 0.010141 | \n",
"
\n",
" \n",
" 639 | \n",
" BS | \n",
" BS | \n",
" 0.006532 | \n",
" 0.007112 | \n",
"
\n",
" \n",
" 882 | \n",
" HB | \n",
" HB | \n",
" 0.005647 | \n",
" 0.006438 | \n",
"
\n",
" \n",
" 935 | \n",
" MY | \n",
" MY | \n",
" 0.005050 | \n",
" 0.005571 | \n",
"
\n",
" \n",
" 1101 | \n",
" fiber tracts | \n",
" NaN | \n",
" 0.005569 | \n",
" NaN | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
"hemisphere_id L R L R\n",
"graph_order \n",
"0 root root 0.026879 0.069915\n",
"1 grey grey 0.011054 0.054640\n",
"2 NaN CH NaN 0.046495\n",
"3 NaN CTX NaN 0.045730\n",
"4 NaN CTXpl NaN 0.043994\n",
"5 NaN Isocortex NaN 0.028471\n",
"278 NaN AI NaN 0.017591\n",
"285 NaN AIp NaN 0.011202\n",
"379 NaN OLF NaN 0.011256\n",
"416 NaN PIR NaN 0.010141\n",
"639 BS BS 0.006532 0.007112\n",
"882 HB HB 0.005647 0.006438\n",
"935 MY MY 0.005050 0.005571\n",
"1101 fiber tracts NaN 0.005569 NaN"
]
},
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"display_table = table[['hemisphere_id', 'acronym', 'projection_volume', 'graph_order']].pivot(index='graph_order', columns='hemisphere_id')\n",
"# display_table.columns = ['structure','L', 'R']\n",
"display_table.columns = display_table.columns.droplevel(0)\n",
"display_table.rename(columns={1:'L', 2:'R'})"
]
}
],
"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.15"
}
},
"nbformat": 4,
"nbformat_minor": 1
}