Overview

Dataset statistics

Number of variables7
Number of observations157
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.2 KiB
Average record size in memory59.8 B

Variable types

Numeric2
Text2
Categorical1
DateTime1
Boolean1

Dataset

Description제주관광정보시스템(VISITJEJU)의 여행일정댓글 정보로 댓글ID, 여행일정, 상위댓글ID, 깊이, 댓글, 등록일시, 사용여부 등의 정보를 제공합니다.
Author제주관광공사
URLhttps://www.data.go.kr/data/15049996/fileData.do

Alerts

사용여부 has constant value ""Constant
상위댓글ID is highly overall correlated with 깊이High correlation
깊이 is highly overall correlated with 상위댓글IDHigh correlation
댓글ID has unique valuesUnique
상위댓글ID has 129 (82.2%) zerosZeros

Reproduction

Analysis started2024-03-23 05:36:23.381511
Analysis finished2024-03-23 05:36:25.292954
Duration1.91 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

댓글ID
Real number (ℝ)

UNIQUE 

Distinct157
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean240.94268
Minimum112
Maximum441
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-03-23T14:36:25.437169image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum112
5-th percentile130.8
Q1169
median222
Q3319
95-th percentile389.4
Maximum441
Range329
Interquartile range (IQR)150

Descriptive statistics

Standard deviation87.015931
Coefficient of variation (CV)0.36114786
Kurtosis-0.96647463
Mean240.94268
Median Absolute Deviation (MAD)63
Skewness0.5141605
Sum37828
Variance7571.7723
MonotonicityNot monotonic
2024-03-23T14:36:25.717049image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
249 1
 
0.6%
112 1
 
0.6%
222 1
 
0.6%
226 1
 
0.6%
344 1
 
0.6%
260 1
 
0.6%
323 1
 
0.6%
340 1
 
0.6%
355 1
 
0.6%
143 1
 
0.6%
Other values (147) 147
93.6%
ValueCountFrequency (%)
112 1
0.6%
123 1
0.6%
124 1
0.6%
125 1
0.6%
127 1
0.6%
128 1
0.6%
129 1
0.6%
130 1
0.6%
131 1
0.6%
132 1
0.6%
ValueCountFrequency (%)
441 1
0.6%
430 1
0.6%
418 1
0.6%
406 1
0.6%
405 1
0.6%
394 1
0.6%
393 1
0.6%
391 1
0.6%
389 1
0.6%
387 1
0.6%

여행일정
Text

Distinct82
Distinct (%)52.2%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2024-03-23T14:36:26.193173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length17
Mean length9.2420382
Min length1

Characters and Unicode

Total characters1451
Distinct characters221
Distinct categories11 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique59 ?
Unique (%)37.6%

Sample

1st row하하하
2nd row겨울제주
3rd row겨울제주
4th row겨울제주
5th row겨울제주
ValueCountFrequency (%)
여행 52
 
13.6%
제주 20
 
5.2%
제주여행 16
 
4.2%
2박3일 11
 
2.9%
3박4일 10
 
2.6%
겨울제주 10
 
2.6%
여행기 8
 
2.1%
템포 8
 
2.1%
한 8
 
2.1%
쉬어가는 8
 
2.1%
Other values (148) 231
60.5%
2024-03-23T14:36:26.979434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
228
 
15.7%
여 100
 
6.9%
행 99
 
6.8%
제 75
 
5.2%
주 74
 
5.1%
일 33
 
2.3%
3 33
 
2.3%
박 32
 
2.2%
가 27
 
1.9%
이 23
 
1.6%
Other values (211) 727
50.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 984
67.8%
Space Separator 228
 
15.7%
Lowercase Letter 98
 
6.8%
Decimal Number 96
 
6.6%
Other Punctuation 20
 
1.4%
Uppercase Letter 13
 
0.9%
Math Symbol 5
 
0.3%
Connector Punctuation 4
 
0.3%
Other Symbol 1
 
0.1%
Close Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
여 100
 
10.2%
행 99
 
10.1%
제 75
 
7.6%
주 74
 
7.5%
일 33
 
3.4%
박 32
 
3.3%
가 27
 
2.7%
이 23
 
2.3%
의 18
 
1.8%
한 17
 
1.7%
Other values (159) 486
49.4%
Lowercase Letter
ValueCountFrequency (%)
e 12
12.2%
t 11
11.2%
i 10
 
10.2%
s 8
 
8.2%
u 6
 
6.1%
c 5
 
5.1%
n 5
 
5.1%
d 5
 
5.1%
y 5
 
5.1%
o 4
 
4.1%
Other values (12) 27
27.6%
Decimal Number
ValueCountFrequency (%)
3 33
34.4%
2 20
20.8%
4 17
17.7%
1 11
 
11.5%
0 6
 
6.2%
6 5
 
5.2%
5 2
 
2.1%
9 1
 
1.0%
8 1
 
1.0%
Uppercase Letter
ValueCountFrequency (%)
J 2
15.4%
B 2
15.4%
M 2
15.4%
L 2
15.4%
N 1
7.7%
W 1
7.7%
E 1
7.7%
T 1
7.7%
A 1
7.7%
Other Punctuation
ValueCountFrequency (%)
. 7
35.0%
! 5
25.0%
, 5
25.0%
? 1
 
5.0%
& 1
 
5.0%
/ 1
 
5.0%
Space Separator
ValueCountFrequency (%)
228
100.0%
Math Symbol
ValueCountFrequency (%)
~ 5
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 4
100.0%
Other Symbol
ValueCountFrequency (%)
♥ 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 979
67.5%
Common 356
 
24.5%
Latin 111
 
7.6%
Han 5
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
여 100
 
10.2%
행 99
 
10.1%
제 75
 
7.7%
주 74
 
7.6%
일 33
 
3.4%
박 32
 
3.3%
가 27
 
2.8%
이 23
 
2.3%
의 18
 
1.8%
한 17
 
1.7%
Other values (154) 481
49.1%
Latin
ValueCountFrequency (%)
e 12
 
10.8%
t 11
 
9.9%
i 10
 
9.0%
s 8
 
7.2%
u 6
 
5.4%
c 5
 
4.5%
n 5
 
4.5%
d 5
 
4.5%
y 5
 
4.5%
o 4
 
3.6%
Other values (21) 40
36.0%
Common
ValueCountFrequency (%)
228
64.0%
3 33
 
9.3%
2 20
 
5.6%
4 17
 
4.8%
1 11
 
3.1%
. 7
 
2.0%
0 6
 
1.7%
! 5
 
1.4%
~ 5
 
1.4%
6 5
 
1.4%
Other values (11) 19
 
5.3%
Han
ValueCountFrequency (%)
州 1
20.0%
島 1
20.0%
行 1
20.0%
旅 1
20.0%
美 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 979
67.5%
ASCII 466
32.1%
CJK 5
 
0.3%
Misc Symbols 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
228
48.9%
3 33
 
7.1%
2 20
 
4.3%
4 17
 
3.6%
e 12
 
2.6%
t 11
 
2.4%
1 11
 
2.4%
i 10
 
2.1%
s 8
 
1.7%
. 7
 
1.5%
Other values (41) 109
23.4%
Hangul
ValueCountFrequency (%)
여 100
 
10.2%
행 99
 
10.1%
제 75
 
7.7%
주 74
 
7.6%
일 33
 
3.4%
박 32
 
3.3%
가 27
 
2.8%
이 23
 
2.3%
의 18
 
1.8%
한 17
 
1.7%
Other values (154) 481
49.1%
Misc Symbols
ValueCountFrequency (%)
♥ 1
100.0%
CJK
ValueCountFrequency (%)
州 1
20.0%
島 1
20.0%
行 1
20.0%
旅 1
20.0%
美 1
20.0%

상위댓글ID
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct21
Distinct (%)13.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean45.235669
Minimum0
Maximum342
Zeros129
Zeros (%)82.2%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-03-23T14:36:27.663107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile311.6
Maximum342
Range342
Interquartile range (IQR)0

Descriptive statistics

Standard deviation102.24763
Coefficient of variation (CV)2.2603321
Kurtosis2.3401271
Mean45.235669
Median Absolute Deviation (MAD)0
Skewness2.0003383
Sum7102
Variance10454.579
MonotonicityNot monotonic
2024-03-23T14:36:27.851746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
0 129
82.2%
297 4
 
2.5%
317 4
 
2.5%
135 2
 
1.3%
159 2
 
1.3%
342 1
 
0.6%
162 1
 
0.6%
257 1
 
0.6%
192 1
 
0.6%
132 1
 
0.6%
Other values (11) 11
 
7.0%
ValueCountFrequency (%)
0 129
82.2%
132 1
 
0.6%
135 2
 
1.3%
150 1
 
0.6%
152 1
 
0.6%
159 2
 
1.3%
162 1
 
0.6%
192 1
 
0.6%
231 1
 
0.6%
251 1
 
0.6%
ValueCountFrequency (%)
342 1
 
0.6%
327 1
 
0.6%
317 4
2.5%
316 1
 
0.6%
314 1
 
0.6%
311 1
 
0.6%
309 1
 
0.6%
308 1
 
0.6%
304 1
 
0.6%
297 4
2.5%

깊이
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
0
129 
1
28 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row1
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 129
82.2%
1 28
 
17.8%

Length

2024-03-23T14:36:28.047336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T14:36:28.186604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 129
82.2%
1 28
 
17.8%

댓글
Text

Distinct153
Distinct (%)97.5%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2024-03-23T14:36:28.525278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length311
Median length60
Mean length19.33121
Min length5

Characters and Unicode

Total characters3035
Distinct characters470
Distinct categories12 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique149 ?
Unique (%)94.9%

Sample

1st rowfgfdg
2nd row2/16 간식 녹차 오프레도 녹차 라떼 그린티 롤케익 호지 초코 다쿠아즈
3rd row2/16 저녁
4th row2/17 짱구분식 모닥치기(대) 라면
5th row2/17 간식 오는정김밥 치즈김밥
ValueCountFrequency (%)
8
 
1.3%
2/17 7
 
1.1%
저녁 7
 
1.1%
제주 6
 
1.0%
2일차 5
 
0.8%
점심 5
 
0.8%
간식 5
 
0.8%
퍼시픽 3
 
0.5%
i 3
 
0.5%
좋아요 3
 
0.5%
Other values (497) 557
91.5%
2024-03-23T14:36:29.314553image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
480
 
15.8%
1 68
 
2.2%
시 53
 
1.7%
2 48
 
1.6%
~ 39
 
1.3%
ㅡ 38
 
1.3%
이 32
 
1.1%
0 32
 
1.1%
일 31
 
1.0%
3 31
 
1.0%
Other values (460) 2183
71.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1921
63.3%
Space Separator 480
 
15.8%
Decimal Number 260
 
8.6%
Lowercase Letter 182
 
6.0%
Other Punctuation 73
 
2.4%
Math Symbol 42
 
1.4%
Open Punctuation 19
 
0.6%
Close Punctuation 18
 
0.6%
Uppercase Letter 17
 
0.6%
Dash Punctuation 14
 
0.5%
Other values (2) 9
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 53
 
2.8%
ㅡ 38
 
2.0%
이 32
 
1.7%
일 31
 
1.6%
다 30
 
1.6%
주 27
 
1.4%
스 25
 
1.3%
지 25
 
1.3%
제 22
 
1.1%
도 21
 
1.1%
Other values (403) 1617
84.2%
Lowercase Letter
ValueCountFrequency (%)
t 19
10.4%
o 18
9.9%
i 17
9.3%
s 15
 
8.2%
e 14
 
7.7%
d 13
 
7.1%
a 12
 
6.6%
f 11
 
6.0%
g 11
 
6.0%
r 11
 
6.0%
Other values (12) 41
22.5%
Decimal Number
ValueCountFrequency (%)
1 68
26.2%
2 48
18.5%
0 32
12.3%
3 31
11.9%
5 20
 
7.7%
7 18
 
6.9%
4 14
 
5.4%
6 12
 
4.6%
8 10
 
3.8%
9 7
 
2.7%
Uppercase Letter
ValueCountFrequency (%)
D 3
17.6%
P 3
17.6%
I 2
11.8%
H 2
11.8%
T 2
11.8%
V 1
 
5.9%
C 1
 
5.9%
A 1
 
5.9%
Y 1
 
5.9%
M 1
 
5.9%
Other Punctuation
ValueCountFrequency (%)
. 29
39.7%
? 14
19.2%
/ 10
 
13.7%
, 7
 
9.6%
: 5
 
6.8%
! 5
 
6.8%
; 3
 
4.1%
Math Symbol
ValueCountFrequency (%)
~ 39
92.9%
> 3
 
7.1%
Space Separator
ValueCountFrequency (%)
480
100.0%
Open Punctuation
ValueCountFrequency (%)
( 19
100.0%
Close Punctuation
ValueCountFrequency (%)
) 18
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 14
100.0%
Modifier Symbol
ValueCountFrequency (%)
^ 8
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1917
63.2%
Common 915
30.1%
Latin 199
 
6.6%
Han 4
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 53
 
2.8%
ㅡ 38
 
2.0%
이 32
 
1.7%
일 31
 
1.6%
다 30
 
1.6%
주 27
 
1.4%
스 25
 
1.3%
지 25
 
1.3%
제 22
 
1.1%
도 21
 
1.1%
Other values (399) 1613
84.1%
Latin
ValueCountFrequency (%)
t 19
 
9.5%
o 18
 
9.0%
i 17
 
8.5%
s 15
 
7.5%
e 14
 
7.0%
d 13
 
6.5%
a 12
 
6.0%
f 11
 
5.5%
g 11
 
5.5%
r 11
 
5.5%
Other values (22) 58
29.1%
Common
ValueCountFrequency (%)
480
52.5%
1 68
 
7.4%
2 48
 
5.2%
~ 39
 
4.3%
0 32
 
3.5%
3 31
 
3.4%
. 29
 
3.2%
5 20
 
2.2%
( 19
 
2.1%
7 18
 
2.0%
Other values (15) 131
 
14.3%
Han
ValueCountFrequency (%)
行 1
25.0%
旅 1
25.0%
州 1
25.0%
島 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1810
59.6%
ASCII 1114
36.7%
Compat Jamo 107
 
3.5%
CJK 4
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
480
43.1%
1 68
 
6.1%
2 48
 
4.3%
~ 39
 
3.5%
0 32
 
2.9%
3 31
 
2.8%
. 29
 
2.6%
5 20
 
1.8%
t 19
 
1.7%
( 19
 
1.7%
Other values (47) 329
29.5%
Hangul
ValueCountFrequency (%)
시 53
 
2.9%
이 32
 
1.8%
일 31
 
1.7%
다 30
 
1.7%
주 27
 
1.5%
스 25
 
1.4%
지 25
 
1.4%
제 22
 
1.2%
도 21
 
1.2%
로 21
 
1.2%
Other values (386) 1523
84.1%
Compat Jamo
ValueCountFrequency (%)
ㅡ 38
35.5%
ㅇ 20
18.7%
ㅋ 15
 
14.0%
ㅎ 14
 
13.1%
ㄴ 6
 
5.6%
ㅁ 6
 
5.6%
ㄹ 2
 
1.9%
ㄶ 1
 
0.9%
ㅓ 1
 
0.9%
ㅗ 1
 
0.9%
Other values (3) 3
 
2.8%
CJK
ValueCountFrequency (%)
行 1
25.0%
旅 1
25.0%
州 1
25.0%
島 1
25.0%

등록일시
Date

Distinct102
Distinct (%)65.0%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2018-05-04 00:00:00
Maximum2024-01-31 00:00:00
2024-03-23T14:36:29.578437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:36:29.887805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

사용여부
Boolean

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size289.0 B
True
157 
ValueCountFrequency (%)
True 157
100.0%
2024-03-23T14:36:30.110895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Interactions

2024-03-23T14:36:24.597996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:36:24.168586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:36:24.754296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:36:24.394489image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-23T14:36:30.208725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
댓글ID여행일정상위댓글ID깊이
댓글ID1.0000.9760.6970.644
여행일정0.9761.0000.0000.431
상위댓글ID0.6970.0001.0001.000
깊이0.6440.4311.0001.000
2024-03-23T14:36:30.384420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
댓글ID상위댓글ID깊이
댓글ID1.0000.1230.487
상위댓글ID0.1231.0000.980
깊이0.4870.9801.000

Missing values

2024-03-23T14:36:24.994868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-23T14:36:25.210641image/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

댓글ID여행일정상위댓글ID깊이댓글등록일시사용여부
0249하하하00fgfdg2020-02-16y
1250겨울제주002/16 간식 녹차 오프레도 녹차 라떼 그린티 롤케익 호지 초코 다쿠아즈2020-02-17y
2252겨울제주25112/16 저녁2020-02-17y
3253겨울제주002/17 짱구분식 모닥치기(대) 라면2020-02-17y
4254겨울제주002/17 간식 오는정김밥 치즈김밥2020-02-17y
5256겨울제주002/17 저녁 제주 해녀짬뽕 특 해녀짬뽕 특 해녀짜장 탕수육(중)2020-02-17y
6441웰빙2002박 3일2024-01-31y
7430준우가족3박4일여행00좋음코스별로 잘짬2023-09-19y
8257겨울제주002/17 간식 스타벅스 성산D주푸치노(저지방, 에스프레소휘핑2020-02-17y
9273바이크투어00제주바이크투어2020-11-19y
댓글ID여행일정상위댓글ID깊이댓글등록일시사용여부
1471692박3일 여행기00좋네요~~~~2018-10-01y
14817410월 제주여행001일 운정이네 본점2018-10-28y
14917310월 제주여행00점심 운정이네 본점2018-10-28y
15017510월 제주여행005일 도두반점2018-10-28y
151186겨울 제주의 모든 것, 윈터 제주 여행001111112019-01-19y
152200제주 여행00첫째낭 아침 먹고 바이제주2019-04-24y
153229666600허경영!허경영!허경영!2019-11-28y
154216삐뽀와 3박4일 제주여행00케니스토리 1008호2019-06-23y
155217삐뽀와 3박4일 제주여행001033호2019-06-27y
156230세식구만의 여행00한림칼국수2019-12-09y