Overview

Dataset statistics

Number of variables6
Number of observations59
Missing cells13
Missing cells (%)3.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.0 KiB
Average record size in memory52.2 B

Variable types

Text2
Numeric2
Categorical2

Dataset

Description서울특별시 광진구 내 불법주정차 단속을 위한 CCTV설치 지번주소, 위도, 경도, 단속지점명, 현장구분 등) 현황
URLhttps://www.data.go.kr/data/15080656/fileData.do

Alerts

자치구 has constant value ""Constant
현장구분 has constant value ""Constant
단속지점명 has 13 (22.0%) missing valuesMissing
위도 has unique valuesUnique
경도 has unique valuesUnique

Reproduction

Analysis started2023-12-12 22:56:19.932056
Analysis finished2023-12-12 22:56:20.623629
Duration0.69 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

고정형CCTV지번주소
Text

Distinct58
Distinct (%)98.3%
Missing0
Missing (%)0.0%
Memory size604.0 B
2023-12-13T07:56:20.787531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length14
Mean length12.542373
Min length7

Characters and Unicode

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

Unique

Unique57 ?
Unique (%)96.6%

Sample

1st row광진구 광장동 331-6
2nd row광진구 광장동 445-3
3rd row광진구 구의2동 96
4th row광진구 군자동 361-8
5th row광진구 구의2동 66-62
ValueCountFrequency (%)
광진구 42
26.1%
구의3동 8
 
5.0%
군자동 5
 
3.1%
자양4동 5
 
3.1%
중곡동 5
 
3.1%
능동 4
 
2.5%
자양동 4
 
2.5%
광장동 4
 
2.5%
자양2동 4
 
2.5%
구의동 4
 
2.5%
Other values (66) 76
47.2%
2023-12-13T07:56:21.182429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
105
14.2%
동 60
 
8.1%
구 58
 
7.8%
- 55
 
7.4%
1 49
 
6.6%
광 46
 
6.2%
진 42
 
5.7%
2 41
 
5.5%
6 37
 
5.0%
4 33
 
4.5%
Other values (17) 214
28.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 302
40.8%
Decimal Number 276
37.3%
Space Separator 105
 
14.2%
Dash Punctuation 55
 
7.4%
Open Punctuation 1
 
0.1%
Close Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 60
19.9%
구 58
19.2%
광 46
15.2%
진 42
13.9%
자 20
 
6.6%
양 18
 
6.0%
의 16
 
5.3%
중 12
 
4.0%
곡 12
 
4.0%
군 6
 
2.0%
Other values (3) 12
 
4.0%
Decimal Number
ValueCountFrequency (%)
1 49
17.8%
2 41
14.9%
6 37
13.4%
4 33
12.0%
3 32
11.6%
5 30
10.9%
7 17
 
6.2%
8 15
 
5.4%
9 12
 
4.3%
0 10
 
3.6%
Space Separator
ValueCountFrequency (%)
105
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 55
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 438
59.2%
Hangul 302
40.8%

Most frequent character per script

Common
ValueCountFrequency (%)
105
24.0%
- 55
12.6%
1 49
11.2%
2 41
 
9.4%
6 37
 
8.4%
4 33
 
7.5%
3 32
 
7.3%
5 30
 
6.8%
7 17
 
3.9%
8 15
 
3.4%
Other values (4) 24
 
5.5%
Hangul
ValueCountFrequency (%)
동 60
19.9%
구 58
19.2%
광 46
15.2%
진 42
13.9%
자 20
 
6.6%
양 18
 
6.0%
의 16
 
5.3%
중 12
 
4.0%
곡 12
 
4.0%
군 6
 
2.0%
Other values (3) 12
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 438
59.2%
Hangul 302
40.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
105
24.0%
- 55
12.6%
1 49
11.2%
2 41
 
9.4%
6 37
 
8.4%
4 33
 
7.5%
3 32
 
7.3%
5 30
 
6.8%
7 17
 
3.9%
8 15
 
3.4%
Other values (4) 24
 
5.5%
Hangul
ValueCountFrequency (%)
동 60
19.9%
구 58
19.2%
광 46
15.2%
진 42
13.9%
자 20
 
6.6%
양 18
 
6.0%
의 16
 
5.3%
중 12
 
4.0%
곡 12
 
4.0%
군 6
 
2.0%
Other values (3) 12
 
4.0%

위도
Real number (ℝ)

UNIQUE 

Distinct59
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.5457
Minimum37.527754
Maximum37.56897
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size663.0 B
2023-12-13T07:56:21.369374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.527754
5-th percentile37.532228
Q137.536961
median37.543603
Q337.553633
95-th percentile37.565151
Maximum37.56897
Range0.041216
Interquartile range (IQR)0.016671533

Descriptive statistics

Standard deviation0.010820865
Coefficient of variation (CV)0.00028820518
Kurtosis-0.83368905
Mean37.5457
Median Absolute Deviation (MAD)0.0082719885
Skewness0.48730963
Sum2215.1963
Variance0.00011709112
MonotonicityNot monotonic
2023-12-13T07:56:21.531664image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.5477094965906 1
 
