Overview

Dataset statistics

Number of variables8
Number of observations71
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.7 KiB
Average record size in memory67.9 B

Variable types

Categorical5
Numeric1
Text2

Dataset

Description충북개발공사의 발주계획 중 용역계약 계획에 관한 자료입니다. 용역명, 조달방식, 계약방법, 예산액 등의 내용을 제공합니다.
Author충북개발공사
URLhttps://www.data.go.kr/data/15040214/fileData.do

Alerts

조달방식 has constant value ""Constant
발주년도 is highly overall correlated with 계약방법 and 1 other fieldsHigh correlation
계약방법 is highly overall correlated with 발주년도High correlation
부서명 is highly overall correlated with 발주년도High correlation
용역명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 10:38:45.423673
Analysis finished2023-12-12 10:38:46.314216
Duration0.89 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

발주년도
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size700.0 B
2020
46 
2021
25 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2020 46
64.8%
2021 25
35.2%

Length

2023-12-12T19:38:46.397531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:38:46.554086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020 46
64.8%
2021 25
35.2%

발주월
Real number (ℝ)

Distinct10
Distinct (%)14.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.1408451
Minimum1
Maximum11
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size771.0 B
2023-12-12T19:38:46.764418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median3
Q37
95-th percentile9.5
Maximum11
Range10
Interquartile range (IQR)5

Descriptive statistics

Standard deviation2.8997329
Coefficient of variation (CV)0.70027562
Kurtosis-0.72779575
Mean4.1408451
Median Absolute Deviation (MAD)2
Skewness0.69157437
Sum294
Variance8.4084507
MonotonicityNot monotonic
2023-12-12T19:38:46.994235image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
3 22
31.0%
1 17
23.9%
7 10
14.1%
2 5
 
7.0%
5 4
 
5.6%
9 4
 
5.6%
6 3
 
4.2%
10 3
 
4.2%
8 2
 
2.8%
11 1
 
1.4%
ValueCountFrequency (%)
1 17
23.9%
2 5
 
7.0%
3 22
31.0%
5 4
 
5.6%
6 3
 
4.2%
7 10
14.1%
8 2
 
2.8%
9 4
 
5.6%
10 3
 
4.2%
11 1
 
1.4%
ValueCountFrequency (%)
11 1
 
1.4%
10 3
 
4.2%
9 4
 
5.6%
8 2
 
2.8%
7 10
14.1%
6 3
 
4.2%
5 4
 
5.6%
3 22
31.0%
2 5
 
7.0%
1 17
23.9%

조달방식
Categorical

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size700.0 B
자체조달
71 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row자체조달
2nd row자체조달
3rd row자체조달
4th row자체조달
5th row자체조달

Common Values

ValueCountFrequency (%)
자체조달 71
100.0%

Length

2023-12-12T19:38:47.185858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:38:47.332271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
자체조달 71
100.0%

용역명
Text

UNIQUE 

Distinct71
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size700.0 B
2023-12-12T19:38:47.636897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length31
Mean length24.915493
Min length8

Characters and Unicode

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

Unique

Unique71 ?
Unique (%)100.0%

Sample

1st row충청북도문화재연구원 청사이전(신축) 건축설계공모용역
2nd row충북도립대학교 학생생활관 건립공사 감리용역
3rd row충북도립대학교 학생생활관 건립 폐기물처리용역
4th row충청북도문화재연구원 청사이전(신축) 감리용역
5th row충청북도문화재연구원 청사이전(신축) 폐기물처리용역
ValueCountFrequency (%)
용역 48
 
13.5%
건립사업 14
 
3.9%
조성사업 14
 
3.9%
00산업단지 11
 
3.1%
오송 9
 
2.5%
청주 8
 
2.2%
충북 8
 
2.2%
음성 7
 
2.0%
건립 7
 
2.0%
진입도로 6
 
1.7%
Other values (125) 224
62.9%
2023-12-12T19:38:48.156600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
288
 
16.3%
역 77
 
4.4%
업 71
 
4.0%
용 68
 
3.8%
사 66
 
