Overview

Dataset statistics

Number of variables17
Number of observations10000
Missing cells5800
Missing cells (%)3.4%
Duplicate rows2099
Duplicate rows (%)21.0%
Total size in memory1.4 MiB
Average record size in memory145.0 B

Variable types

Categorical13
Text4

Dataset

Description전력고객주요정보 대용량고객 일반정보 오류여부, 생성연도, 장비기준, 점검기준, 유무상기준, 순환기준, 공급분류, 용량, 등록일자, 메모, 참고사항, 업종분류, 변전소 분류, 우편번호, 시도, 군구, 번지입니다.
Author한국전력공사
URLhttps://www.data.go.kr/data/15068962/fileData.do

Alerts

오류여부 has constant value ""Constant
생성연도 has constant value ""Constant
장비기준 has constant value ""Constant
점검기준 has constant value ""Constant
유무상기준 has constant value ""Constant
순환기준 has constant value ""Constant
공급분류 has constant value ""Constant
용량 has constant value ""Constant
등록일자 has constant value ""Constant
메모 has constant value ""Constant
참고사항 has constant value ""Constant
Dataset has 2099 (21.0%) duplicate rowsDuplicates
업종분류 has 2963 (29.6%) missing valuesMissing
번지 has 2837 (28.4%) missing valuesMissing

Reproduction

Analysis started2023-12-12 23:45:41.097401
Analysis finished2023-12-12 23:45:42.316021
Duration1.22 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

오류여부
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
정상 종료
10000 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row정상 종료
2nd row정상 종료
3rd row정상 종료
4th row정상 종료
5th row정상 종료

Common Values

ValueCountFrequency (%)
정상 종료 10000
100.0%

Length

2023-12-13T08:45:42.370895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:45:42.444503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정상 10000
50.0%
종료 10000
50.0%

생성연도
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2007
10000 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2007 10000
100.0%

Length

2023-12-13T08:45:42.528647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:45:42.611795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2007 10000
100.0%

장비기준
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
가공송전선로
10000 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가공송전선로
2nd row가공송전선로
3rd row가공송전선로
4th row가공송전선로
5th row가공송전선로

Common Values

ValueCountFrequency (%)
가공송전선로 10000
100.0%

Length

2023-12-13T08:45:42.694432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:45:42.773293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가공송전선로 10000
100.0%

점검기준
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
정밀점검
10000 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row정밀점검
2nd row정밀점검
3rd row정밀점검
4th row정밀점검
5th row정밀점검

Common Values

ValueCountFrequency (%)
정밀점검 10000
100.0%

Length

2023-12-13T08:45:42.852154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:45:42.933732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정밀점검 10000
100.0%

유무상기준
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
유상
10000 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row유상
2nd row유상
3rd row유상
4th row유상
5th row유상

Common Values

ValueCountFrequency (%)
유상 10000
100.0%

Length

2023-12-13T08:45:43.013978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:45:43.101694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유상 10000
100.0%

순환기준
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
요청시
10000 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row요청시
2nd row요청시
3rd row요청시
4th row요청시
5th row요청시

Common Values

ValueCountFrequency (%)
요청시 10000
100.0%

Length

2023-12-13T08:45:43.202724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:45:43.308219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
요청시 10000
100.0%

공급분류
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
1선로 T분기
10000 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1선로 T분기
2nd row1선로 T분기
3rd row1선로 T분기
4th row1선로 T분기
5th row1선로 T분기

Common Values

ValueCountFrequency (%)
1선로 T분기 10000
100.0%

Length

2023-12-13T08:45:43.393254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:45:43.472985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1선로 10000
50.0%
t분기 10000
50.0%

용량
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
380V, 10kA, 30분
10000 

Length

Max length15
Median length15
Mean length15
Min length15

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row380V, 10kA, 30분
2nd row380V, 10kA, 30분
3rd row380V, 10kA, 30분
4th row380V, 10kA, 30분
5th row380V, 10kA, 30분

Common Values

ValueCountFrequency (%)
380V, 10kA, 30분 10000
100.0%

Length

2023-12-13T08:45:43.557712image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:45:43.628466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
380v 10000
33.3%
10ka 10000
33.3%
30분 10000
33.3%

