Overview

Dataset statistics

Number of variables3
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory312.5 KiB
Average record size in memory32.0 B

Variable types

Text1
Categorical2

Dataset

Description대전광역시 도로관리시스템에 등재된 도로구간 별 예상 굴착허가청 현황입니다.(도로구간별 폭(추정)에 따라 분류) ※ 2022년 공공데이터 기업 매칭 지원사업으로 청년 인턴을 통해 구축·정비된 데이터입니다. 법적 효력이 없으므로 참고 목적으로만 활용하시기 바랍니다.
Author대전광역시
URLhttps://www.data.go.kr/data/15110393/fileData.do

Alerts

지형지물부호 has constant value ""Constant
지리정보(WKT) has unique valuesUnique

Reproduction

Analysis started2023-12-12 09:59:28.400704
Analysis finished2023-12-12 09:59:29.565375
Duration1.16 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지리정보(WKT)
Text

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T18:59:29.902717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length1024
Median length996
Mean length360.6345
Min length151

Characters and Unicode

Total characters3606345
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

Unique10000 ?
Unique (%)100.0%

Sample

1st rowMULTIPOLYGON (((239022.877986865 416462.299036227,239021.995008797 416453.149021485,239014.752048222 416455.86364923,239017.306962995 416468.62796762,239022.877986865 416462.299036227)))
2nd rowMULTIPOLYGON (((239991.880106472 416693.699959353,239984.510029307 416690.390023773,239971.709141644 416712.817148585,239983.35012876 416719.674099935,239991.880106472 416693.699959353)))
3rd rowMULTIPOLYGON (((239403.898106058 401566.572478806,239404.61298762 401564.792493786,239403.599344107 401564.851795842,239392.120877918 401565.338354566,239390.849306188 401567.166791722,239402.634124263 401566.851085544,239403.898106058 401566.572478806)))
4th rowMULTIPOLYGON (((234167.079982942 415826.990021392,234162.570057503 415823.160076519,234159.00006177 415827.739975463,234163.120125132 415832.130143947,234167.079982942 415826.990021392)))
5th rowMULTIPOLYGON (((230936.927406817 402836.376638722,230933.168991397 402832.715317677,230928.840682817 402828.559750136,230919.370066783 402837.719002848,230922.163987912 402839.942144325,230922.304091853 402840.39905963,230936.927406817 402836.376638722)))
ValueCountFrequency (%)
multipolygon 10000
 
8.2%
236072.501110865 3
 
< 0.1%
409172.95203496 3
 
< 0.1%
238343.060138434 2
 
< 0.1%
235694.140092249 2
 
< 0.1%
411188.910020358 2
 
< 0.1%
237502.361147463 2
 
< 0.1%
236756.880004986 2
 
< 0.1%
416337.461990878 2
 
< 0.1%
235364.79598486 2
 
< 0.1%
Other values (110809) 111569
91.8%
2023-12-12T18:59:30.893918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 415572
11.5%
4 373975
10.4%
1 339426
9.4%
2 339023
9.4%
9 306653
8.5%
3 293969
8.2%
5 250812
7.0%
6 241433
6.7%
7 231862
 
6.4%
8 229306
 
6.4%
Other values (15) 584314
16.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 3022031
83.8%
Other Punctuation 294787
 
8.2%
Uppercase Letter 120000
 
3.3%
Space Separator 111589
 
3.1%
Open Punctuation 30008
 
0.8%
Close Punctuation 27930
 
0.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 415572
13.8%
4 373975
12.4%
1 339426
11.2%
2 339023
11.2%
9 306653
10.1%
3 293969
9.7%
5 250812
8.3%
6 241433
8.0%
7 231862
7.7%
8 229306
7.6%
Uppercase Letter
ValueCountFrequency (%)
O 20000
16.7%
L 20000
16.7%
U 10000
8.3%
N 10000
8.3%
G 10000
8.3%
Y 10000
8.3%
P 10000
8.3%
I 10000
8.3%
T 10000
8.3%
M 10000
8.3%
Other Punctuation
ValueCountFrequency (%)
. 203171
68.9%
, 91616
31.1%
Space Separator
ValueCountFrequency (%)
111589
100.0%
Open Punctuation
ValueCountFrequency (%)
( 30008
100.0%
Close Punctuation
ValueCountFrequency (%)
) 27930
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 3486345
96.7%
Latin 120000
 
3.3%

Most frequent character per script

