Overview

Dataset statistics

Number of variables6
Number of observations236
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.7 KiB
Average record size in memory50.6 B

Variable types

Text2
Numeric2
Categorical2

Dataset

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

Alerts

자치구 has constant value ""Constant
현장구분 has constant value ""Constant

Reproduction

Analysis started2024-04-06 11:44:14.245223
Analysis finished2024-04-06 11:44:17.079111
Duration2.83 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

고정형CCTV지번주소
Text

Distinct233
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2024-04-06T20:44:17.620314image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length18
Mean length13.707627
Min length5

Characters and Unicode

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

Unique

Unique230 ?
Unique (%)97.5%

Sample

1st row서울 성북구 길음동 478-4
2nd row서울 성북구 종암동 79-213
3rd row서울 성북구 돈암동 51-4
4th row서울 성북구 안암동5가 1-2
5th row길음동 635-7
ValueCountFrequency (%)
성북구 136
18.2%
서울 133
17.8%
정릉동 40
 
5.4%
장위동 30
 
4.0%
길음동 29
 
3.9%
하월곡동 28
 
3.8%
종암동 25
 
3.4%
돈암동 17
 
2.3%
석관동 10
 
1.3%
성북동 6
 
0.8%
Other values (253) 292
39.1%
2024-04-06T20:44:18.560833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
517
16.0%
동 251
 
7.8%
- 194
 
6.0%
1 192
 
5.9%
2 158
 
4.9%
성 144
 
4.5%
북 144
 
4.5%
울 136
 
4.2%
서 136
 
4.2%
구 136
 
4.2%
Other values (36) 1227
37.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1493
46.2%
Decimal Number 1029
31.8%
Space Separator 517
 
16.0%
Dash Punctuation 194
 
6.0%
Open Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 251
16.8%
성 144
 
9.6%
북 144
 
9.6%
울 136
 
9.1%
서 136
 
9.1%
구 136
 
9.1%
암 53
 
3.5%
가 49
 
3.3%
정 41
 
2.7%
릉 41
 
2.7%
Other values (22) 362
24.2%
Decimal Number
ValueCountFrequency (%)
1 192
18.7%
2 158
15.4%
3 107
10.4%
8 104
10.1%
4 99
9.6%
7 91
8.8%
6 86
8.4%
5 77
7.5%
0 67
 
6.5%
9 48
 
4.7%
Space Separator
ValueCountFrequency (%)
517
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 194
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1742
53.8%
Hangul 1493
46.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 251
16.8%
성 144
 
9.6%
북 144
 
9.6%
울 136
 
9.1%
서 136
 
9.1%
구 136
 
9.1%
암 53
 
3.5%
가 49
 
3.3%
정 41
 
2.7%
릉 41
 
2.7%
Other values (22) 362
24.2%
Common
ValueCountFrequency (%)
517
29.7%
- 194
 
11.1%
1 192
 
11.0%
2 158
 
9.1%
3 107
 
6.1%
8 104
 
6.0%
4 99
 
5.7%
7 91
 
5.2%
6 86
 
4.9%
5 77
 
4.4%
Other values (4) 117
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1742
53.8%
Hangul 1493
46.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
517
29.7%
- 194
 
11.1%
1 192
 
11.0%
2 158
 
9.1%
3 107
 
6.1%
8 104
 
6.0%
4 99
 
5.7%
7 91
 
5.2%
6 86
 
4.9%
5 77
 
4.4%
Other values (4) 117
 
6.7%
Hangul
ValueCountFrequency (%)
동 251
16.8%
성 144
 
9.6%
북 144
 
9.6%
울 136
 
9.1%
서 136
 
9.1%
구 136
 
9.1%
암 53
 
3.5%
가 49
 
3.3%
정 41
 
2.7%
릉 41
 
2.7%
Other values (22) 362
24.2%

위도
Real number (ℝ)

Distinct235
Distinct (%)99.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.601814
Minimum37.36114
Maximum37.622247
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.2 KiB
2024-04-06T20:44:18.828883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.36114
5-th percentile37.584021
Q137.596228
median37.603963
Q337.610397
95-th percentile37.617975
Maximum37.622247
Range0.2611066
Interquartile range (IQR)0.014168169

Descriptive statistics

Standard deviation0.018729749
Coefficient of variation (CV)0.0004981076
Kurtosis116.18838
Mean37.601814
Median Absolute Deviation (MAD)0.0066419098
Skewness-9.1246693
Sum8874.028
Variance0.00035080351
MonotonicityNot monotonic
2024-04-06T20:44:19.145821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.6138873 2
 
0.8%
37.6115970194959 1
 
0.4%
37.61900918450178 1
 
0.4%
37.6215648191839 1
 
0.4%
37.610910872834985 1
 
0.4%
37.59567334601336 1
 
0.4%
37.58308558896418 1
 
0.4%
37.59934489686 1
 
0.4%
37.599090174762 1
 
0.4%
37.5875356711495 1
 
