gimi9 Pandas Profiling

Dataset statistics

Number of variables	17
Number of observations	632
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	3
Duplicate rows (%)	0.5%
Total size in memory	90.2 KiB
Average record size in memory	146.2 B

Variable types

Categorical	8
Numeric	9

Dataset

Description	경기주택도시공사 기금관리시스템의 기존주택 전세임대 권역별 센터정보로써 권역명, 전화번호, 권역주소 등의 정보를 포함하고 있습니다.
Author	경기주택도시공사
URL	https://www.data.go.kr/data/15119265/fileData.do

Alerts

Dataset has 3 (0.5%) duplicate rows	Duplicates
`약어` 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
`권역명` is highly overall correlated with `구분` and 3 other fields	High correlation
`사업연도` is highly overall correlated with `계획호수` and 5 other fields	High correlation
`관리지역 아이디` is highly overall correlated with `이율코드` and 4 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
`계약호수` is highly overall correlated with `사업연도` and 3 other fields	High correlation
`해약호수` is highly overall correlated with `계획호수` and 2 other fields	High correlation
`이율코드` is highly overall correlated with `사업연도` and 6 other fields	High correlation
`적용일` is highly overall correlated with `사업연도` and 7 other fields	High correlation
`적용이율` is highly overall correlated with `이율코드` and 3 other fields	High correlation
`구분` is highly overall correlated with `사업연도` and 10 other fields	High correlation
`공급지역` is highly overall correlated with `관리지역 아이디` and 2 other fields	High correlation
`절삭단위` is highly overall correlated with `관리지역 아이디` and 5 other fields	High correlation
`비고` is highly overall correlated with `이율코드` and 4 other fields	High correlation
`구분` is highly imbalanced (64.5%)	Imbalance
`절삭단위` is highly imbalanced (75.0%)	Imbalance
`비고` is highly imbalanced (83.8%)	Imbalance
`권역명` is highly imbalanced (96.7%)	Imbalance
`전화번호` is highly imbalanced (96.7%)	Imbalance
`약어` is highly imbalanced (96.7%)	Imbalance
`권역주소(담당 법무법인)` is highly imbalanced (97.1%)	Imbalance
`사업연도` has 74 (11.7%) zeros	Zeros
`관리지역 아이디` has 74 (11.7%) zeros	Zeros
`계획호수` has 344 (54.4%) zeros	Zeros
`지원호수` has 308 (48.7%) zeros	Zeros
`계약호수` has 323 (51.1%) zeros	Zeros
`해약호수` has 386 (61.1%) zeros	Zeros
`이율코드` has 563 (89.1%) zeros	Zeros
`적용일` has 563 (89.1%) zeros	Zeros
`적용이율` has 577 (91.3%) zeros	Zeros

Reproduction

Analysis started	2024-04-17 16:49:44.086401
Analysis finished	2024-04-17 16:49:52.005356
Duration	7.92 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

구분
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	5.1 KiB

연도별 공급지역	558
이율관리	69
센터관리	5

Length

Max length	8
Median length	8
Mean length	7.5316456
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	연도별 공급지역
2nd row	연도별 공급지역
3rd row	연도별 공급지역
4th row	연도별 공급지역
5th row	연도별 공급지역

Common Values

Value	Count	Frequency (%)
연도별 공급지역	558	88.3%
이율관리	69	10.9%
센터관리	5	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
연도별	558	46.9%
공급지역	558	46.9%
이율관리	69	5.8%
센터관리	5	0.4%

사업연도
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	19
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.802215

Minimum	0
Maximum	23
Zeros	74
Zeros (%)	11.7%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	8
median	13
Q3	18
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	6.7507442
Coefficient of variation (CV)	0.52731063
Kurtosis	-0.7210435
Mean	12.802215
Median Absolute Deviation (MAD)	5
Skewness	-0.39294446
Sum	8091
Variance	45.572547
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
0	74	11.7%
6	31	4.9%
7	31	4.9%
23	31	4.9%
22	31	4.9%
21	31	4.9%
20	31	4.9%
19	31	4.9%
18	31	4.9%
17	31	4.9%
Other values (9)	279	44.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	74	11.7%
6	31	4.9%
7	31	4.9%
8	31	4.9%
9	31	4.9%
10	31	4.9%
11	31	4.9%
12	31	4.9%
13	31	4.9%
14	31	4.9%