Common
ValueCountFrequency (%)
0 415572
11.9%
4 373975
10.7%
1 339426
9.7%
2 339023
9.7%
9 306653
8.8%
3 293969
8.4%
5 250812
7.2%
6 241433
6.9%
7 231862
6.7%
8 229306
6.6%
Other values (5) 464314
13.3%
Latin
ValueCountFrequency (%)
O 20000
16.7%
L 20000
16.7%
U 10000
8.3%
N 10000
8.3%
G 10000
8.3%
Y 10000
8.3%
P 10000
8.3%
I 10000
8.3%
T 10000
8.3%
M 10000
8.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3606345
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 415572
11.5%
4 373975
10.4%
1 339426
9.4%
2 339023
9.4%
9 306653
8.5%
3 293969
8.2%
5 250812
7.0%
6 241433
6.7%
7 231862
 
6.4%
8 229306
 
6.4%
Other values (15) 584314
16.2%

행정읍면동
Categorical

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
대전광역시 동구
3245 
대전광역시 중구
3192 
대전광역시 서구
2284 
대전광역시
1162 
대전광역시 대덕구
 
100

Length

Max length9
Median length8
Mean length7.6631
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대전광역시 동구
2nd row대전광역시 동구
3rd row대전광역시 동구
4th row대전광역시 서구
5th row대전광역시 서구

Common Values

ValueCountFrequency (%)
대전광역시 동구 3245
32.5%
대전광역시 중구 3192
31.9%
대전광역시 서구 2284
22.8%
대전광역시 1162
 
11.6%
대전광역시 대덕구 100
 
1.0%
대전광역시 유성구 17
 
0.2%

Length

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

Common Values (Plot)

2023-12-12T18:59:31.241726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대전광역시 10000
53.1%
동구 3245
 
17.2%
중구 3192
 
16.9%
서구 2284
 
12.1%
대덕구 100
 
0.5%
유성구 17
 
0.1%

지형지물부호
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
굴착허가청구역
10000 

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 (%)
굴착허가청구역 10000
100.0%

Length

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

Common Values (Plot)

2023-12-12T18:59:31.512521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
굴착허가청구역 10000
100.0%

Missing values

