Overview

Dataset statistics

Number of variables8
Number of observations3422
Missing cells0
Missing cells (%)0.0%
Duplicate rows2
Duplicate rows (%)0.1%
Total size in memory220.7 KiB
Average record size in memory66.0 B

Variable types

Categorical4
Text1
Numeric2
DateTime1

Dataset

Description경기도 광주시 관내 차량진입방지시설(차량 출입을 못하도록 볼라드로 막아 놓은 장소의 위치) 현황에 대한 데이터로 지형지물부호, 지번주소, 경도, 위도 등을 제공합니다.
Author경기도 광주시
URLhttps://www.data.go.kr/data/15042235/fileData.do

Alerts

관리기관 has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 2 (0.1%) duplicate rowsDuplicates
재질 is highly overall correlated with 형태High correlation
형태 is highly overall correlated with 재질High correlation
지형지물부호 is highly imbalanced (99.3%)Imbalance
형태 is highly imbalanced (79.5%)Imbalance

Reproduction

Analysis started2023-12-23 07:22:29.661278
Analysis finished2023-12-23 07:22:34.390339
Duration4.73 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지형지물부호
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size26.9 KiB
차량진입방지시설
3420 
신호등
 
2

Length

Max length8
Median length8
Mean length7.9970777
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row신호등
2nd row신호등
3rd row차량진입방지시설
4th row차량진입방지시설
5th row차량진입방지시설

Common Values

ValueCountFrequency (%)
차량진입방지시설 3420
99.9%
신호등 2
 
0.1%

Length

2023-12-23T07:22:34.891951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-23T07:22:35.488234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
차량진입방지시설 3420
99.9%
신호등 2
 
0.1%

지번주소
Text

Distinct1163
Distinct (%)34.0%
Missing0
Missing (%)0.0%
Memory size26.9 KiB
2023-12-23T07:22:36.747481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length26
Mean length20.56429
Min length16

Characters and Unicode

Total characters70371
Distinct characters74
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

Unique310 ?
Unique (%)9.1%

Sample

1st row경기도 광주시 태전동 281-16번지
2nd row경기도 광주시 태전동 281-16번지
3rd row경기도 광주시 송정동 148-5번지
4th row경기도 광주시 송정동 148-5번지
5th row경기도 광주시 탄벌동 701-4번지
ValueCountFrequency (%)
경기도 3422
23.3%
광주시 3422
23.3%
태전동 787
 
5.4%
곤지암읍 606
 
4.1%
송정동 419
 
2.9%
곤지암리 405
 
2.8%
양벌동 220
 
1.5%
고산동 190
 
1.3%
경안동 189
 
1.3%
역동 181
 
1.2%
Other values (1174) 4835
32.9%
2023-12-23T07:22:38.356502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
11254
16.0%
지 4498
 
6.4%
도 3638
 
5.2%
경 3611
 
5.1%
광 3522
 
5.0%
기 3422
 
4.9%
주 3422
 
4.9%
시 3422
 
4.9%
번 3422
 
4.9%
- 3201
 
4.5%
Other values (64) 26959
38.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 41718
59.3%
Decimal Number 14198
 
20.2%
Space Separator 11254
 
16.0%
Dash Punctuation 3201
 
4.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
지 4498
10.8%
도 3638
 
8.7%
경 3611
 
8.7%
광 3522
 
8.4%
기 3422
 
8.2%
주 3422
 
8.2%
시 3422
 
8.2%
번 3422
 
8.2%
동 2550
 
6.1%
곤 1011
 
2.4%
Other values (52) 9200
22.1%
Decimal Number
ValueCountFrequency (%)
1 2871
20.2%
2 2124
15.0%
3 1532
10.8%
4 1355
9.5%
6 1297
9.1%
5 1288
9.1%
7 1064
 
7.5%
9 936
 
6.6%
0 878
 
6.2%
8 853
 
