Overview

Dataset statistics

Number of variables6
Number of observations213038658
Missing cells0
Missing cells (%)0.0%
Total size in memory13.5 GiB
Average record size in memory68.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 "wenetDenmark"Constant
userid has 15124243 (7.1%) zerosZeros
x has 4136283 (1.9%) zerosZeros
y has 3297256 (1.5%) zerosZeros

Reproduction

Analysis started2024-11-23 02:09:35.288630
Analysis finished2024-11-23 02:30:14.182478
Duration20 minutes and 38.89 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 size5.6 GiB
2024-11-23T03:30:14.251613image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

Total characters2556463896
Distinct characters9
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 rowwenetDenmark
2nd rowwenetDenmark
3rd rowwenetDenmark
4th rowwenetDenmark
5th rowwenetDenmark
ValueCountFrequency (%)
wenetdenmark 213038658
100.0%
2024-11-23T03:30:14.434324image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 639115974
25.0%
n 426077316
16.7%
w 213038658
 
8.3%
t 213038658
 
8.3%
D 213038658
 
8.3%
m 213038658
 
8.3%
a 213038658
 
8.3%
r 213038658
 
8.3%
k 213038658
 
8.3%

Most occurring categories

ValueCountFrequency (%)
(unknown) 2556463896
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
e 639115974
25.0%
n 426077316
16.7%
w 213038658
 
8.3%
t 213038658
 
8.3%
D 213038658
 
8.3%
m 213038658
 
8.3%
a 213038658
 
8.3%
r 213038658
 
8.3%
k 213038658
 
8.3%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 2556463896
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
e 639115974
25.0%
n 426077316
16.7%
w 213038658
 
8.3%
t 213038658
 
8.3%
D 213038658
 
8.3%
m 213038658
 
8.3%
a 213038658
 
8.3%
r 213038658
 
8.3%
k 213038658
 
8.3%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 2556463896
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
e 639115974
25.0%
n 426077316
16.7%
w 213038658
 
8.3%
t 213038658
 
8.3%
D 213038658
 
8.3%
m 213038658
 
8.3%
a 213038658
 
8.3%
r 213038658
 
8.3%
k 213038658
 
8.3%

userid
Real number (ℝ)

ZEROS 

User id

Distinct17
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14.93924709
Minimum0
Maximum27
Zeros15124243
Zeros (%)7.1%
Negative0
Negative (%)0.0%
Memory size3.2 GiB
2024-11-23T03:30:14.539612image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q16
median17
Q323
95-th percentile26
Maximum27
Range27
Interquartile range (IQR)17

Descriptive statistics

Standard deviation8.763333968
Coefficient of variation (CV)0.5865981007
Kurtosis-1.185211743
Mean14.93924709
Median Absolute Deviation (MAD)6
Skewness-0.4727783856
Sum3182637151
Variance76.79602223
MonotonicityIncreasing
2024-11-23T03:30:14.637889image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
17 68087982
32.0%
23 29758103
14.0%
2 18830305
 
8.8%
6 17475318
 
8.2%
0 15124243
 
7.1%
26 14120160
 
6.6%
3 13728205
 
6.4%
21 12312754
 
5.8%
27 9511749
 
4.5%
20 5814293
 
2.7%
Other values (7) 8275546
 
3.9%
ValueCountFrequency (%)
0 15124243
7.1%
2 18830305
8.8%
3 13728205
6.4%
6 17475318
8.2%
8 1878740
 
0.9%
ValueCountFrequency (%)
27 9511749
 
4.5%
26 14120160
6.6%
25 4222676
 
2.0%
23 29758103
14.0%
22 335605
 
0.2%

timestamp
Date

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

Distinct204221119
Distinct (%)95.9%
Missing0
Missing (%)0.0%
Memory size3.2 GiB
Minimum2020-11-16 07:00:00.029000
Maximum2020-12-11 21:59:59.996000
2024-11-23T03:30:14.746656image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-11-23T03:30:14.870126image/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

Distinct14507
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.2493298669
Minimum-156.5500031
Maximum138.9600067
Zeros4136283
Zeros (%)1.9%
Negative112686651
Negative (%)52.9%
Memory size3.2 GiB
2024-11-23T03:30:14.984250image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum-156.5500031
5-th percentile-4.579999924
Q1-0.5699999928
median-0.03999999911
Q30.5500000119
95-th percentile7.199999809
Maximum138.9600067
Range295.5100098
Interquartile range (IQR)1.120000005

Descriptive statistics

Standard deviation3.244786238
Coefficient of variation (CV)13.01402948
Kurtosis17.84822713
Mean0.2493298669
Median Absolute Deviation (MAD)0.5499999896
Skewness0.9348410488
Sum53116900.24
Variance10.52863773
MonotonicityNot monotonic
2024-11-23T03:30:15.111115image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 4136283
 
1.9%
-0.1199999973 2924108
 
1.4%
-0.1299999952 2536125
 
1.2%
0.07999999821 2475462
 
1.2%
-0.05000000075 2426520
 
1.1%
-0.1099999994 2307607
 
1.1%
0.09000000358 2274529
 
1.1%
-0.03999999911 2127019
 
1.0%
-0.05999999866 2036377
 
1.0%
-0.09000000358 1955026
 
0.9%
Other values (14497) 187839602
88.2%
ValueCountFrequency (%)
-156.5500031 1
< 0.1%
-153.4199982 1
< 0.1%
-136.75 1
< 0.1%
-133.4600067 1
< 0.1%
-126 1
< 0.1%
ValueCountFrequency (%)
138.9600067 1
< 0.1%
118.2399979 1
< 0.1%
113.5599976 1
< 0.1%
109.9000015 1
< 0.1%
95.93000031 1
< 0.1%

y
Real number (ℝ)

ZEROS 

y axis value at the time of capture

Distinct11824
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.031691972
Minimum-153.0500031
Maximum107.1399994
Zeros3297256
Zeros (%)1.5%
Negative79336197
Negative (%)37.2%
Memory size3.2 GiB
2024-11-23T03:30:15.231160image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum-153.0500031
5-th percentile-9.399999619
Q1-0.3000000119
median0.1899999976
Q34.460000038
95-th percentile9.220000267
Maximum107.1399994
Range260.1900024
Interquartile range (IQR)4.76000005

Descriptive statistics

Standard deviation5.111111202
Coefficient of variation (CV)4.954105817
Kurtosis1.059276856
Mean1.031691972
Median Absolute Deviation (MAD)1.219999969
Skewness-0.3964019832
Sum219790273.3
Variance26.12345772
MonotonicityNot monotonic
2024-11-23T03:30:15.354516image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 3297256
 
1.5%
-0.05000000075 1954461
 
0.9%
0.1599999964 1724341
 
0.8%
0.1899999976 1676223
 
0.8%
-0.03999999911 1628223
 
0.8%
0.1800000072 1567061
 
0.7%
0.200000003 1560010
 
0.7%
-0.02999999933 1553194
 
0.7%
0.2199999988 1510775
 
0.7%
0.1400000006 1504933
 
0.7%
Other values (11814) 195062181
91.6%
ValueCountFrequency (%)
-153.0500031 1
< 0.1%
-94.87999725 1
< 0.1%
-94.83999634 1
< 0.1%
-91.44999695 1
< 0.1%
-82.08999634 1
< 0.1%
ValueCountFrequency (%)
107.1399994 1
< 0.1%
102.8000031 1
< 0.1%
86.09999847 1
< 0.1%
83.77999878 1
< 0.1%
78.40000153 1
< 0.1%

z
Real number (ℝ)

z axis value at the time of capture

Distinct11151
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.580780846
Minimum-136.5500031
Maximum156.4100037
Zeros175422
Zeros (%)0.1%
Negative38100798
Negative (%)17.9%
Memory size3.2 GiB
2024-11-23T03:30:15.469705image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum-136.5500031
5-th percentile-6.559999943
Q12.119999886
median8.659999847
Q39.729999542
95-th percentile9.960000038
Maximum156.4100037
Range292.9600067
Interquartile range (IQR)7.609999657

Descriptive statistics

Standard deviation5.572527365
Coefficient of variation (CV)0.9985210886
Kurtosis1.025922729
Mean5.580780846
Median Absolute Deviation (MAD)1.289999962
Skewness-1.240144049
Sum1188922062
Variance31.05306124
MonotonicityNot monotonic
2024-11-23T03:30:15.605385image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
9.949999809 5481254
 
2.6%
9.93999958 4143627
 
1.9%
9.930000305 3254494
 
1.5%
9.850000381 3067845
 
1.4%
9.920000076 2689061
 
1.3%
9.609999657 2624740
 
1.2%
9.619999886 2468651
 
1.2%
9.630000114 2416246
 
1.1%
9.859999657 2376079
 
1.1%
9.56000042 2286186
 
1.1%
Other values (11141) 182230475
85.5%
ValueCountFrequency (%)
-136.5500031 1
< 0.1%
-133.2799988 1
< 0.1%
-118.1200027 1
< 0.1%
-111.5400009 1
< 0.1%
-111.3099976 1
< 0.1%
ValueCountFrequency (%)
156.4100037 1
< 0.1%
154.1199951 1
< 0.1%
154.0599976 1
< 0.1%
152.4100037 1
< 0.1%
149.6199951 1
< 0.1%

Correlations

2024-11-23T03:30:15.684368image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
useridxyz
userid1.0000.043-0.0050.196
x0.0431.000-0.035-0.070
y-0.005-0.0351.000-0.107
z0.196-0.070-0.1071.000