Overview

Brought to you by YData

Dataset statistics

Number of variables6
Number of observations161861731
Missing cells0
Missing cells (%)0.0%
Total size in memory10.0 GiB
Average record size in memory66.1 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. NOTE: The dataset was sampled to fit into available memory. Results may not reflect the entire dataset.
Creatorname
Authorname
URL
Copyright(c) liveme organization 2024

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 "wenetItaly" Constant
x has 110500526 (68.3%) zeros Zeros
y has 110553284 (68.3%) zeros Zeros
z has 113571225 (70.2%) zeros Zeros

Reproduction

Analysis started2025-04-10 14:09:41.334867
Analysis finished2025-04-10 14:35:17.557960
Duration25 minutes and 36.22 seconds
Software versionydata-profiling v0.0.dev0
Download configurationconfig.json

Variables

experimentid
Text

Constant 

Experiment Id

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.9 GiB
2025-04-10T16:35:17.751773image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

Total characters1618617310
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 rowwenetItaly
2nd rowwenetItaly
3rd rowwenetItaly
4th rowwenetItaly
5th rowwenetItaly
ValueCountFrequency (%)
wenetitaly 161861731
100.0%
2025-04-10T16:35:18.397624image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 323723462
20.0%
t 323723462
20.0%
w 161861731
10.0%
n 161861731
10.0%
I 161861731
10.0%
a 161861731
10.0%
l 161861731
10.0%
y 161861731
10.0%

Most occurring categories

ValueCountFrequency (%)
(unknown) 1618617310
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
e 323723462
20.0%
t 323723462
20.0%
w 161861731
10.0%
n 161861731
10.0%
I 161861731
10.0%
a 161861731
10.0%
l 161861731
10.0%
y 161861731
10.0%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 1618617310
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
e 323723462
20.0%
t 323723462
20.0%
w 161861731
10.0%
n 161861731
10.0%
I 161861731
10.0%
a 161861731
10.0%
l 161861731
10.0%
y 161861731
10.0%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 1618617310
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
e 323723462
20.0%
t 323723462
20.0%
w 161861731
10.0%
n 161861731
10.0%
I 161861731
10.0%
a 161861731
10.0%
l 161861731
10.0%
y 161861731
10.0%

userid
Real number (ℝ)

User id

Distinct196
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean130.369368
Minimum0
Maximum265
Zeros47600
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size2.4 GiB
2025-04-10T16:35:18.720385image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile6
Q158
median127
Q3204
95-th percentile255
Maximum265
Range265
Interquartile range (IQR)146

Descriptive statistics

Standard deviation82.10852656
Coefficient of variation (CV)0.6298145634
Kurtosis-1.345159731
Mean130.369368
Median Absolute Deviation (MAD)75
Skewness0.03098556339
Sum2.110181157 × 1010
Variance6741.810133
MonotonicityNot monotonic
2025-04-10T16:35:19.079099image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
255 4331352
 
2.7%
26 4305552
 
2.7%
217 4047563
 
2.5%
58 3908388
 
2.4%
190 3865164
 
2.4%
45 3686161
 
2.3%
5 3228030
 
2.0%
59 3189651
 
2.0%
97 3106710
 
1.9%
18 2800176
 
1.7%
Other values (186) 125392984
77.5%
ValueCountFrequency (%)
0 47600
 
< 0.1%
1 1396848
0.9%
2 545455
 
0.3%
3 71770
 
< 0.1%
4 2289118
1.4%
ValueCountFrequency (%)
265 579053
0.4%
264 11260
 
< 0.1%
263 1023570
0.6%
262 787459
0.5%
260 212252
 
0.1%

timestamp
Date

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

Distinct155828752
Distinct (%)96.3%
Missing0
Missing (%)0.0%
Memory size2.4 GiB
Minimum2020-11-16 07:00:00.028000
Maximum2020-12-11 21:59:59.983000
2025-04-10T16:35:19.424573image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/
2025-04-10T16:35:19.781441image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

x
Real number (ℝ)

Zeros 

x axis value at the time of capture

Distinct4700
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-2.367616726 × 10-5
Minimum-0.8895999789
Maximum0.6646000147
Zeros110500526
Zeros (%)68.3%
Negative27062796
Negative (%)16.7%
Memory size2.4 GiB
2025-04-10T16:35:20.128217image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/

Quantile statistics

Minimum-0.8895999789
5-th percentile-0.00159999996
Q10
median0
Q30
95-th percentile0.001500000013
Maximum0.6646000147
Range1.554199994
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.003213965518
Coefficient of variation (CV)-135.7468666
Kurtosis917.7892808
Mean-2.367616726 × 10-5
Median Absolute Deviation (MAD)0
Skewness-0.6650178764
Sum-3832.265417
Variance1.032957435 × 10-5
MonotonicityNot monotonic
2025-04-10T16:35:20.515659image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 110500526
68.3%
-9.999999747 × 10-54484374
 