6.0%
Space Separator
ValueCountFrequency (%)
11254
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3201
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 41718
59.3%
Common 28653
40.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
지 4498
10.8%
도 3638
 
8.7%
경 3611
 
8.7%
광 3522
 
8.4%
기 3422
 
8.2%
주 3422
 
8.2%
시 3422
 
8.2%
번 3422
 
8.2%
동 2550
 
6.1%
곤 1011
 
2.4%
Other values (52) 9200
22.1%
Common
ValueCountFrequency (%)
11254
39.3%
- 3201
 
11.2%
1 2871
 
10.0%
2 2124
 
7.4%
3 1532
 
5.3%
4 1355
 
4.7%
6 1297
 
4.5%
5 1288
 
4.5%
7 1064
 
3.7%
9 936
 
3.3%
Other values (2) 1731
 
6.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 41718
59.3%
ASCII 28653
40.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
11254
39.3%
- 3201
 
11.2%
1 2871
 
10.0%
2 2124
 
7.4%
3 1532
 
5.3%
4 1355
 
4.7%
6 1297
 
4.5%
5 1288
 
4.5%
7 1064
 
3.7%
9 936
 
3.3%
Other values (2) 1731
 
6.0%
Hangul
ValueCountFrequency (%)
지 4498
10.8%
도 3638
 
8.7%
경 3611
 
8.7%
광 3522
 
8.4%
기 3422
 
8.2%
주 3422
 
8.2%
시 3422
 
8.2%
번 3422
 
8.2%
동 2550
 
6.1%
곤 1011
 
2.4%
Other values (52) 9200
22.1%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size26.9 KiB
경기도 광주시청
3422 

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 (%)
경기도 광주시청 3422
100.0%

Length

2023-12-23T07:22:39.436411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-23T07:22:40.354606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 3422
50.0%
광주시청 3422
50.0%

재질
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size26.9 KiB
기타
1258 
주철
872 
화강암
497 
스테인레스
274 
미분류
246 
Other values (3)
275 

Length

Max length5
Median length2
Mean length2.5829924
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row플라스틱
2nd row플라스틱
3rd row기타
4th row기타
5th row기타

Common Values

ValueCountFrequency (%)
기타 1258
36.8%
주철 872
25.5%
화강암 497
 
14.5%
스테인레스 274
 
8.0%
미분류 246
 
7.2%
플라스틱 214
 
6.3%
강관 60
 
1.8%
콘크리트 1
 
< 0.1%

Length

2023-12-23T07:22:41.404098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-23T07:22:42.526368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기타 1258
36.8%
주철 872
25.5%
화강암 497
 
14.5%
스테인레스 274
 
8.0%
미분류 246
 
7.2%
플라스틱 214
 
6.3%
강관 60
 
1.8%
콘크리트 1
 
< 0.1%

형태
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct4
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size26.9 KiB
원형
3163 
미분류
 
246
사각형
 
11
육각
 
2

Length

Max length3
Median length2
Mean length2.0751023
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row원형
2nd row원형
3rd row원형
4th row원형
5th row원형

Common Values

ValueCountFrequency (%)
원형 3163
92.4%
미분류 246
 
7.2%
사각형 11
 
0.3%
육각 2
 
0.1%

Length

2023-12-23T07:22:43.353967image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-23T07:22:43.898580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
원형 3163
92.4%
미분류 246
 
7.2%
사각형 11
 
0.3%
육각 2
 
0.1%

경도
Real number (ℝ)

Distinct3376
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.26827
Minimum127.15104
Maximum127.40203
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size30.2 KiB
2023-12-23T07:22:44.716277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.15104
5-th percentile127.22743
Q1127.23335
median127.25515
Q3127.30871
95-th percentile127.34532
Maximum127.40203
Range0.2509883
Interquartile range (IQR)0.075361975

Descriptive statistics

