gimi9 Pandas Profiling

Dataset statistics

Number of variables	14
Number of observations	114
Missing cells	343
Missing cells (%)	21.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	14.0 KiB
Average record size in memory	126.2 B

Variable types

Categorical	1
Numeric	13

Dataset

Description	경기주택도시공사 민원정보
Author	경기주택도시공사
URL	https://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=8OAAUJCSIZW3HDER62Q630746610&infSeq=1

Alerts

`년도` is highly overall correlated with `5월` and 2 other fields	High correlation
`1월` is highly overall correlated with `2월` and 10 other fields	High correlation
`2월` is highly overall correlated with `1월` and 10 other fields	High correlation
`3월` is highly overall correlated with `1월` and 10 other fields	High correlation
`4월` is highly overall correlated with `1월` and 10 other fields	High correlation
`5월` is highly overall correlated with `년도` and 11 other fields	High correlation
`6월` is highly overall correlated with `년도` and 11 other fields	High correlation
`7월` is highly overall correlated with `1월` and 10 other fields	High correlation
`8월` is highly overall correlated with `1월` and 10 other fields	High correlation
`9월` is highly overall correlated with `1월` and 10 other fields	High correlation
`10월` is highly overall correlated with `1월` and 10 other fields	High correlation
`11월` is highly overall correlated with `년도` and 11 other fields	High correlation
`12월` is highly overall correlated with `1월` and 10 other fields	High correlation
`1월` has 21 (18.4%) missing values	Missing
`2월` has 25 (21.9%) missing values	Missing
`3월` has 33 (28.9%) missing values	Missing
`4월` has 35 (30.7%) missing values	Missing
`5월` has 36 (31.6%) missing values	Missing
`6월` has 34 (29.8%) missing values	Missing
`7월` has 30 (26.3%) missing values	Missing
`8월` has 29 (25.4%) missing values	Missing
`9월` has 29 (25.4%) missing values	Missing
`10월` has 22 (19.3%) missing values	Missing
`11월` has 23 (20.2%) missing values	Missing
`12월` has 26 (22.8%) missing values	Missing
`1월` has 26 (22.8%) zeros	Zeros
`2월` has 21 (18.4%) zeros	Zeros
`3월` has 17 (14.9%) zeros	Zeros
`4월` has 19 (16.7%) zeros	Zeros
`5월` has 17 (14.9%) zeros	Zeros
`6월` has 14 (12.3%) zeros	Zeros
`7월` has 13 (11.4%) zeros	Zeros
`8월` has 19 (16.7%) zeros	Zeros
`9월` has 16 (14.0%) zeros	Zeros
`10월` has 21 (18.4%) zeros	Zeros
`11월` has 27 (23.7%) zeros	Zeros
`12월` has 22 (19.3%) zeros	Zeros

Reproduction

Analysis started	2024-03-23 01:31:24.813238
Analysis finished	2024-03-23 01:32:15.503441
Duration	50.69 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

민원구분
Categorical

Distinct	23
Distinct (%)	20.2%
Missing	0
Missing (%)	0.0%
Memory size	1.0 KiB

광교택지	9
동탄택지	9
다산택지	9
기타	9
고양택지	8
Other values (18)	70

Length

Max length	5
Median length	4
Mean length	3.8684211
Min length	2

Unique

Unique	3 ?
Unique (%)	2.6%

Sample

1st row	위례주택
2nd row	동탄택지
3rd row	광교택지
4th row	따복하우스
5th row	주거복지

Common Values

Value	Count	Frequency (%)
광교택지	9	7.9%
동탄택지	9	7.9%
다산택지	9	7.9%
기타	9	7.9%
고양택지	8	7.0%
행복주택	7	6.1%
고덕택지	7	6.1%
다산주택	6	5.3%
산업단지	5	4.4%
동탄주택	5	4.4%
Other values (13)	40	35.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
광교택지	9	7.9%
다산택지	9	7.9%
기타	9	7.9%
동탄택지	9	7.9%
고양택지	8	7.0%
행복주택	7	6.1%
고덕택지	7	6.1%
다산주택	6	5.3%
분양주택	5	4.4%
임대주택	5	4.4%
Other values (13)	40	35.1%

