Overview

Dataset statistics

Number of variables6
Number of observations3246
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory158.6 KiB
Average record size in memory50.0 B

Variable types

Categorical2
Numeric2
Text1
DateTime1

Dataset

Description한국남부발전(주)_계약 체결 현황에 대한 데이터로 계약구분, 사업소, 계약명, 계약일자 등의 항목을 제공합니다.
URLhttps://www.data.go.kr/data/15095366/fileData.do

Alerts

일련번호 is highly overall correlated with 구분High correlation
구분 is highly overall correlated with 일련번호High correlation
계약금액 is highly skewed (γ1 = 20.18408499)Skewed
일련번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 10:04:20.514449
Analysis finished2023-12-12 10:04:21.931261
Duration1.42 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size25.5 KiB
구매입찰정보
1732 
공사용역입찰정보
1514 

Length

Max length8
Median length6
Mean length6.9328404
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row구매입찰정보
2nd row구매입찰정보
3rd row구매입찰정보
4th row구매입찰정보
5th row구매입찰정보

Common Values

ValueCountFrequency (%)
구매입찰정보 1732
53.4%
공사용역입찰정보 1514
46.6%

Length

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

Common Values (Plot)

2023-12-12T19:04:22.133083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
구매입찰정보 1732
53.4%
공사용역입찰정보 1514
46.6%

일련번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct3246
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1623.5
Minimum1
Maximum3246
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size28.7 KiB
2023-12-12T19:04:22.265531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile163.25
Q1812.25
median1623.5
Q32434.75
95-th percentile3083.75
Maximum3246
Range3245
Interquartile range (IQR)1622.5

Descriptive statistics

Standard deviation937.18381
Coefficient of variation (CV)0.57726136
Kurtosis-1.2
Mean1623.5
Median Absolute Deviation (MAD)811.5
Skewness0
Sum5269881
Variance878313.5
MonotonicityStrictly increasing
2023-12-12T19:04:22.402462image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
2169 1
 
< 0.1%
2159 1
 
< 0.1%
2160 1
 
< 0.1%
2161 1
 
< 0.1%
2162 1
 
< 0.1%
2163 1
 
< 0.1%
2164 1
 
< 0.1%
2165 1
 
< 0.1%
2166 1
 
< 0.1%
Other values (3236) 3236
99.7%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
3246 1
< 0.1%
3245 1
< 0.1%
3244 1
< 0.1%
3243 1
< 0.1%
3242 1
< 0.1%
3241 1
< 0.1%
3240 1
< 0.1%
3239 1
< 0.1%
3238 1
< 0.1%
3237 1
< 0.1%

사업소
Categorical

Distinct11
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size25.5 KiB
하동빛드림본부
1060 
삼척빛드림본부
678 
남제주빛드림본부
380 
조달협력처
374 
신인천빛드림본부
262 
Other values (6)
492 

Length

Max length11
Median length7
Mean length6.9904498
Min length5

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row하동빛드림본부
2nd row부산빛드림본부
3rd row하동빛드림본부
4th row삼척빛드림본부
5th row하동빛드림본부

Common Values

ValueCountFrequency (%)
하동빛드림본부 1060
32.7%
삼척빛드림본부 678
20.9%
남제주빛드림본부 380
 
11.7%
조달협력처 374
 
11.5%
신인천빛드림본부 262
 
8.1%
부산빛드림본부 227
 
7.0%
영월빛드림본부 123
 
3.8%
안동빛드림본부 95
 
2.9%
신세종빛드림본부 36
 
1.1%
신재생빛드림권역사업실 10
 
0.3%

Length

2023-12-12T19:04:22.556416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
하동빛드림본부 1060
32.7%
삼척빛드림본부 678
20.9%
남제주빛드림본부 380
 
11.7%
조달협력처 374
 
11.5%
신인천빛드림본부 262
 
8.1%
부산빛드림본부 227
 
7.0%
영월빛드림본부 123
 
3.8%
안동빛드림본부 95
 
2.9%
신세종빛드림본부 36
 
1.1%
신재생빛드림권역사업실 10
 
0.3%

계약명
Text

