Overview

Dataset statistics

Number of variables5
Number of observations3171490
Missing cells0
Missing cells (%)0.0%
Total size in memory175.4 MiB
Average record size in memory58.0 B

Variable types

Text1
Numeric3
DateTime1

Dataset

Description[%] Returns whether the phone is on charge and the type of charger. 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)
levelNumeric value of the charge level of the battery
scaleScale of the battery

Alerts

experimentid has constant value "wenetItaly"Constant
scale has constant value "100.0"Constant

Reproduction

Analysis started2024-11-24 09:09:38.654814
Analysis finished2024-11-24 09:09:48.823539
Duration10.17 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 size78.6 MiB
2024-11-24T10:09:48.917215image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

Total characters31714900
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 3171490
100.0%
2024-11-24T10:09:49.131949image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 6342980
20.0%
t 6342980
20.0%
w 3171490
10.0%
n 3171490
10.0%
I 3171490
10.0%
a 3171490
10.0%
l 3171490
10.0%
y 3171490
10.0%

Most occurring categories

ValueCountFrequency (%)
(unknown) 31714900
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
e 6342980
20.0%
t 6342980
20.0%
w 3171490
10.0%
n 3171490
10.0%
I 3171490
10.0%
a 3171490
10.0%
l 3171490
10.0%
y 3171490
10.0%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 31714900
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
e 6342980
20.0%
t 6342980
20.0%
w 3171490
10.0%
n 3171490
10.0%
I 3171490
10.0%
a 3171490
10.0%
l 3171490
10.0%
y 3171490
10.0%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 31714900
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
e 6342980
20.0%
t 6342980
20.0%
w 3171490
10.0%
n 3171490
10.0%
I 3171490
10.0%
a 3171490
10.0%
l 3171490
10.0%
y 3171490
10.0%

userid
Real number (ℝ)

User id

Distinct221
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean134.3328268
Minimum0
Maximum265
Zeros5712
Zeros (%)0.2%
Negative0
Negative (%)0.0%
Memory size48.4 MiB
2024-11-24T10:09:49.256753image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile12
Q167
median131
Q3207
95-th percentile252
Maximum265
Range265
Interquartile range (IQR)140

Descriptive statistics

Standard deviation78.9188493
Coefficient of variation (CV)0.5874874456
Kurtosis-1.288211018
Mean134.3328268
Median Absolute Deviation (MAD)71
Skewness-0.01317043845
Sum426035217
Variance6228.184774
MonotonicityIncreasing
2024-11-24T10:09:49.385019image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
105 36490
 
1.2%
79 36031
 
1.1%
80 35555
 
1.1%
75 35534
 
1.1%
103 35453
 
1.1%
202 35224
 
1.1%
131 34763
 
1.1%
148 33964
 
1.1%
78 33637
 
1.1%
212 33213
 
1.0%
Other values (211) 2821626
89.0%
ValueCountFrequency (%)
0 5712
 
0.2%
1 16725
0.5%
2 15021
0.5%
3 11826
0.4%
4 14308
0.5%
ValueCountFrequency (%)
265 7265
 
0.2%
264 6636
 
0.2%
263 21539
0.7%
262 18188
0.6%
260 169
 
< 0.1%

timestamp
Date

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

Distinct3169109
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Memory size48.4 MiB
Minimum2020-11-16 07:00:00.411000
Maximum2020-12-11 21:59:59.744000
2024-11-24T10:09:49.506963image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-11-24T10:09:49.626676image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

level
Real number (ℝ)

Numeric value of the charge level of the battery

Distinct100
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean66.81216589
Minimum1
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size48.4 MiB
2024-11-24T10:09:49.744211image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile21
Q144
median69
Q394
95-th percentile100
Maximum100
Range99
Interquartile range (IQR)50

Descriptive statistics

Standard deviation26.99064186
Coefficient of variation (CV)0.4039779508
Kurtosis-1.174516069
Mean66.81216589
Median Absolute Deviation (MAD)25
Skewness-0.2902166103
Sum211894116
Variance728.4947482
MonotonicityNot monotonic
2024-11-24T10:09:49.865684image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 613485
 
19.3%
80 39857
 
1.3%
77 34315
 
1.1%
78 33933
 
1.1%
53 33715
 
1.1%
89 33539
 
1.1%
90 33466
 
1.1%
49 33461
 
1.1%
87 33240
 
1.0%
47 33200
 
1.0%
Other values (90) 2249279
70.9%
ValueCountFrequency (%)
1 776
< 0.1%
2 1022
< 0.1%
3 1210
< 0.1%
4 1769
0.1%
5 1815
0.1%
ValueCountFrequency (%)
100 613485
19.3%
99 27932
 
0.9%
98 28679
 
0.9%
97 30161
 
1.0%
96 33193
 
1.0%

scale
Real number (ℝ)

CONSTANT 

Scale of the battery

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean100
Minimum100
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size48.4 MiB
2024-11-24T10:09:49.959189image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum100
5-th percentile100
Q1100
median100
Q3100
95-th percentile100
Maximum100
Range0
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0
Coefficient of variation (CV)0
Kurtosis0
Mean100
Median Absolute Deviation (MAD)0
Skewness0
Sum317149000
Variance0
MonotonicityIncreasing
2024-11-24T10:09:50.040113image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=1)
ValueCountFrequency (%)
100 3171490
100.0%
ValueCountFrequency (%)
100 3171490
100.0%
ValueCountFrequency (%)
100 3171490
100.0%

Correlations

2024-11-24T10:09:50.097465image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
leveluserid
level1.000-0.029
userid-0.0291.000