gimi9 Pandas Profiling

Dataset statistics

Number of variables	19
Number of observations	2759
Missing cells	11810
Missing cells (%)	22.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	452.8 KiB
Average record size in memory	168.0 B

Variable types

Text	3
Categorical	1
Unsupported	4
Numeric	11

Dataset

Description	관리_공급_대상_pk,관리_입주자모집_공고_승인_pk,주택_구분_코드,주택_관리_번호,모델_번호,주택_형별_면적,전용_면적,주거_공용_면적,공급_면적_계,기타_공용_면적,지하_주차장_면적,계약_면적,대지_지분,공급_세대_수,층_수,공급방식_구분_코드,형별_공급_총_세대_수,특별_공급_세대_수,작업_일자
Author	서울특별시
URL	https://data.seoul.go.kr/dataList/OA-15684/S/1/datasetView.do

Alerts

`전용_면적` is highly overall correlated with `주거_공용_면적` and 3 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 `계약_면적`	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 3 other fields	High correlation
`주택_관리_번호` has 774 (28.1%) missing values	Missing
`모델_번호` has 2759 (100.0%) missing values	Missing
`공급방식_구분_코드` has 2759 (100.0%) missing values	Missing
`형별_공급_총_세대_수` has 2759 (100.0%) missing values	Missing
`특별_공급_세대_수` has 2759 (100.0%) missing values	Missing
`전용_면적` is highly skewed (γ1 = 49.82806827)	Skewed
`주거_공용_면적` is highly skewed (γ1 = 49.99872972)	Skewed
`공급_면적_계` is highly skewed (γ1 = 44.98844043)	Skewed
`지하_주차장_면적` is highly skewed (γ1 = 34.37207313)	Skewed
`계약_면적` is highly skewed (γ1 = 46.44267014)	Skewed
`대지_지분` is highly skewed (γ1 = 39.99743689)	Skewed
`층_수` is highly skewed (γ1 = 34.50365074)	Skewed
`관리_공급_대상_pk` has unique values	Unique
`모델_번호` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`공급방식_구분_코드` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`형별_공급_총_세대_수` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`특별_공급_세대_수` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`주택_형별_면적` has 2749 (99.6%) zeros	Zeros
`주거_공용_면적` has 93 (3.4%) zeros	Zeros
`공급_면적_계` has 32 (1.2%) zeros	Zeros
`기타_공용_면적` has 265 (9.6%) zeros	Zeros
`지하_주차장_면적` has 881 (31.9%) zeros	Zeros
`층_수` has 858 (31.1%) zeros	Zeros

Reproduction

Analysis started	2024-05-11 05:28:30.385705
Analysis finished	2024-05-11 05:29:23.962764
Duration	53.58 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

관리_공급_대상_pk
Text

UNIQUE

Distinct	2759
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	21.7 KiB

Length

Max length	28
Median length	15
Mean length	15.047119
Min length	15

Characters and Unicode

Total characters	41515
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2759 ?
Unique (%)	100.0%

Sample

1st row	11110-100000141
2nd row	11110-100000142
3rd row	11110-100000143
4th row	11110-100000144
5th row	11140-100000141

Value	Count	Frequency (%)
11110-100000141	1	< 0.1%
11650-100000188	1	< 0.1%
11650-100000198	1	< 0.1%
11650-100000181	1	< 0.1%
11650-100000182	1	< 0.1%
11650-100000183	1	< 0.1%
11650-100000184	1	< 0.1%
11650-100000185	1	< 0.1%
11650-100000186	1	< 0.1%
11650-100000187	1	< 0.1%
Other values (2749)	2749	99.6%

Most occurring characters

Value	Count	Frequency (%)
0	17417	42.0%
1	10079	24.3%
-	2759	6.6%
2	2067	5.0%
4	2021	4.9%
5	1672	4.0%
3	1490	3.6%
6	1407	3.4%
7	1296	3.1%
8	816	2.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	38756	93.4%
Dash Punctuation	2759	6.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	17417	44.9%
1	10079	26.0%
2	2067	5.3%
4	2021	5.2%
5	1672	4.3%
3	1490	3.8%
6	1407	3.6%
7	1296	3.3%
8	816	2.1%
9	491	1.3%

Dash Punctuation

Value	Count	Frequency (%)
-	2759	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	41515	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	17417	42.0%
1	10079	24.3%
-	2759	6.6%
2	2067	5.0%
4	2021	4.9%
5	1672	4.0%
3	1490	3.6%
6	1407	3.4%
7	1296	3.1%
8	816	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	41515	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	17417	42.0%
1	10079	24.3%
-	2759	6.6%
2	2067	5.0%
4	2021	4.9%
5	1672	4.0%
3	1490	3.6%
6	1407	3.4%
7	1296	3.1%
8	816	2.0%

관리_입주자모집_공고_승인_pk
Text

Distinct	219
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Memory size	21.7 KiB

Length

Max length	28
Median length	15
Mean length	15.501993
Min length	8

Characters and Unicode

Total characters	42770
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	0.4%

Sample

1st row	11110-100007026
2nd row	11110-100007026
3rd row	11110-100007026
4th row	11110-100007026
5th row	11140-15

Value	Count	Frequency (%)
11440-100009861	123	4.5%
11200-100042354	88	3.2%
11710-100000100000001	58	2.1%
11500-100015410	58	2.1%
11710-100046311	58	2.1%
11440-100007581	53	1.9%
11740-100019542	50	1.8%
11260-100012474	49	1.8%
11140-100006842	46	1.7%
11710-100045030	43	1.6%
Other values (209)	2133	77.3%

Most occurring characters

Value	Count	Frequency (%)
0	14809	34.6%
1	11421	26.7%
-	2759	6.5%
4	2535	5.9%
5	2234	5.2%
2	2013	4.7%
6	1900	4.4%
3	1542	3.6%
7	1422	3.3%
8	1391	3.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	40011	93.5%
Dash Punctuation	2759	6.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	14809	37.0%
1	11421	28.5%
4	2535	6.3%
5	2234	5.6%
2	2013	5.0%
6	1900	4.7%
3	1542	3.9%
7	1422	3.6%
8	1391	3.5%
9	744	1.9%

Dash Punctuation

Value	Count	Frequency (%)
-	2759	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	42770	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	14809	34.6%
1	11421	26.7%
-	2759	6.5%
4	2535	5.9%
5	2234	5.2%
2	2013	4.7%
6	1900	4.4%
3	1542	3.6%
7	1422	3.3%
8	1391	3.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	42770	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	14809	34.6%
1	11421	26.7%
-	2759	6.5%
4	2535	5.9%
5	2234	5.2%
2	2013	4.7%
6	1900	4.4%
3	1542	3.6%
7	1422	3.3%
8	1391	3.3%

주택_구분_코드
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	21.7 KiB

1	2317
2	442

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	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	2317	84.0%
2	442	16.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	2317	84.0%
2	442	16.0%

주택_관리_번호
Text

MISSING

Distinct	1267
Distinct (%)	63.8%
Missing	774
Missing (%)	28.1%
Memory size	21.7 KiB

Length

Max length	22
Median length	16
Mean length	5.7309824
Min length	1

Characters and Unicode

Total characters	11376
Distinct characters	109
Distinct categories	11 ?
Distinct scripts	3 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1065 ?
Unique (%)	53.7%

Sample

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

Value	Count	Frequency (%)
도시형생활주택	131	5.9%
a	31	1.4%
b	30	1.3%
도시형생활주택-원룸형	23	1.0%
아파트	22	1.0%
101동	22	1.0%
106동	21	0.9%
102동	21	0.9%
103동	20	0.9%
107동	20	0.9%
Other values (1095)	1894	84.7%

Most occurring characters

Value	Count	Frequency (%)
1	1215	10.7%
0	1185	10.4%
2	759	6.7%
4	542	4.8%
3	506	4.4%
-	423	3.7%
5	357	3.1%
형	336	3.0%
동	304	2.7%
A	277	2.4%
Other values (99)	5472	48.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5411	47.6%
Other Letter	3021	26.6%
Uppercase Letter	1498	13.2%
Dash Punctuation	423	3.7%
Other Punctuation	287	2.5%
Space Separator	250	2.2%
Lowercase Letter	171	1.5%
Close Punctuation	148	1.3%
Open Punctuation	148	1.3%
Math Symbol	15	0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
형	336	11.1%
동	304	10.1%
주	230	7.6%
택	230	7.6%
호	228	7.5%
시	206	6.8%
생	206	6.8%
활	206	6.8%
도	196	6.5%
입	87	2.9%
Other values (44)	792	26.2%

Uppercase Letter

Value	Count	Frequency (%)
A	277	18.5%
B	273	18.2%
C	146	9.7%
T	145	9.7%
D	106	7.1%
E	105	7.0%
P	70	4.7%
F	66	4.4%
G	53	3.5%
H	50	3.3%
Other values (16)	207	13.8%

Decimal Number

Value	Count	Frequency (%)
1	1215	22.5%
0	1185	21.9%
2	759	14.0%
4	542	10.0%
3	506	9.4%
5	357	6.6%
6	252	4.7%
8	223	4.1%
9	212	3.9%
7	160	3.0%

Lowercase Letter

Value	Count	Frequency (%)
e	51	29.8%
p	50	29.2%
y	50	29.2%
a	8	4.7%
b	4	2.3%
c	3	1.8%
d	2	1.2%
h	1	0.6%
f	1	0.6%
g	1	0.6%

