Overview

Dataset statistics

Number of variables6
Number of observations347
Missing cells314
Missing cells (%)15.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory16.4 KiB
Average record size in memory48.4 B

Variable types

Text1
Categorical4
Boolean1

Dataset

Description제주관광정보시스템(VISITJEJU)의 쇼핑 콘텐츠 정보로 콘텐츠명, 평일오픈시간, 평일클로즈시간, 주말오픈시간, 주말클로즈시간, 휴식시작시간, 휴식종료시간, 택배배송여부 등의 정보를 제공합니다.
Author제주관광공사
URLhttps://www.data.go.kr/data/15041983/fileData.do

Alerts

주말클로즈시간 is highly overall correlated with 평일클로즈시간 and 1 other fieldsHigh correlation
주말오픈시간 is highly overall correlated with 평일오픈시간High correlation
평일클로즈시간 is highly overall correlated with 주말클로즈시간 and 1 other fieldsHigh correlation
평일오픈시간 is highly overall correlated with 주말오픈시간High correlation
택배배송여부 is highly overall correlated with 평일클로즈시간 and 1 other fieldsHigh correlation
택배배송여부 is highly imbalanced (67.0%)Imbalance
택배배송여부 has 314 (90.5%) missing valuesMissing
콘텐츠명 has unique valuesUnique

Reproduction

Analysis started2024-03-23 06:58:40.478433
Analysis finished2024-03-23 06:58:42.393424
Duration1.91 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

콘텐츠명
Text

UNIQUE 

Distinct347
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
2024-03-23T06:58:43.183506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length17
Mean length6.0230548
Min length1

Characters and Unicode

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

Unique

Unique347 ?
Unique (%)100.0%

Sample

1st row한마음한라봉
2nd row오르고나이트
3rd row당근가게
4th row제주민속식품
5th row야호농수산
ValueCountFrequency (%)
제주 6
 
1.4%
플리마켓 3
 
0.7%
제주점 3
 
0.7%
소품샵 2
 
0.5%
제주선물가게 2
 
0.5%
선물고팡 2
 
0.5%
벨롱장 2
 
0.5%
와인점방 2
 
0.5%
제주애퐁당 2
 
0.5%
제주관광공사 2
 
0.5%
Other values (404) 404
94.0%
2024-03-23T06:58:45.216690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
85
 
4.1%
주 79
 
3.8%
제 74
 
3.5%
점 45
 
2.2%
이 36
 
1.7%
스 35
 
1.7%
리 35
 
1.7%
장 33
 
1.6%
시 31
 
1.5%
오 27
 
1.3%
Other values (428) 1610
77.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1932
92.4%
Space Separator 85
 
4.1%
Decimal Number 17
 
0.8%
Open Punctuation 13
 
0.6%
Close Punctuation 13
 
0.6%
Lowercase Letter 11
 
0.5%
Uppercase Letter 11
 
0.5%
Other Punctuation 6
 
0.3%
Dash Punctuation 1
 
< 0.1%
Connector Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 79
 
4.1%
제 74
 
3.8%
점 45
 
2.3%
이 36
 
1.9%
스 35
 
1.8%
리 35
 
1.8%
장 33
 
1.7%
시 31
 
1.6%
오 27
 
1.4%
아 27
 
1.4%
Other values (396) 1510
78.2%
Uppercase Letter
ValueCountFrequency (%)
C 2
18.2%
A 2
18.2%
S 2
18.2%
B 1
9.1%
I 1
9.1%
R 1
9.1%
H 1
9.1%
N 1
9.1%
Decimal Number
ValueCountFrequency (%)
1 4
23.5%
0 4
23.5%
9 3
17.6%
3 2
11.8%
2 2
11.8%
4 1
 
5.9%
7 1
 
5.9%
Lowercase Letter
ValueCountFrequency (%)
o 3
27.3%
k 2
18.2%
e 2
18.2%
l 1
 
9.1%
i 1
 
9.1%
a 1
 
9.1%
p 1
 
9.1%
Other Punctuation
ValueCountFrequency (%)
& 4
66.7%
, 1
 
16.7%
@ 1
 
16.7%
Open Punctuation
ValueCountFrequency (%)
( 11
84.6%
[ 2
 
15.4%
Close Punctuation
ValueCountFrequency (%)
) 11
84.6%
] 2
 
15.4%
Space Separator
ValueCountFrequency (%)
85
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1932
92.4%
Common 136
 
6.5%
Latin 22
 
1.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 79
 
4.1%
제 74
 
3.8%
점 45
 
2.3%
이 36
 
1.9%
스 35
 
1.8%
리 35
 
1.8%
장 33
 
1.7%
시 31
 
1.6%
오 27
 
1.4%
아 27
 