Distinct3200
Distinct (%)98.6%
Missing0
Missing (%)0.0%
Memory size25.5 KiB
2023-12-12T19:04:22.819798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length68
Median length49
Mean length28.044978
Min length8

Characters and Unicode

Total characters91034
Distinct characters568
Distinct categories13 ?
Distinct scripts4 ?
Distinct blocks6 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique3159 ?
Unique (%)97.3%

Sample

1st row하동 4호기 계획예방정비공사 계측제어설비 30일 자재 구매계약
2nd row부산 2020년도 발전기 냉각 및 NG치환용 GAS류 단가계약
3rd row하동 1~8호기 주급수펌프 BFP Mechanical Seal 단가계약(2년)
4th row삼척 환경농도 측정기 설치조건부 추가 구매
5th row하동 2020년 7호기 계획예방정비 터빈분야 일반자재 구매
ValueCountFrequency (%)
구매 1116
 
5.9%
하동 979
 
5.2%
삼척 383
 
2.0%
및 342
 
1.8%
용역 317
 
1.7%
설치조건부 257
 
1.4%
보일러 193
 
1.0%
단가계약 189
 
1.0%
제작구매 182
 
1.0%
2호기 178
 
0.9%
Other values (4032) 14631
78.0%
2023-12-12T19:04:23.239712image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
15528
 
17.1%
기 2340
 
2.6%
2 1923
 
2.1%
구 1763
 
1.9%
비 1655
 
1.8%
매 1622
 
1.8%
사 1438
 
1.6%
공 1388
 
1.5%
설 1378
 
1.5%
동 1318
 
1.4%
Other values (558) 60681
66.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 55100
60.5%
Space Separator 15528
 
17.1%
Lowercase Letter 7452
 
8.2%
Uppercase Letter 5638
 
6.2%
Decimal Number 4778
 
5.2%
Other Punctuation 760
 
0.8%
Open Punctuation 558
 
0.6%
Close Punctuation 558
 
0.6%
Math Symbol 287
 
0.3%
Connector Punctuation 195
 
0.2%
Other values (3) 180
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 2340
 
4.2%
구 1763
 
3.2%
비 1655
 
3.0%
매 1622
 
2.9%
사 1438
 
2.6%
공 1388
 
2.5%
설 1378
 
2.5%
동 1318
 
2.4%
전 1176
 
2.1%
하 1148
 
2.1%
Other values (475) 39874
72.4%
Uppercase Letter
ValueCountFrequency (%)
S 701
12.4%
C 588
 
10.4%
T 482
 
8.5%
P 460
 
8.2%
B 425
 
7.5%
A 328
 
5.8%
H 297
 
5.3%
R 295
 
5.2%
G 294
 
5.2%
O 233
 
4.1%
Other values (16) 1535
27.2%
Lowercase Letter
ValueCountFrequency (%)
e 1023
13.7%
a 717
9.6%
r 709
9.5%
l 606
 
8.1%
t 578
 
7.8%
i 549
 
7.4%
o 537
 
7.2%
n 506
 
6.8%
u 269
 
3.6%
s 258
 
3.5%
Other values (15) 1700
22.8%
Decimal Number
ValueCountFrequency (%)
2 1923
40.2%
1 863
18.1%
0 813
17.0%
3 278
 
5.8%
8 240
 
5.0%
4 216
 
4.5%
5 155
 
3.2%
6 143
 
3.0%
7 103
 
2.2%
9 44
 
0.9%
Other Punctuation
ValueCountFrequency (%)
, 349
45.9%
# 176
23.2%
/ 63
 
8.3%
& 58
 
7.6%
; 58
 
7.6%
· 41
 
5.4%
. 10
 
1.3%
% 3
 
0.4%
! 1
 
0.1%
: 1
 
0.1%
Math Symbol
ValueCountFrequency (%)
~ 283
98.6%
∼ 3
 
1.0%
× 1
 
0.3%
Open Punctuation
ValueCountFrequency (%)
( 536
96.1%
[ 22
 
3.9%
Close Punctuation
ValueCountFrequency (%)
) 536
96.1%
] 22
 
3.9%
Space Separator
ValueCountFrequency (%)
15528
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 195
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 178
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 1
100.0%
Other Symbol
ValueCountFrequency (%)
㎟ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 55097
60.5%
Common 22844
25.1%
Latin 13090
 
14.4%
Han 3
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 2340
 
4.2%
구 1763
 
3.2%
비 1655
 
3.0%
매 1622
 
2.9%
사 1438
 
2.6%
공 1388
 
2.5%
설 1378
 
2.5%
동 1318
 
2.4%
전 1176
 
2.1%
하 1148
 
2.1%
Other values (472) 39871
72.4%
Latin
ValueCountFrequency (%)
e 1023
 
7.8%
a 717
 
5.5%
r 709
 
5.4%
S 701
 
5.4%
l 606
 
4.6%
C 588
 
4.5%
t 578
 
4.4%
i 549
 
4.2%
o 537
 
4.1%
n 506
 
3.9%
Other values (41) 6576
50.2%
Common
ValueCountFrequency (%)
15528
68.0%
2 1923
 
8.4%
1 863
 
3.8%
0 813
 
3.6%
( 536
 
2.3%
) 536
 
2.3%
, 349
 
1.5%
~ 283
 
1.2%
3 278
 
1.2%
8 240
 
1.1%
Other values (22) 1495
 
6.5%
Han
ValueCountFrequency (%)
形 1
33.3%
舊 1
33.3%
新 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 55097
60.5%
ASCII 35888
39.4%
None 42
 
< 0.1%
Math Operators 3
 
< 0.1%
CJK 3
 
< 0.1%
CJK Compat 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
15528
43.3%
2 1923
 
5.4%
e 1023
 
2.9%
1 863
 
2.4%
0 813
 
2.3%
a 717
 
2.0%
r 709
 
2.0%
S 701
 
2.0%
l 606
 
1.7%
C 588
 
1.6%
Other values (69) 12417
34.6%
Hangul
ValueCountFrequency (%)
기 2340
 
4.2%
구 1763
 
3.2%
비 1655
 
3.0%
매 1622
 
2.9%
사 1438
 
2.6%
공 1388
 
2.5%
설 1378
 
2.5%
동 1318
 
2.4%
전 1176
 
2.1%
하 1148
 
2.1%
Other values (472) 39871
72.4%
None
ValueCountFrequency (%)
· 41
97.6%
× 1
 
2.4%
Math Operators
ValueCountFrequency (%)
∼ 3
100.0%
CJK
ValueCountFrequency (%)
形 1
33.3%
舊 1
33.3%
新 1
33.3%
CJK Compat
ValueCountFrequency (%)
㎟ 1
100.0%

계약일자
Date

Distinct803
Distinct (%)24.7%
Missing0
Missing (%)0.0%
Memory size25.5 KiB
Minimum2020-01-02 00:00:00
Maximum2023-06-30 00:00:00
2023-12-12T19:04:23.365090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:04:23.500366image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

계약금액
Real number (ℝ)

SKEWED 

Distinct3179
Distinct (%)97.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7.1722951 × 108
Minimum0
Maximum1.6112916 × 1011
Zeros1
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size28.7 KiB
2023-12-12T19:04:23.623466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile22148190
Q151468520
median1.07999 × 108
Q33.1674575 × 108
95-th percentile1.8514406 × 109
Maximum1.6112916 × 1011
Range1.6112916 × 1011
Interquartile range (IQR)2.6527723 × 108

Descriptive statistics

Standard deviation4.9131706 × 109
Coefficient of variation (CV)6.850207
Kurtosis505.64732
Mean7.1722951 × 108
Median Absolute Deviation (MAD)74719674
Skewness20.184085
Sum2.328127 × 1012
Variance2.4139246 × 1019
MonotonicityNot monotonic
2023-12-12T19:04:23.763238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99000000 4
 
0.1%
39600000 4
 
0.1%
92400000 4
 
0.1%
187000000 3
 
0.1%
77000000 3
 
0.1%
47300000 3
 
0.1%
184800000 3
 
0.1%
297000000 3
 
0.1%
660000000 3
 
0.1%
66528000 2
 