Other Punctuation

Value	Count	Frequency (%)
.	235	81.9%
,	49	17.1%
'	3	1.0%

Dash Punctuation

Value	Count	Frequency (%)
-	423	100.0%

Space Separator

Value	Count	Frequency (%)
	250	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	148	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	148	100.0%

Math Symbol

Value	Count	Frequency (%)
~	15	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	6686	58.8%
Hangul	3021	26.6%
Latin	1669	14.7%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
형	336	11.1%
동	304	10.1%
주	230	7.6%
택	230	7.6%
호	228	7.5%
시	206	6.8%
생	206	6.8%
활	206	6.8%
도	196	6.5%
입	87	2.9%
Other values (44)	792	26.2%

Latin

Value	Count	Frequency (%)
A	277	16.6%
B	273	16.4%
C	146	8.7%
T	145	8.7%
D	106	6.4%
E	105	6.3%
P	70	4.2%
F	66	4.0%
G	53	3.2%
e	51	3.1%
Other values (26)	377	22.6%

Common

Value	Count	Frequency (%)
1	1215	18.2%
0	1185	17.7%
2	759	11.4%
4	542	8.1%
3	506	7.6%
-	423	6.3%
5	357	5.3%
6	252	3.8%
	250	3.7%
.	235	3.5%
Other values (9)	962	14.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8355	73.4%
Hangul	3021	26.6%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	1215	14.5%
0	1185	14.2%
2	759	9.1%
4	542	6.5%
3	506	6.1%
-	423	5.1%
5	357	4.3%
A	277	3.3%
B	273	3.3%
6	252	3.0%
Other values (45)	2566	30.7%

Hangul

Value	Count	Frequency (%)
형	336	11.1%
동	304	10.1%
주	230	7.6%
택	230	7.6%
호	228	7.5%
시	206	6.8%
생	206	6.8%
활	206	6.8%
도	196	6.5%
입	87	2.9%
Other values (44)	792	26.2%

모델_번호
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	2759
Missing (%)	100.0%
Memory size	24.4 KiB

주택_형별_면적
Real number (ℝ)

ZEROS

Distinct	11
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.32477408

Minimum	0
Maximum	126.39
Zeros	2749
Zeros (%)	99.6%
Negative	0
Negative (%)	0.0%
Memory size	24.4 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	5.5605069
Coefficient of variation (CV)	17.121153
Kurtosis	330.35959
Mean	0.32477408
Median Absolute Deviation (MAD)	0
Skewness	17.889153
Sum	896.0517
Variance	30.919237
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0.0	2749	99.6%
40.66	1	< 0.1%
102.49	1	< 0.1%
116.47	1	< 0.1%
69.41	1	< 0.1%
126.39	1	< 0.1%
84.6921	1	< 0.1%
101.3957	1	< 0.1%
84.918	1	< 0.1%
84.8935	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	2749	99.6%
40.66	1	< 0.1%
69.41	1	< 0.1%
84.6921	1	< 0.1%
84.7324	1	< 0.1%
84.8935	1	< 0.1%
84.918	1	< 0.1%
101.3957	1	< 0.1%
102.49	1	< 0.1%
116.47	1	< 0.1%

Value	Count	Frequency (%)
126.39	1	< 0.1%
116.47	1	< 0.1%
102.49	1	< 0.1%
101.3957	1	< 0.1%
84.918	1	< 0.1%
84.8935	1	< 0.1%
84.7324	1	< 0.1%
84.6921	1	< 0.1%
69.41	1	< 0.1%
40.66	1	< 0.1%

전용_면적
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1654
Distinct (%)	59.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.021244

Minimum	11.32
Maximum	19685
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	24.4 KiB

Quantile statistics

Minimum	11.32
5-th percentile	14.598
Q1	24.33
median	38.98
Q3	54.22
95-th percentile	111.5354
Maximum	19685
Range	19673.68
Interquartile range (IQR)	29.89

Descriptive statistics

Standard deviation	381.09484
Coefficient of variation (CV)	6.8026844
Kurtosis	2556.6087
Mean	56.021244
Median Absolute Deviation (MAD)	14.84
Skewness	49.828068
Sum	154562.61
Variance	145233.28
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27.51	28	1.0%
28.0	19	0.7%
19.685	15	0.5%
16.959	14	0.5%
51.08	13	0.5%
22.6	12	0.4%
12.49	12	0.4%
13.25	11	0.4%
26.77	11	0.4%
13.35	11	0.4%
Other values (1644)	2613	94.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11.32	1	< 0.1%
12.01	2	0.1%
12.0192	1	< 0.1%
12.03	1	< 0.1%
12.0478	1	< 0.1%
12.05	1	< 0.1%
12.1	1	< 0.1%
12.1192	2	0.1%
12.16	1	< 0.1%
12.1722	1	< 0.1%

