gimi9 Pandas Profiling

Dataset statistics

Number of variables	14
Number of observations	965
Missing cells	425
Missing cells (%)	3.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	114.2 KiB
Average record size in memory	121.1 B

Variable types

Numeric	8
Categorical	3
Text	3

Dataset

Description	경상남도 공사계약대장시스템의 하도급변경내역 데이터입니다. 하도순번, 변경계약일, 변경하도부 등의 데이터를 포함하고있습니다.
Author	경상남도
URL	https://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15049514

Alerts

`공사구분` has constant value ""	Constant
`부서코드` has constant value ""	Constant
`공사년도` is highly overall correlated with `변경공사종료일`	High correlation
`하도순번` is highly overall correlated with `순번`	High correlation
`순번` is highly overall correlated with `하도순번`	High correlation
`변경하도부분금액` is highly overall correlated with `변경하도금액`	High correlation
`변경하도금액` is highly overall correlated with `변경하도부분금액`	High correlation
`변경공사종료일` is highly overall correlated with `공사년도`	High correlation
`변경하도부분금액` has 98 (10.2%) missing values	Missing
`변경하도금액` has 83 (8.6%) missing values	Missing
`변경공사시작일` has 88 (9.1%) missing values	Missing
`변경공사종료일` has 57 (5.9%) missing values	Missing
`하도비율` has 99 (10.3%) missing values	Missing
`변경공사종료일` is highly skewed (γ1 = -21.23636491)	Skewed
`변경하도부분금액` has 12 (1.2%) zeros	Zeros

Reproduction

Analysis started	2023-12-11 00:34:22.316714
Analysis finished	2023-12-11 00:34:28.695190
Duration	6.38 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

공사년도
Real number (ℝ)

HIGH CORRELATION

Distinct	17
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2012.0518

Minimum	2003
Maximum	2019
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.6 KiB

Quantile statistics

Minimum	2003
5-th percentile	2008
Q1	2010
median	2011
Q3	2014
95-th percentile	2018
Maximum	2019
Range	16
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.3287085
Coefficient of variation (CV)	0.0016543851
Kurtosis	0.30253143
Mean	2012.0518
Median Absolute Deviation (MAD)	2
Skewness	0.028170738
Sum	1941630
Variance	11.0803
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
2010	217	22.5%
2011	129	13.4%
2013	126	13.1%
2012	100	10.4%
2018	85	8.8%
2009	85	8.8%
2017	67	6.9%
2014	46	4.8%
2015	36	3.7%
2003	21	2.2%
Other values (7)	53	5.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2003	21	2.2%
2004	11	1.1%
2005	6	0.6%
2006	1	0.1%
2007	3	0.3%
2008	14	1.5%
2009	85	8.8%
2010	217	22.5%
2011	129	13.4%
2012	100	10.4%

Value	Count	Frequency (%)
2019	7	0.7%
2018	85	8.8%
2017	67	6.9%
2016	11	1.1%
2015	36	3.7%
2014	46	4.8%
2013	126	13.1%
2012	100	10.4%
2011	129	13.4%
2010	217	22.5%

공사구분
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

공사	965

Length

Max length	2
Median length	2
Mean length	2
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 (%)
공사	965	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
공사	965	100.0%

공사번호
Real number (ℝ)

Distinct	190
Distinct (%)	19.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	159.45803

Minimum	1
Maximum	596
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.6 KiB

Quantile statistics

Minimum	1
5-th percentile	10.2
Q1	34
median	93
Q3	219
95-th percentile	505
Maximum	596
Range	595
Interquartile range (IQR)	185

Descriptive statistics

Standard deviation	171.13005
Coefficient of variation (CV)	1.0731981
Kurtosis	-0.28644532
Mean	159.45803
Median Absolute Deviation (MAD)	63
Skewness	1.1315651
Sum	153877
Variance	29285.495
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	34	3.5%
11	25	2.6%
49	25	2.6%
105	23	2.4%
7	23	2.4%
505	22	2.3%
62	15	1.6%
107	15	1.6%
435	14	1.5%
142	14	1.5%
Other values (180)	755	78.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	8	0.8%
2	1	0.1%
4	5	0.5%
5	11	1.1%
7	23	2.4%
10	1	0.1%
11	25	2.6%
12	9	0.9%
13	14	1.5%
14	12	1.2%

Value	Count	Frequency (%)
596	6	0.6%
530	4	0.4%
529	14	1.5%
524	5	0.5%
518	2	0.2%
516	1	0.1%
514	3	0.3%
510	4	0.4%
507	1	0.1%
505	22	2.3%

부서코드
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

1	965

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	965	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	965	100.0%

하도순번
Real number (ℝ)

HIGH CORRELATION

Distinct	27
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.973057

Minimum	1
Maximum	34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	10
Maximum	34
Range	33
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	4.0833255
Coefficient of variation (CV)	1.3734434
Kurtosis	23.00689
Mean	2.973057
Median Absolute Deviation (MAD)	1
Skewness	4.2814083
Sum	2869
Variance	16.673547
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
1	443	45.9%
2	228	23.6%
3	95	9.8%
4	54	5.6%
5	35	3.6%
6	21	2.2%
7	19	2.0%
8	10	1.0%
9	8	0.8%
11	8	0.8%
Other values (17)	44	4.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	443	45.9%
2	228	23.6%
3	95	9.8%
4	54	5.6%
5	35	3.6%
6	21	2.2%
7	19	2.0%
8	10	1.0%
9	8	0.8%
10	5	0.5%

Value	Count	Frequency (%)
34	3	0.3%
32	1	0.1%
31	2	0.2%
29	1	0.1%
25	2	0.2%
24	2	0.2%
23	1	0.1%
21	1	0.1%
19	1	0.1%
18	1	0.1%

순번
Real number (ℝ)

HIGH CORRELATION

Distinct	25
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.0746114

Minimum	1
Maximum	25
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	3
Q3	5
95-th percentile	13
Maximum	25
Range	24
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	4.1960053
Coefficient of variation (CV)	1.0297928
Kurtosis	5.4287781
Mean	4.0746114
Median Absolute Deviation (MAD)	2
Skewness	2.2438914
Sum	3932
Variance	17.606461
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
1	282	29.2%
2	190	19.7%
3	128	13.3%
4	93	9.6%
5	59	6.1%
6	46	4.8%
7	34	3.5%
8	25	2.6%
9	17	1.8%
10	12	1.2%
Other values (15)	79	8.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	282	29.2%
2	190	19.7%
3	128	13.3%
4	93	9.6%
5	59	6.1%
6	46	4.8%
7	34	3.5%
8	25	2.6%
9	17	1.8%
10	12	1.2%

Value	Count	Frequency (%)
25	1	0.1%
24	1	0.1%
23	2	0.2%
22	3	0.3%
21	4	0.4%
20	4	0.4%
19	5	0.5%
18	5	0.5%
17	4	0.4%
16	5	0.5%

변경계약일
Text

Distinct	456
Distinct (%)	47.3%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

Length

Max length	10
Median length	10
Mean length	9.811399
Min length	1

Characters and Unicode

Total characters	9468
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	218 ?
Unique (%)	22.6%

Sample

1st row	2010-07-30
2nd row	2010-09-28
3rd row	2010-07-30
4th row	2010-09-30
5th row	2010-09-30

Value	Count	Frequency (%)
2013-03-12	17	1.8%
2011-08-27	11	1.1%
2012-04-05	10	1.0%
2018-08-14	9	0.9%
	9	0.9%
2012-12-31	8	0.8%
2010-11-30	8	0.8%
2018-10-12	8	0.8%
2015-11-25	7	0.7%
2011-10-06	7	0.7%
Other values (446)	871	90.3%

Most occurring characters

Value	Count	Frequency (%)
0	2193	23.2%
1	2026	21.4%
-	1873	19.8%
2	1668	17.6%
3	467	4.9%
8	267	2.8%
5	220	2.3%
9	211	2.2%
4	190	2.0%
7	187	2.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	7595	80.2%
Dash Punctuation	1873	19.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2193	28.9%
1	2026	26.7%
2	1668	22.0%
3	467	6.1%
8	267	3.5%
5	220	2.9%
9	211	2.8%
4	190	2.5%
7	187	2.5%
6	166	2.2%

Dash Punctuation

Value	Count	Frequency (%)
-	1873	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	9468	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2193	23.2%
1	2026	21.4%
-	1873	19.8%
2	1668	17.6%
3	467	4.9%
8	267	2.8%
5	220	2.3%
9	211	2.2%
4	190	2.0%
7	187	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9468	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2193	23.2%
1	2026	21.4%
-	1873	19.8%
2	1668	17.6%
3	467	4.9%
8	267	2.8%
5	220	2.3%
9	211	2.2%
4	190	2.0%
7	187	2.0%

변경신고일
Text

Distinct	425
Distinct (%)	44.0%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

Length

Max length	10
Median length	10
Mean length	9.9233161
Min length	1

Characters and Unicode

Total characters	9576
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	194 ?
Unique (%)	20.1%

Sample

1st row	2010-10-06
2nd row	2010-11-23
3rd row	2010-10-06
4th row	2010-11-23
5th row	2010-11-23

Value	Count	Frequency (%)
2013-06-26	15	1.6%
2013-12-05	12	1.2%
2011-09-28	11	1.1%
2018-11-05	10	1.0%
2012-05-08	10	1.0%
2018-08-29	9	0.9%
2011-03-04	8	0.8%
2013-02-21	8	0.8%
2010-12-22	8	0.8%
	8	0.8%
Other values (415)	866	89.7%

Most occurring characters

Value	Count	Frequency (%)
0	2183	22.8%
1	1973	20.6%
-	1920	20.1%
2	1722	18.0%
3	420	4.4%
8	276	2.9%
9	251	2.6%
5	229	2.4%
4	209	2.2%
6	206	2.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	7656	79.9%
Dash Punctuation	1920	20.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2183	28.5%
1	1973	25.8%
2	1722	22.5%
3	420	5.5%
8	276	3.6%
9	251	3.3%
5	229	3.0%
4	209	2.7%
6	206	2.7%
7	187	2.4%

Dash Punctuation

Value	Count	Frequency (%)
-	1920	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	9576	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2183	22.8%
1	1973	20.6%
-	1920	20.1%
2	1722	18.0%
3	420	4.4%
8	276	2.9%
9	251	2.6%
5	229	2.4%
4	209	2.2%
6	206	2.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9576	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2183	22.8%
1	1973	20.6%
-	1920	20.1%
2	1722	18.0%
3	420	4.4%
8	276	2.9%
9	251	2.6%
5	229	2.4%
4	209	2.2%
6	206	2.2%

변경하도부분금액
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	740
Distinct (%)	85.4%
Missing	98
Missing (%)	10.2%
Infinite	0
Infinite (%)	0.0%
Mean	1.9259419 × 10⁹

Minimum	0
Maximum	6.6806719 × 10¹⁰
Zeros	12
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	8.6 KiB

Quantile statistics

Minimum	0
5-th percentile	44360600
Q1	2.1289986 × 10⁸
median	5.72465 × 10⁸
Q3	1.2025775 × 10⁹
95-th percentile	8.843131 × 10⁹
Maximum	6.6806719 × 10¹⁰
Range	6.6806719 × 10¹⁰
Interquartile range (IQR)	9.8967768 × 10⁸

Descriptive statistics

Standard deviation	4.9952432 × 10⁹
Coefficient of variation (CV)	2.5936624
Kurtosis	52.42444
Mean	1.9259419 × 10⁹
Median Absolute Deviation (MAD)	4.24135 × 10⁸
Skewness	6.1928412
Sum	1.6697917 × 10¹²
Variance	2.4952455 × 10¹⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	12	1.2%
1164300000	4	0.4%
57970000	4	0.4%
3687200000	3	0.3%
238700000	3	0.3%
1268462000	3	0.3%
1088890000	3	0.3%
275000000	3	0.3%
7942000000	3	0.3%
1477000000	3	0.3%
Other values (730)	826	85.6%
(Missing)	98	10.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	12	1.2%
6130000	1	0.1%
7485000	1	0.1%
8657000	1	0.1%
8835000	1	0.1%
11099000	1	0.1%
15180000	1	0.1%
17067000	1	0.1%
18222080	1	0.1%
19715840	1	0.1%

Value	Count	Frequency (%)
66806718691	1	0.1%
47145320575	1	0.1%
35697825422	1	0.1%
32547700000	1	0.1%
31620050000	1	0.1%
30582483153	1	0.1%
30130359343	1	0.1%
28829900000	1	0.1%
28588890000	1	0.1%
28501300000	1	0.1%

변경하도금액
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	759
Distinct (%)	86.1%
Missing	83
Missing (%)	8.6%
Infinite	0
Infinite (%)	0.0%
Mean	1.5987446 × 10⁹

Minimum	0
Maximum	3.978337 × 10¹⁰
Zeros	8
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	8.6 KiB

Quantile statistics