등록일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2011-02-23 17:01
10000 

Length

Max length16
Median length16
Mean length16
Min length16

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2011-02-23 17:01
2nd row2011-02-23 17:01
3rd row2011-02-23 17:01
4th row2011-02-23 17:01
5th row2011-02-23 17:01

Common Values

ValueCountFrequency (%)
2011-02-23 17:01 10000
100.0%

Length

2023-12-13T08:45:43.704540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:45:43.795774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2011-02-23 10000
50.0%
17:01 10000
50.0%

메모
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
민원이나 업무처리 과정에 제안할 사항
10000 

Length

Max length20
Median length20
Mean length20
Min length20

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row민원이나 업무처리 과정에 제안할 사항
2nd row민원이나 업무처리 과정에 제안할 사항
3rd row민원이나 업무처리 과정에 제안할 사항
4th row민원이나 업무처리 과정에 제안할 사항
5th row민원이나 업무처리 과정에 제안할 사항

Common Values

ValueCountFrequency (%)
민원이나 업무처리 과정에 제안할 사항 10000
100.0%

Length

2023-12-13T08:45:43.878880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:45:43.951721image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
민원이나 10000
20.0%
업무처리 10000
20.0%
과정에 10000
20.0%
제안할 10000
20.0%
사항 10000
20.0%

참고사항
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
긴밀한 연락체계
10000 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row긴밀한 연락체계
2nd row긴밀한 연락체계
3rd row긴밀한 연락체계
4th row긴밀한 연락체계
5th row긴밀한 연락체계

Common Values

ValueCountFrequency (%)
긴밀한 연락체계 10000
100.0%

Length

2023-12-13T08:45:44.060789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:45:44.150850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
긴밀한 10000
50.0%
연락체계 10000
50.0%

업종분류
Text

MISSING 

Distinct334
Distinct (%)4.7%
Missing2963
Missing (%)29.6%
Memory size156.2 KiB
2023-12-13T08:45:44.382389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length25
Mean length9.9091943
Min length2

Characters and Unicode

Total characters69731
Distinct characters294
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique50 ?
Unique (%)0.7%

Sample

1st row기타 수상오락 서비스업
2nd row무선통신업
3rd row주거용 건물 임대업
4th row체인화 편의점
5th row비주거용 건물 임대업
ValueCountFrequency (%)
기타 1558
 
7.6%
행정 1176
 
5.7%
건물 1155
 
5.6%
국방 1115
 
5.4%
및 1063
 
5.2%
임대업 1055
 
5.1%
비주거용 991
 
4.8%
제조업 926
 
4.5%
그외 803
 
3.9%
소매업 795
 
3.9%
Other values (540) 9954
48.3%
2023-12-13T08:45:44.758167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
13554
 
19.4%
업 5658
 
8.1%
기 2248
 
3.2%
용 1598
 
2.3%
타 1583
 
2.3%
행 1454
 
2.1%
비 1454
 
2.1%
물 1396
 
2.0%
정 1350
 
1.9%
건 1309
 
1.9%
Other values (284) 38127
54.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 55859
80.1%
Space Separator 13554
 
19.4%
Other Punctuation 304
 
0.4%
Decimal Number 14
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
업 5658
 
10.1%
기 2248
 
4.0%
용 1598
 
2.9%
타 1583
 
2.8%
행 1454
 
2.6%
비 1454
 
2.6%
물 1396
 
2.5%
정 1350
 
2.4%
건 1309
 
2.3%
대 1308
 
2.3%
Other values (280) 36501
65.3%
Other Punctuation
ValueCountFrequency (%)
/ 229
75.3%
· 75
 
24.7%
Space Separator
ValueCountFrequency (%)
13554
100.0%
Decimal Number
ValueCountFrequency (%)
1 14
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 55859
80.1%
Common 13872
 
19.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
업 5658
 
10.1%
기 2248
 
4.0%
용 1598
 
2.9%
타 1583
 
2.8%
행 1454
 
2.6%
비 1454
 
2.6%
물 1396
 
2.5%
정 1350
 
2.4%
건 1309
 
2.3%
대 1308
 
2.3%
Other values (280) 36501
65.3%
Common
ValueCountFrequency (%)
13554
97.7%
/ 229
 
1.7%
· 75
 
0.5%
1 14
 
0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 55859
80.1%
ASCII 13797
 
19.8%
None 75
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
13554
98.2%
/ 229
 
1.7%
1 14
 
0.1%
Hangul
ValueCountFrequency (%)
업 5658
 
10.1%
기 2248
 
4.0%
용 1598
 
2.9%
타 1583
 
2.8%
행 1454
 
2.6%
비 1454
 
2.6%
물 1396
 
2.5%
정 1350
 
2.4%
건 1309
 
2.3%
대 1308
 
2.3%
Other values (280) 36501
65.3%
None
ValueCountFrequency (%)
· 75
100.0%

변전소 분류
Categorical

Distinct14
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
변전소(22.9kV-y)
3117 
단상2선(22.9kV-y)
2385 
변전소(154kV)
2303 
삼상3선(154kV)
1112 
삼상3선(22kV)
438 
Other values (9)
645 

Length

Max length14
Median length13
Mean length11.9833
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row단상2선(22.9kV-y)
2nd row단상2선(22.9kV-y)
3rd row변전소(22.9kV-y)
4th row단상2선(22.9kV-y)
5th row변전소(22.9kV-y)

Common Values

ValueCountFrequency (%)
변전소(22.9kV-y) 3117
31.2%
단상2선(22.9kV-y) 2385
23.8%
변전소(154kV) 2303
23.0%
삼상3선(154kV) 1112
 
11.1%
삼상3선(22kV) 438
 
4.4%
변전소(66kV) 128
 
1.3%
변전소(22kV) 120
 
1.2%
발전소(154kV) 111
 
1.1%
변전소(345kV) 84
 
0.8%
삼상4선(22kV) 63
 
0.6%
Other values (4) 139
 
1.4%

Length