Value	Count	Frequency (%)
19685.0	1	< 0.1%
3397.9	1	< 0.1%
532.62	1	< 0.1%
340.34	1	< 0.1%
315.02	1	< 0.1%
303.24	1	< 0.1%
245.09	1	< 0.1%
244.783	1	< 0.1%
244.749	1	< 0.1%
244.2033	1	< 0.1%

주거_공용_면적
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	1564
Distinct (%)	56.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.427464

Minimum	0
Maximum	11614
Zeros	93
Zeros (%)	3.4%
Negative	0
Negative (%)	0.0%
Memory size	24.4 KiB

Quantile statistics

Minimum	0
5-th percentile	4.42
Q1	8.1735
median	11.197
Q3	18.718
95-th percentile	33.06694
Maximum	11614
Range	11614
Interquartile range (IQR)	10.5445

Descriptive statistics

Standard deviation	224.98685
Coefficient of variation (CV)	11.580866
Kurtosis	2563.2563
Mean	19.427464
Median Absolute Deviation (MAD)	4.037
Skewness	49.99873
Sum	53600.374
Variance	50619.084
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	93	3.4%
7.16	18	0.7%
9.15	16	0.6%
9.5	15	0.5%
7.6	15	0.5%
8.764	14	0.5%
8.53	14	0.5%
6.74	11	0.4%
6.43	11	0.4%
10.24	11	0.4%
Other values (1554)	2541	92.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	93	3.4%
1.13	1	< 0.1%
1.965	1	< 0.1%
2.15	1	< 0.1%
2.205	2	0.1%
2.32	1	< 0.1%
2.35	1	< 0.1%
2.36	2	0.1%
2.37	1	< 0.1%
2.39	2	0.1%

Value	Count	Frequency (%)
11614.0	1	< 0.1%
2216.56	1	< 0.1%
87.983	1	< 0.1%
87.4	1	< 0.1%
87.292	1	< 0.1%
87.281	1	< 0.1%
75.7011	1	< 0.1%
64.78	1	< 0.1%
63.79	1	< 0.1%
62.898	2	0.1%

공급_면적_계
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	1805
Distinct (%)	65.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	205.74955

Minimum	0
Maximum	281593
Zeros	32
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	24.4 KiB

Quantile statistics

Minimum	0
5-th percentile	21.95
Q1	34.83
median	50.55
Q3	69.475
95-th percentile	141.86798
Maximum	281593
Range	281593
Interquartile range (IQR)	34.645

Descriptive statistics

Standard deviation	5751.3328
Coefficient of variation (CV)	27.953077
Kurtosis	2126.5517
Mean	205.74955
Median Absolute Deviation (MAD)	16.6328
Skewness	44.98844
Sum	567662.99
Variance	33077830
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	32	1.2%
37.5	18	0.7%
34.83	15	0.5%
25.723	14	0.5%
36.66	14	0.5%
37.12	11	0.4%
22.842	10	0.4%
23.57	10	0.4%
35.4	10	0.4%
32.86	10	0.4%
Other values (1795)	2615	94.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	32	1.2%
8.24	1	< 0.1%
8.25	4	0.1%
8.58	1	< 0.1%
8.87	1	< 0.1%
9.37	1	< 0.1%
11.32	1	< 0.1%
12.05	1	< 0.1%
12.79	1	< 0.1%
13.21	1	< 0.1%

Value	Count	Frequency (%)
281593.0	1	< 0.1%
109559.0	1	< 0.1%
5614.46	1	< 0.1%
532.62	1	< 0.1%
355.6	1	< 0.1%
332.766	1	< 0.1%
332.03	1	< 0.1%
331.042	1	< 0.1%
330.493	1	< 0.1%
316.84	1	< 0.1%

기타_공용_면적
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1354
Distinct (%)	49.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.9081553

Minimum	0
Maximum	273.5651
Zeros	265
Zeros (%)	9.6%
Negative	0
Negative (%)	0.0%
Memory size	24.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.76
median	2.64
Q3	7.065
95-th percentile	50.31722
Maximum	273.5651
Range	273.5651
Interquartile range (IQR)	6.305

Descriptive statistics

