Overview

Dataset statistics

Number of variables6
Number of observations108421093
Missing cells0
Missing cells (%)0.0%
Total size in memory6.9 GiB
Average record size in memory68.0 B

Variable types

Text1
Numeric4
DateTime1

Dataset

Description[rad/s] Rate of rotation around the x,y,z axis. 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 9354142 (8.6%) zerosZeros
x has 75881678 (70.0%) zerosZeros
y has 76303779 (70.4%) zerosZeros
z has 78602368 (72.5%) zerosZeros

Reproduction

Analysis started2024-11-23 01:54:01.192810
Analysis finished2024-11-23 02:04:54.524883
Duration10 minutes and 53.33 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 size2.8 GiB
2024-11-23T03:04:54.586851image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

Total characters1301053116
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 108421093
100.0%
2024-11-23T03:04:54.769794image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 325263279
25.0%
n 216842186
16.7%
w 108421093
 
8.3%
t 108421093
 
8.3%
D 108421093
 
8.3%
m 108421093
 
8.3%
a 108421093
 
8.3%
r 108421093
 
8.3%
k 108421093
 
8.3%

Most occurring categories

ValueCountFrequency (%)
(unknown) 1301053116
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
e 325263279
25.0%
n 216842186
16.7%
w 108421093
 
8.3%
t 108421093
 
8.3%
D 108421093
 
8.3%
m 108421093
 
8.3%
a 108421093
 
8.3%
r 108421093
 
8.3%
k 108421093
 
8.3%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 1301053116
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
e 325263279
25.0%
n 216842186
16.7%
w 108421093
 
8.3%
t 108421093
 
8.3%
D 108421093
 
8.3%
m 108421093
 
8.3%
a 108421093
 
8.3%
r 108421093
 
8.3%
k 108421093
 
8.3%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 1301053116
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
e 325263279
25.0%
n 216842186
16.7%
w 108421093
 
8.3%
t 108421093
 
8.3%
D 108421093
 
8.3%
m 108421093
 
8.3%
a 108421093
 
8.3%
r 108421093
 
8.3%
k 108421093
 
8.3%

userid
Real number (ℝ)

ZEROS 

User id

Distinct15
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13.87742938
Minimum0
Maximum27
Zeros9354142
Zeros (%)8.6%
Negative0
Negative (%)0.0%
Memory size1.6 GiB
2024-11-23T03:04:54.878800image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q13
median17
Q323
95-th percentile27
Maximum27
Range27
Interquartile range (IQR)20

Descriptive statistics

Standard deviation9.290748348
Coefficient of variation (CV)0.6694862641
Kurtosis-1.543789326
Mean13.87742938
Median Absolute Deviation (MAD)6
Skewness-0.257550337
Sum1504606061
Variance86.31800486
MonotonicityIncreasing
2024-11-23T03:04:54.973744image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
23 21641746
20.0%
17 21410130
19.7%
2 12939143
11.9%
6 11421033
10.5%
0 9354142
8.6%
3 7532898
 
6.9%
21 6847903
 
6.3%
27 6619627
 
6.1%
20 4440627
 
4.1%
25 3065078
 
2.8%
Other values (5) 3148766
 
2.9%
ValueCountFrequency (%)
0 9354142
8.6%
2 12939143
11.9%
3 7532898
6.9%
6 11421033
10.5%
8 1806507
 
1.7%
ValueCountFrequency (%)
27 6619627
 
6.1%
25 3065078
 
2.8%
23 21641746
20.0%
22 278070
 
0.3%
21 6847903
 
6.3%

timestamp
Date

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

Distinct106086667
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Memory size1.6 GiB
Minimum2020-11-16 07:00:00.018000
Maximum2020-12-11 21:59:59.985000
2024-11-23T03:04:55.091656image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-11-23T03:04:55.212894image/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

Distinct3462
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.442907558 × 10-6
Minimum-0.3027999997
Maximum0.3037
Zeros75881678
Zeros (%)70.0%
Negative16171916
Negative (%)14.9%
Memory size1.6 GiB
2024-11-23T03:04:55.333148image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum-0.3027999997
5-th percentile-0.002000000095
Q10
median0
Q30
95-th percentile0.002099999925
Maximum0.3037
Range0.6064999998
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.00328315195
Coefficient of variation (CV)953.5986358
Kurtosis201.0414408
Mean3.442907558 × 10-6
Median Absolute Deviation (MAD)0
Skewness0.03128269038
Sum373.2838005
Variance1.077908673 × 10-5
MonotonicityNot monotonic
2024-11-23T03:04:55.457520image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 75881678
70.0%
-9.999999747 × 10-52440192
 
2.3%
9.999999747 × 10-52406558
 
2.2%
-0.0001999999949 1542606
 
1.4%
0.0001999999949 1528500
 
1.4%
-0.0003000000142 1034571
 
1.0%
0.0003000000142 1031760
 
1.0%
0.0003999999899 798319
 
0.7%
-0.0003999999899 795993
 
0.7%
0.0005000000237 675970
 
0.6%
Other values (3452) 20284946
 
18.7%
ValueCountFrequency (%)
-0.3027999997 1
< 0.1%
-0.2725000083 1
< 0.1%
-0.2684000134 1
< 0.1%
-0.2655000091 1
< 0.1%
-0.2632000148 1
< 0.1%
ValueCountFrequency (%)
0.3037 1
< 0.1%
0.2790000141 1
< 0.1%
0.277399987 1
< 0.1%
0.2772000134 1
< 0.1%
0.2714999914 1
< 0.1%

y
Real number (ℝ)

ZEROS 

y axis value at the time of capture

Distinct3339
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.825363727 × 10-6
Minimum-0.3488999903
Maximum0.3490000069
Zeros76303779
Zeros (%)70.4%
Negative16027443
Negative (%)14.8%
Memory size1.6 GiB
2024-11-23T03:04:55.575044image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum-0.3488999903
5-th percentile-0.002400000114
Q10
median0
Q30
95-th percentile0.002499999944
Maximum0.3490000069
Range0.6978999972
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.003701508774
Coefficient of variation (CV)635.4124734
Kurtosis150.0955789
Mean5.825363727 × 10-6
Median Absolute Deviation (MAD)0
Skewness-0.1215814397
Sum631.5923024
Variance1.37011672 × 10-5
MonotonicityNot monotonic
2024-11-23T03:04:55.694091image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 76303779
70.4%
-9.999999747 × 10-52266329
 
2.1%
9.999999747 × 10-52229936
 
2.1%
-0.0001999999949 1385854
 
1.3%
0.0001999999949 1377305
 
1.3%
-0.0003000000142 944229
 
0.9%
0.0003000000142 932010
 
0.9%
-0.0003999999899 732698
 
0.7%
0.0003999999899 726122
 
0.7%
-0.0005000000237 619271
 
0.6%
Other values (3329) 20903560
 
19.3%
ValueCountFrequency (%)
-0.3488999903 2
< 0.1%
-0.2786999941 1
< 0.1%
-0.2707999945 1
< 0.1%
-0.2682000101 1
< 0.1%
-0.2601999938 1
< 0.1%
ValueCountFrequency (%)
0.3490000069 2
< 0.1%
0.3224999905 1
< 0.1%
0.2985999882 1
< 0.1%
0.2910999954 1
< 0.1%
0.2822000086 1
< 0.1%

z
Real number (ℝ)

ZEROS 

z axis value at the time of capture

Distinct3328
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-2.423912117 × 10-6
Minimum-0.3167000115
Maximum0.3490000069
Zeros78602368
Zeros (%)72.5%
Negative14897132
Negative (%)13.7%
Memory size1.6 GiB
2024-11-23T03:04:55.812136image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum-0.3167000115
5-th percentile-0.001500000013
Q10
median0
Q30
95-th percentile0.001500000013
Maximum0.3490000069
Range0.6657000184
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.002756787348
Coefficient of variation (CV)-1137.329744
Kurtosis344.9410056
Mean-2.423912117 × 10-6
Median Absolute Deviation (MAD)0
Skewness-0.1515982264
Sum-262.803201
Variance7.599876482 × 10-6
MonotonicityNot monotonic
2024-11-23T03:04:55.930720image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 78602368
72.5%
-9.999999747 × 10-52581165
 
2.4%
9.999999747 × 10-52499187
 
2.3%
-0.0001999999949 1505914
 
1.4%
0.0001999999949 1493572
 
1.4%
0.0003000000142 989336
 
0.9%
-0.0003000000142 982484
 
0.9%
0.0003999999899 752963
 
0.7%
-0.0003999999899 742760
 
0.7%
0.0005000000237 632421
 
0.6%
Other values (3318) 17638923
 
16.3%
ValueCountFrequency (%)
-0.3167000115 1
< 0.1%
-0.3136999905 1
< 0.1%
-0.3027999997 1
< 0.1%
-0.295599997 1
< 0.1%
-0.2899000049 1
< 0.1%
ValueCountFrequency (%)
0.3490000069 1
< 0.1%
0.3082999885 1
< 0.1%
0.2574999928 1
< 0.1%
0.2527999878 1
< 0.1%
0.2504999936 1
< 0.1%

Correlations

2024-11-23T03:04:56.008404image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
useridxyz
userid1.000-0.0030.0020.005
x-0.0031.0000.0140.000
y0.0020.0141.0000.041
z0.0050.0000.0411.000