Dataset statistics
Number of variables | 10 |
---|---|
Number of observations | 199 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 16.6 KiB |
Average record size in memory | 85.7 B |
Variable types
Categorical | 7 |
---|---|
Text | 1 |
Numeric | 2 |
Dataset
Description | Sample |
---|---|
Author | 한국스마트그리드 |
URL | https://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=KSGTEAMCHARGE |
A000000001 has constant value "" | Constant |
4311110700 has constant value "" | Constant |
202108 has constant value "" | Constant |
100 주택용전력 has constant value "" | Constant |
주택용 고압 has constant value "" | Constant |
4 단일계약아파트 has constant value "" | Constant |
106.967 is highly overall correlated with 15963 and 1 other fields | High correlation |
15963 is highly overall correlated with 106.967 and 1 other fields | High correlation |
1 is highly overall correlated with 106.967 and 1 other fields | High correlation |
CB0100101000101 has unique values | Unique |
106.967 has unique values | Unique |
15963 has unique values | Unique |
Reproduction
Analysis started | 2023-12-10 06:34:56.716929 |
---|---|
Analysis finished | 2023-12-10 06:34:58.264544 |
Duration | 1.55 second |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
A000000001
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
A000000001 |
---|
Length
Max length | 10 |
---|---|
Median length | 10 |
Mean length | 10 |
Min length | 10 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | A000000001 |
---|---|
2nd row | A000000001 |
3rd row | A000000001 |
4th row | A000000001 |
5th row | A000000001 |
Common Values
Value | Count | Frequency (%) |
A000000001 | 199 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
a000000001 | 199 |
CB0100101000101
Text
UNIQUE
 