Standard deviation	19.747989
Coefficient of variation (CV)	2.2168438
Kurtosis	37.133763
Mean	8.9081553
Median Absolute Deviation (MAD)	2.417
Skewness	4.9769002
Sum	24577.601
Variance	389.98308
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	265	9.6%
0.17	54	2.0%
0.18	35	1.3%
0.75	26	0.9%
0.42	24	0.9%
0.78	20	0.7%
1.27	19	0.7%
0.76	18	0.7%
0.74	16	0.6%
3.857	16	0.6%
Other values (1344)	2266	82.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	265	9.6%
0.081	2	0.1%
0.11	10	0.4%
0.12	2	0.1%
0.13	1	< 0.1%
0.1312	1	< 0.1%
0.1336	2	0.1%
0.14	1	< 0.1%
0.15	12	0.4%
0.17	54	2.0%

Value	Count	Frequency (%)
273.5651	1	< 0.1%
270.49	1	< 0.1%
202.89	1	< 0.1%
154.92	1	< 0.1%
146.77	1	< 0.1%
144.35	1	< 0.1%
136.11	1	< 0.1%
127.2164	1	< 0.1%
127.1787	1	< 0.1%
126.9024	1	< 0.1%

지하_주차장_면적
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	1173
Distinct (%)	42.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.882579

Minimum	0
Maximum	2387.21
Zeros	881
Zeros (%)	31.9%
Negative	0
Negative (%)	0.0%
Memory size	24.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	11.34
Q3	27.5206
95-th percentile	77.77191
Maximum	2387.21
Range	2387.21
Interquartile range (IQR)	27.5206

Descriptive statistics

Standard deviation	52.029046
Coefficient of variation (CV)	2.4915048
Kurtosis	1552.2593
Mean	20.882579
Median Absolute Deviation (MAD)	11.34
Skewness	34.372073
Sum	57615.036
Variance	2707.0216
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	881	31.9%
4.42	24	0.9%
12.3	17	0.6%
37.895	16	0.6%
7.189	14	0.5%
4.38	12	0.4%
4.33	12	0.4%
6.99	12	0.4%
4.5	11	0.4%
9.77	11	0.4%
Other values (1163)	1749	63.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	881	31.9%
1.58	3	0.1%
1.59	1	< 0.1%
1.604	5	0.2%
1.64	1	< 0.1%
1.65	1	< 0.1%
1.67	1	< 0.1%
1.677	4	0.1%
1.68	1	< 0.1%
1.698	5	0.2%

Value	Count	Frequency (%)
2387.21	1	< 0.1%
241.29	1	< 0.1%
141.7539	1	< 0.1%
139.7012	1	< 0.1%
134.1352	1	< 0.1%
132.6848	1	< 0.1%
132.024	1	< 0.1%
132.006	1	< 0.1%
131.409	1	< 0.1%
131.171	1	< 0.1%

계약_면적
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1844
Distinct (%)	66.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	102.32394

Minimum	0
Maximum	28302
Zeros	5
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	24.4 KiB

Quantile statistics

Minimum	0
5-th percentile	29.36
Q1	39.805
median	64.51
Q3	106.46
95-th percentile	228.5583
Maximum	28302
Range	28302
Interquartile range (IQR)	66.655

Descriptive statistics

Standard deviation	564.08331
Coefficient of variation (CV)	5.512721
Kurtosis	2282.6395
Mean	102.32394
Median Absolute Deviation (MAD)	27.68
Skewness	46.44267
Sum	282311.74
Variance	318189.98
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
35.014	14	0.5%
36.83	13	0.5%
37.68	13	0.5%
33.01	12	0.4%
35.4	11	0.4%
37.12	11	0.4%
55.83	11	0.4%
23.68	10	0.4%
33.76	10	0.4%
36.64	10	0.4%
Other values (1834)	2644	95.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	5	0.2%
7.41	1	< 0.1%
10.08	1	< 0.1%
17.06	1	< 0.1%
17.87	1	< 0.1%
18.7	1	< 0.1%
18.83	1	< 0.1%
20.08	1	< 0.1%
20.13	1	< 0.1%
20.26	1	< 0.1%

Value	Count	Frequency (%)
28302.0	1	< 0.1%
8275.2351	1	< 0.1%
1044.4	1	< 0.1%
517.91	1	< 0.1%
478.457	1	< 0.1%
477.7	1	< 0.1%
476.054	1	< 0.1%
475.243	1	< 0.1%
451.4716	1	< 0.1%
447.68	1	< 0.1%

대지_지분
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1669
Distinct (%)	60.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	43.524435

Minimum	2.33
Maximum	24063
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	24.4 KiB

Quantile statistics

Minimum	2.33
5-th percentile	8.616
Q1	14.7
median	22.55
Q3	32.5205
95-th percentile	68.31533
Maximum	24063
Range	24060.67
Interquartile range (IQR)	17.8205

Descriptive statistics

Standard deviation	532.83087
Coefficient of variation (CV)	12.242109
Kurtosis	1676.2383
Mean	43.524435
Median Absolute Deviation (MAD)	8.36
Skewness	39.997437
Sum	120083.92
Variance	283908.73
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18.45	27	1.0%
14.73	20	0.7%
18.78	19	0.7%
14.86	18	0.7%
10.328	14	0.5%
22.8	11	0.4%
12.61	11	0.4%
14.29	11	0.4%
9.92	11	0.4%
17.96	11	0.4%
Other values (1659)	2606	94.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.33	1	< 0.1%
2.36	1	< 0.1%
2.77	1	< 0.1%
2.79	1	< 0.1%
2.877	2	0.1%
3.54	1	< 0.1%
3.61	1	< 0.1%
3.7	2	0.1%
3.77	1	< 0.1%
3.84	2	0.1%

Value	Count	Frequency (%)
24063.0	1	< 0.1%
14152.0	1	< 0.1%
2156.8009	1	< 0.1%
239.374	1	< 0.1%
239.34	1	< 0.1%
238.258	1	< 0.1%
237.827	1	< 0.1%
235.725	1	< 0.1%
234.995	2	0.1%
234.921	2	0.1%

공급_세대_수
Real number (ℝ)

Distinct	145
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.56506

Minimum	0
Maximum	756
Zeros	5
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	24.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	3
Q3	10
95-th percentile	62
Maximum	756
Range	756
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	38.603195
Coefficient of variation (CV)	2.8457814
Kurtosis	124.97594
Mean	13.56506
Median Absolute Deviation (MAD)	2
Skewness	8.9963083
Sum	37426
Variance	1490.2067
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1128	40.9%
2	216	7.8%
4	196	7.1%
5	168	6.1%
3	117	4.2%
8	83	3.0%
12	75	2.7%
6	67	2.4%
10	65	2.4%
7	36	1.3%
Other values (135)	608	22.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5	0.2%
1	1128	40.9%
2	216	7.8%
3	117	4.2%
4	196	7.1%
5	168	6.1%
6	67	2.4%
7	36	1.3%
8	83	3.0%
9	28	1.0%

Value	Count	Frequency (%)
756	1	< 0.1%
735	1	< 0.1%
507	1	< 0.1%
474	1	< 0.1%
440	1	< 0.1%
294	1	< 0.1%
290	1	< 0.1%
281	1	< 0.1%
280	3	0.1%
262	1	< 0.1%

층_수
Real number (ℝ)

SKEWED ZEROS

Distinct	47
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.0264589

Minimum	0
Maximum	2345
Zeros	858
Zeros (%)	31.1%
Negative	0
Negative (%)	0.0%
Memory size	24.4 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	64.6371
Coefficient of variation (CV)	8.0530033
Kurtosis	1240.062
Mean	8.0264589
Median Absolute Deviation (MAD)	4
Skewness	34.503651
Sum	22145
Variance	4177.9547
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	858	31.1%
6	326	11.8%
5	244	8.8%
4	196	7.1%
2	189	6.9%
3	147	5.3%
1	134	4.9%
7	86	3.1%
20	57	2.1%
12	54	2.0%
Other values (37)	468	17.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	858	31.1%
1	134	4.9%
2	189	6.9%
3	147	5.3%
4	196	7.1%
5	244	8.8%
6	326	11.8%
7	86	3.1%
8	15	0.5%
9	34	1.2%

Value	Count	Frequency (%)
2345	2	0.1%
456	1	< 0.1%
345	1	< 0.1%
235	1	< 0.1%
234	1	< 0.1%
47	11	0.4%
45	4	0.1%
39	4	0.1%
38	4	0.1%
37	1	< 0.1%

공급방식_구분_코드
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	2759
Missing (%)	100.0%
Memory size	24.4 KiB

형별_공급_총_세대_수
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	2759
Missing (%)	100.0%
Memory size	24.4 KiB

특별_공급_세대_수
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	2759
Missing (%)	100.0%
Memory size	24.4 KiB

작업_일자
Real number (ℝ)

Distinct	57
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20198448

Minimum	20180927
Maximum	20240507
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	24.4 KiB

Quantile statistics

Minimum	20180927
5-th percentile	20180927
Q1	20180927
median	20180927
Q3	20221115
95-th percentile	20240208
Maximum	20240507
Range	59580
Interquartile range (IQR)	40188

Descriptive statistics

Standard deviation	23388.223
Coefficient of variation (CV)	0.0011579218
Kurtosis	-1.1434873
Mean	20198448
Median Absolute Deviation (MAD)	0
Skewness	0.79689496
Sum	5.5727518 × 10¹⁰
Variance	5.4700897 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20180927	1565	56.7%
20240102	106	3.8%
20240208	100	3.6%
20230411	88	3.2%
20230310	64	2.3%
20230104	58	2.1%
20191016	56	2.0%
20211029	49	1.8%
20240420	33	1.2%
20190629	32	1.2%
Other values (47)	608	22.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20180927	1565	56.7%
20181114	5	0.2%
20181215	14	0.5%
20190108	13	0.5%
20190214	6	0.2%
20190219	19	0.7%
20190307	20	0.7%
20190328	8	0.3%
20190529	9	0.3%
20190629	32	1.2%

Value	Count	Frequency (%)
20240507	22	0.8%
20240425	5	0.2%
20240420	33	1.2%
20240227	26	0.9%
20240221	30	1.1%
20240208	100	3.6%
20240102	106	3.8%
20230929	11	0.4%
20230912	30	1.1%
20230831	15	0.5%

Phik (φk)
Auto

Heatmap
Table

	주택_구분_코드	주택_형별_면적	전용_면적	주거_공용_면적	공급_면적_계	기타_공용_면적	지하_주차장_면적	계약_면적	대지_지분	공급_세대_수	층_수	작업_일자
주택_구분_코드	1.000	0.000	0.000	0.000	0.000	0.105	0.000	0.000	0.000	0.041	0.000	0.520
주택_형별_면적	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
전용_면적	0.000	0.000	1.000	0.943	0.000	0.626	0.943	0.943	0.000	0.104	0.000	0.225
주거_공용_면적	0.000	0.000	0.943	1.000	0.000	0.626	0.943	0.943	0.000	0.104	0.000	0.286
공급_면적_계	0.000	0.000	0.000	0.000	1.000	0.064	0.000	0.000	0.000	0.104	0.000	0.000
기타_공용_면적	0.105	0.000	0.626	0.626	0.064	1.000	0.788	0.626	0.000	0.119	0.000	0.462
지하_주차장_면적	0.000	0.000	0.943	0.943	0.000	0.788	1.000	0.943	0.000	0.104	0.000	0.286
계약_면적	0.000	0.000	0.943	0.943	0.000	0.626	0.943	1.000	0.943	0.104	0.000	0.286
대지_지분	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.943	1.000	0.000	0.000	NaN
공급_세대_수	0.041	0.000	0.104	0.104	0.104	0.119	0.104	0.104	0.000	1.000	0.000	0.159
층_수	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	NaN
작업_일자	0.520	0.000	0.225	0.286	0.000	0.462	0.286	0.286	NaN	0.159	NaN	1.000

Heatmap
Table

	주택_형별_면적	전용_면적	주거_공용_면적	공급_면적_계	기타_공용_면적	지하_주차장_면적	계약_면적	대지_지분	공급_세대_수	층_수	작업_일자	주택_구분_코드
주택_형별_면적	1.000	0.076	-0.010	0.068	0.037	0.062	0.064	0.083	-0.057	-0.020	0.114	0.000
전용_면적	0.076	1.000	0.674	0.944	0.407	0.484	0.901	0.894	0.332	0.150	0.062	0.000
주거_공용_면적	-0.010	0.674	1.000	0.772	0.457	0.577	0.783	0.582	0.478	0.301	0.225	0.000
공급_면적_계	0.068	0.944	0.772	1.000	0.424	0.539	0.902	0.848	0.365	0.193	0.102	0.000
기타_공용_면적	0.037	0.407	0.457	0.424	1.000	0.399	0.605	0.246	0.352	0.163	0.313	0.079
지하_주차장_면적	0.062	0.484	0.577	0.539	0.399	1.000	0.678	0.400	0.344	0.227	0.242	0.000
계약_면적	0.064	0.901	0.783	0.902	0.605	0.678	1.000	0.765	0.397	0.176	0.261	0.000
대지_지분	0.083	0.894	0.582	0.848	0.246	0.400	0.765	1.000	0.225	0.097	0.013	0.000
공급_세대_수	-0.057	0.332	0.478	0.365	0.352	0.344	0.397	0.225	1.000	0.214	0.158	0.044
층_수	-0.020	0.150	0.301	0.193	0.163	0.227	0.176	0.097	0.214	1.000	0.100	0.000
작업_일자	0.114	0.062	0.225	0.102	0.313	0.242	0.261	0.013	0.158	0.100	1.000	0.271
주택_구분_코드	0.000	0.000	0.000	0.000	0.079	0.000	0.000	0.000	0.044	0.000	0.271	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

	관리_공급_대상_pk	관리_입주자모집_공고_승인_pk	주택_구분_코드	주택_관리_번호	모델_번호	전용_면적	주거_공용_면적	공급_면적_계	기타_공용_면적	지하_주차장_면적	계약_면적	대지_지분	공급_세대_수	층_수	공급방식_구분_코드	형별_공급_총_세대_수	특별_공급_세대_수	작업_일자
