Overview

Dataset statistics

Number of variables6
Number of observations4050
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory201.8 KiB
Average record size in memory51.0 B

Variable types

Categorical3
Text1
Numeric2

Dataset

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

Alerts

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

Reproduction

Analysis started2024-04-20 23:30:24.219375
Analysis finished2024-04-20 23:30:26.256683
Duration2.04 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

자치구
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size31.8 KiB
구로구
4050 

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

Length

2024-04-21T08:30:26.323161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T08:30:26.418105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
구로구 4050
100.0%

안심 주소
Text

UNIQUE 

Distinct4050
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size31.8 KiB
2024-04-21T08:30:26.695030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length53
Median length45
Mean length22.07679
Min length7

Characters and Unicode

Total characters89411
Distinct characters350
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

Unique4050 ?
Unique (%)100.0%

Sample

1st row1.고척근린공원 공연장 (고척2동 산9-14)
2nd row1.고척근린공원 공연장 고정1
3rd row1.고척근린공원 공연장 고정2
4th row10.신구로초교 1번
5th row10.신구로초교 2번
ValueCountFrequency (%)
507
 
3.5%
고정1 498
 
3.5%
고정2 442
 
3.1%
회전형 387
 
2.7%
회전 285
 
2.0%
고정형 198
 
1.4%
고정형-1 153
 
1.1%
1번 150
 
1.0%
고정형-2 150
 
1.0%
고정3 139
 
1.0%
Other values (3744) 11510
79.8%
2024-04-21T08:30:27.122880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
10406
 
11.6%
1 8658
 
9.7%
2 5397
 
6.0%
. 4053
 
4.5%
- 3648
 
4.1%
3 3579
 
4.0%
고 3016
 
3.4%
5 3000
 
3.4%
동 2992
 
3.3%
4 2860
 
3.2%
Other values (340) 41802
46.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 34901
39.0%
Other Letter 31701
35.5%
Space Separator 10406
 
11.6%
Other Punctuation 4053
 
4.5%
Dash Punctuation 3648
 
4.1%
Close Punctuation 2247
 
2.5%
Open Punctuation 2243
 
2.5%
Connector Punctuation 114
 
0.1%
Uppercase Letter 98
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
고 3016
 
9.5%
동 2992
 
9.4%
로 2691
 
8.5%
정 2419
 
7.6%
구 1565
 
4.9%
길 1173
 
3.7%
형 989
 
3.1%
봉 906
 
2.9%
전 867
 
2.7%
회 853
 
2.7%
Other values (309) 14230
44.9%
Uppercase Letter
ValueCountFrequency (%)
A 15
15.3%
P 12
12.2%
B 10
10.2%
C 9
9.2%
T 8
8.2%
L 7
 
7.1%
I 6
 
6.1%
S 4
 
4.1%
K 4
 
4.1%
W 4
 
4.1%
Other values (5) 19
19.4%
Decimal Number
ValueCountFrequency (%)
1 8658
24.8%
2 5397
15.5%
3 3579
10.3%
5 3000
 
8.6%
4 2860
 
8.2%
6 2571
 
7.4%
7 2457
 
7.0%
0 2200
 
6.3%
9 2114
 
6.1%
8 2065
 
5.9%
Space Separator
ValueCountFrequency (%)
10406
100.0%
Other Punctuation
ValueCountFrequency (%)
. 4053
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3648
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2247
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2243
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 114
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 57612
64.4%
Hangul 31701
35.5%
Latin 98
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
고 3016
 
9.5%
동 2992
 
9.4%
로 2691
 
8.5%
정 2419
 
7.6%
구 1565
 
4.9%
길 1173
 
3.7%
형 989
 
3.1%
봉 906
 
2.9%
전 867
 
2.7%
회 853
 
2.7%
Other values (309) 14230
44.9%
Common
ValueCountFrequency (%)
10406
18.1%
1 8658
15.0%
2 5397
9.4%
. 4053
 
7.0%
- 3648
 
6.3%
3 3579
 
6.2%
5 3000
 
5.2%
4 2860
 
5.0%
6 2571
 
4.5%
7 2457
 
4.3%
Other values (6) 10983
19.1%
Latin
ValueCountFrequency (%)
A 15
15.3%
P 12
12.2%
B 10
10.2%
C 9
9.2%
T 8
8.2%
L 7
 
7.1%
I 6
 
6.1%
S 4
 
4.1%
K 4
 
4.1%
W 4
 
4.1%
Other values (5) 19
19.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 57710
64.5%
Hangul 31701
35.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
10406
18.0%
1 8658
15.0%
2 5397
9.4%
. 4053
 
7.0%
- 3648
 
6.3%
3 3579
 
6.2%
5 3000
 
5.2%
4 2860
 
5.0%
6 2571
 
4.5%
7 2457
 
4.3%
Other values (21) 11081
19.2%
Hangul
ValueCountFrequency (%)
고 3016
 
9.5%
동 2992
 
9.4%
로 2691
 
8.5%
정 2419
 
7.6%
구 1565
 
4.9%
길 1173
 
3.7%
형 989
 
3.1%
봉 906
 
2.9%
전 867
 
2.7%
회 853
 
2.7%
Other values (309) 14230
44.9%

위도
Real number (ℝ)

Distinct335
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.494683
Minimum37.475
Maximum37.5152
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size35.7 KiB
2024-04-21T08:30:27.255939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.475
5-th percentile37.482
Q137.4883
median37.494
Q337.5014
95-th percentile37.5076
Maximum37.5152
Range0.0402
Interquartile range (IQR)0.0131

Descriptive statistics

Standard deviation0.0081112735
Coefficient of variation (CV)0.0002163313
Kurtosis-0.8387697
Mean37.494683
Median Absolute Deviation (MAD)0.00635
Skewness0.092197532
Sum151853.47
Variance6.5792758 × 10-5
MonotonicityNot monotonic
2024-04-21T08:30:27.396370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.4905 37
 
0.9%
37.4889 36
 
0.9%
37.502 34
 
0.8%
37.4926 33
 
0.8%
37.4967 32
 
0.8%
37.4856 32
 
0.8%
37.5035 31
 
0.8%
37.494 28
 
0.7%
37.4882 28
 
0.7%
37.4922 27
 
0.7%
Other values (325) 3732
92.1%
ValueCountFrequency (%)
37.475 3
0.1%
37.4756 3
0.1%
37.4759 2
 
< 0.1%
37.4762 3
0.1%
37.4765 2
 
< 0.1%
37.4775 2
 
< 0.1%
37.4787 4
0.1%
37.4789 3
0.1%
37.4791 4
0.1%
37.4792 5
0.1%
ValueCountFrequency (%)
37.5152 4
0.1%
37.515 1
 
< 0.1%
37.5148 3
0.1%
37.5137 6
0.1%
37.5136 1
 
< 0.1%
37.5133 2
 
< 0.1%
37.5132 1
 
< 0.1%
37.5131 4
0.1%
37.5128 3
0.1%
37.5126 2
 
< 0.1%

경도
Real number (ℝ)

Distinct593
Distinct (%)14.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.86495
Minimum126.8164
Maximum126.9024
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size35.7 KiB
2024-04-21T08:30:27.538775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.8164
5-th percentile126.8285
Q1126.84723
median126.8628
Q3126.8864
95-th percentile126.8931
Maximum126.9024
Range0.086
Interquartile range (IQR)0.039175

Descriptive statistics

Standard deviation0.022080822
Coefficient of variation (CV)0.00017404982
Kurtosis-1.2209097
Mean126.86495
Median Absolute Deviation (MAD)0.0203
Skewness-0.2020678
Sum513803.05
Variance0.0004875627
MonotonicityNot monotonic
2024-04-21T08:30:27.675047image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.8874 39
 