Value	Count	Frequency (%)
23	31	4.9%
22	31	4.9%
21	31	4.9%
20	31	4.9%
19	31	4.9%
18	31	4.9%
17	31	4.9%
16	31	4.9%
15	31	4.9%
14	31	4.9%

관리지역 아이디
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	32
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.613924

Minimum	0
Maximum	61
Zeros	74
Zeros (%)	11.7%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	35
median	44
Q3	53
95-th percentile	60
Maximum	61
Range	61
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	17.024723
Coefficient of variation (CV)	0.4191844
Kurtosis	1.0993851
Mean	40.613924
Median Absolute Deviation (MAD)	9
Skewness	-1.3367312
Sum	25668
Variance	289.8412
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
0	74	11.7%
39	18	2.8%
50	18	2.8%
61	18	2.8%
38	18	2.8%
60	18	2.8%
59	18	2.8%
58	18	2.8%
57	18	2.8%
56	18	2.8%
Other values (22)	396	62.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	74	11.7%
31	18	2.8%
32	18	2.8%
33	18	2.8%
34	18	2.8%
35	18	2.8%
36	18	2.8%
37	18	2.8%
38	18	2.8%
39	18	2.8%

Value	Count	Frequency (%)
61	18	2.8%
60	18	2.8%
59	18	2.8%
58	18	2.8%
57	18	2.8%
56	18	2.8%
55	18	2.8%
54	18	2.8%
53	18	2.8%
52	18	2.8%

공급지역
Categorical

HIGH CORRELATION

Distinct	32
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Memory size	5.1 KiB

0	74
고양시	18
과천시	18
광명시	18
광주시	18
Other values (27)	486

Length

Max length	4
Median length	3
Mean length	2.8512658
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	가평군
2nd row	고양시
3rd row	과천시
4th row	광명시
5th row	광주시

Common Values

Value	Count	Frequency (%)
0	74	11.7%
고양시	18	2.8%
과천시	18	2.8%
광명시	18	2.8%
광주시	18	2.8%
구리시	18	2.8%
군포시	18	2.8%
김포시	18	2.8%
남양주시	18	2.8%
동두천시	18	2.8%
Other values (22)	396	62.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0	74	11.7%
고양시	18	2.8%
화성시	18	2.8%
하남시	18	2.8%
포천시	18	2.8%
평택시	18	2.8%
파주시	18	2.8%
이천시	18	2.8%
의정부시	18	2.8%
의왕시	18	2.8%
Other values (22)	396	62.7%

계획호수
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	37
Distinct (%)	5.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	46.039557

Minimum	0
Maximum	320
Zeros	344
Zeros (%)	54.4%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	60
95-th percentile	220
Maximum	320
Range	320
Interquartile range (IQR)	60

Descriptive statistics

Standard deviation	76.066178
Coefficient of variation (CV)	1.6521918
Kurtosis	2.6425604
Mean	46.039557
Median Absolute Deviation (MAD)	0
Skewness	1.8604154
Sum	29097
Variance	5786.0634
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
0	344	54.4%
20	31	4.9%
50	31	4.9%
100	25	4.0%
30	24	3.8%
10	23	3.6%
200	22	3.5%
40	13	2.1%
70	13	2.1%
300	12	1.9%
Other values (27)	94	14.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	344	54.4%
10	23	3.6%
15	3	0.5%
20	31	4.9%
30	24	3.8%
35	1	0.2%
40	13	2.1%
50	31	4.9%
60	5	0.8%
70	13	2.1%

Value	Count	Frequency (%)
320	2	0.3%
300	12	1.9%
290	2	0.3%
280	1	0.2%
270	1	0.2%
260	3	0.5%
250	4	0.6%
240	4	0.6%
230	2	0.3%
220	3	0.5%

지원호수
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	152
Distinct (%)	24.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.571203

Minimum	0
Maximum	461
Zeros	308
Zeros (%)	48.7%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	42.25
95-th percentile	193
Maximum	461
Range	461
Interquartile range (IQR)	42.25

