Overview

Dataset statistics

Number of variables14
Number of observations27
Missing cells28
Missing cells (%)7.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.1 KiB
Average record size in memory117.9 B

Variable types

Unsupported13
Text1

Dataset

Description파일 다운로드
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-2734/F/1/datasetView.do

Alerts

Unnamed: 0 has 27 (100.0%) missing valuesMissing
(단위 : 대, '23.12.31.일 기준) has 1 (3.7%) missing valuesMissing
Unnamed: 2 has unique valuesUnique
Unnamed: 0 is an unsupported type, check if it needs cleaning or further analysisUnsupported
(단위 : 대, '23.12.31.일 기준) 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

Reproduction

Analysis started2024-03-13 17:08:13.515455
Analysis finished2024-03-13 17:08:13.804253
Duration0.29 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Unnamed: 0
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing27
Missing (%)100.0%
Memory size375.0 B

(단위 : 대, '23.12.31.일 기준)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)3.7%
Memory size348.0 B

Unnamed: 2
Text

UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size348.0 B
2024-03-14T02:08:13.921094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length3
Mean length3
Min length1

Characters and Unicode

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

Unique

Unique27 ?
Unique (%)100.0%

Sample

1st row구분
2nd row계
3rd row종로구
4th row중 구
5th row용산구
ValueCountFrequency (%)
구분 1
 
3.6%
계 1
 
3.6%
송파구 1
 
3.6%
강남구 1
 
3.6%
서초구 1
 
3.6%
관악구 1
 
3.6%
동작구 1
 
3.6%
영등포구 1
 
3.6%
금천구 1
 
3.6%
구로구 1
 
3.6%
Other values (18) 18
64.3%
2024-03-14T02:08:14.197092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
구 27
33.3%
강 4
 
4.9%
동 4
 
4.9%
서 3
 
3.7%
포 2
 
2.5%
로 2
 
2.5%
중 2
 
2.5%
천 2
 
2.5%
성 2
 
2.5%
북 2
 
2.5%
Other values (29) 31
38.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 80
98.8%
Space Separator 1
 
1.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 27
33.8%
강 4
 
5.0%
동 4
 
5.0%
서 3
 
3.8%
포 2
 
2.5%
로 2
 
2.5%
중 2
 
2.5%
천 2
 
2.5%
성 2
 
2.5%
북 2
 
2.5%
Other values (28) 30
37.5%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 80
98.8%
Common 1
 
1.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 27
33.8%
강 4
 
5.0%
동 4
 
5.0%
서 3
 
3.8%
포 2
 
2.5%
로 2
 
2.5%
중 2
 
2.5%
천 2
 
2.5%
성 2
 
2.5%
북 2
 
2.5%
Other values (28) 30
37.5%
Common
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 80
98.8%
ASCII 1
 
1.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
구 27
33.8%
강 4
 
5.0%
동 4
 
5.0%
서 3
 
3.8%
포 2
 
2.5%
로 2
 
2.5%
중 2
 
2.5%
천 2
 
2.5%
성 2
 
2.5%
북 2
 
2.5%
Other values (28) 30
37.5%
ASCII
ValueCountFrequency (%)
1
100.0%

Unnamed: 3
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size348.0 B

Unnamed: 4
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size348.0 B

Unnamed: 5
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size348.0 B

Unnamed: 6
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size348.0 B

Unnamed: 7
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size348.0 B

Unnamed: 8
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size348.0 B

Unnamed: 9
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size348.0 B

Unnamed: 10
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size348.0 B

Unnamed: 11
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size348.0 B

Unnamed: 12
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size348.0 B

Unnamed: 13
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size348.0 B

Missing values

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

Unnamed: 0(단위 : 대, '23.12.31.일 기준)Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13
0<NA>순번구분총 계2015년 이전\n설치된 CCTV2015년2016년2017년2018년2019년2020년2021년2022년2023년
1<NA>NaN계99515875957258537107701061912855115259358937911988
2<NA>1종로구20315491581281431426723782225300
3<NA>2중 구2718275236239372386155364419137135
4<NA>3용산구32588838295491147335473486500405
5<NA>4성동구4409190352278939457640483366233471
6<NA>5광진구38283099542666460712191740273340
7<NA>6동대문구3268870749670199215229226317585
8<NA>7중랑구45123341451531702151074976507294644
9<NA>8성북구4578281294572448850713226418355421
Unnamed: 0(단위 : 대, '23.12.31.일 기준)Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13
17<NA>16강서구3546303192167416259457362441596353
18<NA>17구로구5003406248340543531781652685339478
19<NA>18금천구3169092130196539366514207304821
20<NA>19영등포구45661054209248311657651214283341184
21<NA>20동작구302453412424527029931243328372407
22<NA>21관악구5772774447607675663889404549135629
23<NA>22서초구53952275525141022422339419565878457
24<NA>23강남구77216728141280981735787913505588446
25<NA>24송파구40312231831262275261050237151431877
26<NA>25강동구3549571154202273377356614262381359