Overview

Dataset statistics

Number of variables5
Number of observations264232
Missing cells0
Missing cells (%)0.0%
Total size in memory13.1 MiB
Average record size in memory52.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 "wenetDenmark"Constant
scale has constant value "100.0"Constant
userid has 20855 (7.9%) zerosZeros

Reproduction

Analysis started2024-11-24 09:08:44.536806
Analysis finished2024-11-24 09:08:45.570246
Duration1.03 second
Software versionydata-profiling v4.8.3
Download configurationconfig.json

Variables

experimentid
Text

CONSTANT 

Experiment Id

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size5.0 MiB
2024-11-24T10:08:45.669109image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

Total characters3170784
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 264232
100.0%
2024-11-24T10:08:45.887944image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 792696
25.0%
n 528464
16.7%
w 264232
 
8.3%
t 264232
 
8.3%
D 264232
 
8.3%
m 264232
 
8.3%
a 264232
 
8.3%
r 264232
 
8.3%
k 264232
 
8.3%

Most occurring categories

ValueCountFrequency (%)
(unknown) 3170784
100.0%

Most frequent character per category

(unknown)
ValueCountFrequency (%)
e 792696
25.0%
n 528464
16.7%
w 264232
 
8.3%
t 264232
 
8.3%
D 264232
 
8.3%
m 264232
 
8.3%
a 264232
 
8.3%
r 264232
 
8.3%
k 264232
 
8.3%

Most occurring scripts

ValueCountFrequency (%)
(unknown) 3170784
100.0%

Most frequent character per script

(unknown)
ValueCountFrequency (%)
e 792696
25.0%
n 528464
16.7%
w 264232
 
8.3%
t 264232
 
8.3%
D 264232
 
8.3%
m 264232
 
8.3%
a 264232
 
8.3%
r 264232
 
8.3%
k 264232
 
8.3%

Most occurring blocks

ValueCountFrequency (%)
(unknown) 3170784
100.0%

Most frequent character per block

(unknown)
ValueCountFrequency (%)
e 792696
25.0%
n 528464
16.7%
w 264232
 
8.3%
t 264232
 
8.3%
D 264232
 
8.3%
m 264232
 
8.3%
a 264232
 
8.3%
r 264232
 
8.3%
k 264232
 
8.3%

userid
Real number (ℝ)

ZEROS 

User id

Distinct18
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12.31425414
Minimum0
Maximum27
Zeros20855
Zeros (%)7.9%
Negative0
Negative (%)0.0%
Memory size2.0 MiB
2024-11-24T10:08:45.992831image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q13
median6
Q323
95-th percentile26
Maximum27
Range27
Interquartile range (IQR)20

Descriptive statistics

Standard deviation9.975606641
Coefficient of variation (CV)0.810086143
Kurtosis-1.706656399
Mean12.31425414
Median Absolute Deviation (MAD)6
Skewness0.2257707288
Sum3253820
Variance99.51272785
MonotonicityIncreasing
2024-11-24T10:08:46.087902image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
6 34650
13.1%
3 34025
12.9%
23 33792
12.8%
2 28870
10.9%
26 27938
10.6%
5 23069
8.7%
0 20855
7.9%
17 14258
5.4%
27 10315
 
3.9%
20 8980
 
3.4%
Other values (8) 27480
10.4%
ValueCountFrequency (%)
0 20855
7.9%
2 28870
10.9%
3 34025
12.9%
5 23069
8.7%
6 34650
13.1%
ValueCountFrequency (%)
27 10315
 
3.9%
26 27938
10.6%
25 5687
 
2.2%
23 33792
12.8%
22 8674
 
3.3%

timestamp
Date

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

Distinct264222
Distinct (%)> 99.9%
Missing0
Missing (%)0.0%
Memory size2.0 MiB
Minimum2020-11-16 07:00:00.220000
Maximum2020-12-11 21:59:43.081000
2024-11-24T10:08:46.198401image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
2024-11-24T10:08:46.335174image/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%
Mean71.5748244
Minimum1
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.0 MiB
2024-11-24T10:08:46.450093image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile26
Q150
median75
Q3100
95-th percentile100
Maximum100
Range99
Interquartile range (IQR)50

Descriptive statistics

Standard deviation25.8987142
Coefficient of variation (CV)0.3618411141
Kurtosis-1.087342375
Mean71.5748244
Median Absolute Deviation (MAD)25
Skewness-0.4332832873
Sum18912359
Variance670.7433974
MonotonicityNot monotonic
2024-11-24T10:08:46.570468image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 73276
27.7%
71 3410
 
1.3%
49 3216
 
1.2%
70 3093
 
1.2%
51 3032
 
1.1%
75 2966
 
1.1%
47 2920
 
1.1%
73 2919
 
1.1%
44 2823
 
1.1%
74 2817
 
1.1%
Other values (90) 163760
62.0%
ValueCountFrequency (%)
1 5
 
< 0.1%
2 5
 
< 0.1%
3 28
< 0.1%
4 43
< 0.1%
5 29
< 0.1%
ValueCountFrequency (%)
100 73276
27.7%
99 2011
 
0.8%
98 2036
 
0.8%
97 2125
 
0.8%
96 2113
 
0.8%

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 size2.0 MiB
2024-11-24T10:08:46.661683image/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
Sum26423200
Variance0
MonotonicityIncreasing
2024-11-24T10:08:46.739084image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
Histogram with fixed size bins (bins=1)
ValueCountFrequency (%)
100 264232
100.0%
ValueCountFrequency (%)
100 264232
100.0%
ValueCountFrequency (%)
100 264232
100.0%

Correlations

2024-11-24T10:08:46.794969image/svg+xmlMatplotlib v3.8.4, https://matplotlib.org/
leveluserid
level1.000-0.125
userid-0.1251.000