Descriptive statistics

Standard deviation	67.958536
Coefficient of variation (CV)	1.8087932
Kurtosis	6.1527675
Mean	37.571203
Median Absolute Deviation (MAD)	1
Skewness	2.3630979
Sum	23745
Variance	4618.3626
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	308	48.7%
1	30	4.7%
2	13	2.1%
3	8	1.3%
14	6	0.9%
9	5	0.8%
8	5	0.8%
110	5	0.8%
34	5	0.8%
10	5	0.8%
Other values (142)	242	38.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	308	48.7%
1	30	4.7%
2	13	2.1%
3	8	1.3%
4	3	0.5%
5	2	0.3%
6	3	0.5%
7	1	0.2%
8	5	0.8%
9	5	0.8%

Value	Count	Frequency (%)
461	1	0.2%
362	1	0.2%
353	1	0.2%
349	1	0.2%
324	1	0.2%
292	1	0.2%
290	1	0.2%
276	1	0.2%
270	1	0.2%
253	1	0.2%

계약호수
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	133
Distinct (%)	21.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27.536392

Minimum	0
Maximum	387
Zeros	323
Zeros (%)	51.1%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	25
95-th percentile	152.9
Maximum	387
Range	387
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	54.647511
Coefficient of variation (CV)	1.9845559
Kurtosis	9.7892577
Mean	27.536392
Median Absolute Deviation (MAD)	0
Skewness	2.8931921
Sum	17403
Variance	2986.3505
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	323	51.1%
1	30	4.7%
7	9	1.4%
17	8	1.3%
22	8	1.3%
23	8	1.3%
19	8	1.3%
16	7	1.1%
10	7	1.1%
21	7	1.1%
Other values (123)	217	34.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	323	51.1%
1	30	4.7%
2	5	0.8%
3	4	0.6%
4	1	0.2%
5	4	0.6%
6	5	0.8%
7	9	1.4%
8	3	0.5%
9	4	0.6%

Value	Count	Frequency (%)
387	1	0.2%
351	1	0.2%
343	1	0.2%
273	1	0.2%
271	1	0.2%
257	1	0.2%
250	1	0.2%
233	1	0.2%
226	1	0.2%
224	1	0.2%

해약호수
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	79
Distinct (%)	12.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.03481

Minimum	0
Maximum	118
Zeros	386
Zeros (%)	61.1%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	5
95-th percentile	62.9
Maximum	118
Range	118
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	21.982821
Coefficient of variation (CV)	2.1906564
Kurtosis	6.0260611
Mean	10.03481
Median Absolute Deviation (MAD)	0
Skewness	2.5659522
Sum	6342
Variance	483.24443
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	386	61.1%
1	35	5.5%
3	20	3.2%
2	16	2.5%
4	12	1.9%
12	8	1.3%
7	7	1.1%
9	7	1.1%
8	6	0.9%
5	6	0.9%
Other values (69)	129	20.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	386	61.1%
1	35	5.5%
2	16	2.5%
3	20	3.2%
4	12	1.9%
5	6	0.9%
6	5	0.8%
7	7	1.1%
8	6	0.9%
9	7	1.1%

Value	Count	Frequency (%)
118	1	0.2%
105	1	0.2%
104	1	0.2%
103	1	0.2%
98	3	0.5%
96	1	0.2%
95	1	0.2%
93	1	0.2%
91	2	0.3%
86	1	0.2%

이율코드
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	16
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.63132911

Minimum	0
Maximum	15
Zeros	563
Zeros (%)	89.1%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	2.147899
Coefficient of variation (CV)	3.4021859
Kurtosis	16.458022
Mean	0.63132911
Median Absolute Deviation (MAD)	0
Skewness	3.9545221
Sum	399
Variance	4.6134702
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
0	563	89.1%
4	19	3.0%
6	10	1.6%
1	10	1.6%
5	7	1.1%
9	6	0.9%
10	5	0.8%
13	3	0.5%
3	2	0.3%
8	1	0.2%
Other values (6)	6	0.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	563	89.1%
1	10	1.6%
2	1	0.2%
3	2	0.3%
4	19	3.0%
5	7	1.1%
6	10	1.6%
7	1	0.2%
8	1	0.2%
9	6	0.9%