Distinct | 199 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
Length
Max length | 15 |
---|---|
Median length | 15 |
Mean length | 15 |
Min length | 15 |
Characters and Unicode
Total characters | 2985 |
---|---|
Distinct characters | 12 |
Distinct categories | 2 ? |
Distinct scripts | 2 ? |
Distinct blocks | 1 ? |
Unique
Unique | 199 ? |
---|---|
Unique (%) | 100.0% |
Sample
1st row | CB0100101000102 |
---|---|
2nd row | CB0100101000104 |
3rd row | CB0100101000105 |
4th row | CB0100101000106 |
5th row | CB0100101000201 |
Value | Count | Frequency (%) |
cb0100101000102 | 1 | 0.5% |
cb0100105000502 | 1 | 0.5% |
cb0100104001001 | 1 | 0.5% |
cb0100104001101 | 1 | 0.5% |
cb0100104001102 | 1 | 0.5% |
cb0100104001104 | 1 | 0.5% |
cb0100104001106 | 1 | 0.5% |
cb0100104001203 | 1 | 0.5% |
cb0100104001205 | 1 | 0.5% |
cb0100104001206 | 1 | 0.5% |
Other values (189) | 189 |
Most occurring characters
Value | Count | Frequency (%) |
0 | 1524 | |
1 | 582 | 19.5% |
C | 199 | 6.7% |
B | 199 | 6.7% |
2 | 100 | 3.4% |
3 | 91 | 3.0% |
5 | 84 | 2.8% |
4 | 80 | 2.7% |
6 | 73 | 2.4% |
8 | 23 | 0.8% |
Other values (2) | 30 | 1.0% |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 2587 | |
Uppercase Letter | 398 | 13.3% |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
0 | 1524 | |
1 | 582 | 22.5% |
2 | 100 | 3.9% |
3 | 91 | 3.5% |
5 | 84 | 3.2% |
4 | 80 | 3.1% |
6 | 73 | 2.8% |
8 | 23 | 0.9% |
7 | 20 | 0.8% |
9 | 10 | 0.4% |
Uppercase Letter
Value | Count | Frequency (%) |
C | 199 | |
B | 199 |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 2587 | |
Latin | 398 | 13.3% |
Most frequent character per script
Common
Value | Count | Frequency (%) |
0 | 1524 | |
1 | 582 | 22.5% |
2 | 100 | 3.9% |
3 | 91 | 3.5% |
5 | 84 | 3.2% |
4 | 80 | 3.1% |
6 | 73 | 2.8% |
8 | 23 | 0.9% |
7 | 20 | 0.8% |
9 | 10 | 0.4% |
Latin
Value | Count | Frequency (%) |
C | 199 | |
B | 199 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 2985 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
0 | 1524 | |
1 | 582 | 19.5% |
C | 199 | 6.7% |
B | 199 | 6.7% |
2 | 100 | 3.4% |
3 | 91 | 3.0% |
5 | 84 | 2.8% |
4 | 80 | 2.7% |
6 | 73 | 2.4% |
8 | 23 | 0.8% |
Other values (2) | 30 | 1.0% |
4311110700
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
4311110700 |
---|
Length
Max length | 10 |
---|---|
Median length | 10 |
Mean length | 10 |
Min length | 10 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 4311110700 |
---|---|
2nd row | 4311110700 |
3rd row | 4311110700 |
4th row | 4311110700 |
5th row | 4311110700 |
Common Values
Value | Count | Frequency (%) |
4311110700 | 199 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
4311110700 | 199 |
202108
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
202108 |
---|
Length
Max length | 6 |
---|---|
Median length | 6 |
Mean length | 6 |
Min length | 6 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 202108 |
---|---|
2nd row | 202108 |
3rd row | 202108 |
4th row | 202108 |
5th row | 202108 |
Common Values
Value | Count | Frequency (%) |
202108 | 199 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
202108 | 199 |
106.967
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 199 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 299.06885 |
Minimum | 11.172 |
---|---|
Maximum | 767.014 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.9 KiB |
Quantile statistics
Minimum | 11.172 |
---|---|
5-th percentile | 153.5542 |
Q1 | 214.8695 |
median | 288.35 |
Q3 | 357.887 |
95-th percentile | 468.3912 |
Maximum | 767.014 |
Range | 755.842 |
Interquartile range (IQR) | 143.0175 |
Descriptive statistics
Standard deviation | 109.30726 |
---|---|
Coefficient of variation (CV) | 0.36549195 |
Kurtosis | 1.7554437 |
Mean | 299.06885 |
Median Absolute Deviation (MAD) | 72.161 |
Skewness | 0.80530974 |
Sum | 59514.701 |
Variance | 11948.077 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
283.304 | 1 | 0.5% |
288.35 | 1 | 0.5% |
389.213 | 1 | 0.5% |
341.969 | 1 | 0.5% |
361.664 | 1 | 0.5% |
356.585 | 1 | 0.5% |
408.339 | 1 | 0.5% |
273.716 | 1 | 0.5% |
362.215 | 1 | 0.5% |
413.08 | 1 | 0.5% |
Other values (189) | 189 |
Value | Count | Frequency (%) |
11.172 | 1 | |
90.658 | 1 | |
94.231 | 1 | |
105.042 | 1 | |
117.899 | 1 | |
117.941 | 1 | |
131.01 | 1 | |
150.04 | 1 | |
151.538 | 1 | |
152.134 | 1 |
Value | Count | Frequency (%) |
767.014 | 1 | |
648.06 | 1 | |
641.123 | 1 | |
593.513 | 1 | |
587.959 | 1 | |
540.17 | 1 | |
503.567 | 1 | |
484.452 | 1 | |
482.906 | 1 | |
479.589 | 1 |
100 주택용전력
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
100 주택용전력 |
---|
Length
Max length | 9 |
---|---|
Median length | 9 |
Mean length | 9 |
Min length | 9 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 100 주택용전력 |
---|---|
2nd row | 100 주택용전력 |
3rd row | 100 주택용전력 |
4th row | 100 주택용전력 |
5th row | 100 주택용전력 |
Common Values
Value | Count | Frequency (%) |
100 주택용전력 | 199 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
100 | 199 | |
주택용전력 | 199 |
주택용 고압
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
주택용 고압 |
---|
Length
Max length | 6 |
---|---|
Median length | 6 |
Mean length | 6 |
Min length | 6 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 주택용 고압 |
---|---|
2nd row | 주택용 고압 |
3rd row | 주택용 고압 |
4th row | 주택용 고압 |
5th row | 주택용 고압 |
Common Values
Value | Count | Frequency (%) |
주택용 고압 | 199 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
주택용 | 199 | |
고압 | 199 |
4 단일계약아파트
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
4 단일계약아파트 |
---|
Length
Max length | 9 |
---|---|
Median length | 9 |
Mean length | 9 |
Min length | 9 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 4 단일계약아파트 |
---|---|
2nd row | 4 단일계약아파트 |
3rd row | 4 단일계약아파트 |
4th row | 4 단일계약아파트 |
5th row | 4 단일계약아파트 |
Common Values
Value | Count | Frequency (%) |
4 단일계약아파트 | 199 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
4 | 199 | |
단일계약아파트 | 199 |
1
Categorical
HIGH CORRELATION
 
