Overview

Dataset statistics

Number of variables27
Number of observations10000
Missing cells34853
Missing cells (%)12.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.2 MiB
Average record size in memory234.0 B

Variable types

Numeric6
Categorical9
Text5
DateTime4
Unsupported3

Dataset

Description경상북도 상주시 계약정보 테이블
Author경상북도 상주시
URLhttps://www.data.go.kr/data/15063668/fileData.do

Alerts

MODIFY_DATE has constant value ""Constant
REG_DATE has constant value ""Constant
CONTRACT_MNG_NO is highly imbalanced (94.8%)Imbalance
CONTRACT_REASON is highly imbalanced (74.5%)Imbalance
INSPECTION_DATE has 214 (2.1%) missing valuesMissing
SUPERVISOR_DEPT has 2317 (23.2%) missing valuesMissing
SUPERVISOR_NAME has 2317 (23.2%) missing valuesMissing
CONTRACT_DELAY_DATE has 10000 (100.0%) missing valuesMissing
CONTRACT_STOP_DATE has 10000 (100.0%) missing valuesMissing
CONTRACT_CANCEL_DATE has 10000 (100.0%) missing valuesMissing
CONTRACT_PLANNED_PRICE is highly skewed (γ1 = 37.97047503)Skewed
CONTRACT_FIRST_PRICE is highly skewed (γ1 = 35.01367214)Skewed
SUCCESSFUL_PERSENT is highly skewed (γ1 = 99.99700565)Skewed
CONTRACT_PRICE is highly skewed (γ1 = 36.34356714)Skewed
SEQ has unique valuesUnique
CONTRACT_DELAY_DATE is an unsupported type, check if it needs cleaning or further analysisUnsupported
CONTRACT_STOP_DATE is an unsupported type, check if it needs cleaning or further analysisUnsupported
CONTRACT_CANCEL_DATE is an unsupported type, check if it needs cleaning or further analysisUnsupported
CONTRACT_PLANNED_PRICE has 7126 (71.3%) zerosZeros
CONTRACT_PRICE has 102 (1.0%) zerosZeros

Reproduction

Analysis started2023-12-12 22:03:41.246554
Analysis finished2023-12-12 22:03:42.753456
Duration1.51 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

SEQ
Real number (ℝ)

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18022.453
Minimum2
Maximum36230
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T07:03:42.808995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile1756.85
Q18991.75
median17946
Q327038.5
95-th percentile34306.05
Maximum36230
Range36228
Interquartile range (IQR)18046.75

Descriptive statistics

Standard deviation10426.984
Coefficient of variation (CV)0.57855523
Kurtosis-1.200558
Mean18022.453
Median Absolute Deviation (MAD)9016.5
Skewness0.0021390388
Sum1.8022453 × 108
Variance1.08722 × 108
MonotonicityNot monotonic
2023-12-13T07:03:42.931741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
30093 1
 
< 0.1%
23000 1
 
< 0.1%
20836 1
 
< 0.1%
23772 1
 
< 0.1%
33814 1
 
< 0.1%
34083 1
 
< 0.1%
619 1
 
< 0.1%
8117 1
 
< 0.1%
4847 1
 
< 0.1%
31464 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
2 1
< 0.1%
3 1
< 0.1%
10 1
< 0.1%
13 1
< 0.1%
14 1
< 0.1%
16 1
< 0.1%
18 1
< 0.1%
21 1
< 0.1%
22 1
< 0.1%
24 1
< 0.1%
ValueCountFrequency (%)
36230 1
< 0.1%
36227 1
< 0.1%
36215 1
< 0.1%
36211 1
< 0.1%
36207 1
< 0.1%
36200 1
< 0.1%
36199 1
< 0.1%
36197 1
< 0.1%
36196 1
< 0.1%
36195 1
< 0.1%

CONTRACT_MNG_NO
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
202000000000
9941 
201000000000
 
59

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
202000000000 9941
99.4%
201000000000 59
 
0.6%

Length

2023-12-13T07:03:43.061256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:03:43.146026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
202000000000 9941
99.4%
201000000000 59
 
0.6%

CATEGORY1
Categorical

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
수의
6868 
계약
3088 
하도급
 
44

Length

Max length3
Median length2
Mean length2.0044
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row수의
2nd row계약
3rd row계약
4th row계약
5th row계약

Common Values

ValueCountFrequency (%)
수의 6868
68.7%
계약 3088
30.9%
하도급 44
 
0.4%

Length

2023-12-13T07:03:43.224330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:03:43.297299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
수의 6868
68.7%
계약 3088
30.9%
하도급 44
 
0.4%

CATEGORY2
Categorical

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
물품
6238 
공사
2701 
용역
1061 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row물품
2nd row공사
3rd row공사
4th row용역
5th row물품

Common Values

ValueCountFrequency (%)
물품 6238
62.4%
공사 2701
27.0%
용역 1061
 
10.6%

Length

2023-12-13T07:03:43.375273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:03:43.657567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
물품 6238
62.4%
공사 2701
27.0%
용역 1061
 
10.6%

GOV_OFFICE_NAME
Categorical

Distinct34
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
본청
4372 
상하수도사업소
634 
공성면
 
305
모동면
 
280
외서면
 
268
Other values (29)
4141 

Length

Max length11
Median length10
Mean length3.0017
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row사벌국면
2nd row본청
3rd row상하수도사업소
4th row본청
5th row본청

Common Values

ValueCountFrequency (%)
본청 4372
43.7%
상하수도사업소 634
 
6.3%
공성면 305
 
3.0%
모동면 280
 
2.8%
외서면 268
 
2.7%
낙동면 264
 
2.6%
화동면 245
 
2.5%
이안면 236
 
2.4%
모서면 229
 
2.3%
사벌국면 226
 
2.3%
Other values (24) 2941
29.4%

Length

2023-12-13T07:03:43.735522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
본청 4372
43.7%
상하수도사업소 634
 
6.3%
공성면 305
 
3.0%
모동면 280
 
2.8%
외서면 268
 
2.7%
낙동면 264
 
2.6%
화동면 245
 
2.5%
이안면 236
 
2.4%
모서면 229
 
2.3%
사벌국면 226
 
2.3%
Other values (24) 2941
29.4%

CONTRACT_TITLE
Text

Distinct9865
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-13T07:03:43.962650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length58
Median length47
Mean length24.8804
Min length4

Characters and Unicode

Total characters248804
Distinct characters787
Distinct categories13 ?
Distinct scripts3 ?
Distinct blocks6 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique9749 ?
Unique (%)97.5%

Sample

1st row소규모 주민숙원사업 자재지원(2차)(수로관)
2nd row사벌 덕가리(하덕가) 배수로 정비공사
3rd row모서 하수관로 정비공사
4th row중부권 농특산물 융복합단지 조성사업 기본구상 및 타당성조사용역 시행
5th row낙동강 물놀이장 통신공사-전관방송설비
ValueCountFrequency (%)
및 1322
 
3.0%
정비공사 938
 
2.1%
구입 760
 
1.7%
시행 730
 
1.7%
관급자재 710
 
1.6%
농로포장공사 663
 
1.5%
648
 
1.5%
배수로 605
 
1.4%
농로 557
 
1.3%
용역 392
 
0.9%
Other values (10439) 36757
83.4%
2023-12-13T07:03:44.395406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
34120
 
13.7%
사 9696
 
3.9%
공 8714
 
3.5%
리 5854
 
2.4%
로 5838
 
2.3%
( 5666
 
2.3%
) 5657
 
2.3%
수 4723
 
1.9%
관 4613
 
1.9%
정 4249
 
1.7%
Other values (777) 159674
64.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 186854
75.1%
Space Separator 34120
 
13.7%
Decimal Number 9437
 
3.8%
Open Punctuation 5946
 
2.4%
Close Punctuation 5932
 
2.4%
Dash Punctuation 4178
 
1.7%
Uppercase Letter 1346
 
0.5%
Other Punctuation 634
 
0.3%
Math Symbol 193
 
0.1%
Lowercase Letter 108
 
< 0.1%
Other values (3) 56
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 9696
 
5.2%
공 8714
 
4.7%
리 5854
 
3.1%
로 5838
 
3.1%
수 4723
 
2.5%
관 4613
 
2.5%
정 4249
 
2.3%
비 3845
 
2.1%
구 3651
 
2.0%
장 3630
 
1.9%
Other values (703) 132041
70.7%
Uppercase Letter
ValueCountFrequency (%)
P 230
17.1%
C 157
11.7%
E 146
10.8%
V 118
8.8%
D 92
 
6.8%
L 91
 
6.8%
T 83
 
6.2%
R 78
 
5.8%
S 57
 
4.2%
I 53
 
3.9%
Other values (13) 241
17.9%
Lowercase Letter
ValueCountFrequency (%)
a 14
13.0%
c 13
12.0%
t 11
10.2%
e 10
9.3%
r 9
8.3%
i 8
7.4%
o 8
7.4%
d 7
6.5%
p 6
 
5.6%
b 5
 
4.6%
Other values (7) 17
15.7%
Decimal Number
ValueCountFrequency (%)
1 3143
33.3%
2 2837
30.1%
0 891
 
9.4%
3 713
 
7.6%
6 370
 
3.9%
7 350
 
3.7%
8 319
 
3.4%
5 287
 
3.0%
4 281
 
3.0%
9 246
 
2.6%
Other Punctuation
ValueCountFrequency (%)
, 522
82.3%
/ 54
 
8.5%
. 23
 
3.6%
· 22
 
3.5%
: 5
 
0.8%
# 3
 
0.5%
& 3
 
0.5%
' 1
 
0.2%
* 1
 
0.2%
Open Punctuation
ValueCountFrequency (%)
( 5666
95.3%
[ 277
 
4.7%
『 3
 
0.1%
Close Punctuation
ValueCountFrequency (%)
) 5657
95.4%
] 272
 
4.6%
』 3
 
0.1%
Other Number
ValueCountFrequency (%)
① 5
71.4%
② 1
 
14.3%
③ 1
 
14.3%
Math Symbol
ValueCountFrequency (%)
~ 192
99.5%
+ 1
 
0.5%
Space Separator
ValueCountFrequency (%)
34120
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4178
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 46
100.0%
Letter Number
ValueCountFrequency (%)
Ⅵ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 186854
75.1%
Common 60493
 
24.3%
Latin 1457
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 9696
 
5.2%
공 8714
 
4.7%
리 5854
 
3.1%
로 5838
 
3.1%
수 4723
 
2.5%
관 4613
 
2.5%
정 4249
 
2.3%
비 3845
 
2.1%
구 3651
 
2.0%
장 3630
 
1.9%
Other values (703) 132041
70.7%
Latin
ValueCountFrequency (%)
P 230
15.8%
C 157
10.8%
E 146
10.0%
V 118
 
8.1%
D 92
 
6.3%
L 91
 
6.2%
T 83
 
5.7%
R 78
 
5.4%
S 57
 
3.9%
I 53
 
3.6%
Other values (31) 352
24.2%
Common
ValueCountFrequency (%)
34120
56.4%
( 5666
 
9.4%
) 5657
 
9.4%
- 4178
 
6.9%
1 3143
 
5.2%
2 2837
 
4.7%
0 891
 
1.5%
3 713
 
1.2%
, 522
 
0.9%
6 370
 
0.6%
Other values (23) 2396
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 186849
75.1%
ASCII 61912
 
24.9%
None 28
 
< 0.1%
Enclosed Alphanum 7
 
< 0.1%
Compat Jamo 5
 
< 0.1%
Number Forms 3
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
34120
55.1%
( 5666
 
9.2%
) 5657
 
9.1%
- 4178
 
6.7%
1 3143
 
5.1%
2 2837
 
4.6%
0 891
 
1.4%
3 713
 
1.2%
, 522
 
0.8%
6 370
 
0.6%
Other values (57) 3815
 
6.2%
Hangul
ValueCountFrequency (%)
사 9696
 
5.2%
공 8714
 
4.7%
리 5854
 
3.1%
로 5838
 
3.1%
수 4723
 
2.5%
관 4613
 
2.5%
정 4249
 
2.3%
비 3845
 
2.1%
구 3651
 
2.0%
장 3630
 
1.9%
Other values (701) 132036
70.7%
None
ValueCountFrequency (%)
· 22
78.6%
』 3
 
10.7%
『 3
 
10.7%
Enclosed Alphanum
ValueCountFrequency (%)
① 5
71.4%
② 1
 
14.3%
③ 1
 
14.3%
Compat Jamo
ValueCountFrequency (%)
ㅣ 3
60.0%
ㆍ 2
40.0%
Number Forms
ValueCountFrequency (%)
Ⅵ 3
100.0%

CONTRACT_PLANNED_PRICE
Real number (ℝ)

SKEWED  ZEROS 

Distinct2238
Distinct (%)22.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24844830
Minimum0
Maximum1.7654766 × 1010
Zeros7126
Zeros (%)71.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T07:03:44.561656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q32229825
95-th percentile49275927
Maximum1.7654766 × 1010
Range1.7654766 × 1010
Interquartile range (IQR)2229825

Descriptive statistics

Standard deviation3.1585376 × 108
Coefficient of variation (CV)12.713058
Kurtosis1794.4018
Mean24844830
Median Absolute Deviation (MAD)0
Skewness37.970475
Sum2.484483 × 1011
Variance9.9763597 × 1016
MonotonicityNot monotonic
2023-12-13T07:03:44.758328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 7126
71.3%
20000000 17
 
0.2%
22000000 17
 
0.2%
10000000 16
 
0.2%
15000000 12
 
0.1%
4900000 12
 
0.1%
21500000 11
 
0.1%
7000000 11
 
0.1%
21800000 11
 
0.1%
21900000 10
 
0.1%
Other values (2228) 2757
 
27.6%
ValueCountFrequency (%)
0 7126
71.3%
834 1
 
< 0.1%
938 1
 
< 0.1%
955 1
 
< 0.1%
1179 1
 
< 0.1%
1200 1
 
< 0.1%
1391 1
 
< 0.1%
1422 1
 
< 0.1%
30683 1
 
< 0.1%
35180 1
 
< 0.1%
ValueCountFrequency (%)
17654765500 1
 
< 0.1%
15374836200 1
 
< 0.1%
12083977075 1
 
< 0.1%
6636390000 1
 
< 0.1%
6524837200 1
 
< 0.1%
5388911750 1
 
< 0.1%
3442136350 3
< 0.1%
2711113850 1
 
< 0.1%
2655312000 1
 
< 0.1%
2505902025 1
 
< 0.1%

CONTRACT_FIRST_PRICE
Real number (ℝ)

SKEWED 

Distinct7359
Distinct (%)73.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23780129
Minimum9800
Maximum9.6666018 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T07:03:44.917209image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum9800
5-th percentile565590
Q12467150
median7120000
Q314890000
95-th percentile65651255
Maximum9.6666018 × 109
Range9.666592 × 109
Interquartile range (IQR)12422850

Descriptive statistics

Standard deviation1.5795029 × 108
Coefficient of variation (CV)6.6421127
Kurtosis1718.7591
Mean23780129
Median Absolute Deviation (MAD)5314810
Skewness35.013672
Sum2.3780129 × 1011
Variance2.4948295 × 1016
MonotonicityNot monotonic
2023-12-13T07:03:45.064340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
9500000 34
 
0.3%
19000000 19
 
0.2%
7600000 18
 
0.2%
987900 16
 
0.2%
13800000 15
 
0.1%
18400000 15
 
0.1%
4650000 15
 
0.1%
20240000 14
 
0.1%
5700000 13
 
0.1%
20148000 13
 
0.1%
Other values (7349) 9828
98.3%
ValueCountFrequency (%)
9800 1
< 0.1%
16880 1
< 0.1%
20000 1
< 0.1%
20200 1
< 0.1%
25740 1
< 0.1%
32920 1
< 0.1%
35100 1
< 0.1%
42140 1
< 0.1%
43800 1
< 0.1%
47360 1
< 0.1%
ValueCountFrequency (%)
9666601800 1
< 0.1%
5578786000 1
< 0.1%
4675046000 1
< 0.1%
4605941000 1
< 0.1%
2355000000 1
< 0.1%
2173963930 1
< 0.1%
2103479000 1
< 0.1%
2098210000 1
< 0.1%
2040016000 1
< 0.1%
1978194000 1
< 0.1%

SUCCESSFUL_PERSENT
Real number (ℝ)

SKEWED 

Distinct880
Distinct (%)8.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean107.18038
Minimum9.5
Maximum89516.49
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T07:03:45.215176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum9.5
5-th percentile87.88985
Q1100
median100
Q3100
95-th percentile100
Maximum89516.49
Range89506.99
Interquartile range (IQR)0

Descriptive statistics

Standard deviation894.19144
Coefficient of variation (CV)8.3428651
Kurtosis9999.6008
Mean107.18038
Median Absolute Deviation (MAD)0
Skewness99.997006
Sum1071803.8
Variance799578.33
MonotonicityNot monotonic
2023-12-13T07:03:45.383168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100.0 7896
79.0%
92.0 233
 
2.3%
95.0 218
 
2.2%
91.996 40
 
0.4%
91.998 39
 
0.4%
91.997 36
 
0.4%
87.745 26
 
0.3%
87.746 26
 
0.3%
91.995 23
 
0.2%
87.747 19
 
0.2%
Other values (870) 1444
 
14.4%
ValueCountFrequency (%)
9.5 1
< 0.1%
10.0 1
< 0.1%
55.737 1
< 0.1%
66.837 1
< 0.1%
67.643 1
< 0.1%
71.049 1
< 0.1%
72.142 1
< 0.1%
77.997 1
< 0.1%
78.666 1
< 0.1%
78.87 1
< 0.1%
ValueCountFrequency (%)
89516.49 1
 
< 0.1%
100.0 7896
79.0%
99.985 1
 
< 0.1%
99.942 1
 
< 0.1%
99.932 1
 
< 0.1%
99.788 1
 
< 0.1%
99.77 1
 
< 0.1%
99.629 2
 
< 0.1%
99.517 1
 
< 0.1%
99.281 1
 
< 0.1%

CONTRACT_PRICE
Real number (ℝ)

SKEWED  ZEROS 

Distinct7676
Distinct (%)76.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24424166
Minimum0
Maximum1.0855309 × 1010
Zeros102
Zeros (%)1.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T07:03:45.533027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile480130
Q12375880
median6955000
Q314661300
95-th percentile64234640
Maximum1.0855309 × 1010
Range1.0855309 × 1010
Interquartile range (IQR)12285420

Descriptive statistics

Standard deviation1.7721756 × 108
Coefficient of variation (CV)7.2558284
Kurtosis1797.1056
Mean24424166
Median Absolute Deviation (MAD)5208120
Skewness36.343567
Sum2.4424166 × 1011
Variance3.1406062 × 1016
MonotonicityNot monotonic
2023-12-13T07:03:45.711689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 102
 