Minimum	0
5-th percentile	41454378
Q1	1.9448 × 10⁸
median	5.1505858 × 10⁸
Q3	1.0565125 × 10⁹
95-th percentile	7.632185 × 10⁹
Maximum	3.978337 × 10¹⁰
Range	3.978337 × 10¹⁰
Interquartile range (IQR)	8.620325 × 10⁸

Descriptive statistics

Standard deviation	3.7345974 × 10⁹
Coefficient of variation (CV)	2.3359562
Kurtosis	30.172414
Mean	1.5987446 × 10⁹
Median Absolute Deviation (MAD)	3.7652 × 10⁸
Skewness	4.9573347
Sum	1.4100927 × 10¹²
Variance	1.3947218 × 10¹⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8	0.8%
956600000	4	0.4%
492800000	4	0.4%
1184810000	3	0.3%
548460000	3	0.3%
73040000	3	0.3%
16608900	3	0.3%
572000000	3	0.3%
1392600000	3	0.3%
225500000	3	0.3%
Other values (749)	845	87.6%
(Missing)	83	8.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8	0.8%
5517000	1	0.1%
6683000	1	0.1%
7328000	1	0.1%
8800000	1	0.1%
9988000	1	0.1%
13090000	1	0.1%
14000000	1	0.1%
15000000	1	0.1%
16168900	1	0.1%

Value	Count	Frequency (%)
39783370000	1	0.1%
27234900000	1	0.1%
26753100000	1	0.1%
26177800000	1	0.1%
25825593200	1	0.1%
25788400000	1	0.1%
23010900000	1	0.1%
22885500000	1	0.1%
22419100000	1	0.1%
22203500000	1	0.1%

변경공사시작일
Text

MISSING

Distinct	380
Distinct (%)	43.3%
Missing	88
Missing (%)	9.1%
Memory size	7.7 KiB

Length

Max length	10
Median length	10
Mean length	9.986317
Min length	5

Characters and Unicode

Total characters	8758
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	171 ?
Unique (%)	19.5%

Sample

1st row	2008-12-01
2nd row	2004-10-04
3rd row	2004-10-04
4th row	2005-06-13
5th row	2005-06-26

Value	Count	Frequency (%)
2010-05-13	12	1.4%
2018-05-16	12	1.4%
2010-08-11	12	1.4%
2012-03-12	11	1.3%
2007-06-14	8	0.9%
2013-03-11	8	0.9%
2013-03-08	8	0.9%
2013-08-30	8	0.9%
2014-08-28	7	0.8%
2018-02-06	7	0.8%
Other values (370)	784	89.4%

Most occurring characters

Value	Count	Frequency (%)
0	2441	27.9%
-	1746	19.9%
1	1458	16.6%
2	1444	16.5%
3	373	4.3%
8	280	3.2%
5	268	3.1%
4	219	2.5%
9	190	2.2%
6	171	2.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	7012	80.1%
Dash Punctuation	1746	19.9%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2441	34.8%
1	1458	20.8%
2	1444	20.6%
3	373	5.3%
8	280	4.0%
5	268	3.8%
4	219	3.1%
9	190	2.7%
6	171	2.4%
7	168	2.4%

Dash Punctuation

Value	Count	Frequency (%)
-	1746	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	8758	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2441	27.9%
-	1746	19.9%
1	1458	16.6%
2	1444	16.5%
3	373	4.3%
8	280	3.2%
5	268	3.1%
4	219	2.5%
9	190	2.2%
6	171	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8758	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2441	27.9%
-	1746	19.9%
1	1458	16.6%
2	1444	16.5%
3	373	4.3%
8	280	3.2%
5	268	3.1%
4	219	2.5%
9	190	2.2%
6	171	2.0%

변경공사종료일
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED

Distinct	324
Distinct (%)	35.7%
Missing	57
Missing (%)	5.9%
Infinite	0
Infinite (%)	0.0%
Mean	20095830

Minimum	2013103
Maximum	20416042
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.6 KiB

Quantile statistics

Minimum	2013103
5-th percentile	20101130
Q1	20111223
median	20130630
Q3	20150247
95-th percentile	20190628
Maximum	20416042
Range	18402939
Interquartile range (IQR)	39023.75

Descriptive statistics

