Overview

Dataset statistics

Number of variables21
Number of observations166
Missing cells1
Missing cells (%)< 0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory28.2 KiB
Average record size in memory173.8 B

Variable types

Numeric5
Text5
Categorical6
DateTime5

Dataset

Description시흥도시공사에서 체결한 500만원 이상의 공사 대가지급 현황입니다. 유지보수 및 친환경정책에 따른 각종 공사(석면제거포함)의 계약현황 등의 정보를 포함하며, 계약시기 및 물품가액 등이 기재되어 있습니다.
Author시흥도시공사
URLhttps://www.data.go.kr/data/15098957/fileData.do

Alerts

요청기관 has constant value ""Constant
계약기관 has constant value ""Constant
신규장기구분 has constant value ""Constant
공사현장 has constant value ""Constant
계약방법 is highly imbalanced (74.5%)Imbalance
번호 has unique valuesUnique
예정가격 has 153 (92.2%) zerosZeros
낙찰률 has 153 (92.2%) zerosZeros
낙찰금액 has 153 (92.2%) zerosZeros

Reproduction

Analysis started2024-04-22 00:26:50.304907
Analysis finished2024-04-22 00:26:50.776908
Duration0.47 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

UNIQUE 

Distinct166
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean83.5
Minimum1
Maximum166
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2024-04-22T09:26:50.839117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile9.25
Q142.25
median83.5
Q3124.75
95-th percentile157.75
Maximum166
Range165
Interquartile range (IQR)82.5

Descriptive statistics

Standard deviation48.064193
Coefficient of variation (CV)0.57561908
Kurtosis-1.2
Mean83.5
Median Absolute Deviation (MAD)41.5
Skewness0
Sum13861
Variance2310.1667
MonotonicityStrictly increasing
2024-04-22T09:26:50.969500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.6%
106 1
 
0.6%
108 1
 
0.6%
109 1
 
0.6%
110 1
 
0.6%
111 1
 
0.6%
112 1
 
0.6%
113 1
 
0.6%
114 1
 
0.6%
115 1
 
0.6%
Other values (156) 156
94.0%
ValueCountFrequency (%)
1 1
0.6%
2 1
0.6%
3 1
0.6%
4 1
0.6%
5 1
0.6%
6 1
0.6%
7 1
0.6%
8 1
0.6%
9 1
0.6%
10 1
0.6%
ValueCountFrequency (%)
166 1
0.6%
165 1
0.6%
164 1
0.6%
163 1
0.6%
162 1
0.6%
161 1
0.6%
160 1
0.6%
159 1
0.6%
158 1
0.6%
157 1
0.6%
Distinct165
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2024-04-22T09:26:51.199503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length11
Mean length10.987952
Min length9

Characters and Unicode

Total characters1824
Distinct characters16
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique164 ?
Unique (%)98.8%

Sample

1st row20210111A04
2nd row20210206F96
3rd row20210206FD3
4th row20210206FBE
5th row2021020CD45
ValueCountFrequency (%)
2022020663b 2
 
1.2%
20230512d00 1
 
0.6%
202211149dd 1
 
0.6%
202210124ae 1
 
0.6%
2022100660f 1
 
0.6%
20221103e7c 1
 
0.6%
2022110f46e 1
 
0.6%
2022110fb16 1
 
0.6%
2022110fb09 1
 
0.6%
20221117fd9 1
 
0.6%
Other values (155) 155
93.4%
2024-04-22T09:26:51.564692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 463
25.4%
2 457
25.1%
1 239
13.1%
3 109
 
6.0%
5 69
 
3.8%
6 68
 
3.7%
8 64
 
3.5%
4 52
 
2.9%
9 44
 
2.4%
F 42
 
2.3%
Other values (6) 217
11.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1601
87.8%
Uppercase Letter 223
 
12.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 463
28.9%
2 457
28.5%
1 239
14.9%
3 109
 
6.8%
5 69
 
4.3%
6 68
 
4.2%
8 64
 
4.0%
4 52
 
3.2%
9 44
 
2.7%
7 36
 
2.2%
Uppercase Letter
ValueCountFrequency (%)
F 42
18.8%
C 39
17.5%
B 37
16.6%
D 37
16.6%
A 34
15.2%
E 34
15.2%

Most occurring scripts

ValueCountFrequency (%)
Common 1601
87.8%
Latin 223
 
12.2%

Most frequent character per script

Common
ValueCountFrequency (%)
0 463
28.9%
2 457
28.5%
1 239
14.9%
3 109
 
6.8%
5 69
 
4.3%
6 68
 
4.2%
8 64
 
4.0%
4 52
 
3.2%
9 44
 
2.7%
7 36
 
2.2%
Latin
ValueCountFrequency (%)
F 42
18.8%
C 39
17.5%
B 37
16.6%
D 37
16.6%
A 34
15.2%
E 34
15.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1824
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 463
25.4%
2 457
25.1%
1 239
13.1%
3 109
 