0.4%
Other values (225) 225
95.3%
ValueCountFrequency (%)
37.36114 1
0.4%
37.5790318 1
0.4%
37.5791606498229 1
0.4%
37.5795842440005 1
0.4%
37.57974690758516 1
0.4%
37.5803735415022 1
0.4%
37.5805787 1
0.4%
37.5809781 1
0.4%
37.58308558896418 1
0.4%
37.5833824 1
0.4%
ValueCountFrequency (%)
37.6222466 1
0.4%
37.6219094352573 1
0.4%
37.6215648191839 1
0.4%
37.621278 1
0.4%
37.6208849984295 1
0.4%
37.62010614058534 1
0.4%
37.61939594097348 1
0.4%
37.6193132188677 1
0.4%
37.61900918450178 1
0.4%
37.6188563 1
0.4%

경도
Real number (ℝ)

Distinct235
Distinct (%)99.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.02606
Minimum126.98953
Maximum127.07024
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.2 KiB
2024-04-06T20:44:19.448953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.98953
5-th percentile127.00411
Q1127.01347
median127.02278
Q3127.03547
95-th percentile127.05583
Maximum127.07024
Range0.080713411
Interquartile range (IQR)0.021999698

Descriptive statistics

Standard deviation0.016112741
Coefficient of variation (CV)0.00012684594
Kurtosis-0.42261226
Mean127.02606
Median Absolute Deviation (MAD)0.010358172
Skewness0.43348884
Sum29978.151
Variance0.00025962041
MonotonicityNot monotonic
2024-04-06T20:44:19.698686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.0170282 2
 
0.8%
127.029407994221 1
 
0.4%
127.00589568449124 1
 
0.4%
127.051104362734 1
 
0.4%
127.03546653907344 1
 
0.4%
127.00912101908789 1
 
0.4%
127.01714360928749 1
 
0.4%
127.00896859352024 1
 
0.4%
127.007873311169 1
 
0.4%
127.02209808898824 1
 
0.4%
Other values (225) 225
95.3%
ValueCountFrequency (%)
126.989525786594 1
0.4%
126.9936432 1
0.4%
126.995299185127 1
0.4%
126.997163553449 1
0.4%
126.9975442 1
0.4%
126.9985444 1
0.4%
126.99911395595912 1
0.4%
127.000333434653 1
0.4%
127.00039213641266 1
0.4%
127.002566 1
0.4%
ValueCountFrequency (%)
127.07023919785878 1
0.4%
127.0616438 1
0.4%
127.0610905209008 1
0.4%
127.0606347 1
0.4%
127.06058387064468 1
0.4%
127.06046830725585 1
0.4%
127.059861004581 1
0.4%
127.0595381 1
0.4%
127.0591763 1
0.4%
127.05867920832 1
0.4%

자치구
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
성북구
236 

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 (%)
성북구 236
100.0%

Length

2024-04-06T20:44:19.929590image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:44:20.076492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
성북구 236
100.0%

단속지점명
Text

Distinct234
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2024-04-06T20:44:20.385598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length33
Median length23
Mean length11.067797
Min length4

Characters and Unicode

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

Unique

Unique232 ?
Unique (%)98.3%

Sample

1st row길음2동 뚜레쥬르 송천센트레빌
2nd row새날어린이집
3rd row매원초등학교
4th row고려대학교 어린이집
5th row신안아파트 앞 길음초등학교
ValueCountFrequency (%)
앞 19
 
4.8%
정문 15
 
3.8%
인근 10
 
2.5%
후문 7
 
1.8%
사거리 6
 
1.5%
주변 6
 
1.5%
상가 4
 
1.0%
출구 4
 
1.0%
입구 3
 
0.8%
맞은편 3
 
0.8%
Other values (302) 322
80.7%
2024-04-06T20:44:20.872618image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
172
 
6.6%
길 74
 
2.8%
) 68
 
2.6%
( 68
 
2.6%
로 64
 
2.5%
교 62
 
2.4%
1 59
 
2.3%
이 57
 
2.2%
2 54
 
2.1%
동 53
 
2.0%
Other values (272) 1881
72.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1959
75.0%
Decimal Number 309
 
11.8%
Space Separator 172
 
6.6%
Close Punctuation 68
 
2.6%
Open Punctuation 68
 
2.6%
Dash Punctuation 18
 
0.7%
Uppercase Letter 15
 
0.6%
Other Punctuation 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
길 74
 
3.8%
로 64
 
3.3%
교 62
 
3.2%
이 57
 
2.9%
동 53
 
2.7%
초 52
 
2.7%
학 48
 
2.5%
원 46
 
2.3%
등 45
 
2.3%
문 45
 
2.3%
Other values (249) 1413
72.1%
Decimal Number
ValueCountFrequency (%)
1 59
19.1%
2 54
17.5%
3 33
10.7%
4 29
9.4%
5 23
 
7.4%
8 23
 
7.4%
9 23
 
7.4%
7 22
 
7.1%
0 22
 
7.1%
6 21
 
6.8%
Uppercase Letter
ValueCountFrequency (%)
A 3
20.0%
P 3
20.0%
T 3
20.0%
G 2
13.3%
M 2
13.3%
K 1
 
6.7%
B 1
 
6.7%
Other Punctuation
ValueCountFrequency (%)
, 2
66.7%
@ 1
33.3%
Space Separator
ValueCountFrequency (%)
172
100.0%
Close Punctuation
ValueCountFrequency (%)
) 68
100.0%
Open Punctuation
ValueCountFrequency (%)
( 68
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 18
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1959
75.0%
Common 638
 
24.4%
Latin 15
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
길 74
 
3.8%
로 64
 
3.3%
교 62
 
3.2%
이 57
 
2.9%
동 53
 
2.7%
초 52
 
2.7%
학 48
 
2.5%
원 46
 
2.3%
등 45
 
2.3%
문 45
 
2.3%
Other values (249) 1413
72.1%
Common
ValueCountFrequency (%)
172
27.0%
) 68
 
10.7%
( 68
 
10.7%
1 59
 
9.2%
2 54
 
8.5%
3 33
 
5.2%
4 29
 
4.5%
5 23
 
3.6%
8 23
 
3.6%
9 23
 
3.6%
Other values (6) 86
13.5%
Latin
ValueCountFrequency (%)
A 3
20.0%
P 3
20.0%
T 3
20.0%
G 2
13.3%
M 2
13.3%
K 1
 
6.7%
B 1
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1959
75.0%
ASCII 653
 
25.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
172
26.3%
) 68
 
10.4%
( 68
 
10.4%
1 59
 
9.0%
2 54
 
8.3%
3 33
 
5.1%
4 29
 
4.4%
5 23
 
3.5%
8 23
 
3.5%
9 23
 
3.5%
Other values (13) 101
15.5%
Hangul
ValueCountFrequency (%)
길 74
 
3.8%
로 64
 
3.3%
교 62
 
3.2%
이 57
 
2.9%
동 53
 
2.7%
초 52
 
2.7%
학 48
 
2.5%
원 46
 
2.3%
등 45
 
2.3%
문 45
 
2.3%
Other values (249) 1413
72.1%

현장구분
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
불법주정차구역
236 

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 (%)
불법주정차구역 236
100.0%

Length

2024-04-06T20:44:21.037284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:44:21.177418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
불법주정차구역 236
100.0%

Interactions

2024-04-06T20:44:16.439950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T20:44:16.094344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T20:44:16.599737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T20:44:16.295566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-06T20:44:21.273535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.320
경도0.3201.000
2024-04-06T20:44:21.389183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.335
경도0.3351.000

Missing values

2024-04-06T20:44:16.817028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T20:44:17.001249image/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서울 성북구 길음동 478-437.611597127.029408성북구길음2동 뚜레쥬르 송천센트레빌불법주정차구역
1서울 성북구 종암동 79-21337.599896127.032247성북구새날어린이집불법주정차구역
2서울 성북구 돈암동 51-437.597791127.02144성북구매원초등학교불법주정차구역
3서울 성북구 안암동5가 1-237.588703127.031698성북구고려대학교 어린이집불법주정차구역
4길음동 635-737.613887127.017028성북구신안아파트 앞 길음초등학교불법주정차구역
5길음동 1280-137.609459127.017374성북구푸르지오@303동 앞 길원초불법주정차구역
6하월곡동 222-637.605641127.037926성북구영광어린이집불법주정차구역
7장위동 238-11837.615198127.048501성북구황금부동산 앞불법주정차구역
8장위동 124-2637.61757127.055734성북구성북청소년수련관불법주정차구역
9석관동 206-737.61141127.059538성북구석관초등학교 후문불법주정차구역
고정형CCTV지번주소위도경도자치구단속지점명현장구분
226서울 성북구 정릉동 84737.612033127.000333성북구정릉사회복지관불법주정차구역
227서울 성북구 성북동 28637.595187126.989526성북구서울다원학교불법주정차구역
228서울 성북구 정릉동 175-2537.603941127.01507성북구짐랜드어린이집불법주정차구역
229서울 성북구 정릉동 772-437.616173127.00526성북구개동유치원 삼거리불법주정차구역
230서울 성북구 정릉동 102537.603207127.016082성북구정릉힐스테이트APT 상가 앞불법주정차구역
231서울 성북구 돈암동 63237.596311127.022462성북구돈암풍림APT 상가 맞은편불법주정차구역
232서울 성북구 장위동 45-837.612919127.060468성북구장위사거리불법주정차구역
233서울 성북구 안암동3가 133-5937.584069127.022899성북구안암빌라주변불법주정차구역
234서울 성북구 장위동 233-67837.611272127.045692성북구월곡초등학교 후문 인근불법주정차구역
235서울 성북구 정릉동 109-3137.600881127.014066성북구아리랑고개사거리불법주정차구역