Overview

Dataset statistics

Number of variables7
Number of observations1474
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory83.6 KiB
Average record size in memory58.1 B

Variable types

Numeric2
Text1
Categorical1
DateTime3

Dataset

Description한국지역난방공사의 플랜트관리시스템에서 관리하는 유지보수 공사에 대한 데이터로 공사번호, 계약명, 지사명, 공사금액, 계약시작 및 종료일, 시스템 등록일자를 확인 할 수 있습니다.
Author한국지역난방공사
URLhttps://www.data.go.kr/data/15124214/fileData.do

Alerts

공사번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 09:14:54.716253
Analysis finished2023-12-12 09:14:55.842576
Duration1.13 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

공사번호
Real number (ℝ)

UNIQUE 

Distinct1474
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11644.694
Minimum10030
Maximum13276
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size13.1 KiB
2023-12-12T18:14:55.914140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10030
5-th percentile10319.65
Q110955.5
median11595
Q312349.5
95-th percentile13047.4
Maximum13276
Range3246
Interquartile range (IQR)1394

Descriptive statistics

Standard deviation850.44175
Coefficient of variation (CV)0.073032554
Kurtosis-1.0238134
Mean11644.694
Median Absolute Deviation (MAD)681.5
Skewness0.10589896
Sum17164279
Variance723251.17
MonotonicityNot monotonic
2023-12-12T18:14:56.043692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
10030 1
 
0.1%
12114 1
 
0.1%
11932 1
 
0.1%
12131 1
 
0.1%
12130 1
 
0.1%
12128 1
 
0.1%
12126 1
 
0.1%
12122 1
 
0.1%
12121 1
 
0.1%
12120 1
 
0.1%
Other values (1464) 1464
99.3%
ValueCountFrequency (%)
10030 1
0.1%
10033 1
0.1%
10038 1
0.1%
10040 1
0.1%
10042 1
0.1%
10043 1
0.1%
10047 1
0.1%
10057 1
0.1%
10062 1
0.1%
10075 1
0.1%
ValueCountFrequency (%)
13276 1
0.1%
13275 1
0.1%
13271 1
0.1%
13267 1
0.1%
13264 1
0.1%
13255 1
0.1%
13250 1
0.1%
13247 1
0.1%
13246 1
0.1%
13245 1
0.1%

계약명
Text

Distinct1449
Distinct (%)98.3%
Missing0
Missing (%)0.0%
Memory size11.6 KiB
2023-12-12T18:14:56.281377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length50
Median length41
Mean length25.328358
Min length9

Characters and Unicode

Total characters37334
Distinct characters425
Distinct categories12 ?
Distinct scripts3 ?
Distinct blocks5 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1426 ?
Unique (%)96.7%

Sample

1st row2016년 열원시설 제어설비 정기점검보수공사
2nd row분당열원 공기조화기 난방코일 교체공사
3rd row2016년 열원시설 전산설비 정기점검보수공사
4th row2016년도 수원사업소 ABB 분산제어설비 정기점검 보수공사
5th row2016년도 수원사업소 에머슨 분산제어설비 정기점검보수공사
ValueCountFrequency (%)
보수공사 248
 
3.5%
정기점검보수공사 238
 
3.3%
용역 218
 
3.0%
정기점검 174
 
2.4%
및 173
 
2.4%
유지보수용역 156
 
2.2%
분산제어설비 104
 
1.5%
2017년 103
 
1.4%
공사 89
 
1.2%
2017년도 85
 
1.2%
Other values (1369) 5561
77.8%
2023-12-12T18:14:56.652950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5683
 
15.2%
사 1766
 
4.7%
2 1333
 
3.6%
공 1235
 
3.3%
수 1028
 
2.8%
기 973
 
2.6%
0 970
 
2.6%
보 935
 
2.5%
설 913
 
2.4%
지 899
 
2.4%
Other values (415) 21599
57.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 25201
67.5%
Space Separator 5683
 
15.2%
Decimal Number 3655
 
