Overview

Dataset statistics

Number of variables6
Number of observations1598
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory79.7 KiB
Average record size in memory51.1 B

Variable types

Categorical3
Text1
Numeric2

Dataset

Description자치구,안심 주소,위도,경도,CCTV 수량,수정 일시
Author도봉구
URLhttps://data.seoul.go.kr/dataList/OA-20933/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 14:10:48.098115
Analysis finished2024-03-13 14:10:48.842025
Duration0.74 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

자치구
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size12.6 KiB
도봉구
1598 

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 (%)
도봉구 1598
100.0%

Length

2024-03-13T23:10:48.898679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T23:10:48.999195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
도봉구 1598
100.0%

안심 주소
Text

UNIQUE 

Distinct1598
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size12.6 KiB
2024-03-13T23:10:49.221990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length8.3579474
Min length4

Characters and Unicode

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

Unique

Unique1598 ?
Unique (%)100.0%

Sample

1st rowC2004
2nd rowC2008-검1
3rd rowC3019
4th rowC3019-고정1
5th rowC3019-고정2
ValueCountFrequency (%)
설치예정 9
 
0.6%
c2004 1
 
0.1%
쌍문3c3044 1
 
0.1%
쌍문3c3078 1
 
0.1%
쌍문3c3073 1
 
0.1%
쌍문3c3064 1
 
0.1%
쌍문3c3063 1
 
0.1%
쌍문3c3062 1
 
0.1%
쌍문3c3061 1
 
0.1%
쌍문3c3060-고정1 1
 
0.1%
Other values (1589) 1589
98.9%
2024-03-13T23:10:49.622835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 2184
16.4%
2 1306
 
9.8%
0 1138
 
8.5%
C 987
 
7.4%
3 974
 
7.3%
4 701
 
5.2%
- 646
 
4.8%
정 633
 
4.7%
고 624
 
4.7%
창 386
 
2.9%
Other values (29) 3777
28.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 7643
57.2%
Other Letter 3503
26.2%
Uppercase Letter 1541
 
11.5%
Dash Punctuation 646
 
4.8%
Space Separator 23
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
정 633
18.1%
고 624
17.8%
창 386
11.0%
문 339
9.7%
쌍 339
9.7%
방 259
7.4%
학 259
7.4%
봉 248
 
7.1%
도 248
 
7.1%
재 59
 
1.7%
Other values (11) 109
 
3.1%
Decimal Number
ValueCountFrequency (%)
1 2184
28.6%
2 1306
17.1%
0 1138
14.9%
3 974
12.7%
4 701
 
9.2%
5 348
 
4.6%
6 281
 
3.7%
7 262
 
3.4%
8 233
 
3.0%
9 216
 
2.8%
Uppercase Letter
ValueCountFrequency (%)
C 987
64.0%
P 281
 
18.2%
I 137
 
8.9%
S 123
 
8.0%
G 9
 
0.6%
H 4
 
0.3%
Dash Punctuation
ValueCountFrequency (%)
- 646
100.0%
Space Separator
ValueCountFrequency (%)
23
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 8312
62.2%
Hangul 3503
26.2%
Latin 1541
 
11.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
정 633
18.1%
고 624
17.8%
창 386
11.0%
문 339
9.7%
쌍 339
9.7%
방 259
7.4%
학 259
7.4%
봉 248
 
7.1%
도 248
 
7.1%
재 59
 
1.7%
Other values (11) 109
 
3.1%
Common
ValueCountFrequency (%)
1 2184
26.3%
2 1306
15.7%
0 1138
13.7%
3 974
11.7%
4 701
 
8.4%
- 646
 
7.8%
5 348
 
4.2%
6 281
 
3.4%
7 262
 
3.2%
8 233
 
2.8%
Other values (2) 239
 
2.9%
Latin
ValueCountFrequency (%)
C 987
64.0%
P 281
 
18.2%
I 137
 
8.9%
S 123
 
8.0%
G 9
 
0.6%
H 4
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 9853
73.8%
Hangul 3503
 
26.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 2184
22.2%
2 1306
13.3%
0 1138
11.5%
C 987
10.0%
3 974
9.9%
4 701
 
7.1%
- 646
 
6.6%
5 348
 
3.5%
6 281
 
2.9%
P 281
 
2.9%
Other values (8) 1007
10.2%
Hangul
ValueCountFrequency (%)
정 633
18.1%
고 624
17.8%
창 386
11.0%
문 339
9.7%
쌍 339
9.7%
방 259
7.4%
학 259
7.4%
봉 248
 
7.1%
도 248
 
7.1%
재 59
 
1.7%
Other values (11) 109
 
3.1%

위도
Real number (ℝ)

Distinct443
Distinct (%)27.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.658896
Minimum37.632
Maximum37.6939
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size14.2 KiB
2024-03-13T23:10:49.766193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.632
5-th percentile37.6375
Q137.6482
median37.6555
Q337.6685
95-th percentile37.6879
Maximum37.6939
Range0.0619
Interquartile range (IQR)0.0203

Descriptive statistics

Standard deviation0.014700517
Coefficient of variation (CV)0.00039035973
Kurtosis-0.50632699
Mean37.658896
Median Absolute Deviation (MAD)0.0091
Skewness0.50463479
Sum60178.915
Variance0.00021610519
MonotonicityNot monotonic
2024-03-13T23:10:49.906718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.6469 17
 
1.1%
37.6384 13
 
0.8%
37.6529 13
 
0.8%
37.6637 13
 
0.8%
37.6555 13
 
0.8%
37.6602 12
 
0.8%
37.6474 12
 
0.8%
37.652 12
 
0.8%
37.6487 12
 
0.8%
37.6481 12
 
0.8%
Other values (433) 1469
91.9%
ValueCountFrequency (%)
37.632 2
0.1%
37.6322 4
0.3%
37.6329 3
0.2%
37.6332 3
0.2%
37.6333 4
0.3%
37.6335 1
 
0.1%
37.6337 3
0.2%
37.6339 3
0.2%
37.634 2
0.1%
37.6341 1
 
0.1%
ValueCountFrequency (%)
37.6939 1
 
0.1%
37.6936 1
 
0.1%
37.6929 1
 
0.1%
37.6925 1
 
0.1%
37.6924 3
0.2%
37.6923 6
0.4%
37.6922 4
0.3%
37.6921 1
 
0.1%
37.6919 2
 
0.1%
37.6917 1
 
0.1%

경도
Real number (ℝ)

Distinct316
Distinct (%)19.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.03739
Minimum127.0128
Maximum127.053
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size14.2 KiB
2024-03-13T23:10:50.036967image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.0128
5-th percentile127.0171
Q1127.03293
median127.0392
Q3127.04358
95-th percentile127.0497
Maximum127.053
Range0.0402
Interquartile range (IQR)0.01065

Descriptive statistics

Standard deviation0.0089525842
Coefficient of variation (CV)7.047204 × 10-5
Kurtosis0.26773814
Mean127.03739
Median Absolute Deviation (MAD)0.0053
Skewness-0.83184727
Sum203005.75
Variance8.0148764 × 10-5
MonotonicityNot monotonic
2024-03-13T23:10:50.175972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.0393 25
 
1.6%
127.041 24
 
1.5%
127.0431 20
 
1.3%
127.042 20
 
1.3%
127.0411 18
 
1.1%
127.0363 16
 
1.0%
127.0436 15
 
0.9%
127.0453 15
 
0.9%
127.0465 15
 
0.9%
127.0357 15
 
0.9%
Other values (306) 1415
88.5%
ValueCountFrequency (%)
127.0128 1
 
0.1%
127.0133 2
0.1%
127.0135 3
0.2%
127.0136 2
0.1%
127.0137 1
 
0.1%
127.0138 3
0.2%
127.0139 3
0.2%
127.0142 4
0.3%
127.0143 4
0.3%
127.0144 2
0.1%
ValueCountFrequency (%)
127.053 5
 
0.3%
127.0527 7
0.4%
127.0524 1
 
0.1%
127.0523 1
 
0.1%
127.0521 3
 
0.2%
127.0518 1
 
0.1%
127.0516 3
 
0.2%
127.0512 13
0.8%
127.051 6
0.4%
127.0508 1
 
0.1%

CCTV 수량
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size12.6 KiB
1
1598 

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 1598
100.0%

Length

2024-03-13T23:10:50.302544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T23:10:50.393435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 1598
100.0%

수정 일시
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size12.6 KiB
2022-12-01
1598 

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 1598
100.0%

Length

2024-03-13T23:10:50.518504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T23:10:50.625442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-12-01 1598
100.0%

Interactions

2024-03-13T23:10:48.451880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T23:10:48.237504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T23:10:48.558709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T23:10:48.332139image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T23:10:50.679178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.645
경도0.6451.000
2024-03-13T23:10:50.776958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.245
경도0.2451.000

Missing values

2024-03-13T23:10:48.684763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T23:10:48.795744image/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도봉구C200437.6696127.044312022-12-01
1도봉구C2008-검137.6673127.033512022-12-01
2도봉구C301937.6492127.035312022-12-01
3도봉구C3019-고정137.6492127.035312022-12-01
4도봉구C3019-고정237.6492127.035312022-12-01
5도봉구C302037.6478127.034512022-12-01
6도봉구C3020-고정137.6478127.034512022-12-01
7도봉구C3020-고정237.6478127.034512022-12-01
8도봉구G00137.649127.032212022-12-01
9도봉구G00237.6487127.029712022-12-01
자치구안심 주소위도경도CCTV 수량수정 일시
1588도봉구창5I42937.6555127.04212022-12-01
1589도봉구창5I43037.653127.043112022-12-01
1590도봉구창5I43137.6569127.045812022-12-01
1591도봉구창5P19237.6558127.042212022-12-01
1592도봉구창5P192고정137.6558127.042212022-12-01
1593도봉구창5S42737.6595127.04512022-12-01
1594도봉구창5S42837.6545127.04612022-12-01
1595도봉구창5S42937.6555127.04212022-12-01
1596도봉구창5S43037.653127.043112022-12-01
1597도봉구창5S43137.6569127.045912022-12-01