Driving Behavior Dataset

target Target	accmeanx AccMeanX	accmeany AccMeanY	accmeanz AccMeanZ	acccovx AccCovX	acccovy AccCovY	acccovz AccCovZ	accskewx AccSkewX	accskewy AccSkewY	accskewz AccSkewZ	acckurtx AccKurtX	acckurty AccKurtY	acckurtz AccKurtZ	accsumx AccSumX	accsumy AccSumY	accsumz AccSumZ	accminx AccMinX	accminy AccMinY	accminz AccMinZ	accmaxx AccMaxX	accmaxy AccMaxY	accmaxz AccMaxZ	accvarx AccVarX	accvary AccVarY	accvarz AccVarZ	accmedianx AccMedianX	accmediany AccMedianY	accmedianz AccMedianZ	accstdx AccStdX	accstdy AccStdY	accstdz AccStdZ	gyromeanx GyroMeanX	gyromeany GyroMeanY	gyromeanz GyroMeanZ	gyrocovx GyroCovX	gyrocovy GyroCovY	gyrocovz GyroCovZ	gyroskewx GyroSkewX	gyroskewy GyroSkewY	gyroskewz GyroSkewZ	gyrosumx GyroSumX	gyrosumy GyroSumY	gyrosumz GyroSumZ	gyrokurtx GyroKurtX	gyrokurty GyroKurtY	gyrokurtz GyroKurtZ	gyrominx GyroMinX	gyrominy GyroMinY	gyrominz GyroMinZ	gyromaxx GyroMaxX	gyromaxy GyroMaxY	gyromaxz GyroMaxZ	gyrovarx GyroVarX	gyrovary GyroVarY	gyrovarz GyroVarZ	gyromedianx GyroMedianX	gyromediany GyroMedianY	gyromedianz GyroMedianZ	gyrostdx GyroStdX	gyrostdy GyroStdY	gyrostdz GyroStdZ
1	0.28533935546875	-0.13861083984375	-0.957763671875	0.0221495380004247	0.0039751281340916	0.0019262234369913	0.8675941232473949	-1.3058678368257428	-0.507254093830019	-1.164805719977732	1.2398402140041649	-0.7610645928248392	1.141357421875	-0.554443359375	-3.8310546875	0.16259765625	-0.226806640625	-1.01318359375	0.480224609375	-0.086669921875	-0.91162109375	0.0221495380004247	0.0039751281340916	0.0019262234369913	0.249267578125	-0.1204833984375	-0.953125	0.1488272085353505	0.0630486172258495	0.0438887620808718	-0.1774809160305342	4.190839694656488	0.4980916030534351	0.761120175591943	0.1843715401200445	0.2628586135229106	0.2253522642276665	-0.338028342080587	-1.7271831095975467	-0.7099236641221371	16.763358778625953	1.9923664122137403	-4.710496332049015	-4.03586811805139	2.9147956974156277	-0.9236641221374046	3.694656488549618	-0.2519083969465649	0.7862595419847328	4.564885496183206	0.8320610687022901	0.7611201755919428	0.1843715401200397	0.2628586135229104	-0.2862595419847328	4.251908396946565	0.7061068702290076	0.8724220169115076	0.4293850720740531	0.5126973898148014
1	0.3134765625	-0.161669921875	-0.95625	0.0205706655979156	0.0056399524211883	0.0014561235904692	0.0024740804962866	-0.3950876184076279	-0.6775722668425516	-2.649441253579396	-2.6498026514738577	0.6367618126472708	1.5673828125	-0.808349609375	-4.78125	0.16259765625	-0.25390625	-1.01318359375	0.480224609375	-0.086669921875	-0.91162109375	0.0205706655979156	0.0056399524211883	0.0014561235904693	0.32275390625	-0.140380859375	-0.9501953125	0.143424773306133	0.0750996166514074	0.0381591874975	0.5282442748091605	3.8916030534351145	0.3770992366412213	3.0610803566225755	0.5859914923372767	0.2703397237923198	1.2820797030110362	-1.069371742252205	-0.5015299501089073	2.6412213740458026	19.45801526717557	1.8854961832061068	1.6330175090053298	0.846741563008352	-2.9328927120773405	-0.9236641221374046	2.6946564885496183	-0.2519083969465649	3.35114503816794	4.564885496183206	0.8320610687022901	3.061080356622575	0.5859914923372764	0.2703397237923198	0.3358778625954199	3.969465648854962	0.5877862595419847	1.7495943405894336	0.7655008114543553	0.5199420388777193
1	0.3251953125	-0.1583251953125	-0.9501546223958334	0.0172805070877075	0.004579085111618	0.0013878206411996	-0.3542121748734608	-0.6036574343882443	-0.9846350069931809	-1.819231825629774	-1.472250516313962	0.663006286695533	1.951171875	-0.949951171875	-5.700927734375	0.16259765625	-0.25390625	-1.01318359375	0.480224609375	-0.086669921875	-0.91162109375	0.0172805070877075	0.004579085111618	0.0013878206411997	0.353271484375	-0.1409912109375	-0.9434814453125	0.1314553425605346	0.0676689375682672	0.0372534648214061	0.1895674300254455	3.773536895674301	0.0381679389312976	3.137076316453976	0.5524308995202262	0.9055183264378536	1.309764668393348	-0.3788637173136753	-1.3027397586426008	1.137404580152673	22.6412213740458	0.2290076335877857	1.6631698505480526	-1.1922464799374357	1.5406392859258868	-1.5038167938931295	2.6946564885496183	-1.656488549618321	3.35114503816794	4.564885496183206	0.8320610687022901	3.1370763164539754	0.5524308995202301	0.9055183264378538	-0.2862595419847328	3.8320610687022896	0.2404580152671755	1.7711793575056072	0.7432569538996794	0.9515872668535732
1	0.3365652901785714	-0.1724679129464285	-0.9376395089285714	0.015305357319968	0.0052160194941929	0.0022529136566889	-0.6556531802661598	-0.1524541001596116	-0.0405297049966127	-1.214712255654473	-2.1854850903576746	0.6662092430434647	2.35595703125	-1.207275390625	-6.5634765625	0.16259765625	-0.25732421875	-1.01318359375	0.480224609375	-0.086669921875	-0.862548828125	0.015305357319968	0.0052160194941929	0.0022529136566888	0.3837890625	-0.1416015625	-0.936767578125	0.1237148225556181	0.0722220153013812	0.0474648676042488	0.3565976008724102	4.480916030534352	-0.1025081788440567	2.80952380952381	3.9630557659809975	0.8931269961512958	0.861001767400908	2.0097066195790254	-0.6677976458458115	2.496183206106872	31.36641221374046	-0.7175572519083975	0.4341899011506918	4.6420074036613865	-0.6801040376189406	-1.5038167938931295	2.6946564885496183	-1.656488549618321	3.35114503816794	8.725190839694656	0.8320610687022901	2.8095238095238098	3.963055765981004	0.8931269961512959	0.3358778625954199	3.969465648854962	-0.1068702290076336	1.6761634196950517	1.9907425162438768	0.9450539646767776
1	0.337860107421875	-0.1641845703125	-0.941680908203125	0.0131322901163782	0.0050197839736938	0.0020617321133613	-0.7184875391926304	-0.446060798415271	0.2505394873019846	-0.666621833514607	-1.909540390552563	0.5561156239172201	2.702880859375	-1.3134765625	-7.533447265625	0.16259765625	-0.25732421875	-1.01318359375	0.480224609375	-0.086669921875	-0.862548828125	0.0131322901163782	0.0050197839736938	0.0020617321133613	0.3653564453125	-0.1409912109375	-0.9434814453125	0.1145962046333919	0.0708504338285507	0.0454063003707784	0.1765267175572521	4.434160305343512	-0.1679389312977099	2.6675674494493333	3.4143937249743965	0.7997868922057491	1.072054859801441	2.151157790331504	-0.3882484019672541	1.4122137404580168	35.47328244274809	-1.34351145038168	0.7377497407428374	5.422660611794532	-0.8171325417310655	-1.5038167938931295	2.6946564885496183	-1.656488549618321	3.35114503816794	8.725190839694656	0.8320610687022901	2.667567449449333	3.4143937249744023	0.7997868922057493	-0.2862595419847328	4.038167938931298	-0.1793893129770992	1.633268945841233	1.8478078160280635	0.8943080521865769
1	0.3310546875	-0.174560546875	-0.9490831163194444	0.0119075775146484	0.005361258983612	0.0022971497641669	-0.4896319185576068	-0.1236817718601623	0.3491784318419822	-0.7758198938540928	-2.1905818499652616	-0.0864164187098513	2.9794921875	-1.571044921875	-8.541748046875	0.16259765625	-0.257568359375	-1.01318359375	0.480224609375	-0.086669921875	-0.862548828125	0.0119075775146484	0.005361258983612	0.0022971497641669	0.346923828125	-0.1416015625	-0.9501953125	0.1091218471006078	0.073220618568898	0.0479285902584974	0.162849872773537	4.506361323155216	-0.3960983884648008	2.3358050230173077	3.034511392110015	1.1683241717330646	1.138383142525122	2.014693447072492	-0.4596789442037761	1.4656488549618336	40.55725190839695	-3.564885496183207	1.2399842271411117	5.0651007870764335	-0.8121864967232169	-1.5038167938931295	2.6946564885496183	-2.221374045801527	3.35114503816794	8.725190839694656	0.8320610687022901	2.335805023017307	3.034511392110017	1.1683241717330644	0.0534351145038167	4.106870229007634	-0.2519083969465649	1.528334067871716	1.7419849000809442	1.0808904531602934
1	0.3138427734375	-0.16826171875	-0.951318359375	0.013547013203303	0.0051623158984714	0.0020918740166559	-0.2388098254756864	-0.3492320118840124	0.5144678172087956	-1.3868428038673228	-2.016279873165761	0.2099126982563832	3.138427734375	-1.6826171875	-9.51318359375	0.158935546875	-0.257568359375	-1.01318359375	0.480224609375	-0.086669921875	-0.862548828125	0.013547013203303	0.0051623158984714	0.0020918740166558	0.3348388671875	-0.1409912109375	-0.9598388671875	0.1163916371708166	0.07184925816229	0.0457370092666301	0.0358778625954199	4.421374045801527	-0.2786259541984733	2.237490045257659	2.769571832773276	1.1765081029984013	1.2835545879440171	2.1699995558260654	-0.6245800510730452	0.3587786259541996	44.21374045801527	-2.786259541984734	1.5343410563991944	5.767468258878613	-0.7317445949250718	-1.5038167938931295	2.6946564885496183	-2.221374045801527	3.35114503816794	8.725190839694656	0.8320610687022901	2.2374900452576583	2.769571832773278	1.176508102998401	-0.4274809160305344	4.038167938931298	-0.1793893129770992	1.4958242026580724	1.664203062361465	1.0846695824067352
1	0.3014248934659091	-0.1620871803977272	-0.9559437144886364	0.0138885530558499	0.0050654584711248	0.0021180196241899	-0.0048375340575023	-0.5289389564325667	0.6491051546743156	-1.6016370568960645	-1.795529190431484	0.1148684540200272	3.315673828125	-1.782958984375	-10.515380859375	0.158935546875	-0.257568359375	-1.01318359375	0.480224609375	-0.086669921875	-0.862548828125	0.0138885530558499	0.0050654584711248	0.0021180196241898	0.32275390625	-0.140380859375	-0.969482421875	0.1178497053702297	0.0711720343331903	0.0460219472011984	-0.0575988896599582	4.319916724496878	-0.190145732130465	2.10985797606624	2.605844118005411	1.1449735393678058	1.4265227229799609	2.2827681829715187	-0.7844705749931179	-0.6335877862595408	47.519083969465655	-2.0916030534351155	1.933427440496144	6.282590519869881	-0.5277265054977754	-1.5038167938931295	2.6946564885496183	-2.221374045801527	3.35114503816794	8.725190839694656	0.8320610687022901	2.1098579760662397	2.6058441180054137	1.1449735393678058	-0.9083969465648856	3.969465648854962	-0.1068702290076336	1.4525350171566396	1.6142627165382386	1.07003436363876
1	0.2914021809895833	-0.1565348307291666	-0.9579671223958334	0.0138314145080971	0.0049749052885806	0.0019746025403338	0.1865872610843547	-0.6771323133788824	0.7898702977783012	-1.621831017610132	-1.551532940725764	0.4009218900642666	3.496826171875	-1.87841796875	-11.49560546875	0.158935546875	-0.257568359375	-1.01318359375	0.480224609375	-0.086669921875	-0.862548828125	0.0138314145080971	0.0049749052885806	0.001974602540334	0.2996826171875	-0.1259765625	-0.9697265625	0.1176070342628241	0.0705330085036835	0.0444365000909619	-0.1227735368956742	4.270356234096693	-0.1125954198473283	1.9690255212223635	2.398424104691216	1.1130536470114587	1.5607273691564711	2.416529243322474	-0.9207963177342986	-1.4732824427480904	51.24427480916031	-1.35114503816794	2.398147454143523	7.008021485063289	-0.2934766253316335	-1.5038167938931295	2.6946564885496183	-2.221374045801527	3.35114503816794	8.725190839694656	0.8320610687022901	1.9690255212223635	2.398424104691222	1.1130536470114587	-0.8740458015267176	3.847328244274809	0.2404580152671755	1.403219698130825	1.5486846369391096	1.0550135766953233
1	0.2925555889423077	-0.1568509615384615	-0.9571063701923076	0.0126960911811926	0.0045616290508172	0.0018196839552659	0.1554771739617	-0.6796553059015036	0.7362770501030463	-1.4328678157578063	-1.3624210063643618	0.5548778436179636	3.80322265625	-2.0390625	-12.4423828125	0.158935546875	-0.257568359375	-1.01318359375	0.480224609375	-0.086669921875	-0.862548828125	0.0126960911811926	0.0045616290508172	0.0018196839552659	0.306396484375	-0.140380859375	-0.969482421875	0.1126769327821477	0.067539833067733	0.042657753753168	-0.1233118027011156	4.256018790369936	-0.0364063417498532	1.8049438276115048	2.201227739104314	1.095761259504631	1.6068431312497224	2.515282898123721	-1.0261484749655063	-1.6030534351145027	55.328244274809165	-0.4732824427480926	2.77354736043139	7.677661779697844	-0.0746799871077908	-1.5038167938931295	2.6946564885496183	-2.221374045801527	3.35114503816794	8.725190839694656	0.8778625954198473	1.8049438276115048	2.20122773910432	1.095761259504631	-0.8396946564885496	3.969465648854962	0.5877862595419847	1.3434819788934664	1.483653510461361	1.046786157486156


