Overview

Dataset statistics

Number of variables7
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory644.5 KiB
Average record size in memory66.0 B

Variable types

DateTime1
Categorical5
Numeric1

Dataset

Description제주빅데이터센터 데이터를 활용하여 국가별 외국인 방문지 파악을 위한 유동인구 및 와이파이 이용현황 데이터 제공 - 방문인구는 해당 유동인구 수의 일별 합계 ※ 유동인구는 01~24시 해당 시간 정각 측정 인구 (머문 시간(분)/60분)
Author제주데이터허브
URLhttps://www.jejudatahub.net/data/view/data/749

Alerts

서비스 사용시간 has constant value ""Constant
데이터기준일자 has constant value ""Constant
시도명 is highly overall correlated with 읍면동명High correlation
읍면동명 is highly overall correlated with 시도명High correlation
방문인구 has 6553 (65.5%) zerosZeros

Reproduction

Analysis started2023-12-11 20:11:55.831701
Analysis finished2023-12-11 20:11:56.526677
Duration0.69 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일자
Date

Distinct151
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2021-01-01 00:00:00
Maximum2021-05-31 00:00:00
2023-12-12T05:11:56.609692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:11:56.806818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

시도명
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
제주시
6035 
서귀포시
3965 

Length

Max length4
Median length3
Mean length3.3965
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제주시
2nd row제주시
3rd row서귀포시
4th row제주시
5th row서귀포시

Common Values

ValueCountFrequency (%)
제주시 6035
60.4%
서귀포시 3965
39.6%

Length

2023-12-12T05:11:56.986246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T05:11:57.102276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제주시 6035
60.4%
서귀포시 3965
39.6%

읍면동명
Categorical

HIGH CORRELATION 

Distinct43
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
건입동
 
268
송산동
 
257
애월읍
 
256
예래동
 
252
중앙동
 
252
Other values (38)
8715 

Length

Max length4
Median length3
Mean length3.1545
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일도2동
2nd row외도동
3rd row안덕면
4th row아라동
5th row서홍동

Common Values

ValueCountFrequency (%)
건입동 268
 
2.7%
송산동 257
 
2.6%
애월읍 256
 
2.6%
예래동 252
 
2.5%
중앙동 252
 
2.5%
대정읍 250
 
2.5%
삼양동 249
 
2.5%
성산읍 247
 
2.5%
남원읍 247
 
2.5%
연동 245
 
2.5%
Other values (33) 7477
74.8%

Length

2023-12-12T05:11:57.221403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
건입동 268
 
2.7%
송산동 257
 
2.6%
애월읍 256
 
2.6%
예래동 252
 
2.5%
중앙동 252
 
2.5%
대정읍 250
 
2.5%
삼양동 249
 
2.5%
성산읍 247
 
2.5%
남원읍 247
 
2.5%
연동 245
 
2.5%
Other values (33) 7477
74.8%

국적
Categorical

Distinct10
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
타이
1055 
싱가포르
1043 
기타
1016 
중국
1014 
미국
1010 
Other values (5)
4862 

Length

Max length5
Median length2
Mean length2.6043
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row말레이시아
2nd row홍콩
3rd row베트남
4th row미국
5th row타이

Common Values

ValueCountFrequency (%)
타이 1055
10.5%
싱가포르 1043
10.4%
기타 1016
10.2%
중국 1014
10.1%
미국 1010
10.1%
말레이시아 999
10.0%
홍콩 974
9.7%
인도 972
9.7%
베트남 960
9.6%
일본 957
9.6%

Length

2023-12-12T05:11:57.344896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T05:11:57.474005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
타이 1055
10.5%
싱가포르 1043
10.4%
기타 1016
10.2%
중국 1014
10.1%
미국 1010
10.1%
말레이시아 999
10.0%
홍콩 974
9.7%
인도 972
9.7%
베트남 960
9.6%
일본 957
9.6%

방문인구
Real number (ℝ)

ZEROS 

Distinct1514
Distinct (%)15.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7.1085224
Minimum0
Maximum1051.547
Zeros6553
Zeros (%)65.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T05:11:57.634109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31.14
95-th percentile30.079
Maximum1051.547
Range1051.547
Interquartile range (IQR)1.14

