Overview

Dataset statistics

Number of variables21
Number of observations10000
Missing cells3153
Missing cells (%)1.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.8 MiB
Average record size in memory186.0 B

Variable types

Numeric8
Categorical4
Text2
DateTime4
Boolean3

Dataset

Description제주관광정보시스템(VISITJEJU)의 여행일정 데이터로 여행일정ID, 언어코드, 제목, 조회수, 공유수, 여행시작일, 여행종료일 등의 정보를 제공합니다.
Author제주관광공사
URLhttps://www.data.go.kr/data/15049998/fileData.do

Alerts

좋아요수 has constant value ""Constant
소셜네트워크공유수 has constant value ""Constant
언어 is highly imbalanced (79.9%)Imbalance
추천일정등록여부 is highly imbalanced (92.5%)Imbalance
인기점수 has 3150 (31.5%) missing valuesMissing
조회수 is highly skewed (γ1 = 29.93278336)Skewed
공유수 is highly skewed (γ1 = 32.78919457)Skewed
여행기간 is highly skewed (γ1 = 36.85867927)Skewed
댓글수 is highly skewed (γ1 = 65.44837724)Skewed
북마크수 is highly skewed (γ1 = 20.0256353)Skewed
인기점수 is highly skewed (γ1 = 24.78846321)Skewed
여행일정아이디 has unique valuesUnique
조회수 has 3150 (31.5%) zerosZeros
공유수 has 9793 (97.9%) zerosZeros
댓글수 has 9931 (99.3%) zerosZeros
북마크수 has 9806 (98.1%) zerosZeros

Reproduction

Analysis started2024-03-23 05:33:08.440060
Analysis finished2024-03-23 05:33:11.277534
Duration2.84 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

여행일정아이디
Real number (ℝ)

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13139.597
Minimum1
Maximum22839
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-23T14:33:11.425876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3804.95
Q17848.75
median13390.5
Q318592.25
95-th percentile21920.05
Maximum22839
Range22838
Interquartile range (IQR)10743.5

Descriptive statistics

Standard deviation6002.5901
Coefficient of variation (CV)0.45683212
Kurtosis-1.2261373
Mean13139.597
Median Absolute Deviation (MAD)5357.5
Skewness-0.11047571
Sum1.3139597 × 108
Variance36031088
MonotonicityNot monotonic
2024-03-23T14:33:11.692193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
18477 1
 
< 0.1%
7032 1
 
< 0.1%
5870 1
 
< 0.1%
8037 1
 
< 0.1%
21520 1
 
< 0.1%
17332 1
 
< 0.1%
9718 1
 
< 0.1%
17565 1
 
< 0.1%
16136 1
 
< 0.1%
16450 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
1 1
< 0.1%
249 1
< 0.1%
360 1
< 0.1%
381 1
< 0.1%
461 1
< 0.1%
462 1
< 0.1%
483 1
< 0.1%
484 1
< 0.1%
485 1
< 0.1%
492 1
< 0.1%
ValueCountFrequency (%)
22839 1
< 0.1%
22838 1
< 0.1%
22837 1
< 0.1%
22834 1
< 0.1%
22832 1
< 0.1%
22831 1
< 0.1%
22830 1
< 0.1%
22829 1
< 0.1%
22828 1
< 0.1%
22827 1
< 0.1%

언어
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
국문
9255 
영문
 
571
중문간체
 
78
일문
 
58
중문번체
 
38

Length

Max length4
Median length2
Mean length2.0232
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row국문
2nd row국문
3rd row국문
4th row국문
5th row국문

Common Values

ValueCountFrequency (%)
국문 9255
92.5%
영문 571
 
5.7%
중문간체 78
 
0.8%
일문 58
 
0.6%
중문번체 38
 
0.4%

Length

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

Common Values (Plot)

2024-03-23T14:33:12.443765image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
국문 9255
92.5%
영문 571
 
5.7%
중문간체 78
 
0.8%
일문 58
 
0.6%
중문번체 38
 
0.4%

제목
Text

Distinct5710
Distinct (%)57.1%
Missing3
Missing (%)< 0.1%
Memory size156.2 KiB
2024-03-23T14:33:13.056673image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length82
Median length41
Mean length8.8522557
Min length1

Characters and Unicode

Total characters88496
Distinct characters1179
Distinct categories14 ?
Distinct scripts6 ?
Distinct blocks10 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique5044 ?
Unique (%)50.5%

Sample

1st row가족여행
2nd row나홀로 떠나 보는 여행
3rd rowddadas
4th row가족여행으로제주도
5th row힐링~~ 가족여행
ValueCountFrequency (%)
여행 1602
 
7.2%
제주여행 866
 
3.9%
제주 824
 
3.7%
가족여행 775
 
3.5%
2박3일 523
 
2.4%
제주도 485
 
2.2%
3박4일 462
 
2.1%
jeju 367
 
1.7%
3박 276
 
1.2%
4일 272
 
1.2%
Other values (5083) 15752
70.9%
2024-03-23T14:33:14.011373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
12501
 
14.1%
여 5010
 
5.7%
행 4848
 
5.5%
주 3436
 
3.9%
제 3253
 
3.7%
일 2557
 
2.9%
박 2273
 
2.6%
가 2245
 
2.5%
3 2105
 
2.4%
2 2053
 
2.3%
Other values (1169) 48215
54.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 56623
64.0%
Space Separator 12503
 
14.1%
Decimal Number 8566
 
9.7%
Lowercase Letter 7459
 
8.4%
Uppercase Letter 1720
 
1.9%
Other Punctuation 869
 
1.0%
Math Symbol 170
 
0.2%
Close Punctuation 158
 
0.2%
Open Punctuation 140
 
0.2%
Other Symbol 123
 
0.1%
Other values (4) 165
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
여 5010
 
8.8%
행 4848
 
8.6%
주 3436
 
6.1%
제 3253
 
5.7%
일 2557
 
4.5%
박 2273
 
4.0%
가 2245
 
4.0%
족 1511
 
2.7%
이 1083
 
1.9%
도 807
 
1.4%
Other values (1064) 29600
52.3%
Lowercase Letter
ValueCountFrequency (%)
e 756
 
10.1%
i 687
 
9.2%
t 598
 
8.0%
u 525
 
7.0%
a 524
 
7.0%
s 505
 
6.8%
r 499
 
6.7%
j 451
 
6.0%
n 399
 
5.3%
d 395
 
5.3%
Other values (16) 2120
28.4%
Uppercase Letter
ValueCountFrequency (%)
J 382
22.2%
T 218
12.7%
D 129
 
7.5%
N 122
 
7.1%
S 103
 
6.0%
V 87
 
5.1%
M 84
 
4.9%
O 75
 
4.4%
A 71
 
4.1%
E 71
 
4.1%
Other values (16) 378
22.0%
Other Punctuation
ValueCountFrequency (%)
! 308
35.4%
. 260
29.9%
, 112
 
12.9%
/ 58
 
6.7%
& 47
 
5.4%
' 32
 
3.7%
: 21
 
2.4%
# 17
 
2.0%
" 4
 
0.5%
、 3
 
0.3%
Other values (4) 7
 
0.8%
Decimal Number
ValueCountFrequency (%)
3 2105
24.6%
2 2053
24.0%
4 1422
16.6%
1 965
11.3%
0 723
 
8.4%
5 546
 
6.4%
9 214
 
2.5%
6 195
 
2.3%
8 186
 
2.2%
7 147
 
1.7%
Other values (3) 10
 
0.1%
Math Symbol
ValueCountFrequency (%)
~ 145
85.3%
+ 12
 
7.1%
> 5
 
2.9%
< 5
 
2.9%
= 2
 
1.2%
∇ 1
 
0.6%
Other Symbol
ValueCountFrequency (%)
♥ 59
48.0%
♡ 55
44.7%
★ 5
 
4.1%
☆ 2
 
1.6%
ⓐ 1
 
0.8%
♬ 1
 
0.8%
Close Punctuation
ValueCountFrequency (%)
) 113
71.5%
】 44
 
27.8%
] 1
 
0.6%
Open Punctuation
ValueCountFrequency (%)
( 95
67.9%
【 44
31.4%
[ 1
 
0.7%
Space Separator
ValueCountFrequency (%)
12501
> 99.9%
　 2
 
< 0.1%
Modifier Symbol
ValueCountFrequency (%)
^ 34
94.4%
` 2
 
5.6%
Other Number
ValueCountFrequency (%)
① 1
50.0%
② 1
50.0%
Dash Punctuation
ValueCountFrequency (%)
- 92
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 35
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 55843
63.1%
Common 22694
25.6%
Latin 9179
 
10.4%
Han 592
 
0.7%
Hiragana 96
 
0.1%
Katakana 92
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
여 5010
 
9.0%
행 4848
 
8.7%
주 3436
 
6.2%
제 3253
 
5.8%
일 2557
 
4.6%
박 2273
 
4.1%
가 2245
 
4.0%
족 1511
 
2.7%
이 1083
 
1.9%
도 807
 
1.4%
Other values (856) 28820
51.6%
Han
ValueCountFrequency (%)
州 68
 
11.5%
旅 55
 
9.3%
日 30
 
5.1%
行 29
 
4.9%
島 27
 
4.6%
甲 19
 
3.2%
天 18
 
3.0%
游 17
 
2.9%
濟 14
 
2.4%
一 14
 
2.4%
Other values (130) 301
50.8%
Common
ValueCountFrequency (%)
12501
55.1%
3 2105
 
9.3%
2 2053
 
9.0%
4 1422
 
6.3%
1 965
 
4.3%
0 723
 
3.2%
5 546
 
2.4%
! 308
 
1.4%
. 260
 
1.1%
9 214
 
0.9%
Other values (43) 1597
 
7.0%
Latin
ValueCountFrequency (%)
e 756
 
8.2%
i 687
 
7.5%
t 598
 
6.5%
u 525
 
5.7%
a 524
 
5.7%
s 505
 
5.5%
r 499
 
5.4%
j 451
 
4.9%
n 399
 
4.3%
d 395
 
4.3%
Other values (42) 3840
41.8%
Katakana
ValueCountFrequency (%)
ジ 7
 
7.6%
ェ 7
 
7.6%
ン 7
 
7.6%
ュ 6
 
6.5%
チ 5
 
5.4%
ク 4
 
4.3%
ピ 4
 
4.3%
ラ 4
 
4.3%
プ 4
 
4.3%
ア 3
 
3.3%
Other values (25) 41
44.6%
Hiragana
ValueCountFrequency (%)
の 16
16.7%
し 8
 
8.3%
を 8
 
8.3%
り 6
 
6.2%
る 5
 
5.2%
と 5
 
5.2%
く 5
 
5.2%
む 4
 
4.2%
あ 3
 
3.1%
け 3
 
3.1%
Other values (23) 33
34.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 55265
62.4%
ASCII 31642
35.8%
CJK 592
 
0.7%
Compat Jamo 578
 
0.7%
Misc Symbols 122
 
0.1%
None 105
 
0.1%
Hiragana 96
 
0.1%
Katakana 92
 
0.1%
Enclosed Alphanum 3
 
< 0.1%
Math Operators 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
12501
39.5%
3 2105
 
6.7%
2 2053
 
6.5%
4 1422
 
4.5%
1 965
 
3.0%
e 756
 
2.4%
0 723
 
2.3%
i 687
 
2.2%
t 598
 
1.9%
5 546
 
1.7%
Other values (78) 9286
29.3%
Hangul
ValueCountFrequency (%)
여 5010
 
9.1%
행 4848
 
8.8%
주 3436
 
6.2%
제 3253
 
5.9%
일 2557
 
4.6%
박 2273
 
4.1%
가 2245
 
4.1%
족 1511
 
2.7%
이 1083
 
2.0%
도 807
 
1.5%
Other values (826) 28242
51.1%
Compat Jamo
ValueCountFrequency (%)
ㅇ 186
32.2%
ㄹ 66
 
11.4%
ㄴ 63
 
10.9%
ㅎ 47
 
8.1%
ㅁ 32
 
5.5%
ㄱ 30
 
5.2%
ㄷ 26
 
4.5%
ㅋ 24
 
4.2%
ㅊ 14
 
2.4%
ㅈ 12
 
2.1%
Other values (20) 78
13.5%
CJK
ValueCountFrequency (%)
州 68
 
11.5%
旅 55
 
9.3%
日 30
 
5.1%
行 29
 
4.9%
島 27
 
4.6%
甲 19
 
3.2%
天 18
 
3.0%
游 17
 
2.9%
濟 14
 
2.4%
一 14
 
2.4%
Other values (130) 301
50.8%
Misc Symbols
ValueCountFrequency (%)
♥ 59
48.4%
♡ 55
45.1%
★ 5
 
4.1%
☆ 2
 
1.6%
♬ 1
 
0.8%
None
ValueCountFrequency (%)
【 44
41.9%
】 44
41.9%
４ 5
 
4.8%
、 3
 
2.9%
３ 3
 
2.9%
！ 2
 
1.9%
　 2
 
1.9%
５ 2
 
1.9%
Hiragana
ValueCountFrequency (%)
の 16
16.7%
し 8
 
8.3%
を 8
 
8.3%
り 6
 
6.2%
る 5
 
5.2%
と 5
 
5.2%
く 5
 
5.2%
む 4
 
4.2%
あ 3
 
3.1%
け 3
 
3.1%
Other values (23) 33
34.4%
Katakana
ValueCountFrequency (%)
ジ 7
 
7.6%
ェ 7
 
7.6%
ン 7
 
7.6%
ュ 6
 
6.5%
チ 5
 
5.4%
ク 4
 
4.3%
ピ 4
 
4.3%
ラ 4
 
4.3%
プ 4
 
4.3%
ア 3
 
3.3%
Other values (25) 41
44.6%
Enclosed Alphanum
ValueCountFrequency (%)
ⓐ 1
33.3%
① 1
33.3%
② 1
33.3%
Math Operators
ValueCountFrequency (%)
∇ 1
100.0%

조회수
Real number (ℝ)

SKEWED  ZEROS 

Distinct255
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean88.0715
Minimum0
Maximum67178
Zeros3150
Zeros (%)31.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-23T14:33:14.366271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q32
95-th percentile5
Maximum67178
Range67178
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1137.3494
Coefficient of variation (CV)12.913933
Kurtosis1371.8505
Mean88.0715
Median Absolute Deviation (MAD)1
Skewness29.932783
Sum880715
Variance1293563.7
MonotonicityNot monotonic
2024-03-23T14:33:14.689728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 3991
39.9%
0 3150
31.5%
2 1428
 
14.3%
3 627
 
6.3%
4 279
 
2.8%
5 132
 
1.3%
6 65
 
0.7%
8 28
 
0.3%
7 17
 
0.2%
9 11
 
0.1%
Other values (245) 272
 
2.7%
ValueCountFrequency (%)
0 3150
31.5%
1 3991
39.9%
2 1428
 
14.3%
3 627
 
6.3%
4 279
 
2.8%
5 132
 
1.3%
6 65
 
0.7%
7 17
 
0.2%
8 28
 
0.3%
9 11
 
0.1%
ValueCountFrequency (%)
67178 1
< 0.1%
28642 1
< 0.1%
23466 1
< 0.1%
22385 1
< 0.1%
21827 1
< 0.1%
21469 1
< 0.1%
21009 1
< 0.1%
19845 1
< 0.1%
19175 1
< 0.1%
18327 1
< 0.1%

공유수
Real number (ℝ)

SKEWED  ZEROS 

Distinct84
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.1021
Minimum0
Maximum905
Zeros9793
Zeros (%)97.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-23T14:33:14.997330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum905
Range905
Interquartile range (IQR)0

Descriptive statistics

Standard deviation19.036442
Coefficient of variation (CV)17.272881
Kurtosis1330.4125
Mean1.1021
Median Absolute Deviation (MAD)0
Skewness32.789195
Sum11021
Variance362.38611
MonotonicityNot monotonic
2024-03-23T14:33:15.268761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 9793
97.9%
1 25
 
0.2%
3 17
 
0.2%
2 15
 
0.1%
4 10
 
0.1%
5 7
 
0.1%
6 7
 
0.1%
8 6
 
0.1%
21 6
 
0.1%
13 5
 
0.1%
Other values (74) 109
 
1.1%
ValueCountFrequency (%)
0 9793
97.9%
1 25
 
0.2%
2 15
 
0.1%
3 17
 
0.2%
4 10
 
0.1%
5 7
 
0.1%
6 7
 
0.1%
7 5
 
0.1%
8 6
 
0.1%
9 2
 
< 0.1%
ValueCountFrequency (%)
905 1
< 0.1%
885 1
< 0.1%
772 1
< 0.1%
462 1
< 0.1%
344 1
< 0.1%
322 1
< 0.1%
312 1
< 0.1%
307 1
< 0.1%
306 1
< 0.1%
294 1
< 0.1%

여행시작일
Date

Distinct2122
Distinct (%)21.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2016-02-01 00:00:00
Maximum2062-01-13 00:00:00
2024-03-23T14:33:15.609200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:33:15.939038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

여행종료일
Date

Distinct2154
Distinct (%)21.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2016-02-04 00:00:00
Maximum2062-01-15 00:00:00
2024-03-23T14:33:16.163231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:33:16.434391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

인원
Real number (ℝ)

Distinct10
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.3013
Minimum1
Maximum10
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-23T14:33:16.655096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median3
Q34
95-th percentile8
Maximum10
Range9
Interquartile range (IQR)2

Descriptive statistics

Standard deviation2.0043253
Coefficient of variation (CV)0.60713214
Kurtosis2.4345967
Mean3.3013
Median Absolute Deviation (MAD)1
Skewness1.5232625
Sum33013
Variance4.01732
MonotonicityNot monotonic
2024-03-23T14:33:16.836757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
2 3478
34.8%
4 2113
21.1%
3 1523
15.2%
1 1127
 
11.3%
5 613
 
6.1%
6 409
 
4.1%
10 294
 
2.9%
7 199
 
2.0%
8 139
 
1.4%
9 105
 
1.1%
ValueCountFrequency (%)
1 1127
 
11.3%
2 3478
34.8%
3 1523
15.2%
4 2113
21.1%
5 613
 
6.1%
6 409
 
4.1%
7 199
 
2.0%
8 139
 
1.4%
9 105
 
1.1%
10 294
 
2.9%
ValueCountFrequency (%)
10 294
 
2.9%
9 105
 
1.1%
8 139
 
1.4%
7 199
 
2.0%
6 409
 
4.1%
5 613
 
6.1%
4 2113
21.1%
3 1523
15.2%
2 3478
34.8%
1 1127
 
11.3%

여행기간
Real number (ℝ)

SKEWED 

Distinct40
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.4248
Minimum1
Maximum372
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-23T14:33:17.492422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q13
median4
Q35
95-th percentile7
Maximum372
Range371
Interquartile range (IQR)2

Descriptive statistics

Standard deviation8.2564982
Coefficient of variation (CV)1.8659596
Kurtosis1565.0082
Mean4.4248
Median Absolute Deviation (MAD)1
Skewness36.858679
Sum44248
Variance68.169762
MonotonicityNot monotonic
2024-03-23T14:33:17.689304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=40)
ValueCountFrequency (%)
4 3354
33.5%
3 3240
32.4%
5 1364
13.6%
2 589
 
5.9%
6 486
 
4.9%
7 245
 
2.5%
1 230
 
2.3%
8 164
 
1.6%
9 66
 
0.7%
10 51
 
0.5%
Other values (30) 211
 
2.1%
ValueCountFrequency (%)
1 230
 
2.3%
2 589
 
5.9%
3 3240
32.4%
4 3354
33.5%
5 1364
13.6%
6 486
 
4.9%
7 245
 
2.5%
8 164
 
1.6%
9 66
 
0.7%
10 51
 
0.5%
ValueCountFrequency (%)
372 1
< 0.1%
369 1
< 0.1%
368 1
< 0.1%
365 1
< 0.1%
214 1
< 0.1%
157 1
< 0.1%
60 1
< 0.1%
48 1
< 0.1%
39 1
< 0.1%
36 1
< 0.1%

태그
Text

Distinct6067
Distinct (%)60.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-03-23T14:33:17.998559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length84
Median length71
Mean length18.3553
Min length5

Characters and Unicode

Total characters183553
Distinct characters960
Distinct categories12 ?
Distinct scripts6 ?
Distinct blocks8 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique5218 ?
Unique (%)52.2%

Sample

1st row아이,레저와 체험,가족,4명,첫여행
2nd row혼자,휴식과 치유 여행
3rd row부모,식도락 여행,ㄶ
4th row부모,천천히 걷기,가족여행,부모님
5th row혼자,휴식과 치유 여행
ValueCountFrequency (%)
치유 5521
21.9%
부모,휴식과 1387
 
5.5%
커플,휴식과 995
 
4.0%
휴식과 871
 
3.5%
아이,휴식과 804
 
3.2%
친구,휴식과 677
 
2.7%
여행 544
 
2.2%
혼자,휴식과 435
 
1.7%
아이,레저와 364
 
1.4%
커플,식도락 337
 
1.3%
Other values (5446) 13218
52.6%
2024-03-23T14:33:18.743977image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
, 25804
 
14.1%
15155
 
8.3%
행 9117
 
5.0%
여 9003
 
4.9%
식 8063
 
4.4%
유 6600
 
3.6%
휴 6326
 
3.4%
치 5725
 
3.1%
과 5636
 
3.1%
이 2894
 
1.6%
Other values (950) 89230
48.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 120011
65.4%
Other Punctuation 27742
 
15.1%
Lowercase Letter 17005
 
9.3%
Space Separator 15155
 
8.3%
Uppercase Letter 2625
 
1.4%
Decimal Number 952
 
0.5%
Modifier Symbol 37
 
< 0.1%
Connector Punctuation 11
 
< 0.1%
Math Symbol 6
 
< 0.1%
Dash Punctuation 4
 
< 0.1%
Other values (2) 5
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
행 9117
 
7.6%
여 9003
 
7.5%
식 8063
 
6.7%
유 6600
 
5.5%
휴 6326
 
5.3%
치 5725
 
4.8%
과 5636
 
4.7%
이 2894
 
2.4%
부 2731
 
2.3%
아 2704
 
2.3%
Other values (867) 61212
51.0%
Lowercase Letter
ValueCountFrequency (%)
e 2501
14.7%
r 1699
10.0%
i 1550
9.1%
a 1377
 
8.1%
n 1253
 
7.4%
s 1132
 
6.7%
o 1124
 
6.6%
l 912
 
5.4%
u 862
 
5.1%
t 801
 
4.7%
Other values (16) 3794
22.3%
Uppercase Letter
ValueCountFrequency (%)
L 372
14.2%
C 318
12.1%
F 316
12.0%
P 298
11.4%
E 236
9.0%
T 149
 
5.7%
V 140
 
5.3%
H 128
 
4.9%
S 125
 
4.8%
O 90
 
3.4%
Other values (15) 453
17.3%
Other Punctuation
ValueCountFrequency (%)
, 25804
93.0%
/ 1183
 
4.3%
# 642
 
2.3%
. 89
 
0.3%
! 7
 
< 0.1%
& 6
 
< 0.1%
\ 5
 
< 0.1%
＆ 2
 
< 0.1%
、 2
 
< 0.1%
@ 1
 
< 0.1%
Decimal Number
ValueCountFrequency (%)
3 288
30.3%
1 219
23.0%
2 208
21.8%
4 116
12.2%
0 40
 
4.2%
5 37
 
3.9%
7 14
 
1.5%
6 11
 
1.2%
8 10
 
1.1%
9 9
 
0.9%
Modifier Symbol
ValueCountFrequency (%)
^ 36
97.3%
` 1
 
2.7%
Math Symbol
ValueCountFrequency (%)
~ 5
83.3%
+ 1
 
16.7%
Other Symbol
ValueCountFrequency (%)
♡ 2
66.7%
♥ 1
33.3%
Open Punctuation
ValueCountFrequency (%)
[ 1
50.0%
( 1
50.0%
Space Separator
ValueCountFrequency (%)
15155
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 11
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 118877
64.8%
Common 43912
 
23.9%
Latin 19630
 
10.7%
Han 945
 
0.5%
Katakana 147
 
0.1%
Hiragana 42
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
행 9117
 
7.7%
여 9003
 
7.6%
식 8063
 
6.8%
유 6600
 
5.6%
휴 6326
 
5.3%
치 5725
 
4.8%
과 5636
 
4.7%
이 2894
 
2.4%
부 2731
 
2.3%
아 2704
 
2.3%
Other values (704) 60078
50.5%
Han
ValueCountFrequency (%)
休 84
 
8.9%
友 73
 
7.7%
朋 51
 
5.4%
美 37
 
3.9%
食 36
 
3.8%
體 25
 
2.6%
驗 25
 
2.6%
一 23
 
2.4%
子 23
 
2.4%
旅 22
 
2.3%
Other values (115) 546
57.8%
Latin
ValueCountFrequency (%)
e 2501
 
12.7%
r 1699
 
8.7%
i 1550
 
7.9%
a 1377
 
7.0%
n 1253
 
6.4%
s 1132
 
5.8%
o 1124
 
5.7%
l 912
 
4.6%
u 862
 
4.4%
t 801
 
4.1%
Other values (41) 6419
32.7%
Common
ValueCountFrequency (%)
, 25804
58.8%
15155
34.5%
/ 1183
 
2.7%
# 642
 
1.5%
3 288
 
0.7%
1 219
 
0.5%
2 208
 
0.5%
4 116
 
0.3%
. 89
 
0.2%
0 40
 
0.1%
Other values (22) 168
 
0.4%
Katakana
ValueCountFrequency (%)
グ 19
12.9%
ン 16
10.9%
リ 13
 
8.8%
ル 13
 
8.8%
ヒ 12
 
8.2%
レ 9
 
6.1%
ッ 8
 
5.4%
カ 8
 
5.4%
プ 7
 
4.8%
ャ 7
 
4.8%
Other values (17) 35
23.8%
Hiragana
ValueCountFrequency (%)
と 10
23.8%
り 7
16.7%
ひ 6
14.3%
の 4
 
9.5%
で 4
 
9.5%
に 4
 
9.5%
し 3
 
7.1%
び 1
 
2.4%
え 1
 
2.4%
め 1
 
2.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 117855
64.2%
ASCII 63535
34.6%
Compat Jamo 1022
 
0.6%
CJK 945
 
0.5%
Katakana 147
 
0.1%
Hiragana 42
 
< 0.1%
None 4
 
< 0.1%
Misc Symbols 3
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
, 25804
40.6%
15155
23.9%
e 2501
 
3.9%
r 1699
 
2.7%
i 1550
 
2.4%
a 1377
 
2.2%
n 1253
 
2.0%
/ 1183
 
1.9%
s 1132
 
1.8%
o 1124
 
1.8%
Other values (69) 10757
16.9%
Hangul
ValueCountFrequency (%)
행 9117
 
7.7%
여 9003
 
7.6%
식 8063
 
6.8%
유 6600
 
5.6%
휴 6326
 
5.4%
치 5725
 
4.9%
과 5636
 
4.8%
이 2894
 
2.5%
부 2731
 
2.3%
아 2704
 
2.3%
Other values (675) 59056
50.1%
Compat Jamo
ValueCountFrequency (%)
ㅇ 402
39.3%
ㄹ 169
16.5%
ㄴ 104
 
10.2%
ㅁ 74
 
7.2%
ㅎ 69
 
6.8%
ㄷ 31
 
3.0%
ㄱ 28
 
2.7%
ㅋ 24
 
2.3%
ㅅ 19
 
1.9%
ㅏ 14
 
1.4%
Other values (19) 88
 
8.6%
CJK
ValueCountFrequency (%)
休 84
 
8.9%
友 73
 
7.7%
朋 51
 
5.4%
美 37
 
3.9%
食 36
 
3.8%
體 25
 
2.6%
驗 25
 
2.6%
一 23
 
2.4%
子 23
 
2.4%
旅 22
 
2.3%
Other values (115) 546
57.8%
Katakana
ValueCountFrequency (%)
グ 19
12.9%
ン 16
10.9%
リ 13
 
8.8%
ル 13
 
8.8%
ヒ 12
 
8.2%
レ 9
 
6.1%
ッ 8
 
5.4%
カ 8
 
5.4%
プ 7
 
4.8%
ャ 7
 
4.8%
Other values (17) 35
23.8%
Hiragana
ValueCountFrequency (%)
と 10
23.8%
り 7
16.7%
ひ 6
14.3%
の 4
 
9.5%
で 4
 
9.5%
に 4
 
9.5%
し 3
 
7.1%
び 1
 
2.4%
え 1
 
2.4%
め 1
 
2.4%
Misc Symbols
ValueCountFrequency (%)
♡ 2
66.7%
♥ 1
33.3%
None
ValueCountFrequency (%)
＆ 2
50.0%
、 2
50.0%

등록일시
Date

Distinct2027
Distinct (%)20.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2016-06-07 00:00:00
Maximum2024-03-14 00:00:00
2024-03-23T14:33:19.035982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:33:19.324024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수정일시
Date

Distinct1948
Distinct (%)19.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2018-04-13 00:00:00
Maximum2024-03-14 00:00:00
2024-03-23T14:33:19.597894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:33:19.872457image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

추천일정등록여부
Boolean

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size87.9 KiB
False
9908 
True
 
92
ValueCountFrequency (%)
False 9908
99.1%
True 92
 
0.9%
2024-03-23T14:33:20.058132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

공개여부
Boolean

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size87.9 KiB
False
7871 
True
2129 
ValueCountFrequency (%)
False 7871
78.7%
True 2129
 
21.3%
2024-03-23T14:33:20.194677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

좋아요수
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 10000
100.0%

Length

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

Common Values (Plot)

2024-03-23T14:33:20.575645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

댓글수
Real number (ℝ)

SKEWED  ZEROS 

Distinct10
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.0136
Minimum0
Maximum28
Zeros9931
Zeros (%)99.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-23T14:33:20.710994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum28
Range28
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.32928086
Coefficient of variation (CV)24.211828
Kurtosis5295.3388
Mean0.0136
Median Absolute Deviation (MAD)0
Skewness65.448377
Sum136
Variance0.10842588
MonotonicityNot monotonic
2024-03-23T14:33:20.874482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
0 9931
99.3%
1 50
 
0.5%
2 11
 
0.1%
3 2
 
< 0.1%
28 1
 
< 0.1%
8 1
 
< 0.1%
5 1
 
< 0.1%
4 1
 
< 0.1%
7 1
 
< 0.1%
6 1
 
< 0.1%
ValueCountFrequency (%)
0 9931
99.3%
1 50
 
0.5%
2 11
 
0.1%
3 2
 
< 0.1%
4 1
 
< 0.1%
5 1
 
< 0.1%
6 1
 
< 0.1%
7 1
 
< 0.1%
8 1
 
< 0.1%
28 1
 
< 0.1%
ValueCountFrequency (%)
28 1
 
< 0.1%
8 1
 
< 0.1%
7 1
 
< 0.1%
6 1
 
< 0.1%
5 1
 
< 0.1%
4 1
 
< 0.1%
3 2
 
< 0.1%
2 11
 
0.1%
1 50
 
0.5%
0 9931
99.3%

북마크수
Real number (ℝ)

SKEWED  ZEROS 

Distinct49
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.2681
Minimum0
Maximum115
Zeros9806
Zeros (%)98.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-23T14:33:21.072564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum115
Range115
Interquartile range (IQR)0

Descriptive statistics

Standard deviation3.2729335
Coefficient of variation (CV)12.207883
Kurtosis502.39625
Mean0.2681
Median Absolute Deviation (MAD)0
Skewness20.025635
Sum2681
Variance10.712094
MonotonicityNot monotonic
2024-03-23T14:33:21.345658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=49)
ValueCountFrequency (%)
0 9806
98.1%
1 26
 
0.3%
2 24
 
0.2%
3 20
 
0.2%
5 13
 
0.1%
4 10
 
0.1%
10 10
 
0.1%
6 8
 
0.1%
12 6
 
0.1%
7 6
 
0.1%
Other values (39) 71
 
0.7%
ValueCountFrequency (%)
0 9806
98.1%
1 26
 
0.3%
2 24
 
0.2%
3 20
 
0.2%
4 10
 
0.1%
5 13
 
0.1%
6 8
 
0.1%
7 6
 
0.1%
8 3
 
< 0.1%
9 4
 
< 0.1%
ValueCountFrequency (%)
115 1
< 0.1%
101 1
< 0.1%
95 1
< 0.1%
92 1
< 0.1%
75 1
< 0.1%
72 1
< 0.1%
66 1
< 0.1%
62 1
< 0.1%
60 1
< 0.1%
55 1
< 0.1%

사용여부
Boolean

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size87.9 KiB
True
8455 
False
1545 
ValueCountFrequency (%)
True 8455
84.5%
False 1545
 
15.4%
2024-03-23T14:33:21.533952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

소셜네트워크공유수
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 10000
100.0%

Length

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

Common Values (Plot)

2024-03-23T14:33:21.820372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

인기점수
Real number (ℝ)

MISSING  SKEWED 

Distinct263
Distinct (%)3.8%
Missing3150
Missing (%)31.5%
Infinite0
Infinite (%)0.0%
Mean257.18599
Minimum2
Maximum134356
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-23T14:33:21.973068image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile2
Q12
median2
Q34
95-th percentile12
Maximum134356
Range134354
Interquartile range (IQR)2

Descriptive statistics

Standard deviation2744.7507
Coefficient of variation (CV)10.67224
Kurtosis941.16522
Mean257.18599
Median Absolute Deviation (MAD)0
Skewness24.788463
Sum1761724
Variance7533656.3
MonotonicityNot monotonic
2024-03-23T14:33:22.219649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2 3991
39.9%
4 1424
 
14.2%
6 619
 
6.2%
8 273
 
2.7%
10 129
 
1.3%
12 65
 
0.7%
16 27
 
0.3%
14 20
 
0.2%
18 10
 
0.1%
22 8
 
0.1%
Other values (253) 284
 
2.8%
(Missing) 3150
31.5%
ValueCountFrequency (%)
2 3991
39.9%
4 1424
 
14.2%
6 619
 
6.2%
7 2
 
< 0.1%
8 273
 
2.7%
9 5
 
0.1%
10 129
 
1.3%
11 3
 
< 0.1%
12 65
 
0.7%
13 4
 
< 0.1%
ValueCountFrequency (%)
134356 1
< 0.1%
57284 1
< 0.1%
46932 1
< 0.1%
44770 1
< 0.1%
43654 1
< 0.1%
42941 1
< 0.1%
42018 1
< 0.1%
39696 1
< 0.1%
38350 1
< 0.1%
36654 1
< 0.1%

여행객구분
Categorical

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
부모
2485 
커플
2361 
아이
2259 
친구
2015 
혼자
876 

Length

Max length4
Median length2
Mean length2.0008
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row아이
2nd row혼자
3rd row부모
4th row부모
5th row혼자

Common Values

ValueCountFrequency (%)
부모 2485
24.9%
커플 2361
23.6%
아이 2259
22.6%
친구 2015
20.2%
혼자 876
 
8.8%
<NA> 4
 
< 0.1%

Length

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

Common Values (Plot)

2024-03-23T14:33:22.617009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
부모 2485
24.9%
커플 2361
23.6%
아이 2259
22.6%
친구 2015
20.2%
혼자 876
 
8.8%
na 4
 
< 0.1%

Sample

여행일정아이디언어제목조회수공유수여행시작일여행종료일인원여행기간태그등록일시수정일시추천일정등록여부공개여부좋아요수댓글수북마크수사용여부소셜네트워크공유수인기점수여행객구분
1415318477국문가족여행102022-05-082022-05-0841아이,레저와 체험,가족,4명,첫여행2022-02-242022-02-24nn000y02아이
15372832국문나홀로 떠나 보는 여행002018-03-282018-03-3113혼자,휴식과 치유 여행2018-03-162018-04-13nn000y0<NA>혼자
1113216319국문ddadas102021-05-232021-05-2816부모,식도락 여행,ㄶ2021-05-232021-05-24nn000y02부모
3414040국문가족여행으로제주도1189202018-07-022018-07-0453부모,천천히 걷기,가족여행,부모님2018-06-272018-11-28ny0012y02378부모
15312948국문힐링~~ 가족여행002018-04-242018-04-2612혼자,휴식과 치유 여행2018-04-082018-04-13nn000y0<NA>혼자
1190819852국문한 템포 쉬어가는 여행002022-08-212022-08-2444부모,휴식과 치유 여행,숲,수목원2022-06-282022-06-28ny000y0<NA>부모
949916850국문힐링 치유 느림002021-08-082021-08-1225커플,천천히 걷기,느림2021-07-112021-07-11nn000y0<NA>커플
1106615813국문가족여행002021-04-152021-04-1743부모,천천히 걷기,걷기,걷기2021-04-072021-04-07nn000y0<NA>부모
38096664국문가족여행102018-11-162018-11-18103부모,휴식과 치유 여행,식도락2018-11-142018-11-14nn000y02부모
604312961국문제주 겨울 가족 여행 2박 3일002020-01-192020-01-2143아이,레저와 체험,가족,겨울2020-01-132020-01-13nn000y0<NA>아이
여행일정아이디언어제목조회수공유수여행시작일여행종료일인원여행기간태그등록일시수정일시추천일정등록여부공개여부좋아요수댓글수북마크수사용여부소셜네트워크공유수인기점수여행객구분
928216566국문ㅇㅁㅇ102021-06-162021-06-1712레저와 체험,ㄴㅁㅇ,혼자2021-06-152021-06-23nn000y02혼자
804011630중문번체濟州市內兩日遊002019-12-292019-12-3022休閑/體驗,市,州市,老城,父母2019-09-292019-09-29nn000y0<NA>부모
36448486국문가족여행002019-06-102019-06-1263부모,휴식과 치유 여행,식도락2019-03-172019-03-17nn000y0<NA>부모
958712303국문ㅈㅈ502020-01-282020-01-3093아이,레저와 체험,겨울2019-11-202020-01-27nn000y010아이
700511384국문여행계획102019-09-292019-10-0153부모,휴식과 치유 여행,아이,가족여행2019-09-162019-09-16nn000y02부모
754110983국문와이랑 3박 4일d102019-09-052019-09-0824휴식과 치유 여행,커플,제주도여행2019-08-202019-08-23nn000y02커플
1098715430국문펑002021-03-172021-03-2519부모,천천히 걷기,고구마2021-03-032021-03-03nn000y0<NA>부모
27665981영문First Time in Jeju102018-10-112018-10-1222Friends,Vacation,Jeju2018-09-262018-09-26nn000n02친구
38566325국문제주도102018-10-312018-11-0324커플,휴식과 치유 여행,ㅇㅇ,ㅇㅇ2018-10-192018-10-19nn000y02커플
1067615551국문1302021-03-192021-03-2022커플,휴식과 치유 여행,자유2021-03-162023-02-27nn000y06커플