Overview

Dataset statistics

Number of variables7
Number of observations219
Missing cells125
Missing cells (%)8.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory12.3 KiB
Average record size in memory57.6 B

Variable types

Numeric1
Categorical2
Text3
DateTime1

Dataset

Description인천광역시 남동구 공원 전기시설의 안전점검결과에 대한 데이터로 연번, 설비유형, 공원, 제어함, 주소, 점검결과 부적합내역 정비상항, 기타사항 항목을 개방합니다.
Author인천광역시 남동구
URLhttps://www.data.go.kr/data/15067731/fileData.do

Alerts

점검결과 has constant value ""Constant
데이터기준일자 has constant value ""Constant
연번 is highly overall correlated with 설비유형High correlation
설비유형 is highly overall correlated with 연번High correlation
설비유형 is highly imbalanced (66.8%)Imbalance
제어함명 has 125 (57.1%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 21:53:17.819369
Analysis finished2023-12-12 21:53:18.751064
Duration0.93 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct219
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean110
Minimum1
Maximum219
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.1 KiB
2023-12-13T06:53:18.836011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile11.9
Q155.5
median110
Q3164.5
95-th percentile208.1
Maximum219
Range218
Interquartile range (IQR)109

Descriptive statistics

Standard deviation63.364028
Coefficient of variation (CV)0.57603661
Kurtosis-1.2
Mean110
Median Absolute Deviation (MAD)55
Skewness0
Sum24090
Variance4015
MonotonicityStrictly increasing
2023-12-13T06:53:18.992944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.5%
152 1
 
0.5%
141 1
 
0.5%
142 1
 
0.5%
143 1
 
0.5%
144 1
 
0.5%
145 1
 
0.5%
146 1
 
0.5%
147 1
 
0.5%
148 1
 
0.5%
Other values (209) 209
95.4%
ValueCountFrequency (%)
1 1
0.5%
2 1
0.5%
3 1
0.5%
4 1
0.5%
5 1
0.5%
6 1
0.5%
7 1
0.5%
8 1
0.5%
9 1
0.5%
10 1
0.5%
ValueCountFrequency (%)
219 1
0.5%
218 1
0.5%
217 1
0.5%
216 1
0.5%
215 1
0.5%
214 1
0.5%
213 1
0.5%
212 1
0.5%
211 1
0.5%
210 1
0.5%

설비유형
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct4
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
공원등
194 
화장실
 
12
수경시설
 
11
화장실/수경시설
 
2

Length

Max length8
Median length3
Mean length3.0958904
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row공원등
2nd row공원등
3rd row공원등
4th row공원등
5th row공원등

Common Values

ValueCountFrequency (%)
공원등 194
88.6%
화장실 12
 
5.5%
수경시설 11
 
5.0%
화장실/수경시설 2
 
0.9%

Length

2023-12-13T06:53:19.155183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:53:19.284981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공원등 194
88.6%
화장실 12
 
5.5%
수경시설 11
 
5.0%
화장실/수경시설 2
 
0.9%

공원
Text

Distinct153
Distinct (%)69.9%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-13T06:53:19.530570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length15
Mean length7.1369863
Min length4

Characters and Unicode

Total characters1563
Distinct characters183
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

Unique130 ?
Unique (%)59.4%

Sample

1st row큰구월어린이공원
2nd row만월어린이공원
3rd row큰성말어린이공원
4th row작은성말어린이공원
5th row독점어린이공원
ValueCountFrequency (%)
논현포대근린공원 18
 
8.0%
늘솔길공원 16
 
7.1%
해오름공원 5
 
2.2%
호구포근린공원 4
 
1.8%
논현중앙공원 4
 
1.8%
전재울근린공원 4
 
1.8%
구월근린공원 3
 
1.3%
어울근린공원 3
 
1.3%
만수1녹지 3
 
1.3%
인천아시아드근린공원 3
 
1.3%
Other values (147) 163
72.1%
2023-12-13T06:53:19.905133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
공 209
 
13.4%
원 207
 
13.2%
린 147
 
9.4%
어 95
 
6.1%
이 95
 
6.1%
근 55
 
3.5%
지 31
 
2.0%
논 24
 
1.5%
현 24
 
1.5%
포 23
 
1.5%
Other values (173) 653
41.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1498
95.8%
Decimal Number 37
 
2.4%
Space Separator 14
 
0.9%
Uppercase Letter 6
 
0.4%
Close Punctuation 3
 
0.2%
Open Punctuation 3
 
0.2%
Dash Punctuation 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
공 209
 
14.0%
원 207
 
13.8%
린 147
 
9.8%
어 95
 
6.3%
이 95
 
6.3%
근 55
 
3.7%
지 31
 
2.1%
논 24
 
1.6%
현 24
 
1.6%
포 23
 
1.5%
Other values (158) 588
39.3%
Decimal Number
ValueCountFrequency (%)
1 18
48.6%
2 8
21.6%
3 5
 
13.5%
9 2
 
5.4%
6 1
 
2.7%
5 1
 
2.7%
4 1
 
2.7%
8 1
 
2.7%
Uppercase Letter
ValueCountFrequency (%)
L 2
33.3%
E 2
33.3%
D 2
33.3%
Space Separator
ValueCountFrequency (%)
14
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1498
95.8%
Common 59
 
3.8%
Latin 6
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
공 209
 
14.0%
원 207
 
13.8%
린 147
 
9.8%
어 95
 
6.3%
이 95
 
6.3%
근 55
 
3.7%
지 31
 
2.1%
논 24
 
1.6%
현 24
 
1.6%
포 23
 
1.5%
Other values (158) 588
39.3%
Common
ValueCountFrequency (%)
1 18
30.5%
14
23.7%
2 8
13.6%
3 5
 
8.5%
) 3
 
5.1%
( 3
 
5.1%
9 2
 
3.4%
- 2
 
3.4%
6 1
 
1.7%
5 1
 
1.7%
Other values (2) 2
 
3.4%
Latin
ValueCountFrequency (%)
L 2
33.3%
E 2
33.3%
D 2
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1498
95.8%
ASCII 65
 
4.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
공 209
 
14.0%
원 207
 
13.8%
린 147
 
9.8%
어 95
 
6.3%
이 95
 
6.3%
근 55
 
3.7%
지 31
 
2.1%
논 24
 
1.6%
현 24
 
1.6%
포 23
 
1.5%
Other values (158) 588
39.3%
ASCII
ValueCountFrequency (%)
1 18
27.7%
14
21.5%
2 8
12.3%
3 5
 
7.7%
) 3
 
4.6%
( 3
 
4.6%
L 2
 
3.1%
E 2
 
3.1%
D 2
 
3.1%
9 2
 
3.1%
Other values (5) 6
 
9.2%

제어함명
Text

MISSING 

Distinct57
Distinct (%)60.6%
Missing125
Missing (%)57.1%
Memory size1.8 KiB
2023-12-13T06:53:20.149241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length5
Mean length5.6595745
Min length2

Characters and Unicode

Total characters532
Distinct characters65
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

Unique38 ?
Unique (%)40.4%

Sample

1st row1호
2nd row2호
3rd row1호
4th row근린공원1호 LP3
5th row근린공원1호 LP4
ValueCountFrequency (%)
lp-01 5
 
4.5%
lp-02 5
 
4.5%
lp-03 4
 
3.6%
늘솔길공원 4
 
3.6%
lp-07 3
 
2.7%
근린공원1호 3
 
2.7%
화장실1 3
 
2.7%
lp-09 3
 
2.7%
1호 3
 
2.7%
화장실2 3
 
2.7%
Other values (51) 75
67.6%
2023-12-13T06:53:20.496942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
L 71
13.3%
P 71
13.3%
- 64
 
12.0%
1 39
 
7.3%
0 38
 
7.1%
2 31
 
5.8%
17
 
3.2%
공 14
 
2.6%
호 13
 
2.4%
원 12
 
2.3%
Other values (55) 162
30.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 157
29.5%
Other Letter 148
27.8%
Uppercase Letter 144
27.1%
Dash Punctuation 64
12.0%
Space Separator 17
 
3.2%
Close Punctuation 1
 
0.2%
Open Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
공 14
 
9.5%
호 13
 
8.8%
원 12
 
8.1%
장 9
 
6.1%
화 8
 
5.4%
근 8
 
5.4%
린 8
 
5.4%
실 8
 
5.4%
솔 4
 
2.7%
늘 4
 
2.7%
Other values (38) 60
40.5%
Decimal Number
ValueCountFrequency (%)
1 39
24.8%
0 38
24.2%
2 31
19.7%
3 11
 
7.0%
4 8
 
5.1%
5 7
 
4.5%
6 7
 
4.5%
9 6
 
3.8%
8 5
 
3.2%
7 5
 
3.2%
Uppercase Letter
ValueCountFrequency (%)
L 71
49.3%
P 71
49.3%
B 2
 
1.4%
Dash Punctuation
ValueCountFrequency (%)
- 64
100.0%
Space Separator
ValueCountFrequency (%)
17
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 240
45.1%
Hangul 148
27.8%
Latin 144
27.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
공 14
 
9.5%
호 13
 
8.8%
원 12
 
8.1%
장 9
 
6.1%
화 8
 
5.4%
근 8
 
5.4%
린 8
 
5.4%
실 8
 
5.4%
솔 4
 
2.7%
늘 4
 
2.7%
Other values (38) 60
40.5%
Common
ValueCountFrequency (%)
- 64
26.7%
1 39
16.2%
0 38
15.8%
2 31
12.9%
17
 
7.1%
3 11
 
4.6%
4 8
 
3.3%
5 7
 
2.9%
6 7
 
2.9%
9 6
 
2.5%
Other values (4) 12
 
5.0%
Latin
ValueCountFrequency (%)
L 71
49.3%
P 71
49.3%
B 2
 
1.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 384
72.2%
Hangul 148
 
27.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
L 71
18.5%
P 71
18.5%
- 64
16.7%
1 39
10.2%
0 38
9.9%
2 31
8.1%
17
 
4.4%
3 11
 
2.9%
4 8
 
2.1%
5 7
 
1.8%
Other values (7) 27
 
7.0%
Hangul
ValueCountFrequency (%)
공 14
 
9.5%
호 13
 
8.8%
원 12
 
8.1%
장 9
 
6.1%
화 8
 
5.4%
근 8
 
5.4%
린 8
 
5.4%
실 8
 
5.4%
솔 4
 
2.7%
늘 4
 
2.7%
Other values (38) 60
40.5%

주소
Text

Distinct152
Distinct (%)69.4%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-13T06:53:20.856601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length25
Mean length19.356164
Min length17

Characters and Unicode

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

Unique

Unique125 ?
Unique (%)57.1%

Sample

1st row인천광역시 남동구 구월동 1196-4
2nd row인천광역시 남동구 구월1동 1229-2
3rd row인천광역시 남동구 구월동 1163
4th row인천광역시 남동구 구월동 1192-7
5th row인천광역시 남동구 구월1동 1215-7
ValueCountFrequency (%)
인천광역시 219
25.0%
남동구 219
25.0%
논현2동 34
 
3.9%
서창동 31
 
3.5%
논현동 20
 
2.3%
논현고잔동 19
 
2.2%
구월동 18
 
2.1%
738-8 16
 
1.8%
간석동 15
 
1.7%
578-1 12
 
1.4%
Other values (161) 274
31.2%
2023-12-13T06:53:21.319369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
659
15.5%
동 435
 
10.3%
구 257
 
6.1%
남 223
 
5.3%
인 219
 
5.2%
광 219
 
5.2%
역 219
 
5.2%
시 219
 
5.2%
천 219
 
5.2%
- 158
 
3.7%
Other values (33) 1412
33.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2459
58.0%
Decimal Number 957
 
22.6%
Space Separator 659
 
15.5%
Dash Punctuation 158
 
3.7%
Close Punctuation 3
 
0.1%
Open Punctuation 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 435
17.7%
구 257
10.5%
남 223
9.1%
인 219
8.9%
광 219
8.9%
역 219
8.9%
시 219
8.9%
천 219
8.9%
논 82
 
3.3%
현 82
 
3.3%
Other values (19) 285
11.6%
Decimal Number
ValueCountFrequency (%)
1 157
16.4%
2 117
12.2%
7 108
11.3%
6 102
10.7%
5 98
10.2%
4 96
10.0%
8 90
9.4%
3 84
8.8%
9 57
 
6.0%
0 48
 
5.0%
Space Separator
ValueCountFrequency (%)
659
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 158
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2459
58.0%
Common 1780
42.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 435
17.7%
구 257
10.5%
남 223
9.1%
인 219
8.9%
광 219
8.9%
역 219
8.9%
시 219
8.9%
천 219
8.9%
논 82
 
3.3%
현 82
 
3.3%
Other values (19) 285
11.6%
Common
ValueCountFrequency (%)
659
37.0%
- 158
 
8.9%
1 157
 
8.8%
2 117
 
6.6%
7 108
 
6.1%
6 102
 
5.7%
5 98
 
5.5%
4 96
 
5.4%
8 90
 
5.1%
3 84
 
4.7%
Other values (4) 111
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2459
58.0%
ASCII 1780
42.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
659
37.0%
- 158
 
8.9%
1 157
 
8.8%
2 117
 
6.6%
7 108
 
6.1%
6 102
 
5.7%
5 98
 
5.5%
4 96
 
5.4%
8 90
 
5.1%
3 84
 
4.7%
Other values (4) 111
 
6.2%
Hangul
ValueCountFrequency (%)
동 435
17.7%
구 257
10.5%
남 223
9.1%
인 219
8.9%
광 219
8.9%
역 219
8.9%
시 219
8.9%
천 219
8.9%
논 82
 
3.3%
현 82
 
3.3%
Other values (19) 285
11.6%

점검결과
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
적합
219 

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 (%)
적합 219
100.0%

Length

2023-12-13T06:53:21.437646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:53:21.519060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
적합 219
100.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
Minimum2022-08-08 00:00:00
Maximum2022-08-08 00:00:00
2023-12-13T06:53:21.592803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:53:21.667953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T06:53:18.388235image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T06:53:21.730122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비유형제어함명
연번1.0000.7210.000
설비유형0.7211.0001.000
제어함명0.0001.0001.000
2023-12-13T06:53:21.805267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비유형
연번1.0000.518
설비유형0.5181.000

Missing values

2023-12-13T06:53:18.541240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T06:53:18.706222image/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공원등큰구월어린이공원<NA>인천광역시 남동구 구월동 1196-4적합2022-08-08
12공원등만월어린이공원<NA>인천광역시 남동구 구월1동 1229-2적합2022-08-08
23공원등큰성말어린이공원<NA>인천광역시 남동구 구월동 1163적합2022-08-08
34공원등작은성말어린이공원<NA>인천광역시 남동구 구월동 1192-7적합2022-08-08
45공원등독점어린이공원<NA>인천광역시 남동구 구월1동 1215-7적합2022-08-08
56공원등독점어린이공원<NA>인천광역시 남동구 구월1동 1215-7적합2022-08-08
67공원등성리어린이공원1호인천광역시 남동구 구월동 455-2(1495)적합2022-08-08
78공원등무지개어린이공원2호인천광역시 남동구 구월1동 590적합2022-08-08
89공원등소공원1호(구월소공원)1호인천광역시 남동구 구월동 440-2(1486-2)적합2022-08-08
910공원등전재울근린공원근린공원1호 LP3인천광역시 남동구 구월1동 492적합2022-08-08
연번설비유형공원제어함명주소점검결과데이터기준일자
209210수경시설인천아시아드근린공원인천아시아드인천광역시 남동구 구월동 474적합2022-08-08
210211수경시설찬우물근린공원은빛호수인천광역시 남동구 구월동 726-2적합2022-08-08
211212수경시설구월근린공원<NA>인천광역시 남동구 호구포로857번길 36-9적합2022-08-08
212213수경시설구월경관녹지공원<NA>인천광역시 남동구 구월2동 20-1적합2022-08-08
213214수경시설동녘어린이공원<NA>인천광역시 남동구 논현1동 600-7적합2022-08-08
214215수경시설아랫말어린이공원<NA>인천광역시 남동구 논현동 601-2적합2022-08-08
215216수경시설논현중앙공원<NA>인천광역시 남동구 논현동 611-7적합2022-08-08
216217수경시설늘솔길공원<NA>인천광역시 남동구 논현동 738-8적합2022-08-08
217218수경시설논현포대근린공원계류인천광역시 남동구 논현2동 578-1적합2022-08-08
218219수경시설논현포대근린공원벽천인천광역시 남동구 논현2동 578-1적합2022-08-08