Value	Count	Frequency (%)
15	1	0.2%
14	1	0.2%
13	3	0.5%
12	1	0.2%
11	1	0.2%
10	5	0.8%
9	6	0.9%
8	1	0.2%
7	1	0.2%
6	10	1.6%

적용일
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	22
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2181037.1

Minimum	0
Maximum	20230301
Zeros	563
Zeros (%)	89.1%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	20161001
Maximum	20230301
Range	20230301
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	6236293
Coefficient of variation (CV)	2.8593245
Kurtosis	4.3394879
Mean	2181037.1
Median Absolute Deviation (MAD)	0
Skewness	2.5143093
Sum	1.3784155 × 10⁹
Variance	3.889135 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
0	563	89.1%
19500101	10	1.6%
20180101	10	1.6%
20161001	9	1.4%
19000101	6	0.9%
20150601	6	0.9%
20150102	4	0.6%
20200101	3	0.5%
20171231	3	0.5%
20210101	3	0.5%
Other values (12)	15	2.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	563	89.1%
19000101	6	0.9%
19500101	10	1.6%
20150101	1	0.2%
20150102	4	0.6%
20150601	6	0.9%
20160101	1	0.2%
20160520	1	0.2%
20161001	9	1.4%
20170101	1	0.2%

Value	Count	Frequency (%)
20230301	1	0.2%
20230101	1	0.2%
20220101	2	0.3%
20210121	2	0.3%
20210101	3	0.5%
20201231	1	0.2%
20201217	1	0.2%
20200101	3	0.5%
20190101	2	0.3%
20180101	10	1.6%

적용이율
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	25
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.8928165

Minimum	0
Maximum	100
Zeros	577
Zeros (%)	91.3%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	5
Maximum	100
Range	100
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	12.159213
Coefficient of variation (CV)	6.4238733
Kurtosis	53.863508
Mean	1.8928165
Median Absolute Deviation (MAD)	0
Skewness	7.3954764
Sum	1196.26
Variance	147.84646
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
0.0	577	91.3%
95.0	9	1.4%
6.0	6	0.9%
5.0	4	0.6%
1.0	4	0.6%
2.0	4	0.6%
5.5	3	0.5%
6.5	3	0.5%
7.0	3	0.5%
1.5	3	0.5%
Other values (15)	16	2.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	577	91.3%
0.5	1	0.2%
1.0	4	0.6%
1.5	3	0.5%
1.56	1	0.2%
1.57	1	0.2%
1.64	1	0.2%
1.68	1	0.2%
1.76	1	0.2%
1.77	1	0.2%

Value	Count	Frequency (%)
100.0	1	0.2%
95.0	9	1.4%
55.0	1	0.2%
20.0	1	0.2%
10.0	1	0.2%
8.0	1	0.2%
7.0	3	0.5%
6.5	3	0.5%
6.0	6	0.9%
5.5	3	0.5%

절삭단위
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	5.1 KiB

0	591
-1	32
-4	9

Length

Max length	2
Median length	1
Mean length	1.0648734
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	591	93.5%
-1	32	5.1%
-4	9	1.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	591	93.5%
1	32	5.1%
4	9	1.4%

비고
Categorical

HIGH CORRELATION IMBALANCE

Distinct	36
Distinct (%)	5.7%
Missing	0
Missing (%)	0.0%
Memory size	5.1 KiB

0	577
2018년 1월 1일부터 적용	9
총자산 합계 한도 금액	5
자동차 최대한도 금액	4
20161001 임대시작일 부터 적용 대여금 지급 규모별 임대료 이율	3
Other values (31)	34

Length

Max length	38
Median length	1
Mean length	2.3449367
Min length	1

Unique

