Overview

Dataset statistics

Number of variables6
Number of observations1078
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory53.8 KiB
Average record size in memory51.1 B

Variable types

Categorical2
Text1
Numeric2
DateTime1

Dataset

Description자치구,안심 주소,위도,경도,CCTV 수량,수정 일시
Author용산구
URLhttps://data.seoul.go.kr/dataList/OA-20926/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-17 09:10:14.956085
Analysis finished2024-04-17 09:10:15.948038
Duration0.99 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

자치구
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size8.6 KiB
용산구
1078 

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 (%)
용산구 1078
100.0%

Length

2024-04-17T18:10:16.000892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T18:10:16.075214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
용산구 1078
100.0%

안심 주소
Text

UNIQUE 

Distinct1078
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.6 KiB
2024-04-17T18:10:16.229082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length54
Median length45
Mean length33.553803
Min length17

Characters and Unicode

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

Unique

Unique1078 ?
Unique (%)100.0%

Sample

1st row064.자치07-52(00) (효창동 3-263, 용산장애인복지관 옆)
2nd row065.교지07-53(00) (효창동 3-349, 청파초 정문 맞은편)
3rd row공원01-13(00) (후암로13가길 25, 새나라공원)
4th row공원01-14(00) (후암로13가길 25, 새나라공원)
5th row공원02-17(00) 19-1차(용산동2가 1-1923, 후암동 외국인학교 옆 공원)
ValueCountFrequency (%)
앞 302
 
5.9%
옆 118
 
2.3%
한남동 62
 
1.2%
이촌동 56
 
1.1%
이태원동 51
 
1.0%
보광동 42
 
0.8%
용산동2가 42
 
0.8%
후암동 39
 
0.8%
뒤 34
 
0.7%
용문동 33
 
0.6%
Other values (3092) 4330
84.8%
2024-04-17T18:10:16.540242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4042
 
11.2%
0 3061
 
8.5%
1 2455
 
6.8%
- 2264
 
6.3%
( 2228
 
6.2%
) 2225
 
6.2%
2 1788
 
4.9%
3 1037
 
2.9%
동 896
 
2.5%
4 896
 
2.5%
Other values (458) 15279
42.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 12385
34.2%
Decimal Number 12023
33.2%
Space Separator 4042
 
11.2%
Dash Punctuation 2264
 
6.3%
Open Punctuation 2228
 
6.2%
Close Punctuation 2225
 
6.2%
Other Punctuation 663
 
1.8%
Uppercase Letter 330
 
0.9%
Lowercase Letter 9
 
< 0.1%
Math Symbol 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 896
 
7.2%
자 817
 
6.6%
치 794
 
6.4%
원 466
 
3.8%
차 397
 
3.2%
로 351
 
2.8%
이 347
 
2.8%
가 321
 
2.6%
앞 307
 
2.5%
교 298
 
2.4%
Other values (418) 7391
59.7%
Uppercase Letter
ValueCountFrequency (%)
A 207
62.7%
B 45
 
13.6%
C 27
 
8.2%
G 9
 
2.7%
K 7
 
2.1%
U 6
 
1.8%
T 5
 
1.5%
S 5
 
1.5%
P 4
 
1.2%
I 4
 
1.2%
Other values (6) 11
 
3.3%
Decimal Number
ValueCountFrequency (%)
0 3061
25.5%
1 2455
20.4%
2 1788
14.9%
3 1037
 
8.6%
4 896
 
7.5%
5 719
 
6.0%
6 640
 
5.3%
7 495
 
4.1%
9 470
 
3.9%
8 462
 
3.8%
Lowercase Letter
ValueCountFrequency (%)
s 2
22.2%
e 2
22.2%
u 1
11.1%
p 1
11.1%
o 1
11.1%
h 1
11.1%
i 1
11.1%
Other Punctuation
ValueCountFrequency (%)
, 659
99.4%
. 4
 
0.6%
Space Separator
ValueCountFrequency (%)
4042
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2264
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2228
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2225
100.0%
Math Symbol
ValueCountFrequency (%)
+ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 23447
64.8%
Hangul 12385
34.2%
Latin 339
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 896
 
7.2%
자 817
 
6.6%
치 794
 
6.4%
원 466
 
3.8%
차 397
 
