Overview

Dataset statistics

Number of variables4
Number of observations494754315
Missing cells0
Missing cells (%)0.0%
Total size in memory23.0 GiB
Average record size in memory50.0 B

Variable types

Text1
Numeric2
DateTime1

Dataset

Description[hPa or mbar] Ambient air pressure. 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)
valueThe pressure value (hPa, milibar)

Alerts

experimentid has constant value "wenetItaly"Constant

Reproduction

Analysis started2024-11-23 12:40:54.254224
Analysis finished2024-11-23 13:17:45.806221
Duration36 minutes and 51.55 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 size12.0 GiB
2024-11-23T14:17:45.861754image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

Total characters4947543150
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 494754315
100.0%
2024-11-23T14:17:46.042251image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 989508630
20.0%
t 989508630
20.0%
w 494754315
10.0%
n 494754315
10.0%
I 494754315
10.0%
a 494754315
10.0%
l 494754315
10.0%
y 494754315
10.0%

Most occurring categories

ValueCountFrequency (%)
(unknown) 4947543150
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
e 989508630
20.0%
t 989508630
20.0%
w 494754315
10.0%
n 494754315
10.0%
I 494754315
10.0%
a 494754315
10.0%
l 494754315
10.0%
y 494754315
10.0%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 4947543150
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
e 989508630
20.0%
t 989508630
20.0%
w 494754315
10.0%
n 494754315
10.0%
I 494754315
10.0%
a 494754315
10.0%
l 494754315
10.0%
y 494754315
10.0%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 4947543150
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
e 989508630
20.0%
t 989508630
20.0%
w 494754315
10.0%
n 494754315
10.0%
I 494754315
10.0%
a 494754315
10.0%
l 494754315
10.0%
y 494754315
10.0%

userid
Real number (ℝ)

User id

Distinct39
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean143.6510543
Minimum2
Maximum263
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.4 GiB
2024-11-23T14:17:46.160499image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile19
Q175
median135
Q3217
95-th percentile262
Maximum263
Range261
Interquartile range (IQR)142

Descriptive statistics

Standard deviation83.81642335
Coefficient of variation (CV)0.5834723854
Kurtosis-1.417076526
Mean143.6510543
Median Absolute Deviation (MAD)81
Skewness-0.1943775319
Sum7.107197899 × 1010
Variance7025.192823
MonotonicityIncreasing
2024-11-23T14:17:46.299567image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=39)
ValueCountFrequency (%)
78 21514761
 
4.3%
131 21198765
 
4.3%
103 20576077
 
4.2%
221 20366848
 
4.1%
75 20329856
 
4.1%
32 19308871
 
3.9%
19 17426774
 
3.5%
213 17333439
 
3.5%
217 17113931
 
3.5%
247 16684034
 
3.4%
Other values (29) 302900959
61.2%
ValueCountFrequency (%)
2 10935228
2.2%
8 9600710
1.9%
19 17426774
3.5%
20 16039442
3.2%
27 12169622
2.5%
ValueCountFrequency (%)
263 15975236
3.2%
262 14189718
2.9%
249 15590868
3.2%
247 16684034
3.4%
238 5364594
 
1.1%

timestamp
Date

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

Distinct442568398
Distinct (%)89.5%
Missing0
Missing (%)0.0%
Memory size7.4 GiB
Minimum2020-11-16 07:00:00.003000
Maximum2020-12-11 22:00:00
2024-11-23T14:17:46.423406image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-11-23T14:17:46.554762image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

value
Real number (ℝ)

The pressure value (hPa, milibar)

Distinct26313
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean987.1343285
Minimum774.9000244
Maximum1059.930054
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.4 GiB
2024-11-23T14:17:46.668391image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum774.9000244
5-th percentile922.7199707
Q1973.75
median996
Q31008.340027
95-th percentile1024.079956
Maximum1059.930054
Range285.0300293
Interquartile range (IQR)34.59002686

Descriptive statistics

Standard deviation31.22084173
Coefficient of variation (CV)0.03162775402
Kurtosis1.608612395
Mean987.1343285
Median Absolute Deviation (MAD)16.40997314
Skewness-1.222272583
Sum4.883889685 × 1011
Variance974.7409582
MonotonicityNot monotonic
2024-11-23T14:17:46.785197image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
998.9899902 142939
 
< 0.1%
999.0700073 142249
 
< 0.1%
999.210022 142080
 
< 0.1%
999 141494
 
< 0.1%
999.1900024 141219
 
< 0.1%
999.2299805 140654
 
< 0.1%
998.9799805 140311
 
< 0.1%
999.2199707 140228
 
< 0.1%
999.0599976 139631
 
< 0.1%
999.2399902 139612
 
< 0.1%
Other values (26303) 493343898
99.7%
ValueCountFrequency (%)
774.9000244 33
 
< 0.1%
774.9099731 7
 
< 0.1%
774.9199829 82
< 0.1%
774.9299927 66
< 0.1%
774.9400024 91
< 0.1%
ValueCountFrequency (%)
1059.930054 1
< 0.1%
1058.920044 1
< 0.1%
1056.130005 1
< 0.1%
1054.900024 1
< 0.1%
1054.51001 1
< 0.1%

Correlations

2024-11-23T14:17:46.859514image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
useridvalue
userid1.0000.115
value0.1151.000