Overview

Dataset statistics

Number of variables5
Number of observations199
Missing cells0
Missing cells (%)0.0%
Duplicate rows30
Duplicate rows (%)15.1%
Total size in memory8.7 KiB
Average record size in memory44.7 B

Variable types

Categorical3
Numeric2

Alerts

DATE has constant value ""Constant
DAYWEEK has constant value ""Constant
TELOFCNO has constant value ""Constant
Dataset has 30 (15.1%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-10 06:22:41.453759
Analysis finished2023-12-10 06:22:42.845808
Duration1.39 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

DATE
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
20200101
199 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row20200101
2nd row20200101
3rd row20200101
4th row20200101
5th row20200101

Common Values

ValueCountFrequency (%)
20200101 199
100.0%

Length

2023-12-10T15:22:43.039520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:22:43.262038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20200101 199
100.0%

HMS
Real number (ℝ)

Distinct74
Distinct (%)37.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1160.4422
Minimum209
Maximum1630
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:22:43.466466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum209
5-th percentile309
Q11018
median1245
Q31436
95-th percentile1604
Maximum1630
Range1421
Interquartile range (IQR)418

Descriptive statistics

Standard deviation387.49553
Coefficient of variation (CV)0.33392057
Kurtosis0.15581017
Mean1160.4422
Median Absolute Deviation (MAD)200
Skewness-1.0859162
Sum230928
Variance150152.78
MonotonicityIncreasing
2023-12-10T15:22:43.707454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1226 7
 
3.5%
1604 7
 
3.5%
1503 7
 
3.5%
336 7
 
3.5%
829 7
 
3.5%
1422 7
 
3.5%
309 6
 
3.0%
1512 6
 
3.0%
1436 6
 
3.0%
1245 6
 
3.0%
Other values (64) 133
66.8%
ValueCountFrequency (%)
209 1
 
0.5%
254 3
1.5%
301 1
 
0.5%
308 1
 
0.5%
309 6
3.0%
314 1
 
0.5%
318 1
 
0.5%
333 1
 
0.5%
336 7
3.5%
458 1
 
0.5%
ValueCountFrequency (%)
1630 5
2.5%
1609 1
 
0.5%
1604 7
3.5%
1552 1
 
0.5%
1540 1
 
0.5%
1531 1
 
0.5%
1526 1
 
0.5%
1513 1
 
0.5%
1512 6
3.0%
1510 3
1.5%

DAYWEEK
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
WED
199 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowWED
2nd rowWED
3rd rowWED
4th rowWED
5th rowWED

Common Values

ValueCountFrequency (%)
WED 199
100.0%

Length

2023-12-10T15:22:43.926201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:22:44.079887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
wed 199
100.0%

TELOFCNO
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
70
199 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row70
2nd row70
3rd row70
4th row70
5th row70

Common Values

ValueCountFrequency (%)
70 199
100.0%

Length

2023-12-10T15:22:44.238821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:22:44.390553image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
70 199
100.0%

TELNO_MIDDLE_VALUE
Real number (ℝ)

Distinct14
Distinct (%)7.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6172.2111
Minimum4020
Maximum8190
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:22:44.528926image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4020
5-th percentile4612.9
Q14768
median7077
Q37714
95-th percentile8190
Maximum8190
Range4170
Interquartile range (IQR)2946

Descriptive statistics

Standard deviation1505.5566
Coefficient of variation (CV)0.243925
Kurtosis-1.7593666
Mean6172.2111
Median Absolute Deviation (MAD)1113
Skewness0.099305958
Sum1228270
Variance2266700.6
MonotonicityNot monotonic
2023-12-10T15:22:44.702455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
4768 52
26.1%
8190 33
16.6%
7077 32
16.1%
4659 10
 
5.0%
4916 9
 
4.5%
4942 9
 
4.5%
7714 9
 
4.5%
7784 9
 
4.5%
4732 9
 
4.5%
4020 8
 
4.0%
Other values (4) 19
 
9.5%
ValueCountFrequency (%)
4020 8
 
4.0%
4198 2
 
1.0%
4659 10
 
5.0%
4732 9
 
4.5%
4768 52
26.1%
4916 9
 
4.5%
4942 9
 
4.5%
7077 32
16.1%
7078 6
 
3.0%
7402 7
 
3.5%
ValueCountFrequency (%)
8190 33
16.6%
7845 4
 
2.0%
7784 9
 
4.5%
7714 9
 
4.5%
7402 7
 
3.5%
7078 6
 
3.0%
7077 32
16.1%
4942 9
 
4.5%
4916 9
 
4.5%
4768 52
26.1%

Interactions

2023-12-10T15:22:42.077698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:22:41.672365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:22:42.278375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:22:41.912405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:22:44.833360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
HMSTELNO_MIDDLE_VALUE
HMS1.0000.501
TELNO_MIDDLE_VALUE0.5011.000
2023-12-10T15:22:44.972026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
HMSTELNO_MIDDLE_VALUE
HMS1.000-0.048
TELNO_MIDDLE_VALUE-0.0481.000

Missing values

2023-12-10T15:22:42.507107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T15:22:42.752719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

DATEHMSDAYWEEKTELOFCNOTELNO_MIDDLE_VALUE
020200101209WED704768
120200101254WED704768
220200101254WED708190
320200101254WED708190
420200101301WED707077
520200101308WED704020
620200101309WED704659
720200101309WED704916
820200101309WED704942
920200101309WED707402
DATEHMSDAYWEEKTELOFCNOTELNO_MIDDLE_VALUE
189202001011604WED707402
190202001011604WED704916
191202001011604WED704942
192202001011604WED704659
193202001011609WED704768
194202001011630WED704732
195202001011630WED707077
196202001011630WED704768
197202001011630WED707077
198202001011630WED704768

Duplicate rows

Most frequently occurring

DATEHMSDAYWEEKTELOFCNOTELNO_MIDDLE_VALUE# duplicates
220200101336WED7070773
620200101913WED7070773
15202001011309WED7070773
25202001011503WED7070773
27202001011512WED7070773
020200101254WED7081902
120200101336WED7047682
320200101748WED7081902
420200101818WED7081902
520200101913WED7047682