gimi9 Pandas Profiling

Dataset statistics

Number of variables	16
Number of observations	10000
Missing cells	21415
Missing cells (%)	13.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.4 MiB
Average record size in memory	151.0 B

Variable types

Numeric	13
Categorical	3

Dataset

Description	한국부동산원(구.한국감정원)에서 제공하는 부동산 거래 통계를 조회할 수 있는 서비스로 충남의 거래원인별 거래 건수 정보를 제공합니다.
Author	충청남도
URL	https://alldam.chungnam.go.kr/bigdata/collect/view.chungnam?menuCd=DOM_000000201001001000&apiIdx=2562

Alerts

`지역명` 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 overall correlated with `번호` and 4 other fields	High correlation
`합계_건수` is highly overall correlated with `번호` and 8 other fields	High correlation
`매매_건수` is highly overall correlated with `번호` and 8 other fields	High correlation
`판결_건수` is highly overall correlated with `합계_건수` and 4 other fields	High correlation
`교환_건수` is highly overall correlated with `합계_건수` and 4 other fields	High correlation
`증여_건수` is highly overall correlated with `합계_건수` and 5 other fields	High correlation
`분양권_건수` is highly overall correlated with `합계_건수` and 1 other fields	High correlation
`분양권전매_건수` is highly overall correlated with `기타_건수.1`	High correlation
`기타_건수` is highly overall correlated with `합계_건수` and 4 other fields	High correlation
`기타_건수.1` is highly overall correlated with `분양권전매_건수`	High correlation
`지역구분 레벨` is highly imbalanced (50.8%)	Imbalance
`분양권_건수` has 1632 (16.3%) missing values	Missing
`분양권전매_건수` has 5930 (59.3%) missing values	Missing
`분양권검인_건수` has 5930 (59.3%) missing values	Missing
`기타_건수` has 1632 (16.3%) missing values	Missing
`기타_건수.1` has 6291 (62.9%) missing values	Missing
`번호` has unique values	Unique
`판결_건수` has 4484 (44.8%) zeros	Zeros
`교환_건수` has 6151 (61.5%) zeros	Zeros
`증여_건수` has 402 (4.0%) zeros	Zeros
`분양권_건수` has 3080 (30.8%) zeros	Zeros
`분양권전매_건수` has 2965 (29.6%) zeros	Zeros
`분양권검인_건수` has 3893 (38.9%) zeros	Zeros
`기타_건수` has 2234 (22.3%) zeros	Zeros
`기타_건수.1` has 2321 (23.2%) zeros	Zeros

Reproduction

Analysis started	2024-01-09 22:21:02.918830
Analysis finished	2024-01-09 22:21:19.996796
Duration	17.08 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

번호
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	10000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8609.6454

Minimum	1
Maximum	17170
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1
5-th percentile	844.9
Q1	4278.75
median	8610.5
Q3	12924.5
95-th percentile	16366.05
Maximum	17170
Range	17169
Interquartile range (IQR)	8645.75

Descriptive statistics

Standard deviation	4978.4777
Coefficient of variation (CV)	0.57824422
Kurtosis	-1.2069772
Mean	8609.6454
Median Absolute Deviation (MAD)	4324
Skewness	-0.0024048544
Sum	86096454
Variance	24785240
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15413	1	< 0.1%
10907	1	< 0.1%
16416	1	< 0.1%
3250	1	< 0.1%
15429	1	< 0.1%
14172	1	< 0.1%
9770	1	< 0.1%
3504	1	< 0.1%
5984	1	< 0.1%
622	1	< 0.1%
Other values (9990)	9990	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
14	1	< 0.1%

Value	Count	Frequency (%)
17170	1	< 0.1%
17168	1	< 0.1%
17167	1	< 0.1%
17166	1	< 0.1%
17165	1	< 0.1%
17164	1	< 0.1%
17162	1	< 0.1%
17160	1	< 0.1%
17158	1	< 0.1%
17157	1	< 0.1%

