{"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"name":"python","version":"3.11.11","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"},"kaggle":{"accelerator":"none","dataSources":[{"sourceId":102335,"databundleVersionId":12518947,"sourceType":"competition"}],"dockerImageVersionId":31040,"isInternetEnabled":true,"language":"python","sourceType":"notebook","isGpuEnabled":false}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"code","source":"import numpy as np \nimport pandas as pd \n\n# Input data files are available in the read-only \"../input/\" directory\n# For example, running this (by clicking run or pressing Shift+Enter) will list all files under the input directory\n\nimport os\nfor dirname, _, filenames in os.walk('/kaggle/input'):\n    for filename in filenames:\n        print(os.path.join(dirname, filename))\n\n# You can write up to 20GB to the current directory (/kaggle/working/) that gets preserved as output when you create a version using \"Save & Run All\" \n# You can also write temporary files to /kaggle/temp/, but they won't be saved outside of the current session","metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","trusted":true,"execution":{"iopub.status.busy":"2025-09-02T13:26:19.841554Z","iopub.execute_input":"2025-09-02T13:26:19.841876Z","iopub.status.idle":"2025-09-02T13:26:22.088545Z","shell.execute_reply.started":"2025-09-02T13:26:19.841846Z","shell.execute_reply":"2025-09-02T13:26:22.087628Z"}},"outputs":[{"name":"stdout","text":"/kaggle/input/cmi-detect-behavior-with-sensor-data/train_demographics.csv\n/kaggle/input/cmi-detect-behavior-with-sensor-data/test_demographics.csv\n/kaggle/input/cmi-detect-behavior-with-sensor-data/train.csv\n/kaggle/input/cmi-detect-behavior-with-sensor-data/test.csv\n/kaggle/input/cmi-detect-behavior-with-sensor-data/kaggle_evaluation/cmi_inference_server.py\n/kaggle/input/cmi-detect-behavior-with-sensor-data/kaggle_evaluation/cmi_gateway.py\n/kaggle/input/cmi-detect-behavior-with-sensor-data/kaggle_evaluation/__init__.py\n/kaggle/input/cmi-detect-behavior-with-sensor-data/kaggle_evaluation/core/templates.py\n/kaggle/input/cmi-detect-behavior-with-sensor-data/kaggle_evaluation/core/base_gateway.py\n/kaggle/input/cmi-detect-behavior-with-sensor-data/kaggle_evaluation/core/relay.py\n/kaggle/input/cmi-detect-behavior-with-sensor-data/kaggle_evaluation/core/kaggle_evaluation.proto\n/kaggle/input/cmi-detect-behavior-with-sensor-data/kaggle_evaluation/core/__init__.py\n/kaggle/input/cmi-detect-behavior-with-sensor-data/kaggle_evaluation/core/generated/kaggle_evaluation_pb2.py\n/kaggle/input/cmi-detect-behavior-with-sensor-data/kaggle_evaluation/core/generated/kaggle_evaluation_pb2_grpc.py\n/kaggle/input/cmi-detect-behavior-with-sensor-data/kaggle_evaluation/core/generated/__init__.py\n","output_type":"stream"}],"execution_count":1},{"cell_type":"code","source":"df=pd.read_csv('/kaggle/input/cmi-detect-behavior-with-sensor-data/train_demographics.csv')\ndf","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2025-09-02T13:26:31.340546Z","iopub.execute_input":"2025-09-02T13:26:31.340911Z","iopub.status.idle":"2025-09-02T13:26:31.392208Z","shell.execute_reply.started":"2025-09-02T13:26:31.340887Z","shell.execute_reply":"2025-09-02T13:26:31.391301Z"}},"outputs":[{"execution_count":2,"output_type":"execute_result","data":{"text/plain":"        subject  adult_child  age  sex  handedness  height_cm  \\\n0   SUBJ_000206            1   41    1           1      172.0   \n1   SUBJ_001430            0   11    0           1      167.0   \n2   SUBJ_002923            1   28    1           0      164.0   \n3   SUBJ_003328            1   33    1           1      171.0   \n4   SUBJ_004117            0   15    0           1      184.0   \n..          ...          ...  ...  ...         ...        ...   \n76  SUBJ_063319            1   25    1           1      173.0   \n77  SUBJ_063346            1   42    1           1      183.0   \n78  SUBJ_063447            1   36    0           1      175.0   \n79  SUBJ_063464            0   15    0           1      162.0   \n80  SUBJ_064387            0   17    1           1      155.0   \n\n    shoulder_to_wrist_cm  elbow_to_wrist_cm  \n0                     50               25.0  \n1                     51               27.0  \n2                     54               26.0  \n3                     52               25.0  \n4                     54               28.0  \n..                   ...                ...  \n76                    50               29.0  \n77                    51               26.0  \n78                    54               25.0  \n79                    43               23.0  \n80                    42               22.0  \n\n[81 rows x 8 columns]","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>subject</th>\n      <th>adult_child</th>\n      <th>age</th>\n      <th>sex</th>\n      <th>handedness</th>\n      <th>height_cm</th>\n      <th>shoulder_to_wrist_cm</th>\n      <th>elbow_to_wrist_cm</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>SUBJ_000206</td>\n      <td>1</td>\n      <td>41</td>\n      <td>1</td>\n      <td>1</td>\n      <td>172.0</td>\n      <td>50</td>\n      <td>25.0</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>SUBJ_001430</td>\n      <td>0</td>\n      <td>11</td>\n      <td>0</td>\n      <td>1</td>\n      <td>167.0</td>\n      <td>51</td>\n      <td>27.0</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>SUBJ_002923</td>\n      <td>1</td>\n      <td>28</td>\n      <td>1</td>\n      <td>0</td>\n      <td>164.0</td>\n      <td>54</td>\n      <td>26.0</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>SUBJ_003328</td>\n      <td>1</td>\n      <td>33</td>\n      <td>1</td>\n      <td>1</td>\n      <td>171.0</td>\n      <td>52</td>\n      <td>25.0</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>SUBJ_004117</td>\n      <td>0</td>\n      <td>15</td>\n      <td>0</td>\n      <td>1</td>\n      <td>184.0</td>\n      <td>54</td>\n      <td>28.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    </tr>\n    <tr>\n      <th>76</th>\n      <td>SUBJ_063319</td>\n      <td>1</td>\n      <td>25</td>\n      <td>1</td>\n      <td>1</td>\n      <td>173.0</td>\n      <td>50</td>\n      <td>29.0</td>\n    </tr>\n    <tr>\n      <th>77</th>\n      <td>SUBJ_063346</td>\n      <td>1</td>\n      <td>42</td>\n      <td>1</td>\n      <td>1</td>\n      <td>183.0</td>\n      <td>51</td>\n      <td>26.0</td>\n    </tr>\n    <tr>\n      <th>78</th>\n      <td>SUBJ_063447</td>\n      <td>1</td>\n      <td>36</td>\n      <td>0</td>\n      <td>1</td>\n      <td>175.0</td>\n      <td>54</td>\n      <td>25.0</td>\n    </tr>\n    <tr>\n      <th>79</th>\n      <td>SUBJ_063464</td>\n      <td>0</td>\n      <td>15</td>\n      <td>0</td>\n      <td>1</td>\n      <td>162.0</td>\n      <td>43</td>\n      <td>23.0</td>\n    </tr>\n    <tr>\n      <th>80</th>\n      <td>SUBJ_064387</td>\n      <td>0</td>\n      <td>17</td>\n      <td>1</td>\n      <td>1</td>\n      <td>155.0</td>\n      <td>42</td>\n      <td>22.0</td>\n    </tr>\n  </tbody>\n</table>\n<p>81 rows × 8 columns</p>\n</div>"},"metadata":{}}],"execution_count":2},{"cell_type":"code","source":"df['adult_child'].value_counts()","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2025-09-02T13:26:36.880909Z","iopub.execute_input":"2025-09-02T13:26:36.881249Z","iopub.status.idle":"2025-09-02T13:26:36.895331Z","shell.execute_reply.started":"2025-09-02T13:26:36.881224Z","shell.execute_reply":"2025-09-02T13:26:36.894231Z"}},"outputs":[{"execution_count":3,"output_type":"execute_result","data":{"text/plain":"adult_child\n1    42\n0    39\nName: count, dtype: int64"},"metadata":{}}],"execution_count":3},{"cell_type":"code","source":"df1=pd.read_csv('/kaggle/input/cmi-detect-behavior-with-sensor-data/test_demographics.csv')\ndf1","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2025-09-02T13:26:39.655546Z","iopub.execute_input":"2025-09-02T13:26:39.655902Z","iopub.status.idle":"2025-09-02T13:26:39.680147Z","shell.execute_reply.started":"2025-09-02T13:26:39.655876Z","shell.execute_reply":"2025-09-02T13:26:39.679235Z"}},"outputs":[{"execution_count":4,"output_type":"execute_result","data":{"text/plain":"       subject  adult_child  age  sex  handedness  height_cm  \\\n0  SUBJ_016452            1   25    1           1      165.0   \n1  SUBJ_055840            0   13    0           1      177.0   \n\n   shoulder_to_wrist_cm  elbow_to_wrist_cm  \n0                    52               23.0  \n1                    52               27.0  ","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>subject</th>\n      <th>adult_child</th>\n      <th>age</th>\n      <th>sex</th>\n      <th>handedness</th>\n      <th>height_cm</th>\n      <th>shoulder_to_wrist_cm</th>\n      <th>elbow_to_wrist_cm</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>SUBJ_016452</td>\n      <td>1</td>\n      <td>25</td>\n      <td>1</td>\n      <td>1</td>\n      <td>165.0</td>\n      <td>52</td>\n      <td>23.0</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>SUBJ_055840</td>\n      <td>0</td>\n      <td>13</td>\n      <td>0</td>\n      <td>1</td>\n      <td>177.0</td>\n      <td>52</td>\n      <td>27.0</td>\n    </tr>\n  </tbody>\n</table>\n</div>"},"metadata":{}}],"execution_count":4},{"cell_type":"code","source":"df2=pd.read_csv('/kaggle/input/cmi-detect-behavior-with-sensor-data/train.csv')\ndf2","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2025-09-02T13:26:49.050526Z","iopub.execute_input":"2025-09-02T13:26:49.050859Z","iopub.status.idle":"2025-09-02T13:27:26.620997Z","shell.execute_reply.started":"2025-09-02T13:26:49.050836Z","shell.execute_reply":"2025-09-02T13:27:26.620131Z"}},"outputs":[{"execution_count":5,"output_type":"execute_result","data":{"text/plain":"                   row_id sequence_type sequence_id  sequence_counter  \\\n0       SEQ_000007_000000        Target  SEQ_000007                 0   \n1       SEQ_000007_000001        Target  SEQ_000007                 1   \n2       SEQ_000007_000002        Target  SEQ_000007                 2   \n3       SEQ_000007_000003        Target  SEQ_000007                 3   \n4       SEQ_000007_000004        Target  SEQ_000007                 4   \n...                   ...           ...         ...               ...   \n574940  SEQ_065531_000048    Non-Target  SEQ_065531                48   \n574941  SEQ_065531_000049    Non-Target  SEQ_065531                49   \n574942  SEQ_065531_000050    Non-Target  SEQ_065531                50   \n574943  SEQ_065531_000051    Non-Target  SEQ_065531                51   \n574944  SEQ_065531_000052    Non-Target  SEQ_065531                52   \n\n            subject                      orientation  \\\n0       SUBJ_059520  Seated Lean Non Dom - FACE DOWN   \n1       SUBJ_059520  Seated Lean Non Dom - FACE DOWN   \n2       SUBJ_059520  Seated Lean Non Dom - FACE DOWN   \n3       SUBJ_059520  Seated Lean Non Dom - FACE DOWN   \n4       SUBJ_059520  Seated Lean Non Dom - FACE DOWN   \n...             ...                              ...   \n574940  SUBJ_039498  Seated Lean Non Dom - FACE DOWN   \n574941  SUBJ_039498  Seated Lean Non Dom - FACE DOWN   \n574942  SUBJ_039498  Seated Lean Non Dom - FACE DOWN   \n574943  SUBJ_039498  Seated Lean Non Dom - FACE DOWN   \n574944  SUBJ_039498  Seated Lean Non Dom - FACE DOWN   \n\n                                         behavior       phase  \\\n0       Relaxes and moves hand to target location  Transition   \n1       Relaxes and moves hand to target location  Transition   \n2       Relaxes and moves hand to target location  Transition   \n3       Relaxes and moves hand to target location  Transition   \n4       Relaxes and moves hand to target location  Transition   \n...                                           ...         ...   \n574940                           Performs gesture     Gesture   \n574941                           Performs gesture     Gesture   \n574942                           Performs gesture     Gesture   \n574943                           Performs gesture     Gesture   \n574944                           Performs gesture     Gesture   \n\n                   gesture     acc_x  ...  tof_5_v54  tof_5_v55  tof_5_v56  \\\n0       Cheek - pinch skin  6.683594  ...       -1.0       -1.0       -1.0   \n1       Cheek - pinch skin  6.949219  ...       -1.0       -1.0       -1.0   \n2       Cheek - pinch skin  5.722656  ...       -1.0       -1.0      112.0   \n3       Cheek - pinch skin  6.601562  ...       -1.0       -1.0      101.0   \n4       Cheek - pinch skin  5.566406  ...       -1.0       -1.0      101.0   \n...                    ...       ...  ...        ...        ...        ...   \n574940   Write name on leg  3.503906  ...       62.0       65.0       -1.0   \n574941   Write name on leg  3.773438  ...       71.0       72.0       -1.0   \n574942   Write name on leg  3.082031  ...       80.0       77.0       -1.0   \n574943   Write name on leg  3.964844  ...       72.0       77.0       -1.0   \n574944   Write name on leg  4.269531  ...       -1.0       -1.0       -1.0   \n\n        tof_5_v57  tof_5_v58  tof_5_v59  tof_5_v60  tof_5_v61  tof_5_v62  \\\n0            -1.0       -1.0       -1.0       -1.0       -1.0       -1.0   \n1            -1.0       -1.0       -1.0       -1.0       -1.0       -1.0   \n2           119.0       -1.0       -1.0       -1.0       -1.0       -1.0   \n3           111.0       -1.0       -1.0       -1.0       -1.0       -1.0   \n4           109.0      125.0       -1.0       -1.0       -1.0       -1.0   \n...           ...        ...        ...        ...        ...        ...   \n574940       -1.0       -1.0       -1.0       -1.0       -1.0       -1.0   \n574941       -1.0       -1.0       -1.0       -1.0       -1.0       -1.0   \n574942       -1.0       -1.0       -1.0       -1.0       -1.0       -1.0   \n574943       -1.0       -1.0       -1.0       -1.0       -1.0       -1.0   \n574944       -1.0       -1.0       -1.0       -1.0       -1.0       -1.0   \n\n        tof_5_v63  \n0            -1.0  \n1            -1.0  \n2            -1.0  \n3            -1.0  \n4            -1.0  \n...           ...  \n574940       71.0  \n574941       -1.0  \n574942       -1.0  \n574943       -1.0  \n574944       -1.0  \n\n[574945 rows x 341 columns]","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>row_id</th>\n      <th>sequence_type</th>\n      <th>sequence_id</th>\n      <th>sequence_counter</th>\n      <th>subject</th>\n      <th>orientation</th>\n      <th>behavior</th>\n      <th>phase</th>\n      <th>gesture</th>\n      <th>acc_x</th>\n      <th>...</th>\n      <th>tof_5_v54</th>\n      <th>tof_5_v55</th>\n      <th>tof_5_v56</th>\n      <th>tof_5_v57</th>\n      <th>tof_5_v58</th>\n      <th>tof_5_v59</th>\n      <th>tof_5_v60</th>\n      <th>tof_5_v61</th>\n      <th>tof_5_v62</th>\n      <th>tof_5_v63</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>SEQ_000007_000000</td>\n      <td>Target</td>\n      <td>SEQ_000007</td>\n      <td>0</td>\n      <td>SUBJ_059520</td>\n      <td>Seated Lean Non Dom - FACE DOWN</td>\n      <td>Relaxes and moves hand to target location</td>\n      <td>Transition</td>\n      <td>Cheek - pinch skin</td>\n      <td>6.683594</td>\n      <td>...</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>SEQ_000007_000001</td>\n      <td>Target</td>\n      <td>SEQ_000007</td>\n      <td>1</td>\n      <td>SUBJ_059520</td>\n      <td>Seated Lean Non Dom - FACE DOWN</td>\n      <td>Relaxes and moves hand to target location</td>\n      <td>Transition</td>\n      <td>Cheek - pinch skin</td>\n      <td>6.949219</td>\n      <td>...</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>SEQ_000007_000002</td>\n      <td>Target</td>\n      <td>SEQ_000007</td>\n      <td>2</td>\n      <td>SUBJ_059520</td>\n      <td>Seated Lean Non Dom - FACE DOWN</td>\n      <td>Relaxes and moves hand to target location</td>\n      <td>Transition</td>\n      <td>Cheek - pinch skin</td>\n      <td>5.722656</td>\n      <td>...</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>112.0</td>\n      <td>119.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>SEQ_000007_000003</td>\n      <td>Target</td>\n      <td>SEQ_000007</td>\n      <td>3</td>\n      <td>SUBJ_059520</td>\n      <td>Seated Lean Non Dom - FACE DOWN</td>\n      <td>Relaxes and moves hand to target location</td>\n      <td>Transition</td>\n      <td>Cheek - pinch skin</td>\n      <td>6.601562</td>\n      <td>...</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>101.0</td>\n      <td>111.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>SEQ_000007_000004</td>\n      <td>Target</td>\n      <td>SEQ_000007</td>\n      <td>4</td>\n      <td>SUBJ_059520</td>\n      <td>Seated Lean Non Dom - FACE DOWN</td>\n      <td>Relaxes and moves hand to target location</td>\n      <td>Transition</td>\n      <td>Cheek - pinch skin</td>\n      <td>5.566406</td>\n      <td>...</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>101.0</td>\n      <td>109.0</td>\n      <td>125.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.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>574940</th>\n      <td>SEQ_065531_000048</td>\n      <td>Non-Target</td>\n      <td>SEQ_065531</td>\n      <td>48</td>\n      <td>SUBJ_039498</td>\n      <td>Seated Lean Non Dom - FACE DOWN</td>\n      <td>Performs gesture</td>\n      <td>Gesture</td>\n      <td>Write name on leg</td>\n      <td>3.503906</td>\n      <td>...</td>\n      <td>62.0</td>\n      <td>65.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>71.0</td>\n    </tr>\n    <tr>\n      <th>574941</th>\n      <td>SEQ_065531_000049</td>\n      <td>Non-Target</td>\n      <td>SEQ_065531</td>\n      <td>49</td>\n      <td>SUBJ_039498</td>\n      <td>Seated Lean Non Dom - FACE DOWN</td>\n      <td>Performs gesture</td>\n      <td>Gesture</td>\n      <td>Write name on leg</td>\n      <td>3.773438</td>\n      <td>...</td>\n      <td>71.0</td>\n      <td>72.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n    </tr>\n    <tr>\n      <th>574942</th>\n      <td>SEQ_065531_000050</td>\n      <td>Non-Target</td>\n      <td>SEQ_065531</td>\n      <td>50</td>\n      <td>SUBJ_039498</td>\n      <td>Seated Lean Non Dom - FACE DOWN</td>\n      <td>Performs gesture</td>\n      <td>Gesture</td>\n      <td>Write name on leg</td>\n      <td>3.082031</td>\n      <td>...</td>\n      <td>80.0</td>\n      <td>77.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n    </tr>\n    <tr>\n      <th>574943</th>\n      <td>SEQ_065531_000051</td>\n      <td>Non-Target</td>\n      <td>SEQ_065531</td>\n      <td>51</td>\n      <td>SUBJ_039498</td>\n      <td>Seated Lean Non Dom - FACE DOWN</td>\n      <td>Performs gesture</td>\n      <td>Gesture</td>\n      <td>Write name on leg</td>\n      <td>3.964844</td>\n      <td>...</td>\n      <td>72.0</td>\n      <td>77.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n    </tr>\n    <tr>\n      <th>574944</th>\n      <td>SEQ_065531_000052</td>\n      <td>Non-Target</td>\n      <td>SEQ_065531</td>\n      <td>52</td>\n      <td>SUBJ_039498</td>\n      <td>Seated Lean Non Dom - FACE DOWN</td>\n      <td>Performs gesture</td>\n      <td>Gesture</td>\n      <td>Write name on leg</td>\n      <td>4.269531</td>\n      <td>...</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n    </tr>\n  </tbody>\n</table>\n<p>574945 rows × 341 columns</p>\n</div>"},"metadata":{}}],"execution_count":5},{"cell_type":"code","source":"df2.columns","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2025-09-02T13:27:34.82051Z","iopub.execute_input":"2025-09-02T13:27:34.820878Z","iopub.status.idle":"2025-09-02T13:27:34.829007Z","shell.execute_reply.started":"2025-09-02T13:27:34.820854Z","shell.execute_reply":"2025-09-02T13:27:34.828045Z"}},"outputs":[{"execution_count":6,"output_type":"execute_result","data":{"text/plain":"Index(['row_id', 'sequence_type', 'sequence_id', 'sequence_counter', 'subject',\n       'orientation', 'behavior', 'phase', 'gesture', 'acc_x',\n       ...\n       'tof_5_v54', 'tof_5_v55', 'tof_5_v56', 'tof_5_v57', 'tof_5_v58',\n       'tof_5_v59', 'tof_5_v60', 'tof_5_v61', 'tof_5_v62', 'tof_5_v63'],\n      dtype='object', length=341)"},"metadata":{}}],"execution_count":6},{"cell_type":"code","source":"df2.info()","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2025-09-02T13:27:38.430975Z","iopub.execute_input":"2025-09-02T13:27:38.431271Z","iopub.status.idle":"2025-09-02T13:27:38.455987Z","shell.execute_reply.started":"2025-09-02T13:27:38.431252Z","shell.execute_reply":"2025-09-02T13:27:38.455261Z"}},"outputs":[{"name":"stdout","text":"<class 'pandas.core.frame.DataFrame'>\nRangeIndex: 574945 entries, 0 to 574944\nColumns: 341 entries, row_id to tof_5_v63\ndtypes: float64(332), int64(1), object(8)\nmemory usage: 1.5+ GB\n","output_type":"stream"}],"execution_count":7},{"cell_type":"code","source":"df3=pd.read_csv('/kaggle/input/cmi-detect-behavior-with-sensor-data/test.csv')\ndf3","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2025-09-02T13:27:46.281145Z","iopub.execute_input":"2025-09-02T13:27:46.281454Z","iopub.status.idle":"2025-09-02T13:27:46.328103Z","shell.execute_reply.started":"2025-09-02T13:27:46.281431Z","shell.execute_reply":"2025-09-02T13:27:46.327242Z"}},"outputs":[{"execution_count":8,"output_type":"execute_result","data":{"text/plain":"                row_id sequence_id  sequence_counter      subject      acc_x  \\\n0    SEQ_000001_000000  SEQ_000001                 0  SUBJ_055840   9.039062   \n1    SEQ_000001_000001  SEQ_000001                 1  SUBJ_055840   9.421875   \n2    SEQ_000001_000002  SEQ_000001                 2  SUBJ_055840  10.160156   \n3    SEQ_000001_000003  SEQ_000001                 3  SUBJ_055840   9.773438   \n4    SEQ_000001_000004  SEQ_000001                 4  SUBJ_055840   9.195312   \n..                 ...         ...               ...          ...        ...   \n102  SEQ_000011_000046  SEQ_000011                46  SUBJ_016452  -4.062500   \n103  SEQ_000011_000047  SEQ_000011                47  SUBJ_016452  -4.140625   \n104  SEQ_000011_000048  SEQ_000011                48  SUBJ_016452  -4.214844   \n105  SEQ_000011_000049  SEQ_000011                49  SUBJ_016452  -4.406250   \n106  SEQ_000011_000050  SEQ_000011                50  SUBJ_016452  -3.949219   \n\n        acc_y     acc_z     rot_w     rot_x     rot_y  ...  tof_5_v54  \\\n0    5.261719  0.800781  0.367188 -0.397400 -0.629028  ...       97.0   \n1    3.460938 -1.113281  0.353882 -0.507141 -0.652710  ...      175.0   \n2    2.082031 -3.871094  0.384094 -0.532104 -0.639648  ...       -1.0   \n3    1.355469 -4.371094  0.387756 -0.531982 -0.634033  ...       -1.0   \n4    1.011719 -3.222656  0.382751 -0.534180 -0.638367  ...       -1.0   \n..        ...       ...       ...       ...       ...  ...        ...   \n102  8.613281 -3.140625  0.362488  0.176758  0.793274  ...       -1.0   \n103  8.535156 -3.410156  0.340637  0.166565  0.799927  ...       -1.0   \n104  8.414062 -3.371094  0.341675  0.169312  0.799316  ...       -1.0   \n105  8.957031 -3.292969  0.241699  0.135437  0.827820  ...       -1.0   \n106  8.457031 -3.371094  0.302368  0.015930 -0.571106  ...       -1.0   \n\n     tof_5_v55  tof_5_v56  tof_5_v57  tof_5_v58  tof_5_v59  tof_5_v60  \\\n0         87.0      206.0       -1.0      195.0       -1.0       -1.0   \n1        158.0       -1.0       -1.0       -1.0       -1.0       -1.0   \n2        160.0       -1.0       -1.0       -1.0       -1.0       -1.0   \n3        160.0       -1.0       -1.0       -1.0       -1.0       -1.0   \n4        163.0       -1.0       -1.0       -1.0       -1.0       -1.0   \n..         ...        ...        ...        ...        ...        ...   \n102       -1.0       -1.0       -1.0       -1.0       -1.0       -1.0   \n103       -1.0       -1.0       -1.0       -1.0       -1.0       -1.0   \n104       -1.0       -1.0       -1.0       -1.0       -1.0       -1.0   \n105       -1.0       -1.0       -1.0       -1.0       -1.0       -1.0   \n106       -1.0       -1.0       -1.0       -1.0       -1.0       -1.0   \n\n     tof_5_v61  tof_5_v62  tof_5_v63  \n0         -1.0      111.0       -1.0  \n1        211.0      187.0      178.0  \n2         -1.0      197.0      177.0  \n3         -1.0      197.0      183.0  \n4         -1.0      200.0      173.0  \n..         ...        ...        ...  \n102       -1.0       -1.0       -1.0  \n103       -1.0       -1.0       -1.0  \n104       -1.0       -1.0       -1.0  \n105       -1.0       -1.0       -1.0  \n106       -1.0       -1.0       -1.0  \n\n[107 rows x 336 columns]","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>row_id</th>\n      <th>sequence_id</th>\n      <th>sequence_counter</th>\n      <th>subject</th>\n      <th>acc_x</th>\n      <th>acc_y</th>\n      <th>acc_z</th>\n      <th>rot_w</th>\n      <th>rot_x</th>\n      <th>rot_y</th>\n      <th>...</th>\n      <th>tof_5_v54</th>\n      <th>tof_5_v55</th>\n      <th>tof_5_v56</th>\n      <th>tof_5_v57</th>\n      <th>tof_5_v58</th>\n      <th>tof_5_v59</th>\n      <th>tof_5_v60</th>\n      <th>tof_5_v61</th>\n      <th>tof_5_v62</th>\n      <th>tof_5_v63</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>SEQ_000001_000000</td>\n      <td>SEQ_000001</td>\n      <td>0</td>\n      <td>SUBJ_055840</td>\n      <td>9.039062</td>\n      <td>5.261719</td>\n      <td>0.800781</td>\n      <td>0.367188</td>\n      <td>-0.397400</td>\n      <td>-0.629028</td>\n      <td>...</td>\n      <td>97.0</td>\n      <td>87.0</td>\n      <td>206.0</td>\n      <td>-1.0</td>\n      <td>195.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>111.0</td>\n      <td>-1.0</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>SEQ_000001_000001</td>\n      <td>SEQ_000001</td>\n      <td>1</td>\n      <td>SUBJ_055840</td>\n      <td>9.421875</td>\n      <td>3.460938</td>\n      <td>-1.113281</td>\n      <td>0.353882</td>\n      <td>-0.507141</td>\n      <td>-0.652710</td>\n      <td>...</td>\n      <td>175.0</td>\n      <td>158.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>211.0</td>\n      <td>187.0</td>\n      <td>178.0</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>SEQ_000001_000002</td>\n      <td>SEQ_000001</td>\n      <td>2</td>\n      <td>SUBJ_055840</td>\n      <td>10.160156</td>\n      <td>2.082031</td>\n      <td>-3.871094</td>\n      <td>0.384094</td>\n      <td>-0.532104</td>\n      <td>-0.639648</td>\n      <td>...</td>\n      <td>-1.0</td>\n      <td>160.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>197.0</td>\n      <td>177.0</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>SEQ_000001_000003</td>\n      <td>SEQ_000001</td>\n      <td>3</td>\n      <td>SUBJ_055840</td>\n      <td>9.773438</td>\n      <td>1.355469</td>\n      <td>-4.371094</td>\n      <td>0.387756</td>\n      <td>-0.531982</td>\n      <td>-0.634033</td>\n      <td>...</td>\n      <td>-1.0</td>\n      <td>160.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>197.0</td>\n      <td>183.0</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>SEQ_000001_000004</td>\n      <td>SEQ_000001</td>\n      <td>4</td>\n      <td>SUBJ_055840</td>\n      <td>9.195312</td>\n      <td>1.011719</td>\n      <td>-3.222656</td>\n      <td>0.382751</td>\n      <td>-0.534180</td>\n      <td>-0.638367</td>\n      <td>...</td>\n      <td>-1.0</td>\n      <td>163.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>200.0</td>\n      <td>173.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>102</th>\n      <td>SEQ_000011_000046</td>\n      <td>SEQ_000011</td>\n      <td>46</td>\n      <td>SUBJ_016452</td>\n      <td>-4.062500</td>\n      <td>8.613281</td>\n      <td>-3.140625</td>\n      <td>0.362488</td>\n      <td>0.176758</td>\n      <td>0.793274</td>\n      <td>...</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n    </tr>\n    <tr>\n      <th>103</th>\n      <td>SEQ_000011_000047</td>\n      <td>SEQ_000011</td>\n      <td>47</td>\n      <td>SUBJ_016452</td>\n      <td>-4.140625</td>\n      <td>8.535156</td>\n      <td>-3.410156</td>\n      <td>0.340637</td>\n      <td>0.166565</td>\n      <td>0.799927</td>\n      <td>...</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n    </tr>\n    <tr>\n      <th>104</th>\n      <td>SEQ_000011_000048</td>\n      <td>SEQ_000011</td>\n      <td>48</td>\n      <td>SUBJ_016452</td>\n      <td>-4.214844</td>\n      <td>8.414062</td>\n      <td>-3.371094</td>\n      <td>0.341675</td>\n      <td>0.169312</td>\n      <td>0.799316</td>\n      <td>...</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n    </tr>\n    <tr>\n      <th>105</th>\n      <td>SEQ_000011_000049</td>\n      <td>SEQ_000011</td>\n      <td>49</td>\n      <td>SUBJ_016452</td>\n      <td>-4.406250</td>\n      <td>8.957031</td>\n      <td>-3.292969</td>\n      <td>0.241699</td>\n      <td>0.135437</td>\n      <td>0.827820</td>\n      <td>...</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n    </tr>\n    <tr>\n      <th>106</th>\n      <td>SEQ_000011_000050</td>\n      <td>SEQ_000011</td>\n      <td>50</td>\n      <td>SUBJ_016452</td>\n      <td>-3.949219</td>\n      <td>8.457031</td>\n      <td>-3.371094</td>\n      <td>0.302368</td>\n      <td>0.015930</td>\n      <td>-0.571106</td>\n      <td>...</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n      <td>-1.0</td>\n    </tr>\n  </tbody>\n</table>\n<p>107 rows × 336 columns</p>\n</div>"},"metadata":{}}],"execution_count":8},{"cell_type":"code","source":"df3.info()","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2025-09-02T13:27:52.276345Z","iopub.execute_input":"2025-09-02T13:27:52.277168Z","iopub.status.idle":"2025-09-02T13:27:52.296995Z","shell.execute_reply.started":"2025-09-02T13:27:52.277133Z","shell.execute_reply":"2025-09-02T13:27:52.295962Z"}},"outputs":[{"name":"stdout","text":"<class 'pandas.core.frame.DataFrame'>\nRangeIndex: 107 entries, 0 to 106\nColumns: 336 entries, row_id to tof_5_v63\ndtypes: float64(332), int64(1), object(3)\nmemory usage: 281.0+ KB\n","output_type":"stream"}],"execution_count":9},{"cell_type":"code","source":"","metadata":{"trusted":true},"outputs":[],"execution_count":null}]}