Overview

Dataset statistics

Number of variables6
Number of observations2725
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory135.8 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-20941/S/1/datasetView.do

Alerts

자치구 has constant value ""Constant
CCTV 수량 has constant value ""Constant
수정 일시 has constant value ""Constant

Reproduction

Analysis started2024-04-21 01:32:31.063074
Analysis finished2024-04-21 01:32:32.376228
Duration1.31 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

자치구
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size21.4 KiB
금천구
2725 

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 (%)
금천구 2725
100.0%

Length

2024-04-21T10:32:32.483777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:32:32.639322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
금천구 2725
100.0%

안심 주소
Text

Distinct2723
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Memory size21.4 KiB
2024-04-21T10:32:33.526851image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length57
Median length50
Mean length32.622752
Min length2

Characters and Unicode

Total characters88897
Distinct characters329
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

Unique2721 ?
Unique (%)99.9%

Sample

1st rowA101 금천체육공원 / 독산로54길 102-27 / [독산4동 산118-4]
2nd rowA102 산기슭공원화장실 / 독산로54길 6 / [시흥4동 산 138-3]
3rd rowA103 무아래 어린이공원 / [가산동234-29]
4th rowA103-1 무아래 어린이공원 / [가산동234-29]
5th rowA103-2 무아래 어린이공원 / [가산동234-29]
ValueCountFrequency (%)
3116
 
18.0%
독산1동 366
 
2.1%
시흥1동 356
 
2.1%
독산3동 307
 
1.8%
독산2동 296
 
1.7%
시흥5동 287
 
1.7%
독산4동 255
 
1.5%
가산동 250
 
1.4%
시흥4동 231
 
1.3%
시흥3동 172
 
1.0%
Other values (4386) 11635
67.4%
2024-04-21T10:32:34.758964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
14602
 
16.4%
1 7587
 
8.5%
- 4674
 
5.3%
2 4444
 
5.0%
3 4271
 
4.8%
4 3663
 
4.1%
/ 3118
 
3.5%
5 2724
 
3.1%
산 2714
 
3.1%
동 2706
 
3.0%
Other values (319) 38394
43.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 34015
38.3%
Other Letter 24066
27.1%
Space Separator 14602
16.4%
Dash Punctuation 4674
 
5.3%
Other Punctuation 3118
 
3.5%
Uppercase Letter 3100
 
3.5%
Close Punctuation 2659
 
3.0%
Open Punctuation 2659
 
3.0%
Lowercase Letter 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
산 2714
11.3%
동 2706
11.2%
로 2366
 
9.8%
독 2102
 
8.7%
길 2018
 
8.4%
시 1906
 
7.9%
흥 1889
 
7.8%
대 711
 
3.0%
가 551
 
2.3%
원 345
 
1.4%
Other values (281) 6758
28.1%
Uppercase Letter
ValueCountFrequency (%)
P 1803
58.2%
A 250
 
8.1%
C 213
 
6.9%
N 185
 
6.0%
I 164
 
5.3%
S 113
 
3.6%
G 108
 
3.5%
W 76
 
2.5%
F 76
 
2.5%
T 65
 
2.1%
Other values (8) 47
 
1.5%
Decimal Number
ValueCountFrequency (%)
1 7587
22.3%
2 4444
13.1%
3 4271
12.6%
4 3663
10.8%
5 2724
 
8.0%
0 2614
 
7.7%
8 2405
 
7.1%
9 2267
 
6.7%
7 2040
 
6.0%
6 2000
 
5.9%
Lowercase Letter
ValueCountFrequency (%)
t 2
50.0%
e 1
25.0%
s 1
25.0%
Close Punctuation
ValueCountFrequency (%)
] 2614
98.3%
) 45
 
1.7%
Open Punctuation
ValueCountFrequency (%)
[ 2614
98.3%
( 45
 
1.7%
Space Separator
ValueCountFrequency (%)
14602
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4674
100.0%
Other Punctuation
ValueCountFrequency (%)
/ 3118
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 61727
69.4%
Hangul 24066
 
27.1%
Latin 3104
 
3.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
산 2714
11.3%
동 2706
11.2%
로 2366
 
9.8%
독 2102
 
8.7%
길 2018
 
8.4%
시 1906
 
7.9%
흥 1889
 
7.8%
대 711
 
3.0%
가 551
 
2.3%
원 345
 
1.4%
Other values (281) 6758
28.1%
Latin
ValueCountFrequency (%)
P 1803
58.1%
A 250
 
8.1%
C 213
 
6.9%
N 185
 
6.0%
I 164
 
5.3%
S 113
 
3.6%
G 108
 
3.5%
W 76
 
2.4%
F 76
 
2.4%
T 65
 
2.1%
Other values (11) 51
 
1.6%
Common
ValueCountFrequency (%)
14602
23.7%
1 7587
12.3%
- 4674
 
7.6%
2 4444
 
7.2%
3 4271
 
6.9%
4 3663
 
5.9%
/ 3118
 
5.1%
5 2724
 
4.4%
] 2614
 
4.2%
0 2614
 
4.2%
Other values (7) 11416
18.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 64831
72.9%
Hangul 24066
 
27.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
14602
22.5%
1 7587
11.7%
- 4674
 
7.2%
2 4444
 
6.9%
3 4271
 
6.6%
4 3663
 
5.7%
/ 3118
 
4.8%
5 2724
 
4.2%
] 2614
 
4.0%
0 2614
 
4.0%
Other values (28) 14520
22.4%
Hangul
ValueCountFrequency (%)
산 2714
11.3%
동 2706
11.2%
로 2366
 
9.8%
독 2102
 
8.7%
길 2018
 
8.4%
시 1906
 
7.9%
흥 1889
 
7.8%
대 711
 
3.0%
가 551
 
2.3%
원 345
 
1.4%
Other values (281) 6758
28.1%

위도
Real number (ℝ)

Distinct429
Distinct (%)15.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.462116
Minimum37.4338
Maximum37.4851
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size24.1 KiB
2024-04-21T10:32:35.001986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.4338
5-th percentile37.4432
Q137.453
median37.4625
Q337.4712
95-th percentile37.4789
Maximum37.4851
Range0.0513
Interquartile range (IQR)0.0182

Descriptive statistics

Standard deviation0.011300444
Coefficient of variation (CV)0.00030164992
Kurtosis-0.68973223
Mean37.462116
Median Absolute Deviation (MAD)0.0093
Skewness-0.12128345
Sum102084.27
Variance0.00012770004
MonotonicityNot monotonic
2024-04-21T10:32:35.257255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.4678 29
 
1.1%
37.478 24
 
0.9%
37.4501 22
 
0.8%
37.4645 20
 
0.7%
37.4608 18
 
0.7%
37.4513 18
 
0.7%
37.4735 17
 
0.6%
37.4523 17
 
0.6%
37.4641 17
 
0.6%
37.4723 16
 
0.6%
Other values (419) 2527
92.7%
ValueCountFrequency (%)
37.4338 1
 
< 0.1%
37.4339 4
0.1%
37.434 4
0.1%
37.4341 2
 
0.1%
37.4342 2
 
0.1%
37.4343 4
0.1%
37.4344 2
 
0.1%
37.4346 1
 
< 0.1%
37.4347 4
0.1%
37.4348 8
0.3%
ValueCountFrequency (%)
37.4851 2
 
0.1%
37.485 2
 
0.1%
37.4849 1
 
< 0.1%
37.4848 6
0.2%
37.4847 3
0.1%
37.4846 3
0.1%
37.4845 2
 
0.1%
37.4841 2
 
0.1%
37.484 2
 
0.1%
37.4839 2
 
0.1%

경도
Real number (ℝ)

Distinct359
Distinct (%)13.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.90166
Minimum126.8754
Maximum126.9255
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size24.1 KiB
2024-04-21T10:32:35.506768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.8754
5-th percentile126.8848
Q1126.8976
median126.9036
Q3126.9065
95-th percentile126.9122
Maximum126.9255
Range0.0501
Interquartile range (IQR)0.0089

Descriptive statistics

Standard deviation0.0079292333
Coefficient of variation (CV)6.248329 × 10-5
Kurtosis0.69676262
Mean126.90166
Median Absolute Deviation (MAD)0.0038
Skewness-0.78285068
Sum345807.02
Variance6.2872741 × 10-5
MonotonicityNot monotonic
2024-04-21T10:32:35.757098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.9059 44
 
1.6%
126.9058 35
 
1.3%
126.906 34
 
1.2%
126.9043 32
 
1.2%
126.9069 29
 
1.1%
126.904 29
 
1.1%
126.9044 28
 
1.0%
126.9039 28
 
1.0%
126.9042 27
 
1.0%
126.9064 27
 
1.0%
Other values (349) 2412
88.5%
ValueCountFrequency (%)
126.8754 1
 
< 0.1%
126.8755 1
 
< 0.1%
126.8756 2
0.1%
126.8757 1
 
< 0.1%
126.8768 1
 
< 0.1%
126.8772 2
0.1%
126.8773 2
0.1%
126.8774 1
 
< 0.1%
126.8775 2
0.1%
126.8776 3
0.1%
ValueCountFrequency (%)
126.9255 3
0.1%
126.9208 2
0.1%
126.9207 1
 
< 0.1%
126.9206 2
0.1%
126.9205 2
0.1%
126.9204 2
0.1%
126.9203 2
0.1%
126.9202 1
 
< 0.1%
126.92 3
0.1%
126.9199 1
 
< 0.1%

CCTV 수량
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size21.4 KiB
1
2725 

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

Length

2024-04-21T10:32:35.977135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:32:36.138755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 2725
100.0%

수정 일시
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size21.4 KiB
Minimum2022-12-01 00:00:00
Maximum2022-12-01 00:00:00
2024-04-21T10:32:36.270154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:32:36.424576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-04-21T10:32:31.770505image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:32:31.473626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:32:31.924190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:32:31.620023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-21T10:32:36.542717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.762
경도0.7621.000
2024-04-21T10:32:36.676245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.000-0.456
경도-0.4561.000

Missing values

2024-04-21T10:32:32.121392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T10:32:32.302621image/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금천구A101 금천체육공원 / 독산로54길 102-27 / [독산4동 산118-4]37.4677126.909412022-12-01
1금천구A102 산기슭공원화장실 / 독산로54길 6 / [시흥4동 산 138-3]37.4636126.907112022-12-01
2금천구A103 무아래 어린이공원 / [가산동234-29]37.4735126.893312022-12-01
3금천구A103-1 무아래 어린이공원 / [가산동234-29]37.4735126.893312022-12-01
4금천구A103-2 무아래 어린이공원 / [가산동234-29]37.4735126.893412022-12-01
5금천구A103-3 무아래 어린이공원 / [가산동234-29]37.4735126.893312022-12-01
6금천구A104 조마 어린이공원 / [가산동 148-11]37.4757126.895812022-12-01
7금천구A104-1 조마 어린이공원 / [가산동 148-11]37.4757126.895812022-12-01
8금천구A104-2 조마 어린이공원 / [가산동 148-11]37.4756126.895812022-12-01
9금천구A104-3 조마 어린이공원 / [가산동 148-11]37.4757126.895812022-12-01
자치구안심 주소위도경도CCTV 수량수정 일시
2715금천구강0037.4497126.908312022-12-01
2716금천구김0037.4739126.887412022-12-01
2717금천구김OO37.4588126.899512022-12-01
2718금천구박0037.4578126.906412022-12-01
2719금천구송0037.4608126.909812022-12-01
2720금천구이0037.4528126.902812022-12-01
2721금천구장0037.4736126.899612022-12-01
2722금천구정0037.453126.918312022-12-01
2723금천구채0037.4533126.89912022-12-01
2724금천구허037.4732126.892912022-12-01