지역코드
Real number (ℝ)

HIGH CORRELATION

Distinct	18
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44416.575

Minimum	44000
Maximum	44825
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	44000
5-th percentile	44000
Q1	44150
median	44230
Q3	44770
95-th percentile	44825
Maximum	44825
Range	825
Interquartile range (IQR)	620

Descriptive statistics

Standard deviation	306.53042
Coefficient of variation (CV)	0.006901262
Kurtosis	-1.7349551
Mean	44416.575
Median Absolute Deviation (MAD)	100
Skewness	0.30109012
Sum	4.4416575 × 10⁸
Variance	93960.898
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
44825	617	6.2%
44150	584	5.8%
44230	583	5.8%
44790	582	5.8%
44770	582	5.8%
44000	581	5.8%
44180	579	5.8%
44800	577	5.8%
44760	574	5.7%
44200	565	5.7%
Other values (8)	4176	41.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
44000	581	5.8%
44130	559	5.6%
44131	511	5.1%
44133	488	4.9%
44150	584	5.8%
44180	579	5.8%
44200	565	5.7%
44210	557	5.6%
44230	583	5.8%
44250	559	5.6%

Value	Count	Frequency (%)
44825	617	6.2%
44810	560	5.6%
44800	577	5.8%
44790	582	5.8%
44770	582	5.8%
44760	574	5.7%
44710	552	5.5%
44270	390	3.9%
44250	559	5.6%
44230	583	5.8%

지역명
Categorical

HIGH CORRELATION

Distinct	18
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

태안군	617
공주시	584
논산시	583
서천군	582
청양군	582
Other values (13)	7052

Length

Max length	3
Median length	3
Mean length	2.9419
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	예산군
2nd row	서천군
3rd row	논산시
4th row	서북구
5th row	부여군

Common Values

Value	Count	Frequency (%)
태안군	617	6.2%
공주시	584	5.8%
논산시	583	5.8%
서천군	582	5.8%
청양군	582	5.8%
충남	581	5.8%
보령시	579	5.8%
홍성군	577	5.8%
부여군	574	5.7%
아산시	565	5.7%
Other values (8)	4176	41.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
태안군	617	6.2%
공주시	584	5.8%
논산시	583	5.8%
서천군	582	5.8%
청양군	582	5.8%
충남	581	5.8%
보령시	579	5.8%
홍성군	577	5.8%
부여군	574	5.7%
아산시	565	5.7%
Other values (8)	4176	41.8%

조사분기
Real number (ℝ)

Distinct	198
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	201405.85

Minimum	200601
Maximum	202206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	200601
5-th percentile	200612
Q1	201007
median	201407
Q3	201807
95-th percentile	202110
Maximum	202206
Range	1605
Interquartile range (IQR)	800

Descriptive statistics

Standard deviation	470.22923
Coefficient of variation (CV)	0.0023347347
Kurtosis	-1.1592278
Mean	201405.85
Median Absolute Deviation (MAD)	400
Skewness	-0.03340863
Sum	2.0140585 × 10⁹
Variance	221115.53
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
202205	63	0.6%
201202	63	0.6%
202110	61	0.6%
201706	61	0.6%
201301	60	0.6%
201703	59	0.6%
202009	59	0.6%
201206	59	0.6%
202202	59	0.6%
201711	59	0.6%
Other values (188)	9397	94.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
200601	37	0.4%
200602	45	0.4%
200603	38	0.4%
200604	46	0.5%
200605	46	0.5%
200606	38	0.4%
200607	45	0.4%
200608	48	0.5%
200609	45	0.4%
200610	39	0.4%

Value	Count	Frequency (%)
202206	55	0.5%
202205	63	0.6%
202204	49	0.5%
202203	58	0.6%
202202	59	0.6%
202201	58	0.6%
202112	51	0.5%
202111	57	0.6%
202110	61	0.6%
202109	52	0.5%

거래유형
Categorical

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

5	2042
2	2031
3	2025
1	1993
4	1909

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
5	2042	20.4%
2	2031	20.3%
3	2025	20.2%
1	1993	19.9%
4	1909	19.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5	2042	20.4%
2	2031	20.3%
3	2025	20.2%
1	1993	19.9%
4	1909	19.1%

합계_건수
Real number (ℝ)

HIGH CORRELATION

Distinct	2522
Distinct (%)	25.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	951.7302

Minimum	0
Maximum	25927
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	25.95
Q1	110
median	379
Q3	851.25
95-th percentile	4172.05
Maximum	25927
Range	25927
Interquartile range (IQR)	741.25

Descriptive statistics

Standard deviation	2004.8274
Coefficient of variation (CV)	2.1065081
Kurtosis	31.848717
Mean	951.7302
Median Absolute Deviation (MAD)	295
Skewness	5.0160303
Sum	9517302
Variance	4019332.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
70	39	0.4%
72	38	0.4%
66	36	0.4%
78	33	0.3%
93	32	0.3%
21	32	0.3%
36	31	0.3%
82	31	0.3%
91	30	0.3%
59	30	0.3%
Other values (2512)	9668	96.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	8	0.1%
2	7	0.1%
3	10	0.1%
4	17	0.2%
5	18	0.2%
6	23	0.2%
7	14	0.1%
8	15	0.1%
9	13	0.1%

Value	Count	Frequency (%)
25927	1	< 0.1%
23450	1	< 0.1%
23070	1	< 0.1%
23024	1	< 0.1%
21064	1	< 0.1%
20701	1	< 0.1%
19845	1	< 0.1%
19701	1	< 0.1%
19259	1	< 0.1%
19191	1	< 0.1%

매매_건수
Real number (ℝ)

HIGH CORRELATION

Distinct	2031
Distinct (%)	20.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	631.0989

Minimum	0
Maximum	17621
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	18
Q1	80
median	246.5
Q3	569
95-th percentile	2539.2
Maximum	17621
Range	17621
Interquartile range (IQR)	489

Descriptive statistics

Standard deviation	1350.4152
Coefficient of variation (CV)	2.1397838
Kurtosis	34.489289
Mean	631.0989
Median Absolute Deviation (MAD)	188.5
Skewness	5.2446178
Sum	6310989
Variance	1823621.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
53	46	0.5%
61	46	0.5%
50	46	0.5%
66	43	0.4%
16	42	0.4%
21	42	0.4%
17	42	0.4%
70	41	0.4%
68	41	0.4%
51	40	0.4%
Other values (2021)	9571	95.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3	< 0.1%
1	10	0.1%
2	13	0.1%
3	16	0.2%
4	24	0.2%
5	27	0.3%
6	33	0.3%
7	23	0.2%
8	28	0.3%
9	27	0.3%

Value	Count	Frequency (%)
17621	1	< 0.1%
17179	1	< 0.1%
15871	1	< 0.1%
14700	1	< 0.1%
14615	1	< 0.1%
14123	1	< 0.1%
13417	1	< 0.1%
13011	1	< 0.1%
12593	1	< 0.1%
12506	1	< 0.1%

판결_건수
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	154
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.2391

Minimum	0
Maximum	244
Zeros	4484
Zeros (%)	44.8%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	4
95-th percentile	23
Maximum	244
Range	244
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	18.731279
Coefficient of variation (CV)	3.0022406
Kurtosis	38.726008
Mean	6.2391
Median Absolute Deviation (MAD)	1
Skewness	5.7277049
Sum	62391
Variance	350.86082
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4484	44.8%
1	1424	14.2%
2	743	7.4%
3	482	4.8%
4	381	3.8%
5	290	2.9%
6	281	2.8%
7	212	2.1%
8	199	2.0%
9	148	1.5%
Other values (144)	1356	13.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4484	44.8%
1	1424	14.2%
2	743	7.4%
3	482	4.8%
4	381	3.8%
5	290	2.9%
6	281	2.8%
7	212	2.1%
8	199	2.0%
9	148	1.5%

