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/566

Alerts

work_pop_cnt is highly skewed (γ1 = 28.54381339)Skewed
work_pop_cnt has 7948 (79.5%) zerosZeros

Reproduction

Analysis started2023-12-11 20:11:07.640381
Analysis finished2023-12-11 20:11:08.960745
Duration1.32 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.6
Minimum201801
Maximum201809
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T05:11:09.011428image/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.3045544
Coefficient of variation (CV)1.1419732 × 10-5
Kurtosis-1.2322876
Mean201804.6
Median Absolute Deviation (MAD)2
Skewness-0.038296772
Sum2.018046 × 109
Variance5.3109711
MonotonicityNot monotonic
2023-12-12T05:11:09.139846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
201807 1318
13.2%
201808 1302
13.0%
201803 1293
12.9%
201806 1287
12.9%
201805 1233
12.3%
201801 1181
11.8%
201804 1175
11.8%
201802 1170
11.7%
201809 41
 
0.4%
ValueCountFrequency (%)
201801 1181
11.8%
201802 1170
11.7%
201803 1293
12.9%
201804 1175
11.8%
201805 1233
12.3%
201806 1287
12.9%
201807 1318
13.2%
201808 1302
13.0%
201809 41
 
0.4%
ValueCountFrequency (%)
201809 41
 
0.4%
201808 1302
13.0%
201807 1318
13.2%
201806 1287
12.9%
201805 1233
12.3%
201804 1175
11.8%
201803 1293
12.9%
201802 1170
11.7%
201801 1181
11.8%

nationality
Categorical

Distinct30
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
기타
 
463
미국
 
440
인도네시아
 
432
캐나다
 
429
중국
 
422
Other values (25)
7814 

Length

Max length7
Median length6
Mean length3.2169
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row타이완
2nd row몽골
3rd row러시아
4th row필리핀
5th row중국

Common Values

ValueCountFrequency (%)
기타 463
 
4.6%
미국 440
 
4.4%
인도네시아 432
 
4.3%
캐나다 429
 
4.3%
중국 422
 
4.2%
네팔 419
 
4.2%
필리핀 414
 
4.1%
캄보디아 409
 
4.1%
베트남 406
 
4.1%
영국 401
 
4.0%
Other values (20) 5765
57.6%

Length

2023-12-12T05:11:09.271741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
기타 463
 
4.6%
미국 440
 
4.4%
인도네시아 432
 
4.3%
캐나다 429
 
4.3%
중국 422
 
4.2%
네팔 419
 
4.2%
필리핀 414
 
4.1%
캄보디아 409
 
4.1%
베트남 406
 
4.1%
영국 401
 
4.0%
Other values (20) 5765
57.6%

time_range
Categorical

Distinct12
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
15-16시
937 
19-20시
881 
17-18시
868 
11-12시
865 
9-10시
853 
Other values (7)
5596 

Length

Max length6
Median length6
Mean length5.3031
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row23-24시
2nd row9-10시
3rd row3-4시
4th row3-4시
5th row17-18시

Common Values

ValueCountFrequency (%)
15-16시 937
9.4%
19-20시 881
8.8%
17-18시 868
8.7%
11-12시 865
8.6%
9-10시 853
8.5%
21-22시 848
8.5%
23-24시 846
8.5%
13-14시 844
8.4%
1-2시 797
8.0%
3-4시 765
7.6%
Other values (2) 1496
15.0%

Length

2023-12-12T05:11:09.435403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
15-16시 937
9.4%
19-20시 881
8.8%
17-18시 868
8.7%
11-12시 865
8.6%
9-10시 853
8.5%
21-22시 848
8.5%
23-24시 846
8.5%
13-14시 844
8.4%
1-2시 797
8.0%
3-4시 765
7.6%
Other values (2) 1496
15.0%

work_pop_cnt
Real number (ℝ)

SKEWED  ZEROS 

Distinct2011
Distinct (%)20.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean102.38887
Minimum0
Maximum31629.81
Zeros7948
Zeros (%)79.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T05:11:09.613784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile435.6935
Maximum31629.81
Range31629.81
Interquartile range (IQR)0

Descriptive statistics

Standard deviation833.43262
Coefficient of variation (CV)8.1398752
Kurtosis986.09772
Mean102.38887
Median Absolute Deviation (MAD)0
Skewness28.543813
Sum1023888.7
Variance694609.93
MonotonicityNot monotonic
2023-12-12T05:11:09.802665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 7948
79.5%
15.26 3
 
< 0.1%
191.2 3
 
< 0.1%
86.97 3
 
< 0.1%
27.74 2
 
< 0.1%
11.12 2
 
< 0.1%
181.46 2
 
< 0.1%
12.04 2
 
< 0.1%
16.55 2
 
