Overview

Dataset statistics

Number of variables6
Number of observations3191
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory159.1 KiB
Average record size in memory51.0 B

Variable types

Categorical3
Text1
Numeric2

Dataset

Description자치구,안심 주소,위도,경도,CCTV 수량,수정 일시
Author강동구
URLhttps://data.seoul.go.kr/dataList/OA-20948/S/1/datasetView.do

Alerts

자치구 has constant value ""Constant
CCTV 수량 has constant value ""Constant
수정 일시 has constant value ""Constant
안심 주소 has unique valuesUnique

Reproduction

Analysis started2024-03-13 13:02:11.017607
Analysis finished2024-03-13 13:02:12.127731
Duration1.11 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

자치구
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size25.1 KiB
강동구
3191 

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 (%)
강동구 3191
100.0%

Length

2024-03-13T22:02:12.200660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:02:12.306040image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
강동구 3191
100.0%

안심 주소
Text

UNIQUE 

Distinct3191
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size25.1 KiB
2024-03-13T22:02:12.706325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length50
Median length44
Mean length29.317142
Min length3

Characters and Unicode

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

Unique

Unique3191 ?
Unique (%)100.0%

Sample

1st row강일동 119-6 강빛초등학교 회전교차로(주정차단속-강일동-006)
2nd row강일동 119-6 강빛초등학교 회전교차로(주정차단속-강일동-006-01)
3rd row강일동 119-6 강빛초등학교 회전교차로(주정차단속-강일동-006-02)
4th row강일동 144-8 전신주 옆 (방범-강일동-009)
5th row강일동 144-8 전신주 옆(방범-강일동-009-01)
ValueCountFrequency (%)
천호2동 333
 
3.2%
길동 324
 
3.1%
암사1동 303
 
2.9%
앞 284
 
2.8%
천호1동 248
 
2.4%
성내2동 214
 
2.1%
둔촌2동 208
 
2.0%
성내3동 197
 
1.9%
천호3동 194
 
1.9%
상일1동 169
 
1.6%
Other values (4573) 7826
76.0%
2024-03-13T22:02:13.361380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 10922
 
11.7%
0 7200
 
7.7%
7116
 
7.6%
동 6580
 
7.0%
1 6416
 
6.9%
2 5619
 
6.0%
3 3636
 
3.9%
( 3199
 
3.4%
) 3198
 
3.4%
방 2694
 
2.9%
Other values (376) 36971
39.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 36405
38.9%
Decimal Number 32485
34.7%
Dash Punctuation 10922
 
11.7%
Space Separator 7116
 
7.6%
Open Punctuation 3199
 
3.4%
Close Punctuation 3198
 
3.4%
Uppercase Letter 162
 
0.2%
Connector Punctuation 48
 
0.1%
Other Punctuation 10
 
< 0.1%
Lowercase Letter 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 6580
18.1%
방 2694
 
7.4%
범 2670
 
7.3%
천 1633
 
4.5%
호 1630
 
4.5%
사 1346
 
3.7%
성 1146
 
3.1%
일 1139
 
3.1%
내 1083
 
3.0%
암 1034
 
2.8%
Other values (342) 15450
42.4%
Uppercase Letter
ValueCountFrequency (%)
S 58
35.8%
M 49
30.2%
C 14
 
8.6%
K 9
 
5.6%
I 6
 
3.7%
U 6
 
3.7%
T 4
 
2.5%
E 3
 
1.9%
N 3
 
1.9%
W 3
 
1.9%
Other values (4) 7
 
4.3%
Decimal Number
ValueCountFrequency (%)
0 7200
22.2%
1 6416
19.8%
2 5619
17.3%
3 3636
11.2%
4 2490
 
7.7%
5 1870
 
5.8%
6 1420
 
4.4%
7 1352
 
4.2%
8 1343
 
4.1%
9 1139
 
3.5%
Other Punctuation
ValueCountFrequency (%)
# 5
50.0%
, 4
40.0%
? 1
 
10.0%
Dash Punctuation
ValueCountFrequency (%)
- 10922
100.0%
Space Separator
ValueCountFrequency (%)
7116
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3199
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3198
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 48
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 3
100.0%
Math Symbol
ValueCountFrequency (%)
~ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 56981
60.9%
Hangul 36405
38.9%
Latin 165
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 6580
18.1%
방 2694
 
7.4%
범 2670
 
7.3%
천 1633
 
4.5%
호 1630
 
4.5%
사 1346
 
3.7%
성 1146
 
3.1%
일 1139
 
3.1%
내 1083
 
3.0%
암 1034
 
2.8%
Other values (342) 15450
42.4%
Common
ValueCountFrequency (%)
- 10922
19.2%
0 7200
12.6%
7116
12.5%
1 6416
11.3%
2 5619
9.9%
3 3636
 
6.4%
( 3199
 
5.6%
) 3198
 
5.6%
4 2490
 
4.4%
5 1870
 
3.3%
Other values (9) 5315
9.3%
Latin
ValueCountFrequency (%)
S 58
35.2%
M 49
29.7%
C 14
 
8.5%
K 9
 
5.5%
I 6
 
3.6%
U 6
 
3.6%
T 4
 
2.4%
E 3
 
1.8%
N 3
 
1.8%
W 3
 
1.8%
Other values (5) 10
 
6.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 57146
61.1%
Hangul 36405
38.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 10922
19.1%
0 7200
12.6%
7116
12.5%
1 6416
11.2%
2 5619
9.8%
3 3636
 
6.4%
( 3199
 
5.6%
) 3198
 
5.6%
4 2490
 
4.4%
5 1870
 
3.3%
Other values (24) 5480
9.6%
Hangul
ValueCountFrequency (%)
동 6580
18.1%
방 2694
 
7.4%
범 2670
 
7.3%
천 1633
 
4.5%
호 1630
 
4.5%
사 1346
 
3.7%
성 1146
 
3.1%
일 1139
 
3.1%
내 1083
 
3.0%
암 1034
 
2.8%
Other values (342) 15450
42.4%

위도
Real number (ℝ)

Distinct398
Distinct (%)12.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.544679
Minimum37.5151
Maximum37.5772
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size28.2 KiB
2024-03-13T22:02:13.525597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.5151
5-th percentile37.5274
Q137.5364
median37.5451
Q337.5515
95-th percentile37.5618
Maximum37.5772
Range0.0621
Interquartile range (IQR)0.0151

Descriptive statistics

Standard deviation0.010679093
Coefficient of variation (CV)0.00028443691
Kurtosis-0.49153789
Mean37.544679
Median Absolute Deviation (MAD)0.0076
Skewness0.052825449
Sum119805.07
Variance0.00011404302
MonotonicityNot monotonic
2024-03-13T22:02:13.726273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.5513 30
 
0.9%
37.5469 28
 
0.9%
37.5491 28
 
0.9%
37.5477 26
 
0.8%
37.5556 24
 
0.8%
37.5505 24
 
0.8%
37.5413 24
 
0.8%
37.5504 23
 
0.7%
37.5464 22
 
0.7%
37.5466 22
 
0.7%
Other values (388) 2940
92.1%
ValueCountFrequency (%)
37.5151 1
 
< 0.1%
37.5163 1
 
< 0.1%
37.5173 5
0.2%
37.5194 4
0.1%
37.5218 3
0.1%
37.5224 3
0.1%
37.5227 3
0.1%
37.523 6
0.2%
37.5233 6
0.2%
37.5236 3
0.1%
ValueCountFrequency (%)
37.5772 4
0.1%
37.5765 3
0.1%
37.576 5
0.2%
37.5738 1
 
< 0.1%
37.5737 3
0.1%
37.5719 3
0.1%
37.5718 1
 
< 0.1%
37.5703 4
0.1%
37.5691 5
0.2%
37.5684 4
0.1%

경도
Real number (ℝ)

Distinct458
Distinct (%)14.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.14104
Minimum127.1191
Maximum127.1817
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size28.2 KiB
2024-03-13T22:02:13.901951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.1191
5-th percentile127.12355
Q1127.1311
median127.1374
Q3127.147
95-th percentile127.1712
Maximum127.1817
Range0.0626
Interquartile range (IQR)0.0159

Descriptive statistics

Standard deviation0.014040024
Coefficient of variation (CV)0.00011042874
Kurtosis0.25651487
Mean127.14104
Median Absolute Deviation (MAD)0.0074
Skewness0.97155848
Sum405707.04
Variance0.00019712227
MonotonicityNot monotonic
2024-03-13T22:02:14.075027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.1358 30
 
0.9%
127.1338 30
 
0.9%
127.1308 27
 
0.8%
127.1311 25
 
0.8%
127.1336 24
 
0.8%
127.1367 24
 
0.8%
127.1352 23
 
0.7%
127.1374 22
 
0.7%
127.1332 21
 
0.7%
127.1347 21
 
0.7%
Other values (448) 2944
92.3%
ValueCountFrequency (%)
127.1191 4
0.1%
127.12 3
 
0.1%
127.1202 3
 
0.1%
127.1203 1
 
< 0.1%
127.1204 3
 
0.1%
127.1206 4
0.1%
127.1207 3
 
0.1%
127.1208 7
0.2%
127.1209 8
0.3%
127.121 3
 
0.1%
ValueCountFrequency (%)
127.1817 5
0.2%
127.1803 3
 
0.1%
127.1798 4
0.1%
127.1797 5
0.2%
127.1792 4
0.1%
127.1787 5
0.2%
127.1785 4
0.1%
127.1783 5
0.2%
127.1781 4
0.1%
127.178 8
0.3%

CCTV 수량
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size25.1 KiB
1
3191 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row1
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 3191
100.0%

Length

2024-03-13T22:02:14.240292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:02:14.367054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 3191
100.0%

수정 일시
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size25.1 KiB
2022-12-01
3191 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-12-01
2nd row2022-12-01
3rd row2022-12-01
4th row2022-12-01
5th row2022-12-01

Common Values

ValueCountFrequency (%)
2022-12-01 3191
100.0%

Length

2024-03-13T22:02:14.487738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:02:14.622514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-12-01 3191
100.0%

Interactions

2024-03-13T22:02:11.622493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:02:11.382294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:02:11.777398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:02:11.511561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T22:02:14.690854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.692
경도0.6921.000
2024-03-13T22:02:14.796758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.429
경도0.4291.000

Missing values

2024-03-13T22:02:11.947289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T22:02:12.072789image/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강동구강일동 119-6 강빛초등학교 회전교차로(주정차단속-강일동-006)37.5737127.170912022-12-01
1강동구강일동 119-6 강빛초등학교 회전교차로(주정차단속-강일동-006-01)37.5737127.170912022-12-01
2강동구강일동 119-6 강빛초등학교 회전교차로(주정차단속-강일동-006-02)37.5737127.170912022-12-01
3강동구강일동 144-8 전신주 옆 (방범-강일동-009)37.5765127.167212022-12-01
4강동구강일동 144-8 전신주 옆(방범-강일동-009-01)37.5765127.167212022-12-01
5강동구강일동 144-8 전신주 옆(방범-강일동-009-02)37.5765127.167212022-12-01
6강동구강일동 145-2 마을버스종점 앞 (방범-강일동-005)37.5772127.168212022-12-01
7강동구강일동 145-2 마을버스종점 앞(방범-강일동-005-01)37.5772127.168212022-12-01
8강동구강일동 145-2 마을버스종점 앞(방범-강일동-005-02)37.5772127.168212022-12-01
9강동구강일동 145-2 마을버스종점 앞(방범-강일동-005-03)37.5772127.168212022-12-01
자치구안심 주소위도경도CCTV 수량수정 일시
3181강동구천호3동 550 옛날농장 앞(방범-천호3동-031)37.5405127.128812022-12-01
3182강동구천호3동 550 옛날농장 앞(방범-천호3동-031-01)37.5405127.128812022-12-01
3183강동구천호3동 550 옛날농장 앞(방범-천호3동-031-02)37.5405127.128812022-12-01
3184강동구천호3동 551-7 강동복지관어린이집(스쿨존-천호3동-003)37.5398127.129712022-12-01
3185강동구천호3동 560-2(방범-천호3동-014)37.5397127.130512022-12-01
3186강동구천호3동 560-2(방범-천호3동-014-01)37.5397127.130512022-12-01
3187강동구천호3동 560-2(방범-천호3동-014-02)37.5397127.130512022-12-01
3188강동구하남시 감일동 179 서하남IC 진입로(방범-둔촌1동-003)37.5151127.151312022-12-01
3189강동구하남시 감일동 180 서하남IC 진출로(방범-둔촌1동-004)37.5163127.150312022-12-01
3190강동구회의실37.5305127.122412022-12-01