CREATE TABLE sero_features_10 (
  "target" BIGINT,
  "accmeanx" DOUBLE,
  "accmeany" DOUBLE,
  "accmeanz" DOUBLE,
  "acccovx" DOUBLE,
  "acccovy" DOUBLE,
  "acccovz" DOUBLE,
  "accskewx" DOUBLE,
  "accskewy" DOUBLE,
  "accskewz" DOUBLE,
  "acckurtx" DOUBLE,
  "acckurty" DOUBLE,
  "acckurtz" DOUBLE,
  "accsumx" DOUBLE,
  "accsumy" DOUBLE,
  "accsumz" DOUBLE,
  "accminx" DOUBLE,
  "accminy" DOUBLE,
  "accminz" DOUBLE,
  "accmaxx" DOUBLE,
  "accmaxy" DOUBLE,
  "accmaxz" DOUBLE,
  "accvarx" DOUBLE,
  "accvary" DOUBLE,
  "accvarz" DOUBLE,
  "accmedianx" DOUBLE,
  "accmediany" DOUBLE,
  "accmedianz" DOUBLE,
  "accstdx" DOUBLE,
  "accstdy" DOUBLE,
  "accstdz" DOUBLE,
  "gyromeanx" DOUBLE,
  "gyromeany" DOUBLE,
  "gyromeanz" DOUBLE,
  "gyrocovx" DOUBLE,
  "gyrocovy" DOUBLE,
  "gyrocovz" DOUBLE,
  "gyroskewx" DOUBLE,
  "gyroskewy" DOUBLE,
  "gyroskewz" DOUBLE,
  "gyrosumx" DOUBLE,
  "gyrosumy" DOUBLE,
  "gyrosumz" DOUBLE,
  "gyrokurtx" DOUBLE,
  "gyrokurty" DOUBLE,
  "gyrokurtz" DOUBLE,
  "gyrominx" DOUBLE,
  "gyrominy" DOUBLE,
  "gyrominz" DOUBLE,
  "gyromaxx" DOUBLE,
  "gyromaxy" DOUBLE,
  "gyromaxz" DOUBLE,
  "gyrovarx" DOUBLE,
  "gyrovary" DOUBLE,
  "gyrovarz" DOUBLE,
  "gyromedianx" DOUBLE,
  "gyromediany" DOUBLE,
  "gyromedianz" DOUBLE,
  "gyrostdx" DOUBLE,
  "gyrostdy" DOUBLE,
  "gyrostdz" DOUBLE
);