2023-12-13T08:45:44.890515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
변전소(22.9kv-y 3117
31.2%
단상2선(22.9kv-y 2385
23.8%
변전소(154kv 2303
23.0%
삼상3선(154kv 1112
 
11.1%
삼상3선(22kv 438
 
4.4%
변전소(66kv 128
 
1.3%
변전소(22kv 120
 
1.2%
발전소(154kv 111
 
1.1%
변전소(345kv 84
 
0.8%
삼상4선(22kv 63
 
0.6%
Other values (4) 139
 
1.4%

우편번호
Text

Distinct1251
Distinct (%)12.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-13T08:45:45.149986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length7
Mean length7
Min length7

Characters and Unicode

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

Unique

Unique245 ?
Unique (%)2.5%

Sample

1st row780-893
2nd row343-806
3rd row157-848
4th row252-806
5th row156-030
ValueCountFrequency (%)
152-868 404
 
4.0%
140-877 283
 
2.8%
157-848 226
 
2.3%
435-030 214
 
2.1%
240-340 172
 
1.7%
255-806 107
 
1.1%
689-892 104
 
1.0%
100-846 90
 
0.9%
138-827 87
 
0.9%
133-783 85
 
0.9%
Other values (1241) 8228
82.3%
2023-12-13T08:45:45.521533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 10000
14.3%
1 9924
14.2%
8 8515
12.2%
0 8229
11.8%
3 6754
9.6%
2 5948
8.5%
4 5504
7.9%
5 5471
7.8%
7 3977
 
5.7%
6 3196
 
4.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 60000
85.7%
Dash Punctuation 10000
 
14.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 9924
16.5%
8 8515
14.2%
0 8229
13.7%
3 6754
11.3%
2 5948
9.9%
4 5504
9.2%
5 5471
9.1%
7 3977
6.6%
6 3196
 
5.3%
9 2482
 
4.1%
Dash Punctuation
ValueCountFrequency (%)
- 10000
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 70000
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 10000
14.3%
1 9924
14.2%
8 8515
12.2%
0 8229
11.8%
3 6754
9.6%
2 5948
8.5%
4 5504
7.9%
5 5471
7.8%
7 3977
 
5.7%
6 3196
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 70000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 10000
14.3%
1 9924
14.2%
8 8515
12.2%
0 8229
11.8%
3 6754
9.6%
2 5948
8.5%
4 5504
7.9%
5 5471
7.8%
7 3977
 
5.7%
6 3196
 
4.6%

시도
Categorical

Distinct16
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
서울특별시
4382 
강원도
1494 
경기도
1365 
경상북도
516 
충청북도
441 
Other values (11)
1802 

Length

Max length5
Median length5
Mean length4.2399
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경상북도
2nd row충청남도
3rd row서울특별시
4th row강원도
5th row서울특별시

Common Values

ValueCountFrequency (%)
서울특별시 4382
43.8%
강원도 1494
 
14.9%
경기도 1365
 
13.7%
경상북도 516
 
5.2%
충청북도 441
 
4.4%
충청남도 300
 
3.0%
울산광역시 256
 
2.6%
인천광역시 236
 
2.4%
전라남도 234
 
2.3%
경상남도 219
 
2.2%
Other values (6) 557
 
5.6%

Length

2023-12-13T08:45:45.853589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
서울특별시 4382
43.8%
강원도 1494
 
14.9%
경기도 1365
 
13.7%
경상북도 516
 
5.2%
충청북도 441
 
4.4%
충청남도 300
 
3.0%
울산광역시 256
 
2.6%
인천광역시 236
 
2.4%
전라남도 234
 
2.3%
경상남도 219
 
2.2%
Other values (6) 557
 
5.6%

군구
Text

Distinct188
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-13T08:45:46.106960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length3
Mean length3.0984
Min length2

Characters and Unicode

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

Unique

Unique5 ?
Unique (%)< 0.1%

Sample

1st row경주시
2nd row당진군
3rd row강서구
4th row인제군
5th row동작구
ValueCountFrequency (%)
구로구 637
 
6.2%
강서구 476
 
4.6%
중구 414
 
4.0%
용산구 381
 
3.7%
양양군 315
 
3.1%
송파구 315
 
3.1%
강남구 308
 
3.0%
군포시 263
 
2.6%
성동구 251
 
2.4%
강동구 228
 
2.2%
Other values (186) 6725
65.2%
2023-12-13T08:45:46.479179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
구 6195
20.0%
군 2771
 
8.9%
시 2598
 
8.4%
양 1415
 
4.6%
동 1057
 
3.4%
강 1055
 
3.4%
로 853
 
2.8%
주 778
 
2.5%
천 775
 
2.5%
서 767
 
2.5%
Other values (116) 12720
41.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 30671
99.0%
Space Separator 313
 
1.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 6195
20.2%
군 2771
 
9.0%
시 2598
 
8.5%
양 1415
 
4.6%
동 1057
 
3.4%
강 1055
 
3.4%
로 853
 
2.8%
주 778
 
2.5%
천 775
 
2.5%
서 767
 
2.5%
Other values (115) 12407
40.5%
Space Separator
ValueCountFrequency (%)
313
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 30671
99.0%
Common 313
 
1.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 6195
20.2%
군 2771
 
9.0%
시 2598
 
8.5%
양 1415
 
4.6%
동 1057
 
3.4%
강 1055
 
3.4%
로 853
 
2.8%
주 778
 
2.5%
천 775
 
2.5%
서 767
 
2.5%
Other values (115) 12407
40.5%
Common
ValueCountFrequency (%)
313
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 30671
99.0%
ASCII 313
 
1.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
구 6195
20.2%
군 2771
 
9.0%
시 2598
 
8.5%
양 1415
 
4.6%
동 1057
 
3.4%
강 1055
 
3.4%
로 853
 
2.8%
주 778
 
2.5%
천 775
 
2.5%
서 767
 
2.5%
Other values (115) 12407
40.5%
ASCII
ValueCountFrequency (%)
313
100.0%

번지
Text

MISSING 

Distinct1590
Distinct (%)22.2%
Missing2837
Missing (%)28.4%
Memory size156.2 KiB
2023-12-13T08:45:46.743059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length4.7276281
Min length1

Characters and Unicode

Total characters33864
Distinct characters337
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique471 ?
Unique (%)6.6%

Sample

1st row송전리
2nd row중교리
3rd row300∼380
4th row상동2리
5th row77∼170
ValueCountFrequency (%)
667∼699 404
 
5.6%
300∼380 226
 
3.1%
40-(969 106
 
1.5%
1 90
 
1.3%
22∼44 87
 
1.2%
83 87
 
1.2%
도시철도공사 85
 
1.2%
1∼63 65
 
0.9%
600∼603 51
 
0.7%
1∼118 47
 
0.7%
Other values (1583) 5932
82.6%
2023-12-13T08:45:47.107552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
리 3586
 
10.6%
∼ 2488
 
7.3%
0 2398
 
7.1%
1 2370
 
7.0%
6 2059
 
6.1%
3 1878
 
5.5%
9 1677
 
5.0%
2 1228
 
3.6%
4 1218
 
3.6%
7 1177
 
3.5%
Other values (327) 13785
40.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 16050
47.4%
Other Letter 14487
42.8%
Math Symbol 2488
 
7.3%
Open Punctuation 268
 
0.8%
Close Punctuation 240
 
0.7%
Dash Punctuation 210
 
0.6%
Uppercase Letter 104
 
0.3%
Space Separator 17
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
리 3586
24.8%
산 333
 
2.3%
도 290
 
2.0%
대 265
 
1.8%
동 225
 
1.6%
곡 217
 
1.5%
신 208
 
1.4%
공 205
 
1.4%
사 197
 
1.4%
상 187
 
1.3%
Other values (299) 8774
60.6%
Uppercase Letter
ValueCountFrequency (%)
L 19
18.3%
G 19
18.3%
D 12
11.5%
I 11
10.6%
A 11
10.6%
C 7
 
6.7%
O 6
 
5.8%
X 6
 
5.8%
E 6
 
5.8%
M 3
 
2.9%
Other values (3) 4
 
3.8%
Decimal Number
ValueCountFrequency (%)
0 2398
14.9%
1 2370
14.8%
6 2059
12.8%
3 1878
11.7%
9 1677
10.4%
2 1228
7.7%
4 1218
7.6%
7 1177
7.3%
8 1133
7.1%
5 912
 
5.7%
Math Symbol
ValueCountFrequency (%)
∼ 2488
100.0%
Open Punctuation
ValueCountFrequency (%)
( 268
100.0%
Close Punctuation
ValueCountFrequency (%)
) 240
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 210
100.0%
Space Separator
ValueCountFrequency (%)
17
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 19273
56.9%
Hangul 14487
42.8%
Latin 104
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
리 3586
24.8%
산 333
 
2.3%
도 290
 
2.0%
대 265
 
1.8%
동 225
 
1.6%
곡 217
 
1.5%
신 208
 
1.4%
공 205
 
1.4%
사 197
 
1.4%
상 187
 
1.3%
Other values (299) 8774
60.6%
Common
ValueCountFrequency (%)
∼ 2488
12.9%
0 2398
12.4%
1 2370
12.3%
6 2059
10.7%
3 1878
9.7%
9 1677
8.7%
2 1228
6.4%
4 1218
6.3%
7 1177
6.1%
8 1133
5.9%
Other values (5) 1647
8.5%
Latin
ValueCountFrequency (%)
L 19
18.3%
G 19
18.3%
D 12
11.5%
I 11
10.6%
A 11
10.6%
C 7
 
6.7%
O 6
 
5.8%
X 6
 
5.8%
E 6
 
5.8%
M 3
 
2.9%
Other values (3) 4
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 16889
49.9%
Hangul 14487
42.8%
Math Operators 2488
 
7.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
리 3586
24.8%
산 333
 
2.3%
도 290
 
2.0%
대 265
 
1.8%
동 225
 
1.6%
곡 217
 
1.5%
신 208
 
1.4%
공 205
 
1.4%
사 197
 
1.4%
상 187
 
1.3%
Other values (299) 8774
60.6%
Math Operators
ValueCountFrequency (%)
∼ 2488
100.0%
ASCII
ValueCountFrequency (%)
0 2398
14.2%
1 2370
14.0%
6 2059
12.2%
3 1878
11.1%
9 1677
9.9%
2 1228
7.3%
4 1218
7.2%
7 1177
7.0%
8 1133
6.7%
5 912
 
5.4%
Other values (17) 839
 
5.0%

Correlations

2023-12-13T08:45:47.187712image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
변전소 분류시도
변전소 분류1.0000.667
시도0.6671.000
2023-12-13T08:45:47.252909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
변전소 분류시도
변전소 분류1.0000.299
시도0.2991.000
2023-12-13T08:45:47.315417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
변전소 분류시도
변전소 분류1.0000.299
시도0.2991.000

Missing values

2023-12-13T08:45:41.901640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T08:45:42.121905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
2023-12-13T08:45:42.246970image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

오류여부생성연도장비기준점검기준유무상기준순환기준공급분류용량등록일자메모참고사항업종분류변전소 분류우편번호시도군구번지
29185정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계기타 수상오락 서비스업단상2선(22.9kV-y)780-893경상북도경주시송전리
33150정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계무선통신업단상2선(22.9kV-y)343-806충청남도당진군중교리
42063정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계<NA>변전소(22.9kV-y)157-848서울특별시강서구300∼380
29954정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계주거용 건물 임대업단상2선(22.9kV-y)252-806강원도인제군상동2리
26231정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계체인화 편의점변전소(22.9kV-y)156-030서울특별시동작구<NA>
14410정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계<NA>변전소(154kV)427-040경기도과천시<NA>
27975정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계비주거용 건물 임대업변전소(22.9kV-y)133-849서울특별시성동구77∼170
18456정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계비주거용 건물 임대업변전소(22.9kV-y)152-053서울특별시구로구<NA>
20775정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계<NA>발전소(345kV)780-842경상북도경주시상라리
11892정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계가전제품 및 부품 도매업삼상3선(22kV)140-879서울특별시용산구16
오류여부생성연도장비기준점검기준유무상기준순환기준공급분류용량등록일자메모참고사항업종분류변전소 분류우편번호시도군구번지
36505정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계<NA>변전소(22.9kV-y)138-820서울특별시송파구200-(37∼38)
11462정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계<NA>변전소(22.9kV-y)138-820서울특별시송파구128-(67∼112)
2627정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계<NA>변전소(22.9kV-y)150-804서울특별시영등포구385∼560
26566정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계비주거용 건물 임대업변전소(154kV)152-868서울특별시구로구667∼699
25593정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계체인화 편의점변전소(22.9kV-y)135-011서울특별시강남구<NA>
27764정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계농학 연구개발업변전소(22.9kV-y)137-044서울특별시서초구<NA>
6053정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계비주거용 건물 임대업변전소(22.9kV-y)411-370경기도고양시 일산서구<NA>
32971정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계골판지 및 골판지상자 제조업변전소(22.9kV-y)517-923전라남도담양군평장리
857정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계합성수지 및 기타 플라스틱물질 제조업삼상3선(154kV)570-350전라북도익산시<NA>
18963정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계철도운송업삼상3선(154kV)621-882경상남도김해시신월리

Duplicate rows

Most frequently occurring

오류여부생성연도장비기준점검기준유무상기준순환기준공급분류용량등록일자메모참고사항업종분류변전소 분류우편번호시도군구번지# duplicates
1970정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계<NA>변전소(22.9kV-y)157-848서울특별시강서구300∼380224
1743정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계<NA>변전소(154kV)152-868서울특별시구로구667∼699219
2042정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계<NA>삼상3선(154kV)240-340강원도동해시<NA>167
349정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계그외 기타 분류안된 상품 전문 소매업변전소(154kV)435-030경기도군포시<NA>160
872정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계비주거용 건물 임대업변전소(154kV)152-868서울특별시구로구667∼69973
1681정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계<NA>단상2선(22.9kV-y)403-015인천광역시부평구<NA>52
851정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계비주거용 건물 임대업단상2선(22.9kV-y)152-864서울특별시구로구600∼60350
1051정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계사진기 및 사진용품 소매업변전소(22.9kV-y)133-783서울특별시성동구도시철도공사50
1824정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계<NA>변전소(22.9kV-y)100-846서울특별시중구1∼11843
39정상 종료2007가공송전선로정밀점검유상요청시1선로 T분기380V, 10kA, 30분2011-02-23 17:01민원이나 업무처리 과정에 제안할 사항긴밀한 연락체계광고 대행업변전소(154kV)152-868서울특별시구로구667∼69940