Overview

Dataset statistics

Number of variables28
Number of observations200
Missing cells248
Missing cells (%)4.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory45.4 KiB
Average record size in memory232.7 B

Variable types

Categorical20
Text2
Numeric5
Unsupported1

Dataset

DescriptionSample
Author한국스마트그리드
URLhttps://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=KSG2019111100EMCU01a

Alerts

토지면적 has constant value ""Constant
산업분류코드 is highly imbalanced (55.6%)Imbalance
건물용도구분코드 is highly imbalanced (52.9%)Imbalance
건물층수 is highly imbalanced (87.6%)Imbalance
요금제 시작 일자 has 200 (100.0%) missing valuesMissing
업종명 has 48 (24.0%) missing valuesMissing
수용가 번호 has unique valuesUnique
요금제 시작 일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
연면적 has 80 (40.0%) zerosZeros

Reproduction

Analysis started2023-12-10 06:28:05.293106
Analysis finished2023-12-10 06:28:05.900710
Duration0.61 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

통합운영센터 번호
Categorical

Distinct4
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
E000000004
127 
E000000002
43 
E000000001
21 
E000000003
 
9

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowE000000004
2nd rowE000000004
3rd rowE000000004
4th rowE000000004
5th rowE000000004

Common Values

ValueCountFrequency (%)
E000000004 127
63.5%
E000000002 43
 
21.5%
E000000001 21
 
10.5%
E000000003 9
 
4.5%

Length

2023-12-10T15:28:06.021030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:28:06.208118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
e000000004 127
63.5%
e000000002 43
 
21.5%
e000000001 21
 
10.5%
e000000003 9
 
4.5%

수용가 번호
Text

UNIQUE 

Distinct200
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2023-12-10T15:28:06.567212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length4
Mean length8.1
Min length3

Characters and Unicode

Total characters1620
Distinct characters30
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique200 ?
Unique (%)100.0%

Sample

1st row1264
2nd row1265
3rd row1276
4th row1277
5th row1280
ValueCountFrequency (%)
1264 1
 
0.5%
1165 1
 
0.5%
1294 1
 
0.5%
1080 1
 
0.5%
1082 1
 
0.5%
1086 1
 
0.5%
1150 1
 
0.5%
1157 1
 
0.5%
1158 1
 
0.5%
1161 1
 
0.5%
Other values (190) 190
95.0%
2023-12-10T15:28:07.171998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 531
32.8%
1 284
17.5%
3 121
 
7.5%
2 101
 
6.2%
5 78
 
4.8%
6 73
 
4.5%
4 68
 
4.2%
C 65
 
4.0%
M 51
 
3.1%
8 48
 
3.0%
Other values (20) 200
 
12.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1396
86.2%
Uppercase Letter 224
 
13.8%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
C 65
29.0%
M 51
22.8%
I 44
19.6%
K 14
 
6.2%
S 11
 
4.9%
O 6
 
2.7%
J 5
 
2.2%
H 5
 
2.2%
P 5
 
2.2%
E 3
 
1.3%
Other values (10) 15
 
6.7%
Decimal Number
ValueCountFrequency (%)
0 531
38.0%
1 284
20.3%
3 121
 
8.7%
2 101
 
7.2%
5 78
 
5.6%
6 73
 
5.2%
4 68
 
4.9%
8 48
 
3.4%
9 46
 
3.3%
7 46
 
3.3%

Most occurring scripts

ValueCountFrequency (%)
Common 1396
86.2%
Latin 224
 
13.8%

Most frequent character per script

Latin
ValueCountFrequency (%)
C 65
29.0%
M 51
22.8%
I 44
19.6%
K 14
 
6.2%
S 11
 
4.9%
O 6
 
2.7%
J 5
 
2.2%
H 5
 
2.2%
P 5
 
2.2%
E 3
 
1.3%
Other values (10) 15
 
6.7%
Common
ValueCountFrequency (%)
0 531
38.0%
1 284
20.3%
3 121
 
8.7%
2 101
 
7.2%
5 78
 
5.6%
6 73
 
5.2%
4 68
 
4.9%
8 48
 
3.4%
9 46
 
3.3%
7 46
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1620
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 531
32.8%
1 284
17.5%
3 121
 
7.5%
2 101
 
6.2%
5 78
 
4.8%
6 73
 
4.5%
4 68
 
