Overview

Dataset statistics

Number of variables14
Number of observations200
Missing cells800
Missing cells (%)28.6%
Duplicate rows7
Duplicate rows (%)3.5%
Total size in memory23.4 KiB
Average record size in memory119.7 B

Variable types

Text2
Categorical5
Unsupported4
DateTime1
Numeric2

Dataset

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

Alerts

숙박객실갯수 has constant value ""Constant
Dataset has 7 (3.5%) duplicate rowsDuplicates
숙박위도X좌표 is highly overall correlated with 숙박지역명High correlation
숙박경도Y좌표 is highly overall correlated with 숙박지역명High correlation
숙박지역명 is highly overall correlated with 숙박위도X좌표 and 1 other fieldsHigh correlation
접속장치명 is highly imbalanced (78.1%)Imbalance
공유채널명 is highly imbalanced (92.0%)Imbalance
이용자광역시도코드 has 200 (100.0%) missing valuesMissing
숙박테마명 has 200 (100.0%) missing valuesMissing
이용자연령대코드 has 200 (100.0%) missing valuesMissing
이용자성별코드 has 200 (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:19:12.282426
Analysis finished2023-12-10 06:19:14.709650
Duration2.43 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

숙박명
Text

Distinct93
Distinct (%)46.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2023-12-10T15:19:14.989260image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length16
Mean length7.23
Min length3

Characters and Unicode

Total characters1446
Distinct characters199
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique43 ?
Unique (%)21.5%

Sample

1st row펜션정원
2nd row중문통나무펜션&리조트
3rd row몽듀호텔
4th row몽듀호텔
5th row하버호텔
ValueCountFrequency (%)
빨간풍차펜션 10
 
3.9%
제주 8
 
3.1%
레슬리호텔 7
 
2.7%
미르빌펜션&리조트 7
 
2.7%
제주로하스펜션 6
 
2.3%
펜션 6
 
2.3%
돈내코힐스파리조트 5
 
1.9%
호텔 5
 
1.9%
리조트 5
 
1.9%
산방산에펜션 5
 
1.9%
Other values (104) 194
75.2%
2023-12-10T15:19:15.738955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
리 72
 
5.0%
션 62
 
4.3%
스 61
 
4.2%
펜 61
 
4.2%
트 59
 
4.1%
58
 
4.0%
호 51
 
3.5%
텔 49
 
3.4%
조 42
 
2.9%
제 31
 
2.1%
Other values (189) 900
62.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1304
90.2%
Space Separator 58
 
4.0%
Uppercase Letter 44
 
3.0%
Decimal Number 12
 
0.8%
Other Punctuation 9
 
0.6%
Close Punctuation 7
 
0.5%
Open Punctuation 7
 
0.5%
Lowercase Letter 3
 
0.2%
Dash Punctuation 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
리 72
 
5.5%
션 62
 
4.8%
스 61
 
4.7%
펜 61
 
4.7%
트 59
 
4.5%
호 51
 
3.9%
텔 49
 
3.8%
조 42
 
3.2%
제 31
 
2.4%
주 31
 
2.4%
Other values (167) 785
60.2%
Uppercase Letter
ValueCountFrequency (%)
H 8
18.2%
L 8
18.2%
S 4
9.1%
E 4
9.1%
J 4
9.1%
I 4
9.1%
T 4
9.1%
Y 4
9.1%
B 4
9.1%
Decimal Number
ValueCountFrequency (%)
5 5
41.7%
7 3
25.0%
1 2
 
16.7%
0 1
 
8.3%
2 1
 
8.3%
Lowercase Letter
ValueCountFrequency (%)
u 1
33.3%
t 1
33.3%
s 1
33.3%
Space Separator
ValueCountFrequency (%)
58
100.0%
Other Punctuation
ValueCountFrequency (%)
& 9
100.0%
Close Punctuation
ValueCountFrequency (%)
) 7
100.0%
Open Punctuation
ValueCountFrequency (%)
( 7
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1304
90.2%
Common 95
 
6.6%
Latin 47
 
3.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
리 72
 
5.5%
션 62
 
4.8%
스 61
 
4.7%
펜 61
 
4.7%
트 59
 
4.5%
호 51
 
3.9%
텔 49
 
3.8%
조 42
 
3.2%
제 31
 
2.4%
주 31
 
2.4%
Other values (167) 785
60.2%
Latin
ValueCountFrequency (%)
H 8
17.0%
L 8
17.0%
S 4
8.5%
E 4
8.5%
J 4
8.5%
I 4
8.5%
T 4
8.5%
Y 4
8.5%
B 4
8.5%
u 1
 
2.1%
Other values (2) 2
 
4.3%
Common
ValueCountFrequency (%)
58
61.1%
& 9
 
9.5%
) 7
 
7.4%
( 7
 
7.4%
5 5
 
5.3%
7 3
 
3.2%
- 2
 
2.1%
1 2
 
2.1%
0 1
 
1.1%
2 1
 
1.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1304
90.2%
ASCII 142
 
9.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
리 72
 
5.5%
션 62
 
4.8%
스 61
 
4.7%
펜 61
 
4.7%
트 59
 
4.5%
호 51
 
3.9%
텔 49
 
3.8%
조 42
 
3.2%
제 31
 
2.4%
주 31
 
2.4%
Other values (167) 785
60.2%
ASCII
ValueCountFrequency (%)
58
40.8%
& 9
 
6.3%
H 8
 
5.6%
L 8
 
5.6%
) 7
 
4.9%
( 7
 
4.9%
5 5
 
3.5%
S 4
 
2.8%
E 4
 
2.8%
J 4
 
2.8%
Other values (12) 28
19.7%

숙박지역명
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
동부권
56 
서부권
55 
중문/서귀포
54 
제주시내권
35 

Length

Max length6
Median length3
Mean length4.16
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
동부권 56
28.0%
서부권 55
27.5%
중문/서귀포 54
27.0%
제주시내권 35
17.5%

Length

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

Common Values (Plot)

2023-12-10T15:19:16.229067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동부권 56
28.0%
서부권 55
27.5%
중문/서귀포 54
27.0%
제주시내권 35
17.5%

이용자광역시도코드
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing200
Missing (%)100.0%
Memory size1.9 KiB

접속장치명
Categorical

IMBALANCE 

Distinct2
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
MOBILE
193 
PC
 
7

Length

Max length6
Median length6
Mean length5.86
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
MOBILE 193
96.5%
PC 7
 
3.5%

Length

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

Common Values (Plot)

2023-12-10T15:19:16.678124image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
mobile 193
96.5%
pc 7
 
3.5%

등록일시
Date

Distinct193
Distinct (%)96.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
Minimum2019-11-22 14:29:29
Maximum2019-12-21 10:35:35
2023-12-10T15:19:16.866097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:19:17.225822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

공유채널명
Categorical

IMBALANCE 

Distinct3
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
KAKAO
197 
<NA>
 
2
FACEBOOK
 
1

Length

Max length8
Median length5
Mean length5.005
Min length4

Unique

Unique1 ?
Unique (%)0.5%

Sample

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

Common Values

ValueCountFrequency (%)
KAKAO 197
98.5%
<NA> 2
 
1.0%
FACEBOOK 1
 
0.5%

Length

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

Common Values (Plot)

2023-12-10T15:19:17.653742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
kakao 197
98.5%
na 2
 
1.0%
facebook 1
 
0.5%

숙박주소
Text

Distinct93
Distinct (%)46.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2023-12-10T15:19:18.036421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length41
Median length34
Mean length30.29
Min length21

Characters and Unicode

Total characters6058
Distinct characters232
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique43 ?
Unique (%)21.5%

Sample

1st row제주특별자치도 서귀포시 남원읍 일주동로 6523 펜션정원
2nd row제주특별자치도 서귀포시 중산간서로594번길 7-8
3rd row제주특별자치도 제주시 서해안로 382 몽듀호텔
4th row제주특별자치도 제주시 서해안로 382 몽듀호텔
5th row제주특별자치도 제주시 임항로 260 하버호텔
ValueCountFrequency (%)
제주특별자치도 200
 
17.8%
서귀포시 111
 
9.9%
제주시 89
 
7.9%
안덕면 25
 
2.2%
성산읍 22
 
2.0%
구좌읍 16
 
1.4%
한림읍 13
 
1.2%
애월읍 12
 
1.1%
3 11
 
1.0%
서해안로 11
 
1.0%
Other values (259) 616
54.7%
2023-12-10T15:19:18.739341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
957
 
15.8%
주 319
 
5.3%
제 305
 
5.0%
도 206
 
3.4%
시 202
 
3.3%
자 201
 
3.3%
치 201
 
3.3%
특 200
 
3.3%
별 200
 
3.3%
1 175
 
2.9%
Other values (222) 3092
51.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4214
69.6%
Space Separator 957
 
15.8%
Decimal Number 795
 
13.1%
Dash Punctuation 65
 
1.1%
Uppercase Letter 8
 
0.1%
Other Punctuation 7
 
0.1%
Close Punctuation 6
 
0.1%
Open Punctuation 6
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 319
 
7.6%
제 305
 
7.2%
도 206
 
4.9%
시 202
 
4.8%
자 201
 
4.8%
치 201
 
4.8%
특 200
 
4.7%
별 200
 
4.7%
로 141
 
3.3%
서 139
 
3.3%
Other values (205) 2100
49.8%
Decimal Number
ValueCountFrequency (%)
1 175
22.0%
2 106
13.3%
4 97
12.2%
0 83
10.4%
3 68
 
8.6%
6 68
 
8.6%
8 59
 
7.4%
5 59
 
7.4%
7 48
 
6.0%
9 32
 
4.0%
Uppercase Letter
ValueCountFrequency (%)
J 4
50.0%
S 4
50.0%
Space Separator
ValueCountFrequency (%)
957
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 65
100.0%
Other Punctuation
ValueCountFrequency (%)
& 7
100.0%
Close Punctuation
ValueCountFrequency (%)
) 6
100.0%
Open Punctuation
ValueCountFrequency (%)
( 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4214
69.6%
Common 1836
30.3%
Latin 8
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 319
 
7.6%
제 305
 
7.2%
도 206
 
4.9%
시 202
 
4.8%
자 201
 
4.8%
치 201
 
4.8%
특 200
 
4.7%
별 200
 
4.7%
로 141
 
3.3%
서 139
 
3.3%
Other values (205) 2100
49.8%
Common
ValueCountFrequency (%)
957
52.1%
1 175
 
9.5%
2 106
 
5.8%
4 97
 
5.3%
0 83
 
4.5%
3 68
 
3.7%
6 68
 
3.7%
- 65
 
3.5%
8 59
 
3.2%
5 59
 
3.2%
Other values (5) 99
 
5.4%
Latin
ValueCountFrequency (%)
J 4
50.0%
S 4
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4214
69.6%
ASCII 1844
30.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
957
51.9%
1 175
 
9.5%
2 106
 
5.7%
4 97
 
5.3%
0 83
 
4.5%
3 68
 
3.7%
6 68
 
3.7%
- 65
 
3.5%
8 59
 
3.2%
5 59
 
3.2%
Other values (7) 107
 
5.8%
Hangul
ValueCountFrequency (%)
주 319
 
7.6%
제 305
 
7.2%
도 206
 
4.9%
시 202
 
4.8%
자 201
 
4.8%
치 201
 
4.8%
특 200
 
4.7%
별 200
 
4.7%
로 141
 
3.3%
서 139
 
3.3%
Other values (205) 2100
49.8%

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

HIGH CORRELATION 

Distinct93
Distinct (%)46.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean33.380036
Minimum33.216672
Maximum33.559356
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:19:18.963085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum33.216672
5-th percentile33.237408
Q133.249181
median33.391877
Q333.490679
95-th percentile33.548414
Maximum33.559356
Range0.3426847
Interquartile range (IQR)0.24149762

Descriptive statistics

Standard deviation0.11828474
Coefficient of variation (CV)0.0035435773
Kurtosis-1.6625917
Mean33.380036
Median Absolute Deviation (MAD)0.12341045
Skewness0.02204311
Sum6676.0071
Variance0.013991279
MonotonicityNot monotonic
2023-12-10T15:19:19.219704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
33.5484145 10
 
5.0%
33.2460023 7
 
3.5%
33.4810891 7
 
3.5%
33.2374078 6
 
3.0%
33.3904162 5
 
2.5%
33.3029047 5
 
2.5%
33.2463436 5
 
2.5%
33.268467 5
 
2.5%
33.3741441 4
 
2.0%
33.4442281 4
 
2.0%
Other values (83) 142
71.0%
ValueCountFrequency (%)
33.2166718 1
 
0.5%
33.2177394 1
 
0.5%
33.2198658 1
 
0.5%
33.2341608 1
 
0.5%
33.2354786 2
 
1.0%
33.236866 3
1.5%
33.2374078 6
3.0%
33.2394912 1
 
0.5%
33.2396579 2
 
1.0%
33.2414225 3
1.5%
ValueCountFrequency (%)
33.5593565 2
 
1.0%
33.5484145 10
5.0%
33.5455129 4
 
2.0%
33.5452453 1
 
0.5%
33.5439914 1
 
0.5%
33.5431516 1
 
0.5%
33.5423952 1
 
0.5%
33.5254004 2
 
1.0%
33.5219994 2
 
1.0%
33.5196066 1
 
0.5%

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

HIGH CORRELATION 

Distinct93
Distinct (%)46.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.53653
Minimum126.22887
Maximum126.93447
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:19:19.479736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.22887
5-th percentile126.26228
Q1126.38375
median126.51029
Q3126.68833
95-th percentile126.90657
Maximum126.93447
Range0.7055989
Interquartile range (IQR)0.30458383

Descriptive statistics

Standard deviation0.20000272
Coefficient of variation (CV)0.0015805928
Kurtosis-0.828281
Mean126.53653
Median Absolute Deviation (MAD)0.1449016
Skewness0.41298368
Sum25307.305
Variance0.040001089
MonotonicityNot monotonic
2023-12-10T15:19:19.736221image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.74238 10
 
5.0%
126.3060521 7
 
3.5%
126.4706491 7
 
3.5%
126.299013 6
 
3.0%
126.2288741 5
 
2.5%
126.5785035 5
 
2.5%
126.296883 5
 
2.5%
126.386078 5
 
2.5%
126.872379 4
 
2.0%
126.403553 4
 
2.0%
Other values (83) 142
71.0%
ValueCountFrequency (%)
126.2288741 5
2.5%
126.2421759 1
 
0.5%
126.2470947 1
 
0.5%
126.247179 1
 
0.5%
126.2509144 1
 
0.5%
126.252112 1
 
0.5%
126.2628123 1
 
0.5%
126.2697824 3
1.5%
126.2905004 1
 
0.5%
126.2915445 2
 
1.0%
ValueCountFrequency (%)
126.934473 1
 
0.5%
126.9225826 3
1.5%
126.911468 1
 
0.5%
126.9105636 4
2.0%
126.9065679 2
1.0%
126.9048957 2
1.0%
126.8940423 2
1.0%
126.885497 2
1.0%
126.872379 4
2.0%
126.8721404 1
 
0.5%

숙박유형명
Categorical

Distinct4
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
펜션
103 
호텔
52 
리조트/풀빌라/콘도
36 
게스트하우스
 
9

Length

Max length10
Median length2
Mean length3.62
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row펜션
2nd row펜션
3rd row호텔
4th row호텔
5th row호텔

Common Values

ValueCountFrequency (%)
펜션 103
51.5%
호텔 52
26.0%
리조트/풀빌라/콘도 36
 
18.0%
게스트하우스 9
 
4.5%

Length

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

Common Values (Plot)

2023-12-10T15:19:20.209473image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
펜션 103
51.5%
호텔 52
26.0%
리조트/풀빌라/콘도 36
 
18.0%
게스트하우스 9
 
4.5%

숙박객실갯수
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
1
200 

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 200
100.0%

Length

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

Common Values (Plot)

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

숙박테마명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing200
Missing (%)100.0%
Memory size1.9 KiB

이용자연령대코드
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing200
Missing (%)100.0%
Memory size1.9 KiB

이용자성별코드
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing200
Missing (%)100.0%
Memory size1.9 KiB

Interactions

2023-12-10T15:19:13.591652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:19:13.225914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:19:13.805038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:19:13.410832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:19:20.694901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
숙박명숙박지역명접속장치명공유채널명숙박주소숙박위도X좌표숙박경도Y좌표숙박유형명
숙박명1.0001.0000.9610.3321.0001.0001.0001.000
숙박지역명1.0001.0000.0000.0001.0000.8650.8930.682
접속장치명0.9610.0001.0000.3150.9610.0000.2900.051
공유채널명0.3320.0000.3151.0000.3320.0000.2430.000
숙박주소1.0001.0000.9610.3321.0001.0001.0001.000
숙박위도X좌표1.0000.8650.0000.0001.0001.0000.8770.541
숙박경도Y좌표1.0000.8930.2900.2431.0000.8771.0000.592
숙박유형명1.0000.6820.0510.0001.0000.5410.5921.000
2023-12-10T15:19:20.900100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공유채널명접속장치명숙박유형명숙박지역명
공유채널명1.0000.2040.0000.000
접속장치명0.2041.0000.0320.000
숙박유형명0.0000.0321.0000.328
숙박지역명0.0000.0000.3281.000
2023-12-10T15:19:21.114167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
숙박위도X좌표숙박경도Y좌표숙박지역명접속장치명공유채널명숙박유형명
숙박위도X좌표1.0000.4120.7100.0000.0000.348
숙박경도Y좌표0.4121.0000.7560.2180.1820.391
숙박지역명0.7100.7561.0000.0000.0000.328
접속장치명0.0000.2180.0001.0000.2040.032
공유채널명0.0000.1820.0000.2041.0000.000
숙박유형명0.3480.3910.3280.0320.0001.000

Missing values

2023-12-10T15:19:14.156127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T15:19:14.495886image/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

숙박명숙박지역명이용자광역시도코드접속장치명등록일시공유채널명숙박주소숙박위도X좌표숙박경도Y좌표숙박유형명숙박객실갯수숙박테마명이용자연령대코드이용자성별코드
0펜션정원동부권<NA>MOBILE2019-12-10 06:21:14KAKAO제주특별자치도 서귀포시 남원읍 일주동로 6523 펜션정원33.30642126.775168펜션1<NA><NA><NA>
1중문통나무펜션&리조트중문/서귀포<NA>MOBILE2019-12-10 13:01:53KAKAO제주특별자치도 서귀포시 중산간서로594번길 7-833.263333126.451047펜션1<NA><NA><NA>
2몽듀호텔제주시내권<NA>MOBILE2019-12-10 16:35:14KAKAO제주특별자치도 제주시 서해안로 382 몽듀호텔33.512689126.484543호텔1<NA><NA><NA>
3몽듀호텔제주시내권<NA>MOBILE2019-12-10 16:35:15KAKAO제주특별자치도 제주시 서해안로 382 몽듀호텔33.512689126.484543호텔1<NA><NA><NA>
4하버호텔제주시내권<NA>MOBILE2019-12-10 16:45:04KAKAO제주특별자치도 제주시 임항로 260 하버호텔33.517694126.538263호텔1<NA><NA><NA>
5레슬리호텔제주시내권<NA>MOBILE2019-12-10 16:45:32KAKAO제주특별자치도 제주시 광평길 3 레슬리호텔33.481089126.470649호텔1<NA><NA><NA>
6레슬리호텔제주시내권<NA>MOBILE2019-12-10 16:45:32KAKAO제주특별자치도 제주시 광평길 3 레슬리호텔33.481089126.470649호텔1<NA><NA><NA>
7제주노블레스관광호텔제주시내권<NA>MOBILE2019-12-10 16:46:17KAKAO제주특별자치도 제주시 월성로4길 19 제주노블레스관광호텔33.501172126.503453호텔1<NA><NA><NA>
8제주노블레스관광호텔제주시내권<NA>MOBILE2019-12-10 16:46:18KAKAO제주특별자치도 제주시 월성로4길 19 제주노블레스관광호텔33.501172126.503453호텔1<NA><NA><NA>
9그림리조트제주시내권<NA>MOBILE2019-12-10 16:47:21KAKAO제주특별자치도 제주시 서해안로 620-133.516304126.50361펜션1<NA><NA><NA>
숙박명숙박지역명이용자광역시도코드접속장치명등록일시공유채널명숙박주소숙박위도X좌표숙박경도Y좌표숙박유형명숙박객실갯수숙박테마명이용자연령대코드이용자성별코드
190더퍼스트70 호텔중문/서귀포<NA>MOBILE2019-11-24 22:52:48KAKAO제주특별자치도 서귀포시 명동로 46 서귀동18233.247252126.566847호텔1<NA><NA><NA>
191썬라이즈호텔중문/서귀포<NA>MOBILE2019-11-24 22:54:10KAKAO제주특별자치도 서귀포시 중문관광로 310 썬라이즈호텔 중문점33.247568126.430487호텔1<NA><NA><NA>
192에코그린리조트서부권<NA>MOBILE2019-11-24 22:55:14KAKAO제주특별자치도 제주시 한림읍 귀덕6길 94 에코그린리조트33.435929126.291545리조트/풀빌라/콘도1<NA><NA><NA>
193코업시티호텔 하버뷰중문/서귀포<NA>MOBILE2019-11-24 22:58:05KAKAO제주특별자치도 서귀포시 남원읍 태위로 108 코업시티호텔 하버뷰33.274487126.658998호텔1<NA><NA><NA>
194중문스테이중문/서귀포<NA>MOBILE2019-11-24 23:50:41KAKAO제주특별자치도 서귀포시 중문관광로 288 중문스테이33.245912126.429485호텔1<NA><NA><NA>
195밸류호텔 서귀포JS중문/서귀포<NA>MOBILE2019-12-06 02:21:57KAKAO제주특별자치도 서귀포시 김정문화로 51 밸류호텔 서귀포JS33.251417126.510287호텔1<NA><NA><NA>
196제주신라호텔중문/서귀포<NA>MOBILE2019-12-06 08:39:58KAKAO제주특별자치도 서귀포시 중문관광로72번길 75 제주신라호텔33.246789126.407195호텔1<NA><NA><NA>
197산방산애 펜션서부권<NA>PC2019-12-06 14:51:15KAKAO제주특별자치도 서귀포시 안덕면 사계로114번길 53-15 산방산애 펜션33.243364126.303898펜션1<NA><NA><NA>
198제주담스파빌서부권<NA>MOBILE2019-12-06 17:06:57KAKAO제주특별자치도 제주시 한림읍 한림로 162 제주담스파빌33.398932126.242176리조트/풀빌라/콘도1<NA><NA><NA>
199돈내코힐스파리조트중문/서귀포<NA>MOBILE2019-12-06 17:09:55KAKAO제주특별자치도 서귀포시 돈내코로 180 돈내코힐 스파 리조트33.302905126.578503리조트/풀빌라/콘도1<NA><NA><NA>

Duplicate rows

Most frequently occurring

숙박명숙박지역명접속장치명등록일시공유채널명숙박주소숙박위도X좌표숙박경도Y좌표숙박유형명숙박객실갯수# duplicates
0게스트하우스7제주시내권MOBILE2019-12-10 16:50:07KAKAO제주특별자치도 제주시 용문로 168 2층33.508927126.511149게스트하우스12
1더포그레이스리조트동부권MOBILE2019-12-15 21:51:14KAKAO제주특별자치도 서귀포시 성산읍 해맞이해안로 2670 더포그레이스호텔앤리조트33.473424126.910564리조트/풀빌라/콘도12
2레슬리호텔제주시내권MOBILE2019-12-10 16:45:32KAKAO제주특별자치도 제주시 광평길 3 레슬리호텔33.481089126.470649호텔12
3레슬리호텔제주시내권MOBILE2019-12-15 20:46:47KAKAO제주특별자치도 제주시 광평길 3 레슬리호텔33.481089126.470649호텔12
4블랙샌즈호텔 제주제주시내권MOBILE2019-12-10 16:48:38KAKAO제주특별자치도 제주시 삼양2동 2140-1 블랙샌즈호텔33.521999126.587389호텔12
5빨간풍차펜션동부권MOBILE2019-12-08 10:18:23KAKAO제주특별자치도 제주시 구좌읍 김녕리 3100 관리실33.548414126.74238펜션12
6코지하우스서부권MOBILE2019-12-08 23:00:14KAKAO제주특별자치도 제주시 한림읍 금능9길 28 코지하우스33.390416126.228874펜션12