Overview

Dataset statistics

Number of variables6
Number of observations139
Missing cells0
Missing cells (%)0.0%
Duplicate rows1
Duplicate rows (%)0.7%
Total size in memory6.9 KiB
Average record size in memory50.9 B

Variable types

Text1
Categorical5

Dataset

Description대전교통공사의 변전소 및 전기실 변압기 설치 정보에 관련된 사항입니다. 제품명 및 규격 등이 명시되어 시설자료 검색시 참고해 주시기 바랍니다.
Author대전교통공사
URLhttps://www.data.go.kr/data/15098480/fileData.do

Alerts

상태(양호_ 불량 등) has constant value ""Constant
Dataset has 1 (0.7%) duplicate rowsDuplicates
제품명 is highly overall correlated with 규격High correlation
규격 is highly overall correlated with 제품명High correlation
제품명 is highly imbalanced (59.4%)Imbalance

Reproduction

Analysis started2023-12-12 15:39:35.491338
Analysis finished2023-12-12 15:39:35.997821
Duration0.51 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

설치장소
Text

Distinct53
Distinct (%)38.1%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-13T00:39:36.188996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length10
Mean length6.4316547
Min length5

Characters and Unicode

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

Unique

Unique19 ?
Unique (%)13.7%

Sample

1st row판암기지 변전소
2nd row판암기지 변전소
3rd row판암기지 변전소
4th row대동 변전소
5th row대동 변전소
ValueCountFrequency (%)
변전소 18
 
11.1%
구암전기실 6
 
3.7%
판암전기실 5
 
3.1%
정부청사전기실 5
 
3.1%
반석전기실 5
 
3.1%
종합관제전기실 4
 
2.5%
월드컵경기장 4
 
2.5%
본선전기실 4
 
2.5%
신흥전기실 4
 
2.5%
대동전기실 4
 
2.5%
Other values (45) 103
63.6%
2023-12-13T00:39:36.690837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
기 149
16.7%
전 148
16.6%
실 121
 
13.5%
암 27
 
3.0%
지 25
 
2.8%
23
 
2.6%
판 20
 
2.2%
선 19
 
2.1%
본 19
 
2.1%
변 18
 
2.0%
Other values (57) 325
36.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 856
95.7%
Space Separator 23
 
2.6%
Decimal Number 15
 
1.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 149
17.4%
전 148
17.3%
실 121
14.1%
암 27
 
3.2%
지 25
 
2.9%
판 20
 
2.3%
선 19
 
2.2%
본 19
 
2.2%
변 18
 
2.1%
소 18
 
2.1%
Other values (53) 292
34.1%
Decimal Number
ValueCountFrequency (%)
2 6
40.0%
1 5
33.3%
3 4
26.7%
Space Separator
ValueCountFrequency (%)
23
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 856
95.7%
Common 38
 
4.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 149
17.4%
전 148
17.3%
실 121
14.1%
암 27
 
3.2%
지 25
 
2.9%
판 20
 
2.3%
선 19
 
2.2%
본 19
 
2.2%
변 18
 
2.1%
소 18
 
2.1%
Other values (53) 292
34.1%
Common
ValueCountFrequency (%)
23
60.5%
2 6
 
15.8%
1 5
 
13.2%
3 4
 
10.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 856
95.7%
ASCII 38
 
4.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
기 149
17.4%
전 148
17.3%
실 121
14.1%
암 27
 
3.2%
지 25
 
2.9%
판 20
 
2.3%
선 19
 
2.2%
본 19
 
2.2%
변 18
 
2.1%
소 18
 
2.1%
Other values (53) 292
34.1%
ASCII
ValueCountFrequency (%)
23
60.5%
2 6
 
15.8%
1 5
 
13.2%
3 4
 
10.5%

제품명
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct6
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
LS산전 몰드변압기
115 
정류기용 몰드변압기(이화전기)
 
6
고배용 몰드변압기(이화전기)
 
6
소내용 몰드변압기(이화전기)
 
6
ABB
 
4

Length

Max length16
Median length10
Mean length10.503597
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row정류기용 몰드변압기(이화전기)
2nd row고배용 몰드변압기(이화전기)
3rd row소내용 몰드변압기(이화전기)
4th row정류기용 몰드변압기(이화전기)
5th row고배용 몰드변압기(이화전기)

Common Values

ValueCountFrequency (%)
LS산전 몰드변압기 115
82.7%
정류기용 몰드변압기(이화전기) 6
 
4.3%
고배용 몰드변압기(이화전기) 6
 
4.3%
소내용 몰드변압기(이화전기) 6
 
4.3%
ABB 4
 
2.9%
LS산전 몰드변압기 2
 
1.4%

Length

