gimi9 Pandas Profiling

Dataset statistics

Number of variables	10
Number of observations	10000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	937.5 KiB
Average record size in memory	96.0 B

Variable types

Categorical	2
Numeric	8

Dataset

Description	대전도시공사 영구임대아파트는 저소득층 주거공급 및 취약계층 주거복지를 위해 제공되는 영구임대아파트 임대현황 자료 입니다.
URL	https://www.data.go.kr/data/15103607/fileData.do

Alerts

`순번` is highly overall correlated with `동`	High correlation
`동` is highly overall correlated with `순번`	High correlation
`임대면적` is highly overall correlated with `전용면적` and 2 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 1 other fields	High correlation
`월임대료` is highly overall correlated with `임대면적` and 3 other fields	High correlation
`임대대상명` is highly overall correlated with `전용면적` and 1 other fields	High correlation
`임대구분` is highly overall correlated with `보증금`	High correlation

Reproduction

Analysis started	2023-12-12 14:14:53.462882
Analysis finished	2023-12-12 14:15:02.821704
Duration	9.36 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

임대대상명
Categorical

HIGH CORRELATION

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

한마음	5076
보라	2463
송강마을	1856
오류동(누리보듬)	605

Length

Max length	9
Median length	3
Mean length	3.3023
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 (%)
한마음	5076	50.8%
보라	2463	24.6%
송강마을	1856	18.6%
오류동(누리보듬)	605	6.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
한마음	5076	50.8%
보라	2463	24.6%
송강마을	1856	18.6%
오류동(누리보듬	605	6.0%

순번
Real number (ℝ)

HIGH CORRELATION

Distinct	5982
Distinct (%)	59.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2509.2606

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

Quantile statistics

Minimum	1
5-th percentile	177
Q1	906.75
median	2084.5
Q3	3632.25
95-th percentile	6382.05
Maximum	7072
Range	7071
Interquartile range (IQR)	2725.5

Descriptive statistics

Standard deviation	1921.7584
Coefficient of variation (CV)	0.76586639
Kurtosis	-0.49602491
Mean	2509.2606
Median Absolute Deviation (MAD)	1286.5
Skewness	0.73711722
Sum	25092606
Variance	3693155.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
846	4	< 0.1%
383	4	< 0.1%
223	4	< 0.1%
284	4	< 0.1%
354	4	< 0.1%
528	4	< 0.1%
160	4	< 0.1%
427	4	< 0.1%
743	4	< 0.1%
688	4	< 0.1%
Other values (5972)	9960	99.6%

Minimum 10 values
Maximum 10 values

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

Value	Count	Frequency (%)
7072	1	< 0.1%
7071	1	< 0.1%
7069	1	< 0.1%
7068	1	< 0.1%
7067	1	< 0.1%
7065	1	< 0.1%
7064	1	< 0.1%
7063	1	< 0.1%
7061	1	< 0.1%
7060	1	< 0.1%

동
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	102.8116

Minimum	101
Maximum	106
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	101
5-th percentile	101
Q1	101
median	103
Q3	104
95-th percentile	106
Maximum	106
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.6115102
Coefficient of variation (CV)	0.015674401
Kurtosis	-0.84737701
Mean	102.8116
Median Absolute Deviation (MAD)	1
Skewness	0.54126768
Sum	1028116
Variance	2.5969651
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
101	2786	27.9%
102	2197	22.0%
103	1811	18.1%
104	1396	14.0%
105	941	9.4%
106	869	8.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
101	2786	27.9%
102	2197	22.0%
103	1811	18.1%
104	1396	14.0%
105	941	9.4%
106	869	8.7%

Value	Count	Frequency (%)
106	869	8.7%
105	941	9.4%
104	1396	14.0%
103	1811	18.1%
102	2197	22.0%
101	2786	27.9%

호
Real number (ℝ)

Distinct	348
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	819.7134

Minimum	101
Maximum	1709
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	101
5-th percentile	116
Q1	419
median	810
Q3	1206
95-th percentile	1505
Maximum	1709
Range	1608
Interquartile range (IQR)	787

Descriptive statistics

Standard deviation	430.78251
Coefficient of variation (CV)	0.5255282
Kurtosis	-1.1773449
Mean	819.7134
Median Absolute Deviation (MAD)	394
Skewness	-0.00015479761
Sum	8197134
Variance	185573.57
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
507	49	0.5%
706	49	0.5%
1204	49	0.5%
708	48	0.5%
1305	47	0.5%
1304	47	0.5%
1402	47	0.5%
1507	47	0.5%
1502	47	0.5%
407	47	0.5%
Other values (338)	9523	95.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
101	35	0.4%
102	31	0.3%
103	40	0.4%
104	28	0.3%
105	39	0.4%
106	36	0.4%
107	38	0.4%
108	45	0.4%
109	41	0.4%
110	37	0.4%

Value	Count	Frequency (%)
1709	3	< 0.1%
1708	3	< 0.1%
1707	3	< 0.1%
1706	3	< 0.1%
1705	2	< 0.1%
1704	3	< 0.1%
1703	3	< 0.1%
1702	2	< 0.1%
1701	4	< 0.1%
1609	4	< 0.1%

임대면적
Real number (ℝ)

HIGH CORRELATION

Distinct	15
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	45.892215

Minimum	40.93
Maximum	84.52
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	40.93
5-th percentile	40.93
Q1	41.69
median	41.69
Q3	48.98
95-th percentile	60.32
Maximum	84.52
Range	43.59
Interquartile range (IQR)	7.29

Descriptive statistics

Standard deviation	6.3415253
Coefficient of variation (CV)	0.13818303
Kurtosis	5.8872821
Mean	45.892215
Median Absolute Deviation (MAD)	0.76
Skewness	1.9827261
Sum	458922.15
Variance	40.214943
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
41.69	3617	36.2%
48.98	1856	18.6%
40.93	1691	16.9%
48.36	841	8.4%
60.32	612	6.1%
46.52	441	4.4%
58.55	329	3.3%
46.535	232	2.3%
42.055	226	2.3%
65.031	41	0.4%
Other values (5)	114	1.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
40.93	1691	16.9%
41.69	3617	36.2%
42.055	226	2.3%
46.52	441	4.4%
46.535	232	2.3%
48.36	841	8.4%
48.98	1856	18.6%
52.662	28	0.3%
58.198	40	0.4%
58.55	329	3.3%

Value	Count	Frequency (%)
84.52	38	0.4%
83.38	6	0.1%
81.86	2	< 0.1%
65.031	41	0.4%
60.32	612	6.1%
58.55	329	3.3%
58.198	40	0.4%
52.662	28	0.3%
48.98	1856	18.6%
48.36	841	8.4%

전용면적
Real number (ℝ)

HIGH CORRELATION

Distinct	15
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.206081

Minimum	19.804
Maximum	57.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	19.804
5-th percentile	27.406
Q1	28.95
median	28.95
Q3	33.87
95-th percentile	39.9
Maximum	57.9
Range	38.096
Interquartile range (IQR)	4.92

Descriptive statistics

Standard deviation	4.50902
Coefficient of variation (CV)	0.14449171
Kurtosis	1.3228635
Mean	31.206081
Median Absolute Deviation (MAD)	0.72
Skewness	0.47550892
Sum	312060.81
Variance	20.331261
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
28.95	3617	36.2%
33.87	1856	18.6%
28.23	1691	16.9%
35.1	841	8.4%
39.9	612	6.1%
32.82	441	4.4%
41.82	329	3.3%
21.914	232	2.3%
19.804	226	2.3%
30.624	41	0.4%
Other values (5)	114	1.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19.804	226	2.3%
21.914	232	2.3%
24.799	28	0.3%
27.406	40	0.4%
28.23	1691	16.9%
28.95	3617	36.2%
30.624	41	0.4%
32.82	441	4.4%
33.87	1856	18.6%
35.1	841	8.4%

Value	Count	Frequency (%)
57.9	6	0.1%
56.46	2	< 0.1%
41.82	329	3.3%
39.9	612	6.1%
39.801	38	0.4%
35.1	841	8.4%
33.87	1856	18.6%
32.82	441	4.4%
30.624	41	0.4%
28.95	3617	36.2%

공용면적
Real number (ℝ)

HIGH CORRELATION

Distinct	15
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.958853

Minimum	12.049
Maximum	25.48
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	12.049
5-th percentile	12.7
Q1	12.74
median	12.74
Q3	15.11
95-th percentile	20.42
Maximum	25.48
Range	13.431
Interquartile range (IQR)	2.37

Descriptive statistics

Standard deviation	2.1501018
Coefficient of variation (CV)	0.15403142
Kurtosis	4.8979199
Mean	13.958853
Median Absolute Deviation (MAD)	0.04
Skewness	2.2265704
Sum	139588.53
Variance	4.6229379
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
12.74	3617	36.2%
15.11	1856	18.6%
12.7	1691	16.9%
13.26	841	8.4%
20.42	612	6.1%
13.7	441	4.4%
16.73	329	3.3%
13.333	232	2.3%
12.049	226	2.3%
18.632	41	0.4%
Other values (5)	114	1.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12.049	226	2.3%
12.7	1691	16.9%
12.74	3617	36.2%
13.26	841	8.4%
13.333	232	2.3%
13.7	441	4.4%
15.088	28	0.3%
15.11	1856	18.6%
16.674	40	0.4%
16.73	329	3.3%

Value	Count	Frequency (%)
25.48	6	0.1%
25.4	2	< 0.1%
24.215	38	0.4%
20.42	612	6.1%
18.632	41	0.4%
16.73	329	3.3%
16.674	40	0.4%
15.11	1856	18.6%
15.088	28	0.3%
13.7	441	4.4%

임대구분
Categorical

HIGH CORRELATION

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

제외2차	2522
제외1차	2506
수급자	2488
일반	2484

Length

Max length	4
Median length	4
Mean length	3.2544
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	제외1차
2nd row	제외2차
3rd row	일반
4th row	일반
5th row	제외2차

Common Values

Value	Count	Frequency (%)
제외2차	2522	25.2%
제외1차	2506	25.1%
수급자	2488	24.9%
일반	2484	24.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
제외2차	2522	25.2%
제외1차	2506	25.1%
수급자	2488	24.9%
일반	2484	24.8%

보증금
Real number (ℝ)

HIGH CORRELATION

Distinct	58
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3635518

Minimum	1859000
Maximum	23224000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1859000
5-th percentile	1988000
Q1	2384000
median	2733000
Q3	4187000
95-th percentile	7467000
Maximum	23224000
Range	21365000
Interquartile range (IQR)	1803000

Descriptive statistics

Standard deviation	2021852.1
Coefficient of variation (CV)	0.55613867
Kurtosis	14.574275
Mean	3635518
Median Absolute Deviation (MAD)	745000
Skewness	2.9476599
Sum	3.635518 × 10¹⁰
Variance	4.0878861 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1988000	914	9.1%
4187000	911	9.1%
2384000	907	9.1%
2733000	885	8.8%
5433000	476	4.8%
3909000	472	4.7%
7467000	456	4.6%
2326000	452	4.5%
2323000	431	4.3%
2661000	428	4.3%
Other values (48)	3668	36.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1859000	60	0.6%
1939000	416	4.2%
1988000	914	9.1%
2058000	59	0.6%
2256000	118	1.2%
2323000	431	4.3%
2326000	452	4.5%
2328000	9	0.1%
2384000	907	9.1%
2409000	205	2.1%

Value	Count	Frequency (%)
23224000	8	0.1%
17869000	10	0.1%
15991000	7	0.1%
15429000	10	0.1%
14470000	6	0.1%
12787000	57	0.6%
11871000	12	0.1%
11555000	57	0.6%
10623000	11	0.1%
9613000	8	0.1%

월임대료
Real number (ℝ)

HIGH CORRELATION

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

Minimum	37030
Maximum	213150
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	37030
5-th percentile	44200
Q1	49200
median	57900
Q3	69300
95-th percentile	100900
Maximum	213150
Range	176120
Interquartile range (IQR)	20100

Descriptive statistics

Standard deviation	17789.582
Coefficient of variation (CV)	0.28381108
Kurtosis	6.1975114
Mean	62681.069
Median Absolute Deviation (MAD)	9600
Skewness	1.770731
Sum	6.2681069 × 10⁸
Variance	3.1646922 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
69300	571	5.7%
48900	541	5.4%
50600	539	5.4%
52800	522	5.2%
100900	456	4.6%
84300	299	3.0%
69600	290	2.9%
57100	275	2.8%
51300	264	2.6%
49200	262	2.6%
Other values (118)	5981	59.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
37030	60	0.6%
40100	55	0.5%
40500	25	0.2%
40970	59	0.6%
42100	53	0.5%
42600	29	0.3%
42900	59	0.6%
43800	57	0.6%
44200	157	1.6%
45700	63	0.6%

Value	Count	Frequency (%)
213150	8	0.1%
164400	10	0.1%
157650	10	0.1%
147310	7	0.1%
133470	6	0.1%
121540	12	0.1%
119800	2	< 0.1%
118140	57	0.6%
116030	9	0.1%
116000	1	< 0.1%

Heatmap
Table

	임대대상명	순번	동	호	임대면적	전용면적	공용면적	임대구분	보증금	월임대료
임대대상명	1.000	0.621	0.508	0.281	0.620	0.836	0.781	0.000	0.634	0.558
순번	0.621	1.000	0.907	0.518	0.608	0.658	0.709	0.000	0.239	0.300
동	0.508	0.907	1.000	0.092	0.675	0.724	0.684	0.000	0.249	0.389
호	0.281	0.518	0.092	1.000	0.186	0.195	0.164	0.000	0.162	0.170
임대면적	0.620	0.608	0.675	0.186	1.000	0.967	0.980	0.000	0.613	0.714
전용면적	0.836	0.658	0.724	0.195	0.967	1.000	0.930	0.000	0.527	0.596
공용면적	0.781	0.709	0.684	0.164	0.980	0.930	1.000	0.000	0.593	0.648
임대구분	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.672	0.595
보증금	0.634	0.239	0.249	0.162	0.613	0.527	0.593	0.672	1.000	0.982
월임대료	0.558	0.300	0.389	0.170	0.714	0.596	0.648	0.595	0.982	1.000

Heatmap
Table

	임대구분	임대대상명
임대구분	1.000	0.000
임대대상명	0.000	1.000

Heatmap
Table

	순번	동	호	임대면적	전용면적	공용면적	보증금	월임대료	임대대상명	임대구분
순번	1.000	0.943	0.163	-0.018	0.128	0.085	-0.125	-0.127	0.423	0.000
동	0.943	1.000	-0.024	0.151	0.254	0.243	-0.032	-0.013	0.351	0.000
호	0.163	-0.024	1.000	0.000	-0.038	-0.002	0.010	0.079	0.171	0.000
임대면적	-0.018	0.151	0.000	1.000	0.837	0.951	0.476	0.638	0.479	0.000
전용면적	0.128	0.254	-0.038	0.837	1.000	0.865	0.325	0.506	0.753	0.000
공용면적	0.085	0.243	-0.002	0.951	0.865	1.000	0.425	0.598	0.671	0.000
보증금	-0.125	-0.032	0.010	0.476	0.325	0.425	1.000	0.910	0.445	0.503
월임대료	-0.127	-0.013	0.079	0.638	0.506	0.598	0.910	1.000	0.379	0.427
임대대상명	0.423	0.351	0.171	0.479	0.753	0.671	0.445	0.379	1.000	0.000
임대구분	0.000	0.000	0.000	0.000	0.000	0.000	0.503	0.427	0.000	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

	임대대상명	순번	동	호	임대면적	전용면적	공용면적	임대구분	보증금	월임대료
11905	송강마을	1358	102	1404	48.98	33.87	15.11	제외1차	3909000	67800
886	보라	887	101	1202	40.93	28.23	12.7	제외2차	2661000	51300
3067	보라	3068	105	302	58.55	41.82	16.73	일반	6053000	97500
10167	한마음	6692	106	1105	41.69	28.95	12.74	일반	4187000	69300
4634	한마음	1159	101	1510	48.36	35.1	13.26	제외2차	3316000	58700
61	보라	62	101	116	40.93	28.23	12.7	제외1차	2323000	42600
12189	송강마을	1642	103	601	48.98	33.87	15.11	제외1차	3909000	69600
1445	보라	1446	102	403	40.93	28.23	12.7	제외1차	2323000	47800
9301	한마음	5826	105	1503	60.32	39.9	20.42	제외1차	3289000	63800
7590	한마음	4115	104	513	41.69	28.95	12.74	제외2차	2733000	52800

	임대대상명	순번	동	호	임대면적	전용면적	공용면적	임대구분	보증금	월임대료
10383	한마음	6908	106	1319	41.69	28.95	12.74	일반	4187000	69300
9814	한마음	6339	106	617	41.69	28.95	12.74	제외2차	2733000	52800
5312	한마음	1837	102	901	41.69	28.95	12.74	수급자	1988000	48900
590	보라	591	101	808	40.93	28.23	12.7	제외2차	2661000	51300
13976	오류동(누리보듬)	789	101	1601	65.031	30.624	18.632	수급자	2875000	57260
4810	한마음	1335	102	215	41.69	28.95	12.74	제외2차	2733000	47900
10130	한마음	6655	106	1016	41.69	28.95	12.74	제외2차	2733000	52800
13216	오류동(누리보듬)	29	101	408	46.535	21.914	13.333	수급자	2058000	40970
12035	송강마을	1488	103	202	48.98	33.87	15.11	일반	7467000	100900
21	보라	22	101	106	40.93	28.23	12.7	제외1차	2323000	42600

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample