Overview

Dataset statistics

Number of variables6
Number of observations167351175
Missing cells0
Missing cells (%)0.0%
Total size in memory10.3 GiB
Average record size in memory66.0 B

Variable types

Text1
Numeric4
DateTime1

Dataset

Description[m/s2] Acceleration force along the x,y,z axis (including gravity). To compare each sensor observation, the frequency was reduced to one minute. The first non-missing name is reported for each of the categorical variables.
CreatorAndrea Bontempelli, Matteo Busso, Roy Alia Asiku
AuthorAndrea Bontempelli, Matteo Busso, Fausto Giunchiglia
URL
Copyright(c) University of Trento - Knowledge Diversity 2023

Variable descriptions

experimentidExperiment Id
useridUser id
timestampshow month(2), day(2), hour(2), minute(2), second(2), decimals(3)
x x axis value at the time of capture
y y axis value at the time of capture
z z axis value at the time of capture

Alerts

experimentid has constant value "wenetIndia"Constant
userid has 17291270 (10.3%) zerosZeros
x has 2079082 (1.2%) zerosZeros

Reproduction

Analysis started2024-11-22 12:45:20.273340
Analysis finished2024-11-22 13:01:11.554569
Duration15 minutes and 51.28 seconds
Software versionydata-profiling v4.8.3
Download configurationconfig.json

Variables

experimentid
Text

CONSTANT 

Experiment Id

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size4.1 GiB
2024-11-22T14:01:11.614530image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

Total characters1673511750
Distinct characters8
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowwenetIndia
2nd rowwenetIndia
3rd rowwenetIndia
4th rowwenetIndia
5th rowwenetIndia
ValueCountFrequency (%)
wenetindia 167351175
100.0%
2024-11-22T14:01:11.812725image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 334702350
20.0%
n 334702350
20.0%
w 167351175
10.0%
t 167351175
10.0%
I 167351175
10.0%
d 167351175
10.0%
i 167351175
10.0%
a 167351175
10.0%

Most occurring categories

ValueCountFrequency (%)
(unknown) 1673511750
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
e 334702350
20.0%
n 334702350
20.0%
w 167351175
10.0%
t 167351175
10.0%
I 167351175
10.0%
d 167351175
10.0%
i 167351175
10.0%
a 167351175
10.0%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 1673511750
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
e 334702350
20.0%
n 334702350
20.0%
w 167351175
10.0%
t 167351175
10.0%
I 167351175
10.0%
d 167351175
10.0%
i 167351175
10.0%
a 167351175
10.0%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 1673511750
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
e 334702350
20.0%
n 334702350
20.0%
w 167351175
10.0%
t 167351175
10.0%
I 167351175
10.0%
d 167351175
10.0%
i 167351175
10.0%
a 167351175
10.0%

userid
Real number (ℝ)

ZEROS 

User id

Distinct20
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21.52597865
Minimum0
Maximum62
Zeros17291270
Zeros (%)10.3%
Negative0
Negative (%)0.0%
Memory size2.5 GiB
2024-11-22T14:01:11.915505image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q19
median17
Q343
95-th percentile49
Maximum62
Range62
Interquartile range (IQR)34

Descriptive statistics

Standard deviation16.99274155
Coefficient of variation (CV)0.7894062252
Kurtosis-1.234329897
Mean21.52597865
Median Absolute Deviation (MAD)13
Skewness0.4647852206
Sum3602397820
Variance288.7532653
MonotonicityIncreasing
2024-11-22T14:01:12.010656image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%)
9 31584769
18.9%
43 29027209
17.3%
17 19424686
11.6%
0 17291270
10.3%
12 14818910
8.9%
4 13192347
7.9%
35 9666080
 
5.8%
44 9389427
 
5.6%
49 4386644
 
2.6%
26 3424518
 
2.0%
Other values (10) 15145315
9.1%
ValueCountFrequency (%)
0 17291270
10.3%
4 13192347
7.9%
8 3232731
 
1.9%
9 31584769
18.9%
12 14818910
8.9%
ValueCountFrequency (%)
62 730799
 
0.4%
57 3287375
 
2.0%
49 4386644
2.6%
46 92562
 
0.1%
44 9389427
5.6%

timestamp
Date

show month(2), day(2), hour(2), minute(2), second(2), decimals(3)

Distinct160524522
Distinct (%)95.9%
Missing0
Missing (%)0.0%
Memory size2.5 GiB
Minimum2021-07-12 08:00:00.017000
Maximum2021-08-12 14:41:48.791000
2024-11-22T14:01:12.120712image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-11-22T14:01:12.242774image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

x
Real number (ℝ)

ZEROS 

x axis value at the time of capture

Distinct6507
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.5633270191
Minimum-78.44999695
Maximum78.44999695
Zeros2079082
Zeros (%)1.2%
Negative65153083
Negative (%)38.9%
Memory size2.5 GiB
2024-11-22T14:01:12.354764image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum-78.44999695
5-th percentile-3.970000029
Q1-0.4300000072
median0.1700000018
Q31.159999967
95-th percentile7.989999771
Maximum78.44999695
Range156.8999939
Interquartile range (IQR)1.589999974

Descriptive statistics

