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=NES00014 |
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:16:01.820456 |
---|---|
Analysis finished | 2023-12-10 06:16:02.825312 |
Duration | 1 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 | 153 |
---|---|
Distinct (%) | 76.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1732.603 |
Minimum | 208 |
---|---|
Maximum | 3116 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.9 KiB |
Quantile statistics
Minimum | 208 |
---|---|
5-th percentile | 340.8 |
Q1 | 1220.5 |
median | 1635 |
Q3 | 2281.5 |
95-th percentile | 2838.1 |
Maximum | 3116 |
Range | 2908 |
Interquartile range (IQR) | 1061 |
Descriptive statistics
Standard deviation | 760.44217 |
---|---|
Coefficient of variation (CV) | 0.43890156 |
Kurtosis | -0.78080175 |
Mean | 1732.603 |
Median Absolute Deviation (MAD) | 478 |
Skewness | 0.0083824823 |
Sum | 344788 |
Variance | 578272.29 |
Monotonicity | Increasing |
Value | Count | Frequency (%) |
2821 | 4 | 2.0% |
2809 | 3 | 1.5% |
2804 | 3 | 1.5% |
1503 | 3 | 1.5% |
330 | 3 | 1.5% |
1728 | 3 | 1.5% |
1131 | 3 | 1.5% |
1943 | 2 | 1.0% |
2048 | 2 | 1.0% |
1436 | 2 | 1.0% |
Other values (143) | 171 |
Value | Count | Frequency (%) |
208 | 1 | 0.5% |
209 | 1 | 0.5% |
254 | 1 | 0.5% |
301 | 2 | |
318 | 2 | |
330 | 3 | |
342 | 1 | 0.5% |
347 | 1 | 0.5% |
448 | 1 | 0.5% |
502 | 1 | 0.5% |
Value | Count | Frequency (%) |
3116 | 1 | |
3114 | 2 | |
3058 | 1 | |
3055 | 1 | |
3051 | 1 | |
3022 | 1 | |
3020 | 1 | |
2842 | 1 | |
2839 | 1 | |
2838 | 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 |
63 | |
---|---|
51 | |
55 | |
53 | |
54 |
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 2 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 55 |
---|---|
2nd row | 63 |
3rd row | 55 |
4th row | 51 |
5th row | 63 |
Common Values
Value | Count | Frequency (%) |
63 | 84 | |
51 | 35 | |
55 | 32 | 16.1% |
53 | 30 | 15.1% |
54 | 18 | 9.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
63 | 84 | |
51 | 35 | |
55 | 32 | 16.1% |
53 | 30 | 15.1% |
54 | 18 | 9.0% |
TELNO_RP_VALUE
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 16 |
---|---|
Distinct (%) | 8.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 4616.7839 |
Minimum | 22 |
---|---|
Maximum | 8888 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.9 KiB |
Quantile statistics
Minimum | 22 |
---|---|
5-th percentile | 1856.2 |
Q1 | 2415 |
median | 3333 |
Q3 | 7777 |
95-th percentile | 8080 |
Maximum | 8888 |
Range | 8866 |
Interquartile range (IQR) | 5362 |
Descriptive statistics
Standard deviation | 2683.5065 |
---|---|
Coefficient of variation (CV) | 0.58125018 |
Kurtosis | -1.6003158 |
Mean | 4616.7839 |
Median Absolute Deviation (MAD) | 2222 |
Skewness | 0.21405817 |
Sum | 918740 |
Variance | 7201206.9 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
8080 | 36 | |
2415 | 32 | |
2082 | 22 | |
2459 | 22 | |
5808 | 17 | |
7106 | 12 | 6.0% |
1939 | 12 | 6.0% |
6003 | 11 | 5.5% |
7777 | 10 | 5.0% |
8888 | 7 | 3.5% |
Other values (6) | 18 |
Value | Count | Frequency (%) |
22 | 3 | 1.5% |
276 | 1 | 0.5% |
1111 | 6 | 3.0% |
1939 | 12 | 6.0% |
2082 | 22 | |
2415 | 32 | |
2459 | 22 | |
3333 | 2 | 1.0% |
3779 | 1 | 0.5% |
3986 | 5 | 2.5% |
Value | Count | Frequency (%) |
8888 | 7 | 3.5% |
8080 | 36 | |
7777 | 10 | 5.0% |
7106 | 12 | 6.0% |
6003 | 11 | 5.5% |
5808 | 17 | |
3986 | 5 | 2.5% |
3779 | 1 | 0.5% |
3333 | 2 | 1.0% |
2459 | 22 |
HMS | TELOFCNO | TELNO_RP_VALUE | |
---|---|---|---|
HMS | 1.000 | 0.313 | 0.302 |
TELOFCNO | 0.313 | 1.000 | 0.854 |
TELNO_RP_VALUE | 0.302 | 0.854 | 1.000 |
HMS | TELNO_RP_VALUE | TELOFCNO | |
---|---|---|---|
HMS | 1.000 | 0.085 | 0.127 |
TELNO_RP_VALUE | 0.085 | 1.000 | 0.702 |
TELOFCNO | 0.127 | 0.702 | 1.000 |
DATE | HMS | DAYWEEK | TELOFCNO | TELNO_RP_VALUE | |
---|---|---|---|---|---|
0 | 20200101 | 208 | WED | 55 | 2415 |
1 | 20200101 | 209 | WED | 63 | 8080 |
2 | 20200101 | 254 | WED | 55 | 2415 |
3 | 20200101 | 301 | WED | 51 | 1939 |
4 | 20200101 | 301 | WED | 63 | 2082 |
5 | 20200101 | 318 | WED | 51 | 2459 |
6 | 20200101 | 318 | WED | 53 | 5808 |
7 | 20200101 | 330 | WED | 54 | 8888 |
8 | 20200101 | 330 | WED | 54 | 7777 |
9 | 20200101 | 330 | WED | 63 | 1111 |
DATE | HMS | DAYWEEK | TELOFCNO | TELNO_RP_VALUE | |
---|---|---|---|---|---|
189 | 20200101 | 2839 | WED | 63 | 7106 |
190 | 20200101 | 2842 | WED | 63 | 8080 |
191 | 20200101 | 3020 | WED | 63 | 7106 |
192 | 20200101 | 3022 | WED | 63 | 8080 |
193 | 20200101 | 3051 | WED | 63 | 7106 |
194 | 20200101 | 3055 | WED | 63 | 8080 |
195 | 20200101 | 3058 | WED | 63 | 3986 |
196 | 20200101 | 3114 | WED | 51 | 2459 |
197 | 20200101 | 3114 | WED | 53 | 5808 |
198 | 20200101 | 3116 | WED | 63 | 7106 |
Most frequently occurring
DATE | HMS | DAYWEEK | TELOFCNO | TELNO_RP_VALUE | # duplicates | |
---|---|---|---|---|---|---|
0 | 20200101 | 1930 | WED | 53 | 6003 | 2 |