Overview

Dataset statistics

Number of variables6
Number of observations127
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.2 KiB
Average record size in memory50.0 B

Variable types

Categorical4
Numeric1
DateTime1

Dataset

Description제주특별자치도 축산농가에서 일하는 외국인 근로자에 대한 현황 자료로 읍면동별 외국인 국적과 근로자 수에 대한 데이터를 제공합니다.
Author제주특별자치도
URLhttps://www.data.go.kr/data/15097062/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
시군구명 is highly overall correlated with 읍면동명 and 1 other fieldsHigh correlation
읍면동명 is highly overall correlated with 시군구명 and 1 other fieldsHigh correlation
리명 is highly overall correlated with 시군구명 and 1 other fieldsHigh correlation

Reproduction

Analysis started2023-12-12 06:20:15.976050
Analysis finished2023-12-12 06:20:16.621818
Duration0.65 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시군구명
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
제주시
84 
서귀포시
43 

Length

Max length4
Median length3
Mean length3.3385827
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
제주시 84
66.1%
서귀포시 43
33.9%

Length

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

Common Values (Plot)

2023-12-12T15:20:16.854470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제주시 84
66.1%
서귀포시 43
33.9%

읍면동명
Categorical

HIGH CORRELATION 

Distinct18
Distinct (%)14.2%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
한림읍
30 
구좌읍
17 
애월읍
14 
대정읍
13 
조천읍
12 
Other values (13)
41 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique6 ?
Unique (%)4.7%

Sample

1st row구좌읍
2nd row구좌읍
3rd row구좌읍
4th row구좌읍
5th row구좌읍

Common Values

ValueCountFrequency (%)
한림읍 30
23.6%
구좌읍 17
13.4%
애월읍 14
11.0%
대정읍 13
10.2%
조천읍 12
 
9.4%
남원읍 11
 
8.7%
표선면 6
 
4.7%
한경면 5
 
3.9%
성산읍 5
 
3.9%
안덕면 3
 
2.4%
Other values (8) 11
 
8.7%

Length

2023-12-12T15:20:16.990105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
한림읍 30
23.6%
구좌읍 17
13.4%
애월읍 14
11.0%
대정읍 13
10.2%
조천읍 12
 
9.4%
남원읍 11
 
8.7%
표선면 6
 
4.7%
한경면 5
 
3.9%
성산읍 5
 
3.9%
해안동 3
 
2.4%
Other values (8) 11
 
8.7%

리명
Categorical

HIGH CORRELATION 

Distinct48
Distinct (%)37.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
<NA>
11 
금악리
 
7
상대리
 
6
상명리
 
6
동일리
 
5
Other values (43)
92 

Length

Max length4
Median length3
Mean length3.0944882
Min length3

Unique

Unique17 ?
Unique (%)13.4%

Sample

1st row김녕리
2nd row김녕리
3rd row덕천리
4th row덕천리
5th row동복리

Common Values

ValueCountFrequency (%)
<NA> 11
 
8.7%
금악리 7
 
5.5%
상대리 6
 
4.7%
상명리 6
 
4.7%
동일리 5
 
3.9%
명월리 5
 
3.9%
세화리 5
 
3.9%
광령리 5
 
3.9%
금능리 4
 
3.1%
한동리 4
 
3.1%
Other values (38) 69
54.3%

Length

2023-12-12T15:20:17.149759image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 11
 
8.7%
금악리 7
 
5.5%
상대리 6
 
4.7%
상명리 6
 
4.7%
동일리 5
 
3.9%
명월리 5
 
3.9%
세화리 5
 
3.9%
광령리 5
 
3.9%
신평리 4
 
3.1%
대흘리 4
 
3.1%
Other values (38) 69
54.3%

국적
Categorical

Distinct8
Distinct (%)6.3%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
네팔
45 
캄보디아
25 
태국
20 
미얀마
18 
베트남
12 
Other values (3)
7 

Length

Max length4
Median length2
Mean length2.6456693
Min length2

Unique

Unique2 ?
Unique (%)1.6%

Sample

1st row네팔
2nd row캄보디아
3rd row네팔
4th row미얀마
5th row캄보디아

Common Values

ValueCountFrequency (%)
네팔 45
35.4%
캄보디아 25
19.7%
태국 20
15.7%
미얀마 18
 
14.2%
베트남 12
 
9.4%
중국 5
 
3.9%
예멘 1
 
0.8%
짐바브웨 1
 
0.8%

Length

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

Common Values (Plot)

2023-12-12T15:20:17.491574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
네팔 45
35.4%
캄보디아 25
19.7%
태국 20
15.7%
미얀마 18
 
14.2%
베트남 12
 
9.4%
중국 5
 
3.9%
예멘 1
 
0.8%
짐바브웨 1
 
0.8%

외국인수
Real number (ℝ)

Distinct15
Distinct (%)11.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.5984252
Minimum1
Maximum43
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.2 KiB
2023-12-12T15:20:17.661443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median2
Q34
95-th percentile11
Maximum43
Range42
Interquartile range (IQR)3

Descriptive statistics

Standard deviation4.8538315
Coefficient of variation (CV)1.3488766
Kurtosis34.69363
Mean3.5984252
Median Absolute Deviation (MAD)1
Skewness4.8996279
Sum457
Variance23.55968
MonotonicityNot monotonic
2023-12-12T15:20:17.811265image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
1 51
40.2%
2 28
22.0%
3 11
 
8.7%
4 6
 
4.7%
6 6
 
4.7%
8 5
 
3.9%
5 5
 
3.9%
7 4
 
3.1%
11 3
 
2.4%
12 2
 
1.6%
Other values (5) 6
 
4.7%
ValueCountFrequency (%)
1 51
40.2%
2 28
22.0%
3 11
 
8.7%
4 6
 
4.7%
5 5
 
3.9%
6 6
 
4.7%
7 4
 
3.1%
8 5
 
3.9%
9 1
 
0.8%
10 2
 
1.6%
ValueCountFrequency (%)
43 1
 
0.8%
19 1
 
0.8%
16 1
 
0.8%
12 2
 
1.6%
11 3
2.4%
10 2
 
1.6%
9 1
 
0.8%
8 5
3.9%
7 4
3.1%
6 6
4.7%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
Minimum2021-12-21 00:00:00
Maximum2021-12-21 00:00:00
2023-12-12T15:20:17.953496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:20:18.105179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T15:20:16.280642image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T15:20:18.218409image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구명읍면동명리명국적외국인수
시군구명1.0001.0000.9870.0000.000
읍면동명1.0001.0000.9980.0000.000
리명0.9870.9981.0000.0000.000
국적0.0000.0000.0001.0000.000
외국인수0.0000.0000.0000.0001.000
2023-12-12T15:20:18.356478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구명읍면동명리명국적
시군구명1.0000.9340.7470.000
읍면동명0.9341.0000.7860.000
리명0.7470.7861.0000.000
국적0.0000.0000.0001.000
2023-12-12T15:20:18.510298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
외국인수시군구명읍면동명리명국적
외국인수1.0000.0000.0000.0000.000
시군구명0.0001.0000.9340.7470.000
읍면동명0.0000.9341.0000.7860.000
리명0.0000.7470.7861.0000.000
국적0.0000.0000.0000.0001.000

Missing values

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

시군구명읍면동명리명국적외국인수데이터기준일자
0제주시구좌읍김녕리네팔12021-12-21
1제주시구좌읍김녕리캄보디아12021-12-21
2제주시구좌읍덕천리네팔12021-12-21
3제주시구좌읍덕천리미얀마12021-12-21
4제주시구좌읍동복리캄보디아12021-12-21
5제주시구좌읍상도리네팔42021-12-21
6제주시구좌읍상도리캄보디아22021-12-21
7제주시구좌읍세화리네팔82021-12-21
8제주시구좌읍세화리베트남112021-12-21
9제주시구좌읍세화리캄보디아82021-12-21
시군구명읍면동명리명국적외국인수데이터기준일자
117서귀포시안덕면덕수리미얀마12021-12-21
118서귀포시안덕면사계리태국12021-12-21
119서귀포시안덕면상창리네팔22021-12-21
120서귀포시중문동<NA>네팔12021-12-21
121서귀포시표선면가시리네팔112021-12-21
122서귀포시표선면가시리미얀마12021-12-21
123서귀포시표선면가시리태국12021-12-21
124서귀포시표선면성읍리네팔22021-12-21
125서귀포시표선면세화리네팔12021-12-21
126서귀포시표선면세화리캄보디아42021-12-21