Overview

Dataset statistics

Number of variables15
Number of observations472
Missing cells1937
Missing cells (%)27.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory55.4 KiB
Average record size in memory120.3 B

Variable types

Text1
Unsupported14

Dataset

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

Alerts

Unnamed: 2 has 5 (1.1%) missing valuesMissing
Unnamed: 4 has 25 (5.3%) missing valuesMissing
Unnamed: 5 has 87 (18.4%) missing valuesMissing
Unnamed: 6 has 259 (54.9%) missing valuesMissing
Unnamed: 7 has 5 (1.1%) missing valuesMissing
Unnamed: 8 has 263 (55.7%) missing valuesMissing
Unnamed: 9 has 17 (3.6%) missing valuesMissing
Unnamed: 10 has 252 (53.4%) missing valuesMissing
Unnamed: 11 has 220 (46.6%) missing valuesMissing
Unnamed: 12 has 464 (98.3%) missing valuesMissing
Unnamed: 13 has 205 (43.4%) missing valuesMissing
Unnamed: 14 has 132 (28.0%) missing valuesMissing
2021년 1월 기준 서울시 자동차 등록현황(동별, 연료별) has unique valuesUnique
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

Reproduction

Analysis started2024-04-06 12:32:24.151794
Analysis finished2024-04-06 12:32:26.343612
Duration2.19 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

2021년 1월 기준 서울시 자동차 등록현황(동별, 연료별)
Text

UNIQUE 

Distinct472
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
2024-04-06T21:32:26.570222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length13
Mean length13.574153
Min length9

Characters and Unicode

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

Unique

Unique472 ?
Unique (%)100.0%

Sample

1st row사용본거지법정동명
2nd row서울특별시 종로구 청운동
3rd row서울특별시 종로구 신교동
4th row서울특별시 종로구 궁정동
5th row서울특별시 종로구 효자동
ValueCountFrequency (%)
서울특별시 471
33.3%
종로구 87
 
6.2%
중구 74
 
5.2%
성북구 39
 
2.8%
용산구 37
 
2.6%
영등포구 34
 
2.4%
마포구 26
 
1.8%
서대문구 20
 
1.4%
성동구 17
 
1.2%
강남구 16
 
1.1%
Other values (486) 593
41.9%
2024-04-06T21:32:27.323330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
942
14.7%
서 522
 
8.1%
동 490
 
7.6%
구 487
 
7.6%
시 472
 
7.4%
울 471
 
7.4%
특 471
 
7.4%
별 471
 
7.4%
가 145
 
2.3%
로 138
 
2.2%
Other values (211) 1798
28.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5326
83.1%
Space Separator 942
 
14.7%
Decimal Number 139
 
2.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 522
 
9.8%
동 490
 
9.2%
구 487
 
9.1%
시 472
 
8.9%
울 471
 
8.8%
특 471
 
8.8%
별 471
 
8.8%
가 145
 
2.7%
로 138
 
2.6%
종 95
 
1.8%
Other values (202) 1564
29.4%
Decimal Number
ValueCountFrequency (%)
1 37
26.6%
2 34
24.5%
3 23
16.5%
4 17
12.2%
5 14
 
10.1%
6 9
 
6.5%
7 4
 
2.9%
8 1
 
0.7%
Space Separator
ValueCountFrequency (%)
942
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5326
83.1%
Common 1081
 
16.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 522
 
9.8%
동 490
 
9.2%
구 487
 
9.1%
시 472
 
8.9%
울 471
 
8.8%
특 471
 
8.8%
별 471
 
8.8%
가 145
 
2.7%
로 138
 
2.6%
종 95
 
1.8%
Other values (202) 1564
29.4%
Common
ValueCountFrequency (%)
942
87.1%
1 37
 
3.4%
2 34
 
3.1%
3 23
 
2.1%
4 17
 
1.6%
5 14
 
1.3%
6 9
 
0.8%
7 4
 
0.4%
8 1
 
0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5326
83.1%
ASCII 1081
 
16.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
942
87.1%
1 37
 
3.4%
2 34
 
3.1%
3 23
 
2.1%
4 17
 
1.6%
5 14
 
1.3%
6 9
 
0.8%
7 4
 
0.4%
8 1
 
0.1%
Hangul
ValueCountFrequency (%)
서 522
 
9.8%
동 490
 
9.2%
구 487
 
9.1%
시 472
 
8.9%
울 471
 
8.8%
특 471
 
8.8%
별 471
 
8.8%
가 145
 
2.7%
로 138
 
2.6%
종 95
 
1.8%
Other values (202) 1564
29.4%

Unnamed: 1
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size3.8 KiB

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)1.1%
Memory size3.8 KiB

Unnamed: 3
Unsupported

REJECTED  UNSUPPORTED 

Missing3
Missing (%)0.6%
Memory size3.8 KiB

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing25
Missing (%)5.3%
Memory size3.8 KiB

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing87
Missing (%)18.4%
Memory size3.8 KiB

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing259
Missing (%)54.9%
Memory size3.8 KiB

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)1.1%
Memory size3.8 KiB

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing263
Missing (%)55.7%
Memory size3.8 KiB

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing17
Missing (%)3.6%
Memory size3.8 KiB

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing252
Missing (%)53.4%
Memory size3.8 KiB

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing220
Missing (%)46.6%
Memory size3.8 KiB

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing464
Missing (%)98.3%
Memory size3.8 KiB

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing205
Missing (%)43.4%
Memory size3.8 KiB

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing132
Missing (%)28.0%
Memory size3.8 KiB

Missing values

2024-04-06T21:32:25.151000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T21:32:25.573842image/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-04-06T21:32:25.998735image/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

2021년 1월 기준 서울시 자동차 등록현황(동별, 연료별)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14
0사용본거지법정동명동별 총 대수휘발유경유엘피지전기휘발유(유연)휘발유(무연)CNG하이브리드\n(휘발유+전기)하이브리드\n(경유+전기)하이브리드\n(LPG+전기)하이브리드\n(CNG+전기)수소기타연료
1서울특별시 종로구 청운동8002202593241243NaN38NaN1NaNNaN2
2서울특별시 종로구 신교동38387141283NaN111NaN13NaNNaNNaNNaNNaN
3서울특별시 종로구 궁정동4710161NaNNaN14NaN6NaNNaNNaNNaNNaN
4서울특별시 종로구 효자동175556841NaN39NaN8NaNNaNNaNNaNNaN
5서울특별시 종로구 창성동165416641NaN46NaN7NaNNaNNaNNaNNaN
6서울특별시 종로구 통의동13929518NaNNaN44NaN7NaNNaNNaNNaNNaN
7서울특별시 종로구 적선동16439735NaNNaN41NaN6NaNNaNNaNNaNNaN
8서울특별시 종로구 통인동188495612NaNNaN63NaN8NaNNaNNaNNaNNaN
9서울특별시 종로구 누상동787179259673NaN244NaN30NaNNaNNaN23
2021년 1월 기준 서울시 자동차 등록현황(동별, 연료별)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14
462서울특별시 송파구 마천동11761190846181538523325110525117NaN522
463서울특별시 강동구 명일동140593168435397049348451061926NaN826
464서울특별시 강동구 고덕동16815385356749999535288282668NaN2536
465서울특별시 강동구 상일동146743263475097971747874733157NaN2632
466서울특별시 강동구 길동16122288055482664901044457436111NaN822
467서울특별시 강동구 둔촌동88861789310893132NaN2697330613NaN412
468서울특별시 강동구 암사동2189844527495202562969406838911NaN1140
469서울특별시 강동구 성내동221444070818822441221367231469736NaN2044
470서울특별시 강동구 천호동2616149509888266479137730573849NaN2160
471서울특별시 강동구 강일동9593170832611238573279418430411021021