Overview

Dataset statistics

Number of variables8
Number of observations7023
Missing cells0
Missing cells (%)0.0%
Duplicate rows15
Duplicate rows (%)0.2%
Total size in memory459.6 KiB
Average record size in memory67.0 B

Variable types

Categorical5
Numeric3

Dataset

Description경기도 광주시 관내 장애인편의시설 현황에 대한 데이터로 지형지물부호, 관리번호, 도로구간번호, 행정구역 등을 제공합니다.
Author경기도 광주시
URLhttps://www.data.go.kr/data/15042242/fileData.do

Alerts

지형지물부호 has constant value ""Constant
관리기관 has constant value ""Constant
Dataset has 15 (0.2%) duplicate rowsDuplicates
법정구역 is highly overall correlated with 도로구간번호 and 1 other fieldsHigh correlation
행정구역 is highly overall correlated with 도로구간번호 and 1 other fieldsHigh correlation
관리번호 is highly overall correlated with 도로구간번호High correlation
도로구간번호 is highly overall correlated with 관리번호 and 2 other fieldsHigh correlation

Reproduction

Analysis started2023-12-16 15:48:16.778345
Analysis finished2023-12-16 15:48:25.278660
Duration8.5 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지형지물부호
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size55.0 KiB
장애인편의시설
7023 

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 (%)
장애인편의시설 7023
100.0%

Length

2023-12-16T15:48:25.641958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:48:26.185160image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
장애인편의시설 7023
100.0%

관리번호
Real number (ℝ)

HIGH CORRELATION 

Distinct6997
Distinct (%)99.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7398204.4
Minimum3
Maximum92014223
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size61.9 KiB
2023-12-16T15:48:26.830493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile633.1
Q12200.5
median4020
Q35803.5
95-th percentile91492906
Maximum92014223
Range92014220
Interquartile range (IQR)3603

Descriptive statistics

Standard deviation24237609
Coefficient of variation (CV)3.2761475
Kurtosis8.0434027
Mean7398204.4
Median Absolute Deviation (MAD)1801
Skewness3.1519233
Sum5.1957589 × 1010
Variance5.874617 × 1014
MonotonicityDecreasing
2023-12-16T15:48:27.872367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
705 7
 
0.1%
719 4
 
0.1%
2841 3
 
< 0.1%
5158 3
 
< 0.1%
471 3
 
< 0.1%
2888 2
 
< 0.1%
1858 2
 
< 0.1%
4109 2
 
< 0.1%
472 2
 
< 0.1%
1533 2
 
< 0.1%
Other values (6987) 6993
99.6%
ValueCountFrequency (%)
3 1
< 0.1%
7 1
< 0.1%
10 1
< 0.1%
11 1
< 0.1%
20 1
< 0.1%
21 1
< 0.1%
22 1
< 0.1%
25 1
< 0.1%
26 1
< 0.1%
29 1
< 0.1%
ValueCountFrequency (%)
92014223 1
< 0.1%
92014222 1
< 0.1%
92014221 1
< 0.1%
92014220 1
< 0.1%
92014218 1
< 0.1%
92014217 1
< 0.1%
92014216 1
< 0.1%
92014215 1
< 0.1%
92014214 1
< 0.1%
92014212 1
< 0.1%

도로구간번호
Real number (ℝ)

HIGH CORRELATION 

Distinct908
Distinct (%)12.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean58631.946
Minimum0
Maximum900352
Zeros21
Zeros (%)0.3%
Negative0
Negative (%)0.0%
Memory size61.9 KiB
2023-12-16T15:48:28.715515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile643
Q15747
median8183
Q39089
95-th percentile262776
Maximum900352
Range900352
Interquartile range (IQR)3342

Descriptive statistics

Standard deviation143626.44
Coefficient of variation (CV)2.4496278
Kurtosis21.764283
Mean58631.946
Median Absolute Deviation (MAD)2134
Skewness4.3922266
Sum4.1177216 × 108
Variance2.0628556 × 1010
MonotonicityNot monotonic
2023-12-16T15:48:29.576586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
9042 137
 
2.0%
8924 100
 
1.4%
9020 81
 
1.2%
8910 78
 
1.1%
8699 65
 
0.9%
7216 62
 
0.9%
360747 62
 
0.9%
8896 55
 
0.8%
121903 53
 
0.8%
7199 47
 
0.7%
Other values (898) 6283
89.5%
ValueCountFrequency (%)
0 21
0.3%
1 24
0.3%
3 1
 
< 0.1%
5 12
0.2%
10 1
 
< 0.1%
12 1
 
< 0.1%
14 1
 
< 0.1%
15 2
 
< 0.1%
18 8
 
0.1%
19 3
 
< 0.1%
ValueCountFrequency (%)
900352 12
0.2%
900349 10
 
0.1%
900346 6
 
0.1%
900345 12
0.2%
900344 6
 
0.1%
900342 16
0.2%
900341 28
0.4%
900261 9
 
0.1%
900259 4
 
0.1%
900256 1
 
< 0.1%

행정구역
Categorical

HIGH CORRELATION 

Distinct16
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size55.0 KiB
경안동
1547 
광남2동
904 
송정동
893 
오포2동
574 
초월읍
557 
Other values (11)
2548 

Length

Max length5
Median length3
Mean length3.4264559
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row송정동
2nd row송정동
3rd row송정동
4th row송정동
5th row광남1동

Common Values

ValueCountFrequency (%)
경안동 1547
22.0%
광남2동 904
12.9%
송정동 893
12.7%
오포2동 574
 
8.2%
초월읍 557
 
7.9%
광남1동 502
 
7.1%
곤지암읍 493
 
7.0%
오포1동 464
 
6.6%
퇴촌면 379
 
5.4%
신현동 237
 
3.4%
Other values (6) 473
 
6.7%

Length

2023-12-16T15:48:30.115678image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경안동 1547
22.0%
광남2동 904
12.9%
송정동 893
12.7%
오포2동 574
 
8.2%
초월읍 557
 
7.9%
광남1동 502
 
7.1%
곤지암읍 493
 
7.0%
오포1동 464
 
6.6%
퇴촌면 379
 
5.4%
신현동 237
 
3.4%
Other values (6) 473
 
6.7%

법정구역
Categorical

HIGH CORRELATION 

Distinct24
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size55.0 KiB
역동
912 
태전동
904 
송정동
712 
양벌동
566 
초월읍
557 
Other values (19)
3372 

Length

Max length5
Median length3
Mean length2.93564
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row송정동
2nd row송정동
3rd row송정동
4th row송정동
5th row장지동

Common Values

ValueCountFrequency (%)
역동 912
13.0%
태전동 904
12.9%
송정동 712
10.1%
양벌동 566
8.1%
초월읍 557
7.9%
곤지암읍 493
 
7.0%
경안동 490
 
7.0%
장지동 397
 
5.7%
퇴촌면 379
 
5.4%
고산동 315
 
4.5%
Other values (14) 1298
18.5%

Length

2023-12-16T15:48:30.733219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
역동 912
13.0%
태전동 904
12.9%
송정동 712
10.1%
양벌동 566
8.1%
초월읍 557
7.9%
곤지암읍 493
 
7.0%
경안동 490
 
7.0%
장지동 397
 
5.7%
퇴촌면 379
 
5.4%
고산동 315
 
4.5%
Other values (14) 1298
18.5%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size55.0 KiB
경기도 광주시청
7023 

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

Length

2023-12-16T15:48:31.206673image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:48:31.808998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 7023
50.0%
광주시청 7023
50.0%

연장(미터)
Real number (ℝ)

Distinct224
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11.448241
Minimum1
Maximum680
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size61.9 KiB
2023-12-16T15:48:32.435092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median2
Q35
95-th percentile54
Maximum680
Range679
Interquartile range (IQR)4

Descriptive statistics

Standard deviation39.232949
Coefficient of variation (CV)3.4269847
Kurtosis77.96722
Mean11.448241
Median Absolute Deviation (MAD)1
Skewness7.6148523
Sum80401
Variance1539.2243
MonotonicityNot monotonic
2023-12-16T15:48:33.203788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 2270
32.3%
2 1546
22.0%
3 685
 
9.8%
4 627
 
8.9%
6 397
 
5.7%
5 253
 
3.6%
7 152
 
2.2%
8 134
 
1.9%
10 73
 
1.0%
9 70
 
1.0%
Other values (214) 816
 
11.6%
ValueCountFrequency (%)
1 2270
32.3%
2 1546
22.0%
3 685
 
9.8%
4 627
 
8.9%
5 253
 
3.6%
6 397
 
5.7%
7 152
 
2.2%
8 134
 
1.9%
9 70
 
1.0%
10 73
 
1.0%
ValueCountFrequency (%)
680 1
< 0.1%
670 1
< 0.1%
635 1
< 0.1%
515 1
< 0.1%
507 2
< 0.1%
504 1
< 0.1%
478 1
< 0.1%
456 1
< 0.1%
449 1
< 0.1%
436 1
< 0.1%

편의시설종류
Categorical

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size55.0 KiB
점형블록
3435 
점선혼합블록
1920 
선형블록
1634 
<NA>
 
27
턱낮추기
 
7

Length

Max length6
Median length4
Mean length4.5467749
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row점형블록
2nd row점형블록
3rd row점형블록
4th row점형블록
5th row선형블록

