Overview

Dataset statistics

Number of variables12
Number of observations28
Missing cells39
Missing cells (%)11.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.8 KiB
Average record size in memory101.7 B

Variable types

Unsupported11
Text1

Dataset

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

Alerts

Unnamed: 0 has 28 (100.0%) missing valuesMissing
(단위 : 대, '23.12.31.일 기준) has 1 (3.6%) missing valuesMissing
Unnamed: 2 has 1 (3.6%) missing valuesMissing
Unnamed: 3 has 1 (3.6%) missing valuesMissing
Unnamed: 4 has 1 (3.6%) missing valuesMissing
Unnamed: 5 has 1 (3.6%) missing valuesMissing
Unnamed: 6 has 1 (3.6%) missing valuesMissing
Unnamed: 7 has 1 (3.6%) missing valuesMissing
Unnamed: 8 has 1 (3.6%) missing valuesMissing
Unnamed: 9 has 1 (3.6%) missing valuesMissing
Unnamed: 10 has 1 (3.6%) missing valuesMissing
Unnamed: 11 has 1 (3.6%) missing valuesMissing
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

Reproduction

Analysis started2024-03-13 15:46:33.459788
Analysis finished2024-03-13 15:46:34.005312
Duration0.55 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Unnamed: 0
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing28
Missing (%)100.0%
Memory size384.0 B

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

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)3.6%
Memory size356.0 B

Unnamed: 2
Text

MISSING 

Distinct27
Distinct (%)100.0%
Missing1
Missing (%)3.6%
Memory size356.0 B
2024-03-14T00:46:34.132730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length3
Mean length2.962963
Min length1

Characters and Unicode

Total characters80
Distinct characters38
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
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.7%
서대문구 1
 
3.7%
송파구 1
 
3.7%
강남구 1
 
3.7%
서초구 1
 
3.7%
관악구 1
 
3.7%
동작구 1
 
3.7%
영등포구 1
 
3.7%
금천구 1
 
3.7%
구로구 1
 
3.7%
Other values (17) 17
63.0%
2024-03-14T00:46:34.439967image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

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%

Most occurring categories

ValueCountFrequency (%)
Other Letter 80
100.0%

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%

Most occurring scripts

ValueCountFrequency (%)
Hangul 80
100.0%

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%

Most occurring blocks

ValueCountFrequency (%)
Hangul 80
100.0%

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%

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)3.6%
Memory size356.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)3.6%
Memory size356.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)3.6%
Memory size356.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)3.6%
Memory size356.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)3.6%
Memory size356.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)3.6%
Memory size356.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)3.6%
Memory size356.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)3.6%
Memory size356.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)3.6%
Memory size356.0 B

Missing values

2024-03-14T00:46:33.558370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T00:46:33.731561image/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.
2024-03-14T00:46:33.902183image/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: 0(단위 : 대, '23.12.31.일 기준)Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11
0<NA>순번구분2015년2016년2017년2018년2019년2020년2021년2022년2023년
1<NA>NaN계263213301340512492225813967281744088000586810
2<NA>1종로구93510661225132213271510157318121872
3<NA>2중구363565838117412421482191120262157
4<NA>3용산구139816891831188819152058232125312897
5<NA>4성동구108913282103239028333162351936273871
6<NA>5광진구6386571112158623082481311133703421
7<NA>6동대문구120214251535177520612166247125923077
8<NA>7중랑구7518981047120322503165359238564163
9<NA>8성북구103515341940254232383440381540144216
Unnamed: 0(단위 : 대, '23.12.31.일 기준)Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11
18<NA>17구로구140717192231281930743455384240134265
19<NA>18금천구99010901181156318942247227624982978
20<NA>19영등포구90411401429205520933250350838963987
21<NA>20동작구96112001471169019042155218124042656
22<NA>21관악구149620482611324733883652383340294210
23<NA>22서초구154817852169258229383175344231803343
24<NA>23강남구231934474232483454595796614364956829
25<NA>24송파구713798913136420522372252028053471
26<NA>25강동구6708631134159618712475272030863435
27<NA>※ 참고 : 자치구 전체 CCTV중 범죄예방 수사용으로 운영중인 CCTV 수량(연도별 누적)<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaN