Overview

Dataset statistics

Number of variables6
Number of observations159
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.9 KiB
Average record size in memory50.8 B

Variable types

Text2
Numeric2
Categorical2

Dataset

Description고정형CCTV지번주소,위도,경도,자치구,단속지점명,현장구분
Author종로구
URLhttps://data.seoul.go.kr/dataList/OA-20472/S/1/datasetView.do

Alerts

자치구 has constant value ""Constant
현장구분 has constant value ""Constant
단속지점명 has unique valuesUnique

Reproduction

Analysis started2024-04-06 12:08:59.203240
Analysis finished2024-04-06 12:09:00.647952
Duration1.44 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

고정형CCTV지번주소
Text

Distinct157
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2024-04-06T21:09:01.064530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length16
Mean length9.5408805
Min length2

Characters and Unicode

Total characters1517
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

Unique155 ?
Unique (%)97.5%

Sample

1st row동숭동 1-61
2nd row동숭동 1-57
3rd row공평동 1
4th row삼청동 28-6
5th row동숭동 1-27
ValueCountFrequency (%)
종로구 34
 
8.9%
서울 34
 
8.9%
창신동 16
 
4.2%
부암동 8
 
2.1%
숭인동 8
 
2.1%
혜화동 8
 
2.1%
동숭동 8
 
2.1%
청운동 5
 
1.3%
낙원동 4
 
1.1%
신영동 4
 
1.1%
Other values (202) 251
66.1%
2024-04-06T21:09:01.950686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
222
 
14.6%
동 145
 
9.6%
1 136
 
9.0%
- 109
 
7.2%
2 78
 
5.1%
3 60
 
4.0%
로 49
 
3.2%
5 48
 
3.2%
종 44
 
2.9%
6 44
 
2.9%
Other values (74) 582
38.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 646
42.6%
Decimal Number 540
35.6%
Space Separator 222
 
14.6%
Dash Punctuation 109
 
7.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 145
22.4%
로 49
 
7.6%
종 44
 
6.8%
구 36
 
5.6%
서 35
 
5.4%
울 34
 
5.3%
신 31
 
4.8%
가 23
 
3.6%
창 20
 
3.1%
숭 17
 
2.6%
Other values (62) 212
32.8%
Decimal Number
ValueCountFrequency (%)
1 136
25.2%
2 78
14.4%
3 60
11.1%
5 48
 
8.9%
6 44
 
8.1%
8 40
 
7.4%
4 40
 
7.4%
7 35
 
6.5%
0 30
 
5.6%
9 29
 
5.4%
Space Separator
ValueCountFrequency (%)
222
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 109
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 871
57.4%
Hangul 646
42.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 145
22.4%
로 49
 
7.6%
종 44
 
6.8%
구 36
 
5.6%
서 35
 
5.4%
울 34
 
5.3%
신 31
 
4.8%
가 23
 
3.6%
창 20
 
3.1%
숭 17
 
2.6%
Other values (62) 212
32.8%
Common
ValueCountFrequency (%)
222
25.5%
1 136
15.6%
- 109
12.5%
2 78
 
9.0%
3 60
 
6.9%
5 48
 
5.5%
6 44
 
5.1%
8 40
 
4.6%
4 40
 
4.6%
7 35
 
4.0%
Other values (2) 59
 
6.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 871
57.4%
Hangul 646
42.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
222
25.5%
1 136
15.6%
- 109
12.5%
2 78
 
9.0%
3 60
 
6.9%
5 48
 
5.5%
6 44
 
5.1%
8 40
 
4.6%
4 40
 
4.6%
7 35
 
4.0%
Other values (2) 59
 
6.8%
Hangul
ValueCountFrequency (%)
동 145
22.4%
로 49
 
7.6%
종 44
 
6.8%
구 36
 
5.6%
서 35
 
5.4%
울 34
 
5.3%
신 31
 
4.8%
가 23
 
3.6%
창 20
 
3.1%
숭 17
 
2.6%
Other values (62) 212
32.8%

위도
Real number (ℝ)

Distinct157
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.580144
Minimum37.567415
Maximum37.611546
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-04-06T21:09:02.213706image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.567415
5-th percentile37.570296
Q137.57334
median37.577185
Q337.584795
95-th percentile37.601684
Maximum37.611546
Range0.04413083
Interquartile range (IQR)0.011454237

Descriptive statistics

Standard deviation0.0094567267
Coefficient of variation (CV)0.00025164158
Kurtosis1.0779222
Mean37.580144
Median Absolute Deviation (MAD)0.005269
Skewness1.2436869
Sum5975.2429
Variance8.942968 × 10-5
MonotonicityNot monotonic
2024-04-06T21:09:02.489279image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.574936 2
 
1.3%
37.585924 2
 
1.3%
37.571741 1
 
0.6%
37.573543 1
 
0.6%
37.571712 1
 
0.6%
37.569306 1
 
0.6%
37.573646 1
 
0.6%
37.573364 1
 
0.6%
37.584326 1
 
0.6%
37.570144 1
 
0.6%
Other values (147) 147
92.5%
ValueCountFrequency (%)
37.5674151698227 1
0.6%
37.5687030064764 1
0.6%
37.569292 1
0.6%
37.569306 1
0.6%
37.569537 1
0.6%
37.569667 1
0.6%
37.569998 1
0.6%
37.570144 1
0.6%
37.570313 1
0.6%
37.570618 1
0.6%
ValueCountFrequency (%)
37.611546 1
0.6%
37.608028 1
0.6%
37.60649 1
0.6%
37.605652 1
0.6%
37.604895 1
0.6%
37.603958 1
0.6%
37.602735 1
0.6%
37.601895 1
0.6%
37.601661 1
0.6%
37.600788 1
0.6%

경도
Real number (ℝ)

Distinct158
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.98764
Minimum126.95634
Maximum127.022
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-04-06T21:09:03.083621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.95634
5-th percentile126.96086
Q1126.97024
median126.98705
Q3127.00274
95-th percentile127.01563
Maximum127.022
Range0.065661
Interquartile range (IQR)0.0325015

Descriptive statistics

Standard deviation0.018275637
Coefficient of variation (CV)0.00014391666
Kurtosis-1.2686734
Mean126.98764
Median Absolute Deviation (MAD)0.016279
Skewness0.037624084
Sum20191.035
Variance0.00033399891
MonotonicityNot monotonic
2024-04-06T21:09:03.353869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.003334 2
 
1.3%
127.002874 1
 
0.6%
126.990433 1
 
0.6%
126.986947 1
 
0.6%
126.991329 1
 
0.6%
126.991921 1
 
0.6%
126.992144 1
 
0.6%
127.005786 1
 
0.6%
127.003683 1
 
0.6%
126.997443 1
 
0.6%
Other values (148) 148
93.1%
ValueCountFrequency (%)
126.95634 1
0.6%
126.956861 1
0.6%
126.957199 1
0.6%
126.957646 1
0.6%
126.958525 1
0.6%
126.959064 1
0.6%
126.960538 1
0.6%
126.960755 1
0.6%
126.960875 1
0.6%
126.961184 1
0.6%
ValueCountFrequency (%)
127.022001 1
0.6%
127.019838 1
0.6%
127.019049 1
0.6%
127.01737767547397 1
0.6%
127.017096 1
0.6%
127.01586 1
0.6%
127.015756 1
0.6%
127.015656 1
0.6%
127.015626 1
0.6%
127.015563 1
0.6%

자치구
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
종로구
159 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row종로구
2nd row종로구
3rd row종로구
4th row종로구
5th row종로구

Common Values

ValueCountFrequency (%)
종로구 159
100.0%

Length

2024-04-06T21:09:03.622400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T21:09:03.843220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
종로구 159
100.0%

단속지점명
Text

UNIQUE 

Distinct159
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2024-04-06T21:09:04.163681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length20
Mean length13.72327
Min length6

Characters and Unicode

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

Unique

Unique159 ?
Unique (%)100.0%

Sample

1st row대학로예술극장 주변 1
2nd row대학로8가길 36 주변
3rd rowSM면세점 주변
4th row감사원 주변
5th row혜화역 4호선 2번출구 주변
ValueCountFrequency (%)
주변 158
34.4%
어린이 35
 
7.6%
정문 5
 
1.1%
1호선 5
 
1.1%
종로3가역 4
 
0.9%
동묘앞역 4
 
0.9%
3번출구 3
 
0.7%
5호선 3
 
0.7%
청운공원 3
 
0.7%
27 2
 
0.4%
Other values (221) 237
51.6%
2024-04-06T21:09:04.842423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
306
 
14.0%
주 166
 
7.6%
변 160
 
7.3%
) 62
 
2.8%
( 62
 
2.8%
이 51
 
2.3%
어 47
 
2.2%
린 47
 
2.2%
교 41
 
1.9%
로 39
 
1.8%
Other values (244) 1201
55.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1588
72.8%
Space Separator 306
 
14.0%
Decimal Number 151
 
6.9%
Close Punctuation 62
 
2.8%
Open Punctuation 62
 
2.8%
Uppercase Letter 9
 
0.4%
Other Punctuation 2
 
0.1%
Math Symbol 1
 
< 0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 166
 
10.5%
변 160
 
10.1%
이 51
 
3.2%
어 47
 
3.0%
린 47
 
3.0%
교 41
 
2.6%
로 39
 
2.5%
동 37
 
2.3%
문 34
 
2.1%
구 28
 
1.8%
Other values (222) 938
59.1%
Decimal Number
ValueCountFrequency (%)
1 32
21.2%
3 32
21.2%
2 23
15.2%
5 14
9.3%
0 12
 
7.9%
4 11
 
7.3%
8 7
 
4.6%
9 7
 
4.6%
6 7
 
4.6%
7 6
 
4.0%
Uppercase Letter
ValueCountFrequency (%)
K 2
22.2%
B 2
22.2%
I 2
22.2%
M 1
11.1%
S 1
11.1%
R 1
11.1%
Space Separator
ValueCountFrequency (%)
306
100.0%
Close Punctuation
ValueCountFrequency (%)
) 62
100.0%
Open Punctuation
ValueCountFrequency (%)
( 62
100.0%
Other Punctuation
ValueCountFrequency (%)
/ 2
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1588
72.8%
Common 585
 
26.8%
Latin 9
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 166
 
10.5%
변 160
 
10.1%
이 51
 
3.2%
어 47
 
3.0%
린 47
 
3.0%
교 41
 
2.6%
로 39
 
2.5%
동 37
 
2.3%
문 34
 
2.1%
구 28
 
1.8%
Other values (222) 938
59.1%
Common
ValueCountFrequency (%)
306
52.3%
) 62
 
10.6%
( 62
 
10.6%
1 32
 
5.5%
3 32
 
5.5%
2 23
 
3.9%
5 14
 
2.4%
0 12
 
2.1%
4 11
 
1.9%
8 7
 
1.2%
Other values (6) 24
 
4.1%
Latin
ValueCountFrequency (%)
K 2
22.2%
B 2
22.2%
I 2
22.2%
M 1
11.1%
S 1
11.1%
R 1
11.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1588
72.8%
ASCII 594
 
27.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
306
51.5%
) 62
 
10.4%
( 62
 
10.4%
1 32
 
5.4%
3 32
 
5.4%
2 23
 
3.9%
5 14
 
2.4%
0 12
 
2.0%
4 11
 
1.9%
8 7
 
1.2%
Other values (12) 33
 
5.6%
Hangul
ValueCountFrequency (%)
주 166
 
10.5%
변 160
 
10.1%
이 51
 
3.2%
어 47
 
3.0%
린 47
 
3.0%
교 41
 
2.6%
로 39
 
2.5%
동 37
 
2.3%
문 34
 
2.1%
구 28
 
1.8%
Other values (222) 938
59.1%

현장구분
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
불법주정차구역
159 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row불법주정차구역
2nd row불법주정차구역
3rd row불법주정차구역
4th row불법주정차구역
5th row불법주정차구역

Common Values

ValueCountFrequency (%)
불법주정차구역 159
100.0%

Length

2024-04-06T21:09:05.136020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T21:09:05.341750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
불법주정차구역 159
100.0%

Interactions

2024-04-06T21:08:59.919000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T21:08:59.600071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T21:09:00.088896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T21:08:59.752326image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-06T21:09:05.460508image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.712
경도0.7121.000
2024-04-06T21:09:05.622552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.000-0.385
경도-0.3851.000

Missing values

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

고정형CCTV지번주소위도경도자치구단속지점명현장구분
0동숭동 1-6137.581777127.002874종로구대학로예술극장 주변 1불법주정차구역
1동숭동 1-5737.582556127.002353종로구대학로8가길 36 주변불법주정차구역
2공평동 137.572257126.984345종로구SM면세점 주변불법주정차구역
3삼청동 28-637.586893126.983521종로구감사원 주변불법주정차구역
4동숭동 1-2737.581843127.002123종로구혜화역 4호선 2번출구 주변불법주정차구역
5신문로1가 7-537.570764126.975918종로구현대해상 본사 주변불법주정차구역
6삼청동 7137.585041126.982137종로구삼청동주민센터 주변불법주정차구역
7이화동 14937.576877127.002369종로구서울사대부설초교 주변불법주정차구역
8연건동 32-237.57958127.001976종로구연건119안전센터 주변불법주정차구역
9혜화동 90-737.585467127.001626종로구혜화동로터리 주변불법주정차구역
고정형CCTV지번주소위도경도자치구단속지점명현장구분
149서울 종로구 신문로2가 1-25137.57347126.968508종로구대한축구협회 사거리 주변불법주정차구역
150서울 종로구 신교동 6637.583898126.970203종로구푸르메센터 주변불법주정차구역
151서울 종로구 창신동 651-1437.573396127.010608종로구창신길 39 주변불법주정차구역
152서울 종로구 원서동 181-537.578404126.989143종로구현대다솜어린이집 주변불법주정차구역
153서울 종로구 재동 8337.578383126.985332종로구헌법재판소 앞 주변불법주정차구역
154서울 종로구 익선동 30-637.575488126.989187종로구교동초교(삼일대로32길) 주변불법주정차구역
155서울 종로구 궁정동 2-237.584548126.972584종로구주한교황청대사관 주변불법주정차구역
156서울 종로구 청운동 89-1237.586221126.972956종로구청운실버센터 주변불법주정차구역
157서울 종로구 부암동 333-837.591488126.966033종로구인왕산로(자하손만두) 주변불법주정차구역
158서울 종로구 원남동 96-937.575672126.997551종로구원남동사거리 주변불법주정차구역