1.7%
37.5436034 1
 
1.7%
37.5421248254845 1
 
1.7%
37.5409428380723 1
 
1.7%
37.5651081045339 1
 
1.7%
37.5317159114399 1
 
1.7%
37.527754 1
 
1.7%
37.5321362938594 1
 
1.7%
37.5676390076113 1
 
1.7%
37.5423463823407 1
 
1.7%
Other values (49) 49
83.1%
ValueCountFrequency (%)
37.527754 1
1.7%
37.5317159114399 1
1.7%
37.5321362938594 1
1.7%
37.5322380980553 1
1.7%
37.532427 1
1.7%
37.5327922066154 1
1.7%
37.5334639083612 1
1.7%
37.5338906425636 1
1.7%
37.534359 1
1.7%
37.5348071746753 1
1.7%
ValueCountFrequency (%)
37.56897 1
1.7%
37.5676390076113 1
1.7%
37.565533 1
1.7%
37.5651081045339 1
1.7%
37.563713726103 1
1.7%
37.5636736142317 1
1.7%
37.561604786793 1
1.7%
37.5586732232707 1
1.7%
37.5586434042632 1
1.7%
37.558278 1
1.7%

경도
Real number (ℝ)

UNIQUE 

Distinct59
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.08272
Minimum127.06336
Maximum127.10685
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size663.0 B
2023-12-13T07:56:21.688215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.06336
5-th percentile127.06846
Q1127.07328
median127.08351
Q3127.09032
95-th percentile127.09747
Maximum127.10685
Range0.043483498
Interquartile range (IQR)0.01703878

Descriptive statistics

Standard deviation0.010243162
Coefficient of variation (CV)8.0602321 × 10-5
Kurtosis-0.78074704
Mean127.08272
Median Absolute Deviation (MAD)0.0080595755
Skewness0.12520817
Sum7497.8805
Variance0.00010492237
MonotonicityNot monotonic
2023-12-13T07:56:21.837629image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.106845012872 1
 
1.7%
127.1024311 1
 
1.7%
127.071435877498 1
 
1.7%
127.07091084788 1
 
1.7%
127.080695212609 1
 
1.7%
127.083509424474 1
 
1.7%
127.084498 1
 
1.7%
127.085477374542 1
 
1.7%
127.084994790226 1
 
1.7%
127.099597695122 1
 
1.7%
Other values (49) 49
83.1%
ValueCountFrequency (%)
127.06336151443 1
1.7%
127.067398239819 1
1.7%
127.067780136822 1
1.7%
127.068536 1
1.7%
127.068559168953 1
1.7%
127.069221 1
1.7%
127.069377 1
1.7%
127.0695288 1
1.7%
127.07078562234 1
1.7%
127.07091084788 1
1.7%
ValueCountFrequency (%)
127.106845012872 1
1.7%
127.1024311 1
1.7%
127.099597695122 1
1.7%
127.097236076672 1
1.7%
127.096706100005 1
1.7%
127.096380717951 1
1.7%
127.096136 1
1.7%
127.094553608435 1
1.7%
127.094317710402 1
1.7%
127.093132964513 1
1.7%

자치구
Categorical

CONSTANT 

Distinct1
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size604.0 B
광진구
59 

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 (%)
광진구 59
100.0%

Length

2023-12-13T07:56:21.992934image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:56:22.084550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광진구 59
100.0%

단속지점명
Text

MISSING 

Distinct46
Distinct (%)100.0%
Missing13
Missing (%)22.0%
Memory size604.0 B
2023-12-13T07:56:22.311623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length10
Mean length7.5217391
Min length4

Characters and Unicode

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

Unique

Unique46 ?
Unique (%)100.0%

Sample

1st row모두투어앞
2nd row광현교회앞
3rd row아차산역 5번출구 앞
4th row두산위브 앞
5th row국민은행앞
ValueCountFrequency (%)
앞 4
 
6.6%
건너편 3
 
4.9%
현대프라임2단지 1
 
1.6%
중곡지구대앞 1
 
1.6%
모두투어앞 1
 
1.6%
태양주유소앞 1
 
1.6%
고신경정신과의원앞 1
 
1.6%
우리은행앞 1
 
1.6%
공원약국앞 1
 
1.6%
건대입구1번출구앞 1
 
1.6%
Other values (46) 46
75.4%
2023-12-13T07:56:22.661844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
앞 24
 
6.9%
15
 
4.3%
대 11
 
3.2%
건 10
 
2.9%
구 9
 
2.6%
국 6
 
1.7%
원 6
 
1.7%
동 6
 
1.7%
번 5
 
1.4%
역 5
 
1.4%
Other values (125) 249
72.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 316
91.3%
Space Separator 15
 
4.3%
Decimal Number 10
 
2.9%
Uppercase Letter 5
 
1.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
앞 24
 
7.6%
대 11
 
3.5%
건 10
 
3.2%
구 9
 
2.8%
국 6
 
1.9%
원 6
 
1.9%
동 6
 
1.9%
번 5
 
1.6%
역 5
 
1.6%
장 5
 
1.6%
Other values (114) 229
72.5%
Decimal Number
ValueCountFrequency (%)
2 3
30.0%
1 3
30.0%
3 2
20.0%
5 1
 
10.0%
4 1
 
10.0%
Uppercase Letter
ValueCountFrequency (%)
M 1
20.0%
B 1
20.0%
C 1
20.0%
G 1
20.0%
V 1
20.0%
Space Separator
ValueCountFrequency (%)
15
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 316
91.3%
Common 25
 
7.2%
Latin 5
 
1.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
앞 24
 
7.6%
대 11
 
3.5%
건 10
 
3.2%
구 9
 
2.8%
국 6
 
1.9%
원 6
 
1.9%
동 6
 
1.9%
번 5
 
1.6%
역 5
 
1.6%
장 5
 
1.6%
Other values (114) 229
72.5%
Common
ValueCountFrequency (%)
15
60.0%
2 3
 
12.0%
1 3
 
12.0%
3 2
 
8.0%
5 1
 
4.0%
4 1
 
4.0%
Latin
ValueCountFrequency (%)
M 1
20.0%
B 1
20.0%
C 1
20.0%
G 1
20.0%
V 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 316
91.3%
ASCII 30
 
8.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
앞 24
 
7.6%
대 11
 
3.5%
건 10
 
3.2%
구 9
 
2.8%
국 6
 
1.9%
원 6
 
1.9%
동 6
 
1.9%
번 5
 
1.6%
역 5
 
1.6%
장 5
 
1.6%
Other values (114) 229
72.5%
ASCII
ValueCountFrequency (%)
15
50.0%
2 3
 
10.0%
1 3
 
10.0%
3 2
 
6.7%
M 1
 
3.3%
B 1
 
3.3%
5 1
 
3.3%
C 1
 
3.3%
G 1
 
3.3%
V 1
 
3.3%

현장구분
Categorical

CONSTANT 

Distinct1
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size604.0 B
불법주정차구역
59 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row불법주정차구역
2nd row불법주정차구역
3rd row불법주정차구역
4th row불법주정차구역
5th row불법주정차구역

Common Values

ValueCountFrequency (%)
불법주정차구역 59
100.0%

Length

2023-12-13T07:56:22.801141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:56:22.881562image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
불법주정차구역 59
100.0%

Interactions

2023-12-13T07:56:20.312497image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:56:20.130368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:56:20.389500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:56:20.232613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T07:56:22.937353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
고정형CCTV지번주소위도경도단속지점명
고정형CCTV지번주소1.0001.0001.0001.000
위도1.0001.0000.5451.000
경도1.0000.5451.0001.000
단속지점명1.0001.0001.0001.000
2023-12-13T07:56:23.021487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.000-0.033
경도-0.0331.000

Missing values

2023-12-13T07:56:20.485610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:56:20.585901image/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광진구 광장동 331-637.547709127.106845광진구모두투어앞불법주정차구역
1광진구 광장동 445-337.543603127.102431광진구광현교회앞불법주정차구역
2광진구 구의2동 9637.551937127.089448광진구아차산역 5번출구 앞불법주정차구역
3광진구 군자동 361-837.548913127.070786광진구두산위브 앞불법주정차구역
4광진구 구의2동 66-6237.5452127.087981광진구국민은행앞불법주정차구역
5광진구 구의2동 68-2337.546019127.086283광진구구의사거리불법주정차구역
6광진구 구의3동 546-137.532792127.093122광진구리젠트오피스텔 건너편불법주정차구역
7광진구 구의3동 546-1137.535122127.093133광진구지너스타워 주차장앞불법주정차구역
8광진구 구의3동 61137.537846127.096381광진구현대2단지아파트앞불법주정차구역
9광진구 구의3동 546-637.535739127.094554광진구강변역1번출구불법주정차구역
고정형CCTV지번주소위도경도자치구단속지점명현장구분
49자양4동 510-137.53724127.069221광진구<NA>불법주정차구역
50구의동 641-237.54362127.081599광진구구의초등학교 부근불법주정차구역
51자양4동 2-5337.538008127.069529광진구<NA>불법주정차구역
52광장동 571-137.541149127.096136광진구<NA>불법주정차구역
53중곡동 198-1137.56897127.083021광진구<NA>불법주정차구역
54중곡동 75-4237.558278127.091569광진구<NA>불법주정차구역
55구의동 60-4437.547851127.090336광진구광진초등학교불법주정차구역
56중곡동 138-3237.557709127.083307광진구<NA>불법주정차구역
57자양동 553-50237.534359127.071629광진구대양빌딩불법주정차구역
58자양동 2-237.539247127.069377광진구<NA>불법주정차구역