3.7%
지 49
 
2.8%
건 41
 
2.3%
설 36
 
2.0%
산 28
 
1.6%
조 27
 
1.5%
Other values (186) 1018
57.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1406
79.5%
Space Separator 288
 
16.3%
Decimal Number 34
 
1.9%
Close Punctuation 14
 
0.8%
Open Punctuation 14
 
0.8%
Uppercase Letter 12
 
0.7%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
역 77
 
5.5%
업 71
 
5.0%
용 68
 
4.8%
사 66
 
4.7%
지 49
 
3.5%
건 41
 
2.9%
설 36
 
2.6%
산 28
 
2.0%
조 27
 
1.9%
성 27
 
1.9%
Other values (170) 916
65.1%
Uppercase Letter
ValueCountFrequency (%)
S 4
33.3%
E 1
 
8.3%
V 1
 
8.3%
N 1
 
8.3%
G 1
 
8.3%
I 1
 
8.3%
D 1
 
8.3%
B 1
 
8.3%
C 1
 
8.3%
Decimal Number
ValueCountFrequency (%)
0 26
76.5%
2 7
 
20.6%
1 1
 
2.9%
Space Separator
ValueCountFrequency (%)
288
100.0%
Close Punctuation
ValueCountFrequency (%)
) 14
100.0%
Open Punctuation
ValueCountFrequency (%)
( 14
100.0%
Other Punctuation
ValueCountFrequency (%)
· 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1406
79.5%
Common 351
 
19.8%
Latin 12
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
역 77
 
5.5%
업 71
 
5.0%
용 68
 
4.8%
사 66
 
4.7%
지 49
 
3.5%
건 41
 
2.9%
설 36
 
2.6%
산 28
 
2.0%
조 27
 
1.9%
성 27
 
1.9%
Other values (170) 916
65.1%
Latin
ValueCountFrequency (%)
S 4
33.3%
E 1
 
8.3%
V 1
 
8.3%
N 1
 
8.3%
G 1
 
8.3%
I 1
 
8.3%
D 1
 
8.3%
B 1
 
8.3%
C 1
 
8.3%
Common
ValueCountFrequency (%)
288
82.1%
0 26
 
7.4%
) 14
 
4.0%
( 14
 
4.0%
2 7
 
2.0%
1 1
 
0.3%
· 1
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1406
79.5%
ASCII 362
 
20.5%
None 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
288
79.6%
0 26
 
7.2%
) 14
 
3.9%
( 14
 
3.9%
2 7
 
1.9%
S 4
 
1.1%
E 1
 
0.3%
V 1
 
0.3%
N 1
 
0.3%
1 1
 
0.3%
Other values (5) 5
 
1.4%
Hangul
ValueCountFrequency (%)
역 77
 
5.5%
업 71
 
5.0%
용 68
 
4.8%
사 66
 
4.7%
지 49
 
3.5%
건 41
 
2.9%
설 36
 
2.6%
산 28
 
2.0%
조 27
 
1.9%
성 27
 
1.9%
Other values (170) 916
65.1%
None
ValueCountFrequency (%)
· 1
100.0%

용역구분
Categorical

Distinct3
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size700.0 B
기술용역
41 
일반용역
28 
기타
 
2

Length

Max length4
Median length4
Mean length3.943662
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row기술용역
2nd row기술용역
3rd row기타
4th row기술용역
5th row기타

Common Values

ValueCountFrequency (%)
기술용역 41
57.7%
일반용역 28
39.4%
기타 2
 
2.8%

Length

2023-12-12T19:38:48.362131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:38:48.514041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기술용역 41
57.7%
일반용역 28
39.4%
기타 2
 
2.8%

계약방법
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)9.9%
Missing0
Missing (%)0.0%
Memory size700.0 B
수의계약
24 
일반경쟁
16 
제한경쟁
15 
공모
5 
수의견적
4 
Other values (2)
7 

Length

Max length6
Median length4
Mean length3.8873239
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row공모
2nd rowPQ
3rd row수의견적
4th rowPQ
5th row수의계약

Common Values

