Overview

Dataset statistics

Number of variables4
Number of observations66
Missing cells25
Missing cells (%)9.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.2 KiB
Average record size in memory34.0 B

Variable types

Categorical1
Text3

Dataset

Description부산광역시_수영구_여행업등록현황_20220120
Author부산광역시 수영구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=3042065

Alerts

전화번호 has 25 (37.9%) missing valuesMissing

Reproduction

Analysis started2023-12-10 16:00:31.374653
Analysis finished2023-12-10 16:00:31.881878
Duration0.51 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종
Categorical

Distinct3
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Memory size660.0 B
국내외여행업
34 
국내여행업
22 
종합여행업
10 

Length

Max length6
Median length6
Mean length5.5151515
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row국내여행업
2nd row국내여행업
3rd row국내여행업
4th row국내여행업
5th row국내여행업

Common Values

ValueCountFrequency (%)
국내외여행업 34
51.5%
국내여행업 22
33.3%
종합여행업 10
 
15.2%

Length

2023-12-11T01:00:31.958641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:00:32.133853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
국내외여행업 34
51.5%
국내여행업 22
33.3%
종합여행업 10
 
15.2%

상호
Text

Distinct49
Distinct (%)74.2%
Missing0
Missing (%)0.0%
Memory size660.0 B
2023-12-11T01:00:32.412993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length13
Mean length8.2878788
Min length4

Characters and Unicode

Total characters547
Distinct characters128
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

Unique32 ?
Unique (%)48.5%

Sample

1st row(주)세명항공여행사
2nd row(주)딸기여행사
3rd row강남고속관광투어(주)
4th row(주)하늘여행사
5th row제이 투어
ValueCountFrequency (%)
주식회사 3
 
3.6%
투어 3
 
3.6%
주)세명항공여행사 2
 
2.4%
스타투어 2
 
2.4%
트래블엔조이 2
 
2.4%
여행사 2
 
2.4%
미스터와플.미스미스터 2
 
2.4%
2
 
2.4%
아름다운 2
 
2.4%
주)부산의 2
 
2.4%
Other values (48) 61
73.5%
2023-12-11T01:00:32.920842image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
41
 
7.5%
( 40
 
7.3%
) 40
 
7.3%
25
 
4.6%
25
 
4.6%
24
 
4.4%
24
 
4.4%
23
 
4.2%
17
 
3.1%
17
 
3.1%
Other values (118) 271
49.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 437
79.9%
Open Punctuation 40
 
7.3%
Close Punctuation 40
 
7.3%
Space Separator 17
 
3.1%
Lowercase Letter 7
 
1.3%
Other Punctuation 4
 
0.7%
Uppercase Letter 2
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
41
 
9.4%
25
 
5.7%
25
 
5.7%
24
 
5.5%
24
 
5.5%
23
 
5.3%
17
 
3.9%
12
 
2.7%
8
 
1.8%
7
 
1.6%
Other values (104) 231
52.9%
Lowercase Letter
ValueCountFrequency (%)
b 1
14.3%
m 1
14.3%
r 1
14.3%
u 1
14.3%
o 1
14.3%
t 1
14.3%
c 1
14.3%
Other Punctuation
ValueCountFrequency (%)
. 2
50.0%
· 2
50.0%
Uppercase Letter
ValueCountFrequency (%)
J 1
50.0%
P 1
50.0%
Open Punctuation
ValueCountFrequency (%)
( 40
100.0%
Close Punctuation
ValueCountFrequency (%)
) 40
100.0%
Space Separator
ValueCountFrequency (%)
17
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 437
79.9%
Common 101
 
18.5%
Latin 9
 
1.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
41
 
9.4%
25
 
5.7%
25
 
5.7%
24
 
5.5%
24
 
5.5%
23
 
5.3%
17
 
3.9%
12
 
2.7%
8
 
1.8%
7
 
1.6%
Other values (104) 231
52.9%
Latin
ValueCountFrequency (%)
b 1
11.1%
m 1
11.1%
r 1
11.1%
u 1
11.1%
o 1
11.1%
t 1
11.1%
c 1
11.1%
J 1
11.1%
P 1
11.1%
Common
ValueCountFrequency (%)
( 40
39.6%
) 40
39.6%
17
16.8%
. 2
 
2.0%
· 2
 
2.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 437
79.9%
ASCII 108
 
19.7%
None 2
 
0.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
41
 
9.4%
25
 
5.7%
25
 
5.7%
24
 
5.5%
24
 
5.5%
23
 
5.3%
17
 
3.9%
12
 
2.7%
8
 
1.8%
7
 
1.6%
Other values (104) 231
52.9%
ASCII
ValueCountFrequency (%)
( 40
37.0%
) 40
37.0%
17
15.7%
. 2
 
