Overview

Dataset statistics

Number of variables6
Number of observations43
Missing cells2
Missing cells (%)0.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.1 KiB
Average record size in memory51.1 B

Variable types

Categorical1
Text4
DateTime1

Dataset

Description2023년 9월 현황입니다.광주광역시 관내에 있는 전기감리업체 현황으로 업종구분(감리종합, 감리전문), 업체명, 대표자, 소재지도로명주소, 전화번호 항목으로 구성되어 있습니다.
Author광주광역시
URLhttps://www.data.go.kr/data/15043915/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 2 (4.7%) missing valuesMissing
상호 has unique valuesUnique
대표자 has unique valuesUnique

Reproduction

Analysis started2023-12-12 11:54:44.895368
Analysis finished2023-12-12 11:54:45.549666
Duration0.65 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종구분
Categorical

Distinct2
Distinct (%)4.7%
Missing0
Missing (%)0.0%
Memory size476.0 B
감리전문
30 
감리종합
13 

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 (%)
감리전문 30
69.8%
감리종합 13
30.2%

Length

2023-12-12T20:54:45.642120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:54:45.771404image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
감리전문 30
69.8%
감리종합 13
30.2%

상호
Text

UNIQUE 

Distinct43
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size476.0 B
2023-12-12T20:54:46.053689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length12
Mean length8.9534884
Min length5

Characters and Unicode

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

Unique

Unique43 ?
Unique (%)100.0%

Sample

1st row(주)영상엔지니어링
2nd row(주)이건종합건축사사무소
3rd row(주)선진이앤에프
4th row기술사사무소삼흥엔지니어스(주)
5th row(유)빛고을엔지니어링
ValueCountFrequency (%)
주)영상엔지니어링 1
 
2.3%
주)엔에스엔지니어링 1
 
2.3%
주)탑인프라 1
 
2.3%
화성엔지니어링 1
 
2.3%
한걸음(주 1
 
2.3%
태연엔지니어링(주 1
 
2.3%
유)이에프 1
 
2.3%
메타이엔지(주 1
 
2.3%
주)알파엔지니어링 1
 
2.3%
주)대담엔지니어링 1
 
2.3%
Other values (33) 33
76.7%
2023-12-12T20:54:46.557178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
( 38
 
9.9%
) 38
 
9.9%
주 35
 
9.1%
엔 21
 
5.5%
지 21
 
5.5%
니 15
 
3.9%
어 15
 
3.9%
이 15
 
3.9%
링 14
 
3.6%
기 11
 
2.9%
Other values (89) 162
42.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 304
79.0%
Open Punctuation 38
 
9.9%
Close Punctuation 38
 
9.9%
Uppercase Letter 3
 
0.8%
Decimal Number 2
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 35
 
11.5%
엔 21
 
6.9%
지 21
 
6.9%
니 15
 
4.9%
어 15
 
4.9%
이 15
 
4.9%
링 14
 
4.6%
기 11
 
3.6%
사 8
 
2.6%
술 7
 
2.3%
Other values (82) 142
46.7%
Uppercase Letter
ValueCountFrequency (%)
E 1
33.3%
G 1
33.3%
N 1
33.3%
Decimal Number
ValueCountFrequency (%)
2 1
50.0%
1 1
50.0%
Open Punctuation
ValueCountFrequency (%)
( 38
100.0%
Close Punctuation
ValueCountFrequency (%)
) 38
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 304
79.0%
Common 78
 
20.3%
Latin 3
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 35
 
11.5%
엔 21
 
6.9%
지 21
 
6.9%
니 15
 
4.9%
어 15
 
4.9%
이 15
 
4.9%
링 14
 
4.6%
기 11
 
3.6%
사 8
 
2.6%
술 7
 
2.3%
Other values (82) 142
46.7%
Common
ValueCountFrequency (%)
( 38
48.7%
) 38
48.7%
2 1
 
1.3%
1 1
 
1.3%
Latin
ValueCountFrequency (%)
E 1
33.3%
G 1
33.3%
N 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 304
79.0%
ASCII 81
 
21.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
( 38
46.9%
) 38
46.9%
E 1
 
1.2%
G 1
 
1.2%
N 1
 
1.2%
2 1
 
1.2%
1 1
 
1.2%
Hangul
ValueCountFrequency (%)
주 35
 
11.5%
엔 21
 
6.9%
지 21
 
6.9%
니 15
 
4.9%
어 15
 
4.9%
이 15
 
4.9%
링 14
 
4.6%
기 11
 
3.6%
사 8
 
2.6%
술 7
 
2.3%
Other values (82) 142
46.7%

대표자
Text

UNIQUE 

Distinct43
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size476.0 B
2023-12-12T20:54:46.873115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length3
Mean length3.255814
Min length2

Characters and Unicode

Total characters140
Distinct characters64
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

Unique43 ?
Unique (%)100.0%

Sample

1st row이안수
2nd row양상훈
3rd row정회광
4th row서강기,김경숙
5th row김만곤
ValueCountFrequency (%)
이안수 1
 
2.3%
김대열 1
 
2.3%
정현철,정회걸,정순필 1
 
2.3%
정운호 1
 
2.3%
정상인 1
 
2.3%
성인숙 1
 
2.3%
박일규 1
 
2.3%
박상일 1
 
2.3%
한경철 1
 
2.3%
김현덕 1
 
2.3%
Other values (33) 33
76.7%
2023-12-12T20:54:47.326957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
정 11
 
7.9%
이 8
 
5.7%
김 8
 
5.7%
박 8
 
5.7%
현 6
 
4.3%
호 5
 
3.6%
상 4
 
2.9%
성 4
 
2.9%
인 4
 
2.9%
, 3
 
2.1%
Other values (54) 79
56.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 137
97.9%
Other Punctuation 3
 
2.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
정 11
 
8.0%
이 8
 
5.8%
김 8
 
5.8%
박 8
 
5.8%
현 6
 
4.4%
호 5
 
3.6%
상 4
 
2.9%
성 4
 
2.9%
인 4
 
2.9%
경 3
 
2.2%
Other values (53) 76
55.5%
Other Punctuation
ValueCountFrequency (%)
, 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 137
97.9%
Common 3
 
2.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
정 11
 
8.0%
이 8
 
5.8%
김 8
 
5.8%
박 8
 
5.8%
현 6
 
4.4%
호 5
 
3.6%
상 4
 
2.9%
성 4
 
2.9%
인 4
 
2.9%
경 3
 
2.2%
Other values (53) 76
55.5%
Common
ValueCountFrequency (%)
, 3
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 137
97.9%
ASCII 3
 
2.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
정 11
 
8.0%
이 8
 
5.8%
김 8
 
5.8%
박 8
 
5.8%
현 6
 
4.4%
호 5
 
3.6%
상 4
 
2.9%
성 4
 
2.9%
인 4
 
2.9%
경 3
 
2.2%
Other values (53) 76
55.5%
ASCII
ValueCountFrequency (%)
, 3
100.0%

소재지도로명주소
Text

Distinct41
Distinct (%)95.3%
Missing0
Missing (%)0.0%
Memory size476.0 B
2023-12-12T20:54:47.711615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length63
Median length42
Mean length36.186047
Min length27

Characters and Unicode

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

Unique

Unique40 ?
Unique (%)93.0%

Sample

1st row광주광역시 북구 일곡마을로 39 (일곡동 847-3)
2nd row광주광역시 동구 중앙로 306 (계림동 181-7) 신양빌딩
3rd row광주광역시 북구 월동로 81-4 (각화동 181-11)
4th row광주광역시 북구 우치로 5 (중흥동 349-38)
5th row광주광역시 남구 서문대로 556 (송하동 45-2) 3층
ValueCountFrequency (%)
광주광역시 43
 
14.2%
북구 17
 
5.6%
서구 15
 
5.0%
일곡동 4
 
1.3%
매월동 4
 
1.3%
남구 4
 
1.3%
광산구 4
 
1.3%
39 3
 
1.0%
847-3 3
 
1.0%
동구 3
 
1.0%
Other values (173) 202
66.9%
2023-12-12T20:54:48.582537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
259
 
16.6%
광 91
 
5.8%
1 91
 
5.8%
동 57
 
3.7%
2 57
 
3.7%
- 52
 
3.3%
3 47
 
3.0%
구 44
 
