Overview

Dataset statistics

Number of variables7
Number of observations440
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory25.1 KiB
Average record size in memory58.3 B

Variable types

Numeric2
Text1
Categorical1
DateTime3

Dataset

Description한국지역난방공사 플랜트관리시스템 내에서 관리 중인 용역계약에 대한 데이터로 용역번호, 계약명, 지사명, 용역금액, 계약시작 및 종료일, 등록일자를 제공합니다.
Author한국지역난방공사
URLhttps://www.data.go.kr/data/15124218/fileData.do

Alerts

용역번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:56:37.602862
Analysis finished2023-12-12 14:56:38.587722
Duration0.98 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

용역번호
Real number (ℝ)

UNIQUE 

Distinct440
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11732.786
Minimum10196
Maximum13211
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.0 KiB
2023-12-12T23:56:38.672801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10196
5-th percentile10632.4
Q111022.75
median11680.5
Q312459.25
95-th percentile13090
Maximum13211
Range3015
Interquartile range (IQR)1436.5

Descriptive statistics

Standard deviation796.45323
Coefficient of variation (CV)0.067882701
Kurtosis-1.1273352
Mean11732.786
Median Absolute Deviation (MAD)674
Skewness0.18008691
Sum5162426
Variance634337.75
MonotonicityNot monotonic
2023-12-12T23:56:38.845469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
10196 1
 
0.2%
12169 1
 
0.2%
12207 1
 
0.2%
12195 1
 
0.2%
12196 1
 
0.2%
12194 1
 
0.2%
12193 1
 
0.2%
12160 1
 
0.2%
12173 1
 
0.2%
12183 1
 
0.2%
Other values (430) 430
97.7%
ValueCountFrequency (%)
10196 1
0.2%
10215 1
0.2%
10273 1
0.2%
10314 1
0.2%
10316 1
0.2%
10320 1
0.2%
10323 1
0.2%
10326 1
0.2%
10331 1
0.2%
10373 1
0.2%
ValueCountFrequency (%)
13211 1
0.2%
13205 1
0.2%
13201 1
0.2%
13187 1
0.2%
13183 1
0.2%
13176 1
0.2%
13172 1
0.2%
13171 1
0.2%
13168 1
0.2%
13156 1
0.2%

계약명
Text

Distinct432
Distinct (%)98.2%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
2023-12-12T23:56:39.102231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length42
Median length37
Mean length26.347727
Min length15

Characters and Unicode

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

Unique

Unique424 ?
Unique (%)96.4%

Sample

1st row2016년도 무정전 전원공급설비 유지보수용역
2nd row2016년도 서울중앙지사 운전정보통신설비 유지보수 용역
3rd row2016년 상암CES 열공급시설 승강기 유지보수용역
4th row제어시스템 보안 취약점 개선 용역
5th row2016년 상암열원 전기설비 보호계전기 점검용역
ValueCountFrequency (%)
용역 218
 
9.7%
유지보수용역 156
 
7.0%
및 61
 
2.7%
유지보수 49
 
2.2%
2017년 49
 
2.2%
점검용역 41
 
1.8%
2017년도 40
 
1.8%
무정전 39
 
1.7%
전원공급설비 39
 
1.7%
냉난방설비 34
 
1.5%
Other values (342) 1514
67.6%
2023-12-12T23:56:39.925814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1803
 
15.6%
2 582
 
5.0%
지 471
 
4.1%
용 459
 
4.0%
역 445
 
3.8%
0 434
 
3.7%
년 366
 
3.2%
1 306
 
2.6%
사 301
 
2.6%
유 295
 
2.5%
Other values (265) 6131
52.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7507
64.8%
Space Separator 1803
 
15.6%
Decimal Number 1595
 
13.8%
Lowercase Letter 333
 
2.9%
Uppercase Letter 258
 
2.2%
Other Punctuation 51
 
0.4%
Math Symbol 24
 
0.2%
Open Punctuation 10
 
0.1%
Close Punctuation 10
 
0.1%
Dash Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
지 471
 
6.3%
용 459
 
6.1%
역 445
 
5.9%
년 366
 
4.9%
사 301
 
4.0%
유 295
 
3.9%
설 259
 
3.5%
수 255
 
3.4%
보 233
 
3.1%
비 202
 
2.7%
Other values (202) 4221
56.2%
Uppercase Letter
ValueCountFrequency (%)
C 48
18.6%
S 39
15.1%
E 26
10.1%
P 23
8.9%
H 21
8.1%
V 19
 
7.4%
D 13
 
5.0%
A 12
 
4.7%
T 10
 
3.9%
G 10
 
3.9%
Other values (11) 37
14.3%
Lowercase Letter
ValueCountFrequency (%)
t 37
11.1%
o 37
11.1%
r 37
11.1%
a 32
9.6%
i 32
9.6%
n 31
9.3%
e 26
7.8%
l 22
6.6%
c 17
 
