Overview

Dataset statistics

Number of variables13
Number of observations694
Missing cells3470
Missing cells (%)38.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory76.0 KiB
Average record size in memory112.2 B

Variable types

Categorical3
Text1
Unsupported5
Numeric3
DateTime1

Dataset

Description파일 다운로드
Author동작구
URLhttps://data.seoul.go.kr/dataList/OA-13272/F/1/datasetView.do

Alerts

관리기관명 has constant value ""Constant
관리기관전화번호 has constant value ""Constant
데이터기준일자 has constant value ""Constant
소재지지번주소 has 694 (100.0%) missing valuesMissing
카메라화소수 has 694 (100.0%) missing valuesMissing
촬영방면정보 has 694 (100.0%) missing valuesMissing
보관일수 has 694 (100.0%) missing valuesMissing
설치년월 has 694 (100.0%) missing valuesMissing
소재지지번주소 is an unsupported type, check if it needs cleaning or further analysisUnsupported
카메라화소수 is an unsupported type, check if it needs cleaning or further analysisUnsupported
촬영방면정보 is an unsupported type, check if it needs cleaning or further analysisUnsupported
보관일수 is an unsupported type, check if it needs cleaning or further analysisUnsupported
설치년월 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-11 05:03:22.353308
Analysis finished2023-12-11 05:03:24.918202
Duration2.56 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
서울특별시동작구청
694 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서울특별시동작구청
2nd row서울특별시동작구청
3rd row서울특별시동작구청
4th row서울특별시동작구청
5th row서울특별시동작구청

Common Values

ValueCountFrequency (%)
서울특별시동작구청 694
100.0%

Length

2023-12-11T14:03:25.051861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T14:03:25.232209image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울특별시동작구청 694
100.0%

소재지도로명주소
Text

Distinct691
Distinct (%)99.6%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
2023-12-11T14:03:25.584522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length60
Median length54
Mean length33.368876
Min length16

Characters and Unicode

Total characters23158
Distinct characters321
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique688 ?
Unique (%)99.1%

Sample

1st row서울특별시 동작구 장승배기로23길 10
2nd row서울특별시 동작구 노량진로8길 40 마당쇠숯불갈비
3rd row서울특별시 동작구 장승배기로18길 27
4th row서울특별시 동작구 만양로14다길 7
5th row서울특별시 동작구 장승배기로22길 44(노량진2동 226-15)
ValueCountFrequency (%)
서울특별시 701
 
18.3%
동작구 701
 
18.3%
앞 44
 
1.1%
상도로 17
 
0.4%
성대로 15
 
0.4%
만양로 11
 
0.3%
장승배기로 11
 
0.3%
사당로23길 11
 
0.3%
여의대방로 10
 
0.3%
상도4동 10
 
0.3%
Other values (1789) 2309
60.1%
2023-12-11T14:03:26.266950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3172
 
13.7%
동 1397
 
6.0%
1 1219
 
5.3%
2 983
 
4.2%
작 769
 
3.3%
서 735
 
3.2%
구 719
 
3.1%
시 708
 
3.1%
별 706
 
3.0%
울 704
 
3.0%
Other values (311) 12046
52.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 12605
54.4%
Decimal Number 5508
23.8%
Space Separator 3172
 
13.7%
Open Punctuation 627
 
2.7%
Close Punctuation 624
 
2.7%
Dash Punctuation 605
 
2.6%
Other Punctuation 8
 
< 0.1%
Uppercase Letter 8
 
< 0.1%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 1397
 
11.1%
작 769
 
6.1%
서 735
 
5.8%
구 719
 
5.7%
시 708
 
5.6%
별 706
 
5.6%
울 704
 
5.6%
특 702
 
5.6%
로 573
 
4.5%
길 567
 
4.5%
Other values (287) 5025
39.9%
Decimal Number
ValueCountFrequency (%)
1 1219
22.1%
2 983
17.8%
3 631
11.5%
4 564
10.2%
5 424
 
7.7%
6 418
 
7.6%
0 368
 
6.7%
9 312
 
5.7%
7 301
 
5.5%
8 288
 
5.2%
Uppercase Letter
ValueCountFrequency (%)
L 2
25.0%
G 2
25.0%
I 1
12.5%
A 1
12.5%
T 1
12.5%
P 1
12.5%
Other Punctuation
ValueCountFrequency (%)
. 4
50.0%
, 2
25.0%
※ 2
25.0%
Space Separator
ValueCountFrequency (%)
3172
100.0%
Open Punctuation
ValueCountFrequency (%)
( 627
100.0%
Close Punctuation
ValueCountFrequency (%)
) 624
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 605
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 12605
54.4%
Common 10544
45.5%
Latin 9
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 1397
 
