Overview

Dataset statistics

Number of variables4
Number of observations165
Missing cells63
Missing cells (%)9.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.3 KiB
Average record size in memory32.8 B

Variable types

Text3
DateTime1

Dataset

Description제주특별자치도 내에 소재 / 운영하고 있는 국외여행업과 관련한 데이터로 상호명, 소재지, 연락처 정보를 제공합니다.
Author제주특별자치도
URLhttps://www.data.go.kr/data/15056291/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
연락처 has 63 (38.2%) missing valuesMissing
상호명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 00:51:45.118868
Analysis finished2023-12-12 00:51:45.603494
Duration0.48 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호명
Text

UNIQUE 

Distinct165
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-12T09:51:45.816858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length13
Mean length7.8969697
Min length3

Characters and Unicode

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

Unique

Unique165 ?
Unique (%)100.0%

Sample

1st row㈜굿투어
2nd row㈜런여행사
3rd row㈜허브여행사
4th row(유)한송여행사
5th row(유)그린삼육오
ValueCountFrequency (%)
주식회사 53
 
23.3%
유한회사 3
 
1.3%
현여행갤러리 1
 
0.4%
유)반디투어 1
 
0.4%
미소항공여행사 1
 
0.4%
모이자투어 1
 
0.4%
산하글로벌 1
 
0.4%
㈜제주매니아 1
 
0.4%
㈜지제이투어 1
 
0.4%
㈜열방제주여행사 1
 
0.4%
Other values (163) 163
71.8%
2023-12-12T09:51:46.294345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 101
 
7.8%
주 85
 
6.5%
62
 
4.8%
행 58
 
4.5%
여 57
 
4.4%
회 57
 
4.4%
식 54
 
4.1%
투 50
 
3.8%
어 49
 
3.8%
㈜ 48
 
3.7%
Other values (223) 682
52.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1135
87.1%
Space Separator 62
 
4.8%
Other Symbol 48
 
3.7%
Open Punctuation 15
 
1.2%
Close Punctuation 15
 
1.2%
Uppercase Letter 12
 
0.9%
Lowercase Letter 8
 
0.6%
Decimal Number 7
 
0.5%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 101
 
8.9%
주 85
 
7.5%
행 58
 
5.1%
여 57
 
5.0%
회 57
 
5.0%
식 54
 
4.8%
투 50
 
4.4%
어 49
 
4.3%
제 41
 
3.6%
이 32
 
2.8%
Other values (196) 551
48.5%
Uppercase Letter
ValueCountFrequency (%)
O 2
16.7%
F 1
8.3%
C 1
8.3%
P 1
8.3%
S 1
8.3%
A 1
8.3%
H 1
8.3%
G 1
8.3%
R 1
8.3%
U 1
8.3%
Lowercase Letter
ValueCountFrequency (%)
s 3
37.5%
i 1
 
12.5%
r 1
 
12.5%
t 1
 
12.5%
l 1
 
12.5%
a 1
 
12.5%
Decimal Number
ValueCountFrequency (%)
7 3
42.9%
9 1
 
14.3%
1 1
 
14.3%
5 1
 
14.3%
0 1
 
14.3%
Space Separator
ValueCountFrequency (%)
62
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 48
100.0%
Open Punctuation
ValueCountFrequency (%)
( 15
100.0%
Close Punctuation
ValueCountFrequency (%)
) 15
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1183
90.8%
Common 100
 
7.7%
Latin 20
 
1.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 101
 
8.5%
주 85
 
7.2%
행 58
 
4.9%
여 57
 
4.8%
회 57
 
4.8%
식 54
 
4.6%
투 50
 
4.2%
어 49
 
4.1%
㈜ 48
 
4.1%
제 41
 
3.5%
Other values (197) 583
49.3%
Latin
ValueCountFrequency (%)
s 3
15.0%
O 2
 
10.0%
F 1
 
5.0%
i 1
 
5.0%
r 1
 
5.0%
t 1
 
5.0%
C 1
 
5.0%
l 1
 
5.0%
a 1
 
5.0%
P 1
 
5.0%
Other values (7) 7
35.0%
Common
ValueCountFrequency (%)
62
62.0%
( 15
 
15.0%
) 15
 
15.0%
7 3
 
3.0%
& 1
 
1.0%
9 1
 
1.0%
1 1
 
1.0%
5 1
 
1.0%
0 1
 
1.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1135
87.1%
ASCII 120
 