1.0%
126.8883 30
 
0.7%
126.8849 28
 
0.7%
126.8834 28
 
0.7%
126.8868 26
 
0.6%
126.8861 26
 
0.6%
126.8918 25
 
0.6%
126.8873 25
 
0.6%
126.8507 24
 
0.6%
126.8819 24
 
0.6%
Other values (583) 3775
93.2%
ValueCountFrequency (%)
126.8164 3
0.1%
126.8168 4
0.1%
126.8173 3
0.1%
126.8177 2
 
< 0.1%
126.818 7
0.2%
126.8182 3
0.1%
126.8183 5
0.1%
126.8185 2
 
< 0.1%
126.8186 3
0.1%
126.819 2
 
< 0.1%
ValueCountFrequency (%)
126.9024 4
0.1%
126.9019 4
0.1%
126.9018 1
 
< 0.1%
126.9017 4
0.1%
126.9016 3
0.1%
126.9014 2
< 0.1%
126.9013 1
 
< 0.1%
126.9011 3
0.1%
126.9006 3
0.1%
126.9005 2
< 0.1%

CCTV 수량
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size31.8 KiB
1
4050 

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

Length

2024-04-21T08:30:27.803184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T08:30:27.887063image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 4050
100.0%

수정 일시
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size31.8 KiB
2022-12-01
4050 

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

Length

2024-04-21T08:30:27.969898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T08:30:28.053150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-12-01 4050
100.0%

Interactions

2024-04-21T08:30:25.837593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T08:30:25.555163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T08:30:25.931085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T08:30:25.738293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-21T08:30:28.117304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.616
경도0.6161.000
2024-04-21T08:30:28.194221image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.000-0.178
경도-0.1781.000

Missing values

2024-04-21T08:30:26.051257image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T08:30:26.198427image/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구로구1.고척근린공원 공연장 (고척2동 산9-14)37.5058126.853612022-12-01
1구로구1.고척근린공원 공연장 고정137.5058126.853612022-12-01
2구로구1.고척근린공원 공연장 고정237.5058126.853612022-12-01
3구로구10.신구로초교 1번37.4996126.889912022-12-01
4구로구10.신구로초교 2번37.4996126.889912022-12-01
5구로구10.신구로초교 회전형37.4996126.889912022-12-01
6구로구100.개봉3동 403-171(고정1)37.4876126.856512022-12-01
7구로구100.개봉3동 403-171(고정2)37.4876126.856512022-12-01
8구로구100.개봉3동 403-171(회전)37.4876126.856512022-12-01
9구로구1000.온수동85-3 (부일로1다길 16-3) - 고정형 137.4959126.818512022-12-01
자치구안심 주소위도경도CCTV 수량수정 일시
4040구로구996.오류동 156-83 (오류로8다길 28) - 고정형 237.4899126.842912022-12-01
4041구로구996.오류로8다길 32 (고정1)37.4899126.842912022-12-01
4042구로구997.궁동 142-2 (오리로22나길 14) - 고정형 137.4999126.830312022-12-01
4043구로구997.궁동 142-2 (오리로22나길 14) - 고정형 237.4999126.830312022-12-01
4044구로구997.궁동 142-2 (오리로22나길 14) - 고정형 337.4999126.830312022-12-01
4045구로구997.궁동 142-2 (오리로22나길 14) - 고정형 437.4999126.830312022-12-01
4046구로구998.궁동 78-20 (오리로21가길 23-42) - 고정형 237.4995126.82612022-12-01
4047구로구998.궁동 78-20 (오리로21가길 23-42) - 고정형 137.4995126.82612022-12-01
4048구로구999.궁동 78-17 (오리로21가길 23-22) - 고정형 137.4995126.826512022-12-01
4049구로구999.궁동 78-17 (오리로21가길 23-22) - 고정형 237.4995126.826512022-12-01