Dataset statistics
Number of variables | 7 |
---|---|
Number of observations | 192 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 11.6 KiB |
Average record size in memory | 61.7 B |
Variable types
Categorical | 3 |
---|---|
Numeric | 4 |
Dataset
Description | Sample |
---|---|
Author | 한국스마트그리드 |
URL | https://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=KSG2019111100EMUS01a |
mesure_de has constant value "" | Constant |
toc_no is highly overall correlated with legal_dong_cd and 3 other fields | High correlation |
cnsmr_no is highly overall correlated with legal_dong_cd and 2 other fields | High correlation |
legal_dong_cd is highly overall correlated with toc_no and 1 other fields | High correlation |
sg_pwrer_use_am is highly overall correlated with toc_no and 1 other fields | High correlation |
all_pwrer_use_am is highly overall correlated with toc_no | High correlation |
mesure_tm has 8 (4.2%) zeros | Zeros |
sg_pwrer_use_am has 23 (12.0%) zeros | Zeros |
all_pwrer_use_am has 108 (56.2%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-10 06:16:51.696589 |
---|---|
Analysis finished | 2023-12-10 06:16:54.684876 |
Duration | 2.99 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
toc_no
Categorical
HIGH CORRELATION
 
Distinct | 4 |
---|---|
Distinct (%) | 2.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.6 KiB |
E000000001 | |
---|---|
E000000002 | |
E000000003 | |
E000000004 |
Length
Max length | 10 |
---|---|
Median length | 10 |
Mean length | 10 |
Min length | 10 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | E000000001 |
---|---|
2nd row | E000000001 |
3rd row | E000000001 |
4th row | E000000001 |
5th row | E000000001 |
Common Values
Value | Count | Frequency (%) |
E000000001 | 48 | |
E000000002 | 48 | |
E000000003 | 48 | |
E000000004 | 48 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
e000000001 | 48 | |
e000000002 | 48 | |
e000000003 | 48 | |
e000000004 | 48 |
cnsmr_no
Categorical
HIGH CORRELATION
 
Distinct | 8 |
---|---|
Distinct (%) | 4.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.6 KiB |
7333 | |
---|---|
2714 | |
IMC0000008AM03200001 | |
IMC0000012SK00200002 | |
C20180516131706082 | |
Other values (3) |
Length
Max length | 20 |
---|---|
Median length | 19 |
Mean length | 11.5 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 7333 |
---|---|
2nd row | 7333 |
3rd row | 7333 |
4th row | 7333 |
5th row | 7333 |
Common Values
Value | Count | Frequency (%) |
7333 | 24 | |
2714 | 24 | |
IMC0000008AM03200001 | 24 | |
IMC0000012SK00200002 | 24 | |
C20180516131706082 | 24 | |
C20190713131750096 | 24 | |
1003 | 24 | |
1467 | 24 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
7333 | 24 | |
2714 | 24 | |
imc0000008am03200001 | 24 | |
imc0000012sk00200002 | 24 | |
c20180516131706082 | 24 | |
c20190713131750096 | 24 | |
1003 | 24 | |
1467 | 24 |
mesure_de
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.6 KiB |
20191001 |
---|
Length
Max length | 8 |
---|---|
Median length | 8 |
Mean length | 8 |
Min length | 8 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 20191001 |
---|---|
2nd row | 20191001 |
3rd row | 20191001 |
4th row | 20191001 |
5th row | 20191001 |
Common Values
Value | Count | Frequency (%) |
20191001 | 192 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
20191001 | 192 |
mesure_tm
Real number (ℝ)
ZEROS
 
Distinct | 24 |
---|---|
Distinct (%) | 12.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 11.5 |
Minimum | 0 |
---|---|
Maximum | 23 |
Zeros | 8 |
Zeros (%) | 4.2% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.8 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 1 |
Q1 | 5.75 |
median | 11.5 |
Q3 | 17.25 |
95-th percentile | 22 |
Maximum | 23 |
Range | 23 |
Interquartile range (IQR) | 11.5 |
Descriptive statistics
Standard deviation | 6.9402838 |
---|---|
Coefficient of variation (CV) | 0.60350294 |
Kurtosis | -1.2042178 |
Mean | 11.5 |
Median Absolute Deviation (MAD) | 6 |
Skewness | 0 |
Sum | 2208 |
Variance | 48.167539 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 8 | 4.2% |
13 | 8 | 4.2% |
23 | 8 | 4.2% |
22 | 8 | 4.2% |
21 | 8 | 4.2% |
20 | 8 | 4.2% |
19 | 8 | 4.2% |
18 | 8 | 4.2% |
17 | 8 | 4.2% |
16 | 8 | 4.2% |
Other values (14) | 112 |
Value | Count | Frequency (%) |
0 | 8 | |
1 | 8 | |
2 | 8 | |
3 | 8 | |
4 | 8 | |
5 | 8 | |
6 | 8 | |
7 | 8 | |
8 | 8 | |
9 | 8 |
Value | Count | Frequency (%) |
23 | 8 | |
22 | 8 | |
21 | 8 | |
20 | 8 | |
19 | 8 | |
18 | 8 | |
17 | 8 | |
16 | 8 | |
15 | 8 | |
14 | 8 |
legal_dong_cd
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 8 |
---|---|
Distinct (%) | 4.2% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 3.5402635 × 109 |
Minimum | 2.729 × 109 |
---|---|
Maximum | 5.0110253 × 109 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.8 KiB |
Quantile statistics
Minimum | 2.729 × 109 |
---|---|
5-th percentile | 2.729 × 109 |
Q1 | 2.807758 × 109 |
median | 2.9215112 × 109 |
Q3 | 4.4445313 × 109 |
95-th percentile | 5.0110253 × 109 |
Maximum | 5.0110253 × 109 |
Range | 2.2820253 × 109 |
Interquartile range (IQR) | 1.6367733 × 109 |
Descriptive statistics
Standard deviation | 9.3716326 × 108 |
---|---|
Coefficient of variation (CV) | 0.26471568 |
Kurtosis | -1.4969122 |
Mean | 3.5402635 × 109 |
Median Absolute Deviation (MAD) | 1.715112 × 108 |
Skewness | 0.60661042 |
Sum | 6.7973059 × 1011 |
Variance | 8.7827498 × 1017 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
3023011300 | 24 | |
2820011100 | 24 | |
2820010700 | 24 | |
5011025342 | 24 | |
4315038023 | 24 | |
4833011300 | 24 | |
2729000000 | 24 | |
2771000000 | 24 |
Value | Count | Frequency (%) |
2729000000 | 24 | |
2771000000 | 24 | |
2820010700 | 24 | |
2820011100 | 24 | |
3023011300 | 24 | |
4315038023 | 24 | |
4833011300 | 24 | |
5011025342 | 24 |
Value | Count | Frequency (%) |
5011025342 | 24 | |
4833011300 | 24 | |
4315038023 | 24 | |
3023011300 | 24 | |
2820011100 | 24 | |
2820010700 | 24 | |
2771000000 | 24 | |
2729000000 | 24 |
sg_pwrer_use_am
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 126 |
---|---|
Distinct (%) | 65.6% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 262.96875 |
Minimum | 0 |
---|---|
Maximum | 966.6984 |
Zeros | 23 |
Zeros (%) | 12.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.8 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 17.076 |
median | 43 |
Q3 | 448.12075 |
95-th percentile | 888.948 |
Maximum | 966.6984 |
Range | 966.6984 |
Interquartile range (IQR) | 431.04475 |
Descriptive statistics
Standard deviation | 311.09721 |
---|---|
Coefficient of variation (CV) | 1.1830197 |
Kurtosis | -0.63617038 |
Mean | 262.96875 |
Median Absolute Deviation (MAD) | 43 |
Skewness | 0.86659876 |
Sum | 50490 |
Variance | 96781.471 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0.0 | 23 | 12.0% |
28.62 | 21 | 10.9% |
46.68 | 9 | 4.7% |
42.0 | 5 | 2.6% |
23.34 | 4 | 2.1% |
30.0 | 4 | 2.1% |
14.31 | 3 | 1.6% |
602.0 | 2 | 1.0% |
618.0 | 2 | 1.0% |
12.0 | 2 | 1.0% |
Other values (116) | 117 |
Value | Count | Frequency (%) |
0.0 | 23 | |
2.028 | 1 | 0.5% |
2.052 | 1 | 0.5% |
2.124 | 1 | 0.5% |
2.148 | 1 | 0.5% |
2.184 | 1 | 0.5% |
2.316 | 1 | 0.5% |
2.388 | 1 | 0.5% |
2.868 | 1 | 0.5% |
3.48 | 1 | 0.5% |
Value | Count | Frequency (%) |
966.6984 | 1 | |
959.04 | 1 | |
943.92 | 1 | |
932.76 | 1 | |
921.96 | 1 | |
920.88 | 1 | |
913.14 | 1 | |
909.4416 | 1 | |
901.44 | 1 | |
897.66 | 1 |
all_pwrer_use_am
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 74 |
---|---|
Distinct (%) | 38.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 145.67356 |
Minimum | 0 |
---|---|
Maximum | 646 |
Zeros | 108 |
Zeros (%) | 56.2% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.8 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 383.392 |
95-th percentile | 602 |
Maximum | 646 |
Range | 646 |
Interquartile range (IQR) | 383.392 |
Descriptive statistics
Standard deviation | 219.29453 |
---|---|
Coefficient of variation (CV) | 1.5053833 |
Kurtosis | -0.55035407 |
Mean | 145.67356 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 1.0701525 |
Sum | 27969.323 |
Variance | 48090.093 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0.0 | 108 | |
42.0 | 5 | 2.6% |
30.0 | 4 | 2.1% |
12.0 | 2 | 1.0% |
618.0 | 2 | 1.0% |
628.0 | 2 | 1.0% |
602.0 | 2 | 1.0% |
11.0 | 1 | 0.5% |
22.0 | 1 | 0.5% |
23.0 | 1 | 0.5% |
Other values (64) | 64 |
Value | Count | Frequency (%) |
0.0 | 108 | |
11.0 | 1 | 0.5% |
12.0 | 2 | 1.0% |
14.0 | 1 | 0.5% |
16.0 | 1 | 0.5% |
18.0 | 1 | 0.5% |
22.0 | 1 | 0.5% |
23.0 | 1 | 0.5% |
29.0 | 1 | 0.5% |
30.0 | 4 | 2.1% |
Value | Count | Frequency (%) |
646.0 | 1 | |
628.0 | 2 | |
619.0 | 1 | |
618.0 | 2 | |
610.0 | 1 | |
609.0 | 1 | |
608.0 | 1 | |
602.0 | 2 | |
601.0 | 1 | |
592.0 | 1 |
toc_no | cnsmr_no | mesure_tm | legal_dong_cd | sg_pwrer_use_am | all_pwrer_use_am | |
---|---|---|---|---|---|---|
toc_no | 1.000 | 1.000 | 0.000 | 0.914 | 0.773 | 0.856 |
cnsmr_no | 1.000 | 1.000 | 0.000 | 1.000 | 0.829 | 0.881 |
mesure_tm | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 |
legal_dong_cd | 0.914 | 1.000 | 0.000 | 1.000 | 0.590 | 0.765 |
sg_pwrer_use_am | 0.773 | 0.829 | 0.000 | 0.590 | 1.000 | 0.932 |
all_pwrer_use_am | 0.856 | 0.881 | 0.000 | 0.765 | 0.932 | 1.000 |
toc_no | cnsmr_no | |
---|---|---|
toc_no | 1.000 | 0.989 |
cnsmr_no | 0.989 | 1.000 |
mesure_tm | legal_dong_cd | sg_pwrer_use_am | all_pwrer_use_am | toc_no | cnsmr_no | |
---|---|---|---|---|---|---|
mesure_tm | 1.000 | 0.000 | 0.060 | 0.012 | 0.000 | 0.000 |
legal_dong_cd | 0.000 | 1.000 | -0.202 | 0.450 | 0.638 | 0.989 |
sg_pwrer_use_am | 0.060 | -0.202 | 1.000 | 0.484 | 0.615 | 0.599 |
all_pwrer_use_am | 0.012 | 0.450 | 0.484 | 1.000 | 0.528 | 0.490 |
toc_no | 0.000 | 0.638 | 0.615 | 0.528 | 1.000 | 0.989 |
cnsmr_no | 0.000 | 0.989 | 0.599 | 0.490 | 0.989 | 1.000 |
toc_no | cnsmr_no | mesure_de | mesure_tm | legal_dong_cd | sg_pwrer_use_am | all_pwrer_use_am | |
---|---|---|---|---|---|---|---|
0 | E000000001 | 7333 | 20191001 | 0 | 3023011300 | 28.62 | 0.0 |
1 | E000000001 | 7333 | 20191001 | 1 | 3023011300 | 28.62 | 0.0 |
2 | E000000001 | 7333 | 20191001 | 2 | 3023011300 | 28.62 | 0.0 |
3 | E000000001 | 7333 | 20191001 | 3 | 3023011300 | 28.62 | 0.0 |
4 | E000000001 | 7333 | 20191001 | 4 | 3023011300 | 28.62 | 0.0 |
5 | E000000001 | 7333 | 20191001 | 5 | 3023011300 | 28.62 | 0.0 |
6 | E000000001 | 7333 | 20191001 | 6 | 3023011300 | 14.31 | 0.0 |
7 | E000000001 | 7333 | 20191001 | 7 | 3023011300 | 28.62 | 0.0 |
8 | E000000001 | 7333 | 20191001 | 8 | 3023011300 | 28.62 | 0.0 |
9 | E000000001 | 7333 | 20191001 | 9 | 3023011300 | 28.62 | 0.0 |
toc_no | cnsmr_no | mesure_de | mesure_tm | legal_dong_cd | sg_pwrer_use_am | all_pwrer_use_am | |
---|---|---|---|---|---|---|---|
182 | E000000004 | 1467 | 20191001 | 14 | 2771000000 | 20.472 | 0.0 |
183 | E000000004 | 1467 | 20191001 | 15 | 2771000000 | 88.044 | 0.0 |
184 | E000000004 | 1467 | 20191001 | 16 | 2771000000 | 70.44 | 0.0 |
185 | E000000004 | 1467 | 20191001 | 17 | 2771000000 | 17.844 | 0.0 |
186 | E000000004 | 1467 | 20191001 | 18 | 2771000000 | 7.596 | 0.0 |
187 | E000000004 | 1467 | 20191001 | 19 | 2771000000 | 4.644 | 0.0 |
188 | E000000004 | 1467 | 20191001 | 20 | 2771000000 | 4.848 | 0.0 |
189 | E000000004 | 1467 | 20191001 | 21 | 2771000000 | 4.32 | 0.0 |
190 | E000000004 | 1467 | 20191001 | 22 | 2771000000 | 3.972 | 0.0 |
191 | E000000004 | 1467 | 20191001 | 23 | 2771000000 | 3.48 | 0.0 |