Overview

Dataset statistics

Number of variables5
Number of observations61
Missing cells19
Missing cells (%)6.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.5 KiB
Average record size in memory42.2 B

Variable types

Categorical1
Text4

Dataset

Description부산광역시북구_건물위생관리업현황_20221216
Author부산광역시 북구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=3069427

Alerts

업종명 has constant value ""Constant
소재지전화 has 19 (31.1%) missing valuesMissing
업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-10 17:45:54.952969
Analysis finished2023-12-10 17:45:56.282095
Duration1.33 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size620.0 B
건물위생관리업
61 

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 (%)
건물위생관리업 61
100.0%

Length

2023-12-11T02:45:56.434616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T02:45:56.644916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
건물위생관리업 61
100.0%

업소명
Text

UNIQUE 

Distinct61
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size620.0 B
2023-12-11T02:45:57.116130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length13
Mean length7.5245902
Min length2

Characters and Unicode

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

Unique

Unique61 ?
Unique (%)100.0%

Sample

1st row고려
2nd row(주)성아종합관리
3rd row태화환경공사
4th row주)세진환경종합개발
5th row(주)배성산업
ValueCountFrequency (%)
주식회사 4
 
5.8%
고려 1
 
1.4%
주)대민보안공사 1
 
1.4%
현우환경 1
 
1.4%
주)빅맨솔루션 1
 
1.4%
주)토르환경 1
 
1.4%
주)모스트인 1
 
1.4%
보민테크 1
 
1.4%
클린빌(clean 1
 
1.4%
bild 1
 
1.4%
Other values (56) 56
81.2%
2023-12-11T02:45:57.986398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
38
 
8.3%
) 36
 
7.8%
( 35
 
7.6%
18
 
3.9%
11
 
2.4%
11
 
2.4%
11
 
2.4%
9
 
2.0%
8
 
1.7%
8
 
1.7%
Other values (138) 274
59.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 363
79.1%
Close Punctuation 36
 
7.8%
Open Punctuation 35
 
7.6%
Uppercase Letter 9
 
2.0%
Space Separator 8
 
1.7%
Lowercase Letter 7
 
1.5%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
38
 
10.5%
18
 
5.0%
11
 
3.0%
11
 
3.0%
11
 
3.0%
9
 
2.5%
8
 
2.2%
7
 
1.9%
7
 
1.9%
7
 
1.9%
Other values (121) 236
65.0%
Uppercase Letter
ValueCountFrequency (%)
B 3
33.3%
H 1
 
11.1%
R 1
 
11.1%
T 1
 
11.1%
S 1
 
11.1%
M 1
 
11.1%
C 1
 
11.1%
Lowercase Letter
ValueCountFrequency (%)
l 2
28.6%
d 1
14.3%
i 1
14.3%
n 1
14.3%
a 1
14.3%
e 1
14.3%
Close Punctuation
ValueCountFrequency (%)
) 36
100.0%
Open Punctuation
ValueCountFrequency (%)
( 35
100.0%
Space Separator
ValueCountFrequency (%)
8
100.0%
Other Punctuation
ValueCountFrequency (%)
/ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 363
79.1%
Common 80
 
17.4%
Latin 16
 
3.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
38
 
10.5%
18
 
5.0%
11
 
3.0%
11
 
3.0%
11
 
3.0%
9
 
2.5%
8
 
2.2%
7
 
1.9%
7
 
1.9%
7
 
1.9%
Other values (121) 236
65.0%
Latin
ValueCountFrequency (%)
B 3
18.8%
l 2
12.5%
H 1
 
6.2%
R 1
 
6.2%
d 1
 
6.2%
i 1
 
6.2%
T 1
 
6.2%
n 1
 
6.2%
S 1
 
6.2%
M 1
 
6.2%
Other values (3) 3
18.8%
Common
ValueCountFrequency (%)
) 36
45.0%
( 35
43.8%
8
 
10.0%
/ 1
 
1.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 363
79.1%
ASCII 96
 
20.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
38
 
10.5%
18
 
5.0%
11
 
3.0%
11
 
3.0%
11
 
3.0%
9
 
2.5%
8
 
2.2%
7
 
1.9%
7
 
1.9%
7
 
1.9%
Other values (121) 236
65.0%
ASCII
ValueCountFrequency (%)
) 36
37.5%
( 35
36.5%
8
 
8.3%
B 3
 
3.1%
l 2
 
2.1%
H 1
 
1.0%
R 1
 
1.0%
d 1
 
1.0%
i 1
 
1.0%
T 1
 
1.0%
Other values (7) 7
 
7.3%
Distinct59
Distinct (%)96.7%
Missing0
Missing (%)0.0%
Memory size620.0 B
2023-12-11T02:45:58.628444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length44
Median length38
Mean length31.918033
Min length21

Characters and Unicode

Total characters1947
Distinct characters107
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

Unique57 ?
Unique (%)93.4%

Sample

1st row부산광역시 북구 의성로109번길 63-1, 3층 301호 (덕천동)
2nd row부산광역시 북구 시랑로 62 (구포동)
3rd row부산광역시 북구 금곡대로616번길 10-5, 가상가동 207호 (금곡동)
4th row부산광역시 북구 금곡대로 118, 4층 (덕천동)
5th row부산광역시 북구 사상로 588 (구포동)
ValueCountFrequency (%)
부산광역시 61
 
15.7%
북구 61
 
15.7%
구포동 23
 
5.9%
1층 13
 
3.4%
덕천동 13
 
3.4%
2층 9
 
2.3%
만덕동 8
 
2.1%
금곡동 8
 
2.1%
3층 7
 
1.8%
화명동 7
 
1.8%
Other values (134) 178
45.9%
2023-12-11T02:45:59.564857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
327
 
16.8%
91
 
4.7%
1 89
 
4.6%
69
 
3.5%
66
 
3.4%
, 63
 
3.2%
62
 
3.2%
) 62
 
