Overview

Dataset statistics

Number of variables6
Number of observations421
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory20.3 KiB
Average record size in memory49.3 B

Variable types

Categorical2
Text2
DateTime1
Numeric1

Dataset

Description충청북도 진천군 공사계약현황은 진천군에서 시행한 공사계약현황을 보여주는 것으로 관서명, 계약방법, 계약명, 계약금액, 계약일, 계약상대자를 보여줌.
Author충청북도 진천군
URLhttps://www.data.go.kr/data/15064042/fileData.do

Alerts

계약관서 has constant value ""Constant

Reproduction

Analysis started2024-03-14 16:44:48.612496
Analysis finished2024-03-14 16:44:50.059121
Duration1.45 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

계약관서
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.4 KiB
본청
421 

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 (%)
본청 421
100.0%

Length

2024-03-15T01:44:50.361399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T01:44:50.636806image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
본청 421
100.0%

계약방법
Categorical

Distinct4
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size3.4 KiB
수의1인견적
275 
수의2인이상견적
112 
제한경쟁
 
26
일반경쟁
 
8

Length

Max length8
Median length6
Mean length6.3705463
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
수의1인견적 275
65.3%
수의2인이상견적 112
26.6%
제한경쟁 26
 
6.2%
일반경쟁 8
 
1.9%

Length

2024-03-15T01:44:50.925814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T01:44:51.288010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
수의1인견적 275
65.3%
수의2인이상견적 112
26.6%
제한경쟁 26
 
6.2%
일반경쟁 8
 
1.9%

계약명
Text

Distinct419
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Memory size3.4 KiB
2024-03-15T01:44:52.452992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length64
Median length41
Mean length27.413302
Min length8

Characters and Unicode

Total characters11541
Distinct characters421
Distinct categories9 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique417 ?
Unique (%)99.0%

Sample

1st row『어린이(가족) 특화공간 조성사업(통신분야)』 집행
2nd row군청사 내 사무실 전기 공사(회계과)
3rd row진천군 음식물류폐기물 처리시설(40톤/일) 약품탱크 보온공사 집행(식산업자원과)
4th row군청사 냉난방기 중앙제어장치 이전설치 공사(회계과)
5th row『어린이(가족) 특화공간 조성사업(건축분야)』 집행
ValueCountFrequency (%)
2023년 91
 
4.7%
집행 82
 
4.2%
및 41
 
2.1%
공사 36
 
1.8%
집행(산림녹지과 23
 
1.2%
군청사 22
 
1.1%
집행(문화관광과 20
 
1.0%
집행(건설교통과 19
 
1.0%
조성사업 18
 
0.9%
설치 15
 
0.8%
Other values (906) 1586
81.2%
2024-03-15T01:44:54.116194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1555
 
13.5%
사 492
 
4.3%
공 409
 
3.5%
) 371
 
3.2%
( 371
 
3.2%
행 263
 
2.3%
집 261
 
2.3%
과 259
 
2.2%
2 240
 
2.1%
설 210
 
1.8%
Other values (411) 7110
61.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 8451
73.2%
Space Separator 1555
 
13.5%
Decimal Number 567
 
4.9%
Close Punctuation 438
 
3.8%
Open Punctuation 438
 
3.8%
Other Punctuation 42
 
0.4%
Uppercase Letter 26
 
0.2%
Dash Punctuation 14
 
0.1%
Math Symbol 10
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 492
 
5.8%
공 409
 
4.8%
행 263
 
3.1%
집 261
 
3.1%
과 259
 
3.1%
설 210
 
2.5%
지 198
 
2.3%
천 156
 
1.8%
수 147
 
1.7%
도 142
 
1.7%
Other values (376) 5914
70.0%
Decimal Number
ValueCountFrequency (%)
2 240
42.3%
3 122
21.5%
0 119
21.0%
1 40
 
7.1%
4 12
 
2.1%
6 8
 
1.4%
5 7
 
1.2%
7 7
 
1.2%
8 6
 
1.1%
9 6
 
1.1%
Uppercase Letter
ValueCountFrequency (%)
C 7
26.9%
V 4
15.4%
D 3
11.5%
T 3
11.5%
B 2
 
7.7%
L 2
 
7.7%
E 2
 
7.7%
F 1
 
3.8%
R 1
 
3.8%
I 1
 
3.8%
Close Punctuation
ValueCountFrequency (%)
) 371
84.7%
」 54
 
12.3%
』 10
 
2.3%
] 3
 
0.7%
Open Punctuation
ValueCountFrequency (%)
( 371
84.7%
「 54
 
12.3%
『 10
 
2.3%
[ 3
 
0.7%
Other Punctuation
ValueCountFrequency (%)
, 36
85.7%
· 4
 
9.5%
@ 1
 
2.4%
/ 1
 
2.4%
Space Separator
ValueCountFrequency (%)
1555
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 14
100.0%
Math Symbol
ValueCountFrequency (%)
~ 10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 8449
73.2%
Common 3064
 
26.5%
Latin 26
 
0.2%
Han 2
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 492
 
5.8%
공 409
 
4.8%
행 263
 
3.1%
집 261
 
3.1%
과 259
 
3.1%
설 210
 
2.5%
지 198
 
2.3%
천 156
 
1.8%
수 147
 
1.7%
도 142
 
1.7%
Other values (375) 5912
70.0%
Common
ValueCountFrequency (%)
1555
50.8%
) 371
 
12.1%
( 371
 
12.1%
2 240
 
7.8%
3 122
 
4.0%
0 119
 
3.9%
「 54
 
1.8%
」 54
 
1.8%
1 40
 
1.3%
, 36
 
1.2%
Other values (15) 102
 
3.3%
Latin
ValueCountFrequency (%)
C 7
26.9%
V 4
15.4%
D 3
11.5%
T 3
11.5%
B 2
 
7.7%
L 2
 
7.7%
E 2
 
7.7%
F 1
 
3.8%
R 1
 
3.8%
I 1
 
3.8%
Han
ValueCountFrequency (%)
無 2
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 8449
73.2%
ASCII 2958
 
25.6%
None 132
 
1.1%
CJK 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1555
52.6%
) 371
 
12.5%
( 371
 
12.5%
2 240
 
8.1%
3 122
 
4.1%
0 119
 
4.0%
1 40
 
1.4%
, 36
 
1.2%
- 14
 
0.5%
4 12
 
0.4%
Other values (20) 78
 
2.6%
Hangul
ValueCountFrequency (%)
사 492
 
5.8%
공 409
 
4.8%
행 263
 
3.1%
집 261
 
3.1%
과 259
 
3.1%
설 210
 
2.5%
지 198
 
2.3%
천 156
 
1.8%
수 147
 
1.7%
도 142
 
1.7%
Other values (375) 5912
70.0%
None
ValueCountFrequency (%)
「 54
40.9%
」 54
40.9%
『 10
 
7.6%
』 10
 
7.6%
· 4
 
3.0%
CJK
ValueCountFrequency (%)
無 2
100.0%

계약일자
Date

Distinct176
Distinct (%)41.8%
Missing0
Missing (%)0.0%
Memory size3.4 KiB
Minimum2023-01-02 00:00:00
Maximum2023-12-22 00:00:00
2024-03-15T01:44:54.510885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T01:44:54.947717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

계약금액
Real number (ℝ)

Distinct357
Distinct (%)84.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.1162248 × 108
Minimum2120000
Maximum1.4640588 × 1010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.8 KiB
2024-03-15T01:44:55.361356image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2120000
5-th percentile4200000
Q19080000
median18080000
Q349092930
95-th percentile3.2816 × 108
Maximum1.4640588 × 1010
Range1.4638468 × 1010
Interquartile range (IQR)40012930

Descriptive statistics

Standard deviation7.5100354 × 108
Coefficient of variation (CV)6.7280669
Kurtosis336.71801
Mean1.1162248 × 108
Median Absolute Deviation (MAD)11320000
Skewness17.646751
Sum4.6993066 × 1010
Variance5.6400632 × 1017
MonotonicityNot monotonic
2024-03-15T01:44:55.813100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4700000 6
 
1.4%
5000000 5
 
1.2%
20200000 5
 
1.2%
19500000 4
 
1.0%
6900000 4
 
1.0%
4800000 4
 
1.0%
9500000 3
 
0.7%
16560000 3
 
0.7%
11300000 3
 
0.7%
3100000 3
 
0.7%
Other values (347) 381
90.5%
ValueCountFrequency (%)
2120000 1
 
0.2%
2180000 1
 
0.2%
2242900 1
 
0.2%
2380000 1
 
0.2%
2540000 1
 
0.2%
2600000 1
 
0.2%
3000000 1
 
0.2%
3100000 3
0.7%
3170000 1
 
0.2%
3300000 1
 
0.2%
ValueCountFrequency (%)
14640587680 1
0.2%
3752483300 1
0.2%
1700142500 1
0.2%
1200000000 1
0.2%
1197442230 1
0.2%
1094390000 1
0.2%
1000000000 1
0.2%
806894000 1
0.2%
763145530 1
0.2%
636207000 1
0.2%

계약상대자
Text

Distinct189
Distinct (%)44.9%
Missing0
Missing (%)0.0%
Memory size3.4 KiB
2024-03-15T01:44:56.846318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length13
Mean length7.52019
Min length3

Characters and Unicode

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

Unique

Unique109 ?
Unique (%)25.9%

Sample

1st row주식회사 오성이엔에스
2nd row세대전력주식회사
3rd row(주)한성환경기연
4th row가람이엔지
5th row오성건설주식회사
ValueCountFrequency (%)
주식회사 66
 
13.5%
아남전기공사 14
 
2.9%
주)주덕조경건설 11
 
2.2%
백두산건설 10
 
2.0%
주)상산종합조경 9
 
1.8%
거림창호금속건설(주 9
 
1.8%
주)산이 8
 
1.6%
주)인하우스 8
 
1.6%
동방건설(주 7
 
1.4%
주)우진건설 7
 
1.4%
Other values (182) 340
69.5%
2024-03-15T01:44:58.206091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 359
 
11.3%
( 273
 
8.6%
) 273
 
8.6%
건 177
 
5.6%
설 168
 
5.3%
사 99
 
3.1%
식 78
 
2.5%
회 78
 
2.5%
68
 
2.1%
산 64
 
2.0%
Other values (181) 1529
48.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2534
80.0%
Open Punctuation 273
 
8.6%
Close Punctuation 273
 
8.6%
Space Separator 68
 
2.1%
Uppercase Letter 11
 
0.3%
Decimal Number 5
 
0.2%
Other Punctuation 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 359
 
14.2%
건 177
 
7.0%
설 168
 
6.6%
사 99
 
3.9%
식 78
 
3.1%
회 78
 
3.1%
산 64
 
2.5%
전 54
 
2.1%
이 52
 
2.1%
기 50
 
2.0%
Other values (167) 1355
53.5%
Uppercase Letter
ValueCountFrequency (%)
S 3
27.3%
M 2
18.2%
C 2
18.2%
G 1
 
9.1%
N 1
 
9.1%
E 1
 
9.1%
K 1
 
9.1%
Decimal Number
ValueCountFrequency (%)
1 3
60.0%
9 1
 
20.0%
2 1
 
20.0%
Open Punctuation
ValueCountFrequency (%)
( 273
100.0%
Close Punctuation
ValueCountFrequency (%)
) 273
100.0%
Space Separator
ValueCountFrequency (%)
68
100.0%
Other Punctuation
ValueCountFrequency (%)
. 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2534
80.0%
Common 621
 
19.6%
Latin 11
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 359
 
14.2%
건 177
 
7.0%
설 168
 
6.6%
사 99
 
3.9%
식 78
 
3.1%
회 78
 
3.1%
산 64
 
2.5%
전 54
 
2.1%
이 52
 
2.1%
기 50
 
2.0%
Other values (167) 1355
53.5%
Common
ValueCountFrequency (%)
( 273
44.0%
) 273
44.0%
68
 
11.0%
1 3
 
0.5%
. 2
 
0.3%
9 1
 
0.2%
2 1
 
0.2%
Latin
ValueCountFrequency (%)
S 3
27.3%
M 2
18.2%
C 2
18.2%
G 1
 
9.1%
N 1
 
9.1%
E 1
 
9.1%
K 1
 
9.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2534
80.0%
ASCII 632
 
20.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 359
 
