Overview

Dataset statistics

Number of variables10
Number of observations497
Missing cells0
Missing cells (%)0.0%
Duplicate rows1
Duplicate rows (%)0.2%
Total size in memory39.4 KiB
Average record size in memory81.3 B

Variable types

Numeric1
Text1
Categorical6
DateTime2

Dataset

Description한국마사회의 전자입찰시스템에서 투찰하여 낙찰된 용역 및 구매, 공사 등의 입찰공고명, 계약체결형태명, 계약체결방법, 입찰결과 구분 등에 대한 내용을 제공한다.
Author한국마사회
URLhttps://www.data.go.kr/data/15123177/fileData.do

Alerts

공고기관명 has constant value ""Constant
수요기관명 has constant value ""Constant
입찰결과구분명 has constant value ""Constant
Dataset has 1 (0.2%) duplicate rowsDuplicates
업무구분명 is highly overall correlated with 계약체결형태High correlation
계약체결형태 is highly overall correlated with 업무구분명High correlation

Reproduction

Analysis started2023-12-12 04:26:13.921352
Analysis finished2023-12-12 04:26:14.885370
Duration0.96 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

입찰공고번호
Real number (ℝ)

Distinct496
Distinct (%)99.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0225623 × 109
Minimum2.02201 × 109
Maximum2.0230906 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.5 KiB
2023-12-12T13:26:15.001241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.02201 × 109
5-th percentile2.0220204 × 109
Q12.0220601 × 109
median2.0230101 × 109
Q32.0230408 × 109
95-th percentile2.0230803 × 109
Maximum2.0230906 × 109
Range1080550
Interquartile range (IQR)980660

Descriptive statistics

Standard deviation495598.86
Coefficient of variation (CV)0.00024503515
Kurtosis-1.9950099
Mean2.0225623 × 109
Median Absolute Deviation (MAD)80320
Skewness-0.038826873
Sum1.0052135 × 1012
Variance2.4561823 × 1011
MonotonicityNot monotonic
2023-12-12T13:26:15.207903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2022030430 2
 
0.4%
2022020440 1
 
0.2%
2023030440 1
 
0.2%
2023030620 1
 
0.2%
2023040210 1
 
0.2%
2023040200 1
 
0.2%
2023031230 1
 
0.2%
2023020370 1
 
0.2%
2022070410 1
 
0.2%
2022070070 1
 
0.2%
Other values (486) 486
97.8%
ValueCountFrequency (%)
2022010040 1
0.2%
2022010130 1
0.2%
2022010160 1
0.2%
2022010190 1
0.2%
2022010280 1
0.2%
2022010290 1
0.2%
2022020010 1
0.2%
2022020040 1
0.2%
2022020050 1
0.2%
2022020100 1
0.2%
ValueCountFrequency (%)
2023090590 1
0.2%
2023090520 1
0.2%
2023090500 1
0.2%
2023090470 1
0.2%
2023090460 1
0.2%
2023090410 1
0.2%
2023090400 1
0.2%
2023090350 1
0.2%
2023090340 1
0.2%
2023090330 1
0.2%

입찰공고명
Text

Distinct486
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
2023-12-12T13:26:15.632626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length33
Mean length20.957746
Min length8

Characters and Unicode

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

Unique

Unique475 ?
Unique (%)95.6%

Sample

1st row2022년 상반기 수입조사료 티모시 구매
2nd row2022년 장수목장 초지관리용 화학비료 구매
3rd row제주경마공원 노후 도로 재포장 공사
4th row서울경마장 합숙소 출입문 구매 교체
5th row분당지사 주출입구 캐노피 보수공사
ValueCountFrequency (%)
구매 199
 
8.9%
2023년 69
 
3.1%
2022년 63
 
2.8%
서울경마공원 50
 
2.2%
용역 47
 
2.1%
및 46
 
2.1%
한국마사회 34
 
1.5%
제주경마공원 33
 
1.5%
매각 30
 
1.3%
부산경남경마공원 26
 
1.2%
Other values (898) 1646
73.4%
2023-12-12T13:26:16.368770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1754
 
16.8%
2 369
 
3.5%
마 315
 
3.0%
매 280
 
2.7%
사 269
 
2.6%
구 266
 
2.6%
용 255
 
2.4%
경 254
 
2.4%
공 243
 
2.3%
원 183
 
1.8%
Other values (456) 6228
59.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7599
73.0%
Space Separator 1754
 
16.8%
Decimal Number 665
 
6.4%
Close Punctuation 122
 
1.2%
Open Punctuation 122
 
1.2%
Uppercase Letter 119
 
1.1%
Other Punctuation 25
 
0.2%
Lowercase Letter 9
 
0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
마 315
 
4.1%
매 280
 
3.7%
사 269
 
3.5%
구 266
 
3.5%
용 255
 
3.4%
경 254
 
3.3%
공 243
 
3.2%
원 183
 
2.4%
년 151
 
2.0%
장 138
 
1.8%
Other values (403) 5245
69.0%
Uppercase Letter
ValueCountFrequency (%)
T 14
11.8%
P 13
10.9%
E 12
10.1%
D 11
9.2%
L 10
 
8.4%
C 9
 
7.6%
R 7
 
5.9%
V 6
 
5.0%
M 6
 
5.0%
N 5
 
4.2%
Other values (12) 26
21.8%
Decimal Number
ValueCountFrequency (%)
2 369
55.5%
0 158
23.8%
3 81
 
12.2%
1 27
 
4.1%
8 8
 
1.2%
7 6
 
0.9%
4 5
 
0.8%
5 5
 
0.8%
6 3
 
0.5%
9 3
 
0.5%
Lowercase Letter
ValueCountFrequency (%)
k 2
22.2%
m 2
22.2%
h 1
11.1%
u 1
11.1%
b 1
11.1%
s 1
11.1%
p 1
11.1%
Other Punctuation
ValueCountFrequency (%)
. 10
40.0%
; 4
 
16.0%
# 4
 
16.0%
& 4
 
16.0%
＇ 2
 
8.0%
% 1
 
4.0%
Close Punctuation
ValueCountFrequency (%)
) 118
96.7%
』 2
 
1.6%
」 2
 
1.6%
Open Punctuation
ValueCountFrequency (%)
( 118
96.7%
『 2
 
1.6%
「 2
 
1.6%
Space Separator
ValueCountFrequency (%)
1754
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7599
73.0%
Common 2689
 
25.8%
Latin 128
 
1.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
마 315
 
4.1%
매 280
 
3.7%
사 269
 
3.5%
구 266
 
3.5%
용 255
 
3.4%
경 254
 
3.3%
공 243
 
3.2%
원 183
 
2.4%
년 151
 
2.0%
장 138
 
1.8%
Other values (403) 5245
69.0%
Latin
ValueCountFrequency (%)
T 14
 
10.9%
P 13
 
10.2%
E 12
 
9.4%
D 11
 
8.6%
L 10
 
7.8%
C 9
 
7.0%
R 7
 
5.5%
V 6
 
4.7%
M 6
 
4.7%
N 5
 
3.9%
Other values (19) 35
27.3%
Common
ValueCountFrequency (%)
1754
65.2%
2 369
 
13.7%
0 158
 
5.9%
) 118
 
4.4%
( 118
 
4.4%
3 81
 
3.0%
1 27
 
1.0%
. 10
 
0.4%
8 8
 
0.3%
7 6
 
0.2%
Other values (14) 40
 
1.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7599
73.0%
ASCII 2807
 
26.9%
None 10
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1754
62.5%
2 369
 
13.1%
0 158
 
5.6%
) 118
 
