Overview

Dataset statistics

Number of variables5
Number of observations24
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.1 KiB
Average record size in memory46.5 B

Variable types

Numeric1
Categorical3
Text1

Dataset

Description한국전력공사에서 관리하고 있는 송변전설비의 명칭(송전선로, 변압기, 개폐장치 등), 점검항목, 비용의 유무상 여부, 주기 에 대한 정보입니다.
Author한국전력공사
URLhttps://www.data.go.kr/data/15053168/fileData.do

Alerts

번호 is highly overall correlated with 설비High correlation
설비 is highly overall correlated with 번호High correlation
비용 is highly overall correlated with 주기High correlation
주기 is highly overall correlated with 비용High correlation
번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 23:34:11.072737
Analysis finished2023-12-12 23:34:11.552695
Duration0.48 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12.5
Minimum1
Maximum24
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2023-12-13T08:34:11.616149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.15
Q16.75
median12.5
Q318.25
95-th percentile22.85
Maximum24
Range23
Interquartile range (IQR)11.5

Descriptive statistics

Standard deviation7.0710678
Coefficient of variation (CV)0.56568542
Kurtosis-1.2
Mean12.5
Median Absolute Deviation (MAD)6
Skewness0
Sum300
Variance50
MonotonicityStrictly increasing
2023-12-13T08:34:11.744317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
1 1
 
4.2%
14 1
 
4.2%
24 1
 
4.2%
23 1
 
4.2%
22 1
 
4.2%
21 1
 
4.2%
20 1
 
4.2%
19 1
 
4.2%
18 1
 
4.2%
17 1
 
4.2%
Other values (14) 14
58.3%
ValueCountFrequency (%)
1 1
4.2%
2 1
4.2%
3 1
4.2%
4 1
4.2%
5 1
4.2%
6 1
4.2%
7 1
4.2%
8 1
4.2%
9 1
4.2%
10 1
4.2%
ValueCountFrequency (%)
24 1
4.2%
23 1
4.2%
22 1
4.2%
21 1
4.2%
20 1
4.2%
19 1
4.2%
18 1
4.2%
17 1
4.2%
16 1
4.2%
15 1
4.2%

설비
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)25.0%
Missing0
Missing (%)0.0%
Memory size324.0 B
가공송전선로
6 
지중송전선로
5 
개폐장치
5 
변압기
3 
공통
3 

Length

Max length6
Median length4
Mean length4.5416667
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가공송전선로
2nd row가공송전선로
3rd row가공송전선로
4th row가공송전선로
5th row가공송전선로

Common Values

ValueCountFrequency (%)
가공송전선로 6
25.0%
지중송전선로 5
20.8%
개폐장치 5
20.8%
변압기 3
12.5%
공통 3
12.5%
보호설비 2
 
8.3%

Length

2023-12-13T08:34:11.863369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:34:11.979958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가공송전선로 6
25.0%
지중송전선로 5
20.8%
개폐장치 5
20.8%
변압기 3
12.5%
공통 3
12.5%
보호설비 2
 
8.3%

점검항목
Text

Distinct21
Distinct (%)87.5%
Missing0
Missing (%)0.0%
Memory size324.0 B
2023-12-13T08:34:12.155162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length12
Mean length6.875
Min length4

Characters and Unicode

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

Unique

Unique18 ?
Unique (%)75.0%

Sample

1st row보통순시
2nd row활선애자청소
3rd row불량애자 검출
4th row기별점검
5th row고장순시
ValueCountFrequency (%)
측정 6
 
13.3%
보통순시 2
 
4.4%
점검 2
 
4.4%
정밀점검 2
 
4.4%
및 2
 
4.4%
확인점검 2
 
4.4%
고장순시 2
 
4.4%
gis 1
 
2.2%
제어회로 1
 
2.2%
누설전류 1
 
2.2%
Other values (24) 24
53.3%
2023-12-13T08:34:12.501610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
21
 
12.7%
검 10
 
6.1%
정 9
 
5.5%
점 9
 
5.5%
측 7
 
4.2%
기 6
 
3.6%
시 5
 
3.0%
순 4
 
2.4%
보 3
 
1.8%
a 3
 
1.8%
Other values (68) 88
53.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 125
75.8%
Space Separator 21
 
12.7%
Uppercase Letter 11
 
6.7%
Lowercase Letter 6
 
3.6%
Decimal Number 1
 
0.6%
Dash Punctuation 1
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
검 10
 
8.0%
정 9
 
7.2%
점 9
 
7.2%
측 7
 
5.6%
기 6
 
4.8%
시 5
 
4.0%
순 4
 
3.2%
보 3
 
2.4%
조 2
 
1.6%
밀 2
 
1.6%
Other values (54) 68
54.4%
Uppercase Letter
ValueCountFrequency (%)
G 3
27.3%
S 2
18.2%
O 1
 
9.1%
I 1
 
9.1%
P 1
 
9.1%
D 1
 
9.1%
X 1
 
9.1%
R 1
 
9.1%
Lowercase Letter
ValueCountFrequency (%)
a 3
50.0%
s 2
33.3%
y 1
 
16.7%
Space Separator
ValueCountFrequency (%)
21
100.0%
Decimal Number
ValueCountFrequency (%)
2 1
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 125
75.8%
Common 23
 
13.9%
Latin 17
 
10.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
검 10
 
8.0%
정 9
 
7.2%
점 9
 
7.2%
측 7
 
5.6%
기 6
 
4.8%
시 5
 
4.0%
순 4
 
3.2%
보 3
 
2.4%
조 2
 
1.6%
밀 2
 
1.6%
Other values (54) 68
54.4%
Latin
ValueCountFrequency (%)
a 3
17.6%
G 3
17.6%
S 2
11.8%
s 2
11.8%
O 1
 
5.9%
I 1
 
5.9%
P 1
 
5.9%
D 1
 
5.9%
X 1
 
5.9%
R 1
 
5.9%
Common
ValueCountFrequency (%)
21
91.3%
2 1
 
4.3%
- 1
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 125
75.8%
ASCII 40
 
24.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
21
52.5%
a 3
 
7.5%
G 3
 
7.5%
S 2
 
5.0%
s 2
 
5.0%
O 1
 
2.5%
2 1
 
2.5%
I 1
 
2.5%
P 1
 
2.5%
D 1
 
2.5%
Other values (4) 4
 
10.0%
Hangul
ValueCountFrequency (%)
검 10
 
8.0%
정 9
 
7.2%
점 9
 
7.2%
측 7
 
5.6%
기 6
 
4.8%
시 5
 
4.0%
순 4
 
3.2%
보 3
 
2.4%
조 2
 
1.6%
밀 2
 
1.6%
Other values (54) 68
54.4%

비용
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size324.0 B
무상
17 
유상
7 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row무상
2nd row유상
3rd row유상
4th row무상
5th row무상

Common Values

ValueCountFrequency (%)
무상 17
70.8%
유상 7
29.2%

Length

2023-12-13T08:34:12.628184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:34:12.710291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
무상 17
70.8%
유상 7
29.2%

주기
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)20.8%
Missing0
Missing (%)0.0%
Memory size324.0 B
1회/년
13 
요청시
6 
발생시
2 
필요시
2 
휴전시
 
1

Length

Max length4
Median length4
Mean length3.5416667
Min length3

Unique

Unique1 ?
Unique (%)4.2%

Sample

1st row1회/년
2nd row요청시
3rd row요청시
4th row1회/년
5th row발생시

Common Values

ValueCountFrequency (%)
1회/년 13
54.2%
요청시 6
25.0%
발생시 2
 
8.3%
필요시 2
 
8.3%
휴전시 1
 
4.2%

Length

2023-12-13T08:34:12.821888image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T08:34:12.936564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1회/년 13
54.2%
요청시 6
25.0%
발생시 2
 
8.3%
필요시 2
 
8.3%
휴전시 1
 
4.2%

Interactions

2023-12-13T08:34:11.269359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T08:34:13.037732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호설비점검항목비용주기
번호1.0000.9310.6870.8050.635
설비0.9311.0000.6950.4560.459
점검항목0.6870.6951.0000.7010.610
비용0.8050.4560.7011.0000.809
주기0.6350.4590.6100.8091.000
2023-12-13T08:34:13.131024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
비용주기설비
비용1.0000.8710.283
주기0.8711.0000.309
설비0.2830.3091.000
2023-12-13T08:34:13.213137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호설비비용주기
번호1.0000.7220.5000.235
설비0.7221.0000.2830.309
비용0.5000.2831.0000.871
주기0.2350.3090.8711.000

Missing values

2023-12-13T08:34:11.421092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T08:34:11.514544image/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

번호설비점검항목비용주기
01가공송전선로보통순시무상1회/년
12가공송전선로활선애자청소유상요청시
23가공송전선로불량애자 검출유상요청시
34가공송전선로기별점검무상1회/년
45가공송전선로고장순시무상발생시
56가공송전선로정밀점검유상요청시
67지중송전선로보통순시무상1회/년
78지중송전선로맨홀점검유상요청시
89지중송전선로케이블 및 접속함 점검유상요청시
910지중송전선로PD 측정유상요청시
번호설비점검항목비용주기
1415개폐장치GIS 부분방전 측정무상1회/년
1516개폐장치X-Ray 측정유상필요시
1617개폐장치Gas중 수분 및 SO2 측정무상1회/년
1718개폐장치Gas 누기 측정무상1회/년
1819개폐장치조작기구부 확인점검무상1회/년
1920공통개소 과열측정무상1회/년
2021공통피뢰기 누설전류 측정무상1회/년
2122공통제어회로 점검무상1회/년
2223보호설비일반점검무상1회/년
2324보호설비정밀점검무상휴전시