Overview

Dataset statistics

Number of variables5
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory488.3 KiB
Average record size in memory50.0 B

Variable types

Numeric2
Categorical3

Dataset

Description제주도 장기체류 방문 외국인 유동인구 추이 - 방문인구는 해당 유동인구 수의 연월별 합계 ※ 유동인구는 01~24시 해당 시간 정각 측정 인구 (머문 시간(분)/60분)
Author제주데이터허브
URLhttps://www.jejudatahub.net/data/view/data/564

Alerts

visit_population_count has 164 (1.6%) zerosZeros

Reproduction

Analysis started2023-12-11 19:34:14.082124
Analysis finished2023-12-11 19:34:15.540573
Duration1.46 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

base_year_month
Real number (ℝ)

Distinct9
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean201804.56
Minimum201801
Maximum201809
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T04:34:15.599984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum201801
5-th percentile201801
Q1201803
median201805
Q3201807
95-th percentile201808
Maximum201809
Range8
Interquartile range (IQR)4

Descriptive statistics

Standard deviation2.2868814
Coefficient of variation (CV)1.1332159 × 10-5
Kurtosis-1.220595
Mean201804.56
Median Absolute Deviation (MAD)2
Skewness-0.027512425
Sum2.0180456 × 109
Variance5.2298263
MonotonicityNot monotonic
2023-12-12T04:34:15.725366image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
201805 1324
13.2%
201806 1315
13.2%
201807 1274
12.7%
201803 1261
12.6%
201802 1239
12.4%
201808 1233
12.3%
201801 1177
11.8%
201804 1143
11.4%
201809 34
 
0.3%
ValueCountFrequency (%)
201801 1177
11.8%
201802 1239
12.4%
201803 1261
12.6%
201804 1143
11.4%
201805 1324
13.2%
201806 1315
13.2%
201807 1274
12.7%
201808 1233
12.3%
201809 34
 
0.3%
ValueCountFrequency (%)
201809 34
 
0.3%
201808 1233
12.3%
201807 1274
12.7%
201806 1315
13.2%
201805 1324
13.2%
201804 1143
11.4%
201803 1261
12.6%
201802 1239
12.4%
201801 1177
11.8%

nationality
Categorical

Distinct30
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
기타
 
471
인도네시아
 
452
중국
 
447
일본
 
424
미국
 
418
Other values (25)
7788 

Length

Max length7
Median length6
Mean length3.2178
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row미얀마
2nd row프랑스
3rd row인도네시아
4th row우크라이나
5th row러시아

Common Values

ValueCountFrequency (%)
기타 471
 
4.7%
인도네시아 452
 
4.5%
중국 447
 
4.5%
일본 424
 
4.2%
미국 418
 
4.2%
베트남 418
 
4.2%
네팔 417
 
4.2%
캄보디아 402
 
4.0%
필리핀 400
 
4.0%
몽골 400
 
4.0%
Other values (20) 5751
57.5%

Length

2023-12-12T04:34:15.885710image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
기타 471
 
4.7%
인도네시아 452
 
4.5%
중국 447
 
4.5%
일본 424
 
4.2%
미국 418
 
4.2%
베트남 418
 
4.2%
네팔 417
 
4.2%
캄보디아 402
 
4.0%
필리핀 400
 
4.0%
몽골 400
 
4.0%
Other values (20) 5751
57.5%

time_range
Categorical

Distinct12
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
19-20시
931 
13-14시
922 
15-16시
897 
17-18시
882 
11-12시
858 
Other values (7)
5510 

Length

Max length6
Median length6
Mean length5.3185
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row7-8시
2nd row19-20시
3rd row1-2시
4th row3-4시
5th row1-2시

Common Values

ValueCountFrequency (%)
19-20시 931
9.3%
13-14시 922
9.2%
15-16시 897
9.0%
17-18시 882
8.8%
11-12시 858
8.6%
9-10시 853
8.5%
23-24시 843
8.4%
21-22시 833
8.3%
7-8시 769
7.7%
5-6시 762
7.6%
Other values (2) 1450
14.5%

Length

2023-12-12T04:34:16.021340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
19-20시 931
9.3%
13-14시 922
9.2%
15-16시 897
9.0%
17-18시 882
8.8%
11-12시 858
8.6%
9-10시 853
8.5%
23-24시 843
8.4%
21-22시 833
8.3%
7-8시 769
7.7%
5-6시 762
7.6%
Other values (2) 1450
14.5%

visit_population_count
Real number (ℝ)

ZEROS 

Distinct7782
Distinct (%)77.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean481.77585
Minimum0
Maximum36415.17
Zeros164
Zeros (%)1.6%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T04:34:16.162168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile4.72
Q118.3025
median63.08
Q3251.725
95-th percentile2407.187
Maximum36415.17
Range36415.17
Interquartile range (IQR)233.4225

Descriptive statistics

Standard deviation1719.566
Coefficient of variation (CV)3.5692241
Kurtosis142.34651
Mean481.77585
Median Absolute Deviation (MAD)54.475
Skewness10.037801
Sum4817758.5
Variance2956907.2
MonotonicityNot monotonic
2023-12-12T04:34:16.321735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 164
 
