Overview

Dataset statistics

Number of variables6
Number of observations1930
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory96.3 KiB
Average record size in memory51.1 B

Variable types

Categorical3
Text1
Numeric2

Dataset

Description자치구,안심 주소,위도,경도,CCTV 수량,수정 일시
Author종로구
URLhttps://data.seoul.go.kr/dataList/OA-20924/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 10:12:46.884999
Analysis finished2024-03-13 10:12:47.861090
Duration0.98 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

자치구
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size15.2 KiB
종로구
1930 

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

Length

2024-03-13T19:12:47.955465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T19:12:48.125072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
종로구 1930
100.0%

안심 주소
Text

UNIQUE 

Distinct1930
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size15.2 KiB
2024-03-13T19:12:48.396670image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length35
Median length32
Mean length19.080829
Min length13

Characters and Unicode

Total characters36826
Distinct characters205
Distinct categories7 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1930 ?
Unique (%)100.0%

Sample

1st row공원001_명륜3가 산 2-11 와룡공원_메인
2nd row공원002_명륜3가 산 2-11 와룡공원_검지1
3rd row공원002_명륜3가 산 2-11 와룡공원_메인
4th row공원003_명륜3가 산 2-11 와룡공원_메인
5th row공원004_명륜3가 산 2-11 와룡공원_메인
ValueCountFrequency (%)
산 23
 
0.5%
근처_메인 23
 
0.5%
종로구 21
 
0.5%
53 17
 
0.4%
난계로27길84 13
 
0.3%
문화재003 13
 
0.3%
메인1 13
 
0.3%
6_검지1 13
 
0.3%
29_검지1 12
 
0.3%
9_메인 12
 
0.3%
Other values (1923) 4098
96.2%
2024-03-13T19:12:48.840353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
_ 3725
 
10.1%
1 2790
 
7.6%
2328
 
6.3%
2 2150
 
5.8%
3 1644
 
4.5%
방 1563
 
4.2%
범 1563
 
4.2%
길 1421
 
3.9%
0 1415
 
3.8%
4 1264
 
3.4%
Other values (195) 16963
46.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 16840
45.7%
Decimal Number 13272
36.0%
Connector Punctuation 3725
 
10.1%
Space Separator 2328
 
6.3%
Dash Punctuation 525
 
1.4%
Close Punctuation 68
 
0.2%
Open Punctuation 68
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
방 1563
 
9.3%
범 1563
 
9.3%
길 1421
 
8.4%
로 1257
 
7.5%
지 1183
 
7.0%
검 1116
 
6.6%
인 977
 
5.8%
메 804
 
4.8%
문 374
 
2.2%
동 305
 
1.8%
Other values (180) 6277
37.3%
Decimal Number
ValueCountFrequency (%)
1 2790
21.0%
2 2150
16.2%
3 1644
12.4%
0 1415
10.7%
4 1264
9.5%
5 1079
 
8.1%
6 787
 
5.9%
7 750
 
5.7%
9 713
 
5.4%
8 680
 
5.1%
Connector Punctuation
ValueCountFrequency (%)
_ 3725
100.0%
Space Separator
ValueCountFrequency (%)
2328
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 525
100.0%
Close Punctuation
ValueCountFrequency (%)
) 68
100.0%
Open Punctuation
ValueCountFrequency (%)
( 68
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 19986
54.3%
Hangul 16840
45.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
방 1563
 
9.3%
범 1563
 
9.3%
길 1421
 
8.4%
로 1257
 
7.5%
지 1183
 
7.0%
검 1116
 
6.6%
인 977
 
5.8%
메 804
 
4.8%
문 374
 
2.2%
동 305
 
1.8%
Other values (180) 6277
37.3%
Common
ValueCountFrequency (%)
_ 3725
18.6%
1 2790
14.0%
2328
11.6%
2 2150
10.8%
3 1644
8.2%
0 1415
 
7.1%
4 1264
 
6.3%
5 1079
 
5.4%
6 787
 
3.9%
7 750
 
3.8%
Other values (5) 2054
10.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 19986
54.3%
Hangul 16840
45.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
_ 3725
18.6%
1 2790
14.0%
2328
11.6%
2 2150
10.8%
3 1644
8.2%
0 1415
 
7.1%
4 1264
 
6.3%
5 1079
 
5.4%
6 787
 
3.9%
7 750
 
3.8%
Other values (5) 2054
10.3%
Hangul
ValueCountFrequency (%)
방 1563
 
9.3%
범 1563
 
9.3%
길 1421
 
8.4%
로 1257
 
7.5%
지 1183
 
7.0%
검 1116
 
6.6%
인 977
 
5.8%
메 804
 
4.8%
문 374
 
2.2%
동 305
 
1.8%
Other values (180) 6277
37.3%

위도
Real number (ℝ)

Distinct303
Distinct (%)15.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.581029
Minimum37.5631
Maximum37.6166
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size17.1 KiB
2024-03-13T19:12:48.994610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.5631
5-th percentile37.5693
Q137.5736
median37.57785
Q337.5862
95-th percentile37.606
Maximum37.6166
Range0.0535
Interquartile range (IQR)0.0126

Descriptive statistics

Standard deviation0.010898668
Coefficient of variation (CV)0.0002900045
Kurtosis1.0737063
Mean37.581029
Median Absolute Deviation (MAD)0.00535
Skewness1.1915899
Sum72531.387
Variance0.00011878096
MonotonicityNot monotonic
2024-03-13T19:12:49.177727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.5631 53
 
2.7%
37.5768 29
 
1.5%
37.5742 28
 
1.5%
37.5757 25
 
1.3%
37.5744 24
 
1.2%
37.5781 24
 
1.2%
37.5736 21
 
1.1%
37.5734 21
 
1.1%
37.5794 18
 
0.9%
37.5733 18
 
0.9%
Other values (293) 1669
86.5%
ValueCountFrequency (%)
37.5631 53
2.7%
37.5674 5
 
0.3%
37.5686 4
 
0.2%
37.5687 7
 
0.4%
37.5689 4
 
0.2%
37.569 2
 
0.1%
37.5691 10
 
0.5%
37.5692 10
 
0.5%
37.5693 11
 
0.6%
37.5694 7
 
0.4%
ValueCountFrequency (%)
37.6166 3
0.2%
37.6149 1
 
0.1%
37.6147 6
0.3%
37.614 3
0.2%
37.6139 3
0.2%
37.6135 3
0.2%
37.6131 3
0.2%
37.6126 3
0.2%
37.6125 5
0.3%
37.6124 3
0.2%

경도
Real number (ℝ)

Distinct450
Distinct (%)23.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.9899
Minimum126.9435
Maximum127.0367
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size17.1 KiB
2024-03-13T19:12:49.362808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.9435
5-th percentile126.96004
Q1126.9685
median126.9912
Q3127.0074
95-th percentile127.0206
Maximum127.0367
Range0.0932
Interquartile range (IQR)0.0389

Descriptive statistics

Standard deviation0.021294506
Coefficient of variation (CV)0.00016768661
Kurtosis-1.0779338
Mean126.9899
Median Absolute Deviation (MAD)0.0196
Skewness0.12334136
Sum245090.51
Variance0.000453456
MonotonicityNot monotonic
2024-03-13T19:12:49.541846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.0367 53
 
2.7%
126.9683 18
 
0.9%
127.0124 15
 
0.8%
126.9657 14
 
0.7%
126.9976 14
 
0.7%
126.9857 13
 
0.7%
126.9668 13
 
0.7%
127.0162 11
 
0.6%
126.9653 11
 
0.6%
127.0086 11
 
0.6%
Other values (440) 1757
91.0%
ValueCountFrequency (%)
126.9435 1
 
0.1%
126.9536 3
0.2%
126.955 3
0.2%
126.9552 2
 
0.1%
126.9559 3
0.2%
126.9562 3
0.2%
126.9563 1
 
0.1%
126.9565 4
0.2%
126.9566 5
0.3%
126.9568 3
0.2%
ValueCountFrequency (%)
127.0367 53
2.7%
127.023 4
 
0.2%
127.0227 6
 
0.3%
127.0226 3
 
0.2%
127.0225 2
 
0.1%
127.022 4
 
0.2%
127.0219 4
 
0.2%
127.0216 6
 
0.3%
127.0215 4
 
0.2%
127.021 4
 
0.2%

CCTV 수량
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size15.2 KiB
1
1930 

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

Length

2024-03-13T19:12:49.718524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T19:12:49.918343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 1930
100.0%

수정 일시
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size15.2 KiB
2022-12-01
1930 

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

Length

2024-03-13T19:12:50.058132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T19:12:50.159436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-12-01 1930
100.0%

Interactions

2024-03-13T19:12:47.321548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T19:12:47.107542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T19:12:47.417875image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T19:12:47.209611image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T19:12:50.221459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.864
경도0.8641.000
2024-03-13T19:12:50.319036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.000-0.388
경도-0.3881.000

Missing values

2024-03-13T19:12:47.645329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T19:12:47.795493image/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종로구공원001_명륜3가 산 2-11 와룡공원_메인37.5913126.994512022-12-01
1종로구공원002_명륜3가 산 2-11 와룡공원_검지137.5912126.9912022-12-01
2종로구공원002_명륜3가 산 2-11 와룡공원_메인37.5912126.9912022-12-01
3종로구공원003_명륜3가 산 2-11 와룡공원_메인37.5919126.992912022-12-01
4종로구공원004_명륜3가 산 2-11 와룡공원_메인37.5922126.996112022-12-01
5종로구공원005_옥인동 185-3 수성동계곡_메인37.5821126.963712022-12-01
6종로구공원006_옥인동 185-3 수성동계곡_메인37.5825126.963912022-12-01
7종로구공원007_옥인동 185-3 수성동계곡_메인37.5824126.962312022-12-01
8종로구공원008_옥인동 185-3 수성동계곡_메인37.583126.96212022-12-01
9종로구공원009_숭인동 58-587 숭인공원_메인37.5781127.017812022-12-01
자치구안심 주소위도경도CCTV 수량수정 일시
1920종로구주정차098_숭인동길 39_메인137.5769127.02212022-12-01
1921종로구주정차099_교남동 7_메인137.5674126.965812022-12-01
1922종로구주정차100_삼일대로 30길 23_메인137.5741126.98912022-12-01
1923종로구주정차101_창신길 12_메인137.5723127.010712022-12-01
1924종로구주정차102_계동길 23_메인137.5783126.986712022-12-01
1925종로구주정차103_자하문로 89_메인137.5839126.970312022-12-01
1926종로구주정차104_창경궁로 150_메인137.5758126.997412022-12-01
1927종로구치수001_세검정로6길 51-4_메인37.6003126.961912022-12-01
1928종로구치수002_세검정로9길 1_메인37.6034126.96212022-12-01
1929종로구치수003_홍지동 72-7_메인37.6003126.957912022-12-01