Overview

Dataset statistics

Number of variables4
Number of observations35997678
Missing cells0
Missing cells (%)0.0%
Total size in memory1.7 GiB
Average record size in memory52.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 "wenetDenmark"Constant
userid has 15115531 (42.0%) zerosZeros

Reproduction

Analysis started2024-11-23 02:37:37.987232
Analysis finished2024-11-23 02:39:54.356228
Duration2 minutes and 16.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 size961.2 MiB
2024-11-23T03:39:54.430439image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

Total characters431972136
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 35997678
100.0%
2024-11-23T03:39:54.611427image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 107993034
25.0%
n 71995356
16.7%
w 35997678
 
8.3%
t 35997678
 
8.3%
D 35997678
 
8.3%
m 35997678
 
8.3%
a 35997678
 
8.3%
r 35997678
 
8.3%
k 35997678
 
8.3%

Most occurring categories

ValueCountFrequency (%)
(unknown) 431972136
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
e 107993034
25.0%
n 71995356
16.7%
w 35997678
 
8.3%
t 35997678
 
8.3%
D 35997678
 
8.3%
m 35997678
 
8.3%
a 35997678
 
8.3%
r 35997678
 
8.3%
k 35997678
 
8.3%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 431972136
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
e 107993034
25.0%
n 71995356
16.7%
w 35997678
 
8.3%
t 35997678
 
8.3%
D 35997678
 
8.3%
m 35997678
 
8.3%
a 35997678
 
8.3%
r 35997678
 
8.3%
k 35997678
 
8.3%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 431972136
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
e 107993034
25.0%
n 71995356
16.7%
w 35997678
 
8.3%
t 35997678
 
8.3%
D 35997678
 
8.3%
m 35997678
 
8.3%
a 35997678
 
8.3%
r 35997678
 
8.3%
k 35997678
 
8.3%

userid
Real number (ℝ)

ZEROS 

User id

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13.77862914
Minimum0
Maximum27
Zeros15115531
Zeros (%)42.0%
Negative0
Negative (%)0.0%
Memory size549.3 MiB
2024-11-23T03:39:54.708215image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median21
Q327
95-th percentile27
Maximum27
Range27
Interquartile range (IQR)27

Descriptive statistics

Standard deviation11.94188224
Coefficient of variation (CV)0.8666959622
Kurtosis-1.814013128
Mean13.77862914
Median Absolute Deviation (MAD)6
Skewness-0.2144284873
Sum495998655
Variance142.6085514
MonotonicityIncreasing
2024-11-23T03:39:54.788992image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=3)
ValueCountFrequency (%)
0 15115531
42.0%
21 11303219
31.4%
27 9578928
26.6%
ValueCountFrequency (%)
0 15115531
42.0%
21 11303219
31.4%
27 9578928
26.6%
ValueCountFrequency (%)
27 9578928
26.6%
21 11303219
31.4%
0 15115531
42.0%

timestamp
Date

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

Distinct35796649
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Memory size549.3 MiB
Minimum2020-11-16 07:00:00.018000
Maximum2020-12-11 21:59:59.952000
2024-11-23T03:39:54.907619image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-11-23T03:39:55.027575image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

value
Real number (ℝ)

The pressure value (hPa, milibar)

Distinct4014
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1013.646057
Minimum991.3099976
Maximum1031.640015
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size549.3 MiB
2024-11-23T03:39:55.143786image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum991.3099976
5-th percentile998.6599731
Q11007.630005
median1014.76001
Q31019.590027
95-th percentile1027.619995
Maximum1031.640015
Range40.33001709
Interquartile range (IQR)11.96002197

Descriptive statistics

Standard deviation8.683067624
Coefficient of variation (CV)0.008566173137
Kurtosis-0.5318557913
Mean1013.646057
Median Absolute Deviation (MAD)6.059997559
Skewness-0.3161934045
Sum3.648890437 × 1010
Variance75.39566336
MonotonicityNot monotonic
2024-11-23T03:39:55.270974image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1014.130005 38992
 
0.1%
1014.119995 38072
 
0.1%
1014.140015 35685
 
0.1%
1014.109985 35380
 
0.1%
1017.25 34497
 
0.1%
1017.23999 34009
 
0.1%
1014.099976 33638
 
0.1%
1015.349976 32716
 
0.1%
1014.150024 32513
 
0.1%
1015.359985 32243
 
0.1%
Other values (4004) 35649933
99.0%
ValueCountFrequency (%)
991.3099976 10
 
< 0.1%
991.3200073 14
 
< 0.1%
991.3300171 31
< 0.1%
991.3400269 24
 
< 0.1%
991.3499756 70
< 0.1%
ValueCountFrequency (%)
1031.640015 1
< 0.1%
1031.630005 1
< 0.1%
1031.619995 1
< 0.1%
1031.48999 1
< 0.1%
1031.430054 1
< 0.1%

Correlations

2024-11-23T03:39:55.349092image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
useridvalue
userid1.0000.380
value0.3801.000