ValueCountFrequency (%)
수의계약 24
33.8%
일반경쟁 16
22.5%
제한경쟁 15
21.1%
공모 5
 
7.0%
수의견적 4
 
5.6%
수의견적제출 4
 
5.6%
PQ 3
 
4.2%

Length

2023-12-12T19:38:48.654012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:38:48.796836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
수의계약 24
33.8%
일반경쟁 16
22.5%
제한경쟁 15
21.1%
공모 5
 
7.0%
수의견적 4
 
5.6%
수의견적제출 4
 
5.6%
pq 3
 
4.2%

예산액(단위: 천원)
Text

Distinct55
Distinct (%)77.5%
Missing0
Missing (%)0.0%
Memory size700.0 B
2023-12-12T19:38:49.075553image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length12
Mean length8.9014085
Min length5

Characters and Unicode

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

Unique

Unique47 ?
Unique (%)66.2%

Sample

1st row 367,000,000
2nd row 2,400,000,000
3rd row 80,000,000
4th row 800,000,000
5th row 16,000,000
ValueCountFrequency (%)
20,000 6
 
8.5%
22,000,000 5
 
7.0%
1,500,000 3
 
4.2%
20,000,000 2
 
2.8%
37,000 2
 
2.8%
150,000 2
 
2.8%
10,000 2
 
2.8%
200,000,000 2
 
2.8%
367,000,000 1
 
1.4%
35,000 1
 
1.4%
Other values (45) 45
63.4%
2023-12-12T19:38:49.473663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 309
48.9%
, 106
 
16.8%
50
 
7.9%
2 40
 
6.3%
1 33
 
5.2%
3 23
 
3.6%
5 15
 
2.4%
9 13
 
2.1%
7 12
 
1.9%
8 12
 
1.9%
Other values (2) 19
 
3.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 476
75.3%
Other Punctuation 106
 
16.8%
Space Separator 50
 
7.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 309
64.9%
2 40
 
8.4%
1 33
 
6.9%
3 23
 
4.8%
5 15
 
3.2%
9 13
 
2.7%
7 12
 
2.5%
8 12
 
2.5%
4 12
 
2.5%
6 7
 
1.5%
Other Punctuation
ValueCountFrequency (%)
, 106
100.0%
Space Separator
ValueCountFrequency (%)
50
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 632
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 309
48.9%
, 106
 
16.8%
50
 
7.9%
2 40
 
6.3%
1 33
 
5.2%
3 23
 
3.6%
5 15
 
2.4%
9 13
 
2.1%
7 12
 
1.9%
8 12
 
1.9%
Other values (2) 19
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 632
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 309
48.9%
, 106
 
16.8%
50
 
7.9%
2 40
 
6.3%
1 33
 
5.2%
3 23
 
3.6%
5 15
 
2.4%
9 13
 
2.1%
7 12
 
1.9%
8 12
 
1.9%
Other values (2) 19
 
3.0%

부서명
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)15.5%
Missing0
Missing (%)0.0%
Memory size700.0 B
사업계획부
20 
오송사업단
11 
재생사업부
10 
복합사업부
9 
건축사업부
7 
Other values (6)
14 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique2 ?
Unique (%)2.8%

Sample

1st row건축사업부
2nd row건축사업부
3rd row건축사업부
4th row건축사업부
5th row건축사업부

Common Values

ValueCountFrequency (%)
사업계획부 20
28.2%
오송사업단 11
15.5%
재생사업부 10
14.1%
복합사업부 9
12.7%
건축사업부 7
 
9.9%
사업지원실 4
 
5.6%
보상사업부 3
 
4.2%
개발사업부 3
 
4.2%
경영기획실 2
 
2.8%
열린혁신팀 1
 
1.4%

Length

2023-12-12T19:38:49.632696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
사업계획부 20
28.2%
오송사업단 11
15.5%
재생사업부 10
14.1%
복합사업부 9
12.7%
건축사업부 7
 
9.9%
사업지원실 4
 
5.6%
보상사업부 3
 
4.2%
개발사업부 3
 
4.2%
경영기획실 2
 
2.8%
열린혁신팀 1
 
1.4%

Interactions

2023-12-12T19:38:45.910635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T19:38:49.711158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
발주년도발주월용역명용역구분계약방법예산액(단위: 천원)부서명
발주년도1.0000.3061.0000.1590.6191.0000.838
발주월0.3061.0001.0000.3380.5170.9380.630
용역명1.0001.0001.0001.0001.0001.0001.000
용역구분0.1590.3381.0001.0000.3340.9140.645
계약방법0.6190.5171.0000.3341.0001.0000.499
예산액(단위: 천원)1.0000.9381.0000.9141.0001.0000.000
부서명0.8380.6301.0000.6450.4990.0001.000
2023-12-12T19:38:49.827159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
용역구분부서명계약방법발주년도
용역구분1.0000.4500.2290.259
부서명0.4501.0000.2610.780
계약방법0.2290.2611.0000.642
발주년도0.2590.7800.6421.000
2023-12-12T19:38:49.918832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
발주월발주년도용역구분계약방법부서명
발주월1.0000.3220.2300.2920.377
발주년도0.3221.0000.2590.6420.780
용역구분0.2300.2591.0000.2290.450
계약방법0.2920.6420.2291.0000.261
부서명0.3770.7800.4500.2611.000

Missing values

2023-12-12T19:38:46.070785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:38:46.261300image/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

발주년도발주월조달방식용역명용역구분계약방법예산액(단위: 천원)부서명
020211자체조달충청북도문화재연구원 청사이전(신축) 건축설계공모용역기술용역공모367,000,000건축사업부
120213자체조달충북도립대학교 학생생활관 건립공사 감리용역기술용역PQ2,400,000,000건축사업부
220215자체조달충북도립대학교 학생생활관 건립 폐기물처리용역기타수의견적80,000,000건축사업부
320218자체조달충청북도문화재연구원 청사이전(신축) 감리용역기술용역PQ800,000,000건축사업부
420219자체조달충청북도문화재연구원 청사이전(신축) 폐기물처리용역기타수의계약16,000,000건축사업부
520218자체조달생활밀착형 국민체육센터 건립 감리용역기술용역PQ920,000,000건축사업부
620213자체조달담수자원 종 보존시설 민물고기아쿠아리움 건축 설계공모기술용역공모203,000,000건축사업부
720213자체조달SNS 홍보대행 용역일반용역수의계약22,000,000경영기획실
820213자체조달조직진단 연구용역일반용역수의계약22,000,000경영기획실
920211자체조달청주 북이산업단지 보상 기본조사 용역일반용역수의견적93,720,000보상사업부
발주년도발주월조달방식용역명용역구분계약방법예산액(단위: 천원)부서명
6120201자체조달음성 맹동인곡산업단지 환경영향평가(변경) 용역기술용역제한경쟁150,000사업계획부
6220201자체조달음성 맹동인곡산업단지 교통영향평가(변경) 용역기술용역수의계약20,000사업계획부
6320201자체조달동충주산업단지 석면해체제거 감리 용역일반용역수의계약20,000개발사업부
6420201자체조달동충주산업단지 지정폐기물(석면) 처리 용역일반용역수의계약20,000개발사업부
6520201자체조달충북 소방본부 청사 건립사업 외 2 감독권한대행 등 통합건설사업관리 용역기술용역일반경쟁1,174,000복합사업부
6620201자체조달충청북도 근로자종합복지관 건립 건설폐기물처리 용역일반용역수의계약11,110복합사업부
6720201자체조달오송바이오메디컬지구 진입도로 건설공사 건설사업관리용역기술용역일반경쟁1,483,000오송사업단
6820201자체조달충북 청주전시관 건립사업 사후환경영향조사 용역기술용역일반경쟁480,000오송사업단
6920201자체조달충북 청주전시관 건립사업 건설폐기물처리 용역일반용역제한경쟁518,320오송사업단
7020201자체조달충북 청주전시관 건립사업 석면조사 및 비산측정 용역일반용역수의계약4,000오송사업단