TestingLoopStuff.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The autoreload extension is already loaded. To reload it, use:\n",
      "  %reload_ext autoreload\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>experiment_id</th>\n",
       "      <th>experiment_container_id</th>\n",
       "      <th>targeted_structure</th>\n",
       "      <th>imaging_depth</th>\n",
       "      <th>cre_line</th>\n",
       "      <th>reporter_line</th>\n",
       "      <th>full_genotype</th>\n",
       "      <th>session_type</th>\n",
       "      <th>donor_id</th>\n",
       "      <th>specimen_id</th>\n",
       "      <th>experiment_date</th>\n",
       "      <th>experiment_datetime</th>\n",
       "      <th>first_session</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>644942849</td>\n",
       "      <td>644919226</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_A</td>\n",
       "      <td>329071</td>\n",
       "      <td>596175193</td>\n",
       "      <td>10/24/2017 10:32</td>\n",
       "      <td>2017-10-24 10:00:32</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>645035903</td>\n",
       "      <td>644919226</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_B</td>\n",
       "      <td>329071</td>\n",
       "      <td>596175193</td>\n",
       "      <td>10/25/2017 10:34</td>\n",
       "      <td>2017-10-25 10:00:34</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>645086795</td>\n",
       "      <td>644919226</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_C</td>\n",
       "      <td>329071</td>\n",
       "      <td>596175193</td>\n",
       "      <td>10/26/2017 10:27</td>\n",
       "      <td>2017-10-26 10:00:27</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>645362806</td>\n",
       "      <td>644919226</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_D</td>\n",
       "      <td>329071</td>\n",
       "      <td>596175193</td>\n",
       "      <td>10/30/2017 11:41</td>\n",
       "      <td>2017-10-30 11:00:41</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>646922970</td>\n",
       "      <td>646555436</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_A</td>\n",
       "      <td>330982</td>\n",
       "      <td>596393048</td>\n",
       "      <td>11/7/2017 14:19</td>\n",
       "      <td>2017-11-07 14:00:19</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>647108734</td>\n",
       "      <td>646555436</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_B</td>\n",
       "      <td>330982</td>\n",
       "      <td>596393048</td>\n",
       "      <td>11/8/2017 11:56</td>\n",
       "      <td>2017-11-08 11:00:56</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>647551128</td>\n",
       "      <td>646555436</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_C</td>\n",
       "      <td>330982</td>\n",
       "      <td>596393048</td>\n",
       "      <td>11/9/2017 11:48</td>\n",
       "      <td>2017-11-09 11:00:48</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>647887770</td>\n",
       "      <td>646555436</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_D</td>\n",
       "      <td>330982</td>\n",
       "      <td>596393048</td>\n",
       "      <td>11/10/2017 13:06</td>\n",
       "      <td>2017-11-10 13:00:06</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>648647430</td>\n",
       "      <td>648562391</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_A</td>\n",
       "      <td>330982</td>\n",
       "      <td>596393048</td>\n",
       "      <td>11/15/2017 11:58</td>\n",
       "      <td>2017-11-15 11:00:58</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>649118720</td>\n",
       "      <td>648562391</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_B</td>\n",
       "      <td>330982</td>\n",
       "      <td>596393048</td>\n",
       "      <td>11/16/2017 11:45</td>\n",
       "      <td>2017-11-16 11:00:45</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>649318212</td>\n",
       "      <td>648562391</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_C</td>\n",
       "      <td>330982</td>\n",
       "      <td>596393048</td>\n",
       "      <td>11/17/2017 12:22</td>\n",
       "      <td>2017-11-17 12:00:22</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>652844352</td>\n",
       "      <td>652784528</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_A</td>\n",
       "      <td>333706</td>\n",
       "      <td>597617440</td>\n",
       "      <td>12/8/2017 11:25</td>\n",
       "      <td>2017-12-08 11:00:25</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>653053906</td>\n",
       "      <td>652784528</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_C</td>\n",
       "      <td>333706</td>\n",
       "      <td>597617440</td>\n",
       "      <td>12/12/2017 12:33</td>\n",
       "      <td>2017-12-12 12:00:33</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>653123781</td>\n",
       "      <td>652784528</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_D</td>\n",
       "      <td>333706</td>\n",
       "      <td>597617440</td>\n",
       "      <td>12/13/2017 11:20</td>\n",
       "      <td>2017-12-13 11:00:20</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>639253368</td>\n",
       "      <td>639001089</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_A</td>\n",
       "      <td>334310</td>\n",
       "      <td>599659785</td>\n",
       "      <td>9/28/2017 14:14</td>\n",
       "      <td>2017-09-28 14:00:14</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>639438856</td>\n",
       "      <td>639001089</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_B</td>\n",
       "      <td>334310</td>\n",
       "      <td>599659785</td>\n",
       "      <td>9/29/2017 13:53</td>\n",
       "      <td>2017-09-29 13:00:53</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>639769395</td>\n",
       "      <td>639001089</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_C</td>\n",
       "      <td>334310</td>\n",
       "      <td>599659785</td>\n",
       "      <td>10/2/2017 12:49</td>\n",
       "      <td>2017-10-02 12:00:49</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>639932228</td>\n",
       "      <td>639001089</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_D</td>\n",
       "      <td>334310</td>\n",
       "      <td>599659785</td>\n",
       "      <td>10/3/2017 12:56</td>\n",
       "      <td>2017-10-03 12:00:56</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>661423848</td>\n",
       "      <td>661409179</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_A</td>\n",
       "      <td>355469</td>\n",
       "      <td>643316601</td>\n",
       "      <td>2/6/2018 15:03</td>\n",
       "      <td>2018-02-06 15:00:03</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>663771245</td>\n",
       "      <td>661409179</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_B</td>\n",
       "      <td>355469</td>\n",
       "      <td>643316601</td>\n",
       "      <td>2/7/2018 13:40</td>\n",
       "      <td>2018-02-07 13:00:40</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>663773621</td>\n",
       "      <td>661409179</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_C</td>\n",
       "      <td>355469</td>\n",
       "      <td>643316601</td>\n",
       "      <td>2/14/2018 14:44</td>\n",
       "      <td>2018-02-14 14:00:44</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>665286182</td>\n",
       "      <td>661409179</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_D</td>\n",
       "      <td>355469</td>\n",
       "      <td>643316601</td>\n",
       "      <td>2/19/2018 14:51</td>\n",
       "      <td>2018-02-19 14:00:51</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>670396087</td>\n",
       "      <td>670266085</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_A</td>\n",
       "      <td>355471</td>\n",
       "      <td>644831080</td>\n",
       "      <td>3/6/2018 13:37</td>\n",
       "      <td>2018-03-06 13:00:37</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>671152642</td>\n",
       "      <td>670266085</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_B</td>\n",
       "      <td>355471</td>\n",
       "      <td>644831080</td>\n",
       "      <td>3/8/2018 12:48</td>\n",
       "      <td>2018-03-08 12:00:48</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>672185644</td>\n",
       "      <td>670266085</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_D</td>\n",
       "      <td>355471</td>\n",
       "      <td>644831080</td>\n",
       "      <td>3/12/2018 12:28</td>\n",
       "      <td>2018-03-12 12:00:28</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>672584839</td>\n",
       "      <td>670266085</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_C</td>\n",
       "      <td>355471</td>\n",
       "      <td>644831080</td>\n",
       "      <td>3/13/2018 10:47</td>\n",
       "      <td>2018-03-13 10:00:47</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>685744008</td>\n",
       "      <td>682951696</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_A</td>\n",
       "      <td>369316</td>\n",
       "      <td>657448350</td>\n",
       "      <td>4/17/2018 11:43</td>\n",
       "      <td>2018-04-17 11:00:43</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>686726085</td>\n",
       "      <td>682951696</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_C</td>\n",
       "      <td>369316</td>\n",
       "      <td>657448350</td>\n",
       "      <td>4/19/2018 10:41</td>\n",
       "      <td>2018-04-19 10:00:41</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>695471168</td>\n",
       "      <td>695444116</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_A</td>\n",
       "      <td>363887</td>\n",
       "      <td>652073919</td>\n",
       "      <td>5/8/2018 14:39</td>\n",
       "      <td>2018-05-08 14:00:39</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>696136550</td>\n",
       "      <td>695444116</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_B</td>\n",
       "      <td>363887</td>\n",
       "      <td>652073919</td>\n",
       "      <td>5/9/2018 14:54</td>\n",
       "      <td>2018-05-09 14:00:54</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>698244621</td>\n",
       "      <td>695444116</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_C</td>\n",
       "      <td>363887</td>\n",
       "      <td>652073919</td>\n",
       "      <td>5/15/2018 13:56</td>\n",
       "      <td>2018-05-15 13:00:56</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>698724265</td>\n",
       "      <td>695444116</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_D</td>\n",
       "      <td>363887</td>\n",
       "      <td>652073919</td>\n",
       "      <td>5/16/2018 14:41</td>\n",
       "      <td>2018-05-16 14:00:41</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>700914412</td>\n",
       "      <td>700821114</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_A</td>\n",
       "      <td>363887</td>\n",
       "      <td>652073919</td>\n",
       "      <td>5/22/2018 15:12</td>\n",
       "      <td>2018-05-22 15:00:12</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>701325132</td>\n",
       "      <td>700821114</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_B</td>\n",
       "      <td>363887</td>\n",
       "      <td>652073919</td>\n",
       "      <td>5/23/2018 15:33</td>\n",
       "      <td>2018-05-23 15:00:33</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>702134928</td>\n",
       "      <td>700821114</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_C</td>\n",
       "      <td>363887</td>\n",
       "      <td>652073919</td>\n",
       "      <td>5/24/2018 14:27</td>\n",
       "      <td>2018-05-24 14:00:27</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>702723649</td>\n",
       "      <td>700821114</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_D</td>\n",
       "      <td>363887</td>\n",
       "      <td>652073919</td>\n",
       "      <td>5/25/2018 14:51</td>\n",
       "      <td>2018-05-25 14:00:51</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>692342909</td>\n",
       "      <td>692315205</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_A</td>\n",
       "      <td>369320</td>\n",
       "      <td>656813113</td>\n",
       "      <td>4/30/2018 16:09</td>\n",
       "      <td>2018-04-30 16:00:09</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>692841424</td>\n",
       "      <td>692315205</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_B</td>\n",
       "      <td>369320</td>\n",
       "      <td>656813113</td>\n",
       "      <td>5/1/2018 15:46</td>\n",
       "      <td>2018-05-01 15:00:46</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>693272975</td>\n",
       "      <td>692315205</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_C</td>\n",
       "      <td>369320</td>\n",
       "      <td>656813113</td>\n",
       "      <td>5/2/2018 15:23</td>\n",
       "      <td>2018-05-02 15:00:23</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>693862238</td>\n",
       "      <td>692315205</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_D</td>\n",
       "      <td>369320</td>\n",
       "      <td>656813113</td>\n",
       "      <td>5/3/2018 14:50</td>\n",
       "      <td>2018-05-03 14:00:50</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>712178916</td>\n",
       "      <td>712038821</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_A</td>\n",
       "      <td>373723</td>\n",
       "      <td>660049533</td>\n",
       "      <td>6/20/2018 13:11</td>\n",
       "      <td>2018-06-20 13:00:11</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>712860764</td>\n",
       "      <td>712038821</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_B</td>\n",
       "      <td>373723</td>\n",
       "      <td>660049533</td>\n",
       "      <td>6/21/2018 13:02</td>\n",
       "      <td>2018-06-21 13:00:02</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>713525580</td>\n",
       "      <td>712038821</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_C</td>\n",
       "      <td>373723</td>\n",
       "      <td>660049533</td>\n",
       "      <td>6/22/2018 11:04</td>\n",
       "      <td>2018-06-22 11:00:04</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>714126693</td>\n",
       "      <td>712038821</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_D</td>\n",
       "      <td>373723</td>\n",
       "      <td>660049533</td>\n",
       "      <td>6/25/2018 11:10</td>\n",
       "      <td>2018-06-25 11:00:10</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>715161256</td>\n",
       "      <td>715027436</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_A</td>\n",
       "      <td>373723</td>\n",
       "      <td>660049533</td>\n",
       "      <td>6/27/2018 11:35</td>\n",
       "      <td>2018-06-27 11:00:35</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>715887497</td>\n",
       "      <td>715027436</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_B</td>\n",
       "      <td>373723</td>\n",
       "      <td>660049533</td>\n",
       "      <td>6/28/2018 11:58</td>\n",
       "      <td>2018-06-28 11:00:58</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>716327871</td>\n",
       "      <td>715027436</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_C</td>\n",
       "      <td>373723</td>\n",
       "      <td>660049533</td>\n",
       "      <td>6/29/2018 12:55</td>\n",
       "      <td>2018-06-29 12:00:55</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>716600289</td>\n",
       "      <td>715027436</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Vip-IRES-Cre</td>\n",
       "      <td>Ai148</td>\n",
       "      <td>Vip-IRES-Cre;Ai148</td>\n",
       "      <td>behavior_session_D</td>\n",
       "      <td>373723</td>\n",
       "      <td>660049533</td>\n",
       "      <td>7/2/2018 13:20</td>\n",
       "      <td>2018-07-02 13:00:20</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>715228642</td>\n",
       "      <td>715094648</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_A</td>\n",
       "      <td>384942</td>\n",
       "      <td>687987489</td>\n",
       "      <td>6/27/2018 13:08</td>\n",
       "      <td>2018-06-27 13:00:08</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>715887471</td>\n",
       "      <td>715094648</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_B</td>\n",
       "      <td>384942</td>\n",
       "      <td>687987489</td>\n",
       "      <td>6/28/2018 15:34</td>\n",
       "      <td>2018-06-28 15:00:34</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>716337289</td>\n",
       "      <td>715094648</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_C</td>\n",
       "      <td>384942</td>\n",
       "      <td>687987489</td>\n",
       "      <td>6/29/2018 14:27</td>\n",
       "      <td>2018-06-29 14:00:27</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>716602547</td>\n",
       "      <td>715094648</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_D</td>\n",
       "      <td>384942</td>\n",
       "      <td>687987489</td>\n",
       "      <td>7/2/2018 14:58</td>\n",
       "      <td>2018-07-02 14:00:58</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>720001924</td>\n",
       "      <td>719860866</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_A</td>\n",
       "      <td>384942</td>\n",
       "      <td>687987489</td>\n",
       "      <td>7/13/2018 14:33</td>\n",
       "      <td>2018-07-13 14:00:33</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>720793118</td>\n",
       "      <td>719860866</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_B</td>\n",
       "      <td>384942</td>\n",
       "      <td>687987489</td>\n",
       "      <td>7/17/2018 14:53</td>\n",
       "      <td>2018-07-17 14:00:53</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>723064523</td>\n",
       "      <td>719860866</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_C</td>\n",
       "      <td>384942</td>\n",
       "      <td>687987489</td>\n",
       "      <td>7/20/2018 15:14</td>\n",
       "      <td>2018-07-20 15:00:14</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>723750115</td>\n",
       "      <td>719860866</td>\n",
       "      <td>VISp</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_D</td>\n",
       "      <td>384942</td>\n",
       "      <td>687987489</td>\n",
       "      <td>7/23/2018 13:48</td>\n",
       "      <td>2018-07-23 13:00:48</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>719321260</td>\n",
       "      <td>719538773</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_A</td>\n",
       "      <td>385255</td>\n",
       "      <td>685152008</td>\n",
       "      <td>7/12/2018 10:27</td>\n",
       "      <td>2018-07-12 10:00:27</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>719996589</td>\n",
       "      <td>719538773</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_B</td>\n",
       "      <td>385255</td>\n",
       "      <td>685152008</td>\n",
       "      <td>7/13/2018 10:13</td>\n",
       "      <td>2018-07-13 10:00:13</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>723748162</td>\n",
       "      <td>719538773</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_C</td>\n",
       "      <td>385255</td>\n",
       "      <td>685152008</td>\n",
       "      <td>7/23/2018 11:18</td>\n",
       "      <td>2018-07-23 11:00:18</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>723037901</td>\n",
       "      <td>719538773</td>\n",
       "      <td>VISal</td>\n",
       "      <td>175</td>\n",
       "      <td>Slc17a7-IRES2-Cre</td>\n",
       "      <td>Camk2a-tTA;Ai93</td>\n",
       "      <td>Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93</td>\n",
       "      <td>behavior_session_D</td>\n",
       "      <td>385255</td>\n",
       "      <td>685152008</td>\n",
       "      <td>7/20/2018 13:47</td>\n",
       "      <td>2018-07-20 13:00:47</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    experiment_id  experiment_container_id targeted_structure  imaging_depth  \\\n",
       "0       644942849                644919226               VISp            175   \n",
       "1       645035903                644919226               VISp            175   \n",
       "2       645086795                644919226               VISp            175   \n",
       "3       645362806                644919226               VISp            175   \n",
       "4       646922970                646555436               VISp            175   \n",
       "5       647108734                646555436               VISp            175   \n",
       "6       647551128                646555436               VISp            175   \n",
       "7       647887770                646555436               VISp            175   \n",
       "8       648647430                648562391              VISal            175   \n",
       "9       649118720                648562391              VISal            175   \n",
       "10      649318212                648562391              VISal            175   \n",
       "11      652844352                652784528               VISp            175   \n",
       "12      653053906                652784528               VISp            175   \n",
       "13      653123781                652784528               VISp            175   \n",
       "14      639253368                639001089               VISp            175   \n",
       "15      639438856                639001089               VISp            175   \n",
       "16      639769395                639001089               VISp            175   \n",
       "17      639932228                639001089               VISp            175   \n",
       "18      661423848                661409179              VISal            175   \n",
       "19      663771245                661409179              VISal            175   \n",
       "20      663773621                661409179              VISal            175   \n",
       "21      665286182                661409179              VISal            175   \n",
       "22      670396087                670266085               VISp            175   \n",
       "23      671152642                670266085               VISp            175   \n",
       "24      672185644                670266085               VISp            175   \n",
       "25      672584839                670266085               VISp            175   \n",
       "26      685744008                682951696               VISp            175   \n",
       "27      686726085                682951696               VISp            175   \n",
       "28      695471168                695444116               VISp            175   \n",
       "29      696136550                695444116               VISp            175   \n",
       "30      698244621                695444116               VISp            175   \n",
       "31      698724265                695444116               VISp            175   \n",
       "32      700914412                700821114              VISal            175   \n",
       "33      701325132                700821114              VISal            175   \n",
       "34      702134928                700821114              VISal            175   \n",
       "35      702723649                700821114              VISal            175   \n",
       "36      692342909                692315205              VISal            175   \n",
       "37      692841424                692315205              VISal            175   \n",
       "38      693272975                692315205              VISal            175   \n",
       "39      693862238                692315205              VISal            175   \n",
       "40      712178916                712038821               VISp            175   \n",
       "41      712860764                712038821               VISp            175   \n",
       "42      713525580                712038821               VISp            175   \n",
       "43      714126693                712038821               VISp            175   \n",
       "44      715161256                715027436              VISal            175   \n",
       "45      715887497                715027436              VISal            175   \n",
       "46      716327871                715027436              VISal            175   \n",
       "47      716600289                715027436              VISal            175   \n",
       "48      715228642                715094648              VISal            175   \n",
       "49      715887471                715094648              VISal            175   \n",
       "50      716337289                715094648              VISal            175   \n",
       "51      716602547                715094648              VISal            175   \n",
       "52      720001924                719860866               VISp            175   \n",
       "53      720793118                719860866               VISp            175   \n",
       "54      723064523                719860866               VISp            175   \n",
       "55      723750115                719860866               VISp            175   \n",
       "56      719321260                719538773              VISal            175   \n",
       "57      719996589                719538773              VISal            175   \n",
       "58      723748162                719538773              VISal            175   \n",
       "59      723037901                719538773              VISal            175   \n",
       "\n",
       "             cre_line    reporter_line                      full_genotype  \\\n",
       "0        Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "1        Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "2        Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "3        Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "4        Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "5        Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "6        Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "7        Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "8        Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "9        Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "10       Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "11  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "12  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "13  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "14  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "15  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "16  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "17  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "18  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "19  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "20  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "21  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "22  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "23  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "24  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "25  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "26  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "27  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "28       Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "29       Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "30       Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "31       Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "32       Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "33       Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "34       Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "35       Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "36  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "37  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "38  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "39  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "40       Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "41       Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "42       Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "43       Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "44       Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "45       Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "46       Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "47       Vip-IRES-Cre            Ai148                 Vip-IRES-Cre;Ai148   \n",
       "48  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "49  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "50  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "51  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "52  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "53  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "54  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "55  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "56  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "57  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "58  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "59  Slc17a7-IRES2-Cre  Camk2a-tTA;Ai93  Slc17a7-IRES2-Cre;Camk2a-tTA;Ai93   \n",
       "\n",
       "          session_type  donor_id  specimen_id   experiment_date  \\\n",
       "0   behavior_session_A    329071    596175193  10/24/2017 10:32   \n",
       "1   behavior_session_B    329071    596175193  10/25/2017 10:34   \n",
       "2   behavior_session_C    329071    596175193  10/26/2017 10:27   \n",
       "3   behavior_session_D    329071    596175193  10/30/2017 11:41   \n",
       "4   behavior_session_A    330982    596393048   11/7/2017 14:19   \n",
       "5   behavior_session_B    330982    596393048   11/8/2017 11:56   \n",
       "6   behavior_session_C    330982    596393048   11/9/2017 11:48   \n",
       "7   behavior_session_D    330982    596393048  11/10/2017 13:06   \n",
       "8   behavior_session_A    330982    596393048  11/15/2017 11:58   \n",
       "9   behavior_session_B    330982    596393048  11/16/2017 11:45   \n",
       "10  behavior_session_C    330982    596393048  11/17/2017 12:22   \n",
       "11  behavior_session_A    333706    597617440   12/8/2017 11:25   \n",
       "12  behavior_session_C    333706    597617440  12/12/2017 12:33   \n",
       "13  behavior_session_D    333706    597617440  12/13/2017 11:20   \n",
       "14  behavior_session_A    334310    599659785   9/28/2017 14:14   \n",
       "15  behavior_session_B    334310    599659785   9/29/2017 13:53   \n",
       "16  behavior_session_C    334310    599659785   10/2/2017 12:49   \n",
       "17  behavior_session_D    334310    599659785   10/3/2017 12:56   \n",
       "18  behavior_session_A    355469    643316601    2/6/2018 15:03   \n",
       "19  behavior_session_B    355469    643316601    2/7/2018 13:40   \n",
       "20  behavior_session_C    355469    643316601   2/14/2018 14:44   \n",
       "21  behavior_session_D    355469    643316601   2/19/2018 14:51   \n",
       "22  behavior_session_A    355471    644831080    3/6/2018 13:37   \n",
       "23  behavior_session_B    355471    644831080    3/8/2018 12:48   \n",
       "24  behavior_session_D    355471    644831080   3/12/2018 12:28   \n",
       "25  behavior_session_C    355471    644831080   3/13/2018 10:47   \n",
       "26  behavior_session_A    369316    657448350   4/17/2018 11:43   \n",
       "27  behavior_session_C    369316    657448350   4/19/2018 10:41   \n",
       "28  behavior_session_A    363887    652073919    5/8/2018 14:39   \n",
       "29  behavior_session_B    363887    652073919    5/9/2018 14:54   \n",
       "30  behavior_session_C    363887    652073919   5/15/2018 13:56   \n",
       "31  behavior_session_D    363887    652073919   5/16/2018 14:41   \n",
       "32  behavior_session_A    363887    652073919   5/22/2018 15:12   \n",
       "33  behavior_session_B    363887    652073919   5/23/2018 15:33   \n",
       "34  behavior_session_C    363887    652073919   5/24/2018 14:27   \n",
       "35  behavior_session_D    363887    652073919   5/25/2018 14:51   \n",
       "36  behavior_session_A    369320    656813113   4/30/2018 16:09   \n",
       "37  behavior_session_B    369320    656813113    5/1/2018 15:46   \n",
       "38  behavior_session_C    369320    656813113    5/2/2018 15:23   \n",
       "39  behavior_session_D    369320    656813113    5/3/2018 14:50   \n",
       "40  behavior_session_A    373723    660049533   6/20/2018 13:11   \n",
       "41  behavior_session_B    373723    660049533   6/21/2018 13:02   \n",
       "42  behavior_session_C    373723    660049533   6/22/2018 11:04   \n",
       "43  behavior_session_D    373723    660049533   6/25/2018 11:10   \n",
       "44  behavior_session_A    373723    660049533   6/27/2018 11:35   \n",
       "45  behavior_session_B    373723    660049533   6/28/2018 11:58   \n",
       "46  behavior_session_C    373723    660049533   6/29/2018 12:55   \n",
       "47  behavior_session_D    373723    660049533    7/2/2018 13:20   \n",
       "48  behavior_session_A    384942    687987489   6/27/2018 13:08   \n",
       "49  behavior_session_B    384942    687987489   6/28/2018 15:34   \n",
       "50  behavior_session_C    384942    687987489   6/29/2018 14:27   \n",
       "51  behavior_session_D    384942    687987489    7/2/2018 14:58   \n",
       "52  behavior_session_A    384942    687987489   7/13/2018 14:33   \n",
       "53  behavior_session_B    384942    687987489   7/17/2018 14:53   \n",
       "54  behavior_session_C    384942    687987489   7/20/2018 15:14   \n",
       "55  behavior_session_D    384942    687987489   7/23/2018 13:48   \n",
       "56  behavior_session_A    385255    685152008   7/12/2018 10:27   \n",
       "57  behavior_session_B    385255    685152008   7/13/2018 10:13   \n",
       "58  behavior_session_C    385255    685152008   7/23/2018 11:18   \n",
       "59  behavior_session_D    385255    685152008   7/20/2018 13:47   \n",
       "\n",
       "   experiment_datetime  first_session  \n",
       "0  2017-10-24 10:00:32           True  \n",
       "1  2017-10-25 10:00:34           True  \n",
       "2  2017-10-26 10:00:27           True  \n",
       "3  2017-10-30 11:00:41           True  \n",
       "4  2017-11-07 14:00:19           True  \n",
       "5  2017-11-08 11:00:56           True  \n",
       "6  2017-11-09 11:00:48           True  \n",
       "7  2017-11-10 13:00:06           True  \n",
       "8  2017-11-15 11:00:58          False  \n",
       "9  2017-11-16 11:00:45          False  \n",
       "10 2017-11-17 12:00:22          False  \n",
       "11 2017-12-08 11:00:25           True  \n",
       "12 2017-12-12 12:00:33           True  \n",
       "13 2017-12-13 11:00:20           True  \n",
       "14 2017-09-28 14:00:14           True  \n",
       "15 2017-09-29 13:00:53           True  \n",
       "16 2017-10-02 12:00:49           True  \n",
       "17 2017-10-03 12:00:56           True  \n",
       "18 2018-02-06 15:00:03           True  \n",
       "19 2018-02-07 13:00:40           True  \n",
       "20 2018-02-14 14:00:44           True  \n",
       "21 2018-02-19 14:00:51           True  \n",
       "22 2018-03-06 13:00:37           True  \n",
       "23 2018-03-08 12:00:48           True  \n",
       "24 2018-03-12 12:00:28           True  \n",
       "25 2018-03-13 10:00:47           True  \n",
       "26 2018-04-17 11:00:43           True  \n",
       "27 2018-04-19 10:00:41           True  \n",
       "28 2018-05-08 14:00:39           True  \n",
       "29 2018-05-09 14:00:54           True  \n",
       "30 2018-05-15 13:00:56           True  \n",
       "31 2018-05-16 14:00:41           True  \n",
       "32 2018-05-22 15:00:12          False  \n",
       "33 2018-05-23 15:00:33          False  \n",
       "34 2018-05-24 14:00:27          False  \n",
       "35 2018-05-25 14:00:51          False  \n",
       "36 2018-04-30 16:00:09           True  \n",
       "37 2018-05-01 15:00:46           True  \n",
       "38 2018-05-02 15:00:23           True  \n",
       "39 2018-05-03 14:00:50           True  \n",
       "40 2018-06-20 13:00:11           True  \n",
       "41 2018-06-21 13:00:02           True  \n",
       "42 2018-06-22 11:00:04           True  \n",
       "43 2018-06-25 11:00:10           True  \n",
       "44 2018-06-27 11:00:35          False  \n",
       "45 2018-06-28 11:00:58          False  \n",
       "46 2018-06-29 12:00:55          False  \n",
       "47 2018-07-02 13:00:20          False  \n",
       "48 2018-06-27 13:00:08           True  \n",
       "49 2018-06-28 15:00:34           True  \n",
       "50 2018-06-29 14:00:27           True  \n",
       "51 2018-07-02 14:00:58           True  \n",
       "52 2018-07-13 14:00:33          False  \n",
       "53 2018-07-17 14:00:53          False  \n",
       "54 2018-07-20 15:00:14          False  \n",
       "55 2018-07-23 13:00:48          False  \n",
       "56 2018-07-12 10:00:27           True  \n",
       "57 2018-07-13 10:00:13           True  \n",
       "58 2018-07-23 11:00:18           True  \n",
       "59 2018-07-20 13:00:47           True  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%load_ext autoreload\n",
    "%autoreload 2\n",
    "import matplotlib as mpl\n",
    "%matplotlib inline\n",
    "import scipy as sp\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "# sometimes order maters on these\n",
    "import matplotlib.pyplot as plt\n",
    "from mpl_toolkits.mplot3d import Axes3D\n",
    "import oBehave.plotting_stuff as obps\n",
    "import oBehave.helperfunctions as obhf\n",
    "import oBehave.neural_analysis as obna\n",
    "import oBehave.behavior_anaylsis as obba\n",
    "import sklearn.decomposition as decomp\n",
    "\n",
    "import time\n",
    "\n",
    "from visual_behavior.ophys.dataset.visual_behavior_ophys_dataset import VisualBehaviorOphysDataset\n",
    "from visual_behavior.ophys.response_analysis.utilities import get_trace_around_timepoint,get_nearest_frame\n",
    "from visual_behavior.ophys.response_analysis.response_analysis import ResponseAnalysis\n",
    "\n",
    "experiment_id = 639438856\n",
    "manifest = obhf.load_manifest()\n",
    "obba.includeNovelSession(manifest)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "644942849\n",
      "loading trial response dataframe\n",
      "loading flash response dataframe\n",
      "12\n",
      "0.699155092239\n",
      "0.690745830536\n",
      "0.691195011139\n",
      "0.690325975418\n",
      "0.691327810287\n",
      "0.691833972931\n",
      "0.690372943878\n",
      "0.692614078522\n",
      "0.690312862396\n",
      "0.69141292572\n",
      "0.690892934799\n",
      "0.690749168396\n",
      "645035903\n",
      "loading trial response dataframe\n",
      "loading flash response dataframe\n",
      "11\n",
      "0.656512975693\n",
      "0.649142980576\n",
      "0.649562120438\n",
      "0.648685932159\n",
      "0.649038076401\n"
     ]
    },
    {
     "ename": "KeyboardInterrupt",
     "evalue": "",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m\u001b[0m",
      "\u001b[0;31mKeyboardInterrupt\u001b[0mTraceback (most recent call last)",
      "\u001b[0;32m<ipython-input-7-94b9c47d2d4a>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m     32\u001b[0m         \u001b[0mcr\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'SparAve'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcompute_lifetime_sparseness\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mim_means\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     33\u001b[0m         \u001b[0;32mfor\u001b[0m \u001b[0mrr\u001b[0m \u001b[0;32min\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;36m2\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;36m3\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;36m4\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;36m5\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 34\u001b[0;31m             \u001b[0mim_means\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0mFR\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mFR\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'image_name'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m==\u001b[0m\u001b[0mimage\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m&\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mFR\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'cell'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m==\u001b[0m\u001b[0mii\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m&\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mFR\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'repeats'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m==\u001b[0m\u001b[0mrr\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmean_response\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmean\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mfor\u001b[0m \u001b[0mimage\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mnp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0munique\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mFR\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'image_name'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     35\u001b[0m             \u001b[0mcr\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'Spar'\u001b[0m\u001b[0;34m+\u001b[0m\u001b[0mstr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mrr\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcompute_lifetime_sparseness\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mim_means\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     36\u001b[0m         \u001b[0mim_means\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0mFR\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mFR\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'image_name'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m==\u001b[0m\u001b[0mimage\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m&\u001b[0m\u001b[0;34m(\u001b[0m \u001b[0mFR\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'cell'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m==\u001b[0m\u001b[0mii\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m&\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mFR\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'repeats'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m==\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m&\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mFR\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'response_type'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m==\u001b[0m\u001b[0;34m'HIT'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmean_response\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmean\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mfor\u001b[0m \u001b[0mimage\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mnp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0munique\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mFR\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'image_name'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/home/ec2-user/anaconda3/envs/python2/lib/python2.7/site-packages/pandas/core/ops.pyc\u001b[0m in \u001b[0;36mwrapper\u001b[0;34m(self, other, axis)\u001b[0m\n\u001b[1;32m    877\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    878\u001b[0m             \u001b[0;32mwith\u001b[0m \u001b[0mnp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0merrstate\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mall\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'ignore'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 879\u001b[0;31m                 \u001b[0mres\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mna_op\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mvalues\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mother\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    880\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mis_scalar\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mres\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    881\u001b[0m                 raise TypeError('Could not compare {typ} type with Series'\n",
      "\u001b[0;32m/home/ec2-user/anaconda3/envs/python2/lib/python2.7/site-packages/pandas/core/ops.pyc\u001b[0m in \u001b[0;36mna_op\u001b[0;34m(x, y)\u001b[0m\n\u001b[1;32m    814\u001b[0m             \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    815\u001b[0m                 \u001b[0;32mwith\u001b[0m \u001b[0mnp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0merrstate\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mall\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'ignore'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 816\u001b[0;31m                     \u001b[0mresult\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mgetattr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mx\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0my\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    817\u001b[0m                 \u001b[0;32mif\u001b[0m \u001b[0mresult\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0mNotImplemented\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    818\u001b[0m                     \u001b[0;32mraise\u001b[0m \u001b[0mTypeError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"invalid type comparison\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/home/ec2-user/anaconda3/envs/python2/lib/python2.7/site-packages/numpy/core/numeric.pyc\u001b[0m in \u001b[0;36m__exit__\u001b[0;34m(self, *exc_info)\u001b[0m\n\u001b[1;32m   3068\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3069\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m__exit__\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m*\u001b[0m\u001b[0mexc_info\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3070\u001b[0;31m         \u001b[0mseterr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m**\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0moldstate\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   3071\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcall\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0m_Unspecified\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3072\u001b[0m             \u001b[0mseterrcall\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0moldcall\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/home/ec2-user/anaconda3/envs/python2/lib/python2.7/site-packages/numpy/core/numeric.pyc\u001b[0m in \u001b[0;36mseterr\u001b[0;34m(all, divide, over, under, invalid)\u001b[0m\n\u001b[1;32m   2746\u001b[0m     \u001b[0mold\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mgeterr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2747\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2748\u001b[0;31m     \u001b[0;32mif\u001b[0m \u001b[0mdivide\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2749\u001b[0m         \u001b[0mdivide\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mall\u001b[0m \u001b[0;32mor\u001b[0m \u001b[0mold\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'divide'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2750\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0mover\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m: "
     ]
    }
   ],
   "source": [
    "def compute_lifetime_sparseness(image_responses):\n",
    "    # image responses should be an array of the trial averaged responses to each image\n",
    "    # sparseness = 1-(sum of trial averaged responses to images / N)squared / (sum of (squared mean responses / n)) / (1-(1/N))\n",
    "    # N = number of images\n",
    "    # Modified shamelessly from allen institute code\n",
    "    N = float(len(image_responses))\n",
    "    ls = ((1-(1/N) * ((np.power(np.abs(image_responses).sum(axis=0),2)) / (np.power(image_responses,2).sum(axis=0)))) / (1-(1/N)))\n",
    "    return ls\n",
    "\n",
    "\n",
    "keylist = ['experiment_id','cell_indices','cell_specimen_ids','session_type','cre_line',\n",
    "           'SparAve','Spar1','Spar2','Spar3','Spar4','Spar5','Shit','Smiss']\n",
    "cr = {k:[] for k in keylist}\n",
    "for ex,row in manifest.iterrows():\n",
    "    if not row['first_session']:\n",
    "        continue\n",
    "    print(row['experiment_id'])\n",
    "    dataset= VisualBehaviorOphysDataset(experiment_id=row['experiment_id'], cache_dir=obhf.drive_path)\n",
    "    analysis = ResponseAnalysis(dataset)\n",
    "    FR = obba.includeAddRepeats(analysis.flash_response_df,dataset.all_trials)\n",
    "    unique_cells = np.unique(FR['cell'])\n",
    "    unique_images = np.unique(FR['image_name'])\n",
    "    print(len(unique_cells))\n",
    "    for ii in unique_cells:\n",
    "        stime = time.time()\n",
    "        cr['experiment_id'].append(row['experiment_id'])\n",
    "        cr['cell_indices'].append(dataset.cell_indices[ii])\n",
    "        cr['cell_specimen_ids'].append(dataset.cell_specimen_ids[ii])\n",
    "        cr['cre_line'].append(row['cre_line'])\n",
    "        cr['session_type'].append(row['session_type'])\n",
    "        im_means = [FR[(FR['image_name']==image)&( FR['cell']==ii)].mean_response.mean() for image in np.unique(FR['image_name'])]\n",
    "        cr['SparAve'].append(compute_lifetime_sparseness(im_means))\n",
    "        for rr in [1,2,3,4,5]:\n",
    "            im_means = [FR[(FR['image_name']==image)&(FR['cell']==ii)&(FR['repeats']==rr)].mean_response.mean() for image in np.unique(FR['image_name'])]\n",
    "            cr['Spar'+str(rr)].append(compute_lifetime_sparseness(im_means))\n",
    "        im_means = [FR[(FR['image_name']==image)&( FR['cell']==ii)&(FR['repeats']==1)&(FR['response_type']=='HIT')].mean_response.mean() for image in np.unique(FR['image_name'])]\n",
    "        cr['Shit'].append(compute_lifetime_sparseness(im_means))\n",
    "        im_means = [FR[(FR['image_name']==image)&( FR['cell']==ii)&(FR['repeats']==1)&(FR['response_type']=='MISS')].mean_response.mean() for image in np.unique(FR['image_name'])]\n",
    "        cr['Smiss'].append(compute_lifetime_sparseness(im_means))\n",
    "        print(time.time()-stime)\n",
    "CellResp = pd.DataFrame(cr)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(60, 13)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "manifest.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "70.0"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "60*100*0.7 / 60."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "conda_python2",
   "language": "python",
   "name": "conda_python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.14"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}