Overview

Dataset statistics

Number of variables5
Number of observations153
Missing cells62
Missing cells (%)8.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.1 KiB
Average record size in memory40.9 B

Variable types

Categorical2
Text3

Dataset

Description제주특별자치도 제주시 관내 공중위생업 관련 건물위생관리업 현황 데이터를 제공합니다.
Author제주특별자치도 제주시
URLhttps://www.data.go.kr/data/15056157/fileData.do

Alerts

업종명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
전화번호 has 62 (40.5%) missing valuesMissing
업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:06:43.186201
Analysis finished2023-12-12 14:06:43.549411
Duration0.36 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
건물위생관리업
153 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row건물위생관리업
2nd row건물위생관리업
3rd row건물위생관리업
4th row건물위생관리업
5th row건물위생관리업

Common Values

ValueCountFrequency (%)
건물위생관리업 153
100.0%

Length

2023-12-12T23:06:43.626474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:06:43.721597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
건물위생관리업 153
100.0%

업소명
Text

UNIQUE 

Distinct153
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-12T23:06:43.927432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length11
Mean length6.8888889
Min length2

Characters and Unicode

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

Unique

Unique153 ?
Unique (%)100.0%

Sample

1st row주식회사제이어스
2nd row빌클린 주식회사
3rd row아모렉스
4th row주식회사 더맨서비스
5th row(주)진혁
ValueCountFrequency (%)
주식회사 20
 
11.4%
유한회사 2
 
1.1%
주식회사제이어스 1
 
0.6%
주)제주맑은누리 1
 
0.6%
아라청소사업단 1
 
0.6%
그린제주 1
 
0.6%
제주용역 1
 
0.6%
일심선경개발 1
 
0.6%
성진개발 1
 
0.6%
클린통 1
 
0.6%
Other values (145) 145
82.9%
2023-12-12T23:06:44.304046image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 89
 
8.4%
스 43
 
4.1%
사 42
 
4.0%
) 40
 
3.8%
회 39
 