6.0%
5 69
 
3.8%
6 68
 
3.7%
8 64
 
3.5%
4 52
 
2.9%
9 44
 
2.4%
F 42
 
2.3%
Other values (6) 217
11.9%
Distinct165
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2024-04-22T09:26:51.851609image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length40
Median length32
Mean length24.451807
Min length11

Characters and Unicode

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

Unique

Unique164 ?
Unique (%)98.8%

Sample

1st row2021년 캠핑사이트 전기 및 소화기함 교체공사
2nd row은계어울림센터-1 건립 전기공사
3rd row은계어울림센터-1 건립 소방공사
4th row은계어울림센터-1 건립 정보통신공사
5th row방산동 공영차고지 전력계량기 분리 공사
ValueCountFrequency (%)
공사 78
 
8.6%
42
 
4.6%
설치 20
 
2.2%
교체 20
 
2.2%
그린센터 17
 
1.9%
보수 15
 
1.7%
시흥그린센터 13
 
1.4%
교체공사 12
 
1.3%
소래초 11
 
1.2%
개선공사 10
 
1.1%
Other values (437) 669
73.8%
2024-04-22T09:26:52.271984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
741
 
18.3%
212
 
5.2%
174
 
4.3%
81
 
2.0%
74
 
1.8%
65
 
1.6%
64
 
1.6%
63
 
1.6%
62
 
1.5%
60
 
1.5%
Other values (328) 2463
60.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3136
77.3%
Space Separator 741
 
18.3%
Decimal Number 73
 
1.8%
Other Punctuation 29
 
0.7%
Open Punctuation 26
 
0.6%
Close Punctuation 26
 
0.6%
Uppercase Letter 17
 
0.4%
Dash Punctuation 7
 
0.2%
Math Symbol 3
 
0.1%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
212
 
6.8%
174
 
5.5%
81
 
2.6%
74
 
2.4%
65
 
2.1%
64
 
2.0%
63
 
2.0%
62
 
2.0%
60
 
1.9%
48
 
1.5%
Other values (305) 2233
71.2%
Uppercase Letter
ValueCountFrequency (%)
C 5
29.4%
A 3
17.6%
B 3
17.6%
P 2
 
11.8%
G 1
 
5.9%
H 1
 
5.9%
S 1
 
5.9%
U 1
 
5.9%
Decimal Number
ValueCountFrequency (%)
1 31
42.5%
2 29
39.7%
3 4
 
5.5%
0 4
 
5.5%
5 3
 
4.1%
6 2
 
2.7%
Other Punctuation
ValueCountFrequency (%)
, 27
93.1%
# 1
 
3.4%
. 1
 
3.4%
Space Separator
ValueCountFrequency (%)
741
100.0%
Open Punctuation
ValueCountFrequency (%)
( 26
100.0%
Close Punctuation
ValueCountFrequency (%)
) 26
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%
Math Symbol
ValueCountFrequency (%)
~ 3
100.0%
Lowercase Letter
ValueCountFrequency (%)
o 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3136
77.3%
Common 905
 
22.3%
Latin 18
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
212
 
6.8%
174
 
5.5%
81
 
2.6%
74
 
2.4%
65
 
2.1%
64
 
2.0%
63
 
2.0%
62
 
2.0%
60
 
1.9%
48
 
1.5%
Other values (305) 2233
71.2%
Common
ValueCountFrequency (%)
741
81.9%
1 31
 
3.4%
2 29
 
3.2%
, 27
 
3.0%
( 26
 
2.9%
) 26
 
2.9%
- 7
 
0.8%
3 4
 
0.4%
0 4
 
0.4%
~ 3
 
0.3%
Other values (4) 7
 
0.8%
Latin
ValueCountFrequency (%)
C 5
27.8%
A 3
16.7%
B 3
16.7%
P 2
 
11.1%
G 1
 
5.6%
H 1
 
5.6%
S 1
 
5.6%
U 1
 
5.6%
o 1
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3136
77.3%
ASCII 923
 
22.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
741
80.3%
1 31
 
3.4%
2 29
 
3.1%
, 27
 
2.9%
( 26
 
2.8%
) 26
 
2.8%
- 7
 
0.8%
C 5
 
0.5%
3 4
 
0.4%
0 4
 
0.4%
Other values (13) 23
 
2.5%
Hangul
ValueCountFrequency (%)
212
 
6.8%
174
 
5.5%
81
 
2.6%
74
 
2.4%
65
 
2.1%
64
 
2.0%
63
 
2.0%
62
 
2.0%
60
 
1.9%
48
 
1.5%
Other values (305) 2233
71.2%

요청기관
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
시흥도시공사
166 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row시흥도시공사
2nd row시흥도시공사
3rd row시흥도시공사
4th row시흥도시공사
5th row시흥도시공사

Common Values

ValueCountFrequency (%)
시흥도시공사 166
100.0%

Length

2024-04-22T09:26:52.398192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-22T09:26:52.488099image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
시흥도시공사 166
100.0%

계약기관
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
시흥도시공사
166 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row시흥도시공사
2nd row시흥도시공사
3rd row시흥도시공사
4th row시흥도시공사
5th row시흥도시공사

Common Values

ValueCountFrequency (%)
시흥도시공사 166
100.0%

Length

2024-04-22T09:26:52.581662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-22T09:26:52.675474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
시흥도시공사 166
100.0%

공종
Categorical

Distinct30
Distinct (%)18.1%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
시설물유지관리업
49 
전기공사업
19 
기계설비공사업
15 
기계가스설비공사업
실내건축공사업
Other values (25)
67 

Length

Max length15
Median length14
Mean length8.0542169
Min length4

Unique

Unique9 ?
Unique (%)5.4%

Sample

1st row전기공사업
2nd row전기공사업
3rd row전문소방시설공사업
4th row정보통신공사업
5th row전기공사업

Common Values

ValueCountFrequency (%)
시설물유지관리업 49
29.5%
전기공사업 19
 
11.4%
기계설비공사업 15
 
9.0%
기계가스설비공사업 9
 
5.4%
실내건축공사업 7
 
4.2%
지반조성ㆍ포장공사업 7
 
4.2%
전문소방시설공사업 6
 
3.6%
가스난방공사업 5
 
3.0%
정보통신공사업 5
 
3.0%
조경공사업 4
 
2.4%
Other values (20) 40
24.1%

Length

2024-04-22T09:26:52.774895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
시설물유지관리업 49
29.5%
전기공사업 19
 
11.4%
기계설비공사업 15
 
9.0%
기계가스설비공사업 9
 
5.4%
실내건축공사업 7
 
4.2%
지반조성ㆍ포장공사업 7
 
4.2%
전문소방시설공사업 6
 
3.6%
가스난방공사업 5
 
3.0%
정보통신공사업 5
 
3.0%
조경공사업 4
 
2.4%
Other values (20) 40
24.1%

신규장기구분
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
신규(단년도)
166 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row신규(단년도)
2nd row신규(단년도)
3rd row신규(단년도)
4th row신규(단년도)
5th row신규(단년도)

Common Values

ValueCountFrequency (%)
신규(단년도) 166
100.0%

Length

2024-04-22T09:26:52.885783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-22T09:26:52.975019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
신규(단년도 166
100.0%
Distinct91
Distinct (%)55.2%
Missing1
Missing (%)0.6%
Memory size1.4 KiB
2024-04-22T09:26:53.204536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length2.9939394
Min length2

Characters and Unicode

Total characters494
Distinct characters103
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

Unique64 ?
Unique (%)38.8%

Sample

1st row황성환
2nd row박미숙
3rd row이익규
4th row김영운
5th row황성환
ValueCountFrequency (%)
김상현 7
 
4.2%
오광섭 7
 
4.2%
정보현 7
 
4.2%
서무숙 6
 
3.6%
김이남 6
 
3.6%
김인도 5
 
3.0%
염환집 5
 
3.0%
송명진 5
 
3.0%
황성환 4
 
2.4%
김병철 4
 
2.4%
Other values (81) 109
66.1%
2024-04-22T09:26:53.581339image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
48
 
9.7%
28
 
5.7%
18
 
3.6%
18
 
3.6%
14
 
2.8%
14
 
2.8%
13
 
2.6%
12
 
2.4%
10
 
2.0%
10
 
2.0%
Other values (93) 309
62.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 494
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
48
 
9.7%
28
 
5.7%
18
 
3.6%
18
 
3.6%
14
 
2.8%
14
 
2.8%
13
 
2.6%
12
 
2.4%
10
 
2.0%
10
 
2.0%
Other values (93) 309
62.6%

Most occurring scripts

ValueCountFrequency (%)
Hangul 494
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
48
 
9.7%
28
 
5.7%
18
 
3.6%
18
 
3.6%
14
 
2.8%
14
 
2.8%
13
 
2.6%
12
 
2.4%
10
 
2.0%
10
 
2.0%
Other values (93) 309
62.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 494
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
48
 
9.7%
28
 
5.7%
18
 
3.6%
18
 
3.6%
14
 
2.8%
14
 
2.8%
13
 
2.6%
12
 
2.4%
10
 
2.0%
10
 
2.0%
Other values (93) 309
62.6%

계약방법
Categorical

IMBALANCE 

Distinct3
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
수의계약
154 
제한경쟁
 
11
지명경쟁
 
1

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique1 ?
Unique (%)0.6%

Sample

1st row수의계약
2nd row제한경쟁
3rd row제한경쟁
4th row제한경쟁
5th row수의계약

Common Values

ValueCountFrequency (%)
수의계약 154
92.8%
제한경쟁 11
 
6.6%
지명경쟁 1
 
0.6%

Length

2024-04-22T09:26:53.716067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-22T09:26:53.821340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
수의계약 154
92.8%
제한경쟁 11
 
6.6%
지명경쟁 1
 
0.6%
Distinct134
Distinct (%)80.7%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2021-02-01 00:00:00
Maximum2023-11-23 00:00:00
2024-04-22T09:26:53.941898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-22T09:26:54.071965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

계약금액
Real number (ℝ)

Distinct151
Distinct (%)91.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean76253647
Minimum5150000
Maximum6.1547281 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2024-04-22T09:26:54.198943image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum5150000
5-th percentile5792500
Q17812357.5
median12255000
Q319453500
95-th percentile1 × 108
Maximum6.1547281 × 109
Range6.1495781 × 109
Interquartile range (IQR)11641142

Descriptive statistics

Standard deviation4.9027241 × 108
Coefficient of variation (CV)6.4294946
Kurtosis145.56867
Mean76253647
Median Absolute Deviation (MAD)5542690
Skewness11.764869
Sum1.2658105 × 1010
Variance2.4036703 × 1017
MonotonicityNot monotonic
2024-04-22T09:26:54.333080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
5500000 3
 
1.8%
100000000 3
 
1.8%
19800000 3
 
1.8%
9900000 3
 
1.8%
9880000 2
 
1.2%
7700000 2
 
1.2%
12210000 2
 
1.2%
6776000 2
 
1.2%
20000000 2
 
1.2%
18000000 2
 
1.2%
Other values (141) 142
85.5%
ValueCountFrequency (%)
5150000 1
 
0.6%
5500000 3
1.8%
5610000 1
 
0.6%
5676900 1
 
0.6%
5720000 1
 
0.6%
5775000 1
 
0.6%
5790000 1
 
0.6%
5800000 1
 
0.6%
5808260 1
 
0.6%
5888300 1
 
0.6%
ValueCountFrequency (%)
6154728100 1
 
0.6%
1000000000 1
 
0.6%
727668090 1
 
0.6%
614003040 1
 
0.6%
597391850 1
 
0.6%
481334810 1
 
0.6%
387100000 1
 
0.6%
124129000 1
 
0.6%
100000000 3
1.8%
85806280 1
 
0.6%

예정가격
Real number (ℝ)

ZEROS 

Distinct14
Distinct (%)8.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.2654993 × 108
Minimum0
Maximum8.19 × 109
Zeros153
Zeros (%)92.2%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2024-04-22T09:26:54.445330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile4.8704561 × 108
Maximum8.19 × 109
Range8.19 × 109
Interquartile range (IQR)0

Descriptive statistics

Standard deviation8.4740223 × 108
Coefficient of variation (CV)6.6961889
Kurtosis77.019794
Mean1.2654993 × 108
Median Absolute Deviation (MAD)0
Skewness8.6920541
Sum2.1007288 × 1010
Variance7.1809054 × 1017
MonotonicityNot monotonic
2024-04-22T09:26:54.770848image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
0 153
92.2%
932000000 1
 
0.6%
808000000 1
 
0.6%
510000000 1
 
0.6%
8190000000 1
 
0.6%
7082442800 1
 
0.6%
693134800 1
 
0.6%
822936675 1
 
0.6%
141464350 1
 
0.6%
543051700 1
 
0.6%
Other values (4) 4
 
2.4%
ValueCountFrequency (%)
0 153
92.2%
90676600 1
 
0.6%
97503600 1
 
0.6%
141464350 1
 
0.6%
418182425 1
 
0.6%
510000000 1
 
0.6%
543051700 1
 
0.6%
677895275 1
 
0.6%
693134800 1
 
0.6%
808000000 1
 
0.6%
ValueCountFrequency (%)
8190000000 1
0.6%
7082442800 1
0.6%
932000000 1
0.6%
822936675 1
0.6%
808000000 1
0.6%
693134800 1
0.6%
677895275 1
0.6%
543051700 1
0.6%
510000000 1
0.6%
418182425 1
0.6%
Distinct90
Distinct (%)54.2%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2024-04-22T09:26:55.017097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length13
Mean length8.0120482
Min length2

Characters and Unicode

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

Unique

Unique62 ?
Unique (%)37.3%

Sample

1st row주식회사우성전력
2nd row주식회사 미성
3rd row(주)지에스방재
4th row주식회사 맥스텍
5th row주식회사우성전력
ValueCountFrequency (%)
주식회사 74
29.5%
넥스프릴 7
 
2.8%
명성종합설비 7
 
2.8%
부천기업 7
 
2.8%
협동조합 6
 
2.4%
위드 6
 
2.4%
만물건설 6
 
2.4%
지이큐솔루션주식회사 6
 
2.4%
항길건설 5
 
2.0%
영규전력공사 5
 
2.0%
Other values (86) 122
48.6%
2024-04-22T09:26:55.409494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
121
 
9.1%
93
 
7.0%
85
 
6.4%
85
 
6.4%
85
 
6.4%
32
 
2.4%
( 31
 
2.3%
) 31
 
2.3%
30
 
2.3%
23
 
1.7%
Other values (157) 714
53.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1174
88.3%
Space Separator 85
 
6.4%
Open Punctuation 31
 
2.3%
Close Punctuation 31
 
2.3%
Uppercase Letter 8
 
0.6%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
121
 
10.3%
93
 
7.9%
85
 
7.2%
85
 
7.2%
32
 
2.7%
30
 
2.6%
23
 
2.0%
22
 
1.9%
22
 
1.9%
21
 
1.8%
Other values (149) 640
54.5%
Uppercase Letter
ValueCountFrequency (%)
E 3
37.5%
N 2
25.0%
G 2
25.0%
C 1
 
12.5%
Space Separator
ValueCountFrequency (%)
85
100.0%
Open Punctuation
ValueCountFrequency (%)
( 31
100.0%
Close Punctuation
ValueCountFrequency (%)
) 31
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1174
88.3%
Common 148
 
11.1%
Latin 8
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
121
 
10.3%
93
 
7.9%
85
 
7.2%
85
 
7.2%
32
 
2.7%
30
 
2.6%
23
 
2.0%
22
 
1.9%
22
 
1.9%
21
 
1.8%
Other values (149) 640
54.5%
Common
ValueCountFrequency (%)
85
57.4%
( 31
 
20.9%
) 31
 
20.9%
& 1
 
0.7%
Latin
ValueCountFrequency (%)
E 3
37.5%
N 2
25.0%
G 2
25.0%
C 1
 
12.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1174
88.3%
ASCII 156
 
11.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
121
 
10.3%
93
 
7.9%
85
 
7.2%
85
 
7.2%
32
 
2.7%
30
 
2.6%
23
 
2.0%
22
 
1.9%
22
 
1.9%
21
 
1.8%
Other values (149) 640
54.5%
ASCII
ValueCountFrequency (%)
85
54.5%
( 31
 
19.9%
) 31
 
19.9%
E 3
 
1.9%
N 2
 
1.3%
G 2
 
1.3%
C 1
 
0.6%
& 1
 
0.6%
Distinct97
Distinct (%)58.4%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2024-04-22T09:26:55.661551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length55
Median length48.5
Mean length38.680723
Min length26

Characters and Unicode

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

Unique

Unique68 ?
Unique (%)41.0%

Sample

1st row(14951) 경기도 시흥시 신천로 13-1 ()
2nd row(12930) 경기도 하남시 조정대로 150(덕풍동) 318호
3rd row(12930) 경기도 하남시 조정대로 150, 하남아이테코 567호 (덕풍동)
4th row(18469) 경기도 화성시 동탄기흥로 602 (영천동)더 퍼스트타워3차 1407호
5th row(14951) 경기도 시흥시 신천로 13-1 ()
ValueCountFrequency (%)
경기도 160
 
13.9%
시흥시 104
 
9.1%
신천동 22
 
1.9%
정왕동 20
 
1.7%
안산시 16
 
1.4%
단원구 14
 
1.2%
11-0 11
 
1.0%
대야동 11
 
1.0%
하중동 10
 
0.9%
김포시 9
 
0.8%
Other values (405) 772
67.2%
2024-04-22T09:26:56.054476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
983
 
15.3%
1 453
 
7.1%
) 315
 