0.1%
Other values (3169) 3214
99.0%
ValueCountFrequency (%)
0 1
< 0.1%
18600 1
< 0.1%
31000 1
< 0.1%
79590 1
< 0.1%
4280100 1
< 0.1%
6523000 1
< 0.1%
9150460 1
< 0.1%
9970675 1
< 0.1%
10173980 1
< 0.1%
10187440 1
< 0.1%
ValueCountFrequency (%)
161129161600 1
< 0.1%
96963570000 1
< 0.1%
94710000000 1
< 0.1%
90156000000 1
< 0.1%
71161721400 1
< 0.1%
67737890000 1
< 0.1%
60248169295 1
< 0.1%
55154000000 1
< 0.1%
32023381000 1
< 0.1%
27434726990 1
< 0.1%

Interactions

2023-12-12T19:04:21.441139image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:04:21.185170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:04:21.553773image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:04:21.323461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T19:04:23.867574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분일련번호사업소계약금액
구분1.0000.9970.2070.041
일련번호0.9971.0000.3140.040
사업소0.2070.3141.0000.259
계약금액0.0410.0400.2591.000
2023-12-12T19:04:23.956724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분사업소
구분1.0000.198
사업소0.1981.000
2023-12-12T19:04:24.043075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호계약금액구분사업소
일련번호1.0000.0690.9530.139
계약금액0.0691.0000.0440.131
구분0.9530.0441.0000.198
사업소0.1390.1310.1981.000

Missing values

2023-12-12T19:04:21.736064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:04:21.878817image/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구매입찰정보1하동빛드림본부하동 4호기 계획예방정비공사 계측제어설비 30일 자재 구매계약2020-01-0275570840
1구매입찰정보2부산빛드림본부부산 2020년도 발전기 냉각 및 NG치환용 GAS류 단가계약2020-01-0277163130
2구매입찰정보3하동빛드림본부하동 1~8호기 주급수펌프 BFP Mechanical Seal 단가계약(2년)2020-01-03211200000
3구매입찰정보4삼척빛드림본부삼척 환경농도 측정기 설치조건부 추가 구매2020-01-03265325792
4구매입찰정보5하동빛드림본부하동 2020년 7호기 계획예방정비 터빈분야 일반자재 구매2020-01-0941454330
5구매입찰정보6하동빛드림본부하동 주변 환경측정소 신규설치 및 노후계기 교체 설치조건부 구매2020-01-10613450000
6구매입찰정보7남제주빛드림본부2019년 남제주·한림 환경화학 자재그룹(85품목) 구매2020-01-10178244000
7구매입찰정보8하동빛드림본부하동 7호기 계획예방정비 보일러 및 미분탄설비 일반자재 구매2020-01-1373830570
8구매입찰정보9삼척빛드림본부STM Trap Controller Set 구매2020-01-1439699995
9구매입찰정보10조달협력처IP 전화기 114대 구매2020-01-1538162104
구분일련번호사업소계약명계약일자계약금액
3236공사용역입찰정보3237조달협력처2023년 발전소 건축물 내진성능평가 검증 용역2023-06-1516650000
3237공사용역입찰정보3238조달협력처익산 다송리 태양광 공사·안전 감리용역2023-06-1565697690
3238공사용역입찰정보3239부산빛드림본부[부산] 소내승강기 점검 및 정비 위탁용역2023-06-1935674300
3239공사용역입찰정보3240삼척빛드림본부삼척빛드림본부 사업장폐기물(폐합성수지) 재활용 위탁 처리용역2023-06-20124640000
3240공사용역입찰정보3241삼척빛드림본부삼척빛드림본부 사업장폐기물(SCR폐촉매) 재활용 위탁 처리용역2023-06-21149292000
3241공사용역입찰정보3242조달협력처2023년 한국남부발전 소셜미디어(SNS) 운영·관리 용역2023-06-22114700000
3242공사용역입찰정보3243하동빛드림본부하동 2023년도 사업장폐기물(폐합성수지류 등) 재활용 위탁처리용역 단가계약2023-06-22172314830
3243공사용역입찰정보3244조달협력처2023년도 내부회계관리제도 운영실태 점검 용역2023-06-27187000000
3244공사용역입찰정보3245삼척빛드림본부2023 삼척빛드림본부 항온항습기 유지보수 용역2023-06-2991850000
3245공사용역입찰정보3246조달협력처2023년도 KOSPO 안전관리등급평가 용역2023-06-30174757000