Overview

Dataset statistics

Number of variables6
Number of observations76436946
Missing cells0
Missing cells (%)0.0%
Total size in memory4.7 GiB
Average record size in memory66.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 "wenetIndia"Constant
userid has 11460218 (15.0%) zerosZeros
x has 49162870 (64.3%) zerosZeros
y has 49191835 (64.4%) zerosZeros
z has 50783970 (66.4%) zerosZeros

Reproduction

Analysis started2024-11-22 12:34:24.369149
Analysis finished2024-11-22 12:41:52.743006
Duration7 minutes and 28.37 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 size1.9 GiB
2024-11-22T13:41:52.797413image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

Total characters764369460
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 76436946
100.0%
2024-11-22T13:41:52.971867image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 152873892
20.0%
n 152873892
20.0%
w 76436946
10.0%
t 76436946
10.0%
I 76436946
10.0%
d 76436946
10.0%
i 76436946
10.0%
a 76436946
10.0%

Most occurring categories

ValueCountFrequency (%)
(unknown) 764369460
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
e 152873892
20.0%
n 152873892
20.0%
w 76436946
10.0%
t 76436946
10.0%
I 76436946
10.0%
d 76436946
10.0%
i 76436946
10.0%
a 76436946
10.0%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 764369460
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
e 152873892
20.0%
n 152873892
20.0%
w 76436946
10.0%
t 76436946
10.0%
I 76436946
10.0%
d 76436946
10.0%
i 76436946
10.0%
a 76436946
10.0%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 764369460
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
e 152873892
20.0%
n 152873892
20.0%
w 76436946
10.0%
t 76436946
10.0%
I 76436946
10.0%
d 76436946
10.0%
i 76436946
10.0%
a 76436946
10.0%

userid
Real number (ℝ)

ZEROS 

User id

Distinct18
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21.87446773
Minimum0
Maximum62
Zeros11460218
Zeros (%)15.0%
Negative0
Negative (%)0.0%
Memory size1.1 GiB
2024-11-22T13:41:53.072073image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation17.10338149
Coefficient of variation (CV)0.7818878932
Kurtosis-1.214616587
Mean21.87446773
Median Absolute Deviation (MAD)17
Skewness0.370047267
Sum1672017509
Variance292.5256585
MonotonicityIncreasing
2024-11-22T13:41:53.163115image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
0 11460218
15.0%
9 10099272
13.2%
12 9469292
12.4%
44 9286511
12.1%
35 8565340
11.2%
17 7855440
10.3%
43 7855204
10.3%
8 3107006
 
4.1%
4 1961076
 
2.6%
26 1737094
 
2.3%
Other values (8) 5040493
6.6%
ValueCountFrequency (%)
0 11460218
15.0%
4 1961076
 
2.6%
8 3107006
 
4.1%
9 10099272
13.2%
12 9469292
12.4%
ValueCountFrequency (%)
62 661731
 
0.9%
57 1673564
 
2.2%
46 40306
 
0.1%
44 9286511
12.1%
43 7855204
10.3%

timestamp
Date

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

Distinct75206053
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Memory size1.1 GiB
Minimum2021-07-12 08:00:00.016000
Maximum2021-08-12 14:41:49.195000
2024-11-22T13:41:53.270780image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-11-22T13:41:53.395760image/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

Distinct2272
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.870042845 × 10-6
Minimum-0.2930999994
Maximum0.2558999956
Zeros49162870
Zeros (%)64.3%
Negative13629804
Negative (%)17.8%
Memory size1.1 GiB
2024-11-22T13:41:53.509589image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum-0.2930999994
5-th percentile-0.001099999994
Q10
median0
Q30
95-th percentile0.001300000004
Maximum0.2558999956
Range0.548999995
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.002558814211
Coefficient of variation (CV)525.4192402
Kurtosis201.9567955
Mean4.870042845 × 10-6
Median Absolute Deviation (MAD)0
Skewness0.037559069
Sum372.2512019
Variance6.547530167 × 10-6
MonotonicityNot monotonic
2024-11-22T13:41:53.622097image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 49162870
64.3%
-9.999999747 × 10-53101208
 
4.1%
9.999999747 × 10-52989258
 
3.9%
-0.0001999999949 1792451
 
2.3%
0.0001999999949 1725813
 
2.3%
-0.0003000000142 1191161
 
1.6%
0.0003000000142 1157346
 
1.5%
-0.0003999999899 863304
 
1.1%
0.0003999999899 845600
 
