Overview

Dataset statistics

Number of variables6
Number of observations1337
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory65.4 KiB
Average record size in memory50.1 B

Variable types

Categorical2
Text1
Numeric2
DateTime1

Dataset

Description경기도 광주시에 생활방법 CCTV가 설치된 위치(주소)에 대한 정보로 CCTV가 설치된 곳의 관리기관명, 설치위치, 설치용도, 위도, 경도 등에 데이터를 제공합니다
URLhttps://www.data.go.kr/data/15101129/fileData.do

Alerts

관리기관 has constant value ""Constant
데이터기준일자 has constant value ""Constant
설치용도 is highly imbalanced (77.7%)Imbalance

Reproduction

Analysis started2023-12-12 13:53:53.823292
Analysis finished2023-12-12 13:53:54.580666
Duration0.76 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size10.6 KiB
광주시
1337 

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 (%)
광주시 1337
100.0%

Length

2023-12-12T22:53:54.646485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:53:54.735476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광주시 1337
100.0%

설치위치
Text

Distinct1281
Distinct (%)95.8%
Missing0
Missing (%)0.0%
Memory size10.6 KiB
2023-12-12T22:53:54.970060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length24
Mean length19.972326
Min length14

Characters and Unicode

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

Unique

Unique1232 ?
Unique (%)92.1%

Sample

1st row경기도 광주시 초월읍 도평리 233-26
2nd row경기도 광주시 문형동 271-1
3rd row경기도 광주시 송정동 322-3
4th row경기도 광주시 송정동 산17-7
5th row경기도 광주시 도척면 궁평리 102-1
ValueCountFrequency (%)
경기도 1337
21.9%
광주시 1337
21.9%
오포읍 236
 
3.9%
초월읍 154
 
2.5%
곤지암읍 119
 
2.0%
경안동 93
 
1.5%
태전동 78
 
1.3%
퇴촌면 74
 
1.2%
송정동 70
 
1.1%
도척면 67
 
1.1%
Other values (1351) 2530
41.5%
2023-12-12T22:53:55.378269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4759
17.8%
도 1933
 
7.2%
경 1430
 
5.4%
광 1357
 
5.1%
주 1337
 
5.0%
시 1337
 
5.0%
기 1337
 
5.0%
- 1052
 
3.9%
1 987
 
3.7%
동 868
 
3.3%
Other values (128) 10306
38.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 15664
58.7%
Decimal Number 5228
 
19.6%
Space Separator 4759
 
17.8%
Dash Punctuation 1052
 
3.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
도 1933
12.3%
경 1430
 
9.1%
광 1357
 
8.7%
주 1337
 
8.5%
시 1337
 
8.5%
기 1337
 
8.5%
동 868
 
5.5%
리 527
 
3.4%
읍 509
 
3.2%
지 247
 
1.6%
Other values (116) 4782
30.5%
Decimal Number
ValueCountFrequency (%)
1 987
18.9%
2 730
14.0%
3 590
11.3%
4 548
10.5%
5 479
9.2%
6 460
8.8%
7 420
8.0%
0 354
 
6.8%
8 344
 
6.6%
9 316
 
6.0%
Space Separator
ValueCountFrequency (%)
4759
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1052
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 15664
58.7%
Common 11039
41.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
도 1933
12.3%
경 1430
 
9.1%
광 1357
 
8.7%
주 1337
 
8.5%
시 1337
 
8.5%
기 1337
 
8.5%
동 868
 
5.5%
리 527
 
3.4%
읍 509
 
3.2%
지 247
 
1.6%
Other values (116) 4782
30.5%
Common
ValueCountFrequency (%)
4759
43.1%
- 1052
 
9.5%
1 987
 
8.9%
2 730
 
6.6%
3 590
 
5.3%
4 548
 
5.0%
5 479
 
4.3%
6 460
 
4.2%
7 420
 
3.8%
0 354
 
3.2%
Other values (2) 660
 
6.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 15664
58.7%
ASCII 11039
41.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4759
43.1%
- 1052
 
9.5%
1 987
 
8.9%
2 730
 
6.6%
3 590
 
5.3%
4 548
 
5.0%
5 479
 
4.3%
6 460
 
4.2%
7 420
 
3.8%
0 354
 
3.2%
Other values (2) 660
 
6.0%
Hangul
ValueCountFrequency (%)
도 1933
12.3%
경 1430
 
9.1%
광 1357
 
8.7%
주 1337
 
8.5%
시 1337
 
8.5%
기 1337
 
8.5%
동 868
 
5.5%
리 527
 
3.4%
읍 509
 
3.2%
지 247
 
1.6%
Other values (116) 4782
30.5%

설치용도
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size10.6 KiB
생활방범
1289 
차량방범
 
48

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row생활방범
2nd row생활방범
3rd row생활방범
4th row생활방범
5th row생활방범

Common Values

ValueCountFrequency (%)
생활방범 1289
96.4%
차량방범 48
 
3.6%

Length

2023-12-12T22:53:55.525696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:53:55.630451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
생활방범 1289
96.4%
차량방범 48
 
3.6%

위도
Real number (ℝ)

Distinct1336
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.394343
Minimum37.271882
Maximum37.532281
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size11.9 KiB
2023-12-12T22:53:55.743245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.271882
5-th percentile37.332051
Q137.36432
median37.395059
Q337.416366
95-th percentile37.471768
Maximum37.532281
Range0.2603989
Interquartile range (IQR)0.05204644

Descriptive statistics

Standard deviation0.042292604
Coefficient of variation (CV)0.0011309894
Kurtosis0.57968592
Mean37.394343
Median Absolute Deviation (MAD)0.02638649
Skewness0.22055099
Sum49996.237
Variance0.0017886644
MonotonicityNot monotonic
2023-12-12T22:53:55.907062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.41068689 2
 
0.1%
37.39383007 1
 
0.1%
37.45819465 1
 
0.1%
37.45887165 1
 
0.1%
37.47560295 1
 
0.1%
37.52921552 1
 
0.1%
37.49983569 1
 
0.1%
37.48288193 1
 
0.1%
37.49686128 1
 
0.1%
37.44934688 1
 
0.1%
Other values (1326) 1326
99.2%
ValueCountFrequency (%)
37.27188192 1
0.1%
37.27440252 1
0.1%
37.27813281 1
0.1%
37.27821438 1
0.1%
37.27866829 1
0.1%
37.27907858 1
0.1%
37.27941929 1
0.1%
37.28064928 1
0.1%
37.28168878 1
0.1%
37.28304948 1
0.1%
ValueCountFrequency (%)
37.53228082 1
0.1%
37.53117241 1
0.1%
37.53093073 1
0.1%
37.52967646 1
0.1%
37.52921552 1
0.1%
37.52824918 1
0.1%
37.52672364 1
0.1%
37.52583337 1
0.1%
37.52464469 1
0.1%
37.51672754 1
0.1%

경도
Real number (ℝ)

Distinct1335
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.26443
Minimum127.14065
Maximum127.44482
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size11.9 KiB
2023-12-12T22:53:56.066065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.14065
5-th percentile127.16578
Q1127.23034
median127.2554
Q3127.30617
95-th percentile127.36417
Maximum127.44482
Range0.3041685
Interquartile range (IQR)0.0758281

Descriptive statistics

Standard deviation0.058024238
Coefficient of variation (CV)0.00045593447
Kurtosis0.14964848
Mean127.26443
Median Absolute Deviation (MAD)0.0366646
Skewness0.36812977
Sum170152.54
Variance0.0033668122
MonotonicityNot monotonic
2023-12-12T22:53:56.235120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.2487085 2
 
0.1%
127.2577987 2
 