2023-12-12T18:59:29.379973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:59:29.505857image/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)행정읍면동지형지물부호
16648MULTIPOLYGON (((239022.877986865 416462.299036227,239021.995008797 416453.149021485,239014.752048222 416455.86364923,239017.306962995 416468.62796762,239022.877986865 416462.299036227)))대전광역시 동구굴착허가청구역
11445MULTIPOLYGON (((239991.880106472 416693.699959353,239984.510029307 416690.390023773,239971.709141644 416712.817148585,239983.35012876 416719.674099935,239991.880106472 416693.699959353)))대전광역시 동구굴착허가청구역
2107MULTIPOLYGON (((239403.898106058 401566.572478806,239404.61298762 401564.792493786,239403.599344107 401564.851795842,239392.120877918 401565.338354566,239390.849306188 401567.166791722,239402.634124263 401566.851085544,239403.898106058 401566.572478806)))대전광역시 동구굴착허가청구역
16116MULTIPOLYGON (((234167.079982942 415826.990021392,234162.570057503 415823.160076519,234159.00006177 415827.739975463,234163.120125132 415832.130143947,234167.079982942 415826.990021392)))대전광역시 서구굴착허가청구역
1590MULTIPOLYGON (((230936.927406817 402836.376638722,230933.168991397 402832.715317677,230928.840682817 402828.559750136,230919.370066783 402837.719002848,230922.163987912 402839.942144325,230922.304091853 402840.39905963,230936.927406817 402836.376638722)))대전광역시 서구굴착허가청구역
19154MULTIPOLYGON (((235120.57912766 412426.731971754,235117.406042403 412426.756992507,235094.527974856 412494.92114853,235097.70698761 412495.259113748,235097.920122233 412494.243980875,235120.412093517 412427.228121003,235120.57912766 412426.731971754)))대전광역시 중구굴착허가청구역
14634MULTIPOLYGON (((235797.410102321 415557.067135627,235795.408036096 415559.313148995,235814.78799225 415579.499962107,235816.953059406 415577.422063224,235797.410102321 415557.067135627)))대전광역시 서구굴착허가청구역
6484MULTIPOLYGON (((242753.910046689 408368.440109612,242749.575104025 408361.281018338,242736.549960458 408370.750124895,242712.270105857 408387.390072614,242692.070079722 408401.539989725,242679.95605432 408409.823080476,242656.360035688 408425.390087821,242649.679985233 408428.130006886,242644.359951791 408430.40014007,242636.619032365 408433.025134028,242645.416072896 408440.967994392,242679.91737679 408417.701813514,242694.380004814 408407.950103679,242753.910046689 408368.440109612)))대전광역시 동구굴착허가청구역
14968MULTIPOLYGON (((235252.500118689 414424.910013319,235249.53001892 414424.490085783,235247.439952125 414436.869977822,235250.220067955 414443.27008023,235252.969993444 414442.079981769,235250.54999309 414436.500090895,235252.500118689 414424.910013319)))대전광역시 중구굴착허가청구역
20420MULTIPOLYGON (((237846.962116802 413645.063067073,237845.147986779 413639.595140894,237831.840109558 413640.049979854,237833.192022792 413645.172969403,237834.520007705 413644.280046331,237835.560071573 413643.580118732,237836.500056585 413643.700026889,237846.962116802 413645.063067073)))대전광역시 중구굴착허가청구역
지리정보(WKT)행정읍면동지형지물부호
3906MULTIPOLYGON (((240529.000074679 411518.640091482,240523.95995221 411515.375048167,240510.420033789 411534.71010252,240506.820018799 411535.960052642,240515.590089898 411542.529990573,240514.95012605 411539.099999366,240514.990118914 411538.64000658,240515.259998129 411538.260035667,240529.000074679 411518.640091482)))대전광역시 중구굴착허가청구역
15307MULTIPOLYGON (((235435.989971854 414186.879989958,235434.310002777 414181.200079788,235409.539970035 414185.61997745,235412.110114184 414194.319978881,235435.989971854 414186.879989958)))대전광역시굴착허가청구역
9361MULTIPOLYGON (((238887.490131628 416335.370041639,238879.485024748 416332.053027071,238870.320121947 416352.586108753,238859.224959206 416373.163030192,238865.576989928 416376.201979248,238882.260017419 416342.190147182,238884.670081739 416337.039983766,238886.270147114 416335.419956353,238886.619969339 416335.290108759,238887.490131628 416335.370041639)))대전광역시 동구굴착허가청구역
10174MULTIPOLYGON (((239181.050011295 416424.090142465,239172.924067803 416420.34411609,239173.133121045 416423.717053459,239181.310085726 416427.850110773,239181.050011295 416424.090142465)))대전광역시 동구굴착허가청구역
6913MULTIPOLYGON (((234812.476940767 408035.800821922,234815.0345609 408032.617361099,234813.86301844 408031.676013483,234812.4689757 408030.910092571,234806.5910857 408029.04596413,234803.604072261 408028.530129581,234799.848979825 408029.089990698,234797.635130714 408030.234054739,234790.477070779 408034.653002691,234786.872211482 408036.982294503,234789.043704448 408040.341334539,234790.348013291 408039.498005299,234792.614130205 408038.035074873,234799.605992922 408033.71811283,234801.09499729 408032.949068398,234803.55814826 408032.581022204,234805.641979685 408032.941129455,234810.887032331 408034.605106737,234811.657978852 408035.028065761,234812.076070746 408035.316146304,234812.476940767 408035.800821922)))대전광역시 중구굴착허가청구역
8300MULTIPOLYGON (((241535.180067353 415819.850130124,241528.780107138 415811.449999172,241380.220148552 415920.450030645,241388.850088097 415927.300014822,241535.180067353 415819.850130124)))대전광역시 동구굴착허가청구역
11217MULTIPOLYGON (((240002.893007976 414797.423043317,240001.999972832 414796.310146588,239986.392968961 414776.892088256,239982.886985623 414779.343030426,239996.980072231 414796.180148048,239997.260099969 414796.740037497,239995.999958103 414802.080036146,240002.893007976 414797.423043317)))대전광역시 동구굴착허가청구역
1261MULTIPOLYGON (((230291.784012833 401780.206965763,230290.931086878 401777.4450048,230286.645953258 401779.56501562,230288.169044576 401782.89306916,230291.784012833 401780.206965763)))대전광역시 서구굴착허가청구역
14151MULTIPOLYGON (((235272.710147037 416493.150105983,235272.680070641 416479.390067419,235264.680100529 416478.800057086,235264.710048227 416493.320019763,235272.710147037 416493.150105983)))대전광역시 서구굴착허가청구역
9881MULTIPOLYGON (((239594.611135772 416834.227037849,239594.4381455 416831.232048656,239572.205957768 416832.388004871,239572.362135005 416835.38410755,239594.611135772 416834.227037849)))대전광역시 동구굴착허가청구역