3.2%
로 351
 
2.8%
이 347
 
2.8%
가 321
 
2.6%
앞 307
 
2.5%
교 298
 
2.4%
Other values (418) 7391
59.7%
Latin
ValueCountFrequency (%)
A 207
61.1%
B 45
 
13.3%
C 27
 
8.0%
G 9
 
2.7%
K 7
 
2.1%
U 6
 
1.8%
T 5
 
1.5%
S 5
 
1.5%
P 4
 
1.2%
I 4
 
1.2%
Other values (13) 20
 
5.9%
Common
ValueCountFrequency (%)
4042
17.2%
0 3061
13.1%
1 2455
10.5%
- 2264
9.7%
( 2228
9.5%
) 2225
9.5%
2 1788
7.6%
3 1037
 
4.4%
4 896
 
3.8%
5 719
 
3.1%
Other values (7) 2732
11.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 23786
65.8%
Hangul 12385
34.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4042
17.0%
0 3061
12.9%
1 2455
10.3%
- 2264
9.5%
( 2228
9.4%
) 2225
9.4%
2 1788
7.5%
3 1037
 
4.4%
4 896
 
3.8%
5 719
 
3.0%
Other values (30) 3071
12.9%
Hangul
ValueCountFrequency (%)
동 896
 
7.2%
자 817
 
6.6%
치 794
 
6.4%
원 466
 
3.8%
차 397
 
3.2%
로 351
 
2.8%
이 347
 
2.8%
가 321
 
2.6%
앞 307
 
2.5%
교 298
 
2.4%
Other values (418) 7391
59.7%

위도
Real number (ℝ)

Distinct342
Distinct (%)31.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.536847
Minimum37.5169
Maximum37.5546
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size9.6 KiB
2024-04-17T18:10:16.659513image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.5169
5-th percentile37.5209
Q137.5303
median37.53695
Q337.5444
95-th percentile37.5513
Maximum37.5546
Range0.0377
Interquartile range (IQR)0.0141

Descriptive statistics

Standard deviation0.0092546248
Coefficient of variation (CV)0.00024654774
Kurtosis-0.85043105
Mean37.536847
Median Absolute Deviation (MAD)0.00705
Skewness-0.18102123
Sum40464.721
Variance8.564808 × 10-5
MonotonicityNot monotonic
2024-04-17T18:10:16.775065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.5351 10
 
0.9%
37.5336 10
 
0.9%
37.5417 10
 
0.9%
37.5383 9
 
0.8%
37.5464 8
 
0.7%
37.5372 8
 
0.7%
37.5349 8
 
0.7%
37.5409 8
 
0.7%
37.5303 8
 
0.7%
37.5326 8
 
0.7%
Other values (332) 991
91.9%
ValueCountFrequency (%)
37.5169 1
 
0.1%
37.5173 1
 
0.1%
37.5174 4
0.4%
37.5176 2
0.2%
37.5177 2
0.2%
37.5178 3
0.3%
37.5179 4
0.4%
37.518 1
 
0.1%
37.5182 1
 
0.1%
37.5184 1
 
0.1%
ValueCountFrequency (%)
37.5546 2
0.2%
37.5543 2
0.2%
37.5539 1
 
0.1%
37.5538 1
 
0.1%
37.5537 1
 
0.1%
37.5536 3
0.3%
37.5534 1
 
0.1%
37.5532 2
0.2%
37.5529 1
 
0.1%
37.5527 2
0.2%

경도
Real number (ℝ)

Distinct482
Distinct (%)44.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.97917
Minimum126.946
Maximum127.0125
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size9.6 KiB
2024-04-17T18:10:16.902725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.946
5-th percentile126.9555
Q1126.96543
median126.97695
Q3126.99398
95-th percentile127.0041
Maximum127.0125
Range0.0665
Interquartile range (IQR)0.02855

Descriptive statistics

Standard deviation0.016110333
Coefficient of variation (CV)0.00012687382
Kurtosis-1.2365131
Mean126.97917
Median Absolute Deviation (MAD)0.01365
Skewness0.12177847
Sum136883.55
Variance0.00025954283
MonotonicityNot monotonic
2024-04-17T18:10:17.021995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.9635 9
 
0.8%
126.997 8
 
0.7%
126.9686 8
 
