Overview

Dataset statistics

Number of variables13
Number of observations200
Missing cells600
Missing cells (%)23.1%
Duplicate rows44
Duplicate rows (%)22.0%
Total size in memory21.6 KiB
Average record size in memory110.7 B

Variable types

Text2
Categorical4
DateTime1
Numeric3
Unsupported3

Dataset

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

Alerts

Dataset has 44 (22.0%) duplicate rowsDuplicates
접속장치명 is highly overall correlated with 관광지지역명High correlation
관광지지역명 is highly overall correlated with 접속장치명High correlation
관광지위도X좌표 is highly overall correlated with 관광지경도Y좌표 and 1 other fieldsHigh correlation
관광지경도Y좌표 is highly overall correlated with 관광지위도X좌표 and 1 other fieldsHigh correlation
관광지금액 is highly overall correlated with 관광지유형명High correlation
관광지유형명 is highly overall correlated with 관광지위도X좌표 and 2 other fieldsHigh correlation
접속장치명 is highly imbalanced (91.9%)Imbalance
공유채널명 is highly imbalanced (86.3%)Imbalance
이용자연령대코드 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
관광지위도X좌표 has 43 (21.5%) zerosZeros
관광지경도Y좌표 has 43 (21.5%) zerosZeros
관광지금액 has 6 (3.0%) zerosZeros

Reproduction

Analysis started2023-12-10 06:44:32.350178
Analysis finished2023-12-10 06:44:34.659901
Duration2.31 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관광지명
Text

Distinct76
Distinct (%)38.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2023-12-10T15:44:34.906139image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length22
Mean length14.455
Min length4

Characters and Unicode

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

Unique

Unique33 ?
Unique (%)16.5%

Sample

1st row최남단 감귤따기체험/ 농장속 모노레일 기차여행
2nd row제주시티투어(1회·1일 이용권)
3rd row제주도렌트카 80% 할인 - 스팅어 2018년형
4th row제주시티투어(1회·1일 이용권)
5th row윈드1947 카트 테마파크
ValueCountFrequency (%)
이용권 23
 