4.2%
( 118
 
4.2%
3 81
 
2.9%
1 27
 
1.0%
T 14
 
0.5%
P 13
 
0.5%
E 12
 
0.4%
Other values (38) 143
 
5.1%
Hangul
ValueCountFrequency (%)
마 315
 
4.1%
매 280
 
3.7%
사 269
 
3.5%
구 266
 
3.5%
용 255
 
3.4%
경 254
 
3.3%
공 243
 
3.2%
원 183
 
2.4%
년 151
 
2.0%
장 138
 
1.8%
Other values (403) 5245
69.0%
None
ValueCountFrequency (%)
『 2
20.0%
＇ 2
20.0%
』 2
20.0%
」 2
20.0%
「 2
20.0%

업무구분명
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
물품구매
257 
일반용역
114 
시설공사
71 
매각
33 
기술용역
 
22

Length

Max length4
Median length4
Mean length3.8672032
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row물품구매
2nd row물품구매
3rd row시설공사
4th row물품구매
5th row시설공사

Common Values

ValueCountFrequency (%)
물품구매 257
51.7%
일반용역 114
22.9%
시설공사 71
 
14.3%
매각 33
 
6.6%
기술용역 22
 
4.4%

Length

2023-12-12T13:26:16.591647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:26:16.751215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
물품구매 257
51.7%
일반용역 114
22.9%
시설공사 71
 
14.3%
매각 33
 
6.6%
기술용역 22
 
4.4%

계약체결형태
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
총액계약
372 
단가계약
66 
59 

Length

Max length4
Median length4
Mean length3.6438632
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row단가계약
2nd row총액계약
3rd row총액계약
4th row총액계약
5th row총액계약

Common Values

ValueCountFrequency (%)
총액계약 372
74.8%
단가계약 66
 
13.3%
59
 
11.9%

Length

2023-12-12T13:26:16.930730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:26:17.049620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
총액계약 372
84.9%
단가계약 66
 
15.1%

계약체결방법
Categorical

Distinct4
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
제한경쟁
261 
수의계약
180 
일반경쟁
55 
지명경쟁
 
1

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique1 ?
Unique (%)0.2%

Sample

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

Common Values

ValueCountFrequency (%)
제한경쟁 261
52.5%
수의계약 180
36.2%
일반경쟁 55
 
11.1%
지명경쟁 1
 
0.2%

Length

2023-12-12T13:26:17.187680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:26:17.301322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제한경쟁 261
52.5%
수의계약 180
36.2%
일반경쟁 55
 
11.1%
지명경쟁 1
 
0.2%

공고기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
한국마사회
497 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row한국마사회
2nd row한국마사회
3rd row한국마사회
4th row한국마사회
5th row한국마사회

Common Values

ValueCountFrequency (%)
한국마사회 497
100.0%

Length

2023-12-12T13:26:17.434169image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:26:17.529897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
한국마사회 497
100.0%

수요기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
한국마사회
497 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row한국마사회
2nd row한국마사회
3rd row한국마사회
4th row한국마사회
5th row한국마사회

Common Values

ValueCountFrequency (%)
한국마사회 497
100.0%

Length

2023-12-12T13:26:17.635477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:26:17.743267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
한국마사회 497
100.0%

입찰개시일자
Date

Distinct240
Distinct (%)48.3%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
Minimum2022-01-19 00:00:00
Maximum2023-09-27 00:00:00
2023-12-12T13:26:17.859598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:26:18.063067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

입찰개시시각
Date

Distinct11
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
Minimum2023-12-12 10:00:00
Maximum2023-12-12 19:00:00
2023-12-12T13:26:18.223800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:26:18.382009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)

입찰결과구분명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
완료(낙찰)
497 

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 (%)
완료(낙찰) 497
100.0%

Length

2023-12-12T13:26:18.522882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:26:18.618496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
완료(낙찰 497
100.0%

Interactions

2023-12-12T13:26:14.512289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T13:26:18.679779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
입찰공고번호업무구분명계약체결형태계약체결방법입찰개시시각
입찰공고번호1.0000.1520.2650.0270.438
업무구분명0.1521.0000.6200.4980.645
계약체결형태0.2650.6201.0000.3350.523
계약체결방법0.0270.4980.3351.0000.487
입찰개시시각0.4380.6450.5230.4871.000
2023-12-12T13:26:18.790893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
계약체결방법계약체결형태업무구분명
계약체결방법1.0000.3230.426
계약체결형태0.3231.0000.576
업무구분명0.4260.5761.000
2023-12-12T13:26:18.883049image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
입찰공고번호업무구분명계약체결형태계약체결방법
입찰공고번호1.0000.1140.0860.032
업무구분명0.1141.0000.5760.426
계약체결형태0.0860.5761.0000.323
계약체결방법0.0320.4260.3231.000

Missing values

2023-12-12T13:26:14.653342image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T13:26:14.818460image/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

입찰공고번호입찰공고명업무구분명계약체결형태계약체결방법공고기관명수요기관명입찰개시일자입찰개시시각입찰결과구분명
020220204402022년 상반기 수입조사료 티모시 구매물품구매단가계약일반경쟁한국마사회한국마사회2022-03-2514:00완료(낙찰)
120220300502022년 장수목장 초지관리용 화학비료 구매물품구매총액계약수의계약한국마사회한국마사회2022-03-1111:00완료(낙찰)
22022030190제주경마공원 노후 도로 재포장 공사시설공사총액계약제한경쟁한국마사회한국마사회2022-03-1713:00완료(낙찰)
32022030740서울경마장 합숙소 출입문 구매 교체물품구매총액계약제한경쟁한국마사회한국마사회2022-04-0211:00완료(낙찰)
42023031280분당지사 주출입구 캐노피 보수공사시설공사총액계약제한경쟁한국마사회한국마사회2023-04-0511:00완료(낙찰)
52023030730서울경마공원 새벽조교 응급구호 전담동물병원 운영일반용역총액계약제한경쟁한국마사회한국마사회2023-03-3015:00완료(낙찰)
62023030710제주목장 배합사료 연간구매물품구매단가계약제한경쟁한국마사회한국마사회2023-03-3116:00완료(낙찰)
720230400302023년 렛츠런파크 부산경남 썸즈업(Thumbs Up) 워터페스티벌 대행용역일반용역총액계약제한경쟁한국마사회한국마사회2023-04-1916:00완료(낙찰)
82022120050영천경마공원 건설공사 건설폐기물(폐합성수지) 처리용역일반용역총액계약일반경쟁한국마사회한국마사회2022-12-1411:00완료(낙찰)
92022120110밀폐공간 구조장비 구매물품구매총액계약수의계약한국마사회한국마사회2022-12-0917:00완료(낙찰)
입찰공고번호입찰공고명업무구분명계약체결형태계약체결방법공고기관명수요기관명입찰개시일자입찰개시시각입찰결과구분명
4872023040440실내승마장 대형환풍기 구매물품구매총액계약수의계약한국마사회한국마사회2023-04-2114:00완료(낙찰)
4882023040450말 수장대 자동문 설치물품구매총액계약수의계약한국마사회한국마사회2023-04-2114:00완료(낙찰)
4892023090090서울경마공원 정문 전광판 구매물품구매총액계약수의계약한국마사회한국마사회2023-09-1814:00완료(낙찰)
4902023090190제주목장 합숙소 환경개선공사시설공사총액계약제한경쟁한국마사회한국마사회2023-09-1511:00완료(낙찰)
49120230802702023년 서울경마공원 승강기 유지관리용역일반용역총액계약제한경쟁한국마사회한국마사회2023-08-3116:00완료(낙찰)
4922023060230유휴자산 효율화 방안 연구용역(재공고)일반용역일반경쟁한국마사회한국마사회2023-06-2015:00완료(낙찰)
4932023060300부산경남경마공원 관람대 프리미엄 전동기 설치공사시설공사총액계약제한경쟁한국마사회한국마사회2023-06-2115:00완료(낙찰)
4942023070150콘텐츠 제작 CG장비 구매물품구매총액계약수의계약한국마사회한국마사회2023-07-2214:00완료(낙찰)
4952023070240제주경마공원 영상감시장치 설치공사시설공사총액계약제한경쟁한국마사회한국마사회2023-07-2711:00완료(낙찰)
4962023070440서울경마공원 마사지역 도로 재포장 공사시설공사총액계약제한경쟁한국마사회한국마사회2023-08-0411:00완료(낙찰)

Duplicate rows

Most frequently occurring

입찰공고번호입찰공고명업무구분명계약체결형태계약체결방법공고기관명수요기관명입찰개시일자입찰개시시각입찰결과구분명# duplicates
02022030430제주 말관계자 숙소 불용집기 매각매각일반경쟁한국마사회한국마사회2022-03-2515:00완료(낙찰)2