Overview

Dataset statistics

Number of variables6
Number of observations88
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.4 KiB
Average record size in memory51.5 B

Variable types

Text2
Numeric2
Categorical2

Dataset

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

Alerts

자치구 has constant value ""Constant
현장구분 has constant value ""Constant
고정형CCTV지번주소 has unique valuesUnique
위도 has unique valuesUnique
경도 has unique valuesUnique
단속지점명 has unique valuesUnique

Reproduction

Analysis started2024-04-06 11:00:31.686997
Analysis finished2024-04-06 11:00:33.059072
Duration1.37 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

고정형CCTV지번주소
Text

UNIQUE 

Distinct88
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size836.0 B
2024-04-06T20:00:33.444541image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length18
Mean length10.022727
Min length6

Characters and Unicode

Total characters882
Distinct characters37
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

Unique88 ?
Unique (%)100.0%

Sample

1st row회기동 54-16
2nd row이문동 341-47
3rd row회기동 346-18
4th row답십리1동 486-15
5th row답십리2동 2-201
ValueCountFrequency (%)
장안동 11
 
6.1%
답십리동 8
 
4.4%
전농동 7
 
3.9%
휘경동 7
 
3.9%
용두동 7
 
3.9%
제기동 7
 
3.9%
회기동 5
 
2.8%
이문동 4
 
2.2%
장안1동 4
 
2.2%
신설동 4
 
2.2%
Other values (100) 117
64.6%
2024-04-06T20:00:34.172166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
93
 
10.5%
동 91
 
10.3%
- 80
 
9.1%
1 80
 
9.1%
2 65
 
7.4%
3 50
 
5.7%
4 39
 
4.4%
9 38
 
4.3%
5 35
 
4.0%
0 28
 
3.2%
Other values (27) 283
32.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 411
46.6%
Other Letter 298
33.8%
Space Separator 93
 
10.5%
Dash Punctuation 80
 
9.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 91
30.5%
장 19
 
6.4%
안 19
 
6.4%
리 16
 
5.4%
십 14
 
4.7%
답 14
 
4.7%
기 12
 
4.0%
경 12
 
4.0%
휘 12
 
4.0%
문 11
 
3.7%
Other values (15) 78
26.2%
Decimal Number
ValueCountFrequency (%)
1 80
19.5%
2 65
15.8%
3 50
12.2%
4 39
9.5%
9 38
9.2%
5 35
8.5%
0 28
 
6.8%
6 27
 
6.6%
7 25
 
6.1%
8 24
 
5.8%
Space Separator
ValueCountFrequency (%)
93
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 80
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 584
66.2%
Hangul 298
33.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 91
30.5%
장 19
 
6.4%
안 19
 
6.4%
리 16
 
5.4%
십 14
 
4.7%
답 14
 
4.7%
기 12
 
4.0%
경 12
 
4.0%
휘 12
 
4.0%
문 11
 
3.7%
Other values (15) 78
26.2%
Common
ValueCountFrequency (%)
93
15.9%
- 80
13.7%
1 80
13.7%
2 65
11.1%
3 50
8.6%
4 39
6.7%
9 38
6.5%
5 35
 
6.0%
0 28
 
4.8%
6 27
 
4.6%
Other values (2) 49
8.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 584
66.2%
Hangul 298
33.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
93
15.9%
- 80
13.7%
1 80
13.7%
2 65
11.1%
3 50
8.6%
4 39
6.7%
9 38
6.5%
5 35
 
6.0%
0 28
 
4.8%
6 27
 
4.6%
Other values (2) 49
8.4%
Hangul
ValueCountFrequency (%)
동 91
30.5%
장 19
 
6.4%
안 19
 
6.4%
리 16
 
5.4%
십 14
 
4.7%
답 14
 
4.7%
기 12
 
4.0%
경 12
 
4.0%
휘 12
 
4.0%
문 11
 
3.7%
Other values (15) 78
26.2%

위도
Real number (ℝ)

UNIQUE 

Distinct88
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.579228
Minimum37.563559
Maximum37.601232
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size924.0 B
2024-04-06T20:00:34.429733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.563559
5-th percentile37.565212
Q137.571518
median37.577822
Q337.587338
95-th percentile37.595918
Maximum37.601232
Range0.037673551
Interquartile range (IQR)0.015819729

