Overview

Dataset statistics

Number of variables4
Number of observations552
Missing cells191
Missing cells (%)8.7%
Duplicate rows3
Duplicate rows (%)0.5%
Total size in memory17.4 KiB
Average record size in memory32.2 B

Variable types

Text3
DateTime1

Dataset

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

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 3 (0.5%) duplicate rowsDuplicates
연락처 has 191 (34.6%) missing valuesMissing

Reproduction

Analysis started2023-12-12 07:41:43.147544
Analysis finished2023-12-12 07:41:43.843629
Duration0.7 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호명
Text

Distinct549
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Memory size4.4 KiB
2023-12-12T16:41:44.132561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length23
Mean length7.692029
Min length2

Characters and Unicode

Total characters4246
Distinct characters448
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

Unique546 ?
Unique (%)98.9%

Sample

1st row㈜한성여행사
2nd row㈜보광여행사
3rd row스카이관광여행사
4th row주식회사 태신항공여행사
5th row㈜조광여행사
ValueCountFrequency (%)
주식회사 141
 
18.6%
제주 8
 
1.1%
유한회사 6
 
0.8%
투어 3
 
0.4%
제주여행 3
 
0.4%
제주도여행사 2
 
0.3%
여행사 2
 
0.3%
제주1번가 2
 
0.3%
사회적협동조합 2
 
0.3%
제주도 2
 
0.3%
Other values (584) 588
77.5%
2023-12-12T16:41:44.639172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 406
 
9.6%
사 289
 
6.8%
제 278
 
6.5%
207
 
4.9%
행 172
 
4.1%
여 169
 
4.0%
투 159
 
3.7%
회 157
 
3.7%
어 157
 
3.7%
식 146
 
3.4%
Other values (438) 2106
49.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3790
89.3%
Space Separator 207
 
4.9%
Other Symbol 117
 
2.8%
Uppercase Letter 37
 
0.9%
Lowercase Letter 32
 
0.8%
Decimal Number 22
 
0.5%
Close Punctuation 18
 
0.4%
Open Punctuation 18
 
0.4%
Other Punctuation 5
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 406
 
10.7%
사 289
 
7.6%
제 278
 
7.3%
행 172
 
4.5%
여 169
 
4.5%
투 159
 
4.2%
회 157
 
4.1%
어 157
 
4.1%
식 146
 
3.9%
이 78
 
2.1%
Other values (388) 1779
46.9%
Uppercase Letter
ValueCountFrequency (%)
A 4
 
10.8%
T 4
 
10.8%
B 3
 
8.1%
U 3
 
8.1%
I 3
 
8.1%
M 2
 
5.4%
P 2
 
5.4%
V 2
 
5.4%
S 2
 
5.4%
H 2
 
5.4%
Other values (8) 10
27.0%
Lowercase Letter
ValueCountFrequency (%)
e 5
15.6%
o 4
12.5%
r 4
12.5%
j 3
9.4%
u 3
9.4%
l 2
 
6.2%
a 2
 
6.2%
n 2
 
6.2%
y 2
 
6.2%
x 1
 
3.1%
Other values (4) 4
12.5%
Decimal Number
ValueCountFrequency (%)
1 6
27.3%
7 3
13.6%
3 2
 
9.1%
0 2
 
9.1%
2 2
 
9.1%
5 2
 
9.1%
9 2
 
9.1%
4 1
 
4.5%
8 1
 
4.5%
6 1
 
4.5%
Close Punctuation
ValueCountFrequency (%)
) 15
83.3%
] 3
 