4.3%
제주시티투어(1회·1일 21
 
4.0%
저지리마을 16
 
3.0%
예술투어 16
 
3.0%
입장권 16
 
3.0%
15
 
2.8%
12/14 10
 
1.9%
테마파크 10
 
1.9%
12/15 9
 
1.7%
교래리 9
 
1.7%
Other values (163) 384
72.6%
2023-12-10T15:44:35.485593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
332
 
11.5%
1 118
 
4.1%
주 74
 
2.6%
제 64
 
2.2%
어 62
 
2.1%
험 49
 
1.7%
체 49
 
1.7%
마 47
 
1.6%
권 45
 
1.6%
( 43
 
1.5%
Other values (285) 2008
69.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2070
71.6%
Space Separator 332
 
11.5%
Decimal Number 202
 
7.0%
Other Punctuation 66
 
2.3%
Open Punctuation 56
 
1.9%
Close Punctuation 56
 
1.9%
Uppercase Letter 40
 
1.4%
Math Symbol 19
 
0.7%
Lowercase Letter 18
 
0.6%
Dash Punctuation 16
 
0.6%
Other values (2) 16
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 74
 
3.6%
제 64
 
3.1%
어 62
 
3.0%
험 49
 
2.4%
체 49
 
2.4%
마 47
 
2.3%
권 45
 
2.2%
장 41
 
2.0%
시 40
 
1.9%
투 38
 
1.8%
Other values (241) 1561
75.4%
Uppercase Letter
ValueCountFrequency (%)
A 7
17.5%
F 5
12.5%
I 4
10.0%
L 4
10.0%
O 3
7.5%
C 2
 
5.0%
S 2
 
5.0%
X 2
 
5.0%
T 2
 
5.0%
E 2
 
5.0%
Other values (7) 7
17.5%
Decimal Number
ValueCountFrequency (%)
1 118
58.4%
2 29
 
14.4%
4 18
 
8.9%
9 9
 
4.5%
5 9
 
4.5%
7 7
 
3.5%
0 4
 
2.0%
8 3
 
1.5%
6 3
 
1.5%
3 2
 
1.0%
Other Punctuation
ValueCountFrequency (%)
/ 33
50.0%
· 23
34.8%
& 9
 
13.6%
% 1
 
1.5%
Lowercase Letter
ValueCountFrequency (%)
k 9
50.0%
g 6
33.3%
m 3
 
16.7%
Open Punctuation
ValueCountFrequency (%)
( 43
76.8%
[ 13
 
23.2%
Close Punctuation
ValueCountFrequency (%)
) 43
76.8%
] 13
 
23.2%
Math Symbol
ValueCountFrequency (%)
+ 16
84.2%
~ 3
 
15.8%
Space Separator
ValueCountFrequency (%)
332
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 16
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 15
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2071
71.6%
Common 762
 
26.4%
Latin 58
 
2.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 74
 
3.6%
제 64
 
3.1%
어 62
 
3.0%
험 49
 
2.4%
체 49
 
2.4%
마 47
 
2.3%
권 45
 
2.2%
장 41
 
2.0%
시 40
 
1.9%
투 38
 
1.8%
Other values (242) 1562
75.4%
Common
ValueCountFrequency (%)
332
43.6%
1 118
 
15.5%
( 43
 
5.6%
) 43
 
5.6%
/ 33
 
4.3%
2 29
 
3.8%
· 23
 
3.0%
4 18
 
2.4%
+ 16
 
2.1%
- 16
 
2.1%
Other values (13) 91
 
11.9%
Latin
ValueCountFrequency (%)
k 9
15.5%
A 7
12.1%
g 6
10.3%
F 5
 
8.6%
I 4
 
6.9%
L 4
 
6.9%
m 3
 
5.2%
O 3
 
5.2%
C 2
 
3.4%
S 2
 
3.4%
Other values (10) 13
22.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2070
71.6%
ASCII 797
 
27.6%
None 24
 
0.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
332
41.7%
1 118
 
14.8%
( 43
 
5.4%
) 43
 
5.4%
/ 33
 
4.1%
2 29
 
3.6%
4 18
 
2.3%
+ 16
 
2.0%
- 16
 
2.0%
_ 15
 
1.9%
Other values (32) 134
16.8%
Hangul
ValueCountFrequency (%)
주 74
 
3.6%
제 64
 
3.1%
어 62
 
3.0%
험 49
 
2.4%
체 49
 
2.4%
마 47
 
2.3%
권 45
 
2.2%
장 41
 
2.0%
시 40
 
1.9%
투 38
 
1.8%
Other values (241) 1561
75.4%
None
ValueCountFrequency (%)
· 23
95.8%
㈜ 1
 
4.2%

관광지지역명
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
<NA>
91 
중문/서귀포
49 
제주시내권
27 
서부권
17 
동부권
16 

Length

Max length6
Median length5
Mean length4.46
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row중문/서귀포

Common Values

ValueCountFrequency (%)
<NA> 91
45.5%
중문/서귀포 49
24.5%
제주시내권 27
 
13.5%
서부권 17
 
8.5%
동부권 16
 
8.0%

Length

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

Common Values (Plot)

2023-12-10T15:44:35.875247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 91
45.5%
중문/서귀포 49
24.5%
제주시내권 27
 
13.5%
서부권 17
 
8.5%
동부권 16
 
8.0%

접속장치명
Categorical

HIGH CORRELATION  IMBALANCE 

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

Length

Max length6
Median length6
Mean length5.96
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
MOBILE 198
99.0%
PC 2
 
1.0%

Length

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

Common Values (Plot)

2023-12-10T15:44:36.279346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
mobile 198
99.0%
pc 2
 
1.0%

등록일시
Date

Distinct155
Distinct (%)77.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
Minimum2019-11-25 01:04:59
Maximum2019-12-22 23:24:54
2023-12-10T15:44:36.462343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:44:36.661421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

공유채널명
Categorical

IMBALANCE 

Distinct4
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
KAKAO
193 
FACEBOOK
 
3
BAND
 
2
LINE
 
2

Length

Max length8
Median length5
Mean length5.025
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
KAKAO 193
96.5%
FACEBOOK 3
 
1.5%
BAND 2
 
1.0%
LINE 2
 
1.0%

Length

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

Common Values (Plot)

2023-12-10T15:44:37.106795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
kakao 193
96.5%
facebook 3
 
1.5%
band 2
 
1.0%
line 2
 
1.0%

관광지주소
Text

Distinct63
Distinct (%)31.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2023-12-10T15:44:37.431783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length31
Mean length22.885
Min length1

Characters and Unicode

Total characters4577
Distinct characters164
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique27 ?
Unique (%)13.5%

Sample

1st row제주특별자치도 서귀포시 남원읍 남위남성로 168 최남단감귤체험농장
2nd row제주특별자치도 제주시 선덕로 23
3rd row제주특별자치도 제주시 서광로 66 2층 202호 제주허브닷컴
4th row제주특별자치도 제주시 선덕로 23
5th row제주특별자치도 서귀포시 토평공단로 78-27
ValueCountFrequency (%)
제주특별자치도 172
19.5%
제주시 106
 
12.0%
서귀포시 66
 
7.5%
한경면 27
 
3.1%
용금로 24
 
2.7%
864 24
 
2.7%
선덕로 21
 
2.4%
23 21
 
2.4%
방림원 16
 
1.8%
일원 16
 
1.8%
Other values (140) 387
44.0%
2023-12-10T15:44:37.949797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
834
18.2%
제 297
 
6.5%
주 293
 
6.4%
도 173
 
3.8%
시 173
 
3.8%
특 172
 
3.8%
별 172
 
3.8%
자 172
 
3.8%
치 172
 
3.8%
로 147
 
3.2%
Other values (154) 1972
43.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3024
66.1%
Space Separator 834
 
18.2%
Decimal Number 678
 
14.8%
Dash Punctuation 41
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
제 297
 
9.8%
주 293
 
9.7%
도 173
 
5.7%
시 173
 
5.7%
특 172
 
5.7%
별 172
 
5.7%
자 172
 
5.7%
치 172
 
5.7%
로 147
 
4.9%
서 79
 
2.6%
Other values (142) 1174
38.8%
Decimal Number
ValueCountFrequency (%)
1 140
20.6%
2 98
14.5%
6 79
11.7%
3 71
10.5%
8 63
9.3%
4 61
9.0%
7 57
8.4%
0 56
 
8.3%
5 29
 
4.3%
9 24
 
3.5%
Space Separator
ValueCountFrequency (%)
834
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 41
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3024
66.1%
Common 1553
33.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
제 297
 
9.8%
주 293
 
9.7%
도 173
 
5.7%
시 173
 
5.7%
특 172
 
5.7%
별 172
 
5.7%
자 172
 
5.7%
치 172
 
5.7%
로 147
 
4.9%
서 79
 
2.6%
Other values (142) 1174
38.8%
Common
ValueCountFrequency (%)
834
53.7%
1 140
 
9.0%
2 98
 
6.3%
6 79
 
5.1%
3 71
 
4.6%
8 63
 
4.1%
4 61
 
3.9%
7 57
 
3.7%
0 56
 
3.6%
- 41
 
2.6%
Other values (2) 53
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3024
66.1%
ASCII 1553
33.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
834
53.7%
1 140
 
9.0%
2 98
 
6.3%
6 79
 
5.1%
3 71
 
4.6%
8 63
 
4.1%
4 61
 
3.9%
7 57
 
3.7%
0 56
 
3.6%
- 41
 
2.6%
Other values (2) 53
 
3.4%
Hangul
ValueCountFrequency (%)
제 297
 
9.8%
주 293
 
9.7%
도 173
 
5.7%
시 173
 
5.7%
특 172
 
5.7%
별 172
 
5.7%
자 172
 
5.7%
치 172
 
5.7%
로 147
 
4.9%
서 79
 
2.6%
Other values (142) 1174
38.8%

관광지위도X좌표
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct59
Distinct (%)29.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean26.212091
Minimum0
Maximum34.780228
Zeros43
Zeros (%)21.5%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:44:38.158347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q133.248874
median33.3083
Q333.466628
95-th percentile33.496231
Maximum34.780228
Range34.780228
Interquartile range (IQR)0.21775363

Descriptive statistics

Standard deviation13.75289
Coefficient of variation (CV)0.52467733
Kurtosis-0.046623988
Mean26.212091
Median Absolute Deviation (MAD)0.14419265
Skewness-1.3976333
Sum5242.4183
Variance189.14199
MonotonicityNot monotonic
2023-12-10T15:44:38.353192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 43
21.5%
33.4862179 21
 
10.5%
33.3371661 8
 
4.0%
33.2895195 7
 
3.5%
33.2716179 6
 
3.0%
33.2899514 5
 
2.5%
33.2603977 5
 
2.5%
33.304974 5
 
2.5%
33.4490508 5
 
2.5%
33.2502419 5
 
2.5%
Other values (49) 90
45.0%
ValueCountFrequency (%)
0.0 43
21.5%
33.2365989 2
 
1.0%
33.2392231 1
 
0.5%
33.2402491 2
 
1.0%
33.2473366 1
 
0.5%
33.2487954 1
 
0.5%
33.2489004 1
 
0.5%
33.2502419 5
 
2.5%
33.2552154 1
 
0.5%
33.2562765 2
 
1.0%
ValueCountFrequency (%)
34.7802284 1
 
0.5%
33.5365289 1
 
0.5%
33.5177779 1
 
0.5%
33.5146545 2
 
1.0%
33.5099181 1
 
0.5%
33.5052414 2
 
1.0%
33.5008438 1
 
0.5%
33.4993408 1
 
0.5%
33.4960674 5
2.5%
33.494198 2
 
1.0%

관광지경도Y좌표
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct59
Distinct (%)29.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean99.305235
Minimum0
Maximum126.91401
Zeros43
Zeros (%)21.5%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:44:38.578428image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q1126.26847
median126.48529
Q3126.52599
95-th percentile126.77025
Maximum126.91401
Range126.91401
Interquartile range (IQR)0.2575143

Descriptive statistics

Standard deviation52.10104
Coefficient of variation (CV)0.52465552
Kurtosis-0.046276785
Mean99.305235
Median Absolute Deviation (MAD)0.1361037
Skewness-1.3979442
Sum19861.047
Variance2714.5183
MonotonicityNot monotonic
2023-12-10T15:44:38.825579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 43
21.5%
126.4994025 21
 
10.5%
126.2684717 8
 
4.0%
126.5888268 7
 
3.5%
126.5320193 6
 
3.0%
126.693455 5
 
2.5%
126.4915207 5
 
2.5%
126.3163542 5
 
2.5%
126.4332653 5
 
2.5%
126.4119743 5
 
2.5%
Other values (49) 90
45.0%
ValueCountFrequency (%)
0.0 43
21.5%
126.1653957 1
 
0.5%
126.1654719 2
 
1.0%
126.2684717 8
 
4.0%
126.2987639 1
 
0.5%
126.3059385 3
 
1.5%
126.3163542 5
 
2.5%
126.3383952 2
 
1.0%
126.349009 2
 
1.0%
126.3553885 2
 
1.0%
ValueCountFrequency (%)
126.9140092 1
 
0.5%
126.8551278 1
 
0.5%
126.8444521 1
 
0.5%
126.8437183 1
 
0.5%
126.8369662 1
 
0.5%
126.8147248 2
1.0%
126.7784205 2
1.0%
126.7721332 1
 
0.5%
126.7701478 1
 
0.5%
126.7168442 3
1.5%

관광지유형명
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)7.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
제주마을체험
48 
테마공원
34 
스포츠/레저
30 
전시/박물관
27 
버스/택시관광
26 
Other values (10)
35 

Length

Max length7
Median length6
Mean length5.4
Min length2

Unique

Unique2 ?
Unique (%)1.0%

Sample

1st row제주마을체험
2nd row버스/택시관광
3rd row렌터카
4th row버스/택시관광
5th row스포츠/레저

Common Values

ValueCountFrequency (%)
제주마을체험 48
24.0%
테마공원 34
17.0%
스포츠/레저 30
15.0%
전시/박물관 27
13.5%
버스/택시관광 26
13.0%
맛집 9
 
4.5%
공연/쇼 5
 
2.5%
유모차/카시트 5
 
2.5%
뷰티/테라피 3
 
1.5%
해양관광 3
 
1.5%
Other values (5) 10
 
5.0%

Length

2023-12-10T15:44:39.038033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
제주마을체험 48
24.0%
테마공원 34
17.0%
스포츠/레저 30
15.0%
전시/박물관 27
13.5%
버스/택시관광 26
13.0%
맛집 9
 
4.5%
공연/쇼 5
 
2.5%
유모차/카시트 5
 
2.5%
뷰티/테라피 3
 
1.5%
해양관광 3
 
1.5%
Other values (5) 10
 
5.0%

관광지금액
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct56
Distinct (%)28.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19868.5
Minimum0
Maximum450000
Zeros6
Zeros (%)3.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:44:39.590647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2000
Q17375
median10600
Q315000
95-th percentile80000
Maximum450000
Range450000
Interquartile range (IQR)7625

Descriptive statistics

Standard deviation41543.727
Coefficient of variation (CV)2.0909342
Kurtosis64.313894
Mean19868.5
Median Absolute Deviation (MAD)4400
Skewness7.2048688
Sum3973700
Variance1.7258813 × 109
MonotonicityNot monotonic
2023-12-10T15:44:39.823117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2000 23
 
11.5%
10600 19
 
9.5%
15000 12
 
6.0%
14900 8
 
4.0%
21000 7
 
3.5%
8000 7
 
3.5%
3000 6
 
3.0%
9500 6
 
3.0%
4000 6
 
3.0%
0 6
 
3.0%
Other values (46) 100
50.0%
ValueCountFrequency (%)
0 6
 
3.0%
2000 23
11.5%
3000 6
 
3.0%
3500 2
 
1.0%
4000 6
 
3.0%
4300 1
 
0.5%
5000 2
 
1.0%
6500 2
 
1.0%
7000 2
 
1.0%
7500 5
 
2.5%
ValueCountFrequency (%)
450000 1
 
0.5%
236000 2
 
1.0%
89000 3
1.5%
80000 5
2.5%
56000 4
2.0%
48000 1
 
0.5%
43600 1
 
0.5%
40000 1
 
0.5%
39100 2
 
1.0%
39000 1
 
0.5%

이용자연령대코드
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:44:33.909134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:44:33.148558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:44:33.544271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:44:34.007412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:44:33.286980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:44:33.665806image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:44:34.133228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:44:33.420979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:44:33.799586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:44:39.978579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관광지명관광지지역명접속장치명공유채널명관광지주소관광지위도X좌표관광지경도Y좌표관광지유형명관광지금액
관광지명1.0001.0000.5950.0001.0001.0001.0001.0001.000
관광지지역명1.0001.000NaN0.1331.0000.2470.2470.6900.688
접속장치명0.595NaN1.0000.6840.0000.0000.0000.0000.000
공유채널명0.0000.1330.6841.0000.4190.0000.0000.4730.000
관광지주소1.0001.0000.0000.4191.0001.0001.0000.9900.847
관광지위도X좌표1.0000.2470.0000.0001.0001.0001.0000.5740.287
관광지경도Y좌표1.0000.2470.0000.0001.0001.0001.0000.5740.287
관광지유형명1.0000.6900.0000.4730.9900.5740.5741.0000.940
관광지금액1.0000.6880.0000.0000.8470.2870.2870.9401.000
2023-12-10T15:44:40.186648image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
접속장치명관광지유형명공유채널명관광지지역명
접속장치명1.0000.0000.4811.000
관광지유형명0.0001.0000.2790.477
공유채널명0.4810.2791.0000.124
관광지지역명1.0000.4770.1241.000
2023-12-10T15:44:40.369128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관광지위도X좌표관광지경도Y좌표관광지금액관광지지역명접속장치명공유채널명관광지유형명
관광지위도X좌표1.0000.605-0.2010.1620.0000.0000.510
관광지경도Y좌표0.6051.000-0.0960.1620.0000.0000.510
관광지금액-0.201-0.0961.0000.4820.0000.0000.824
관광지지역명0.1620.1620.4821.0001.0000.1240.477
접속장치명0.0000.0000.0001.0001.0000.4810.000
공유채널명0.0000.0000.0000.1240.4811.0000.279
관광지유형명0.5100.5100.8240.4770.0000.2791.000

Missing values

2023-12-10T15:44:34.306437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T15:44:34.551772image/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-21 06:49:06KAKAO제주특별자치도 서귀포시 남원읍 남위남성로 168 최남단감귤체험농장33.289951126.693455제주마을체험3000<NA><NA><NA>
1제주시티투어(1회·1일 이용권)<NA>MOBILE2019-12-21 10:19:30KAKAO제주특별자치도 제주시 선덕로 2333.486218126.499403버스/택시관광2000<NA><NA><NA>
2제주도렌트카 80% 할인 - 스팅어 2018년형<NA>MOBILE2019-12-21 14:35:39KAKAO제주특별자치도 제주시 서광로 66 2층 202호 제주허브닷컴33.499341126.503735렌터카56000<NA><NA><NA>
3제주시티투어(1회·1일 이용권)<NA>MOBILE2019-12-21 15:24:24KAKAO제주특별자치도 제주시 선덕로 2333.486218126.499403버스/택시관광2000<NA><NA><NA>
4윈드1947 카트 테마파크중문/서귀포MOBILE2019-12-21 16:57:29KAKAO제주특별자치도 서귀포시 토평공단로 78-2733.289519126.588827스포츠/레저21000<NA><NA><NA>
5윈드1947 카트 테마파크중문/서귀포MOBILE2019-12-21 18:02:56KAKAO제주특별자치도 서귀포시 토평공단로 78-2733.289519126.588827스포츠/레저21000<NA><NA><NA>
6제주시 한식 뷔페 섬채제주시내권MOBILE2019-12-21 21:16:26KAKAO제주특별자치도 제주시 오라로 61 2층33.496067126.510361맛집9000<NA><NA><NA>
7제주시 한식 뷔페 섬채제주시내권MOBILE2019-12-21 21:18:51KAKAO제주특별자치도 제주시 오라로 61 2층33.496067126.510361맛집9000<NA><NA><NA>
8제주불빛정원&인생사진관(야간)서부권MOBILE2019-12-21 22:02:08KAKAO제주특별자치도 제주시 애월읍 평화로 2346 제주장미빛축제33.422596126.408966테마공원9500<NA><NA><NA>
9청귤체험 귤 체험농장중문/서귀포MOBILE2019-12-21 22:03:31KAKAO제주특별자치도 서귀포시 호근동 1067 귤사랑33.271618126.532019제주마을체험4000<NA><NA><NA>
관광지명관광지지역명접속장치명등록일시공유채널명관광지주소관광지위도X좌표관광지경도Y좌표관광지유형명관광지금액이용자연령대코드이용자성별코드이용자광역시도코드
190제주바당비행 패러글라이딩체험서부권MOBILE2019-12-22 23:14:26KAKAO제주특별자치도 제주시 한림읍 금악리 1222-233.350011126.305938스포츠/레저89000<NA><NA><NA>
191행복공방 도자기 체험 카페중문/서귀포MOBILE2019-12-22 23:17:57KAKAO제주특별자치도 서귀포시 중산간서로 188 농업기술원 옆33.260398126.491521제주마을체험22500<NA><NA><NA>
192행복공방 도자기 체험 카페중문/서귀포MOBILE2019-12-22 23:17:59KAKAO제주특별자치도 서귀포시 중산간서로 188 농업기술원 옆33.260398126.491521제주마을체험22500<NA><NA><NA>
193에코랜드동부권MOBILE2019-12-22 23:18:23KAKAO제주특별자치도 제주시 조천읍 번영로 1278-16933.45553126.668187테마공원12200<NA><NA><NA>
194허브동산 - 주·야간 통합 입장권중문/서귀포MOBILE2019-12-22 23:19:56KAKAO제주특별자치도 서귀포시 표선면 돈오름로 17033.329124126.814725테마공원9900<NA><NA><NA>
195제주러브랜드 입장권 (야간개장 어린이휴게실 포함)제주시내권MOBILE2019-12-22 23:24:54KAKAO제주특별자치도 제주시 1100로 2894-7233.451992126.489005테마공원8000<NA><NA><NA>
196제주불빛정원&인생사진관(야간)서부권MOBILE2019-11-29 12:39:23KAKAO제주특별자치도 제주시 애월읍 평화로 2346 제주장미빛축제33.422596126.408966테마공원9500<NA><NA><NA>
197어승생승마장-체험승마A코스서부권MOBILE2019-11-29 18:14:41KAKAO제주특별자치도 제주시 1100로 265933.425705126.490448스포츠/레저56000<NA><NA><NA>
198제주시티투어(1회·1일 이용권)<NA>MOBILE2019-11-30 05:15:35KAKAO제주특별자치도 제주시 선덕로 2333.486218126.499403버스/택시관광2000<NA><NA><NA>
199제주테디베어뮤지엄중문/서귀포MOBILE2019-11-30 11:13:34KAKAO제주특별자치도 서귀포시 중문관광로110번길 3133.250242126.411974전시/박물관8500<NA><NA><NA>

Duplicate rows

Most frequently occurring

관광지명관광지지역명접속장치명등록일시공유채널명관광지주소관광지위도X좌표관광지경도Y좌표관광지유형명관광지금액# duplicates
112/1 저지리마을 예술투어<NA>MOBILE2019-11-27 15:52:44KAKAO제주특별자치도 제주시 한경면 용금로 864 방림원 일원0.00.0제주마을체험03
012/1 저지리마을 예술투어<NA>MOBILE2019-11-27 15:52:42KAKAO제주특별자치도 제주시 한경면 용금로 864 방림원 일원0.00.0제주마을체험02
212/14 저지리마을 예술투어<NA>MOBILE2019-12-02 17:04:43KAKAO제주특별자치도 제주시 한경면 용금로 864 방림원 일원0.00.0제주마을체험106002
312/14 저지리마을 예술투어<NA>MOBILE2019-12-02 20:22:41KAKAO제주특별자치도 제주시 한경면 용금로 864 방림원 일원0.00.0제주마을체험106002
4LAF 아트 페스타 야간 입장권동부권MOBILE2019-12-14 04:01:42KAKAO제주특별자치도 제주시 조천읍 선교로 115-1 제주라프33.486767126.706893전시/박물관105002
5[감귤체험]하효감귤체험중문/서귀포MOBILE2019-12-14 15:19:04KAKAO제주특별자치도 서귀포시 효돈순환로 217-833.256276126.622392제주마을체험150002
6골프탕탕 미니그라운드 골프장중문/서귀포MOBILE2019-12-22 12:37:44KAKAO제주특별자치도 서귀포시 안덕면 산록남로762번길 7133.305765126.388851테마공원96002
7넥슨컴퓨터박물관제주시내권MOBILE2019-12-22 08:42:17KAKAO제주특별자치도 제주시 노형동 8633.472488126.485595전시/박물관75002
8논짓물해수족욕카페서부권MOBILE2019-12-14 03:59:48KAKAO제주특별자치도 제주시 한경면 고산리 3616-933.309218126.165472테마공원80002
9니나수 족욕 카페중문/서귀포MOBILE2019-12-14 03:52:58KAKAO제주특별자치도 서귀포시 안덕면 대평로 2933.236599126.363867뷰티/테라피130002