4.2%
C 65
 
4.0%
M 51
 
3.1%
8 48
 
3.0%
Other values (20) 200
 
12.3%

산업분류코드
Categorical

IMBALANCE 

Distinct23
Distinct (%)11.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
<NA>
127 
40 
20129
 
4
10620
 
3
23311
 
2
Other values (18)
24 

Length

Max length5
Median length4
Mean length3.565
Min length1

Unique

Unique12 ?
Unique (%)6.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 127
63.5%
40
 
20.0%
20129 4
 
2.0%
10620 3
 
1.5%
23311 2
 
1.0%
86101 2
 
1.0%
51100 2
 
1.0%
13999 2
 
1.0%
22299 2
 
1.0%
20131 2
 
1.0%
Other values (13) 14
 
7.0%

Length

2023-12-10T15:28:07.419504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 127
79.4%
20129 4
 
2.5%
10620 3
 
1.9%
23311 2
 
1.2%
86101 2
 
1.2%
51100 2
 
1.2%
13999 2
 
1.2%
22299 2
 
1.2%
20131 2
 
1.2%
13993 2
 
1.2%
Other values (12) 12
 
7.5%

건물효율유형코드
Categorical

Distinct4
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
<NA>
126 
38 
2
35 
1
 
1

Length

Max length4
Median length4
Mean length2.89
Min length1

Unique

Unique1 ?
Unique (%)0.5%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 126
63.0%
38
 
19.0%
2 35
 
17.5%
1 1
 
0.5%

Length

2023-12-10T15:28:07.639786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:28:07.848278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 126
77.8%
2 35
 
21.6%
1 1
 
0.6%

건물시설군코드
Categorical

Distinct8
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
<NA>
123 
2
48 
18 
5
 
3
9
 
3
Other values (3)
 
5

Length

Max length4
Median length4
Mean length2.845
Min length1

Unique

Unique2 ?
Unique (%)1.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 123
61.5%
2 48
 
24.0%
18
 
9.0%
5 3
 
1.5%
9 3
 
1.5%
6 3
 
1.5%
7 1
 
0.5%
1 1
 
0.5%

Length

2023-12-10T15:28:08.089640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:28:08.316868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 123
67.6%
2 48
 
26.4%
5 3
 
1.6%
9 3
 
1.6%
6 3
 
1.6%
7 1
 
0.5%
1 1
 
0.5%

건물용도구분코드
Categorical

IMBALANCE 

Distinct12
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
<NA>
123 
23
46 
18 
25
 
2
21
 
2
Other values (7)
 
9

Length

Max length4
Median length4
Mean length3.14
Min length1

Unique

Unique5 ?
Unique (%)2.5%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 123
61.5%
23 46
 
23.0%
18
 
9.0%
25 2
 
1.0%
21 2
 
1.0%
63 2
 
1.0%
61 2
 
1.0%
22 1
 
0.5%
44 1
 
0.5%
51 1
 
0.5%
Other values (2) 2
 
1.0%

Length

2023-12-10T15:28:08.534725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 123
67.6%
23 46
 
25.3%
25 2
 
1.1%
21 2
 
1.1%
63 2
 
1.1%
61 2
 
1.1%
22 1
 
0.5%
44 1
 
0.5%
51 1
 
0.5%
11 1
 
0.5%

온실가스목표관리대상여부
Categorical

Distinct4
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
<NA>
126 
N
27 
Y
26 
21 

Length

Max length4
Median length4
Mean length2.89
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 126
63.0%
N 27
 
13.5%
Y 26
 
13.0%
21
 
10.5%

Length

2023-12-10T15:28:08.770251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:28:08.970671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 126
70.4%
n 27
 
15.1%
y 26
 
14.5%

피크제어기설치여부
Categorical

Distinct3
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
N
157 
Y
24 
19 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowN
2nd rowN
3rd rowN
4th rowN
5th rowN

Common Values

ValueCountFrequency (%)
N 157
78.5%
Y 24
 
12.0%
19
 
9.5%

Length

2023-12-10T15:28:09.146434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:28:09.327299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
n 157
86.7%
y 24
 
13.3%

법정동코드
Real number (ℝ)