년도
Real number (ℝ)

HIGH CORRELATION

Distinct	9
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2020.0702

Minimum	2016
Maximum	2024
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 KiB

Quantile statistics

Minimum	2016
5-th percentile	2016
Q1	2018
median	2020
Q3	2022
95-th percentile	2024
Maximum	2024
Range	8
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.4664808
Coefficient of variation (CV)	0.0012209877
Kurtosis	-1.1549511
Mean	2020.0702
Median Absolute Deviation (MAD)	2
Skewness	0.025955393
Sum	230288
Variance	6.0835274
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
2021	16	14.0%
2017	14	12.3%
2019	14	12.3%
2018	14	12.3%
2024	12	10.5%
2023	12	10.5%
2022	12	10.5%
2020	12	10.5%
2016	8	7.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2016	8	7.0%
2017	14	12.3%
2018	14	12.3%
2019	14	12.3%
2020	12	10.5%
2021	16	14.0%
2022	12	10.5%
2023	12	10.5%
2024	12	10.5%

Value	Count	Frequency (%)
2024	12	10.5%
2023	12	10.5%
2022	12	10.5%
2021	16	14.0%
2020	12	10.5%
2019	14	12.3%
2018	14	12.3%
2017	14	12.3%
2016	8	7.0%

1월
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	34
Distinct (%)	36.6%
Missing	21
Missing (%)	18.4%
Infinite	0
Infinite (%)	0.0%
Mean	26.72043

Minimum	0
Maximum	1028
Zeros	26
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	1.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3
Q3	17
95-th percentile	69
Maximum	1028
Range	1028
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	109.16654
Coefficient of variation (CV)	4.0855084
Kurtosis	79.094737
Mean	26.72043
Median Absolute Deviation (MAD)	3
Skewness	8.621406
Sum	2485
Variance	11917.334
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
0	26	22.8%
1	9	7.9%
3	7	6.1%
2	6	5.3%
7	4	3.5%
4	4	3.5%
12	3	2.6%
17	2	1.8%
15	2	1.8%
11	2	1.8%
Other values (24)	28	24.6%
(Missing)	21	18.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	26	22.8%
1	9	7.9%
2	6	5.3%
3	7	6.1%
4	4	3.5%
5	1	0.9%
6	2	1.8%
7	4	3.5%
9	1	0.9%
11	2	1.8%

Value	Count	Frequency (%)
1028	1	0.9%
197	1	0.9%
129	1	0.9%
107	1	0.9%
72	1	0.9%
67	1	0.9%
63	1	0.9%
58	2	1.8%
55	1	0.9%
45	1	0.9%

2월
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	37
Distinct (%)	41.6%
Missing	25
Missing (%)	21.9%
Infinite	0
Infinite (%)	0.0%
Mean	25.438202

Minimum	0
Maximum	679
Zeros	21
Zeros (%)	18.4%
Negative	0
Negative (%)	0.0%
Memory size	1.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	18
95-th percentile	68.8
Maximum	679
Range	679
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	88.326352
Coefficient of variation (CV)	3.4721932
Kurtosis	42.064903
Mean	25.438202
Median Absolute Deviation (MAD)	3
Skewness	6.318679
Sum	2264
Variance	7801.5444
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
0	21	18.4%
1	12	10.5%
2	8	7.0%
3	4	3.5%
6	3	2.6%
4	3	2.6%
5	3	2.6%
9	3	2.6%
19	2	1.8%
15	2	1.8%
Other values (27)	28	24.6%
(Missing)	25	21.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	21	18.4%
1	12	10.5%
2	8	7.0%
3	4	3.5%
4	3	2.6%
5	3	2.6%
6	3	2.6%
7	1	0.9%
9	3	2.6%
10	1	0.9%

Value	Count	Frequency (%)
679	1	0.9%
482	1	0.9%
104	1	0.9%
88	1	0.9%
74	1	0.9%
61	1	0.9%
60	1	0.9%
58	1	0.9%
51	1	0.9%
48	1	0.9%

3월
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	33
Distinct (%)	40.7%
Missing	33
Missing (%)	28.9%
Infinite	0
Infinite (%)	0.0%
Mean	162.53086

Minimum	0
Maximum	11157
Zeros	17
Zeros (%)	14.9%
Negative	0
Negative (%)	0.0%
Memory size	1.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	5
Q3	16
95-th percentile	187
Maximum	11157
Range	11157
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	1238.4366
Coefficient of variation (CV)	7.6197009
Kurtosis	80.577407
Mean	162.53086
Median Absolute Deviation (MAD)	5
Skewness	8.9657523
Sum	13165
Variance	1533725.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
0	17	14.9%
1	9	7.9%
2	5	4.4%
3	4	3.5%
4	4	3.5%
5	4	3.5%
7	3	2.6%
8	3	2.6%
6	3	2.6%
23	3	2.6%
Other values (23)	26	22.8%
(Missing)	33	28.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	17	14.9%
1	9	7.9%
2	5	4.4%
3	4	3.5%
4	4	3.5%
5	4	3.5%
6	3	2.6%
7	3	2.6%
8	3	2.6%
9	1	0.9%

Value	Count	Frequency (%)
11157	1	0.9%
423	1	0.9%
230	1	0.9%
194	1	0.9%
187	1	0.9%
116	1	0.9%
108	1	0.9%
89	1	0.9%
80	1	0.9%
69	1	0.9%

4월
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	29
Distinct (%)	36.7%
Missing	35
Missing (%)	30.7%
Infinite	0
Infinite (%)	0.0%
Mean	56.151899

Minimum	0
Maximum	1573
Zeros	19
Zeros (%)	16.7%
Negative	0
Negative (%)	0.0%
Memory size	1.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	17.5
95-th percentile	195.4
Maximum	1573
Range	1573
Interquartile range (IQR)	16.5

Descriptive statistics

Standard deviation	223.20274
Coefficient of variation (CV)	3.9749812
Kurtosis	32.121239
Mean	56.151899
Median Absolute Deviation (MAD)	3
Skewness	5.5107074
Sum	4436
Variance	49819.464
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
0	19	16.7%
1	8	7.0%
2	7	6.1%
3	6	5.3%
4	4	3.5%
6	4	3.5%
19	3	2.6%
16	3	2.6%
10	3	2.6%
23	2	1.8%
Other values (19)	20	17.5%
(Missing)	35	30.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19	16.7%
1	8	7.0%
2	7	6.1%
3	6	5.3%
4	4	3.5%
6	4	3.5%
9	2	1.8%
10	3	2.6%
11	1	0.9%
12	1	0.9%

Value	Count	Frequency (%)
1573	1	0.9%
999	1	0.9%
750	1	0.9%
199	1	0.9%
195	1	0.9%
64	1	0.9%
58	1	0.9%
57	1	0.9%
48	1	0.9%
38	1	0.9%

5월
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	34
Distinct (%)	43.6%
Missing	36
Missing (%)	31.6%
Infinite	0
Infinite (%)	0.0%
Mean	73.74359

Minimum	0
Maximum	1947
Zeros	17
Zeros (%)	14.9%
Negative	0
Negative (%)	0.0%
Memory size	1.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	6
Q3	14.75
95-th percentile	275.9
Maximum	1947
Range	1947
Interquartile range (IQR)	13.75

Descriptive statistics

Standard deviation	261.67232
Coefficient of variation (CV)	3.5484076
Kurtosis	36.181738
Mean	73.74359
Median Absolute Deviation (MAD)	6
Skewness	5.6533177
Sum	5752
Variance	68472.401
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
0	17	14.9%
1	9	7.9%
6	5	4.4%
2	4	3.5%
14	4	3.5%
4	4	3.5%
10	3	2.6%
32	2	1.8%
9	2	1.8%
11	2	1.8%
Other values (24)	26	22.8%
(Missing)	36	31.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	17	14.9%
1	9	7.9%
2	4	3.5%
3	2	1.8%
4	4	3.5%
5	1	0.9%
6	5	4.4%
7	2	1.8%
8	1	0.9%
9	2	1.8%

Value	Count	Frequency (%)
1947	1	0.9%
904	1	0.9%
828	1	0.9%
366	1	0.9%
260	1	0.9%
246	1	0.9%
244	1	0.9%
231	1	0.9%
87	1	0.9%
86	1	0.9%

6월
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	36
Distinct (%)	45.0%
Missing	34
Missing (%)	29.8%
Infinite	0
Infinite (%)	0.0%
Mean	519.3875

Minimum	0
Maximum	23543
Zeros	14
Zeros (%)	12.3%
Negative	0
Negative (%)	0.0%
Memory size	1.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	5.5
Q3	28
95-th percentile	519.1
Maximum	23543
Range	23543
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	2897.8079
Coefficient of variation (CV)	5.5792792
Kurtosis	53.503548
Mean	519.3875
Median Absolute Deviation (MAD)	5.5
Skewness	7.1038223
Sum	41551
Variance	8397290.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
0	14	12.3%
1	10	8.8%
3	6	5.3%
2	5	4.4%
5	3	2.6%
19	3	2.6%
9	3	2.6%
35	2	1.8%
18	2	1.8%
6	2	1.8%
Other values (26)	30	26.3%
(Missing)	34	29.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14	12.3%
1	10	8.8%
2	5	4.4%
3	6	5.3%
4	2	1.8%
5	3	2.6%
6	2	1.8%
7	1	0.9%
8	1	0.9%
9	3	2.6%

Value	Count	Frequency (%)
23543	1	0.9%
10823	1	0.9%
3467	1	0.9%
825	1	0.9%
503	1	0.9%
479	1	0.9%
356	1	0.9%
342	1	0.9%
280	1	0.9%
168	1	0.9%

7월
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	36
Distinct (%)	42.9%
Missing	30
Missing (%)	26.3%
Infinite	0
Infinite (%)	0.0%
Mean	84.678571

Minimum	0
Maximum	1688
Zeros	13
Zeros (%)	11.4%
Negative	0
Negative (%)	0.0%
Memory size	1.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	4.5
Q3	20.25
95-th percentile	504.45
Maximum	1688
Range	1688
Interquartile range (IQR)	19.25

Descriptive statistics

Standard deviation	268.84475
Coefficient of variation (CV)	3.1748852
Kurtosis	20.504542
Mean	84.678571
Median Absolute Deviation (MAD)	4.5
Skewness	4.3977878
Sum	7113
Variance	72277.498
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
0	13	11.4%
1	12	10.5%
2	9	7.9%
4	5	4.4%
8	4	3.5%
21	3	2.6%
3	3	2.6%
7	2	1.8%
10	2	1.8%
5	2	1.8%
Other values (26)	29	25.4%
(Missing)	30	26.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	13	11.4%
1	12	10.5%
2	9	7.9%
3	3	2.6%
4	5	4.4%
5	2	1.8%
6	2	1.8%
7	2	1.8%
8	4	3.5%
9	2	1.8%

Value	Count	Frequency (%)
1688	1	0.9%
1195	1	0.9%
1145	1	0.9%
621	1	0.9%
537	1	0.9%
320	1	0.9%
285	1	0.9%
282	1	0.9%
149	1	0.9%
143	1	0.9%

8월
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	35
Distinct (%)	41.2%
Missing	29
Missing (%)	25.4%
Infinite	0
Infinite (%)	0.0%
Mean	64.952941

Minimum	0
Maximum	1577
Zeros	19
Zeros (%)	16.7%
Negative	0
Negative (%)	0.0%
Memory size	1.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	4
Q3	13
95-th percentile	282.8
Maximum	1577
Range	1577
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	236.65913
Coefficient of variation (CV)	3.6435476
Kurtosis	30.603046
Mean	64.952941
Median Absolute Deviation (MAD)	4
Skewness	5.3885896
Sum	5521
Variance	56007.545
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
0	19	16.7%
2	9	7.9%
1	7	6.1%
5	7	6.1%
3	5	4.4%
4	4	3.5%
9	3	2.6%
8	2	1.8%
6	2	1.8%
7	2	1.8%
Other values (25)	25	21.9%
(Missing)	29	25.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19	16.7%
1	7	6.1%
2	9	7.9%
3	5	4.4%
4	4	3.5%
5	7	6.1%
6	2	1.8%
7	2	1.8%
8	2	1.8%
9	3	2.6%

Value	Count	Frequency (%)
1577	1	0.9%
1380	1	0.9%
477	1	0.9%
435	1	0.9%
293	1	0.9%
242	1	0.9%
231	1	0.9%
143	1	0.9%
110	1	0.9%
103	1	0.9%

9월
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	33
Distinct (%)	38.8%
Missing	29
Missing (%)	25.4%
Infinite	0
Infinite (%)	0.0%
Mean	107.30588

Minimum	0
Maximum	2969
Zeros	16
Zeros (%)	14.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	4
Q3	15
95-th percentile	563
Maximum	2969
Range	2969
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	401.17028
Coefficient of variation (CV)	3.7385675
Kurtosis	33.350902
Mean	107.30588
Median Absolute Deviation (MAD)	4
Skewness	5.4331408
Sum	9121
Variance	160937.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
0	16	14.0%
1	11	9.6%
3	8	7.0%
2	7	6.1%
5	5	4.4%
11	4	3.5%
4	3	2.6%
15	3	2.6%
27	2	1.8%
9	2	1.8%
Other values (23)	24	21.1%
(Missing)	29	25.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	16	14.0%
1	11	9.6%
2	7	6.1%
3	8	7.0%
4	3	2.6%
5	5	4.4%
6	2	1.8%
7	1	0.9%
8	1	0.9%
9	2	1.8%

Value	Count	Frequency (%)
2969	1	0.9%
1509	1	0.9%
1342	1	0.9%
959	1	0.9%
624	1	0.9%
319	1	0.9%
318	1	0.9%
231	1	0.9%
114	1	0.9%
74	1	0.9%

10월
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	35
Distinct (%)	38.0%
Missing	22
Missing (%)	19.3%
Infinite	0
Infinite (%)	0.0%
Mean	105.1087

Minimum	0
Maximum	4470
Zeros	21
Zeros (%)	18.4%
Negative	0
Negative (%)	0.0%
Memory size	1.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	5
Q3	16
95-th percentile	127.6
Maximum	4470
Range	4470
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	569.81592
Coefficient of variation (CV)	5.4212063
Kurtosis	47.074946
Mean	105.1087
Median Absolute Deviation (MAD)	5
Skewness	6.793447
Sum	9670
Variance	324690.19
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
0	21	18.4%
1	8	7.0%
2	8	7.0%
5	6	5.3%
7	4	3.5%
3	4	3.5%
9	3	2.6%
10	3	2.6%
28	2	1.8%
15	2	1.8%
Other values (25)	31	27.2%
(Missing)	22	19.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	21	18.4%
1	8	7.0%
2	8	7.0%
3	4	3.5%
4	2	1.8%
5	6	5.3%
6	1	0.9%
7	4	3.5%
8	2	1.8%
9	3	2.6%

Value	Count	Frequency (%)
4470	1	0.9%
3164	1	0.9%
674	1	0.9%
226	1	0.9%
132	1	0.9%
124	1	0.9%
118	1	0.9%
67	1	0.9%
42	1	0.9%
38	1	0.9%

11월
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	39
Distinct (%)	42.9%
Missing	23
Missing (%)	20.2%
Infinite	0
Infinite (%)	0.0%
Mean	90.296703

Minimum	0
Maximum	2664
Zeros	27
Zeros (%)	23.7%
Negative	0
Negative (%)	0.0%
Memory size	1.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	7
Q3	26
95-th percentile	347.5
Maximum	2664
Range	2664
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	344.4792
Coefficient of variation (CV)	3.8149699
Kurtosis	38.229108
Mean	90.296703
Median Absolute Deviation (MAD)	7
Skewness	5.8519672
Sum	8217
Variance	118665.92
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
0	27	23.7%
7	6	5.3%
1	5	4.4%
4	4	3.5%
2	4	3.5%
8	4	3.5%
11	3	2.6%
3	3	2.6%
68	2	1.8%
13	2	1.8%
Other values (29)	31	27.2%
(Missing)	23	20.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	27	23.7%
1	5	4.4%
2	4	3.5%
3	3	2.6%
4	4	3.5%
5	1	0.9%
6	1	0.9%
7	6	5.3%
8	4	3.5%
9	1	0.9%

Value	Count	Frequency (%)
2664	1	0.9%
1527	1	0.9%
946	1	0.9%
840	1	0.9%
358	1	0.9%
337	1	0.9%
263	1	0.9%
140	1	0.9%
139	1	0.9%
101	1	0.9%

12월
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	34
Distinct (%)	38.6%
Missing	26
Missing (%)	22.8%
Infinite	0
Infinite (%)	0.0%
Mean	58.852273

Minimum	0
Maximum	3243
Zeros	22
Zeros (%)	19.3%
Negative	0
Negative (%)	0.0%
Memory size	1.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.75
median	4
Q3	18
95-th percentile	99.35
Maximum	3243
Range	3243
Interquartile range (IQR)	17.25

Descriptive statistics

Standard deviation	349.81107
Coefficient of variation (CV)	5.9438837
Kurtosis	81.486922
Mean	58.852273
Median Absolute Deviation (MAD)	4
Skewness	8.9023486
Sum	5179
Variance	122367.78
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
0	22	19.3%
1	9	7.9%
2	8	7.0%
4	7	6.1%
3	3	2.6%
18	3	2.6%
12	3	2.6%
22	2	1.8%
9	2	1.8%
47	2	1.8%
Other values (24)	27	23.7%
(Missing)	26	22.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	22	19.3%
1	9	7.9%
2	8	7.0%
3	3	2.6%
4	7	6.1%
5	1	0.9%
6	2	1.8%
7	1	0.9%
8	2	1.8%
9	2	1.8%

Value	Count	Frequency (%)
3243	1	0.9%
554	1	0.9%
223	1	0.9%
186	1	0.9%
106	1	0.9%
87	1	0.9%
71	1	0.9%
48	1	0.9%
47	2	1.8%
40	1	0.9%

Phik (φk)
Auto

Heatmap
Table

	민원구분	년도	1월	2월	3월	4월	5월	6월	7월	8월	9월	10월	11월	12월
민원구분	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.206	0.000	0.000	0.000	0.000	0.000	0.000
년도	0.000	1.000	0.315	0.198	0.000	0.208	0.316	0.160	0.324	0.226	0.296	0.316	0.127	0.153
1월	0.000	0.315	1.000	0.694	0.000	0.826	0.331	0.000	0.000	0.000	0.994	0.717	0.412	0.000
2월	0.000	0.198	0.694	1.000	1.000	0.790	0.687	0.881	0.457	0.487	0.822	0.368	0.294	0.000
3월	0.000	0.000	0.000	1.000	1.000	0.000	0.000	1.000	0.442	0.441	0.000	0.000	0.000	0.000
4월	0.000	0.208	0.826	0.790	0.000	1.000	0.681	0.616	0.843	0.624	0.828	0.703	0.907	1.000
5월	0.000	0.316	0.331	0.687	0.000	0.681	1.000	0.722	0.456	0.341	0.583	0.405	0.501	0.881
6월	0.206	0.160	0.000	0.881	1.000	0.616	0.722	1.000	0.643	0.334	0.000	0.000	0.000	1.000
7월	0.000	0.324	0.000	0.457	0.442	0.843	0.456	0.643	1.000	0.941	0.696	0.790	0.632	0.565
8월	0.000	0.226	0.000	0.487	0.441	0.624	0.341	0.334	0.941	1.000	0.846	0.915	0.711	0.000
9월	0.000	0.296	0.994	0.822	0.000	0.828	0.583	0.000	0.696	0.846	1.000	1.000	0.717	0.000
10월	0.000	0.316	0.717	0.368	0.000	0.703	0.405	0.000	0.790	0.915	1.000	1.000	0.744	0.000
11월	0.000	0.127	0.412	0.294	0.000	0.907	0.501	0.000	0.632	0.711	0.717	0.744	1.000	0.521
12월	0.000	0.153	0.000	0.000	0.000	1.000	0.881	1.000	0.565	0.000	0.000	0.000	0.521	1.000

Heatmap
Table

	년도	1월	2월	3월	4월	5월	6월	7월	8월	9월	10월	11월	12월	민원구분