2023-12-13T00:39:36.857366image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:39:36.981441image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
ls산전 117
42.7%
몰드변압기 117
42.7%
몰드변압기(이화전기 18
 
6.6%
정류기용 6
 
2.2%
고배용 6
 
2.2%
소내용 6
 
2.2%
abb 4
 
1.5%

규격
Categorical

HIGH CORRELATION 

Distinct21
Distinct (%)15.1%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
6.6KV/380/220V 150kVA
36 
6.6KV/380/220V 200kVA
25 
6.6KV/380/220V 750kVA
11 
6.6KV/380/220V 300kVA
11 
6.6KV/380/220V 400kVA
9 
Other values (16)
47 

Length

Max length24
Median length21
Mean length21.057554
Min length20

Unique

Unique6 ?
Unique (%)4.3%

Sample

1st row22.9KV/600V/600V,3000kVA
2nd row22.9KV/6.6kV,6500kVA
3rd row6.6KV/380/220V 150kVA
4th row22.9KV/600V/600V,3000kVA
5th row22.9KV/6.6kV,6500kVA

Common Values

ValueCountFrequency (%)
6.6KV/380/220V 150kVA 36
25.9%
6.6KV/380/220V 200kVA 25
18.0%
6.6KV/380/220V 750kVA 11
 
7.9%
6.6KV/380/220V 300kVA 11
 
7.9%
6.6KV/380/220V 400kVA 9
 
6.5%
22.9KV/600V/600V,3000kVA 6
 
4.3%
6.6KV/380/220V 250kVA 6
 
4.3%
6.6KV/380/220V 600kVA 6
 
4.3%
6.6KV/380/220V 500kVA 6
 
4.3%
6.6KV/380/220V 30kVA 5
 
3.6%
Other values (11) 18
12.9%

Length

2023-12-13T00:39:37.136434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
6.6kv/380/220v 127
47.7%
150kva 36
 
13.5%
200kva 25
 
9.4%
750kva 11
 
4.1%
300kva 11
 
4.1%
400kva 9
 
3.4%
22.9kv/600v/600v,3000kva 6
 
2.3%
250kva 6
 
2.3%
600kva 6
 
2.3%
500kva 6
 
2.3%
Other values (12) 23
 
8.6%

수량
Categorical

Distinct5
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
1
61 
2
59 
3
16 
4
 
2
5
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)0.7%

Sample

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

Common Values

ValueCountFrequency (%)
1 61
43.9%
2 59
42.4%
3 16
 
11.5%
4 2
 
1.4%
5 1
 
0.7%

Length

2023-12-13T00:39:37.290131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:39:37.421239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 61
43.9%
2 59
42.4%
3 16
 
11.5%
4 2
 
1.4%
5 1
 
0.7%

연식
Categorical

Distinct3
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2004
80 
2006
45 
2005
14 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2004 80
57.6%
2006 45
32.4%
2005 14
 
10.1%

Length

2023-12-13T00:39:37.560609image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:39:37.678437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2004 80
57.6%
2006 45
32.4%
2005 14
 
10.1%

상태(양호_ 불량 등)
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
양호
139 

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 (%)
양호 139
100.0%

Length

2023-12-13T00:39:37.829074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:39:37.946166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
양호 139
100.0%

Correlations

2023-12-13T00:39:38.009510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치장소제품명규격수량연식
설치장소1.0000.8740.0000.0001.000
제품명0.8741.0000.9130.5720.671
규격0.0000.9131.0000.6210.734
수량0.0000.5720.6211.0000.221
연식1.0000.6710.7340.2211.000
2023-12-13T00:39:38.111780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수량연식규격제품명
수량1.0000.1680.3390.431
연식0.1681.0000.4340.353
규격0.3390.4341.0000.665
제품명0.4310.3530.6651.000
2023-12-13T00:39:38.210997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
제품명규격수량연식
제품명1.0000.6650.4310.353
규격0.6651.0000.3390.434
수량0.4310.3391.0000.168
연식0.3530.4340.1681.000

Missing values

2023-12-13T00:39:35.812552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T00:39:35.944193image/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.

Sample

설치장소제품명규격수량연식상태(양호_ 불량 등)
0판암기지 변전소정류기용 몰드변압기(이화전기)22.9KV/600V/600V,3000kVA32004양호
1판암기지 변전소고배용 몰드변압기(이화전기)22.9KV/6.6kV,6500kVA22004양호
2판암기지 변전소소내용 몰드변압기(이화전기)6.6KV/380/220V 150kVA22004양호
3대동 변전소정류기용 몰드변압기(이화전기)22.9KV/600V/600V,3000kVA32004양호
4대동 변전소고배용 몰드변압기(이화전기)22.9KV/6.6kV,6500kVA22004양호
5대동 변전소소내용 몰드변압기(이화전기)6.6KV/380/220V 150kVA22004양호
6시청 변전소정류기용 몰드변압기(이화전기)22.9KV/600V/600V,3000kVA32004양호
7시청 변전소고배용 몰드변압기(이화전기)22.9KV/6.6kV,5000kVA22004양호
8시청 변전소소내용 몰드변압기(이화전기)6.6KV/380/220V 150kVA22004양호
9갑천 변전소정류기용 몰드변압기(이화전기)22.9KV/600V/600V,3000kVA32005양호
설치장소제품명규격수량연식상태(양호_ 불량 등)
129반석전기실LS산전 몰드변압기6.6KV/380/220V 750kVA22006양호
130반석전기실LS산전 몰드변압기6.6KV/380/220V 30kVA22006양호
131반석전기실LS산전 몰드변압기6.6KV/380/220V 200kVA12006양호
132반석전기실LS산전 몰드변압기6.6KV/380/220V 150kVA12006양호
133반석본선전기실LS산전 몰드변압기6.6KV/380/220V 100kVA12006양호
134외삼기지1전기실LS산전 몰드변압기6.6KV/380/220V 200kVA22005양호
135외삼기지1전기실LS산전 몰드변압기6.6KV/380/220V 400kVA22005양호
136외삼기지1전기실LS산전 몰드변압기6.6KV/380/220V 70kVA22005양호
137외삼기지2전기실LS산전 몰드변압기6.6KV/380/220V 200kVA22005양호
138외삼기지2전기실LS산전 몰드변압기6.6KV/380/220V 500kVA22005양호

Duplicate rows

Most frequently occurring

설치장소제품명규격수량연식상태(양호_ 불량 등)# duplicates
0판암기지3전기실LS산전 몰드변압기6.6KV/380/220V 150kVA12004양호2