Dataset statistics
Number of variables | 8 |
---|---|
Number of observations | 620 |
Missing cells | 357 |
Missing cells (%) | 7.2% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 42.5 KiB |
Average record size in memory | 70.2 B |
Variable types
Numeric | 6 |
---|---|
Categorical | 2 |
Dataset
Description | 경기도 불법광고물 단속 현황 |
---|---|
Author | 경기도 |
URL | https://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=IMORMEV8I72COW1QUIX118785722&infSeq=1 |
현수막수(개) is highly overall correlated with 벽보수(개) | High correlation |
벽보수(개) is highly overall correlated with 현수막수(개) and 1 other fields | High correlation |
전단수(개) is highly overall correlated with 벽보수(개) | High correlation |
입간판수(개) has 44 (7.1%) missing values | Missing |
벽보수(개) has 10 (1.6%) missing values | Missing |
전단수(개) has 41 (6.6%) missing values | Missing |
기타수(개) has 261 (42.1%) missing values | Missing |
입간판수(개) has 30 (4.8%) zeros | Zeros |
전단수(개) has 11 (1.8%) zeros | Zeros |
기타수(개) has 55 (8.9%) zeros | Zeros |
Reproduction
Analysis started | 2024-04-29 13:20:37.262945 |
---|---|
Analysis finished | 2024-04-29 13:20:42.826853 |
Duration | 5.56 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
집계년도
Real number (ℝ)
Distinct | 7 |
---|---|
Distinct (%) | 1.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2019.4 |
Minimum | 2017 |
---|---|
Maximum | 2023 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 5.6 KiB |
Quantile statistics
Minimum | 2017 |
---|---|
5-th percentile | 2017 |
Q1 | 2018 |
median | 2019 |
Q3 | 2021 |
95-th percentile | 2023 |
Maximum | 2023 |
Range | 6 |
Interquartile range (IQR) | 3 |
Descriptive statistics
Standard deviation | 1.961174 |
---|---|
Coefficient of variation (CV) | 0.0009711667 |
Kurtosis | -1.001653 |
Mean | 2019.4 |
Median Absolute Deviation (MAD) | 1.5 |
Skewness | 0.46998547 |
Sum | 1252028 |
Variance | 3.8462036 |
Monotonicity | Decreasing |
Value | Count | Frequency (%) |
2019 | 124 | |
2018 | 124 | |
2017 | 124 | |
2023 | 62 | |
2022 | 62 | |
2021 | 62 | |
2020 | 62 |
Value | Count | Frequency (%) |
2017 | 124 | |
2018 | 124 | |
2019 | 124 | |
2020 | 62 | |
2021 | 62 | |
2022 | 62 | |
2023 | 62 |
Value | Count | Frequency (%) |
2023 | 62 | |
2022 | 62 | |
2021 | 62 | |
2020 | 62 | |
2019 | 124 | |
2018 | 124 | |
2017 | 124 |
집계분기
Categorical
Distinct | 6 |
---|---|
Distinct (%) | 1.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 5.0 KiB |
2분기 | |
---|---|
1분기 | |
하반기 | |
상반기 | |
4분기 |
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 3 |
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 (%) |
2분기 | 124 | |
1분기 | 124 | |
하반기 | 93 | |
상반기 | 93 | |
4분기 | 93 | |
3분기 | 93 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2분기 | 124 | |
1분기 | 124 | |
하반기 | 93 | |
상반기 | 93 | |
4분기 | 93 | |
3분기 | 93 |
시군명
Categorical
Distinct | 31 |
---|---|
Distinct (%) | 5.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 5.0 KiB |
가평군 | 20 |
---|---|
고양시 | 20 |
과천시 | 20 |
광명시 | 20 |
광주시 | 20 |
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 (%) |
가평군 | 20 | 3.2% |
고양시 | 20 | 3.2% |
과천시 | 20 | 3.2% |
광명시 | 20 | 3.2% |
광주시 | 20 | 3.2% |
구리시 | 20 | 3.2% |
군포시 | 20 | 3.2% |
김포시 | 20 | 3.2% |
남양주시 | 20 | 3.2% |
동두천시 | 20 | 3.2% |
Other values (21) | 420 |
Length
Value | Count | Frequency (%) |
가평군 | 20 | 3.2% |
안양시 | 20 | 3.2% |
하남시 | 20 | 3.2% |
포천시 | 20 | 3.2% |
평택시 | 20 | 3.2% |
파주시 | 20 | 3.2% |
이천시 | 20 | 3.2% |
의정부시 | 20 | 3.2% |
의왕시 | 20 | 3.2% |
용인시 | 20 | 3.2% |
Other values (21) | 420 |
현수막수(개)
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 616 |
---|---|
Distinct (%) | 99.5% |
Missing | 1 |
Missing (%) | 0.2% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 39257.11 |
Minimum | 300 |
---|---|
Maximum | 434243 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 5.6 KiB |
Quantile statistics
Minimum | 300 |
---|---|
5-th percentile | 1399.3 |
Q1 | 6779 |
median | 22797 |
Q3 | 50374.5 |
95-th percentile | 130644 |
Maximum | 434243 |
Range | 433943 |
Interquartile range (IQR) | 43595.5 |
Descriptive statistics
Standard deviation | 51754.217 |
---|---|
Coefficient of variation (CV) | 1.31834 |
Kurtosis | 14.355193 |
Mean | 39257.11 |
Median Absolute Deviation (MAD) | 17947 |
Skewness | 3.1830075 |
Sum | 24300151 |
Variance | 2.678499 × 109 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
6952 | 2 | 0.3% |
4731 | 2 | 0.3% |
8900 | 2 | 0.3% |
5855 | 1 | 0.2% |
74341 | 1 | 0.2% |
3877 | 1 | 0.2% |
79676 | 1 | 0.2% |
45676 | 1 | 0.2% |
73642 | 1 | 0.2% |
34147 | 1 | 0.2% |
Other values (606) | 606 |
Value | Count | Frequency (%) |
300 | 1 | |
401 | 1 | |
510 | 1 | |
592 | 1 | |
600 | 1 | |
648 | 1 | |
650 | 1 | |
653 | 1 | |
723 | 1 | |
727 | 1 |
Value | Count | Frequency (%) |
434243 | 1 | |
389283 | 1 | |
331085 | 1 | |
297170 | 1 | |
285285 | 1 | |
284641 | 1 | |
284324 | 1 | |
269646 | 1 | |
264851 | 1 | |
224670 | 1 |
입간판수(개)
Real number (ℝ)
MISSING
  ZEROS
 