1.6%
3.62 10
 
0.1%
3.57 9
 
0.1%
8.41 8
 
0.1%
7.18 8
 
0.1%
8.09 7
 
0.1%
6.87 7
 
0.1%
6.13 7
 
0.1%
3.88 6
 
0.1%
10.24 6
 
0.1%
Other values (7772) 9768
97.7%
ValueCountFrequency (%)
0.0 164
1.6%
2.79 1
 
< 0.1%
2.8 1
 
< 0.1%
2.81 2
 
< 0.1%
2.83 1
 
< 0.1%
2.84 2
 
< 0.1%
2.85 3
 
< 0.1%
2.86 2
 
< 0.1%
2.87 1
 
< 0.1%
2.88 3
 
< 0.1%
ValueCountFrequency (%)
36415.17 1
< 0.1%
35734.36 1
< 0.1%
35285.24 1
< 0.1%
31799.88 1
< 0.1%
30423.15 1
< 0.1%
30133.53 1
< 0.1%
29632.78 1
< 0.1%
28120.38 1
< 0.1%
26974.98 1
< 0.1%
23725.87 1
< 0.1%

emd_name
Categorical

Distinct43
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
제주시 용담2동
 
298
제주시 이도2동
 
294
제주시 노형동
 
284
서귀포시 안덕면
 
282
제주시 연동
 
278
Other values (38)
8564 

Length

Max length8
Median length8
Mean length7.5513
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서귀포시 영천동
2nd row서귀포시 표선면
3rd row제주시 외도동
4th row서귀포시 중문동
5th row제주시 오라동

Common Values

ValueCountFrequency (%)
제주시 용담2동 298
 
3.0%
제주시 이도2동 294
 
2.9%
제주시 노형동 284
 
2.8%
서귀포시 안덕면 282
 
2.8%
제주시 연동 278
 
2.8%
서귀포시 예래동 276
 
2.8%
제주시 한림읍 271
 
2.7%
제주시 애월읍 265
 
2.6%
제주시 구좌읍 261
 
2.6%
제주시 이도1동 254
 
2.5%
Other values (33) 7237
72.4%

Length

2023-12-12T04:34:16.482657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
제주시 6153
30.8%
서귀포시 3847
19.2%
용담2동 298
 
1.5%
이도2동 294
 
1.5%
노형동 284
 
1.4%
안덕면 282
 
1.4%
연동 278
 
1.4%
예래동 276
 
1.4%
한림읍 271
 
1.4%
애월읍 265
 
1.3%
Other values (35) 7752
38.8%

Interactions

2023-12-12T04:34:15.086454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T04:34:14.786693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T04:34:15.236957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T04:34:14.936984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T04:34:16.572008image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
base_year_monthnationalitytime_rangevisit_population_countemd_name
base_year_month1.0000.2720.0040.0310.000
nationality0.2721.0000.0280.4620.151
time_range0.0040.0281.0000.0250.024
visit_population_count0.0310.4620.0251.0000.260
emd_name0.0000.1510.0240.2601.000
2023-12-12T04:34:16.719593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
nationalitytime_rangeemd_name
nationality1.0000.0090.033
time_range0.0091.0000.007
emd_name0.0330.0071.000
2023-12-12T04:34:16.819155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
base_year_monthvisit_population_countnationalitytime_rangeemd_name
base_year_month1.0000.0240.0980.0000.000
visit_population_count0.0241.0000.1640.0110.092
nationality0.0980.1641.0000.0090.033
time_range0.0000.0110.0091.0000.007
emd_name0.0000.0920.0330.0071.000

Missing values

2023-12-12T04:34:15.385852image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T04:34:15.492568image/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

base_year_monthnationalitytime_rangevisit_population_countemd_name
37848201804미얀마7-8시57.41서귀포시 영천동
94242201808프랑스19-20시43.62서귀포시 표선면
17534201802인도네시아1-2시57.39제주시 외도동
88982201808우크라이나3-4시13.26서귀포시 중문동
12638201802러시아1-2시27.46제주시 오라동
11047201801필리핀7-8시11.17서귀포시 송산동
47844201805러시아3-4시23.96서귀포시 표선면
82096201807필리핀11-12시43.72제주시 일도1동
50740201805스리랑카3-4시476.65제주시 구좌읍
53118201805일본17-18시8.39제주시 용담1동
base_year_monthnationalitytime_rangevisit_population_countemd_name
8319201801캄보디아23-24시767.66서귀포시 남원읍
60603201806몽골15-16시12.62서귀포시 서홍동
29708201803일본23-24시132.09제주시 삼양동
7828201801카자흐스탄15-16시5.91제주시 일도2동
85402201808몽골19-20시574.14제주시 연동
59505201806독일23-24시34.65제주시 한경면
4544201801스리랑카19-20시199.64제주시 일도1동
30298201803중국5-6시351.71제주시 우도면
1228201801뉴질랜드21-22시8.2제주시 이도2동
64697201806인도9-10시98.91제주시 애월읍