Overview

Dataset statistics

Number of variables6
Number of observations558
Missing cells136
Missing cells (%)4.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory26.3 KiB
Average record size in memory48.2 B

Variable types

Categorical2
Text3
DateTime1

Dataset

Description제주특별자치도 제주시 관내 국내 여행업 관련 현황 데이터를 제공합니다.
Author제주특별자치도 제주시
URLhttps://www.data.go.kr/data/15056293/fileData.do

Alerts

구분 has constant value ""Constant
데이터기준일자 has constant value ""Constant
비고 is highly imbalanced (92.6%)Imbalance
연락처 has 136 (24.4%) missing valuesMissing
상호명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 03:30:23.059840
Analysis finished2023-12-12 03:30:23.835757
Duration0.78 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.5 KiB
국내여행업
558 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
국내여행업 558
100.0%

Length

2023-12-12T12:30:23.923022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:30:24.049556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
국내여행업 558
100.0%

상호명
Text

UNIQUE 

Distinct558
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size4.5 KiB
2023-12-12T12:30:24.357715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length23
Mean length7.7329749
Min length2

Characters and Unicode

Total characters4315
Distinct characters422
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

Unique558 ?
Unique (%)100.0%

Sample

1st row(유)그린삼육오
2nd row(유)글로벌여행사
3rd row(유)대기여행사
4th row(유)대승항공여행사
5th row(유)미로항공여행
ValueCountFrequency (%)
주식회사 139
 
18.5%
유한회사 7
 
0.9%
tour 3
 
0.4%
여행사 3
 
0.4%
제주여행 3
 
0.4%
제주 3
 
0.4%
투어 2
 
0.3%
제주도 2
 
0.3%
나눔투어 2
 
0.3%
여행 2
 
0.3%
Other values (585) 586
77.9%
2023-12-12T12:30:24.924599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 382
 
8.9%
사 297
 
6.9%
제 259
 
6.0%
194
 
4.5%
행 193
 
4.5%
여 190
 
4.4%
투 169
 
3.9%
어 169
 
3.9%
㈜ 153
 
3.5%
회 153
 
3.5%
Other values (412) 2156
50.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3822
88.6%
Space Separator 194
 
4.5%
Other Symbol 153
 
3.5%
Lowercase Letter 37
 
0.9%
Close Punctuation 29
 
0.7%
Open Punctuation 29
 
0.7%
Uppercase Letter 29
 
0.7%
Decimal Number 19
 
0.4%
Other Punctuation 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 382
 
10.0%
사 297
 
7.8%
제 259
 
6.8%
행 193
 
5.0%
여 190
 
5.0%
투 169
 
4.4%
어 169
 
4.4%
회 153
 
4.0%
식 141
 
3.7%
이 79
 
2.1%
Other values (366) 1790
46.8%
Lowercase Letter
ValueCountFrequency (%)
o 6
16.2%
r 5
13.5%
e 5
13.5%
u 4
10.8%
j 3
8.1%
a 2
 
5.4%
y 2
 
5.4%
l 2
 
5.4%
n 2
 
5.4%
x 1
 
2.7%
Other values (5) 5
13.5%
Uppercase Letter
ValueCountFrequency (%)
A 4
13.8%
T 3
10.3%
B 3
10.3%
I 3
10.3%
V 2
6.9%
P 2
6.9%
J 2
6.9%
G 2
6.9%
S 2
6.9%
U 2
6.9%
Other values (4) 4
13.8%
Decimal Number
ValueCountFrequency (%)
1 6
31.6%
7 3
15.8%
9 2
 
10.5%
0 2
 
10.5%
2 2
 
10.5%
5 1
 
5.3%
8 1
 
5.3%
4 1
 
5.3%
3 1
 
5.3%
Close Punctuation
ValueCountFrequency (%)
) 26
89.7%
] 3
 