Distinct | 3 |
---|---|
Distinct (%) | 1.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
1 | |
---|---|
2 | |
3 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 1 |
---|---|
2nd row | 1 |
3rd row | 2 |
4th row | 1 |
5th row | 1 |
Common Values
Value | Count | Frequency (%) |
1 | 107 | |
2 | 77 | |
3 | 15 | 7.5% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 107 | |
2 | 77 | |
3 | 15 | 7.5% |
15963
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 199 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 35957.96 |
Minimum | 7836 |
---|---|
Maximum | 132965 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.9 KiB |
Quantile statistics
Minimum | 7836 |
---|---|
5-th percentile | 19915.4 |
Q1 | 25116 |
median | 31346 |
Q3 | 41626 |
95-th percentile | 61018 |
Maximum | 132965 |
Range | 125129 |
Interquartile range (IQR) | 16510 |
Descriptive statistics
Standard deviation | 16339.962 |
---|---|
Coefficient of variation (CV) | 0.4544185 |
Kurtosis | 8.6818836 |
Mean | 35957.96 |
Median Absolute Deviation (MAD) | 7652 |
Skewness | 2.340958 |
Sum | 7155634 |
Variance | 2.6699437 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
30918 | 1 | 0.5% |
31346 | 1 | 0.5% |
46739 | 1 | 0.5% |
39026 | 1 | 0.5% |
42243 | 1 | 0.5% |
41415 | 1 | 0.5% |
49861 | 1 | 0.5% |
30108 | 1 | 0.5% |
42331 | 1 | 0.5% |
50637 | 1 | 0.5% |
Other values (189) | 189 |
Value | Count | Frequency (%) |
7836 | 1 | |
14581 | 1 | |
14881 | 1 | |
15800 | 1 | |
16891 | 1 | |
16894 | 1 | |
18002 | 1 | |
19616 | 1 | |
19746 | 1 | |
19793 | 1 |
Value | Count | Frequency (%) |
132965 | 1 | |
104306 | 1 | |
102634 | 1 | |
91166 | 1 | |
89826 | 1 | |
78312 | 1 | |
69495 | 1 | |
64886 | 1 | |
64516 | 1 | |
63718 | 1 |
106.967 | 1 | 15963 | |
---|---|---|---|
106.967 | 1.000 | 0.913 | 0.993 |
1 | 0.913 | 1.000 | 1.000 |
15963 | 0.993 | 1.000 | 1.000 |
106.967 | 15963 | 1 | |
---|---|---|---|
106.967 | 1.000 | 1.000 | 0.859 |
15963 | 1.000 | 1.000 | 0.979 |
1 | 0.859 | 0.979 | 1.000 |
A000000001 | CB0100101000101 | 4311110700 | 202108 | 106.967 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 1 | 15963 | |
---|---|---|---|---|---|---|---|---|---|---|
0 | A000000001 | CB0100101000102 | 4311110700 | 202108 | 283.304 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 1 | 30918 |
1 | A000000001 | CB0100101000104 | 4311110700 | 202108 | 216.245 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 1 | 25230 |
2 | A000000001 | CB0100101000105 | 4311110700 | 202108 | 348.381 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 2 | 40071 |
3 | A000000001 | CB0100101000106 | 4311110700 | 202108 | 90.658 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 1 | 14581 |
4 | A000000001 | CB0100101000201 | 4311110700 | 202108 | 203.313 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 1 | 24134 |
5 | A000000001 | CB0100101000203 | 4311110700 | 202108 | 369.23 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 2 | 43476 |
6 | A000000001 | CB0100101000206 | 4311110700 | 202108 | 105.042 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 1 | 15800 |
7 | A000000001 | CB0100101000208 | 4311110700 | 202108 | 287.225 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 1 | 31252 |
8 | A000000001 | CB0100101000302 | 4311110700 | 202108 | 203.122 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 1 | 24118 |
9 | A000000001 | CB0100101000307 | 4311110700 | 202108 | 425.732 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 2 | 52704 |
A000000001 | CB0100101000101 | 4311110700 | 202108 | 106.967 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 1 | 15963 | |
---|---|---|---|---|---|---|---|---|---|---|
189 | A000000001 | CB0100106001101 | 4311110700 | 202108 | 341.402 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 2 | 38932 |
190 | A000000001 | CB0100106001103 | 4311110700 | 202108 | 234.574 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 1 | 26788 |
191 | A000000001 | CB0100106001203 | 4311110700 | 202108 | 241.12 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 1 | 27341 |
192 | A000000001 | CB0100106001205 | 4311110700 | 202108 | 302.677 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 2 | 32612 |
193 | A000000001 | CB0100106001501 | 4311110700 | 202108 | 189.843 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 1 | 22993 |
194 | A000000001 | CB0100106001505 | 4311110700 | 202108 | 339.025 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 2 | 38545 |
195 | A000000001 | CB0100107000101 | 4311110700 | 202108 | 284.894 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 1 | 31055 |
196 | A000000001 | CB0100107000104 | 4311110700 | 202108 | 321.851 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 2 | 35743 |
197 | A000000001 | CB0100107000203 | 4311110700 | 202108 | 237.267 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 1 | 27014 |
198 | A000000001 | CB0100107000204 | 4311110700 | 202108 | 248.94 | 100 주택용전력 | 주택용 고압 | 4 단일계약아파트 | 1 | 28005 |