Dataset statistics
Number of variables | 5 |
---|---|
Number of observations | 199 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 30 |
Duplicate rows (%) | 15.1% |
Total size in memory | 8.7 KiB |
Average record size in memory | 44.7 B |
Variable types
Categorical | 3 |
---|---|
Numeric | 2 |
Dataset
Description | Sample |
---|---|
Author | (주)네스 |
URL | https://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=NES00011 |
DATE has constant value "" | Constant |
DAYWEEK has constant value "" | Constant |
TELOFCNO has constant value "" | Constant |
Dataset has 30 (15.1%) duplicate rows | Duplicates |
Reproduction
Analysis started | 2023-12-10 06:22:41.453759 |
---|---|
Analysis finished | 2023-12-10 06:22:42.845808 |
Duration | 1.39 second |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
DATE
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
20200101 |
---|
Length
Max length | 8 |
---|---|
Median length | 8 |
Mean length | 8 |
Min length | 8 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 20200101 |
---|---|
2nd row | 20200101 |
3rd row | 20200101 |
4th row | 20200101 |
5th row | 20200101 |
Common Values
Value | Count | Frequency (%) |
20200101 | 199 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
20200101 | 199 |
HMS
Real number (ℝ)
Distinct | 74 |
---|---|
Distinct (%) | 37.2% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1160.4422 |
Minimum | 209 |
---|---|
Maximum | 1630 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.9 KiB |
Quantile statistics
Minimum | 209 |
---|---|
5-th percentile | 309 |
Q1 | 1018 |
median | 1245 |
Q3 | 1436 |
95-th percentile | 1604 |
Maximum | 1630 |
Range | 1421 |
Interquartile range (IQR) | 418 |
Descriptive statistics
Standard deviation | 387.49553 |
---|---|
Coefficient of variation (CV) | 0.33392057 |
Kurtosis | 0.15581017 |
Mean | 1160.4422 |
Median Absolute Deviation (MAD) | 200 |
Skewness | -1.0859162 |
Sum | 230928 |
Variance | 150152.78 |
Monotonicity | Increasing |
Value | Count | Frequency (%) |
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 |
Value | Count | Frequency (%) |
209 | 1 | 0.5% |
254 | 3 | |
301 | 1 | 0.5% |
308 | 1 | 0.5% |
309 | 6 | |
314 | 1 | 0.5% |
318 | 1 | 0.5% |
333 | 1 | 0.5% |
336 | 7 | |
458 | 1 | 0.5% |
Value | Count | Frequency (%) |
1630 | 5 | |
1609 | 1 | 0.5% |
1604 | 7 | |
1552 | 1 | 0.5% |
1540 | 1 | 0.5% |
1531 | 1 | 0.5% |
1526 | 1 | 0.5% |
1513 | 1 | 0.5% |
1512 | 6 | |
1510 | 3 |
DAYWEEK
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
WED |
---|
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 3 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | WED |
---|---|
2nd row | WED |
3rd row | WED |
4th row | WED |
5th row | WED |
Common Values
Value | Count | Frequency (%) |
WED | 199 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
wed | 199 |
TELOFCNO
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
70 |
---|
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 2 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 70 |
---|---|
2nd row | 70 |
3rd row | 70 |
4th row | 70 |
5th row | 70 |
Common Values
Value | Count | Frequency (%) |
70 | 199 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
70 | 199 |
TELNO_MIDDLE_VALUE
Real number (ℝ)
Distinct | 14 |
---|---|
Distinct (%) | 7.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 6172.2111 |
Minimum | 4020 |
---|---|
Maximum | 8190 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.9 KiB |
Quantile statistics
Minimum | 4020 |
---|---|
5-th percentile | 4612.9 |
Q1 | 4768 |
median | 7077 |
Q3 | 7714 |
95-th percentile | 8190 |
Maximum | 8190 |
Range | 4170 |
Interquartile range (IQR) | 2946 |
Descriptive statistics
Standard deviation | 1505.5566 |
---|---|
Coefficient of variation (CV) | 0.243925 |
Kurtosis | -1.7593666 |
Mean | 6172.2111 |
Median Absolute Deviation (MAD) | 1113 |
Skewness | 0.099305958 |
Sum | 1228270 |
Variance | 2266700.6 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
4768 | 52 | |
8190 | 33 | |
7077 | 32 | |
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% |
Value | Count | Frequency (%) |
4020 | 8 | 4.0% |
4198 | 2 | 1.0% |
4659 | 10 | 5.0% |
4732 | 9 | 4.5% |
4768 | 52 | |
4916 | 9 | 4.5% |
4942 | 9 | 4.5% |
7077 | 32 | |
7078 | 6 | 3.0% |
7402 | 7 | 3.5% |
Value | Count | Frequency (%) |
8190 | 33 | |
7845 | 4 | 2.0% |
7784 | 9 | 4.5% |
7714 | 9 | 4.5% |
7402 | 7 | 3.5% |
7078 | 6 | 3.0% |
7077 | 32 | |
4942 | 9 | 4.5% |
4916 | 9 | 4.5% |
4768 | 52 |
HMS | TELNO_MIDDLE_VALUE | |
---|---|---|
HMS | 1.000 | 0.501 |
TELNO_MIDDLE_VALUE | 0.501 | 1.000 |
HMS | TELNO_MIDDLE_VALUE | |
---|---|---|
HMS | 1.000 | -0.048 |
TELNO_MIDDLE_VALUE | -0.048 | 1.000 |
DATE | HMS | DAYWEEK | TELOFCNO | TELNO_MIDDLE_VALUE | |
---|---|---|---|---|---|
0 | 20200101 | 209 | WED | 70 | 4768 |
1 | 20200101 | 254 | WED | 70 | 4768 |
2 | 20200101 | 254 | WED | 70 | 8190 |
3 | 20200101 | 254 | WED | 70 | 8190 |
4 | 20200101 | 301 | WED | 70 | 7077 |
5 | 20200101 | 308 | WED | 70 | 4020 |
6 | 20200101 | 309 | WED | 70 | 4659 |
7 | 20200101 | 309 | WED | 70 | 4916 |
8 | 20200101 | 309 | WED | 70 | 4942 |
9 | 20200101 | 309 | WED | 70 | 7402 |
DATE | HMS | DAYWEEK | TELOFCNO | TELNO_MIDDLE_VALUE | |
---|---|---|---|---|---|
189 | 20200101 | 1604 | WED | 70 | 7402 |
190 | 20200101 | 1604 | WED | 70 | 4916 |
191 | 20200101 | 1604 | WED | 70 | 4942 |
192 | 20200101 | 1604 | WED | 70 | 4659 |
193 | 20200101 | 1609 | WED | 70 | 4768 |
194 | 20200101 | 1630 | WED | 70 | 4732 |
195 | 20200101 | 1630 | WED | 70 | 7077 |
196 | 20200101 | 1630 | WED | 70 | 4768 |
197 | 20200101 | 1630 | WED | 70 | 7077 |
198 | 20200101 | 1630 | WED | 70 | 4768 |
Most frequently occurring
DATE | HMS | DAYWEEK | TELOFCNO | TELNO_MIDDLE_VALUE | # duplicates | |
---|---|---|---|---|---|---|
2 | 20200101 | 336 | WED | 70 | 7077 | 3 |
6 | 20200101 | 913 | WED | 70 | 7077 | 3 |
15 | 20200101 | 1309 | WED | 70 | 7077 | 3 |
25 | 20200101 | 1503 | WED | 70 | 7077 | 3 |
27 | 20200101 | 1512 | WED | 70 | 7077 | 3 |
0 | 20200101 | 254 | WED | 70 | 8190 | 2 |
1 | 20200101 | 336 | WED | 70 | 4768 | 2 |
3 | 20200101 | 748 | WED | 70 | 8190 | 2 |
4 | 20200101 | 818 | WED | 70 | 8190 | 2 |
5 | 20200101 | 913 | WED | 70 | 4768 | 2 |