Distinct66
Distinct (%)33.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.1919708 × 109
Minimum1.1170128 × 109
Maximum5.0130119 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:28:09.553735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.1170128 × 109
5-th percentile2.711 × 109
Q12.723 × 109
median2.729 × 109
Q34.1302476 × 109
95-th percentile4.7152118 × 109
Maximum5.0130119 × 109
Range3.8959991 × 109
Interquartile range (IQR)1.4072476 × 109

Descriptive statistics

Standard deviation8.140158 × 108
Coefficient of variation (CV)0.25501981
Kurtosis-0.29709693
Mean3.1919708 × 109
Median Absolute Deviation (MAD)42000000
Skewness0.78722607
Sum6.3839417 × 1011
Variance6.6262173 × 1017
MonotonicityNot monotonic
2023-12-10T15:28:09.827708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2729000000 38
19.0%
2771000000 33
16.5%
2717000000 15
 
7.5%
2723000000 11
 
5.5%
2711000000 11
 
5.5%
2714000000 8
 
4.0%
2726000000 7
 
3.5%
2720000000 4
 
2.0%
3171025000 4
 
2.0%
4313011900 3
 
1.5%
Other values (56) 66
33.0%
ValueCountFrequency (%)
1117012800 1
 
0.5%
1150010800 2
 
1.0%
2623010100 1
 
0.5%
2626010200 1
 
0.5%
2629011100 1
 
0.5%
2635010500 1
 
0.5%
2653010400 1
 
0.5%
2711000000 11
5.5%
2714000000 8
4.0%
2717000000 15
7.5%
ValueCountFrequency (%)
5013011900 1
 
0.5%
5013011600 1
 
0.5%
5011013700 1
 
0.5%
4833011300 1
 
0.5%
4812312900 1
 
0.5%
4723012800 1
 
0.5%
4719012300 1
 
0.5%
4719011300 3
1.5%
4715011800 3
1.5%
4713038027 1
 
0.5%

요금제
Categorical

Distinct12
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
산업용전력(을)
65 
43 
<NA>
32 
일반용전력(을)
17 
일반용전력(갑)Ⅰ
12 
Other values (7)
31 

Length

Max length11
Median length9
Mean length6.15
Min length1

Unique

Unique2 ?
Unique (%)1.0%

Sample

1st row산업용전력(을)
2nd row일반용전력(갑)Ⅰ
3rd row일반용전력(갑)Ⅰ
4th row일반용전력(을)
5th row<NA>

Common Values

ValueCountFrequency (%)
산업용전력(을) 65
32.5%
43
21.5%
<NA> 32
16.0%
일반용전력(을) 17
 
8.5%
일반용전력(갑)Ⅰ 12
 
6.0%
산업용 전력(갑) 1 9
 
4.5%
산업용전력(갑)Ⅱ 7
 
3.5%
일반용전력(갑)Ⅱ 7
 
3.5%
주택용전력(고압) 4
 
2.0%
산업용전력(갑)Ⅰ 2
 
1.0%
Other values (2) 2
 
1.0%

Length