Standard deviation0.045195607
Coefficient of variation (CV)0.00035512077
Kurtosis-0.47368801
Mean127.26827
Median Absolute Deviation (MAD)0.02419505
Skewness0.60238695
Sum435512.03
Variance0.0020426429
MonotonicityNot monotonic
2023-12-23T07:22:45.471004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.25627 3
 
0.1%
127.2334174 3
 
0.1%
127.2335967 3
 
0.1%
127.2306927 3
 
0.1%
127.230693 3
 
0.1%
127.2309405 2
 
0.1%
127.2309402 2
 
0.1%
127.2562357 2
 
0.1%
127.2598889 2
 
0.1%
127.2560691 2
 
0.1%
Other values (3366) 3397
99.3%
ValueCountFrequency (%)
127.1510418 1
< 0.1%
127.1510591 1
< 0.1%
127.1510848 1
< 0.1%
127.1512341 1
< 0.1%
127.1512363 1
< 0.1%
127.1512413 1
< 0.1%
127.1512496 1
< 0.1%
127.1512612 1
< 0.1%
127.15835 1
< 0.1%
127.1583811 1
< 0.1%
ValueCountFrequency (%)
127.4020301 1
< 0.1%
127.4020164 1
< 0.1%
127.4020011 1
< 0.1%
127.4019879 1
< 0.1%
127.4019743 1
< 0.1%
127.4018633 1
< 0.1%
127.4018486 1
< 0.1%
127.4018336 1
< 0.1%
127.4018183 1
< 0.1%
127.4018037 1
< 0.1%

위도
Real number (ℝ)

Distinct3419
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.389011
Minimum37.303176
Maximum37.524662
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size30.2 KiB
2023-12-23T07:22:46.312148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.303176
5-th percentile37.34785
Q137.372033
median37.385559
Q337.411735
95-th percentile37.463681
Maximum37.524662
Range0.22148634
Interquartile range (IQR)0.039702293

Descriptive statistics

Standard deviation0.03314251
Coefficient of variation (CV)0.0008864238
Kurtosis0.68070107
Mean37.389011
Median Absolute Deviation (MAD)0.02300451
Skewness0.25950694
Sum127945.2
Variance0.0010984259
MonotonicityNot monotonic
2023-12-23T07:22:47.125757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.38654022 2
 
0.1%
37.38014295 2
 
0.1%
37.35281602 2
 
0.1%
37.39304224 1
 
< 0.1%
37.37880946 1
 
< 0.1%
37.38576328 1
 
< 0.1%
37.3780449 1
 
< 0.1%
37.37803907 1
 
< 0.1%
37.37803616 1
 
< 0.1%
37.37805012 1
 
< 0.1%
Other values (3409) 3409
99.6%
ValueCountFrequency (%)
37.30317602 1
< 0.1%
37.30318865 1
< 0.1%
37.30319032 1
< 0.1%
37.30320295 1
< 0.1%
37.30321104 1
< 0.1%
37.30321676 1
< 0.1%
37.30322414 1
< 0.1%
37.30323653 1
< 0.1%
37.30374043 1
< 0.1%
37.30375353 1
< 0.1%
ValueCountFrequency (%)
37.52466236 1
< 0.1%
37.52464954 1
< 0.1%
37.47808069 1
< 0.1%
37.47806527 1
< 0.1%
37.4759392 1
< 0.1%
37.47592633 1
< 0.1%
37.47419053 1
< 0.1%
37.47418884 1
< 0.1%
37.47418674 1
< 0.1%
37.47247339 1
< 0.1%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size26.9 KiB
Minimum2023-12-15 00:00:00
Maximum2023-12-15 00:00:00
2023-12-23T07:22:47.816715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-23T07:22:48.260355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-23T07:22:32.441419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-23T07:22:31.324703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-23T07:22:32.799213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-23T07:22:31.899698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-23T07:22:48.520678image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지형지물부호재질형태경도위도
지형지물부호1.0000.1090.0000.0000.016
재질0.1091.0000.9030.6050.645
형태0.0000.9031.0000.1480.120
경도0.0000.6050.1481.0000.832
위도0.0160.6450.1200.8321.000
2023-12-23T07:22:48.851784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
재질형태지형지물부호
재질1.0000.6050.082
형태0.6051.0000.000
지형지물부호0.0820.0001.000
2023-12-23T07:22:49.316395image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
경도위도지형지물부호재질형태
경도1.000-0.1750.0000.3430.089
위도-0.1751.0000.0160.3860.077
지형지물부호0.0000.0161.0000.0820.000
재질0.3430.3860.0821.0000.605
형태0.0890.0770.0000.6051.000