Distinct | 368 |
---|---|
Distinct (%) | 63.9% |
Missing | 44 |
Missing (%) | 7.1% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 7303.9531 |
Minimum | 0 |
---|---|
Maximum | 1414350 |
Zeros | 30 |
Zeros (%) | 4.8% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 5.6 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 22.75 |
median | 161.5 |
Q3 | 504 |
95-th percentile | 5137.5 |
Maximum | 1414350 |
Range | 1414350 |
Interquartile range (IQR) | 481.25 |
Descriptive statistics
Standard deviation | 68382.534 |
---|---|
Coefficient of variation (CV) | 9.3624005 |
Kurtosis | 320.00736 |
Mean | 7303.9531 |
Median Absolute Deviation (MAD) | 155.5 |
Skewness | 16.574375 |
Sum | 4207077 |
Variance | 4.676171 × 109 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 30 | 4.8% |
1 | 12 | 1.9% |
2 | 11 | 1.8% |
3 | 9 | 1.5% |
5 | 8 | 1.3% |
6 | 8 | 1.3% |
10 | 8 | 1.3% |
14 | 7 | 1.1% |
50 | 6 | 1.0% |
46 | 6 | 1.0% |
Other values (358) | 471 | |
(Missing) | 44 | 7.1% |
Value | Count | Frequency (%) |
0 | 30 | |
1 | 12 | 1.9% |
2 | 11 | 1.8% |
3 | 9 | 1.5% |
4 | 3 | 0.5% |
5 | 8 | 1.3% |
6 | 8 | 1.3% |
7 | 5 | 0.8% |
8 | 1 | 0.2% |
9 | 5 | 0.8% |
Value | Count | Frequency (%) |
1414350 | 1 | |
428596 | 1 | |
427010 | 1 | |
424589 | 1 | |
281757 | 1 | |
169793 | 1 | |
131792 | 1 | |
129471 | 1 | |
88294 | 1 | |
74554 | 1 |
벽보수(개)
Real number (ℝ)
HIGH CORRELATION
  MISSING
 