2023-12-10T15:28:10.062775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
산업용전력(을 65
37.1%
na 32
18.3%
일반용전력(을 17
 
9.7%
일반용전력(갑)ⅰ 12
 
6.9%
산업용 9
 
5.1%
전력(갑 9
 
5.1%
1 9
 
5.1%
산업용전력(갑)ⅱ 7
 
4.0%
일반용전력(갑)ⅱ 7
 
4.0%
주택용전력(고압 4
 
2.3%
Other values (3) 4
 
2.3%

요금제 전압 구분
Categorical

Distinct8
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
선택Ⅱ
72 
46 
<NA>
32 
없음
16 
선택(Ⅱ)
14 
Other values (3)
20 

Length

Max length5
Median length4
Mean length2.755
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row선택Ⅱ
2nd row없음
3rd row선택Ⅰ
4th row선택Ⅱ
5th row<NA>

Common Values

ValueCountFrequency (%)
선택Ⅱ 72
36.0%
46
23.0%
<NA> 32
16.0%
없음 16
 
8.0%
선택(Ⅱ) 14
 
7.0%
전력 9
 
4.5%
선택Ⅰ 7
 
3.5%
선택(Ⅲ) 4
 
2.0%

Length

2023-12-10T15:28:10.300433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:28:10.532177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
선택ⅱ 72
46.8%
na 32
20.8%
없음 16
 
10.4%
선택(ⅱ 14
 
9.1%
전력 9
 
5.8%
선택ⅰ 7
 
4.5%
선택(ⅲ 4
 
2.6%

요금제 선택 구분
Categorical

Distinct6
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
고압A
88 
46 
<NA>
32 
저압
22 
고압B
9 

Length

Max length4
Median length3
Mean length2.605
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row고압A
2nd row저압
3rd row고압A
4th row고압A
5th row<NA>

Common Values

ValueCountFrequency (%)
고압A 88
44.0%
46
23.0%
<NA> 32
 
16.0%
저압 22
 
11.0%
고압B 9
 
4.5%
구분없음 3
 
1.5%

Length

2023-12-10T15:28:10.767316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:28:10.946683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
고압a 88
57.1%
na 32
 
20.8%
저압 22
 
14.3%
고압b 9
 
5.8%
구분없음 3
 
1.9%

수용가 타입 번호
Categorical

Distinct2
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
FT
129 
BD
71 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowFT
2nd rowFT
3rd rowBD
4th rowBD
5th rowBD

Common Values

ValueCountFrequency (%)
FT 129
64.5%
BD 71
35.5%

Length

2023-12-10T15:28:11.149630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:28:11.312326image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
ft 129
64.5%
bd 71
35.5%

요금제 시작 일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing200
Missing (%)100.0%
Memory size1.9 KiB

스마트그리드 보급지원 계약 시작일자
Categorical

Distinct2
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
<NA>
127 
73 

Length

Max length4
Median length4
Mean length2.905
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 127
63.5%
73
36.5%

Length

2023-12-10T15:28:11.506471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:28:11.694382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 127
100.0%

스마트그리드 보급지원 계약 종료일자
Categorical

Distinct49
Distinct (%)24.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
20251231
109 
<NA>
18 
13 
20240401
 
6
20200731
 
3
Other values (44)
51 

Length

Max length8
Median length8
Mean length7.18
Min length1

Unique

Unique39 ?
Unique (%)19.5%

Sample

1st row20251231
2nd row20251231
3rd row20251231
4th row20251231
5th row20251231

Common Values

ValueCountFrequency (%)
20251231 109
54.5%
<NA> 18
 
9.0%
13
 
6.5%
20240401 6
 
3.0%
20200731 3
 
1.5%
20171130 3
 
1.5%
20180630 3
 
1.5%
20210730 2
 
1.0%
20210731 2
 
1.0%
20200331 2
 
1.0%
Other values (39) 39
 
19.5%

Length

2023-12-10T15:28:11.903521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
20251231 109
58.3%
na 18
 
9.6%
20240401 6
 
3.2%
20200731 3
 
1.6%
20171130 3
 
1.6%
20180630 3
 
1.6%
20210731 2
 
1.1%
20200331 2
 
1.1%
20210730 2
 
1.1%
20200924 1
 
0.5%
Other values (38) 38
 
20.3%

스마트그리드 보급지원 계약 상태코드
Categorical

Distinct3
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
Y
127 
1
71 
2
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowY
2nd rowY
3rd rowY
4th rowY
5th rowY

Common Values

ValueCountFrequency (%)
Y 127
63.5%
1 71
35.5%
2 2
 
1.0%

Length

2023-12-10T15:28:12.098835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:28:12.283515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
y 127
63.5%
1 71
35.5%
2 2
 
1.0%

전체전력량정보구분코드
Categorical

Distinct5
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2
63 
1
49 
Z
42 
30 
3
16 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row3
3rd row2
4th row1
5th row1

Common Values

ValueCountFrequency (%)
2 63
31.5%
1 49
24.5%
Z 42
21.0%
30
15.0%
3 16
 
8.0%

Length

2023-12-10T15:28:12.438075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:28:12.623273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 63
37.1%
1 49
28.8%
z 42
24.7%
3 16
 
9.4%

등록일시
Real number (ℝ)

Distinct150
Distinct (%)75.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0179417 × 1013
Minimum2.0170125 × 1013
Maximum2.0191218 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:28:12.843319image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0170125 × 1013
5-th percentile2.0170125 × 1013
Q12.0171194 × 1013
median2.0180421 × 1013
Q32.0180516 × 1013
95-th percentile2.0190222 × 1013
Maximum2.0191218 × 1013
Range2.1092949 × 1010
Interquartile range (IQR)9.3224382 × 109

Descriptive statistics

Standard deviation6.3775864 × 109
Coefficient of variation (CV)0.00031604413
Kurtosis-0.52967708
Mean2.0179417 × 1013
Median Absolute Deviation (MAD)2.000196 × 108
Skewness0.04736415
Sum4.0358835 × 1015
Variance4.0673609 × 1019
MonotonicityNot monotonic
2023-12-10T15:28:13.069561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20170125162121 23
 
11.5%
20180516112800 15
 
7.5%
20170125162122 10
 
5.0%
20191218111146 6
 
3.0%
20180427121044 1
 
0.5%
20180221115624 1
 
0.5%
20171010114038 1
 
0.5%
20180313111020 1
 
0.5%
20180313111320 1
 
0.5%
20180313113727 1
 
0.5%
Other values (140) 140
70.0%
ValueCountFrequency (%)
20170125162121 23
11.5%
20170125162122 10
5.0%
20170210163636 1
 
0.5%
20170215113906 1
 
0.5%
20170215113955 1
 
0.5%
20170320162817 1
 
0.5%
20170327093311 1
 
0.5%
20170327095757 1
 
0.5%
20170327170920 1
 
0.5%
20170327175148 1
 
0.5%
ValueCountFrequency (%)
20191218111146 6
3.0%
20190305113310 1
 
0.5%
20190222200019 1
 
0.5%
20190222193344 1
 
0.5%
20190222174741 1
 
0.5%
20190222170018 1
 
0.5%
20190221114754 1
 
0.5%
20190221113905 1
 
0.5%
20190221113500 1
 
0.5%
20190221105616 1
 
0.5%

수정일시
Real number (ℝ)

Distinct177
Distinct (%)88.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0185353 × 1013
Minimum2.0170508 × 1013
Maximum2.0210218 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:28:13.661095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0170508 × 1013
5-th percentile2.0180122 × 1013
Q12.0180516 × 1013
median2.0181212 × 1013
Q32.0190422 × 1013
95-th percentile2.0191022 × 1013
Maximum2.0210218 × 1013
Range3.971001 × 1010
Interquartile range (IQR)9.9054814 × 109

Descriptive statistics

Standard deviation5.6989004 × 109
Coefficient of variation (CV)0.00028232851
Kurtosis0.71613099
Mean2.0185353 × 1013
Median Absolute Deviation (MAD)1.0899206 × 109
Skewness0.5641956
Sum4.0370705 × 1015
Variance3.2477466 × 1019
MonotonicityNot monotonic
2023-12-10T15:28:13.929812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20180516112800 15
 
7.5%
20191218111146 6
 
3.0%
20180710144245 5
 
2.5%
20190320160238 1
 
0.5%
20180508143446 1
 
0.5%
20190320160117 1
 
0.5%
20190320160137 1
 
0.5%
20190320160108 1
 
0.5%
20170516212709 1
 
0.5%
20180409092526 1
 
0.5%
Other values (167) 167
83.5%
ValueCountFrequency (%)
20170508155225 1
0.5%
20170516212709 1
0.5%
20180122171925 1
0.5%
20180122172006 1
0.5%
20180122172040 1
0.5%
20180122172219 1
0.5%
20180122172311 1
0.5%
20180122172929 1
0.5%
20180122174228 1
0.5%
20180122174707 1
0.5%
ValueCountFrequency (%)
20210218165440 1
 
0.5%
20201016162621 1
 
0.5%
20201016142821 1
 
0.5%
20200331174457 1
 
0.5%
20191218111146 6
3.0%
20191011231502 1
 
0.5%
20191010095719 1
 
0.5%
20191010094152 1
 
0.5%
20191008174358 1
 
0.5%
20190713221456 1
 
0.5%

적재일시
Real number (ℝ)

Distinct53
Distinct (%)26.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0191632 × 1013
Minimum2.0181207 × 1013
Maximum2.0210303 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:28:14.187875image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0181207 × 1013
5-th percentile2.0181207 × 1013
Q12.019032 × 1013
median2.0190405 × 1013
Q32.019051 × 1013
95-th percentile2.0210303 × 1013
Maximum2.0210303 × 1013
Range2.9095971 × 1010
Interquartile range (IQR)1.9000032 × 108

Descriptive statistics

Standard deviation7.3779123 × 109
Coefficient of variation (CV)0.00036539455
Kurtosis1.6985804
Mean2.0191632 × 1013
Median Absolute Deviation (MAD)1.050417 × 108
Skewness1.2682475
Sum4.0383264 × 1015
Variance5.4433589 × 1019
MonotonicityNot monotonic
2023-12-10T15:28:14.463980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20190405123647 22
 
11.0%
20210303075505 18
 
9.0%
20190510175353 16
 
8.0%
20190405023002 14
 
7.0%
20181224103150 13
 
6.5%
20181207104513 12
 
6.0%
20190510165352 11
 
5.5%
20200515163935 9
 
4.5%
20190405155559 6
 
3.0%
20190405071523 6
 
3.0%
Other values (43) 73
36.5%
ValueCountFrequency (%)
20181207104513 12
6.0%
20181224101715 3
 
1.5%
20181224103150 13
6.5%
20190125155603 2
 
1.0%
20190125215021 1
 
0.5%
20190126135023 3
 
1.5%
20190126165042 2
 
1.0%
20190128115030 1
 
0.5%
20190221115040 1
 
0.5%
20190221125026 3
 
1.5%
ValueCountFrequency (%)
20210303075505 18
9.0%
20210218175021 1
 
0.5%
20201016175024 1
 
0.5%
20201016155022 1
 
0.5%
20200515163935 9
4.5%
20200511090025 1
 
0.5%
20191012005035 1
 
0.5%
20191010105059 2
 
1.0%
20191008185023 1
 
0.5%
20190712225019 2
 
1.0%

토지면적
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
0
200 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 200
100.0%

Length

2023-12-10T15:28:14.687722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:28:14.856106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 200
100.0%

건물층수
Categorical

IMBALANCE 

Distinct5
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
0
193 
3
 
2
2
 
2
6
 
2
5
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)0.5%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 193
96.5%
3 2
 
1.0%
2 2
 
1.0%
6 2
 
1.0%
5 1
 
0.5%

Length

2023-12-10T15:28:15.030478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:28:15.228900image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 193
96.5%
3 2
 
1.0%
2 2
 
1.0%
6 2
 
1.0%
5 1
 
0.5%

연면적
Real number (ℝ)

ZEROS 

Distinct119
Distinct (%)59.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20104.701
Minimum0
Maximum1960484
Zeros80
Zeros (%)40.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:28:15.449358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1567
Q37914
95-th percentile40238.5
Maximum1960484
Range1960484
Interquartile range (IQR)7914

Descriptive statistics

Standard deviation142297.19
Coefficient of variation (CV)7.077807
Kurtosis176.26171
Mean20104.701
Median Absolute Deviation (MAD)1567
Skewness12.975141
Sum4020940.2
Variance2.0248491 × 1010
MonotonicityNot monotonic
2023-12-10T15:28:15.733292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 80
40.0%
42509.0 2
 
1.0%
12637.0 2
 
1.0%
818.0 1
 
0.5%
3709.0 1
 
0.5%
8728.0 1
 
0.5%
27838.0 1
 
0.5%
2073.0 1
 
0.5%
7889.0 1
 
0.5%
21432.0 1
 
0.5%
Other values (109) 109
54.5%
ValueCountFrequency (%)
0.0 80
40.0%
10.0 1
 
0.5%
15.52 1
 
0.5%
191.14 1
 
0.5%
198.0 1
 
0.5%
530.0 1
 
0.5%
593.92 1
 
0.5%
752.0 1
 
0.5%
753.0 1
 
0.5%
818.0 1
 
0.5%
ValueCountFrequency (%)
1960484.0 1
0.5%
377185.0 1
0.5%
252635.0 1
0.5%
127505.0 1
0.5%
123552.0 1
0.5%
66562.0 1
0.5%
51712.0 1
0.5%
47000.0 1
0.5%
42509.0 2
1.0%
40119.0 1
0.5%

업종명
Text

MISSING 

Distinct53
Distinct (%)34.9%
Missing48
Missing (%)24.0%
Memory size1.7 KiB
2023-12-10T15:28:16.078273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length10
Mean length3.1644737
Min length1

Characters and Unicode

Total characters481
Distinct characters87
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique38 ?
Unique (%)25.0%

Sample

1st row제조
2nd row제조업
3rd row복지관
4th row제조업
5th row요양원
ValueCountFrequency (%)
제조업 44
31.9%
제조 18
 
13.0%
운수 6
 
4.3%
복지관 4
 
2.9%
섬유제조 3
 
2.2%
학술연구용역 3
 
2.2%
비영리법인 3
 
2.2%
공원 3
 
2.2%
시설 2
 
1.4%
자동차부품 2
 
1.4%
Other values (44) 50
36.2%
2023-12-10T15:28:16.569535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
제 72
 
15.0%
조 72
 
15.0%
업 55
 
11.4%
30
 
6.2%
시 10
 
2.1%
관 10
 
2.1%
품 9
 
1.9%
설 9
 
1.9%
공 8
 
1.7%
운 7
 
1.5%
Other values (77) 199
41.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 446
92.7%
Space Separator 30
 
6.2%
Close Punctuation 2
 
0.4%
Open Punctuation 2
 
0.4%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
제 72
 
16.1%
조 72
 
16.1%
업 55
 
12.3%
시 10
 
2.2%
관 10
 
2.2%
품 9
 
2.0%
설 9
 
2.0%
공 8
 
1.8%
운 7
 
1.6%
유 7
 
1.6%
Other values (73) 187
41.9%
Space Separator
ValueCountFrequency (%)
30
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Other Punctuation
ValueCountFrequency (%)
/ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 446
92.7%
Common 35
 
7.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
제 72
 
16.1%
조 72
 
16.1%
업 55
 
12.3%
시 10
 
2.2%
관 10
 
2.2%
품 9
 
2.0%
설 9
 
2.0%
공 8
 
1.8%
운 7
 
1.6%
유 7
 
1.6%
Other values (73) 187
41.9%
Common
ValueCountFrequency (%)
30
85.7%
) 2
 
5.7%
( 2
 
5.7%
/ 1
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 446
92.7%
ASCII 35
 
7.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
제 72
 
16.1%
조 72
 
16.1%
업 55
 
12.3%
시 10
 
2.2%
관 10
 
2.2%
품 9
 
2.0%
설 9
 
2.0%
공 8
 
1.8%
운 7
 
1.6%
유 7
 
1.6%
Other values (73) 187
41.9%
ASCII
ValueCountFrequency (%)
30
85.7%
) 2
 
5.7%
( 2
 
5.7%
/ 1
 
2.9%

DR 가입여부
Categorical

Distinct3
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
N
152 
Y
30 
18 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowN
2nd rowN
3rd rowN
4th rowN
5th rowN

Common Values

ValueCountFrequency (%)
N 152
76.0%
Y 30
 
15.0%
18
 
9.0%

Length

2023-12-10T15:28:16.786533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:28:16.962727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
n 152
83.5%
y 30
 
16.5%

EMS구분인증코드
Categorical

Distinct4
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
<NA>
126 
2
56 
 
11
1
 
7

Length

Max length4
Median length4
Mean length2.89
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 126
63.0%
2 56
28.0%
11
 
5.5%
1 7
 
3.5%

Length

2023-12-10T15:28:17.146465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:28:17.322593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 126
66.7%
2 56
29.6%
1 7
 
3.7%

민간공공구분코드
Categorical

Distinct3
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
1
120 
2
62 
18 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row1
3rd row2
4th row2
5th row2

Common Values

ValueCountFrequency (%)
1 120
60.0%
2 62
31.0%
18
 
9.0%

Length

2023-12-10T15:28:17.507356image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:28:17.748423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 120
65.9%
2 62
34.1%

Sample

통합운영센터 번호수용가 번호산업분류코드건물효율유형코드건물시설군코드건물용도구분코드온실가스목표관리대상여부피크제어기설치여부법정동코드요금제요금제 전압 구분요금제 선택 구분수용가 타입 번호요금제 시작 일자스마트그리드 보급지원 계약 시작일자스마트그리드 보급지원 계약 종료일자스마트그리드 보급지원 계약 상태코드전체전력량정보구분코드등록일시수정일시적재일시토지면적건물층수연면적업종명DR 가입여부EMS구분인증코드민간공공구분코드
0E0000000041264<NA><NA><NA><NA><NA>N2771000000산업용전력(을)선택Ⅱ고압AFT<NA><NA>20251231Y1201801301522202018013015231920190405031904000.0제조N<NA>1
1E0000000041265<NA><NA><NA><NA><NA>N2771000000일반용전력(갑)Ⅰ없음저압FT<NA><NA>20251231Y3201801301527062019040413362620190405031904000.0제조업N<NA>1
2E0000000041276<NA><NA><NA><NA><NA>N2729000000일반용전력(갑)Ⅰ선택Ⅰ고압ABD<NA><NA>20251231Y220180221133521201802211337022018122410315000826.0복지관N<NA>2
3E0000000041277<NA><NA><NA><NA><NA>N2723000000일반용전력(을)선택Ⅱ고압ABD<NA><NA>20251231Y1201802211339342018022113412120181224103150004026.0<NA>N<NA>2
4E0000000041280<NA><NA><NA><NA><NA>N2714000000<NA><NA><NA>BD<NA><NA>20251231Y1201802211400092018022114112320181224103150001251.0<NA>N<NA>2
5E0000000041281<NA><NA><NA><NA><NA>N2729000000산업용전력(갑)Ⅱ선택Ⅱ고압AFT<NA><NA>20251231Y2201802271630202018022716314320181224103150000.0제조업N<NA>1
6E0000000041283<NA><NA><NA><NA><NA>N2720000000일반용전력(갑)Ⅱ선택Ⅱ고압ABD<NA><NA>20251231Y220180227164232201901261549532019012616504200377185.0요양원N<NA>2
7E0000000041286<NA><NA><NA><NA><NA>N2771000000일반용전력(갑)Ⅱ선택Ⅰ고압ABD<NA><NA>20251231Y2201802271658092018022717032620181224103150001033.0<NA>N<NA>2
8E0000000041287<NA><NA><NA><NA><NA>N2729000000산업용전력(을)선택Ⅱ고압AFT<NA><NA>20251231Y1201804181224292018041812254820190405123647000.0<NA>N<NA>1
9E0000000041288<NA><NA><NA><NA><NA>N2729000000일반용전력(을)선택Ⅱ고압AFT<NA><NA>20251231Y2201803131043402018031310522020190405071523003716.0<NA>N<NA>2
통합운영센터 번호수용가 번호산업분류코드건물효율유형코드건물시설군코드건물용도구분코드온실가스목표관리대상여부피크제어기설치여부법정동코드요금제요금제 전압 구분요금제 선택 구분수용가 타입 번호요금제 시작 일자스마트그리드 보급지원 계약 시작일자스마트그리드 보급지원 계약 종료일자스마트그리드 보급지원 계약 상태코드전체전력량정보구분코드등록일시수정일시적재일시토지면적건물층수연면적업종명DR 가입여부EMS구분인증코드민간공공구분코드
190E0000000041054<NA><NA><NA><NA><NA>N2711000000일반용전력(갑)Ⅱ선택Ⅱ고압ABD<NA><NA>20251231Y2201701251621212021021816544020210218175021001971.0문화집회N<NA>2
191E0000000011847223NN4420038024FT<NA>2019073012018051611280020180516112800201812241017150033700.0<NA>N21
192E0000000012613223NN2820010700FT<NA>20200322120180516112800201805161128002018122410171500959.56<NA>N21
193E00000000135478223NN4155034023FT<NA>2021012812018051611280020180516112800201812241017150010000.0<NA>N21
194E000000002IMC0000007KV06200001302012111NN2920014700산업용전력(을)선택(Ⅱ)고압AFT<NA>202009101Z201804231425322018120614552020181207104513020.0제조N21
195E000000002IMC0000016SK00200002233112223YY4223012100산업용전력(을)선택(Ⅱ)고압AFT<NA>201703311Z201805021252242019031916254520190319175054000.0시멘트제조Y21
196E000000002IMC0000018SK00200002233112223YY4623010900산업용전력(갑)ⅡFT<NA>201612311Z201805021339092019031916235920190319175054000.0제조업(시멘트)Y21
197E000000002IMC0000023KO054000011399322YY4715011800산업용전력(을)FT<NA>1Z201805021448302018120614531720181207104513000.0제조업Y21
198E000000002IMC0000057AS00200001511002584YY1150010800일반용전력(을)선택(Ⅱ)고압ABD<NA>202203311Z201807241600062018120615104220181207104513000.0서비스업Y11
199E000000002IMC0000060SW04300001171242223YN4311332032FT<NA>202107311Z201807301714572018120615084220181207104513000.0제조업N21