3.7%
( 39
 
3.7%
식 34
 
3.2%
린 28
 
2.7%
제 26
 
2.5%
클 23
 
2.2%
Other values (196) 651
61.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 951
90.2%
Close Punctuation 40
 
3.8%
Open Punctuation 39
 
3.7%
Space Separator 22
 
2.1%
Decimal Number 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 89
 
9.4%
스 43
 
4.5%
사 42
 
4.4%
회 39
 
4.1%
식 34
 
3.6%
린 28
 
2.9%
제 26
 
2.7%
클 23
 
2.4%
에 20
 
2.1%
경 19
 
2.0%
Other values (191) 588
61.8%
Decimal Number
ValueCountFrequency (%)
2 1
50.0%
6 1
50.0%
Close Punctuation
ValueCountFrequency (%)
) 40
100.0%
Open Punctuation
ValueCountFrequency (%)
( 39
100.0%
Space Separator
ValueCountFrequency (%)
22
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 951
90.2%
Common 103
 
9.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 89
 
9.4%
스 43
 
4.5%
사 42
 
4.4%
회 39
 
4.1%
식 34
 
3.6%
린 28
 
2.9%
제 26
 
2.7%
클 23
 
2.4%
에 20
 
2.1%
경 19
 
2.0%
Other values (191) 588
61.8%
Common
ValueCountFrequency (%)
) 40
38.8%
( 39
37.9%
22
21.4%
2 1
 
1.0%
6 1
 
1.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 951
90.2%
ASCII 103
 
9.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 89
 
9.4%
스 43
 
4.5%
사 42
 
4.4%
회 39
 
4.1%
식 34
 
3.6%
린 28
 
2.9%
제 26
 
2.7%
클 23
 
2.4%
에 20
 
2.1%
경 19
 
2.0%
Other values (191) 588
61.8%
ASCII
ValueCountFrequency (%)
) 40
38.8%
( 39
37.9%
22
21.4%
2 1
 
1.0%
6 1
 
1.0%

주소
Text

Distinct137
Distinct (%)89.5%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-12T23:06:44.661614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length25
Mean length19.96732
Min length17

Characters and Unicode

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

Unique

Unique124 ?
Unique (%)81.0%

Sample

1st row제주특별자치도 제주시 중앙로 217
2nd row제주특별자치도 제주시 광양9길 50
3rd row제주특별자치도 제주시 서해안로 216
4th row제주특별자치도 제주시 삼무로 15
5th row제주특별자치도 제주시 애월읍 신엄8길 21
ValueCountFrequency (%)
제주특별자치도 153
24.4%
제주시 153
24.4%
서광로 7
 
1.1%
도령로 7
 
1.1%
25 5
 
0.8%
조천읍 5
 
0.8%
애월읍 5
 
0.8%
10 5
 
0.8%
14 4
 
0.6%
15 4
 
0.6%
Other values (201) 278
44.4%
2023-12-12T23:06:45.229516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
475
15.5%
제 308
 
10.1%
주 307
 
10.0%
도 171
 
5.6%
특 153
 
5.0%
별 153
 
5.0%
자 153
 
5.0%
치 153
 
5.0%
시 153
 
5.0%
로 117
 
3.8%
Other values (108) 912
29.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2100
68.7%
Space Separator 475
 
15.5%
Decimal Number 457
 
15.0%
Dash Punctuation 23
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
제 308
14.7%
주 307
14.6%
도 171
8.1%
특 153
7.3%
별 153
7.3%
자 153
7.3%
치 153
7.3%
시 153
7.3%
로 117
 
5.6%
길 80
 
3.8%
Other values (96) 352
16.8%
Decimal Number
ValueCountFrequency (%)
1 106
23.2%
2 66
14.4%
3 57
12.5%
5 47
10.3%
6 42
 
9.2%
4 37
 
8.1%
0 32
 
7.0%
7 26
 
5.7%
9 25
 
5.5%
8 19
 
4.2%
Space Separator
ValueCountFrequency (%)
475
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 23
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2100
68.7%
Common 955
31.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
제 308
14.7%
주 307
14.6%
도 171
8.1%
특 153
7.3%
별 153
7.3%
자 153
7.3%
치 153
7.3%
시 153
7.3%
로 117
 
5.6%
길 80
 
3.8%
Other values (96) 352
16.8%
Common
ValueCountFrequency (%)
475
49.7%
1 106
 
11.1%
2 66
 
6.9%
3 57
 
6.0%
5 47
 
4.9%
6 42
 
4.4%
4 37
 
3.9%
0 32
 
3.4%
7 26
 
2.7%
9 25
 
2.6%
Other values (2) 42
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2100
68.7%
ASCII 955
31.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
475
49.7%
1 106
 
11.1%
2 66
 
6.9%
3 57
 
6.0%
5 47
 
4.9%
6 42
 
4.4%
4 37
 
3.9%
0 32
 
3.4%
7 26
 
2.7%
9 25
 
2.6%
Other values (2) 42
 
4.4%
Hangul
ValueCountFrequency (%)
제 308
14.7%
주 307
14.6%
도 171
8.1%
특 153
7.3%
별 153
7.3%
자 153
7.3%
치 153
7.3%
시 153
7.3%
로 117
 
5.6%
길 80
 
3.8%
Other values (96) 352
16.8%

전화번호
Text

MISSING 

Distinct91
Distinct (%)100.0%
Missing62
Missing (%)40.5%
Memory size1.3 KiB
2023-12-12T23:06:45.599930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.032967
Min length12

Characters and Unicode

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

Unique91 ?
Unique (%)100.0%

Sample

1st row064-702-2385
2nd row064-702-4447
3rd row064-711-0125
4th row064-711-0163
5th row064-711-1173
ValueCountFrequency (%)
064-713-1151 1
 
1.1%
064-755-0050 1
 
1.1%
064-752-9256 1
 
1.1%
064-752-5559 1
 
1.1%
064-752-4112 1
 
1.1%
064-752-0069 1
 
1.1%
064-751-9090 1
 
1.1%
064-751-7770 1
 
1.1%
064-751-5002 1
 
1.1%
064-751-2224 1
 
1.1%
Other values (81) 81
89.0%
2023-12-12T23:06:46.093247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 182
16.6%
4 156
14.2%
0 150
13.7%
7 136
12.4%
6 126
11.5%
2 87
7.9%
5 76
6.9%
1 74
6.8%
8 39
 
3.6%
3 38
 
3.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 913
83.4%
Dash Punctuation 182
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 156
17.1%
0 150
16.4%
7 136
14.9%
6 126
13.8%
2 87
9.5%
5 76
8.3%
1 74
8.1%
8 39
 
4.3%
3 38
 
4.2%
9 31
 
3.4%
Dash Punctuation
ValueCountFrequency (%)
- 182
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1095
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 182
16.6%
4 156
14.2%
0 150
13.7%
7 136
12.4%
6 126
11.5%
2 87
7.9%
5 76
6.9%
1 74
6.8%
8 39
 
3.6%
3 38
 
3.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1095
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 182
16.6%
4 156
14.2%
0 150
13.7%
7 136
12.4%
6 126
11.5%
2 87
7.9%
5 76
6.9%
1 74
6.8%
8 39
 
3.6%
3 38
 
3.5%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2021-02-15
153 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-02-15
2nd row2021-02-15
3rd row2021-02-15
4th row2021-02-15
5th row2021-02-15

Common Values

ValueCountFrequency (%)
2021-02-15 153
100.0%

Length

2023-12-12T23:06:46.261148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:06:46.377641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-02-15 153
100.0%

Missing values

2023-12-12T23:06:43.414744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:06:43.513877image/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건물위생관리업주식회사제이어스제주특별자치도 제주시 중앙로 217064-702-23852021-02-15
1건물위생관리업빌클린 주식회사제주특별자치도 제주시 광양9길 50064-702-44472021-02-15
2건물위생관리업아모렉스제주특별자치도 제주시 서해안로 216064-711-01252021-02-15
3건물위생관리업주식회사 더맨서비스제주특별자치도 제주시 삼무로 15064-711-01632021-02-15
4건물위생관리업(주)진혁제주특별자치도 제주시 애월읍 신엄8길 21064-711-11732021-02-15
5건물위생관리업(주)제이에스에스제주특별자치도 제주시 도령로 103064-711-41122021-02-15
6건물위생관리업청정심엔에스제주특별자치도 제주시 도령로 54064-711-98002021-02-15
7건물위생관리업주식회사 에스원환경제주특별자치도 제주시 삼무로11길 16064-712-07882021-02-15
8건물위생관리업(주)태성피엠씨제주특별자치도 제주시 제원1길 5064-712-11902021-02-15
9건물위생관리업제주클린제주특별자치도 제주시 도령로 87064-712-24932021-02-15
업종명업소명주소전화번호데이터기준일자
143건물위생관리업클린앤클리어제주특별자치도 제주시 동광로16길 15<NA>2021-02-15
144건물위생관리업(주)성진글로벌제주특별자치도 제주시 신대로22길 25<NA>2021-02-15
145건물위생관리업클린라이프윈도우맨제주특별자치도 제주시 조천읍 조천18길 50-9<NA>2021-02-15
146건물위생관리업사회적협동조합이도일동도시재생주민협의체제주특별자치도 제주시 오현길 9<NA>2021-02-15
147건물위생관리업다모아탑클린제주특별자치도 제주시 한경면 중산간서로 3793<NA>2021-02-15
148건물위생관리업주식회사디엠에스6제주특별자치도 제주시 조천읍 신북로 577<NA>2021-02-15
149건물위생관리업주식회사세이펌제주특별자치도 제주시 애월읍 중산간서로 6012<NA>2021-02-15
150건물위생관리업창세기서비스제주특별자치도 제주시 신광로6길 25<NA>2021-02-15
151건물위생관리업한국건물관리제주특별자치도 제주시 월광로 25<NA>2021-02-15
152건물위생관리업오롯제주특별자치도 제주시 조천읍 신북로 95<NA>2021-02-15