년도	1.000	-0.456	-0.481	-0.433	-0.442	-0.511	-0.602	-0.471	-0.429	-0.442	-0.495	-0.517	-0.410	0.000
1월	-0.456	1.000	0.833	0.807	0.859	0.836	0.793	0.794	0.757	0.820	0.808	0.780	0.619	0.000
2월	-0.481	0.833	1.000	0.867	0.865	0.791	0.793	0.794	0.800	0.806	0.791	0.793	0.570	0.000
3월	-0.433	0.807	0.867	1.000	0.889	0.836	0.780	0.802	0.800	0.763	0.792	0.767	0.571	0.000
4월	-0.442	0.859	0.865	0.889	1.000	0.907	0.798	0.814	0.828	0.785	0.814	0.822	0.686	0.000
5월	-0.511	0.836	0.791	0.836	0.907	1.000	0.793	0.824	0.816	0.787	0.841	0.801	0.703	0.000
6월	-0.602	0.793	0.793	0.780	0.798	0.793	1.000	0.848	0.849	0.825	0.870	0.815	0.688	0.078
7월	-0.471	0.794	0.794	0.802	0.814	0.824	0.848	1.000	0.832	0.792	0.821	0.788	0.675	0.000
8월	-0.429	0.757	0.800	0.800	0.828	0.816	0.849	0.832	1.000	0.859	0.830	0.785	0.661	0.000
9월	-0.442	0.820	0.806	0.763	0.785	0.787	0.825	0.792	0.859	1.000	0.911	0.823	0.700	0.000
10월	-0.495	0.808	0.791	0.792	0.814	0.841	0.870	0.821	0.830	0.911	1.000	0.868	0.715	0.000
11월	-0.517	0.780	0.793	0.767	0.822	0.801	0.815	0.788	0.785	0.823	0.868	1.000	0.749	0.000
12월	-0.410	0.619	0.570	0.571	0.686	0.703	0.688	0.675	0.661	0.700	0.715	0.749	1.000	0.000
민원구분	0.000	0.000	0.000	0.000	0.000	0.000	0.078	0.000	0.000	0.000	0.000	0.000	0.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	민원구분	년도	1월	2월	3월	4월	5월	6월	7월	8월	9월	10월	11월	12월
0	위례주택	2017	17	3	5	6	244	356	30	1380	1509	3164	4	47
1	동탄택지	2017	36	27	69	32	32	44	282	435	63	42	358	47
2	광교택지	2017	107	19	16	25	8	11	18	9	624	9	68	4
3	따복하우스	2017	42	21	23	23	56	13	6	4	3	5	8	2
4	주거복지	2017	4	3	7	3	7	<NA>	9	2	5	<NA>	4	3
5	고덕택지	2017	3	<NA>	2	1	<NA>	3	3	3	1	<NA>	2	1
6	광교주택	2017	3	<NA>	2	<NA>	1	3	2	<NA>	<NA>	<NA>	<NA>	<NA>
7	산업단지	2017	<NA>	<NA>	<NA>	1	2	<NA>	4	1	1	<NA>	<NA>	<NA>
8	고덕주택	2017	<NA>	2	3	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>
9	동탄주택	2017	<NA>	<NA>	<NA>	2	1	<NA>	<NA>	<NA>	<NA>	<NA>	1	<NA>

	민원구분	년도	1월	2월	3월	4월	5월	6월	7월	8월	9월	10월	11월	12월
104	고덕택지	2018	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	2	3	<NA>
105	고덕주택	2018	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	14	<NA>	<NA>
106	고양택지	2018	1	<NA>	1	3	<NA>	<NA>	1	<NA>	3	1	3	3
107	행복주택	2018	<NA>	<NA>	<NA>	19	19	19	1	8	4	1	7	2
108	주거복지	2018	11	11	18	19	12	9	8	5	4	3	6	8
109	산업단지	2018	<NA>	<NA>	<NA>	<NA>	1	3	<NA>	1	<NA>	3	<NA>	<NA>
110	기타	2018	11	17	6	3	10	14	9	6	15	15	11	1
111	다산택지	2017	1028	482	230	999	260	503	149	110	959	31	39	34
112	고양택지	2017	<NA>	<NA>	<NA>	<NA>	<NA>	76	1145	1577	1342	674	946	<NA>
113	다산주택	2017	197	74	116	750	231	825	320	77	2969	4470	1527	9

Overview

Variables

Common Values

Length

Interactions

Correlations

Missing values

Sample