Overview

Dataset statistics

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

Variable types

Text2
Numeric2
Categorical2

Dataset

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

Alerts

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

Reproduction

Analysis started2024-04-06 10:15:49.626822
Analysis finished2024-04-06 10:15:51.266836
Duration1.64 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

고정형CCTV지번주소
Text

Distinct153
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2024-04-06T19:15:51.704509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length16
Mean length12.993548
Min length7

Characters and Unicode

Total characters2014
Distinct characters40
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

Unique151 ?
Unique (%)97.4%

Sample

1st row구로2동 436
2nd row구로3동 252-89
3rd row구로5동 106-9
4th row구로3동 147-6
5th row구로3동 169-9
ValueCountFrequency (%)
서울 72
 
16.4%
구로구 72
 
16.4%
구로동 30
 
6.8%
고척동 14
 
3.2%
구로3동 13
 
3.0%
구로2동 11
 
2.5%
오류동 10
 
2.3%
신도림동 6
 
1.4%
구로4동 6
 
1.4%
개봉1동 5
 
1.1%
Other values (168) 200
45.6%
2024-04-06T19:15:52.530462image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
299
14.8%
구 217
 
10.8%
동 153
 
7.6%
로 147
 
7.3%
1 140
 
7.0%
- 138
 
6.9%
2 113
 
5.6%
3 90
 
4.5%
7 77
 
3.8%
서 72
 
3.6%
Other values (30) 568
28.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 837
41.6%
Decimal Number 740
36.7%
Space Separator 299
 
14.8%
Dash Punctuation 138
 
6.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 217
25.9%
동 153
18.3%
로 147
17.6%
서 72
 
8.6%
울 72
 
8.6%
고 25
 
3.0%
척 25
 
3.0%
봉 20
 
2.4%
개 17
 
2.0%
오 16
 
1.9%
Other values (18) 73
 
8.7%
Decimal Number
ValueCountFrequency (%)
1 140
18.9%
2 113
15.3%
3 90
12.2%
7 77
10.4%
4 68
9.2%
6 56
 
7.6%
5 53
 
7.2%
0 50
 
6.8%
9 47
 
6.4%
8 46
 
6.2%
Space Separator
ValueCountFrequency (%)
299
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 138
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1177
58.4%
Hangul 837
41.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 217
25.9%
동 153
18.3%
로 147
17.6%
서 72
 
8.6%
울 72
 
8.6%
고 25
 
3.0%
척 25
 
3.0%
봉 20
 
2.4%
개 17
 
2.0%
오 16
 
1.9%
Other values (18) 73
 
8.7%
Common
ValueCountFrequency (%)
299
25.4%
1 140
11.9%
- 138
11.7%
2 113
 
9.6%
3 90
 
7.6%
7 77
 
6.5%
4 68
 
5.8%
6 56
 
4.8%
5 53
 
4.5%
0 50
 
4.2%
Other values (2) 93
 
7.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1177
58.4%
Hangul 837
41.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
299
25.4%
1 140
11.9%
- 138
11.7%
2 113
 
9.6%
3 90
 
7.6%
7 77
 
6.5%
4 68
 
5.8%
6 56
 
4.8%
5 53
 
4.5%
0 50
 
4.2%
Other values (2) 93
 
7.9%
Hangul
ValueCountFrequency (%)
구 217
25.9%
동 153
18.3%
로 147
17.6%
서 72
 
8.6%
울 72
 
8.6%
고 25
 
3.0%
척 25
 
3.0%
봉 20
 
2.4%
개 17
 
2.0%
오 16
 
1.9%
Other values (18) 73
 
8.7%

위도
Real number (ℝ)

UNIQUE 

Distinct155
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.494805
Minimum37.476193
Maximum37.511453
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-04-06T19:15:52.788411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.476193
5-th percentile37.481869
Q137.48776
median37.49544
Q337.500923
95-th percentile37.506593
Maximum37.511453
Range0.035259192
Interquartile range (IQR)0.013163411

Descriptive statistics

Standard deviation0.0081860327
Coefficient of variation (CV)0.00021832445
Kurtosis-0.91094077
Mean37.494805
Median Absolute Deviation (MAD)0.0066765
Skewness-0.05602964
Sum5811.6947
Variance6.7011132 × 10-5
MonotonicityNot monotonic
2024-04-06T19:15:53.066169image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.4944863 1
 
0.6%
37.496172818227336 1
 
0.6%
37.4970497419434 1
 
0.6%
37.4851056 1
 
0.6%
37.4943470676697 1
 
0.6%
37.4818733278888 1
 
0.6%
37.50384696058085 1
 
0.6%
37.5065366437513 1
 
0.6%
37.48789983174323 1
 
0.6%
37.48136380917537 1
 
0.6%
Other values (145) 145
93.5%
ValueCountFrequency (%)
37.47619340844826 1
0.6%
37.47747671145602 1
0.6%
37.480907037082055 1
0.6%
37.4813556 1
0.6%
37.48136380917537 1
0.6%
37.481404 1
0.6%
37.4815273 1
0.6%
37.4818581 1
0.6%
37.4818733278888 1
0.6%
37.4823619480377 1
0.6%
ValueCountFrequency (%)
37.5114526 1
0.6%
37.5112029731186 1
0.6%
37.5111668 1
0.6%
37.5098927 1
0.6%
37.509594942391 1
0.6%
37.5078412 1
0.6%
37.50686047634491 1
0.6%
37.50672284950311 1
0.6%
37.5065366437513 1
0.6%
37.5063054 1
0.6%

경도
Real number (ℝ)

UNIQUE 

Distinct155
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.8707
Minimum126.81633
Maximum126.90139
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-04-06T19:15:53.351509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.81633
5-th percentile126.8377
Q1126.8549
median126.87877
Q3126.88879
95-th percentile126.89758
Maximum126.90139
Range0.085061887
Interquartile range (IQR)0.0338878

Descriptive statistics

Standard deviation0.021268048
Coefficient of variation (CV)0.00016763562
Kurtosis-0.83816666
Mean126.8707
Median Absolute Deviation (MAD)0.0143331
Skewness-0.53504201
Sum19664.958
Variance0.00045232987
MonotonicityNot monotonic
2024-04-06T19:15:53.685952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.8871003 1
 
0.6%
126.84255764811202 1
 
0.6%
126.821650622957 1
 
0.6%
126.8861793 1
 
0.6%
126.824891165345 1
 
0.6%
126.89734934250203 1
 
0.6%
126.88545556111283 1
 
0.6%
126.85859599741316 1
 
0.6%
126.83958427738946 1
 
0.6%
126.83850862202063 1
 
0.6%
Other values (145) 145
93.5%
ValueCountFrequency (%)
126.8163259125092 1
0.6%
126.821650622957 1
0.6%
126.82329547126136 1
0.6%
126.82453818876829 1
0.6%
126.824891165345 1
0.6%
126.82555726826784 1
0.6%
126.8292762 1
0.6%
126.8369902 1
0.6%
126.8380039 1
0.6%
126.83850862202063 1
0.6%
ValueCountFrequency (%)
126.9013878 1
0.6%
126.9012697 1
0.6%
126.8997733 1
0.6%
126.8997578 1
0.6%
126.8993594 1
0.6%
126.8983117 1
0.6%
126.898290771371 1
0.6%
126.8981323 1
0.6%
126.89734934250203 1
0.6%
126.8960739 1
0.6%

자치구
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
구로구
155 

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 (%)
구로구 155
100.0%

Length

2024-04-06T19:15:53.931683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T19:15:54.097000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
구로구 155
100.0%

단속지점명
Text

UNIQUE 

Distinct155
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2024-04-06T19:15:54.364058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length15
Mean length8.2258065
Min length3

Characters and Unicode

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

Unique

Unique155 ?
Unique (%)100.0%

Sample

1st row구로경찰서 앞
2nd row삼화인쇄 앞
3rd row영림중학교 옆
4th row이화우성아파트진입로삼거리
5th row영서중학교 앞
ValueCountFrequency (%)
앞 43
 
16.7%
삼거리 7
 
2.7%
옆 6
 
2.3%
정문 5
 
1.9%
보호구역 3
 
1.2%
어린이 3
 
1.2%
상가 2
 
0.8%
건너편 2
 
0.8%
구로5동 2
 
0.8%
구일중 2
 
0.8%
Other values (180) 183
70.9%
2024-04-06T19:15:54.968059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
114
 
8.9%
앞 54
 
4.2%
구 33
 
2.6%
로 30
 
2.4%
동 27
 
2.1%
아 24
 
1.9%
교 21
 
1.6%
트 21
 
1.6%
고 20
 
1.6%
리 20
 
1.6%
Other values (245) 911
71.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1087
85.3%
Space Separator 114
 
8.9%
Decimal Number 43
 
3.4%
Uppercase Letter 14
 
1.1%
Close Punctuation 8
 
0.6%
Open Punctuation 8
 
0.6%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
앞 54
 
5.0%
구 33
 
3.0%
로 30
 
2.8%
동 27
 
2.5%
아 24
 
2.2%
교 21
 
1.9%
트 21
 
1.9%
고 20
 
1.8%
리 20
 
1.8%
이 18
 
1.7%
Other values (223) 819
75.3%
Decimal Number
ValueCountFrequency (%)
1 11
25.6%
2 9
20.9%
5 7
16.3%
6 4
 
9.3%
0 3
 
7.0%
9 2
 
4.7%
8 2
 
4.7%
4 2
 
4.7%
3 2
 
4.7%
7 1
 
2.3%
Uppercase Letter
ValueCountFrequency (%)
S 3
21.4%
C 3
21.4%
G 2
14.3%
U 2
14.3%
X 1
 
7.1%
T 1
 
7.1%
A 1
 
7.1%
N 1
 
7.1%
Space Separator
ValueCountFrequency (%)
114
100.0%
Close Punctuation
ValueCountFrequency (%)
) 8
100.0%
Open Punctuation
ValueCountFrequency (%)
( 8
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1087
85.3%
Common 174
 
13.6%
Latin 14
 
1.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
앞 54
 
5.0%
구 33
 
3.0%
로 30
 
2.8%
동 27
 
2.5%
아 24
 
2.2%
교 21
 
1.9%
트 21
 
1.9%
고 20
 
1.8%
리 20
 
1.8%
이 18
 
1.7%
Other values (223) 819
75.3%
Common
ValueCountFrequency (%)
114
65.5%
1 11
 
6.3%
2 9
 
5.2%
) 8
 
4.6%
( 8
 
4.6%
5 7
 
4.0%
6 4
 
2.3%
0 3
 
1.7%
9 2
 
1.1%
8 2
 
1.1%
Other values (4) 6
 
3.4%
Latin
ValueCountFrequency (%)
S 3
21.4%
C 3
21.4%
G 2
14.3%
U 2
14.3%
X 1
 
7.1%
T 1
 
7.1%
A 1
 
7.1%
N 1
 
7.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1087
85.3%
ASCII 188
 
14.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
114
60.6%
1 11
 
5.9%
2 9
 
4.8%
) 8
 
4.3%
( 8
 
4.3%
5 7
 
3.7%
6 4
 
2.1%
0 3
 
1.6%
S 3
 
1.6%
C 3
 
1.6%
Other values (12) 18
 
9.6%
Hangul
ValueCountFrequency (%)
앞 54
 
5.0%
구 33
 
3.0%
로 30
 
2.8%
동 27
 
2.5%
아 24
 
2.2%
교 21
 
1.9%
트 21
 
1.9%
고 20
 
1.8%
리 20
 
1.8%
이 18
 
1.7%
Other values (223) 819
75.3%

현장구분
Categorical

CONSTANT 

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

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

Length

2024-04-06T19:15:55.206163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T19:15:55.384754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
불법주정차구역 155
100.0%

Interactions

2024-04-06T19:15:50.628807image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T19:15:50.205348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T19:15:50.806702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T19:15:50.445114image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-06T19:15:55.482947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.774
경도0.7741.000
2024-04-06T19:15:55.634883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.000-0.204
경도-0.2041.000

Missing values

2024-04-06T19:15:51.006485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T19:15:51.194039image/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구로2동 43637.494486126.8871구로구구로경찰서 앞불법주정차구역
1구로3동 252-8937.483716126.891645구로구삼화인쇄 앞불법주정차구역
2구로5동 106-937.497823126.891381구로구영림중학교 옆불법주정차구역
3구로3동 147-637.490383126.893103구로구이화우성아파트진입로삼거리불법주정차구역
4구로3동 169-937.489156126.892512구로구영서중학교 앞불법주정차구역
5신도림동390-4437.507841126.880457구로구신도림주민센터 앞불법주정차구역
6개봉3동370-4037.483692126.853963구로구개봉동 개웅교 앞불법주정차구역
7구로3동23737.481404126.89274구로구신한방불법주정차구역
8개봉1동 465-1037.49944126.853254구로구의당빌딩불법주정차구역
9구로2동 394-5737.490716126.880458구로구벚꽃로 삼거리불법주정차구역
고정형CCTV지번주소위도경도자치구단속지점명현장구분
145서울 구로구 구로동 685-15537.49549126.874208구로구구일중 사거리2불법주정차구역
146서울 구로구 오류동 14-38037.498011126.839441구로구오류 금호어울림아파트 정문 인근불법주정차구역
147서울 구로구 신도림동 375-137.509595126.885201구로구열린어린이집 앞(보미프라자)불법주정차구역
148서울 구로구 개봉동 407-1837.49326126.858686구로구GS25 개봉역점 앞불법주정차구역
149서울 구로구 구로동 607-237.501946126.877127구로구은산빌딩불법주정차구역
150서울 구로구 오류동 137-137.493893126.84557구로구오류동역 1번출구 앞불법주정차구역
151서울 구로구 구로동 1278-137.486582126.891175구로구구로종합사회복지관 앞불법주정차구역
152서울 구로구 개봉동 64-1937.500839126.844931구로구원우빌딩불법주정차구역
153서울 구로구 구로동 1-437.50686126.892271구로구신도림역3번출구불법주정차구역
154서울 구로구 구로동 197-2837.484487126.89271구로구이엔씨벤처드림타워6차불법주정차구역