Dataset statistics
Number of variables | 6 |
---|---|
Number of observations | 200 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 10.5 KiB |
Average record size in memory | 53.7 B |
Variable types
Categorical | 4 |
---|---|
Numeric | 2 |
Dataset
Description | Sample |
---|---|
Author | 한국스마트그리드 |
URL | https://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=KSG2019111100AMUS02a |
toc_no has constant value "" | Constant |
mesure_ym has constant value "" | Constant |
legal_dong_cd has constant value "" | Constant |
all_pwrer_use_am has constant value "" | Constant |
cnsmr_no has unique values | Unique |
Reproduction
Analysis started | 2023-12-10 06:14:35.305676 |
---|---|
Analysis finished | 2023-12-10 06:14:36.234093 |
Duration | 0.93 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
toc_no
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
A000000002 |
---|
Length
Max length | 10 |
---|---|
Median length | 10 |
Mean length | 10 |
Min length | 10 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | A000000002 |
---|---|
2nd row | A000000002 |
3rd row | A000000002 |
4th row | A000000002 |
5th row | A000000002 |
Common Values
Value | Count | Frequency (%) |
A000000002 | 200 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
a000000002 | 200 |
cnsmr_no
Real number (ℝ)
UNIQUE
 
Distinct | 200 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 3.4107203 × 109 |
Minimum | 3.41072 × 109 |
---|---|
Maximum | 3.4107206 × 109 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.9 KiB |
Quantile statistics
Minimum | 3.41072 × 109 |
---|---|
5-th percentile | 3.41072 × 109 |
Q1 | 3.4107201 × 109 |
median | 3.4107203 × 109 |
Q3 | 3.4107205 × 109 |
95-th percentile | 3.4107206 × 109 |
Maximum | 3.4107206 × 109 |
Range | 615 |
Interquartile range (IQR) | 334.75 |
Descriptive statistics
Standard deviation | 187.01616 |
---|---|
Coefficient of variation (CV) | 5.4831867 × 10-8 |
Kurtosis | -1.303755 |
Mean | 3.4107203 × 109 |
Median Absolute Deviation (MAD) | 167.5 |
Skewness | 0.024330996 |
Sum | 6.8214406 × 1011 |
Variance | 34975.045 |
Monotonicity | Strictly increasing |
Value | Count | Frequency (%) |
3410720004 | 1 | 0.5% |
3410720432 | 1 | 0.5% |
3410720400 | 1 | 0.5% |
3410720403 | 1 | 0.5% |
3410720404 | 1 | 0.5% |
3410720406 | 1 | 0.5% |
3410720409 | 1 | 0.5% |
3410720411 | 1 | 0.5% |
3410720412 | 1 | 0.5% |
3410720423 | 1 | 0.5% |
Other values (190) | 190 |
Value | Count | Frequency (%) |
3410720004 | 1 | |
3410720011 | 1 | |
3410720014 | 1 | |
3410720019 | 1 | |
3410720020 | 1 | |
3410720023 | 1 | |
3410720028 | 1 | |
3410720031 | 1 | |
3410720032 | 1 | |
3410720033 | 1 |
Value | Count | Frequency (%) |
3410720619 | 1 | |
3410720618 | 1 | |
3410720617 | 1 | |
3410720613 | 1 | |
3410720611 | 1 | |
3410720609 | 1 | |
3410720604 | 1 | |
3410720603 | 1 | |
3410720599 | 1 | |
3410720596 | 1 |
mesure_ym
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
201910 |
---|
Length
Max length | 6 |
---|---|
Median length | 6 |
Mean length | 6 |
Min length | 6 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 201910 |
---|---|
2nd row | 201910 |
3rd row | 201910 |
4th row | 201910 |
5th row | 201910 |
Common Values
Value | Count | Frequency (%) |
201910 | 200 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
201910 | 200 |
legal_dong_cd
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
2653010400 |
---|
Length
Max length | 10 |
---|---|
Median length | 10 |
Mean length | 10 |
Min length | 10 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2653010400 |
---|---|
2nd row | 2653010400 |
3rd row | 2653010400 |
4th row | 2653010400 |
5th row | 2653010400 |
Common Values
Value | Count | Frequency (%) |
2653010400 | 200 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2653010400 | 200 |
sg_pwrer_use_am
Real number (ℝ)
Distinct | 196 |
---|---|
Distinct (%) | 98.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 207.4335 |
Minimum | 0 |
---|---|
Maximum | 1118.3 |
Zeros | 2 |
Zeros (%) | 1.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.9 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 44.2 |
Q1 | 117.55 |
median | 200.25 |
Q3 | 273.575 |
95-th percentile | 438.085 |
Maximum | 1118.3 |
Range | 1118.3 |
Interquartile range (IQR) | 156.025 |
Descriptive statistics
Standard deviation | 131.96901 |
---|---|
Coefficient of variation (CV) | 0.63619911 |
Kurtosis | 11.079449 |
Mean | 207.4335 |
Median Absolute Deviation (MAD) | 81.15 |
Skewness | 2.0907312 |
Sum | 41486.7 |
Variance | 17415.819 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
145.0 | 2 | 1.0% |
331.0 | 2 | 1.0% |
0.0 | 2 | 1.0% |
221.1 | 2 | 1.0% |
262.5 | 1 | 0.5% |
164.2 | 1 | 0.5% |
48.6 | 1 | 0.5% |
130.7 | 1 | 0.5% |
261.2 | 1 | 0.5% |
272.7 | 1 | 0.5% |
Other values (186) | 186 |
Value | Count | Frequency (%) |
0.0 | 2 | |
1.4 | 1 | |
2.4 | 1 | |
12.5 | 1 | |
28.3 | 1 | |
31.0 | 1 | |
36.3 | 1 | |
37.5 | 1 | |
42.3 | 1 | |
44.3 | 1 |
Value | Count | Frequency (%) |
1118.3 | 1 | |
691.5 | 1 | |
540.6 | 1 | |
501.0 | 1 | |
487.2 | 1 | |
464.2 | 1 | |
457.6 | 1 | |
453.4 | 1 | |
453.3 | 1 | |
439.7 | 1 |
all_pwrer_use_am
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 200 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 200 |
cnsmr_no | sg_pwrer_use_am | |
---|---|---|
cnsmr_no | 1.000 | 0.185 |
sg_pwrer_use_am | 0.185 | 1.000 |
cnsmr_no | sg_pwrer_use_am | |
---|---|---|
cnsmr_no | 1.000 | -0.092 |
sg_pwrer_use_am | -0.092 | 1.000 |
toc_no | cnsmr_no | mesure_ym | legal_dong_cd | sg_pwrer_use_am | all_pwrer_use_am | |
---|---|---|---|---|---|---|
0 | A000000002 | 3410720004 | 201910 | 2653010400 | 262.5 | 0 |
1 | A000000002 | 3410720011 | 201910 | 2653010400 | 266.0 | 0 |
2 | A000000002 | 3410720014 | 201910 | 2653010400 | 184.6 | 0 |
3 | A000000002 | 3410720019 | 201910 | 2653010400 | 259.2 | 0 |
4 | A000000002 | 3410720020 | 201910 | 2653010400 | 59.6 | 0 |
5 | A000000002 | 3410720023 | 201910 | 2653010400 | 313.7 | 0 |
6 | A000000002 | 3410720028 | 201910 | 2653010400 | 157.9 | 0 |
7 | A000000002 | 3410720031 | 201910 | 2653010400 | 108.6 | 0 |
8 | A000000002 | 3410720032 | 201910 | 2653010400 | 306.1 | 0 |
9 | A000000002 | 3410720033 | 201910 | 2653010400 | 60.8 | 0 |
toc_no | cnsmr_no | mesure_ym | legal_dong_cd | sg_pwrer_use_am | all_pwrer_use_am | |
---|---|---|---|---|---|---|
190 | A000000002 | 3410720596 | 201910 | 2653010400 | 221.1 | 0 |
191 | A000000002 | 3410720599 | 201910 | 2653010400 | 167.6 | 0 |
192 | A000000002 | 3410720603 | 201910 | 2653010400 | 128.2 | 0 |
193 | A000000002 | 3410720604 | 201910 | 2653010400 | 187.2 | 0 |
194 | A000000002 | 3410720609 | 201910 | 2653010400 | 271.6 | 0 |
195 | A000000002 | 3410720611 | 201910 | 2653010400 | 307.4 | 0 |
196 | A000000002 | 3410720613 | 201910 | 2653010400 | 187.9 | 0 |
197 | A000000002 | 3410720617 | 201910 | 2653010400 | 309.8 | 0 |
198 | A000000002 | 3410720618 | 201910 | 2653010400 | 145.0 | 0 |
199 | A000000002 | 3410720619 | 201910 | 2653010400 | 107.1 | 0 |