Unique	29 ?
Unique (%)	4.6%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	577	91.3%
2018년 1월 1일부터 적용	9	1.4%
총자산 합계 한도 금액	5	0.8%
자동차 최대한도 금액	4	0.6%
20161001 임대시작일 부터 적용 대여금 지급 규모별 임대료 이율	3	0.5%
20150102 계약체결 부터 적용 임대료 이율	3	0.5%
20150102 계약체결 부터 적용 대여금 지급율	2	0.3%
2019년 기준 적용 이율	1	0.2%
2017년 기준 적용 이율	1	0.2%
2017년12월 부터 손실보정적립금 부여 안함	1	0.2%
Other values (26)	26	4.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0	577	71.2%
적용	32	4.0%
이율	17	2.1%
부터	13	1.6%
2018년	10	1.2%
금액	10	1.2%
1월	9	1.1%
1일부터	9	1.1%
대여금	7	0.9%
한도	7	0.9%
Other values (61)	119	14.7%

권역명
Categorical

HIGH CORRELATION IMBALANCE

Distinct	6
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	5.1 KiB

0	627
본사	1
수원권역	1
성남권역	1
고양권역	1

Length

Max length	5
Median length	1
Mean length	1.0221519
Min length	1

Unique

Unique	5 ?
Unique (%)	0.8%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	627	99.2%
본사	1	0.2%
수원권역	1	0.2%
성남권역	1	0.2%
고양권역	1	0.2%
남양주권역	1	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	627	99.2%
본사	1	0.2%
수원권역	1	0.2%
성남권역	1	0.2%
고양권역	1	0.2%
남양주권역	1	0.2%

전화번호
Categorical

HIGH CORRELATION IMBALANCE

Distinct	6
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	5.1 KiB

0	627
1588-0466	1
031-213-1115	1
02-2174-2993	1
02-554-5302	1

Length

Max length	12
Median length	1
Mean length	1.0806962
Min length	1

Unique

Unique	5 ?
Unique (%)	0.8%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	627	99.2%
1588-0466	1	0.2%
031-213-1115	1	0.2%
02-2174-2993	1	0.2%
02-554-5302	1	0.2%
02-6219-7005	1	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	627	99.2%
1588-0466	1	0.2%
031-213-1115	1	0.2%
02-2174-2993	1	0.2%
02-554-5302	1	0.2%
02-6219-7005	1	0.2%

약어
Categorical

HIGH CORRELATION IMBALANCE

Distinct	6
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	5.1 KiB

0	627
본사	1
수원권	1
성남권	1
고양권	1

Length

Max length	4
Median length	1
Mean length	1.0158228
Min length	1

Unique

Unique	5 ?
Unique (%)	0.8%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	627	99.2%
본사	1	0.2%
수원권	1	0.2%
성남권	1	0.2%
고양권	1	0.2%
남양주권	1	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	627	99.2%
본사	1	0.2%
수원권	1	0.2%
성남권	1	0.2%
고양권	1	0.2%
남양주권	1	0.2%

권역주소(담당 법무법인)
Categorical

HIGH CORRELATION IMBALANCE

Distinct	5
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	5.1 KiB

0	628
법무법인 서린	1
법무법인 코러스	1
법무법인 덕수	1
법무법인 씨케이	1

Length

Max length	8
Median length	1
Mean length	1.0411392
Min length	1

Unique

Unique	4 ?
Unique (%)	0.6%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	628	99.4%
법무법인 서린	1	0.2%
법무법인 코러스	1	0.2%
법무법인 덕수	1	0.2%
법무법인 씨케이	1	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	628	98.7%
법무법인	4	0.6%
서린	1	0.2%
코러스	1	0.2%
덕수	1	0.2%
씨케이	1	0.2%

Heatmap
Table

	구분	사업연도	관리지역 아이디	공급지역	계획호수	지원호수	계약호수	해약호수	이율코드	적용일	적용이율	절삭단위	비고	권역명	전화번호	약어	권역주소(담당 법무법인)
구분	1.000	0.936	0.940	0.868	0.222	0.206	0.081	0.081	0.765	1.000	0.350	0.848	0.838	0.940	0.940	0.940	0.660
사업연도	0.936	1.000	0.698	0.618	0.433	0.404	0.363	0.394	0.553	0.921	0.279	0.796	0.501	0.000	0.000	0.000	0.000
관리지역 아이디	0.940	0.698	1.000	1.000	0.495	0.518	0.364	0.471	0.610	0.998	0.259	0.821	0.626	0.175	0.175	0.175	0.095
공급지역	0.868	0.618	1.000	1.000	0.646	0.651	0.555	0.584	0.494	0.998	0.000	0.699	0.000	0.000	0.000	0.000	0.000
계획호수	0.222	0.433	0.495	0.646	1.000	0.711	0.798	0.709	0.000	0.280	0.000	0.088	0.000	0.000	0.000	0.000	0.000
지원호수	0.206	0.404	0.518	0.651	0.711	1.000	0.847	0.706	0.000	0.163	0.000	0.000	0.000	0.000	0.000	0.000	0.000
계약호수	0.081	0.363	0.364	0.555	0.798	0.847	1.000	0.670	0.000	0.168	0.000	0.000	0.000	0.000	0.000	0.000	0.000
해약호수	0.081	0.394	0.471	0.584	0.709	0.706	0.670	1.000	0.000	0.168	0.000	0.000	0.000	0.000	0.000	0.000	0.000
이율코드	0.765	0.553	0.610	0.494	0.000	0.000	0.000	0.000	1.000	0.991	0.942	0.917	0.985	0.000	0.000	0.000	0.000
적용일	1.000	0.921	0.998	0.998	0.280	0.163	0.168	0.168	0.991	1.000	0.334	0.492	0.969	0.000	0.000	0.000	0.000
적용이율	0.350	0.279	0.259	0.000	0.000	0.000	0.000	0.000	0.942	0.334	1.000	0.689	0.998	0.000	0.000	0.000	0.000
절삭단위	0.848	0.796	0.821	0.699	0.088	0.000	0.000	0.000	0.917	0.492	0.689	1.000	0.980	0.000	0.000	0.000	0.000
비고	0.838	0.501	0.626	0.000	0.000	0.000	0.000	0.000	0.985	0.969	0.998	0.980	1.000	0.000	0.000	0.000	0.000
권역명	0.940	0.000	0.175	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	1.000	1.000	1.000
전화번호	0.940	0.000	0.175	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	1.000	1.000	1.000
약어	0.940	0.000	0.175	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	1.000	1.000	1.000
권역주소(담당 법무법인)	0.660	0.000	0.095	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	1.000	1.000	1.000

Heatmap
Table

	약어	권역주소(담당 법무법인)	구분	공급지역	비고	전화번호	절삭단위	권역명
약어	1.000	0.999	0.703	0.000	0.000	1.000	0.000	1.000
권역주소(담당 법무법인)	0.999	1.000	0.628	0.000	0.000	0.999	0.000	0.999
구분	0.703	0.628	1.000	0.673	0.578	0.703	0.530	0.703
공급지역	0.000	0.000	0.673	1.000	0.000	0.000	0.462	0.000
비고	0.000	0.000	0.578	0.000	1.000	0.000	0.835	0.000
전화번호	1.000	0.999	0.703	0.000	0.000	1.000	0.000	1.000
절삭단위	0.000	0.000	0.530	0.462	0.835	0.000	1.000	0.000
권역명	1.000	0.999	0.703	0.000	0.000	1.000	0.000	1.000

Heatmap
Table

	사업연도	관리지역 아이디	계획호수	지원호수	계약호수	해약호수	이율코드	적용일	적용이율	구분	공급지역	절삭단위	비고	권역명	전화번호	약어	권역주소(담당 법무법인)