9.8%
Uppercase Letter 1293
 
3.5%
Lowercase Letter 1013
 
2.7%
Other Punctuation 239
 
0.6%
Close Punctuation 102
 
0.3%
Open Punctuation 102
 
0.3%
Math Symbol 27
 
0.1%
Dash Punctuation 17
 
< 0.1%
Other values (2) 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 1766
 
7.0%
공 1235
 
4.9%
수 1028
 
4.1%
기 973
 
3.9%
보 935
 
3.7%
설 913
 
3.6%
지 899
 
3.6%
년 839
 
3.3%
정 700
 
2.8%
검 621
 
2.5%
Other values (337) 15292
60.7%
Uppercase Letter
ValueCountFrequency (%)
C 163
12.6%
S 151
11.7%
P 131
10.1%
E 111
 
8.6%
L 99
 
7.7%
D 83
 
6.4%
H 77
 
6.0%
B 69
 
5.3%
T 62
 
4.8%
G 49
 
3.8%
Other values (13) 298
23.0%
Lowercase Letter
ValueCountFrequency (%)
i 107
10.6%
t 99
9.8%
a 96
9.5%
o 94
9.3%
e 85
 
8.4%
r 83
 
8.2%
n 82
 
8.1%
l 70
 
6.9%
c 45
 
4.4%
u 34
 
3.4%
Other values (13) 218
21.5%
Decimal Number
ValueCountFrequency (%)
2 1333
36.5%
0 970
26.5%
1 709
19.4%
7 198
 
5.4%
8 167
 
4.6%
9 148
 
4.0%
3 59
 
1.6%
6 48
 
1.3%
4 15
 
0.4%
5 8
 
0.2%
Other Punctuation
ValueCountFrequency (%)
# 101
42.3%
/ 52
21.8%
, 33
 
13.8%
. 23
 
9.6%
· 19
 
7.9%
' 6
 
2.5%
? 3
 
1.3%
& 2
 
0.8%
Close Punctuation
ValueCountFrequency (%)
) 98
96.1%
』 2
 
2.0%
] 1
 
1.0%
」 1
 
1.0%
Open Punctuation
ValueCountFrequency (%)
( 98
96.1%
『 2
 
2.0%
[ 1
 
1.0%
「 1
 
1.0%
Math Symbol
ValueCountFrequency (%)
~ 25
92.6%
→ 2
 
7.4%
Space Separator
ValueCountFrequency (%)
5683
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 17
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 1
100.0%
Final Punctuation
ValueCountFrequency (%)
’ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 25201
67.5%
Common 9827
 
26.3%
Latin 2306
 
6.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 1766
 
7.0%
공 1235
 
4.9%
수 1028
 
4.1%
기 973
 
3.9%
보 935
 
3.7%
설 913
 
3.6%
지 899
 
3.6%
년 839
 
3.3%
정 700
 
2.8%
검 621
 
2.5%
Other values (337) 15292
60.7%
Latin
ValueCountFrequency (%)
C 163
 
7.1%
S 151
 
6.5%
P 131
 
5.7%
E 111
 
4.8%
i 107
 
4.6%
t 99
 
4.3%
L 99
 
4.3%
a 96
 
4.2%
o 94
 
4.1%
e 85
 
3.7%
Other values (36) 1170
50.7%
Common
ValueCountFrequency (%)
5683
57.8%
2 1333
 
13.6%
0 970
 
9.9%
1 709
 
7.2%
7 198
 
2.0%
8 167
 
1.7%
9 148
 
1.5%
# 101
 
1.0%
) 98
 
1.0%
( 98
 
1.0%
Other values (22) 322
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 25201
67.5%
ASCII 12105
32.4%
None 25
 
0.1%
Arrows 2
 
< 0.1%
Punctuation 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5683
46.9%
2 1333
 
11.0%
0 970
 
8.0%
1 709
 
5.9%
7 198
 
1.6%
8 167
 
1.4%
C 163
 
1.3%
S 151
 
1.2%
9 148
 
1.2%
P 131
 
1.1%
Other values (61) 2452
20.3%
Hangul
ValueCountFrequency (%)
사 1766
 
7.0%
공 1235
 
4.9%
수 1028
 
4.1%
기 973
 
3.9%
보 935
 
3.7%
설 913
 
3.6%
지 899
 
3.6%
년 839
 
3.3%
정 700
 
2.8%
검 621
 
2.5%
Other values (337) 15292
60.7%
None
ValueCountFrequency (%)
· 19
76.0%
『 2
 
8.0%
』 2
 
8.0%
「 1
 
4.0%
」 1
 
4.0%
Arrows
ValueCountFrequency (%)
→ 2
100.0%
Punctuation
ValueCountFrequency (%)
’ 1
100.0%

지사명
Categorical

Distinct19
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size11.6 KiB
대구지사
177 
수원사업소
172 
분당사업소
159 
강남지사
133 
광교지사
112 
Other values (14)
721 

Length

Max length6
Median length4
Mean length4.436228
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대구지사
2nd row분당사업소
3rd row대구지사
4th row수원사업소
5th row수원사업소

Common Values

ValueCountFrequency (%)
대구지사 177
12.0%
수원사업소 172
11.7%
분당사업소 159
10.8%
강남지사 133
9.0%
광교지사 112
 
7.6%
김해사업소 93
 
6.3%
세종지사 89
 
6.0%
판교지사 77
 
5.2%
청주지사 77
 
5.2%
파주지사 75
 
5.1%
Other values (9) 310
21.0%

Length

2023-12-12T18:14:56.775006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
대구지사 177
12.0%
수원사업소 172
11.7%
분당사업소 159
10.8%
강남지사 133
9.0%
광교지사 112
 
7.6%
김해사업소 93
 
6.3%
세종지사 89
 
6.0%
판교지사 77
 
5.2%
청주지사 77
 
5.2%
파주지사 75
 
5.1%
Other values (9) 310
21.0%

공사금액
Real number (ℝ)

Distinct1242
Distinct (%)84.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean73162953
Minimum580000
Maximum5.69283 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size13.1 KiB
2023-12-12T18:14:56.886998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum580000
5-th percentile2202860
Q16671142.5
median9790000
Q331301545
95-th percentile2.9207604 × 108
Maximum5.69283 × 109
Range5.69225 × 109
Interquartile range (IQR)24630402

Descriptive statistics

Standard deviation2.9879817 × 108
Coefficient of variation (CV)4.0840092
Kurtosis150.3696
Mean73162953
Median Absolute Deviation (MAD)6490000
Skewness10.363016
Sum1.0784219 × 1011
Variance8.9280348 × 1016
MonotonicityNot monotonic
2023-12-12T18:14:57.032296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
9900000 12
 
0.8%
9680000 11
 
0.7%
9350000 11
 
0.7%
9240000 9
 
0.6%
8250000 8
 
0.5%
8800000 7
 
0.5%
9460000 7
 
0.5%
7700000 6
 
0.4%
9020000 6
 
0.4%
6600000 6
 
0.4%
Other values (1232) 1391
94.4%
ValueCountFrequency (%)
580000 1
0.1%
1023000 1
0.1%
1078000 1
0.1%
1112925 1
0.1%
1254000 1
0.1%
1292280 1
0.1%
1309000 1
0.1%
1336830 1
0.1%
1381600 2
0.1%
1390000 1
0.1%
ValueCountFrequency (%)
5692830000 1
0.1%
5023618600 1
0.1%
2400210120 1
0.1%
2375164000 1
0.1%
2275515000 1
0.1%
2224300000 1
0.1%
2200000000 1
0.1%
2072252600 1
0.1%
2031848500 1
0.1%
1647250000 1
0.1%

계약시작일
Date

Distinct822
Distinct (%)55.8%
Missing0
Missing (%)0.0%
Memory size11.6 KiB
Minimum2016-04-20 00:00:00
Maximum2023-07-10 00:00:00
2023-12-12T18:14:57.182239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:14:57.301244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

계약종료일
Date

Distinct847
Distinct (%)57.5%
Missing0
Missing (%)0.0%
Memory size11.6 KiB
Minimum2016-04-27 00:00:00
Maximum2024-04-24 00:00:00
2023-12-12T18:14:57.430773image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:14:57.551990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

등록일자
Date

Distinct745
Distinct (%)50.5%
Missing0
Missing (%)0.0%
Memory size11.6 KiB
Minimum2016-03-28 00:00:00
Maximum2023-06-01 00:00:00
2023-12-12T18:14:57.711968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:14:57.842158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-12T18:14:55.405911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:14:55.184535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:14:55.500546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:14:55.308552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T18:14:57.924384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공사번호지사명공사금액
공사번호1.0000.5010.089
지사명0.5011.0000.199
공사금액0.0890.1991.000
2023-12-12T18:14:58.016135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공사번호공사금액지사명
공사번호1.0000.0900.212
공사금액0.0901.0000.089
지사명0.2120.0891.000

Missing values

2023-12-12T18:14:55.630215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:14:55.785605image/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

공사번호계약명지사명공사금액계약시작일계약종료일등록일자
0100302016년 열원시설 제어설비 정기점검보수공사대구지사395905002016-04-252016-06-012016-03-28
110040분당열원 공기조화기 난방코일 교체공사분당사업소85140002016-04-212016-05-102016-04-05
2100332016년 열원시설 전산설비 정기점검보수공사대구지사470360002016-05-042016-06-012016-04-06
3100422016년도 수원사업소 ABB 분산제어설비 정기점검 보수공사수원사업소391833202016-05-232016-06-252016-04-11
4100572016년도 수원사업소 에머슨 분산제어설비 정기점검보수공사수원사업소228800002016-05-232016-06-252016-04-11
510062전기실 냉방기 전원 설치공사대구지사75900002016-04-202016-04-272016-04-14
6100752016년 도촌 분산제어설비 정기점검 보수공사분당사업소84700002016-07-012016-07-262016-04-19
7100892016년 수원사업소 탈질 및 수처리용 공기압축기 정기점검보수공사수원사업소46000002016-06-082016-06-172016-04-21
8100832016년도 수원사업소 발전용보일러 탈질설비 정기점검보수공사수원사업소90816002016-05-252016-06-132016-04-22
9100852016년도 수원사업소 전기집진기 정기점검보수공사수원사업소460955002016-05-302016-06-172016-04-22
공사번호계약명지사명공사금액계약시작일계약종료일등록일자
146413255세종지사 상수도 매설배관 누수부위 보수공사세종지사87010002023-05-302023-06-142023-05-09
1465132502023년도 분당사업소 열공급시설 전기분야 정기점검보수공사분당사업소2052578042023-06-262023-08-092023-05-10
1466132152023년도 화성지사 분산제어설비 정기점검보수공사화성지사502260002023-05-152023-06-132023-05-12
1467132642023년도 분당사업소 현장제어설비 정기점검보수공사분당사업소283847702023-07-102023-08-072023-05-17
146813243세종지사 관리동 승강기 로프 교체공사세종지사80000002023-06-092023-06-152023-05-23
1469132712023년 우드칩 신재생에너지시설 현장제어설비 정기점검보수공사대구지사139072402023-07-032023-07-312023-05-26
147013267김해사업소 열원 주변압기#1 누유 보수 공사김해사업소102850002023-06-192023-07-072023-05-26
1471132472023년 동탄지사 공기압축기 정기점검보수공사동탄지사193941002023-05-152023-06-142023-05-31
1472132762023년도 분당사업소 분산제어설비 정기점검보수공사분당사업소346000002023-07-032023-07-282023-06-01
1473132752023년도 도촌가압장 분산제어설비 정기점검보수공사분당사업소120120002023-06-262023-07-212023-06-01