Dataset statistics
Number of variables | 5 |
---|---|
Number of observations | 199 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 1 |
Duplicate rows (%) | 0.5% |
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=NES00013 |
DATE has constant value "" | Constant |
DAYWEEK has constant value "" | Constant |
Dataset has 1 (0.5%) duplicate rows | Duplicates |
TELNO_RP_VALUE is highly overall correlated with TELOFCNO | High correlation |
TELOFCNO is highly overall correlated with TELNO_RP_VALUE | High correlation |
Reproduction
Analysis started | 2023-12-10 06:25:53.921859 |
---|---|
Analysis finished | 2023-12-10 06:25:55.038291 |
Duration | 1.12 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 | 197 |
---|---|
Distinct (%) | 99.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 16989.99 |
Minimum | 209 |
---|---|
Maximum | 62835 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.9 KiB |
Quantile statistics
Minimum | 209 |
---|---|
5-th percentile | 1037 |
Q1 | 3528 |
median | 12233 |
Q3 | 23186 |
95-th percentile | 53652.4 |
Maximum | 62835 |
Range | 62626 |
Interquartile range (IQR) | 19658 |
Descriptive statistics
Standard deviation | 15826.085 |
---|---|
Coefficient of variation (CV) | 0.93149469 |
Kurtosis | 0.54738284 |
Mean | 16989.99 |
Median Absolute Deviation (MAD) | 9422 |
Skewness | 1.1729879 |
Sum | 3381008 |
Variance | 2.5046498 × 108 |
Monotonicity | Increasing |
Value | Count | Frequency (%) |
1930 | 2 | 1.0% |
2804 | 2 | 1.0% |
209 | 1 | 0.5% |
15646 | 1 | 0.5% |
20019 | 1 | 0.5% |
20043 | 1 | 0.5% |
20653 | 1 | 0.5% |
20709 | 1 | 0.5% |
20759 | 1 | 0.5% |
20948 | 1 | 0.5% |
Other values (187) | 187 |
Value | Count | Frequency (%) |
209 | 1 | |
257 | 1 | |
342 | 1 | |
447 | 1 | |
503 | 1 | |
659 | 1 | |
753 | 1 | |
820 | 1 | |
941 | 1 | |
1019 | 1 |
Value | Count | Frequency (%) |
62835 | 1 | |
62713 | 1 | |
55812 | 1 | |
55711 | 1 | |
55620 | 1 | |
55145 | 1 | |
55014 | 1 | |
54552 | 1 | |
54428 | 1 | |
53719 | 1 |
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
HIGH CORRELATION
 
Distinct | 5 |
---|---|
Distinct (%) | 2.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
42 | |
---|---|
33 | |
41 | |
43 | 2 |
44 | 2 |
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 2 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 42 |
---|---|
2nd row | 42 |
3rd row | 33 |
4th row | 42 |
5th row | 33 |
Common Values
Value | Count | Frequency (%) |
42 | 103 | |
33 | 53 | |
41 | 39 | 19.6% |
43 | 2 | 1.0% |
44 | 2 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
42 | 103 | |
33 | 53 | |
41 | 39 | 19.6% |
43 | 2 | 1.0% |
44 | 2 | 1.0% |
TELNO_RP_VALUE
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 18 |
---|---|
Distinct (%) | 9.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 5277.5678 |
Minimum | 60 |
---|---|
Maximum | 9478 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.9 KiB |
Quantile statistics
Minimum | 60 |
---|---|
5-th percentile | 271 |
Q1 | 1125 |
median | 8987 |
Q3 | 8987 |
95-th percentile | 8987 |
Maximum | 9478 |
Range | 9418 |
Interquartile range (IQR) | 7862 |
Descriptive statistics
Standard deviation | 4003.2617 |
---|---|
Coefficient of variation (CV) | 0.75854291 |
Kurtosis | -1.9076225 |
Mean | 5277.5678 |
Median Absolute Deviation (MAD) | 0 |
Skewness | -0.20797584 |
Sum | 1050236 |
Variance | 16026104 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
8987 | 102 | |
1125 | 49 | |
271 | 33 | 16.6% |
5431 | 1 | 0.5% |
2785 | 1 | 0.5% |
5050 | 1 | 0.5% |
7978 | 1 | 0.5% |
5252 | 1 | 0.5% |
5607 | 1 | 0.5% |
5464 | 1 | 0.5% |
Other values (8) | 8 | 4.0% |
Value | Count | Frequency (%) |
60 | 1 | 0.5% |
271 | 33 | |
1125 | 49 | |
1316 | 1 | 0.5% |
2222 | 1 | 0.5% |
2730 | 1 | 0.5% |
2785 | 1 | 0.5% |
3333 | 1 | 0.5% |
5050 | 1 | 0.5% |
5252 | 1 | 0.5% |
Value | Count | Frequency (%) |
9478 | 1 | 0.5% |
8987 | 102 | |
7978 | 1 | 0.5% |
7155 | 1 | 0.5% |
5633 | 1 | 0.5% |
5607 | 1 | 0.5% |
5464 | 1 | 0.5% |
5431 | 1 | 0.5% |
5252 | 1 | 0.5% |
5050 | 1 | 0.5% |
HMS | TELOFCNO | TELNO_RP_VALUE | |
---|---|---|---|
HMS | 1.000 | 0.472 | 0.321 |
TELOFCNO | 0.472 | 1.000 | 0.926 |
TELNO_RP_VALUE | 0.321 | 0.926 | 1.000 |
HMS | TELNO_RP_VALUE | TELOFCNO | |
---|---|---|---|
HMS | 1.000 | -0.014 | 0.212 |
TELNO_RP_VALUE | -0.014 | 1.000 | 0.872 |
TELOFCNO | 0.212 | 0.872 | 1.000 |
DATE | HMS | DAYWEEK | TELOFCNO | TELNO_RP_VALUE | |
---|---|---|---|---|---|
0 | 20200101 | 209 | WED | 42 | 8987 |
1 | 20200101 | 257 | WED | 42 | 8987 |
2 | 20200101 | 342 | WED | 33 | 1125 |
3 | 20200101 | 447 | WED | 42 | 8987 |
4 | 20200101 | 503 | WED | 33 | 1125 |
5 | 20200101 | 659 | WED | 42 | 8987 |
6 | 20200101 | 753 | WED | 42 | 8987 |
7 | 20200101 | 820 | WED | 42 | 8987 |
8 | 20200101 | 941 | WED | 41 | 3333 |
9 | 20200101 | 1019 | WED | 42 | 8987 |
DATE | HMS | DAYWEEK | TELOFCNO | TELNO_RP_VALUE | |
---|---|---|---|---|---|
189 | 20200101 | 53719 | WED | 33 | 1125 |
190 | 20200101 | 54428 | WED | 42 | 8987 |
191 | 20200101 | 54552 | WED | 42 | 8987 |
192 | 20200101 | 55014 | WED | 43 | 2785 |
193 | 20200101 | 55145 | WED | 33 | 1125 |
194 | 20200101 | 55620 | WED | 42 | 8987 |
195 | 20200101 | 55711 | WED | 33 | 1125 |
196 | 20200101 | 55812 | WED | 33 | 1125 |
197 | 20200101 | 62713 | WED | 42 | 8987 |
198 | 20200101 | 62835 | WED | 42 | 8987 |
Most frequently occurring
DATE | HMS | DAYWEEK | TELOFCNO | TELNO_RP_VALUE | # duplicates | |
---|---|---|---|---|---|---|
0 | 20200101 | 1930 | WED | 33 | 1125 | 2 |