1.1%
-0.0005000000237 673523
 
0.9%
Other values (2262) 12934412
 
16.9%
ValueCountFrequency (%)
-0.2930999994 1
< 0.1%
-0.2588 1
< 0.1%
-0.2224999964 2
< 0.1%
-0.1921000034 1
< 0.1%
-0.1906999946 1
< 0.1%
ValueCountFrequency (%)
0.2558999956 2
< 0.1%
0.199000001 1
< 0.1%
0.1970999986 1
< 0.1%
0.1879999936 1
< 0.1%
0.1832000017 1
< 0.1%

y
Real number (ℝ)

ZEROS 

y axis value at the time of capture

Distinct2611
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-1.218571732 × 10-6
Minimum-0.2921000123
Maximum0.2603000104
Zeros49191835
Zeros (%)64.4%
Negative13616806
Negative (%)17.8%
Memory size1.1 GiB
2024-11-22T13:41:53.730335image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum-0.2921000123
5-th percentile-0.001300000004
Q10
median0
Q30
95-th percentile0.001300000004
Maximum0.2603000104
Range0.5524000227
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.002879720987
Coefficient of variation (CV)-2363.193656
Kurtosis204.1769811
Mean-1.218571732 × 10-6
Median Absolute Deviation (MAD)0
Skewness-0.2264380132
Sum-93.14390169
Variance8.29279296 × 10-6
MonotonicityNot monotonic
2024-11-22T13:41:53.843527image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 49191835
64.4%
9.999999747 × 10-52907435
 
3.8%
-9.999999747 × 10-52889343
 
3.8%
0.0001999999949 1670803
 
2.2%
-0.0001999999949 1667328
 
2.2%
-0.0003000000142 1139291
 
1.5%
0.0003000000142 1136683
 
1.5%
-0.0003999999899 847101
 
1.1%
0.0003999999899 841532
 
1.1%
-0.0005000000237 668276
 
0.9%
Other values (2601) 13477319
 
17.6%
ValueCountFrequency (%)
-0.2921000123 1
< 0.1%
-0.2836999893 1
< 0.1%
-0.2815000117 2
< 0.1%
-0.277700007 1
< 0.1%
-0.2669999897 1
< 0.1%
ValueCountFrequency (%)
0.2603000104 2
< 0.1%
0.2422000021 1
< 0.1%
0.2294999957 1
< 0.1%
0.229399994 2
< 0.1%
0.2169999927 1
< 0.1%

z
Real number (ℝ)

ZEROS 

z axis value at the time of capture

Distinct2344
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-2.169729544 × 10-6
Minimum-0.2161999941
Maximum0.2138999999
Zeros50783970
Zeros (%)66.4%
Negative12644367
Negative (%)16.5%
Memory size1.1 GiB
2024-11-22T13:41:53.961225image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum-0.2161999941
5-th percentile-0.001000000047
Q10
median0
Q30
95-th percentile0.001000000047
Maximum0.2138999999
Range0.4300999939
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.002370012992
Coefficient of variation (CV)-1092.308025
Kurtosis222.8793819
Mean-2.169729544 × 10-6
Median Absolute Deviation (MAD)0
Skewness-0.5664450999
Sum-165.8475
Variance5.616961583 × 10-6
MonotonicityNot monotonic
2024-11-22T13:41:54.081091image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 50783970
66.4%
9.999999747 × 10-52951383
 
3.9%
-9.999999747 × 10-52797322
 
3.7%
0.0001999999949 1707503
 
2.2%
-0.0001999999949 1640827
 
2.1%
0.0003000000142 1166789
 
1.5%
-0.0003000000142 1130247
 
1.5%
0.0003999999899 871350
 
1.1%
-0.0003999999899 851448
 
1.1%
0.0005000000237 690797
 
0.9%
Other values (2334) 11845310
 
15.5%
ValueCountFrequency (%)
-0.2161999941 1
< 0.1%
-0.2018000036 1
< 0.1%
-0.2011000067 1
< 0.1%
-0.1923000067 2
< 0.1%
-0.1919 2
< 0.1%
ValueCountFrequency (%)
0.2138999999 1
< 0.1%
0.2106000036 1
< 0.1%
0.1919 2
< 0.1%
0.191200003 1
< 0.1%
0.1905000061 1
< 0.1%

Correlations

2024-11-22T13:41:54.148851image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
useridxyz
userid1.000-0.0110.001-0.004
x-0.0111.0000.0470.038
y0.0010.0471.0000.062
z-0.0040.0380.0621.000