Overview

Dataset statistics

Number of variables12
Number of observations1221
Missing cells2466
Missing cells (%)16.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory120.6 KiB
Average record size in memory101.1 B

Variable types

Categorical2
Numeric3
Text2
DateTime3
Unsupported2

Dataset

Description사업소별 공사명 및 공사시작일, 종료일, 설비명, 자재명이 기록되어있으며, 항목은 사업소,공사번호,공사구분,공사명,공사시작일,공사종료일,준공승인일,오더번호,설비번호,설비명,자재구분,자재명으로 구성되어있음
Author한국중부발전(주)
URLhttps://www.data.go.kr/data/15083280/fileData.do

Alerts

공사번호 is highly overall correlated with 오더번호 and 1 other fieldsHigh correlation
오더번호 is highly overall correlated with 공사번호High correlation
설비번호 is highly overall correlated with 사업소High correlation
사업소 is highly overall correlated with 공사번호 and 1 other fieldsHigh correlation
공사구분 is highly imbalanced (63.4%)Imbalance
자재구분 has 1221 (100.0%) missing valuesMissing
자재명 has 1221 (100.0%) missing valuesMissing
오더번호 has unique valuesUnique
자재구분 is an unsupported type, check if it needs cleaning or further analysisUnsupported
자재명 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 02:37:06.970977
Analysis finished2023-12-12 02:37:08.986263
Duration2.02 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

사업소
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size9.7 KiB
제주발전본부
605 
인천발전본부
173 
신서천발전본부
166 
보령발전본부
124 
서울발전본부
117 
Other values (2)
 
36

Length

Max length7
Median length6
Mean length6.1572482
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row보령발전본부
2nd row보령발전본부
3rd row보령발전본부
4th row보령발전본부
5th row보령발전본부

Common Values

ValueCountFrequency (%)
제주발전본부 605
49.5%
인천발전본부 173
 
14.2%
신서천발전본부 166
 
13.6%
보령발전본부 124
 
10.2%
서울발전본부 117
 
9.6%
신보령발전본부 26
 
2.1%
세종발전본부 10
 
0.8%

Length

2023-12-12T11:37:09.080955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:37:09.255407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제주발전본부 605
49.5%
인천발전본부 173
 
14.2%
신서천발전본부 166
 
13.6%
보령발전본부 124
 
10.2%
서울발전본부 117
 
9.6%
신보령발전본부 26
 
2.1%
세종발전본부 10
 
0.8%

공사번호
Real number (ℝ)

HIGH CORRELATION 

Distinct126
Distinct (%)10.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24539.331
Minimum22707
Maximum26156
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.9 KiB
2023-12-12T11:37:09.435893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum22707
5-th percentile23374
Q124005
median24127
Q325461
95-th percentile25720
Maximum26156
Range3449
Interquartile range (IQR)1456

Descriptive statistics

Standard deviation880.24902
Coefficient of variation (CV)0.035870946
Kurtosis-1.4230084
Mean24539.331
Median Absolute Deviation (MAD)682
Skewness0.15522786
Sum29962523
Variance774838.33
MonotonicityNot monotonic
2023-12-12T11:37:09.581692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
24045 209
17.1%
25461 177
14.5%
24127 153
12.5%
23445 148
12.1%
25703 91
7.5%
25508 70
 
5.7%
25027 64
 
5.2%
23368 40
 
3.3%
26003 38
 
3.1%
24005 37
 
3.0%
Other values (116) 194
15.9%
ValueCountFrequency (%)
22707 1
 
0.1%
22708 1
 
0.1%
22919 17
 
1.4%
23182 1
 
0.1%
23362 1
 
0.1%
23368 40
 
3.3%
23374 1
 
0.1%
23417 1
 
0.1%
23423 1
 
0.1%
23445 148
12.1%
ValueCountFrequency (%)
26156 1
 
0.1%
26112 1
 
0.1%
26092 1
 
0.1%
26053 1
 
0.1%
26042 1
 
0.1%
26035 1
 
0.1%
26003 38
3.1%
25984 1
 
0.1%
25982 1
 
0.1%
25972 1
 
0.1%

공사구분
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size9.7 KiB
O/H
1046 
단가공사
 
77
일반공사
 
50
간이공사
 
34
용역공사
 
14

Length

Max length4
Median length3
Mean length3.1433251
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row단가공사
2nd row단가공사
3rd row단가공사
4th row단가공사
5th row단가공사

Common Values

ValueCountFrequency (%)
O/H 1046
85.7%
단가공사 77
 
6.3%
일반공사 50
 
4.1%
간이공사 34
 
2.8%
용역공사 14
 
1.1%

Length

2023-12-12T11:37:09.743637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:37:09.846406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
o/h 1046
85.7%
단가공사 77
 
6.3%
일반공사 50
 
4.1%
간이공사 34
 
2.8%
용역공사 14
 
1.1%
Distinct125
Distinct (%)10.2%
Missing0
Missing (%)0.0%
Memory size9.7 KiB
2023-12-12T11:37:10.103051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length41
Mean length24.543817
Min length13

Characters and Unicode

Total characters29968
Distinct characters284
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

Unique101 ?
Unique (%)8.3%

Sample

1st row2022년도 석탄취급설비 Pulley Lagging 연간 단가계약공사
2nd row2022년 탈황폐수 총질소제거설비 열교환기 기계세정 단가계약
3rd row2022년도 석탄취급설비 벨트접착 연간 단가공사
4th row2022년도 석탄취급설비 벨트접착 연간 단가공사
5th row2022년도 석탄취급설비 벨트접착 연간 단가공사
ValueCountFrequency (%)
계획예방정비공사 781
13.5%
2022년 563
 
9.7%
복합 514
 
8.9%
1호기 514
 
8.9%
제주 387
 
6.7%
lng 386
 
6.7%
2호기 267
 
4.6%
2022년도 158
 
2.7%
gt 157
 
2.7%
내연 156
 
2.7%
Other values (344) 1903
32.9%
2023-12-12T11:37:10.538715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4566
 
15.2%
2 2571
 
8.6%
1325
 
4.4%
1191
 
4.0%
1184
 
4.0%
1121
 
3.7%
1095
 
3.7%
1060
 
3.5%
1047
 
3.5%
1039
 
3.5%
Other values (274) 13769
45.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 18301
61.1%
Space Separator 4566
 
15.2%
Decimal Number 4250
 
14.2%
Uppercase Letter 1763
 
5.9%
Lowercase Letter 338
 
1.1%
Open Punctuation 286
 
1.0%
Close Punctuation 286
 
1.0%
Other Punctuation 169
 
0.6%
Dash Punctuation 5
 
< 0.1%
Math Symbol 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
1325
 
7.2%
1191
 
6.5%
1184
 
6.5%
1121
 
6.1%
1095
 
6.0%
1060
 
5.8%
1047
 
5.7%
1039
 
5.7%
1035
 
5.7%
944
 
5.2%
Other values (209) 7260
39.7%
Lowercase Letter
ValueCountFrequency (%)
a 46
13.6%
e 45
13.3%
l 31
 
9.2%
t 23
 
6.8%
r 21
 
6.2%
v 18
 
5.3%
i 18
 
5.3%
o 18
 
5.3%
c 17
 
5.0%
n 17
 
5.0%
Other values (13) 84
24.9%
Uppercase Letter
ValueCountFrequency (%)
G 554
31.4%
L 397
22.5%
N 389
22.1%
T 175
 
9.9%
B 52
 
2.9%
S 47
 
2.7%
P 32
 
1.8%
C 26
 
1.5%
V 17
 
1.0%
K 16
 
0.9%
Other values (11) 58
 
3.3%
Decimal Number
ValueCountFrequency (%)
2 2571
60.5%
0 778
 
18.3%
1 536
 
12.6%
3 159
 
3.7%
5 115
 
2.7%
6 71
 
1.7%
4 13
 
0.3%
8 3
 
0.1%
7 3
 
0.1%
9 1
 
< 0.1%
Other Punctuation
ValueCountFrequency (%)
# 159
94.1%
, 8
 
4.7%
. 1
 
0.6%
· 1
 
0.6%
Open Punctuation
ValueCountFrequency (%)
( 285
99.7%
[ 1
 
0.3%
Close Punctuation
ValueCountFrequency (%)
) 285
99.7%
] 1
 
0.3%
Space Separator
ValueCountFrequency (%)
4566
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%
Math Symbol
ValueCountFrequency (%)
~ 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 18301
61.1%
Common 9566
31.9%
Latin 2101
 
7.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
1325
 
7.2%
1191
 
6.5%
1184
 
6.5%
1121
 
6.1%
1095
 
6.0%
1060
 
5.8%
1047
 
5.7%
1039
 
5.7%
1035
 
5.7%
944
 
5.2%
Other values (209) 7260
39.7%
Latin
ValueCountFrequency (%)
G 554
26.4%
L 397
18.9%
N 389
18.5%
T 175
 
8.3%
B 52
 
2.5%
S 47
 
2.2%
a 46
 
2.2%
e 45
 
2.1%
P 32
 
1.5%
l 31
 
1.5%
Other values (34) 333
15.8%
Common
ValueCountFrequency (%)
4566
47.7%
2 2571
26.9%
0 778
 
8.1%
1 536
 
5.6%
( 285
 
3.0%
) 285
 
3.0%
# 159
 
1.7%
3 159
 
1.7%
5 115
 
1.2%
6 71
 
0.7%
Other values (11) 41
 
0.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 18301
61.1%
ASCII 11666
38.9%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4566
39.1%
2 2571
22.0%
0 778
 
6.7%
G 554
 
4.7%
1 536
 
4.6%
L 397
 
3.4%
N 389
 
3.3%
( 285
 
2.4%
) 285
 
2.4%
T 175
 
1.5%
Other values (54) 1130
 
9.7%
Hangul
ValueCountFrequency (%)
1325
 
7.2%
1191
 
6.5%
1184
 
6.5%
1121
 
6.1%
1095
 
6.0%
1060
 
5.8%
1047
 
5.7%
1039
 
5.7%
1035
 
5.7%
944
 
5.2%
Other values (209) 7260
39.7%
None
ValueCountFrequency (%)
· 1
100.0%
Distinct134
Distinct (%)11.0%
Missing0
Missing (%)0.0%
Memory size9.7 KiB
Minimum2022-01-03 00:00:00
Maximum2023-05-11 00:00:00
2023-12-12T11:37:10.697007image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:37:10.882543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct130
Distinct (%)10.8%
Missing12
Missing (%)1.0%
Memory size9.7 KiB
Minimum2022-01-03 00:00:00
Maximum2023-10-05 00:00:00
2023-12-12T11:37:11.060177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:37:11.222596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct129
Distinct (%)10.7%
Missing12
Missing (%)1.0%
Memory size9.7 KiB
Minimum2022-01-03 00:00:00
Maximum2023-10-20 00:00:00
2023-12-12T11:37:11.391488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:37:11.546488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

오더번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct1221
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1319070.8
Minimum1301930
Maximum1338994
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.9 KiB
2023-12-12T11:37:11.698332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1301930
5-th percentile1307928
Q11310503
median1315922
Q31328773
95-th percentile1334872
Maximum1338994
Range37064
Interquartile range (IQR)18270

Descriptive statistics

Standard deviation9439.8469
Coefficient of variation (CV)0.0071564372
Kurtosis-1.1507154
Mean1319070.8
Median Absolute Deviation (MAD)6686
Skewness0.39432455
Sum1.6105854 × 109
Variance89110710
MonotonicityNot monotonic
2023-12-12T11:37:11.870666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1338994 1
 
0.1%
1319677 1
 
0.1%
1319191 1
 
0.1%
1319192 1
 
0.1%
1319193 1
 
0.1%
1319645 1
 
0.1%
1319664 1
 
0.1%
1319670 1
 
0.1%
1319672 1
 
0.1%
1319678 1
 
0.1%
Other values (1211) 1211
99.2%
ValueCountFrequency (%)
1301930 1
0.1%
1301948 1
0.1%
1302062 1
0.1%
1302099 1
0.1%
1302295 1
0.1%
1302646 1
0.1%
1302911 1
0.1%
1302912 1
0.1%
1303014 1
0.1%
1303076 1
0.1%
ValueCountFrequency (%)
1338994 1
0.1%
1338864 1
0.1%
1338787 1
0.1%
1338782 1
0.1%
1338777 1
0.1%
1338774 1
0.1%
1338772 1
0.1%
1338771 1
0.1%
1338770 1
0.1%
1338769 1
0.1%

설비번호
Real number (ℝ)

HIGH CORRELATION 

Distinct981
Distinct (%)80.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean34306330
Minimum3020150
Maximum70573110
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.9 KiB
2023-12-12T11:37:12.042029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3020150
5-th percentile10669840
Q121025880
median40127910
Q340251480
95-th percentile50292940
Maximum70573110
Range67552960
Interquartile range (IQR)19225600

Descriptive statistics

Standard deviation12914567
Coefficient of variation (CV)0.37644851
Kurtosis0.29358943
Mean34306330
Median Absolute Deviation (MAD)9326420
Skewness-0.26858785
Sum4.1888029 × 1010
Variance1.6678604 × 1014
MonotonicityNot monotonic
2023-12-12T11:37:12.225876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3020840 14
 
1.1%
21010700 7
 
0.6%
10791260 7
 
0.6%
21012110 6
 
0.5%
40192680 6
 
0.5%
40306940 6
 
0.5%
11192340 6
 
0.5%
21001870 5
 
0.4%
21012130 5
 
0.4%
50155930 5
 
0.4%
Other values (971) 1154
94.5%
ValueCountFrequency (%)
3020150 2
 
0.2%
3020840 14
1.1%
10037030 1
 
0.1%
10124390 1
 
0.1%
10162310 1
 
0.1%
10246140 1
 
0.1%
10272160 1
 
0.1%
10339610 1
 
0.1%
10341190 2
 
0.2%
10345370 1
 
0.1%
ValueCountFrequency (%)
70573110 1
 
0.1%
70546260 3
0.2%
70534830 1
 
0.1%
70494530 1
 
0.1%
70478490 1
 
0.1%
70447240 2
0.2%
70418650 1
 
0.1%
70415100 1
 
0.1%
70349250 1
 
0.1%
70331220 1
 
0.1%
Distinct864
Distinct (%)70.8%
Missing0
Missing (%)0.0%
Memory size9.7 KiB
2023-12-12T11:37:12.573385image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length71
Median length47
Mean length22.570025
Min length3

Characters and Unicode

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

Unique

Unique683 ?
Unique (%)55.9%

Sample

1st rowAB-12A BELT CONVEYOR BELT
2nd row반응조계통 LINE
3rd row기타설비
4th rowS/R-F BOOM DRIVE MOTOR
5th rowAB-21B BELT CONVEYOR BELT
ValueCountFrequency (%)
a 156
 
3.1%
valve 112
 
2.2%
hp 112
 
2.2%
motor 82
 
1.6%
gt 80
 
1.6%
belt 77
 
1.5%
gas 70
 
1.4%
pump 70
 
1.4%
oil 69
 
1.4%
for 66
 
1.3%
Other values (1003) 4118
82.2%
2023-12-12T11:37:13.082197image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3795
 
13.8%
E 2043
 
7.4%
R 1737
 
6.3%
T 1687
 
6.1%
A 1664
 
6.0%
O 1498
 
5.4%
L 1213
 
4.4%
N 1110
 
4.0%
I 1106
 
4.0%
S 1025
 
3.7%
Other values (158) 10680
38.8%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 20713
75.2%
Space Separator 3795
 
13.8%
Decimal Number 1254
 
4.6%
Lowercase Letter 600
 
2.2%
Other Letter 370
 
1.3%
Other Punctuation 329
 
1.2%
Dash Punctuation 279
 
1.0%
Close Punctuation 102
 
0.4%
Open Punctuation 102
 
0.4%
Math Symbol 11
 
< 0.1%
Other values (2) 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
44
 
11.9%
25
 
6.8%
24
 
6.5%
18
 
4.9%
16
 
4.3%
16
 
4.3%
14
 
3.8%
12
 
3.2%
12
 
3.2%
10
 
2.7%
Other values (77) 179
48.4%
Uppercase Letter
ValueCountFrequency (%)
E 2043
 
9.9%
R 1737
 
8.4%
T 1687
 
8.1%
A 1664
 
8.0%
O 1498
 
7.2%
L 1213
 
5.9%
N 1110
 
5.4%
I 1106
 
5.3%
S 1025
 
4.9%
C 985
 
4.8%
Other values (16) 6645
32.1%
Lowercase Letter
ValueCountFrequency (%)
e 94
15.7%
r 87
14.5%
o 68
11.3%
t 55
9.2%
a 44
7.3%
n 44
7.3%
i 38
 
6.3%
l 30
 
5.0%
u 22
 
3.7%
m 19
 
3.2%
Other values (13) 99
16.5%
Decimal Number
ValueCountFrequency (%)
1 527
42.0%
0 243
19.4%
2 145
 
11.6%
3 109
 
8.7%
6 84
 
6.7%
5 45
 
3.6%
4 29
 
2.3%
8 28
 
2.2%
7 27
 
2.2%
9 17
 
1.4%
Other Punctuation
ValueCountFrequency (%)
# 151
45.9%
/ 80
24.3%
. 57
 
17.3%
& 21
 
6.4%
, 8
 
2.4%
% 7
 
2.1%
" 2
 
0.6%
? 1
 
0.3%
@ 1
 
0.3%
' 1
 
0.3%
Math Symbol
ValueCountFrequency (%)
~ 4
36.4%
× 3
27.3%
= 2
18.2%
+ 2
18.2%
Close Punctuation
ValueCountFrequency (%)
) 88
86.3%
] 14
 
13.7%
Open Punctuation
ValueCountFrequency (%)
( 88
86.3%
[ 14
 
13.7%
Space Separator
ValueCountFrequency (%)
3795
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 279
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 2
100.0%
Other Symbol
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 21313
77.3%
Common 5875
 
21.3%
Hangul 370
 
1.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
44
 
11.9%
25
 
6.8%
24
 
6.5%
18
 
4.9%
16
 
4.3%
16
 
4.3%
14
 
3.8%
12
 
3.2%
12
 
3.2%
10
 
2.7%
Other values (77) 179
48.4%
Latin
ValueCountFrequency (%)
E 2043
 
9.6%
R 1737
 
8.1%
T 1687
 
7.9%
A 1664
 
7.8%
O 1498
 
7.0%
L 1213
 
5.7%
N 1110
 
5.2%
I 1106
 
5.2%
S 1025
 
4.8%
C 985
 
4.6%
Other values (39) 7245
34.0%
Common
ValueCountFrequency (%)
3795
64.6%
1 527
 
9.0%
- 279
 
4.7%
0 243
 
4.1%
# 151
 
2.6%
2 145
 
2.5%
3 109
 
1.9%
) 88
 
1.5%
( 88
 
1.5%
6 84
 
1.4%
Other values (22) 366
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 27184
98.6%
Hangul 370
 
1.3%
None 3
 
< 0.1%
Letterlike Symbols 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3795
 
14.0%
E 2043
 
7.5%
R 1737
 
6.4%
T 1687
 
6.2%
A 1664
 
6.1%
O 1498
 
5.5%
L 1213
 
4.5%
N 1110
 
4.1%
I 1106
 
4.1%
S 1025
 
3.8%
Other values (69) 10306
37.9%
Hangul
ValueCountFrequency (%)
44
 
11.9%
25
 
6.8%
24
 
6.5%
18
 
4.9%
16
 
4.3%
16
 
4.3%
14
 
3.8%
12
 
3.2%
12
 
3.2%
10
 
2.7%
Other values (77) 179
48.4%
None
ValueCountFrequency (%)
× 3
100.0%
Letterlike Symbols
ValueCountFrequency (%)
1
100.0%

자재구분
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1221
Missing (%)100.0%
Memory size10.9 KiB

자재명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1221
Missing (%)100.0%
Memory size10.9 KiB

Interactions

2023-12-12T11:37:08.114470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:37:07.445189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:37:07.766690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:37:08.248817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:37:07.537029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:37:07.862439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:37:08.379880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:37:07.648067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:37:07.975183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T11:37:13.201138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사업소공사번호공사구분오더번호설비번호
사업소1.0000.8030.6230.7050.963
공사번호0.8031.0000.7630.9300.790
공사구분0.6230.7631.0000.5730.640
오더번호0.7050.9300.5731.0000.763
설비번호0.9630.7900.6400.7631.000
2023-12-12T11:37:13.299673image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사업소공사구분
사업소1.0000.463
공사구분0.4631.000
2023-12-12T11:37:13.379691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공사번호오더번호설비번호사업소공사구분
공사번호1.0000.7620.1140.5780.416
오더번호0.7621.000-0.0310.4560.272
설비번호0.114-0.0311.0000.9200.437
사업소0.5780.4560.9201.0000.463
공사구분0.4160.2720.4370.4631.000

Missing values

2023-12-12T11:37:08.559868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T11:37:08.778651image/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.
2023-12-12T11:37:08.923098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

사업소공사번호공사구분공사명공사시작일공사종료일준공승인일오더번호설비번호설비명자재구분자재명
0보령발전본부23446단가공사2022년도 석탄취급설비 Pulley Lagging 연간 단가계약공사2022-07-282022-12-292022-12-29133899411241430AB-12A BELT CONVEYOR BELT<NA><NA>
1보령발전본부23451단가공사2022년 탈황폐수 총질소제거설비 열교환기 기계세정 단가계약2023-01-052023-02-092023-02-13133886411192340반응조계통 LINE<NA><NA>
2보령발전본부23368단가공사2022년도 석탄취급설비 벨트접착 연간 단가공사2022-12-212022-12-212022-12-21133840810651370기타설비<NA><NA>
3보령발전본부23368단가공사2022년도 석탄취급설비 벨트접착 연간 단가공사2022-12-212022-12-212022-12-21133840610671520S/R-F BOOM DRIVE MOTOR<NA><NA>
4보령발전본부23368단가공사2022년도 석탄취급설비 벨트접착 연간 단가공사2022-12-212022-12-212022-12-21133840411266200AB-21B BELT CONVEYOR BELT<NA><NA>
5보령발전본부23368단가공사2022년도 석탄취급설비 벨트접착 연간 단가공사2022-12-212022-12-212022-12-21133839011450500BELT CONVEYOR BELT<NA><NA>
6보령발전본부25720단가공사제3~6호기 축류팬 및 미분기 유압작동설비 반출정비 단가계약2022-12-092022-12-092022-12-14133740110346420PULV D<NA><NA>
7보령발전본부25720단가공사제3~6호기 축류팬 및 미분기 유압작동설비 반출정비 단가계약2022-12-092022-12-092022-12-14133739710509440BOOSTER FAN A<NA><NA>
8보령발전본부25720단가공사제3~6호기 축류팬 및 미분기 유압작동설비 반출정비 단가계약2022-12-092022-12-092022-12-14133739410341190IDF A<NA><NA>
9보령발전본부23762단가공사2022년 복합발전소 가스터빈 고온부점검 단가계약공사2022-12-072022-12-192022-12-21133709910791260GT CASING<NA><NA>
사업소공사번호공사구분공사명공사시작일공사종료일준공승인일오더번호설비번호설비명자재구분자재명
1211신보령발전본부23450단가공사2022년 탈황폐수처리설비 기계적 세정 단가공사2022-03-102022-04-122022-04-121308996705462601ST EVAPORATOR A<NA><NA>
1212신보령발전본부23923용역공사2022년 신보령 터빈설비 와전류탐상시험(ECT) 용역 2차 설계변경 시행2023-05-112023-05-112023-05-11130700170316830U#2 MAIN CONDENSER A<NA><NA>
1213신보령발전본부23921일반공사신보령 2호기 보일러 Platen SH Metal TC 설치 공사2022-02-172022-12-302023-01-10130697270210350U#2 PLATEN SH TUBES METAL THERMOCOUPLE 01F~152F<NA><NA>
1214신보령발전본부23841일반공사신보령 2호기 터빈 고온고압 공압제어밸브 정밀점검공사2022-02-102022-06-142022-06-14130649270349250U#2 MAIN STM TO CRH WORMUP LINE TEMP CV ACTUATOR<NA><NA>
1215신보령발전본부23830일반공사신보령 2호기 주제어시스템 Relay 및 Power supply 정밀점검공사2022-02-102022-06-142022-06-141306379700920601IR21 INTERPOSING RELAY CABINET FOR BOP<NA><NA>
1216신보령발전본부23740일반공사신보령 2호기 진동감시 시스템(VMS) 정밀점검 공사 시행2022-02-032022-06-092022-06-091304447702960102VP01 VIBRATION MONITERING SYS. CABINET FOR BLR<NA><NA>
1217신보령발전본부23722용역공사2022년 신보령 터빈설비 와전류탐상시험(ECT) 용역 설계변경시행2023-05-112023-05-112023-05-11130437670316830U#2 MAIN CONDENSER A<NA><NA>
1218신보령발전본부23681일반공사신보령 2호기 보일러 중요 공압 제어밸브 정밀점검 공사2022-01-262022-12-292023-01-10130409870209120U#2 HP BYPASS VV A SPRAY WTR LINE TEMP CV ACTUATOR<NA><NA>
1219신보령발전본부23500일반공사신보령 2호기 미분기 화재감시 시스템 정밀점검 공사2022-01-172022-12-292023-01-03130311570234610PULVERIZER A FIRE DETECTOR (PHOTO DIODE SENSOR)<NA><NA>
1220신보령발전본부23463용역공사22년 신보령 터빈설비 와전류탐상시험(ECT) 용역 시행2022-01-142023-09-202023-09-27130301470316830U#2 MAIN CONDENSER A<NA><NA>