Overview

Dataset statistics

Number of variables19
Number of observations283
Missing cells4505
Missing cells (%)83.8%
Duplicate rows8
Duplicate rows (%)2.8%
Total size in memory42.1 KiB
Average record size in memory152.5 B

Variable types

Categorical1
Unsupported18

Dataset

Description17개 시도별 옥외광고 관리현황 자료로 허가신고 및 안전점검 현황, 업체 및 공무원 현황, 불법광고물 정비 현황, 행정처분 현황, 정비기금 현황 등을 제공합니다.
Author행정안전부 한국지방재정공제회
URLhttps://www.data.go.kr/data/15045522/fileData.do

Alerts

Dataset has 8 (2.8%) duplicate rowsDuplicates
Unnamed: 0 is highly imbalanced (82.4%)Imbalance
Unnamed: 1 has 238 (84.1%) missing valuesMissing
Unnamed: 2 has 243 (85.9%) missing valuesMissing
Unnamed: 3 has 243 (85.9%) missing valuesMissing
Unnamed: 4 has 248 (87.6%) missing valuesMissing
Unnamed: 5 has 251 (88.7%) missing valuesMissing
Unnamed: 6 has 251 (88.7%) missing valuesMissing
Unnamed: 7 has 251 (88.7%) missing valuesMissing
Unnamed: 8 has 251 (88.7%) missing valuesMissing
Unnamed: 9 has 251 (88.7%) missing valuesMissing
Unnamed: 10 has 250 (88.3%) missing valuesMissing
Unnamed: 11 has 251 (88.7%) missing valuesMissing
Unnamed: 12 has 251 (88.7%) missing valuesMissing
Unnamed: 13 has 251 (88.7%) missing valuesMissing
Unnamed: 14 has 251 (88.7%) missing valuesMissing
Unnamed: 15 has 254 (89.8%) missing valuesMissing
Unnamed: 16 has 254 (89.8%) missing valuesMissing
Unnamed: 17 has 254 (89.8%) missing valuesMissing
Unnamed: 18 has 262 (92.6%) missing valuesMissing
Unnamed: 1 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 2 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 3 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 4 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
Unnamed: 7 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
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 13 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 14 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 15 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 16 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 17 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 18 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 13:50:17.982838
Analysis finished2023-12-12 13:50:19.066693
Duration1.08 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Unnamed: 0
Categorical

IMBALANCE 

Distinct10
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
<NA>
263 
비율
 
4
구분
 
3
14년
 
3
총계
 
2
Other values (5)
 
8

Length

Max length4
Median length4
Mean length3.8833922
Min length2

Unique

Unique2 ?
Unique (%)0.7%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 263
92.9%
비율 4
 
1.4%
구분 3
 
1.1%
14년 3
 
1.1%
총계 2
 
0.7%
고정 2
 
0.7%
유동 2
 
0.7%
15년 2
 
0.7%
증가수 1
 
0.4%
증가율 1
 
0.4%

Length

2023-12-12T22:50:19.172517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:50:19.316782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 263
92.9%
비율 4
 
1.4%
구분 3
 
1.1%
14년 3
 
1.1%
총계 2
 
0.7%
고정 2
 
0.7%
유동 2
 
0.7%
15년 2
 
0.7%
증가수 1
 
0.4%
증가율 1
 
0.4%

Unnamed: 1
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing238
Missing (%)84.1%
Memory size2.3 KiB

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing243
Missing (%)85.9%
Memory size2.3 KiB

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing243
Missing (%)85.9%
Memory size2.3 KiB

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing248
Missing (%)87.6%
Memory size2.3 KiB

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing251
Missing (%)88.7%
Memory size2.3 KiB

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing251
Missing (%)88.7%
Memory size2.3 KiB

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing251
Missing (%)88.7%
Memory size2.3 KiB

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing251
Missing (%)88.7%
Memory size2.3 KiB

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing251
Missing (%)88.7%
Memory size2.3 KiB

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing250
Missing (%)88.3%
Memory size2.3 KiB

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing251
Missing (%)88.7%
Memory size2.3 KiB

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing251
Missing (%)88.7%
Memory size2.3 KiB

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing251
Missing (%)88.7%
Memory size2.3 KiB

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing251
Missing (%)88.7%
Memory size2.3 KiB

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing254
Missing (%)89.8%
Memory size2.3 KiB

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing254
Missing (%)89.8%
Memory size2.3 KiB

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing254
Missing (%)89.8%
Memory size2.3 KiB

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing262
Missing (%)92.6%
Memory size2.3 KiB

Missing values

2023-12-12T22:50:18.150104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T22:50:18.423275image/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.
2023-12-12T22:50:18.733096image/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

Unnamed: 0Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18
0<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
3<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
4<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
5<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
6<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
7<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
8<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
9<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
Unnamed: 0Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18
273<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
274<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
275<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
276<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
277<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
278<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
279구분안전점검 시행 광고물NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
280<NA>계서울부산대구인천광주대전울산세종경기강원충북충남전북전남경북경남제주
281총계845887534997157326218292919884899521701450631862230541212695248072222503
282비율1008.90670111.7877246.7763757.3509243.4626662.3502155.7916020.06147420.1139645.9854832.2012582.7249734.8718493.1860312.9318588.5378542.959049

Duplicate rows

Most frequently occurring

Unnamed: 0# duplicates
7<NA>263
4비율4
014년3
3구분3
115년2
2고정2
5유동2
6총계2