1.4%
Other values (396) 1510
78.2%
Common
ValueCountFrequency (%)
85
62.5%
( 11
 
8.1%
) 11
 
8.1%
& 4
 
2.9%
1 4
 
2.9%
0 4
 
2.9%
9 3
 
2.2%
[ 2
 
1.5%
] 2
 
1.5%
3 2
 
1.5%
Other values (7) 8
 
5.9%
Latin
ValueCountFrequency (%)
o 3
13.6%
C 2
 
9.1%
A 2
 
9.1%
S 2
 
9.1%
k 2
 
9.1%
e 2
 
9.1%
B 1
 
4.5%
l 1
 
4.5%
I 1
 
4.5%
R 1
 
4.5%
Other values (5) 5
22.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1929
92.3%
ASCII 158
 
7.6%
Compat Jamo 3
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
85
53.8%
( 11
 
7.0%
) 11
 
7.0%
& 4
 
2.5%
1 4
 
2.5%
0 4
 
2.5%
o 3
 
1.9%
9 3
 
1.9%
C 2
 
1.3%
A 2
 
1.3%
Other values (22) 29
 
18.4%
Hangul
ValueCountFrequency (%)
주 79
 
4.1%
제 74
 
3.8%
점 45
 
2.3%
이 36
 
1.9%
스 35
 
1.8%
리 35
 
1.8%
장 33
 
1.7%
시 31
 
1.6%
오 27
 
1.4%
아 27
 
1.4%
Other values (393) 1507
78.1%
Compat Jamo
ValueCountFrequency (%)
ㄷ 1
33.3%
ㅇ 1
33.3%
ㄹ 1
33.3%

평일오픈시간
Categorical

HIGH CORRELATION 

Distinct23
Distinct (%)6.6%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
11:00
82 
10:00
67 
<NA>
45 
09:00
35 
12:00
28 
Other values (18)
90 

Length

Max length5
Median length5
Mean length4.870317
Min length4

Unique

Unique9 ?
Unique (%)2.6%

Sample

1st row09:00
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row09:00

Common Values

ValueCountFrequency (%)
11:00 82
23.6%
10:00 67
19.3%
<NA> 45
13.0%
09:00 35
10.1%
12:00 28
 
8.1%
08:00 20
 
5.8%
13:00 19
 
5.5%
10:30 18
 
5.2%
09:30 6
 
1.7%
14:00 4
 
1.2%
Other values (13) 23
 
6.6%

Length

2024-03-23T06:58:45.765106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
11:00 82
23.6%
10:00 67
19.3%
na 45
13.0%
09:00 35
10.1%
12:00 28
 
8.1%
08:00 20
 
5.8%
13:00 19
 
5.5%
10:30 18
 
5.2%
09:30 6
 
1.7%
00:00 4
 
1.2%
Other values (13) 23
 
6.6%

평일클로즈시간
Categorical

HIGH CORRELATION 

Distinct22
Distinct (%)6.3%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
18:00
87 
19:00
53 
20:00
47 
<NA>
45 
21:00
28 
Other values (17)
87 

Length

Max length5
Median length5
Mean length4.870317
Min length4

Unique

Unique8 ?
Unique (%)2.3%

Sample

1st row18:00
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row20:00

Common Values

ValueCountFrequency (%)
18:00 87
25.1%
19:00 53
15.3%
20:00 47
13.5%
<NA> 45
13.0%
21:00 28
 
8.1%
17:00 22
 
6.3%
22:00 20
 
5.8%
17:30 9
 
2.6%
14:00 7
 
2.0%
19:30 6
 
1.7%
Other values (12) 23
 
6.6%

Length

2024-03-23T06:58:46.162930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
18:00 87
25.1%
19:00 53
15.3%
20:00 47
13.5%
na 45
13.0%
21:00 28
 
8.1%
17:00 22
 
6.3%
22:00 20
 
5.8%
17:30 9
 
2.6%
14:00 7
 
2.0%
19:30 6
 
1.7%
Other values (12) 23
 
6.6%

주말오픈시간
Categorical

HIGH CORRELATION 

Distinct24
Distinct (%)6.9%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
11:00
81 
10:00
60 
<NA>
54 
12:00
32 
09:00
30 
Other values (19)
90 

Length

Max length5
Median length5
Mean length4.8443804
Min length4

Unique

Unique8 ?
Unique (%)2.3%

Sample

1st row09:00
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row09:00

Common Values

ValueCountFrequency (%)
11:00 81
23.3%
10:00 60
17.3%
<NA> 54
15.6%
12:00 32
 
9.2%
09:00 30
 
8.6%
13:00 20
 
5.8%
08:00 19
 
5.5%
10:30 15
 
4.3%
14:00 6
 
1.7%
00:00 4
 
1.2%
Other values (14) 26
 
7.5%

Length

2024-03-23T06:58:46.793396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
11:00 81
23.3%
10:00 60
17.3%
na 54
15.6%
12:00 32
 
9.2%
09:00 30
 
8.6%
13:00 20
 
5.8%
08:00 19
 
5.5%
10:30 15
 
4.3%
14:00 6
 
1.7%
08:30 4
 
1.2%
Other values (14) 26
 
7.5%

주말클로즈시간
Categorical

HIGH CORRELATION 

Distinct23
Distinct (%)6.6%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
18:00
85 
<NA>
54 
19:00
48 
20:00
44 
21:00
26 
Other values (18)
90 

Length

Max length5
Median length5
Mean length4.8443804
Min length4

Unique

Unique8 ?
Unique (%)2.3%

Sample

1st row18:00
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row20:00

Common Values

ValueCountFrequency (%)
18:00 85
24.5%
<NA> 54
15.6%
19:00 48
13.8%
20:00 44
12.7%
21:00 26
 
7.5%
17:00 23
 
6.6%
22:00 21
 
6.1%
17:30 8
 
2.3%
14:00 8
 
2.3%
00:00 6
 
1.7%
Other values (13) 24
 
6.9%

Length

2024-03-23T06:58:47.185710image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
18:00 85
24.5%
na 54
15.6%
19:00 48
13.8%
20:00 44
12.7%
21:00 26
 
7.5%
17:00 23
 
6.6%
22:00 21
 
6.1%
17:30 8
 
2.3%
14:00 8
 
2.3%
00:00 6
 
1.7%
Other values (13) 24
 
6.9%

택배배송여부
Boolean

HIGH CORRELATION  IMBALANCE  MISSING 

Distinct2
Distinct (%)6.1%
Missing314
Missing (%)90.5%
Memory size826.0 B
True
 
31
False
 
2
(Missing)
314 
ValueCountFrequency (%)
True 31
 
8.9%
False 2
 
0.6%
(Missing) 314
90.5%
2024-03-23T06:58:47.494407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-23T06:58:47.837238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
평일오픈시간평일클로즈시간주말오픈시간주말클로즈시간택배배송여부
평일오픈시간1.0000.8790.9990.8370.000
평일클로즈시간0.8791.0000.8371.0000.610
주말오픈시간0.9990.8371.0000.7620.000
주말클로즈시간0.8371.0000.7621.0000.588
택배배송여부0.0000.6100.0000.5881.000
2024-03-23T06:58:48.177641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
택배배송여부주말클로즈시간주말오픈시간평일클로즈시간평일오픈시간
택배배송여부1.0000.5070.0000.5330.000
주말클로즈시간0.5071.0000.3060.9470.396
주말오픈시간0.0000.3061.0000.3950.934
평일클로즈시간0.5330.9470.3951.0000.459
평일오픈시간0.0000.3960.9340.4591.000
2024-03-23T06:58:48.471444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
평일오픈시간평일클로즈시간주말오픈시간주말클로즈시간택배배송여부
평일오픈시간1.0000.4590.9340.3960.000
평일클로즈시간0.4591.0000.3950.9470.533
주말오픈시간0.9340.3951.0000.3060.000
주말클로즈시간0.3960.9470.3061.0000.507
택배배송여부0.0000.5330.0000.5071.000

Missing values

2024-03-23T06:58:41.834565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-23T06:58:42.203562image/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한마음한라봉09:0018:0009:0018:00<NA>
1오르고나이트<NA><NA><NA><NA><NA>
2당근가게<NA><NA><NA><NA><NA>
3제주민속식품<NA><NA><NA><NA><NA>
4야호농수산09:0020:0009:0020:00<NA>
5아름낭10:0020:0010:0020:00<NA>
6세화해녀민속오일시장08:0014:0008:0014:00<NA>
7바이올가 영어마을점09:0021:0009:0021:00<NA>
8사회복지법인 평화의마을<NA><NA><NA><NA><NA>
9서귀포향토오일시장08:0021:0008:0021:00<NA>
콘텐츠명평일오픈시간평일클로즈시간주말오픈시간주말클로즈시간택배배송여부
337B일상잡화점10:0017:0010:0017:00<NA>
338라바북스11:0018:0011:0018:00<NA>
339제주관광공사 중문면세점 (내국인)10:0019:0010:0019:00<NA>
340모슬포중앙시장08:0020:0008:0020:00<NA>
341소심한책방10:0018:0010:0018:00<NA>
342딜다책방10:0018:0010:0018:00<NA>
343응스테이앤샵11:0017:0011:0017:00<NA>
344돌코롱<NA><NA><NA><NA><NA>
345미앤제주<NA><NA><NA><NA><NA>
346보헤미안 제주08:0021:0008:0021:00y