Diff of /Random/Random 1.ipynb [000000] .. [d8f241]

Switch to unified view

a b/Random/Random 1.ipynb
1
{
2
 "cells": [
3
  {
4
   "cell_type": "code",
5
   "execution_count": 1,
6
   "metadata": {},
7
   "outputs": [],
8
   "source": [
9
    "import pandas as pd"
10
   ]
11
  },
12
  {
13
   "cell_type": "code",
14
   "execution_count": 2,
15
   "metadata": {},
16
   "outputs": [
17
    {
18
     "name": "stdout",
19
     "output_type": "stream",
20
     "text": [
21
      "CPU times: user 44.7 s, sys: 6.46 s, total: 51.1 s\n",
22
      "Wall time: 51.1 s\n"
23
     ]
24
    },
25
    {
26
     "data": {
27
      "text/html": [
28
       "<div>\n",
29
       "<style scoped>\n",
30
       "    .dataframe tbody tr th:only-of-type {\n",
31
       "        vertical-align: middle;\n",
32
       "    }\n",
33
       "\n",
34
       "    .dataframe tbody tr th {\n",
35
       "        vertical-align: top;\n",
36
       "    }\n",
37
       "\n",
38
       "    .dataframe thead th {\n",
39
       "        text-align: right;\n",
40
       "    }\n",
41
       "</style>\n",
42
       "<table border=\"1\" class=\"dataframe\">\n",
43
       "  <thead>\n",
44
       "    <tr style=\"text-align: right;\">\n",
45
       "      <th></th>\n",
46
       "      <th>target</th>\n",
47
       "      <th>subject</th>\n",
48
       "      <th>chest_ACC_x</th>\n",
49
       "      <th>chest_ACC_y</th>\n",
50
       "      <th>chest_ACC_z</th>\n",
51
       "      <th>chest_ECG</th>\n",
52
       "      <th>chest_EMG</th>\n",
53
       "      <th>chest_EDA</th>\n",
54
       "      <th>chest_Temp</th>\n",
55
       "      <th>chest_Resp</th>\n",
56
       "    </tr>\n",
57
       "  </thead>\n",
58
       "  <tbody>\n",
59
       "    <tr>\n",
60
       "      <th>0</th>\n",
61
       "      <td>1</td>\n",
62
       "      <td>6</td>\n",
63
       "      <td>0.6280</td>\n",
64
       "      <td>-0.0082</td>\n",
65
       "      <td>-0.7272</td>\n",
66
       "      <td>0.016937</td>\n",
67
       "      <td>0.134720</td>\n",
68
       "      <td>9.645462</td>\n",
69
       "      <td>33.432587</td>\n",
70
       "      <td>4.010010</td>\n",
71
       "    </tr>\n",
72
       "    <tr>\n",
73
       "      <th>1</th>\n",
74
       "      <td>1</td>\n",
75
       "      <td>6</td>\n",
76
       "      <td>0.6276</td>\n",
77
       "      <td>-0.0056</td>\n",
78
       "      <td>-0.7262</td>\n",
79
       "      <td>0.017853</td>\n",
80
       "      <td>0.216248</td>\n",
81
       "      <td>9.645462</td>\n",
82
       "      <td>33.459747</td>\n",
83
       "      <td>4.039001</td>\n",
84
       "    </tr>\n",
85
       "    <tr>\n",
86
       "      <th>2</th>\n",
87
       "      <td>1</td>\n",
88
       "      <td>6</td>\n",
89
       "      <td>0.6270</td>\n",
90
       "      <td>-0.0054</td>\n",
91
       "      <td>-0.7200</td>\n",
92
       "      <td>0.016525</td>\n",
93
       "      <td>0.142136</td>\n",
94
       "      <td>9.646606</td>\n",
95
       "      <td>33.452240</td>\n",
96
       "      <td>3.993225</td>\n",
97
       "    </tr>\n",
98
       "    <tr>\n",
99
       "      <th>3</th>\n",
100
       "      <td>1</td>\n",
101
       "      <td>6</td>\n",
102
       "      <td>0.6266</td>\n",
103
       "      <td>-0.0070</td>\n",
104
       "      <td>-0.7174</td>\n",
105
       "      <td>0.012863</td>\n",
106
       "      <td>0.033371</td>\n",
107
       "      <td>9.646225</td>\n",
108
       "      <td>33.453735</td>\n",
109
       "      <td>4.002380</td>\n",
110
       "    </tr>\n",
111
       "    <tr>\n",
112
       "      <th>4</th>\n",
113
       "      <td>1</td>\n",
114
       "      <td>6</td>\n",
115
       "      <td>0.6242</td>\n",
116
       "      <td>-0.0078</td>\n",
117
       "      <td>-0.7202</td>\n",
118
       "      <td>0.007278</td>\n",
119
       "      <td>-0.024994</td>\n",
120
       "      <td>9.646988</td>\n",
121
       "      <td>33.426544</td>\n",
122
       "      <td>3.996277</td>\n",
123
       "    </tr>\n",
124
       "    <tr>\n",
125
       "      <th>5</th>\n",
126
       "      <td>1</td>\n",
127
       "      <td>6</td>\n",
128
       "      <td>0.6238</td>\n",
129
       "      <td>-0.0072</td>\n",
130
       "      <td>-0.7206</td>\n",
131
       "      <td>-0.007416</td>\n",
132
       "      <td>-0.050766</td>\n",
133
       "      <td>9.645462</td>\n",
134
       "      <td>33.447693</td>\n",
135
       "      <td>3.977966</td>\n",
136
       "    </tr>\n",
137
       "    <tr>\n",
138
       "      <th>6</th>\n",
139
       "      <td>1</td>\n",
140
       "      <td>6</td>\n",
141
       "      <td>0.6242</td>\n",
142
       "      <td>-0.0090</td>\n",
143
       "      <td>-0.7194</td>\n",
144
       "      <td>-0.025040</td>\n",
145
       "      <td>-0.017715</td>\n",
146
       "      <td>9.647369</td>\n",
147
       "      <td>33.444672</td>\n",
148
       "      <td>3.956604</td>\n",
149
       "    </tr>\n",
150
       "    <tr>\n",
151
       "      <th>7</th>\n",
152
       "      <td>1</td>\n",
153
       "      <td>6</td>\n",
154
       "      <td>0.6232</td>\n",
155
       "      <td>-0.0074</td>\n",
156
       "      <td>-0.7182</td>\n",
157
       "      <td>-0.039093</td>\n",
158
       "      <td>0.011215</td>\n",
159
       "      <td>9.648132</td>\n",
160
       "      <td>33.467316</td>\n",
161
       "      <td>3.953552</td>\n",
162
       "    </tr>\n",
163
       "    <tr>\n",
164
       "      <th>8</th>\n",
165
       "      <td>1</td>\n",
166
       "      <td>6</td>\n",
167
       "      <td>0.6218</td>\n",
168
       "      <td>-0.0114</td>\n",
169
       "      <td>-0.7166</td>\n",
170
       "      <td>-0.045410</td>\n",
171
       "      <td>-0.011032</td>\n",
172
       "      <td>9.646988</td>\n",
173
       "      <td>33.453735</td>\n",
174
       "      <td>3.929138</td>\n",
175
       "    </tr>\n",
176
       "    <tr>\n",
177
       "      <th>9</th>\n",
178
       "      <td>1</td>\n",
179
       "      <td>6</td>\n",
180
       "      <td>0.6162</td>\n",
181
       "      <td>-0.0130</td>\n",
182
       "      <td>-0.7158</td>\n",
183
       "      <td>-0.040237</td>\n",
184
       "      <td>-0.049576</td>\n",
185
       "      <td>9.646225</td>\n",
186
       "      <td>33.437103</td>\n",
187
       "      <td>3.932190</td>\n",
188
       "    </tr>\n",
189
       "    <tr>\n",
190
       "      <th>10</th>\n",
191
       "      <td>1</td>\n",
192
       "      <td>6</td>\n",
193
       "      <td>0.6158</td>\n",
194
       "      <td>-0.0158</td>\n",
195
       "      <td>-0.7138</td>\n",
196
       "      <td>-0.024490</td>\n",
197
       "      <td>-0.069260</td>\n",
198
       "      <td>9.645081</td>\n",
199
       "      <td>33.447693</td>\n",
200
       "      <td>3.904724</td>\n",
201
       "    </tr>\n",
202
       "    <tr>\n",
203
       "      <th>11</th>\n",
204
       "      <td>1</td>\n",
205
       "      <td>6</td>\n",
206
       "      <td>0.6140</td>\n",
207
       "      <td>-0.0156</td>\n",
208
       "      <td>-0.7128</td>\n",
209
       "      <td>-0.012909</td>\n",
210
       "      <td>-0.053513</td>\n",
211
       "      <td>9.644699</td>\n",
212
       "      <td>33.447693</td>\n",
213
       "      <td>3.892517</td>\n",
214
       "    </tr>\n",
215
       "    <tr>\n",
216
       "      <th>12</th>\n",
217
       "      <td>1</td>\n",
218
       "      <td>6</td>\n",
219
       "      <td>0.6090</td>\n",
220
       "      <td>-0.0142</td>\n",
221
       "      <td>-0.7138</td>\n",
222
       "      <td>-0.009293</td>\n",
223
       "      <td>-0.049026</td>\n",
224
       "      <td>9.643936</td>\n",
225
       "      <td>33.447693</td>\n",
226
       "      <td>3.883362</td>\n",
227
       "    </tr>\n",
228
       "    <tr>\n",
229
       "      <th>13</th>\n",
230
       "      <td>1</td>\n",
231
       "      <td>6</td>\n",
232
       "      <td>0.6082</td>\n",
233
       "      <td>-0.0166</td>\n",
234
       "      <td>-0.7090</td>\n",
235
       "      <td>-0.008194</td>\n",
236
       "      <td>-0.016800</td>\n",
237
       "      <td>9.645844</td>\n",
238
       "      <td>33.414459</td>\n",
239
       "      <td>3.906250</td>\n",
240
       "    </tr>\n",
241
       "    <tr>\n",
242
       "      <th>14</th>\n",
243
       "      <td>1</td>\n",
244
       "      <td>6</td>\n",
245
       "      <td>0.6058</td>\n",
246
       "      <td>-0.0184</td>\n",
247
       "      <td>-0.7082</td>\n",
248
       "      <td>-0.008606</td>\n",
249
       "      <td>0.059189</td>\n",
250
       "      <td>9.644318</td>\n",
251
       "      <td>33.411469</td>\n",
252
       "      <td>3.712463</td>\n",
253
       "    </tr>\n",
254
       "    <tr>\n",
255
       "      <th>15</th>\n",
256
       "      <td>1</td>\n",
257
       "      <td>6</td>\n",
258
       "      <td>0.6040</td>\n",
259
       "      <td>-0.0218</td>\n",
260
       "      <td>-0.7048</td>\n",
261
       "      <td>-0.003250</td>\n",
262
       "      <td>0.077133</td>\n",
263
       "      <td>9.643936</td>\n",
264
       "      <td>33.465851</td>\n",
265
       "      <td>3.254700</td>\n",
266
       "    </tr>\n",
267
       "    <tr>\n",
268
       "      <th>16</th>\n",
269
       "      <td>1</td>\n",
270
       "      <td>6</td>\n",
271
       "      <td>0.6040</td>\n",
272
       "      <td>-0.0238</td>\n",
273
       "      <td>-0.7128</td>\n",
274
       "      <td>0.000916</td>\n",
275
       "      <td>0.010071</td>\n",
276
       "      <td>9.643173</td>\n",
277
       "      <td>33.450684</td>\n",
278
       "      <td>3.834534</td>\n",
279
       "    </tr>\n",
280
       "    <tr>\n",
281
       "      <th>17</th>\n",
282
       "      <td>1</td>\n",
283
       "      <td>6</td>\n",
284
       "      <td>0.6038</td>\n",
285
       "      <td>-0.0254</td>\n",
286
       "      <td>-0.7160</td>\n",
287
       "      <td>0.003433</td>\n",
288
       "      <td>0.006821</td>\n",
289
       "      <td>9.643173</td>\n",
290
       "      <td>33.435608</td>\n",
291
       "      <td>3.840637</td>\n",
292
       "    </tr>\n",
293
       "    <tr>\n",
294
       "      <th>18</th>\n",
295
       "      <td>1</td>\n",
296
       "      <td>6</td>\n",
297
       "      <td>0.6018</td>\n",
298
       "      <td>-0.0286</td>\n",
299
       "      <td>-0.7110</td>\n",
300
       "      <td>-0.003067</td>\n",
301
       "      <td>-0.011856</td>\n",
302
       "      <td>9.643936</td>\n",
303
       "      <td>33.508148</td>\n",
304
       "      <td>3.851318</td>\n",
305
       "    </tr>\n",
306
       "    <tr>\n",
307
       "      <th>19</th>\n",
308
       "      <td>1</td>\n",
309
       "      <td>6</td>\n",
310
       "      <td>0.5994</td>\n",
311
       "      <td>-0.0290</td>\n",
312
       "      <td>-0.7126</td>\n",
313
       "      <td>-0.015884</td>\n",
314
       "      <td>-0.044632</td>\n",
315
       "      <td>9.643936</td>\n",
316
       "      <td>33.438599</td>\n",
317
       "      <td>3.837585</td>\n",
318
       "    </tr>\n",
319
       "    <tr>\n",
320
       "      <th>20</th>\n",
321
       "      <td>1</td>\n",
322
       "      <td>6</td>\n",
323
       "      <td>0.5978</td>\n",
324
       "      <td>-0.0326</td>\n",
325
       "      <td>-0.7080</td>\n",
326
       "      <td>-0.030899</td>\n",
327
       "      <td>0.076950</td>\n",
328
       "      <td>9.644699</td>\n",
329
       "      <td>33.462799</td>\n",
330
       "      <td>3.788757</td>\n",
331
       "    </tr>\n",
332
       "    <tr>\n",
333
       "      <th>21</th>\n",
334
       "      <td>1</td>\n",
335
       "      <td>6</td>\n",
336
       "      <td>0.5982</td>\n",
337
       "      <td>-0.0358</td>\n",
338
       "      <td>-0.7064</td>\n",
339
       "      <td>-0.035339</td>\n",
340
       "      <td>0.133026</td>\n",
341
       "      <td>9.643173</td>\n",
342
       "      <td>33.444672</td>\n",
343
       "      <td>3.782654</td>\n",
344
       "    </tr>\n",
345
       "    <tr>\n",
346
       "      <th>22</th>\n",
347
       "      <td>1</td>\n",
348
       "      <td>6</td>\n",
349
       "      <td>0.5950</td>\n",
350
       "      <td>-0.0328</td>\n",
351
       "      <td>-0.7106</td>\n",
352
       "      <td>-0.034470</td>\n",
353
       "      <td>0.051956</td>\n",
354
       "      <td>9.645462</td>\n",
355
       "      <td>33.459747</td>\n",
356
       "      <td>3.778076</td>\n",
357
       "    </tr>\n",
358
       "    <tr>\n",
359
       "      <th>23</th>\n",
360
       "      <td>1</td>\n",
361
       "      <td>6</td>\n",
362
       "      <td>0.5948</td>\n",
363
       "      <td>-0.0350</td>\n",
364
       "      <td>-0.7102</td>\n",
365
       "      <td>-0.034332</td>\n",
366
       "      <td>-0.047836</td>\n",
367
       "      <td>9.643936</td>\n",
368
       "      <td>33.438599</td>\n",
369
       "      <td>3.761292</td>\n",
370
       "    </tr>\n",
371
       "    <tr>\n",
372
       "      <th>24</th>\n",
373
       "      <td>1</td>\n",
374
       "      <td>6</td>\n",
375
       "      <td>0.5912</td>\n",
376
       "      <td>-0.0352</td>\n",
377
       "      <td>-0.7046</td>\n",
378
       "      <td>-0.033737</td>\n",
379
       "      <td>-0.207779</td>\n",
380
       "      <td>9.643936</td>\n",
381
       "      <td>33.441620</td>\n",
382
       "      <td>3.762817</td>\n",
383
       "    </tr>\n",
384
       "    <tr>\n",
385
       "      <th>25</th>\n",
386
       "      <td>1</td>\n",
387
       "      <td>6</td>\n",
388
       "      <td>0.5922</td>\n",
389
       "      <td>-0.0370</td>\n",
390
       "      <td>-0.7056</td>\n",
391
       "      <td>-0.024765</td>\n",
392
       "      <td>-0.344147</td>\n",
393
       "      <td>9.643173</td>\n",
394
       "      <td>33.440155</td>\n",
395
       "      <td>3.746033</td>\n",
396
       "    </tr>\n",
397
       "    <tr>\n",
398
       "      <th>26</th>\n",
399
       "      <td>1</td>\n",
400
       "      <td>6</td>\n",
401
       "      <td>0.5928</td>\n",
402
       "      <td>-0.0410</td>\n",
403
       "      <td>-0.7054</td>\n",
404
       "      <td>-0.021149</td>\n",
405
       "      <td>-0.347305</td>\n",
406
       "      <td>9.643936</td>\n",
407
       "      <td>33.536865</td>\n",
408
       "      <td>3.778076</td>\n",
409
       "    </tr>\n",
410
       "    <tr>\n",
411
       "      <th>27</th>\n",
412
       "      <td>1</td>\n",
413
       "      <td>6</td>\n",
414
       "      <td>0.5914</td>\n",
415
       "      <td>-0.0406</td>\n",
416
       "      <td>-0.7032</td>\n",
417
       "      <td>-0.026413</td>\n",
418
       "      <td>-0.049118</td>\n",
419
       "      <td>9.643173</td>\n",
420
       "      <td>33.450684</td>\n",
421
       "      <td>3.648376</td>\n",
422
       "    </tr>\n",
423
       "    <tr>\n",
424
       "      <th>28</th>\n",
425
       "      <td>1</td>\n",
426
       "      <td>6</td>\n",
427
       "      <td>0.5890</td>\n",
428
       "      <td>-0.0418</td>\n",
429
       "      <td>-0.7054</td>\n",
430
       "      <td>-0.032547</td>\n",
431
       "      <td>0.199448</td>\n",
432
       "      <td>9.643173</td>\n",
433
       "      <td>33.455261</td>\n",
434
       "      <td>3.285217</td>\n",
435
       "    </tr>\n",
436
       "    <tr>\n",
437
       "      <th>29</th>\n",
438
       "      <td>1</td>\n",
439
       "      <td>6</td>\n",
440
       "      <td>0.5886</td>\n",
441
       "      <td>-0.0466</td>\n",
442
       "      <td>-0.7026</td>\n",
443
       "      <td>-0.032593</td>\n",
444
       "      <td>0.287384</td>\n",
445
       "      <td>9.643173</td>\n",
446
       "      <td>33.476379</td>\n",
447
       "      <td>3.697205</td>\n",
448
       "    </tr>\n",
449
       "    <tr>\n",
450
       "      <th>...</th>\n",
451
       "      <td>...</td>\n",
452
       "      <td>...</td>\n",
453
       "      <td>...</td>\n",
454
       "      <td>...</td>\n",
455
       "      <td>...</td>\n",
456
       "      <td>...</td>\n",
457
       "      <td>...</td>\n",
458
       "      <td>...</td>\n",
459
       "      <td>...</td>\n",
460
       "      <td>...</td>\n",
461
       "    </tr>\n",
462
       "    <tr>\n",
463
       "      <th>31470573</th>\n",
464
       "      <td>4</td>\n",
465
       "      <td>7</td>\n",
466
       "      <td>0.8482</td>\n",
467
       "      <td>-0.0274</td>\n",
468
       "      <td>-0.3788</td>\n",
469
       "      <td>-0.144699</td>\n",
470
       "      <td>0.013138</td>\n",
471
       "      <td>12.242508</td>\n",
472
       "      <td>34.706207</td>\n",
473
       "      <td>2.009583</td>\n",
474
       "    </tr>\n",
475
       "    <tr>\n",
476
       "      <th>31470574</th>\n",
477
       "      <td>4</td>\n",
478
       "      <td>7</td>\n",
479
       "      <td>0.8474</td>\n",
480
       "      <td>-0.0254</td>\n",
481
       "      <td>-0.3698</td>\n",
482
       "      <td>-0.141861</td>\n",
483
       "      <td>0.009384</td>\n",
484
       "      <td>12.242508</td>\n",
485
       "      <td>34.724670</td>\n",
486
       "      <td>2.021790</td>\n",
487
       "    </tr>\n",
488
       "    <tr>\n",
489
       "      <th>31470575</th>\n",
490
       "      <td>4</td>\n",
491
       "      <td>7</td>\n",
492
       "      <td>0.8510</td>\n",
493
       "      <td>-0.0262</td>\n",
494
       "      <td>-0.3596</td>\n",
495
       "      <td>-0.138016</td>\n",
496
       "      <td>-0.006271</td>\n",
497
       "      <td>12.242508</td>\n",
498
       "      <td>34.713867</td>\n",
499
       "      <td>2.024841</td>\n",
500
       "    </tr>\n",
501
       "    <tr>\n",
502
       "      <th>31470576</th>\n",
503
       "      <td>4</td>\n",
504
       "      <td>7</td>\n",
505
       "      <td>0.8486</td>\n",
506
       "      <td>-0.0258</td>\n",
507
       "      <td>-0.3560</td>\n",
508
       "      <td>-0.133072</td>\n",
509
       "      <td>-0.015427</td>\n",
510
       "      <td>12.234879</td>\n",
511
       "      <td>34.727722</td>\n",
512
       "      <td>2.037048</td>\n",
513
       "    </tr>\n",
514
       "    <tr>\n",
515
       "      <th>31470577</th>\n",
516
       "      <td>4</td>\n",
517
       "      <td>7</td>\n",
518
       "      <td>0.8466</td>\n",
519
       "      <td>-0.0228</td>\n",
520
       "      <td>-0.3560</td>\n",
521
       "      <td>-0.128677</td>\n",
522
       "      <td>-0.011902</td>\n",
523
       "      <td>12.240982</td>\n",
524
       "      <td>34.724670</td>\n",
525
       "      <td>2.064514</td>\n",
526
       "    </tr>\n",
527
       "    <tr>\n",
528
       "      <th>31470578</th>\n",
529
       "      <td>4</td>\n",
530
       "      <td>7</td>\n",
531
       "      <td>0.8446</td>\n",
532
       "      <td>-0.0236</td>\n",
533
       "      <td>-0.3570</td>\n",
534
       "      <td>-0.125977</td>\n",
535
       "      <td>-0.004166</td>\n",
536
       "      <td>12.241745</td>\n",
537
       "      <td>34.720032</td>\n",
538
       "      <td>2.061462</td>\n",
539
       "    </tr>\n",
540
       "    <tr>\n",
541
       "      <th>31470579</th>\n",
542
       "      <td>4</td>\n",
543
       "      <td>7</td>\n",
544
       "      <td>0.8442</td>\n",
545
       "      <td>-0.0238</td>\n",
546
       "      <td>-0.3682</td>\n",
547
       "      <td>-0.124329</td>\n",
548
       "      <td>-0.016617</td>\n",
549
       "      <td>12.240982</td>\n",
550
       "      <td>34.726166</td>\n",
551
       "      <td>1.881409</td>\n",
552
       "    </tr>\n",
553
       "    <tr>\n",
554
       "      <th>31470580</th>\n",
555
       "      <td>4</td>\n",
556
       "      <td>7</td>\n",
557
       "      <td>0.8414</td>\n",
558
       "      <td>-0.0262</td>\n",
559
       "      <td>-0.3758</td>\n",
560
       "      <td>-0.124283</td>\n",
561
       "      <td>-0.015244</td>\n",
562
       "      <td>12.240219</td>\n",
563
       "      <td>34.681610</td>\n",
564
       "      <td>2.018738</td>\n",
565
       "    </tr>\n",
566
       "    <tr>\n",
567
       "      <th>31470581</th>\n",
568
       "      <td>4</td>\n",
569
       "      <td>7</td>\n",
570
       "      <td>0.8382</td>\n",
571
       "      <td>-0.0254</td>\n",
572
       "      <td>-0.3814</td>\n",
573
       "      <td>-0.123230</td>\n",
574
       "      <td>-0.018082</td>\n",
575
       "      <td>12.242508</td>\n",
576
       "      <td>34.744629</td>\n",
577
       "      <td>2.021790</td>\n",
578
       "    </tr>\n",
579
       "    <tr>\n",
580
       "      <th>31470582</th>\n",
581
       "      <td>4</td>\n",
582
       "      <td>7</td>\n",
583
       "      <td>0.8402</td>\n",
584
       "      <td>-0.0242</td>\n",
585
       "      <td>-0.3906</td>\n",
586
       "      <td>-0.120667</td>\n",
587
       "      <td>-0.016068</td>\n",
588
       "      <td>12.240219</td>\n",
589
       "      <td>34.712341</td>\n",
590
       "      <td>2.030945</td>\n",
591
       "    </tr>\n",
592
       "    <tr>\n",
593
       "      <th>31470583</th>\n",
594
       "      <td>4</td>\n",
595
       "      <td>7</td>\n",
596
       "      <td>0.8350</td>\n",
597
       "      <td>-0.0222</td>\n",
598
       "      <td>-0.3960</td>\n",
599
       "      <td>-0.117691</td>\n",
600
       "      <td>-0.010529</td>\n",
601
       "      <td>12.240982</td>\n",
602
       "      <td>34.726166</td>\n",
603
       "      <td>2.052307</td>\n",
604
       "    </tr>\n",
605
       "    <tr>\n",
606
       "      <th>31470584</th>\n",
607
       "      <td>4</td>\n",
608
       "      <td>7</td>\n",
609
       "      <td>0.8358</td>\n",
610
       "      <td>-0.0258</td>\n",
611
       "      <td>-0.4038</td>\n",
612
       "      <td>-0.115677</td>\n",
613
       "      <td>-0.001602</td>\n",
614
       "      <td>12.234879</td>\n",
615
       "      <td>34.712341</td>\n",
616
       "      <td>2.056885</td>\n",
617
       "    </tr>\n",
618
       "    <tr>\n",
619
       "      <th>31470585</th>\n",
620
       "      <td>4</td>\n",
621
       "      <td>7</td>\n",
622
       "      <td>0.8356</td>\n",
623
       "      <td>-0.0264</td>\n",
624
       "      <td>-0.4118</td>\n",
625
       "      <td>-0.112198</td>\n",
626
       "      <td>0.006363</td>\n",
627
       "      <td>12.240982</td>\n",
628
       "      <td>34.715424</td>\n",
629
       "      <td>2.061462</td>\n",
630
       "    </tr>\n",
631
       "    <tr>\n",
632
       "      <th>31470586</th>\n",
633
       "      <td>4</td>\n",
634
       "      <td>7</td>\n",
635
       "      <td>0.8354</td>\n",
636
       "      <td>-0.0264</td>\n",
637
       "      <td>-0.4130</td>\n",
638
       "      <td>-0.109451</td>\n",
639
       "      <td>0.003479</td>\n",
640
       "      <td>12.245178</td>\n",
641
       "      <td>34.720032</td>\n",
642
       "      <td>2.043152</td>\n",
643
       "    </tr>\n",
644
       "    <tr>\n",
645
       "      <th>31470587</th>\n",
646
       "      <td>4</td>\n",
647
       "      <td>7</td>\n",
648
       "      <td>0.8354</td>\n",
649
       "      <td>-0.0264</td>\n",
650
       "      <td>-0.4126</td>\n",
651
       "      <td>-0.108765</td>\n",
652
       "      <td>-0.010071</td>\n",
653
       "      <td>12.239838</td>\n",
654
       "      <td>34.733856</td>\n",
655
       "      <td>2.037048</td>\n",
656
       "    </tr>\n",
657
       "    <tr>\n",
658
       "      <th>31470588</th>\n",
659
       "      <td>4</td>\n",
660
       "      <td>7</td>\n",
661
       "      <td>0.8370</td>\n",
662
       "      <td>-0.0274</td>\n",
663
       "      <td>-0.4066</td>\n",
664
       "      <td>-0.105377</td>\n",
665
       "      <td>0.000961</td>\n",
666
       "      <td>12.238693</td>\n",
667
       "      <td>34.727722</td>\n",
668
       "      <td>2.024841</td>\n",
669
       "    </tr>\n",
670
       "    <tr>\n",
671
       "      <th>31470589</th>\n",
672
       "      <td>4</td>\n",
673
       "      <td>7</td>\n",
674
       "      <td>0.8376</td>\n",
675
       "      <td>-0.0290</td>\n",
676
       "      <td>-0.4014</td>\n",
677
       "      <td>-0.101120</td>\n",
678
       "      <td>-0.006729</td>\n",
679
       "      <td>12.239456</td>\n",
680
       "      <td>34.740021</td>\n",
681
       "      <td>2.024841</td>\n",
682
       "    </tr>\n",
683
       "    <tr>\n",
684
       "      <th>31470590</th>\n",
685
       "      <td>4</td>\n",
686
       "      <td>7</td>\n",
687
       "      <td>0.8396</td>\n",
688
       "      <td>-0.0302</td>\n",
689
       "      <td>-0.3942</td>\n",
690
       "      <td>-0.097366</td>\n",
691
       "      <td>-0.005447</td>\n",
692
       "      <td>12.240219</td>\n",
693
       "      <td>34.727722</td>\n",
694
       "      <td>2.032471</td>\n",
695
       "    </tr>\n",
696
       "    <tr>\n",
697
       "      <th>31470591</th>\n",
698
       "      <td>4</td>\n",
699
       "      <td>7</td>\n",
700
       "      <td>0.8390</td>\n",
701
       "      <td>-0.0294</td>\n",
702
       "      <td>-0.3864</td>\n",
703
       "      <td>-0.092834</td>\n",
704
       "      <td>-0.005081</td>\n",
705
       "      <td>12.234879</td>\n",
706
       "      <td>34.740021</td>\n",
707
       "      <td>2.027893</td>\n",
708
       "    </tr>\n",
709
       "    <tr>\n",
710
       "      <th>31470592</th>\n",
711
       "      <td>4</td>\n",
712
       "      <td>7</td>\n",
713
       "      <td>0.8398</td>\n",
714
       "      <td>-0.0290</td>\n",
715
       "      <td>-0.3806</td>\n",
716
       "      <td>-0.088943</td>\n",
717
       "      <td>-0.005173</td>\n",
718
       "      <td>12.239075</td>\n",
719
       "      <td>34.710846</td>\n",
720
       "      <td>2.040100</td>\n",
721
       "    </tr>\n",
722
       "    <tr>\n",
723
       "      <th>31470593</th>\n",
724
       "      <td>4</td>\n",
725
       "      <td>7</td>\n",
726
       "      <td>0.8382</td>\n",
727
       "      <td>-0.0302</td>\n",
728
       "      <td>-0.3766</td>\n",
729
       "      <td>-0.087753</td>\n",
730
       "      <td>-0.002792</td>\n",
731
       "      <td>12.239456</td>\n",
732
       "      <td>34.727722</td>\n",
733
       "      <td>2.037048</td>\n",
734
       "    </tr>\n",
735
       "    <tr>\n",
736
       "      <th>31470594</th>\n",
737
       "      <td>4</td>\n",
738
       "      <td>7</td>\n",
739
       "      <td>0.8414</td>\n",
740
       "      <td>-0.0328</td>\n",
741
       "      <td>-0.3720</td>\n",
742
       "      <td>-0.088760</td>\n",
743
       "      <td>-0.006638</td>\n",
744
       "      <td>12.239456</td>\n",
745
       "      <td>34.723114</td>\n",
746
       "      <td>2.041626</td>\n",
747
       "    </tr>\n",
748
       "    <tr>\n",
749
       "      <th>31470595</th>\n",
750
       "      <td>4</td>\n",
751
       "      <td>7</td>\n",
752
       "      <td>0.8440</td>\n",
753
       "      <td>-0.0330</td>\n",
754
       "      <td>-0.3710</td>\n",
755
       "      <td>-0.085098</td>\n",
756
       "      <td>0.008514</td>\n",
757
       "      <td>12.239456</td>\n",
758
       "      <td>34.712341</td>\n",
759
       "      <td>1.889038</td>\n",
760
       "    </tr>\n",
761
       "    <tr>\n",
762
       "      <th>31470596</th>\n",
763
       "      <td>4</td>\n",
764
       "      <td>7</td>\n",
765
       "      <td>0.8452</td>\n",
766
       "      <td>-0.0322</td>\n",
767
       "      <td>-0.3674</td>\n",
768
       "      <td>-0.082809</td>\n",
769
       "      <td>0.006775</td>\n",
770
       "      <td>12.237930</td>\n",
771
       "      <td>34.663177</td>\n",
772
       "      <td>2.073669</td>\n",
773
       "    </tr>\n",
774
       "    <tr>\n",
775
       "      <th>31470597</th>\n",
776
       "      <td>4</td>\n",
777
       "      <td>7</td>\n",
778
       "      <td>0.8446</td>\n",
779
       "      <td>-0.0328</td>\n",
780
       "      <td>-0.3608</td>\n",
781
       "      <td>-0.079971</td>\n",
782
       "      <td>0.000778</td>\n",
783
       "      <td>12.240219</td>\n",
784
       "      <td>34.732361</td>\n",
785
       "      <td>2.082825</td>\n",
786
       "    </tr>\n",
787
       "    <tr>\n",
788
       "      <th>31470598</th>\n",
789
       "      <td>4</td>\n",
790
       "      <td>7</td>\n",
791
       "      <td>0.8442</td>\n",
792
       "      <td>-0.0344</td>\n",
793
       "      <td>-0.3638</td>\n",
794
       "      <td>-0.076309</td>\n",
795
       "      <td>-0.001511</td>\n",
796
       "      <td>12.240219</td>\n",
797
       "      <td>34.724670</td>\n",
798
       "      <td>2.073669</td>\n",
799
       "    </tr>\n",
800
       "    <tr>\n",
801
       "      <th>31470599</th>\n",
802
       "      <td>4</td>\n",
803
       "      <td>7</td>\n",
804
       "      <td>0.8434</td>\n",
805
       "      <td>-0.0330</td>\n",
806
       "      <td>-0.3634</td>\n",
807
       "      <td>-0.074844</td>\n",
808
       "      <td>-0.006271</td>\n",
809
       "      <td>12.240219</td>\n",
810
       "      <td>34.716980</td>\n",
811
       "      <td>2.082825</td>\n",
812
       "    </tr>\n",
813
       "    <tr>\n",
814
       "      <th>31470600</th>\n",
815
       "      <td>4</td>\n",
816
       "      <td>7</td>\n",
817
       "      <td>0.8462</td>\n",
818
       "      <td>-0.0348</td>\n",
819
       "      <td>-0.3650</td>\n",
820
       "      <td>-0.073013</td>\n",
821
       "      <td>-0.006638</td>\n",
822
       "      <td>12.233353</td>\n",
823
       "      <td>34.715424</td>\n",
824
       "      <td>2.079773</td>\n",
825
       "    </tr>\n",
826
       "    <tr>\n",
827
       "      <th>31470601</th>\n",
828
       "      <td>4</td>\n",
829
       "      <td>7</td>\n",
830
       "      <td>0.8446</td>\n",
831
       "      <td>-0.0360</td>\n",
832
       "      <td>-0.3652</td>\n",
833
       "      <td>-0.071136</td>\n",
834
       "      <td>-0.001694</td>\n",
835
       "      <td>12.239075</td>\n",
836
       "      <td>34.724670</td>\n",
837
       "      <td>2.079773</td>\n",
838
       "    </tr>\n",
839
       "    <tr>\n",
840
       "      <th>31470602</th>\n",
841
       "      <td>4</td>\n",
842
       "      <td>7</td>\n",
843
       "      <td>0.8472</td>\n",
844
       "      <td>-0.0358</td>\n",
845
       "      <td>-0.3654</td>\n",
846
       "      <td>-0.067154</td>\n",
847
       "      <td>0.000778</td>\n",
848
       "      <td>12.236786</td>\n",
849
       "      <td>34.726166</td>\n",
850
       "      <td>2.076721</td>\n",
851
       "    </tr>\n",
852
       "  </tbody>\n",
853
       "</table>\n",
854
       "<p>31470603 rows × 10 columns</p>\n",
855
       "</div>"
856
      ],
857
      "text/plain": [
858
       "          target  subject  chest_ACC_x  chest_ACC_y  chest_ACC_z  chest_ECG  \\\n",
859
       "0              1        6       0.6280      -0.0082      -0.7272   0.016937   \n",
860
       "1              1        6       0.6276      -0.0056      -0.7262   0.017853   \n",
861
       "2              1        6       0.6270      -0.0054      -0.7200   0.016525   \n",
862
       "3              1        6       0.6266      -0.0070      -0.7174   0.012863   \n",
863
       "4              1        6       0.6242      -0.0078      -0.7202   0.007278   \n",
864
       "...          ...      ...          ...          ...          ...        ...   \n",
865
       "31470598       4        7       0.8442      -0.0344      -0.3638  -0.076309   \n",
866
       "31470599       4        7       0.8434      -0.0330      -0.3634  -0.074844   \n",
867
       "31470600       4        7       0.8462      -0.0348      -0.3650  -0.073013   \n",
868
       "31470601       4        7       0.8446      -0.0360      -0.3652  -0.071136   \n",
869
       "31470602       4        7       0.8472      -0.0358      -0.3654  -0.067154   \n",
870
       "\n",
871
       "          chest_EMG  chest_EDA  chest_Temp  chest_Resp  \n",
872
       "0          0.134720   9.645462   33.432587    4.010010  \n",
873
       "1          0.216248   9.645462   33.459747    4.039001  \n",
874
       "2          0.142136   9.646606   33.452240    3.993225  \n",
875
       "3          0.033371   9.646225   33.453735    4.002380  \n",
876
       "4         -0.024994   9.646988   33.426544    3.996277  \n",
877
       "...             ...        ...         ...         ...  \n",
878
       "31470598  -0.001511  12.240219   34.724670    2.073669  \n",
879
       "31470599  -0.006271  12.240219   34.716980    2.082825  \n",
880
       "31470600  -0.006638  12.233353   34.715424    2.079773  \n",
881
       "31470601  -0.001694  12.239075   34.724670    2.079773  \n",
882
       "31470602   0.000778  12.236786   34.726166    2.076721  \n",
883
       "\n",
884
       "[31470603 rows x 10 columns]"
885
      ]
886
     },
887
     "execution_count": 2,
888
     "metadata": {},
889
     "output_type": "execute_result"
890
    }
891
   ],
892
   "source": [
893
    "%%time\n",
894
    "df = pd.read_csv(\"master_data.csv\")\n",
895
    "df"
896
   ]
897
  },
898
  {
899
   "cell_type": "code",
900
   "execution_count": 3,
901
   "metadata": {},
902
   "outputs": [],
903
   "source": [
904
    "df = df[df['target']>0]"
905
   ]
906
  },
907
  {
908
   "cell_type": "code",
909
   "execution_count": 4,
910
   "metadata": {
911
    "scrolled": true
912
   },
913
   "outputs": [
914
    {
915
     "data": {
916
      "text/html": [
917
       "<div>\n",
918
       "<style scoped>\n",
919
       "    .dataframe tbody tr th:only-of-type {\n",
920
       "        vertical-align: middle;\n",
921
       "    }\n",
922
       "\n",
923
       "    .dataframe tbody tr th {\n",
924
       "        vertical-align: top;\n",
925
       "    }\n",
926
       "\n",
927
       "    .dataframe thead th {\n",
928
       "        text-align: right;\n",
929
       "    }\n",
930
       "</style>\n",
931
       "<table border=\"1\" class=\"dataframe\">\n",
932
       "  <thead>\n",
933
       "    <tr style=\"text-align: right;\">\n",
934
       "      <th></th>\n",
935
       "      <th>target</th>\n",
936
       "      <th>subject</th>\n",
937
       "      <th>chest_ACC_x</th>\n",
938
       "      <th>chest_ACC_y</th>\n",
939
       "      <th>chest_ACC_z</th>\n",
940
       "      <th>chest_ECG</th>\n",
941
       "      <th>chest_EMG</th>\n",
942
       "      <th>chest_EDA</th>\n",
943
       "      <th>chest_Temp</th>\n",
944
       "      <th>chest_Resp</th>\n",
945
       "    </tr>\n",
946
       "  </thead>\n",
947
       "  <tbody>\n",
948
       "    <tr>\n",
949
       "      <th>0</th>\n",
950
       "      <td>1</td>\n",
951
       "      <td>6</td>\n",
952
       "      <td>0.6280</td>\n",
953
       "      <td>-0.0082</td>\n",
954
       "      <td>-0.7272</td>\n",
955
       "      <td>0.016937</td>\n",
956
       "      <td>0.134720</td>\n",
957
       "      <td>9.645462</td>\n",
958
       "      <td>33.432587</td>\n",
959
       "      <td>4.010010</td>\n",
960
       "    </tr>\n",
961
       "    <tr>\n",
962
       "      <th>1</th>\n",
963
       "      <td>1</td>\n",
964
       "      <td>6</td>\n",
965
       "      <td>0.6276</td>\n",
966
       "      <td>-0.0056</td>\n",
967
       "      <td>-0.7262</td>\n",
968
       "      <td>0.017853</td>\n",
969
       "      <td>0.216248</td>\n",
970
       "      <td>9.645462</td>\n",
971
       "      <td>33.459747</td>\n",
972
       "      <td>4.039001</td>\n",
973
       "    </tr>\n",
974
       "    <tr>\n",
975
       "      <th>2</th>\n",
976
       "      <td>1</td>\n",
977
       "      <td>6</td>\n",
978
       "      <td>0.6270</td>\n",
979
       "      <td>-0.0054</td>\n",
980
       "      <td>-0.7200</td>\n",
981
       "      <td>0.016525</td>\n",
982
       "      <td>0.142136</td>\n",
983
       "      <td>9.646606</td>\n",
984
       "      <td>33.452240</td>\n",
985
       "      <td>3.993225</td>\n",
986
       "    </tr>\n",
987
       "    <tr>\n",
988
       "      <th>3</th>\n",
989
       "      <td>1</td>\n",
990
       "      <td>6</td>\n",
991
       "      <td>0.6266</td>\n",
992
       "      <td>-0.0070</td>\n",
993
       "      <td>-0.7174</td>\n",
994
       "      <td>0.012863</td>\n",
995
       "      <td>0.033371</td>\n",
996
       "      <td>9.646225</td>\n",
997
       "      <td>33.453735</td>\n",
998
       "      <td>4.002380</td>\n",
999
       "    </tr>\n",
1000
       "    <tr>\n",
1001
       "      <th>4</th>\n",
1002
       "      <td>1</td>\n",
1003
       "      <td>6</td>\n",
1004
       "      <td>0.6242</td>\n",
1005
       "      <td>-0.0078</td>\n",
1006
       "      <td>-0.7202</td>\n",
1007
       "      <td>0.007278</td>\n",
1008
       "      <td>-0.024994</td>\n",
1009
       "      <td>9.646988</td>\n",
1010
       "      <td>33.426544</td>\n",
1011
       "      <td>3.996277</td>\n",
1012
       "    </tr>\n",
1013
       "    <tr>\n",
1014
       "      <th>5</th>\n",
1015
       "      <td>1</td>\n",
1016
       "      <td>6</td>\n",
1017
       "      <td>0.6238</td>\n",
1018
       "      <td>-0.0072</td>\n",
1019
       "      <td>-0.7206</td>\n",
1020
       "      <td>-0.007416</td>\n",
1021
       "      <td>-0.050766</td>\n",
1022
       "      <td>9.645462</td>\n",
1023
       "      <td>33.447693</td>\n",
1024
       "      <td>3.977966</td>\n",
1025
       "    </tr>\n",
1026
       "    <tr>\n",
1027
       "      <th>6</th>\n",
1028
       "      <td>1</td>\n",
1029
       "      <td>6</td>\n",
1030
       "      <td>0.6242</td>\n",
1031
       "      <td>-0.0090</td>\n",
1032
       "      <td>-0.7194</td>\n",
1033
       "      <td>-0.025040</td>\n",
1034
       "      <td>-0.017715</td>\n",
1035
       "      <td>9.647369</td>\n",
1036
       "      <td>33.444672</td>\n",
1037
       "      <td>3.956604</td>\n",
1038
       "    </tr>\n",
1039
       "    <tr>\n",
1040
       "      <th>7</th>\n",
1041
       "      <td>1</td>\n",
1042
       "      <td>6</td>\n",
1043
       "      <td>0.6232</td>\n",
1044
       "      <td>-0.0074</td>\n",
1045
       "      <td>-0.7182</td>\n",
1046
       "      <td>-0.039093</td>\n",
1047
       "      <td>0.011215</td>\n",
1048
       "      <td>9.648132</td>\n",
1049
       "      <td>33.467316</td>\n",
1050
       "      <td>3.953552</td>\n",
1051
       "    </tr>\n",
1052
       "    <tr>\n",
1053
       "      <th>8</th>\n",
1054
       "      <td>1</td>\n",
1055
       "      <td>6</td>\n",
1056
       "      <td>0.6218</td>\n",
1057
       "      <td>-0.0114</td>\n",
1058
       "      <td>-0.7166</td>\n",
1059
       "      <td>-0.045410</td>\n",
1060
       "      <td>-0.011032</td>\n",
1061
       "      <td>9.646988</td>\n",
1062
       "      <td>33.453735</td>\n",
1063
       "      <td>3.929138</td>\n",
1064
       "    </tr>\n",
1065
       "    <tr>\n",
1066
       "      <th>9</th>\n",
1067
       "      <td>1</td>\n",
1068
       "      <td>6</td>\n",
1069
       "      <td>0.6162</td>\n",
1070
       "      <td>-0.0130</td>\n",
1071
       "      <td>-0.7158</td>\n",
1072
       "      <td>-0.040237</td>\n",
1073
       "      <td>-0.049576</td>\n",
1074
       "      <td>9.646225</td>\n",
1075
       "      <td>33.437103</td>\n",
1076
       "      <td>3.932190</td>\n",
1077
       "    </tr>\n",
1078
       "    <tr>\n",
1079
       "      <th>10</th>\n",
1080
       "      <td>1</td>\n",
1081
       "      <td>6</td>\n",
1082
       "      <td>0.6158</td>\n",
1083
       "      <td>-0.0158</td>\n",
1084
       "      <td>-0.7138</td>\n",
1085
       "      <td>-0.024490</td>\n",
1086
       "      <td>-0.069260</td>\n",
1087
       "      <td>9.645081</td>\n",
1088
       "      <td>33.447693</td>\n",
1089
       "      <td>3.904724</td>\n",
1090
       "    </tr>\n",
1091
       "    <tr>\n",
1092
       "      <th>11</th>\n",
1093
       "      <td>1</td>\n",
1094
       "      <td>6</td>\n",
1095
       "      <td>0.6140</td>\n",
1096
       "      <td>-0.0156</td>\n",
1097
       "      <td>-0.7128</td>\n",
1098
       "      <td>-0.012909</td>\n",
1099
       "      <td>-0.053513</td>\n",
1100
       "      <td>9.644699</td>\n",
1101
       "      <td>33.447693</td>\n",
1102
       "      <td>3.892517</td>\n",
1103
       "    </tr>\n",
1104
       "    <tr>\n",
1105
       "      <th>12</th>\n",
1106
       "      <td>1</td>\n",
1107
       "      <td>6</td>\n",
1108
       "      <td>0.6090</td>\n",
1109
       "      <td>-0.0142</td>\n",
1110
       "      <td>-0.7138</td>\n",
1111
       "      <td>-0.009293</td>\n",
1112
       "      <td>-0.049026</td>\n",
1113
       "      <td>9.643936</td>\n",
1114
       "      <td>33.447693</td>\n",
1115
       "      <td>3.883362</td>\n",
1116
       "    </tr>\n",
1117
       "    <tr>\n",
1118
       "      <th>13</th>\n",
1119
       "      <td>1</td>\n",
1120
       "      <td>6</td>\n",
1121
       "      <td>0.6082</td>\n",
1122
       "      <td>-0.0166</td>\n",
1123
       "      <td>-0.7090</td>\n",
1124
       "      <td>-0.008194</td>\n",
1125
       "      <td>-0.016800</td>\n",
1126
       "      <td>9.645844</td>\n",
1127
       "      <td>33.414459</td>\n",
1128
       "      <td>3.906250</td>\n",
1129
       "    </tr>\n",
1130
       "    <tr>\n",
1131
       "      <th>14</th>\n",
1132
       "      <td>1</td>\n",
1133
       "      <td>6</td>\n",
1134
       "      <td>0.6058</td>\n",
1135
       "      <td>-0.0184</td>\n",
1136
       "      <td>-0.7082</td>\n",
1137
       "      <td>-0.008606</td>\n",
1138
       "      <td>0.059189</td>\n",
1139
       "      <td>9.644318</td>\n",
1140
       "      <td>33.411469</td>\n",
1141
       "      <td>3.712463</td>\n",
1142
       "    </tr>\n",
1143
       "    <tr>\n",
1144
       "      <th>15</th>\n",
1145
       "      <td>1</td>\n",
1146
       "      <td>6</td>\n",
1147
       "      <td>0.6040</td>\n",
1148
       "      <td>-0.0218</td>\n",
1149
       "      <td>-0.7048</td>\n",
1150
       "      <td>-0.003250</td>\n",
1151
       "      <td>0.077133</td>\n",
1152
       "      <td>9.643936</td>\n",
1153
       "      <td>33.465851</td>\n",
1154
       "      <td>3.254700</td>\n",
1155
       "    </tr>\n",
1156
       "    <tr>\n",
1157
       "      <th>16</th>\n",
1158
       "      <td>1</td>\n",
1159
       "      <td>6</td>\n",
1160
       "      <td>0.6040</td>\n",
1161
       "      <td>-0.0238</td>\n",
1162
       "      <td>-0.7128</td>\n",
1163
       "      <td>0.000916</td>\n",
1164
       "      <td>0.010071</td>\n",
1165
       "      <td>9.643173</td>\n",
1166
       "      <td>33.450684</td>\n",
1167
       "      <td>3.834534</td>\n",
1168
       "    </tr>\n",
1169
       "    <tr>\n",
1170
       "      <th>17</th>\n",
1171
       "      <td>1</td>\n",
1172
       "      <td>6</td>\n",
1173
       "      <td>0.6038</td>\n",
1174
       "      <td>-0.0254</td>\n",
1175
       "      <td>-0.7160</td>\n",
1176
       "      <td>0.003433</td>\n",
1177
       "      <td>0.006821</td>\n",
1178
       "      <td>9.643173</td>\n",
1179
       "      <td>33.435608</td>\n",
1180
       "      <td>3.840637</td>\n",
1181
       "    </tr>\n",
1182
       "    <tr>\n",
1183
       "      <th>18</th>\n",
1184
       "      <td>1</td>\n",
1185
       "      <td>6</td>\n",
1186
       "      <td>0.6018</td>\n",
1187
       "      <td>-0.0286</td>\n",
1188
       "      <td>-0.7110</td>\n",
1189
       "      <td>-0.003067</td>\n",
1190
       "      <td>-0.011856</td>\n",
1191
       "      <td>9.643936</td>\n",
1192
       "      <td>33.508148</td>\n",
1193
       "      <td>3.851318</td>\n",
1194
       "    </tr>\n",
1195
       "    <tr>\n",
1196
       "      <th>19</th>\n",
1197
       "      <td>1</td>\n",
1198
       "      <td>6</td>\n",
1199
       "      <td>0.5994</td>\n",
1200
       "      <td>-0.0290</td>\n",
1201
       "      <td>-0.7126</td>\n",
1202
       "      <td>-0.015884</td>\n",
1203
       "      <td>-0.044632</td>\n",
1204
       "      <td>9.643936</td>\n",
1205
       "      <td>33.438599</td>\n",
1206
       "      <td>3.837585</td>\n",
1207
       "    </tr>\n",
1208
       "    <tr>\n",
1209
       "      <th>20</th>\n",
1210
       "      <td>1</td>\n",
1211
       "      <td>6</td>\n",
1212
       "      <td>0.5978</td>\n",
1213
       "      <td>-0.0326</td>\n",
1214
       "      <td>-0.7080</td>\n",
1215
       "      <td>-0.030899</td>\n",
1216
       "      <td>0.076950</td>\n",
1217
       "      <td>9.644699</td>\n",
1218
       "      <td>33.462799</td>\n",
1219
       "      <td>3.788757</td>\n",
1220
       "    </tr>\n",
1221
       "    <tr>\n",
1222
       "      <th>21</th>\n",
1223
       "      <td>1</td>\n",
1224
       "      <td>6</td>\n",
1225
       "      <td>0.5982</td>\n",
1226
       "      <td>-0.0358</td>\n",
1227
       "      <td>-0.7064</td>\n",
1228
       "      <td>-0.035339</td>\n",
1229
       "      <td>0.133026</td>\n",
1230
       "      <td>9.643173</td>\n",
1231
       "      <td>33.444672</td>\n",
1232
       "      <td>3.782654</td>\n",
1233
       "    </tr>\n",
1234
       "    <tr>\n",
1235
       "      <th>22</th>\n",
1236
       "      <td>1</td>\n",
1237
       "      <td>6</td>\n",
1238
       "      <td>0.5950</td>\n",
1239
       "      <td>-0.0328</td>\n",
1240
       "      <td>-0.7106</td>\n",
1241
       "      <td>-0.034470</td>\n",
1242
       "      <td>0.051956</td>\n",
1243
       "      <td>9.645462</td>\n",
1244
       "      <td>33.459747</td>\n",
1245
       "      <td>3.778076</td>\n",
1246
       "    </tr>\n",
1247
       "    <tr>\n",
1248
       "      <th>23</th>\n",
1249
       "      <td>1</td>\n",
1250
       "      <td>6</td>\n",
1251
       "      <td>0.5948</td>\n",
1252
       "      <td>-0.0350</td>\n",
1253
       "      <td>-0.7102</td>\n",
1254
       "      <td>-0.034332</td>\n",
1255
       "      <td>-0.047836</td>\n",
1256
       "      <td>9.643936</td>\n",
1257
       "      <td>33.438599</td>\n",
1258
       "      <td>3.761292</td>\n",
1259
       "    </tr>\n",
1260
       "    <tr>\n",
1261
       "      <th>24</th>\n",
1262
       "      <td>1</td>\n",
1263
       "      <td>6</td>\n",
1264
       "      <td>0.5912</td>\n",
1265
       "      <td>-0.0352</td>\n",
1266
       "      <td>-0.7046</td>\n",
1267
       "      <td>-0.033737</td>\n",
1268
       "      <td>-0.207779</td>\n",
1269
       "      <td>9.643936</td>\n",
1270
       "      <td>33.441620</td>\n",
1271
       "      <td>3.762817</td>\n",
1272
       "    </tr>\n",
1273
       "    <tr>\n",
1274
       "      <th>25</th>\n",
1275
       "      <td>1</td>\n",
1276
       "      <td>6</td>\n",
1277
       "      <td>0.5922</td>\n",
1278
       "      <td>-0.0370</td>\n",
1279
       "      <td>-0.7056</td>\n",
1280
       "      <td>-0.024765</td>\n",
1281
       "      <td>-0.344147</td>\n",
1282
       "      <td>9.643173</td>\n",
1283
       "      <td>33.440155</td>\n",
1284
       "      <td>3.746033</td>\n",
1285
       "    </tr>\n",
1286
       "    <tr>\n",
1287
       "      <th>26</th>\n",
1288
       "      <td>1</td>\n",
1289
       "      <td>6</td>\n",
1290
       "      <td>0.5928</td>\n",
1291
       "      <td>-0.0410</td>\n",
1292
       "      <td>-0.7054</td>\n",
1293
       "      <td>-0.021149</td>\n",
1294
       "      <td>-0.347305</td>\n",
1295
       "      <td>9.643936</td>\n",
1296
       "      <td>33.536865</td>\n",
1297
       "      <td>3.778076</td>\n",
1298
       "    </tr>\n",
1299
       "    <tr>\n",
1300
       "      <th>27</th>\n",
1301
       "      <td>1</td>\n",
1302
       "      <td>6</td>\n",
1303
       "      <td>0.5914</td>\n",
1304
       "      <td>-0.0406</td>\n",
1305
       "      <td>-0.7032</td>\n",
1306
       "      <td>-0.026413</td>\n",
1307
       "      <td>-0.049118</td>\n",
1308
       "      <td>9.643173</td>\n",
1309
       "      <td>33.450684</td>\n",
1310
       "      <td>3.648376</td>\n",
1311
       "    </tr>\n",
1312
       "    <tr>\n",
1313
       "      <th>28</th>\n",
1314
       "      <td>1</td>\n",
1315
       "      <td>6</td>\n",
1316
       "      <td>0.5890</td>\n",
1317
       "      <td>-0.0418</td>\n",
1318
       "      <td>-0.7054</td>\n",
1319
       "      <td>-0.032547</td>\n",
1320
       "      <td>0.199448</td>\n",
1321
       "      <td>9.643173</td>\n",
1322
       "      <td>33.455261</td>\n",
1323
       "      <td>3.285217</td>\n",
1324
       "    </tr>\n",
1325
       "    <tr>\n",
1326
       "      <th>29</th>\n",
1327
       "      <td>1</td>\n",
1328
       "      <td>6</td>\n",
1329
       "      <td>0.5886</td>\n",
1330
       "      <td>-0.0466</td>\n",
1331
       "      <td>-0.7026</td>\n",
1332
       "      <td>-0.032593</td>\n",
1333
       "      <td>0.287384</td>\n",
1334
       "      <td>9.643173</td>\n",
1335
       "      <td>33.476379</td>\n",
1336
       "      <td>3.697205</td>\n",
1337
       "    </tr>\n",
1338
       "    <tr>\n",
1339
       "      <th>...</th>\n",
1340
       "      <td>...</td>\n",
1341
       "      <td>...</td>\n",
1342
       "      <td>...</td>\n",
1343
       "      <td>...</td>\n",
1344
       "      <td>...</td>\n",
1345
       "      <td>...</td>\n",
1346
       "      <td>...</td>\n",
1347
       "      <td>...</td>\n",
1348
       "      <td>...</td>\n",
1349
       "      <td>...</td>\n",
1350
       "    </tr>\n",
1351
       "    <tr>\n",
1352
       "      <th>31470573</th>\n",
1353
       "      <td>4</td>\n",
1354
       "      <td>7</td>\n",
1355
       "      <td>0.8482</td>\n",
1356
       "      <td>-0.0274</td>\n",
1357
       "      <td>-0.3788</td>\n",
1358
       "      <td>-0.144699</td>\n",
1359
       "      <td>0.013138</td>\n",
1360
       "      <td>12.242508</td>\n",
1361
       "      <td>34.706207</td>\n",
1362
       "      <td>2.009583</td>\n",
1363
       "    </tr>\n",
1364
       "    <tr>\n",
1365
       "      <th>31470574</th>\n",
1366
       "      <td>4</td>\n",
1367
       "      <td>7</td>\n",
1368
       "      <td>0.8474</td>\n",
1369
       "      <td>-0.0254</td>\n",
1370
       "      <td>-0.3698</td>\n",
1371
       "      <td>-0.141861</td>\n",
1372
       "      <td>0.009384</td>\n",
1373
       "      <td>12.242508</td>\n",
1374
       "      <td>34.724670</td>\n",
1375
       "      <td>2.021790</td>\n",
1376
       "    </tr>\n",
1377
       "    <tr>\n",
1378
       "      <th>31470575</th>\n",
1379
       "      <td>4</td>\n",
1380
       "      <td>7</td>\n",
1381
       "      <td>0.8510</td>\n",
1382
       "      <td>-0.0262</td>\n",
1383
       "      <td>-0.3596</td>\n",
1384
       "      <td>-0.138016</td>\n",
1385
       "      <td>-0.006271</td>\n",
1386
       "      <td>12.242508</td>\n",
1387
       "      <td>34.713867</td>\n",
1388
       "      <td>2.024841</td>\n",
1389
       "    </tr>\n",
1390
       "    <tr>\n",
1391
       "      <th>31470576</th>\n",
1392
       "      <td>4</td>\n",
1393
       "      <td>7</td>\n",
1394
       "      <td>0.8486</td>\n",
1395
       "      <td>-0.0258</td>\n",
1396
       "      <td>-0.3560</td>\n",
1397
       "      <td>-0.133072</td>\n",
1398
       "      <td>-0.015427</td>\n",
1399
       "      <td>12.234879</td>\n",
1400
       "      <td>34.727722</td>\n",
1401
       "      <td>2.037048</td>\n",
1402
       "    </tr>\n",
1403
       "    <tr>\n",
1404
       "      <th>31470577</th>\n",
1405
       "      <td>4</td>\n",
1406
       "      <td>7</td>\n",
1407
       "      <td>0.8466</td>\n",
1408
       "      <td>-0.0228</td>\n",
1409
       "      <td>-0.3560</td>\n",
1410
       "      <td>-0.128677</td>\n",
1411
       "      <td>-0.011902</td>\n",
1412
       "      <td>12.240982</td>\n",
1413
       "      <td>34.724670</td>\n",
1414
       "      <td>2.064514</td>\n",
1415
       "    </tr>\n",
1416
       "    <tr>\n",
1417
       "      <th>31470578</th>\n",
1418
       "      <td>4</td>\n",
1419
       "      <td>7</td>\n",
1420
       "      <td>0.8446</td>\n",
1421
       "      <td>-0.0236</td>\n",
1422
       "      <td>-0.3570</td>\n",
1423
       "      <td>-0.125977</td>\n",
1424
       "      <td>-0.004166</td>\n",
1425
       "      <td>12.241745</td>\n",
1426
       "      <td>34.720032</td>\n",
1427
       "      <td>2.061462</td>\n",
1428
       "    </tr>\n",
1429
       "    <tr>\n",
1430
       "      <th>31470579</th>\n",
1431
       "      <td>4</td>\n",
1432
       "      <td>7</td>\n",
1433
       "      <td>0.8442</td>\n",
1434
       "      <td>-0.0238</td>\n",
1435
       "      <td>-0.3682</td>\n",
1436
       "      <td>-0.124329</td>\n",
1437
       "      <td>-0.016617</td>\n",
1438
       "      <td>12.240982</td>\n",
1439
       "      <td>34.726166</td>\n",
1440
       "      <td>1.881409</td>\n",
1441
       "    </tr>\n",
1442
       "    <tr>\n",
1443
       "      <th>31470580</th>\n",
1444
       "      <td>4</td>\n",
1445
       "      <td>7</td>\n",
1446
       "      <td>0.8414</td>\n",
1447
       "      <td>-0.0262</td>\n",
1448
       "      <td>-0.3758</td>\n",
1449
       "      <td>-0.124283</td>\n",
1450
       "      <td>-0.015244</td>\n",
1451
       "      <td>12.240219</td>\n",
1452
       "      <td>34.681610</td>\n",
1453
       "      <td>2.018738</td>\n",
1454
       "    </tr>\n",
1455
       "    <tr>\n",
1456
       "      <th>31470581</th>\n",
1457
       "      <td>4</td>\n",
1458
       "      <td>7</td>\n",
1459
       "      <td>0.8382</td>\n",
1460
       "      <td>-0.0254</td>\n",
1461
       "      <td>-0.3814</td>\n",
1462
       "      <td>-0.123230</td>\n",
1463
       "      <td>-0.018082</td>\n",
1464
       "      <td>12.242508</td>\n",
1465
       "      <td>34.744629</td>\n",
1466
       "      <td>2.021790</td>\n",
1467
       "    </tr>\n",
1468
       "    <tr>\n",
1469
       "      <th>31470582</th>\n",
1470
       "      <td>4</td>\n",
1471
       "      <td>7</td>\n",
1472
       "      <td>0.8402</td>\n",
1473
       "      <td>-0.0242</td>\n",
1474
       "      <td>-0.3906</td>\n",
1475
       "      <td>-0.120667</td>\n",
1476
       "      <td>-0.016068</td>\n",
1477
       "      <td>12.240219</td>\n",
1478
       "      <td>34.712341</td>\n",
1479
       "      <td>2.030945</td>\n",
1480
       "    </tr>\n",
1481
       "    <tr>\n",
1482
       "      <th>31470583</th>\n",
1483
       "      <td>4</td>\n",
1484
       "      <td>7</td>\n",
1485
       "      <td>0.8350</td>\n",
1486
       "      <td>-0.0222</td>\n",
1487
       "      <td>-0.3960</td>\n",
1488
       "      <td>-0.117691</td>\n",
1489
       "      <td>-0.010529</td>\n",
1490
       "      <td>12.240982</td>\n",
1491
       "      <td>34.726166</td>\n",
1492
       "      <td>2.052307</td>\n",
1493
       "    </tr>\n",
1494
       "    <tr>\n",
1495
       "      <th>31470584</th>\n",
1496
       "      <td>4</td>\n",
1497
       "      <td>7</td>\n",
1498
       "      <td>0.8358</td>\n",
1499
       "      <td>-0.0258</td>\n",
1500
       "      <td>-0.4038</td>\n",
1501
       "      <td>-0.115677</td>\n",
1502
       "      <td>-0.001602</td>\n",
1503
       "      <td>12.234879</td>\n",
1504
       "      <td>34.712341</td>\n",
1505
       "      <td>2.056885</td>\n",
1506
       "    </tr>\n",
1507
       "    <tr>\n",
1508
       "      <th>31470585</th>\n",
1509
       "      <td>4</td>\n",
1510
       "      <td>7</td>\n",
1511
       "      <td>0.8356</td>\n",
1512
       "      <td>-0.0264</td>\n",
1513
       "      <td>-0.4118</td>\n",
1514
       "      <td>-0.112198</td>\n",
1515
       "      <td>0.006363</td>\n",
1516
       "      <td>12.240982</td>\n",
1517
       "      <td>34.715424</td>\n",
1518
       "      <td>2.061462</td>\n",
1519
       "    </tr>\n",
1520
       "    <tr>\n",
1521
       "      <th>31470586</th>\n",
1522
       "      <td>4</td>\n",
1523
       "      <td>7</td>\n",
1524
       "      <td>0.8354</td>\n",
1525
       "      <td>-0.0264</td>\n",
1526
       "      <td>-0.4130</td>\n",
1527
       "      <td>-0.109451</td>\n",
1528
       "      <td>0.003479</td>\n",
1529
       "      <td>12.245178</td>\n",
1530
       "      <td>34.720032</td>\n",
1531
       "      <td>2.043152</td>\n",
1532
       "    </tr>\n",
1533
       "    <tr>\n",
1534
       "      <th>31470587</th>\n",
1535
       "      <td>4</td>\n",
1536
       "      <td>7</td>\n",
1537
       "      <td>0.8354</td>\n",
1538
       "      <td>-0.0264</td>\n",
1539
       "      <td>-0.4126</td>\n",
1540
       "      <td>-0.108765</td>\n",
1541
       "      <td>-0.010071</td>\n",
1542
       "      <td>12.239838</td>\n",
1543
       "      <td>34.733856</td>\n",
1544
       "      <td>2.037048</td>\n",
1545
       "    </tr>\n",
1546
       "    <tr>\n",
1547
       "      <th>31470588</th>\n",
1548
       "      <td>4</td>\n",
1549
       "      <td>7</td>\n",
1550
       "      <td>0.8370</td>\n",
1551
       "      <td>-0.0274</td>\n",
1552
       "      <td>-0.4066</td>\n",
1553
       "      <td>-0.105377</td>\n",
1554
       "      <td>0.000961</td>\n",
1555
       "      <td>12.238693</td>\n",
1556
       "      <td>34.727722</td>\n",
1557
       "      <td>2.024841</td>\n",
1558
       "    </tr>\n",
1559
       "    <tr>\n",
1560
       "      <th>31470589</th>\n",
1561
       "      <td>4</td>\n",
1562
       "      <td>7</td>\n",
1563
       "      <td>0.8376</td>\n",
1564
       "      <td>-0.0290</td>\n",
1565
       "      <td>-0.4014</td>\n",
1566
       "      <td>-0.101120</td>\n",
1567
       "      <td>-0.006729</td>\n",
1568
       "      <td>12.239456</td>\n",
1569
       "      <td>34.740021</td>\n",
1570
       "      <td>2.024841</td>\n",
1571
       "    </tr>\n",
1572
       "    <tr>\n",
1573
       "      <th>31470590</th>\n",
1574
       "      <td>4</td>\n",
1575
       "      <td>7</td>\n",
1576
       "      <td>0.8396</td>\n",
1577
       "      <td>-0.0302</td>\n",
1578
       "      <td>-0.3942</td>\n",
1579
       "      <td>-0.097366</td>\n",
1580
       "      <td>-0.005447</td>\n",
1581
       "      <td>12.240219</td>\n",
1582
       "      <td>34.727722</td>\n",
1583
       "      <td>2.032471</td>\n",
1584
       "    </tr>\n",
1585
       "    <tr>\n",
1586
       "      <th>31470591</th>\n",
1587
       "      <td>4</td>\n",
1588
       "      <td>7</td>\n",
1589
       "      <td>0.8390</td>\n",
1590
       "      <td>-0.0294</td>\n",
1591
       "      <td>-0.3864</td>\n",
1592
       "      <td>-0.092834</td>\n",
1593
       "      <td>-0.005081</td>\n",
1594
       "      <td>12.234879</td>\n",
1595
       "      <td>34.740021</td>\n",
1596
       "      <td>2.027893</td>\n",
1597
       "    </tr>\n",
1598
       "    <tr>\n",
1599
       "      <th>31470592</th>\n",
1600
       "      <td>4</td>\n",
1601
       "      <td>7</td>\n",
1602
       "      <td>0.8398</td>\n",
1603
       "      <td>-0.0290</td>\n",
1604
       "      <td>-0.3806</td>\n",
1605
       "      <td>-0.088943</td>\n",
1606
       "      <td>-0.005173</td>\n",
1607
       "      <td>12.239075</td>\n",
1608
       "      <td>34.710846</td>\n",
1609
       "      <td>2.040100</td>\n",
1610
       "    </tr>\n",
1611
       "    <tr>\n",
1612
       "      <th>31470593</th>\n",
1613
       "      <td>4</td>\n",
1614
       "      <td>7</td>\n",
1615
       "      <td>0.8382</td>\n",
1616
       "      <td>-0.0302</td>\n",
1617
       "      <td>-0.3766</td>\n",
1618
       "      <td>-0.087753</td>\n",
1619
       "      <td>-0.002792</td>\n",
1620
       "      <td>12.239456</td>\n",
1621
       "      <td>34.727722</td>\n",
1622
       "      <td>2.037048</td>\n",
1623
       "    </tr>\n",
1624
       "    <tr>\n",
1625
       "      <th>31470594</th>\n",
1626
       "      <td>4</td>\n",
1627
       "      <td>7</td>\n",
1628
       "      <td>0.8414</td>\n",
1629
       "      <td>-0.0328</td>\n",
1630
       "      <td>-0.3720</td>\n",
1631
       "      <td>-0.088760</td>\n",
1632
       "      <td>-0.006638</td>\n",
1633
       "      <td>12.239456</td>\n",
1634
       "      <td>34.723114</td>\n",
1635
       "      <td>2.041626</td>\n",
1636
       "    </tr>\n",
1637
       "    <tr>\n",
1638
       "      <th>31470595</th>\n",
1639
       "      <td>4</td>\n",
1640
       "      <td>7</td>\n",
1641
       "      <td>0.8440</td>\n",
1642
       "      <td>-0.0330</td>\n",
1643
       "      <td>-0.3710</td>\n",
1644
       "      <td>-0.085098</td>\n",
1645
       "      <td>0.008514</td>\n",
1646
       "      <td>12.239456</td>\n",
1647
       "      <td>34.712341</td>\n",
1648
       "      <td>1.889038</td>\n",
1649
       "    </tr>\n",
1650
       "    <tr>\n",
1651
       "      <th>31470596</th>\n",
1652
       "      <td>4</td>\n",
1653
       "      <td>7</td>\n",
1654
       "      <td>0.8452</td>\n",
1655
       "      <td>-0.0322</td>\n",
1656
       "      <td>-0.3674</td>\n",
1657
       "      <td>-0.082809</td>\n",
1658
       "      <td>0.006775</td>\n",
1659
       "      <td>12.237930</td>\n",
1660
       "      <td>34.663177</td>\n",
1661
       "      <td>2.073669</td>\n",
1662
       "    </tr>\n",
1663
       "    <tr>\n",
1664
       "      <th>31470597</th>\n",
1665
       "      <td>4</td>\n",
1666
       "      <td>7</td>\n",
1667
       "      <td>0.8446</td>\n",
1668
       "      <td>-0.0328</td>\n",
1669
       "      <td>-0.3608</td>\n",
1670
       "      <td>-0.079971</td>\n",
1671
       "      <td>0.000778</td>\n",
1672
       "      <td>12.240219</td>\n",
1673
       "      <td>34.732361</td>\n",
1674
       "      <td>2.082825</td>\n",
1675
       "    </tr>\n",
1676
       "    <tr>\n",
1677
       "      <th>31470598</th>\n",
1678
       "      <td>4</td>\n",
1679
       "      <td>7</td>\n",
1680
       "      <td>0.8442</td>\n",
1681
       "      <td>-0.0344</td>\n",
1682
       "      <td>-0.3638</td>\n",
1683
       "      <td>-0.076309</td>\n",
1684
       "      <td>-0.001511</td>\n",
1685
       "      <td>12.240219</td>\n",
1686
       "      <td>34.724670</td>\n",
1687
       "      <td>2.073669</td>\n",
1688
       "    </tr>\n",
1689
       "    <tr>\n",
1690
       "      <th>31470599</th>\n",
1691
       "      <td>4</td>\n",
1692
       "      <td>7</td>\n",
1693
       "      <td>0.8434</td>\n",
1694
       "      <td>-0.0330</td>\n",
1695
       "      <td>-0.3634</td>\n",
1696
       "      <td>-0.074844</td>\n",
1697
       "      <td>-0.006271</td>\n",
1698
       "      <td>12.240219</td>\n",
1699
       "      <td>34.716980</td>\n",
1700
       "      <td>2.082825</td>\n",
1701
       "    </tr>\n",
1702
       "    <tr>\n",
1703
       "      <th>31470600</th>\n",
1704
       "      <td>4</td>\n",
1705
       "      <td>7</td>\n",
1706
       "      <td>0.8462</td>\n",
1707
       "      <td>-0.0348</td>\n",
1708
       "      <td>-0.3650</td>\n",
1709
       "      <td>-0.073013</td>\n",
1710
       "      <td>-0.006638</td>\n",
1711
       "      <td>12.233353</td>\n",
1712
       "      <td>34.715424</td>\n",
1713
       "      <td>2.079773</td>\n",
1714
       "    </tr>\n",
1715
       "    <tr>\n",
1716
       "      <th>31470601</th>\n",
1717
       "      <td>4</td>\n",
1718
       "      <td>7</td>\n",
1719
       "      <td>0.8446</td>\n",
1720
       "      <td>-0.0360</td>\n",
1721
       "      <td>-0.3652</td>\n",
1722
       "      <td>-0.071136</td>\n",
1723
       "      <td>-0.001694</td>\n",
1724
       "      <td>12.239075</td>\n",
1725
       "      <td>34.724670</td>\n",
1726
       "      <td>2.079773</td>\n",
1727
       "    </tr>\n",
1728
       "    <tr>\n",
1729
       "      <th>31470602</th>\n",
1730
       "      <td>4</td>\n",
1731
       "      <td>7</td>\n",
1732
       "      <td>0.8472</td>\n",
1733
       "      <td>-0.0358</td>\n",
1734
       "      <td>-0.3654</td>\n",
1735
       "      <td>-0.067154</td>\n",
1736
       "      <td>0.000778</td>\n",
1737
       "      <td>12.236786</td>\n",
1738
       "      <td>34.726166</td>\n",
1739
       "      <td>2.076721</td>\n",
1740
       "    </tr>\n",
1741
       "  </tbody>\n",
1742
       "</table>\n",
1743
       "<p>31470603 rows × 10 columns</p>\n",
1744
       "</div>"
1745
      ],
1746
      "text/plain": [
1747
       "          target  subject  chest_ACC_x  chest_ACC_y  chest_ACC_z  chest_ECG  \\\n",
1748
       "0              1        6       0.6280      -0.0082      -0.7272   0.016937   \n",
1749
       "1              1        6       0.6276      -0.0056      -0.7262   0.017853   \n",
1750
       "2              1        6       0.6270      -0.0054      -0.7200   0.016525   \n",
1751
       "3              1        6       0.6266      -0.0070      -0.7174   0.012863   \n",
1752
       "4              1        6       0.6242      -0.0078      -0.7202   0.007278   \n",
1753
       "...          ...      ...          ...          ...          ...        ...   \n",
1754
       "31470598       4        7       0.8442      -0.0344      -0.3638  -0.076309   \n",
1755
       "31470599       4        7       0.8434      -0.0330      -0.3634  -0.074844   \n",
1756
       "31470600       4        7       0.8462      -0.0348      -0.3650  -0.073013   \n",
1757
       "31470601       4        7       0.8446      -0.0360      -0.3652  -0.071136   \n",
1758
       "31470602       4        7       0.8472      -0.0358      -0.3654  -0.067154   \n",
1759
       "\n",
1760
       "          chest_EMG  chest_EDA  chest_Temp  chest_Resp  \n",
1761
       "0          0.134720   9.645462   33.432587    4.010010  \n",
1762
       "1          0.216248   9.645462   33.459747    4.039001  \n",
1763
       "2          0.142136   9.646606   33.452240    3.993225  \n",
1764
       "3          0.033371   9.646225   33.453735    4.002380  \n",
1765
       "4         -0.024994   9.646988   33.426544    3.996277  \n",
1766
       "...             ...        ...         ...         ...  \n",
1767
       "31470598  -0.001511  12.240219   34.724670    2.073669  \n",
1768
       "31470599  -0.006271  12.240219   34.716980    2.082825  \n",
1769
       "31470600  -0.006638  12.233353   34.715424    2.079773  \n",
1770
       "31470601  -0.001694  12.239075   34.724670    2.079773  \n",
1771
       "31470602   0.000778  12.236786   34.726166    2.076721  \n",
1772
       "\n",
1773
       "[31470603 rows x 10 columns]"
1774
      ]
1775
     },
1776
     "execution_count": 4,
1777
     "metadata": {},
1778
     "output_type": "execute_result"
1779
    }
1780
   ],
1781
   "source": [
1782
    "df"
1783
   ]
1784
  },
1785
  {
1786
   "cell_type": "code",
1787
   "execution_count": 5,
1788
   "metadata": {},
1789
   "outputs": [
1790
    {
1791
     "data": {
1792
      "text/plain": [
1793
       "array([1, 2, 4, 3])"
1794
      ]
1795
     },
1796
     "execution_count": 5,
1797
     "metadata": {},
1798
     "output_type": "execute_result"
1799
    }
1800
   ],
1801
   "source": [
1802
    "df['target'].unique()"
1803
   ]
1804
  },
1805
  {
1806
   "cell_type": "code",
1807
   "execution_count": 6,
1808
   "metadata": {},
1809
   "outputs": [],
1810
   "source": [
1811
    "df.to_csv(\"master_data.csv\",index=False)"
1812
   ]
1813
  },
1814
  {
1815
   "cell_type": "code",
1816
   "execution_count": null,
1817
   "metadata": {},
1818
   "outputs": [],
1819
   "source": [
1820
    "df"
1821
   ]
1822
  },
1823
  {
1824
   "cell_type": "code",
1825
   "execution_count": null,
1826
   "metadata": {},
1827
   "outputs": [],
1828
   "source": []
1829
  }
1830
 ],
1831
 "metadata": {
1832
  "kernelspec": {
1833
   "display_name": "Python 3",
1834
   "language": "python",
1835
   "name": "python3"
1836
  },
1837
  "language_info": {
1838
   "codemirror_mode": {
1839
    "name": "ipython",
1840
    "version": 3
1841
   },
1842
   "file_extension": ".py",
1843
   "mimetype": "text/x-python",
1844
   "name": "python",
1845
   "nbconvert_exporter": "python",
1846
   "pygments_lexer": "ipython3",
1847
   "version": "3.6.8"
1848
  }
1849
 },
1850
 "nbformat": 4,
1851
 "nbformat_minor": 2
1852
}