Permalink
Cannot retrieve contributors at this time
Name already in use
A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
COVID_Behavior/behavior_pivot.ipynb
Go to fileThis commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
5364 lines (5364 sloc)
219 KB
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "cells": [ | |
| { | |
| "cell_type": "code", | |
| "execution_count": 29, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "import pandas as pd\n", | |
| "import numpy as np\n", | |
| "import configparser\n", | |
| "from ast import literal_eval\n", | |
| "\n", | |
| "\n", | |
| "config = configparser.ConfigParser()\n", | |
| "config.read('targets_of_interest.ini')\n", | |
| "targets = literal_eval(config['section1']['targets_of_interest'])\n" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 30, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "behaviors = pd.read_csv('behaviors_wide_deID.csv',index_col=0)\n", | |
| "behaviors_orig = behaviors.copy()" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 31, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "cols = behaviors.columns.tolist()\n", | |
| "target_ndr_cols = [col for col in cols if 'Behavior_No_Data_Recorded_' in col]" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 32, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "name": "stdout", | |
| "output_type": "stream", | |
| "text": [ | |
| "<class 'pandas.core.frame.DataFrame'>\n", | |
| "Index: 77793 entries, 0 to 77792\n", | |
| "Data columns (total 21 columns):\n", | |
| " # Column Non-Null Count Dtype \n", | |
| "--- ------ -------------- ----- \n", | |
| " 0 Concat 77793 non-null object \n", | |
| " 1 n_observations 77793 non-null int64 \n", | |
| " 2 Missing_Shift 77793 non-null int64 \n", | |
| " 3 Behavior_aggression 77793 non-null int64 \n", | |
| " 4 Behavior_sib 77793 non-null int64 \n", | |
| " 5 Behavior_elopement 77793 non-null int64 \n", | |
| " 6 Behavior_disruptive 77793 non-null int64 \n", | |
| " 7 Behavior_other 77793 non-null int64 \n", | |
| " 8 Behavior_Episodes_aggression 77793 non-null float64\n", | |
| " 9 Behavior_Episodes_sib 77793 non-null float64\n", | |
| " 10 Behavior_Episodes_elopement 77793 non-null float64\n", | |
| " 11 Behavior_Episodes_disruptive 77793 non-null float64\n", | |
| " 12 Behavior_Episodes_other 77793 non-null float64\n", | |
| " 13 Behavior_LOA 77793 non-null float64\n", | |
| " 14 Behavior_None 77793 non-null float64\n", | |
| " 15 Behavior_No_Data_Recorded 77793 non-null float64\n", | |
| " 16 Behavior_No_Data_Recorded_aggression 77793 non-null float64\n", | |
| " 17 Behavior_No_Data_Recorded_sib 77793 non-null float64\n", | |
| " 18 Behavior_No_Data_Recorded_elopement 77793 non-null float64\n", | |
| " 19 Behavior_No_Data_Recorded_disruptive 77793 non-null float64\n", | |
| " 20 Behavior_No_Data_Recorded_other 77793 non-null float64\n", | |
| "dtypes: float64(13), int64(7), object(1)\n", | |
| "memory usage: 13.1+ MB\n" | |
| ] | |
| } | |
| ], | |
| "source": [ | |
| "behaviors.info()" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 33, | |
| "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>Concat</th>\n", | |
| " <th>n_observations</th>\n", | |
| " <th>Missing_Shift</th>\n", | |
| " <th>Behavior_aggression</th>\n", | |
| " <th>Behavior_sib</th>\n", | |
| " <th>Behavior_elopement</th>\n", | |
| " <th>Behavior_disruptive</th>\n", | |
| " <th>Behavior_other</th>\n", | |
| " <th>Behavior_Episodes_aggression</th>\n", | |
| " <th>Behavior_Episodes_sib</th>\n", | |
| " <th>...</th>\n", | |
| " <th>Behavior_Episodes_disruptive</th>\n", | |
| " <th>Behavior_Episodes_other</th>\n", | |
| " <th>Behavior_LOA</th>\n", | |
| " <th>Behavior_None</th>\n", | |
| " <th>Behavior_No_Data_Recorded</th>\n", | |
| " <th>Behavior_No_Data_Recorded_aggression</th>\n", | |
| " <th>Behavior_No_Data_Recorded_sib</th>\n", | |
| " <th>Behavior_No_Data_Recorded_elopement</th>\n", | |
| " <th>Behavior_No_Data_Recorded_disruptive</th>\n", | |
| " <th>Behavior_No_Data_Recorded_other</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>21</th>\n", | |
| " <td>1 2019-09-22 07:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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>22</th>\n", | |
| " <td>1 2019-09-22 15:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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>37</th>\n", | |
| " <td>1 2019-09-27 15:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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>58</th>\n", | |
| " <td>1 2019-10-04 15:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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>81</th>\n", | |
| " <td>1 2019-10-12 07:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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>...</th>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>77695</th>\n", | |
| " <td>9 2020-07-30 15:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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>77696</th>\n", | |
| " <td>9 2020-07-30 23:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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>77697</th>\n", | |
| " <td>9 2020-07-31 07:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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>77698</th>\n", | |
| " <td>9 2020-07-31 15:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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>77699</th>\n", | |
| " <td>9 2020-07-31 23:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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>16267 rows × 21 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " Concat n_observations Missing_Shift \\\n", | |
| "21 1 2019-09-22 07:00:00 1 0 \n", | |
| "22 1 2019-09-22 15:00:00 1 0 \n", | |
| "37 1 2019-09-27 15:00:00 1 0 \n", | |
| "58 1 2019-10-04 15:00:00 1 0 \n", | |
| "81 1 2019-10-12 07:00:00 1 0 \n", | |
| "... ... ... ... \n", | |
| "77695 9 2020-07-30 15:00:00 1 1 \n", | |
| "77696 9 2020-07-30 23:00:00 1 1 \n", | |
| "77697 9 2020-07-31 07:00:00 1 1 \n", | |
| "77698 9 2020-07-31 15:00:00 1 1 \n", | |
| "77699 9 2020-07-31 23:00:00 1 1 \n", | |
| "\n", | |
| " Behavior_aggression Behavior_sib Behavior_elopement \\\n", | |
| "21 0 0 0 \n", | |
| "22 0 0 0 \n", | |
| "37 0 0 0 \n", | |
| "58 0 0 0 \n", | |
| "81 0 0 0 \n", | |
| "... ... ... ... \n", | |
| "77695 0 0 0 \n", | |
| "77696 0 0 0 \n", | |
| "77697 0 0 0 \n", | |
| "77698 0 0 0 \n", | |
| "77699 0 0 0 \n", | |
| "\n", | |
| " Behavior_disruptive Behavior_other Behavior_Episodes_aggression \\\n", | |
| "21 0 0 0.0 \n", | |
| "22 0 0 0.0 \n", | |
| "37 0 0 0.0 \n", | |
| "58 0 0 0.0 \n", | |
| "81 0 0 0.0 \n", | |
| "... ... ... ... \n", | |
| "77695 0 0 0.0 \n", | |
| "77696 0 0 0.0 \n", | |
| "77697 0 0 0.0 \n", | |
| "77698 0 0 0.0 \n", | |
| "77699 0 0 0.0 \n", | |
| "\n", | |
| " Behavior_Episodes_sib ... Behavior_Episodes_disruptive \\\n", | |
| "21 0.0 ... 0.0 \n", | |
| "22 0.0 ... 0.0 \n", | |
| "37 0.0 ... 0.0 \n", | |
| "58 0.0 ... 0.0 \n", | |
| "81 0.0 ... 0.0 \n", | |
| "... ... ... ... \n", | |
| "77695 0.0 ... 0.0 \n", | |
| "77696 0.0 ... 0.0 \n", | |
| "77697 0.0 ... 0.0 \n", | |
| "77698 0.0 ... 0.0 \n", | |
| "77699 0.0 ... 0.0 \n", | |
| "\n", | |
| " Behavior_Episodes_other Behavior_LOA Behavior_None \\\n", | |
| "21 0.0 0.0 0.0 \n", | |
| "22 0.0 0.0 0.0 \n", | |
| "37 0.0 0.0 0.0 \n", | |
| "58 0.0 0.0 0.0 \n", | |
| "81 0.0 0.0 0.0 \n", | |
| "... ... ... ... \n", | |
| "77695 0.0 0.0 0.0 \n", | |
| "77696 0.0 0.0 0.0 \n", | |
| "77697 0.0 0.0 0.0 \n", | |
| "77698 0.0 0.0 0.0 \n", | |
| "77699 0.0 0.0 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded Behavior_No_Data_Recorded_aggression \\\n", | |
| "21 1.0 0.0 \n", | |
| "22 1.0 0.0 \n", | |
| "37 1.0 0.0 \n", | |
| "58 1.0 0.0 \n", | |
| "81 1.0 0.0 \n", | |
| "... ... ... \n", | |
| "77695 1.0 0.0 \n", | |
| "77696 1.0 0.0 \n", | |
| "77697 1.0 0.0 \n", | |
| "77698 1.0 0.0 \n", | |
| "77699 1.0 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_sib Behavior_No_Data_Recorded_elopement \\\n", | |
| "21 0.0 0.0 \n", | |
| "22 0.0 0.0 \n", | |
| "37 0.0 0.0 \n", | |
| "58 0.0 0.0 \n", | |
| "81 0.0 0.0 \n", | |
| "... ... ... \n", | |
| "77695 0.0 0.0 \n", | |
| "77696 0.0 0.0 \n", | |
| "77697 0.0 0.0 \n", | |
| "77698 0.0 0.0 \n", | |
| "77699 0.0 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_disruptive Behavior_No_Data_Recorded_other \n", | |
| "21 0.0 0.0 \n", | |
| "22 0.0 0.0 \n", | |
| "37 0.0 0.0 \n", | |
| "58 0.0 0.0 \n", | |
| "81 0.0 0.0 \n", | |
| "... ... ... \n", | |
| "77695 0.0 0.0 \n", | |
| "77696 0.0 0.0 \n", | |
| "77697 0.0 0.0 \n", | |
| "77698 0.0 0.0 \n", | |
| "77699 0.0 0.0 \n", | |
| "\n", | |
| "[16267 rows x 21 columns]" | |
| ] | |
| }, | |
| "execution_count": 33, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "# This means nothing was recorded at all for the shift\n", | |
| "behaviors[(behaviors[target_ndr_cols].sum(axis=1) == 0) & (behaviors['Behavior_No_Data_Recorded'] > 0)]\n" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 34, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "# If there's nothing recorded at all, set no data recorded\n", | |
| "behaviors = behaviors.set_index('Concat')\n", | |
| "behaviors.loc[behaviors.sum(axis=1) == 0,'Behavior_No_Data_Recorded'] = 1.0" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 35, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "no_data_cols = ['Behavior_No_Data_Recorded_' + targ for targ in targets]" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 36, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "# Basically if it's an \"other\" no data recorded *only*, then it's not an issue\n", | |
| "# Unless it's the only observation!\n", | |
| "behaviors.loc[(behaviors['n_observations'] > 1) & (behaviors['Behavior_No_Data_Recorded_other']>0) & (behaviors[no_data_cols].sum(axis=1)==0),'Behavior_No_Data_Recorded'] = 0" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 37, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "behaviors = behaviors.drop('n_observations',axis=1)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 38, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "behaviors = behaviors.reset_index()\n", | |
| "ids = behaviors['Concat'].str.split(n=2,expand=True)\n", | |
| "ids = ids[0] + \" \" + ids[1]" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 39, | |
| "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>Concat</th>\n", | |
| " <th>Missing_Shift</th>\n", | |
| " <th>Behavior_aggression</th>\n", | |
| " <th>Behavior_sib</th>\n", | |
| " <th>Behavior_elopement</th>\n", | |
| " <th>Behavior_disruptive</th>\n", | |
| " <th>Behavior_other</th>\n", | |
| " <th>Behavior_Episodes_aggression</th>\n", | |
| " <th>Behavior_Episodes_sib</th>\n", | |
| " <th>Behavior_Episodes_elopement</th>\n", | |
| " <th>Behavior_Episodes_disruptive</th>\n", | |
| " <th>Behavior_Episodes_other</th>\n", | |
| " <th>Behavior_LOA</th>\n", | |
| " <th>Behavior_None</th>\n", | |
| " <th>Behavior_No_Data_Recorded</th>\n", | |
| " <th>Behavior_No_Data_Recorded_aggression</th>\n", | |
| " <th>Behavior_No_Data_Recorded_sib</th>\n", | |
| " <th>Behavior_No_Data_Recorded_elopement</th>\n", | |
| " <th>Behavior_No_Data_Recorded_disruptive</th>\n", | |
| " <th>Behavior_No_Data_Recorded_other</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>2448</th>\n", | |
| " <td>11 2019-12-20 07:00:00</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4543</th>\n", | |
| " <td>13 2020-02-17 15:00:00</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>1.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", | |
| " <td>3.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4974</th>\n", | |
| " <td>13 2020-07-10 07:00:00</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>3.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>5994</th>\n", | |
| " <td>14 2020-07-18 07:00:00</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.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>6017</th>\n", | |
| " <td>14 2020-07-25 23:00:00</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.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>...</th>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>60330</th>\n", | |
| " <td>61 2019-10-14 07:00:00</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.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>60687</th>\n", | |
| " <td>61 2020-02-10 07:00:00</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.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>60783</th>\n", | |
| " <td>61 2020-03-13 07:00:00</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.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>69405</th>\n", | |
| " <td>7 2020-03-13 07:00:00</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.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>77118</th>\n", | |
| " <td>9 2020-01-20 07:00:00</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.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>168 rows × 20 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " Concat Missing_Shift Behavior_aggression \\\n", | |
| "2448 11 2019-12-20 07:00:00 0 0 \n", | |
| "4543 13 2020-02-17 15:00:00 0 1 \n", | |
| "4974 13 2020-07-10 07:00:00 0 0 \n", | |
| "5994 14 2020-07-18 07:00:00 0 0 \n", | |
| "6017 14 2020-07-25 23:00:00 0 0 \n", | |
| "... ... ... ... \n", | |
| "60330 61 2019-10-14 07:00:00 0 0 \n", | |
| "60687 61 2020-02-10 07:00:00 0 0 \n", | |
| "60783 61 2020-03-13 07:00:00 0 0 \n", | |
| "69405 7 2020-03-13 07:00:00 0 0 \n", | |
| "77118 9 2020-01-20 07:00:00 0 0 \n", | |
| "\n", | |
| " Behavior_sib Behavior_elopement Behavior_disruptive Behavior_other \\\n", | |
| "2448 0 0 1 0 \n", | |
| "4543 1 0 0 0 \n", | |
| "4974 1 0 0 0 \n", | |
| "5994 0 0 0 0 \n", | |
| "6017 0 0 0 0 \n", | |
| "... ... ... ... ... \n", | |
| "60330 0 0 0 0 \n", | |
| "60687 0 0 0 0 \n", | |
| "60783 0 0 0 0 \n", | |
| "69405 0 0 0 0 \n", | |
| "77118 0 0 0 0 \n", | |
| "\n", | |
| " Behavior_Episodes_aggression Behavior_Episodes_sib \\\n", | |
| "2448 0.0 0.0 \n", | |
| "4543 2.0 1.0 \n", | |
| "4974 0.0 1.0 \n", | |
| "5994 0.0 0.0 \n", | |
| "6017 0.0 0.0 \n", | |
| "... ... ... \n", | |
| "60330 0.0 0.0 \n", | |
| "60687 0.0 0.0 \n", | |
| "60783 0.0 0.0 \n", | |
| "69405 0.0 0.0 \n", | |
| "77118 0.0 0.0 \n", | |
| "\n", | |
| " Behavior_Episodes_elopement Behavior_Episodes_disruptive \\\n", | |
| "2448 0.0 1.0 \n", | |
| "4543 0.0 0.0 \n", | |
| "4974 0.0 0.0 \n", | |
| "5994 0.0 0.0 \n", | |
| "6017 0.0 0.0 \n", | |
| "... ... ... \n", | |
| "60330 0.0 0.0 \n", | |
| "60687 0.0 0.0 \n", | |
| "60783 0.0 0.0 \n", | |
| "69405 0.0 0.0 \n", | |
| "77118 0.0 0.0 \n", | |
| "\n", | |
| " Behavior_Episodes_other Behavior_LOA Behavior_None \\\n", | |
| "2448 0.0 0.0 0.0 \n", | |
| "4543 0.0 0.0 0.0 \n", | |
| "4974 0.0 0.0 0.0 \n", | |
| "5994 0.0 0.0 0.0 \n", | |
| "6017 0.0 0.0 0.0 \n", | |
| "... ... ... ... \n", | |
| "60330 0.0 0.0 0.0 \n", | |
| "60687 0.0 0.0 0.0 \n", | |
| "60783 0.0 0.0 0.0 \n", | |
| "69405 0.0 0.0 0.0 \n", | |
| "77118 0.0 0.0 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded Behavior_No_Data_Recorded_aggression \\\n", | |
| "2448 3.0 1.0 \n", | |
| "4543 3.0 1.0 \n", | |
| "4974 3.0 1.0 \n", | |
| "5994 1.0 1.0 \n", | |
| "6017 1.0 1.0 \n", | |
| "... ... ... \n", | |
| "60330 1.0 1.0 \n", | |
| "60687 1.0 1.0 \n", | |
| "60783 1.0 1.0 \n", | |
| "69405 1.0 1.0 \n", | |
| "77118 1.0 1.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_sib Behavior_No_Data_Recorded_elopement \\\n", | |
| "2448 0.0 1.0 \n", | |
| "4543 1.0 0.0 \n", | |
| "4974 1.0 0.0 \n", | |
| "5994 0.0 0.0 \n", | |
| "6017 0.0 0.0 \n", | |
| "... ... ... \n", | |
| "60330 0.0 0.0 \n", | |
| "60687 0.0 0.0 \n", | |
| "60783 0.0 0.0 \n", | |
| "69405 0.0 0.0 \n", | |
| "77118 0.0 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_disruptive Behavior_No_Data_Recorded_other \n", | |
| "2448 1.0 0.0 \n", | |
| "4543 1.0 0.0 \n", | |
| "4974 1.0 0.0 \n", | |
| "5994 0.0 0.0 \n", | |
| "6017 0.0 0.0 \n", | |
| "... ... ... \n", | |
| "60330 0.0 0.0 \n", | |
| "60687 0.0 0.0 \n", | |
| "60783 0.0 0.0 \n", | |
| "69405 0.0 0.0 \n", | |
| "77118 0.0 0.0 \n", | |
| "\n", | |
| "[168 rows x 20 columns]" | |
| ] | |
| }, | |
| "execution_count": 39, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "behaviors[behaviors['Behavior_No_Data_Recorded_aggression'] > 0]" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 40, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "behaviors['Concat_Date'] = ids" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 41, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "name": "stderr", | |
| "output_type": "stream", | |
| "text": [ | |
| "C:\\Users\\jen-f\\AppData\\Local\\Temp\\ipykernel_65216\\2424302537.py:3: PerformanceWarning: dropping on a non-lexsorted multi-index without a level parameter may impact performance.\n", | |
| " by_shift_pivoted = by_shift_pivoted.reset_index().drop('Concat',axis=1)\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>Date</th>\n", | |
| " <th>Person_ID</th>\n", | |
| " <th>Missing_Shift07:00:00</th>\n", | |
| " <th>Missing_Shift15:00:00</th>\n", | |
| " <th>Missing_Shift23:00:00</th>\n", | |
| " <th>Behavior_aggression07:00:00</th>\n", | |
| " <th>Behavior_aggression15:00:00</th>\n", | |
| " <th>Behavior_aggression23:00:00</th>\n", | |
| " <th>Behavior_sib07:00:00</th>\n", | |
| " <th>Behavior_sib15:00:00</th>\n", | |
| " <th>...</th>\n", | |
| " <th>Behavior_No_Data_Recorded_elopement23:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_disruptive07:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_disruptive15:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_disruptive23:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_other07:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_other15:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_other23:00:00</th>\n", | |
| " <th>Concat_Date07:00:00</th>\n", | |
| " <th>Concat_Date15:00:00</th>\n", | |
| " <th>Concat_Date23:00:00</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>0</th>\n", | |
| " <td>2019-09-15</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>1 2019-09-15</td>\n", | |
| " <td>1 2019-09-15</td>\n", | |
| " <td>1 2019-09-15</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1</th>\n", | |
| " <td>2019-09-16</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>1 2019-09-16</td>\n", | |
| " <td>1 2019-09-16</td>\n", | |
| " <td>1 2019-09-16</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2</th>\n", | |
| " <td>2019-09-17</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>1 2019-09-17</td>\n", | |
| " <td>1 2019-09-17</td>\n", | |
| " <td>1 2019-09-17</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>3</th>\n", | |
| " <td>2019-09-18</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>1 2019-09-18</td>\n", | |
| " <td>1 2019-09-18</td>\n", | |
| " <td>1 2019-09-18</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4</th>\n", | |
| " <td>2019-09-19</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>1 2019-09-19</td>\n", | |
| " <td>1 2019-09-19</td>\n", | |
| " <td>1 2019-09-19</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>...</th>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25926</th>\n", | |
| " <td>2020-08-27</td>\n", | |
| " <td>9</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>9 2020-08-27</td>\n", | |
| " <td>9 2020-08-27</td>\n", | |
| " <td>9 2020-08-27</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25927</th>\n", | |
| " <td>2020-08-28</td>\n", | |
| " <td>9</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>9 2020-08-28</td>\n", | |
| " <td>9 2020-08-28</td>\n", | |
| " <td>9 2020-08-28</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25928</th>\n", | |
| " <td>2020-08-29</td>\n", | |
| " <td>9</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>9 2020-08-29</td>\n", | |
| " <td>9 2020-08-29</td>\n", | |
| " <td>9 2020-08-29</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25929</th>\n", | |
| " <td>2020-08-30</td>\n", | |
| " <td>9</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>9 2020-08-30</td>\n", | |
| " <td>9 2020-08-30</td>\n", | |
| " <td>9 2020-08-30</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25930</th>\n", | |
| " <td>2020-08-31</td>\n", | |
| " <td>9</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>9 2020-08-31</td>\n", | |
| " <td>9 2020-08-31</td>\n", | |
| " <td>9 2020-08-31</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>25931 rows × 62 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " Date Person_ID Missing_Shift07:00:00 Missing_Shift15:00:00 \\\n", | |
| "0 2019-09-15 1 0 0 \n", | |
| "1 2019-09-16 1 0 0 \n", | |
| "2 2019-09-17 1 0 0 \n", | |
| "3 2019-09-18 1 0 0 \n", | |
| "4 2019-09-19 1 0 0 \n", | |
| "... ... ... ... ... \n", | |
| "25926 2020-08-27 9 0 0 \n", | |
| "25927 2020-08-28 9 0 0 \n", | |
| "25928 2020-08-29 9 0 0 \n", | |
| "25929 2020-08-30 9 0 0 \n", | |
| "25930 2020-08-31 9 0 0 \n", | |
| "\n", | |
| " Missing_Shift23:00:00 Behavior_aggression07:00:00 \\\n", | |
| "0 0 0 \n", | |
| "1 0 0 \n", | |
| "2 0 0 \n", | |
| "3 0 0 \n", | |
| "4 0 0 \n", | |
| "... ... ... \n", | |
| "25926 0 0 \n", | |
| "25927 0 0 \n", | |
| "25928 0 0 \n", | |
| "25929 0 0 \n", | |
| "25930 0 0 \n", | |
| "\n", | |
| " Behavior_aggression15:00:00 Behavior_aggression23:00:00 \\\n", | |
| "0 0 0 \n", | |
| "1 0 0 \n", | |
| "2 0 0 \n", | |
| "3 0 0 \n", | |
| "4 0 0 \n", | |
| "... ... ... \n", | |
| "25926 0 0 \n", | |
| "25927 0 0 \n", | |
| "25928 0 0 \n", | |
| "25929 0 0 \n", | |
| "25930 0 0 \n", | |
| "\n", | |
| " Behavior_sib07:00:00 Behavior_sib15:00:00 ... \\\n", | |
| "0 0 0 ... \n", | |
| "1 0 0 ... \n", | |
| "2 0 1 ... \n", | |
| "3 0 0 ... \n", | |
| "4 0 0 ... \n", | |
| "... ... ... ... \n", | |
| "25926 0 0 ... \n", | |
| "25927 0 0 ... \n", | |
| "25928 0 0 ... \n", | |
| "25929 0 0 ... \n", | |
| "25930 0 0 ... \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_elopement23:00:00 \\\n", | |
| "0 0.0 \n", | |
| "1 0.0 \n", | |
| "2 0.0 \n", | |
| "3 0.0 \n", | |
| "4 0.0 \n", | |
| "... ... \n", | |
| "25926 0.0 \n", | |
| "25927 0.0 \n", | |
| "25928 0.0 \n", | |
| "25929 0.0 \n", | |
| "25930 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_disruptive07:00:00 \\\n", | |
| "0 0.0 \n", | |
| "1 0.0 \n", | |
| "2 0.0 \n", | |
| "3 0.0 \n", | |
| "4 0.0 \n", | |
| "... ... \n", | |
| "25926 0.0 \n", | |
| "25927 0.0 \n", | |
| "25928 0.0 \n", | |
| "25929 0.0 \n", | |
| "25930 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_disruptive15:00:00 \\\n", | |
| "0 0.0 \n", | |
| "1 0.0 \n", | |
| "2 0.0 \n", | |
| "3 0.0 \n", | |
| "4 0.0 \n", | |
| "... ... \n", | |
| "25926 0.0 \n", | |
| "25927 0.0 \n", | |
| "25928 0.0 \n", | |
| "25929 0.0 \n", | |
| "25930 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_disruptive23:00:00 \\\n", | |
| "0 0.0 \n", | |
| "1 0.0 \n", | |
| "2 0.0 \n", | |
| "3 0.0 \n", | |
| "4 0.0 \n", | |
| "... ... \n", | |
| "25926 0.0 \n", | |
| "25927 0.0 \n", | |
| "25928 0.0 \n", | |
| "25929 0.0 \n", | |
| "25930 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_other07:00:00 \\\n", | |
| "0 0.0 \n", | |
| "1 0.0 \n", | |
| "2 0.0 \n", | |
| "3 0.0 \n", | |
| "4 0.0 \n", | |
| "... ... \n", | |
| "25926 0.0 \n", | |
| "25927 0.0 \n", | |
| "25928 0.0 \n", | |
| "25929 0.0 \n", | |
| "25930 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_other15:00:00 \\\n", | |
| "0 0.0 \n", | |
| "1 0.0 \n", | |
| "2 0.0 \n", | |
| "3 0.0 \n", | |
| "4 0.0 \n", | |
| "... ... \n", | |
| "25926 0.0 \n", | |
| "25927 0.0 \n", | |
| "25928 0.0 \n", | |
| "25929 0.0 \n", | |
| "25930 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_other23:00:00 Concat_Date07:00:00 \\\n", | |
| "0 0.0 1 2019-09-15 \n", | |
| "1 0.0 1 2019-09-16 \n", | |
| "2 0.0 1 2019-09-17 \n", | |
| "3 0.0 1 2019-09-18 \n", | |
| "4 0.0 1 2019-09-19 \n", | |
| "... ... ... \n", | |
| "25926 0.0 9 2020-08-27 \n", | |
| "25927 0.0 9 2020-08-28 \n", | |
| "25928 0.0 9 2020-08-29 \n", | |
| "25929 0.0 9 2020-08-30 \n", | |
| "25930 0.0 9 2020-08-31 \n", | |
| "\n", | |
| " Concat_Date15:00:00 Concat_Date23:00:00 \n", | |
| "0 1 2019-09-15 1 2019-09-15 \n", | |
| "1 1 2019-09-16 1 2019-09-16 \n", | |
| "2 1 2019-09-17 1 2019-09-17 \n", | |
| "3 1 2019-09-18 1 2019-09-18 \n", | |
| "4 1 2019-09-19 1 2019-09-19 \n", | |
| "... ... ... \n", | |
| "25926 9 2020-08-27 9 2020-08-27 \n", | |
| "25927 9 2020-08-28 9 2020-08-28 \n", | |
| "25928 9 2020-08-29 9 2020-08-29 \n", | |
| "25929 9 2020-08-30 9 2020-08-30 \n", | |
| "25930 9 2020-08-31 9 2020-08-31 \n", | |
| "\n", | |
| "[25931 rows x 62 columns]" | |
| ] | |
| }, | |
| "execution_count": 41, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "behaviors[['Person_ID', 'Date','Shift']] = behaviors['Concat'].str.split(' ',expand =True)\n", | |
| "by_shift_pivoted = behaviors.pivot(index=['Person_ID','Date'], columns='Shift').reset_index(level=0)\n", | |
| "by_shift_pivoted = by_shift_pivoted.reset_index().drop('Concat',axis=1)\n", | |
| "by_shift_pivoted.columns = [\"\".join(pair) for pair in by_shift_pivoted.columns]\n", | |
| "by_shift_pivoted" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 42, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "times = ['07:00:00','15:00:00','23:00:00']\n", | |
| "for target in targets:\n", | |
| " for time in times:\n", | |
| " by_shift_pivoted['Behavior_'+target+time] = np.where(by_shift_pivoted['Behavior_No_Data_Recorded_'+target+time] > 0,\n", | |
| " float(\"NaN\"),\n", | |
| " by_shift_pivoted['Behavior_'+target+time])\n", | |
| " by_shift_pivoted['Behavior_Episodes_'+target+time] = np.where(by_shift_pivoted['Behavior_No_Data_Recorded_'+target+time] > 0,\n", | |
| " float(\"NaN\"),\n", | |
| " by_shift_pivoted['Behavior_Episodes_'+target+time])" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 43, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/plain": [ | |
| "[nan, 21.0, 22.0, 62.0]" | |
| ] | |
| }, | |
| "execution_count": 43, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "high_episode_individuals = pd.read_csv('high_episode_flag_ids.csv')['Person_ID'].tolist()\n", | |
| "high_episode_individuals" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 44, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "name": "stdout", | |
| "output_type": "stream", | |
| "text": [ | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_aggression07:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_aggression07:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_aggression07:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_aggression07:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_aggression15:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_aggression15:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_aggression15:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_aggression15:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_aggression23:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_aggression23:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_aggression23:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_aggression23:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_sib07:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_sib07:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_sib07:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_sib07:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_sib15:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_sib15:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_sib15:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_sib15:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_sib23:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_sib23:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_sib23:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_sib23:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_elopement07:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_elopement07:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_elopement07:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_elopement07:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_elopement15:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_elopement15:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_elopement15:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_elopement15:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_elopement23:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_elopement23:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_elopement23:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_elopement23:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_disruptive07:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_disruptive07:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_disruptive07:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_disruptive07:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_disruptive15:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_disruptive15:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_disruptive15:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_disruptive15:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_disruptive23:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_disruptive23:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_disruptive23:00:00]\n", | |
| "Index: []\n", | |
| "Empty DataFrame\n", | |
| "Columns: [Person_ID, Behavior_Episodes_disruptive23:00:00]\n", | |
| "Index: []\n" | |
| ] | |
| } | |
| ], | |
| "source": [ | |
| "episode_cols = [col for col in by_shift_pivoted.columns if 'Episodes' in col]\n", | |
| "episode_cols\n", | |
| "\n", | |
| "by_shift_pivoted\n", | |
| "\n", | |
| "for target in targets:\n", | |
| " for time in times:\n", | |
| " for ind in high_episode_individuals:\n", | |
| " print(by_shift_pivoted.loc[(by_shift_pivoted['Behavior_Episodes_' + target +time] > 15) & (by_shift_pivoted['Person_ID']==ind),\n", | |
| " ['Person_ID','Behavior_Episodes_' + target +time]])\n", | |
| " by_shift_pivoted.loc[(by_shift_pivoted['Behavior_Episodes_' + target +time] > 15) & (by_shift_pivoted['Person_ID']==ind),'Behavior_No_Data_Recorded_'+target+time] = 1.0" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 45, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "# by_shift_pivoted[by_shift_pivoted['Behavior_E" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 46, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "concats = []\n", | |
| "for target in targets:\n", | |
| " for time in times:\n", | |
| " \n", | |
| " concat = by_shift_pivoted.loc[(by_shift_pivoted['Behavior_Episodes_' + target +time] > 15) ,\n", | |
| " ['Person_ID','Date']]\n", | |
| " concats.extend(concat.Person_ID + \" \" + concat.Date)\n", | |
| " # by_shift_pivoted.loc[(by_shift_pivoted['Behavior_Episodes_' + target +time] > 15) ,'Behavior_No_Data_Recorded_'+target+time] = 1.0\n", | |
| "pd.DataFrame({'high_eps_final':sorted(concats)}).to_csv('high_eps_finalized.csv')" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 47, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "inds = []\n", | |
| "for target in targets:\n", | |
| " for time in times: \n", | |
| " inds.extend( by_shift_pivoted.loc[(by_shift_pivoted['Behavior_Episodes_' + target +time] > 15),\n", | |
| " 'Person_ID'].unique().tolist() )\n", | |
| "pd.DataFrame({'Person_ID':sorted(list(set(inds)))}).to_csv('high_ep_unfiltered.csv')" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 48, | |
| "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>Date</th>\n", | |
| " <th>Person_ID</th>\n", | |
| " <th>Missing_Shift07:00:00</th>\n", | |
| " <th>Missing_Shift15:00:00</th>\n", | |
| " <th>Missing_Shift23:00:00</th>\n", | |
| " <th>Behavior_aggression07:00:00</th>\n", | |
| " <th>Behavior_aggression15:00:00</th>\n", | |
| " <th>Behavior_aggression23:00:00</th>\n", | |
| " <th>Behavior_sib07:00:00</th>\n", | |
| " <th>Behavior_sib15:00:00</th>\n", | |
| " <th>...</th>\n", | |
| " <th>Behavior_No_Data_Recorded_elopement23:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_disruptive07:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_disruptive15:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_disruptive23:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_other07:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_other15:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_other23:00:00</th>\n", | |
| " <th>Concat_Date07:00:00</th>\n", | |
| " <th>Concat_Date15:00:00</th>\n", | |
| " <th>Concat_Date23:00:00</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>816</th>\n", | |
| " <td>2019-12-20</td>\n", | |
| " <td>11</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>11 2019-12-20</td>\n", | |
| " <td>11 2019-12-20</td>\n", | |
| " <td>11 2019-12-20</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1658</th>\n", | |
| " <td>2020-07-10</td>\n", | |
| " <td>13</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>13 2020-07-10</td>\n", | |
| " <td>13 2020-07-10</td>\n", | |
| " <td>13 2020-07-10</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1998</th>\n", | |
| " <td>2020-07-18</td>\n", | |
| " <td>14</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>14 2020-07-18</td>\n", | |
| " <td>14 2020-07-18</td>\n", | |
| " <td>14 2020-07-18</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2027</th>\n", | |
| " <td>2020-08-16</td>\n", | |
| " <td>14</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>14 2020-08-16</td>\n", | |
| " <td>14 2020-08-16</td>\n", | |
| " <td>14 2020-08-16</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2082</th>\n", | |
| " <td>2019-10-16</td>\n", | |
| " <td>15</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>15 2019-10-16</td>\n", | |
| " <td>15 2019-10-16</td>\n", | |
| " <td>15 2019-10-16</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>...</th>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>20110</th>\n", | |
| " <td>2019-10-14</td>\n", | |
| " <td>61</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>61 2019-10-14</td>\n", | |
| " <td>61 2019-10-14</td>\n", | |
| " <td>61 2019-10-14</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>20229</th>\n", | |
| " <td>2020-02-10</td>\n", | |
| " <td>61</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>61 2020-02-10</td>\n", | |
| " <td>61 2020-02-10</td>\n", | |
| " <td>61 2020-02-10</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>20261</th>\n", | |
| " <td>2020-03-13</td>\n", | |
| " <td>61</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>61 2020-03-13</td>\n", | |
| " <td>61 2020-03-13</td>\n", | |
| " <td>61 2020-03-13</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>23135</th>\n", | |
| " <td>2020-03-13</td>\n", | |
| " <td>7</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>7 2020-03-13</td>\n", | |
| " <td>7 2020-03-13</td>\n", | |
| " <td>7 2020-03-13</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25706</th>\n", | |
| " <td>2020-01-20</td>\n", | |
| " <td>9</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>9 2020-01-20</td>\n", | |
| " <td>9 2020-01-20</td>\n", | |
| " <td>9 2020-01-20</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>152 rows × 62 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " Date Person_ID Missing_Shift07:00:00 Missing_Shift15:00:00 \\\n", | |
| "816 2019-12-20 11 0 0 \n", | |
| "1658 2020-07-10 13 0 0 \n", | |
| "1998 2020-07-18 14 0 0 \n", | |
| "2027 2020-08-16 14 0 0 \n", | |
| "2082 2019-10-16 15 0 0 \n", | |
| "... ... ... ... ... \n", | |
| "20110 2019-10-14 61 0 0 \n", | |
| "20229 2020-02-10 61 0 0 \n", | |
| "20261 2020-03-13 61 0 0 \n", | |
| "23135 2020-03-13 7 0 0 \n", | |
| "25706 2020-01-20 9 0 0 \n", | |
| "\n", | |
| " Missing_Shift23:00:00 Behavior_aggression07:00:00 \\\n", | |
| "816 0 NaN \n", | |
| "1658 0 NaN \n", | |
| "1998 0 NaN \n", | |
| "2027 0 NaN \n", | |
| "2082 0 NaN \n", | |
| "... ... ... \n", | |
| "20110 0 NaN \n", | |
| "20229 0 NaN \n", | |
| "20261 0 NaN \n", | |
| "23135 0 NaN \n", | |
| "25706 0 NaN \n", | |
| "\n", | |
| " Behavior_aggression15:00:00 Behavior_aggression23:00:00 \\\n", | |
| "816 0.0 0.0 \n", | |
| "1658 1.0 0.0 \n", | |
| "1998 0.0 0.0 \n", | |
| "2027 0.0 0.0 \n", | |
| "2082 0.0 1.0 \n", | |
| "... ... ... \n", | |
| "20110 0.0 0.0 \n", | |
| "20229 0.0 0.0 \n", | |
| "20261 0.0 0.0 \n", | |
| "23135 0.0 0.0 \n", | |
| "25706 0.0 0.0 \n", | |
| "\n", | |
| " Behavior_sib07:00:00 Behavior_sib15:00:00 ... \\\n", | |
| "816 0.0 0.0 ... \n", | |
| "1658 NaN 1.0 ... \n", | |
| "1998 0.0 0.0 ... \n", | |
| "2027 0.0 0.0 ... \n", | |
| "2082 0.0 0.0 ... \n", | |
| "... ... ... ... \n", | |
| "20110 0.0 0.0 ... \n", | |
| "20229 0.0 0.0 ... \n", | |
| "20261 0.0 0.0 ... \n", | |
| "23135 0.0 0.0 ... \n", | |
| "25706 0.0 0.0 ... \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_elopement23:00:00 \\\n", | |
| "816 0.0 \n", | |
| "1658 0.0 \n", | |
| "1998 0.0 \n", | |
| "2027 0.0 \n", | |
| "2082 0.0 \n", | |
| "... ... \n", | |
| "20110 0.0 \n", | |
| "20229 0.0 \n", | |
| "20261 0.0 \n", | |
| "23135 0.0 \n", | |
| "25706 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_disruptive07:00:00 \\\n", | |
| "816 1.0 \n", | |
| "1658 1.0 \n", | |
| "1998 0.0 \n", | |
| "2027 0.0 \n", | |
| "2082 1.0 \n", | |
| "... ... \n", | |
| "20110 0.0 \n", | |
| "20229 0.0 \n", | |
| "20261 0.0 \n", | |
| "23135 0.0 \n", | |
| "25706 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_disruptive15:00:00 \\\n", | |
| "816 0.0 \n", | |
| "1658 0.0 \n", | |
| "1998 0.0 \n", | |
| "2027 0.0 \n", | |
| "2082 0.0 \n", | |
| "... ... \n", | |
| "20110 0.0 \n", | |
| "20229 0.0 \n", | |
| "20261 0.0 \n", | |
| "23135 0.0 \n", | |
| "25706 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_disruptive23:00:00 \\\n", | |
| "816 0.0 \n", | |
| "1658 0.0 \n", | |
| "1998 0.0 \n", | |
| "2027 0.0 \n", | |
| "2082 0.0 \n", | |
| "... ... \n", | |
| "20110 0.0 \n", | |
| "20229 0.0 \n", | |
| "20261 0.0 \n", | |
| "23135 0.0 \n", | |
| "25706 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_other07:00:00 \\\n", | |
| "816 0.0 \n", | |
| "1658 0.0 \n", | |
| "1998 0.0 \n", | |
| "2027 0.0 \n", | |
| "2082 0.0 \n", | |
| "... ... \n", | |
| "20110 0.0 \n", | |
| "20229 0.0 \n", | |
| "20261 0.0 \n", | |
| "23135 0.0 \n", | |
| "25706 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_other15:00:00 \\\n", | |
| "816 0.0 \n", | |
| "1658 0.0 \n", | |
| "1998 0.0 \n", | |
| "2027 0.0 \n", | |
| "2082 0.0 \n", | |
| "... ... \n", | |
| "20110 0.0 \n", | |
| "20229 0.0 \n", | |
| "20261 0.0 \n", | |
| "23135 0.0 \n", | |
| "25706 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_other23:00:00 Concat_Date07:00:00 \\\n", | |
| "816 0.0 11 2019-12-20 \n", | |
| "1658 0.0 13 2020-07-10 \n", | |
| "1998 0.0 14 2020-07-18 \n", | |
| "2027 0.0 14 2020-08-16 \n", | |
| "2082 0.0 15 2019-10-16 \n", | |
| "... ... ... \n", | |
| "20110 0.0 61 2019-10-14 \n", | |
| "20229 0.0 61 2020-02-10 \n", | |
| "20261 0.0 61 2020-03-13 \n", | |
| "23135 0.0 7 2020-03-13 \n", | |
| "25706 0.0 9 2020-01-20 \n", | |
| "\n", | |
| " Concat_Date15:00:00 Concat_Date23:00:00 \n", | |
| "816 11 2019-12-20 11 2019-12-20 \n", | |
| "1658 13 2020-07-10 13 2020-07-10 \n", | |
| "1998 14 2020-07-18 14 2020-07-18 \n", | |
| "2027 14 2020-08-16 14 2020-08-16 \n", | |
| "2082 15 2019-10-16 15 2019-10-16 \n", | |
| "... ... ... \n", | |
| "20110 61 2019-10-14 61 2019-10-14 \n", | |
| "20229 61 2020-02-10 61 2020-02-10 \n", | |
| "20261 61 2020-03-13 61 2020-03-13 \n", | |
| "23135 7 2020-03-13 7 2020-03-13 \n", | |
| "25706 9 2020-01-20 9 2020-01-20 \n", | |
| "\n", | |
| "[152 rows x 62 columns]" | |
| ] | |
| }, | |
| "execution_count": 48, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "by_shift_pivoted[by_shift_pivoted['Behavior_No_Data_Recorded_aggression07:00:00'] > 0]" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 49, | |
| "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>Date</th>\n", | |
| " <th>Person_ID</th>\n", | |
| " <th>Missing_Shift07:00:00</th>\n", | |
| " <th>Missing_Shift15:00:00</th>\n", | |
| " <th>Missing_Shift23:00:00</th>\n", | |
| " <th>Behavior_aggression07:00:00</th>\n", | |
| " <th>Behavior_aggression15:00:00</th>\n", | |
| " <th>Behavior_aggression23:00:00</th>\n", | |
| " <th>Behavior_sib07:00:00</th>\n", | |
| " <th>Behavior_sib15:00:00</th>\n", | |
| " <th>...</th>\n", | |
| " <th>Behavior_No_Data_Recorded_elopement23:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_disruptive07:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_disruptive15:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_disruptive23:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_other07:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_other15:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_other23:00:00</th>\n", | |
| " <th>Concat_Date07:00:00</th>\n", | |
| " <th>Concat_Date15:00:00</th>\n", | |
| " <th>Concat_Date23:00:00</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>816</th>\n", | |
| " <td>2019-12-20</td>\n", | |
| " <td>11</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>11 2019-12-20</td>\n", | |
| " <td>11 2019-12-20</td>\n", | |
| " <td>11 2019-12-20</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1998</th>\n", | |
| " <td>2020-07-18</td>\n", | |
| " <td>14</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>14 2020-07-18</td>\n", | |
| " <td>14 2020-07-18</td>\n", | |
| " <td>14 2020-07-18</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2027</th>\n", | |
| " <td>2020-08-16</td>\n", | |
| " <td>14</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>14 2020-08-16</td>\n", | |
| " <td>14 2020-08-16</td>\n", | |
| " <td>14 2020-08-16</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2082</th>\n", | |
| " <td>2019-10-16</td>\n", | |
| " <td>15</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>15 2019-10-16</td>\n", | |
| " <td>15 2019-10-16</td>\n", | |
| " <td>15 2019-10-16</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2178</th>\n", | |
| " <td>2020-01-20</td>\n", | |
| " <td>15</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>15 2020-01-20</td>\n", | |
| " <td>15 2020-01-20</td>\n", | |
| " <td>15 2020-01-20</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>...</th>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>20110</th>\n", | |
| " <td>2019-10-14</td>\n", | |
| " <td>61</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>61 2019-10-14</td>\n", | |
| " <td>61 2019-10-14</td>\n", | |
| " <td>61 2019-10-14</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>20229</th>\n", | |
| " <td>2020-02-10</td>\n", | |
| " <td>61</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>61 2020-02-10</td>\n", | |
| " <td>61 2020-02-10</td>\n", | |
| " <td>61 2020-02-10</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>20261</th>\n", | |
| " <td>2020-03-13</td>\n", | |
| " <td>61</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>61 2020-03-13</td>\n", | |
| " <td>61 2020-03-13</td>\n", | |
| " <td>61 2020-03-13</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>23135</th>\n", | |
| " <td>2020-03-13</td>\n", | |
| " <td>7</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>7 2020-03-13</td>\n", | |
| " <td>7 2020-03-13</td>\n", | |
| " <td>7 2020-03-13</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25706</th>\n", | |
| " <td>2020-01-20</td>\n", | |
| " <td>9</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>9 2020-01-20</td>\n", | |
| " <td>9 2020-01-20</td>\n", | |
| " <td>9 2020-01-20</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>122 rows × 62 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " Date Person_ID Missing_Shift07:00:00 Missing_Shift15:00:00 \\\n", | |
| "816 2019-12-20 11 0 0 \n", | |
| "1998 2020-07-18 14 0 0 \n", | |
| "2027 2020-08-16 14 0 0 \n", | |
| "2082 2019-10-16 15 0 0 \n", | |
| "2178 2020-01-20 15 0 0 \n", | |
| "... ... ... ... ... \n", | |
| "20110 2019-10-14 61 0 0 \n", | |
| "20229 2020-02-10 61 0 0 \n", | |
| "20261 2020-03-13 61 0 0 \n", | |
| "23135 2020-03-13 7 0 0 \n", | |
| "25706 2020-01-20 9 0 0 \n", | |
| "\n", | |
| " Missing_Shift23:00:00 Behavior_aggression07:00:00 \\\n", | |
| "816 0 NaN \n", | |
| "1998 0 NaN \n", | |
| "2027 0 NaN \n", | |
| "2082 0 NaN \n", | |
| "2178 0 NaN \n", | |
| "... ... ... \n", | |
| "20110 0 NaN \n", | |
| "20229 0 NaN \n", | |
| "20261 0 NaN \n", | |
| "23135 0 NaN \n", | |
| "25706 0 NaN \n", | |
| "\n", | |
| " Behavior_aggression15:00:00 Behavior_aggression23:00:00 \\\n", | |
| "816 0.0 0.0 \n", | |
| "1998 0.0 0.0 \n", | |
| "2027 0.0 0.0 \n", | |
| "2082 0.0 1.0 \n", | |
| "2178 0.0 0.0 \n", | |
| "... ... ... \n", | |
| "20110 0.0 0.0 \n", | |
| "20229 0.0 0.0 \n", | |
| "20261 0.0 0.0 \n", | |
| "23135 0.0 0.0 \n", | |
| "25706 0.0 0.0 \n", | |
| "\n", | |
| " Behavior_sib07:00:00 Behavior_sib15:00:00 ... \\\n", | |
| "816 0.0 0.0 ... \n", | |
| "1998 0.0 0.0 ... \n", | |
| "2027 0.0 0.0 ... \n", | |
| "2082 0.0 0.0 ... \n", | |
| "2178 0.0 0.0 ... \n", | |
| "... ... ... ... \n", | |
| "20110 0.0 0.0 ... \n", | |
| "20229 0.0 0.0 ... \n", | |
| "20261 0.0 0.0 ... \n", | |
| "23135 0.0 0.0 ... \n", | |
| "25706 0.0 0.0 ... \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_elopement23:00:00 \\\n", | |
| "816 0.0 \n", | |
| "1998 0.0 \n", | |
| "2027 0.0 \n", | |
| "2082 0.0 \n", | |
| "2178 0.0 \n", | |
| "... ... \n", | |
| "20110 0.0 \n", | |
| "20229 0.0 \n", | |
| "20261 0.0 \n", | |
| "23135 0.0 \n", | |
| "25706 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_disruptive07:00:00 \\\n", | |
| "816 1.0 \n", | |
| "1998 0.0 \n", | |
| "2027 0.0 \n", | |
| "2082 1.0 \n", | |
| "2178 0.0 \n", | |
| "... ... \n", | |
| "20110 0.0 \n", | |
| "20229 0.0 \n", | |
| "20261 0.0 \n", | |
| "23135 0.0 \n", | |
| "25706 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_disruptive15:00:00 \\\n", | |
| "816 0.0 \n", | |
| "1998 0.0 \n", | |
| "2027 0.0 \n", | |
| "2082 0.0 \n", | |
| "2178 0.0 \n", | |
| "... ... \n", | |
| "20110 0.0 \n", | |
| "20229 0.0 \n", | |
| "20261 0.0 \n", | |
| "23135 0.0 \n", | |
| "25706 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_disruptive23:00:00 \\\n", | |
| "816 0.0 \n", | |
| "1998 0.0 \n", | |
| "2027 0.0 \n", | |
| "2082 0.0 \n", | |
| "2178 0.0 \n", | |
| "... ... \n", | |
| "20110 0.0 \n", | |
| "20229 0.0 \n", | |
| "20261 0.0 \n", | |
| "23135 0.0 \n", | |
| "25706 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_other07:00:00 \\\n", | |
| "816 0.0 \n", | |
| "1998 0.0 \n", | |
| "2027 0.0 \n", | |
| "2082 0.0 \n", | |
| "2178 0.0 \n", | |
| "... ... \n", | |
| "20110 0.0 \n", | |
| "20229 0.0 \n", | |
| "20261 0.0 \n", | |
| "23135 0.0 \n", | |
| "25706 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_other15:00:00 \\\n", | |
| "816 0.0 \n", | |
| "1998 0.0 \n", | |
| "2027 0.0 \n", | |
| "2082 0.0 \n", | |
| "2178 0.0 \n", | |
| "... ... \n", | |
| "20110 0.0 \n", | |
| "20229 0.0 \n", | |
| "20261 0.0 \n", | |
| "23135 0.0 \n", | |
| "25706 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_other23:00:00 Concat_Date07:00:00 \\\n", | |
| "816 0.0 11 2019-12-20 \n", | |
| "1998 0.0 14 2020-07-18 \n", | |
| "2027 0.0 14 2020-08-16 \n", | |
| "2082 0.0 15 2019-10-16 \n", | |
| "2178 0.0 15 2020-01-20 \n", | |
| "... ... ... \n", | |
| "20110 0.0 61 2019-10-14 \n", | |
| "20229 0.0 61 2020-02-10 \n", | |
| "20261 0.0 61 2020-03-13 \n", | |
| "23135 0.0 7 2020-03-13 \n", | |
| "25706 0.0 9 2020-01-20 \n", | |
| "\n", | |
| " Concat_Date15:00:00 Concat_Date23:00:00 \n", | |
| "816 11 2019-12-20 11 2019-12-20 \n", | |
| "1998 14 2020-07-18 14 2020-07-18 \n", | |
| "2027 14 2020-08-16 14 2020-08-16 \n", | |
| "2082 15 2019-10-16 15 2019-10-16 \n", | |
| "2178 15 2020-01-20 15 2020-01-20 \n", | |
| "... ... ... \n", | |
| "20110 61 2019-10-14 61 2019-10-14 \n", | |
| "20229 61 2020-02-10 61 2020-02-10 \n", | |
| "20261 61 2020-03-13 61 2020-03-13 \n", | |
| "23135 7 2020-03-13 7 2020-03-13 \n", | |
| "25706 9 2020-01-20 9 2020-01-20 \n", | |
| "\n", | |
| "[122 rows x 62 columns]" | |
| ] | |
| }, | |
| "execution_count": 49, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "by_shift_pivoted[by_shift_pivoted['Behavior_aggression07:00:00'].isna() & ~by_shift_pivoted['Behavior_sib07:00:00'].isna()]" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 50, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/plain": [ | |
| "Index(['Concat', 'n_observations', 'Missing_Shift', 'Behavior_aggression',\n", | |
| " 'Behavior_sib', 'Behavior_elopement', 'Behavior_disruptive',\n", | |
| " 'Behavior_other', 'Behavior_Episodes_aggression',\n", | |
| " 'Behavior_Episodes_sib', 'Behavior_Episodes_elopement',\n", | |
| " 'Behavior_Episodes_disruptive', 'Behavior_Episodes_other',\n", | |
| " 'Behavior_LOA', 'Behavior_None', 'Behavior_No_Data_Recorded',\n", | |
| " 'Behavior_No_Data_Recorded_aggression', 'Behavior_No_Data_Recorded_sib',\n", | |
| " 'Behavior_No_Data_Recorded_elopement',\n", | |
| " 'Behavior_No_Data_Recorded_disruptive',\n", | |
| " 'Behavior_No_Data_Recorded_other'],\n", | |
| " dtype='object')" | |
| ] | |
| }, | |
| "execution_count": 50, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "behaviors_orig.columns" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 51, | |
| "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>Concat</th>\n", | |
| " <th>n_observations</th>\n", | |
| " <th>Missing_Shift</th>\n", | |
| " <th>Behavior_aggression</th>\n", | |
| " <th>Behavior_sib</th>\n", | |
| " <th>Behavior_elopement</th>\n", | |
| " <th>Behavior_disruptive</th>\n", | |
| " <th>Behavior_other</th>\n", | |
| " <th>Behavior_Episodes_aggression</th>\n", | |
| " <th>Behavior_Episodes_sib</th>\n", | |
| " <th>...</th>\n", | |
| " <th>Behavior_Episodes_disruptive</th>\n", | |
| " <th>Behavior_Episodes_other</th>\n", | |
| " <th>Behavior_LOA</th>\n", | |
| " <th>Behavior_None</th>\n", | |
| " <th>Behavior_No_Data_Recorded</th>\n", | |
| " <th>Behavior_No_Data_Recorded_aggression</th>\n", | |
| " <th>Behavior_No_Data_Recorded_sib</th>\n", | |
| " <th>Behavior_No_Data_Recorded_elopement</th>\n", | |
| " <th>Behavior_No_Data_Recorded_disruptive</th>\n", | |
| " <th>Behavior_No_Data_Recorded_other</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>0</th>\n", | |
| " <td>1 2019-09-15 07:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1</th>\n", | |
| " <td>1 2019-09-15 15:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2</th>\n", | |
| " <td>1 2019-09-15 23:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>3</th>\n", | |
| " <td>1 2019-09-16 07:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4</th>\n", | |
| " <td>1 2019-09-16 15:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>5</th>\n", | |
| " <td>1 2019-09-16 23:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>6</th>\n", | |
| " <td>1 2019-09-17 07:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>7</th>\n", | |
| " <td>1 2019-09-17 15:00:00</td>\n", | |
| " <td>3</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>8</th>\n", | |
| " <td>1 2019-09-17 23:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>9</th>\n", | |
| " <td>1 2019-09-18 07:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>10</th>\n", | |
| " <td>1 2019-09-18 15:00:00</td>\n", | |
| " <td>3</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>2.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>11</th>\n", | |
| " <td>1 2019-09-18 23:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>12</th>\n", | |
| " <td>1 2019-09-19 07:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>13</th>\n", | |
| " <td>1 2019-09-19 15:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>14</th>\n", | |
| " <td>1 2019-09-19 23:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>15</th>\n", | |
| " <td>1 2019-09-20 07:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>16</th>\n", | |
| " <td>1 2019-09-20 15:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>17</th>\n", | |
| " <td>1 2019-09-20 23:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>18</th>\n", | |
| " <td>1 2019-09-21 07:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>19</th>\n", | |
| " <td>1 2019-09-21 15:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>20</th>\n", | |
| " <td>1 2019-09-21 23:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>21</th>\n", | |
| " <td>1 2019-09-22 07:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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>22</th>\n", | |
| " <td>1 2019-09-22 15:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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>23</th>\n", | |
| " <td>1 2019-09-22 23:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>24</th>\n", | |
| " <td>1 2019-09-23 07:00:00</td>\n", | |
| " <td>3</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>2.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25</th>\n", | |
| " <td>1 2019-09-23 15:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>26</th>\n", | |
| " <td>1 2019-09-23 23:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>27</th>\n", | |
| " <td>1 2019-09-24 07:00:00</td>\n", | |
| " <td>4</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>2.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>28</th>\n", | |
| " <td>1 2019-09-24 15:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>29</th>\n", | |
| " <td>1 2019-09-24 23:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>30</th>\n", | |
| " <td>1 2019-09-25 07:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>31</th>\n", | |
| " <td>1 2019-09-25 15:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>32</th>\n", | |
| " <td>1 2019-09-25 23:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>33</th>\n", | |
| " <td>1 2019-09-26 07:00:00</td>\n", | |
| " <td>3</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>2.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>34</th>\n", | |
| " <td>1 2019-09-26 15:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>35</th>\n", | |
| " <td>1 2019-09-26 23:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>36</th>\n", | |
| " <td>1 2019-09-27 07:00:00</td>\n", | |
| " <td>3</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>2.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>37</th>\n", | |
| " <td>1 2019-09-27 15:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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>38</th>\n", | |
| " <td>1 2019-09-27 23:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>39</th>\n", | |
| " <td>1 2019-09-28 07:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>40</th>\n", | |
| " <td>1 2019-09-28 15:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>41</th>\n", | |
| " <td>1 2019-09-28 23:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>42</th>\n", | |
| " <td>1 2019-09-29 07:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>43</th>\n", | |
| " <td>1 2019-09-29 15:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>44</th>\n", | |
| " <td>1 2019-09-29 23:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>45</th>\n", | |
| " <td>1 2019-09-30 07:00:00</td>\n", | |
| " <td>3</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>2.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>46</th>\n", | |
| " <td>1 2019-09-30 15:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>47</th>\n", | |
| " <td>1 2019-09-30 23:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>48</th>\n", | |
| " <td>1 2019-10-01 07:00:00</td>\n", | |
| " <td>3</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>2.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>49</th>\n", | |
| " <td>1 2019-10-01 15:00:00</td>\n", | |
| " <td>3</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>50</th>\n", | |
| " <td>1 2019-10-01 23:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>51</th>\n", | |
| " <td>1 2019-10-02 07:00:00</td>\n", | |
| " <td>3</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>2.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>52</th>\n", | |
| " <td>1 2019-10-02 15:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>53</th>\n", | |
| " <td>1 2019-10-02 23:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>54</th>\n", | |
| " <td>1 2019-10-03 07:00:00</td>\n", | |
| " <td>3</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>2.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>55</th>\n", | |
| " <td>1 2019-10-03 15:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>56</th>\n", | |
| " <td>1 2019-10-03 23:00:00</td>\n", | |
| " <td>5</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>5.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>57</th>\n", | |
| " <td>1 2019-10-04 07:00:00</td>\n", | |
| " <td>3</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>2.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", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>58</th>\n", | |
| " <td>1 2019-10-04 15:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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>59</th>\n", | |
| " <td>1 2019-10-04 23:00:00</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.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", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>60 rows × 21 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " Concat n_observations Missing_Shift Behavior_aggression \\\n", | |
| "0 1 2019-09-15 07:00:00 1 0 0 \n", | |
| "1 1 2019-09-15 15:00:00 1 0 0 \n", | |
| "2 1 2019-09-15 23:00:00 5 0 0 \n", | |
| "3 1 2019-09-16 07:00:00 5 0 0 \n", | |
| "4 1 2019-09-16 15:00:00 5 0 0 \n", | |
| "5 1 2019-09-16 23:00:00 5 0 0 \n", | |
| "6 1 2019-09-17 07:00:00 5 0 0 \n", | |
| "7 1 2019-09-17 15:00:00 3 0 0 \n", | |
| "8 1 2019-09-17 23:00:00 5 0 0 \n", | |
| "9 1 2019-09-18 07:00:00 5 0 0 \n", | |
| "10 1 2019-09-18 15:00:00 3 0 0 \n", | |
| "11 1 2019-09-18 23:00:00 5 0 0 \n", | |
| "12 1 2019-09-19 07:00:00 5 0 0 \n", | |
| "13 1 2019-09-19 15:00:00 5 0 0 \n", | |
| "14 1 2019-09-19 23:00:00 5 0 0 \n", | |
| "15 1 2019-09-20 07:00:00 5 0 0 \n", | |
| "16 1 2019-09-20 15:00:00 1 0 0 \n", | |
| "17 1 2019-09-20 23:00:00 1 0 0 \n", | |
| "18 1 2019-09-21 07:00:00 1 0 0 \n", | |
| "19 1 2019-09-21 15:00:00 1 0 0 \n", | |
| "20 1 2019-09-21 23:00:00 1 0 0 \n", | |
| "21 1 2019-09-22 07:00:00 1 0 0 \n", | |
| "22 1 2019-09-22 15:00:00 1 0 0 \n", | |
| "23 1 2019-09-22 23:00:00 5 0 0 \n", | |
| "24 1 2019-09-23 07:00:00 3 0 0 \n", | |
| "25 1 2019-09-23 15:00:00 5 0 0 \n", | |
| "26 1 2019-09-23 23:00:00 5 0 0 \n", | |
| "27 1 2019-09-24 07:00:00 4 0 0 \n", | |
| "28 1 2019-09-24 15:00:00 5 0 0 \n", | |
| "29 1 2019-09-24 23:00:00 5 0 0 \n", | |
| "30 1 2019-09-25 07:00:00 5 0 0 \n", | |
| "31 1 2019-09-25 15:00:00 5 0 0 \n", | |
| "32 1 2019-09-25 23:00:00 5 0 0 \n", | |
| "33 1 2019-09-26 07:00:00 3 0 0 \n", | |
| "34 1 2019-09-26 15:00:00 5 0 0 \n", | |
| "35 1 2019-09-26 23:00:00 5 0 0 \n", | |
| "36 1 2019-09-27 07:00:00 3 0 0 \n", | |
| "37 1 2019-09-27 15:00:00 1 0 0 \n", | |
| "38 1 2019-09-27 23:00:00 1 0 0 \n", | |
| "39 1 2019-09-28 07:00:00 1 0 0 \n", | |
| "40 1 2019-09-28 15:00:00 1 0 0 \n", | |
| "41 1 2019-09-28 23:00:00 1 0 0 \n", | |
| "42 1 2019-09-29 07:00:00 1 0 0 \n", | |
| "43 1 2019-09-29 15:00:00 1 0 0 \n", | |
| "44 1 2019-09-29 23:00:00 5 0 0 \n", | |
| "45 1 2019-09-30 07:00:00 3 0 0 \n", | |
| "46 1 2019-09-30 15:00:00 5 0 0 \n", | |
| "47 1 2019-09-30 23:00:00 5 0 0 \n", | |
| "48 1 2019-10-01 07:00:00 3 0 0 \n", | |
| "49 1 2019-10-01 15:00:00 3 0 0 \n", | |
| "50 1 2019-10-01 23:00:00 5 0 0 \n", | |
| "51 1 2019-10-02 07:00:00 3 0 0 \n", | |
| "52 1 2019-10-02 15:00:00 5 0 0 \n", | |
| "53 1 2019-10-02 23:00:00 5 0 0 \n", | |
| "54 1 2019-10-03 07:00:00 3 0 0 \n", | |
| "55 1 2019-10-03 15:00:00 5 0 0 \n", | |
| "56 1 2019-10-03 23:00:00 5 0 0 \n", | |
| "57 1 2019-10-04 07:00:00 3 0 0 \n", | |
| "58 1 2019-10-04 15:00:00 1 0 0 \n", | |
| "59 1 2019-10-04 23:00:00 1 0 0 \n", | |
| "\n", | |
| " Behavior_sib Behavior_elopement Behavior_disruptive Behavior_other \\\n", | |
| "0 0 0 0 0 \n", | |
| "1 0 0 0 0 \n", | |
| "2 0 0 0 0 \n", | |
| "3 0 0 0 0 \n", | |
| "4 0 0 0 0 \n", | |
| "5 0 0 0 0 \n", | |
| "6 0 0 0 0 \n", | |
| "7 1 0 1 0 \n", | |
| "8 0 0 0 0 \n", | |
| "9 0 0 0 0 \n", | |
| "10 0 0 1 0 \n", | |
| "11 0 0 0 0 \n", | |
| "12 0 0 0 0 \n", | |
| "13 0 0 0 0 \n", | |
| "14 0 0 0 0 \n", | |
| "15 0 0 0 0 \n", | |
| "16 0 0 0 0 \n", | |
| "17 0 0 0 0 \n", | |
| "18 0 0 0 0 \n", | |
| "19 0 0 0 0 \n", | |
| "20 0 0 0 0 \n", | |
| "21 0 0 0 0 \n", | |
| "22 0 0 0 0 \n", | |
| "23 0 0 0 0 \n", | |
| "24 0 0 0 1 \n", | |
| "25 0 0 0 0 \n", | |
| "26 0 0 0 0 \n", | |
| "27 0 0 1 1 \n", | |
| "28 0 0 0 0 \n", | |
| "29 0 0 0 0 \n", | |
| "30 0 0 0 0 \n", | |
| "31 0 0 0 0 \n", | |
| "32 0 0 0 0 \n", | |
| "33 0 0 0 1 \n", | |
| "34 0 0 0 0 \n", | |
| "35 0 0 0 0 \n", | |
| "36 0 0 0 1 \n", | |
| "37 0 0 0 0 \n", | |
| "38 0 0 0 0 \n", | |
| "39 0 0 0 0 \n", | |
| "40 0 0 0 0 \n", | |
| "41 0 0 0 0 \n", | |
| "42 0 0 0 0 \n", | |
| "43 0 0 0 0 \n", | |
| "44 0 0 0 0 \n", | |
| "45 0 0 0 1 \n", | |
| "46 0 0 0 0 \n", | |
| "47 0 0 0 0 \n", | |
| "48 0 0 0 1 \n", | |
| "49 1 0 0 1 \n", | |
| "50 0 0 0 0 \n", | |
| "51 0 0 0 1 \n", | |
| "52 0 0 0 0 \n", | |
| "53 0 0 0 0 \n", | |
| "54 0 0 0 1 \n", | |
| "55 0 0 0 0 \n", | |
| "56 0 0 0 0 \n", | |
| "57 0 0 0 1 \n", | |
| "58 0 0 0 0 \n", | |
| "59 0 0 0 0 \n", | |
| "\n", | |
| " Behavior_Episodes_aggression Behavior_Episodes_sib ... \\\n", | |
| "0 0.0 0.0 ... \n", | |
| "1 0.0 0.0 ... \n", | |
| "2 0.0 0.0 ... \n", | |
| "3 0.0 0.0 ... \n", | |
| "4 0.0 0.0 ... \n", | |
| "5 0.0 0.0 ... \n", | |
| "6 0.0 0.0 ... \n", | |
| "7 0.0 1.0 ... \n", | |
| "8 0.0 0.0 ... \n", | |
| "9 0.0 0.0 ... \n", | |
| "10 0.0 0.0 ... \n", | |
| "11 0.0 0.0 ... \n", | |
| "12 0.0 0.0 ... \n", | |
| "13 0.0 0.0 ... \n", | |
| "14 0.0 0.0 ... \n", | |
| "15 0.0 0.0 ... \n", | |
| "16 0.0 0.0 ... \n", | |
| "17 0.0 0.0 ... \n", | |
| "18 0.0 0.0 ... \n", | |
| "19 0.0 0.0 ... \n", | |
| "20 0.0 0.0 ... \n", | |
| "21 0.0 0.0 ... \n", | |
| "22 0.0 0.0 ... \n", | |
| "23 0.0 0.0 ... \n", | |
| "24 0.0 0.0 ... \n", | |
| "25 0.0 0.0 ... \n", | |
| "26 0.0 0.0 ... \n", | |
| "27 0.0 0.0 ... \n", | |
| "28 0.0 0.0 ... \n", | |
| "29 0.0 0.0 ... \n", | |
| "30 0.0 0.0 ... \n", | |
| "31 0.0 0.0 ... \n", | |
| "32 0.0 0.0 ... \n", | |
| "33 0.0 0.0 ... \n", | |
| "34 0.0 0.0 ... \n", | |
| "35 0.0 0.0 ... \n", | |
| "36 0.0 0.0 ... \n", | |
| "37 0.0 0.0 ... \n", | |
| "38 0.0 0.0 ... \n", | |
| "39 0.0 0.0 ... \n", | |
| "40 0.0 0.0 ... \n", | |
| "41 0.0 0.0 ... \n", | |
| "42 0.0 0.0 ... \n", | |
| "43 0.0 0.0 ... \n", | |
| "44 0.0 0.0 ... \n", | |
| "45 0.0 0.0 ... \n", | |
| "46 0.0 0.0 ... \n", | |
| "47 0.0 0.0 ... \n", | |
| "48 0.0 0.0 ... \n", | |
| "49 0.0 2.0 ... \n", | |
| "50 0.0 0.0 ... \n", | |
| "51 0.0 0.0 ... \n", | |
| "52 0.0 0.0 ... \n", | |
| "53 0.0 0.0 ... \n", | |
| "54 0.0 0.0 ... \n", | |
| "55 0.0 0.0 ... \n", | |
| "56 0.0 0.0 ... \n", | |
| "57 0.0 0.0 ... \n", | |
| "58 0.0 0.0 ... \n", | |
| "59 0.0 0.0 ... \n", | |
| "\n", | |
| " Behavior_Episodes_disruptive Behavior_Episodes_other Behavior_LOA \\\n", | |
| "0 0.0 0.0 1.0 \n", | |
| "1 0.0 0.0 1.0 \n", | |
| "2 0.0 0.0 0.0 \n", | |
| "3 0.0 0.0 0.0 \n", | |
| "4 0.0 0.0 0.0 \n", | |
| "5 0.0 0.0 0.0 \n", | |
| "6 0.0 0.0 0.0 \n", | |
| "7 2.0 0.0 0.0 \n", | |
| "8 0.0 0.0 0.0 \n", | |
| "9 0.0 0.0 0.0 \n", | |
| "10 1.0 0.0 0.0 \n", | |
| "11 0.0 0.0 0.0 \n", | |
| "12 0.0 0.0 0.0 \n", | |
| "13 0.0 0.0 0.0 \n", | |
| "14 0.0 0.0 0.0 \n", | |
| "15 0.0 0.0 0.0 \n", | |
| "16 0.0 0.0 1.0 \n", | |
| "17 0.0 0.0 1.0 \n", | |
| "18 0.0 0.0 1.0 \n", | |
| "19 0.0 0.0 1.0 \n", | |
| "20 0.0 0.0 1.0 \n", | |
| "21 0.0 0.0 0.0 \n", | |
| "22 0.0 0.0 0.0 \n", | |
| "23 0.0 0.0 0.0 \n", | |
| "24 0.0 2.0 0.0 \n", | |
| "25 0.0 0.0 0.0 \n", | |
| "26 0.0 0.0 0.0 \n", | |
| "27 3.0 3.0 0.0 \n", | |
| "28 0.0 0.0 0.0 \n", | |
| "29 0.0 0.0 0.0 \n", | |
| "30 0.0 0.0 0.0 \n", | |
| "31 0.0 0.0 0.0 \n", | |
| "32 0.0 0.0 0.0 \n", | |
| "33 0.0 1.0 0.0 \n", | |
| "34 0.0 0.0 0.0 \n", | |
| "35 0.0 0.0 0.0 \n", | |
| "36 0.0 1.0 0.0 \n", | |
| "37 0.0 0.0 0.0 \n", | |
| "38 0.0 0.0 1.0 \n", | |
| "39 0.0 0.0 1.0 \n", | |
| "40 0.0 0.0 1.0 \n", | |
| "41 0.0 0.0 1.0 \n", | |
| "42 0.0 0.0 1.0 \n", | |
| "43 0.0 0.0 1.0 \n", | |
| "44 0.0 0.0 0.0 \n", | |
| "45 0.0 1.0 0.0 \n", | |
| "46 0.0 0.0 0.0 \n", | |
| "47 0.0 0.0 0.0 \n", | |
| "48 0.0 1.0 0.0 \n", | |
| "49 0.0 3.0 0.0 \n", | |
| "50 0.0 0.0 0.0 \n", | |
| "51 0.0 1.0 0.0 \n", | |
| "52 0.0 0.0 0.0 \n", | |
| "53 0.0 0.0 0.0 \n", | |
| "54 0.0 1.0 0.0 \n", | |
| "55 0.0 0.0 0.0 \n", | |
| "56 0.0 0.0 0.0 \n", | |
| "57 0.0 1.0 0.0 \n", | |
| "58 0.0 0.0 0.0 \n", | |
| "59 0.0 0.0 1.0 \n", | |
| "\n", | |
| " Behavior_None Behavior_No_Data_Recorded \\\n", | |
| "0 0.0 0.0 \n", | |
| "1 0.0 0.0 \n", | |
| "2 5.0 0.0 \n", | |
| "3 5.0 0.0 \n", | |
| "4 5.0 0.0 \n", | |
| "5 5.0 0.0 \n", | |
| "6 5.0 0.0 \n", | |
| "7 1.0 0.0 \n", | |
| "8 5.0 0.0 \n", | |
| "9 5.0 0.0 \n", | |
| "10 2.0 0.0 \n", | |
| "11 5.0 0.0 \n", | |
| "12 5.0 0.0 \n", | |
| "13 5.0 0.0 \n", | |
| "14 5.0 0.0 \n", | |
| "15 5.0 0.0 \n", | |
| "16 0.0 0.0 \n", | |
| "17 0.0 0.0 \n", | |
| "18 0.0 0.0 \n", | |
| "19 0.0 0.0 \n", | |
| "20 0.0 0.0 \n", | |
| "21 0.0 1.0 \n", | |
| "22 0.0 1.0 \n", | |
| "23 5.0 0.0 \n", | |
| "24 2.0 0.0 \n", | |
| "25 5.0 0.0 \n", | |
| "26 5.0 0.0 \n", | |
| "27 2.0 0.0 \n", | |
| "28 5.0 0.0 \n", | |
| "29 5.0 0.0 \n", | |
| "30 5.0 0.0 \n", | |
| "31 5.0 0.0 \n", | |
| "32 5.0 0.0 \n", | |
| "33 2.0 0.0 \n", | |
| "34 5.0 0.0 \n", | |
| "35 5.0 0.0 \n", | |
| "36 2.0 0.0 \n", | |
| "37 0.0 1.0 \n", | |
| "38 0.0 0.0 \n", | |
| "39 0.0 0.0 \n", | |
| "40 0.0 0.0 \n", | |
| "41 0.0 0.0 \n", | |
| "42 0.0 0.0 \n", | |
| "43 0.0 0.0 \n", | |
| "44 5.0 0.0 \n", | |
| "45 2.0 0.0 \n", | |
| "46 5.0 0.0 \n", | |
| "47 5.0 0.0 \n", | |
| "48 2.0 0.0 \n", | |
| "49 1.0 0.0 \n", | |
| "50 5.0 0.0 \n", | |
| "51 2.0 0.0 \n", | |
| "52 5.0 0.0 \n", | |
| "53 5.0 0.0 \n", | |
| "54 2.0 0.0 \n", | |
| "55 5.0 0.0 \n", | |
| "56 5.0 0.0 \n", | |
| "57 2.0 0.0 \n", | |
| "58 0.0 1.0 \n", | |
| "59 0.0 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_aggression Behavior_No_Data_Recorded_sib \\\n", | |
| "0 0.0 0.0 \n", | |
| "1 0.0 0.0 \n", | |
| "2 0.0 0.0 \n", | |
| "3 0.0 0.0 \n", | |
| "4 0.0 0.0 \n", | |
| "5 0.0 0.0 \n", | |
| "6 0.0 0.0 \n", | |
| "7 0.0 0.0 \n", | |
| "8 0.0 0.0 \n", | |
| "9 0.0 0.0 \n", | |
| "10 0.0 0.0 \n", | |
| "11 0.0 0.0 \n", | |
| "12 0.0 0.0 \n", | |
| "13 0.0 0.0 \n", | |
| "14 0.0 0.0 \n", | |
| "15 0.0 0.0 \n", | |
| "16 0.0 0.0 \n", | |
| "17 0.0 0.0 \n", | |
| "18 0.0 0.0 \n", | |
| "19 0.0 0.0 \n", | |
| "20 0.0 0.0 \n", | |
| "21 0.0 0.0 \n", | |
| "22 0.0 0.0 \n", | |
| "23 0.0 0.0 \n", | |
| "24 0.0 0.0 \n", | |
| "25 0.0 0.0 \n", | |
| "26 0.0 0.0 \n", | |
| "27 0.0 0.0 \n", | |
| "28 0.0 0.0 \n", | |
| "29 0.0 0.0 \n", | |
| "30 0.0 0.0 \n", | |
| "31 0.0 0.0 \n", | |
| "32 0.0 0.0 \n", | |
| "33 0.0 0.0 \n", | |
| "34 0.0 0.0 \n", | |
| "35 0.0 0.0 \n", | |
| "36 0.0 0.0 \n", | |
| "37 0.0 0.0 \n", | |
| "38 0.0 0.0 \n", | |
| "39 0.0 0.0 \n", | |
| "40 0.0 0.0 \n", | |
| "41 0.0 0.0 \n", | |
| "42 0.0 0.0 \n", | |
| "43 0.0 0.0 \n", | |
| "44 0.0 0.0 \n", | |
| "45 0.0 0.0 \n", | |
| "46 0.0 0.0 \n", | |
| "47 0.0 0.0 \n", | |
| "48 0.0 0.0 \n", | |
| "49 0.0 0.0 \n", | |
| "50 0.0 0.0 \n", | |
| "51 0.0 0.0 \n", | |
| "52 0.0 0.0 \n", | |
| "53 0.0 0.0 \n", | |
| "54 0.0 0.0 \n", | |
| "55 0.0 0.0 \n", | |
| "56 0.0 0.0 \n", | |
| "57 0.0 0.0 \n", | |
| "58 0.0 0.0 \n", | |
| "59 0.0 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_elopement Behavior_No_Data_Recorded_disruptive \\\n", | |
| "0 0.0 0.0 \n", | |
| "1 0.0 0.0 \n", | |
| "2 0.0 0.0 \n", | |
| "3 0.0 0.0 \n", | |
| "4 0.0 0.0 \n", | |
| "5 0.0 0.0 \n", | |
| "6 0.0 0.0 \n", | |
| "7 0.0 0.0 \n", | |
| "8 0.0 0.0 \n", | |
| "9 0.0 0.0 \n", | |
| "10 0.0 0.0 \n", | |
| "11 0.0 0.0 \n", | |
| "12 0.0 0.0 \n", | |
| "13 0.0 0.0 \n", | |
| "14 0.0 0.0 \n", | |
| "15 0.0 0.0 \n", | |
| "16 0.0 0.0 \n", | |
| "17 0.0 0.0 \n", | |
| "18 0.0 0.0 \n", | |
| "19 0.0 0.0 \n", | |
| "20 0.0 0.0 \n", | |
| "21 0.0 0.0 \n", | |
| "22 0.0 0.0 \n", | |
| "23 0.0 0.0 \n", | |
| "24 0.0 0.0 \n", | |
| "25 0.0 0.0 \n", | |
| "26 0.0 0.0 \n", | |
| "27 0.0 0.0 \n", | |
| "28 0.0 0.0 \n", | |
| "29 0.0 0.0 \n", | |
| "30 0.0 0.0 \n", | |
| "31 0.0 0.0 \n", | |
| "32 0.0 0.0 \n", | |
| "33 0.0 0.0 \n", | |
| "34 0.0 0.0 \n", | |
| "35 0.0 0.0 \n", | |
| "36 0.0 0.0 \n", | |
| "37 0.0 0.0 \n", | |
| "38 0.0 0.0 \n", | |
| "39 0.0 0.0 \n", | |
| "40 0.0 0.0 \n", | |
| "41 0.0 0.0 \n", | |
| "42 0.0 0.0 \n", | |
| "43 0.0 0.0 \n", | |
| "44 0.0 0.0 \n", | |
| "45 0.0 0.0 \n", | |
| "46 0.0 0.0 \n", | |
| "47 0.0 0.0 \n", | |
| "48 0.0 0.0 \n", | |
| "49 0.0 0.0 \n", | |
| "50 0.0 0.0 \n", | |
| "51 0.0 0.0 \n", | |
| "52 0.0 0.0 \n", | |
| "53 0.0 0.0 \n", | |
| "54 0.0 0.0 \n", | |
| "55 0.0 0.0 \n", | |
| "56 0.0 0.0 \n", | |
| "57 0.0 0.0 \n", | |
| "58 0.0 0.0 \n", | |
| "59 0.0 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_other \n", | |
| "0 0.0 \n", | |
| "1 0.0 \n", | |
| "2 0.0 \n", | |
| "3 0.0 \n", | |
| "4 0.0 \n", | |
| "5 0.0 \n", | |
| "6 0.0 \n", | |
| "7 0.0 \n", | |
| "8 0.0 \n", | |
| "9 0.0 \n", | |
| "10 0.0 \n", | |
| "11 0.0 \n", | |
| "12 0.0 \n", | |
| "13 0.0 \n", | |
| "14 0.0 \n", | |
| "15 0.0 \n", | |
| "16 0.0 \n", | |
| "17 0.0 \n", | |
| "18 0.0 \n", | |
| "19 0.0 \n", | |
| "20 0.0 \n", | |
| "21 0.0 \n", | |
| "22 0.0 \n", | |
| "23 0.0 \n", | |
| "24 0.0 \n", | |
| "25 0.0 \n", | |
| "26 0.0 \n", | |
| "27 0.0 \n", | |
| "28 0.0 \n", | |
| "29 0.0 \n", | |
| "30 0.0 \n", | |
| "31 0.0 \n", | |
| "32 0.0 \n", | |
| "33 0.0 \n", | |
| "34 0.0 \n", | |
| "35 0.0 \n", | |
| "36 0.0 \n", | |
| "37 0.0 \n", | |
| "38 0.0 \n", | |
| "39 0.0 \n", | |
| "40 0.0 \n", | |
| "41 0.0 \n", | |
| "42 0.0 \n", | |
| "43 0.0 \n", | |
| "44 0.0 \n", | |
| "45 0.0 \n", | |
| "46 0.0 \n", | |
| "47 0.0 \n", | |
| "48 0.0 \n", | |
| "49 0.0 \n", | |
| "50 0.0 \n", | |
| "51 0.0 \n", | |
| "52 0.0 \n", | |
| "53 0.0 \n", | |
| "54 0.0 \n", | |
| "55 0.0 \n", | |
| "56 0.0 \n", | |
| "57 0.0 \n", | |
| "58 0.0 \n", | |
| "59 0.0 \n", | |
| "\n", | |
| "[60 rows x 21 columns]" | |
| ] | |
| }, | |
| "execution_count": 51, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "behaviors_orig.head(60)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 52, | |
| "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>Date</th>\n", | |
| " <th>Person_ID</th>\n", | |
| " <th>Missing_Shift07:00:00</th>\n", | |
| " <th>Missing_Shift15:00:00</th>\n", | |
| " <th>Missing_Shift23:00:00</th>\n", | |
| " <th>Behavior_aggression07:00:00</th>\n", | |
| " <th>Behavior_aggression15:00:00</th>\n", | |
| " <th>Behavior_aggression23:00:00</th>\n", | |
| " <th>Behavior_sib07:00:00</th>\n", | |
| " <th>Behavior_sib15:00:00</th>\n", | |
| " <th>...</th>\n", | |
| " <th>Behavior_No_Data_Recorded_elopement23:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_disruptive07:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_disruptive15:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_disruptive23:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_other07:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_other15:00:00</th>\n", | |
| " <th>Behavior_No_Data_Recorded_other23:00:00</th>\n", | |
| " <th>Concat_Date07:00:00</th>\n", | |
| " <th>Concat_Date15:00:00</th>\n", | |
| " <th>Concat_Date23:00:00</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>1514</th>\n", | |
| " <td>2020-02-17</td>\n", | |
| " <td>13</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>13 2020-02-17</td>\n", | |
| " <td>13 2020-02-17</td>\n", | |
| " <td>13 2020-02-17</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2444</th>\n", | |
| " <td>2019-10-18</td>\n", | |
| " <td>16</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>16 2019-10-18</td>\n", | |
| " <td>16 2019-10-18</td>\n", | |
| " <td>16 2019-10-18</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2491</th>\n", | |
| " <td>2019-12-04</td>\n", | |
| " <td>16</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>16 2019-12-04</td>\n", | |
| " <td>16 2019-12-04</td>\n", | |
| " <td>16 2019-12-04</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2820</th>\n", | |
| " <td>2019-11-03</td>\n", | |
| " <td>17</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>17 2019-11-03</td>\n", | |
| " <td>17 2019-11-03</td>\n", | |
| " <td>17 2019-11-03</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>6396</th>\n", | |
| " <td>2019-10-10</td>\n", | |
| " <td>26</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>26 2019-10-10</td>\n", | |
| " <td>26 2019-10-10</td>\n", | |
| " <td>26 2019-10-10</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>6566</th>\n", | |
| " <td>2020-03-28</td>\n", | |
| " <td>26</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>26 2020-03-28</td>\n", | |
| " <td>26 2020-03-28</td>\n", | |
| " <td>26 2020-03-28</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>7809</th>\n", | |
| " <td>2020-09-07</td>\n", | |
| " <td>29</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>29 2020-09-07</td>\n", | |
| " <td>29 2020-09-07</td>\n", | |
| " <td>29 2020-09-07</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>8516</th>\n", | |
| " <td>2020-08-25</td>\n", | |
| " <td>30</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</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>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>30 2020-08-25</td>\n", | |
| " <td>30 2020-08-25</td>\n", | |
| " <td>30 2020-08-25</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>8955</th>\n", | |
| " <td>2019-11-18</td>\n", | |
| " <td>32</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>32 2019-11-18</td>\n", | |
| " <td>32 2019-11-18</td>\n", | |
| " <td>32 2019-11-18</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>9529</th>\n", | |
| " <td>2020-06-19</td>\n", | |
| " <td>33</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>33 2020-06-19</td>\n", | |
| " <td>33 2020-06-19</td>\n", | |
| " <td>33 2020-06-19</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>13921</th>\n", | |
| " <td>2020-06-23</td>\n", | |
| " <td>45</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>45 2020-06-23</td>\n", | |
| " <td>45 2020-06-23</td>\n", | |
| " <td>45 2020-06-23</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>15119</th>\n", | |
| " <td>2019-10-25</td>\n", | |
| " <td>49</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>0.0</td>\n", | |
| " <td>...</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", | |
| " <td>0.0</td>\n", | |
| " <td>49 2019-10-25</td>\n", | |
| " <td>49 2019-10-25</td>\n", | |
| " <td>49 2019-10-25</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>12 rows × 62 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " Date Person_ID Missing_Shift07:00:00 Missing_Shift15:00:00 \\\n", | |
| "1514 2020-02-17 13 0 0 \n", | |
| "2444 2019-10-18 16 0 0 \n", | |
| "2491 2019-12-04 16 0 0 \n", | |
| "2820 2019-11-03 17 0 0 \n", | |
| "6396 2019-10-10 26 0 0 \n", | |
| "6566 2020-03-28 26 0 0 \n", | |
| "7809 2020-09-07 29 0 0 \n", | |
| "8516 2020-08-25 30 0 0 \n", | |
| "8955 2019-11-18 32 0 0 \n", | |
| "9529 2020-06-19 33 0 0 \n", | |
| "13921 2020-06-23 45 0 0 \n", | |
| "15119 2019-10-25 49 0 0 \n", | |
| "\n", | |
| " Missing_Shift23:00:00 Behavior_aggression07:00:00 \\\n", | |
| "1514 0 1.0 \n", | |
| "2444 0 1.0 \n", | |
| "2491 0 0.0 \n", | |
| "2820 0 0.0 \n", | |
| "6396 0 0.0 \n", | |
| "6566 0 1.0 \n", | |
| "7809 0 0.0 \n", | |
| "8516 0 1.0 \n", | |
| "8955 0 1.0 \n", | |
| "9529 0 0.0 \n", | |
| "13921 0 0.0 \n", | |
| "15119 0 0.0 \n", | |
| "\n", | |
| " Behavior_aggression15:00:00 Behavior_aggression23:00:00 \\\n", | |
| "1514 NaN 0.0 \n", | |
| "2444 NaN 0.0 \n", | |
| "2491 NaN 0.0 \n", | |
| "2820 NaN 0.0 \n", | |
| "6396 NaN 0.0 \n", | |
| "6566 NaN 0.0 \n", | |
| "7809 NaN 0.0 \n", | |
| "8516 NaN 0.0 \n", | |
| "8955 NaN 0.0 \n", | |
| "9529 NaN 0.0 \n", | |
| "13921 NaN 0.0 \n", | |
| "15119 NaN 0.0 \n", | |
| "\n", | |
| " Behavior_sib07:00:00 Behavior_sib15:00:00 ... \\\n", | |
| "1514 1.0 NaN ... \n", | |
| "2444 1.0 NaN ... \n", | |
| "2491 1.0 NaN ... \n", | |
| "2820 0.0 0.0 ... \n", | |
| "6396 0.0 NaN ... \n", | |
| "6566 0.0 NaN ... \n", | |
| "7809 0.0 0.0 ... \n", | |
| "8516 1.0 NaN ... \n", | |
| "8955 0.0 0.0 ... \n", | |
| "9529 0.0 0.0 ... \n", | |
| "13921 0.0 0.0 ... \n", | |
| "15119 0.0 0.0 ... \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_elopement23:00:00 \\\n", | |
| "1514 0.0 \n", | |
| "2444 0.0 \n", | |
| "2491 0.0 \n", | |
| "2820 0.0 \n", | |
| "6396 0.0 \n", | |
| "6566 0.0 \n", | |
| "7809 0.0 \n", | |
| "8516 0.0 \n", | |
| "8955 0.0 \n", | |
| "9529 0.0 \n", | |
| "13921 0.0 \n", | |
| "15119 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_disruptive07:00:00 \\\n", | |
| "1514 0.0 \n", | |
| "2444 0.0 \n", | |
| "2491 0.0 \n", | |
| "2820 0.0 \n", | |
| "6396 0.0 \n", | |
| "6566 0.0 \n", | |
| "7809 0.0 \n", | |
| "8516 0.0 \n", | |
| "8955 0.0 \n", | |
| "9529 0.0 \n", | |
| "13921 0.0 \n", | |
| "15119 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_disruptive15:00:00 \\\n", | |
| "1514 1.0 \n", | |
| "2444 1.0 \n", | |
| "2491 1.0 \n", | |
| "2820 0.0 \n", | |
| "6396 1.0 \n", | |
| "6566 1.0 \n", | |
| "7809 0.0 \n", | |
| "8516 0.0 \n", | |
| "8955 1.0 \n", | |
| "9529 0.0 \n", | |
| "13921 0.0 \n", | |
| "15119 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_disruptive23:00:00 \\\n", | |
| "1514 0.0 \n", | |
| "2444 0.0 \n", | |
| "2491 0.0 \n", | |
| "2820 0.0 \n", | |
| "6396 0.0 \n", | |
| "6566 0.0 \n", | |
| "7809 0.0 \n", | |
| "8516 0.0 \n", | |
| "8955 0.0 \n", | |
| "9529 0.0 \n", | |
| "13921 0.0 \n", | |
| "15119 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_other07:00:00 \\\n", | |
| "1514 0.0 \n", | |
| "2444 0.0 \n", | |
| "2491 0.0 \n", | |
| "2820 0.0 \n", | |
| "6396 0.0 \n", | |
| "6566 0.0 \n", | |
| "7809 0.0 \n", | |
| "8516 0.0 \n", | |
| "8955 0.0 \n", | |
| "9529 0.0 \n", | |
| "13921 0.0 \n", | |
| "15119 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_other15:00:00 \\\n", | |
| "1514 0.0 \n", | |
| "2444 0.0 \n", | |
| "2491 0.0 \n", | |
| "2820 0.0 \n", | |
| "6396 0.0 \n", | |
| "6566 0.0 \n", | |
| "7809 1.0 \n", | |
| "8516 1.0 \n", | |
| "8955 0.0 \n", | |
| "9529 0.0 \n", | |
| "13921 0.0 \n", | |
| "15119 0.0 \n", | |
| "\n", | |
| " Behavior_No_Data_Recorded_other23:00:00 Concat_Date07:00:00 \\\n", | |
| "1514 0.0 13 2020-02-17 \n", | |
| "2444 0.0 16 2019-10-18 \n", | |
| "2491 0.0 16 2019-12-04 \n", | |
| "2820 0.0 17 2019-11-03 \n", | |
| "6396 0.0 26 2019-10-10 \n", | |
| "6566 0.0 26 2020-03-28 \n", | |
| "7809 0.0 29 2020-09-07 \n", | |
| "8516 0.0 30 2020-08-25 \n", | |
| "8955 0.0 32 2019-11-18 \n", | |
| "9529 0.0 33 2020-06-19 \n", | |
| "13921 0.0 45 2020-06-23 \n", | |
| "15119 0.0 49 2019-10-25 \n", | |
| "\n", | |
| " Concat_Date15:00:00 Concat_Date23:00:00 \n", | |
| "1514 13 2020-02-17 13 2020-02-17 \n", | |
| "2444 16 2019-10-18 16 2019-10-18 \n", | |
| "2491 16 2019-12-04 16 2019-12-04 \n", | |
| "2820 17 2019-11-03 17 2019-11-03 \n", | |
| "6396 26 2019-10-10 26 2019-10-10 \n", | |
| "6566 26 2020-03-28 26 2020-03-28 \n", | |
| "7809 29 2020-09-07 29 2020-09-07 \n", | |
| "8516 30 2020-08-25 30 2020-08-25 \n", | |
| "8955 32 2019-11-18 32 2019-11-18 \n", | |
| "9529 33 2020-06-19 33 2020-06-19 \n", | |
| "13921 45 2020-06-23 45 2020-06-23 \n", | |
| "15119 49 2019-10-25 49 2019-10-25 \n", | |
| "\n", | |
| "[12 rows x 62 columns]" | |
| ] | |
| }, | |
| "execution_count": 52, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "by_shift_pivoted.loc[by_shift_pivoted['Behavior_No_Data_Recorded_aggression15:00:00'] > 0]" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": null, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 53, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "for target in targets:\n", | |
| " for time in times:\n", | |
| " by_shift_pivoted.loc[by_shift_pivoted['Behavior_LOA' + time] > 0, 'Behavior_' +target + time] = float(\"NaN\")\n", | |
| " by_shift_pivoted.loc[by_shift_pivoted['Behavior_LOA' + time] > 0, 'Behavior_Episodes_' +target+ time] = float(\"NaN\")\n", | |
| "# by_shift_pivoted.loc[by_shift_pivoted['Behavior_No_Data_Recorded' + time] > 0, 'Behavior_' +target + time] = float(\"NaN\")\n", | |
| "# by_shift_pivoted.loc[by_shift_pivoted['Behavior_No_Data_Recorded' + time] > 0, 'Behavior_Episodes_' +target+ time] = float(\"NaN\")" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 54, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "for target in targets:\n", | |
| " cols = ['Behavior_'+target+time for time in times]\n", | |
| " by_shift_pivoted['Behavior_'+target] = by_shift_pivoted[cols].sum(axis=1,min_count=3) \n", | |
| " by_shift_pivoted['Behavior_'+target] = np.where(by_shift_pivoted['Behavior_'+target].isna(), float(\"NaN\"), (by_shift_pivoted['Behavior_'+target] > 0) * 1.0)\n", | |
| " cols = ['Behavior_Episodes_'+target+time for time in times]\n", | |
| " by_shift_pivoted['Behavior_Episodes_'+target] = by_shift_pivoted[cols].sum(axis=1, min_count=3)\n", | |
| " by_shift_pivoted['Behavior_Episodes_'+target] = np.where(by_shift_pivoted['Behavior_Episodes_'+target].isna(), float(\"NaN\"), by_shift_pivoted['Behavior_Episodes_'+target])" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 55, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "final_cols = ['Person_ID','Date'] + ['Behavior_'+target for target in targets] + ['Behavior_Episodes_'+target for target in targets]\n", | |
| "by_shift_pivoted = by_shift_pivoted[final_cols]" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 56, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "by_shift_pivoted.to_csv('behaviors_pivoted_deID.csv')" | |
| ] | |
| } | |
| ], | |
| "metadata": { | |
| "kernelspec": { | |
| "display_name": "myenv", | |
| "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.11.9" | |
| } | |
| }, | |
| "nbformat": 4, | |
| "nbformat_minor": 4 | |
| } |