Overview

Dataset statistics

Number of variables10
Number of observations56
Missing cells3
Missing cells (%)0.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.5 KiB
Average record size in memory82.4 B

Variable types

Categorical5
Text1
DateTime4

Dataset

Description한국동서발전의 정비적격기업 심사 결과 현황 정보입니다. 정비적격기업의 신청일, 서류심사일, 최종상태 등을 나타냅니다.
URLhttps://www.data.go.kr/data/15118919/fileData.do

Alerts

현장실사 is highly overall correlated with 심사사업소 and 3 other fieldsHigh correlation
심사사업소 is highly overall correlated with 서류심사 and 2 other fieldsHigh correlation
서류심사 is highly overall correlated with 심사사업소 and 3 other fieldsHigh correlation
종합심사 is highly overall correlated with 심사사업소 and 3 other fieldsHigh correlation
최종상태 is highly overall correlated with 서류심사 and 2 other fieldsHigh correlation
서류심사 is highly imbalanced (87.1%)Imbalance
현장실사 is highly imbalanced (87.1%)Imbalance
종합심사 is highly imbalanced (87.1%)Imbalance
최종상태 is highly imbalanced (87.1%)Imbalance
서류심사일 has 1 (1.8%) missing valuesMissing
현장실사일 has 1 (1.8%) missing valuesMissing
종합심사일 has 1 (1.8%) missing valuesMissing

Reproduction

Analysis started2023-12-12 05:45:55.848301
Analysis finished2023-12-12 05:45:56.998699
Duration1.15 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

심사사업소
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size580.0 B
일산화력본부
20 
울산화력본부
18 
당진화력본부
15 
동해발전본부
3 

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 (%)
일산화력본부 20
35.7%
울산화력본부 18
32.1%
당진화력본부 15
26.8%
동해발전본부 3
 
5.4%

Length

2023-12-12T14:45:57.082111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:45:57.207772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일산화력본부 20
35.7%
울산화력본부 18
32.1%
당진화력본부 15
26.8%
동해발전본부 3
 
5.4%

품목
Text

Distinct47
Distinct (%)83.9%
Missing0
Missing (%)0.0%
Memory size580.0 B
2023-12-12T14:45:57.495830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length22.5
Mean length18.285714
Min length9

Characters and Unicode

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

Unique

Unique42 ?
Unique (%)75.0%

Sample

1st row내화재(등 1건)
2nd rowLining(등 1건)
3rd rowDC Motor(등 4건)
4th rowSprocket(등 10건)
5th rowPneumatic Type(등 6건)
ValueCountFrequency (%)
1건 12
 
7.9%
10건 11
 
7.2%
2건 10
 
6.6%
transformer(등 6
 
3.9%
pump(등 5
 
3.3%
centrifugal 5
 
3.3%
3건 4
 
2.6%
20건 4
 
2.6%
5건 4
 
2.6%
4건 3
 
2.0%
Other values (59) 88
57.9%
2023-12-12T14:45:58.022017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
97
 
9.5%
) 64
 
6.2%
( 64
 
6.2%
e 60
 
5.9%
r 57
 
5.6%
등 56
 
5.5%
건 56
 
5.5%
a 46
 
4.5%
n 32
 
3.1%
l 29
 
2.8%
Other values (65) 463
45.2%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 447
43.7%
Other Letter 144
 
14.1%
Uppercase Letter 117
 
11.4%
Space Separator 97
 
9.5%
Decimal Number 80
 
7.8%
Close Punctuation 64
 
6.2%
Open Punctuation 64
 
6.2%
Other Punctuation 6
 
0.6%
Dash Punctuation 5
 
0.5%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 60
13.4%
r 57
12.8%
a 46
10.3%
n 32
 
7.2%
l 29
 
6.5%
o 28
 
6.3%
i 28
 
6.3%
t 23
 
5.1%
u 21
 
4.7%
g 18
 
4.0%
Other values (13) 105
23.5%
Uppercase Letter
ValueCountFrequency (%)
C 21
17.9%
R 13
11.1%
T 13
11.1%
S 10
8.5%
V 10
8.5%
H 10
8.5%
P 9
7.7%
M 5
 
4.3%
O 4
 
3.4%
F 4
 
3.4%
Other values (9) 18
15.4%
Other Letter
ValueCountFrequency (%)
등 56
38.9%
건 56
38.9%
압 7
 
4.9%
고 6
 
4.2%
특 3
 
2.1%
기 3
 
2.1%
전 2
 
1.4%
동 2
 
1.4%
소 1
 
0.7%
연 1
 
0.7%
Other values (7) 7
 
4.9%
Decimal Number
ValueCountFrequency (%)
1 23
28.7%
0 16
20.0%
2 14
17.5%
9 5
 
6.2%
6 5
 
6.2%
3 4
 
5.0%
4 4
 
5.0%
5 4
 
5.0%
7 3
 
3.8%
8 2
 
2.5%
Other Punctuation
ValueCountFrequency (%)
, 3
50.0%
. 3
50.0%
Space Separator
ValueCountFrequency (%)
97
100.0%
Close Punctuation
ValueCountFrequency (%)
) 64
100.0%
Open Punctuation
ValueCountFrequency (%)
( 64
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 564
55.1%
Common 316
30.9%
Hangul 144
 
14.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 60
 
10.6%
r 57
 
10.1%
a 46
 
8.2%
n 32
 
5.7%
l 29
 
5.1%
o 28
 
5.0%
i 28
 
5.0%
t 23
 
4.1%
C 21
 
3.7%
u 21
 
3.7%
Other values (32) 219
38.8%
Hangul
ValueCountFrequency (%)
등 56
38.9%
건 56
38.9%
압 7
 
4.9%
고 6
 
4.2%
특 3
 
2.1%
기 3
 
2.1%
전 2
 
1.4%
동 2
 
1.4%
소 1
 
0.7%
연 1
 
0.7%
Other values (7) 7
 
4.9%
Common
ValueCountFrequency (%)
97
30.7%
) 64
20.3%
( 64
20.3%
1 23
 
7.3%
0 16
 
5.1%
2 14
 
4.4%
- 5
 
1.6%
9 5
 
1.6%
6 5
 
1.6%
3 4
 
1.3%
Other values (6) 19
 
6.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 880
85.9%
Hangul 144
 
14.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
97
 
11.0%
) 64
 
7.3%
( 64
 
7.3%
e 60
 
6.8%
r 57
 
6.5%
a 46
 
5.2%
n 32
 
3.6%
l 29
 
3.3%
o 28
 
3.2%
i 28
 
3.2%
Other values (48) 375
42.6%
Hangul
ValueCountFrequency (%)
등 56
38.9%
건 56
38.9%
압 7
 
4.9%
고 6
 
4.2%
특 3
 
2.1%
기 3
 
2.1%
전 2
 
1.4%
동 2
 
1.4%
소 1
 
0.7%
연 1
 
0.7%
Other values (7) 7
 
4.9%

신청일
Date

Distinct50
Distinct (%)89.3%
Missing0
Missing (%)0.0%
Memory size580.0 B
Minimum2022-01-05 00:00:00
Maximum2022-12-14 00:00:00
2023-12-12T14:45:58.190922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:45:58.435271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

서류심사
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size580.0 B
완료
55 
<NA>
 
1

Length

Max length4
Median length2
Mean length2.0357143
Min length2

Unique

Unique1 ?
Unique (%)1.8%

Sample

1st row완료
2nd row완료
3rd row완료
4th row완료
5th row완료

Common Values

ValueCountFrequency (%)
완료 55
98.2%
<NA> 1
 
1.8%

Length

2023-12-12T14:45:58.590649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:45:58.691138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
완료 55
98.2%
na 1
 
1.8%

서류심사일
Date

MISSING 

Distinct42
Distinct (%)76.4%
Missing1
Missing (%)1.8%
Memory size580.0 B
Minimum2022-01-24 00:00:00
Maximum2023-05-30 00:00:00
2023-12-12T14:45:58.807914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:45:59.267431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=42)

현장실사
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size580.0 B
완료
55 
<NA>
 
1

Length

Max length4
Median length2
Mean length2.0357143
Min length2

Unique

Unique1 ?
Unique (%)1.8%

Sample

1st row완료
2nd row완료
3rd row완료
4th row완료
5th row완료

Common Values

ValueCountFrequency (%)
완료 55
98.2%
<NA> 1
 
1.8%

Length

2023-12-12T14:45:59.403955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:45:59.502447image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
완료 55
98.2%
na 1
 
1.8%

현장실사일
Date

MISSING 

Distinct43
Distinct (%)78.2%
Missing1
Missing (%)1.8%
Memory size580.0 B
Minimum2022-03-16 00:00:00
Maximum2023-06-09 00:00:00
2023-12-12T14:45:59.607660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:45:59.746017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=43)

종합심사
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size580.0 B
완료
55 
<NA>
 
1

Length

Max length4
Median length2
Mean length2.0357143
Min length2

Unique

Unique1 ?
Unique (%)1.8%

Sample

1st row완료
2nd row완료
3rd row완료
4th row완료
5th row완료

Common Values

ValueCountFrequency (%)
완료 55
98.2%
<NA> 1
 
1.8%

Length

2023-12-12T14:45:59.898021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:46:00.042128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
완료 55
98.2%
na 1
 
1.8%

종합심사일
Date

MISSING 

Distinct35
Distinct (%)63.6%
Missing1
Missing (%)1.8%
Memory size580.0 B
Minimum2022-03-16 00:00:00
Maximum2023-06-12 00:00:00
2023-12-12T14:46:00.170367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:46:00.338264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)

최종상태
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size580.0 B
심사완료
55 
서류심사
 
1

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique1 ?
Unique (%)1.8%

Sample

1st row심사완료
2nd row심사완료
3rd row심사완료
4th row심사완료
5th row심사완료

Common Values

ValueCountFrequency (%)
심사완료 55
98.2%
서류심사 1
 
1.8%

Length

2023-12-12T14:46:00.481847image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:46:00.594339image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
심사완료 55
98.2%
서류심사 1
 
1.8%

Correlations

2023-12-12T14:46:00.660988image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
심사사업소품목신청일서류심사일현장실사일종합심사일최종상태
심사사업소1.0000.8760.8510.5820.9840.9220.000
품목0.8761.0000.0000.7850.9330.9211.000
신청일0.8510.0001.0000.9270.9690.9900.000
서류심사일0.5820.7850.9271.0000.9330.930NaN
현장실사일0.9840.9330.9690.9331.0000.999NaN
종합심사일0.9220.9210.9900.9300.9991.000NaN
최종상태0.0001.0000.000NaNNaNNaN1.000
2023-12-12T14:46:00.803560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
현장실사심사사업소서류심사종합심사최종상태
현장실사1.0001.0001.0001.0001.000
심사사업소1.0001.0001.0001.0000.000
서류심사1.0001.0001.0001.0001.000
종합심사1.0001.0001.0001.0001.000
최종상태1.0000.0001.0001.0001.000
2023-12-12T14:46:00.918992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
심사사업소서류심사현장실사종합심사최종상태
심사사업소1.0001.0001.0001.0000.000
서류심사1.0001.0001.0001.0001.000
현장실사1.0001.0001.0001.0001.000
종합심사1.0001.0001.0001.0001.000
최종상태0.0001.0001.0001.0001.000

Missing values

2023-12-12T14:45:56.493411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T14:45:56.707657image/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-12T14:45:56.879521image/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일산화력본부내화재(등 1건)2022-01-05완료2022-01-24완료2022-04-28완료2022-05-02심사완료
1일산화력본부Lining(등 1건)2022-01-05완료2022-05-02완료2022-05-02완료2022-05-02심사완료
2당진화력본부DC Motor(등 4건)2022-01-14완료2022-09-02완료2022-09-13완료2022-09-13심사완료
3울산화력본부Sprocket(등 10건)2022-01-14완료2022-01-25완료2022-04-07완료2022-04-11심사완료
4울산화력본부Pneumatic Type(등 6건)2022-01-24완료2022-02-15완료2022-04-07완료2022-04-11심사완료
5울산화력본부Transformer(등 1건)2022-02-10완료2022-02-16완료2022-03-16완료2022-03-16심사완료
6당진화력본부Server Computer(등 2건)2022-02-22완료2022-06-27완료2022-07-27완료2022-07-27심사완료
7일산화력본부Transformer(등 1건)2022-02-23완료2022-06-20완료2022-06-28완료2022-07-01심사완료
8일산화력본부Sootblower(등 7건)2022-03-03완료2022-05-24완료2022-05-30완료2022-05-30심사완료
9당진화력본부Rigid Hanger(등 4건)2022-03-16완료2022-11-14완료2022-11-14완료2022-11-14심사완료
심사사업소품목신청일서류심사서류심사일현장실사현장실사일종합심사종합심사일최종상태
46울산화력본부Transformer(등 1건)2022-10-01완료2022-10-12완료2022-11-14완료2022-11-18심사완료
47당진화력본부Coating(등 2건)2022-10-12완료2023-01-31완료2023-02-08완료2023-02-13심사완료
48일산화력본부Rigid Hanger(등 20건)2022-10-25완료2022-10-26완료2022-10-26완료2022-10-26심사완료
49울산화력본부Knife Gate Valve(등 1건)2022-10-28완료2022-11-25완료2023-01-11완료2023-01-11심사완료
50당진화력본부고압-특고압전동기(6.9kV)(등 2건)2022-10-28완료2022-12-05완료2022-12-08완료2022-12-09심사완료
51울산화력본부Guide Roller(등 3건)2022-11-03완료2022-12-16완료2023-01-19완료2023-01-25심사완료
52일산화력본부Collecting Plate(집진판)(등 9건)2022-11-09완료2022-12-07완료2022-12-12완료2022-12-12심사완료
53동해발전본부Centrifugal Fan(등 20건)2022-11-10완료2022-11-14완료2022-12-06완료2022-12-07심사완료
54당진화력본부Centrifugal Pump(등 20건)2022-12-01완료2023-05-30완료2023-06-09완료2023-06-12심사완료
55일산화력본부Hydraulic Cylinder(등 1건)2022-12-14완료2023-01-05완료2023-01-11완료2023-01-11심사완료