Missing values

2023-12-23T07:22:33.328820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-23T07:22:34.043830image/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신호등경기도 광주시 태전동 281-16번지경기도 광주시청플라스틱원형127.22696337.3930422023-12-15
1신호등경기도 광주시 태전동 281-16번지경기도 광주시청플라스틱원형127.22697337.3930562023-12-15
2차량진입방지시설경기도 광주시 송정동 148-5번지경기도 광주시청기타원형127.25715337.4193022023-12-15
3차량진입방지시설경기도 광주시 송정동 148-5번지경기도 광주시청기타원형127.25703437.4192952023-12-15
4차량진입방지시설경기도 광주시 탄벌동 701-4번지경기도 광주시청기타원형127.25045937.4158572023-12-15
5차량진입방지시설경기도 광주시 탄벌동 701-4번지경기도 광주시청기타원형127.25047437.4158432023-12-15
6차량진입방지시설경기도 광주시 탄벌동 43-4번지경기도 광주시청기타원형127.25048637.4158332023-12-15
7차량진입방지시설경기도 광주시 탄벌동 701-4번지경기도 광주시청기타원형127.25044637.4158682023-12-15
8차량진입방지시설경기도 광주시 탄벌동 37-33번지경기도 광주시청기타원형127.24967637.4166382023-12-15
9차량진입방지시설경기도 광주시 탄벌동 37-33번지경기도 광주시청기타원형127.24969237.4166232023-12-15
지형지물부호지번주소관리기관재질형태경도위도데이터기준일자
3412차량진입방지시설경기도 광주시 도척면 노곡리 58-47번지경기도 광주시청미분류미분류127.33128337.3037872023-12-15
3413차량진입방지시설경기도 광주시 도척면 노곡리 58-47번지경기도 광주시청미분류미분류127.3313537.3039012023-12-15
3414차량진입방지시설경기도 광주시 도척면 노곡리 58-46번지경기도 광주시청미분류미분류127.33135537.3039142023-12-15
3415차량진입방지시설경기도 광주시 도척면 노곡리 58-46번지경기도 광주시청미분류미분류127.33135837.3039272023-12-15
3416차량진입방지시설경기도 광주시 태전동 704-6번지경기도 광주시청기타원형127.22624337.3780272023-12-15
3417차량진입방지시설경기도 광주시 태전동 704-6번지경기도 광주시청기타원형127.22626137.3780242023-12-15
3418차량진입방지시설경기도 광주시 태전동 704-6번지경기도 광주시청기타원형127.22626237.3781092023-12-15
3419차량진입방지시설경기도 광주시 태전동 704-6번지경기도 광주시청기타원형127.22628137.3781062023-12-15
3420차량진입방지시설경기도 광주시 태전동 63-22번지경기도 광주시청기타원형127.22758337.3779212023-12-15
3421차량진입방지시설경기도 광주시 태전동 산18-7번지경기도 광주시청기타원형127.22772637.3779192023-12-15

Duplicate rows

Most frequently occurring

지형지물부호지번주소관리기관재질형태경도위도데이터기준일자# duplicates
0차량진입방지시설경기도 광주시 곤지암읍 곤지암리 594-56번지경기도 광주시청기타원형127.33904637.3528162023-12-152
1차량진입방지시설경기도 광주시 태전동 702-1번지경기도 광주시청기타원형127.22830637.3801432023-12-152