2.8%
9.999999747 × 10-54298082
 
2.7%
-0.0001999999949 3041181
 
1.9%
-0.0003000000142 2620519
 
1.6%
0.0001999999949 2571046
 
1.6%
0.0003000000142 1721466
 
1.1%
-0.0003999999899 1422255
 
0.9%
0.0003999999899 1304229
 
0.8%
-0.0006000000285 1201828
 
0.7%
Other values (4690) 28696225
 
17.7%
ValueCountFrequency (%)
-0.8895999789 1
< 0.1%
-0.5551000237 1
< 0.1%
-0.4767999947 1
< 0.1%
-0.4144999981 1
< 0.1%
-0.3998999894 1
< 0.1%
ValueCountFrequency (%)
0.6646000147 1
< 0.1%
0.4602000117 1
< 0.1%
0.4447000027 1
< 0.1%
0.4171999991 1
< 0.1%
0.4007999897 1
< 0.1%

y
Real number (ℝ)

Zeros 

y axis value at the time of capture

Distinct5036
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-1.362253995 × 10-8
Minimum-0.7135999799
Maximum0.9218999743
Zeros110553284
Zeros (%)68.3%
Negative25210319
Negative (%)15.6%
Memory size2.4 GiB
2025-04-10T16:35:20.902160image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/

Quantile statistics

Minimum-0.7135999799
5-th percentile-0.001799999969
Q10
median0
Q30
95-th percentile0.001700000023
Maximum0.9218999743
Range1.635499954
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.003749070781
Coefficient of variation (CV)-275210.8487
Kurtosis732.4415798
Mean-1.362253995 × 10-8
Median Absolute Deviation (MAD)0
Skewness-0.002398713655
Sum-2.204967896
Variance1.405553172 × 10-5
MonotonicityNot monotonic
2025-04-10T16:35:21.278282image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 110553284
68.3%
9.999999747 × 10-54786306
 
3.0%
-9.999999747 × 10-54632839
 
2.9%
0.0001999999949 2567637
 
1.6%
-0.0001999999949 2521617
 
1.6%
0.0005000000237 1706938
 
1.1%
0.0003000000142 1695782
 
1.0%
-0.0003000000142 1664809
 
1.0%
0.0003999999899 1324887
 
0.8%
-0.0005000000237 1278436
 
0.8%
Other values (5026) 29129196
 
18.0%
ValueCountFrequency (%)
-0.7135999799 1
< 0.1%
-0.621900022 1
< 0.1%
-0.6100999713 1
< 0.1%
-0.5885999799 1
< 0.1%
-0.5558999777 1
< 0.1%
ValueCountFrequency (%)
0.9218999743 1
< 0.1%
0.8392999768 1
< 0.1%
0.8169999719 1
< 0.1%
0.7105000019 1
< 0.1%
0.7050999999 1
< 0.1%

z
Real number (ℝ)

Zeros 

z axis value at the time of capture

Distinct5085
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.594879726 × 10-6
Minimum-0.7329000235
Maximum0.9072999954
Zeros113571225
Zeros (%)70.2%
Negative22776296
Negative (%)14.1%
Memory size2.4 GiB
2025-04-10T16:35:21.635562image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/

Quantile statistics

Minimum-0.7329000235
5-th percentile-0.001099999994
Q10
median0
Q30
95-th percentile0.001099999994
Maximum0.9072999954
Range1.640200019
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.003114403418
Coefficient of variation (CV)1200.211088
Kurtosis1517.778467
Mean2.594879726 × 10-6
Median Absolute Deviation (MAD)0
Skewness-3.020042634
Sum420.0117241
Variance9.699508652 × 10-6
MonotonicityNot monotonic
2025-04-10T16:35:22.000697image/svg+xmlMatplotlib v3.9.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 113571225
70.2%
9.999999747 × 10-55136400
 
3.2%
-9.999999747 × 10-55029491
 
3.1%
0.0001999999949 2768111
 
1.7%
-0.0001999999949 2646996
 
1.6%
0.0003000000142 1846687
 
1.1%
-0.0003000000142 1678661
 
1.0%
0.0006000000285 1589555
 
1.0%
0.0005000000237 1411941
 
0.9%
0.0003999999899 1392989
 
0.9%
Other values (5075) 24789675
 
15.3%
ValueCountFrequency (%)
-0.7329000235 1
< 0.1%
-0.6711999774 1
< 0.1%
-0.6553000212 1
< 0.1%
-0.5825999975 1
< 0.1%
-0.581700027 1
< 0.1%
ValueCountFrequency (%)
0.9072999954 1
< 0.1%
0.681400001 1
< 0.1%
0.6079999804 1
< 0.1%
0.586499989 1
< 0.1%
0.5321999788 1
< 0.1%