dataframeHandling.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "human-crown",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>mass</th>\n",
       "      <th>charge</th>\n",
       "      <th>p</th>\n",
       "      <th>pdgId</th>\n",
       "      <th>status</th>\n",
       "      <th>pt</th>\n",
       "      <th>eta</th>\n",
       "      <th>phi</th>\n",
       "      <th>decayLength</th>\n",
       "      <th>ctau</th>\n",
       "      <th>...</th>\n",
       "      <th>trackPt</th>\n",
       "      <th>dR</th>\n",
       "      <th>trackPhi</th>\n",
       "      <th>trackEta</th>\n",
       "      <th>validHits</th>\n",
       "      <th>missingInnerHits</th>\n",
       "      <th>missingTrackHits</th>\n",
       "      <th>missingOuterHits</th>\n",
       "      <th>validLayers</th>\n",
       "      <th>layersNoMeasurements</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>700.048</td>\n",
       "      <td>1</td>\n",
       "      <td>1189.790</td>\n",
       "      <td>1000024</td>\n",
       "      <td>62.0</td>\n",
       "      <td>109.149</td>\n",
       "      <td>3.079860</td>\n",
       "      <td>2.742540</td>\n",
       "      <td>167.75800</td>\n",
       "      <td>98.7050</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>700.048</td>\n",
       "      <td>-1</td>\n",
       "      <td>134.310</td>\n",
       "      <td>-1000024</td>\n",
       "      <td>62.0</td>\n",
       "      <td>134.275</td>\n",
       "      <td>-0.022846</td>\n",
       "      <td>-0.234468</td>\n",
       "      <td>19.89770</td>\n",
       "      <td>103.7100</td>\n",
       "      <td>...</td>\n",
       "      <td>52.1775</td>\n",
       "      <td>0.001520</td>\n",
       "      <td>-0.235915</td>\n",
       "      <td>-0.022381</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>700.048</td>\n",
       "      <td>1</td>\n",
       "      <td>717.605</td>\n",
       "      <td>1000024</td>\n",
       "      <td>62.0</td>\n",
       "      <td>306.623</td>\n",
       "      <td>1.494320</td>\n",
       "      <td>2.455400</td>\n",
       "      <td>24.18880</td>\n",
       "      <td>23.5970</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>700.048</td>\n",
       "      <td>1</td>\n",
       "      <td>530.192</td>\n",
       "      <td>1000024</td>\n",
       "      <td>62.0</td>\n",
       "      <td>526.916</td>\n",
       "      <td>-0.111461</td>\n",
       "      <td>1.445640</td>\n",
       "      <td>189.75800</td>\n",
       "      <td>250.5500</td>\n",
       "      <td>...</td>\n",
       "      <td>541.6250</td>\n",
       "      <td>0.000252</td>\n",
       "      <td>1.445530</td>\n",
       "      <td>-0.111233</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>700.048</td>\n",
       "      <td>-1</td>\n",
       "      <td>480.965</td>\n",
       "      <td>-1000024</td>\n",
       "      <td>62.0</td>\n",
       "      <td>283.369</td>\n",
       "      <td>-1.121270</td>\n",
       "      <td>0.710112</td>\n",
       "      <td>3.86992</td>\n",
       "      <td>5.6327</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       mass  charge         p    pdgId  status       pt       eta       phi  \\\n",
       "1   700.048       1  1189.790  1000024    62.0  109.149  3.079860  2.742540   \n",
       "6   700.048      -1   134.310 -1000024    62.0  134.275 -0.022846 -0.234468   \n",
       "8   700.048       1   717.605  1000024    62.0  306.623  1.494320  2.455400   \n",
       "27  700.048       1   530.192  1000024    62.0  526.916 -0.111461  1.445640   \n",
       "29  700.048      -1   480.965 -1000024    62.0  283.369 -1.121270  0.710112   \n",
       "\n",
       "    decayLength      ctau  ...   trackPt        dR  trackPhi  trackEta  \\\n",
       "1     167.75800   98.7050  ...    0.0000  0.000000  0.000000  0.000000   \n",
       "6      19.89770  103.7100  ...   52.1775  0.001520 -0.235915 -0.022381   \n",
       "8      24.18880   23.5970  ...    0.0000  0.000000  0.000000  0.000000   \n",
       "27    189.75800  250.5500  ...  541.6250  0.000252  1.445530 -0.111233   \n",
       "29      3.86992    5.6327  ...    0.0000  0.000000  0.000000  0.000000   \n",
       "\n",
       "    validHits  missingInnerHits  missingTrackHits  missingOuterHits  \\\n",
       "1         0.0               0.0               0.0               0.0   \n",
       "6         4.0               1.0               0.0               2.0   \n",
       "8         0.0               0.0               0.0               0.0   \n",
       "27       18.0               1.0               0.0               2.0   \n",
       "29        0.0               0.0               0.0               0.0   \n",
       "\n",
       "    validLayers  layersNoMeasurements  \n",
       "1           0.0                   0.0  \n",
       "6           4.0                   9.0  \n",
       "8           0.0                   0.0  \n",
       "27         14.0                   0.0  \n",
       "29          0.0                   0.0  \n",
       "\n",
       "[5 rows x 27 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "df = pd.read_table('data/charginosFullData.txt', index_col=False, names=['mass', 'charge', 'p', 'pdgId', 'status', 'pt', 'eta', 'phi', 'decayLength', 'ctau', 'beta', 'gamma', 'eventId', 'eventRun', 'eventLumiBlock', 'foundTrack', 'trackCharge', 'trackPt', 'dR', 'trackPhi', 'trackEta', 'validHits', 'missingInnerHits', 'missingTrackHits', 'missingOuterHits', 'validLayers', 'layersNoMeasurements'])\n",
    "\n",
    "charginos = df[df['mass'] == 700.048]\n",
    "\n",
    "hits = df.copy()\n",
    "hits = hits[hits['mass'] != 700.048]\n",
    "hits.dropna(inplace=True, axis=1)\n",
    "hits.rename({'mass' :'hits', 'ctau':'sub', 'ctau*boost':'trackerpart', 'validHits':'layer'}, axis = 1, inplace = True)\n",
    "\n",
    "charginos.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "dynamic-mainstream",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>hits</th>\n",
       "      <th>sub</th>\n",
       "      <th>trackerpart</th>\n",
       "      <th>layer</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>5.0</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>6.0</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>7.0</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>8.0</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>9.0</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>11.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>12.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>13.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>14.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>15.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>16.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>17.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>18.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>5.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>6.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>7.0</td>\n",
       "      <td>1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>8.0</td>\n",
       "      <td>1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>9.0</td>\n",
       "      <td>1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>11.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>12.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>13.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>14.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>15.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>16.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>17.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>18.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>19.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>20.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>21.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>22.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>23.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>24.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>25.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>5.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>6.0</td>\n",
       "      <td>1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>7.0</td>\n",
       "      <td>1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    hits  sub  trackerpart  layer\n",
       "0    0.0    0          0.0      0\n",
       "2    1.0    1          1.0      1\n",
       "3    2.0    1          1.0      2\n",
       "4    3.0    1          1.0      3\n",
       "5    4.0    1          1.0      4\n",
       "7    0.0    0          0.0      0\n",
       "9    1.0    1          1.0      1\n",
       "10   2.0    1          1.0      2\n",
       "11   3.0    1          1.0      3\n",
       "12   4.0    1          1.0      4\n",
       "13   5.0    1          3.0      1\n",
       "14   6.0    1          3.0      1\n",
       "15   7.0    1          3.0      1\n",
       "16   8.0    1          3.0      2\n",
       "17   9.0    1          3.0      3\n",
       "18  10.0    1          3.0      4\n",
       "19  11.0    1          5.0      1\n",
       "20  12.0    1          5.0      1\n",
       "21  13.0    1          5.0      2\n",
       "22  14.0    1          5.0      2\n",
       "23  15.0    1          5.0      3\n",
       "24  16.0    1          5.0      4\n",
       "25  17.0    1          5.0      5\n",
       "26  18.0    1          5.0      6\n",
       "28   0.0    0          0.0      0\n",
       "30   1.0    1          1.0      1\n",
       "31   2.0    1          2.0      2\n",
       "32   3.0    1          2.0      3\n",
       "34   1.0    1          1.0      1\n",
       "35   2.0    1          2.0      1\n",
       "36   3.0    1          2.0      2\n",
       "37   4.0    1          2.0      2\n",
       "38   5.0    1          2.0      3\n",
       "39   6.0    1          2.0      3\n",
       "40   7.0    1          4.0      2\n",
       "41   8.0    1          4.0      2\n",
       "42   9.0    1          4.0      3\n",
       "43  10.0    1          4.0      3\n",
       "44  11.0    1          6.0      1\n",
       "45  12.0    1          6.0      1\n",
       "46  13.0    1          6.0      2\n",
       "47  14.0    1          6.0      2\n",
       "48  15.0    1          6.0      3\n",
       "49  16.0    1          6.0      3\n",
       "50  17.0    1          6.0      3\n",
       "51  18.0    1          6.0      4\n",
       "52  19.0    1          6.0      5\n",
       "53  20.0    1          6.0      6\n",
       "54  21.0    1          6.0      7\n",
       "55  22.0    1          6.0      8\n",
       "56  23.0    1          6.0      8\n",
       "57  24.0    1          6.0      9\n",
       "58  25.0    1          6.0      9\n",
       "60   1.0    1          1.0      2\n",
       "61   2.0    1          2.0      1\n",
       "62   3.0    1          2.0      2\n",
       "63   4.0    1          2.0      2\n",
       "64   5.0    1          2.0      3\n",
       "65   6.0    1          4.0      1\n",
       "66   7.0    1          4.0      1"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hits.head(60)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "coastal-visibility",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "hitsDf          hit  subdetector  trackerPart  layerDisk...\n",
       "Name: 0, dtype: object"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def createHitsDataFrame(df):\n",
    "    tmpDf = pd.DataFrame(data=[[0,0,0,0]], columns=['hit', 'subdetector', 'trackerPart', 'layerDiskWheel'], index=['hit1'])\n",
    "    dfList = []\n",
    "    tmpSize = 0\n",
    "\n",
    "    for i in range(100):\n",
    "        wholeHit = df.iloc[i,:].values\n",
    "        hitNumber = df.iloc[i,:].values[0]\n",
    "\n",
    "        if hitNumber == 0 and tmpSize == 0:\n",
    "            dfList.append(tmpDf)\n",
    "\n",
    "        elif hitNumber == 0 and tmpSize != 0:\n",
    "            dfList.append(tmpDf)\n",
    "            tmpSize = 0\n",
    "            tmpDf = pd.DataFrame(data=[[0,0,0,0]], columns=['hit', 'subdetector', 'trackerPart', 'layerDiskWheel'], index=['hit1'])\n",
    "            dfList.append(tmpDf)\n",
    "\n",
    "        else:\n",
    "            if hitNumber == 1:\n",
    "                if tmpSize != 0:\n",
    "                    dfList.append(tmpDf)\n",
    "                tmpSize = 1\n",
    "                tmpDf = pd.DataFrame(data=[[wholeHit[0],wholeHit[1],wholeHit[2],wholeHit[3]]], columns=['hit', 'subdetector', 'trackerPart', 'layerDiskWheel'], index=['hit1'])\n",
    "\n",
    "            elif hitNumber > tmpSize:\n",
    "                tmpDf.loc['hit'+str(hitNumber)] = [wholeHit[0], wholeHit[1], wholeHit[2], wholeHit[3]]\n",
    "                tmpSize += 1\n",
    "\n",
    "            else:\n",
    "                print(tmpDf)\n",
    "                dfList.append(tmpDf)\n",
    "                tmpDf = pd.DataFrame(data=[[wholeHit[0],wholeHit[1],wholeHit[2],wholeHit[3]]], columns=['hit', 'subdetector', 'trackerPart', 'layerDiskWheel'], index=['hit1'])\n",
    "                tmpSize = 1\n",
    "\n",
    "    dfList.append(tmpDf)\n",
    "    dfDf = pd.DataFrame({'hitsDf': dfList})\n",
    "\n",
    "    return dfDf\n",
    "\n",
    "hitsDF = createHitsDataFrame(hits)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "comparative-class",
   "metadata": {},
   "outputs": [],
   "source": [
    "hitsDF = createHitsDataFrame(hits)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "italic-resort",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>hitsDf</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>hit  subdetector  trackerPart  layerDisk...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>hit  subdetector  trackerPart  layerDi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>hit  subdetector  trackerPart  layerDisk...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>hit  subdetector  trackerPart  layer...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>hit  subdetector  trackerPart  layerDisk...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>hit  subdetector  trackerPart  layerDi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>hit  subdetector  trackerPart  layer...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>hit  subdetector  trackerPart  layer...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>hit  subdetector  trackerPart  layer...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>hit  subdetector  trackerPart  layerDi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>hit  subdetector  trackerPart  layerDi...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               hitsDf\n",
       "0         hit  subdetector  trackerPart  layerDisk...\n",
       "1           hit  subdetector  trackerPart  layerDi...\n",
       "2         hit  subdetector  trackerPart  layerDisk...\n",
       "3             hit  subdetector  trackerPart  layer...\n",
       "4         hit  subdetector  trackerPart  layerDisk...\n",
       "5           hit  subdetector  trackerPart  layerDi...\n",
       "6             hit  subdetector  trackerPart  layer...\n",
       "7             hit  subdetector  trackerPart  layer...\n",
       "8             hit  subdetector  trackerPart  layer...\n",
       "9           hit  subdetector  trackerPart  layerDi...\n",
       "10          hit  subdetector  trackerPart  layerDi..."
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hitsDF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "binding-modification",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['mass', 'charge', 'p', 'pdgId', 'status', 'pt', 'eta', 'phi',\n",
       "       'decayLength', 'ctau', 'beta', 'gamma', 'eventId', 'eventRun',\n",
       "       'eventLumiBlock', 'foundTrack', 'trackCharge', 'trackPt', 'dR',\n",
       "       'trackPhi', 'trackEta', 'validHits', 'missingInnerHits',\n",
       "       'missingTrackHits', 'missingOuterHits', 'validLayers',\n",
       "       'layersNoMeasurements'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "charginos.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "robust-vatican",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>mass</th>\n",
       "      <th>charge</th>\n",
       "      <th>p</th>\n",
       "      <th>pdgId</th>\n",
       "      <th>status</th>\n",
       "      <th>pt</th>\n",
       "      <th>eta</th>\n",
       "      <th>phi</th>\n",
       "      <th>decayLength</th>\n",
       "      <th>ctau</th>\n",
       "      <th>...</th>\n",
       "      <th>trackPt</th>\n",
       "      <th>dR</th>\n",
       "      <th>trackPhi</th>\n",
       "      <th>trackEta</th>\n",
       "      <th>validHits</th>\n",
       "      <th>missingInnerHits</th>\n",
       "      <th>missingTrackHits</th>\n",
       "      <th>missingOuterHits</th>\n",
       "      <th>validLayers</th>\n",
       "      <th>layersNoMeasurements</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>700.048</td>\n",
       "      <td>1</td>\n",
       "      <td>1189.790</td>\n",
       "      <td>1000024</td>\n",
       "      <td>62.0</td>\n",
       "      <td>109.149</td>\n",
       "      <td>3.079860</td>\n",
       "      <td>2.742540</td>\n",
       "      <td>167.75800</td>\n",
       "      <td>98.7050</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>700.048</td>\n",
       "      <td>-1</td>\n",
       "      <td>134.310</td>\n",
       "      <td>-1000024</td>\n",
       "      <td>62.0</td>\n",
       "      <td>134.275</td>\n",
       "      <td>-0.022846</td>\n",
       "      <td>-0.234468</td>\n",
       "      <td>19.89770</td>\n",
       "      <td>103.7100</td>\n",
       "      <td>...</td>\n",
       "      <td>52.1775</td>\n",
       "      <td>0.001520</td>\n",
       "      <td>-0.235915</td>\n",
       "      <td>-0.022381</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>700.048</td>\n",
       "      <td>1</td>\n",
       "      <td>717.605</td>\n",
       "      <td>1000024</td>\n",
       "      <td>62.0</td>\n",
       "      <td>306.623</td>\n",
       "      <td>1.494320</td>\n",
       "      <td>2.455400</td>\n",
       "      <td>24.18880</td>\n",
       "      <td>23.5970</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>700.048</td>\n",
       "      <td>1</td>\n",
       "      <td>530.192</td>\n",
       "      <td>1000024</td>\n",
       "      <td>62.0</td>\n",
       "      <td>526.916</td>\n",
       "      <td>-0.111461</td>\n",
       "      <td>1.445640</td>\n",
       "      <td>189.75800</td>\n",
       "      <td>250.5500</td>\n",
       "      <td>...</td>\n",
       "      <td>541.6250</td>\n",
       "      <td>0.000252</td>\n",
       "      <td>1.445530</td>\n",
       "      <td>-0.111233</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>700.048</td>\n",
       "      <td>-1</td>\n",
       "      <td>480.965</td>\n",
       "      <td>-1000024</td>\n",
       "      <td>62.0</td>\n",
       "      <td>283.369</td>\n",
       "      <td>-1.121270</td>\n",
       "      <td>0.710112</td>\n",
       "      <td>3.86992</td>\n",
       "      <td>5.6327</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       mass  charge         p    pdgId  status       pt       eta       phi  \\\n",
       "1   700.048       1  1189.790  1000024    62.0  109.149  3.079860  2.742540   \n",
       "6   700.048      -1   134.310 -1000024    62.0  134.275 -0.022846 -0.234468   \n",
       "8   700.048       1   717.605  1000024    62.0  306.623  1.494320  2.455400   \n",
       "27  700.048       1   530.192  1000024    62.0  526.916 -0.111461  1.445640   \n",
       "29  700.048      -1   480.965 -1000024    62.0  283.369 -1.121270  0.710112   \n",
       "\n",
       "    decayLength      ctau  ...   trackPt        dR  trackPhi  trackEta  \\\n",
       "1     167.75800   98.7050  ...    0.0000  0.000000  0.000000  0.000000   \n",
       "6      19.89770  103.7100  ...   52.1775  0.001520 -0.235915 -0.022381   \n",
       "8      24.18880   23.5970  ...    0.0000  0.000000  0.000000  0.000000   \n",
       "27    189.75800  250.5500  ...  541.6250  0.000252  1.445530 -0.111233   \n",
       "29      3.86992    5.6327  ...    0.0000  0.000000  0.000000  0.000000   \n",
       "\n",
       "    validHits  missingInnerHits  missingTrackHits  missingOuterHits  \\\n",
       "1         0.0               0.0               0.0               0.0   \n",
       "6         4.0               1.0               0.0               2.0   \n",
       "8         0.0               0.0               0.0               0.0   \n",
       "27       18.0               1.0               0.0               2.0   \n",
       "29        0.0               0.0               0.0               0.0   \n",
       "\n",
       "    validLayers  layersNoMeasurements  \n",
       "1           0.0                   0.0  \n",
       "6           4.0                   9.0  \n",
       "8           0.0                   0.0  \n",
       "27         14.0                   0.0  \n",
       "29          0.0                   0.0  \n",
       "\n",
       "[5 rows x 27 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "charginos.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "protecting-uruguay",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "breathing-keyboard",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "occupied-printer",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "vocational-possibility",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "interim-handbook",
   "metadata": {},
   "outputs": [],
   "source": [
    "charginos.to_pickle('charginosDf.pkl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "bibliographic-showcase",
   "metadata": {},
   "outputs": [],
   "source": [
    "hitsDF.to_pickle('hitsDf.pkl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "accurate-charter",
   "metadata": {},
   "outputs": [],
   "source": [
    "hitsDataFrame = pd.read_pickle('data/hitsDf.pkl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "above-provision",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>hitsDf</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>hit  subdetector  trackerPart  layerDisk...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>hit  subdetector  trackerPart  layerDisk...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>hit  subdetector  trackerPart  layerDisk...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>hit  subdetector  trackerPart  layerDis...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>hit  subdetector  trackerPart  layerDisk...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>hit  subdetector  trackerPart  layerDisk...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>hit  subdetector  trackerPart  layerDis...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>hit  subdetector  trackerPart  layerDis...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>hit  subdetector  trackerPart  layerDis...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>hit  subdetector  trackerPart  layerDisk...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              hitsDf\n",
       "0        hit  subdetector  trackerPart  layerDisk...\n",
       "1        hit  subdetector  trackerPart  layerDisk...\n",
       "2        hit  subdetector  trackerPart  layerDisk...\n",
       "3         hit  subdetector  trackerPart  layerDis...\n",
       "4        hit  subdetector  trackerPart  layerDisk...\n",
       "5        hit  subdetector  trackerPart  layerDisk...\n",
       "6         hit  subdetector  trackerPart  layerDis...\n",
       "7         hit  subdetector  trackerPart  layerDis...\n",
       "8         hit  subdetector  trackerPart  layerDis...\n",
       "9        hit  subdetector  trackerPart  layerDisk..."
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hitsDataFrame.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "protecting-determination",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>hit</th>\n",
       "      <th>subdetector</th>\n",
       "      <th>trackerPart</th>\n",
       "      <th>layerDiskWheel</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>hit1</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hit2</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hit3</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hit4</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hit5</th>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hit6</th>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hit7</th>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hit8</th>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hit9</th>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hit10</th>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       hit  subdetector  trackerPart  layerDiskWheel\n",
       "hit1     1            1            1               1\n",
       "hit2     2            1            1               2\n",
       "hit3     3            1            1               3\n",
       "hit4     4            1            3               1\n",
       "hit5     5            1            3               1\n",
       "hit6     6            1            3               2\n",
       "hit7     7            1            3               2\n",
       "hit8     8            1            4               1\n",
       "hit9     9            1            5               1\n",
       "hit10   10            1            5               1"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hitsDataFrame.iloc[11,0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "proved-dayton",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "married-junior",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "metallic-domestic",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "centered-traveler",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "architectural-columbia",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "looking-efficiency",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "assigned-longer",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "binding-complaint",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "third-cowboy",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "impossible-reform",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "secondary-brother",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "fresh-heart",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "weekly-yorkshire",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "warming-poker",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "overall-charm",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "confidential-harmony",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "controversial-twelve",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "underlying-baseline",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "wrapped-registration",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_table('charginoData.txt', names=['mass','charge','p','pdgId','status','pt','eta','phi','beta','gamma','event','run','luminosityBlock','foundTrack','trackCharge','trackPt','trackPhi','trackEta','validHits','missingInnerHits','trackHits','missingOuterHits','validLayers','hpmissingOuterHits'], index_col=False)\n",
    "\n",
    "df.to_csv('charginosWithHitPattern')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "undefined-trace",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}