3.2%
( 62
 
3.2%
61
 
3.1%
Other values (97) 995
51.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1079
55.4%
Decimal Number 341
 
17.5%
Space Separator 327
 
16.8%
Other Punctuation 63
 
3.2%
Close Punctuation 62
 
3.2%
Open Punctuation 62
 
3.2%
Dash Punctuation 12
 
0.6%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
91
 
8.4%
69
 
6.4%
66
 
6.1%
62
 
5.7%
61
 
5.7%
61
 
5.7%
61
 
5.7%
61
 
5.7%
61
 
5.7%
41
 
3.8%
Other values (81) 445
41.2%
Decimal Number
ValueCountFrequency (%)
1 89
26.1%
2 57
16.7%
0 35
 
10.3%
3 30
 
8.8%
4 30
 
8.8%
6 30
 
8.8%
5 25
 
7.3%
8 17
 
5.0%
9 14
 
4.1%
7 14
 
4.1%
Space Separator
ValueCountFrequency (%)
327
100.0%
Other Punctuation
ValueCountFrequency (%)
, 63
100.0%
Close Punctuation
ValueCountFrequency (%)
) 62
100.0%
Open Punctuation
ValueCountFrequency (%)
( 62
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 12
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1079
55.4%
Common 867
44.5%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
91
 
8.4%
69
 
6.4%
66
 
6.1%
62
 
5.7%
61
 
5.7%
61
 
5.7%
61
 
5.7%
61
 
5.7%
61
 
5.7%
41
 
3.8%
Other values (81) 445
41.2%
Common
ValueCountFrequency (%)
327
37.7%
1 89
 
10.3%
, 63
 
7.3%
) 62
 
7.2%
( 62
 
7.2%
2 57
 
6.6%
0 35
 
4.0%
3 30
 
3.5%
4 30
 
3.5%
6 30
 
3.5%
Other values (5) 82
 
9.5%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1079
55.4%
ASCII 868
44.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
327
37.7%
1 89
 
10.3%
, 63
 
7.3%
) 62
 
7.1%
( 62
 
7.1%
2 57
 
6.6%
0 35
 
4.0%
3 30
 
3.5%
4 30
 
3.5%
6 30
 
3.5%
Other values (6) 83
 
9.6%
Hangul
ValueCountFrequency (%)
91
 
8.4%
69
 
6.4%
66
 
6.1%
62
 
5.7%
61
 
5.7%
61
 
5.7%
61
 
5.7%
61
 
5.7%
61
 
5.7%
41
 
3.8%
Other values (81) 445
41.2%
Distinct58
Distinct (%)95.1%
Missing0
Missing (%)0.0%
Memory size620.0 B
2023-12-11T02:46:00.160713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length37
Median length34
Mean length23.491803
Min length17

Characters and Unicode

Total characters1433
Distinct characters85
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

Unique55 ?
Unique (%)90.2%

Sample

1st row부산광역시 북구 덕천동 387-17 (3층) 301호
2nd row부산광역시 북구 구포동 1217-8
3rd row부산광역시 북구 금곡동 98-1
4th row부산광역시 북구 덕천동 561-11
5th row부산광역시 북구 구포동 1123-7
ValueCountFrequency (%)
부산광역시 61
21.0%
북구 61
21.0%
구포동 25
 
8.6%
덕천동 13
 
4.5%
금곡동 8
 
2.8%
만덕동 8
 
2.8%
화명동 7
 
2.4%
2층 5
 
1.7%
417-28 2
 
0.7%
1330-1 2
 
0.7%
Other values (91) 98
33.8%
2023-12-11T02:46:01.226002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
282
19.7%
86
 
6.0%
1 78
 
5.4%
62
 
4.3%
62
 
4.3%
61
 
4.3%
61
 
4.3%
61
 
4.3%
61
 
4.3%
61
 
4.3%
Other values (75) 558
38.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 739
51.6%
Decimal Number 344
24.0%
Space Separator 282
 
19.7%
Dash Punctuation 59
 
4.1%
Close Punctuation 3
 
0.2%
Open Punctuation 3
 
0.2%
Other Punctuation 2
 
0.1%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
86
11.6%
62
 
8.4%
62
 
8.4%
61
 
8.3%
61
 
8.3%
61
 
8.3%
61
 
8.3%
61
 
8.3%
26
 
3.5%
21
 
2.8%
Other values (59) 177
24.0%
Decimal Number
ValueCountFrequency (%)
1 78
22.7%
2 55
16.0%
0 37
10.8%
7 33
9.6%
3 28
 
8.1%
8 28
 
8.1%
4 25
 
7.3%
5 24
 
7.0%
6 24
 
7.0%
9 12
 
3.5%
Space Separator
ValueCountFrequency (%)
282
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 59
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Other Punctuation
ValueCountFrequency (%)
, 2
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 739
51.6%
Common 693
48.4%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
86
11.6%
62
 
8.4%
62
 
8.4%
61
 
8.3%
61
 
8.3%
61
 
8.3%
61
 
8.3%
61
 
8.3%
26
 
3.5%
21
 
2.8%
Other values (59) 177
24.0%
Common
ValueCountFrequency (%)
282
40.7%
1 78
 
11.3%
- 59
 
8.5%
2 55
 
7.9%
0 37
 
5.3%
7 33
 
4.8%
3 28
 
4.0%
8 28
 
4.0%
4 25
 
3.6%
5 24
 
3.5%
Other values (5) 44
 
6.3%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 739
51.6%
ASCII 694
48.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
282
40.6%
1 78
 
11.2%
- 59
 
8.5%
2 55
 
7.9%
0 37
 
5.3%
7 33
 
4.8%
3 28
 
4.0%
8 28
 
4.0%
4 25
 
3.6%
5 24
 
3.5%
Other values (6) 45
 
6.5%
Hangul
ValueCountFrequency (%)
86
11.6%
62
 
8.4%
62
 
8.4%
61
 
8.3%
61
 
8.3%
61
 
8.3%
61
 
8.3%
61
 
8.3%
26
 
3.5%
21
 
2.8%
Other values (59) 177
24.0%

소재지전화
Text

MISSING 

Distinct41
Distinct (%)97.6%
Missing19
Missing (%)31.1%
Memory size620.0 B
2023-12-11T02:46:01.844981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique40 ?
Unique (%)95.2%

Sample

1st row051-323-4400
2nd row051-333-3855
3rd row051-333-0006
4th row051-336-6821
5th row051-265-2597
ValueCountFrequency (%)
051-342-2112 2
 
4.8%
051-338-4194 1
 
2.4%
051-323-4400 1
 
2.4%
051-311-7479 1
 
2.4%
051-532-3974 1
 
2.4%
051-363-9425 1
 
2.4%
051-902-7119 1
 
2.4%
051-507-1441 1
 
2.4%
051-557-6467 1
 
2.4%
051-334-4596 1
 
2.4%
Other values (31) 31
73.8%
2023-12-11T02:46:02.689353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 84
16.7%
5 74
14.7%
0 67
13.3%
3 66
13.1%
1 65
12.9%
4 29
 
5.8%
2 28
 
5.6%
7 28
 
5.6%
8 24
 
4.8%
6 20
 
4.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 420
83.3%
Dash Punctuation 84
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 74
17.6%
0 67
16.0%
3 66
15.7%
1 65
15.5%
4 29
 
6.9%
2 28
 
6.7%
7 28
 
6.7%
8 24
 
5.7%
6 20
 
4.8%
9 19
 
4.5%
Dash Punctuation
ValueCountFrequency (%)
- 84
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 504
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 84
16.7%
5 74
14.7%
0 67
13.3%
3 66
13.1%
1 65
12.9%
4 29
 
5.8%
2 28
 
5.6%
7 28
 
5.6%
8 24
 
4.8%
6 20
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 504
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 84
16.7%
5 74
14.7%
0 67
13.3%
3 66
13.1%
1 65
12.9%
4 29
 
5.8%
2 28
 
5.6%
7 28
 
5.6%
8 24
 
4.8%
6 20
 
4.0%

Correlations

2023-12-11T02:46:02.908670image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업소명영업소 주소(도로명)영업소 주소(지번)소재지전화
업소명1.0001.0001.0001.000
영업소 주소(도로명)1.0001.0000.9970.995
영업소 주소(지번)1.0000.9971.0000.995
소재지전화1.0000.9950.9951.000

Missing values

2023-12-11T02:45:55.963224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T02:45:56.198615image/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건물위생관리업고려부산광역시 북구 의성로109번길 63-1, 3층 301호 (덕천동)부산광역시 북구 덕천동 387-17 (3층) 301호051-323-4400
1건물위생관리업(주)성아종합관리부산광역시 북구 시랑로 62 (구포동)부산광역시 북구 구포동 1217-8051-333-3855
2건물위생관리업태화환경공사부산광역시 북구 금곡대로616번길 10-5, 가상가동 207호 (금곡동)부산광역시 북구 금곡동 98-1051-333-0006
3건물위생관리업주)세진환경종합개발부산광역시 북구 금곡대로 118, 4층 (덕천동)부산광역시 북구 덕천동 561-11051-336-6821
4건물위생관리업(주)배성산업부산광역시 북구 사상로 588 (구포동)부산광역시 북구 구포동 1123-7051-265-2597
5건물위생관리업세종관리부산광역시 북구 금곡대로616번길 116 (금곡동)부산광역시 북구 금곡동 66-12051-361-0484
6건물위생관리업(주)청진시스템부산광역시 북구 덕천로294번길 5, 2층 (만덕동)부산광역시 북구 만덕동 840-48051-783-0757
7건물위생관리업태화청소용역부산광역시 북구 금곡대로104번길 24 (덕천동)부산광역시 북구 덕천동 572-6051-338-9338
8건물위생관리업(주)에스씨에스부산광역시 북구 시랑로83번길 21 (구포동,2층)부산광역시 북구 구포동 1225-10 2층051-342-3855
9건물위생관리업(주)하이종합환경부산광역시 북구 구남언덕로16번길 4, 1층 (구포동)부산광역시 북구 구포동 1075-24051-327-3113
업종명업소명영업소 주소(도로명)영업소 주소(지번)소재지전화
51건물위생관리업청소야닷컴부산광역시 북구 만덕2로29번길 21-5, 1층 (만덕동)부산광역시 북구 만덕동 301-10<NA>
52건물위생관리업온유스카이부산광역시 북구 구남언덕로 21, 2층 (구포동)부산광역시 북구 구포동 927-4051-337-5944
53건물위생관리업(주)비뉴부산광역시 북구 백양대로 1025, 1층 152호 (구포동, 협진태양아파트)부산광역시 북구 구포동 1084-3 협진태양아파트051-973-8644
54건물위생관리업(주)서정이엔씨부산광역시 북구 학사로17번길 19, 중도빌딩 201호 (화명동)부산광역시 북구 화명동 2322 중도빌딩055-388-0089
55건물위생관리업엘지크리닝서비스부산광역시 북구 백양대로 1003, 117호 (구포동, 현대아파트)부산광역시 북구 구포동 1103-2 현대아파트 117호051-335-5279
56건물위생관리업(주)상동실업부산광역시 북구 만덕대로40번길 33, 지하1층 (덕천동)부산광역시 북구 덕천동 417-28<NA>
57건물위생관리업티에스(T/S)방역부산광역시 북구 사상로 592, 3층 (구포동)부산광역시 북구 구포동 1123-2<NA>
58건물위생관리업더프라임인터내셔널부산광역시 북구 백양대로 1025, 2층 216호 (구포동, 협진태양아파트)부산광역시 북구 구포동 1084-3 협진태양아파트<NA>
59건물위생관리업청솔클린부산광역시 북구 모분재로23번길 91, 1층 (덕천동)부산광역시 북구 덕천동 801-8<NA>
60건물위생관리업주식회사 제이유부산광역시 북구 백양대로 1103, 1층 (구포동)부산광역시 북구 구포동 982-21051-334-2000