Overview

Dataset statistics

Number of variables11
Number of observations764
Missing cells0
Missing cells (%)0.0%
Duplicate rows33
Duplicate rows (%)4.3%
Total size in memory68.8 KiB
Average record size in memory92.2 B

Variable types

Categorical7
Text1
Numeric2
DateTime1

Dataset

Description경기도 여주시의 CCTV 현황입니다. 관리기관명, 소재지지번주소, 설치목적구분, 카메라대수, 촬영방면정보, 보관일수, 관리기관전화번호, 위도, 경도 등의 데이터를 제공합니다.
Author경기도 여주시
URLhttps://www.data.go.kr/data/15105004/fileData.do

Alerts

관리기관명 has constant value ""Constant
카메라화소수 has constant value ""Constant
촬영방면정보 has constant value ""Constant
보관일수 has constant value ""Constant
관리기관전화번호 has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 33 (4.3%) duplicate rowsDuplicates
설치목적구분 is highly imbalanced (54.1%)Imbalance

Reproduction

Analysis started2023-12-12 22:07:21.951512
Analysis finished2023-12-12 22:07:22.967915
Duration1.02 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.1 KiB
경기도 여주시청
764 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도 여주시청
2nd row경기도 여주시청
3rd row경기도 여주시청
4th row경기도 여주시청
5th row경기도 여주시청

Common Values

ValueCountFrequency (%)
경기도 여주시청 764
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:07:23.155010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 764
50.0%
여주시청 764
50.0%

소재지지번주소
Text

Distinct662
Distinct (%)86.6%
Missing0
Missing (%)0.0%
Memory size6.1 KiB
2023-12-13T07:07:23.471354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length25
Mean length20.244764
Min length17

Characters and Unicode

Total characters15467
Distinct characters140
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

Unique583 ?
Unique (%)76.3%

Sample

1st row경기도 여주시 가남읍 태평리 561
2nd row경기도 여주시 가남읍 태평리 141-22
3rd row경기도 여주시 가남읍 태평리 562-1
4th row경기도 여주시 가남읍 태평리 507-9
5th row경기도 여주시 가남읍 태평리 479-1
ValueCountFrequency (%)
경기도 764
19.9%
여주시 764
19.9%
여흥동 150
 
3.9%
중앙동 134
 
3.5%
오학동 81
 
2.1%
가남읍 75
 
2.0%
강천면 66
 
1.7%
하동 59
 
1.5%
북내면 51
 
1.3%
홍문동 51
 
1.3%
Other values (759) 1646
42.9%
2023-12-13T07:07:23.870203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3077
19.9%
여 914
 
5.9%
도 785
 
5.1%
주 773
 
5.0%
시 765
 
4.9%
경 764
 
4.9%
기 764
 
4.9%
동 742
 
4.8%
- 525
 
3.4%
1 498
 
3.2%
Other values (130) 5860
37.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 9041
58.5%
Space Separator 3077
 
19.9%
Decimal Number 2824
 
18.3%
Dash Punctuation 525
 
3.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
여 914
 
10.1%
도 785
 
8.7%
주 773
 
8.5%
시 765
 
8.5%
경 764
 
8.5%
기 764
 
8.5%
동 742
 
8.2%
리 415
 
4.6%
면 342
 
3.8%
흥 198
 
2.2%
Other values (118) 2579
28.5%
Decimal Number
ValueCountFrequency (%)
1 498
17.6%
2 404
14.3%
3 354
12.5%
4 334
11.8%
5 298
10.6%
6 252
8.9%
9 190
 
6.7%
7 187
 
6.6%
0 157
 
5.6%
8 150
 
5.3%
Space Separator
ValueCountFrequency (%)
3077
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 525
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 9041
58.5%
Common 6426
41.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
여 914
 
10.1%
도 785
 
8.7%
주 773
 
8.5%
시 765
 
8.5%
경 764
 
8.5%
기 764
 
8.5%
동 742
 
8.2%
리 415
 
4.6%
면 342
 
3.8%
흥 198
 
2.2%
Other values (118) 2579
28.5%
Common
ValueCountFrequency (%)
3077
47.9%
- 525
 
8.2%
1 498
 
7.7%
2 404
 
6.3%
3 354
 
5.5%
4 334
 
5.2%
5 298
 
4.6%
6 252
 
3.9%
9 190
 
3.0%
7 187
 
2.9%
Other values (2) 307
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 9041
58.5%
ASCII 6426
41.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3077
47.9%
- 525
 
8.2%
1 498
 
7.7%
2 404
 
6.3%
3 354
 
5.5%
4 334
 
5.2%
5 298
 
4.6%
6 252
 
3.9%
9 190
 
3.0%
7 187
 
2.9%
Other values (2) 307
 
4.8%
Hangul
ValueCountFrequency (%)
여 914
 
10.1%
도 785
 
8.7%
주 773
 
8.5%
시 765
 
8.5%
경 764
 
8.5%
기 764
 
8.5%
동 742
 
8.2%
리 415
 
4.6%
면 342
 
3.8%
흥 198
 
2.2%
Other values (118) 2579
28.5%

설치목적구분
Categorical

IMBALANCE 

Distinct3
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size6.1 KiB
방범용
655 
시설안전_및_화재예방
68 
교통단속(주정차)
 
41

Length

Max length11
Median length3
Mean length4.0340314
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
방범용 655
85.7%
시설안전_및_화재예방 68
 
8.9%
교통단속(주정차) 41
 
5.4%

Length

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

Common Values (Plot)

2023-12-13T07:07:24.129774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
방범용 655
85.7%
시설안전_및_화재예방 68
 
8.9%
교통단속(주정차 41
 
5.4%

카메라대수
Categorical

Distinct11
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size6.1 KiB
4
180 
5
158 
1
141 
3
117 
2
109 
Other values (6)
59 

Length

Max length4
Median length3
Mean length3.0013089
Min length3

Unique

Unique3 ?
Unique (%)0.4%

Sample

1st row 3
2nd row 6
3rd row 5
4th row 4
5th row 5

Common Values

ValueCountFrequency (%)
4 180
23.6%
5 158
20.7%
1 141
18.5%
3 117
15.3%
2 109
14.3%
6 37
 
4.8%
7 13
 
1.7%
8 6
 
0.8%
9 1
 
0.1%
- 1
 
0.1%

Length

2023-12-13T07:07:24.242444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
4 180
23.6%
5 158
20.7%
1 141
18.5%
3 117
15.3%
2 109
14.3%
6 37
 
4.8%
7 13
 
1.7%
8 6
 
0.8%
9 1
 
0.1%
1
 
0.1%

카메라화소수
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.1 KiB
200
764 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row200
2nd row200
3rd row200
4th row200
5th row200

Common Values

ValueCountFrequency (%)
200 764
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:07:24.445258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
200 764
100.0%

촬영방면정보
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.1 KiB
주변100m이내
764 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row주변100m이내
2nd row주변100m이내
3rd row주변100m이내
4th row주변100m이내
5th row주변100m이내

Common Values

ValueCountFrequency (%)
주변100m이내 764
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:07:24.624384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
주변100m이내 764
100.0%

보관일수
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.1 KiB
30
764 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row30
2nd row30
3rd row30
4th row30
5th row30

Common Values

ValueCountFrequency (%)
30 764
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:07:25.098864image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
30 764
100.0%

관리기관전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.1 KiB
031-887-3380
764 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row031-887-3380
2nd row031-887-3380
3rd row031-887-3380
4th row031-887-3380
5th row031-887-3380

Common Values

ValueCountFrequency (%)
031-887-3380 764
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:07:25.289617image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
031-887-3380 764
100.0%

위도
Real number (ℝ)

Distinct651
Distinct (%)85.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.62049
Minimum127.42125
Maximum127.76708
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.8 KiB
2023-12-13T07:07:25.394591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.42125
5-th percentile127.50585
Q1127.57225
median127.635
Q3127.6535
95-th percentile127.71846
Maximum127.76708
Range0.34583453
Interquartile range (IQR)0.081250844

Descriptive statistics

Standard deviation0.064840406
Coefficient of variation (CV)0.00050807208
Kurtosis0.37460615
Mean127.62049
Median Absolute Deviation (MAD)0.030265439
Skewness-0.59608913
Sum97502.052
Variance0.0042042783
MonotonicityNot monotonic
2023-12-13T07:07:25.548404image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.723956413574 7
 
0.9%
127.635350395546 6
 
0.8%
127.640506190826 5
 
0.7%
127.635154148876 4
 
0.5%
127.619934413331 4
 
0.5%
127.556190632797 4
 
0.5%
127.55138008947 4
 
0.5%
127.538799574088 3
 
0.4%
127.540951305066 3
 
0.4%
127.644892717229 3
 
0.4%
Other values (641) 721
94.4%
ValueCountFrequency (%)
127.421249715357 1
0.1%
127.421703954556 1
0.1%
127.42905686 1
0.1%
127.430320039776 1
0.1%
127.431291551888 1
0.1%
127.436075381736 1
0.1%
127.43841569 1
0.1%
127.439755602617 1
0.1%
127.440215512323 1
0.1%
127.441314156244 1
0.1%
ValueCountFrequency (%)
127.767084243193 1
0.1%
127.761159366952 1
0.1%
127.757915345737 1
0.1%
127.756419671245 2
0.3%
127.754576423936 1
0.1%
127.753861161238 1
0.1%
127.751124891914 1
0.1%
127.7507706 1
0.1%
127.748119174615 1
0.1%
127.746703549386 1
0.1%

경도
Real number (ℝ)

Distinct651
Distinct (%)85.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.296545
Minimum37.147353
Maximum37.438103
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.8 KiB
2023-12-13T07:07:25.678630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.147353
5-th percentile37.198038
Q137.267143
median37.296349
Q337.325743
95-th percentile37.401986
Maximum37.438103
Range0.29075008
Interquartile range (IQR)0.058600147

Descriptive statistics

Standard deviation0.058013055
Coefficient of variation (CV)0.0015554539
Kurtosis-0.075703506
Mean37.296545
Median Absolute Deviation (MAD)0.029406142
Skewness0.011874339
Sum28494.561
Variance0.0033655146
MonotonicityNot monotonic
2023-12-13T07:07:25.829966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.3060377065255 7
 
0.9%
37.2963489722671 6
 
0.8%
37.2934740148627 5
 
0.7%
37.2917087376004 4
 
0.5%
37.3054025209619 4
 
0.5%
37.299887241206 4
 
0.5%
37.3447861908982 4
 
0.5%
37.3335553300458 3
 
0.4%
37.364224826946 3
 
0.4%
37.2946260547227 3
 
0.4%
Other values (641) 721
94.4%
ValueCountFrequency (%)
37.147352545352 1
0.1%
37.1513940020708 1
0.1%
37.1540111680798 1
0.1%
37.16004543 2
0.3%
37.1611140457047 1
0.1%
37.1615892132721 1
0.1%
37.16305226 1
0.1%
37.1630635414517 1
0.1%
37.1684127323485 1
0.1%
37.17129639 1
0.1%
ValueCountFrequency (%)
37.43810262801 1
0.1%
37.4367063830477 1
0.1%
37.433342167599 1
0.1%
37.4332813372558 1
0.1%
37.422473200534 2
0.3%
37.4203358231683 1
0.1%
37.416951 1
0.1%
37.4163235297378 1
0.1%
37.4154653013479 1
0.1%
37.41367684 1
0.1%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.1 KiB
Minimum2023-11-15 00:00:00
Maximum2023-11-15 00:00:00
2023-12-13T07:07:25.935211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:07:26.015305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T07:07:22.486267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:07:22.279609image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:07:22.582686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:07:22.379847image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T07:07:26.095860image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치목적구분카메라대수위도경도
설치목적구분1.0000.5660.2570.266
카메라대수0.5661.0000.2210.176
위도0.2570.2211.0000.740
경도0.2660.1760.7401.000
2023-12-13T07:07:26.195933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
카메라대수설치목적구분
카메라대수1.0000.397
설치목적구분0.3971.000
2023-12-13T07:07:26.296077image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도설치목적구분카메라대수
위도1.000-0.2550.1580.095
경도-0.2551.0000.1640.075
설치목적구분0.1580.1641.0000.397
카메라대수0.0950.0750.3971.000

Missing values

2023-12-13T07:07:22.726150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:07:22.885422image/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경기도 여주시청경기도 여주시 가남읍 태평리 561방범용3200주변100m이내30031-887-3380127.54375737.202652023-11-15
1경기도 여주시청경기도 여주시 가남읍 태평리 141-22방범용6200주변100m이내30031-887-3380127.54553537.2031232023-11-15
2경기도 여주시청경기도 여주시 가남읍 태평리 562-1방범용5200주변100m이내30031-887-3380127.54654437.2023512023-11-15
3경기도 여주시청경기도 여주시 가남읍 태평리 507-9방범용4200주변100m이내30031-887-3380127.53527237.1979052023-11-15
4경기도 여주시청경기도 여주시 가남읍 태평리 479-1방범용5200주변100m이내30031-887-3380127.53857137.1985252023-11-15
5경기도 여주시청경기도 여주시 가남읍 태평리 산 65-5방범용3200주변100m이내30031-887-3380127.53437437.2024992023-11-15
6경기도 여주시청경기도 여주시 가남읍 태평리 533-2방범용5200주변100m이내30031-887-3380127.53480937.201592023-11-15
7경기도 여주시청경기도 여주시 가남읍 태평리 550교통단속(주정차)4200주변100m이내30031-887-3380127.54793137.2042612023-11-15
8경기도 여주시청경기도 여주시 가남읍 태평리 83-4방범용4200주변100m이내30031-887-3380127.54850537.2061392023-11-15
9경기도 여주시청경기도 여주시 가남읍 신해리 620-14방범용4200주변100m이내30031-887-3380127.53529237.216762023-11-15
관리기관명소재지지번주소설치목적구분카메라대수카메라화소수촬영방면정보보관일수관리기관전화번호위도경도데이터기준일자
754경기도 여주시청경기도 여주시 흥천면 외사리 산 16시설안전_및_화재예방1200주변100m이내30031-887-3380127.48521137.3556462023-11-15
755경기도 여주시청경기도 여주시 흥천면 효지리 217-15방범용5200주변100m이내30031-887-3380127.54277137.3323822023-11-15
756경기도 여주시청경기도 여주시 흥천면 효지리 364-5방범용5200주변100m이내30031-887-3380127.538837.3335552023-11-15
757경기도 여주시청경기도 여주시 흥천면 효지리 364-5방범용2200주변100m이내30031-887-3380127.538837.3335552023-11-15
758경기도 여주시청경기도 여주시 흥천면 계신리 554방범용1200주변100m이내30031-887-3380127.51715837.3728092023-11-15
759경기도 여주시청경기도 여주시 흥천면 대당리 22-11방범용4200주변100m이내30031-887-3380127.55496137.3249652023-11-15
760경기도 여주시청경기도 여주시 흥천면 효지리 산 30-7방범용4200주변100m이내30031-887-3380127.55423237.325782023-11-15
761경기도 여주시청경기도 여주시 흥천면 효지리 123방범용7200주변100m이내30031-887-3380127.54856137.3300742023-11-15
762경기도 여주시청경기도 여주시 흥천면 효지리 200-2방범용6200주변100m이내30031-887-3380127.54827637.3308932023-11-15
763경기도 여주시청경기도 여주시 흥천면 효지리 377-2방범용3200주변100m이내30031-887-3380127.54188337.3327012023-11-15

Duplicate rows

Most frequently occurring

관리기관명소재지지번주소설치목적구분카메라대수카메라화소수촬영방면정보보관일수관리기관전화번호위도경도데이터기준일자# duplicates
20경기도 여주시청경기도 여주시 여흥동 홍문동 86방범용5200주변100m이내30031-887-3380127.6353537.2963492023-11-154
1경기도 여주시청경기도 여주시 가남읍 심석리 518방범용2200주변100m이내30031-887-3380127.55619137.2998872023-11-153
28경기도 여주시청경기도 여주시 중앙동 하동 3-112시설안전_및_화재예방1200주변100m이내30031-887-3380127.61993437.3054032023-11-153
0경기도 여주시청경기도 여주시 가남읍 상활리 404-9방범용3200주변100m이내30031-887-3380127.72395637.3060382023-11-152
2경기도 여주시청경기도 여주시 가남읍 양귀리 634-5방범용1200주변100m이내30031-887-3380127.58969337.1979522023-11-152
3경기도 여주시청경기도 여주시 강천면 강천리 645시설안전_및_화재예방1200주변100m이내30031-887-3380127.70874937.2335022023-11-152
4경기도 여주시청경기도 여주시 강천면 부평리 452방범용2200주변100m이내30031-887-3380127.74428737.2732552023-11-152
5경기도 여주시청경기도 여주시 강천면 이호리 523-2방범용2200주변100m이내30031-887-3380127.6844237.2837542023-11-152
6경기도 여주시청경기도 여주시 금사면 상활리 404-9방범용2200주변100m이내30031-887-3380127.72395637.3060382023-11-152
7경기도 여주시청경기도 여주시 대신면 당남리 318시설안전_및_화재예방1200주변100m이내30031-887-3380127.54793337.3841562023-11-152