5.1%
v 14
 
4.2%
Other values (10) 48
14.4%
Decimal Number
ValueCountFrequency (%)
2 582
36.5%
0 434
27.2%
1 306
19.2%
7 97
 
6.1%
8 79
 
5.0%
9 71
 
4.5%
6 10
 
0.6%
3 8
 
0.5%
5 4
 
0.3%
4 4
 
0.3%
Other Punctuation
ValueCountFrequency (%)
/ 17
33.3%
· 14
27.5%
. 11
21.6%
' 5
 
9.8%
# 2
 
3.9%
? 1
 
2.0%
, 1
 
2.0%
Space Separator
ValueCountFrequency (%)
1803
100.0%
Math Symbol
ValueCountFrequency (%)
~ 24
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7507
64.8%
Common 3495
30.1%
Latin 591
 
5.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
지 471
 
6.3%
용 459
 
6.1%
역 445
 
5.9%
년 366
 
4.9%
사 301
 
4.0%
유 295
 
3.9%
설 259
 
3.5%
수 255
 
3.4%
보 233
 
3.1%
비 202
 
2.7%
Other values (202) 4221
56.2%
Latin
ValueCountFrequency (%)
C 48
 
8.1%
S 39
 
6.6%
t 37
 
6.3%
o 37
 
6.3%
r 37
 
6.3%
a 32
 
5.4%
i 32
 
5.4%
n 31
 
5.2%
E 26
 
4.4%
e 26
 
4.4%
Other values (31) 246
41.6%
Common
ValueCountFrequency (%)
1803
51.6%
2 582
 
16.7%
0 434
 
12.4%
1 306
 
8.8%
7 97
 
2.8%
8 79
 
2.3%
9 71
 
2.0%
~ 24
 
0.7%
/ 17
 
0.5%
· 14
 
0.4%
Other values (12) 68
 
1.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7507
64.8%
ASCII 4072
35.1%
None 14
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1803
44.3%
2 582
 
14.3%
0 434
 
10.7%
1 306
 
7.5%
7 97
 
2.4%
8 79
 
1.9%
9 71
 
1.7%
C 48
 
1.2%
S 39
 
1.0%
t 37
 
0.9%
Other values (52) 576
 
14.1%
Hangul
ValueCountFrequency (%)
지 471
 
6.3%
용 459
 
6.1%
역 445
 
5.9%
년 366
 
4.9%
사 301
 
4.0%
유 295
 
3.9%
설 259
 
3.5%
수 255
 
3.4%
보 233
 
3.1%
비 202
 
2.7%
Other values (202) 4221
56.2%
None
ValueCountFrequency (%)
· 14
100.0%

지사명
Categorical

Distinct18
Distinct (%)4.1%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
수원사업소
55 
강남지사
54 
대구지사
52 
분당사업소
34 
청주지사
33 
Other values (13)
212 

Length

Max length6
Median length4
Mean length4.4272727
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row강남지사
2nd row서울중앙지사
3rd row서울중앙지사
4th row강남지사
5th row서울중앙지사

Common Values

ValueCountFrequency (%)
수원사업소 55
12.5%
강남지사 54
12.3%
대구지사 52
11.8%
분당사업소 34
 
7.7%
청주지사 33
 
7.5%
김해사업소 33
 
7.5%
세종지사 30
 
6.8%
서울중앙지사 24
 
5.5%
광교지사 21
 
4.8%
판교지사 19
 
4.3%
Other values (8) 85
19.3%

Length

2023-12-12T23:56:40.086852image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
수원사업소 55
12.5%
강남지사 54
12.3%
대구지사 52
11.8%
분당사업소 34
 
7.7%
청주지사 33
 
7.5%
김해사업소 33
 
7.5%
세종지사 30
 
6.8%
서울중앙지사 24
 
5.5%
광교지사 21
 
4.8%
판교지사 19
 
4.3%
Other values (8) 85
19.3%

용역금액
Real number (ℝ)

Distinct408
Distinct (%)92.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20830952
Minimum1023000
Maximum4.469861 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.0 KiB
2023-12-12T23:56:40.283669image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1023000
5-th percentile1572450
Q13994650
median9625985
Q325890490
95-th percentile47599852
Maximum4.469861 × 108
Range4.459631 × 108
Interquartile range (IQR)21895840

Descriptive statistics

Standard deviation41837675
Coefficient of variation (CV)2.008438
Kurtosis50.297705
Mean20830952
Median Absolute Deviation (MAD)7410950
Skewness6.5291558
Sum9.1656188 × 109
Variance1.750391 × 1015
MonotonicityNot monotonic
2023-12-12T23:56:40.449120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2079000 4
 
0.9%
2893000 4
 
0.9%
2244000 3
 
0.7%
1540000 3
 
0.7%
4840000 3
 
0.7%
4400000 3
 
0.7%
1485000 3
 
0.7%
2860000 3
 
0.7%
2948000 2
 
0.5%
1381600 2
 
0.5%
Other values (398) 410
93.2%
ValueCountFrequency (%)
1023000 1
 
0.2%
1078000 1
 
0.2%
1112925 1
 
0.2%
1254000 1
 
0.2%
1292280 1
 
0.2%
1309000 1
 
0.2%
1336830 1
 
0.2%
1381600 2
0.5%
1430000 1
 
0.2%
1485000 3
0.7%
ValueCountFrequency (%)
446986100 1
0.2%
379252720 1
0.2%
297290415 1
0.2%
274393443 1
0.2%
274121339 1
0.2%
267371500 1
0.2%
253000000 1
0.2%
151800000 1
0.2%
135000000 1
0.2%
99316800 1
0.2%

계약시작일
Date

Distinct355
Distinct (%)80.7%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
Minimum2016-08-10 00:00:00
Maximum2023-05-12 00:00:00
2023-12-12T23:56:40.579587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:56:40.708474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

계약종료일
Date

Distinct355
Distinct (%)80.7%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
Minimum2016-11-22 00:00:00
Maximum2024-04-24 00:00:00
2023-12-12T23:56:40.872694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:56:41.011262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

등록일자
Date

Distinct282
Distinct (%)64.1%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
Minimum2016-07-01 00:00:00
Maximum2023-03-13 00:00:00
2023-12-12T23:56:41.159631image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:56:41.322972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-12T23:56:38.136190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:56:37.925952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:56:38.246882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:56:38.030034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:56:41.413459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
용역번호지사명용역금액
용역번호1.0000.5350.000
지사명0.5351.0000.130
용역금액0.0000.1301.000
2023-12-12T23:56:41.506864image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
용역번호용역금액지사명
용역번호1.000-0.0600.232
용역금액-0.0601.0000.053
지사명0.2320.0531.000

Missing values

2023-12-12T23:56:38.398539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:56:38.539923image/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

용역번호계약명지사명용역금액계약시작일계약종료일등록일자
0101962016년도 무정전 전원공급설비 유지보수용역강남지사390225002016-08-102017-08-092016-07-01
1102152016년도 서울중앙지사 운전정보통신설비 유지보수 용역서울중앙지사297630002016-08-242017-08-232016-07-14
2102732016년 상암CES 열공급시설 승강기 유지보수용역서울중앙지사23694002016-09-092017-09-082016-08-22
310316제어시스템 보안 취약점 개선 용역강남지사118800002016-11-032016-11-222016-09-26
4103202016년 상암열원 전기설비 보호계전기 점검용역서울중앙지사117000002016-11-072016-11-282016-09-28
5103142016년도 서울중앙지사 굴뚝배출가스 측정설비 유지보수용역서울중앙지사371448002016-11-072017-11-062016-09-29
6103262016년도 분당사업소 무정전전원공급설비 유지보수용역분당사업소241938202016-11-192017-11-172016-10-04
7103312016년도 서울남부지사 가스누설감지설비 정기점검 유지보수 용역강남지사74800002016-12-072016-12-262016-10-12
8103232017년 서울중앙지사 무정전 전원공급설비 유지보수용역서울중앙지사338345522016-12-012017-11-302016-10-12
9103732017년도 서울중앙지사 중앙열공급시설 무정전 전원공급설비 유지보수 용역서울중앙지사241585002017-02-152017-12-152016-12-07
용역번호계약명지사명용역금액계약시작일계약종료일등록일자
430131562022년 분당사업소 유량계 교정검사 용역분당사업소39420002022-12-132022-12-302022-11-28
431131712023년 분당사업소 소방시설 점검용역분당사업소112280002023-01-022023-12-292022-12-01
432131682022년도 김해사업소 열 생산 및 공급 계량설비 검교정 용역김해사업소43640002022-12-122022-12-282022-12-01
433131722022년도 평택지사 열계량설비 검교정 용역평택지사12922802022-12-152022-12-312022-12-06
434131762023년 열생산 및 공급유량계 검교정 용역강남지사85336002023-02-132023-03-142022-12-27
435131832023년도 김해사업소 소방시설 점검용역김해사업소56430002023-02-032024-02-022023-01-17
436131872023년 세종지사 소방시설 점검용역세종지사74580002023-03-202024-03-182023-02-08
437132012023년 세종지사 무정전 전원공급설비 유지보수용역세종지사170263002023-04-052024-04-032023-03-02
43813205일원열원 증설터빈 Governor Valve 구동부 보수 및 정밀점검 용역강남지사125180002023-05-012023-05-262023-03-09
43913211수원사업소 Turbine E/H Actuator 정밀점검 용역수원사업소93443902023-05-122023-06-092023-03-13