0.1%
127.291918 1
 
0.1%
127.3117363 1
 
0.1%
127.3310919 1
 
0.1%
127.3828589 1
 
0.1%
127.3350618 1
 
0.1%
127.303314 1
 
0.1%
127.281283 1
 
0.1%
127.2820203 1
 
0.1%
Other values (1325) 1325
99.1%
ValueCountFrequency (%)
127.1406496 1
0.1%
127.1409525 1
0.1%
127.1417343 1
0.1%
127.141877 1
0.1%
127.1420574 1
0.1%
127.1421365 1
0.1%
127.1425951 1
0.1%
127.142641 1
0.1%
127.1430596 1
0.1%
127.1431437 1
0.1%
ValueCountFrequency (%)
127.4448181 1
0.1%
127.4406131 1
0.1%
127.4393935 1
0.1%
127.4382338 1
0.1%
127.4380112 1
0.1%
127.4371379 1
0.1%
127.4354705 1
0.1%
127.4318033 1
0.1%
127.4315977 1
0.1%
127.4241128 1
0.1%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size10.6 KiB
Minimum2023-06-14 00:00:00
Maximum2023-06-14 00:00:00
2023-12-12T22:53:56.350436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:53:56.460132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T22:53:54.203068image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:53:54.052609image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:53:54.288900image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:53:54.126830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T22:53:56.546175image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치용도위도경도
설치용도1.0000.0000.130
위도0.0001.0000.724
경도0.1300.7241.000
2023-12-12T22:53:56.643787image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도설치용도
위도1.0000.0020.000
경도0.0021.0000.099
설치용도0.0000.0991.000

Missing values

2023-12-12T22:53:54.439897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T22:53:54.540618image/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

관리기관설치위치설치용도위도경도데이터기준일자
0광주시경기도 광주시 초월읍 도평리 233-26생활방범37.39383127.2919182023-06-14
1광주시경기도 광주시 문형동 271-1생활방범37.34854127.214022023-06-14
2광주시경기도 광주시 송정동 322-3생활방범37.424322127.2551962023-06-14
3광주시경기도 광주시 송정동 산17-7생활방범37.416494127.2638432023-06-14
4광주시경기도 광주시 도척면 궁평리 102-1생활방범37.338834127.3257972023-06-14
5광주시경기도 광주시 태전동 467-27생활방범37.395153127.2109422023-06-14
6광주시경기도 광주시 삼리 405-5생활방범37.354998127.3237362023-06-14
7광주시경기도 광주시 수양리 334-1생활방범37.329617127.3764712023-06-14
8광주시경기도 광주시 삼리 398-14생활방범37.355619127.325592023-06-14
9광주시경기도 광주시 경안동 80-2생활방범37.413425127.255532023-06-14
관리기관설치위치설치용도위도경도데이터기준일자
1327광주시경기도 광주시 역동 229-4도생활방범37.403016127.2563592023-06-14
1328광주시경기도 광주시 쌍령동 495도생활방범37.406071127.2665522023-06-14
1329광주시경기도 광주시 역동 1-152답생활방범37.407923127.2541552023-06-14
1330광주시경기도 광주시 역동 134-68도생활방범37.401205127.2543562023-06-14
1331광주시경기도 광주시 경안동 36-17대생활방범37.409406127.2558262023-06-14
1332광주시경기도 광주시 경안동 산17-27임생활방범37.409081127.2510042023-06-14
1333광주시경기도 광주시 경안동 152-8도생활방범37.410335127.2485232023-06-14
1334광주시경기도 광주시 퇴촌면 도수리 604-1학생활방범37.471524127.3164892023-06-14
1335광주시경기도 광주시 곤지암읍 삼리 105-5도생활방범37.356612127.3263112023-06-14
1336광주시경기도 광주시 곤지암읍 곤지암리 580생활방범37.349701127.3390072023-06-14