Overview

Dataset statistics

Number of variables12
Number of observations59
Missing cells177
Missing cells (%)25.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.9 KiB
Average record size in memory103.2 B

Variable types

Categorical5
Text2
Numeric2
Unsupported3

Dataset

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

Alerts

관리기관명 has constant value ""Constant
관할경찰서명 has constant value ""Constant
CCTV설치여부 has constant value ""Constant
데이터기준일자 has constant value ""Constant
CCTV설치대수 has 59 (100.0%) missing valuesMissing
소재지지번주소 has 59 (100.0%) missing valuesMissing
보호구역도로폭 has 59 (100.0%) missing valuesMissing
경도(WGS84좌표) has unique valuesUnique
위도(WGS84좌표) has unique valuesUnique
CCTV설치대수 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 04:13:46.055051
Analysis finished2023-12-11 04:13:47.333676
Duration1.28 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시설종류
Categorical

Distinct4
Distinct (%)6.8%
Missing0
Missing (%)0.0%
Memory size604.0 B
초등학교
21 
유치원
19 
어린이집
18 
특수학교
 
1

Length

Max length4
Median length4
Mean length3.6779661
Min length3

Unique

Unique1 ?
Unique (%)1.7%

Sample

1st row초등학교
2nd row초등학교
3rd row초등학교
4th row초등학교
5th row초등학교

Common Values

ValueCountFrequency (%)
초등학교 21
35.6%
유치원 19
32.2%
어린이집 18
30.5%
특수학교 1
 
1.7%

Length

2023-12-11T13:13:47.437062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T13:13:47.594812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
초등학교 21
35.6%
유치원 19
32.2%
어린이집 18
30.5%
특수학교 1
 
1.7%

대상시설명
Text

Distinct58
Distinct (%)98.3%
Missing0
Missing (%)0.0%
Memory size604.0 B
2023-12-11T13:13:47.903096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length10
Mean length4.9491525
Min length2

Characters and Unicode

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

Unique

Unique57 ?
Unique (%)96.6%

Sample

1st row신상도초등학교
2nd row강남초등학교
3rd row남사초등학교
4th row남성초등학교
5th row노량진초등학교
ValueCountFrequency (%)
상도 2
 
3.3%
은로초등학교 2
 
3.3%
열림 1
 
1.6%
예담 1
 
1.6%
요요 1
 
1.6%
중대부속 1
 
1.6%
강남 1
 
1.6%
성모 1
 
1.6%
행복 1
 
1.6%
신남성초교 1
 
1.6%
Other values (49) 49
80.3%
2023-12-11T13:13:48.355105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
교 30
 
10.3%
초 30
 
10.3%
학 22
 
7.5%
등 22
 
7.5%
) 10
 
3.4%
( 10
 
3.4%
남 10
 
3.4%
상 8
 
2.7%
성 7
 
2.4%
신 6
 
2.1%
Other values (74) 137
46.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 270
92.5%
Close Punctuation 10
 
3.4%
Open Punctuation 10
 
3.4%
Space Separator 2
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
교 30
 
11.1%
초 30
 
11.1%
학 22
 
8.1%
등 22
 
8.1%
남 10
 
3.7%
상 8
 
3.0%
성 7
 
2.6%
신 6
 
2.2%
사 6
 
2.2%
은 5
 
1.9%
Other values (71) 124
45.9%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 270
92.5%
Common 22
 
7.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
교 30
 
11.1%
초 30
 
11.1%
학 22
 
8.1%
등 22
 
8.1%
남 10
 
3.7%
상 8
 
3.0%
성 7
 
2.6%
신 6
 
2.2%
사 6
 
2.2%
은 5
 
1.9%
Other values (71) 124
45.9%
Common
ValueCountFrequency (%)
) 10
45.5%
( 10
45.5%
2
 
9.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 270
92.5%
ASCII 22
 
7.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
교 30
 
11.1%
초 30
 
11.1%
학 22
 
8.1%
등 22
 
8.1%
남 10
 
3.7%
상 8
 
3.0%
성 7
 
2.6%
신 6
 
2.2%
사 6
 
2.2%
은 5
 
1.9%
Other values (71) 124
45.9%
ASCII
ValueCountFrequency (%)
) 10
45.5%
( 10
45.5%
2
 
9.1%

소재지도로명주소
Text

Distinct56
Distinct (%)94.9%
Missing0
Missing (%)0.0%
Memory size604.0 B
2023-12-11T13:13:48.733951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length21
Mean length18.661017
Min length13

Characters and Unicode

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

Unique

Unique53 ?
Unique (%)89.8%

Sample

1st row서울특별시 동작구 장승배기로 14
2nd row서울특별시 동작구 강남초등길 15
3rd row서울특별시 동작구 동작대로13길 22
4th row서울특별시 동작구 사당로23길 57-14
5th row서울특별시 동작구 장승배기로 160
ValueCountFrequency (%)
서울특별시 59
25.5%
동작구 59
25.5%
15 4
 
1.7%
서달로 3
 
1.3%
27 3
 
1.3%
22 2
 
0.9%
흑석동 2
 
0.9%
16 2
 
0.9%
여의대방로36길 2
 
0.9%
14 2
 
0.9%
Other values (84) 93
40.3%
2023-12-11T13:13:49.236750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
173
15.7%
동 69
 
6.3%
서 63
 
5.7%
작 63
 
5.7%
시 60
 
5.4%
특 59
 
5.4%
별 59
 
5.4%
구 59
 
5.4%
울 59
 
5.4%
로 49
 
4.5%
Other values (53) 388
35.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 724
65.8%
Decimal Number 196
 
17.8%
Space Separator 173
 
15.7%
Dash Punctuation 8
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 69
9.5%
서 63
8.7%
작 63
8.7%
시 60
8.3%
특 59
8.1%
별 59
8.1%
구 59
8.1%
울 59
8.1%
로 49
 
6.8%
길 40
 
5.5%
Other values (41) 144
19.9%
Decimal Number
ValueCountFrequency (%)
1 47
24.0%
2 33
16.8%
4 24
12.2%
3 23
11.7%
6 20
10.2%
5 13
 
6.6%
7 12
 
6.1%
0 10
 
5.1%
8 7
 
3.6%
9 7
 
3.6%
Space Separator
ValueCountFrequency (%)
173
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 724
65.8%
Common 377
34.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 69
9.5%
서 63
8.7%
작 63
8.7%
시 60
8.3%
특 59
8.1%
별 59
8.1%
구 59
8.1%
울 59
8.1%
로 49
 
6.8%
길 40
 
5.5%
Other values (41) 144
19.9%
Common
ValueCountFrequency (%)
173
45.9%
1 47
 
12.5%
2 33
 
8.8%
4 24
 
6.4%
3 23
 
6.1%
6 20
 
5.3%
5 13
 
3.4%
7 12
 
3.2%
0 10
 
2.7%
- 8
 
2.1%
Other values (2) 14
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 724
65.8%
ASCII 377
34.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
173
45.9%
1 47
 
12.5%
2 33
 
8.8%
4 24
 
6.4%
3 23
 
6.1%
6 20
 
5.3%
5 13
 
3.4%
7 12
 
3.2%
0 10
 
2.7%
- 8
 
2.1%
Other values (2) 14
 
3.7%
Hangul
ValueCountFrequency (%)
동 69
9.5%
서 63
8.7%
작 63
8.7%
시 60
8.3%
특 59
8.1%
별 59
8.1%
구 59
8.1%
울 59
8.1%
로 49
 
6.8%
길 40
 
5.5%
Other values (41) 144
19.9%

경도(WGS84좌표)
Real number (ℝ)

UNIQUE 

Distinct59
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.94923
Minimum126.90749
Maximum126.98069
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size663.0 B
2023-12-11T13:13:49.455454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.90749
5-th percentile126.91586
Q1126.93567
median126.94997
Q3126.96453
95-th percentile126.97886
Maximum126.98069
Range0.073198
Interquartile range (IQR)0.02885785

Descriptive statistics

Standard deviation0.019117561
Coefficient of variation (CV)0.00015059218
Kurtosis-0.75978797
Mean126.94923
Median Absolute Deviation (MAD)0.0147066
Skewness-0.16631259
Sum7490.0044
Variance0.00036548116
MonotonicityNot monotonic
2023-12-11T13:13:49.702799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.9440875 1
 
1.7%
126.9527103 1
 
1.7%
126.9558951 1
 
1.7%
126.949975 1
 
1.7%
126.951925 1
 
1.7%
126.9399895 1
 
1.7%
126.941125 1
 
1.7%
126.964764 1
 
1.7%
126.9598625 1
 
1.7%
126.9502282 1
 
1.7%
Other values (49) 49
83.1%
ValueCountFrequency (%)
126.9074905 1
1.7%
126.912675 1
1.7%
126.91375 1
1.7%
126.91609 1
1.7%
126.921175 1
1.7%
126.922989 1
1.7%
126.9253283 1
1.7%
126.9263625 1
1.7%
126.9269611 1
1.7%
126.9292403 1
1.7%
ValueCountFrequency (%)
126.9806885 1
1.7%
126.9793271 1
1.7%
126.9789897 1
1.7%
126.97885 1
1.7%
126.9776381 1
1.7%
126.9772236 1
1.7%
126.975624 1
1.7%
126.9751989 1
1.7%
126.9723962 1
1.7%
126.971775 1
1.7%

위도(WGS84좌표)
Real number (ℝ)

UNIQUE 

Distinct59
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.498061
Minimum37.480902
Maximum37.511734
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size663.0 B
2023-12-11T13:13:49.940941image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.480902
5-th percentile37.4828
Q137.491176
median37.499244
Q337.505017
95-th percentile37.510085
Maximum37.511734
Range0.0308311
Interquartile range (IQR)0.013841

Descriptive statistics

Standard deviation0.0088982122
Coefficient of variation (CV)0.00023729793
Kurtosis-0.88362324
Mean37.498061
Median Absolute Deviation (MAD)0.0061241
Skewness-0.4176633
Sum2212.3856
Variance7.917818 × 10-5
MonotonicityNot monotonic
2023-12-11T13:13:50.167322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.5003417 1
 
1.7%
37.5062787 1
 
1.7%
37.5064912 1
 
1.7%
37.5035667 1
 
1.7%
37.5015083 1
 
1.7%
37.50161 1
 
1.7%
37.495793 1
 
1.7%
37.488571 1
 
1.7%
37.5031333 1
 
1.7%
37.4980682 1
 
1.7%
Other values (49) 49
83.1%
ValueCountFrequency (%)
37.4809025 1
1.7%
37.4816578 1
1.7%
37.4826872 1
1.7%
37.482812 1
1.7%
37.4830502 1
1.7%
37.4830596 1
1.7%
37.4831214 1
1.7%
37.4844213 1
1.7%
37.48517 1
1.7%
37.4882458 1
1.7%
ValueCountFrequency (%)
37.5117336 1
1.7%
37.5106172 1
1.7%
37.5104701 1
1.7%
37.5100424 1
1.7%
37.5089505 1
1.7%
37.5089181 1
1.7%
37.508827 1
1.7%
37.5086325 1
1.7%
37.508575 1
1.7%
37.5084262 1
1.7%

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size604.0 B
서울특별시 동작구청
59 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

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

Length

2023-12-11T13:13:50.382814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T13:13:50.514918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울특별시 59
50.0%
동작구청 59
50.0%

관할경찰서명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size604.0 B
동작경찰서
59 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row동작경찰서
2nd row동작경찰서
3rd row동작경찰서
4th row동작경찰서
5th row동작경찰서

Common Values

ValueCountFrequency (%)
동작경찰서 59
100.0%

Length

2023-12-11T13:13:50.650436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T13:13:50.758397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동작경찰서 59
100.0%

CCTV설치여부
Categorical

CONSTANT 

Distinct1
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size604.0 B
설치
59 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row설치
2nd row설치
3rd row설치
4th row설치
5th row설치

Common Values

ValueCountFrequency (%)
설치 59
100.0%

Length

2023-12-11T13:13:50.887305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T13:13:51.024062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
설치 59
100.0%

CCTV설치대수
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing59
Missing (%)100.0%
Memory size663.0 B

소재지지번주소
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing59
Missing (%)100.0%
Memory size663.0 B

보호구역도로폭
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing59
Missing (%)100.0%
Memory size663.0 B

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size604.0 B
2016-05-31
59 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2016-05-31
2nd row2016-05-31
3rd row2016-05-31
4th row2016-05-31
5th row2016-05-31

Common Values

ValueCountFrequency (%)
2016-05-31 59
100.0%

Length

2023-12-11T13:13:51.165233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T13:13:51.287771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2016-05-31 59
100.0%

Interactions

2023-12-11T13:13:46.709217image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T13:13:46.474021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T13:13:46.856796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T13:13:46.581969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T13:13:51.378923image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시설종류대상시설명소재지도로명주소경도(WGS84좌표)위도(WGS84좌표)
시설종류1.0000.8990.7810.2580.000
대상시설명0.8991.0000.9910.9410.937
소재지도로명주소0.7810.9911.0000.9851.000
경도(WGS84좌표)0.2580.9410.9851.0000.582
위도(WGS84좌표)0.0000.9371.0000.5821.000
2023-12-11T13:13:51.522938image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
경도(WGS84좌표)위도(WGS84좌표)시설종류
경도(WGS84좌표)1.000-0.3760.139
위도(WGS84좌표)-0.3761.0000.000
시설종류0.1390.0001.000

Missing values

2023-12-11T13:13:47.021400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T13:13:47.259873image/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

시설종류대상시설명소재지도로명주소경도(WGS84좌표)위도(WGS84좌표)관리기관명관할경찰서명CCTV설치여부CCTV설치대수소재지지번주소보호구역도로폭데이터기준일자
0초등학교신상도초등학교서울특별시 동작구 장승배기로 14126.94408737.500342서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
1초등학교강남초등학교서울특별시 동작구 강남초등길 15126.9527137.506279서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
2초등학교남사초등학교서울특별시 동작구 동작대로13길 22126.9789937.482687서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
3초등학교남성초등학교서울특별시 동작구 사당로23길 57-14126.97562437.484421서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
4초등학교노량진초등학교서울특별시 동작구 장승배기로 160126.94073937.511734서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
5초등학교대림초등학교서울특별시 동작구 대방동1길 22126.92532837.5006서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
6초등학교동작초등학교서울특별시 동작구 동작대로29길 214126.97722437.494237서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
7초등학교문창초등학교서울특별시 동작구 신대방2길 14126.9137537.48886서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
8초등학교보라매초등학교서울특별시 동작구 여의대방로16길 30126.9160937.4959서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
9초등학교본동초등학교서울특별시 동작구 노량진로26길 16-40126.95357537.510042서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
시설종류대상시설명소재지도로명주소경도(WGS84좌표)위도(WGS84좌표)관리기관명관할경찰서명CCTV설치여부CCTV설치대수소재지지번주소보호구역도로폭데이터기준일자
49어린이집흑석서울특별시 동작구 서달로 72126.96168737.499994서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
50어린이집상도서울특별시 동작구 양녕로36길 15126.94639337.502609서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
51어린이집다문화(남사초교)서울특별시 동작구 동작대로17길 28126.9788537.48306서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
52어린이집노벨(상아유치원)서울특별시 동작구 양녕로 26길 27126.94415537.497362서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
53어린이집애광(애광유치원)서울특별시 동작구 상도동126.9332237.497514서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
54어린이집영재(영화초교)서울특별시 동작구 여의대방로36길 105126.93186837.508827서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
55어린이집문화서울특별시 동작구 사당로13길 24126.97239637.48517서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
56어린이집큰별서울특별시 동작구 흑석동126.96514137.504667서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
57어린이집성대서울특별시 동작구 성대로10길 27126.93526837.496831서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31
58특수학교삼성(신상도초교)서울특별시 동작구 양녕로30길 19-4126.94601437.499244서울특별시 동작구청동작경찰서설치<NA><NA><NA>2016-05-31