사업연도	1.000	0.311	0.651	0.698	0.745	0.418	-0.535	-0.535	-0.472	0.699	0.277	0.500	0.187	0.000	0.000	0.000	0.000
관리지역 아이디	0.311	1.000	-0.149	-0.102	-0.071	-0.151	-0.535	-0.535	-0.472	0.703	0.979	0.504	0.298	0.064	0.064	0.064	0.064
계획호수	0.651	-0.149	1.000	0.913	0.898	0.751	-0.301	-0.301	-0.266	0.135	0.284	0.051	0.000	0.000	0.000	0.000	0.000
지원호수	0.698	-0.102	0.913	1.000	0.981	0.841	-0.330	-0.330	-0.291	0.091	0.300	0.000	0.000	0.000	0.000	0.000	0.000
계약호수	0.745	-0.071	0.898	0.981	1.000	0.773	-0.318	-0.318	-0.281	0.047	0.226	0.000	0.000	0.000	0.000	0.000	0.000
해약호수	0.418	-0.151	0.751	0.841	0.773	1.000	-0.268	-0.268	-0.237	0.047	0.243	0.000	0.000	0.000	0.000	0.000	0.000
이율코드	-0.535	-0.535	-0.301	-0.330	-0.318	-0.268	1.000	0.996	0.866	0.638	0.194	0.746	0.900	0.000	0.000	0.000	0.000
적용일	-0.535	-0.535	-0.301	-0.330	-0.318	-0.268	0.996	1.000	0.873	0.999	0.936	0.751	0.851	0.000	0.000	0.000	0.000
적용이율	-0.472	-0.472	-0.266	-0.291	-0.281	-0.237	0.866	0.873	1.000	0.273	0.000	0.668	0.957	0.000	0.000	0.000	0.000
구분	0.699	0.703	0.135	0.091	0.047	0.047	0.638	0.999	0.273	1.000	0.673	0.530	0.578	0.703	0.703	0.703	0.628
공급지역	0.277	0.979	0.284	0.300	0.226	0.243	0.194	0.936	0.000	0.673	1.000	0.462	0.000	0.000	0.000	0.000	0.000
절삭단위	0.500	0.504	0.051	0.000	0.000	0.000	0.746	0.751	0.668	0.530	0.462	1.000	0.835	0.000	0.000	0.000	0.000
비고	0.187	0.298	0.000	0.000	0.000	0.000	0.900	0.851	0.957	0.578	0.000	0.835	1.000	0.000	0.000	0.000	0.000
권역명	0.000	0.064	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.703	0.000	0.000	0.000	1.000	1.000	1.000	0.999
전화번호	0.000	0.064	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.703	0.000	0.000	0.000	1.000	1.000	1.000	0.999
약어	0.000	0.064	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.703	0.000	0.000	0.000	1.000	1.000	1.000	0.999
권역주소(담당 법무법인)	0.000	0.064	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.628	0.000	0.000	0.000	0.999	0.999	0.999	1.000

Count
Matrix

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.

First rows
Last rows

	구분	사업연도	관리지역 아이디	공급지역	계획호수	지원호수	계약호수	해약호수
0	연도별 공급지역	6	39	가평군	0	0	0	0
1	연도별 공급지역	6	31	고양시	103	103	20	83
2	연도별 공급지역	6	40	과천시	0	0	0	0
3	연도별 공급지역	6	41	광명시	0	0	0	0
4	연도별 공급지역	6	42	광주시	0	0	0	0
5	연도별 공급지역	6	43	구리시	0	0	0	0
6	연도별 공급지역	6	44	군포시	0	0	0	0
7	연도별 공급지역	6	45	김포시	0	0	0	0
8	연도별 공급지역	6	32	남양주시	50	1	0	1
9	연도별 공급지역	6	46	동두천시	0	0	0	0

	구분	이율코드	적용일	적용이율	비고	권역명	전화번호	약어	권역주소(담당 법무법인)
622	이율관리	11	19000101	1.0	0	0	0	0	0
623	이율관리	12	19000101	10.0	1월~3월 미만	0	0	0	0
624	이율관리	13	19000101	20.0	회수의문	0	0	0	0
625	이율관리	14	19000101	55.0	3월 ~ 12월 미만	0	0	0	0
626	이율관리	15	19000101	100.0	12월 이상	0	0	0	0
627	센터관리	0	0	0.0	0	본사	1588-0466	본사	0
628	센터관리	0	0	0.0	0	수원권역	031-213-1115	수원권	법무법인 서린
629	센터관리	0	0	0.0	0	성남권역	02-2174-2993	성남권	법무법인 코러스
630	센터관리	0	0	0.0	0	고양권역	02-554-5302	고양권	법무법인 덕수
631	센터관리	0	0	0.0	0	남양주권역	02-6219-7005	남양주권	법무법인 씨케이

Most frequently occurring

	구분	이율코드	적용일	적용이율	절삭단위	비고	# duplicates
0	이율관리	4	20150601	6.0	-1	0	2
1	이율관리	4	20161001	6.0	-1	0	2
2	이율관리	4	20180101	6.0	-1	2018년 1월 1일부터 적용	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring