Overview

Dataset statistics

Number of variables25
Number of observations100
Missing cells400
Missing cells (%)16.0%
Duplicate rows48
Duplicate rows (%)48.0%
Total size in memory21.2 KiB
Average record size in memory217.3 B

Variable types

Categorical11
Unsupported4
DateTime2
Numeric8

Dataset

DescriptionSample
Author(주)넥스트이지
URLhttps://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=NXESTAYNGRSVC0000000

Alerts

숙박객실갯수 has constant value ""Constant
Dataset has 48 (48.0%) duplicate rowsDuplicates
소아인원갯수 is highly imbalanced (75.9%)Imbalance
유아인원갯수 is highly imbalanced (75.8%)Imbalance
결제수단명 is highly imbalanced (61.2%)Imbalance
이용자광역시도코드 has 100 (100.0%) missing valuesMissing
숙박테마명 has 100 (100.0%) missing valuesMissing
이용자연령대코드 has 100 (100.0%) missing valuesMissing
이용자성별코드 has 100 (100.0%) missing valuesMissing
이용자광역시도코드 is an unsupported type, check if it needs cleaning or further analysisUnsupported
숙박테마명 is an unsupported type, check if it needs cleaning or further analysisUnsupported
이용자연령대코드 is an unsupported type, check if it needs cleaning or further analysisUnsupported
이용자성별코드 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-10 06:39:04.218520
Analysis finished2023-12-10 06:39:04.538741
Duration0.32 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

숙박명
Categorical

Distinct40
Distinct (%)40.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
제주비치하우스
 
4
호텔 시리우스 제주
 
4
파인힐호텔
 
4
몽듀호텔
 
4
더썸펜션
 
4
Other values (35)
80 

Length

Max length16
Median length9
Mean length7.31
Min length3

Unique

Unique2 ?
Unique (%)2.0%

Sample

1st row레슬리호텔
2nd row호텔 시리우스 제주
3rd row제주끄라비펜션
4th row서우봉비치호텔
5th row미소게스트하우스

Common Values

ValueCountFrequency (%)
제주비치하우스 4
 
4.0%
호텔 시리우스 제주 4
 
4.0%
파인힐호텔 4
 
4.0%
몽듀호텔 4
 
4.0%
더썸펜션 4
 
4.0%
더포그레이스리조트 4
 
4.0%
제주엘루이호텔 4
 
4.0%
돈내코힐스파리조트 4
 
4.0%
미소게스트하우스 4
 
4.0%
서우봉비치호텔 4
 
4.0%
Other values (30) 60
60.0%

Length

2023-12-10T15:39:04.678149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
제주 8
 
6.0%
호텔 7
 
5.2%
제주비치하우스 4
 
3.0%
시리우스 4
 
3.0%
파인힐호텔 4
 
3.0%
몽듀호텔 4
 
3.0%
더썸펜션 4
 
3.0%
더포그레이스리조트 4
 
3.0%
제주엘루이호텔 4
 
3.0%
돈내코힐스파리조트 4
 
3.0%
Other values (40) 87
64.9%

숙박지역명
Categorical

Distinct4
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
제주시내권
39 
중문/서귀포
28 
동부권
18 
서부권
15 

Length

Max length6
Median length5
Mean length4.62
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제주시내권
2nd row제주시내권
3rd row중문/서귀포
4th row동부권
5th row제주시내권

Common Values

ValueCountFrequency (%)
제주시내권 39
39.0%
중문/서귀포 28
28.0%
동부권 18
18.0%
서부권 15
 
15.0%

Length

2023-12-10T15:39:04.885632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:39:05.059359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제주시내권 39
39.0%
중문/서귀포 28
28.0%
동부권 18
18.0%
서부권 15
 
15.0%

이용자광역시도코드
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

접속장치명
Categorical

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
MOBILE
56 
PC
44 

Length

Max length6
Median length6
Mean length4.24
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowPC
2nd rowPC
3rd rowMOBILE
4th rowMOBILE
5th rowPC

Common Values

ValueCountFrequency (%)
MOBILE 56
56.0%
PC 44
44.0%

Length

2023-12-10T15:39:05.284681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:39:05.645059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
mobile 56
56.0%
pc 44
44.0%

예약일시
Date

Distinct50
Distinct (%)50.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2019-09-05 15:37:49
Maximum2019-12-24 22:06:23
2023-12-10T15:39:05.829379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:39:06.053671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

취소일시
Date

Distinct52
Distinct (%)52.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2019-11-19 18:05:12
Maximum2019-12-24 22:57:56
2023-12-10T15:39:06.258096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:39:06.467959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

객실명
Categorical

Distinct46
Distinct (%)46.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
슈페리어
 
4
디럭스트윈
 
4
패밀리-24평
 
4
슈페리어 트윈
 
4
패밀리 스위트룸
 
4
Other values (41)
80 

Length

Max length23
Median length16
Mean length8.72
Min length2

Unique

Unique3 ?
Unique (%)3.0%

Sample

1st row스탠다드더블
2nd row스탠다드트윈-조식불포함
3rd row스탠다드B[12평형]
4th row슈페리어 트윈
5th row8인 도미토리(남)

Common Values

ValueCountFrequency (%)
슈페리어 4
 
4.0%
디럭스트윈 4
 
4.0%
패밀리-24평 4
 
4.0%
슈페리어 트윈 4
 
4.0%
패밀리 스위트룸 4
 
4.0%
디럭스 트윈A 3
 
3.0%
슈페리어트윈(SuperiorTwin) 2
 
2.0%
스탠다드B[12평형] 2
 
2.0%
8인 도미토리(남) 2
 
2.0%
8인 도미토리(여) 2
 
2.0%
Other values (36) 69
69.0%

Length

2023-12-10T15:39:06.718449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
디럭스 13
 
7.2%
슈페리어 10
 
5.5%
더블 6
 
3.3%
트윈룸 6
 
3.3%
디럭스트윈 6
 
3.3%
트윈 6
 
3.3%
스위트룸 4
 
2.2%
패밀리 4
 
2.2%
4
 
2.2%
더블룸 4
 
2.2%
Other values (56) 118
65.2%

기준인원갯수
Real number (ℝ)

Distinct7
Distinct (%)7.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.58
Minimum1
Maximum12
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T15:39:06.929561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q12
median2
Q32
95-th percentile4.05
Maximum12
Range11
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1.6341062
Coefficient of variation (CV)0.63337449
Kurtosis21.054732
Mean2.58
Median Absolute Deviation (MAD)0
Skewness4.1348582
Sum258
Variance2.670303
MonotonicityNot monotonic
2023-12-10T15:39:07.252898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
2 73
73.0%
4 14
 
14.0%
1 4
 
4.0%
3 4
 
4.0%
12 2
 
2.0%
5 2
 
2.0%
6 1
 
1.0%
ValueCountFrequency (%)
1 4
 
4.0%
2 73
73.0%
3 4
 
4.0%
4 14
 
14.0%
5 2
 
2.0%
6 1
 
1.0%
12 2
 
2.0%
ValueCountFrequency (%)
12 2
 
2.0%
6 1
 
1.0%
5 2
 
2.0%
4 14
 
14.0%
3 4
 
4.0%
2 73
73.0%
1 4
 
4.0%

최대인원갯수
Real number (ℝ)

Distinct9
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.46
Minimum2
Maximum36
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T15:39:07.441626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile2
Q12
median3
Q34
95-th percentile10
Maximum36
Range34
Interquartile range (IQR)2

Descriptive statistics

Standard deviation5.2328025
Coefficient of variation (CV)1.1732741
Kurtosis25.810909
Mean4.46
Median Absolute Deviation (MAD)1
Skewness4.7448769
Sum446
Variance27.382222
MonotonicityNot monotonic
2023-12-10T15:39:07.651808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
2 35
35.0%
3 28
28.0%
4 16
16.0%
8 9
 
9.0%
5 4
 
4.0%
36 2
 
2.0%
6 2
 
2.0%
16 2
 
2.0%
10 2
 
2.0%
ValueCountFrequency (%)
2 35
35.0%
3 28
28.0%
4 16
16.0%
5 4
 
4.0%
6 2
 
2.0%
8 9
 
9.0%
10 2
 
2.0%
16 2
 
2.0%
36 2
 
2.0%
ValueCountFrequency (%)
36 2
 
2.0%
16 2
 
2.0%
10 2
 
2.0%
8 9
 
9.0%
6 2
 
2.0%
5 4
 
4.0%
4 16
16.0%
3 28
28.0%
2 35
35.0%

성인인원갯수
Real number (ℝ)

Distinct8
Distinct (%)8.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.79
Minimum1
Maximum10
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T15:39:07.874325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median2
Q32
95-th percentile9
Maximum10
Range9
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1.9811995
Coefficient of variation (CV)0.71010735
Kurtosis5.2460285
Mean2.79
Median Absolute Deviation (MAD)0
Skewness2.4132455
Sum279
Variance3.9251515
MonotonicityNot monotonic
2023-12-10T15:39:08.070346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
2 71
71.0%
1 6
 
6.0%
3 5
 
5.0%
5 4
 
4.0%
9 4
 
4.0%
6 4
 
4.0%
4 4
 
4.0%
10 2
 
2.0%
ValueCountFrequency (%)
1 6
 
6.0%
2 71
71.0%
3 5
 
5.0%
4 4
 
4.0%
5 4
 
4.0%
6 4
 
4.0%
9 4
 
4.0%
10 2
 
2.0%
ValueCountFrequency (%)
10 2
 
2.0%
9 4
 
4.0%
6 4
 
4.0%
5 4
 
4.0%
4 4
 
4.0%
3 5
 
5.0%
2 71
71.0%
1 6
 
6.0%

소아인원갯수
Categorical

IMBALANCE 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
0
94 
1
 
4
2
 
2

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 94
94.0%
1 4
 
4.0%
2 2
 
2.0%

Length

2023-12-10T15:39:08.293244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:39:08.481914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 94
94.0%
1 4
 
4.0%
2 2
 
2.0%

유아인원갯수
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
0
96 
1
 
4

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 96
96.0%
1 4
 
4.0%

Length

2023-12-10T15:39:08.674438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:39:08.844387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 96
96.0%
1 4
 
4.0%

숙박주소
Categorical

Distinct40
Distinct (%)40.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
제주특별자치도 제주시 서해안로 456-2제주비치하우스
 
4
제주특별자치도 제주시 도령로 133호텔 시리우스 제주
 
4
제주특별자치도 서귀포시 부두로 44파인힐호텔
 
4
제주특별자치도 제주시 서해안로 382몽듀호텔
 
4
제주특별자치도 서귀포시 성산읍 난고로42번길 110103동
 
4
Other values (35)
80 

Length

Max length40
Median length32
Mean length28.68
Min length22

Unique

Unique2 ?
Unique (%)2.0%

Sample

1st row제주특별자치도 제주시 광평길 3레슬리호텔
2nd row제주특별자치도 제주시 도령로 133호텔 시리우스 제주
3rd row제주특별자치도 서귀포시 토평로148번길28
4th row제주특별자치도 제주시 조천읍 함덕6길 10서우봉비치호텔
5th row제주특별자치도 제주시 관덕로 41일도1동1416-1

Common Values

ValueCountFrequency (%)
제주특별자치도 제주시 서해안로 456-2제주비치하우스 4
 
4.0%
제주특별자치도 제주시 도령로 133호텔 시리우스 제주 4
 
4.0%
제주특별자치도 서귀포시 부두로 44파인힐호텔 4
 
4.0%
제주특별자치도 제주시 서해안로 382몽듀호텔 4
 
4.0%
제주특별자치도 서귀포시 성산읍 난고로42번길 110103동 4
 
4.0%
제주특별자치도 서귀포시 성산읍 해맞이해안로 2670더포그레이스호텔앤리조트 4
 
4.0%
제주특별자치도 제주시 서광로21길 1(삼도일동) 4
 
4.0%
제주특별자치도 서귀포시 돈내코로 180돈내코힐 스파 리조트 4
 
4.0%
제주특별자치도 제주시 관덕로 41일도1동1416-1 4
 
4.0%
제주특별자치도 제주시 조천읍 함덕6길 10서우봉비치호텔 4
 
4.0%
Other values (30) 60
60.0%

Length

2023-12-10T15:39:09.093787image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
제주특별자치도 100
21.1%
제주시 50
 
10.6%
서귀포시 50
 
10.6%
서해안로 14
 
3.0%
성산읍 12
 
2.5%
안덕면 8
 
1.7%
도령로 6
 
1.3%
관덕로 6
 
1.3%
180돈내코힐 4
 
0.8%
스파 4
 
0.8%
Other values (87) 219
46.3%

이용시작일자
Real number (ℝ)

Distinct35
Distinct (%)35.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20193264
Minimum20191117
Maximum20200430
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T15:39:09.782426image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20191117
5-th percentile20191124
Q120191211
median20191218
Q320191231
95-th percentile20200214
Maximum20200430
Range9313
Interquartile range (IQR)20

Descriptive statistics

Standard deviation3790.9825
Coefficient of variation (CV)0.000187735
Kurtosis-0.30728561
Mean20193264
Median Absolute Deviation (MAD)12
Skewness1.3030809
Sum2.0193264 × 109
Variance14371548
MonotonicityNot monotonic
2023-12-10T15:39:10.027439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
20191212 8
 
8.0%
20191231 7
 
7.0%
20191230 5
 
5.0%
20191207 4
 
4.0%
20191219 4
 
4.0%
20191211 4
 
4.0%
20191213 4
 
4.0%
20191214 4
 
4.0%
20191218 4
 
4.0%
20191204 4
 
4.0%
Other values (25) 52
52.0%
ValueCountFrequency (%)
20191117 2
2.0%
20191123 2
2.0%
20191124 2
2.0%
20191125 2
2.0%
20191129 2
2.0%
20191130 2
2.0%
20191201 2
2.0%
20191202 2
2.0%
20191204 4
4.0%
20191207 4
4.0%
ValueCountFrequency (%)
20200430 2
2.0%
20200223 2
2.0%
20200214 2
2.0%
20200209 2
2.0%
20200125 2
2.0%
20200119 1
 
1.0%
20200112 2
2.0%
20200107 4
4.0%
20200106 2
2.0%
20200104 2
2.0%

이용종료일자
Real number (ℝ)

Distinct36
Distinct (%)36.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20193891
Minimum20191118
Maximum20200503
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T15:39:10.263026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20191118
5-th percentile20191125
Q120191212
median20191220
Q320200102
95-th percentile20200216
Maximum20200503
Range9385
Interquartile range (IQR)8890

Descriptive statistics

Standard deviation4123.034
Coefficient of variation (CV)0.00020417235
Kurtosis-1.2377139
Mean20193891
Median Absolute Deviation (MAD)12.5
Skewness0.88672538
Sum2.0193891 × 109
Variance16999410
MonotonicityNot monotonic
2023-12-10T15:39:10.532278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)
ValueCountFrequency (%)
20191213 10
 
10.0%
20191215 6
 
6.0%
20200102 5
 
5.0%
20191231 5
 
5.0%
20191216 4
 
4.0%
20191219 4
 
4.0%
20191125 4
 
4.0%
20191221 4
 
4.0%
20191202 4
 
4.0%
20191208 4
 
4.0%
Other values (26) 50
50.0%
ValueCountFrequency (%)
20191118 2
2.0%
20191125 4
4.0%
20191126 2
2.0%
20191201 2
2.0%
20191202 4
4.0%
20191203 2
2.0%
20191205 2
2.0%
20191206 2
2.0%
20191208 4
4.0%
20191212 2
2.0%
ValueCountFrequency (%)
20200503 2
2.0%
20200226 2
2.0%
20200216 2
2.0%
20200211 2
2.0%
20200126 2
2.0%
20200120 1
1.0%
20200113 2
2.0%
20200110 2
2.0%
20200109 2
2.0%
20200108 2
2.0%

이용일수갯수
Categorical

Distinct4
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
1
64 
2
23 
3
11 
4
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 64
64.0%
2 23
 
23.0%
3 11
 
11.0%
4 2
 
2.0%

Length

2023-12-10T15:39:10.762550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:39:10.951334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 64
64.0%
2 23
 
23.0%
3 11
 
11.0%
4 2
 
2.0%

결제수단명
Categorical

IMBALANCE 

Distinct4
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
카드
85 
무통장
11 
계좌이체
 
2
핸드폰
 
2

Length

Max length4
Median length2
Mean length2.17
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row카드
2nd row무통장
3rd row카드
4th row카드
5th row카드

Common Values

ValueCountFrequency (%)
카드 85
85.0%
무통장 11
 
11.0%
계좌이체 2
 
2.0%
핸드폰 2
 
2.0%

Length

2023-12-10T15:39:11.188994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:39:11.375846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
카드 85
85.0%
무통장 11
 
11.0%
계좌이체 2
 
2.0%
핸드폰 2
 
2.0%

총금액
Real number (ℝ)

Distinct44
Distinct (%)44.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean139809.4
Minimum12000
Maximum1410000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T15:39:11.571677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum12000
5-th percentile35000
Q150000
median72000
Q3149105
95-th percentile287096
Maximum1410000
Range1398000
Interquartile range (IQR)99105

Descriptive statistics

Standard deviation215016.47
Coefficient of variation (CV)1.5379257
Kurtosis24.236236
Mean139809.4
Median Absolute Deviation (MAD)28000
Skewness4.6448651
Sum13980940
Variance4.6232084 × 1010
MonotonicityNot monotonic
2023-12-10T15:39:11.884571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=44)
ValueCountFrequency (%)
50000 6
 
6.0%
72000 6
 
6.0%
12000 4
 
4.0%
53960 4
 
4.0%
120000 4
 
4.0%
47500 4
 
4.0%
48000 2
 
2.0%
277050 2
 
2.0%
43000 2
 
2.0%
79000 2
 
2.0%
Other values (34) 64
64.0%
ValueCountFrequency (%)
12000 4
4.0%
35000 2
2.0%
38000 2
2.0%
40000 2
2.0%
43000 2
2.0%
44000 2
2.0%
45000 2
2.0%
47000 1
 
1.0%
47500 4
4.0%
48000 2
2.0%
ValueCountFrequency (%)
1410000 2
2.0%
720000 2
2.0%
391520 1
1.0%
281600 2
2.0%
277050 2
2.0%
258000 2
2.0%
225390 2
2.0%
216920 2
2.0%
206340 2
2.0%
180000 2
2.0%

숙박위도X좌표
Real number (ℝ)

Distinct40
Distinct (%)40.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean33.402599
Minimum33.216672
Maximum33.542832
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T15:39:12.193131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum33.216672
5-th percentile33.234161
Q133.258703
median33.469103
Q333.512689
95-th percentile33.521999
Maximum33.542832
Range0.3261599
Interquartile range (IQR)0.2539863

Descriptive statistics

Standard deviation0.11960103
Coefficient of variation (CV)0.0035805904
Kurtosis-1.6331407
Mean33.402599
Median Absolute Deviation (MAD)0.0489719
Skewness-0.43934016
Sum3340.2599
Variance0.014304405
MonotonicityNot monotonic
2023-12-10T15:39:12.440729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=40)
ValueCountFrequency (%)
33.518075 4
 
4.0%
33.2414225 4
 
4.0%
33.5428317 4
 
4.0%
33.5134062 4
 
4.0%
33.3029046 4
 
4.0%
33.5001873 4
 
4.0%
33.4934468 4
 
4.0%
33.4433538 4
 
4.0%
33.4734237 4
 
4.0%
33.5126889 4
 
4.0%
Other values (30) 60
60.0%
ValueCountFrequency (%)
33.2166718 2
2.0%
33.2177393 2
2.0%
33.2341608 2
2.0%
33.2354786 2
2.0%
33.236866 2
2.0%
33.2394911 2
2.0%
33.2414225 4
4.0%
33.2423523 3
3.0%
33.2440867 2
2.0%
33.2500948 3
3.0%
ValueCountFrequency (%)
33.5428317 4
4.0%
33.5219994 2
2.0%
33.5196066 2
2.0%
33.518075 4
4.0%
33.5173505 2
2.0%
33.516304 2
2.0%
33.5134062 4
4.0%
33.5128159 2
2.0%
33.5126889 4
4.0%
33.5001873 4
4.0%

숙박경도Y좌표
Real number (ℝ)

Distinct40
Distinct (%)40.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.54086
Minimum126.25091
Maximum126.96749
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T15:39:12.708939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.25091
5-th percentile126.26281
Q1126.47065
median126.51272
Q3126.5785
95-th percentile126.92258
Maximum126.96749
Range0.7165733
Interquartile range (IQR)0.1078543

Descriptive statistics

Standard deviation0.18609715
Coefficient of variation (CV)0.0014706487
Kurtosis0.3007765
Mean126.54086
Median Absolute Deviation (MAD)0.06578735
Skewness0.78863689
Sum12654.086
Variance0.03463215
MonotonicityNot monotonic
2023-12-10T15:39:13.084419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=40)
ValueCountFrequency (%)
126.488451 4
 
4.0%
126.5643307 4
 
4.0%
126.660286 4
 
4.0%
126.523796 4
 
4.0%
126.5785034 4
 
4.0%
126.5218222 4
 
4.0%
126.4909933 4
 
4.0%
126.9065679 4
 
4.0%
126.9105635 4
 
4.0%
126.4845434 4
 
4.0%
Other values (30) 60
60.0%
ValueCountFrequency (%)
126.2509144 2
2.0%
126.252112 2
2.0%
126.2628123 2
2.0%
126.2905003 2
2.0%
126.2946818 2
2.0%
126.2993235 2
2.0%
126.3032638 2
2.0%
126.322396 2
2.0%
126.369878 1
1.0%
126.3748012 2
2.0%
ValueCountFrequency (%)
126.9674877 2
2.0%
126.9318881 2
2.0%
126.9225825 2
2.0%
126.9105635 4
4.0%
126.9065679 4
4.0%
126.660286 4
4.0%
126.6589976 2
2.0%
126.591394 2
2.0%
126.587389 2
2.0%
126.5785034 4
4.0%

숙박유형명
Categorical

Distinct4
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
호텔
54 
펜션
27 
리조트/풀빌라/콘도
13 
게스트하우스
6 

Length

Max length10
Median length2
Mean length3.28
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row호텔
2nd row호텔
3rd row펜션
4th row호텔
5th row게스트하우스

Common Values

ValueCountFrequency (%)
호텔 54
54.0%
펜션 27
27.0%
리조트/풀빌라/콘도 13
 
13.0%
게스트하우스 6
 
6.0%

Length

2023-12-10T15:39:13.368991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:39:13.578438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
호텔 54
54.0%
펜션 27
27.0%
리조트/풀빌라/콘도 13
 
13.0%
게스트하우스 6
 
6.0%

숙박객실갯수
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
1
100 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 100
100.0%

Length

2023-12-10T15:39:13.779789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:39:13.932356image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 100
100.0%

숙박테마명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

이용자연령대코드
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

이용자성별코드
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

Sample

숙박명숙박지역명이용자광역시도코드접속장치명예약일시취소일시객실명기준인원갯수최대인원갯수성인인원갯수소아인원갯수유아인원갯수숙박주소이용시작일자이용종료일자이용일수갯수결제수단명총금액숙박위도X좌표숙박경도Y좌표숙박유형명숙박객실갯수숙박테마명이용자연령대코드이용자성별코드
0레슬리호텔제주시내권<NA>PC2019-12-17 23:17:512019-12-21 09:12:02스탠다드더블22200제주특별자치도 제주시 광평길 3레슬리호텔20200112202001131카드5000033.481089126.470649호텔1<NA><NA><NA>
1호텔 시리우스 제주제주시내권<NA>PC2019-10-05 15:40:422019-11-22 10:10:45스탠다드트윈-조식불포함22200제주특별자치도 제주시 도령로 133호텔 시리우스 제주20191213201912163무통장22539033.493447126.490993호텔1<NA><NA><NA>
2제주끄라비펜션중문/서귀포<NA>MOBILE2019-12-02 17:56:052019-12-05 09:48:06스탠다드B[12평형]22200제주특별자치도 서귀포시 토평로148번길2820191230201912311카드4500033.279477126.591394펜션1<NA><NA><NA>
3서우봉비치호텔동부권<NA>MOBILE2019-12-04 03:29:472019-12-05 10:17:45슈페리어 트윈22200제주특별자치도 제주시 조천읍 함덕6길 10서우봉비치호텔20191207201912081카드4750033.542832126.660286호텔1<NA><NA><NA>
4미소게스트하우스제주시내권<NA>PC2019-12-02 12:28:192019-12-05 10:47:248인 도미토리(남)18100제주특별자치도 제주시 관덕로 41일도1동1416-120191212201912131카드1200033.513406126.523796게스트하우스1<NA><NA><NA>
5미소게스트하우스제주시내권<NA>PC2019-12-02 12:25:522019-12-05 10:47:538인 도미토리(여)18100제주특별자치도 제주시 관덕로 41일도1동1416-120191212201912131카드1200033.513406126.523796게스트하우스1<NA><NA><NA>
6돈내코힐스파리조트중문/서귀포<NA>PC2019-11-19 22:24:352019-12-05 14:03:43디럭스스파(53m2)23200제주특별자치도 서귀포시 돈내코로 180돈내코힐 스파 리조트20191130201912022카드14814033.302905126.578503리조트/풀빌라/콘도1<NA><NA><NA>
7제주엘루이호텔제주시내권<NA>MOBILE2019-11-27 11:00:072019-12-05 14:05:53디럭스트윈23200제주특별자치도 제주시 서광로21길 1(삼도일동)20191219201912212카드8600033.500187126.521822호텔1<NA><NA><NA>
8베스트웨스턴제주호텔제주시내권<NA>PC2019-11-23 16:35:272019-12-05 17:44:43스탠다드트윈22200제주특별자치도 제주시 도령로 27베스트웨스턴제주호텔20191225201912283카드21692033.487826126.481854호텔1<NA><NA><NA>
9더썸펜션동부권<NA>MOBILE2019-12-05 21:52:452019-12-05 22:12:32패밀리-24평48500제주특별자치도 서귀포시 성산읍 난고로42번길 110103동20191211201912132카드25800033.443354126.906568펜션1<NA><NA><NA>
숙박명숙박지역명이용자광역시도코드접속장치명예약일시취소일시객실명기준인원갯수최대인원갯수성인인원갯수소아인원갯수유아인원갯수숙박주소이용시작일자이용종료일자이용일수갯수결제수단명총금액숙박위도X좌표숙박경도Y좌표숙박유형명숙박객실갯수숙박테마명이용자연령대코드이용자성별코드
90해호텔제주시내권<NA>MOBILE2019-11-03 15:26:512019-11-23 08:27:17산전망 더블22200제주특별자치도 제주시 서해안로 526해호텔20191123201911252카드7200033.519607126.495218호텔1<NA><NA><NA>
91더썸펜션동부권<NA>MOBILE2019-12-17 00:46:012019-12-17 01:01:47패밀리-24평48600제주특별자치도 서귀포시 성산읍 난고로42번길 110103동20191230201912311카드16900033.443354126.906568펜션1<NA><NA><NA>
92블랙샌즈호텔 제주제주시내권<NA>PC2019-12-12 20:59:472019-12-17 11:53:22스탠다드 룸23200제주특별자치도 제주시 삼양2동 2140-1블랙샌즈호텔20191231202001033카드14283033.521999126.587389호텔1<NA><NA><NA>
93케니스토리 인 서귀포중문/서귀포<NA>MOBILE2019-12-17 09:13:082019-12-17 14:42:50[귤따기PKG] 이코노미 더블 - 조식포함22200제주특별자치도 서귀포시 동문로 42케니스토리 인 서귀포20191220201912211카드5000033.250095126.56497호텔1<NA><NA><NA>
94더포그레이스리조트동부권<NA>PC2019-12-17 17:05:132019-12-17 17:11:06슈페리어24100제주특별자치도 서귀포시 성산읍 해맞이해안로 2670더포그레이스호텔앤리조트20200107202001092카드10000033.473424126.910563리조트/풀빌라/콘도1<NA><NA><NA>
95케니스토리 인 서귀포중문/서귀포<NA>PC2019-12-21 21:39:202019-12-24 09:33:03이코노미더블 조식포함 (2인)22200제주특별자치도 서귀포시 동문로 42케니스토리 인 서귀포20191230201912311카드4700033.250095126.56497호텔1<NA><NA><NA>
96제주나인리조트제주시내권<NA>MOBILE2019-11-17 16:44:122019-12-24 15:29:44패밀리(35평형)68300제주특별자치도 제주시 해안마을북길 14-520191231202001022카드39152033.465024126.453734리조트/풀빌라/콘도1<NA><NA><NA>
97천지연 크리스탈 호텔중문/서귀포<NA>MOBILE2019-12-24 18:34:022019-12-24 22:44:37디럭스 트윈A24200제주특별자치도 서귀포시 서귀동 650-1천지연 크리스탈 호텔20200119202001201무통장6600033.242352126.562103호텔1<NA><NA><NA>
98퀸스베이펜션서부권<NA>PC2019-12-24 22:06:232019-12-24 22:57:56엘린24200제주특별자치도 제주시 애월읍 신엄안2길 54퀸스베이20191224201912273카드10200033.477116126.369878펜션1<NA><NA><NA>
99제주비치하우스제주시내권<NA>PC2019-12-12 18:06:162019-12-16 13:55:36모던오션24200제주특별자치도 제주시 서해안로 456-2제주비치하우스20191214201912151무통장4800033.518075126.488451펜션1<NA><NA><NA>

Duplicate rows

Most frequently occurring

숙박명숙박지역명접속장치명예약일시취소일시객실명기준인원갯수최대인원갯수성인인원갯수소아인원갯수유아인원갯수숙박주소이용시작일자이용종료일자이용일수갯수결제수단명총금액숙박위도X좌표숙박경도Y좌표숙박유형명숙박객실갯수# duplicates
0WE호텔중문/서귀포MOBILE2019-11-19 15:27:002019-11-21 17:15:52슈페리어트윈 (산전망)23201제주특별자치도 서귀포시 1100로 453-9520191124201911251카드12000033.286219126.444266호텔12
1고흐와 바흐 펜션서부권PC2019-11-28 13:17:362019-11-28 15:46:03고흐와 바흐436920제주특별자치도 제주시 한림읍 명재로 142-21고흐와 바흐 펜션20200430202005033계좌이체141000033.3913126.262812펜션12
2구덕게스트하우스(제주하이킹인)중문/서귀포PC2019-12-12 18:06:162019-12-13 16:54:23스텐다드 더블룸22200제주특별자치도 서귀포시 솔동산로22번길2020191215201912161무통장3500033.244087126.562422게스트하우스12
3그림리조트제주시내권PC2019-11-23 03:50:402019-12-04 17:57:40패밀리하우스-패밀리룸5101000제주특별자치도 제주시 서해안로 620-120191204201912051카드27705033.516304126.50361펜션12
4까사데비발디호텔서부권MOBILE2019-12-11 01:22:002019-12-12 09:50:41비발디 디럭스23200제주특별자치도 서귀포시 안덕면 향교로 214까사데비발디20191231202001022카드13349033.234161126.2905호텔12
5나디아펜션서부권MOBILE2019-11-25 15:29:432019-11-25 17:00:5015평형 한라산 전망22200제주특별자치도 제주시 애월읍 애원로 74나디아펜션20191125201911261핸드폰4000033.458055126.322396펜션12
6더썸펜션동부권MOBILE2019-12-05 21:52:452019-12-05 22:12:32패밀리-24평48500제주특별자치도 서귀포시 성산읍 난고로42번길 110103동20191211201912132카드25800033.443354126.906568펜션12
7더썸펜션동부권MOBILE2019-12-17 00:46:012019-12-17 01:01:47패밀리-24평48600제주특별자치도 서귀포시 성산읍 난고로42번길 110103동20191230201912311카드16900033.443354126.906568펜션12
8더포그레이스리조트동부권PC2019-12-09 16:08:522019-12-09 16:21:34슈페리어24300제주특별자치도 서귀포시 성산읍 해맞이해안로 2670더포그레이스호텔앤리조트20191212201912131카드6000033.473424126.910563리조트/풀빌라/콘도12
9더포그레이스리조트동부권PC2019-12-17 17:05:132019-12-17 17:11:06슈페리어24100제주특별자치도 서귀포시 성산읍 해맞이해안로 2670더포그레이스호텔앤리조트20200107202001092카드10000033.473424126.910563리조트/풀빌라/콘도12