Value	Count	Frequency (%)
244	1	< 0.1%
243	1	< 0.1%
228	1	< 0.1%
221	1	< 0.1%
213	1	< 0.1%
203	1	< 0.1%
197	2	< 0.1%
186	1	< 0.1%
184	1	< 0.1%
167	1	< 0.1%

교환_건수
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	128
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.9846

Minimum	0
Maximum	200
Zeros	6151
Zeros (%)	61.5%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	13.651388
Coefficient of variation (CV)	3.4260373
Kurtosis	53.713026
Mean	3.9846
Median Absolute Deviation (MAD)	0
Skewness	6.7165863
Sum	39846
Variance	186.3604
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6151	61.5%
2	871	8.7%
4	464	4.6%
1	430	4.3%
6	299	3.0%
3	256	2.6%
7	196	2.0%
5	191	1.9%
8	188	1.9%
9	127	1.3%
Other values (118)	827	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6151	61.5%
1	430	4.3%
2	871	8.7%
3	256	2.6%
4	464	4.6%
5	191	1.9%
6	299	3.0%
7	196	2.0%
8	188	1.9%
9	127	1.3%

Value	Count	Frequency (%)
200	1	< 0.1%
189	1	< 0.1%
182	1	< 0.1%
175	2	< 0.1%
174	1	< 0.1%
171	1	< 0.1%
153	1	< 0.1%
149	1	< 0.1%
143	1	< 0.1%
141	1	< 0.1%

증여_건수
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	596
Distinct (%)	6.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	90.124

Minimum	0
Maximum	3118
Zeros	402
Zeros (%)	4.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	10
median	29
Q3	92
95-th percentile	223.05
Maximum	3118
Range	3118
Interquartile range (IQR)	82

Descriptive statistics

Standard deviation	234.78262
Coefficient of variation (CV)	2.6051065
Kurtosis	41.783667
Mean	90.124
Median Absolute Deviation (MAD)	27
Skewness	6.1080791
Sum	901240
Variance	55122.878
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	402	4.0%
1	366	3.7%
2	318	3.2%
3	244	2.4%
4	242	2.4%
6	210	2.1%
5	209	2.1%
11	193	1.9%
13	188	1.9%
10	180	1.8%
Other values (586)	7448	74.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	402	4.0%
1	366	3.7%
2	318	3.2%
3	244	2.4%
4	242	2.4%
5	209	2.1%
6	210	2.1%
7	168	1.7%
8	176	1.8%
9	159	1.6%

Value	Count	Frequency (%)
3118	1	< 0.1%
2952	1	< 0.1%
2938	1	< 0.1%
2816	1	< 0.1%
2370	1	< 0.1%
2330	1	< 0.1%
2327	1	< 0.1%
2298	1	< 0.1%
2292	1	< 0.1%
2240	1	< 0.1%

분양권_건수
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	969
Distinct (%)	11.6%
Missing	1632
Missing (%)	16.3%
Infinite	0
Infinite (%)	0.0%
Mean	150.13719

Minimum	0
Maximum	5089
Zeros	3080
Zeros (%)	30.8%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4
Q3	64
95-th percentile	874.6
Maximum	5089
Range	5089
Interquartile range (IQR)	64

Descriptive statistics

Standard deviation	446.99508
Coefficient of variation (CV)	2.9772442
Kurtosis	35.349337
Mean	150.13719
Median Absolute Deviation (MAD)	4
Skewness	5.3016768
Sum	1256348
Variance	199804.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3080	30.8%
1	466	4.7%
2	301	3.0%
3	221	2.2%
4	192	1.9%
5	146	1.5%
6	127	1.3%
7	110	1.1%
8	93	0.9%
9	80	0.8%
Other values (959)	3552	35.5%
(Missing)	1632	16.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3080	30.8%
1	466	4.7%
2	301	3.0%
3	221	2.2%
4	192	1.9%
5	146	1.5%
6	127	1.3%
7	110	1.1%
8	93	0.9%
9	80	0.8%

Value	Count	Frequency (%)
5089	1	< 0.1%
5038	1	< 0.1%
4994	1	< 0.1%
4972	1	< 0.1%
4753	1	< 0.1%
4663	1	< 0.1%
4299	1	< 0.1%
4294	1	< 0.1%
4269	1	< 0.1%
4221	1	< 0.1%

분양권전매_건수
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	298
Distinct (%)	7.3%
Missing	5930
Missing (%)	59.3%
Infinite	0
Infinite (%)	0.0%
Mean	25.852826

Minimum	0
Maximum	1336
Zeros	2965
Zeros (%)	29.6%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	93.887619
Coefficient of variation (CV)	3.6316192
Kurtosis	43.499393
Mean	25.852826
Median Absolute Deviation (MAD)	0
Skewness	5.797448
Sum	105221
Variance	8814.8849
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2965	29.6%
1	76	0.8%
2	66	0.7%
4	43	0.4%
5	38	0.4%
7	38	0.4%
6	36	0.4%
3	32	0.3%
11	29	0.3%
8	28	0.3%
Other values (288)	719	7.2%
(Missing)	5930	59.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2965	29.6%
1	76	0.8%
2	66	0.7%
3	32	0.3%
4	43	0.4%
5	38	0.4%
6	36	0.4%
7	38	0.4%
8	28	0.3%
9	14	0.1%

Value	Count	Frequency (%)
1336	1	< 0.1%
1325	1	< 0.1%
926	1	< 0.1%
906	1	< 0.1%
905	1	< 0.1%
854	1	< 0.1%
823	1	< 0.1%
776	1	< 0.1%
721	1	< 0.1%
689	1	< 0.1%

분양권검인_건수
Real number (ℝ)

MISSING ZEROS

Distinct	102
Distinct (%)	2.5%
Missing	5930
Missing (%)	59.3%
Infinite	0
Infinite (%)	0.0%
Mean	12.260197

Minimum	0
Maximum	2361
Zeros	3893
Zeros (%)	38.9%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	109.03444
Coefficient of variation (CV)	8.8933676
Kurtosis	157.32263
Mean	12.260197
Median Absolute Deviation (MAD)	0
Skewness	11.689231
Sum	49899
Variance	11888.508
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3893	38.9%
1	14	0.1%
3	12	0.1%
2	12	0.1%
4	9	0.1%
9	5	0.1%
7	4	< 0.1%
304	3	< 0.1%
36	3	< 0.1%
91	3	< 0.1%
Other values (92)	112	1.1%
(Missing)	5930	59.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3893	38.9%
1	14	0.1%
2	12	0.1%
3	12	0.1%
4	9	0.1%
5	1	< 0.1%
7	4	< 0.1%
8	2	< 0.1%
9	5	0.1%
12	1	< 0.1%

Value	Count	Frequency (%)
2361	1	< 0.1%
1543	1	< 0.1%
1534	1	< 0.1%
1492	2	< 0.1%
1487	1	< 0.1%
1437	1	< 0.1%
1423	2	< 0.1%
1401	1	< 0.1%
1383	1	< 0.1%
1313	1	< 0.1%

기타_건수
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	513
Distinct (%)	6.1%
Missing	1632
Missing (%)	16.3%
Infinite	0
Infinite (%)	0.0%
Mean	52.977892

