Overview

Dataset statistics

Number of variables7
Number of observations282
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory16.1 KiB
Average record size in memory58.5 B

Variable types

Numeric2
Categorical3
Text2

Dataset

Description인천광역시 서구관내에 위치한 녹지 현황(지역구분, 녹지명, 소재지, 면적, 종류)에 관하여 입력된 엑셀 데이터파일입니다.
Author인천광역시 서구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15068428&srcSe=7661IVAWM27C61E190

Alerts

데이터기준일자 has constant value ""Constant
연번 is highly overall correlated with 지역구분High correlation
지역구분 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique

Reproduction

Analysis started2024-01-28 08:40:52.095114
Analysis finished2024-01-28 08:40:52.755932
Duration0.66 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct282
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean141.5
Minimum1
Maximum282
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.6 KiB
2024-01-28T17:40:52.813023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile15.05
Q171.25
median141.5
Q3211.75
95-th percentile267.95
Maximum282
Range281
Interquartile range (IQR)140.5

Descriptive statistics

Standard deviation81.550598
Coefficient of variation (CV)0.57632931
Kurtosis-1.2
Mean141.5
Median Absolute Deviation (MAD)70.5
Skewness0
Sum39903
Variance6650.5
MonotonicityStrictly increasing
2024-01-28T17:40:52.935298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
187 1
 
0.4%
193 1
 
0.4%
192 1
 
0.4%
191 1
 
0.4%
190 1
 
0.4%
189 1
 
0.4%
188 1
 
0.4%
186 1
 
0.4%
195 1
 
0.4%
Other values (272) 272
96.5%
ValueCountFrequency (%)
1 1
0.4%
2 1
0.4%
3 1
0.4%
4 1
0.4%
5 1
0.4%
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
10 1
0.4%
ValueCountFrequency (%)
282 1
0.4%
281 1
0.4%
280 1
0.4%
279 1
0.4%
278 1
0.4%
277 1
0.4%
276 1
0.4%
275 1
0.4%
274 1
0.4%
273 1
0.4%

지역구분
Categorical

HIGH CORRELATION 

Distinct13
Distinct (%)4.6%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
청라지구
109 
가정지구
35 
원도심지역
23 
원당지구
20 
검단산단
19 
Other values (8)
76 

Length

Max length5
Median length4
Mean length4.1382979
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row원도심지역
2nd row원도심지역
3rd row원도심지역
4th row원도심지역
5th row원도심지역

Common Values

ValueCountFrequency (%)
청라지구 109
38.7%
가정지구 35
 
12.4%
원도심지역 23
 
8.2%
원당지구 20
 
7.1%
검단산단 19
 
6.7%
오류지구 17
 
6.0%
당하지구 16
 
5.7%
검단2지구 13
 
4.6%
아라뱃길 11
 
3.9%
북항지역 9
 
3.2%
Other values (3) 10
 
3.5%

Length

2024-01-28T17:40:53.051127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
청라지구 109
38.7%
가정지구 35
 
12.4%
원도심지역 23
 
8.2%
원당지구 20
 
7.1%
검단산단 19
 
6.7%
오류지구 17
 
6.0%
당하지구 16
 
5.7%
검단2지구 13
 
4.6%
아라뱃길 11
 
3.9%
북항지역 9
 
3.2%
Other values (3) 10
 
3.5%

녹지명
Text

Distinct269
Distinct (%)95.4%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
2024-01-28T17:40:53.261213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length15
Mean length8.8971631
Min length4

Characters and Unicode

Total characters2509
Distinct characters80
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

Unique256 ?
Unique (%)90.8%

Sample

1st row인천교녹지
2nd row석남녹지
3rd row가좌녹지
4th row검암1녹지
5th row검암2-2녹지
ValueCountFrequency (%)
완충녹지 98
 
22.8%
경관녹지 13
 
3.0%
청라 13
 
3.0%
검단일반산업단지 9
 
2.1%
북항배후단지 8
 
1.9%
경서국민임대주택단지 3
 
0.7%
원당19녹지 2
 
0.5%
주공2단지 2
 
0.5%
오류18녹지 2
 
0.5%
경관2녹지 2
 
0.5%
Other values (265) 278
64.7%
2024-01-28T17:40:53.607003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
지 342
 
13.6%
녹 281
 
11.2%
호 172
 
6.9%
149
 
5.9%
라 126
 
5.0%
완 121
 
4.8%
충 121
 
4.8%
청 114
 
4.5%
1 113
 
4.5%
2 81
 
3.2%
Other values (70) 889
35.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1870
74.5%
Decimal Number 460
 
18.3%
Space Separator 149
 
5.9%
Dash Punctuation 22
 
0.9%
Open Punctuation 4
 
0.2%
Close Punctuation 4
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
지 342
18.3%
녹 281
15.0%
호 172
 
9.2%
라 126
 
6.7%
완 121
 
6.5%
충 121
 
6.5%
청 114
 
6.1%
단 57
 
3.0%
당 44
 
2.4%
가 37
 
2.0%
Other values (56) 455
24.3%
Decimal Number
ValueCountFrequency (%)
1 113
24.6%
2 81
17.6%
5 38
 
8.3%
6 35
 
7.6%
3 35
 
7.6%
4 34
 
7.4%
8 34
 
7.4%
7 33
 
7.2%
9 32
 
7.0%
0 25
 
5.4%
Space Separator
ValueCountFrequency (%)
149
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 22
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1870
74.5%
Common 639
 
25.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
지 342
18.3%
녹 281
15.0%
호 172
 
9.2%
라 126
 
6.7%
완 121
 
6.5%
충 121
 
6.5%
청 114
 
6.1%
단 57
 
3.0%
당 44
 
2.4%
가 37
 
2.0%
Other values (56) 455
24.3%
Common
ValueCountFrequency (%)
149
23.3%
1 113
17.7%
2 81
12.7%
5 38
 
5.9%
6 35
 
5.5%
3 35
 
5.5%
4 34
 
5.3%
8 34
 
5.3%
7 33
 
5.2%
9 32
 
5.0%
Other values (4) 55
 
8.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1870
74.5%
ASCII 639
 
25.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
지 342
18.3%
녹 281
15.0%
호 172
 
9.2%
라 126
 
6.7%
완 121
 
6.5%
충 121
 
6.5%
청 114
 
6.1%
단 57
 
3.0%
당 44
 
2.4%
가 37
 
2.0%
Other values (56) 455
24.3%
ASCII
ValueCountFrequency (%)
149
23.3%
1 113
17.7%
2 81
12.7%
5 38
 
5.9%
6 35
 
5.5%
3 35
 
5.5%
4 34
 
5.3%
8 34
 
5.3%
7 33
 
5.2%
9 32
 
5.0%
Other values (4) 55
 
8.6%

소재지
Text

Distinct270
Distinct (%)95.7%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
2024-01-28T17:40:53.935493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length40
Median length39
Mean length21.794326
Min length9

Characters and Unicode

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

Unique

Unique258 ?
Unique (%)91.5%

Sample

1st row인천광역시 서구 가좌동 606-2 일원
2nd row인천광역시 서구 석남동 223-494 일원
3rd row인천광역시 서구 가좌동 376-1 일원
4th row인천광역시 서구 검암동 595-1~666-4
5th row인천광역시 서구 검암동 492-3 일원
ValueCountFrequency (%)
인천광역시 282
20.0%
서구 282
20.0%
일원 265
18.8%
청라동 109
 
7.7%
가정동 32
 
2.3%
오류동 28
 
2.0%
마전동 24
 
1.7%
당하동 20
 
1.4%
원당동 19
 
1.3%
경서동 9
 
0.6%
Other values (305) 341
24.2%
2024-01-28T17:40:54.364553image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1130
18.4%
1 390
 
6.3%
원 294
 
4.8%
서 292
 
4.8%
구 282
 
4.6%
천 282
 
4.6%
동 282
 
4.6%
인 282
 
4.6%
시 282
 
4.6%
역 282
 
4.6%
Other values (50) 2348
38.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3376
54.9%
Decimal Number 1331
 
21.7%
Space Separator 1130
 
18.4%
Dash Punctuation 275
 
4.5%
Other Punctuation 27
 
0.4%
Close Punctuation 3
 
< 0.1%
Open Punctuation 3
 
< 0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
원 294
8.7%
서 292
8.6%
구 282
8.4%
천 282
8.4%
동 282
8.4%
인 282
8.4%
시 282
8.4%
역 282
8.4%
광 282
8.4%
일 268
7.9%
Other values (34) 548
16.2%
Decimal Number
ValueCountFrequency (%)
1 390
29.3%
6 121
 
9.1%
2 121
 
9.1%
0 117
 
8.8%
7 112
 
8.4%
5 112
 
8.4%
4 105
 
7.9%
3 101
 
7.6%
9 80
 
6.0%
8 72
 
5.4%
Space Separator
ValueCountFrequency (%)
1130
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 275
100.0%
Other Punctuation
ValueCountFrequency (%)
, 27
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3376
54.9%
Common 2770
45.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
원 294
8.7%
서 292
8.6%
구 282
8.4%
천 282
8.4%
동 282
8.4%
인 282
8.4%
시 282
8.4%
역 282
8.4%
광 282
8.4%
일 268
7.9%
Other values (34) 548
16.2%
Common
ValueCountFrequency (%)
1130
40.8%
1 390
 
14.1%
- 275
 
9.9%
6 121
 
4.4%
2 121
 
4.4%
0 117
 
4.2%
7 112
 
4.0%
5 112
 
4.0%
4 105
 
3.8%
3 101
 
3.6%
Other values (6) 186
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3376
54.9%
ASCII 2770
45.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1130
40.8%
1 390
 
14.1%
- 275
 
9.9%
6 121
 
4.4%
2 121
 
4.4%
0 117
 
4.2%
7 112
 
4.0%
5 112
 
4.0%
4 105
 
3.8%
3 101
 
3.6%
Other values (6) 186
 
6.7%
Hangul
ValueCountFrequency (%)
원 294
8.7%
서 292
8.6%
구 282
8.4%
천 282
8.4%
동 282
8.4%
인 282
8.4%
시 282
8.4%
역 282
8.4%
광 282
8.4%
일 268
7.9%
Other values (34) 548
16.2%

면적(제곱미터)
Real number (ℝ)

Distinct275
Distinct (%)97.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5292.4443
Minimum39.8
Maximum155080
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.6 KiB
2024-01-28T17:40:54.485092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum39.8
5-th percentile190.135
Q1879
median2284.55
Q35732.325
95-th percentile18224.41
Maximum155080
Range155040.2
Interquartile range (IQR)4853.325

Descriptive statistics

Standard deviation11909.571
Coefficient of variation (CV)2.2502969
Kurtosis94.301258
Mean5292.4443
Median Absolute Deviation (MAD)1612.15
Skewness8.4339808
Sum1492469.3
Variance1.4183788 × 108
MonotonicityNot monotonic
2024-01-28T17:40:54.605799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
298.1 2
 
0.7%
754.0 2
 
0.7%
107.7 2
 
0.7%
986.6 2
 
0.7%
1196.9 2
 
0.7%
114.7 2
 
0.7%
207.1 2
 
0.7%
5344.0 1
 
0.4%
2018.9 1
 
0.4%
2060.5 1
 
0.4%
Other values (265) 265
94.0%
ValueCountFrequency (%)
39.8 1
0.4%
69.2 1
0.4%
84.9 1
0.4%
88.6 1
0.4%
106.0 1
0.4%
107.7 2
0.7%
114.0 1
0.4%
114.7 2
0.7%
129.7 1
0.4%
134.4 1
0.4%
ValueCountFrequency (%)
155080.0 1
0.4%
76103.0 1
0.4%
52095.9 1
0.4%
46998.3 1
0.4%
39139.2 1
0.4%
25365.2 1
0.4%
24068.1 1
0.4%
22954.6 1
0.4%
22908.0 1
0.4%
21935.3 1
0.4%

종류
Categorical

Distinct3
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
완충녹지
221 
경관녹지
59 
연결녹지
 
2

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row완충녹지
2nd row완충녹지
3rd row완충녹지
4th row완충녹지
5th row완충녹지

Common Values

ValueCountFrequency (%)
완충녹지 221
78.4%
경관녹지 59
 
20.9%
연결녹지 2
 
0.7%

Length

2024-01-28T17:40:54.714330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T17:40:54.791512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
완충녹지 221
78.4%
경관녹지 59
 
20.9%
연결녹지 2
 
0.7%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
2022-09-05
282 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-09-05
2nd row2022-09-05
3rd row2022-09-05
4th row2022-09-05
5th row2022-09-05

Common Values

ValueCountFrequency (%)
2022-09-05 282
100.0%

Length

2024-01-28T17:40:54.877690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T17:40:54.962192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-09-05 282
100.0%

Interactions

2024-01-28T17:40:52.451530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T17:40:52.307810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T17:40:52.527290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T17:40:52.375120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-28T17:40:55.016640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번지역구분면적(제곱미터)종류
연번1.0000.9170.0900.422
지역구분0.9171.0000.0000.269
면적(제곱미터)0.0900.0001.0000.000
종류0.4220.2690.0001.000
2024-01-28T17:40:55.096373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지역구분종류
지역구분1.0000.154
종류0.1541.000
2024-01-28T17:40:55.167933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번면적(제곱미터)지역구분종류
연번1.0000.1260.7080.276
면적(제곱미터)0.1261.0000.0000.000
지역구분0.7080.0001.0000.154
종류0.2760.0000.1541.000

Missing values

2024-01-28T17:40:52.628906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T17:40:52.717829image/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원도심지역인천교녹지인천광역시 서구 가좌동 606-2 일원21309.0완충녹지2022-09-05
12원도심지역석남녹지인천광역시 서구 석남동 223-494 일원155080.0완충녹지2022-09-05
23원도심지역가좌녹지인천광역시 서구 가좌동 376-1 일원76103.0완충녹지2022-09-05
34원도심지역검암1녹지인천광역시 서구 검암동 595-1~666-4972.8완충녹지2022-09-05
45원도심지역검암2-2녹지인천광역시 서구 검암동 492-3 일원540.7완충녹지2022-09-05
56원도심지역검암2-3녹지인천광역시 서구 검암동 525-4, 525-9 일원647.4완충녹지2022-09-05
67원도심지역검암2-4녹지인천광역시 서구 검암동 524-1 일원3223.3완충녹지2022-09-05
78원도심지역현대정유녹지인천광역시 서구 원창동 379 일원20740.0완충녹지2022-09-05
89원도심지역서부산단녹지인천광역시 서구 경서동 692-2 외 5개소15354.7완충녹지2022-09-05
910원도심지역연희2-1녹지(길쌈마을 쉼터)인천광역시 서구 연희동 684-7 일원252.4경관녹지2022-09-05
연번지역구분녹지명소재지면적(제곱미터)종류데이터기준일자
272273가정지구가정지구5호경관녹지인천광역시 서구 신현동 110-3 일원1929.9경관녹지2022-09-05
273274가정지구가정지구6호경관녹지인천광역시 서구 신현동 213-50 일원3814.5경관녹지2022-09-05
274275가정지구가정지구7호경관녹지인천광역시 서구 가정동 71-141 일원6738.1경관녹지2022-09-05
275276가정지구가정지구8호경관녹지인천광역시 서구 가정동 106-19 일원88.6경관녹지2022-09-05
276277가정지구가정지구9호경관녹지인천광역시 서구 가정동 106-33 일원84.9경관녹지2022-09-05
277278가정지구가정지구10호경관녹지인천광역시 서구 가정동 106-29 일원129.7경관녹지2022-09-05
278279가정지구가정지구11호경관녹지인천광역시 서구 가정동 106-38 일원162.5경관녹지2022-09-05
279280가정지구가정지구12호경관녹지인천광역시 서구 가정동 산72-1 일원983.5경관녹지2022-09-05
280281가정지구가정지구1호연결녹지인천광역시 서구 가정동 71-2 일원11826.7연결녹지2022-09-05
281282가정지구가정지구2호연결녹지인천광역시 서구 가정동 73-11 일원14253.6연결녹지2022-09-05