Distinct | 595 |
---|---|
Distinct (%) | 97.5% |
Missing | 10 |
Missing (%) | 1.6% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 172920.52 |
Minimum | 0 |
---|---|
Maximum | 4352241 |
Zeros | 6 |
Zeros (%) | 1.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 5.6 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 90.05 |
Q1 | 3723.25 |
median | 19353.5 |
Q3 | 89371.25 |
95-th percentile | 925988.9 |
Maximum | 4352241 |
Range | 4352241 |
Interquartile range (IQR) | 85648 |
Descriptive statistics
Standard deviation | 451614.08 |
---|---|
Coefficient of variation (CV) | 2.6116858 |
Kurtosis | 31.918797 |
Mean | 172920.52 |
Median Absolute Deviation (MAD) | 18707 |
Skewness | 5.0101897 |
Sum | 1.0548152 × 108 |
Variance | 2.0395527 × 1011 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 6 | 1.0% |
2 | 3 | 0.5% |
4675 | 2 | 0.3% |
47 | 2 | 0.3% |
38 | 2 | 0.3% |
291 | 2 | 0.3% |
72 | 2 | 0.3% |
40 | 2 | 0.3% |
267 | 2 | 0.3% |
10 | 2 | 0.3% |
Other values (585) | 585 | |
(Missing) | 10 | 1.6% |
Value | Count | Frequency (%) |
0 | 6 | |
2 | 3 | |
10 | 2 | 0.3% |
12 | 1 | 0.2% |
22 | 1 | 0.2% |
23 | 1 | 0.2% |
33 | 1 | 0.2% |
35 | 1 | 0.2% |
38 | 2 | 0.3% |
39 | 1 | 0.2% |
Value | Count | Frequency (%) |
4352241 | 1 | |
3838403 | 1 | |
3510859 | 1 | |
3450563 | 1 | |
2523476 | 1 | |
2386839 | 1 | |
2316388 | 1 | |
2256223 | 1 | |
2101239 | 1 | |
1720338 | 1 |
전단수(개)
Real number (ℝ)
HIGH CORRELATION
  MISSING
  ZEROS
 
Distinct | 556 |
---|---|
Distinct (%) | 96.0% |
Missing | 41 |
Missing (%) | 6.6% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 559084.75 |
Minimum | 0 |
---|---|
Maximum | 16349348 |
Zeros | 11 |
Zeros (%) | 1.8% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 5.6 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 29 |
Q1 | 4303 |
median | 34164 |
Q3 | 355840.5 |
95-th percentile | 3111543.7 |
Maximum | 16349348 |
Range | 16349348 |
Interquartile range (IQR) | 351537.5 |
Descriptive statistics
Standard deviation | 1369775.3 |
---|---|
Coefficient of variation (CV) | 2.4500315 |
Kurtosis | 38.680159 |
Mean | 559084.75 |
Median Absolute Deviation (MAD) | 33984 |
Skewness | 4.9839818 |
Sum | 3.2371007 × 108 |
Variance | 1.8762843 × 1012 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 11 | 1.8% |
20 | 4 | 0.6% |
9 | 3 | 0.5% |
40 | 3 | 0.5% |
180 | 2 | 0.3% |
10 | 2 | 0.3% |
30 | 2 | 0.3% |
194329 | 2 | 0.3% |
29 | 2 | 0.3% |
70 | 2 | 0.3% |
Other values (546) | 546 | |
(Missing) | 41 | 6.6% |
Value | Count | Frequency (%) |
0 | 11 | |
3 | 1 | 0.2% |
5 | 1 | 0.2% |
9 | 3 | 0.5% |
10 | 2 | 0.3% |
11 | 1 | 0.2% |
12 | 1 | 0.2% |
15 | 1 | 0.2% |
20 | 4 | 0.6% |
21 | 1 | 0.2% |
Value | Count | Frequency (%) |
16349348 | 1 | |
10502143 | 1 | |
7808926 | 1 | |
7289595 | 1 | |
5930171 | 1 | |
5737599 | 1 | |
5253057 | 1 | |
5204771 | 1 | |
5174784 | 1 | |
5027987 | 1 |
기타수(개)
Real number (ℝ)
MISSING
  ZEROS
 