4.9%
( 315
 
4.9%
285
 
4.4%
0 262
 
4.1%
4 207
 
3.2%
182
 
2.8%
175
 
2.7%
166
 
2.6%
Other values (222) 3078
47.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2770
43.1%
Decimal Number 1823
28.4%
Space Separator 983
 
15.3%
Close Punctuation 315
 
4.9%
Open Punctuation 315
 
4.9%
Dash Punctuation 132
 
2.1%
Other Punctuation 66
 
1.0%
Uppercase Letter 16
 
0.2%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
285
 
10.3%
182
 
6.6%
175
 
6.3%
166
 
6.0%
163
 
5.9%
149
 
5.4%
112
 
4.0%
81
 
2.9%
72
 
2.6%
55
 
2.0%
Other values (193) 1330
48.0%
Uppercase Letter
ValueCountFrequency (%)
B 4
25.0%
A 2
12.5%
L 1
 
6.2%
G 1
 
6.2%
E 1
 
6.2%
J 1
 
6.2%
K 1
 
6.2%
N 1
 
6.2%
Y 1
 
6.2%
T 1
 
6.2%
Other values (2) 2
12.5%
Decimal Number
ValueCountFrequency (%)
1 453
24.8%
0 262
14.4%
4 207
11.4%
2 165
 
9.1%
9 162
 
8.9%
5 142
 
7.8%
3 129
 
7.1%
7 119
 
6.5%
8 101
 
5.5%
6 83
 
4.6%
Other Punctuation
ValueCountFrequency (%)
, 65
98.5%
. 1
 
1.5%
Space Separator
ValueCountFrequency (%)
983
100.0%
Close Punctuation
ValueCountFrequency (%)
) 315
100.0%
Open Punctuation
ValueCountFrequency (%)
( 315
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 132
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 3635
56.6%
Hangul 2770
43.1%
Latin 16
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
285
 
10.3%
182
 
6.6%
175
 
6.3%
166
 
6.0%
163
 
5.9%
149
 
5.4%
112
 
4.0%
81
 
2.9%
72
 
2.6%
55
 
2.0%
Other values (193) 1330
48.0%
Common
ValueCountFrequency (%)
983
27.0%
1 453
12.5%
) 315
 
8.7%
( 315
 
8.7%
0 262
 
7.2%
4 207
 
5.7%
2 165
 
4.5%
9 162
 
4.5%
5 142
 
3.9%
- 132
 
3.6%
Other values (7) 499
13.7%
Latin
ValueCountFrequency (%)
B 4
25.0%
A 2
12.5%
L 1
 
6.2%
G 1
 
6.2%
E 1
 
6.2%
J 1
 
6.2%
K 1
 
6.2%
N 1
 
6.2%
Y 1
 
6.2%
T 1
 
6.2%
Other values (2) 2
12.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3651
56.9%
Hangul 2770
43.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
983
26.9%
1 453
12.4%
) 315
 
8.6%
( 315
 
8.6%
0 262
 
7.2%
4 207
 
5.7%
2 165
 
4.5%
9 162
 
4.4%
5 142
 
3.9%
- 132
 
3.6%
Other values (19) 515
14.1%
Hangul
ValueCountFrequency (%)
285
 
10.3%
182
 
6.6%
175
 
6.3%
166
 
6.0%
163
 
5.9%
149
 
5.4%
112
 
4.0%
81
 
2.9%
72
 
2.6%
55
 
2.0%
Other values (193) 1330
48.0%
Distinct132
Distinct (%)79.5%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2021-02-04 00:00:00
Maximum2023-11-29 00:00:00
2024-04-22T09:26:56.191216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-22T09:26:56.322095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct135
Distinct (%)81.3%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2021-02-23 00:00:00
Maximum2023-12-31 00:00:00
2024-04-22T09:26:56.441465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-22T09:26:56.568539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

낙찰률
Real number (ℝ)

ZEROS 

Distinct14
Distinct (%)8.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.8968133
Minimum0
Maximum88.635
Zeros153
Zeros (%)92.2%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2024-04-22T09:26:56.670588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile87.941
Maximum88.635
Range88.635
Interquartile range (IQR)0

Descriptive statistics

Standard deviation23.732627
Coefficient of variation (CV)3.4411004
Kurtosis8.1356268
Mean6.8968133
Median Absolute Deviation (MAD)0
Skewness3.1681268
Sum1144.871
Variance563.23758
MonotonicityNot monotonic
2024-04-22T09:26:56.770370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
0.0 153
92.2%
88.576 1
 
0.6%
88.476 1
 
0.6%
88.554 1
 
0.6%
86.735 1
 
0.6%
86.901 1
 
0.6%
88.583 1
 
0.6%
88.423 1
 
0.6%
87.745 1
 
0.6%
88.635 1
 
0.6%
Other values (4) 4
 
2.4%
ValueCountFrequency (%)
0.0 153
92.2%
86.735 1
 
0.6%
86.901 1
 
0.6%
87.745 1
 
0.6%
87.755 1
 
0.6%
88.003 1
 
0.6%
88.124 1
 
0.6%
88.361 1
 
0.6%
88.423 1
 
0.6%
88.476 1
 
0.6%
ValueCountFrequency (%)
88.635 1
0.6%
88.583 1
0.6%
88.576 1
0.6%
88.554 1
0.6%
88.476 1
0.6%
88.423 1
0.6%
88.361 1
0.6%
88.124 1
0.6%
88.003 1
0.6%
87.755 1
0.6%

낙찰금액
Real number (ℝ)

ZEROS 

Distinct14
Distinct (%)8.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.1040451 × 108
Minimum0
Maximum7.1 × 109
Zeros153
Zeros (%)92.2%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2024-04-22T09:26:56.870581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile4.3137828 × 108
Maximum7.1 × 109
Range7.1 × 109
Interquartile range (IQR)0

Descriptive statistics

Standard deviation7.3577742 × 108
Coefficient of variation (CV)6.6643784
Kurtosis76.76676
Mean1.1040451 × 108
Median Absolute Deviation (MAD)0
Skewness8.6746601
Sum1.8327148 × 1010
Variance5.413684 × 1017
MonotonicityNot monotonic
2024-04-22T09:26:56.981448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
0 153
92.2%
826000000 1
 
0.6%
715000000 1
 
0.6%
452000000 1
 
0.6%
7100000000 1
 
0.6%
6154728100 1
 
0.6%
614003044 1
 
0.6%
727668094 1
 
0.6%
124129000 1
 
0.6%
481334810 1
 
0.6%
Other values (4) 4
 
2.4%
ValueCountFrequency (%)
0 153
92.2%
79573900 1
 
0.6%
85806280 1
 
0.6%
124129000 1
 
0.6%
369513140 1
 
0.6%
452000000 1
 
0.6%
481334810 1
 
0.6%
597391859 1
 
0.6%
614003044 1
 
0.6%
715000000 1
 
0.6%
ValueCountFrequency (%)
7100000000 1
0.6%
6154728100 1
0.6%
826000000 1
0.6%
727668094 1
0.6%
715000000 1
0.6%
614003044 1
0.6%
597391859 1
0.6%
481334810 1
0.6%
452000000 1
0.6%
369513140 1
0.6%
Distinct134
Distinct (%)80.7%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2021-01-25 00:00:00
Maximum2023-11-23 00:00:00
2024-04-22T09:26:57.110161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-22T09:26:57.235106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct134
Distinct (%)80.7%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2021-02-23 00:00:00
Maximum2023-12-31 00:00:00
2024-04-22T09:26:57.364138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-22T09:26:57.492668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

공사현장
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
경기도 시흥시
166 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도 시흥시
2nd row경기도 시흥시
3rd row경기도 시흥시
4th row경기도 시흥시
5th row경기도 시흥시

Common Values

ValueCountFrequency (%)
경기도 시흥시 166
100.0%

Length

2024-04-22T09:26:57.601330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-22T09:26:57.690157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 166
50.0%
시흥시 166
50.0%

Sample

번호계약번호공사명요청기관계약기관공종신규장기구분대표자명계약방법계약일자계약금액예정가격낙찰업체명대표업체주소착공일자준공일자낙찰률낙찰금액입찰일자실제준공일자공사현장
0120210111A042021년 캠핑사이트 전기 및 소화기함 교체공사시흥도시공사시흥도시공사전기공사업신규(단년도)황성환수의계약2021-02-01199990000주식회사우성전력(14951) 경기도 시흥시 신천로 13-1 ()2021-02-042021-02-230.002021-02-012021-02-23경기도 시흥시
1220210206F96은계어울림센터-1 건립 전기공사시흥도시공사시흥도시공사전기공사업신규(단년도)박미숙제한경쟁2021-02-16100000000932000000주식회사 미성(12930) 경기도 하남시 조정대로 150(덕풍동) 318호2021-03-152021-12-3188.5768260000002021-01-252021-12-31경기도 시흥시
2320210206FD3은계어울림센터-1 건립 소방공사시흥도시공사시흥도시공사전문소방시설공사업신규(단년도)이익규제한경쟁2021-02-16100000000808000000(주)지에스방재(12930) 경기도 하남시 조정대로 150, 하남아이테코 567호 (덕풍동)2021-03-152021-12-3188.4767150000002021-01-252021-12-31경기도 시흥시
3420210206FBE은계어울림센터-1 건립 정보통신공사시흥도시공사시흥도시공사정보통신공사업신규(단년도)김영운제한경쟁2021-02-16100000000510000000주식회사 맥스텍(18469) 경기도 화성시 동탄기흥로 602 (영천동)더 퍼스트타워3차 1407호2021-03-152021-12-3188.5544520000002021-01-252021-12-31경기도 시흥시
452021020CD45방산동 공영차고지 전력계량기 분리 공사시흥도시공사시흥도시공사전기공사업신규(단년도)황성환수의계약2021-02-1655000000주식회사우성전력(14951) 경기도 시흥시 신천로 13-1 ()2021-03-062021-03-090.002021-02-162021-03-04경기도 시흥시
5620210215EEE방산차고지 주차관제센터 조성 공사시흥도시공사시흥도시공사실내건축공사업신규(단년도)조효금수의계약2021-02-2396870000(주)미래기업(14998) 경기도 시흥시 새재로7번길 18, 1층 102호(장현동)2021-02-242021-03-090.002021-02-232021-03-09경기도 시흥시
6720210216F8B교통사업팀 전산장비 이전 및 상황실, 전산실 구축공사시흥도시공사시흥도시공사정보통신공사업신규(단년도)장혜진수의계약2021-02-25495000000주식회사 앤샾(06043) 서울특별시 강남구 강남대로146길 8-0 (논현동) 4층~7층2021-03-022021-03-210.002021-02-252021-03-21경기도 시흥시
7820210215678은계어울림센터-1 건축공사(건축, 토목, 조경, 기계)시흥도시공사시흥도시공사건축공사업신규(단년도)김장욱제한경쟁2021-02-2410000000008190000000신동아종합건설 주식회사(15521) 경기도 안산시 상록구 건건로 119-9 (건건동)2층207호2021-03-152021-12-3186.73571000000002021-02-012021-12-22경기도 시흥시
8920200000000시흥그린센터 불꽃감지기 소방개선공사시흥도시공사시흥도시공사전문소방시설공사업신규(단년도)박창호수의계약2021-03-24176000000진명이엔씨(주)(04317) 서울특별시 용산구 효창원로66길 2, 세림빌딩 3층 (효창동)2021-03-292021-04-170.002021-03-242021-04-17경기도 시흥시
91020210312B35환경미화타운 석면해체 및 천장 인테리어 공사시흥도시공사시흥도시공사비계.구조물해체공사업신규(단년도)양해명수의계약2021-03-24200000000주식회사 가가종합철거환경(15398) 경기도 안산시 단원구 신길중앙로1길 54-0 (신길동 102호)2021-03-262021-04-240.002021-03-242021-04-24경기도 시흥시
번호계약번호공사명요청기관계약기관공종신규장기구분대표자명계약방법계약일자계약금액예정가격낙찰업체명대표업체주소착공일자준공일자낙찰률낙찰금액입찰일자실제준공일자공사현장
1561572023090E832소래초 일반통행변경 공사시흥도시공사시흥도시공사지반조성ㆍ포장공사업신규(단년도)서경선수의계약2023-09-21549000000주식회사 태왕산업개발(14975) 경기도 시흥시 하중로136번길 12, 101호 (하중동)2023-10-042023-10-200.002023-09-212023-10-20경기도 시흥시
1571582023090E2F4(소래초)전기 추가공사시흥도시공사시흥도시공사전기공사업신규(단년도)박춘일수의계약2023-09-2176200000주식회사 우일전력(14976) 경기도 시흥시 하중로 233, 402호(하중동)2023-09-212023-10-130.002023-09-212023-10-13경기도 시흥시
158159202310017비산재 고형화 혼합기 핀 로드 및 샤프트 교체 공사시흥도시공사시흥도시공사시설물유지관리업신규(단년도)김병철수의계약2023-10-06194700000주로테크 주식회사(15613) 경기도 안산시 단원구 산성로 7 (초지동)2023-11-012023-11-110.002023-10-062023-11-06경기도 시흥시
15916020231002959배곧한울공원 어린이놀이터 배수시설 개선공사시흥도시공사시흥도시공사시설물유지관리업신규(단년도)김인도수의계약2023-10-10194040000항길건설 주식회사(14957) 경기도 시흥시 신현로12번길 30-0 (포동, 서강아파트) 상가동 202호2023-10-132023-11-060.002023-10-102023-11-06경기도 시흥시
16016120231016366소각로 배출 슈트 내화벽돌 교체 공사시흥도시공사시흥도시공사시설물유지관리업신규(단년도)정운필수의계약2023-10-31118800000주식회사 건일(14059) 경기도 안양시 동안구 흥안대로427번길 38, 성지스타위드 1307 (관양동)2023-11-062023-11-200.002023-10-312023-11-20경기도 시흥시
161162202311021ACABC행복학습타운 으뜸관 측면 오수관 교체공사시흥도시공사시흥도시공사시설물유지관리업신규(단년도)우희갑수의계약2023-11-0672600000다올건설(14946) 경기도 시흥시 수인로3413번길 50-0 (신천동)2023-11-132023-11-300.002023-11-062023-11-30경기도 시흥시
1621632023110695F갯골생태공원 오수처리시설 분리막 설비 교체 공사시흥도시공사시흥도시공사시설물유지관리업신규(단년도)정보민수의계약2023-11-08218610000주식회사 푸름엔지니어링(14912) 경기도 시흥시 비둘기공원6길 25, 4층 401호(대야동, 견우프라자)2023-11-152023-11-300.002023-11-082023-11-30경기도 시흥시
16316420231113615시흥그린센터 굴뚝 최상부 보수 공사시흥도시공사시흥도시공사시설물유지관리업신규(단년도)이선화수의계약2023-11-22195805300(주)에벤에셀(15103) 경기도 시흥시 공단1대로 244-0 (정왕동) 9-327호2023-11-242023-12-080.002023-11-222023-12-08경기도 시흥시
16416520231111CB5그린환경부 폐기물 크레인 버켓 와이어, 파워 케이블 교체 공사시흥도시공사시흥도시공사시설물유지관리업신규(단년도)정보현수의계약2023-11-22140800000부천기업 주식회사(10003) 경기도 김포시 월곶면 애기봉로 250-02023-11-222023-11-280.002023-11-222023-11-28경기도 시흥시
16516620231113985그린환경부 5.5층 구간 연돌 보온 공사시흥도시공사시흥도시공사시설물유지관리업신규(단년도)오광섭수의계약2023-11-23188000000넥스프릴 주식회사(15014) 경기도 시흥시 오이도로 21-0 (정왕동) 스틸랜드에스비센터 302호2023-11-292023-12-080.002023-11-232023-12-08경기도 시흥시