Minimum	0
Maximum	5362
Zeros	2234
Zeros (%)	22.3%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	6
Q3	36
95-th percentile	191
Maximum	5362
Range	5362
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	186.67574
Coefficient of variation (CV)	3.5236536
Kurtosis	202.15995
Mean	52.977892
Median Absolute Deviation (MAD)	6
Skewness	10.95288
Sum	443319
Variance	34847.832
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2234	22.3%
1	709	7.1%
2	395	4.0%
3	264	2.6%
4	262	2.6%
6	170	1.7%
5	165	1.7%
7	143	1.4%
8	136	1.4%
9	124	1.2%
Other values (503)	3766	37.7%
(Missing)	1632	16.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2234	22.3%
1	709	7.1%
2	395	4.0%
3	264	2.6%
4	262	2.6%
5	165	1.7%
6	170	1.7%
7	143	1.4%
8	136	1.4%
9	124	1.2%

Value	Count	Frequency (%)
5362	1	< 0.1%
4566	1	< 0.1%
4334	1	< 0.1%
3411	1	< 0.1%
3099	1	< 0.1%
3014	1	< 0.1%
2832	1	< 0.1%
2224	1	< 0.1%
2221	1	< 0.1%
1766	1	< 0.1%

기타_건수.1
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	487
Distinct (%)	13.1%
Missing	6291
Missing (%)	62.9%
Infinite	0
Infinite (%)	0.0%
Mean	107.29253

Minimum	0
Maximum	4518
Zeros	2321
Zeros (%)	23.2%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	372.63926
Coefficient of variation (CV)	3.4731146
Kurtosis	34.773004
Mean	107.29253
Median Absolute Deviation (MAD)	0
Skewness	5.3478262
Sum	397948
Variance	138860.02
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2321	23.2%
1	88	0.9%
2	49	0.5%
4	48	0.5%
5	40	0.4%
7	35	0.4%
8	34	0.3%
3	30	0.3%
6	27	0.3%
9	24	0.2%
Other values (477)	1013	10.1%
(Missing)	6291	62.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2321	23.2%
1	88	0.9%
2	49	0.5%
3	30	0.3%
4	48	0.5%
5	40	0.4%
6	27	0.3%
7	35	0.4%
8	34	0.3%
9	24	0.2%

Value	Count	Frequency (%)
4518	1	< 0.1%
3773	1	< 0.1%
3745	1	< 0.1%
3646	1	< 0.1%
3501	1	< 0.1%
3253	1	< 0.1%
3238	1	< 0.1%
3228	1	< 0.1%
3153	1	< 0.1%
2914	1	< 0.1%

지역구분 레벨
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

1	8420
2	999
0	581

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
1	8420	84.2%
2	999	10.0%
0	581	5.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	8420	84.2%
2	999	10.0%
0	581	5.8%

Heatmap
Table

	번호	지역코드	지역명	조사분기	거래유형	합계_건수	매매_건수	판결_건수	교환_건수	증여_건수	분양권_건수	분양권전매_건수	분양권검인_건수	기타_건수	기타_건수.1	지역구분 레벨
