Overview

Dataset statistics

Number of variables3
Number of observations9766
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory238.6 KiB
Average record size in memory25.0 B

Variable types

Text1
Categorical1
Numeric1

Dataset

Description대전광역시 도로관리시스템을 통해서 신청되었던 도로 굴착 예정 지역 목록입니다.(지리정보를 포함한 데이터입니다.)
Author대전광역시
URLhttps://www.data.go.kr/data/15110266/fileData.do

Alerts

지형지물부호 has constant value ""Constant
굴착위치관리번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 09:48:49.197022
Analysis finished2023-12-12 09:48:49.982233
Duration0.79 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지리정보(WKT)
Text

Distinct9744
Distinct (%)99.8%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
2023-12-12T18:48:50.144664image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length1024
Median length983
Mean length99.228036
Min length55

Characters and Unicode

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

Unique

Unique9730 ?
Unique (%)99.6%

Sample

1st rowMULTILINESTRING ((234178.414000001 317232.7291,234178.414 317267.7291))
2nd rowMULTILINESTRING ((235249.7244 326939.923699999,235129.6011 327108.609400001,235116.158999999 327131.9418,235101.904799999 327165.1799,235095.1969 327196.1835,235092.669700001 327228.121,235096.023599999 327262.7557,235104.1344 327296.6186,235115.044400001 327321.5495,235157.985700001 327410.8907))
3rd rowMULTILINESTRING ((234947.291899999 316974.334899999,234947.291899999 316994.3349))
4th rowMULTILINESTRING ((237629.331699999 314147.767899999,237654.238599999 314174.562999999))
5th rowMULTILINESTRING ((240085.7087 318251.685200001,240121.0259 318294.614),(240085.7087 318251.685200001,240112.623599999 318231.222500001,240154.1667 318283.0511,240161.3991 318317.0492),(240072.153500001 318261.9909,240085.7087 318251.685200001),(240030.996899999 318294.1499,240058.011499999 318272.972899999,240140.680499999 318374.361300001),(240030.996899999 318294.1499,240133.1197 318417.930600001),(240029.094999999 318295.640799999,240030.996899999 318294.1499),(240161.3991 318317.0492,240147.3536 318321.6942),(240161.3991 318317.0492,240177.2725 318391.6664))
ValueCountFrequency (%)
multilinestring 9766
 
20.3%
314290.8124),(238536.583700001 6
 
< 0.1%
238600.381900001 6
 
< 0.1%
314427.851900001,238547.092699999 6
 
< 0.1%
314430.809900001,238511.125900001 6
 
< 0.1%
314431.468200001,238509.7355 6
 
< 0.1%
314359.7182),(238509.4261 6
 
< 0.1%
314354.3103,238566.020200001 6
 
< 0.1%
314351.335400001,238553.809700001 6
 
< 0.1%
314280.476000001),(238547.092699999 6
 
< 0.1%
Other values (37826) 38314
79.6%
2023-12-12T18:48:50.560821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
9 124784
12.9%
0 114511
11.8%
3 89335
 
9.2%
1 74609
 
7.7%
2 71166
 
7.3%
. 57206
 
5.9%
4 41378
 
4.3%
7 38922
 
4.0%
38368
 
4.0%
8 38017
 
3.9%
Other values (15) 280765
29.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 666571
68.8%
Uppercase Letter 146490
 
15.1%
Other Punctuation 76056
 
7.8%
Space Separator 38368
 
4.0%
Open Punctuation 20818
 
2.1%
Close Punctuation 20758
 
2.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
9 124784
18.7%
0 114511
17.2%
3 89335
13.4%
1 74609
11.2%
2 71166
10.7%
4 41378
 
6.2%
7 38922
 
5.8%
8 38017
 
5.7%
5 37215
 
5.6%
6 36634
 
5.5%
Uppercase Letter
ValueCountFrequency (%)
I 29298
20.0%
N 19532
13.3%
T 19532
13.3%
L 19532
13.3%
U 9766
 
6.7%
G 9766
 
6.7%
R 9766
 
6.7%
S 9766
 
6.7%
E 9766
 
6.7%
M 9766
 
6.7%
Other Punctuation
ValueCountFrequency (%)
. 57206
75.2%
, 18850
 
24.8%
Space Separator
ValueCountFrequency (%)
38368
100.0%
Open Punctuation
ValueCountFrequency (%)
( 20818
100.0%
Close Punctuation
ValueCountFrequency (%)
) 20758
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 822571
84.9%
Latin 146490
 
15.1%

Most frequent character per script

Common
ValueCountFrequency (%)
9 124784
15.2%
0 114511
13.9%
3 89335
10.9%
1 74609
9.1%
2 71166
8.7%
. 57206
7.0%
4 41378
 
5.0%
7 38922
 
4.7%
38368
 
4.7%
8 38017
 
4.6%
Other values (5) 134275
16.3%
Latin
ValueCountFrequency (%)
I 29298
20.0%
N 19532
13.3%
T 19532
13.3%
L 19532
13.3%
U 9766
 
6.7%
G 9766
 
6.7%
R 9766
 
6.7%
S 9766
 
6.7%
E 9766
 
6.7%
M 9766
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 969061
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
9 124784
12.9%
0 114511
11.8%
3 89335
 
9.2%
1 74609
 
7.7%
2 71166
 
7.3%
. 57206
 
5.9%
4 41378
 
4.3%
7 38922
 
4.0%
38368
 
4.0%
8 38017
 
3.9%
Other values (15) 280765
29.0%

지형지물부호
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
굴착예정지
9766 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row굴착예정지
2nd row굴착예정지
3rd row굴착예정지
4th row굴착예정지
5th row굴착예정지

Common Values

ValueCountFrequency (%)
굴착예정지 9766
100.0%

Length

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

Common Values (Plot)

2023-12-12T18:48:50.801299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
굴착예정지 9766
100.0%

굴착위치관리번호
Real number (ℝ)

UNIQUE 

Distinct9766
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4955.9445
Minimum1
Maximum9916
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size86.0 KiB
2023-12-12T18:48:50.899539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile490.25
Q12443.25
median4975.5
Q37470.75
95-th percentile9427.75
Maximum9916
Range9915
Interquartile range (IQR)5027.5

Descriptive statistics

Standard deviation2881.9122
Coefficient of variation (CV)0.58150615
Kurtosis-1.2227939
Mean4955.9445
Median Absolute Deviation (MAD)2514
Skewness0.0020835997
Sum48399754
Variance8305418
MonotonicityNot monotonic
2023-12-12T18:48:51.038191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1000 1
 
< 0.1%
6657 1
 
< 0.1%
6650 1
 
< 0.1%
6651 1
 
< 0.1%
6652 1
 
< 0.1%
6653 1
 
< 0.1%
6654 1
 
< 0.1%
6655 1
 
< 0.1%
6656 1
 
< 0.1%
6658 1
 
< 0.1%
Other values (9756) 9756
99.9%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
9916 1
< 0.1%
9915 1
< 0.1%
9914 1
< 0.1%
9913 1
< 0.1%
9912 1
< 0.1%
9911 1
< 0.1%
9910 1
< 0.1%
9909 1
< 0.1%
9908 1
< 0.1%
9907 1
< 0.1%

Interactions

2023-12-12T18:48:49.678679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-12T18:48:49.808066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:48:49.925275image/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

지리정보(WKT)지형지물부호굴착위치관리번호
0MULTILINESTRING ((234178.414000001 317232.7291,234178.414 317267.7291))굴착예정지1000
1MULTILINESTRING ((235249.7244 326939.923699999,235129.6011 327108.609400001,235116.158999999 327131.9418,235101.904799999 327165.1799,235095.1969 327196.1835,235092.669700001 327228.121,235096.023599999 327262.7557,235104.1344 327296.6186,235115.044400001 327321.5495,235157.985700001 327410.8907))굴착예정지999
2MULTILINESTRING ((234947.291899999 316974.334899999,234947.291899999 316994.3349))굴착예정지998
3MULTILINESTRING ((237629.331699999 314147.767899999,237654.238599999 314174.562999999))굴착예정지997
4MULTILINESTRING ((240085.7087 318251.685200001,240121.0259 318294.614),(240085.7087 318251.685200001,240112.623599999 318231.222500001,240154.1667 318283.0511,240161.3991 318317.0492),(240072.153500001 318261.9909,240085.7087 318251.685200001),(240030.996899999 318294.1499,240058.011499999 318272.972899999,240140.680499999 318374.361300001),(240030.996899999 318294.1499,240133.1197 318417.930600001),(240029.094999999 318295.640799999,240030.996899999 318294.1499),(240161.3991 318317.0492,240147.3536 318321.6942),(240161.3991 318317.0492,240177.2725 318391.6664))굴착예정지996
5MULTILINESTRING ((239872.829199999 317827.5297,239918.888600001 317962.455399999),(239918.888600001 317962.455399999,239935.192900001 318010.217,239901.934699999 318036.057),(239860.3178 317983.359899999,239874.793600001 317978.193299999,239918.888600001 317962.455399999),(239875.2234 318093.8167,239901.561900001 318165.4395))굴착예정지995
6MULTILINESTRING ((239581.0934 317673.928899999,239593.344600001 317651.5933,239597.8974 317647.043500001,239601.705200001 317644.644499999,239627.551699999 317632.294399999,239690.8131 317629.472899999,239695.391699999 317627.6405),(239718.2268 317677.289300001,239751.252500001 317750.998600001))굴착예정지994
7MULTILINESTRING ((239643.264299999 317222.300699999,239700.8901 317193.456599999),(239645.4743 317387.5592,239651.0995 317478.4431))굴착예정지993
8MULTILINESTRING ((240699.1824 317476.382200002,240722.5412 317528.4049),(240911.0282 317505.700200001,240955.068499999 317484.6546),(240387.940299999 317568.752,240408.7681 317559.1496,240422.6784 317552.736500001),(240951.0885 317572.5206,240975.625699999 317594.873500001,240988.2314 317604.458500001,241009.1953 317616.3713),(240517.8339 317595.626700001,240559.125400001 317577.9274),(240435.308600001 317632.890599999,240468.2058 317618.0333),(240583.323600001 317652.345200001,240596.4155 317646.6973,240591.98 317636.9026),(240895.0317 317722.318800001,240890.3513 317711.4989,240885.7704 317700.909200001),(240595.0905 317732.593100001,240597.3246 317731.555000001,240624.1469 317719.090800001),(240650.104399999 317766.237500001,240658.3095 317784.032400001),(240484.532300001 317782.755000002,240508.3228 317772.0238),(240239.720599999 317806.709499999,240280.6759 317787.7552),(240123.110700001 317865.341399999,240140.834800001 317852.030800001))굴착예정지992
9MULTILINESTRING ((232507.287700001 317675.6657,232500.2877 317675.6657))굴착예정지991
지리정보(WKT)지형지물부호굴착위치관리번호
9756MULTILINESTRING ((239112.4 315932.4,239114.900000001 315934.1))굴착예정지9907
9757MULTILINESTRING ((239137.800000001 315955.4,239142.099999999 315958.0))굴착예정지9908
9758MULTILINESTRING ((233149.999999999 316269.9,233155.3 316271.7))굴착예정지9909
9759MULTILINESTRING ((235250.8 314917.1,235256.400000001 314911.5))굴착예정지9910
9760MULTILINESTRING ((234620.100000001 324955.899999999,234630.699999999 324951.2))굴착예정지9911
9761MULTILINESTRING ((234797.500000001 325287.8,234804.899999999 325283.799999999))굴착예정지9912
9762MULTILINESTRING ((235884.600000001 321403.9,235907.900000001 321404.0))굴착예정지9913
9763MULTILINESTRING ((238319.1 319965.1,238320.4 319957.7))굴착예정지9914
9764MULTILINESTRING ((238312.1 319993.6,238312.9 319990.0))굴착예정지9915
9765MULTILINESTRING ((232266.499999999 312988.1,232274.799999999 312992.199999999))굴착예정지9916