14.2%
건 177
 
7.0%
설 168
 
6.6%
사 99
 
3.9%
식 78
 
3.1%
회 78
 
3.1%
산 64
 
2.5%
전 54
 
2.1%
이 52
 
2.1%
기 50
 
2.0%
Other values (167) 1355
53.5%
ASCII
ValueCountFrequency (%)
( 273
43.2%
) 273
43.2%
68
 
10.8%
1 3
 
0.5%
S 3
 
0.5%
. 2
 
0.3%
M 2
 
0.3%
C 2
 
0.3%
G 1
 
0.2%
N 1
 
0.2%
Other values (4) 4
 
0.6%

Interactions

2024-03-15T01:44:49.194131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T01:44:58.381056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
계약방법계약금액
계약방법1.0000.638
계약금액0.6381.000
2024-03-15T01:44:58.591869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
계약금액계약방법
계약금액1.0000.296
계약방법0.2961.000

Missing values

2024-03-15T01:44:49.563723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T01:44:49.923260image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

계약관서계약방법계약명계약일자계약금액계약상대자
0본청수의2인이상견적『어린이(가족) 특화공간 조성사업(통신분야)』 집행2023-01-02104966300주식회사 오성이엔에스
1본청수의1인견적군청사 내 사무실 전기 공사(회계과)2023-01-042540000세대전력주식회사
2본청수의1인견적진천군 음식물류폐기물 처리시설(40톤/일) 약품탱크 보온공사 집행(식산업자원과)2023-01-0414570000(주)한성환경기연
3본청수의1인견적군청사 냉난방기 중앙제어장치 이전설치 공사(회계과)2023-01-064220000가람이엔지
4본청제한경쟁『어린이(가족) 특화공간 조성사업(건축분야)』 집행2023-01-113752483300오성건설주식회사
5본청제한경쟁「진천 문화예술회관 건립공사(통신)(장기계속, 전체분 및 1차분)」집행2023-01-17366145030(주)아이티이엔지
6본청제한경쟁「복합커뮤니티센터 및 도시재생어울림센터 건립사업(소방)(장기계속, 전체분 및 1차분)」집행2023-01-17300000000주식회사 가온전력
7본청제한경쟁「복합커뮤니티센터 및 도시재생어울림센터 건립사업(통신)(장기계속, 전체분 및 1차분)」집행2023-01-17394450360(주)예원정보통신
8본청일반경쟁「진천 문화예술회관 건립공사(전기)(장기계속, 전체분 및 1차분)」집행2023-01-191197442230(주)태원전력공사
9본청일반경쟁「진천 문화예술회관 건립공사(소방)(장기계속, 전체분 및 1차분)」 집행2023-01-191700142500(합)한승전력
계약관서계약방법계약명계약일자계약금액계약상대자
411본청제한경쟁『송강 문화창조마을 조성사업 건축공사』 집행(장기계속, 2차분)2023-12-171000000000주식회사 제이에스건설
412본청수의1인견적안동김씨 사충문 보수정비공사 집행(문화관광과)2023-12-184700000원창건설(주)
413본청수의1인견적진천군립치매전담요양원 세탁실 공사 집행(주민복지과)2023-12-196100000유한건축설비공사
414본청수의1인견적관내 주요관광지 관광안내판 설치 및 보수 집행(문화관광과)2023-12-194800000스카이광고
415본청수의1인견적백곡 장수복지회관 기능보강(어닝, 트랜치) 공사 집행(건축디자인과)2023-12-198500000주식회사 청풍
416본청수의1인견적백곡천 하상주차장 표지판 및 배수문 명패 설치공사 집행(건설교통과)2023-12-205000000스카이광고
417본청제한경쟁[보재이상설기념관 건립사업 조경공사] 집행2023-12-20372798400삼정건설(주)
418본청제한경쟁『궁골~서원간 군도개설공사(잔여구간)』2023-12-20292844990(주)태광건설
419본청제한경쟁김유신탄생지와태실 호우피해 사면복구공사 집행2023-12-22437173000가람건설(주)
420본청수의2인이상견적진천군 음식물류폐기물 공공처리시설(10톤) 설비철거공사 집행(정정)2023-12-2272615780(주)대창