Overview

Dataset statistics

Number of variables6
Number of observations38
Missing cells2
Missing cells (%)0.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.9 KiB
Average record size in memory51.5 B

Variable types

Categorical1
Text4
DateTime1

Dataset

Description2023년 9월 현황입니다.광주광역시 내 전기설계업체 현황에 대한 데이터입니다. 업종, 상호명, 소재지도로명주소, 전화번호 등의 항목을 제공합니다.
Author광주광역시
URLhttps://www.data.go.kr/data/15043914/fileData.do

Alerts

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

Reproduction

Analysis started2023-12-11 22:58:27.151295
Analysis finished2023-12-11 22:58:27.614851
Duration0.46 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종구분
Categorical

Distinct2
Distinct (%)5.3%
Missing0
Missing (%)0.0%
Memory size436.0 B
설계전문1종
24 
설계전문2종
14 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row설계전문1종
2nd row설계전문1종
3rd row설계전문1종
4th row설계전문1종
5th row설계전문1종

Common Values

ValueCountFrequency (%)
설계전문1종 24
63.2%
설계전문2종 14
36.8%

Length

2023-12-12T07:58:27.674997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:58:27.766661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
설계전문1종 24
63.2%
설계전문2종 14
36.8%

상호
Text

UNIQUE 

Distinct38
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size436.0 B
2023-12-12T07:58:27.951084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length12
Mean length8.8421053
Min length5

Characters and Unicode

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

Unique

Unique38 ?
Unique (%)100.0%

Sample

1st row(주)영상엔지니어링
2nd row엔지니어링그룹에이원
3rd row(주)선진이앤에프
4th row기술사사무소삼흥엔지니어스(주)
5th row(주)좋은엔지니어링
ValueCountFrequency (%)
주)영상엔지니어링 1
 
2.6%
대삼엔지니어링 1
 
2.6%
주)신가전기 1
 
2.6%
주)티아이에너지 1
 
2.6%
주)이룸전기기술사사무소 1
 
2.6%
주)전원기술단 1
 
2.6%
주)이건종합건축사사무소 1
 
2.6%
주)아이디테크 1
 
2.6%
주)정인엔지니어링 1
 
2.6%
주)양일테크 1
 
2.6%
Other values (28) 28
73.7%
2023-12-12T07:58:28.254975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
( 32
 
9.5%
) 32
 
9.5%
주 30
 
8.9%
지 20
 
6.0%
엔 19
 
5.7%
이 15
 
4.5%
니 14
 
4.2%
어 14
 
4.2%
링 13
 
3.9%
기 8
 
2.4%
Other values (80) 139
41.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 269
80.1%
Open Punctuation 32
 
9.5%
Close Punctuation 32
 
9.5%
Uppercase Letter 3
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 30
 
11.2%
지 20
 
7.4%
엔 19
 
7.1%
이 15
 
5.6%
니 14
 
5.2%
어 14
 
5.2%
링 13
 
4.8%
기 8
 
3.0%
에 8
 
3.0%
사 6
 
2.2%
Other values (75) 122
45.4%
Uppercase Letter
ValueCountFrequency (%)
E 1
33.3%
N 1
33.3%
G 1
33.3%
Open Punctuation
ValueCountFrequency (%)
( 32
100.0%
Close Punctuation
ValueCountFrequency (%)
) 32
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 269
80.1%
Common 64
 
19.0%
Latin 3
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 30
 
11.2%
지 20
 
7.4%
엔 19
 
7.1%
이 15
 
5.6%
니 14
 
5.2%
어 14
 
5.2%
링 13
 
4.8%
기 8
 
3.0%
에 8
 
3.0%
사 6
 
2.2%
Other values (75) 122
45.4%
Latin
ValueCountFrequency (%)
E 1
33.3%
N 1
33.3%
G 1
33.3%
Common
ValueCountFrequency (%)
( 32
50.0%
) 32
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 269
80.1%
ASCII 67
 
19.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
( 32
47.8%
) 32
47.8%
E 1
 
1.5%
N 1
 
1.5%
G 1
 
1.5%
Hangul
ValueCountFrequency (%)
주 30
 
11.2%
지 20
 