번호	1.000	0.994	0.981	0.216	0.068	0.626	0.627	0.447	0.418	0.394	0.506	0.371	0.175	0.337	0.510	0.872
지역코드	0.994	1.000	1.000	0.124	0.000	0.159	0.131	0.056	0.059	0.022	0.192	0.344	0.067	0.000	0.192	0.524
지역명	0.981	1.000	1.000	0.132	0.000	0.641	0.634	0.473	0.448	0.626	0.500	0.463	0.221	0.555	0.461	1.000
조사분기	0.216	0.124	0.132	1.000	0.000	0.096	0.088	0.079	0.095	0.073	0.208	0.077	0.208	0.039	0.099	0.128
거래유형	0.068	0.000	0.000	0.000	1.000	0.273	0.262	0.235	0.258	0.197	0.215	0.239	0.107	0.133	0.356	0.000
합계_건수	0.626	0.159	0.641	0.096	0.273	1.000	0.969	0.798	0.749	0.809	0.757	0.412	0.173	0.592	0.590	0.764
매매_건수	0.627	0.131	0.634	0.088	0.262	0.969	1.000	0.786	0.775	0.802	0.663	0.414	0.173	0.595	0.509	0.759
판결_건수	0.447	0.056	0.473	0.079	0.235	0.798	0.786	1.000	0.774	0.671	0.510	0.126	0.000	0.620	0.212	0.584
교환_건수	0.418	0.059	0.448	0.095	0.258	0.749	0.775	0.774	1.000	0.641	0.363	0.000	0.000	0.622	0.000	0.561
증여_건수	0.394	0.022	0.626	0.073	0.197	0.809	0.802	0.671	0.641	1.000	0.490	0.294	0.000	0.773	0.239	0.812
분양권_건수	0.506	0.192	0.500	0.208	0.215	0.757	0.663	0.510	0.363	0.490	1.000	NaN	NaN	0.251	NaN	0.574
분양권전매_건수	0.371	0.344	0.463	0.077	0.239	0.412	0.414	0.126	0.000	0.294	NaN	1.000	0.651	NaN	0.678	0.476
분양권검인_건수	0.175	0.067	0.221	0.208	0.107	0.173	0.173	0.000	0.000	0.000	NaN	0.651	1.000	NaN	0.520	0.238
기타_건수	0.337	0.000	0.555	0.039	0.133	0.592	0.595	0.620	0.622	0.773	0.251	NaN	NaN	1.000	NaN	0.733
기타_건수.1	0.510	0.192	0.461	0.099	0.356	0.590	0.509	0.212	0.000	0.239	NaN	0.678	0.520	NaN	1.000	0.530
지역구분 레벨	0.872	0.524	1.000	0.128	0.000	0.764	0.759	0.584	0.561	0.812	0.574	0.476	0.238	0.733	0.530	1.000

Heatmap
Table

	지역명	지역구분 레벨	거래유형
지역명	1.000	0.999	0.000
지역구분 레벨	0.999	1.000	0.000
거래유형	0.000	0.000	1.000

Heatmap
Table

	번호	지역코드	조사분기	합계_건수	매매_건수	판결_건수	교환_건수	증여_건수	분양권_건수	분양권전매_건수	분양권검인_건수	기타_건수	기타_건수.1	지역명	거래유형	지역구분 레벨