1.9%
b 1
 
0.9%
m 1
 
0.9%
r 1
 
0.9%
u 1
 
0.9%
o 1
 
0.9%
t 1
 
0.9%
Other values (3) 3
 
2.8%
None
ValueCountFrequency (%)
· 2
100.0%
Distinct50
Distinct (%)75.8%
Missing0
Missing (%)0.0%
Memory size660.0 B
2023-12-11T01:00:33.344508image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length39
Mean length33.181818
Min length22

Characters and Unicode

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

Unique

Unique36 ?
Unique (%)54.5%

Sample

1st row부산광역시 수영구 수영로 532, 6층 (광안동, 부성빌딩)
2nd row부산광역시 수영구 수영로 607-1, 3층 (광안동)
3rd row부산광역시 수영구 과정로 55 (망미동, 망미1동 새마을금고)
4th row부산광역시 수영구 수영로705번길 1, 2층 (수영동)
5th row부산광역시 수영구 수영로 759, 511호 (수영동, 알파오피스텔)
ValueCountFrequency (%)
부산광역시 66
 
15.0%
수영구 66
 
15.0%
수영로 31
 
7.1%
광안동 21
 
4.8%
수영동 15
 
3.4%
남천동 13
 
3.0%
759 11
 
2.5%
알파오피스텔 9
 
2.1%
망미동 9
 
2.1%
3층 8
 
1.8%
Other values (105) 190
43.3%
2023-12-11T01:00:33.889556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
373
 
17.0%
123
 
5.6%
120
 
5.5%
107
 
4.9%
80
 
3.7%
, 73
 
3.3%
72
 
3.3%
69
 
3.2%
69
 
3.2%
68
 
3.1%
Other values (96) 1036
47.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1257
57.4%
Space Separator 373
 
17.0%
Decimal Number 345
 
15.8%
Other Punctuation 73
 
3.3%
Open Punctuation 66
 
3.0%
Close Punctuation 66
 
3.0%
Dash Punctuation 6
 
0.3%
Uppercase Letter 3
 
0.1%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
123
 
9.8%
120
 
9.5%
107
 
8.5%
80
 
6.4%
72
 
5.7%
69
 
5.5%
69
 
5.5%
68
 
5.4%
68
 
5.4%
66
 
5.3%
Other values (77) 415
33.0%
Decimal Number
ValueCountFrequency (%)
1 56
16.2%
2 46
13.3%
5 43
12.5%
6 37
10.7%
3 37
10.7%
0 32
9.3%
7 29
8.4%
4 26
7.5%
9 21
 
6.1%
8 18
 
5.2%
Uppercase Letter
ValueCountFrequency (%)
C 1
33.3%
B 1
33.3%
M 1
33.3%
Space Separator
ValueCountFrequency (%)
373
100.0%
Other Punctuation
ValueCountFrequency (%)
, 73
100.0%
Open Punctuation
ValueCountFrequency (%)
( 66
100.0%
Close Punctuation
ValueCountFrequency (%)
) 66
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1257
57.4%
Common 929
42.4%
Latin 4
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
123
 
9.8%
120
 
9.5%
107
 
8.5%
80
 
6.4%
72
 
5.7%
69
 
5.5%
69
 
5.5%
68
 
5.4%
68
 
5.4%
66
 
5.3%
Other values (77) 415
33.0%
Common
ValueCountFrequency (%)
373
40.2%
, 73
 
7.9%
( 66
 
7.1%
) 66
 
7.1%
1 56
 
6.0%
2 46
 
5.0%
5 43
 
4.6%
6 37
 
4.0%
3 37
 
4.0%
0 32
 
3.4%
Other values (5) 100
 
10.8%
Latin
ValueCountFrequency (%)
C 1
25.0%
B 1
25.0%
M 1
25.0%
e 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1257
57.4%
ASCII 933
42.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
373
40.0%
, 73
 
7.8%
( 66
 
7.1%
) 66
 
7.1%
1 56
 
6.0%
2 46
 
4.9%
5 43
 
4.6%
6 37
 
4.0%
3 37
 
4.0%
0 32
 
3.4%
Other values (9) 104
 
11.1%
Hangul
ValueCountFrequency (%)
123
 
9.8%
120
 
9.5%
107
 
8.5%
80
 
6.4%
72
 
5.7%
69
 
5.5%
69
 
5.5%
68
 
5.4%
68
 
5.4%
66
 
5.3%
Other values (77) 415
33.0%

전화번호
Text

MISSING 

Distinct30
Distinct (%)73.2%
Missing25
Missing (%)37.9%
Memory size660.0 B
2023-12-11T01:00:34.234787image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.97561
Min length9

Characters and Unicode

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