2.8%
) 44
 
2.8%
주 44
 
2.8%
Other values (121) 770
49.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 742
47.7%
Decimal Number 413
26.5%
Space Separator 259
 
16.6%
Dash Punctuation 52
 
3.3%
Close Punctuation 44
 
2.8%
Open Punctuation 44
 
2.8%
Other Punctuation 1
 
0.1%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 91
 
12.3%
동 57
 
7.7%
구 44
 
5.9%
주 44
 
5.9%
역 43
 
5.8%
시 43
 
5.8%
로 42
 
5.7%
서 17
 
2.3%
북 17
 
2.3%
호 16
 
2.2%
Other values (105) 328
44.2%
Decimal Number
ValueCountFrequency (%)
1 91
22.0%
2 57
13.8%
3 47
11.4%
0 40
9.7%
4 37
9.0%
5 34
 
8.2%
6 30
 
7.3%
8 28
 
6.8%
7 25
 
6.1%
9 24
 
5.8%
Space Separator
ValueCountFrequency (%)
259
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 52
100.0%
Close Punctuation
ValueCountFrequency (%)
) 44
100.0%
Open Punctuation
ValueCountFrequency (%)
( 44
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 813
52.2%
Hangul 742
47.7%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 91
 
12.3%
동 57
 
7.7%
구 44
 
5.9%
주 44
 
5.9%
역 43
 
5.8%
시 43
 
5.8%
로 42
 
5.7%
서 17
 
2.3%
북 17
 
2.3%
호 16
 
2.2%
Other values (105) 328
44.2%
Common
ValueCountFrequency (%)
259
31.9%
1 91
 
11.2%
2 57
 
7.0%
- 52
 
6.4%
3 47
 
5.8%
) 44
 
5.4%
( 44
 
5.4%
0 40
 
4.9%
4 37
 
4.6%
5 34
 
4.2%
Other values (5) 108
13.3%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 814
52.3%
Hangul 742
47.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
259
31.8%
1 91
 
11.2%
2 57
 
7.0%
- 52
 
6.4%
3 47
 
5.8%
) 44
 
5.4%
( 44
 
5.4%
0 40
 
4.9%
4 37
 
4.5%
5 34
 
4.2%
Other values (6) 109
13.4%
Hangul
ValueCountFrequency (%)
광 91
 
12.3%
동 57
 
7.7%
구 44
 
5.9%
주 44
 
5.9%
역 43
 
5.8%
시 43
 
5.8%
로 42
 
5.7%
서 17
 
2.3%
북 17
 
2.3%
호 16
 
2.2%
Other values (105) 328
44.2%

전화번호
Text

MISSING 

Distinct40
Distinct (%)97.6%
Missing2
Missing (%)4.7%
Memory size476.0 B
2023-12-12T20:54:48.872979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.097561
Min length12

Characters and Unicode

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

Unique39 ?
Unique (%)95.1%

Sample

1st row062-574-3100
2nd row062-234-1100
3rd row062-265-5404
4th row062-526-4637
5th row062-673-7373
ValueCountFrequency (%)
062-574-3123 2
 
4.9%
062-610-5693 1
 
2.4%
062-384-8231 1
 
2.4%
062-574-3100 1
 
2.4%
062-953-8118 1
 
2.4%
062-716-5383 1
 
2.4%
062-531-4450 1
 
2.4%
070-8281-7911 1
 
2.4%
062-375-7620 1
 
2.4%
062-603-2866 1
 
2.4%
Other values (30) 30
73.2%
2023-12-12T20:54:49.265176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 82
16.5%
0 74
14.9%
6 66
13.3%
2 66
13.3%
3 39
7.9%
7 37
7.5%
1 36
7.3%
5 33
6.7%
4 30
 
6.0%
8 19
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 414
83.5%
Dash Punctuation 82
 
16.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 74
17.9%
6 66
15.9%
2 66
15.9%
3 39
9.4%
7 37
8.9%
1 36
8.7%
5 33
8.0%
4 30
7.2%
8 19
 
4.6%
9 14
 
3.4%
Dash Punctuation
ValueCountFrequency (%)
- 82
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 496
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 82
16.5%
0 74
14.9%
6 66
13.3%
2 66
13.3%
3 39
7.9%
7 37
7.5%
1 36
7.3%
5 33
6.7%
4 30
 
6.0%
8 19
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 496
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 82
16.5%
0 74
14.9%
6 66
13.3%
2 66
13.3%
3 39
7.9%
7 37
7.5%
1 36
7.3%
5 33
6.7%
4 30
 
6.0%
8 19
 
3.8%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size476.0 B
Minimum2023-09-15 00:00:00
Maximum2023-09-15 00:00:00
2023-12-12T20:54:49.428314image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:54:49.541862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-12T20:54:49.639452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종구분상호대표자소재지도로명주소전화번호
업종구분1.0001.0001.0000.0001.000
상호1.0001.0001.0001.0001.000
대표자1.0001.0001.0001.0001.000
소재지도로명주소0.0001.0001.0001.0001.000
전화번호1.0001.0001.0001.0001.000

Missing values

2023-12-12T20:54:45.341730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T20:54:45.499958image/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감리종합(주)영상엔지니어링이안수광주광역시 북구 일곡마을로 39 (일곡동 847-3)062-574-31002023-09-15
1감리종합(주)이건종합건축사사무소양상훈광주광역시 동구 중앙로 306 (계림동 181-7) 신양빌딩062-234-11002023-09-15
2감리종합(주)선진이앤에프정회광광주광역시 북구 월동로 81-4 (각화동 181-11)062-265-54042023-09-15
3감리종합기술사사무소삼흥엔지니어스(주)서강기,김경숙광주광역시 북구 우치로 5 (중흥동 349-38)062-526-46372023-09-15
4감리종합(유)빛고을엔지니어링김만곤광주광역시 남구 서문대로 556 (송하동 45-2) 3층062-673-73732023-09-15
5감리종합(주)21세기이엔지조호성광주광역시 동구 동명로67번길 22-31 (산수동 359-32)062-652-22902023-09-15
6감리종합(주)송하기술감리백승호광주광역시 북구 첨단과기로208번길 17-29 (오룡동 1110-34) 제레드비동 8호062-512-09092023-09-15
7감리종합(주)미드엔지니어링건축사사무소안태경광주광역시 남구 대남대로 267 (백운동 651-3) 303호062-511-96502023-09-15
8감리종합(주)건창기술단류백호광주광역시 서구 풍암신흥로62번길 3-38 (풍암동 1036-24)062-655-71192023-09-15
9감리종합(주)양일테크박정훈광주광역시 서구 유덕로 50-1 (유촌동 599-15)070-7713-06762023-09-15
업종구분상호대표자소재지도로명주소전화번호데이터기준일자
33감리전문(유)다온엔지니어링주현이광주광역시 서구 풍암중앙로91번길 4-3 (풍암동 1163-4)062-383-46622023-09-15
34감리전문(주)유원정호성광주광역시 서구 유덕로 22-6 (유촌동 495) 205호070-4252-87542023-09-15
35감리전문(주)한빛네트웍스황생동광주광역시 광산구 어등대로595번길 23 (운수동 68-67)062-971-70002023-09-15
36감리전문(주)대담이노텍김유연광주광역시 북구 동문대로 116 (두암동 859-11) 501호062-412-11772023-09-15
37감리전문(주)에이스에너지임채윤광주광역시 서구 무진대로 571-1 (덕흥동 28-11) , 1층070-4442-31682023-09-15
38감리전문드림전기솔라(주)정율래광주광역시 동구 화산로350번길 18 (용산동 177) 상가동 비-7호061-332-87002023-09-15
39감리전문(주)신가전기유정남광주광역시 서구 풍암2로 2 (풍암동 1109-1) 롯데슈퍼센터 4층402호062-651-40242023-09-15
40감리전문(주)미래건설안전윤양실광주광역시 북구 첨단과기로208번길 43-22 (오룡동 1110-43) 와이어스파크(지식산업센터) B동 2008호062-376-04492023-09-15
41감리전문(주)대광종합기술이주상광주광역시 북구 일곡마을로 39 (일곡동 847-3)062-574-31232023-09-15
42감리전문(주)전원기술단이몽실광주광역시 남구 구성로 70-1 (월산동 23-7) 201호062-675-47002023-09-15