Descriptive statistics

Standard deviation0.010006842
Coefficient of variation (CV)0.00026628654
Kurtosis-0.89239813
Mean37.579228
Median Absolute Deviation (MAD)0.0071206318
Skewness0.33774204
Sum3306.972
Variance0.0001001369
MonotonicityNot monotonic
2024-04-06T20:00:34.693804image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.5913085191965 1
 
1.1%
37.5975657007894 1
 
1.1%
37.59145063371186 1
 
1.1%
37.57938795702464 1
 
1.1%
37.5763790902045 1
 
1.1%
37.5750632519361 1
 
1.1%
37.574995814306 1
 
1.1%
37.588515 1
 
1.1%
37.5901434817754 1
 
1.1%
37.57143127137561 1
 
1.1%
Other values (78) 78
88.6%
ValueCountFrequency (%)
37.5635586969386 1
1.1%
37.5636079016961 1
1.1%
37.56435821796124 1
1.1%
37.56441075661149 1
1.1%
37.565211 1
1.1%
37.5652128361908 1
1.1%
37.56542509665979 1
1.1%
37.5658404960549 1
1.1%
37.56598752017292 1
1.1%
37.5668003 1
1.1%
ValueCountFrequency (%)
37.60123224788201 1
1.1%
37.59862153487213 1
1.1%
37.598489037706265 1
1.1%
37.5975657007894 1
1.1%
37.596092577446 1
1.1%
37.59559327197172 1
1.1%
37.59463787522692 1
1.1%
37.594499326412 1
1.1%
37.5944265739933 1
1.1%
37.5936129296943 1
1.1%

경도
Real number (ℝ)

UNIQUE 

Distinct88
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.05494
Minimum127.02411
Maximum127.07623
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size924.0 B
2024-04-06T20:00:34.927626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.02411
5-th percentile127.02888
Q1127.04531
median127.05693
Q3127.06416
95-th percentile127.07388
Maximum127.07623
Range0.052119699
Interquartile range (IQR)0.018853308

Descriptive statistics

Standard deviation0.01368056
Coefficient of variation (CV)0.00010767436
Kurtosis-0.48207678
Mean127.05494
Median Absolute Deviation (MAD)0.0098211507
Skewness-0.51687566
Sum11180.835
Variance0.00018715771
MonotonicityNot monotonic
2024-04-06T20:00:35.182717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.055649231405 1
 
1.1%
127.060637456174 1
 
1.1%
127.0507911834108 1
 
1.1%
127.05710574282128 1
 
1.1%
127.04572068037363 1
 
1.1%
127.04670757230676 1
 
1.1%
127.026906979272 1
 
1.1%
127.05892 1
 
1.1%
127.056710422532 1
 
1.1%
127.07484620854817 1
 
1.1%
Other values (78) 78
88.6%
ValueCountFrequency (%)
127.02411434640148 1
1.1%
127.02474396131768 1
1.1%
127.025509796381 1
1.1%
127.026906979272 1
1.1%
127.02797813757 1
1.1%
127.03054232598063 1
1.1%
127.030731821143 1
1.1%
127.03077171603516 1
1.1%
127.034961117228 1
1.1%
127.0358919602174 1
1.1%
ValueCountFrequency (%)
127.0762340458939 1
1.1%
127.07484620854817 1
1.1%
127.074403847227 1
1.1%
127.074200836143 1
1.1%
127.073891154437 1
1.1%
127.073866196873 1
1.1%
127.07383491181504 1
1.1%
127.073465 1
1.1%
127.072750314807 1
1.1%
127.07272677032208 1
1.1%

자치구
Categorical

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size836.0 B
동대문구
88 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row동대문구
2nd row동대문구
3rd row동대문구
4th row동대문구
5th row동대문구

Common Values

ValueCountFrequency (%)
동대문구 88
100.0%

Length

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

Common Values (Plot)

2024-04-06T20:00:35.959321image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동대문구 88
100.0%

단속지점명
Text

UNIQUE 

Distinct88
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size836.0 B
2024-04-06T20:00:36.301809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length33
Mean length27.590909
Min length15

Characters and Unicode

Total characters2428
Distinct characters246
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

Unique88 ?
Unique (%)100.0%

Sample

1st row경희대로4길64(청량초 공영주차장옆,HG0_P002)
2nd row회기로25길54(청량초교 담장,IM1_P006)
3rd row이문로37(베라체캠퍼스@,HG0_P003)
4th row사가정로2길123(답십리초교 후문 사거리,DS1_P002)
5th row한천로59(동아아파트 진입로,DS2_P005)
ValueCountFrequency (%)
답십리로 2
 
1.3%
경희대로4길64(청량초 1
 
0.6%
고산자로31길25(새마을금고,롯데캐슬피랜체,ys0_c068 1
 
0.6%
하정로44(베르빌,ys0_c061 1
 
0.6%
서울시립대로3길4(우리외과,jn1_c009 1
 
0.6%
서울시립대로5길27(밥퍼,jn1_c022 1
 
0.6%
전농로20길10(혜성여고,jn2_c041 1
 
0.6%
천장산로 1
 
0.6%
31(외대후문,삼성래미안삼거리,im1_p005 1
 
0.6%
경희대로1나길56-3(경희의료원 1
 
0.6%
Other values (145) 145
92.9%
2024-04-06T20:00:36.989469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 211
 
8.7%
1 120
 
4.9%
, 101
 
4.2%
로 91
 
3.7%
_ 88
 
3.6%
( 87
 
3.6%
2 87
 
3.6%
) 86
 
3.5%
P 72
 
3.0%
70
 
2.9%
Other values (236) 1415
58.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1062
43.7%
Decimal Number 651
26.8%
Uppercase Letter 268
 
11.0%
Other Punctuation 109
 
4.5%
Connector Punctuation 88
 
3.6%
Open Punctuation 87
 
3.6%
Close Punctuation 86
 
3.5%
Space Separator 70
 
2.9%
Dash Punctuation 7
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 91
 
8.6%
길 48
 
4.5%
장 27
 
2.5%
이 25
 
2.4%
리 25
 
2.4%
경 23
 
2.2%
문 21
 
2.0%
한 21
 
2.0%
대 21
 
2.0%
동 19
 
1.8%
Other values (204) 741
69.8%
Uppercase Letter
ValueCountFrequency (%)
P 72
26.9%
J 36
13.4%
S 25
 
9.3%
A 19
 
7.1%
H 18
 
6.7%
C 18
 
6.7%
D 14
 
5.2%
K 12
 
4.5%
G 12
 
4.5%
N 11
 
4.1%
Other values (5) 31
11.6%
Decimal Number
ValueCountFrequency (%)
0 211
32.4%
1 120
18.4%
2 87
13.4%
4 44
 
6.8%
6 43
 
6.6%
3 40
 
6.1%
5 37
 
5.7%
8 27
 
4.1%
7 25
 
3.8%
9 17
 
2.6%
Other Punctuation
ValueCountFrequency (%)
, 101
92.7%
@ 8
 
7.3%
Connector Punctuation
ValueCountFrequency (%)
_ 88
100.0%
Open Punctuation
ValueCountFrequency (%)
( 87
100.0%
Close Punctuation
ValueCountFrequency (%)
) 86
100.0%
Space Separator
ValueCountFrequency (%)
70
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1098
45.2%
Hangul 1062
43.7%
Latin 268
 
11.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 91
 
8.6%
길 48
 
4.5%
장 27
 
2.5%
이 25
 
2.4%
리 25
 
2.4%
경 23
 
2.2%
문 21
 
2.0%
한 21
 
2.0%
대 21
 
2.0%
동 19
 
1.8%
Other values (204) 741
69.8%
Common
ValueCountFrequency (%)
0 211
19.2%
1 120
10.9%
, 101
9.2%
_ 88
8.0%
( 87
7.9%
2 87
7.9%
) 86
7.8%
70
 
6.4%
4 44
 
4.0%
6 43
 
3.9%
Other values (7) 161
14.7%
Latin
ValueCountFrequency (%)
P 72
26.9%
J 36
13.4%
S 25
 
9.3%
A 19
 
7.1%
H 18
 
6.7%
C 18
 
6.7%
D 14
 
5.2%
K 12
 
4.5%
G 12
 
4.5%
N 11
 
4.1%
Other values (5) 31
11.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1366
56.3%
Hangul 1062
43.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 211
15.4%
1 120
 
8.8%
, 101
 
7.4%
_ 88
 
6.4%
( 87
 
6.4%
2 87
 
6.4%
) 86
 
6.3%
P 72
 
5.3%
70
 
5.1%
4 44
 
3.2%
Other values (22) 400
29.3%
Hangul
ValueCountFrequency (%)
로 91
 
8.6%
길 48
 
4.5%
장 27
 
2.5%
이 25
 
2.4%
리 25
 
2.4%
경 23
 
2.2%
문 21
 
2.0%
한 21
 
2.0%
대 21
 
2.0%
동 19
 
1.8%
Other values (204) 741
69.8%

현장구분
Categorical

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size836.0 B
불법주정차구역
88 

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

Length

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

Common Values (Plot)

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

Interactions

2024-04-06T20:00:32.489220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T20:00:32.171858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T20:00:32.617437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T20:00:32.337396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-06T20:00:37.465652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
고정형CCTV지번주소위도경도단속지점명
고정형CCTV지번주소1.0001.0001.0001.000
위도1.0001.0000.6681.000
경도1.0000.6681.0001.000
단속지점명1.0001.0001.0001.000
2024-04-06T20:00:37.610011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.000-0.108
경도-0.1081.000

Missing values

2024-04-06T20:00:32.811577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T20:00:32.991168image/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회기동 54-1637.591309127.055649동대문구경희대로4길64(청량초 공영주차장옆,HG0_P002)불법주정차구역
1이문동 341-4737.592105127.056759동대문구회기로25길54(청량초교 담장,IM1_P006)불법주정차구역
2회기동 346-1837.590509127.056223동대문구이문로37(베라체캠퍼스@,HG0_P003)불법주정차구역
3답십리1동 486-1537.567654127.055737동대문구사가정로2길123(답십리초교 후문 사거리,DS1_P002)불법주정차구역
4답십리2동 2-20137.567053127.06223동대문구한천로59(동아아파트 진입로,DS2_P005)불법주정차구역
5답십리동 97-837.574892127.057324동대문구전농로111(동호빌딩앞,청솔우성@삼거리,DS1_P003)불법주정차구역
6제기동 101537.578627127.039965동대문구왕산로147(NH농협은행 경동시장,횡단보도,JG0_P004)불법주정차구역
7제기동 271-4837.579787127.034961동대문구정릉천동로83(정릉천 복개주차장입구,JG0_P005)불법주정차구역
8전농동 38-5937.577756127.06017동대문구사가정로138(전농칼국수 앞,JN2_P001)불법주정차구역
9신설동 67-137.576899127.024744동대문구한빛로11(아시아태평양대학,YS0_P006)불법주정차구역
고정형CCTV지번주소위도경도자치구단속지점명현장구분
78용두동 12-537.577538127.041846동대문구고산자로32길 67(한양수자인 그라시엘 앞,YS0_P010)불법주정차구역
79전농동 591-5337.580633127.046513동대문구왕산로210근처( 청량리역4번출구,환승센터,JN1_P003)불법주정차구역
80용두동 255-4737.570993127.027978동대문구청계천로7길4(동대문경찰서교통센터,청계센트럴포레,YS0_P009)불법주정차구역
81전농동 622-137.578336127.043492동대문구답십리로 9(삼성베스트 내과의원,JN1_P004)불법주정차구역
82전농동 620-4737.577925127.044081동대문구답십리로 27 (청량리롯데캐슬 L65, JN1_P005)불법주정차구역
83장안동 355-137.568084127.074201동대문구장한로18길88(장안현대홈타운 후문,JA1_P008)불법주정차구역
84전농동 620-5637.57923127.043475동대문구왕산로36길 6(힐스테이트오피스텔 옆 사거리,JN1_P006)불법주정차구역
85이문동 346-14037.594499127.056524동대문구이문로9길 52(경희중고등학교 정문,IM1_P008)불법주정차구역
86장안동 329-537.576794127.074404동대문구답십리로69길 100(장안힐스테이트아파트,JA2_P007)불법주정차구역
87청량리동 520-7937.586788127.040283동대문구제기로65 (국제자원앞,CR0_P001)불법주정차구역