번호	1.000	0.998	0.025	-0.585	-0.598	-0.346	-0.195	-0.323	-0.461	-0.233	-0.064	-0.280	-0.170	0.901	0.028	0.803
지역코드	0.998	1.000	-0.014	-0.586	-0.598	-0.344	-0.194	-0.324	-0.467	-0.229	-0.051	-0.285	-0.165	0.999	0.000	0.837
조사분기	0.025	-0.014	1.000	0.130	0.101	0.073	0.089	0.151	0.148	-0.059	-0.320	0.223	-0.115	0.051	0.000	0.078
합계_건수	-0.585	-0.586	0.130	1.000	0.973	0.672	0.537	0.798	0.600	0.066	-0.023	0.692	-0.014	0.308	0.117	0.640
매매_건수	-0.598	-0.598	0.101	0.973	1.000	0.677	0.554	0.791	0.534	-0.022	-0.055	0.662	-0.114	0.302	0.111	0.633
판결_건수	-0.346	-0.344	0.073	0.672	0.677	1.000	0.604	0.737	0.242	-0.156	-0.080	0.670	-0.225	0.202	0.100	0.428
교환_건수	-0.195	-0.194	0.089	0.537	0.554	0.604	1.000	0.685	0.082	-0.320	-0.112	0.665	-0.396	0.189	0.107	0.405
증여_건수	-0.323	-0.324	0.151	0.798	0.791	0.737	0.685	1.000	0.265	-0.208	-0.135	0.775	-0.294	0.257	0.115	0.520
분양권_건수	-0.461	-0.467	0.148	0.600	0.534	0.242	0.082	0.265	1.000	NaN	NaN	0.216	NaN	0.216	0.091	0.418
분양권전매_건수	-0.233	-0.229	-0.059	0.066	-0.022	-0.156	-0.320	-0.208	NaN	1.000	0.324	NaN	0.856	0.214	0.148	0.344
분양권검인_건수	-0.064	-0.051	-0.320	-0.023	-0.055	-0.080	-0.112	-0.135	NaN	0.324	1.000	NaN	0.289	0.094	0.066	0.154
기타_건수	-0.280	-0.285	0.223	0.692	0.662	0.670	0.665	0.775	0.216	NaN	NaN	1.000	NaN	0.216	0.077	0.438
기타_건수.1	-0.170	-0.165	-0.115	-0.014	-0.114	-0.225	-0.396	-0.294	NaN	0.856	0.289	NaN	1.000	0.195	0.156	0.374
지역명	0.901	0.999	0.051	0.308	0.302	0.202	0.189	0.257	0.216	0.214	0.094	0.216	0.195	1.000	0.000	0.999
거래유형	0.028	0.000	0.000	0.117	0.111	0.100	0.107	0.115	0.091	0.148	0.066	0.077	0.156	0.000	1.000	0.000
지역구분 레벨	0.803	0.837	0.078	0.640	0.633	0.428	0.405	0.520	0.418	0.344	0.154	0.438	0.374	0.999	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	지역구분 레벨
15412	15413	44810	예산군	200704	1	532	300	7	3	74	133	<NA>	<NA>	15	<NA>	1
12695	12696	44770	서천군	201112	4	101	91	0	0	10	0	<NA>	<NA>	0	<NA>	1
8541	8542	44230	논산시	202102	2	533	341	11	3	127	1	0	0	50	0	1
3284	3285	44133	서북구	201201	5	505	240	1	0	56	203	<NA>	<NA>	5	<NA>	2
11699	11700	44760	부여군	201208	4	66	53	0	0	13	0	<NA>	<NA>	0	<NA>	1
3360	3361	44133	서북구	201802	3	2904	520	1	0	35	2347	0	0	1	0	2
12931	12932	44770	서천군	201701	4	63	44	0	0	19	<NA>	0	0	<NA>	0	1
5636	5637	44180	보령시	202205	3	242	147	2	0	23	5	0	0	65	0	1
3614	3615	44133	서북구	202201	2	641	521	2	6	69	2	0	0	41	0	2
2729	2730	44131	동남구	202010	4	1511	619	1	0	59	<NA>	163	0	<NA>	669	2

	번호	지역코드	지역명	조사분기	거래유형	합계_건수	매매_건수	판결_건수	교환_건수	증여_건수	분양권_건수	분양권전매_건수	분양권검인_건수	기타_건수	기타_건수.1	지역구분 레벨
3384	3385	44133	서북구	201812	2	382	248	1	4	69	0	0	0	60	0	2
3454	3455	44133	서북구	201704	4	1378	509	1	0	21	<NA>	147	0	<NA>	700	2
401	402	44000	충남	201202	3	6025	4550	31	7	324	1091	<NA>	<NA>	22	<NA>	0
10691	10692	44710	금산군	200909	4	68	57	0	0	10	0	<NA>	<NA>	1	<NA>	1
115	116	44000	충남	200707	3	4072	3128	8	2	229	675	<NA>	<NA>	30	<NA>	0
2128	2129	44131	동남구	201204	1	1332	993	4	4	102	22	<NA>	<NA>	207	<NA>	2
13557	13558	44790	청양군	201305	3	24	17	0	0	4	3	<NA>	<NA>	0	<NA>	1
8583	8584	44230	논산시	202107	2	697	579	3	6	61	0	0	0	48	0	1
16622	16623	44825	태안군	200812	3	70	61	0	0	9	0	<NA>	<NA>	0	<NA>	1
7384	7385	44210	서산시	201801	2	1022	736	2	16	143	0	0	0	125	0	1

Overview

Variables

Common Values

Length

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample