Dataset statistics
Number of variables | 8 |
---|---|
Number of observations | 186 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 13.0 KiB |
Average record size in memory | 71.7 B |
Variable types
Numeric | 6 |
---|---|
Categorical | 2 |
Dataset
Description | 경기도_시군분석마트외국인기본 |
---|---|
Author | 경기도 |
URL | https://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=MKY5DQFFMTW9N4GGCVUU33701198&infSeq=1 |
년도 is highly overall correlated with 생성일자 | High correlation |
시군코드 is highly overall correlated with 시군명 | High correlation |
등록외국인수 is highly overall correlated with 등록외국인남자수 and 3 other fields | High correlation |
등록외국인남자수 is highly overall correlated with 등록외국인수 and 3 other fields | High correlation |
등록외국인여자수 is highly overall correlated with 등록외국인수 and 3 other fields | High correlation |
등록외국인여자2030수 is highly overall correlated with 등록외국인수 and 3 other fields | High correlation |
시군명 is highly overall correlated with 시군코드 and 4 other fields | High correlation |
생성일자 is highly overall correlated with 년도 | High correlation |
등록외국인남자수 has unique values | Unique |
Reproduction
Analysis started | 2023-12-10 21:33:53.230122 |
---|---|
Analysis finished | 2023-12-10 21:33:56.532220 |
Duration | 3.3 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
년도
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 6 |
---|---|
Distinct (%) | 3.2% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2014.5 |
Minimum | 2012 |
---|---|
Maximum | 2017 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.8 KiB |
Quantile statistics
Minimum | 2012 |
---|---|
5-th percentile | 2012 |
Q1 | 2013 |
median | 2014.5 |
Q3 | 2016 |
95-th percentile | 2017 |
Maximum | 2017 |
Range | 5 |
Interquartile range (IQR) | 3 |
Descriptive statistics
Standard deviation | 1.7124347 |
---|---|
Coefficient of variation (CV) | 0.00085005443 |
Kurtosis | -1.2703798 |
Mean | 2014.5 |
Median Absolute Deviation (MAD) | 1.5 |
Skewness | 0 |
Sum | 374697 |
Variance | 2.9324324 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
2012 | 31 | |
2013 | 31 | |
2014 | 31 | |
2015 | 31 | |
2017 | 31 | |
2016 | 31 |
Value | Count | Frequency (%) |
2012 | 31 | |
2013 | 31 | |
2014 | 31 | |
2015 | 31 | |
2016 | 31 | |
2017 | 31 |
Value | Count | Frequency (%) |
2017 | 31 | |
2016 | 31 | |
2015 | 31 | |
2014 | 31 | |
2013 | 31 | |
2012 | 31 |
시군코드
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 31 |
---|---|
Distinct (%) | 16.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 4142.4194 |
Minimum | 4111 |
---|---|
Maximum | 4183 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.8 KiB |
Quantile statistics
Minimum | 4111 |
---|---|
5-th percentile | 4113 |
Q1 | 4125 |
median | 4141 |
Q3 | 4159 |
95-th percentile | 4182 |
Maximum | 4183 |
Range | 72 |
Interquartile range (IQR) | 34 |
Descriptive statistics
Standard deviation | 20.597729 |
---|---|
Coefficient of variation (CV) | 0.004972391 |
Kurtosis | -0.84000522 |
Mean | 4142.4194 |
Median Absolute Deviation (MAD) | 16 |
Skewness | 0.34779322 |
Sum | 770490 |
Variance | 424.26643 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
4111 | 6 | 3.2% |
4113 | 6 | 3.2% |
4183 | 6 | 3.2% |
4182 | 6 | 3.2% |
4180 | 6 | 3.2% |
4167 | 6 | 3.2% |
4165 | 6 | 3.2% |
4163 | 6 | 3.2% |
4161 | 6 | 3.2% |
4159 | 6 | 3.2% |
Other values (21) | 126 |
Value | Count | Frequency (%) |
4111 | 6 | |
4113 | 6 | |
4115 | 6 | |
4117 | 6 | |
4119 | 6 | |
4121 | 6 | |
4122 | 6 | |
4125 | 6 | |
4127 | 6 | |
4128 | 6 |
Value | Count | Frequency (%) |
4183 | 6 | |
4182 | 6 | |
4180 | 6 | |
4167 | 6 | |
4165 | 6 | |
4163 | 6 | |
4161 | 6 | |
4159 | 6 | |
4157 | 6 | |
4155 | 6 |
시군명
Categorical
HIGH CORRELATION
 