Standard deviation	850141.03
Coefficient of variation (CV)	0.042304349
Kurtosis	450.48375
Mean	20095830
Median Absolute Deviation (MAD)	19410.5
Skewness	-21.236365
Sum	1.8247014 × 10¹⁰
Variance	7.2273977 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20131231	51	5.3%
20141231	26	2.7%
20111231	25	2.6%
20101130	21	2.2%
20130709	18	1.9%
20140817	10	1.0%
20121231	10	1.0%
20110506	9	0.9%
20161231	9	0.9%
20111221	9	0.9%
Other values (314)	720	74.6%
(Missing)	57	5.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2013103	1	0.1%
2030105	1	0.1%
20100222	1	0.1%
20100228	2	0.2%
20100331	2	0.2%
20100423	1	0.1%
20100531	1	0.1%
20100623	2	0.2%
20100630	2	0.2%
20100731	4	0.4%

Value	Count	Frequency (%)
20416042	1	0.1%
20211231	1	0.1%
20201219	1	0.1%
20200817	6	0.6%
20200704	2	0.2%
20200324	1	0.1%
20200323	8	0.8%
20191231	3	0.3%
20191128	8	0.8%
20191125	1	0.1%

하도비율
Real number (ℝ)

MISSING

Distinct	496
Distinct (%)	57.3%
Missing	99
Missing (%)	10.3%
Infinite	0
Infinite (%)	0.0%
Mean	87.783326

Minimum	0
Maximum	218.01
Zeros	7
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	8.6 KiB

Quantile statistics

Minimum	0
5-th percentile	82
Q1	83
median	85.99
Q3	90.0275
95-th percentile	100.5775
Maximum	218.01
Range	218.01
Interquartile range (IQR)	7.0275

Descriptive statistics

Standard deviation	13.764153
Coefficient of variation (CV)	0.1567969
Kurtosis	31.01642
Mean	87.783326
Median Absolute Deviation (MAD)	3.4
Skewness	0.40961594
Sum	76020.36
Variance	189.45192
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90.0	27	2.8%
85.0	13	1.3%
87.0	10	1.0%
95.0	9	0.9%
82.0	9	0.9%
89.99	9	0.9%
84.99	8	0.8%
82.5	7	0.7%
0.0	7	0.7%
87.99	6	0.6%
Other values (486)	761	78.9%
(Missing)	99	10.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	7	0.7%
10.22	1	0.1%
57.0	1	0.1%
65.02	1	0.1%
65.34	1	0.1%
65.61	1	0.1%
67.46	1	0.1%
68.43	1	0.1%
68.47	1	0.1%
69.98	1	0.1%

Value	Count	Frequency (%)
218.01	1	0.1%
188.88	1	0.1%
188.78	1	0.1%
158.41	1	0.1%
151.9	1	0.1%
144.21	1	0.1%
141.4	1	0.1%
139.04	1	0.1%
135.11	1	0.1%
133.73	1	0.1%

적용방법
Categorical

Distinct	3
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

직불	582
대지급	232
-	151

Length

Max length	3
Median length	2
Mean length	2.0839378
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	-
2nd row	대지급
3rd row	-
4th row	대지급
5th row	대지급

Common Values

Value	Count	Frequency (%)
직불	582	60.3%
대지급	232	24.0%
-	151	15.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
직불	582	60.3%
대지급	232	24.0%
	151	15.6%

Phik (φk)
Auto

Heatmap
Table

	공사년도	공사번호	하도순번	순번	변경하도부분금액	변경하도금액	변경공사종료일	하도비율	적용방법
공사년도	1.000	0.547	0.488	0.165	0.167	0.194	0.000	0.000	0.577
공사번호	0.547	1.000	0.132	0.040	0.135	0.211	0.126	0.000	0.338
하도순번	0.488	0.132	1.000	0.626	0.403	0.160	0.000	0.149	0.321
순번	0.165	0.040	0.626	1.000	0.185	0.121	0.000	0.093	0.354
변경하도부분금액	0.167	0.135	0.403	0.185	1.000	0.902	0.000	0.226	0.313
변경하도금액	0.194	0.211	0.160	0.121	0.902	1.000	0.000	0.000	0.290
변경공사종료일	0.000	0.126	0.000	0.000	0.000	0.000	1.000	0.000	0.000
하도비율	0.000	0.000	0.149	0.093	0.226	0.000	0.000	1.000	0.336
적용방법	0.577	0.338	0.321	0.354	0.313	0.290	0.000	0.336	1.000

Heatmap
Table

	공사년도	공사번호	하도순번	순번	변경하도부분금액	변경하도금액	변경공사종료일	하도비율	적용방법
