Overview

Dataset statistics

Number of variables6
Number of observations4091
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory203.9 KiB
Average record size in memory51.0 B

Variable types

Categorical2
Text1
Numeric2
DateTime1

Dataset

Description자치구,안심 주소,위도,경도,CCTV 수량,수정 일시
Author광진구
URLhttps://data.seoul.go.kr/dataList/OA-20928/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 17:25:28.298945
Analysis finished2024-03-13 17:25:28.968485
Duration0.67 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

자치구
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size32.1 KiB
광진구
4091 

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 (%)
광진구 4091
100.0%

Length

2024-03-14T02:25:29.014250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T02:25:29.088420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광진구 4091
100.0%

안심 주소
Text

UNIQUE 

Distinct4091
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size32.1 KiB
2024-03-14T02:25:29.238937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length17
Mean length14.527988
Min length12

Characters and Unicode

Total characters59434
Distinct characters64
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

Unique4091 ?
Unique (%)100.0%

Sample

1st row공원-광장-045-01
2nd row공원-광장-045-02
3rd row공원-광장-045-03
4th row공원-광장-045-비상벨
5th row공원-광장-046-01
ValueCountFrequency (%)
체험용 3
 
0.1%
관제센터 3
 
0.1%
공원-광장-045-01 1
 
< 0.1%
생활방범-중곡4-301-03 1
 
< 0.1%
생활방범-중곡4-298-비상벨 1
 
< 0.1%
생활방범-중곡4-299-01 1
 
< 0.1%
생활방범-중곡4-299-02 1
 
< 0.1%
생활방범-중곡4-299-03 1
 
< 0.1%
생활방범-중곡4-299-04 1
 
< 0.1%
생활방범-중곡4-299-비상벨 1
 
< 0.1%
Other values (4084) 4084
99.7%
2024-03-14T02:25:29.509410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 12267
20.6%
0 5682
 
9.6%
1 3446
 
5.8%
2 3007
 
5.1%
3 2787
 
4.7%
범 2745
 
4.6%
방 2745
 
4.6%
활 2651
 
4.5%
생 2651
 
4.5%
4 2531
 
4.3%
Other values (54) 18922
31.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 25061
42.2%
Decimal Number 22087
37.2%
Dash Punctuation 12267
20.6%
Uppercase Letter 12
 
< 0.1%
Space Separator 7
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
범 2745
 
11.0%
방 2745
 
11.0%
활 2651
 
10.6%
생 2651
 
10.6%
자 1332
 
5.3%
양 1328
 
5.3%
중 1093
 
4.4%
곡 1093
 
4.4%
구 886
 
3.5%
의 886
 
3.5%
Other values (39) 7651
30.5%
Decimal Number
ValueCountFrequency (%)
0 5682
25.7%
1 3446
15.6%
2 3007
13.6%
3 2787
12.6%
4 2531
11.5%
5 1572
 
7.1%
6 786
 
3.6%
8 769
 
3.5%
7 767
 
3.5%
9 740
 
3.4%
Uppercase Letter
ValueCountFrequency (%)
C 6
50.0%
V 3
25.0%
T 3
25.0%
Dash Punctuation
ValueCountFrequency (%)
- 12267
100.0%
Space Separator
ValueCountFrequency (%)
7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 34361
57.8%
Hangul 25061
42.2%
Latin 12
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
범 2745
 
11.0%
방 2745
 
11.0%
활 2651
 
10.6%
생 2651
 
10.6%
자 1332
 
5.3%
양 1328
 
5.3%
중 1093
 
4.4%
곡 1093
 
4.4%
구 886
 
3.5%
의 886
 
3.5%
Other values (39) 7651
30.5%
Common
ValueCountFrequency (%)
- 12267
35.7%
0 5682
16.5%
1 3446
 
10.0%
2 3007
 
8.8%
3 2787
 
8.1%
4 2531
 
7.4%
5 1572
 
4.6%
6 786
 
2.3%
8 769
 
2.2%
7 767
 
2.2%
Other values (2) 747
 
2.2%
Latin
ValueCountFrequency (%)
C 6
50.0%
V 3
25.0%
T 3
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 34373
57.8%
Hangul 25061
42.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 12267
35.7%
0 5682
16.5%
1 3446
 
10.0%
2 3007
 
8.7%
3 2787
 
8.1%
4 2531
 
7.4%
5 1572
 
4.6%
6 786
 
2.3%
8 769
 
2.2%
7 767
 
2.2%
Other values (5) 759
 
2.2%
Hangul
ValueCountFrequency (%)
범 2745
 
11.0%
방 2745
 
11.0%
활 2651
 
10.6%
생 2651
 
10.6%
자 1332
 
5.3%
양 1328
 
5.3%
중 1093
 
4.4%
곡 1093
 
4.4%
구 886
 
3.5%
의 886
 
3.5%
Other values (39) 7651
30.5%

위도
Real number (ℝ)

Distinct394
Distinct (%)9.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.54803
Minimum37.5279
Maximum37.5717
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size36.1 KiB
2024-03-14T02:25:29.654779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.5279
5-th percentile37.5316
Q137.5383
median37.5471
Q337.5568
95-th percentile37.56785
Maximum37.5717
Range0.0438
Interquartile range (IQR)0.0185

Descriptive statistics

