Overview

Dataset statistics

Number of variables14
Number of observations1843
Missing cells2218
Missing cells (%)8.6%
Duplicate rows16
Duplicate rows (%)0.9%
Total size in memory208.9 KiB
Average record size in memory116.1 B

Variable types

Categorical4
Text2
DateTime4
Numeric4

Dataset

DescriptionGH에서 공급하는 택지의 입찰공고 및 개찰결과 내역으로써 사업지구명, 공고명, 공급방법, 모집공고일, 접수시작일, 접수종료일, 개찰일, 토지용도, 면적, 입찰금액 등의 정보를 포함하고 있습니다.
Author경기주택도시공사
URLhttps://www.data.go.kr/data/15088703/fileData.do

Alerts

기타유의사항 has constant value ""Constant
Dataset has 16 (0.9%) duplicate rowsDuplicates
면적(제곱미터) is highly overall correlated with 공급예정가액(원) and 2 other fieldsHigh correlation
공급예정가액(원) is highly overall correlated with 면적(제곱미터) and 2 other fieldsHigh correlation
입찰금액(원) is highly overall correlated with 면적(제곱미터) and 3 other fieldsHigh correlation
낙찰률(퍼센트) is highly overall correlated with 입찰금액(원) and 1 other fieldsHigh correlation
사업지구명 is highly overall correlated with 공급방법High correlation
공급방법 is highly overall correlated with 낙찰률(퍼센트) and 2 other fieldsHigh correlation
토지용도 is highly overall correlated with 면적(제곱미터) and 3 other fieldsHigh correlation
사업지구명 is highly imbalanced (52.7%)Imbalance
공급방법 is highly imbalanced (96.8%)Imbalance
면적(제곱미터) has 38 (2.1%) missing valuesMissing
입찰금액(원) has 1081 (58.7%) missing valuesMissing
낙찰률(퍼센트) has 1087 (59.0%) missing valuesMissing

Reproduction

Analysis started2024-03-14 12:11:03.441256
Analysis finished2024-03-14 12:11:09.966020
Duration6.52 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

사업지구명
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct30
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size14.5 KiB
화성동탄(2) 택지개발사업
907 
광교지구 택지개발사업
389 
남양주 다산진건주택지구
182 
고덕국제화계획지구
151 
남양주 다산지금 주택지구
 
87
Other values (25)
127 

Length

Max length24
Median length18
Mean length12.684753
Min length5

Unique

Unique15 ?
Unique (%)0.8%

Sample

1st row고덕국제화계획지구
2nd row고덕국제화계획지구
3rd row고덕국제화계획지구
4th row고덕국제화계획지구
5th row고덕국제화계획지구

Common Values

ValueCountFrequency (%)
화성동탄(2) 택지개발사업 907
49.2%
광교지구 택지개발사업 389
21.1%
남양주 다산진건주택지구 182
 
9.9%
고덕국제화계획지구 151
 
8.2%
남양주 다산지금 주택지구 87
 
4.7%
고양관광문화단지(택지) 37
 
2.0%
연천BIX(은통산업단지) 조성사업 16
 
0.9%
광주역세권 도시개발사업 14
 
0.8%
남양주 다산진건지구 12
 
0.7%
판교제2테크노밸리 도시첨단산업단지 9
 
0.5%
Other values (20) 39
 
2.1%

Length

2024-03-14T21:11:10.220711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
택지개발사업 1319
36.6%
화성동탄(2 907
25.2%
광교지구 389
 
10.8%
남양주 291
 
8.1%
다산진건주택지구 182
 
5.0%
고덕국제화계획지구 151
 
4.2%
주택지구 95
 
2.6%
다산지금 87
 
2.4%
고양관광문화단지(택지 37
 
1.0%
광주역세권 20
 
0.6%
Other values (28) 127
 
3.5%

공고명
Text

Distinct153
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size14.5 KiB
2024-03-14T21:11:11.011052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length57
Median length37
Mean length29.706457
Min length14

Characters and Unicode

Total characters54749
Distinct characters150
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique45 ?
Unique (%)2.4%

Sample

1st row고덕국제화계획지구 업무시설용지 공급 공고
2nd row고덕국제화계획지구 점포겸용 단독주택용지 공급 공고
3rd row고덕국제화계획지구 점포겸용 단독주택용지 공급 공고
4th row고덕국제화계획지구 점포겸용 단독주택용지 공급 공고
5th row고덕국제화계획지구 점포겸용 단독주택용지 공급 공고
ValueCountFrequency (%)
점포겸용 885
 
10.9%
화성동탄(2 879
 
10.8%
단독주택용지 863
 
10.6%
공급공고 489
 
6.0%
공급 476
 
5.9%
근린생활시설용지 314
 
3.9%
공고 305
 
3.8%
광교 266
 
3.3%
및 252
 
3.1%
재공급공고(d20,d21 211
 
2.6%
Other values (181) 3182
39.2%
2024-03-14T21:11:12.212116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6385
 
11.7%
공 3478
 
6.4%
용 2915
 
5.3%
지 2877
 
5.3%
( 1921
 
3.5%
) 1921
 
3.5%
고 1846
 
3.4%
2 1810
 
3.3%
급 1748
 
3.2%
주 1457
 
2.7%
Other values (140) 28391
51.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 38336
70.0%
Space Separator 6385
 
11.7%
Decimal Number 3622
 
6.6%
Open Punctuation 1956
 
3.6%
Close Punctuation 1956
 
3.6%
Other Punctuation 1398
 
2.6%
Uppercase Letter 998
 
1.8%
Dash Punctuation 76
 
0.1%
Math Symbol 22
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
공 3478
 
9.1%
용 2915
 
7.6%
지 2877
 
7.5%
고 1846
 
4.8%
급 1748
 
4.6%
주 1457
 
3.8%
시 1213
 
3.2%
화 1149
 
3.0%
택 1100
 
2.9%
단 1012
 
2.6%
Other values (111) 19541
51.0%
Decimal Number
ValueCountFrequency (%)
2 1810
50.0%
1 588
 
16.2%
0 459
 
12.7%
7 349
 
9.6%
3 183
 
5.1%
4 84
 
2.3%
6 60
 
1.7%
5 58
 
1.6%
8 26
 
0.7%
9 5
 
0.1%
Uppercase Letter
ValueCountFrequency (%)
D 856
85.8%
F 68
 
6.8%
C 23
 
2.3%
I 16
 
1.6%
B 16
 
1.6%
X 16
 
1.6%
A 2
 
0.2%
M 1
 
0.1%
Other Punctuation
ValueCountFrequency (%)
, 1258
90.0%
/ 123
 
8.8%
. 12
 
0.9%
· 5
 
0.4%
Open Punctuation
ValueCountFrequency (%)
( 1921
98.2%
[ 35
 
1.8%
Close Punctuation
ValueCountFrequency (%)
) 1921
98.2%
] 35
 
1.8%
Space Separator
ValueCountFrequency (%)
6385
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 76
100.0%
Math Symbol
ValueCountFrequency (%)
~ 22
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 38336
70.0%
Common 15415
28.2%
Latin 998
 
1.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
공 3478
 
9.1%
용 2915
 
7.6%
지 2877
 
7.5%
고 1846
 
4.8%
급 1748
 
4.6%
주 1457
 
3.8%
시 1213
 
3.2%
화 1149
 
3.0%
택 1100
 
2.9%
단 1012
 
2.6%
Other values (111) 19541
51.0%
Common
ValueCountFrequency (%)
6385
41.4%
( 1921
 
12.5%
) 1921
 
12.5%
2 1810
 
11.7%
, 1258
 
8.2%
1 588
 
3.8%
0 459
 
3.0%
7 349
 
2.3%
3 183
 
1.2%
/ 123
 
0.8%
Other values (11) 418
 
2.7%
Latin
ValueCountFrequency (%)
D 856
85.8%
F 68
 
6.8%
C 23
 
2.3%
I 16
 
1.6%
B 16
 
1.6%
X 16
 
1.6%
A 2
 
0.2%
M 1
 
0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 38336
70.0%
ASCII 16408
30.0%
None 5
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6385
38.9%
( 1921
 
11.7%
) 1921
 
11.7%
2 1810
 
11.0%
, 1258
 
7.7%
D 856
 
5.2%
1 588
 
3.6%
0 459
 
2.8%
7 349
 
2.1%
3 183
 
1.1%
Other values (18) 678
 
4.1%
Hangul
ValueCountFrequency (%)
공 3478
 
9.1%
용 2915
 
7.6%
지 2877
 
7.5%
고 1846
 
4.8%
급 1748
 
4.6%
주 1457
 
3.8%
시 1213
 
3.2%
화 1149
 
3.0%
택 1100
 
2.9%
단 1012
 
2.6%
Other values (111) 19541
51.0%
None
ValueCountFrequency (%)
· 5
100.0%

공급방법
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size14.5 KiB
입찰
1837 
경쟁입찰
 
6

Length

Max length4
Median length2
Mean length2.0065111
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
입찰 1837
99.7%
경쟁입찰 6
 
0.3%

Length

2024-03-14T21:11:12.657958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T21:11:13.011264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
입찰 1837
99.7%
경쟁입찰 6
 
0.3%

모집공고일
Date

Distinct122
Distinct (%)6.6%
Missing0
Missing (%)0.0%
Memory size14.5 KiB
Minimum2008-11-20 00:00:00
Maximum2024-02-22 00:00:00
2024-03-14T21:11:13.339344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:13.713388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

공고접수시작일
Date

Distinct126
Distinct (%)6.8%
Missing0
Missing (%)0.0%
Memory size14.5 KiB
Minimum2008-12-05 00:00:00
Maximum2024-03-04 00:00:00
2024-03-14T21:11:13.942477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:14.183694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

공고접수종료일
Date

Distinct127
Distinct (%)6.9%
Missing0
Missing (%)0.0%
Memory size14.5 KiB
Minimum2008-12-05 00:00:00
Maximum2024-03-04 00:00:00
2024-03-14T21:11:14.411402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:14.664955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

개찰일자
Date

Distinct127
Distinct (%)6.9%
Missing0
Missing (%)0.0%
Memory size14.5 KiB
Minimum2008-12-17 00:00:00
Maximum2024-03-04 00:00:00
2024-03-14T21:11:14.971584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:15.211576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

토지용도
Categorical

HIGH CORRELATION 

Distinct40
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size14.5 KiB
단독주택
712 
근린생활시설
217 
단독주택용지(점포겸용)
153 
근린생활시설(일반)
133 
도시지원시설용지
121 
Other values (35)
507 

Length

Max length24
Median length13
Mean length6.1741725
Min length3

Unique

Unique10 ?
Unique (%)0.5%

Sample

1st row업무시설용지
2nd row단독주택용지(점포겸용)
3rd row단독주택용지(점포겸용)
4th row단독주택용지(점포겸용)
5th row단독주택용지(점포겸용)

Common Values

ValueCountFrequency (%)
단독주택 712
38.6%
근린생활시설 217
 
11.8%
단독주택용지(점포겸용) 153
 
8.3%
근린생활시설(일반) 133
 
7.2%
도시지원시설용지 121
 
6.6%
주차장 79
 
4.3%
근린생활시설용지 46
 
2.5%
근린상업용지 46
 
2.5%
상업용지 45
 
2.4%
업무시설용지 40
 
2.2%
Other values (30) 251
 
13.6%

Length

2024-03-14T21:11:15.432694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
단독주택 712
38.6%
근린생활시설 217
 
11.8%
단독주택용지(점포겸용 153
 
8.3%
근린생활시설(일반 133
 
7.2%
도시지원시설용지 121
 
6.6%
주차장 79
 
4.3%
근린생활시설용지 46
 
2.5%
근린상업용지 46
 
2.5%
상업용지 45
 
2.4%
업무시설용지 40
 
2.2%
Other values (29) 251
 
13.6%

가지번
Text

Distinct1185
Distinct (%)64.3%
Missing0
Missing (%)0.0%
Memory size14.5 KiB
2024-03-14T21:11:16.613486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length9
Mean length6.799783
Min length2

Characters and Unicode

Total characters12532
Distinct characters65
Distinct categories10 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique754 ?
Unique (%)40.9%

Sample

1st row업무1-1-5
2nd row110-1
3rd row110-2
4th row110-3
5th row110-4
ValueCountFrequency (%)
f-3 43
 
2.2%
f-1 37
 
1.9%
f-2 18
 
0.9%
근생5 14
 
0.7%
근생72-4 7
 
0.4%
근생71-8 7
 
0.4%
근생72-3 7
 
0.4%
근생72-2 7
 
0.4%
근생71-7 7
 
0.4%
근생71-5 7
 
0.4%
Other values (1027) 1819
92.2%
2024-03-14T21:11:18.058969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 2075
16.6%
1 2014
16.1%
2 1418
11.3%
0 1254
10.0%
4 1167
9.3%
709
 
5.7%
3 610
 
4.9%
7 405
 
3.2%
5 396
 
3.2%
근 375
 
3.0%
Other values (55) 2109
16.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 7949
63.4%
Dash Punctuation 2075
 
16.6%
Other Letter 1518
 
12.1%
Space Separator 709
 
5.7%
Uppercase Letter 190
 
1.5%
Other Number 63
 
0.5%
Close Punctuation 11
 
0.1%
Open Punctuation 11
 
0.1%
Lowercase Letter 5
 
< 0.1%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
근 375
24.7%
생 337
22.2%
상 144
 
9.5%
업 141
 
9.3%
도 121
 
8.0%
시 121
 
8.0%
주 78
 
5.1%
무 68
 
4.5%
일 27
 
1.8%
지 19
 
1.3%
Other values (22) 87
 
5.7%
Decimal Number
ValueCountFrequency (%)
1 2014
25.3%
2 1418
17.8%
0 1254
15.8%
4 1167
14.7%
3 610
 
7.7%
7 405
 
5.1%
5 396
 
5.0%
6 276
 
3.5%
8 211
 
2.7%
9 198
 
2.5%
Uppercase Letter
ValueCountFrequency (%)
F 114
60.0%
C 22
 
11.6%
R 18
 
9.5%
D 11
 
5.8%
A 8
 
4.2%
M 5
 
2.6%
H 5
 
2.6%
O 4
 
2.1%
B 3
 
1.6%
Other Number
ValueCountFrequency (%)
① 24
38.1%
④ 11
17.5%
② 9
 
14.3%
⑤ 6
 
9.5%
⑧ 4
 
6.3%
⑥ 4
 
6.3%
⑦ 3
 
4.8%
③ 2
 
3.2%
Dash Punctuation
ValueCountFrequency (%)
- 2075
100.0%
Space Separator
ValueCountFrequency (%)
709
100.0%
Close Punctuation
ValueCountFrequency (%)
) 11
100.0%
Open Punctuation
ValueCountFrequency (%)
( 11
100.0%
Lowercase Letter
ValueCountFrequency (%)
d 5
100.0%
Other Punctuation
ValueCountFrequency (%)
/ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 10819
86.3%
Hangul 1518
 
12.1%
Latin 195
 
1.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
근 375
24.7%
생 337
22.2%
상 144
 
9.5%
업 141
 
9.3%
도 121
 
8.0%
시 121
 
8.0%
주 78
 
5.1%
무 68
 
4.5%
일 27
 
1.8%
지 19
 
1.3%
Other values (22) 87
 
5.7%
Common
ValueCountFrequency (%)
- 2075
19.2%
1 2014
18.6%
2 1418
13.1%
0 1254
11.6%
4 1167
10.8%
709
 
6.6%
3 610
 
5.6%
7 405
 
3.7%
5 396
 
3.7%
6 276
 
2.6%
Other values (13) 495
 
4.6%
Latin
ValueCountFrequency (%)
F 114
58.5%
C 22
 
11.3%
R 18
 
9.2%
D 11
 
5.6%
A 8
 
4.1%
M 5
 
2.6%
d 5
 
2.6%
H 5
 
2.6%
O 4
 
2.1%
B 3
 
1.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 10951
87.4%
Hangul 1518
 
12.1%
Enclosed Alphanum 63
 
0.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 2075
18.9%
1 2014
18.4%
2 1418
12.9%
0 1254
11.5%
4 1167
10.7%
709
 
6.5%
3 610
 
5.6%
7 405
 
3.7%
5 396
 
3.6%
6 276
 
2.5%
Other values (15) 627
 
5.7%
Hangul
ValueCountFrequency (%)
근 375
24.7%
생 337
22.2%
상 144
 
9.5%
업 141
 
9.3%
도 121
 
8.0%
시 121
 
8.0%
주 78
 
5.1%
무 68
 
4.5%
일 27
 
1.8%
지 19
 
1.3%
Other values (22) 87
 
5.7%
Enclosed Alphanum
ValueCountFrequency (%)
① 24
38.1%
④ 11
17.5%
② 9
 
14.3%
⑤ 6
 
9.5%
⑧ 4
 
6.3%
⑥ 4
 
6.3%
⑦ 3
 
4.8%
③ 2
 
3.2%

면적(제곱미터)
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct635
Distinct (%)35.2%
Missing38
Missing (%)2.1%
Infinite0
Infinite (%)0.0%
Mean2057.2606
Minimum164.5
Maximum89283
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size16.3 KiB
2024-03-14T21:11:18.404952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum164.5
5-th percentile205
Q1253
median573
Q31077
95-th percentile8084.7
Maximum89283
Range89118.5
Interquartile range (IQR)824

Descriptive statistics

Standard deviation6703.7867
Coefficient of variation (CV)3.2585987
Kurtosis65.34651
Mean2057.2606
Median Absolute Deviation (MAD)333.3
Skewness7.4164678
Sum3713355.4
Variance44940757
MonotonicityNot monotonic
2024-03-14T21:11:18.651196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
232.0 39
 
2.1%
247.0 31
 
1.7%
262.0 28
 
1.5%
267.0 26
 
1.4%
265.1 24
 
1.3%
234.0 24
 
1.3%
266.0 22
 
1.2%
265.0 17
 
0.9%
244.0 16
 
0.9%
222.0 16
 
0.9%
Other values (625) 1562
84.8%
(Missing) 38
 
2.1%
ValueCountFrequency (%)
164.5 3
0.2%
164.6 2
 
0.1%
164.8 1
 
0.1%
165.0 1
 
0.1%
170.0 1
 
0.1%
171.0 1
 
0.1%
176.0 3
0.2%
180.0 4
0.2%
181.0 5
0.3%
186.0 6
0.3%
ValueCountFrequency (%)
89283.0 1
 
0.1%
84479.0 1
 
0.1%
77722.0 1
 
0.1%
60175.4 1
 
0.1%
59228.0 3
0.2%
50957.3 6
0.3%
50266.7 1
 
0.1%
46561.9 2
 
0.1%
41130.2 4
0.2%
38570.0 4
0.2%

공급예정가액(원)
Real number (ℝ)

HIGH CORRELATION 

Distinct808
Distinct (%)44.1%
Missing12
Missing (%)0.7%
Infinite0
Infinite (%)0.0%
Mean7.0007442 × 109
Minimum1.34366 × 108
Maximum5.64 × 1011
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size16.3 KiB
2024-03-14T21:11:18.890880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.34366 × 108
5-th percentile5.19507 × 108
Q16.46259 × 108
median8.8088 × 108
Q34 × 109
95-th percentile1.7645067 × 1010
Maximum5.64 × 1011
Range5.6386563 × 1011
Interquartile range (IQR)3.353741 × 109

Descriptive statistics

Standard deviation2.9217233 × 1010
Coefficient of variation (CV)4.1734467
Kurtosis124.3768
Mean7.0007442 × 109
Median Absolute Deviation (MAD)4.01484 × 108
Skewness9.8248394
Sum1.2818363 × 1013
Variance8.536467 × 1020
MonotonicityNot monotonic
2024-03-14T21:11:19.327305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
700000000 134
 
7.3%
3000000000 78
 
4.2%
600000000 59
 
3.2%
4000000000 43
 
2.3%
800000000 42
 
2.3%
5000000000 31
 
1.7%
10000000000 22
 
1.2%
6000000000 18
 
1.0%
680636000 16
 
0.9%
7000000000 13
 
0.7%
Other values (798) 1375
74.6%
(Missing) 12
 
0.7%
ValueCountFrequency (%)
134366000 1
0.1%
299466000 1
0.1%
312144000 2
0.1%
312800000 1
0.1%
323000000 1
0.1%
323469000 1
0.1%
326136000 1
0.1%
329565000 1
0.1%
334443000 2
0.1%
334935000 1
0.1%
ValueCountFrequency (%)
564000000000 1
 
0.1%
409000000000 1
 
0.1%
279000000000 3
0.2%
257000000000 3
0.2%
242000000000 2
0.1%
203000000000 2
0.1%
196000000000 4
0.2%
171000000000 2
0.1%
157000000000 2
0.1%
145000000000 3
0.2%

입찰금액(원)
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct598
Distinct (%)78.5%
Missing1081
Missing (%)58.7%
Infinite0
Infinite (%)0.0%
Mean7.9695878 × 109
Minimum88000000
Maximum7.51 × 1011
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size16.3 KiB
2024-03-14T21:11:19.682550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum88000000
5-th percentile6 × 108
Q17.5 × 108
median1.0593 × 109
Q37 × 109
95-th percentile2.215885 × 1010
Maximum7.51 × 1011
Range7.50912 × 1011
Interquartile range (IQR)6.25 × 109

Descriptive statistics

Standard deviation3.2566874 × 1010
Coefficient of variation (CV)4.0863937
Kurtosis363.25036
Mean7.9695878 × 109
Median Absolute Deviation (MAD)5.120475 × 108
Skewness16.935764
Sum6.0728259 × 1012
Variance1.0606013 × 1021
MonotonicityNot monotonic
2024-03-14T21:11:19.945751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
10000000000 31
 
1.7%
20000000000 18
 
1.0%
8000000000 15
 
0.8%
7000000000 11
 
0.6%
4000000000 10
 
0.5%
9000000000 8
 
0.4%
1000000000 7
 
0.4%
2000000000 6
 
0.3%
5000000000 6
 
0.3%
680000000 5
 
0.3%
Other values (588) 645
35.0%
(Missing) 1081
58.7%
ValueCountFrequency (%)
88000000 1
0.1%
352000000 1
0.1%
496900000 1
0.1%
502400000 1
0.1%
510900000 1
0.1%
515190000 1
0.1%
515500000 1
0.1%
519900000 1
0.1%
521100000 1
0.1%
524000000 1
0.1%
ValueCountFrequency (%)
751000000000 1
0.1%
257000000000 1
0.1%
171000000000 1
0.1%
168000000000 1
0.1%
145000000000 1
0.1%
142000000000 1
0.1%
114000000000 1
0.1%
96879582000 1
0.1%
80000000000 1
0.1%
78142770000 1
0.1%

낙찰률(퍼센트)
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct166
Distinct (%)22.0%
Missing1087
Missing (%)59.0%
Infinite0
Infinite (%)0.0%
Mean143.17447
Minimum11
Maximum520
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size16.3 KiB
2024-03-14T21:11:20.213304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum11
5-th percentile100
Q1108
median121
Q3151.25
95-th percentile258.25
Maximum520
Range509
Interquartile range (IQR)43.25

Descriptive statistics

Standard deviation55.987215
Coefficient of variation (CV)0.39104188
Kurtosis6.0917147
Mean143.17447
Median Absolute Deviation (MAD)16
Skewness2.1707589
Sum108239.9
Variance3134.5682
MonotonicityNot monotonic
2024-03-14T21:11:20.473087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100.0 52
 
2.8%
120.0 29
 
1.6%
110.0 25
 
1.4%
106.0 24
 
1.3%
105.0 24
 
1.3%
113.0 23
 
1.2%
103.0 21
 
1.1%
128.0 20
 
1.1%
108.0 17
 
0.9%
101.0 17
 
0.9%
Other values (156) 504
27.3%
(Missing) 1087
59.0%
ValueCountFrequency (%)
11.0 1
 
0.1%
100.0 52
2.8%
100.1 1
 
0.1%
100.2 1
 
0.1%
100.6 1
 
0.1%
101.0 17
 
0.9%
102.0 13
 
0.7%
103.0 21
1.1%
104.0 10
 
0.5%
105.0 24
1.3%
ValueCountFrequency (%)
520.0 1
0.1%
464.0 1
0.1%
407.0 1
0.1%
360.0 1
0.1%
356.0 1
0.1%
355.0 1
0.1%
354.0 1
0.1%
351.0 1
0.1%
346.0 1
0.1%
340.0 1
0.1%

기타유의사항
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size14.5 KiB
공란은 데이터 미집계
1843 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row공란은 데이터 미집계
2nd row공란은 데이터 미집계
3rd row공란은 데이터 미집계
4th row공란은 데이터 미집계
5th row공란은 데이터 미집계

Common Values

ValueCountFrequency (%)
공란은 데이터 미집계 1843
100.0%

Length

2024-03-14T21:11:20.797011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T21:11:20.968242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공란은 1843
33.3%
데이터 1843
33.3%
미집계 1843
33.3%

Interactions

2024-03-14T21:11:07.416724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:04.284800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:05.313291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:06.351934image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:07.666606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:04.531856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:05.567743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:06.613276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:08.157120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:04.788152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:05.824308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:06.877891image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:08.428061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:05.058322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:06.096018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:11:07.154549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T21:11:21.082724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사업지구명공급방법토지용도면적(제곱미터)공급예정가액(원)입찰금액(원)낙찰률(퍼센트)
사업지구명1.0000.7850.9180.2830.0140.0000.504
공급방법0.7851.0000.9120.0000.0000.000NaN
토지용도0.9180.9121.0000.9190.9030.8980.780
면적(제곱미터)0.2830.0000.9191.0000.9370.8600.000
공급예정가액(원)0.0140.0000.9030.9371.0000.9110.000
입찰금액(원)0.0000.0000.8980.8600.9111.0000.047
낙찰률(퍼센트)0.504NaN0.7800.0000.0000.0471.000
2024-03-14T21:11:21.279536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
토지용도사업지구명공급방법
토지용도1.0000.4320.779
사업지구명0.4321.0000.641
공급방법0.7790.6411.000
2024-03-14T21:11:21.436640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
면적(제곱미터)공급예정가액(원)입찰금액(원)낙찰률(퍼센트)사업지구명공급방법토지용도
면적(제곱미터)1.0000.9330.9020.2700.1010.0000.646
공급예정가액(원)0.9331.0000.9430.3130.0060.0000.648
입찰금액(원)0.9020.9431.0000.5420.0000.0000.687
낙찰률(퍼센트)0.2700.3130.5421.0000.2181.0000.410
사업지구명0.1010.0060.0000.2181.0000.6410.432
공급방법0.0000.0000.0001.0000.6411.0000.779
토지용도0.6460.6480.6870.4100.4320.7791.000

Missing values

2024-03-14T21:11:08.806417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T21:11:09.396807image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
2024-03-14T21:11:09.784631image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

사업지구명공고명공급방법모집공고일공고접수시작일공고접수종료일개찰일자토지용도가지번면적(제곱미터)공급예정가액(원)입찰금액(원)낙찰률(퍼센트)기타유의사항
0고덕국제화계획지구고덕국제화계획지구 업무시설용지 공급 공고입찰2023-09-182023-10-112023-10-112023-10-11업무시설용지업무1-1-51822.011500000000<NA><NA>공란은 데이터 미집계
1고덕국제화계획지구고덕국제화계획지구 점포겸용 단독주택용지 공급 공고입찰2023-12-082023-12-192023-12-192023-12-19단독주택용지(점포겸용)110-1248.0700000000<NA><NA>공란은 데이터 미집계
2고덕국제화계획지구고덕국제화계획지구 점포겸용 단독주택용지 공급 공고입찰2023-12-082023-12-192023-12-192023-12-19단독주택용지(점포겸용)110-2247.0700000000<NA><NA>공란은 데이터 미집계
3고덕국제화계획지구고덕국제화계획지구 점포겸용 단독주택용지 공급 공고입찰2023-12-082023-12-192023-12-192023-12-19단독주택용지(점포겸용)110-3247.0700000000<NA><NA>공란은 데이터 미집계
4고덕국제화계획지구고덕국제화계획지구 점포겸용 단독주택용지 공급 공고입찰2023-12-082023-12-192023-12-192023-12-19단독주택용지(점포겸용)110-4244.0700000000<NA><NA>공란은 데이터 미집계
5고덕국제화계획지구고덕국제화계획지구 점포겸용 단독주택용지 공급 공고입찰2023-12-082023-12-192023-12-192023-12-19단독주택용지(점포겸용)110-5246.0700000000<NA><NA>공란은 데이터 미집계
6고덕국제화계획지구고덕국제화계획지구 점포겸용 단독주택용지 공급 공고입찰2023-12-082023-12-192023-12-192023-12-19단독주택용지(점포겸용)110-6247.0700000000<NA><NA>공란은 데이터 미집계
7고덕국제화계획지구고덕국제화계획지구 점포겸용 단독주택용지 공급 공고입찰2023-12-082023-12-192023-12-192023-12-19단독주택용지(점포겸용)110-7247.1700000000<NA><NA>공란은 데이터 미집계
8고덕국제화계획지구고덕국제화계획지구 점포겸용 단독주택용지 공급 공고입찰2023-12-082023-12-192023-12-192023-12-19단독주택용지(점포겸용)110-8248.0700000000<NA><NA>공란은 데이터 미집계
9고덕국제화계획지구고덕국제화계획지구 점포겸용 단독주택용지 공급 공고입찰2023-12-082023-12-192023-12-192023-12-19단독주택용지(점포겸용)111-1261.1700000000<NA><NA>공란은 데이터 미집계
사업지구명공고명공급방법모집공고일공고접수시작일공고접수종료일개찰일자토지용도가지번면적(제곱미터)공급예정가액(원)입찰금액(원)낙찰률(퍼센트)기타유의사항
1833화성동탄(2) 택지개발사업화성동탄(2) 근린생활시설용지 및 근린상업용지 공급공고입찰2023-08-012023-08-162023-08-162023-08-16근린생활시설용지529-105800.33000000000<NA><NA>공란은 데이터 미집계
1834화성동탄(2) 택지개발사업화성동탄(2) 근린생활시설용지 및 근린상업용지 공급공고입찰2023-08-012023-08-162023-08-162023-08-16근린생활시설용지529-106849.93000000000<NA><NA>공란은 데이터 미집계
1835화성동탄(2) 택지개발사업화성동탄(2) 근린생활시설용지 및 근린상업용지 공급공고입찰2023-08-012023-08-162023-08-162023-08-16근린생활시설용지529-107833.13000000000<NA><NA>공란은 데이터 미집계
1836화성동탄(2) 택지개발사업화성동탄(2) 근린생활시설용지 및 근린상업용지 공급공고입찰2023-08-012023-08-162023-08-162023-08-16근린생활시설용지529-201857.83000000000<NA><NA>공란은 데이터 미집계
1837화성동탄(2) 택지개발사업화성동탄(2) 근린생활시설용지 및 근린상업용지 공급공고입찰2023-08-012023-08-162023-08-162023-08-16근린생활시설용지529-202837.13000000000<NA><NA>공란은 데이터 미집계
1838화성동탄(2) 택지개발사업화성동탄(2) 근린생활시설용지 및 근린상업용지 공급공고입찰2023-08-012023-08-162023-08-162023-08-16근린생활시설용지529-203824.23000000000<NA><NA>공란은 데이터 미집계
1839화성동탄(2) 택지개발사업화성동탄(2) 근린생활시설용지 및 근린상업용지 공급공고입찰2023-08-012023-08-162023-08-162023-08-16근린상업용지8314-302985.840000000004130000000100.2공란은 데이터 미집계
1840화성동탄(2) 택지개발사업화성동탄(2) 근린생활시설용지 및 근린상업용지 공급공고입찰2023-08-012023-08-162023-08-162023-08-16근린상업용지8314-3031203.150000000004940000000100.1공란은 데이터 미집계
1841화성동탄(2) 택지개발사업화성동탄(2) 근린생활시설용지 및 근린상업용지 공급공고입찰2023-08-012023-08-162023-08-162023-08-16근린상업용지8314-304946.640000000003760000000100.0공란은 데이터 미집계
1842화성동탄(2) 택지개발사업화성동탄(2) 근린생활시설용지 및 근린상업용지 공급공고입찰2023-08-012023-08-162023-08-162023-08-16근린상업용지8314-3051096.940000000004490000000100.0공란은 데이터 미집계

Duplicate rows

Most frequently occurring

사업지구명공고명공급방법모집공고일공고접수시작일공고접수종료일개찰일자토지용도가지번면적(제곱미터)공급예정가액(원)입찰금액(원)낙찰률(퍼센트)기타유의사항# duplicates
0고덕국제화계획지구고덕국제화계획지구 업무시설용지 공급 공고입찰2023-09-182023-10-112023-10-112023-10-11업무시설용지업무1-1-51822.011500000000<NA><NA>공란은 데이터 미집계2
1광교지구 택지개발사업광교 도시지원시설용지(도시17블록) 공급공고입찰2015-01-092015-01-232015-01-232015-01-23도시지원시설용지도시1721380.044846670000<NA><NA>공란은 데이터 미집계2
2광교지구 택지개발사업광교 업무복합(D3) 및 도시지원시설용지(도시8~10)블록 공급안내입찰2014-02-172014-02-272014-02-272014-02-27업무복합용지D350957.3257000000000<NA><NA>공란은 데이터 미집계2
3광교지구 택지개발사업광교 업무복합,공동주택,업무시설,도시지원시설,근린생활시설,주차장,단독주택,종교,문화복지시설용지 공급공고입찰2011-06-242011-07-042011-07-042011-07-04업무시설업무2-3-1869.031631600004475700000141.0공란은 데이터 미집계2
4광교지구 택지개발사업광교 업무복합,공동주택,중심상업,의료시설용지 공급공고입찰2011-10-272011-11-102011-11-112011-11-11업무복합용지D350957.3279000000000<NA><NA>공란은 데이터 미집계2
5광교지구 택지개발사업광교지구 유치원 및 근생용지 신규공급 및 수의계약 대상부지 공급 안내입찰2012-04-132012-04-232012-04-232012-04-23도시지원시설용지도시14-115237.022855500000<NA><NA>공란은 데이터 미집계2
6광교지구 택지개발사업광교지구 유치원 및 근생용지 신규공급 및 수의계약 대상부지 공급 안내입찰2012-04-132012-04-232012-04-232012-04-23도시지원시설용지도시14-2-17967.513732500000<NA><NA>공란은 데이터 미집계2
7광교지구 택지개발사업광교지구 유치원 및 근생용지 신규공급 및 수의계약 대상부지 공급 안내입찰2012-04-132012-04-232012-04-232012-04-23도시지원시설용지도시14-2-26209.010058580000<NA><NA>공란은 데이터 미집계2
8광교지구 택지개발사업광교지구 유치원 및 근생용지 신규공급 및 수의계약 대상부지 공급 안내입찰2012-04-132012-04-232012-04-232012-04-23도시지원시설용지도시14-2-35962.79776700000<NA><NA>공란은 데이터 미집계2
9광교지구 택지개발사업광교지구 유치원 및 근생용지 신규공급 및 수의계약 대상부지 공급 안내입찰2012-04-132012-04-232012-04-232012-04-23도시지원시설용지도시14-3-13599.05686420000<NA><NA>공란은 데이터 미집계2