공사년도	1.000	-0.398	-0.153	-0.126	-0.181	-0.188	0.844	-0.017	0.420
공사번호	-0.398	1.000	-0.117	-0.035	0.079	0.078	-0.437	0.027	0.157
하도순번	-0.153	-0.117	1.000	0.503	0.039	0.039	0.002	0.041	0.202
순번	-0.126	-0.035	0.503	1.000	0.103	0.091	0.091	0.034	0.230
변경하도부분금액	-0.181	0.079	0.039	0.103	1.000	0.985	-0.083	-0.071	0.221
변경하도금액	-0.188	0.078	0.039	0.091	0.985	1.000	-0.085	-0.018	0.192
변경공사종료일	0.844	-0.437	0.002	0.091	-0.083	-0.085	1.000	-0.061	0.000
하도비율	-0.017	0.027	0.041	0.034	-0.071	-0.018	-0.061	1.000	0.157
적용방법	0.420	0.157	0.202	0.230	0.221	0.192	0.000	0.157	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

	공사년도	공사구분	공사번호	부서코드	하도순번	순번	변경계약일	변경신고일	변경하도부분금액	변경하도금액	변경공사시작일	변경공사종료일	하도비율	적용방법
0	2003	공사	105	1	24	12	2010-07-30	2010-10-06	66806718691	6830780000	<NA>	<NA>	10.22	-
1	2003	공사	105	1	31	21	2010-09-28	2010-11-23	7455954035	6183100000	2008-12-01	20101130	82.93	대지급
2	2003	공사	105	1	8	14	2010-07-30	2010-10-06	12609801832	10348800000	<NA>	20101130	82.07	-
3	2003	공사	105	1	11	15	2010-09-30	2010-11-23	11655600000	8808800000	2004-10-04	20101130	75.58	대지급
4	2003	공사	105	1	12	16	2010-09-30	2010-11-23	5604500000	4255570000	2004-10-04	20101130	75.93	대지급
5	2003	공사	105	1	21	17	2010-09-30	2010-11-23	941380000	717090000	2005-06-13	20101130	76.17	직불
6	2003	공사	105	1	19	18	2010-09-30	2010-11-23	977900000	828960000	2005-06-26	20101130	84.77	대지급
7	2003	공사	105	1	32	19	2010-09-30	2010-11-23	454520000	298210000	2010-01-07	20101130	65.61	대지급
8	2003	공사	105	1	18	20	2010-09-28	2010-11-23	1704061185	1683000000	2005-03-07	20101130	98.76	대지급
9	2003	공사	105	1	34	10	2010-08-02	2010-10-05	1862200378	1652200000	<NA>	20101130	88.72	-

	공사년도	공사구분	공사번호	부서코드	하도순번	순번	변경계약일	변경신고일	변경하도부분금액	변경하도금액	변경공사시작일	변경공사종료일	하도비율	적용방법
955	2017	공사	132	1	1	8	2018-10-12	2018-11-05	151374000	136235000	2018-05-16	20191128	90.0	직불
956	2017	공사	132	1	2	7	2018-10-12	2018-11-05	6130000	5517000	2018-05-16	20191128	90.0	직불
957	2017	공사	132	1	3	6	2018-10-12	2018-11-05	2644975000	2380399000	2017-12-18	20191128	90.0	직불
958	2017	공사	132	1	4	5	2018-10-12	2018-11-05	1892235000	1702980000	2017-12-18	20191128	90.0	직불
959	2018	공사	73	1	1	1	2018-12-18	2018-12-19	478358100	446532900	<NA>	<NA>	93.35	직불
960	2017	공사	132	1	3	3	2018-08-14	2018-08-29	<NA>	<NA>	2017-12-18	20191128	<NA>	-
961	2017	공사	132	1	2	2	2018-08-14	2018-08-29	<NA>	<NA>	2018-05-16	20191128	<NA>	-
962	2017	공사	132	1	1	1	2018-08-14	2018-08-29	<NA>	<NA>	2018-05-16	20191128	<NA>	-
963	2018	공사	73	1	2	2	2018-12-18	2018-12-19	1272308400	1069103200	<NA>	<NA>	84.03	직불
964	2017	공사	132	1	4	4	2018-08-14	2018-08-29	<NA>	<NA>	2017-12-18	20191128	<NA>	-

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

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

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)

Interactions

Correlations

Missing values

Sample