Common Values

ValueCountFrequency (%)
점형블록 3435
48.9%
점선혼합블록 1920
27.3%
선형블록 1634
23.3%
<NA> 27
 
0.4%
턱낮추기 7
 
0.1%

Length

2023-12-16T15:48:34.008789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:48:34.949141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
점형블록 3435
48.9%
점선혼합블록 1920
27.3%
선형블록 1634
23.3%
na 27
 
0.4%
턱낮추기 7
 
0.1%

Interactions

2023-12-16T15:48:21.655782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:48:18.633696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:48:20.002955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:48:22.306102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:48:19.183146image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:48:20.291701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:48:23.097546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:48:19.632141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:48:20.891805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-16T15:48:35.300990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호도로구간번호행정구역법정구역연장(미터)편의시설종류
관리번호1.0000.8190.5170.7610.0410.140
도로구간번호0.8191.0000.7800.8580.0720.254
행정구역0.5170.7801.0000.9990.1670.446
법정구역0.7610.8580.9991.0000.1450.540
연장(미터)0.0410.0720.1670.1451.0000.188
편의시설종류0.1400.2540.4460.5400.1881.000
2023-12-16T15:48:35.716949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
법정구역행정구역편의시설종류
법정구역1.0000.9530.283
행정구역0.9531.0000.222
편의시설종류0.2830.2221.000
2023-12-16T15:48:36.087804image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호도로구간번호연장(미터)행정구역법정구역편의시설종류
관리번호1.0000.689-0.0100.3290.4970.132
도로구간번호0.6891.0000.0170.5200.5400.166
연장(미터)-0.0100.0171.0000.0690.0550.121
행정구역0.3290.5200.0691.0000.9530.222
법정구역0.4970.5400.0550.9531.0000.283
편의시설종류0.1320.1660.1210.2220.2831.000

Missing values

2023-12-16T15:48:23.930742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-16T15:48:25.011078image/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장애인편의시설92014223900023송정동송정동경기도 광주시청1점형블록
1장애인편의시설92014222900023송정동송정동경기도 광주시청1점형블록
2장애인편의시설92014221900025송정동송정동경기도 광주시청1점형블록
3장애인편의시설92014220900025송정동송정동경기도 광주시청1점형블록
4장애인편의시설92014218160790광남1동장지동경기도 광주시청1선형블록
5장애인편의시설92014217160790광남1동장지동경기도 광주시청2점형블록
6장애인편의시설92014216120975능평동능평동경기도 광주시청147선형블록
7장애인편의시설92014215100200능평동능평동경기도 광주시청1점형블록
8장애인편의시설92014214100200능평동능평동경기도 광주시청2점형블록
9장애인편의시설92014212123200초월읍초월읍경기도 광주시청2선형블록
지형지물부호관리번호도로구간번호행정구역법정구역관리기관연장(미터)편의시설종류
7013장애인편의시설291002송정동탄벌동경기도 광주시청1점형블록
7014장애인편의시설261002송정동탄벌동경기도 광주시청3점형블록
7015장애인편의시설251002송정동탄벌동경기도 광주시청1선형블록
7016장애인편의시설22682송정동탄벌동경기도 광주시청2선형블록
7017장애인편의시설21682송정동탄벌동경기도 광주시청4점형블록
7018장애인편의시설20682송정동탄벌동경기도 광주시청2선형블록
7019장애인편의시설11507경안동경안동경기도 광주시청13점형블록
7020장애인편의시설101449경안동역동경기도 광주시청9점형블록
7021장애인편의시설7931송정동송정동경기도 광주시청5점형블록
7022장애인편의시설318경안동경안동경기도 광주시청4점형블록

Duplicate rows

Most frequently occurring

지형지물부호관리번호도로구간번호행정구역법정구역관리기관연장(미터)편의시설종류# duplicates
2장애인편의시설705360576퇴촌면퇴촌면경기도 광주시청159선형블록7
3장애인편의시설719360576퇴촌면퇴촌면경기도 광주시청168선형블록4
0장애인편의시설471399송정동송정동경기도 광주시청17점형블록3
10장애인편의시설2841162419광남2동태전동경기도 광주시청165선형블록3
14장애인편의시설51588559송정동송정동경기도 광주시청20점선혼합블록3
1장애인편의시설472399송정동송정동경기도 광주시청3선형블록2
4장애인편의시설1188100263신현동신현동경기도 광주시청10점형블록2
5장애인편의시설15332823초월읍초월읍경기도 광주시청180선형블록2
6장애인편의시설18584990광남2동태전동경기도 광주시청152선형블록2
7장애인편의시설19885013광남2동태전동경기도 광주시청184점선혼합블록2