7.4%
엔 19
 
7.1%
이 15
 
5.6%
니 14
 
5.2%
어 14
 
5.2%
링 13
 
4.8%
기 8
 
3.0%
에 8
 
3.0%
사 6
 
2.2%
Other values (75) 122
45.4%

대표자
Text

UNIQUE 

Distinct38
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size436.0 B
2023-12-12T07:58:28.472072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length3
Mean length3.2894737
Min length2

Characters and Unicode

Total characters125
Distinct characters59
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

Unique38 ?
Unique (%)100.0%

Sample

1st row이안수
2nd row한영미
3rd row정회광
4th row서강기,김경숙
5th row박규남
ValueCountFrequency (%)
이안수 1
 
2.6%
박현자 1
 
2.6%
유정남 1
 
2.6%
정현철 1
 
2.6%
박자영 1
 
2.6%
이몽실 1
 
2.6%
양상훈 1
 
2.6%
박철선 1
 
2.6%
이명수 1
 
2.6%
박정훈 1
 
2.6%
Other values (28) 28
73.7%
2023-12-12T07:58:28.876068image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
정 11
 
8.8%
이 8
 
6.4%
현 7
 
5.6%
김 7
 
5.6%
박 7
 
5.6%
상 4
 
3.2%
호 4
 
3.2%
철 4
 
3.2%
주 3
 
2.4%
수 3
 
2.4%
Other values (49) 67
53.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 122
97.6%
Other Punctuation 3
 
2.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
정 11
 
9.0%
이 8
 
6.6%
현 7
 
5.7%
김 7
 
5.7%
박 7
 
5.7%
상 4
 
3.3%
호 4
 
3.3%
철 4
 
3.3%
주 3
 
2.5%
수 3
 
2.5%
Other values (48) 64
52.5%
Other Punctuation
ValueCountFrequency (%)
, 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 122
97.6%
Common 3
 
2.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
정 11
 
9.0%
이 8
 
6.6%
현 7
 
5.7%
김 7
 
5.7%
박 7
 
5.7%
상 4
 
3.3%
호 4
 
3.3%
철 4
 
3.3%
주 3
 
2.5%
수 3
 
2.5%
Other values (48) 64
52.5%
Common
ValueCountFrequency (%)
, 3
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 122
97.6%
ASCII 3
 
2.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
정 11
 
9.0%
이 8
 
6.6%
현 7
 
5.7%
김 7
 
5.7%
박 7
 
5.7%
상 4
 
3.3%
호 4
 
3.3%
철 4
 
3.3%
주 3
 
2.5%
수 3
 
2.5%
Other values (48) 64
52.5%
ASCII
ValueCountFrequency (%)
, 3
100.0%

주소
Text

Distinct35
Distinct (%)92.1%
Missing0
Missing (%)0.0%
Memory size436.0 B
2023-12-12T07:58:29.229805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length40
Mean length35.631579
Min length27

Characters and Unicode

Total characters1354
Distinct characters126
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

Unique33 ?
Unique (%)86.8%

Sample

1st row광주광역시 북구 일곡마을로 39 (일곡동 847-3)
2nd row광주광역시 광산구 왕버들로 287 (신창동 1136-3) 2층
3rd row광주광역시 북구 월동로 81-4 (각화동 181-11)
4th row광주광역시 북구 우치로 5 (중흥동 349-38)
5th row광주광역시 서구 대남대로 473-2 (농성동 648-5) 3층
ValueCountFrequency (%)
광주광역시 38
 
14.2%
서구 15
 
5.6%
북구 14
 
5.2%
광산구 5
 
1.9%
매월동 4
 
1.5%
일곡동 4
 
1.5%
847-3 3
 
1.1%
치평동 3
 
1.1%
일곡마을로 3
 
1.1%
남구 3
 
1.1%
Other values (144) 175
65.5%
2023-12-12T07:58:29.768693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
229
 
16.9%
1 84
 
6.2%
광 82
 
6.1%
2 50
 
3.7%
동 46
 
3.4%
- 45
 
3.3%
3 39
 
2.9%
구 39
 
2.9%
주 39
 
2.9%
역 38
 