10.3%
Open Punctuation
ValueCountFrequency (%)
( 26
89.7%
[ 3
 
10.3%
Other Punctuation
ValueCountFrequency (%)
& 2
66.7%
, 1
33.3%
Space Separator
ValueCountFrequency (%)
194
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 153
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3975
92.1%
Common 274
 
6.3%
Latin 66
 
1.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 382
 
9.6%
사 297
 
7.5%
제 259
 
6.5%
행 193
 
4.9%
여 190
 
4.8%
투 169
 
4.3%
어 169
 
4.3%
㈜ 153
 
3.8%
회 153
 
3.8%
식 141
 
3.5%
Other values (367) 1869
47.0%
Latin
ValueCountFrequency (%)
o 6
 
9.1%
r 5
 
7.6%
e 5
 
7.6%
u 4
 
6.1%
A 4
 
6.1%
T 3
 
4.5%
B 3
 
4.5%
j 3
 
4.5%
I 3
 
4.5%
a 2
 
3.0%
Other values (19) 28
42.4%
Common
ValueCountFrequency (%)
194
70.8%
) 26
 
9.5%
( 26
 
9.5%
1 6
 
2.2%
7 3
 
1.1%
] 3
 
1.1%
[ 3
 
1.1%
9 2
 
0.7%
0 2
 
0.7%
& 2
 
0.7%
Other values (6) 7
 
2.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3822
88.6%
ASCII 340
 
7.9%
None 153
 
3.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 382
 
10.0%
사 297
 
7.8%
제 259
 
6.8%
행 193
 
5.0%
여 190
 
5.0%
투 169
 
4.4%
어 169
 
4.4%
회 153
 
4.0%
식 141
 
3.7%
이 79
 
2.1%
Other values (366) 1790
46.8%
ASCII
ValueCountFrequency (%)
194
57.1%
) 26
 
7.6%
( 26
 
7.6%
1 6
 
1.8%
o 6
 
1.8%
r 5
 
1.5%
e 5
 
1.5%
u 4
 
1.2%
A 4
 
1.2%
T 3
 
0.9%
Other values (35) 61
 
17.9%
None
ValueCountFrequency (%)
㈜ 153
100.0%

소재지
Text

Distinct401
Distinct (%)71.9%
Missing0
Missing (%)0.0%
Memory size4.5 KiB
2023-12-12T12:30:25.372801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length28
Mean length19.729391
Min length16

Characters and Unicode

Total characters11009
Distinct characters156
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

Unique311 ?
Unique (%)55.7%

Sample

1st row제주특별자치도 제주시 선덕로8길 26
2nd row제주특별자치도 제주시 월랑로10길 22
3rd row제주특별자치도 제주시 용문로 144
4th row제주특별자치도 제주시 고마로13길 10
5th row제주특별자치도 제주시 전농로 8-1
ValueCountFrequency (%)
제주특별자치도 558
24.4%
제주시 558
24.4%
도령로 19
 
0.8%
조천읍 16
 
0.7%
일주서로 15
 
0.7%
애월읍 15
 
0.7%
연삼로 14
 
0.6%
5 14
 
0.6%
중앙로 13
 
0.6%
남성로 13
 
0.6%
Other values (479) 1050
46.0%
2023-12-12T12:30:26.016274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1727
15.7%
주 1136
 
10.3%
제 1120
 
10.2%
도 600
 
5.5%
자 560
 
5.1%
시 559
 
5.1%
특 558
 
5.1%
별 558
 
5.1%
치 558
 
5.1%
로 409
 
3.7%
Other values (146) 3224
29.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7612
69.1%
Space Separator 1727
 
15.7%
Decimal Number 1578
 
14.3%
Dash Punctuation 92
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 1136
14.9%
제 1120
14.7%
도 600
7.9%
자 560
7.4%
시 559
7.3%
특 558
7.3%
별 558
7.3%
치 558
7.3%
로 409
 
5.4%
길 242
 
3.2%
Other values (134) 1312
17.2%
Decimal Number
ValueCountFrequency (%)
1 364
23.1%
2 227
14.4%
4 164
10.4%
3 155
9.8%
5 146
9.3%
6 127
 
8.0%
7 124
 
7.9%
0 112
 
7.1%
8 84
 
5.3%
9 75
 
4.8%
Space Separator
ValueCountFrequency (%)
1727
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 92
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7612
69.1%
Common 3397
30.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 1136
14.9%
제 1120
14.7%
도 600
7.9%
자 560
7.4%
시 559
7.3%
특 558
7.3%
별 558
7.3%
치 558
7.3%
로 409
 
5.4%
길 242
 
3.2%
Other values (134) 1312
17.2%
Common
ValueCountFrequency (%)
1727
50.8%
1 364
 
10.7%
2 227
 
6.7%
4 164
 
4.8%
3 155
 
4.6%
5 146
 
4.3%
6 127
 
3.7%
7 124
 
3.7%
0 112
 
3.3%
- 92
 
2.7%
Other values (2) 159
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7612
69.1%
ASCII 3397
30.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1727
50.8%
1 364
 
10.7%
2 227
 
6.7%
4 164
 
4.8%
3 155
 
4.6%
5 146
 
4.3%
6 127
 
3.7%
7 124
 
3.7%
0 112
 
3.3%
- 92
 
2.7%
Other values (2) 159
 
4.7%
Hangul
ValueCountFrequency (%)
주 1136
14.9%
제 1120
14.7%
도 600
7.9%
자 560
7.4%
시 559
7.3%
특 558
7.3%
별 558
7.3%
치 558
7.3%
로 409
 
5.4%
길 242
 
3.2%
Other values (134) 1312
17.2%

연락처
Text

MISSING 

Distinct414
Distinct (%)98.1%
Missing136
Missing (%)24.4%
Memory size4.5 KiB
2023-12-12T12:30:26.361506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length11.964455
Min length9

Characters and Unicode

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

Unique407 ?
Unique (%)96.4%

Sample

1st row064-711-3651
2nd row064-748-6454
3rd row064-725-4536
4th row064-727-5588
5th row064-724-1206
ValueCountFrequency (%)
064-711-4321 3
 
0.7%
064-805-3393 2
 
0.5%
064-749-3330 2
 
0.5%
064-805-9889 2
 
0.5%
064-748-9001 2
 
0.5%
064-712-2313 2
 
0.5%
064-756-9779 2
 
0.5%
064-747-5303 1
 
0.2%
064-759-9100 1
 
0.2%
064-746-4003 1
 
0.2%
Other values (404) 404
95.7%
2023-12-12T12:30:27.186002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 834
16.5%
0 829
16.4%
4 744
14.7%
7 591
11.7%
6 556
11.0%
1 290
 
5.7%
2 284
 
5.6%
5 269
 
5.3%
8 234
 
4.6%
3 209
 
4.1%
Other values (2) 209
 
4.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 4214
83.5%
Dash Punctuation 834
 
16.5%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 829
19.7%
4 744
17.7%
7 591
14.0%
6 556
13.2%
1 290
 
6.9%
2 284
 
6.7%
5 269
 
6.4%
8 234
 
5.6%
3 209
 
5.0%
9 208
 
4.9%
Dash Punctuation
ValueCountFrequency (%)
- 834
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 5049
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 834
16.5%
0 829
16.4%
4 744
14.7%
7 591
11.7%
6 556
11.0%
1 290
 
5.7%
2 284
 
5.6%
5 269
 
5.3%
8 234
 
4.6%
3 209
 
4.1%
Other values (2) 209
 
4.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 5049
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 834
16.5%
0 829
16.4%
4 744
14.7%
7 591
11.7%
6 556
11.0%
1 290
 
5.7%
2 284
 
5.6%
5 269
 
5.3%
8 234
 
4.6%
3 209
 
4.1%
Other values (2) 209
 
4.1%

비고
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size4.5 KiB
<NA>
553 
휴업
 
5

Length

Max length4
Median length4
Mean length3.9820789
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row휴업
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 553
99.1%
휴업 5
 
0.9%

Length

2023-12-12T12:30:27.382150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:30:27.506235image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 553
99.1%
휴업 5
 
0.9%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.5 KiB
Minimum2021-05-31 00:00:00
Maximum2021-05-31 00:00:00
2023-12-12T12:30:27.620176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:30:27.753225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2023-12-12T12:30:23.589107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T12:30:23.770992image/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국내여행업(유)그린삼육오제주특별자치도 제주시 선덕로8길 26064-711-3651<NA>2021-05-31
1국내여행업(유)글로벌여행사제주특별자치도 제주시 월랑로10길 22064-748-6454<NA>2021-05-31
2국내여행업(유)대기여행사제주특별자치도 제주시 용문로 144064-725-4536휴업2021-05-31
3국내여행업(유)대승항공여행사제주특별자치도 제주시 고마로13길 10064-727-5588<NA>2021-05-31
4국내여행업(유)미로항공여행제주특별자치도 제주시 전농로 8-1064-724-1206<NA>2021-05-31
5국내여행업(유)스카이관광제주특별자치도 제주시 전농로 96064-759-7788<NA>2021-05-31
6국내여행업(유)승제주특별자치도 제주시 남광로 113-1064-753-8496<NA>2021-05-31
7국내여행업(유)영스타관광제주특별자치도 제주시 신대로10길 36064-744-7799<NA>2021-05-31
8국내여행업(유)월드컵여행사제주특별자치도 제주시 용마서길 25-1064-743-2301<NA>2021-05-31
9국내여행업(유)인성여행사제주특별자치도 제주시 다랑곶6길 69064-748-0123<NA>2021-05-31
구분상호명소재지연락처비고데이터기준일자
548국내여행업해피타임제주특별자치도 제주시 아란8길 16<NA><NA>2021-05-31
549국내여행업행복제주제주특별자치도 제주시 신대로 119064-756-5500<NA>2021-05-31
550국내여행업행복한여행사제주특별자치도 제주시 일주서로 7667064-745-7542<NA>2021-05-31
551국내여행업현여행갤러리제주특별자치도 제주시 구남로6길 44<NA><NA>2021-05-31
552국내여행업홀리데이여행사제주특별자치도 제주시 진군4길 10064-746-6000<NA>2021-05-31
553국내여행업홍스타투어제주특별자치도 제주시 연동8길 29064-743-5308<NA>2021-05-31
554국내여행업황금여행사제주특별자치도 제주시 중앙로 118-1064-723-3295<NA>2021-05-31
555국내여행업휘파람투어제주특별자치도 제주시 인다9길 3064-727-0509<NA>2021-05-31
556국내여행업히든여행사제주특별자치도 제주시 임항로 257064-711-6011<NA>2021-05-31
557국내여행업힐링제주제주특별자치도 제주시 신대로 70<NA><NA>2021-05-31