Overview

Dataset statistics

Number of variables4
Number of observations56
Missing cells2
Missing cells (%)0.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.9 KiB
Average record size in memory34.3 B

Variable types

Text4

Dataset

Description전라북도 시군구별 전기안전관리 대행업체에 관한 정보입니다. 업체명, 대표자, 전화번호, 주소 등의 항목을 제공합니다.
Author전북특별자치도
URLhttps://www.data.go.kr/data/15059754/fileData.do

Alerts

전화번호 has 2 (3.6%) missing valuesMissing
업체명 has unique valuesUnique
주소 has unique valuesUnique

Reproduction

Analysis started2024-03-14 11:10:41.110859
Analysis finished2024-03-14 11:10:42.065727
Duration0.95 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업체명
Text

UNIQUE 

Distinct56
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size576.0 B
2024-03-14T20:10:42.926301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length12
Mean length8.9642857
Min length4

Characters and Unicode

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

Unique

Unique56 ?
Unique (%)100.0%

Sample

1st row(주)케시
2nd row전북전기관리공사
3rd row한국전기관리소
4th row대한전기안전관리
5th row(유)호남전기안전관리
ValueCountFrequency (%)
주식회사 2
 
3.3%
주)케시 1
 
1.7%
유한회사 1
 
1.7%
동부전기안전관리 1
 
1.7%
주)셉코 1
 
1.7%
한일전기관리단 1
 
1.7%
유)고인돌전기안전관리 1
 
1.7%
대한전기안전관리소 1
 
1.7%
kens 1
 
1.7%
삼성전기관리공사 1
 
1.7%
Other values (49) 49
81.7%
2024-03-14T20:10:44.448017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
전 79
15.7%
기 45
 
9.0%
리 41
 
8.2%
관 40
 
8.0%
안 27
 
5.4%
( 23
 
4.6%
) 23
 
4.6%
유 22
 
4.4%
한 20
 
4.0%
사 18
 
3.6%
Other values (70) 164
32.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 440
87.6%
Open Punctuation 23
 
4.6%
Close Punctuation 23
 
4.6%
Uppercase Letter 10
 
2.0%
Space Separator 4
 
0.8%
Dash Punctuation 1
 
0.2%
Other Symbol 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 79
18.0%
기 45
 
10.2%
리 41
 
9.3%
관 40
 
9.1%
안 27
 
6.1%
유 22
 
5.0%
한 20
 
4.5%
사 18
 
4.1%
공 12
 
2.7%
소 10
 
2.3%
Other values (58) 126
28.6%
Uppercase Letter
ValueCountFrequency (%)
K 3
30.0%
E 2
20.0%
T 1
 
10.0%
O 1
 
10.0%
P 1
 
10.0%
S 1
 
10.0%
N 1
 
10.0%
Open Punctuation
ValueCountFrequency (%)
( 23
100.0%
Close Punctuation
ValueCountFrequency (%)
) 23
100.0%
Space Separator
ValueCountFrequency (%)
4
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 441
87.8%
Common 51
 
10.2%
Latin 10
 
2.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 79
17.9%
기 45
 
10.2%
리 41
 
9.3%
관 40
 
9.1%
안 27
 
6.1%
유 22
 
5.0%
한 20
 
4.5%
사 18
 
4.1%
공 12
 
2.7%
소 10
 
2.3%
Other values (59) 127
28.8%
Latin
ValueCountFrequency (%)
K 3
30.0%
E 2
20.0%
T 1
 
10.0%
O 1
 
10.0%
P 1
 
10.0%
S 1
 
10.0%
N 1
 
10.0%
Common
ValueCountFrequency (%)
( 23
45.1%
) 23
45.1%
4
 
7.8%
- 1
 
2.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 440
87.6%
ASCII 61
 
12.2%
None 1
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
전 79
18.0%
기 45
 
10.2%
리 41
 
9.3%
관 40
 
9.1%
안 27
 
6.1%
유 22
 
5.0%
한 20
 
4.5%
사 18
 
4.1%
공 12
 
2.7%
소 10
 