2.8%
Other values (116) 663
49.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 645
47.6%
Decimal Number 358
26.4%
Space Separator 229
 
16.9%
Dash Punctuation 45
 
3.3%
Open Punctuation 38
 
2.8%
Close Punctuation 38
 
2.8%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 82
 
12.7%
동 46
 
7.1%
구 39
 
6.0%
주 39
 
6.0%
역 38
 
5.9%
시 38
 
5.9%
로 37
 
5.7%
서 16
 
2.5%
북 14
 
2.2%
월 13
 
2.0%
Other values (101) 283
43.9%
Decimal Number
ValueCountFrequency (%)
1 84
23.5%
2 50
14.0%
3 39
10.9%
4 33
 
9.2%
0 31
 
8.7%
8 27
 
7.5%
5 26
 
7.3%
6 24
 
6.7%
9 22
 
6.1%
7 22
 
6.1%
Space Separator
ValueCountFrequency (%)
229
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 45
100.0%
Open Punctuation
ValueCountFrequency (%)
( 38
100.0%
Close Punctuation
ValueCountFrequency (%)
) 38
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 709
52.4%
Hangul 645
47.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 82
 
12.7%
동 46
 
7.1%
구 39
 
6.0%
주 39
 
6.0%
역 38
 
5.9%
시 38
 
5.9%
로 37
 
5.7%
서 16
 
2.5%
북 14
 
2.2%
월 13
 
2.0%
Other values (101) 283
43.9%
Common
ValueCountFrequency (%)
229
32.3%
1 84
 
11.8%
2 50
 
7.1%
- 45
 
6.3%
3 39
 
5.5%
( 38
 
5.4%
) 38
 
5.4%
4 33
 
4.7%
0 31
 
4.4%
8 27
 
3.8%
Other values (5) 95
13.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 709
52.4%
Hangul 645
47.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
229
32.3%
1 84
 
11.8%
2 50
 
7.1%
- 45
 
6.3%
3 39
 
5.5%
( 38
 
5.4%
) 38
 
5.4%
4 33
 
4.7%
0 31
 
4.4%
8 27
 
3.8%
Other values (5) 95
13.4%
Hangul
ValueCountFrequency (%)
광 82
 
12.7%
동 46
 
7.1%
구 39
 
6.0%
주 39
 
6.0%
역 38
 
5.9%
시 38
 
5.9%
로 37
 
5.7%
서 16
 
2.5%
북 14
 
2.2%
월 13
 
2.0%
Other values (101) 283
43.9%

전화번호
Text

MISSING 

Distinct35
Distinct (%)97.2%
Missing2
Missing (%)5.3%
Memory size436.0 B
2023-12-12T07:58:29.996171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.083333
Min length12

Characters and Unicode

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

Unique34 ?
Unique (%)94.4%

Sample

1st row062-574-3100
2nd row062-523-6403
3rd row062-265-5404
4th row062-526-4637
5th row062-383-7114
ValueCountFrequency (%)
062-574-3123 2
 
5.6%
062-383-0772 1
 
2.8%
062-523-6403 1
 
2.8%
070-4442-3168 1
 
2.8%
062-710-0425 1
 
2.8%
062-511-5928 1
 
2.8%
062-675-4700 1
 
2.8%
062-234-1100 1
 
2.8%
062-651-4024 1
 
2.8%
062-384-6333 1
 
2.8%
Other values (25) 25
69.4%
2023-12-12T07:58:30.346682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 72
16.6%
0 67
15.4%
6 58
13.3%
2 56
12.9%
3 36
8.3%
7 34
7.8%
1 31
7.1%
5 30
6.9%
4 27
 
6.2%
8 14
 
3.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 363
83.4%
Dash Punctuation 72
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 67
18.5%
6 58
16.0%
2 56
15.4%
3 36
9.9%
7 34
9.4%
1 31
8.5%
5 30
8.3%
4 27
7.4%
8 14
 
3.9%
9 10
 
2.8%
Dash Punctuation
ValueCountFrequency (%)
- 72
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 435
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 72
16.6%
0 67
15.4%
6 58
13.3%
2 56
12.9%
3 36
8.3%
7 34
7.8%
1 31
7.1%
5 30
6.9%
4 27
 