16.7%
Open Punctuation
ValueCountFrequency (%)
( 15
83.3%
[ 3
 
16.7%
Other Punctuation
ValueCountFrequency (%)
& 4
80.0%
. 1
 
20.0%
Space Separator
ValueCountFrequency (%)
207
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 117
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3907
92.0%
Common 270
 
6.4%
Latin 69
 
1.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 406
 
10.4%
사 289
 
7.4%
제 278
 
7.1%
행 172
 
4.4%
여 169
 
4.3%
투 159
 
4.1%
회 157
 
4.0%
어 157
 
4.0%
식 146
 
3.7%
㈜ 117
 
3.0%
Other values (389) 1857
47.5%
Latin
ValueCountFrequency (%)
e 5
 
7.2%
A 4
 
5.8%
T 4
 
5.8%
o 4
 
5.8%
r 4
 
5.8%
B 3
 
4.3%
j 3
 
4.3%
U 3
 
4.3%
u 3
 
4.3%
I 3
 
4.3%
Other values (22) 33
47.8%
Common
ValueCountFrequency (%)
207
76.7%
) 15
 
5.6%
( 15
 
5.6%
1 6
 
2.2%
& 4
 
1.5%
] 3
 
1.1%
[ 3
 
1.1%
7 3
 
1.1%
3 2
 
0.7%
0 2
 
0.7%
Other values (7) 10
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3790
89.3%
ASCII 339
 
8.0%
None 117
 
2.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 406
 
10.7%
사 289
 
7.6%
제 278
 
7.3%
행 172
 
4.5%
여 169
 
4.5%
투 159
 
4.2%
회 157
 
4.1%
어 157
 
4.1%
식 146
 
3.9%
이 78
 
2.1%
Other values (388) 1779
46.9%
ASCII
ValueCountFrequency (%)
207
61.1%
) 15
 
4.4%
( 15
 
4.4%
1 6
 
1.8%
e 5
 
1.5%
& 4
 
1.2%
A 4
 
1.2%
T 4
 
1.2%
o 4
 
1.2%
r 4
 
1.2%
Other values (39) 71
 
20.9%
None
ValueCountFrequency (%)
㈜ 117
100.0%

소재지
Text

Distinct385
Distinct (%)69.7%
Missing0
Missing (%)0.0%
Memory size4.4 KiB
2023-12-12T16:41:45.102584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length33
Median length30
Mean length19.947464
Min length16

Characters and Unicode

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

Unique

Unique301 ?
Unique (%)54.5%

Sample

1st row제주특별자치도 제주시 신광로1길 17
2nd row제주특별자치도 제주시 원노형9길 24
3rd row제주특별자치도 제주시 연북로 45
4th row제주특별자치도 제주시 청사로 26
5th row제주특별자치도 제주시 신광로4길 44
ValueCountFrequency (%)
제주특별자치도 551
24.3%
제주시 521
23.0%
서귀포시 29
 
1.3%
연북로 26
 
1.1%
92 19
 
0.8%
5 18
 
0.8%
조천읍 18
 
0.8%
도령로 18
 
0.8%
애월읍 15
 
0.7%
일주서로 15
 
0.7%
Other values (490) 1037
45.7%
2023-12-12T16:41:45.762100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1715
15.6%
주 1094
 
9.9%
제 1081
 
9.8%
도 589
 
5.3%
자 553
 
5.0%
특 552
 
5.0%
별 551
 
5.0%
치 551
 
5.0%
시 551
 
5.0%
로 413
 
3.8%
Other values (157) 3361
30.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7616
69.2%
Space Separator 1715
 
15.6%
Decimal Number 1587
 
14.4%
Dash Punctuation 92
 
0.8%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 1094
14.4%
제 1081
14.2%
도 589
7.7%
자 553
 
7.3%
특 552
 
7.2%
별 551
 
7.2%
치 551
 
7.2%
시 551
 
7.2%
로 413
 
5.4%
길 226
 
3.0%
Other values (144) 1455
19.1%
Decimal Number
ValueCountFrequency (%)
1 358
22.6%
2 243
15.3%
4 159
10.0%
5 159
10.0%
3 154
9.7%
7 135
 
8.5%
6 115
 
7.2%
0 106
 
6.7%
8 79
 
5.0%
9 79
 
5.0%
Space Separator
ValueCountFrequency (%)
1715
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 92
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7616
69.2%
Common 3394
30.8%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 1094
14.4%
제 1081
14.2%
도 589
7.7%
자 553
 
7.3%
특 552
 
7.2%
별 551
 
7.2%
치 551
 
7.2%
시 551
 
7.2%
로 413
 
5.4%
길 226
 
3.0%
Other values (144) 1455
19.1%
Common
ValueCountFrequency (%)
1715
50.5%
1 358
 
10.5%
2 243
 
7.2%
4 159
 
4.7%
5 159
 
4.7%
3 154
 
4.5%
7 135
 
4.0%
6 115
 
3.4%
0 106
 
3.1%
- 92
 
2.7%
Other values (2) 158
 
4.7%
Latin
ValueCountFrequency (%)
A 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7616
69.2%
ASCII 3395
30.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1715
50.5%
1 358
 
10.5%
2 243
 
7.2%
4 159
 
4.7%
5 159
 
4.7%
3 154
 
4.5%
7 135
 
4.0%
6 115
 
3.4%
0 106
 
3.1%
- 92
 
2.7%
Other values (3) 159
 
4.7%
Hangul
ValueCountFrequency (%)
주 1094
14.4%
제 1081
14.2%
도 589
7.7%
자 553
 
7.3%
특 552
 
7.2%
별 551
 
7.2%
치 551
 
7.2%
시 551
 
7.2%
로 413
 
5.4%
길 226
 
3.0%
Other values (144) 1455
19.1%

연락처
Text

MISSING 

Distinct353
Distinct (%)97.8%
Missing191
Missing (%)34.6%
Memory size4.4 KiB
2023-12-12T16:41:46.066613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.958449
Min length9

Characters and Unicode

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

Unique347 ?
Unique (%)96.1%

Sample

1st row064-747-0055
2nd row064-758-4035
3rd row064-721-9200
4th row064-713-6332
5th row064-746-6177
ValueCountFrequency (%)
064-712-2313 3
 
0.8%
064-711-4321 3
 
0.8%
064-739-9059 2
 
0.6%
064-711-2232 2
 
0.6%
064-805-3393 2
 
0.6%
064-749-3330 2
 
0.6%
064-805-7900 1
 
0.3%
064-747-9090 1
 
0.3%
064-805-7000 1
 
0.3%
064-758-2822 1
 
0.3%
Other values (343) 343
95.0%
2023-12-12T16:41:46.632882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 714
16.5%
0 709
16.4%
4 615
14.2%
7 502
11.6%
6 485
11.2%
1 263
 
6.1%
2 226
 
5.2%
5 225
 
5.2%
8 216
 
5.0%
3 189
 
4.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 3603
83.5%
Dash Punctuation 714
 
16.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 709
19.7%
4 615
17.1%
7 502
13.9%
6 485
13.5%
1 263
 
7.3%
2 226
 
6.3%
5 225
 
6.2%
8 216
 
6.0%
3 189
 
5.2%
9 173
 
4.8%
Dash Punctuation
ValueCountFrequency (%)
- 714
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 4317
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 714
16.5%
0 709
16.4%
4 615
14.2%
7 502
11.6%
6 485
11.2%
1 263
 
6.1%
2 226
 
5.2%
5 225
 
5.2%
8 216
 
5.0%
3 189
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 4317
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 714
16.5%
0 709
16.4%
4 615
14.2%
7 502
11.6%
6 485
11.2%
1 263
 
6.1%
2 226
 
5.2%
5 225
 
5.2%
8 216
 
5.0%
3 189
 
4.4%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.4 KiB
Minimum2023-06-30 00:00:00
Maximum2023-06-30 00:00:00
2023-12-12T16:41:46.788108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:41:46.907467image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2023-12-12T16:41:43.667958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:41:43.796529image/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길 17064-747-00552023-06-30
1㈜보광여행사제주특별자치도 제주시 원노형9길 24064-758-40352023-06-30
2스카이관광여행사제주특별자치도 제주시 연북로 45064-721-92002023-06-30
3주식회사 태신항공여행사제주특별자치도 제주시 청사로 26064-713-63322023-06-30
4㈜조광여행사제주특별자치도 제주시 신광로4길 44064-746-61772023-06-30
5㈜한길여행사제주특별자치도 제주시 우정로 88064-744-42312023-06-30
6㈜동양썬라이즈관광제주특별자치도 제주시 일주서로 7653-1064-744-07742023-06-30
7제주나이스여행사제주특별자치도 제주시 중앙로4길 3064-725-01002023-06-30
8㈜대일관광제주특별자치도 제주시 연오로 35064-755-99012023-06-30
9㈜뉴월드컵관광여행사제주특별자치도 제주시 현사길 45064-747-40912023-06-30
상호명소재지연락처데이터기준일자
542웨이랩주식회사제주특별자치도 서귀포시 이어도로 777<NA>2023-06-30
543홀로 제주제주특별자치도 서귀포시 막숙포로40번길 8<NA>2023-06-30
544모시고트립제주특별자치도 서귀포시 토평로50번길 47<NA>2023-06-30
545여행제주제주특별자치도 서귀포시 서호중앙로 55 A동 1009호<NA>2023-06-30
546제주HEW봉그레제주특별자치도 서귀포시 중앙로 172<NA>2023-06-30
547플레이스제주특별자치도 서귀포시 성산읍 동류암로 20064-766-30492023-06-30
548브라보투어 주식회사제주특별자치도 서귀포시 표선면 서성일로 63<NA>2023-06-30
549제이제이여행사제주특별자치도 서귀포시 남원읍 원님서로 374<NA>2023-06-30
550제주우도투어제주특별자치도 서귀포시 표선면 포션당포로 10-2064-787-23692023-06-30
551스위트메이 주식회사제주특별자치도 서귀포시 신중남로 23-2064-739-57572023-06-30

Duplicate rows

Most frequently occurring

상호명소재지연락처데이터기준일자# duplicates
0제주도여행사제주특별자치도 서귀포시 서호로 26064-739-90592023-06-302
1주식회사 제주여행오크라제주특별자치도 제주시 월평9길 13064-711-22322023-06-302
2힐링제주제주특별자치도 제주시 신대로 70<NA>2023-06-302