Standard deviation0.011382088
Coefficient of variation (CV)0.0003031341
Kurtosis-1.036206
Mean37.54803
Median Absolute Deviation (MAD)0.0093
Skewness0.22063139
Sum153608.99
Variance0.00012955193
MonotonicityNot monotonic
2024-03-14T02:25:29.996574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.5552 35
 
0.9%
37.5372 33
 
0.8%
37.5383 32
 
0.8%
37.5414 31
 
0.8%
37.5365 29
 
0.7%
37.5576 28
 
0.7%
37.5392 27
 
0.7%
37.5603 27
 
0.7%
37.5345 27
 
0.7%
37.5483 26
 
0.6%
Other values (384) 3796
92.8%
ValueCountFrequency (%)
37.5279 1
 
< 0.1%
37.5281 1
 
< 0.1%
37.5287 6
0.1%
37.5288 1
 
< 0.1%
37.5289 5
0.1%
37.529 6
0.1%
37.5291 1
 
< 0.1%
37.5292 1
 
< 0.1%
37.5293 5
0.1%
37.5294 6
0.1%
ValueCountFrequency (%)
37.5717 2
 
< 0.1%
37.5716 5
 
0.1%
37.5712 5
 
0.1%
37.5711 14
0.3%
37.571 1
 
< 0.1%
37.5709 8
0.2%
37.5707 2
 
< 0.1%
37.5706 6
0.1%
37.5705 9
0.2%
37.5704 6
0.1%

경도
Real number (ℝ)

Distinct390
Distinct (%)9.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.08288
Minimum127.0606
Maximum127.1107
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size36.1 KiB
2024-03-14T02:25:30.118571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.0606
5-th percentile127.0659
Q1127.0756
median127.0831
Q3127.0895
95-th percentile127.10075
Maximum127.1107
Range0.0501
Interquartile range (IQR)0.0139

Descriptive statistics

Standard deviation0.010110477
Coefficient of variation (CV)7.9558135 × 10-5
Kurtosis-0.43478874
Mean127.08288
Median Absolute Deviation (MAD)0.0069
Skewness0.084251593
Sum519896.06
Variance0.00010222174
MonotonicityNot monotonic
2024-03-14T02:25:30.229053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.0824 46
 
1.1%
127.087 39
 
1.0%
127.0851 38
 
0.9%
127.0839 36
 
0.9%
127.089 35
 
0.9%
127.0872 33
 
0.8%
127.085 32
 
0.8%
127.0695 31
 
0.8%
127.0806 31
 
0.8%
127.0873 30
 
0.7%
Other values (380) 3740
91.4%
ValueCountFrequency (%)
127.0606 1
 
< 0.1%
127.0611 2
 
< 0.1%
127.0613 6
0.1%
127.0616 6
0.1%
127.0618 4
0.1%
127.0622 5
0.1%
127.0624 1
 
< 0.1%
127.0626 2
 
< 0.1%
127.0627 5
0.1%
127.0628 3
0.1%
ValueCountFrequency (%)
127.1107 5
0.1%
127.1098 8
0.2%
127.1092 5
0.1%
127.109 3
 
0.1%
127.1081 5
0.1%
127.108 5
0.1%
127.1074 4
0.1%
127.1068 1
 
< 0.1%
127.1061 6
0.1%
127.1057 5
0.1%

CCTV 수량
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size32.1 KiB
1
4091 

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

Length

2024-03-14T02:25:30.334300image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T02:25:30.425159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 4091
100.0%

수정 일시
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size32.1 KiB
Minimum2022-12-01 00:00:00
Maximum2022-12-01 00:00:00
2024-03-14T02:25:30.499604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T02:25:30.565311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-03-14T02:25:28.681697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T02:25:28.481150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T02:25:28.756186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T02:25:28.565163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T02:25:30.619810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.652
경도0.6521.000
2024-03-14T02:25:30.689031image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.191
경도0.1911.000

Missing values

2024-03-14T02:25:28.849500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T02:25:28.935294image/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광진구공원-광장-045-0137.546127.103912022-12-01
1광진구공원-광장-045-0237.546127.103912022-12-01
2광진구공원-광장-045-0337.546127.103912022-12-01
3광진구공원-광장-045-비상벨37.546127.103912022-12-01
4광진구공원-광장-046-0137.5482127.100612022-12-01
5광진구공원-광장-046-0237.5482127.100612022-12-01
6광진구공원-광장-046-0337.5482127.100612022-12-01
7광진구공원-광장-046-비상벨37.5482127.100612022-12-01
8광진구공원-광장-047-0137.5463127.098712022-12-01
9광진구공원-광장-047-비상벨37.5463127.098712022-12-01
자치구안심 주소위도경도CCTV 수량수정 일시
4081광진구주차-중곡4-056-0237.5583127.091612022-12-01
4082광진구주차-화양-032-0137.5412127.067812022-12-01
4083광진구주차-화양-033-0137.541127.071312022-12-01
4084광진구주차-화양-034-0137.5421127.071412022-12-01
4085광진구주차-화양-034-0237.5421127.071412022-12-01
4086광진구주차-화양-034-0337.5421127.071412022-12-01
4087광진구주차-화양-035-0137.5409127.070912022-12-01
4088광진구주차-화양-035-0237.5409127.070912022-12-01
4089광진구주차-화양-035-0337.5409127.070912022-12-01
4090광진구철거0919-무단투기-자양4-033-0137.5396127.069512022-12-01