Overview

Dataset statistics

Number of variables10
Number of observations149
Missing cells1
Missing cells (%)0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.8 KiB
Average record size in memory80.9 B

Variable types

Categorical3
Unsupported7

Dataset

Description장기미집행도시계획시설현황20178
Author전라북도
URLhttps://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=202479

Alerts

시도명 is highly overall correlated with 시군구명High correlation
시군구명 is highly overall correlated with 시도명High correlation
시도명 is highly imbalanced (73.3%)Imbalance
(부분)미집행 결정면적 is an unsupported type, check if it needs cleaning or further analysisUnsupported
미집행10년미만 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysisUnsupported
미집행10년이상 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-03-14 01:08:25.907130
Analysis finished2024-03-14 01:08:26.301173
Duration0.39 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도명
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct5
Distinct (%)3.4%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
전라북도
132 
14 
<NA>
 
1
전라북도계
 
1
합 계
 
1

Length

Max length5
Median length4
Mean length3.7181208
Min length1

Unique

Unique3 ?
Unique (%)2.0%

Sample

1st row<NA>
2nd row전라북도
3rd row전라북도
4th row전라북도
5th row전라북도

Common Values

ValueCountFrequency (%)
전라북도 132
88.6%
14
 
9.4%
<NA> 1
 
0.7%
전라북도계 1
 
0.7%
합 계 1
 
0.7%

Length

2024-03-14T10:08:26.381433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T10:08:26.472792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전라북도 132
97.1%
na 1
 
0.7%
전라북도계 1
 
0.7%
합 1
 
0.7%
계 1
 
0.7%

시군구명
Categorical

HIGH CORRELATION 

Distinct30
Distinct (%)20.1%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
군산시
17 
전주시
14 
완주군
14 
부안군
12 
남원시
12 
Other values (25)
80 

Length

Max length4
Median length3
Mean length3.0738255
Min length1

Unique

Unique15 ?
Unique (%)10.1%

Sample

1st row<NA>
2nd row전주시
3rd row전주시
4th row전주시
5th row전주시

Common Values

ValueCountFrequency (%)
군산시 17
11.4%
전주시 14
9.4%
완주군 14
9.4%
부안군 12
 
8.1%
남원시 12
 
8.1%
순창군 11
 
7.4%
임실군 11
 
7.4%
고창군 10
 
6.7%
김제시 8
 
5.4%
익산시 6
 
4.0%
Other values (20) 34
22.8%

Length

2024-03-14T10:08:26.570606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
군산시 17
11.6%
전주시 14
9.5%
완주군 14
9.5%
부안군 12
 
8.2%
남원시 12
 
8.2%
순창군 11
 
7.5%
임실군 11
 
7.5%
고창군 10
 
6.8%
김제시 8
 
5.4%
무주군 6
 
4.1%
Other values (19) 32
21.8%

시설명
Categorical

Distinct30
Distinct (%)20.1%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
16 
도로
14 
공원
14 
녹지
12 
광장
12 
Other values (25)
81 

Length

Max length8
Median length7
Mean length3.0067114
Min length1

Unique

Unique6 ?
Unique (%)4.0%

Sample

1st row<NA>
2nd row도로
3rd row공원
4th row녹지
5th row광장

Common Values

ValueCountFrequency (%)
16
 
10.7%
도로 14
 
9.4%
공원 14
 
9.4%
녹지 12
 
8.1%
광장 12
 
8.1%
주차장 10
 
6.7%
유원지 6
 
4.0%
체육시설 6
 
4.0%
공공청사 5
 
3.4%
학교 4
 
2.7%
Other values (20) 50
33.6%

Length

2024-03-14T10:08:26.787216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
도로 14
 
10.5%
공원 14
 
10.5%
녹지 12
 
9.0%
광장 12
 
9.0%
주차장 10
 
7.5%
유원지 6
 
4.5%
체육시설 6
 
4.5%
공공청사 5
 
3.8%
공공공지 4
 
3.0%
하천 4
 
3.0%
Other values (19) 46
34.6%

(부분)미집행 결정면적
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.7%
Memory size1.3 KiB

미집행10년미만
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size1.3 KiB

Unnamed: 5
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size1.3 KiB

Unnamed: 6
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size1.3 KiB

미집행10년이상
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size1.3 KiB

Unnamed: 8
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size1.3 KiB

Unnamed: 9
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size1.3 KiB

Correlations

2024-03-14T10:08:26.856425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시도명시군구명시설명
시도명1.0000.9260.675
시군구명0.9261.0000.000
시설명0.6750.0001.000
2024-03-14T10:08:26.926830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구명시도명시설명
시군구명1.0000.6970.000
시도명0.6971.0000.382
시설명0.0000.3821.000
2024-03-14T10:08:26.997111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시도명시군구명시설명
시도명1.0000.6970.382
시군구명0.6971.0000.000
시설명0.3820.0001.000

Missing values

2024-03-14T10:08:26.053576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T10:08:26.240982image/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

시도명시군구명시설명(부분)미집행 결정면적미집행10년미만Unnamed: 5Unnamed: 6미집행10년이상Unnamed: 8Unnamed: 9
0<NA><NA><NA>NaN개소면적사업비개소면적사업비
1전라북도전주시도로610580235152536662283722317781748376
2전라북도전주시공원14161701333361016111623671618947
3전라북도전주시녹지716961832661161837224885389
4전라북도전주시광장1724001117095259656309198672
5전라북도전주시사회복지시설6091609832000
6전라북도전주시청소년수련시설387551387552130000
7전라북도전주시문화시설49801701385000
8전라북도전주시연구시설7390900014702733000
9전라북도전주시체육시설171281171284100000
시도명시군구명시설명(부분)미집행 결정면적미집행10년미만Unnamed: 5Unnamed: 6미집행10년이상Unnamed: 8Unnamed: 9
139전라북도부안군하천527825492527825495924000
140전라북도부안군하수도164682126437100438250
141전라북도부안군유수지72619672619784000
142전라북도부안군수질오염방지시설2816228166588000
143전라북도부안군폐기물처리시설880720001299700
144전라북도부안군공공청사6577165770000
145전라북도부안군청소년수련시설216251216250000
146부안군계31669168521602675726317443141381
147전라북도계888213477198542044231507710546336312
148합 계888213477198542044231507710546336312