Standard deviation3.178139735
Coefficient of variation (CV)5.641731404
Kurtosis3.145694885
Mean0.5633270191
Median Absolute Deviation (MAD)0.7700000256
Skewness0.3994393857
Sum94273438.56
Variance10.10057217
MonotonicityNot monotonic
2024-11-22T14:01:12.473336image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 2079082
 
1.2%
0.05000000075 1487768
 
0.9%
0.05999999866 1411020
 
0.8%
0.01999999955 1163451
 
0.7%
-0.009999999776 1145888
 
0.7%
0.009999999776 1129209
 
0.7%
0.03999999911 1127554
 
0.7%
-0.05000000075 1109274
 
0.7%
0.0700000003 1080248
 
0.6%
0.02999999933 1057182
 
0.6%
Other values (6497) 154560499
92.4%
ValueCountFrequency (%)
-78.44999695 15
< 0.1%
-78.44000244 2
 
< 0.1%
-75.16999817 1
 
< 0.1%
-75.02999878 1
 
< 0.1%
-71.18000031 1
 
< 0.1%
ValueCountFrequency (%)
78.44999695 1
 
< 0.1%
78.44000244 8
< 0.1%
76.98999786 1
 
< 0.1%
74.63999939 1
 
< 0.1%
73.16999817 1
 
< 0.1%

y
Real number (ℝ)

y axis value at the time of capture

Distinct7006
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.590941221
Minimum-78.58999634
Maximum78.44999695
Zeros1454900
Zeros (%)0.9%
Negative56230777
Negative (%)33.6%
Memory size2.5 GiB
2024-11-22T14:01:12.589766image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum-78.58999634
5-th percentile-6.269999981
Q1-0.2300000042
median0.4199999869
Q34.289999962
95-th percentile8.850000381
Maximum78.44999695
Range157.0399933
Interquartile range (IQR)4.519999966

Descriptive statistics

Standard deviation4.130172682
Coefficient of variation (CV)2.596056112
Kurtosis1.404800481
Mean1.590941221
Median Absolute Deviation (MAD)1.159999996
Skewness-0.299760338
Sum266245882.8
Variance17.05832638
MonotonicityNot monotonic
2024-11-22T14:01:12.713754image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.05000000075 1526626
 
0.9%
0 1454900
 
0.9%
0.0700000003 1332891
 
0.8%
0.07999999821 1197489
 
0.7%
0.03999999911 1172154
 
0.7%
0.05999999866 1164464
 
0.7%
0.02999999933 1146396
 
0.7%
-0.5699999928 1136697
 
0.7%
-0.150000006 1116555
 
0.7%
-0.5799999833 1107997
 
0.7%
Other values (6996) 154995006
92.6%
ValueCountFrequency (%)
-78.58999634 1
 
< 0.1%
-78.51999664 16
< 0.1%
-78.44000244 9
< 0.1%
-78.30000305 1
 
< 0.1%
-76.95999908 1
 
< 0.1%
ValueCountFrequency (%)
78.44999695 2
< 0.1%
70.66000366 1
< 0.1%
67.23999786 1
< 0.1%
63.81000137 1
< 0.1%
62.27999878 1
< 0.1%

z
Real number (ℝ)

z axis value at the time of capture

Distinct7852
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.060806321
Minimum-81.25
Maximum118.5999985
Zeros79255
Zeros (%)< 0.1%
Negative25156872
Negative (%)15.0%
Memory size2.5 GiB
2024-11-22T14:01:12.838197image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum-81.25
5-th percentile-8.050000191
Q14.070000172
median9.039999962
Q39.840000153
95-th percentile9.970000267
Maximum118.5999985
Range199.8499985
Interquartile range (IQR)5.769999981

Descriptive statistics

Standard deviation5.560498552
Coefficient of variation (CV)0.9174519457
Kurtosis1.398594544
Mean6.060806321
Median Absolute Deviation (MAD)0.8999996185
Skewness-1.531232916
Sum1014283059
Variance30.91914415
MonotonicityNot monotonic
2024-11-22T14:01:12.964679image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
9.869999886 4904397
 
2.9%
9.859999657 4424160
 
2.6%
9.880000114 3927983
 
2.3%
9.850000381 3503982
 
2.1%
9.840000153 3021408
 
1.8%
9.890000343 2565533
 
1.5%
9.93999958 2072028
 
1.2%
9.819999695 2003226
 
1.2%
9.800000191 1952152
 
1.2%
9.829999924 1925258
 
1.2%
Other values (7842) 137051048
81.9%
ValueCountFrequency (%)
-81.25 1
 
< 0.1%
-78.44000244 22
< 0.1%
-77.33000183 1
 
< 0.1%
-75.41000366 1
 
< 0.1%
-74.87000275 1
 
< 0.1%
ValueCountFrequency (%)
118.5999985 1
< 0.1%
115.2099991 1
< 0.1%
110.3099976 1
< 0.1%
109.8099976 1
< 0.1%
104.8799973 1
< 0.1%

Correlations

2024-11-22T14:01:13.046385image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
useridxyz
userid1.0000.0430.0050.109
x0.0431.000-0.060-0.106
y0.005-0.0601.000-0.312
z0.109-0.106-0.3121.000