0.7%
126.9814 7
 
0.6%
126.9751 7
 
0.6%
126.9677 7
 
0.6%
126.9906 7
 
0.6%
126.9664 6
 
0.6%
126.9642 6
 
0.6%
126.9698 6
 
0.6%
Other values (472) 1007
93.4%
ValueCountFrequency (%)
126.946 1
0.1%
126.9461 1
0.1%
126.9485 1
0.1%
126.9486 1
0.1%
126.9494 1
0.1%
126.951 1
0.1%
126.9514 2
0.2%
126.9515 1
0.1%
126.9518 1
0.1%
126.9519 1
0.1%
ValueCountFrequency (%)
127.0125 1
0.1%
127.0124 1
0.1%
127.0123 1
0.1%
127.0111 2
0.2%
127.0107 1
0.1%
127.0103 1
0.1%
127.0102 1
0.1%
127.01 1
0.1%
127.0093 1
0.1%
127.0089 1
0.1%

CCTV 수량
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size8.6 KiB
1
1078 

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

Length

2024-04-17T18:10:17.140032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T18:10:17.217864image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 1078
100.0%

수정 일시
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size8.6 KiB
Minimum2022-12-01 00:00:00
Maximum2022-12-01 00:00:00
2024-04-17T18:10:17.280477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T18:10:17.350554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-04-17T18:10:15.379981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T18:10:15.216423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T18:10:15.708176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T18:10:15.298568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-17T18:10:17.408817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.725
경도0.7251.000
2024-04-17T18:10:17.483238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.000-0.191
경도-0.1911.000

Missing values

2024-04-17T18:10:15.829598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-17T18:10:15.913451image/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용산구064.자치07-52(00) (효창동 3-263, 용산장애인복지관 옆)37.5475126.961812022-12-01
1용산구065.교지07-53(00) (효창동 3-349, 청파초 정문 맞은편)37.5478126.963312022-12-01
2용산구공원01-13(00) (후암로13가길 25, 새나라공원)37.5482126.976312022-12-01
3용산구공원01-14(00) (후암로13가길 25, 새나라공원)37.5481126.976512022-12-01
4용산구공원02-17(00) 19-1차(용산동2가 1-1923, 후암동 외국인학교 옆 공원)37.545126.984412022-12-01
5용산구공원02-17(A1) (신흥로 100-5, 옆)37.5453126.984412022-12-01
6용산구공원02-18(00) (용산동2가 5-1717, 소월길 주민쉼터)37.5457126.987912022-12-01
7용산구공원03-13(00) 19-1차(동자동 8-3, 새꿈어린이공원 하단부)37.5524126.974212022-12-01
8용산구공원03-14(00) 19-1차(동자동 19-14, 새꿈어린이공원 상단부)37.5523126.974412022-12-01
9용산구공원03-15(00) 20-2차(동자동 18-21, 센트리빌아파트 공원내(두텁바위어린이공원))37.5519126.973612022-12-01
자치구안심 주소위도경도CCTV 수량수정 일시
1068용산구자치16-51(00) (보광동 265-74 전주)37.5299127.001312022-12-01
1069용산구자치16-52(00) 20-2차(보광동 265-499, 보광동 교회)37.532126.999112022-12-01
1070용산구자치16-53(00) 20-3차(보광동 210-14, 보성교회 입구 전주 옆)37.5259126.997312022-12-01
1071용산구자치16-53(A1) (보광동 210-14, 보성교회 입구 옆 전주)37.5259126.997212022-12-01
1072용산구자치16-54(00) 20-3차(보광동 239-6, 참숯갈비 아래쪽)37.5301126.997912022-12-01
1073용산구자치16-54(A1) 20-3차(보광로32길 16)37.5299126.997812022-12-01
1074용산구자치16-55(00) 20-3차(보광동 3-336, 송화빌라 아래쪽)37.5301127.002312022-12-01
1075용산구자치16-56(00) 21-2차(보광동 265-796, 다세대주택 앞)37.5318126.999712022-12-01
1076용산구자치16-57(00) 21-2차(보광동 7-8, 다세대주택 옆)37.5292127.001712022-12-01
1077용산구자치16-58(00) (보광동 9-23, 경찰 이동식 카메라)37.5281127.00112022-12-01