6.2%
8 14
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 435
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 72
16.6%
0 67
15.4%
6 58
13.3%
2 56
12.9%
3 36
8.3%
7 34
7.8%
1 31
7.1%
5 30
6.9%
4 27
 
6.2%
8 14
 
3.2%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size436.0 B
Minimum2023-09-15 00:00:00
Maximum2023-09-15 00:00:00
2023-12-12T07:58:30.502911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T07:58:30.611803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-12T07:58:30.697901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종구분상호대표자주소전화번호
업종구분1.0001.0001.0000.6221.000
상호1.0001.0001.0001.0001.000
대표자1.0001.0001.0001.0001.000
주소0.6221.0001.0001.0001.000
전화번호1.0001.0001.0001.0001.000

Missing values

2023-12-12T07:58:27.447448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T07:58:27.549500image/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설계전문1종(주)영상엔지니어링이안수광주광역시 북구 일곡마을로 39 (일곡동 847-3)062-574-31002023-09-15
1설계전문1종엔지니어링그룹에이원한영미광주광역시 광산구 왕버들로 287 (신창동 1136-3) 2층062-523-64032023-09-15
2설계전문1종(주)선진이앤에프정회광광주광역시 북구 월동로 81-4 (각화동 181-11)062-265-54042023-09-15
3설계전문1종기술사사무소삼흥엔지니어스(주)서강기,김경숙광주광역시 북구 우치로 5 (중흥동 349-38)062-526-46372023-09-15
4설계전문1종(주)좋은엔지니어링박규남광주광역시 서구 대남대로 473-2 (농성동 648-5) 3층062-383-71142023-09-15
5설계전문1종(유)빛고을엔지니어링김만곤광주광역시 남구 서문대로 556 (송하동 45-2) 3층062-673-73732023-09-15
6설계전문1종(주)팔마이엔지박인수광주광역시 서구 매월2로15번길 16 (매월동 946) 매월 종합상가 202-209062-610-56932023-09-15
7설계전문1종원탑엔지니어링김지원광주광역시 광산구 수완로12번길 30 (신가동 1161) 401호062-522-05512023-09-15
8설계전문1종(주)엔에스엔지니어링김대열광주광역시 북구 양일로 147-40 (일곡동 684-1) 2층062-974-19972023-09-15
9설계전문1종(주)엘에이치엔지니어링이현광주광역시 북구 연양로105번길 40-2 (양산동 917)062-575-34712023-09-15
업종구분상호대표자주소전화번호데이터기준일자
28설계전문2종에이디이엔지이정석광주광역시 서구 매월2로 53 (매월동 948) 산업용재유통센터 9동203호<NA>2023-09-15
29설계전문2종(주)양일테크박정훈광주광역시 서구 유덕로 50-1 (유촌동 599-15)070-7713-06762023-09-15
30설계전문2종(주)대담이노텍김유연광주광역시 북구 동문대로 116 (두암동 859-11) 501호062-412-11772023-09-15
31설계전문2종(주)송하기술감리백승호광주광역시 북구 첨단과기로208번길 17-29 (오룡동 1110-34) 제레드비동 8호062-512-09092023-09-15
32설계전문2종(주)대담엔지니어링김현덕광주광역시 북구 동문대로 116 (두암동 859-11) 5층062-384-82312023-09-15
33설계전문2종(주)한빛네트웍스황생동광주광역시 광산구 어등대로595번길 23 (운수동 68-67)062-971-70002023-09-15
34설계전문2종(주)대광종합기술이주상광주광역시 북구 일곡마을로 39 (일곡동 847-3)062-574-31232023-09-15
35설계전문2종(주)유원정호성광주광역시 서구 유덕로 22-6 (유촌동 495) 205호070-4252-87542023-09-15
36설계전문2종(주)신가전기유정남광주광역시 서구 풍암2로 2 (풍암동 1109-1) 롯데슈퍼센터 4층402호062-651-40242023-09-15
37설계전문2종(주)하나이엔지강인석광주광역시 북구 비엔날레로 183-5 (용봉동 1347-1) 2층062-526-67022023-09-15