Overview

Dataset statistics

Number of variables13
Number of observations671
Missing cells3355
Missing cells (%)38.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory73.5 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 671 (100.0%) missing valuesMissing
카메라화소수 has 671 (100.0%) missing valuesMissing
촬영방면정보 has 671 (100.0%) missing valuesMissing
보관일수 has 671 (100.0%) missing valuesMissing
설치년월 has 671 (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:13.174901
Analysis finished2023-12-11 05:03:15.865922
Duration2.69 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리기관명
Categorical

CONSTANT 

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

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 (%)
서울특별시동작구청 671
100.0%

Length

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

Common Values (Plot)

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

소재지도로명주소
Text

Distinct642
Distinct (%)95.7%
Missing0
Missing (%)0.0%
Memory size5.4 KiB
2023-12-11T14:03:16.577901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length60
Median length52
Mean length32.114754
Min length16

Characters and Unicode

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

Unique

Unique624 ?
Unique (%)93.0%

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 (%)
서울특별시 678
 
18.4%
동작구 678
 
18.4%
앞 41
 
1.1%
상도로 18
 
0.5%
성대로 15
 
0.4%
사당로23길 13
 
0.4%
만양로 11
 
0.3%
노량진로 11
 
0.3%
장승배기로 11
 
0.3%
현충로 10
 
0.3%
Other values (1617) 2194
59.6%
2023-12-11T14:03:17.275102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3031
 
14.1%
동 1267
 
5.9%
1 1133
 
5.3%
2 940
 
4.4%
작 748
 
3.5%
서 713
 
3.3%
구 692
 
3.2%
시 684
 
3.2%
별 681
 
3.2%
울 681
 
3.2%
Other values (276) 10979
50.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 11788
54.7%
Decimal Number 5143
23.9%
Space Separator 3031
 
14.1%
Dash Punctuation 534
 
2.5%
Open Punctuation 523
 
2.4%
Close Punctuation 521
 
2.4%
Uppercase Letter 6
 
< 0.1%
Other Punctuation 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 1267
 
10.7%
작 748
 
6.3%
서 713
 
6.0%
구 692
 
5.9%
시 684
 
5.8%
별 681
 
5.8%
울 681
 
5.8%
특 679
 
5.8%
로 611
 
5.2%
길 595
 
5.0%
Other values (254) 4437
37.6%
Decimal Number
ValueCountFrequency (%)
1 1133
22.0%
2 940
18.3%
3 571
11.1%
4 524
10.2%
6 394
 
7.7%
5 376
 
7.3%
0 346
 
6.7%
9 300
 
5.8%
7 288
 
5.6%
8 271
 
5.3%
Uppercase Letter
ValueCountFrequency (%)
G 1
16.7%
I 1
16.7%
L 1
16.7%
T 1
16.7%
P 1
16.7%
A 1
16.7%
Other Punctuation
ValueCountFrequency (%)
※ 2
66.7%
, 1
33.3%
Space Separator
ValueCountFrequency (%)
3031
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 534
100.0%
Open Punctuation
ValueCountFrequency (%)
( 523
100.0%
Close Punctuation
ValueCountFrequency (%)
) 521
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 11788
54.7%
Common 9755
45.3%
Latin 6
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 1267
 
10.7%
작 748
 
6.3%
서 713
 
6.0%
구 692
 
5.9%
시 684
 
5.8%
별 681
 
5.8%
울 681
 
5.8%
특 679
 
5.8%
로 611
 
5.2%
길 595
 
5.0%
Other values (254) 4437
37.6%
Common
ValueCountFrequency (%)
3031
31.1%
1 1133
 
11.6%
2 940
 
9.6%
3 571
 
5.9%
- 534
 
5.5%
4 524
 
5.4%
( 523
 
5.4%
) 521
 
5.3%
6 394
 
4.0%
5 376
 
3.9%
Other values (6) 1208
 
12.4%
Latin
ValueCountFrequency (%)
G 1
16.7%
I 1
16.7%
L 1
16.7%
T 1
16.7%
P 1
16.7%
A 1
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 11788
54.7%
ASCII 9759
45.3%
Punctuation 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3031
31.1%
1 1133
 
11.6%
2 940
 
9.6%
3 571
 
5.9%
- 534
 
5.5%
4 524
 
5.4%
( 523
 
5.4%
) 521
 
5.3%
6 394
 
4.0%
5 376
 
3.9%
Other values (11) 1212
 
12.4%
Hangul
ValueCountFrequency (%)
동 1267
 
10.7%
작 748
 
6.3%
서 713
 
6.0%
구 692
 
5.9%
시 684
 
5.8%
별 681
 
5.8%
울 681
 
5.8%
특 679
 
5.8%
로 611
 
5.2%
길 595
 
5.0%
Other values (254) 4437
37.6%
Punctuation
ValueCountFrequency (%)
※ 2
100.0%

소재지지번주소
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing671
Missing (%)100.0%
Memory size6.0 KiB

설치목적구분
Categorical

Distinct5
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size5.4 KiB
생활방범
449 
어린이보호
103 
기타
64 
교통단속
 
36
쓰레기단속
 
19

Length

Max length5
Median length4
Mean length3.9910581
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
생활방범 449
66.9%
어린이보호 103
 
15.4%
기타 64
 
9.5%
교통단속 36
 
5.4%
쓰레기단속 19
 
2.8%

Length

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

Common Values (Plot)

2023-12-11T14:03:17.691833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
생활방범 449
66.9%
어린이보호 103
 
15.4%
기타 64
 
9.5%
교통단속 36
 
5.4%
쓰레기단속 19
 
2.8%

카메라대수
Real number (ℝ)

Distinct8
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.6527571
Minimum1
Maximum9
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.0 KiB
2023-12-11T14:03:17.896043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median3
Q34
95-th percentile4
Maximum9
Range8
Interquartile range (IQR)3

Descriptive statistics

Standard deviation1.3394655
Coefficient of variation (CV)0.50493333
Kurtosis0.34815858
Mean2.6527571
Median Absolute Deviation (MAD)1
Skewness0.28613411
Sum1780
Variance1.7941678
MonotonicityNot monotonic
2023-12-11T14:03:18.111596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
3 228
34.0%
1 219
32.6%
4 162
24.1%
2 31
 
4.6%
5 27
 
4.0%
9 2
 
0.3%
8 1
 
0.1%
6 1
 
0.1%
ValueCountFrequency (%)
1 219
32.6%
2 31
 
4.6%
3 228
34.0%
4 162
24.1%
5 27
 
4.0%
6 1
 
0.1%
8 1
 
0.1%
9 2
 
0.3%
ValueCountFrequency (%)
9 2
 
0.3%
8 1
 
0.1%
6 1
 
0.1%
5 27
 
4.0%
4 162
24.1%
3 228
34.0%
2 31
 
4.6%
1 219
32.6%

카메라화소수
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing671
Missing (%)100.0%
Memory size6.0 KiB

촬영방면정보
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing671
Missing (%)100.0%
Memory size6.0 KiB

보관일수
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing671
Missing (%)100.0%
Memory size6.0 KiB

설치년월
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing671
Missing (%)100.0%
Memory size6.0 KiB

관리기관전화번호
Categorical

CONSTANT 

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

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 671
100.0%

Length

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

Common Values (Plot)

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

위도
Real number (ℝ)

Distinct613
Distinct (%)91.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.497072
Minimum37.47626
Maximum37.51617
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.0 KiB
2023-12-11T14:03:18.725796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.47626
5-th percentile37.48003
Q137.488685
median37.4978
Q337.50523
95-th percentile37.51141
Maximum37.51617
Range0.03991
Interquartile range (IQR)0.016545

Descriptive statistics

Standard deviation0.0099880962
Coefficient of variation (CV)0.00026637003
Kurtosis-0.96126512
Mean37.497072
Median Absolute Deviation (MAD)0.00832
Skewness-0.23547426
Sum25160.535
Variance9.9762066 × 10-5
MonotonicityNot monotonic
2023-12-11T14:03:19.003378image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.47732 3
 
0.4%
37.49551 3
 
0.4%
37.51086 2
 
0.3%
37.47779 2
 
0.3%
37.48955 2
 
0.3%
37.49579 2
 
0.3%
37.48125 2
 
0.3%
37.5 2
 
0.3%
37.49773 2
 
0.3%
37.48185 2
 
0.3%
Other values (603) 649
96.7%
ValueCountFrequency (%)
37.47626 1
 
0.1%
37.47641 1
 
0.1%
37.47695 1
 
0.1%
37.47706 1
 
0.1%
37.47717 1
 
0.1%
37.47732 3
0.4%
37.47735 1
 
0.1%
37.47739 1
 
0.1%
37.47757 1
 
0.1%
37.47774 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.51396 1
0.1%
37.5139 1
0.1%
37.51373 1
0.1%
37.51355 1
0.1%

경도
Real number (ℝ)

Distinct632
Distinct (%)94.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.94898
Minimum126.90498
Maximum126.98279
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.0 KiB
2023-12-11T14:03:19.255486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.90498
5-th percentile126.91295
Q1126.93368
median126.9467
Q3126.96822
95-th percentile126.98002
Maximum126.98279
Range0.07781
Interquartile range (IQR)0.03453

Descriptive statistics

Standard deviation0.02045384
Coefficient of variation (CV)0.00016111858
Kurtosis-1.0142235
Mean126.94898
Median Absolute Deviation (MAD)0.01643
Skewness-0.062165393
Sum85182.769
Variance0.00041835958
MonotonicityNot monotonic
2023-12-11T14:03:19.527320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.97253 4
 
0.6%
126.92926 2
 
0.3%
126.96624 2
 
0.3%
126.91649 2
 
0.3%
126.98192 2
 
0.3%
126.97579 2
 
0.3%
126.9451 2
 
0.3%
126.93079 2
 
0.3%
126.96111 2
 
0.3%
126.97557 2
 
0.3%
Other values (622) 649
96.7%
ValueCountFrequency (%)
126.90498 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.90786 1
0.1%
126.90828 1
0.1%
126.90881 1
0.1%
ValueCountFrequency (%)
126.98279 1
0.1%
126.98248 1
0.1%
126.98246 1
0.1%
126.98192 2
0.3%
126.98173 1
0.1%
126.98163 1
0.1%
126.9816 1
0.1%
126.98151 1
0.1%
126.98114 1
0.1%
126.98109 2
0.3%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size5.4 KiB
Minimum2019-05-16 00:00:00
Maximum2019-05-16 00:00:00
2023-12-11T14:03:19.752114image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:03:19.912025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-11T14:03:14.807325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:03:13.692197image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:03:14.235012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:03:14.998875image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:03:13.864465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:03:14.411125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:03:15.166500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:03:14.041545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:03:14.600244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T14:03:20.034451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치목적구분카메라대수위도경도
설치목적구분1.0000.4810.3990.289
카메라대수0.4811.0000.2420.107
위도0.3990.2421.0000.778
경도0.2890.1070.7781.000
2023-12-11T14:03:20.189818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
카메라대수위도경도설치목적구분
카메라대수1.0000.058-0.0280.320
위도0.0581.000-0.3550.176
경도-0.028-0.3551.0000.123
설치목적구분0.3200.1760.1231.000

Missing values

2023-12-11T14:03:15.418984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T14:03:15.744674image/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.51014126.939452019-05-16
1서울특별시동작구청서울특별시 동작구 노량진로8길 40 마당쇠숯불갈비<NA>생활방범3<NA><NA><NA><NA>02-820-290637.5124126.937592019-05-16
2서울특별시동작구청서울특별시 동작구 장승배기로18길 27<NA>생활방범3<NA><NA><NA><NA>02-820-290637.5074126.94162019-05-16
3서울특별시동작구청서울특별시 동작구 만양로14다길 7<NA>생활방범1<NA><NA><NA><NA>02-820-290637.5113126.945312019-05-16
4서울특별시동작구청서울특별시 동작구 장승배기로22길 44(노량진2동 226-15)<NA>생활방범1<NA><NA><NA><NA>02-820-290637.5086126.941562019-05-16
5서울특별시동작구청서울특별시 동작구 장승배기로19다길 24(노량진2동 302-27)<NA>생활방범1<NA><NA><NA><NA>02-820-290637.50927126.937572019-05-16
6서울특별시동작구청서울특별시 동작구 장승배기로24가길 39(노량진1동 232-52)<NA>생활방범1<NA><NA><NA><NA>02-820-290637.51125126.942072019-05-16
7서울특별시동작구청서울특별시 동작구 노량진로26길 65(노량진1동 485-2)<NA>생활방범1<NA><NA><NA><NA>02-820-290637.5097126.955522019-05-16
8서울특별시동작구청서울특별시 동작구 노량진로18길 20(노량진1동 408-1)<NA>생활방범3<NA><NA><NA><NA>02-820-290637.51199126.950972019-05-16
9서울특별시동작구청서울특별시 동작구 상도로60길 35(상도1동 126-65) 동녘빌라<NA>생활방범3<NA><NA><NA><NA>02-820-290637.49226126.95462019-05-16
관리기관명소재지도로명주소소재지지번주소설치목적구분카메라대수카메라화소수촬영방면정보보관일수설치년월관리기관전화번호위도경도데이터기준일자
661서울특별시동작구청서울특별시 동작구 신대방2길 12 보라매빗물펌프장(운영실)<NA>기타2<NA><NA><NA><NA>02-820-290637.48797126.913312019-05-16
662서울특별시동작구청서울특별시 동작구 노량진로 20-2 대방지하보도<NA>기타6<NA><NA><NA><NA>02-820-290637.51333126.926882019-05-16
663서울특별시동작구청서울특별시 동작구 노량진로32길 14-7 용양봉저정<NA>기타5<NA><NA><NA><NA>02-820-290637.51286126.955792019-05-16
664서울특별시동작구청서울특별시 동작구 상도로53길 39 실로암교회 옆 엘리베이터<NA>기타1<NA><NA><NA><NA>02-820-290637.50058126.953532019-05-16
665서울특별시동작구청서울특별시 동작구 동작대로45길 22 갯마을지하보도<NA>기타3<NA><NA><NA><NA>02-820-290637.4973126.982792019-05-16
666서울특별시동작구청서울특별시 동작구 동작대로 9 (사당역 8번출구)<NA>기타1<NA><NA><NA><NA>02-820-290637.47732126.98162019-05-16
667서울특별시동작구청서울특별시 동작구 신대방1길 109<NA>기타1<NA><NA><NA><NA>02-820-290637.48497126.905832019-05-16
668서울특별시동작구청서울특별시 동작구 대림로 19<NA>기타1<NA><NA><NA><NA>02-820-290637.48695126.912032019-05-16
669서울특별시동작구청서울특별시 동작구 신대방2길 14<NA>기타1<NA><NA><NA><NA>02-820-290637.48911126.915492019-05-16
670서울특별시동작구청서울특별시 동작구 여의대방로20길 33<NA>기타1<NA><NA><NA><NA>02-820-290637.48989126.91712019-05-16