2.3%
Other values (58) 126
28.6%
ASCII
ValueCountFrequency (%)
( 23
37.7%
) 23
37.7%
4
 
6.6%
K 3
 
4.9%
E 2
 
3.3%
T 1
 
1.6%
- 1
 
1.6%
O 1
 
1.6%
P 1
 
1.6%
S 1
 
1.6%
None
ValueCountFrequency (%)
㈜ 1
100.0%

대표자
Text

Distinct53
Distinct (%)94.6%
Missing0
Missing (%)0.0%
Memory size576.0 B
2024-03-14T20:10:45.570677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length3
Mean length4.3214286
Min length3

Characters and Unicode

Total characters242
Distinct characters72
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

Unique50 ?
Unique (%)89.3%

Sample

1st row이*실
2nd row한*규외1명
3rd row서*석외6명
4th row김*열외4명
5th row최*열
ValueCountFrequency (%)
박*철 2
 
3.6%
김*순 2
 
3.6%
장*섭 2
 
3.6%
이*홍 1
 
1.8%
박*석 1
 
1.8%
이*실 1
 
1.8%
신*호 1
 
1.8%
이*영외5명 1
 
1.8%
박*성외6명 1
 
1.8%
이*재 1
 
1.8%
Other values (43) 43
76.8%
2024-03-14T20:10:47.266547image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
* 60
24.8%
외 20
 
8.3%
명 18
 
7.4%
이 10
 
4.1%
김 9
 
3.7%
박 7
 
2.9%
6 6
 
2.5%
최 5
 
2.1%
, 4
 
1.7%
임 4
 
1.7%
Other values (62) 99
40.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 158
65.3%
Other Punctuation 64
26.4%
Decimal Number 20
 
8.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
외 20
 
12.7%
명 18
 
11.4%
이 10
 
6.3%
김 9
 
5.7%
박 7
 
4.4%
최 5
 
3.2%
임 4
 
2.5%
장 4
 
2.5%
석 3
 
1.9%
원 3
 
1.9%
Other values (53) 75
47.5%
Decimal Number
ValueCountFrequency (%)
6 6
30.0%
2 3
15.0%
4 3
15.0%
3 3
15.0%
5 3
15.0%
7 1
 
5.0%
1 1
 
5.0%
Other Punctuation
ValueCountFrequency (%)
* 60
93.8%
, 4
 
6.2%

Most occurring scripts

ValueCountFrequency (%)
Hangul 158
65.3%
Common 84
34.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
외 20
 
12.7%
명 18
 
11.4%
이 10
 
6.3%
김 9
 
5.7%
박 7
 
4.4%
최 5
 
3.2%
임 4
 
2.5%
장 4
 
2.5%
석 3
 
1.9%
원 3
 
1.9%
Other values (53) 75
47.5%
Common
ValueCountFrequency (%)
* 60
71.4%
6 6
 
7.1%
, 4
 
4.8%
2 3
 
3.6%
4 3
 
3.6%
3 3
 
3.6%
5 3
 
3.6%
7 1
 
1.2%
1 1
 
1.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 158
65.3%
ASCII 84
34.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
* 60
71.4%
6 6
 
7.1%
, 4
 
4.8%
2 3
 
3.6%
4 3
 
3.6%
3 3
 
3.6%
5 3
 
3.6%
7 1
 
1.2%
1 1
 
1.2%
Hangul
ValueCountFrequency (%)
외 20
 
12.7%
명 18
 
11.4%
이 10
 
6.3%
김 9
 
5.7%
박 7
 
4.4%
최 5
 
3.2%
임 4
 
2.5%
장 4
 
2.5%
석 3
 
1.9%
원 3
 
1.9%
Other values (53) 75
47.5%

전화번호
Text

MISSING 

Distinct52
Distinct (%)96.3%
Missing2
Missing (%)3.6%
Memory size576.0 B
2024-03-14T20:10:48.354056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.018519
Min length12

Characters and Unicode

Total characters649
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

Unique50 ?
Unique (%)92.6%

Sample

1st row063-253-0300
2nd row063-858-1625
3rd row063-854-2221
4th row063-278-8771
5th row063-252-1341
ValueCountFrequency (%)
063-237-2100 2
 
3.7%
063-535-0401 2
 
3.7%
063-626-8382 1
 
1.9%
063-253-0300 1
 
1.9%
063-835-1520 1
 
1.9%
063-537-1921 1
 
1.9%
063-277-5678 1
 
1.9%
063-838-8600 1
 
1.9%
063-564-8885 1
 
1.9%
063-228-8771 1
 
1.9%
Other values (42) 42
77.8%
2024-03-14T20:10:49.666935image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 108
16.6%
6 94
14.5%
3 92
14.2%
0 89
13.7%
2 76
11.7%
8 43
 
6.6%
1 41
 
6.3%
5 31
 
4.8%
7 30
 
4.6%
4 28
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 541
83.4%
Dash Punctuation 108
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 94
17.4%
3 92
17.0%
0 89
16.5%
2 76
14.0%
8 43
7.9%
1 41
7.6%
5 31
 
5.7%
7 30
 
5.5%
4 28
 
5.2%
9 17
 
3.1%
Dash Punctuation
ValueCountFrequency (%)
- 108
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 649
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 108
16.6%
6 94
14.5%
3 92
14.2%
0 89
13.7%
2 76
11.7%
8 43
 
6.6%
1 41
 
6.3%
5 31
 
4.8%
7 30
 
4.6%
4 28
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 649
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 108
16.6%
6 94
14.5%
3 92
14.2%
0 89
13.7%
2 76
11.7%
8 43
 
6.6%
1 41
 
6.3%
5 31
 
4.8%
7 30
 
4.6%
4 28
 
4.3%

주소
Text

UNIQUE 

Distinct56
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size576.0 B
2024-03-14T20:10:50.927457image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length31
Mean length27.285714
Min length15

Characters and Unicode

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

Unique

Unique56 ?
Unique (%)100.0%

Sample

1st row고창군 고창읍 덕산리 257-1(보릿골로 57-12) 3호
2nd row고창군 고창읍 월곡공원2길 43
3rd row군산시 검다메안길 6-8, 202(조촌동)
4th row군산시 나운로 3 (나운동 534-3)
5th row군산시 대학로 507 (미룡동 444)
ValueCountFrequency (%)
전주시 24
 
8.2%
완산구 16
 
5.5%
익산시 12
 
4.1%
덕진구 8
 
2.7%
군산시 7
 
2.4%
정읍시 7
 
2.4%
효자동3가 5
 
1.7%
영등동 4
 
1.4%
남원시 3
 
1.0%
고창군 2
 
0.7%
Other values (196) 205
70.0%
2024-03-14T20:10:52.619524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
268
 
17.5%
1 80
 
5.2%
2 64
 
4.2%
동 59
 
3.9%
( 55
 
3.6%
3 55
 
3.6%
) 55
 
3.6%
시 54
 
3.5%
산 51
 
3.3%
- 51
 
3.3%
Other values (134) 736
48.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 682
44.6%
Decimal Number 410
26.8%
Space Separator 268
 
17.5%
Open Punctuation 55
 
3.6%
Close Punctuation 55
 
3.6%
Dash Punctuation 51
 
3.3%
Other Punctuation 7
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 59
 
8.7%
시 54
 
7.9%
산 51
 
7.5%
로 35
 
5.1%
주 29
 
4.3%
전 27
 
4.0%
길 27
 
4.0%
구 25
 
3.7%
가 24
 
3.5%
완 16
 
2.3%
Other values (117) 335
49.1%
Decimal Number
ValueCountFrequency (%)
1 80
19.5%
2 64
15.6%
3 55
13.4%
5 48
11.7%
4 36
8.8%
6 34
8.3%
7 26
 
6.3%
0 25
 
6.1%
8 22
 
5.4%
9 20
 
4.9%
Other Punctuation
ValueCountFrequency (%)
, 5
71.4%
@ 1
 
14.3%
/ 1
 
14.3%
Space Separator
ValueCountFrequency (%)
268
100.0%
Open Punctuation
ValueCountFrequency (%)
( 55
100.0%
Close Punctuation
ValueCountFrequency (%)
) 55
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 51
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 846
55.4%
Hangul 682
44.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 59
 
8.7%
시 54
 
7.9%
산 51
 
7.5%
로 35
 
5.1%
주 29
 
4.3%
전 27
 
4.0%
길 27
 
4.0%
구 25
 
3.7%
가 24
 
3.5%
완 16
 
2.3%
Other values (117) 335
49.1%
Common
ValueCountFrequency (%)
268
31.7%
1 80
 
9.5%
2 64
 
7.6%
( 55
 
6.5%
3 55
 
6.5%
) 55
 
6.5%
- 51
 
6.0%
5 48
 
5.7%
4 36
 
4.3%
6 34
 
4.0%
Other values (7) 100
 
11.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 846
55.4%
Hangul 682
44.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
268
31.7%
1 80
 
9.5%
2 64
 
7.6%
( 55
 
6.5%
3 55
 
6.5%
) 55
 
6.5%
- 51
 
6.0%
5 48
 
5.7%
4 36
 
4.3%
6 34
 
4.0%
Other values (7) 100
 
11.8%
Hangul
ValueCountFrequency (%)
동 59
 
8.7%
시 54
 
7.9%
산 51
 
7.5%
로 35
 
5.1%
주 29
 
4.3%
전 27
 
4.0%
길 27
 
4.0%
구 25
 
3.7%
가 24
 
3.5%
완 16
 
2.3%
Other values (117) 335
49.1%

Correlations

2024-03-14T20:10:52.887000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업체명대표자전화번호주소
업체명1.0001.0001.0001.000
대표자1.0001.0000.9941.000
전화번호1.0000.9941.0001.000
주소1.0001.0001.0001.000

Missing values

2024-03-14T20:10:41.676239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T20:10:41.951694image/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(주)케시이*실063-253-0300고창군 고창읍 덕산리 257-1(보릿골로 57-12) 3호
1전북전기관리공사한*규외1명063-858-1625고창군 고창읍 월곡공원2길 43
2한국전기관리소서*석외6명063-854-2221군산시 검다메안길 6-8, 202(조촌동)
3대한전기안전관리김*열외4명063-278-8771군산시 나운로 3 (나운동 534-3)
4(유)호남전기안전관리최*열063-252-1341군산시 대학로 507 (미룡동 444)
5나라전기관리공사최*관063-232-6330군산시 번영로 159 (조촌동 895-16) 현대한솔@상가 103
6(유)한국관리공사정*택063-226-6417군산시 상지곡안4길 38 (지곡동 511-11)
7(유)군장전기안전관리소전*배063-442-2666군산시 월명로 416-1 (미원동 37)
8(유)한국전력보안공사임*훈063-222-6627군산시 칠성안3길 14 (산북동 3622-2)
9전북전기사업소김*태063-242-6321남원시 시청동로 21 (도통동 532-6)
업체명대표자전화번호주소
46전북전기기술공사이*열외4명063-853-1520전주시 완산구 전주객사5길 47 (고사동 203-6) 603호
47㈜전기안전관리컨설팅조*중063-451-9050전주시 완산구 황강서원4길 15-6 (효자동3가 1604-12) 온세미로빌102호
48(유)대한전기안전관리공사채*진,문*대063-286-9800전주시 완산구 효자로 2 (효자동3가 1071)
49(유)장안전기안전관리장*섭063-226-0189정읍시 동부4길 30-1(상동)
50그린전기안전관리김*주063-538-8966정읍시 벚꽃로 539-11(상동)
51반디이엔에스김*순<NA>정읍시 북면 3산단1길 88 (북면 태곡리 929)
52주식회사 희성박*석070-8252-1911정읍시 서부산업도로 476,202호(수성동)
53주식회사 서브원이*홍02-6924-4102정읍시 서부산업도로 552 (하북동 191-17)
54유한회사 삼인전기안전관리최*경<NA>정읍시 연지1길 34 (연지동 305-72)
55유한회사삼성전기관리공사박*완063-535-0401정읍시 연지동 305-95