Unique19 ?
Unique (%)46.3%

Sample

1st row051-621-7202
2nd row051-643-8870
3rd row051-529-9898
4th row051-996-4226
5th row051-751-6273
ValueCountFrequency (%)
051-755-0125 2
 
4.9%
051-851-5515 2
 
4.9%
051-621-7202 2
 
4.9%
051-756-4117 2
 
4.9%
051-643-8870 2
 
4.9%
051-502-6888 2
 
4.9%
051-752-4455 2
 
4.9%
051-996-4226 2
 
4.9%
051-747-6677 2
 
4.9%
051-751-6273 2
 
4.9%
Other values (20) 21
51.2%
2023-12-11T01:00:34.741513image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 81
16.5%
5 77
15.7%
0 73
14.9%
1 66
13.4%
6 42
8.6%
7 36
7.3%
2 36
7.3%
8 23
 
4.7%
9 21
 
4.3%
4 21
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 410
83.5%
Dash Punctuation 81
 
16.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 77
18.8%
0 73
17.8%
1 66
16.1%
6 42
10.2%
7 36
8.8%
2 36
8.8%
8 23
 
5.6%
9 21
 
5.1%
4 21
 
5.1%
3 15
 
3.7%
Dash Punctuation
ValueCountFrequency (%)
- 81
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 491
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 81
16.5%
5 77
15.7%
0 73
14.9%
1 66
13.4%
6 42
8.6%
7 36
7.3%
2 36
7.3%
8 23
 
4.7%
9 21
 
4.3%
4 21
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 491
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 81
16.5%
5 77
15.7%
0 73
14.9%
1 66
13.4%
6 42
8.6%
7 36
7.3%
2 36
7.3%
8 23
 
4.7%
9 21
 
4.3%
4 21
 
4.3%

Correlations

2023-12-11T01:00:34.888532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종상호소재지(도로명)전화번호
업종1.0000.0000.1700.000
상호0.0001.0000.9981.000
소재지(도로명)0.1700.9981.0000.998
전화번호0.0001.0000.9981.000

Missing values

2023-12-11T01:00:31.731795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:00:31.839683image/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국내여행업(주)세명항공여행사부산광역시 수영구 수영로 532, 6층 (광안동, 부성빌딩)051-621-7202
1국내여행업(주)딸기여행사부산광역시 수영구 수영로 607-1, 3층 (광안동)051-643-8870
2국내여행업강남고속관광투어(주)부산광역시 수영구 과정로 55 (망미동, 망미1동 새마을금고)051-529-9898
3국내여행업(주)하늘여행사부산광역시 수영구 수영로705번길 1, 2층 (수영동)051-996-4226
4국내여행업제이 투어부산광역시 수영구 수영로 759, 511호 (수영동, 알파오피스텔)051-751-6273
5국내여행업웰빙투어부산광역시 수영구 수영로545번길 21, 708호 (광안동, 유원빌딩)051-919-2231
6국내여행업(주)월드시티 홀딩스부산광역시 수영구 광남로 22 (남천동)<NA>
7국내여행업삼성투어부산광역시 수영구 수영로 662, 3층 (광안동)<NA>
8국내여행업성원여행사부산광역시 수영구 수영로 759, 808호 (수영동)051-747-6677
9국내여행업(주)에버그린투어부산광역시 수영구 연수로 265-1, 1층 (망미동)<NA>
업종상호소재지(도로명)전화번호
56종합여행업부산문화방송(주)(tour mbc)부산광역시 수영구 감포로8번길 69 (민락동, 부산MBC)051-760-1046
57종합여행업(주)해피테마투어부산광역시 수영구 광안해변로 237, 902호 (민락동)051-756-2626
58종합여행업(주)잠언코리아부산광역시 수영구 수영로 759, 알파오피스텔 812호 (수영동)<NA>
59종합여행업(주)헬로우에이젼시부산광역시 수영구 황령대로 479, 2층 (남천동)051-441-1955
60종합여행업타피사코리아(주)부산광역시 수영구 수영로575번길 33, 4층 (광안동)051-624-2972
61종합여행업(주)스마일코리아부산광역시 수영구 수영로 759, 알파오피스텔 지하1층 1311호 (수영동)1800-8757
62종합여행업에이스투어부산광역시 수영구 수영로666번길 6, 삼정그린코아 711호 (광안동)<NA>
63종합여행업제이하우스부산광역시 수영구 광일로 59, 광원아파트 상가동 126호 (광안동)<NA>
64종합여행업주식회사 해암부산광역시 수영구 광일로 63, 102동 4층 402호 (광안동, 광원아파트)<NA>
65종합여행업여왕의 놀이터부산광역시 수영구 연수로357번길 35 (수영동)<NA>