0	11110-100000141	11110-100007026	1	0	<NA>	82.2243	22.0105	104.2348	6.8723	49.8192	160.9263	112.8867	42	3	<NA>	<NA>	<NA>	20221026
1	11110-100000142	11110-100007026	1	0	<NA>	84.9751	22.2912	107.2663	7.1021	51.4859	165.8543	116.6633	2	1	<NA>	<NA>	<NA>	20221026
2	11110-100000143	11110-100007026	1	0	<NA>	84.9974	23.1502	108.1476	7.104	51.4994	166.751	116.6939	2	2	<NA>	<NA>	<NA>	20221026
3	11110-100000144	11110-100007026	1	0	<NA>	84.9826	22.5711	107.5537	7.1027	51.4905	165.1469	116.6736	6	2	<NA>	<NA>	<NA>	20221026
4	11140-100000141	11140-15	1	84.95B	<NA>	84.95	26.01	110.96	4.55	47.33	162.85	48.46	58	0	<NA>	<NA>	<NA>	20180927
5	11140-100000142	11140-15	1	84.98A	<NA>	84.98	27.12	112.1	4.55	47.35	164.01	48.8	84	0	<NA>	<NA>	<NA>	20180927
6	11140-100000143	11140-15	1	84.97C	<NA>	84.97	27.45	112.42	4.55	47.34	164.33	48.9	13	0	<NA>	<NA>	<NA>	20180927
7	11140-100000144	11140-15	1	84.95D	<NA>	84.95	26.49	111.45	4.55	47.33	163.34	48.6	13	0	<NA>	<NA>	<NA>	20180927
8	11140-100000145	11140-15	1	84.98E	<NA>	84.98	26.31	111.3	4.55	47.35	163.2	48.56	13	0	<NA>	<NA>	<NA>	20180927
9	11140-100000161	11140-100005982	1	D	<NA>	31.02	17.28	48.3	2.17	17.84	68.31	13.517	6	0	<NA>	<NA>	<NA>	20180927

	관리_공급_대상_pk	관리_입주자모집_공고_승인_pk	주택_구분_코드	주택_관리_번호	모델_번호	전용_면적	주거_공용_면적	공급_면적_계	기타_공용_면적	지하_주차장_면적	계약_면적	대지_지분	공급_세대_수	층_수	공급방식_구분_코드	형별_공급_총_세대_수	특별_공급_세대_수	작업_일자
2749	11740-100000717	11740-100025383	1	84A	<NA>	84.0964	26.9471	111.0435	8.9081	46.0234	165.975	55.4439	56	11	<NA>	<NA>	<NA>	20240227
2750	11740-100000718	11740-100025383	1	84T	<NA>	84.0941	27.8453	111.9394	8.908	46.0221	166.8695	55.4424	5	10	<NA>	<NA>	<NA>	20240227
2751	11740-100000719	11740-100025383	1	84M	<NA>	84.4162	26.9541	111.3703	8.942	46.1984	166.5107	55.6547	11	12	<NA>	<NA>	<NA>	20240227
2752	11740-100000720	11740-100025383	1	101E	<NA>	101.0804	31.8332	132.9136	10.7073	55.3182	198.9391	66.6413	16	24	<NA>	<NA>	<NA>	20240227
2753	11740-100000721	11740-100025383	1	84I	<NA>	84.0505	25.3018	109.3523	8.9033	45.9983	164.2539	55.4136	35	9	<NA>	<NA>	<NA>	20240227
2754	11740-100000722	11740-100025383	1	84H	<NA>	84.0593	25.9062	109.9655	8.9042	46.0031	164.8728	55.4194	1	4	<NA>	<NA>	<NA>	20240227
2755	11740-100000723	11740-100025383	1	84G	<NA>	84.1277	25.9654	110.0931	8.9115	46.0405	165.0451	55.4645	22	11	<NA>	<NA>	<NA>	20240227
2756	11740-100000724	11740-100025383	1	84Q	<NA>	84.241	30.2844	114.5254	8.9235	46.1025	169.5514	55.5392	2	4	<NA>	<NA>	<NA>	20240227
2757	11740-100000725	11740-100025383	1	101F	<NA>	101.0797	33.2587	134.3384	10.7072	55.3179	200.3635	66.6408	6	23	<NA>	<NA>	<NA>	20240227
2758	11740-100000726	11740-100025383	1	101C	<NA>	101.0459	32.159	133.2049	10.7036	55.2994	199.2079	66.6185	48	27	<NA>	<NA>	<NA>	20240227

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Uppercase Letter

Decimal Number

Lowercase Letter

Other Punctuation

Dash Punctuation

Space Separator

Close Punctuation

Open Punctuation

Math Symbol

Modifier Symbol

Most occurring scripts

Most frequent character per script

Hangul

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Interactions

Correlations

Missing values

Sample