Overview

Dataset statistics

Number of variables6
Number of observations2450
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory122.2 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-20937/S/1/datasetView.do

Alerts

자치구 has constant value ""Constant
CCTV 수량 has constant value ""Constant
수정 일시 has constant value ""Constant
위도 is highly overall correlated with 경도High correlation
경도 is highly overall correlated with 위도High correlation
안심 주소 has unique valuesUnique

Reproduction

Analysis started2024-03-13 17:31:39.740538
Analysis finished2024-03-13 17:31:40.410469
Duration0.67 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

자치구
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size19.3 KiB
마포구
2450 

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 (%)
마포구 2450
100.0%

Length

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

Common Values (Plot)

2024-03-14T02:31:40.539117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
마포구 2450
100.0%

안심 주소
Text

UNIQUE 

Distinct2450
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size19.3 KiB
2024-03-14T02:31:40.718960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length37
Median length34
Mean length17.177143
Min length8

Characters and Unicode

Total characters42084
Distinct characters277
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

Unique2450 ?
Unique (%)100.0%

Sample

1st rowU001-홍익로 10
2nd rowU002-와우산로23길 20
3rd rowU003-와우산로27길 44
4th rowU004-와우산로25길 12
5th rowU005-와우산로 111
ValueCountFrequency (%)
앞 126
 
2.3%
옆 62
 
1.1%
삼거리 55
 
1.0%
12 53
 
1.0%
11 45
 
0.8%
21 43
 
0.8%
15 42
 
0.8%
10 41
 
0.7%
17 39
 
0.7%
13 38
 
0.7%
Other values (3024) 4955
90.1%
2024-03-14T02:31:41.035208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 4046
 
9.6%
1 3145
 
7.5%
3049
 
7.2%
2 2301
 
5.5%
방 2218
 
5.3%
범 2211
 
5.3%
로 1884
 
4.5%
3 1705
 
4.1%
길 1573
 
3.7%
0 1559
 
3.7%
Other values (267) 18393
43.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 18362
43.6%
Decimal Number 16392
39.0%
Dash Punctuation 4046
 
9.6%
Space Separator 3049
 
7.2%
Open Punctuation 79
 
0.2%
Uppercase Letter 73
 
0.2%
Close Punctuation 72
 
0.2%
Connector Punctuation 6
 
< 0.1%
Other Punctuation 4
 
< 0.1%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
방 2218
 
12.1%
범 2211
 
12.0%
로 1884
 
10.3%
길 1573
 
8.6%
산 412
 
2.2%
정 386
 
2.1%
월 353
 
1.9%
드 353
 
1.9%
컵 353
 
1.9%
동 297
 
1.6%
Other values (243) 8322
45.3%
Decimal Number
ValueCountFrequency (%)
1 3145
19.2%
2 2301
14.0%
3 1705
10.4%
0 1559
9.5%
4 1540
9.4%
7 1298
7.9%
6 1253
 
7.6%
5 1249
 
7.6%
8 1177
 
7.2%
9 1165
 
7.1%
Uppercase Letter
ValueCountFrequency (%)
U 25
34.2%
A 14
19.2%
C 12
16.4%
K 10
 
13.7%
S 10
 
13.7%
P 1
 
1.4%
I 1
 
1.4%
Dash Punctuation
ValueCountFrequency (%)
- 4046
100.0%
Space Separator
ValueCountFrequency (%)
3049
100.0%
Open Punctuation
ValueCountFrequency (%)
( 79
100.0%
Close Punctuation
ValueCountFrequency (%)
) 72
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 6
100.0%
Other Punctuation
ValueCountFrequency (%)
& 4
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 23648
56.2%
Hangul 18362
43.6%
Latin 74
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
방 2218
 
12.1%
범 2211
 
12.0%
로 1884
 
10.3%
길 1573
 
8.6%
산 412
 
2.2%
정 386
 
2.1%
월 353
 
1.9%
드 353
 
1.9%
컵 353
 
1.9%
동 297
 
1.6%
Other values (243) 8322
45.3%
Common
ValueCountFrequency (%)
- 4046
17.1%
1 3145
13.3%
3049
12.9%
2 2301
9.7%
3 1705
7.2%
0 1559
 
6.6%
4 1540
 
6.5%
7 1298
 
5.5%
6 1253
 
5.3%
5 1249
 
5.3%
Other values (6) 2503
10.6%
Latin
ValueCountFrequency (%)
U 25
33.8%
A 14
18.9%
C 12
16.2%
K 10
 
13.5%
S 10
 
13.5%
P 1
 
1.4%
e 1
 
1.4%
I 1
 
1.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 23722
56.4%
Hangul 18362
43.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 4046
17.1%
1 3145
13.3%
3049
12.9%
2 2301
9.7%
3 1705
7.2%
0 1559
 
6.6%
4 1540
 
6.5%
7 1298
 
5.5%
6 1253
 
5.3%
5 1249
 
5.3%
Other values (14) 2577
10.9%
Hangul
ValueCountFrequency (%)
방 2218
 
12.1%
범 2211
 
12.0%
로 1884
 
10.3%
길 1573
 
8.6%
산 412
 
2.2%
정 386
 
2.1%
월 353
 
1.9%
드 353
 
1.9%
컵 353
 
1.9%
동 297
 
1.6%
Other values (243) 8322
45.3%

위도
Real number (ℝ)

HIGH CORRELATION 

Distinct397
Distinct (%)16.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.554628
Minimum37.5352
Maximum37.5887
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size21.7 KiB
2024-03-14T02:31:41.148197image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.5352
5-th percentile37.5403
Q137.5478
median37.5534
Q337.5599
95-th percentile37.5759
Maximum37.5887
Range0.0535
Interquartile range (IQR)0.0121

Descriptive statistics

Standard deviation0.010112617
Coefficient of variation (CV)0.00026927752
Kurtosis0.61486777
Mean37.554628
Median Absolute Deviation (MAD)0.0059
Skewness0.81525313
Sum92008.838
Variance0.00010226502
MonotonicityNot monotonic
2024-03-14T02:31:41.263991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.5495 27
 
1.1%
37.5496 24
 
1.0%
37.552 24
 
1.0%
37.5562 23
 
0.9%
37.5558 21
 
0.9%
37.5525 21
 
0.9%
37.5544 19
 
0.8%
37.5554 19
 
0.8%
37.5549 19
 
0.8%
37.5489 19
 
0.8%
Other values (387) 2234
91.2%
ValueCountFrequency (%)
37.5352 1
 
< 0.1%
37.5354 3
0.1%
37.5357 1
 
< 0.1%
37.5358 3
0.1%
37.5361 1
 
< 0.1%
37.5362 5
0.2%
37.5363 1
 
< 0.1%
37.5364 2
 
0.1%
37.5367 1
 
< 0.1%
37.5368 1
 
< 0.1%
ValueCountFrequency (%)
37.5887 1
 
< 0.1%
37.5882 1
 
< 0.1%
37.5877 4
0.2%
37.5876 4
0.2%
37.5864 1
 
< 0.1%
37.5859 3
0.1%
37.5858 1
 
< 0.1%
37.5855 2
0.1%
37.5854 4
0.2%
37.5853 1
 
< 0.1%

경도
Real number (ℝ)

HIGH CORRELATION 

Distinct601
Distinct (%)24.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.92662
Minimum126.877
Maximum126.9632
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size21.7 KiB
2024-03-14T02:31:41.377349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.877
5-th percentile126.89599
Q1126.90982
median126.9241
Q3126.94508
95-th percentile126.9591
Maximum126.9632
Range0.0862
Interquartile range (IQR)0.03525

Descriptive statistics

Standard deviation0.020499009
Coefficient of variation (CV)0.00016150283
Kurtosis-0.92552169
Mean126.92662
Median Absolute Deviation (MAD)0.0172
Skewness-0.068029528
Sum310970.22
Variance0.00042020936
MonotonicityNot monotonic
2024-03-14T02:31:41.500160image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.9101 18
 
0.7%
126.9442 16
 
0.7%
126.9236 15
 
0.6%
126.9465 15
 
0.6%
126.9055 14
 
0.6%
126.9396 13
 
0.5%
126.9444 13
 
0.5%
126.9488 13
 
0.5%
126.9108 12
 
0.5%
126.9456 12
 
0.5%
Other values (591) 2309
94.2%
ValueCountFrequency (%)
126.877 4
0.2%
126.8771 5
0.2%
126.8774 3
 
0.1%
126.8788 1
 
< 0.1%
126.8797 8
0.3%
126.8798 3
 
0.1%
126.88 2
 
0.1%
126.8801 1
 
< 0.1%
126.8802 1
 
< 0.1%
126.8804 3
 
0.1%
ValueCountFrequency (%)
126.9632 2
 
0.1%
126.9626 6
0.2%
126.9625 2
 
0.1%
126.9624 2
 
0.1%
126.9623 2
 
0.1%
126.9622 2
 
0.1%
126.9621 2
 
0.1%
126.962 5
0.2%
126.9619 3
0.1%
126.9618 4
0.2%

CCTV 수량
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size19.3 KiB
1
2450 

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

Length

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

Common Values (Plot)

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

수정 일시
Date

CONSTANT 

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

Interactions

2024-03-14T02:31:40.082516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T02:31:39.948488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T02:31:40.163465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T02:31:40.018126image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T02:31:41.825079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.864
경도0.8641.000
2024-03-14T02:31:41.882291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.000-0.607
경도-0.6071.000

Missing values

2024-03-14T02:31:40.286147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T02:31:40.374278image/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마포구U001-홍익로 1037.5542126.923612022-12-01
1마포구U002-와우산로23길 2037.5539126.924212022-12-01
2마포구U003-와우산로27길 4437.5543126.92612022-12-01
3마포구U004-와우산로25길 1237.5538126.92612022-12-01
4마포구U005-와우산로 11137.5534126.925912022-12-01
5마포구U006-와우산로 133-137.5537126.928412022-12-01
6마포구U007-와우산로27길 3537.5545126.926512022-12-01
7마포구U008-와우산로27길 5637.555126.925712022-12-01
8마포구U009-1-어울마당로 13037.5558126.924412022-12-01
9마포구U009-2-어울마당로 13037.5558126.924412022-12-01
자치구안심 주소위도경도CCTV 수량수정 일시
2440마포구청소008-4-월드컵북로 19037.5683126.907912022-12-01
2441마포구청소008-월드컵북로 19037.5683126.907912022-12-01
2442마포구청소009-1-월드컵북로30길 4437.5696126.909212022-12-01
2443마포구청소009-2-월드컵북로30길 4437.5696126.909212022-12-01
2444마포구청소009-3-월드컵북로30길 4437.5696126.909212022-12-01
2445마포구청소009-월드컵북로30길 4437.5696126.909212022-12-01
2446마포구청소010-1-양화진길 537.5486126.912912022-12-01
2447마포구청소010-2-양화진길 537.5486126.912912022-12-01
2448마포구청소010-3-양화진길 537.5486126.912912022-12-01
2449마포구청소010-양화진길 537.5486126.912912022-12-01