Overview

Dataset statistics

Number of variables16
Number of observations138
Missing cells306
Missing cells (%)13.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory17.6 KiB
Average record size in memory130.9 B

Variable types

Categorical8
Text3
DateTime3
Numeric2

Dataset

Description화성종합경기타운 시설물 관리대장 현황입니다. 전기, 기계, 통신, 소방, 승강기 등의 상태와 정보를 나타냅니다.
Author화성도시공사
URLhttps://www.data.go.kr/data/15070860/fileData.do

Alerts

상태평가 has constant value ""Constant
관리기관 has constant value ""Constant
데이터기준일자 has constant value ""Constant
공종 is highly overall correlated with 설치위치 and 4 other fieldsHigh correlation
관리자 연락처 is highly overall correlated with 공종 and 4 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 overall correlated with 공종 and 2 other fieldsHigh correlation
도래시기 is highly overall correlated with 필요예산 and 3 other fieldsHigh correlation
수선율(퍼센트) is highly overall correlated with 교체비용 and 2 other fieldsHigh correlation
교체일 has 117 (84.8%) missing valuesMissing
담당자의견 has 58 (42.0%) missing valuesMissing
교체비용 has 59 (42.8%) missing valuesMissing
필요예산 has 72 (52.2%) missing valuesMissing
설비명 has unique valuesUnique

Reproduction

Analysis started2024-03-14 23:45:29.839149
Analysis finished2024-03-14 23:45:34.451761
Duration4.61 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

공종
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)5.1%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
조경,토목
28 
전기
20 
기계
20 
통신
20 
소방
20 
Other values (2)
30 

Length

Max length5
Median length2
Mean length2.6811594
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전기
2nd row전기
3rd row전기
4th row전기
5th row전기

Common Values

ValueCountFrequency (%)
조경,토목 28
20.3%
전기 20
14.5%
기계 20
14.5%
통신 20
14.5%
소방 20
14.5%
건축 20
14.5%
승강기 10
 
7.2%

Length

2024-03-15T08:45:34.679451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T08:45:35.356430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
조경,토목 28
20.3%
전기 20
14.5%
기계 20
14.5%
통신 20
14.5%
소방 20
14.5%
건축 20
14.5%
승강기 10
 
7.2%

설비명
Text

UNIQUE 

Distinct138
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2024-03-15T08:45:37.228732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length21
Mean length8.7028986
Min length2

Characters and Unicode

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

Unique

Unique138 ?
Unique (%)100.0%

Sample

1st row디젤엔진발전기
2nd row발전기 소모품(필터, 배터리 등)
3rd row특고압 수전반
4th row몰드변압기
5th row정류반 축전지
ValueCountFrequency (%)
보조경기장 8
 
3.2%
주경기장 8
 
3.2%
주차장 7
 
2.8%
실내경기장 6
 
2.4%
마감 6
 
2.4%
설비 5
 
2.0%
잔디 5
 
2.0%
등 4
 
1.6%
포장 4
 
1.6%
및 4
 
1.6%
Other values (168) 191
77.0%
2024-03-15T08:45:39.055608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
111
 
9.2%
기 54
 
4.5%
장 50
 
4.2%
설 44
 
3.7%
비 42
 
3.5%
경 38
 
3.2%
( 33
 
2.7%
) 33
 
2.7%
조 27
 
2.2%
전 24
 
2.0%
Other values (224) 745
62.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 939
78.2%
Space Separator 111
 
9.2%
Uppercase Letter 36
 
3.0%
Open Punctuation 33
 
2.7%
Close Punctuation 33
 
2.7%
Other Punctuation 26
 
2.2%
Decimal Number 18
 
1.5%
Lowercase Letter 3
 
0.2%
Dash Punctuation 1
 
0.1%
Math Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 54
 
5.8%
장 50
 
5.3%
설 44
 
4.7%
비 42
 
4.5%
경 38
 
4.0%
조 27
 
2.9%
전 24
 
2.6%
주 22
 
2.3%
방 15
 
1.6%
보 15
 
1.6%
Other values (190) 608
64.7%
Uppercase Letter
ValueCountFrequency (%)
C 7
19.4%
P 5
13.9%
T 4
11.1%
D 3
8.3%
L 3
8.3%
N 2
 
5.6%
U 2
 
5.6%
S 2
 
5.6%
R 2
 
5.6%
F 1
 
2.8%
Other values (5) 5
13.9%
Decimal Number
ValueCountFrequency (%)
1 5
27.8%
3 4
22.2%
0 3
16.7%
2 3
16.7%
8 1
 
5.6%
7 1
 
5.6%
4 1
 
5.6%
Other Punctuation
ValueCountFrequency (%)
, 18
69.2%
. 6
 
23.1%
# 1
 
3.8%
: 1
 
3.8%
Lowercase Letter
ValueCountFrequency (%)
u 1
33.3%
c 1
33.3%
f 1
33.3%
Space Separator
ValueCountFrequency (%)
111
100.0%
Open Punctuation
ValueCountFrequency (%)
( 33
100.0%
Close Punctuation
ValueCountFrequency (%)
) 33
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 939
78.2%
Common 223
 
18.6%
Latin 39
 
3.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 54
 
5.8%
장 50
 
5.3%
설 44
 
4.7%
비 42
 
4.5%
경 38
 
4.0%
조 27
 
2.9%
전 24
 
2.6%
주 22
 
2.3%
방 15
 
1.6%
보 15
 
1.6%
Other values (190) 608
64.7%
Latin
ValueCountFrequency (%)
C 7
17.9%
P 5
12.8%
T 4
10.3%
D 3
 
7.7%
L 3
 
7.7%
N 2
 
5.1%
U 2
 
5.1%
S 2
 
5.1%
R 2
 
5.1%
F 1
 
2.6%
Other values (8) 8
20.5%
Common
ValueCountFrequency (%)
111
49.8%
( 33
 
14.8%
) 33
 
14.8%
, 18
 
8.1%
. 6
 
2.7%
1 5
 
2.2%
3 4
 
1.8%
0 3
 
1.3%
2 3
 
1.3%
- 1
 
0.4%
Other values (6) 6
 
2.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 939
78.2%
ASCII 262
 
21.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
111
42.4%
( 33
 
12.6%
) 33
 
12.6%
, 18
 
6.9%
C 7
 
2.7%
. 6
 
2.3%
1 5
 
1.9%
P 5
 
1.9%
T 4
 
1.5%
3 4
 
1.5%
Other values (24) 36
 
13.7%
Hangul
ValueCountFrequency (%)
기 54
 
5.8%
장 50
 
5.3%
설 44
 
4.7%
비 42
 
4.5%
경 38
 
4.0%
조 27
 
2.9%
전 24
 
2.6%
주 22
 
2.3%
방 15
 
1.6%
보 15
 
1.6%
Other values (190) 608
64.7%

최초설치일
Date

Distinct3
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
Minimum2023-03-17 00:00:00
Maximum2023-12-19 00:00:00
2024-03-15T08:45:39.398425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:45:39.719690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=3)

교체일
Date

MISSING 

Distinct18
Distinct (%)85.7%
Missing117
Missing (%)84.8%
Memory size1.2 KiB
Minimum2022-08-17 00:00:00
Maximum2023-12-19 00:00:00
2024-03-15T08:45:40.046709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:45:40.391980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)

설치위치
Categorical

HIGH CORRELATION 

Distinct26
Distinct (%)18.8%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
경기장 전체
54 
주경기장
13 
실내체육관
11 
보조경기장
11 
기계실
11 
Other values (21)
38 

Length

Max length16
Median length11
Mean length5.0724638
Min length3

Unique

Unique12 ?
Unique (%)8.7%

Sample

1st row발전기실
2nd row발전기실
3rd row전기실
4th row전기실
5th row전기실

Common Values

ValueCountFrequency (%)
경기장 전체 54
39.1%
주경기장 13
 
9.4%
실내체육관 11
 
8.0%
보조경기장 11
 
8.0%
기계실 11
 
8.0%
전기실 5
 
3.6%
수변공간 4
 
2.9%
MDF실 4
 
2.9%
기계실.공조실 3
 
2.2%
펌프실 2
 
1.4%
Other values (16) 20
 
14.5%

Length

2024-03-15T08:45:40.787351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경기장 54
27.3%
전체 54
27.3%
주경기장 14
 
7.1%
기계실 12
 
6.1%
실내체육관 11
 
5.6%
보조경기장 11
 
5.6%
전기실 5
 
2.5%
수변공간 4
 
2.0%
mdf실 4
 
2.0%
기계실.공조실 3
 
1.5%
Other values (20) 26
13.1%

수량
Text

Distinct59
Distinct (%)42.8%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2024-03-15T08:45:41.438390image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length6
Mean length3.4057971
Min length1

Characters and Unicode

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

Unique

Unique53 ?
Unique (%)38.4%

Sample

1st row3SET
2nd row3SET
3rd row1식
4th row8SET
5th row18EA
ValueCountFrequency (%)
1식 63
45.7%
10set 6
 
4.3%
1set 5
 
3.6%
10ea 5
 
3.6%
3set 4
 
2.9%
7,140㎡ 2
 
1.4%
18ea 2
 
1.4%
122set 1
 
0.7%
24set 1
 
0.7%
352ea 1
 
0.7%
Other values (48) 48
34.8%
2024-03-15T08:45:42.552653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 104
22.1%
식 66
14.0%
E 47
10.0%
0 26
 
5.5%
3 26
 
5.5%
S 24
 
5.1%
T 24
 
5.1%
A 23
 
4.9%
2 22
 
4.7%
, 15
 
3.2%
Other values (12) 93
19.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 244
51.9%
Uppercase Letter 118
25.1%
Other Letter 75
 
16.0%
Other Punctuation 17
 
3.6%
Other Symbol 10
 
2.1%
Lowercase Letter 6
 
1.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 104
42.6%
0 26
 
10.7%
3 26
 
10.7%
2 22
 
9.0%
4 15
 
6.1%
9 13
 
5.3%
8 11
 
4.5%
5 10
 
4.1%
7 10
 
4.1%
6 7
 
2.9%
Uppercase Letter
ValueCountFrequency (%)
E 47
39.8%
S 24
20.3%
T 24
20.3%
A 23
19.5%
Lowercase Letter
ValueCountFrequency (%)
m 4
66.7%
e 1
 
16.7%
a 1
 
16.7%
Other Letter
ValueCountFrequency (%)
식 66
88.0%
대 9
 
12.0%
Other Punctuation
ValueCountFrequency (%)
, 15
88.2%
. 2
 
11.8%
Other Symbol
ValueCountFrequency (%)
㎡ 10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 271
57.7%
Latin 124
26.4%
Hangul 75
 
16.0%

Most frequent character per script

Common
ValueCountFrequency (%)
1 104
38.4%
0 26
 
9.6%
3 26
 
9.6%
2 22
 
8.1%
, 15
 
5.5%
4 15
 
5.5%
9 13
 
4.8%
8 11
 
4.1%
5 10
 
3.7%
㎡ 10
 
3.7%
Other values (3) 19
 
7.0%
Latin
ValueCountFrequency (%)
E 47
37.9%
S 24
19.4%
T 24
19.4%
A 23
18.5%
m 4
 
3.2%
e 1
 
0.8%
a 1
 
0.8%
Hangul
ValueCountFrequency (%)
식 66
88.0%
대 9
 
12.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 385
81.9%
Hangul 75
 
16.0%
CJK Compat 10
 
2.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 104
27.0%
E 47
12.2%
0 26
 
6.8%
3 26
 
6.8%
S 24
 
6.2%
T 24
 
6.2%
A 23
 
6.0%
2 22
 
5.7%
, 15
 
3.9%
4 15
 
3.9%
Other values (9) 59
15.3%
Hangul
ValueCountFrequency (%)
식 66
88.0%
대 9
 
12.0%
CJK Compat
ValueCountFrequency (%)
㎡ 10
100.0%

내구연한
Categorical

HIGH CORRELATION 

Distinct14
Distinct (%)10.1%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
20년
36 
10년
26 
40년
19 
8년
10 
11년
9 
Other values (9)
38 

Length

Max length3
Median length3
Mean length2.7898551
Min length2

Unique

Unique1 ?
Unique (%)0.7%

Sample

1st row30년
2nd row3년
3rd row20년
4th row25년
5th row3년

Common Values

ValueCountFrequency (%)
20년 36
26.1%
10년 26
18.8%
40년 19
13.8%
8년 10
 
7.2%
11년 9
 
6.5%
9년 7
 
5.1%
25년 6
 
4.3%
15년 6
 
4.3%
소모품 6
 
4.3%
7년 4
 
2.9%
Other values (4) 9
 
6.5%

Length

2024-03-15T08:45:42.992005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
20년 36
26.1%
10년 26
18.8%
40년 19
13.8%
8년 10
 
7.2%
11년 9
 
6.5%
9년 7
 
5.1%
25년 6
 
4.3%
15년 6
 
4.3%
소모품 6
 
4.3%
7년 4
 
2.9%
Other values (4) 9
 
6.5%

도래시기
Categorical

HIGH CORRELATION 

Distinct26
Distinct (%)18.8%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2031-06-01
35 
2021-06-01
23 
2051-06-01
19 
2019-06-01
8 
2022-06-01
7 
Other values (21)
46 

Length

Max length10
Median length10
Mean length9.7318841
Min length3

Unique

Unique13 ?
Unique (%)9.4%

Sample

1st row2041-06-01
2nd row2025-10-01
3rd row2031-06-01
4th row2036-06-01
5th row2028-07-01

Common Values

ValueCountFrequency (%)
2031-06-01 35
25.4%
2021-06-01 23
16.7%
2051-06-01 19
13.8%
2019-06-01 8
 
5.8%
2022-06-01 7
 
5.1%
2036-06-01 6
 
4.3%
2026-06-01 6
 
4.3%
2020-06-01 6
 
4.3%
<NA> 5
 
3.6%
2018-06-01 4
 
2.9%
Other values (16) 19
13.8%

Length

2024-03-15T08:45:43.411914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2031-06-01 35
25.4%
2021-06-01 23
16.7%
2051-06-01 19
13.8%
2019-06-01 8
 
5.8%
2022-06-01 7
 
5.1%
2036-06-01 6
 
4.3%
2026-06-01 6
 
4.3%
2020-06-01 6
 
4.3%
na 5
 
3.6%
2018-06-01 4
 
2.9%
Other values (16) 19
13.8%

상태평가
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
양호
138 

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 (%)
양호 138
100.0%

Length

2024-03-15T08:45:43.916334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T08:45:44.204555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
양호 138
100.0%

담당자의견
Text

MISSING 

Distinct42
Distinct (%)52.5%
Missing58
Missing (%)42.0%
Memory size1.2 KiB
2024-03-15T08:45:44.959820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length63
Median length51
Mean length33.775
Min length13

Characters and Unicode

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

Unique

Unique32 ?
Unique (%)40.0%

Sample

1st row내구연한도 많이 남았으며, 상태가 매우 양호
2nd row22년도에 교체완료 하였으며, 점검을 통해 추가 보수예정
3rd row내구연한도 많이 남았으며, 상태가 매우 양호
4th row내구연한도 많이 남았으며, 상태가 매우 양호
5th row2028년 전량 교체예정(2025년 교체완료)
ValueCountFrequency (%)
상태가 36
 
6.0%
교체예정 23
 
3.8%
따라 23
 
3.8%
양호 23
 
3.8%
점검결과에 19
 
3.2%
및 19
 
3.2%
예정 17
 
2.8%
지났으나 16
 
2.7%
점검결과 13
 
2.2%
지속적인 13
 
2.2%
Other values (152) 399
66.4%
2024-03-15T08:45:46.209299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
521
 
19.3%
2 76
 
2.8%
점 64
 
2.4%
검 64
 
2.4%
체 52
 
1.9%
교 52
 
1.9%
정 51
 
1.9%
, 50
 
1.9%
예 49
 
1.8%
상 47
 
1.7%
Other values (190) 1676
62.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1890
69.9%
Space Separator 521
 
19.3%
Decimal Number 150
 
5.6%
Other Punctuation 74
 
2.7%
Close Punctuation 27
 
1.0%
Open Punctuation 27
 
1.0%
Uppercase Letter 13
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 64
 
3.4%
검 64
 
3.4%
체 52
 
2.8%
교 52
 
2.8%
정 51
 
2.7%
예 49
 
2.6%
상 47
 
2.5%
에 45
 
2.4%
시 45
 
2.4%
가 44
 
2.3%
Other values (169) 1377
72.9%
Decimal Number
ValueCountFrequency (%)
2 76
50.7%
0 28
 
18.7%
7 13
 
8.7%
3 12
 
8.0%
1 9
 
6.0%
4 4
 
2.7%
9 3
 
2.0%
6 2
 
1.3%
5 2
 
1.3%
8 1
 
0.7%
Uppercase Letter
ValueCountFrequency (%)
L 3
23.1%
E 3
23.1%
D 3
23.1%
W 2
15.4%
S 1
 
7.7%
H 1
 
7.7%
Other Punctuation
ValueCountFrequency (%)
, 50
67.6%
. 24
32.4%
Space Separator
ValueCountFrequency (%)
521
100.0%
Close Punctuation
ValueCountFrequency (%)
) 27
100.0%
Open Punctuation
ValueCountFrequency (%)
( 27
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1890
69.9%
Common 799
29.6%
Latin 13
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 64
 
3.4%
검 64
 
3.4%
체 52
 
2.8%
교 52
 
2.8%
정 51
 
2.7%
예 49
 
2.6%
상 47
 
2.5%
에 45
 
2.4%
시 45
 
2.4%
가 44
 
2.3%
Other values (169) 1377
72.9%
Common
ValueCountFrequency (%)
521
65.2%
2 76
 
9.5%
, 50
 
6.3%
0 28
 
3.5%
) 27
 
3.4%
( 27
 
3.4%
. 24
 
3.0%
7 13
 
1.6%
3 12
 
1.5%
1 9
 
1.1%
Other values (5) 12
 
1.5%
Latin
ValueCountFrequency (%)
L 3
23.1%
E 3
23.1%
D 3
23.1%
W 2
15.4%
S 1
 
7.7%
H 1
 
7.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1890
69.9%
ASCII 812
30.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
521
64.2%
2 76
 
9.4%
, 50
 
6.2%
0 28
 
3.4%
) 27
 
3.3%
( 27
 
3.3%
. 24
 
3.0%
7 13
 
1.6%
3 12
 
1.5%
1 9
 
1.1%
Other values (11) 25
 
3.1%
Hangul
ValueCountFrequency (%)
점 64
 
3.4%
검 64
 
3.4%
체 52
 
2.8%
교 52
 
2.8%
정 51
 
2.7%
예 49
 
2.6%
상 47
 
2.5%
에 45
 
2.4%
시 45
 
2.4%
가 44
 
2.3%
Other values (169) 1377
72.9%

교체비용
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct70
Distinct (%)88.6%
Missing59
Missing (%)42.8%
Infinite0
Infinite (%)0.0%
Mean1.0593872 × 109
Minimum2500000
Maximum2.1800192 × 1010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2024-03-15T08:45:46.456495image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2500000
5-th percentile8150000
Q11.0225834 × 108
median2.5264354 × 108
Q38.8249215 × 108
95-th percentile4.1981905 × 109
Maximum2.1800192 × 1010
Range2.1797692 × 1010
Interquartile range (IQR)7.8023381 × 108

Descriptive statistics

Standard deviation2.6897801 × 109
Coefficient of variation (CV)2.5389964
Kurtosis46.355407
Mean1.0593872 × 109
Median Absolute Deviation (MAD)2.0354091 × 108
Skewness6.2735131
Sum8.3691585 × 1010
Variance7.2349171 × 1018
MonotonicityNot monotonic
2024-03-15T08:45:46.811220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
200000000 6
 
4.3%
100000000 4
 
2.9%
1000000000 2
 
1.4%
150000000 1
 
0.7%
5684642532 1
 
0.7%
5000000 1
 
0.7%
60000000 1
 
0.7%
800000000 1
 
0.7%
600000000 1
 
0.7%
923903609 1
 
0.7%
Other values (60) 60
43.5%
(Missing) 59
42.8%
ValueCountFrequency (%)
2500000 1
0.7%
3458579 1
0.7%
4469400 1
0.7%
5000000 1
0.7%
8500000 1
0.7%
23307177 1
0.7%
40000000 1
0.7%
42213464 1
0.7%
42231234 1
0.7%
49102629 1
0.7%
ValueCountFrequency (%)
21800192044 1
0.7%
6982521965 1
0.7%
5684642532 1
0.7%
4387062824 1
0.7%
4177204668 1
0.7%
3130914577 1
0.7%
2930445057 1
0.7%
2601476317 1
0.7%
2147727273 1
0.7%
2082872870 1
0.7%

수선율(퍼센트)
Categorical

HIGH CORRELATION 

Distinct25
Distinct (%)18.1%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
5(퍼센트)
26 
100(퍼센트)
23 
20(퍼센트)
20 
0(퍼센트)
15 
1(퍼센트)
7 
Other values (20)
47 

Length

Max length8
Median length7
Mean length6.7971014
Min length6

Unique

Unique12 ?
Unique (%)8.7%

Sample

1st row30(퍼센트)
2nd row50(퍼센트)
3rd row5(퍼센트)
4th row100(퍼센트)
5th row100(퍼센트)

Common Values

ValueCountFrequency (%)
5(퍼센트) 26
18.8%
100(퍼센트) 23
16.7%
20(퍼센트) 20
14.5%
0(퍼센트) 15
10.9%
1(퍼센트) 7
 
5.1%
10(퍼센트) 6
 
4.3%
2(퍼센트) 6
 
4.3%
3(퍼센트) 5
 
3.6%
50(퍼센트) 5
 
3.6%
0.3(퍼센트) 4
 
2.9%
Other values (15) 21
15.2%

Length

2024-03-15T08:45:47.283703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
5(퍼센트 26
18.8%
100(퍼센트 23
16.7%
20(퍼센트 20
14.5%
0(퍼센트 15
10.9%
1(퍼센트 7
 
5.1%
10(퍼센트 6
 
4.3%
2(퍼센트 6
 
4.3%
3(퍼센트 5
 
3.6%
50(퍼센트 5
 
3.6%
0.3(퍼센트 4
 
2.9%
Other values (15) 21
15.2%

필요예산
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct57
Distinct (%)86.4%
Missing72
Missing (%)52.2%
Infinite0
Infinite (%)0.0%
Mean47187938
Minimum172929
Maximum6.814899 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2024-03-15T08:45:47.709072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum172929
5-th percentile2000000
Q14602050
median10000000
Q323088498
95-th percentile2.7344186 × 108
Maximum6.814899 × 108
Range6.8131697 × 108
Interquartile range (IQR)18486448

Descriptive statistics

Standard deviation1.1935995 × 108
Coefficient of variation (CV)2.5294589
Kurtosis16.724687
Mean47187938
Median Absolute Deviation (MAD)7834987
Skewness4.0187743
Sum3.1144039 × 109
Variance1.4246797 × 1016
MonotonicityNot monotonic
2024-03-15T08:45:48.180037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2000000 6
 
4.3%
10000000 3
 
2.2%
5000000 2
 
1.4%
30000000 2
 
1.4%
2500000 1
 
0.7%
12531614 1
 
0.7%
8935512 1
 
0.7%
10835163 1
 
0.7%
16873482 1
 
0.7%
6215605 1
 
0.7%
Other values (47) 47
34.1%
(Missing) 72
52.2%
ValueCountFrequency (%)
172929 1
 
0.7%
1200000 1
 
0.7%
1500000 1
 
0.7%
2000000 6
4.3%
2110673 1
 
0.7%
2500000 1
 
0.7%
3105723 1
 
0.7%
3928969 1
 
0.7%
3933743 1
 
0.7%
4000000 1
 
0.7%
ValueCountFrequency (%)
681489900 1
0.7%
540540000 1
0.7%
386208225 1
0.7%
300000000 1
0.7%
193767438 1
0.7%
94141125 1
0.7%
92098060 1
0.7%
58303497 1
0.7%
51770635 1
0.7%
50000000 1
0.7%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
화성도시공사
138 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row 화성도시공사
2nd row 화성도시공사
3rd row 화성도시공사
4th row 화성도시공사
5th row 화성도시공사

Common Values

ValueCountFrequency (%)
화성도시공사 138
100.0%

Length

2024-03-15T08:45:48.617042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T08:45:48.929183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
화성도시공사 138
100.0%

관리자 연락처
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
031-371-0032
48 
031-371-0035
20 
031-371-0031
20 
031-371-0056
20 
031-371-0039
20 

Length

Max length14
Median length14
Mean length13.855072
Min length13

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row 031-371-0032
2nd row 031-371-0032
3rd row 031-371-0032
4th row 031-371-0032
5th row 031-371-0032

Common Values

ValueCountFrequency (%)
031-371-0032 48
34.8%
031-371-0035 20
14.5%
031-371-0031 20
14.5%
031-371-0056 20
14.5%
031-371-0039 20
14.5%
031-371-0057 10
 
7.2%

Length

2024-03-15T08:45:49.287392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T08:45:49.492172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
031-371-0032 48
34.8%
031-371-0035 20
14.5%
031-371-0031 20
14.5%
031-371-0056 20
14.5%
031-371-0039 20
14.5%
031-371-0057 10
 
7.2%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
Minimum2023-12-31 00:00:00
Maximum2023-12-31 00:00:00
2024-03-15T08:45:49.768577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:45:50.076895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-03-15T08:45:32.162965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:45:31.599466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:45:32.462993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:45:31.869022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T08:45:50.307295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공종최초설치일교체일설치위치수량내구연한도래시기담당자의견교체비용수선율(퍼센트)필요예산관리자 연락처
공종1.0000.0001.0000.8350.8400.9520.9170.9930.1780.8880.0001.000
최초설치일0.0001.0001.0000.0000.6200.1310.8530.4500.0000.5380.0000.199
교체일1.0001.0001.0000.9780.9100.9920.9951.000NaN0.8630.6131.000
설치위치0.8350.0000.9781.0000.7800.7410.7980.9020.0000.4820.0000.833
수량0.8400.6200.9100.7801.0000.7790.9450.9450.0000.0000.9750.805
내구연한0.9520.1310.9920.7410.7791.0000.9910.8190.0000.7960.1980.879
도래시기0.9170.8530.9950.7980.9450.9911.0000.9810.0000.6160.9180.918
담당자의견0.9930.4501.0000.9020.9450.8190.9811.0000.0000.9050.9390.993
교체비용0.1780.000NaN0.0000.0000.0000.0000.0001.0000.8560.0000.178
수선율(퍼센트)0.8880.5380.8630.4820.0000.7960.6160.9050.8561.0000.0000.892
필요예산0.0000.0000.6130.0000.9750.1980.9180.9390.0000.0001.0000.000
관리자 연락처1.0000.1991.0000.8330.8050.8790.9180.9930.1780.8920.0001.000
2024-03-15T08:45:50.651503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공종설치위치내구연한관리자 연락처도래시기수선율(퍼센트)
공종1.0000.5080.6650.9960.6550.597
설치위치0.5081.0000.3130.5180.2540.131
내구연한0.6650.3131.0000.6650.8800.372
관리자 연락처0.9960.5180.6651.0000.6620.614
도래시기0.6550.2540.8800.6621.0000.194
수선율(퍼센트)0.5970.1310.3720.6140.1941.000
2024-03-15T08:45:50.936656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
교체비용필요예산공종설치위치내구연한도래시기수선율(퍼센트)관리자 연락처
교체비용1.0000.4740.1460.0000.0000.0000.5600.146
필요예산0.4741.0000.0000.0000.0940.6530.0000.000
공종0.1460.0001.0000.5080.6650.6550.5970.996
설치위치0.0000.0000.5081.0000.3130.2540.1310.518
내구연한0.0000.0940.6650.3131.0000.8800.3720.665
도래시기0.0000.6530.6550.2540.8801.0000.1940.662
수선율(퍼센트)0.5600.0000.5970.1310.3720.1941.0000.614
관리자 연락처0.1460.0000.9960.5180.6650.6620.6141.000

Missing values

2024-03-15T08:45:32.962755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T08:45:33.856541image/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.
2024-03-15T08:45:34.319852image/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전기디젤엔진발전기2023-06-11<NA>발전기실3SET30년2041-06-01양호내구연한도 많이 남았으며, 상태가 매우 양호31380375030(퍼센트)94141125화성도시공사031-371-00322023-12-31
1전기발전기 소모품(필터, 배터리 등)2023-06-112023-10-22발전기실3SET3년2025-10-01양호22년도에 교체완료 하였으며, 점검을 통해 추가 보수예정850000050(퍼센트)4250000화성도시공사031-371-00322023-12-31
2전기특고압 수전반2023-06-11<NA>전기실1식20년2031-06-01양호내구연한도 많이 남았으며, 상태가 매우 양호10354126985(퍼센트)51770635화성도시공사031-371-00322023-12-31
3전기몰드변압기2023-06-11<NA>전기실8SET25년2036-06-01양호내구연한도 많이 남았으며, 상태가 매우 양호193767438100(퍼센트)193767438화성도시공사031-371-00322023-12-31
4전기정류반 축전지2023-06-112023-07-15전기실18EA3년2028-07-01양호2028년 전량 교체예정(2025년 교체완료)2500000100(퍼센트)5000000화성도시공사031-371-00322023-12-31
5전기분전반(옥내형)2023-06-11<NA>경기장 전체294SET10년2021-06-01양호내구연한도 많이 남았으며, 상태가 매우 양호3556129415(퍼센트)17780647화성도시공사031-371-00322023-12-31
6전기분전반(옥외형)2023-06-11<NA>경기장 전체14SET10년2021-06-01양호내구연한도 많이 남았으며, 상태가 매우 양호422134645(퍼센트)2110673화성도시공사031-371-00322023-12-31
7전기LCP반2023-06-11<NA>경기장 전체39SET10년2021-06-01양호평소 고장이 거의 없으며, 고장날 시 즉각 조치하겠음3340647285(퍼센트)16703236화성도시공사031-371-00322023-12-31
8전기MCC반2023-06-11<NA>전기실12SET20년2031-06-01양호평소 고장이 거의 없으며, 고장날 시 즉각 조치하겠음1693195205(퍼센트)8465976화성도시공사031-371-00322023-12-31
9전기UPS(무정전전원장치)2023-06-11<NA>UPS실1SET10년2021-06-01양호상태가 양호하여, 24년도 교체예정7194525030(퍼센트)21583575화성도시공사031-371-00322023-12-31
공종설비명최초설치일교체일설치위치수량내구연한도래시기상태평가담당자의견교체비용수선율(퍼센트)필요예산관리기관관리자 연락처데이터기준일자
128조경,토목보조경기장 잔디2023-06-11<NA>보조경기장7,140㎡소모품<NA>양호<NA><NA>90(퍼센트)<NA>화성도시공사031-371-00322023-12-31
129조경,토목보조경기장 트랙2023-06-112023-08-23보조경기장1식20년2043-06-01양호<NA><NA>100(퍼센트)<NA>화성도시공사031-371-00322023-12-31
130조경,토목예비포지 잔디2023-06-112023-05-21예비포지1,026㎡소모품<NA>양호<NA><NA>90(퍼센트)<NA>화성도시공사031-371-00322023-12-31
131조경,토목옥외시설(체육시설, 파골라, 벤치 등)2023-06-11<NA>경기장 전체1식20년2031-06-01양호<NA><NA>20(퍼센트)<NA>화성도시공사031-371-00322023-12-31
132조경,토목어린이놀이시설2023-06-11<NA>어린이놀이시설1식20년2031-06-01양호<NA><NA>20(퍼센트)<NA>화성도시공사031-371-00322023-12-31
133조경,토목잔디 스프링클러2023-06-11<NA>경기장 전체18ea20년2031-06-01양호<NA><NA>60(퍼센트)<NA>화성도시공사031-371-00322023-12-31
134조경,토목침전조2023-06-11<NA>수변공간1식20년2031-06-01양호<NA><NA>5(퍼센트)<NA>화성도시공사031-371-00322023-12-31
135조경,토목저류지2023-06-11<NA>수변공간1식20년2031-06-01양호<NA><NA>5(퍼센트)<NA>화성도시공사031-371-00322023-12-31
136조경,토목외부 조경 잔디2023-06-11<NA>경기장 전체51,436㎡소모품<NA>양호<NA><NA>20(퍼센트)<NA>화성도시공사031-371-00322023-12-31
137조경,토목외부 조경수2023-06-11<NA>경기장 전체1식소모품<NA>양호<NA><NA>20(퍼센트)<NA>화성도시공사031-371-00322023-12-31