Distinct | 31 |
---|---|
Distinct (%) | 16.7% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.6 KiB |
수원시 | 6 |
---|---|
성남시 | 6 |
의정부시 | 6 |
안양시 | 6 |
부천시 | 6 |
Other values (26) |
Length
Max length | 4 |
---|---|
Median length | 3 |
Mean length | 3.0967742 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 수원시 |
---|---|
2nd row | 성남시 |
3rd row | 의정부시 |
4th row | 안양시 |
5th row | 부천시 |
Common Values
Value | Count | Frequency (%) |
수원시 | 6 | 3.2% |
성남시 | 6 | 3.2% |
의정부시 | 6 | 3.2% |
안양시 | 6 | 3.2% |
부천시 | 6 | 3.2% |
광명시 | 6 | 3.2% |
평택시 | 6 | 3.2% |
동두천시 | 6 | 3.2% |
안산시 | 6 | 3.2% |
고양시 | 6 | 3.2% |
Other values (21) | 126 |
Length
Value | Count | Frequency (%) |
수원시 | 6 | 3.2% |
의왕시 | 6 | 3.2% |
가평군 | 6 | 3.2% |
연천군 | 6 | 3.2% |
여주시 | 6 | 3.2% |
포천시 | 6 | 3.2% |
양주시 | 6 | 3.2% |
광주시 | 6 | 3.2% |
화성시 | 6 | 3.2% |
김포시 | 6 | 3.2% |
Other values (21) | 126 |
등록외국인수
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 183 |
---|---|
Distinct (%) | 98.4% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 11184.667 |
Minimum | 211 |
---|---|
Maximum | 55719 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.8 KiB |
Quantile statistics
Minimum | 211 |
---|---|
5-th percentile | 913 |
Q1 | 2908.25 |
median | 7246 |
Q3 | 15639.5 |
95-th percentile | 36122.25 |
Maximum | 55719 |
Range | 55508 |
Interquartile range (IQR) | 12731.25 |
Descriptive statistics
Standard deviation | 11714.653 |
---|---|
Coefficient of variation (CV) | 1.0473851 |
Kurtosis | 3.3905463 |
Mean | 11184.667 |
Median Absolute Deviation (MAD) | 5450.5 |
Skewness | 1.8217124 |
Sum | 2080348 |
Variance | 1.372331 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1077 | 2 | 1.1% |
7254 | 2 | 1.1% |
3512 | 2 | 1.1% |
27697 | 1 | 0.5% |
21345 | 1 | 0.5% |
3015 | 1 | 0.5% |
892 | 1 | 0.5% |
1469 | 1 | 0.5% |
37852 | 1 | 0.5% |
16936 | 1 | 0.5% |
Other values (173) | 173 |
Value | Count | Frequency (%) |
211 | 1 | |
235 | 1 | |
274 | 1 | |
292 | 1 | |
297 | 1 | |
310 | 1 | |
729 | 1 | |
760 | 1 | |
791 | 1 | |
892 | 1 |
Value | Count | Frequency (%) |
55719 | 1 | |
54497 | 1 | |
53755 | 1 | |
53733 | 1 | |
49249 | 1 | |
43465 | 1 | |
37852 | 1 | |
37351 | 1 | |
37183 | 1 | |
36516 | 1 |
등록외국인남자수
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 186 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 6685.0161 |
Minimum | 95 |
---|---|
Maximum | 31522 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.8 KiB |
Quantile statistics
Minimum | 95 |
---|---|
5-th percentile | 456.25 |
Q1 | 1488.5 |
median | 4114.5 |
Q3 | 9040.25 |
95-th percentile | 22886.5 |
Maximum | 31522 |
Range | 31427 |
Interquartile range (IQR) | 7551.75 |
Descriptive statistics
Standard deviation | 7074.5544 |
---|---|
Coefficient of variation (CV) | 1.0582704 |
Kurtosis | 2.6347983 |
Mean | 6685.0161 |
Median Absolute Deviation (MAD) | 3430 |
Skewness | 1.686805 |
Sum | 1243413 |
Variance | 50049320 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
13781 | 1 | 0.5% |
11070 | 1 | 0.5% |
9489 | 1 | 0.5% |
1905 | 1 | 0.5% |
604 | 1 | 0.5% |
457 | 1 | 0.5% |
679 | 1 | 0.5% |
20086 | 1 | 0.5% |
8424 | 1 | 0.5% |
1906 | 1 | 0.5% |
Other values (176) | 176 |
Value | Count | Frequency (%) |
95 | 1 | |
101 | 1 | |
117 | 1 | |
133 | 1 | |
137 | 1 | |
147 | 1 | |
382 | 1 | |
409 | 1 | |
436 | 1 | |
456 | 1 |
Value | Count | Frequency (%) |
31522 | 1 | |
30853 | 1 | |
30839 | 1 | |
30610 | 1 | |
28374 | 1 | |
26862 | 1 | |
25587 | 1 | |
24995 | 1 | |
24802 | 1 | |
23612 | 1 |
등록외국인여자수
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 185 |
---|---|
Distinct (%) | 99.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 4499.6505 |
Minimum | 116 |
---|---|
Maximum | 24197 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.8 KiB |
Quantile statistics
Minimum | 116 |
---|---|
5-th percentile | 281.25 |
Q1 | 1169.5 |
median | 2777 |
Q3 | 6019.75 |
95-th percentile | 16563.5 |
Maximum | 24197 |
Range | 24081 |
Interquartile range (IQR) | 4850.25 |
Descriptive statistics
Standard deviation | 4963.3138 |
---|---|
Coefficient of variation (CV) | 1.1030443 |
Kurtosis | 4.4294121 |
Mean | 4499.6505 |
Median Absolute Deviation (MAD) | 1952.5 |
Skewness | 2.0739635 |
Sum | 836935 |
Variance | 24634484 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
611 | 2 | 1.1% |
13916 | 1 | 0.5% |
3538 | 1 | 0.5% |
2709 | 1 | 0.5% |
1110 | 1 | 0.5% |
288 | 1 | 0.5% |
620 | 1 | 0.5% |
790 | 1 | 0.5% |
17766 | 1 | 0.5% |
8512 | 1 | 0.5% |
Other values (175) | 175 |
Value | Count | Frequency (%) |
116 | 1 | |
134 | 1 | |
157 | 1 | |
159 | 1 | |
160 | 1 | |
163 | 1 | |
263 | 1 | |
267 | 1 | |
274 | 1 | |
279 | 1 |
Value | Count | Frequency (%) |
24197 | 1 | |
23658 | 1 | |
23145 | 1 | |
22880 | 1 | |
20875 | 1 | |
18470 | 1 | |
18213 | 1 | |
17837 | 1 | |
17766 | 1 | |
17112 | 1 |
등록외국인여자2030수
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 180 |
---|---|
Distinct (%) | 96.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2137.5538 |
Minimum | 57 |
---|---|
Maximum | 9692 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.8 KiB |
Quantile statistics
Minimum | 57 |
---|---|
5-th percentile | 161.25 |
Q1 | 758.25 |
median | 1523.5 |
Q3 | 3025.75 |
95-th percentile | 7037.75 |
Maximum | 9692 |
Range | 9635 |
Interquartile range (IQR) | 2267.5 |
Descriptive statistics
Standard deviation | 2089.4362 |
---|---|
Coefficient of variation (CV) | 0.97748944 |
Kurtosis | 2.7654121 |
Mean | 2137.5538 |
Median Absolute Deviation (MAD) | 1039 |
Skewness | 1.7088319 |
Sum | 397585 |
Variance | 4365743.8 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
162 | 2 | 1.1% |
3988 | 2 | 1.1% |
285 | 2 | 1.1% |
350 | 2 | 1.1% |
343 | 2 | 1.1% |
1630 | 2 | 1.1% |
6071 | 1 | 0.5% |
1674 | 1 | 0.5% |
265 | 1 | 0.5% |
500 | 1 | 0.5% |
Other values (170) | 170 |
Value | Count | Frequency (%) |
57 | 1 | |
68 | 1 | |
79 | 1 | |
87 | 1 | |
96 | 1 | |
98 | 1 | |
141 | 1 | |
148 | 1 | |
160 | 1 | |
161 | 1 |
Value | Count | Frequency (%) |
9692 | 1 | |
9610 | 1 | |
9512 | 1 | |
9007 | 1 | |
8615 | 1 | |
8151 | 1 | |
7351 | 1 | |
7220 | 1 | |
7165 | 1 | |
7110 | 1 |
생성일자
Categorical
HIGH CORRELATION
 
Distinct | 2 |
---|---|
Distinct (%) | 1.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.6 KiB |
20180315 | |
---|---|
20190131 |
Length
Max length | 8 |
---|---|
Median length | 8 |
Mean length | 8 |
Min length | 8 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 20180315 |
---|---|
2nd row | 20180315 |
3rd row | 20180315 |
4th row | 20180315 |
5th row | 20180315 |
Common Values
Value | Count | Frequency (%) |
20180315 | 155 | |
20190131 | 31 | 16.7% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
20180315 | 155 | |
20190131 | 31 | 16.7% |
년도 | 시군코드 | 시군명 | 등록외국인수 | 등록외국인남자수 | 등록외국인여자수 | 등록외국인여자2030수 | 생성일자 | |
---|---|---|---|---|---|---|---|---|
년도 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 |
시군코드 | 0.000 | 1.000 | 1.000 | 0.573 | 0.548 | 0.729 | 0.798 | 0.000 |
시군명 | 0.000 | 1.000 | 1.000 | 0.906 | 0.904 | 0.928 | 0.952 | 0.000 |
등록외국인수 | 0.000 | 0.573 | 0.906 | 1.000 | 0.968 | 0.971 | 0.954 | 0.000 |
등록외국인남자수 | 0.000 | 0.548 | 0.904 | 0.968 | 1.000 | 0.935 | 0.927 | 0.000 |
등록외국인여자수 | 0.000 | 0.729 | 0.928 | 0.971 | 0.935 | 1.000 | 0.964 | 0.000 |
등록외국인여자2030수 | 0.000 | 0.798 | 0.952 | 0.954 | 0.927 | 0.964 | 1.000 | 0.000 |
생성일자 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 |
생성일자 | 시군명 | |
---|---|---|
생성일자 | 1.000 | 0.000 |
시군명 | 0.000 | 1.000 |
년도 | 시군코드 | 등록외국인수 | 등록외국인남자수 | 등록외국인여자수 | 등록외국인여자2030수 | 시군명 | 생성일자 | |
---|---|---|---|---|---|---|---|---|
년도 | 1.000 | 0.000 | 0.083 | 0.096 | 0.085 | 0.048 | 0.000 | 0.989 |
시군코드 | 0.000 | 1.000 | -0.290 | -0.195 | -0.444 | -0.349 | 0.936 | 0.000 |
등록외국인수 | 0.083 | -0.290 | 1.000 | 0.988 | 0.957 | 0.973 | 0.574 | 0.000 |
등록외국인남자수 | 0.096 | -0.195 | 0.988 | 1.000 | 0.913 | 0.946 | 0.568 | 0.000 |
등록외국인여자수 | 0.085 | -0.444 | 0.957 | 0.913 | 1.000 | 0.973 | 0.626 | 0.000 |
등록외국인여자2030수 | 0.048 | -0.349 | 0.973 | 0.946 | 0.973 | 1.000 | 0.696 | 0.000 |
시군명 | 0.000 | 0.936 | 0.574 | 0.568 | 0.626 | 0.696 | 1.000 | 0.000 |
생성일자 | 0.989 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 |
년도 | 시군코드 | 시군명 | 등록외국인수 | 등록외국인남자수 | 등록외국인여자수 | 등록외국인여자2030수 | 생성일자 | |
---|---|---|---|---|---|---|---|---|
0 | 2012 | 4111 | 수원시 | 27697 | 13781 | 13916 | 6071 | 20180315 |
1 | 2012 | 4113 | 성남시 | 15656 | 7207 | 8449 | 3699 | 20180315 |
2 | 2012 | 4115 | 의정부시 | 3613 | 1476 | 2137 | 1082 | 20180315 |
3 | 2012 | 4117 | 안양시 | 6818 | 3203 | 3615 | 1661 | 20180315 |
4 | 2012 | 4119 | 부천시 | 16005 | 8041 | 7964 | 3773 | 20180315 |
5 | 2012 | 4121 | 광명시 | 4444 | 2029 | 2415 | 1015 | 20180315 |
6 | 2012 | 4122 | 평택시 | 13032 | 8019 | 5013 | 2785 | 20180315 |
7 | 2012 | 4125 | 동두천시 | 2491 | 1239 | 1252 | 893 | 20180315 |
8 | 2012 | 4127 | 안산시 | 43465 | 24995 | 18470 | 8151 | 20180315 |
9 | 2012 | 4128 | 고양시 | 11304 | 5558 | 5746 | 2686 | 20180315 |
년도 | 시군코드 | 시군명 | 등록외국인수 | 등록외국인남자수 | 등록외국인여자수 | 등록외국인여자2030수 | 생성일자 | |
---|---|---|---|---|---|---|---|---|
176 | 2016 | 4155 | 안성시 | 9851 | 6474 | 3377 | 1777 | 20190131 |
177 | 2016 | 4157 | 김포시 | 17835 | 14142 | 3693 | 1773 | 20190131 |
178 | 2016 | 4159 | 화성시 | 34685 | 25587 | 9098 | 5024 | 20190131 |
179 | 2016 | 4161 | 광주시 | 12114 | 8353 | 3761 | 1966 | 20190131 |
180 | 2016 | 4163 | 양주시 | 7298 | 5636 | 1662 | 910 | 20190131 |
181 | 2016 | 4165 | 포천시 | 12549 | 9766 | 2783 | 1729 | 20190131 |
182 | 2016 | 4167 | 여주시 | 3065 | 1923 | 1142 | 738 | 20190131 |
183 | 2016 | 4180 | 연천군 | 979 | 690 | 289 | 162 | 20190131 |
184 | 2016 | 4182 | 가평군 | 1069 | 458 | 611 | 262 | 20190131 |
185 | 2016 | 4183 | 양평군 | 1513 | 692 | 821 | 539 | 20190131 |