Distinct | 257 |
---|---|
Distinct (%) | 71.6% |
Missing | 261 |
Missing (%) | 42.1% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 187348.64 |
Minimum | 0 |
---|---|
Maximum | 6849571 |
Zeros | 55 |
Zeros (%) | 8.9% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 5.6 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 13 |
median | 351 |
Q3 | 9493 |
95-th percentile | 871551.8 |
Maximum | 6849571 |
Range | 6849571 |
Interquartile range (IQR) | 9480 |
Descriptive statistics
Standard deviation | 668762.83 |
---|---|
Coefficient of variation (CV) | 3.5696168 |
Kurtosis | 37.450486 |
Mean | 187348.64 |
Median Absolute Deviation (MAD) | 351 |
Skewness | 5.4909857 |
Sum | 67258160 |
Variance | 4.4724373 × 1011 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 55 | 8.9% |
1 | 7 | 1.1% |
10 | 4 | 0.6% |
7 | 4 | 0.6% |
32 | 4 | 0.6% |
42 | 4 | 0.6% |
236 | 4 | 0.6% |
25 | 3 | 0.5% |
12 | 3 | 0.5% |
4 | 3 | 0.5% |
Other values (247) | 268 | |
(Missing) | 261 |
Value | Count | Frequency (%) |
0 | 55 | |
1 | 7 | 1.1% |
2 | 3 | 0.5% |
3 | 3 | 0.5% |
4 | 3 | 0.5% |
5 | 2 | 0.3% |
7 | 4 | 0.6% |
8 | 2 | 0.3% |
10 | 4 | 0.6% |
11 | 3 | 0.5% |
Value | Count | Frequency (%) |
6849571 | 1 | |
4103729 | 1 | |
3629282 | 1 | |
3433027 | 1 | |
3299269 | 1 | |
3250214 | 1 | |
2857732 | 1 | |
2810390 | 1 | |
2350428 | 1 | |
2262718 | 1 |
집계년도 | 집계분기 | 시군명 | 현수막수(개) | 입간판수(개) | 벽보수(개) | 전단수(개) | 기타수(개) | |
---|---|---|---|---|---|---|---|---|
집계년도 | 1.000 | 0.853 | 0.000 | 0.000 | NaN | 0.111 | 0.121 | 0.127 |
집계분기 | 0.853 | 1.000 | 0.000 | 0.170 | 0.119 | 0.162 | 0.117 | 0.000 |
시군명 | 0.000 | 0.000 | 1.000 | 0.624 | 0.000 | 0.509 | 0.576 | 0.568 |
현수막수(개) | 0.000 | 0.170 | 0.624 | 1.000 | 0.000 | 0.409 | 0.446 | 0.455 |
입간판수(개) | NaN | 0.119 | 0.000 | 0.000 | 1.000 | 0.806 | 0.000 | 0.000 |
벽보수(개) | 0.111 | 0.162 | 0.509 | 0.409 | 0.806 | 1.000 | 0.666 | 0.388 |
전단수(개) | 0.121 | 0.117 | 0.576 | 0.446 | 0.000 | 0.666 | 1.000 | 0.000 |
기타수(개) | 0.127 | 0.000 | 0.568 | 0.455 | 0.000 | 0.388 | 0.000 | 1.000 |
시군명 | 집계분기 | |
---|---|---|
시군명 | 1.000 | 0.000 |
집계분기 | 0.000 | 1.000 |
집계년도 | 현수막수(개) | 입간판수(개) | 벽보수(개) | 전단수(개) | 기타수(개) | 집계분기 | 시군명 | |
---|---|---|---|---|---|---|---|---|
집계년도 | 1.000 | -0.011 | -0.188 | 0.016 | 0.145 | -0.078 | 0.466 | 0.000 |
현수막수(개) | -0.011 | 1.000 | 0.492 | 0.553 | 0.406 | 0.254 | 0.090 | 0.268 |
입간판수(개) | -0.188 | 0.492 | 1.000 | 0.482 | 0.310 | 0.331 | 0.077 | 0.000 |
벽보수(개) | 0.016 | 0.553 | 0.482 | 1.000 | 0.654 | 0.222 | 0.081 | 0.212 |
전단수(개) | 0.145 | 0.406 | 0.310 | 0.654 | 1.000 | 0.322 | 0.070 | 0.276 |
기타수(개) | -0.078 | 0.254 | 0.331 | 0.222 | 0.322 | 1.000 | 0.000 | 0.267 |
집계분기 | 0.466 | 0.090 | 0.077 | 0.081 | 0.070 | 0.000 | 1.000 | 0.000 |
시군명 | 0.000 | 0.268 | 0.000 | 0.212 | 0.276 | 0.267 | 0.000 | 1.000 |
집계년도 | 집계분기 | 시군명 | 현수막수(개) | 입간판수(개) | 벽보수(개) | 전단수(개) | 기타수(개) | |
---|---|---|---|---|---|---|---|---|
0 | 2023 | 하반기 | 가평군 | 2216 | 0 | 75 | 0 | 0 |
1 | 2023 | 하반기 | 고양시 | 65134 | 404 | 51247 | 29825 | 140 |
2 | 2023 | 하반기 | 과천시 | 3413 | 0 | 5480 | 3125 | 0 |
3 | 2023 | 하반기 | 광명시 | 8058 | 11 | 1260104 | 878557 | 25 |
4 | 2023 | 하반기 | 광주시 | 9301 | 24 | 41804 | 4320 | 0 |
5 | 2023 | 하반기 | 구리시 | 10031 | 19 | 3720 | 1042739 | 352605 |
6 | 2023 | 하반기 | 군포시 | 8676 | 31 | 1258 | 18802 | 2027 |
7 | 2023 | 하반기 | 김포시 | 24029 | 50 | 57796 | 2633945 | 11925 |
8 | 2023 | 하반기 | 남양주시 | 74101 | 330 | 16316 | 26862 | 774 |
9 | 2023 | 하반기 | 동두천시 | 3155 | 21 | 18150 | 243710 | 8 |
집계년도 | 집계분기 | 시군명 | 현수막수(개) | 입간판수(개) | 벽보수(개) | 전단수(개) | 기타수(개) | |
---|---|---|---|---|---|---|---|---|
610 | 2017 | 1분기 | 오산시 | 57871 | 46920 | 29050 | 90 | <NA> |
611 | 2017 | 1분기 | 용인시 | 85158 | 131792 | 21120 | 3513 | 1190 |
612 | 2017 | 1분기 | 의왕시 | 5011 | 3763 | 64260 | 1212 | 4333 |
613 | 2017 | 1분기 | 의정부시 | 59203 | 428596 | 1383030 | 289 | 170 |
614 | 2017 | 1분기 | 이천시 | 3426 | 11932 | 48475 | 12 | <NA> |
615 | 2017 | 1분기 | 파주시 | 4022 | 54617 | 425460 | 270 | 86 |
616 | 2017 | 1분기 | 평택시 | 51292 | 6489 | 48765 | 367 | 1989 |
617 | 2017 | 1분기 | 포천시 | 8519 | 4501 | 59023 | <NA> | <NA> |
618 | 2017 | 1분기 | 하남시 | 17800 | 67626 | 71948 | 239 | <NA> |
619 | 2017 | 1분기 | 화성시 | 130224 | <NA> | 20255 | 421 | 1049488 |