11.1%
작 769
 
6.1%
서 735
 
5.8%
구 719
 
5.7%
시 708
 
5.6%
별 706
 
5.6%
울 704
 
5.6%
특 702
 
5.6%
로 573
 
4.5%
길 567
 
4.5%
Other values (287) 5025
39.9%
Common
ValueCountFrequency (%)
3172
30.1%
1 1219
 
11.6%
2 983
 
9.3%
3 631
 
6.0%
( 627
 
5.9%
) 624
 
5.9%
- 605
 
5.7%
4 564
 
5.3%
5 424
 
4.0%
6 418
 
4.0%
Other values (7) 1277
12.1%
Latin
ValueCountFrequency (%)
L 2
22.2%
G 2
22.2%
e 1
11.1%
I 1
11.1%
A 1
11.1%
T 1
11.1%
P 1
11.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 12605
54.4%
ASCII 10551
45.6%
Punctuation 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3172
30.1%
1 1219
 
11.6%
2 983
 
9.3%
3 631
 
6.0%
( 627
 
5.9%
) 624
 
5.9%
- 605
 
5.7%
4 564
 
5.3%
5 424
 
4.0%
6 418
 
4.0%
Other values (13) 1284
12.2%
Hangul
ValueCountFrequency (%)
동 1397
 
11.1%
작 769
 
6.1%
서 735
 
5.8%
구 719
 
5.7%
시 708
 
5.6%
별 706
 
5.6%
울 704
 
5.6%
특 702
 
5.6%
로 573
 
4.5%
길 567
 
4.5%
Other values (287) 5025
39.9%
Punctuation
ValueCountFrequency (%)
※ 2
100.0%

소재지지번주소
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing694
Missing (%)100.0%
Memory size6.2 KiB

설치목적구분
Categorical

Distinct7
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
생활방범
407 
어린이보호
105 
공원방범
58 
그린파킹
49 
교통단속
41 
Other values (2)
 
34

Length

Max length5
Median length4
Mean length4.1354467
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row생활방범
2nd row생활방범
3rd row생활방범
4th row생활방범
5th row생활방범

Common Values

ValueCountFrequency (%)
생활방범 407
58.6%
어린이보호 105
 
15.1%
공원방범 58
 
8.4%
그린파킹 49
 
7.1%
교통단속 41
 
5.9%
쓰레기단속 19
 
2.7%
기타 15
 
2.2%

Length

2023-12-11T14:03:26.479362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T14:03:26.689393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
생활방범 407
58.6%
어린이보호 105
 
15.1%
공원방범 58
 
8.4%
그린파킹 49
 
7.1%
교통단속 41
 
5.9%
쓰레기단속 19
 
2.7%
기타 15
 
2.2%

카메라대수
Real number (ℝ)

Distinct9
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.9135447
Minimum1
Maximum10
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.2 KiB
2023-12-11T14:03:26.878352image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median3
Q34
95-th percentile5
Maximum10
Range9
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.3380936
Coefficient of variation (CV)0.45926655
Kurtosis1.3516759
Mean2.9135447
Median Absolute Deviation (MAD)1
Skewness0.27077173
Sum2022
Variance1.7904945
MonotonicityNot monotonic
2023-12-11T14:03:27.040537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
3 249
35.9%
4 197
28.4%
1 170
24.5%
5 39
 
5.6%
2 31
 
4.5%
6 4
 
0.6%
9 2
 
0.3%
10 1
 
0.1%
8 1
 
0.1%
ValueCountFrequency (%)
1 170
24.5%
2 31
 
4.5%
3 249
35.9%
4 197
28.4%
5 39
 
5.6%
6 4
 
0.6%
8 1
 
0.1%
9 2
 
0.3%
10 1
 
0.1%
ValueCountFrequency (%)
10 1
 
0.1%
9 2
 
0.3%
8 1
 
0.1%
6 4
 
0.6%
5 39
 
5.6%
4 197
28.4%
3 249
35.9%
2 31
 
4.5%
1 170
24.5%

카메라화소수
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing694
Missing (%)100.0%
Memory size6.2 KiB

촬영방면정보
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing694
Missing (%)100.0%
Memory size6.2 KiB

보관일수
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing694
Missing (%)100.0%
Memory size6.2 KiB

설치년월
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing694
Missing (%)100.0%
Memory size6.2 KiB

관리기관전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
02-820-2906
694 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row02-820-2906
2nd row02-820-2906
3rd row02-820-2906
4th row02-820-2906
5th row02-820-2906

Common Values

ValueCountFrequency (%)
02-820-2906 694
100.0%

Length

2023-12-11T14:03:27.263702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T14:03:27.421849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
02-820-2906 694
100.0%

위도
Real number (ℝ)

Distinct676
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.497014
Minimum37.476259
Maximum37.51617
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.2 KiB
2023-12-11T14:03:27.580420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.476259
5-th percentile37.480004
Q137.488706
median37.497727
Q337.505163
95-th percentile37.511301
Maximum37.51617
Range0.039911
Interquartile range (IQR)0.01645625

Descriptive statistics

Standard deviation0.0099158233
Coefficient of variation (CV)0.00026444301
Kurtosis-0.9533753
Mean37.497014
Median Absolute Deviation (MAD)0.0081625
Skewness-0.23840524
Sum26022.928
Variance9.8323552 × 10-5
MonotonicityNot monotonic
2023-12-11T14:03:27.855093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.47732 3
 
0.4%
37.51118 2
 
0.3%
37.50557 2
 
0.3%
37.498074 2
 
0.3%
37.50071 2
 
0.3%
37.477791 2
 
0.3%
37.49537 2
 
0.3%
37.49729 2
 
0.3%
37.49612 2
 
0.3%
37.49724 2
 
0.3%
Other values (666) 673
97.0%
ValueCountFrequency (%)
37.476259 1
 
0.1%
37.476405 1
 
0.1%
37.476951 1
 
0.1%
37.47706 1
 
0.1%
37.47717 1
 
0.1%
37.47732 3
0.4%
37.477351 1
 
0.1%
37.477385 1
 
0.1%
37.477572 1
 
0.1%
37.477737 1
 
0.1%
ValueCountFrequency (%)
37.51617 1
0.1%
37.51558 1
0.1%
37.5155 1
0.1%
37.51505 1
0.1%
37.51471 1
0.1%
37.51432 1
0.1%
37.513961 1
0.1%
37.5139 1
0.1%
37.513546 1
0.1%
37.51348 1
0.1%

경도
Real number (ℝ)

Distinct682
Distinct (%)98.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.94867
Minimum126.90498
Maximum126.98248
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.2 KiB
2023-12-11T14:03:28.142921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.90498
5-th percentile126.91285
Q1126.93352
median126.94632
Q3126.96819
95-th percentile126.97995
Maximum126.98248
Range0.077496
Interquartile range (IQR)0.03467225

Descriptive statistics

Standard deviation0.02045367
Coefficient of variation (CV)0.00016111764
Kurtosis-1.0144166
Mean126.94867
Median Absolute Deviation (MAD)0.016446
Skewness-0.045620765
Sum88102.378
Variance0.00041835263
MonotonicityNot monotonic
2023-12-11T14:03:28.377953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.97253 3
 
0.4%
126.98004 2
 
0.3%
126.977614 2
 
0.3%
126.94503 2
 
0.3%
126.94431 2
 
0.3%
126.96624 2
 
0.3%
126.91649 2
 
0.3%
126.94282 2
 
0.3%
126.95031 2
 
0.3%
126.98095 2
 
0.3%
Other values (672) 673
97.0%
ValueCountFrequency (%)
126.904984 1
0.1%
126.90583 1
0.1%
126.90624 1
0.1%
126.90677 1
0.1%
126.90698 1
0.1%
126.90754 1
0.1%
126.90777 1
0.1%
126.907861 1
0.1%
126.908275 1
0.1%
126.90881 1
0.1%
ValueCountFrequency (%)
126.98248 1
0.1%
126.982458 1
0.1%
126.982041 1
0.1%
126.981921 1
0.1%
126.981918 1
0.1%
126.981733 1
0.1%
126.981628 1
0.1%
126.9816 1
0.1%
126.981507 1
0.1%
126.981138 1
0.1%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
Minimum2020-03-24 00:00:00
Maximum2020-03-24 00:00:00
2023-12-11T14:03:28.607993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:03:28.757025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-11T14:03:23.788499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:03:22.829867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:03:23.253663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:03:23.958289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:03:22.961774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:03:23.393394image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:03:24.149082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:03:23.104187image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:03:23.594286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T14:03:28.876624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치목적구분카메라대수위도경도
설치목적구분1.0000.5850.3610.250
카메라대수0.5851.0000.2130.122
위도0.3610.2131.0000.784
경도0.2500.1220.7841.000
2023-12-11T14:03:29.033879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
카메라대수위도경도설치목적구분
카메라대수1.000-0.0330.0570.358
위도-0.0331.000-0.3500.191
경도0.057-0.3501.0000.128
설치목적구분0.3580.1910.1281.000

Missing values

2023-12-11T14:03:24.428531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T14:03:24.785763image/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

관리기관명소재지도로명주소소재지지번주소설치목적구분카메라대수카메라화소수촬영방면정보보관일수설치년월관리기관전화번호위도경도데이터기준일자
0서울특별시동작구청서울특별시 동작구 장승배기로23길 10<NA>생활방범3<NA><NA><NA><NA>02-820-290637.510141126.9394522020-03-24
1서울특별시동작구청서울특별시 동작구 노량진로8길 40 마당쇠숯불갈비<NA>생활방범3<NA><NA><NA><NA>02-820-290637.512401126.9375882020-03-24
2서울특별시동작구청서울특별시 동작구 장승배기로18길 27<NA>생활방범3<NA><NA><NA><NA>02-820-290637.507402126.9415992020-03-24
3서울특별시동작구청서울특별시 동작구 만양로14다길 7<NA>생활방범1<NA><NA><NA><NA>02-820-290637.511299126.945312020-03-24
4서울특별시동작구청서울특별시 동작구 장승배기로22길 44(노량진2동 226-15)<NA>생활방범1<NA><NA><NA><NA>02-820-290637.508595126.9415612020-03-24
5서울특별시동작구청서울특별시 동작구 장승배기로19다길 24(노량진2동 302-27)<NA>생활방범1<NA><NA><NA><NA>02-820-290637.509271126.9375722020-03-24
6서울특별시동작구청서울특별시 동작구 장승배기로24가길 39(노량진1동 232-52)<NA>생활방범1<NA><NA><NA><NA>02-820-290637.511253126.9420722020-03-24
7서울특별시동작구청서울특별시 동작구 노량진로26길 65(노량진1동 485-2)<NA>생활방범1<NA><NA><NA><NA>02-820-290637.5097126.9555222020-03-24
8서울특별시동작구청서울특별시 동작구 노량진로18길 20(노량진1동 408-1)<NA>생활방범3<NA><NA><NA><NA>02-820-290637.511993126.950972020-03-24
9서울특별시동작구청서울특별시 동작구 상도로60길 35(상도1동 126-65) 동녘빌라<NA>생활방범3<NA><NA><NA><NA>02-820-290637.492257126.9545962020-03-24
관리기관명소재지도로명주소소재지지번주소설치목적구분카메라대수카메라화소수촬영방면정보보관일수설치년월관리기관전화번호위도경도데이터기준일자
684서울특별시동작구청서울특별시 동작구 신대방2길 12 보라매빗물펌프장(운영실)<NA>기타2<NA><NA><NA><NA>02-820-290637.48797126.913312020-03-24
685서울특별시동작구청서울특별시 동작구 노량진로 20-2 대방지하보도<NA>기타6<NA><NA><NA><NA>02-820-290637.51333126.926882020-03-24
686서울특별시동작구청서울특별시 동작구 노량진로32길 14-7 용양봉저정<NA>기타5<NA><NA><NA><NA>02-820-290637.51286126.955792020-03-24
687서울특별시동작구청서울특별시 동작구 상도로53길 39 실로암교회 옆 엘리베이터<NA>기타1<NA><NA><NA><NA>02-820-290637.50058126.953532020-03-24
688서울특별시동작구청서울특별시 동작구 상도동 159-334 상도지하차도<NA>기타8<NA><NA><NA><NA>02-820-290637.502252126.946282020-03-24
689서울특별시동작구청서울특별시 동작구 동작대로 9 (사당역 8번출구)<NA>기타1<NA><NA><NA><NA>02-820-290637.47732126.98162020-03-24
690서울특별시동작구청서울특별시 동작구 신대방1길 109<NA>기타1<NA><NA><NA><NA>02-820-290637.48497126.905832020-03-24
691서울특별시동작구청서울특별시 동작구 대림로 19<NA>기타1<NA><NA><NA><NA>02-820-290637.48695126.912032020-03-24
692서울특별시동작구청서울특별시 동작구 신대방2길 14<NA>기타1<NA><NA><NA><NA>02-820-290637.48911126.915492020-03-24
693서울특별시동작구청서울특별시 동작구 여의대방로20길 33<NA>기타1<NA><NA><NA><NA>02-820-290637.48989126.91712020-03-24