Overview

Dataset statistics

Number of variables12
Number of observations28
Missing cells38
Missing cells (%)11.3%
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-2722/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: 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
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

Reproduction

Analysis started2024-03-13 07:51:46.165306
Analysis finished2024-03-13 07:51:46.653255
Duration0.49 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.일 기준)
Text

MISSING 

Distinct27
Distinct (%)100.0%
Missing1
Missing (%)3.6%
Memory size356.0 B
2024-03-13T16:51:46.770575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length3
Mean length3
Min length2

Characters and Unicode

Total characters81
Distinct characters40
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-13T16:51:47.060596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
구 25
30.9%
강 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 (30) 33
40.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 79
97.5%
Space Separator 2
 
2.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 25
31.6%
강 4
 
5.1%
동 4
 
5.1%
서 3
 
3.8%
문 2
 
2.5%
포 2
 
2.5%
천 2
 
2.5%
로 2
 
2.5%
중 2
 
2.5%
북 2
 
2.5%
Other values (29) 31
39.2%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 79
97.5%
Common 2
 
2.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 25
31.6%
강 4
 
5.1%
동 4
 
5.1%
서 3
 
3.8%
문 2
 
2.5%
포 2
 
2.5%
천 2
 
2.5%
로 2
 
2.5%
중 2
 
2.5%
북 2
 
2.5%
Other values (29) 31
39.2%
Common
ValueCountFrequency (%)
2
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 79
97.5%
ASCII 2
 
2.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
구 25
31.6%
강 4
 
5.1%
동 4
 
5.1%
서 3
 
3.8%
문 2
 
2.5%
포 2
 
2.5%
천 2
 
2.5%
로 2
 
2.5%
중 2
 
2.5%
북 2
 
2.5%
Other values (29) 31
39.2%
ASCII
ValueCountFrequency (%)
2
100.0%

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

Unnamed: 3
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
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-13T16:51:46.264004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T16:51:46.398534image/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-13T16:51:46.562427image/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>구 분CCTV 총계범죄예방 및 수사NaNNaNNaNNaN시설안전\n·\n화재예방교통단속교통정보수집\n·\n분석기타\n다른법령
1<NA><NA>NaN소 계방범어린이\n보호구역공원·놀이터쓰레기\n무단투기NaNNaNNaNNaN
2<NA>자치구9951586810687478390858710863838825318596
3<NA>종로구2031187216464518103412500
4<NA>중구2718215718007621962623320167
5<NA>용산구3258289724742341890535600
6<NA>성동구44093871286442136122511042800
7<NA>광진구3828342125565642356614925800
8<NA>동대문326830772492285268321176014
9<NA>중랑구451241633821141190115929000
Unnamed: 0(단위 : 대, '23.12.31.일 기준)Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11
18<NA>강서구35463397272629935022014900
19<NA>구로구5003426532455384503228345500
20<NA>금천구31692978241326625346019100
21<NA>영등포4566398735102861910557400
22<NA>동작구30242656204340318921115680185
23<NA>관악구57724210350425330614786070200
24<NA>서초구5395334328102033300837121500
25<NA>강남구77216829523611174760152708032
26<NA>송파구403134712304456711016739300
27<NA>강동구3549343529632542180011400