1.0%
9500000 23
 
0.2%
4650000 15
 
0.1%
19000000 15
 
0.1%
987900 14
 
0.1%
13800000 13
 
0.1%
18000000 12
 
0.1%
18400000 11
 
0.1%
990000 11
 
0.1%
7000000 11
 
0.1%
Other values (7666) 9773
97.7%
ValueCountFrequency (%)
0 102
1.0%
9800 1
 
< 0.1%
16880 1
 
< 0.1%
20000 1
 
< 0.1%
20200 1
 
< 0.1%
25740 1
 
< 0.1%
32920 1
 
< 0.1%
35100 1
 
< 0.1%
42140 1
 
< 0.1%
44440 1
 
< 0.1%
ValueCountFrequency (%)
10855309000 1
< 0.1%
6551680000 1
< 0.1%
6309136000 1
< 0.1%
4118400000 1
< 0.1%
3092349000 1
< 0.1%
2355000000 1
< 0.1%
2325840000 1
< 0.1%
2257458800 1
< 0.1%
2215796000 1
< 0.1%
2176000000 1
< 0.1%

CONTRACT_DATE
Date

Distinct1092
Distinct (%)10.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2009-07-24 00:00:00
Maximum2019-03-05 00:00:00
2023-12-13T07:03:45.874812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:03:46.051023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

CONTRACT_START_DATE
Date

Distinct1108
Distinct (%)11.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2009-07-24 00:00:00
Maximum2019-03-11 00:00:00
2023-12-13T07:03:46.223841image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:03:46.360225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

CONTRACT_END_DATE
Date

Distinct1391
Distinct (%)13.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2015-08-22 00:00:00
Maximum2090-12-31 00:00:00
2023-12-13T07:03:46.524218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:03:46.681984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

CONTRACT_WAY
Categorical

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
수의1인견적
6868 
일반경쟁
2423 
수의2인이상견적
 
463
제한경쟁
 
236
지명경쟁
 
10

Length

Max length8
Median length6
Mean length5.5588
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row수의1인견적
2nd row수의2인이상견적
3rd row제한경쟁
4th row일반경쟁
5th row일반경쟁

Common Values

ValueCountFrequency (%)
수의1인견적 6868
68.7%
일반경쟁 2423
 
24.2%
수의2인이상견적 463
 
4.6%
제한경쟁 236
 
2.4%
지명경쟁 10
 
0.1%

Length

2023-12-13T07:03:46.828564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:03:46.959800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
수의1인견적 6868
68.7%
일반경쟁 2423
 
24.2%
수의2인이상견적 463
 
4.6%
제한경쟁 236
 
2.4%
지명경쟁 10
 
0.1%

COMPLETION_DATE
Date

Distinct1391
Distinct (%)13.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2015-08-22 00:00:00
Maximum2090-12-31 00:00:00
2023-12-13T07:03:47.088917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:03:47.238052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

CONTRACT_TYPE
Categorical

Distinct21
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
관급자재구매
4206 
구매
2014 
전문
1658 
종합
649 
일반
490 
Other values (16)
983 

Length

Max length6
Median length2
Mean length3.7462
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row관급자재구매
2nd row전문
3rd row전문
4th row학술
5th row관급자재구매

Common Values

ValueCountFrequency (%)
관급자재구매 4206
42.1%
구매 2014
20.1%
전문 1658
 
16.6%
종합 649
 
6.5%
일반 490
 
4.9%
기술 253
 
2.5%
폐기물 217
 
2.2%
전기 131
 
1.3%
산림 69
 
0.7%
지하수 57
 
0.6%
Other values (11) 256
 
2.6%

Length

2023-12-13T07:03:47.371711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
관급자재구매 4206
42.1%
구매 2014
20.1%
전문 1658
 
16.6%
종합 649
 
6.5%
일반 490
 
4.9%
기술 253
 
2.5%
폐기물 217
 
2.2%
전기 131
 
1.3%
산림 69
 
0.7%
지하수 57
 
0.6%
Other values (11) 256
 
2.6%

CONTRACT_TARGET
Text

Distinct1703
Distinct (%)17.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-13T07:03:47.703354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length21
Mean length7.6956
Min length2

Characters and Unicode

Total characters76956
Distinct characters484
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

Unique945 ?
Unique (%)9.4%

Sample

1st row(주)덕산지에스
2nd row(주)영광건설
3rd row갑일건설(주)
4th row(재)한국농촌경제연구원
5th row주식회사 소비코프로페셔널
ValueCountFrequency (%)
주식회사 670
 
6.2%
주)덕산지에스 550
 
5.1%
삼우산업(주 460
 
4.2%
주)메쉬코리아 409
 
3.8%
영남레미콘사업(협 293
 
2.7%
중화레미콘(주 263
 
2.4%
삼백레미콘주식회사 216
 
2.0%
동원파이프상사 216
 
2.0%
주)한국테크원 185
 
1.7%
대구지방조달청 182
 
1.7%
Other values (1745) 7402
68.2%
2023-12-13T07:03:48.175150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 7649
 
9.9%
) 6646
 
8.6%
( 6645
 
8.6%
사 2263
 
2.9%
산 2001
 
2.6%
건 1830
 
2.4%
업 1750
 
2.3%
설 1608
 
2.1%
콘 1580
 
2.1%
미 1341
 
1.7%
Other values (474) 43643
56.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 62587
81.3%
Close Punctuation 6646
 
8.6%
Open Punctuation 6645
 
8.6%
Space Separator 847
 
1.1%
Uppercase Letter 117
 
0.2%
Lowercase Letter 60
 
0.1%
Other Punctuation 27
 
< 0.1%
Math Symbol 16
 
< 0.1%
Decimal Number 8
 
< 0.1%
Dash Punctuation 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 7649
 
12.2%
사 2263
 
3.6%
산 2001
 
3.2%
건 1830
 
2.9%
업 1750
 
2.8%
설 1608
 
2.6%
콘 1580
 
2.5%
미 1341
 
2.1%
스 1298
 
2.1%
회 1256
 
2.0%
Other values (434) 40011
63.9%
Uppercase Letter
ValueCountFrequency (%)
A 15
12.8%
O 12
10.3%
E 12
10.3%
H 10
8.5%
M 10
8.5%
D 9
7.7%
C 8
 
6.8%
S 7
 
6.0%
P 6
 
5.1%
J 6
 
5.1%
Other values (10) 22
18.8%
Lowercase Letter
ValueCountFrequency (%)
n 18
30.0%
e 12
20.0%
i 12
20.0%
g 12
20.0%
r 6
 
10.0%
Other Punctuation
ValueCountFrequency (%)
& 12
44.4%
. 10
37.0%
, 3
 
11.1%
/ 1
 
3.7%
· 1
 
3.7%
Decimal Number
ValueCountFrequency (%)
1 4
50.0%
3 2
25.0%
2 1
 
12.5%
9 1
 
12.5%
Math Symbol
ValueCountFrequency (%)
< 8
50.0%
> 8
50.0%
Close Punctuation
ValueCountFrequency (%)
) 6646
100.0%
Open Punctuation
ValueCountFrequency (%)
( 6645
100.0%
Space Separator
ValueCountFrequency (%)
847
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 62587
81.3%
Common 14192
 
18.4%
Latin 177
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 7649
 
12.2%
사 2263
 
3.6%
산 2001
 
3.2%
건 1830
 
2.9%
업 1750
 
2.8%
설 1608
 
2.6%
콘 1580
 
2.5%
미 1341
 
2.1%
스 1298
 
2.1%
회 1256
 
2.0%
Other values (434) 40011
63.9%
Latin
ValueCountFrequency (%)
n 18
 
10.2%
A 15
 
8.5%
O 12
 
6.8%
e 12
 
6.8%
E 12
 
6.8%
i 12
 
6.8%
g 12
 
6.8%
H 10
 
5.6%
M 10
 
5.6%
D 9
 
5.1%
Other values (15) 55
31.1%
Common
ValueCountFrequency (%)
) 6646
46.8%
( 6645
46.8%
847
 
6.0%
& 12
 
0.1%
. 10
 
0.1%
< 8
 
0.1%
> 8
 
0.1%
1 4
 
< 0.1%
- 3
 
< 0.1%
, 3
 
< 0.1%
Other values (5) 6
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 62587
81.3%
ASCII 14368
 
18.7%
None 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 7649
 
12.2%
사 2263
 
3.6%
산 2001
 
3.2%
건 1830
 
2.9%
업 1750
 
2.8%
설 1608
 
2.6%
콘 1580
 
2.5%
미 1341
 
2.1%
스 1298
 
2.1%
회 1256
 
2.0%
Other values (434) 40011
63.9%
ASCII
ValueCountFrequency (%)
) 6646
46.3%
( 6645
46.2%
847
 
5.9%
n 18
 
0.1%
A 15
 
0.1%
O 12
 
0.1%
e 12
 
0.1%
E 12
 
0.1%
i 12
 
0.1%
& 12
 
0.1%
Other values (29) 137
 
1.0%
None
ValueCountFrequency (%)
· 1
100.0%

CONTRACT_REASON
Categorical

IMBALANCE 

Distinct25
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
소액수의
7110 
일반경쟁
2423 
지역제한
 
185
국가기관, 다른지자체
 
109
기타
 
54
Other values (20)
 
119

Length

Max length39
Median length4
Mean length4.1803
Min length2

Unique

Unique4 ?
Unique (%)< 0.1%

Sample

1st row소액수의
2nd row소액수의
3rd row지역제한
4th row일반경쟁
5th row일반경쟁

Common Values

ValueCountFrequency (%)
소액수의 7110
71.1%
일반경쟁 2423
 
24.2%
지역제한 185
 
1.8%
국가기관, 다른지자체 109
 
1.1%
기타 54
 
0.5%
기타(농공단지) 27
 
0.3%
중소기업+지역제한 24
 
0.2%
일정금액(일반 30억, 전문 등 3억)이상 공사 / 도급한도액시공능력 10
 
0.1%
기타(다른법령위탁대행) 10
 
0.1%
재공고입찰수의 9
 
0.1%
Other values (15) 39
 
0.4%

Length

2023-12-13T07:03:48.324371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
소액수의 7110
69.1%
일반경쟁 2423
 
23.6%
지역제한 185
 
1.8%
국가기관 109
 
1.1%
다른지자체 109
 
1.1%
기타 54
 
0.5%
기타(농공단지 27
 
0.3%
27
 
0.3%
중소기업+지역제한 24
 
0.2%
공사 20
 
0.2%
Other values (41) 195
 
1.9%

INSPECTION_DATE
Real number (ℝ)

MISSING 

Distinct1221
Distinct (%)12.5%
Missing214
Missing (%)2.1%
Infinite0
Infinite (%)0.0%
Mean20170931
Minimum20140430
Maximum20200820
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T07:03:48.467759image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20140430
5-th percentile20151123
Q120160908
median20170825
Q320180612
95-th percentile20190319
Maximum20200820
Range60390
Interquartile range (IQR)19704

Descriptive statistics

Standard deviation10835.704
Coefficient of variation (CV)0.00053719404
Kurtosis-0.74251982
Mean20170931
Median Absolute Deviation (MAD)9801
Skewness-0.11684152
Sum1.9739273 × 1011
Variance1.1741248 × 108
MonotonicityNot monotonic
2023-12-13T07:03:48.624791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20171226 59
 
0.6%
20181217 50
 
0.5%
20171220 48
 
0.5%
20171222 45
 
0.4%
20171218 44
 
0.4%
20171219 42
 
0.4%
20171227 41
 
0.4%
20160629 39
 
0.4%
20181227 39
 
0.4%
20181224 39
 
0.4%
Other values (1211) 9340
93.4%
(Missing) 214
 
2.1%
ValueCountFrequency (%)
20140430 1
< 0.1%
20140530 1
< 0.1%
20141203 1
< 0.1%
20150113 1
< 0.1%
20150121 1
< 0.1%
20150127 1
< 0.1%
20150205 1
< 0.1%
20150210 1
< 0.1%
20150223 1
< 0.1%
20150224 2
< 0.1%
ValueCountFrequency (%)
20200820 1
< 0.1%
20200818 1
< 0.1%
20200805 1
< 0.1%
20200804 1
< 0.1%
20200730 1
< 0.1%
20200713 2
< 0.1%
20200622 1
< 0.1%
20200610 1
< 0.1%
20200604 1
< 0.1%
20200526 1
< 0.1%

CONTRACT_TARGET_LOCATION
Text

Distinct1534
Distinct (%)15.3%
Missing5
Missing (%)< 0.1%
Memory size156.2 KiB
2023-12-13T07:03:48.950033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length44
Median length30
Mean length16.817409
Min length6

Characters and Unicode

Total characters168090
Distinct characters369
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique869 ?
Unique (%)8.7%

Sample

1st row경상북도 상주시 헌신공단길
2nd row경상북도 상주시 모서면 삼포3길 18
3rd row경상북도 상주시 경상대로
4th row전라남도 나주시 빛가람로 601
5th row경기도 양주시 백석읍 권율로1203번길 39-33
ValueCountFrequency (%)
경상북도 8301
22.0%
상주시 6889
 
18.2%
공성면 805
 
2.1%
헌신공단길 610
 
1.6%
경상대로 493
 
1.3%
화동면 492
 
1.3%
영남제일로 490
 
1.3%
대구광역시 472
 
1.3%
서울특별시 447
 
1.2%
평천공단길 434
 
1.1%
Other values (2101) 18316
48.5%
2023-12-13T07:03:49.481263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
29498
17.5%
상 16439
 
9.8%
경 9572
 
5.7%
시 9561
 
5.7%
도 8955
 
5.3%
북 8843
 
5.3%
주 7690
 
4.6%
길 4667
 
2.8%
로 4576
 
2.7%
1 3673
 
2.2%
Other values (359) 64616
38.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 120445
71.7%
Space Separator 29498
 
17.5%
Decimal Number 16531
 
9.8%
Dash Punctuation 1595
 
0.9%
Other Punctuation 8
 
< 0.1%
Uppercase Letter 5
 
< 0.1%
Close Punctuation 4
 
< 0.1%
Open Punctuation 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
상 16439
 
13.6%
경 9572
 
7.9%
시 9561
 
7.9%
도 8955
 
7.4%
북 8843
 
7.3%
주 7690
 
6.4%
길 4667
 
3.9%
로 4576
 
3.8%
면 2873
 
2.4%
동 2607
 
2.2%
Other values (339) 44662
37.1%
Decimal Number
ValueCountFrequency (%)
1 3673
22.2%
2 3196
19.3%
8 1772
10.7%
4 1458
 
8.8%
7 1449
 
8.8%
3 1429
 
8.6%
5 1262
 
7.6%
0 911
 
5.5%
9 708
 
4.3%
6 673
 
4.1%
Uppercase Letter
ValueCountFrequency (%)
A 2
40.0%
C 1
20.0%
E 1
20.0%
P 1
20.0%
Other Punctuation
ValueCountFrequency (%)
, 7
87.5%
/ 1
 
12.5%
Space Separator
ValueCountFrequency (%)
29498
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1595
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 120445
71.7%
Common 47640
 
28.3%
Latin 5
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
상 16439
 
13.6%
경 9572
 
7.9%
시 9561
 
7.9%
도 8955
 
7.4%
북 8843
 
7.3%
주 7690
 
6.4%
길 4667
 
3.9%
로 4576
 
3.8%
면 2873
 
2.4%
동 2607
 
2.2%
Other values (339) 44662
37.1%
Common
ValueCountFrequency (%)
29498
61.9%
1 3673
 
7.7%
2 3196
 
6.7%
8 1772
 
3.7%
- 1595
 
3.3%
4 1458
 
3.1%
7 1449
 
3.0%
3 1429
 
3.0%
5 1262
 
2.6%
0 911
 
1.9%
Other values (6) 1397
 
2.9%
Latin
ValueCountFrequency (%)
A 2
40.0%
C 1
20.0%
E 1
20.0%
P 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 120445
71.7%
ASCII 47645
 
28.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
29498
61.9%
1 3673
 
7.7%
2 3196
 
6.7%
8 1772
 
3.7%
- 1595
 
3.3%
4 1458
 
3.1%
7 1449
 
3.0%
3 1429
 
3.0%
5 1262
 
2.6%
0 911
 
1.9%
Other values (10) 1402
 
2.9%
Hangul
ValueCountFrequency (%)
상 16439
 
13.6%
경 9572
 
7.9%
시 9561
 
7.9%
도 8955
 
7.4%
북 8843
 
7.3%
주 7690
 
6.4%
길 4667
 
3.9%
로 4576
 
3.8%
면 2873
 
2.4%
동 2607
 
2.2%
Other values (339) 44662
37.1%

SUPERVISOR_DEPT
Text

MISSING 

Distinct59
Distinct (%)0.8%
Missing2317
Missing (%)23.2%
Memory size156.2 KiB
2023-12-13T07:03:49.702699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length3
Mean length3.9645972
Min length3

Characters and Unicode

Total characters30460
Distinct characters112
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique3 ?
Unique (%)< 0.1%

Sample

1st row사벌국면
2nd row건설과
3rd row상하수도사업소
4th row경제기업과
5th row관광진흥과
ValueCountFrequency (%)
건설과 1287
16.8%
개발지원과 675
 
8.8%
상하수도사업소 507
 
6.6%
도시과 481
 
6.3%
산림녹지과 332
 
4.3%
외서면 266
 
3.5%
낙동면 264
 
3.4%
모동면 260
 
3.4%
관광진흥과 238
 
3.1%
모서면 225
 
2.9%
Other values (49) 3148
41.0%
2023-12-13T07:03:50.414372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
과 4121
 
13.5%
면 2346
 
7.7%
건 1373
 
4.5%
동 1314
 
4.3%
설 1287
 
4.2%
지 1217
 
4.0%
도 988
 
3.2%
원 809
 
2.7%
사 791
 
2.6%
업 752
 
2.5%
Other values (102) 15462
50.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 30460
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
과 4121
 
13.5%
면 2346
 
7.7%
건 1373
 
4.5%
동 1314
 
4.3%
설 1287
 
4.2%
지 1217
 
4.0%
도 988
 
3.2%
원 809
 
2.7%
사 791
 
2.6%
업 752
 
2.5%
Other values (102) 15462
50.8%

Most occurring scripts

ValueCountFrequency (%)
Hangul 30460
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
과 4121
 
13.5%
면 2346
 
7.7%
건 1373
 
4.5%
동 1314
 
4.3%
설 1287
 
4.2%
지 1217
 
4.0%
도 988
 
3.2%
원 809
 
2.7%
사 791
 
2.6%
업 752
 
2.5%
Other values (102) 15462
50.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 30460
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
과 4121
 
13.5%
면 2346
 
7.7%
건 1373
 
4.5%
동 1314
 
4.3%
설 1287
 
4.2%
지 1217
 
4.0%
도 988
 
3.2%
원 809
 
2.7%
사 791
 
2.6%
업 752
 
2.5%
Other values (102) 15462
50.8%

SUPERVISOR_NAME
Text

MISSING 

Distinct500
Distinct (%)6.5%
Missing2317
Missing (%)23.2%
Memory size156.2 KiB
2023-12-13T07:03:50.766585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length3
Mean length3.0028635
Min length2

Characters and Unicode

Total characters23071
Distinct characters167
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique161 ?
Unique (%)2.1%

Sample

1st row이재명
2nd row김인식
3rd row최병찬
4th row신영민
5th row윤승민
ValueCountFrequency (%)
김두영 246
 
3.2%
박주호 233
 
3.0%
배성호 224
 
2.9%
차한준 176
 
2.3%
김동구 167
 
2.2%
최영철 166
 
2.2%
차재현 165
 
2.1%
김대성 156
 
2.0%
정신일 142
 
1.8%
김형준 139
 
1.8%
Other values (490) 5869
76.4%
2023-12-13T07:03:51.291142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 2316
 
10.0%
성 1074
 
4.7%
영 938
 
4.1%
재 852
 
3.7%
정 831
 
3.6%
이 787
 
3.4%
호 607
 
2.6%
박 594
 
2.6%
현 509
 
2.2%
준 451
 
2.0%
Other values (157) 14112
61.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 23071
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 2316
 
10.0%
성 1074
 
4.7%
영 938
 
4.1%
재 852
 
3.7%
정 831
 
3.6%
이 787
 
3.4%
호 607
 
2.6%
박 594
 
2.6%
현 509
 
2.2%
준 451
 
2.0%
Other values (157) 14112
61.2%

Most occurring scripts

ValueCountFrequency (%)
Hangul 23071
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 2316
 
10.0%
성 1074
 
4.7%
영 938
 
4.1%
재 852
 
3.7%
정 831
 
3.6%
이 787
 
3.4%
호 607
 
2.6%
박 594
 
2.6%
현 509
 
2.2%
준 451
 
2.0%
Other values (157) 14112
61.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 23071
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 2316
 
10.0%
성 1074
 
4.7%
영 938
 
4.1%
재 852
 
3.7%
정 831
 
3.6%
이 787
 
3.4%
호 607
 
2.6%
박 594
 
2.6%
현 509
 
2.2%
준 451
 
2.0%
Other values (157) 14112
61.2%

CONTRACT_DELAY_DATE
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing10000
Missing (%)100.0%
Memory size166.0 KiB

CONTRACT_STOP_DATE
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing10000
Missing (%)100.0%
Memory size166.0 KiB

CONTRACT_CANCEL_DATE
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing10000
Missing (%)100.0%
Memory size166.0 KiB

MODIFY_DATE
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2020-08-21 3:30
10000 

Length

Max length15
Median length15
Mean length15
Min length15

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2020-08-21 3:30
2nd row2020-08-21 3:30
3rd row2020-08-21 3:30
4th row2020-08-21 3:30
5th row2020-08-21 3:30

Common Values

ValueCountFrequency (%)
2020-08-21 3:30 10000
100.0%

Length

2023-12-13T07:03:51.448768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:03:51.556298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020-08-21 10000
50.0%
3:30 10000
50.0%

REG_DATE
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2020-08-21 3:30
10000 

Length

Max length15
Median length15
Mean length15
Min length15

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2020-08-21 3:30
2nd row2020-08-21 3:30
3rd row2020-08-21 3:30
4th row2020-08-21 3:30
5th row2020-08-21 3:30

Common Values

ValueCountFrequency (%)
2020-08-21 3:30 10000
100.0%

Length

2023-12-13T07:03:51.661990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:03:51.755354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020-08-21 10000
50.0%
3:30 10000
50.0%

Sample

SEQCONTRACT_MNG_NOCATEGORY1CATEGORY2GOV_OFFICE_NAMECONTRACT_TITLECONTRACT_PLANNED_PRICECONTRACT_FIRST_PRICESUCCESSFUL_PERSENTCONTRACT_PRICECONTRACT_DATECONTRACT_START_DATECONTRACT_END_DATECONTRACT_WAYCOMPLETION_DATECONTRACT_TYPECONTRACT_TARGETCONTRACT_REASONINSPECTION_DATECONTRACT_TARGET_LOCATIONSUPERVISOR_DEPTSUPERVISOR_NAMECONTRACT_DELAY_DATECONTRACT_STOP_DATECONTRACT_CANCEL_DATEMODIFY_DATEREG_DATE
3138530093202000000000수의물품사벌국면소규모 주민숙원사업 자재지원(2차)(수로관)01487920100.014879202018-06-262018-06-262018-07-05수의1인견적2018-07-05관급자재구매(주)덕산지에스소액수의20180628경상북도 상주시 헌신공단길사벌국면이재명<NA><NA><NA>2020-08-21 3:302020-08-21 3:30
3516733283202000000000계약공사본청사벌 덕가리(하덕가) 배수로 정비공사381172253346277087.789297970002018-11-052018-11-052019-03-29수의2인이상견적2019-03-29전문(주)영광건설소액수의20190408경상북도 상주시 모서면 삼포3길 18건설과김인식<NA><NA><NA>2020-08-21 3:302020-08-21 3:30
1936921418202000000000계약공사상하수도사업소모서 하수관로 정비공사1095635009619600087.799609690002017-09-292017-10-112018-06-09제한경쟁2018-06-09전문갑일건설(주)지역제한20180618경상북도 상주시 경상대로상하수도사업소최병찬<NA><NA><NA>2020-08-21 3:302020-08-21 3:30
2496521937202000000000계약용역본청중부권 농특산물 융복합단지 조성사업 기본구상 및 타당성조사용역 시행19635352515730000088.1211573000002017-10-302017-11-012018-12-03일반경쟁2018-12-03학술(재)한국농촌경제연구원일반경쟁20181210전라남도 나주시 빛가람로 601경제기업과신영민<NA><NA><NA>2020-08-21 3:302020-08-21 3:30
2183118437202000000000계약물품본청낙동강 물놀이장 통신공사-전관방송설비04119800100.041198002017-06-152017-06-152017-08-25일반경쟁2017-08-25관급자재구매주식회사 소비코프로페셔널일반경쟁20170825경기도 양주시 백석읍 권율로1203번길 39-33관광진흥과윤승민<NA><NA><NA>2020-08-21 3:302020-08-21 3:30
3123829620202000000000수의용역본청도시재생사업-상주주조 가옥철거 및 정비(폐합성수지 처리용역)2100000199400094.95219940002018-06-122018-06-122018-07-03수의1인견적2018-07-03폐기물(주)정림산업소액수의20180704경상북도 상주시 공성면 상무로 340-10도시과이동순<NA><NA><NA>2020-08-21 3:302020-08-21 3:30
2297424583202000000000계약물품본청함창중앙초등학교 어린이보호구역 개선공사 - 미끄럼방지바닥포장재033493180100.0334931802018-02-082018-02-082018-03-30일반경쟁2018-03-30관급자재구매(주)소일콘일반경쟁20180525경상북도 상주시 신서문1길 112건설과정해창<NA><NA><NA>2020-08-21 3:302020-08-21 3:30
2728325925202000000000수의물품중동면관급자재구입-용접철망(죽암1리 배수로 설치공사)13776401377640100.013776402018-03-192018-03-192018-04-16수의1인견적2018-04-16관급자재구매주식회사 타이슨소액수의20180416경상북도 상주시 사벌면 목가1길 103중동면오재화<NA><NA><NA>2020-08-21 3:302020-08-21 3:30
1724315272202000000000수의물품본청브루셀라·결핵 검진등 및 예방접종 가축방역 소모품 구입[시]018545000100.0185450002017-03-142017-03-142017-04-03수의1인견적2017-04-03구매중앙가축약품소액수의20170403경상북도 상주시 공성면 옥산리축산과권학현<NA><NA><NA>2020-08-21 3:302020-08-21 3:30
3493333220202000000000수의공사화북면저수지 스핀들[종대]수리및 수문 교체에 따른 긴급 보수06270000100.062700002018-11-012018-11-012018-11-29수의1인견적2018-11-29종합용호산업개발주식회사소액수의20181129경상북도 상주시 서곡3길<NA><NA><NA><NA><NA>2020-08-21 3:302020-08-21 3:30
SEQCONTRACT_MNG_NOCATEGORY1CATEGORY2GOV_OFFICE_NAMECONTRACT_TITLECONTRACT_PLANNED_PRICECONTRACT_FIRST_PRICESUCCESSFUL_PERSENTCONTRACT_PRICECONTRACT_DATECONTRACT_START_DATECONTRACT_END_DATECONTRACT_WAYCOMPLETION_DATECONTRACT_TYPECONTRACT_TARGETCONTRACT_REASONINSPECTION_DATECONTRACT_TARGET_LOCATIONSUPERVISOR_DEPTSUPERVISOR_NAMECONTRACT_DELAY_DATECONTRACT_STOP_DATECONTRACT_CANCEL_DATEMODIFY_DATEREG_DATE
59154764202000000000계약공사본청후천교 상산교 계룡교 구간 차선도색공사454423503995971087.934399597102016-02-222016-02-252016-03-11수의2인이상견적2016-03-11전문(주)세모라인소액수의20160315경상북도 상주시 낙양동건설과김대성<NA><NA><NA>2020-08-21 3:302020-08-21 3:30
3374234933202000000000계약물품본청중동면 월상저수지 주변 정비공사-옹벽블럭 추가01170000100.011700002018-12-262018-12-262019-01-25일반경쟁2019-01-25관급자재구매(주)덕산지에스일반경쟁20181227경상북도 상주시 헌신공단길개발지원과배성호<NA><NA><NA>2020-08-21 3:302020-08-21 3:30
1178214449202000000000수의물품신흥동신흥5통 가장안길포장공사(용접철망)03941580100.039415802017-03-082017-03-082017-04-16수의1인견적2017-04-16구매(주)메쉬코리아소액수의20170324경상북도 상주시 공성면 평천공단길<NA><NA><NA><NA><NA>2020-08-21 3:302020-08-21 3:30
1796814736202000000000수의공사은척면은척봉상2리농로포장공사011970000100.0115090002017-03-092017-03-152017-04-19수의1인견적2017-04-19종합(주)우성건설소액수의20170419경상북도 상주시 은척면 봉중2길 20-6은척면채영구<NA><NA><NA>2020-08-21 3:302020-08-21 3:30
2734826624202000000000계약물품본청실내승마장 진입로 데크설치공사 시행(금속제울타리)05040000100.050400002018-03-262018-03-262018-05-15일반경쟁2018-05-15관급자재구매천일합성목재주식회사일반경쟁20180417경상남도 창원시 마산합포구 진전면 삼진의거대로 364-77축산과김준성<NA><NA><NA>2020-08-21 3:302020-08-21 3:30
68313583202000000000수의물품상하수도사업소모동 금천오수관거 설치공사-레미콘02479800100.024798002015-11-202015-11-202016-01-30수의1인견적2016-01-30구매영남레미콘사업(협)소액수의20160214경상북도 영주시 구성로88번길상하수도사업소김태연<NA><NA><NA>2020-08-21 3:302020-08-21 3:30
1658915780202000000000수의물품외서면관급자재 추가 구입(이천리 농로 및 수로설치공사) / 레미콘756250756250100.07562502017-03-172017-03-172017-04-28수의1인견적2017-04-28구매삼백레미콘주식회사소액수의20170323경상북도 상주시 외서면 귀호길외서면김영국<NA><NA><NA>2020-08-21 3:302020-08-21 3:30
3105630225202000000000수의용역계림동계림 중덕어덕길(8통) 농로정비 폐기물처리용역 시행04035000100.050720002018-06-292018-06-292018-12-05수의1인견적2018-12-05일반(주)삼백환경소액수의20181205경상북도 상주시 선상서로 2389-54<NA><NA><NA><NA><NA>2020-08-21 3:302020-08-21 3:30
96887837202000000000계약공사본청청리면사무소옆 소로(3-4) 확포장공사785482006893770087.764761200002016-04-152016-04-222017-03-22수의2인이상견적2017-03-22종합(주)일진건설소액수의20170328경상북도 상주시 함창읍 함창중앙로도시과조재영<NA><NA><NA>2020-08-21 3:302020-08-21 3:30
2528222711202000000000계약공사상하수도사업소동지역 하수도맨홀 단차 개선공사18080010015865410087.7511758000002017-11-202017-11-272018-06-01제한경쟁2018-06-01전문경동건설 주식회사지역제한20180605경상북도 경주시 충효녹지길 142-7상하수도사업소최병찬<NA><NA><NA>2020-08-21 3:302020-08-21 3:30