Descriptive statistics

Standard deviation36.09133
Coefficient of variation (CV)5.0771916
Kurtosis254.19718
Mean7.1085224
Median Absolute Deviation (MAD)0
Skewness13.570988
Sum71085.224
Variance1302.5841
MonotonicityNot monotonic
2023-12-12T05:11:57.775123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 6553
65.5%
11.722 38
 
0.4%
1.253 36
 
0.4%
0.604 27
 
0.3%
0.008 25
 
0.2%
27.199 24
 
0.2%
2.729 21
 
0.2%
0.032 20
 
0.2%
3.4730000000000003 19
 
0.2%
30.079 17
 
0.2%
Other values (1504) 3220
32.2%
ValueCountFrequency (%)
0.0 6553
65.5%
0.008 25
 
0.2%
0.009 10
 
0.1%
0.016 13
 
0.1%
0.018 11
 
0.1%
0.022 8
 
0.1%
0.024 10
 
0.1%
0.027 9
 
0.1%
0.0289999999999999 13
 
0.1%
0.032 20
 
0.2%
ValueCountFrequency (%)
1051.547 1
< 0.1%
994.776 1
< 0.1%
792.11 1
< 0.1%
708.113 1
< 0.1%
641.697 1
< 0.1%
631.441 1
< 0.1%
590.419 1
< 0.1%
586.513 1
< 0.1%
576.746 1
< 0.1%
561.118 1
< 0.1%

서비스 사용시간
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

2023-12-12T05:11:57.931304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T05:11:58.066924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2021-07-26
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-07-26
2nd row2021-07-26
3rd row2021-07-26
4th row2021-07-26
5th row2021-07-26

Common Values

ValueCountFrequency (%)
2021-07-26 10000
100.0%

Length

2023-12-12T05:11:58.195098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T05:11:58.334624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-07-26 10000
100.0%

Interactions

2023-12-12T05:11:56.207195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T05:11:58.419420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시도명읍면동명국적방문인구
시도명1.0001.0000.0280.032
읍면동명1.0001.0000.0000.313
국적0.0280.0001.0000.149
방문인구0.0320.3130.1491.000
2023-12-12T05:11:58.551631image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시도명읍면동명국적
시도명1.0000.9980.021
읍면동명0.9981.0000.000
국적0.0210.0001.000
2023-12-12T05:11:58.676436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
방문인구시도명읍면동명국적
방문인구1.0000.0310.1180.068
시도명0.0311.0000.9980.021
읍면동명0.1180.9981.0000.000
국적0.0680.0210.0001.000

Missing values

2023-12-12T05:11:56.343587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T05:11:56.472044image/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

일자시도명읍면동명국적방문인구서비스 사용시간데이터기준일자
280012021-03-07제주시일도2동말레이시아0.002021-07-26
285562021-03-08제주시외도동홍콩0.002021-07-26
532082021-05-04서귀포시안덕면베트남0.002021-07-26
129472021-01-31제주시아라동미국0.002021-07-26
316512021-03-15서귀포시서홍동타이0.40202021-07-26
59102021-01-14서귀포시안덕면타이0.00902021-07-26
191952021-02-14서귀포시성산읍싱가포르0.002021-07-26
159612021-02-07제주시일도2동말레이시아0.002021-07-26
248902021-02-27제주시한림읍미국21.12302021-07-26
226552021-02-22서귀포시안덕면인도0.002021-07-26
일자시도명읍면동명국적방문인구서비스 사용시간데이터기준일자
182682021-02-12서귀포시대정읍타이0.002021-07-26
299722021-03-11서귀포시정방동인도1.30302021-07-26
628962021-05-27제주시이호동인도0.002021-07-26
120922021-01-29제주시건입동싱가포르0.002021-07-26
61282021-01-15서귀포시송산동홍콩0.002021-07-26
586912021-05-17서귀포시대정읍기타0.002021-07-26
445392021-04-14서귀포시대륜동일본0.002021-07-26
422322021-04-09제주시용담2동타이0.002021-07-26
320182021-03-16제주시삼도1동타이0.002021-07-26
224182021-02-22제주시이도2동인도0.002021-07-26