9.2%
None 48
 
3.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 101
 
8.9%
주 85
 
7.5%
행 58
 
5.1%
여 57
 
5.0%
회 57
 
5.0%
식 54
 
4.8%
투 50
 
4.4%
어 49
 
4.3%
제 41
 
3.6%
이 32
 
2.8%
Other values (196) 551
48.5%
ASCII
ValueCountFrequency (%)
62
51.7%
( 15
 
12.5%
) 15
 
12.5%
7 3
 
2.5%
s 3
 
2.5%
O 2
 
1.7%
F 1
 
0.8%
i 1
 
0.8%
r 1
 
0.8%
t 1
 
0.8%
Other values (16) 16
 
13.3%
None
ValueCountFrequency (%)
㈜ 48
100.0%

소재지
Text

Distinct138
Distinct (%)83.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-12T09:51:47.227152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length25
Mean length19.636364
Min length17

Characters and Unicode

Total characters3240
Distinct characters100
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

Unique123 ?
Unique (%)74.5%

Sample

1st row제주특별자치도 제주시 번영로 476
2nd row제주특별자치도 제주시 남성로 129-7
3rd row제주특별자치도 제주시 신대로 124
4th row제주특별자치도 제주시 신대로12길 51
5th row제주특별자치도 제주시 선덕로8길 26
ValueCountFrequency (%)
제주특별자치도 162
24.3%
제주시 150
22.5%
서귀포시 15
 
2.2%
연북로 13
 
1.9%
92 12
 
1.8%
도령로 10
 
1.5%
중앙로 8
 
1.2%
10 5
 
0.7%
용해로 5
 
0.7%
15 4
 
0.6%
Other values (210) 283
42.4%
2023-12-12T09:51:47.952181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
502
15.5%
주 318
 
9.8%
제 315
 
9.7%
도 180
 
5.6%
특 165
 
5.1%
별 165
 
5.1%
자 165
 
5.1%
치 165
 
5.1%
시 165
 
5.1%
로 129
 
4.0%
Other values (90) 971
30.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2249
69.4%
Space Separator 502
 
15.5%
Decimal Number 463
 
14.3%
Dash Punctuation 26
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 318
14.1%
제 315
14.0%
도 180
8.0%
특 165
 
7.3%
별 165
 
7.3%
자 165
 
7.3%
치 165
 
7.3%
시 165
 
7.3%
로 129
 
5.7%
길 68
 
3.0%
Other values (78) 414
18.4%
Decimal Number
ValueCountFrequency (%)
1 98
21.2%
2 77
16.6%
5 50
10.8%
3 46
9.9%
6 41
8.9%
4 38
 
8.2%
8 30
 
6.5%
7 30
 
6.5%
9 29
 
6.3%
0 24
 
5.2%
Space Separator
ValueCountFrequency (%)
502
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 26
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2249
69.4%
Common 991
30.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 318
14.1%
제 315
14.0%
도 180
8.0%
특 165
 
7.3%
별 165
 
7.3%
자 165
 
7.3%
치 165
 
7.3%
시 165
 
7.3%
로 129
 
5.7%
길 68
 
3.0%
Other values (78) 414
18.4%
Common
ValueCountFrequency (%)
502
50.7%
1 98
 
9.9%
2 77
 
7.8%
5 50
 
5.0%
3 46
 
4.6%
6 41
 
4.1%
4 38
 
3.8%
8 30
 
3.0%
7 30
 
3.0%
9 29
 
2.9%
Other values (2) 50
 
5.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2249
69.4%
ASCII 991
30.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
502
50.7%
1 98
 
9.9%
2 77
 
7.8%
5 50
 
5.0%
3 46
 
4.6%
6 41
 
4.1%
4 38
 
3.8%
8 30
 
3.0%
7 30
 
3.0%
9 29
 
2.9%
Other values (2) 50
 
5.0%
Hangul
ValueCountFrequency (%)
주 318
14.1%
제 315
14.0%
도 180
8.0%
특 165
 
7.3%
별 165
 
7.3%
자 165
 
7.3%
치 165
 
7.3%
시 165
 
7.3%
로 129
 
5.7%
길 68
 
3.0%
Other values (78) 414
18.4%

연락처
Text

MISSING 

Distinct101
Distinct (%)99.0%
Missing63
Missing (%)38.2%
Memory size1.4 KiB
2023-12-12T09:51:48.290492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length12
Mean length11.882353
Min length9

