Overview

Dataset statistics

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

Variable types

Categorical2
Text2
DateTime1
Numeric1

Dataset

Description충청북도 진천군 용역 계약 현황 정보는 진천군에서 용역계약한 관서명, 계약방법, 계약명, 계약금액, 계약일, 계약상대자를 포함하는 데이터임.
Author충청북도 진천군
URLhttps://www.data.go.kr/data/15064047/fileData.do

Alerts

계약관서 has constant value ""Constant
계약방법 is highly imbalanced (62.7%)Imbalance

Reproduction

Analysis started2024-03-14 19:09:07.280857
Analysis finished2024-03-14 19:09:08.681122
Duration1.4 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
본청
419 

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

Length

2024-03-15T04:09:08.964527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T04:09:09.370280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
본청 419
100.0%

계약명
Text

Distinct418
Distinct (%)99.8%
Missing0
Missing (%)0.0%
Memory size3.4 KiB
2024-03-15T04:09:10.753150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length69
Median length49
Mean length33.725537
Min length17

Characters and Unicode

Total characters14131
Distinct characters441
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.5%

Sample

1st row2022회계연도 재무제표 검토용역 추진(회계과)
2nd row2023년도 군청사 소방시설 종합정밀점검 용역 집행
3rd row2023년 작업임도 신설 공사 및 임도구조개량 실시설계 용역 집행
4th row2023년 광혜원 화랑공원 앉음석 공사 실시설계 용역
5th row2023년 봉화산 지역특화 숲길 조성 사업 실시설계 용역 집행
ValueCountFrequency (%)
2023년 110
 
4.6%
집행 78
 
3.2%
용역 78
 
3.2%
및 56
 
2.3%
실시설계 41
 
1.7%
진천군 38
 
1.6%
조성사업 31
 
1.3%
용역(산림녹지과 27
 
1.1%
개설공사 22
 
0.9%
기술지도 22
 
0.9%
Other values (1039) 1897
79.0%
2024-03-15T04:09:12.658271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2023
 
14.3%
역 427
 
3.0%
용 395
 
2.8%
) 366
 
2.6%
( 366
 
2.6%
2 328
 
2.3%
사 310
 
2.2%
설 253
 
1.8%
과 250
 
1.8%
지 245
 
1.7%
Other values (431) 9168
64.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 10338
73.2%
Space Separator 2023
 
14.3%
Decimal Number 737
 
5.2%
Open Punctuation 449
 
3.2%
Close Punctuation 445
 
3.1%
Other Punctuation 43
 
0.3%
Uppercase Letter 43
 
0.3%
Dash Punctuation 36
 
0.3%
Math Symbol 17
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
역 427
 
4.1%
용 395
 
3.8%
사 310
 
3.0%
설 253
 
2.4%
과 250
 
2.4%
지 245
 
2.4%
기 226
 
2.2%
공 212
 
2.1%
시 207
 
2.0%
도 184
 
1.8%
Other values (394) 7629
73.8%
Uppercase Letter
ValueCountFrequency (%)
D 8
18.6%
S 8
18.6%
G 7
16.3%
B 6
14.0%
I 5
11.6%
E 3
 
7.0%
M 2
 
4.7%
V 1
 
2.3%
A 1
 
2.3%
W 1
 
2.3%
Decimal Number
ValueCountFrequency (%)
2 328
44.5%
3 162
22.0%
0 149
20.2%
1 36
 
4.9%
4 18
 
2.4%
5 12
 
1.6%
8 11
 
1.5%
6 9
 
1.2%
9 8
 
1.1%
7 4
 
0.5%
Other Punctuation
ValueCountFrequency (%)
, 22
51.2%
· 9
20.9%
' 7
 
16.3%
. 3
 
7.0%
" 2
 
4.7%
Close Punctuation
ValueCountFrequency (%)
) 366
82.2%
」 46
 
10.3%
』 24
 
5.4%
] 9
 
2.0%
Open Punctuation
ValueCountFrequency (%)
( 366
81.5%
「 50
 
11.1%
『 24
 
5.3%
[ 9
 
2.0%
Space Separator
ValueCountFrequency (%)
2023
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 36
100.0%
Math Symbol
ValueCountFrequency (%)
~ 17
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 10337
73.2%
Common 3750
 
26.5%
Latin 43
 
0.3%
Han 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
역 427
 
4.1%
용 395
 
3.8%
사 310
 
3.0%
설 253
 
2.4%
과 250
 
2.4%
지 245
 
2.4%
기 226
 
2.2%
공 212
 
2.1%
시 207
 
2.0%
도 184
 
1.8%
Other values (393) 7628
73.8%
Common
ValueCountFrequency (%)
2023
53.9%
) 366
 
9.8%
( 366
 
9.8%
2 328
 
8.7%
3 162
 
4.3%
0 149
 
4.0%
「 50
 
1.3%
」 46
 
1.2%
- 36
 
1.0%
1 36
 
1.0%
Other values (16) 188
 
5.0%
Latin
ValueCountFrequency (%)
D 8
18.6%
S 8
18.6%
G 7
16.3%
B 6
14.0%
I 5
11.6%
E 3
 
7.0%
M 2
 
4.7%
V 1
 
2.3%
A 1
 
2.3%
W 1
 
2.3%
Han
ValueCountFrequency (%)
林 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 10337
73.2%
ASCII 3640
 
25.8%
None 153
 
1.1%
CJK 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2023
55.6%
) 366
 
10.1%
( 366
 
10.1%
2 328
 
9.0%
3 162
 
4.5%
0 149
 
4.1%
- 36
 
1.0%
1 36
 
1.0%
, 22
 
0.6%
4 18
 
0.5%
Other values (22) 134
 
3.7%
Hangul
ValueCountFrequency (%)
역 427
 
4.1%
용 395
 
3.8%
사 310
 
3.0%
설 253
 
2.4%
과 250
 
2.4%
지 245
 
2.4%
기 226
 
2.2%
공 212
 
2.1%
시 207
 
2.0%
도 184
 
1.8%
Other values (393) 7628
73.8%
None
ValueCountFrequency (%)
「 50
32.7%
」 46
30.1%
』 24
15.7%
『 24
15.7%
· 9
 
5.9%
CJK
ValueCountFrequency (%)
林 1
100.0%

계약방법
Categorical

IMBALANCE 

Distinct4
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size3.4 KiB
수의1인견적
360 
수의2인이상견적
42 
일반경쟁
 
11
제한경쟁
 
6

Length

Max length8
Median length6
Mean length6.1193317
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row수의1인견적
2nd row수의1인견적
3rd row수의1인견적
4th row수의1인견적
5th row수의1인견적

Common Values

ValueCountFrequency (%)
수의1인견적 360
85.9%
수의2인이상견적 42
 
10.0%
일반경쟁 11
 
2.6%
제한경쟁 6
 
1.4%

Length

2024-03-15T04:09:12.934986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T04:09:13.293336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
수의1인견적 360
85.9%
수의2인이상견적 42
 
10.0%
일반경쟁 11
 
2.6%
제한경쟁 6
 
1.4%

계약일자
Date

Distinct187
Distinct (%)44.6%
Missing0
Missing (%)0.0%
Memory size3.4 KiB
Minimum2023-01-04 00:00:00
Maximum2023-12-27 00:00:00
2024-03-15T04:09:13.651468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T04:09:14.084425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

계약금액
Real number (ℝ)

Distinct355
Distinct (%)84.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean27549945
Minimum1260000
Maximum1.7 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.8 KiB
2024-03-15T04:09:14.506411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1260000
5-th percentile2640000
Q15873000
median12540000
Q319760000
95-th percentile85417992
Maximum1.7 × 109
Range1.69874 × 109
Interquartile range (IQR)13887000

Descriptive statistics

Standard deviation93724862
Coefficient of variation (CV)3.4019981
Kurtosis244.93058
Mean27549945
Median Absolute Deviation (MAD)6960000
Skewness14.234748
Sum1.1543427 × 1010
Variance8.7843497 × 1015
MonotonicityNot monotonic
2024-03-15T04:09:14.971745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
18000000 5
 
1.2%
20000000 4
 
1.0%
4140000 4
 
1.0%
19000000 3
 
0.7%
3610000 3
 
0.7%
9100000 3
 
0.7%
8091000 3
 
0.7%
4750000 3
 
0.7%
2640000 3
 
0.7%
2600000 3
 
0.7%
Other values (345) 385
91.9%
ValueCountFrequency (%)
1260000 1
0.2%
1325000 1
0.2%
1706000 1
0.2%
2055800 1
0.2%
2100000 1
0.2%
2280000 1
0.2%
2320000 1
0.2%
2382000 1
0.2%
2400000 2
0.5%
2438000 1
0.2%
ValueCountFrequency (%)
1700000000 1
0.2%
390000000 1
0.2%
370000000 1
0.2%
369157200 1
0.2%
324600000 1
0.2%
229100000 1
0.2%
221342930 1
0.2%
205884550 1
0.2%
202736840 1
0.2%
200300000 1
0.2%

계약상대자
Text

Distinct197
Distinct (%)47.0%
Missing0
Missing (%)0.0%
Memory size3.4 KiB
2024-03-15T04:09:15.647030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length15
Mean length9.2863962
Min length2

Characters and Unicode

Total characters3891
Distinct characters256
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

Unique141 ?
Unique (%)33.7%

Sample

1st row회계법인 청담
2nd row(주)가람방재
3rd row(주)하늘숲엔지니어링
4th row(주)명지기술단
5th row(주)하늘숲엔지니어링
ValueCountFrequency (%)
주식회사 60
 
12.0%
주)태광건설 28
 
5.6%
동아환경개발(주 24
 
4.8%
주)하늘숲엔지니어링 15
 
3.0%
주)해린엔지니어링 15
 
3.0%
주)범진 13
 
2.6%
주)수일건설엔지니어링 11
 
2.2%
주)정상엔지니어링 11
 
2.2%
주)청담산업개발 10
 
2.0%
정우지오텍(주 9
 
1.8%
Other values (199) 306
61.0%
2024-03-15T04:09:16.649500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 313
 
8.0%
( 245
 
6.3%
) 245
 
6.3%
사 174
 
4.5%
지 119
 
3.1%
건 100
 
2.6%
회 96
 
2.5%
설 89
 
2.3%
83
 
2.1%
엔 78
 
2.0%
Other values (246) 2349
60.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3301
84.8%
Open Punctuation 245
 
6.3%
Close Punctuation 245
 
6.3%
Space Separator 83
 
2.1%
Uppercase Letter 10
 
0.3%
Decimal Number 6
 
0.2%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 313
 
9.5%
사 174
 
5.3%
지 119
 
3.6%
건 100
 
3.0%
회 96
 
2.9%
설 89
 
2.7%
엔 78
 
2.4%
식 77
 
2.3%
니 62
 
1.9%
어 59
 
1.8%
Other values (234) 2134
64.6%
Uppercase Letter
ValueCountFrequency (%)
C 2
20.0%
S 2
20.0%
M 2
20.0%
B 2
20.0%
L 1
10.0%
D 1
10.0%
Decimal Number
ValueCountFrequency (%)
1 4
66.7%
9 2
33.3%
Open Punctuation
ValueCountFrequency (%)
( 245
100.0%
Close Punctuation
ValueCountFrequency (%)
) 245
100.0%
Space Separator
ValueCountFrequency (%)
83
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3301
84.8%
Common 580
 
14.9%
Latin 10
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 313
 
9.5%
사 174
 
5.3%
지 119
 
3.6%
건 100
 
3.0%
회 96
 
2.9%
설 89
 
2.7%
엔 78
 
2.4%
식 77
 
2.3%
니 62
 
1.9%
어 59
 
1.8%
Other values (234) 2134
64.6%
Common
ValueCountFrequency (%)
( 245
42.2%
) 245
42.2%
83
 
14.3%
1 4
 
0.7%
9 2
 
0.3%
& 1
 
0.2%
Latin
ValueCountFrequency (%)
C 2
20.0%
S 2
20.0%
M 2
20.0%
B 2
20.0%
L 1
10.0%
D 1
10.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3301
84.8%
ASCII 590
 
15.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 313
 
9.5%
사 174
 
5.3%
지 119
 
3.6%
건 100
 
3.0%
회 96
 
2.9%
설 89
 
2.7%
엔 78
 
2.4%
식 77
 
2.3%
니 62
 
1.9%
어 59
 
1.8%
Other values (234) 2134
64.6%
ASCII
ValueCountFrequency (%)
( 245
41.5%
) 245
41.5%
83
 
14.1%
1 4
 
0.7%
C 2
 
0.3%
S 2
 
0.3%
M 2
 
0.3%
9 2
 
0.3%
B 2
 
0.3%
& 1
 
0.2%
Other values (2) 2
 
0.3%

Interactions

2024-03-15T04:09:07.876367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T04:09:16.844403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
계약방법계약금액
계약방법1.0000.748
계약금액0.7481.000
2024-03-15T04:09:17.283301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
계약금액계약방법
계약금액1.0000.385
계약방법0.3851.000

Missing values

2024-03-15T04:09:08.203761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T04:09:08.532398image/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본청2022회계연도 재무제표 검토용역 추진(회계과)수의1인견적2023-01-0418800000회계법인 청담
1본청2023년도 군청사 소방시설 종합정밀점검 용역 집행수의1인견적2023-01-092382000(주)가람방재
2본청2023년 작업임도 신설 공사 및 임도구조개량 실시설계 용역 집행수의1인견적2023-01-0915460000(주)하늘숲엔지니어링
3본청2023년 광혜원 화랑공원 앉음석 공사 실시설계 용역수의1인견적2023-01-103130000(주)명지기술단
4본청2023년 봉화산 지역특화 숲길 조성 사업 실시설계 용역 집행수의1인견적2023-01-1118320000(주)하늘숲엔지니어링
5본청2023년 부가가치세 환급추진 용역 집행(회계과)수의1인견적2023-01-125700000태성회계법인
6본청「2023년 충북혁신도시 비점오염저감 시설 유지관리 용역」 집행수의1인견적2023-01-1315240000중경산업(주)
7본청재난위험시설 금한교 보수공사 실시설계용역 집행수의1인견적2023-01-1710010000(주)태광건설
8본청2023년 생활권 등산로 정비 사업 실시설계 용역(산림녹지과)수의1인견적2023-01-185370000(주)하늘숲엔지니어링
9본청2023 시설물 정밀안전점검 및 (상반기)정기안전점검 용역 집행수의2인이상견적2023-01-2074615790(주)태광건설
계약관서계약명계약방법계약일자계약금액계약상대자
409본청「진천백곡지구 수해복구공사 실시설계용역」집행수의1인견적2023-12-1115670000(주)태광건설
410본청모치올교 확장공사 건설재해예방 기술지도 용역(건설교통과)수의1인견적2023-12-114400000주식회사한국건설안전지도원
411본청2023년도 지역사회 통합돌봄 성과공유대회 행사 용역 집행수의1인견적2023-12-124500000L&B이벤트기획
412본청석장교차로~혁신도시 간 연결도로 개설사업 건설재해예방 기술지도 용역(투자전략실)수의1인견적2023-12-152508000주식회사 한국휴먼안전컨설팅
413본청「은탄지구 자연재해위험개선지구 정비사업 타당성조사 및 기본계획수립 용역」집행수의1인견적2023-12-1817550000(주)도화엔지니어링
414본청이월면 행복나눔의 집 및 이월마실 어울림센터 통합건립공사 건축설계용역(공모)일반경쟁2023-12-20229100000건축사사무소 기억공간
415본청『궁골~서원간 군도개설공사(잔여구간) 폐기물처리용역』 집행수의1인견적2023-12-206564000동아환경개발(주)
416본청2023년 도로팀 응급복구 장비임차(건설교통과)수의1인견적2023-12-218360000초평중기
417본청궁골~서원간 군도개설공사(잔여구간) 건설재해예방 기술지도 용역(건설교통과)수의1인견적2023-12-214400000주식회사한국건설안전지도원
418본청김유신탄생지와 태실 호우피해 사면복구공사건설재해예방 기술지도 용역(문화관광과)수의1인견적2023-12-272640000(주)건설안전지원센터