< 0.1%
111.53 2
 
< 0.1%
Other values (2001) 2031
 
20.3%
ValueCountFrequency (%)
0.0 7948
79.5%
3.91 1
 
< 0.1%
4.18 1
 
< 0.1%
4.58 1
 
< 0.1%
4.68 1
 
< 0.1%
4.93 1
 
< 0.1%
5.07 1
 
< 0.1%
5.38 1
 
< 0.1%
5.42 1
 
< 0.1%
5.47 1
 
< 0.1%
ValueCountFrequency (%)
31629.81 1
< 0.1%
31248.63 1
< 0.1%
30975.42 1
< 0.1%
30752.84 1
< 0.1%
29400.69 1
< 0.1%
22128.49 1
< 0.1%
10481.52 1
< 0.1%
10470.34 1
< 0.1%
10111.15 1
< 0.1%
10040.28 1
< 0.1%

emd_name
Categorical

Distinct43
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
제주시 용담2동
 
303
제주시 애월읍
 
294
제주시 건입동
 
288
제주시 한림읍
 
286
서귀포시 성산읍
 
283
Other values (38)
8546 

Length

Max length8
Median length8
Mean length7.5548
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제주시 삼양동
2nd row제주시 삼도1동
3rd row서귀포시 정방동
4th row서귀포시 예래동
5th row제주시 노형동

Common Values

ValueCountFrequency (%)
제주시 용담2동 303
 
3.0%
제주시 애월읍 294
 
2.9%
제주시 건입동 288
 
2.9%
제주시 한림읍 286
 
2.9%
서귀포시 성산읍 283
 
2.8%
제주시 이도2동 281
 
2.8%
서귀포시 안덕면 276
 
2.8%
서귀포시 예래동 268
 
2.7%
제주시 아라동 266
 
2.7%
제주시 노형동 265
 
2.6%
Other values (33) 7190
71.9%

Length

2023-12-12T05:11:09.966412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
제주시 6048
30.2%
서귀포시 3952
19.8%
용담2동 303
 
1.5%
애월읍 294
 
1.5%
건입동 288
 
1.4%
한림읍 286
 
1.4%
성산읍 283
 
1.4%
이도2동 281
 
1.4%
안덕면 276
 
1.4%
예래동 268
 
1.3%
Other values (35) 7721
38.6%

Interactions

2023-12-12T05:11:08.558003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:11:08.317934image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:11:08.665772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:11:08.442595image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T05:11:10.087321image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
base_year_monthnationalitytime_rangework_pop_cntemd_name
base_year_month1.0000.2940.0000.0000.029
nationality0.2941.0000.0320.2030.180
time_range0.0000.0321.0000.0000.000
work_pop_cnt0.0000.2030.0001.0000.201
emd_name0.0290.1800.0000.2011.000
2023-12-12T05:11:10.222830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
time_rangenationalityemd_name
time_range1.0000.0100.000
nationality0.0101.0000.039
emd_name0.0000.0391.000
2023-12-12T05:11:10.357281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
base_year_monthwork_pop_cntnationalitytime_rangeemd_name
base_year_month1.0000.0080.1050.0000.014
work_pop_cnt0.0081.0000.0830.0000.087
nationality0.1050.0831.0000.0100.039
time_range0.0000.0000.0101.0000.000
emd_name0.0140.0870.0390.0001.000

Missing values

2023-12-12T05:11:08.799827image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T05:11:08.906786image/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_rangework_pop_cntemd_name
68195201806타이완23-24시0.0제주시 삼양동
13768201802몽골9-10시0.0제주시 삼도1동
59938201806러시아3-4시0.0서귀포시 정방동
70077201806필리핀3-4시0.0서귀포시 예래동
41834201804중국17-18시9420.17제주시 노형동
9521201801타이완5-6시0.0제주시 이도1동
48129201805말레이시아19-20시0.0제주시 용담2동
82388201807필리핀3-4시0.0제주시 오라동
66457201806카자흐스탄21-22시0.0제주시 용담2동
79260201807캄보디아19-20시0.0제주시 건입동
base_year_monthnationalitytime_rangework_pop_cntemd_name
80517201807타이완21-22시0.0제주시 화북동
5212201801오스트레일리아1-2시0.0서귀포시 대정읍
40751201804인도네시아13-14시117.59서귀포시 정방동
23262201803네팔19-20시0.0서귀포시 동홍동
87990201808영국11-12시0.0제주시 일도2동
37131201804미국17-18시24.81서귀포시 대륜동
929201801네팔5-6시0.0제주시 연동
65733201806중국1-2시0.0제주시 삼양동
8211201801캄보디아17-18시304.43제주시 노형동
74325201807방글라데시19-20시0.0제주시 도두동