Characters and Unicode

Total characters1212
Distinct characters12
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique100 ?
Unique (%)98.0%

Sample

1st row064-702-0070
2nd row064-711-0009
3rd row064-711-1012
4th row064-711-2373
5th row064-711-3651
ValueCountFrequency (%)
064-748-9001 2
 
2.0%
064-759-7788 1
 
1.0%
064-702-0070 1
 
1.0%
064-749-7222 1
 
1.0%
064-756-3661 1
 
1.0%
064-755-2000 1
 
1.0%
064-753-8496 1
 
1.0%
064-753-3667 1
 
1.0%
064-752-0068 1
 
1.0%
064-752-0007 1
 
1.0%
Other values (91) 91
89.2%
2023-12-12T09:51:48.751729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 199
16.4%
- 198
16.3%
4 180
14.9%
7 152
12.5%
6 139
11.5%
2 70
 
5.8%
1 64
 
5.3%
8 56
 
4.6%
5 55
 
4.5%
3 52
 
4.3%
Other values (2) 47
 
3.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1011
83.4%
Dash Punctuation 198
 
16.3%
Space Separator 3
 
0.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 199
19.7%
4 180
17.8%
7 152
15.0%
6 139
13.7%
2 70
 
6.9%
1 64
 
6.3%
8 56
 
5.5%
5 55
 
5.4%
3 52
 
5.1%
9 44
 
4.4%
Dash Punctuation
ValueCountFrequency (%)
- 198
100.0%
Space Separator
ValueCountFrequency (%)
3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1212
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 199
16.4%
- 198
16.3%
4 180
14.9%
7 152
12.5%
6 139
11.5%
2 70
 
5.8%
1 64
 
5.3%
8 56
 
4.6%
5 55
 
4.5%
3 52
 
4.3%
Other values (2) 47
 
3.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1212
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 199
16.4%
- 198
16.3%
4 180
14.9%
7 152
12.5%
6 139
11.5%
2 70
 
5.8%
1 64
 
5.3%
8 56
 
4.6%
5 55
 
4.5%
3 52
 
4.3%
Other values (2) 47
 
3.9%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2023-06-30 00:00:00
Maximum2023-06-30 00:00:00
2023-12-12T09:51:48.881124image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:51:48.973032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2023-12-12T09:51:45.422678image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T09:51:45.557134image/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㈜굿투어제주특별자치도 제주시 번영로 476064-702-00702023-06-30
1㈜런여행사제주특별자치도 제주시 남성로 129-7064-711-00092023-06-30
2㈜허브여행사제주특별자치도 제주시 신대로 124064-711-10122023-06-30
3(유)한송여행사제주특별자치도 제주시 신대로12길 51064-711-23732023-06-30
4(유)그린삼육오제주특별자치도 제주시 선덕로8길 26064-711-36512023-06-30
5트래블라운지제주특별자치도 제주시 연북로 92064-711-44882023-06-30
6주식회사 인제주아일랜드제주특별자치도 제주시 거로남10길 26-5064-711-78992023-06-30
7주식회사 우도사랑투어제주특별자치도 제주시 천수로 82064-712-19422023-06-30
8주식회사 명보관광제주특별자치도 제주시 도령로 87064-712-87692023-06-30
9㈜소리여행사제주특별자치도 제주시 월랑로 74064-713-00072023-06-30
상호명소재지연락처데이터기준일자
155제주 가진투어제주특별자치도 제주시 연북로 161<NA>2023-06-30
156주식회사 썬시티코리아제주특별자치도 제주시 구좌읍 월정 5길064-728-78902023-06-30
157제이원여행사제주특별자치도 제주시 선사로 8길 37<NA>2023-06-30
158주식회사 여행하는 이유제주특별자치도 제주시 월랑북길 17<NA>2023-06-30
159이편한투어제주특별자치도 제주시 연북로 92<NA>2023-06-30
160주식회사 레인보우엔케이투어제주특별자치도 제주시 신광로 15<NA>2023-06-30
161㈜클릭앤라이드제주특별자치도 서귀포시 말질로 322<NA>2023-06-30
162주식회사 뷰틱스제줕특별자치도 서귀포시 서호중앙로55<NA>2023-06-30
163바스톤투어제줕특별자치도 서귀포시 서호중앙로55<NA>2023-06-30
164㈜클릭제주제줕특별자치도 서귀포시 서호중앙로55<NA>2023-06-30