Overview

Dataset statistics

Number of variables3
Number of observations530
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory13.1 KiB
Average record size in memory25.2 B

Variable types

Text1
Categorical1
Numeric1

Dataset

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

Alerts

지형지물부호 has constant value ""Constant
지리정보(WKT) has unique valuesUnique
굴착위치관리번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 22:49:54.501464
Analysis finished2023-12-12 22:49:54.838093
Duration0.34 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지리정보(WKT)
Text

UNIQUE 

Distinct530
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size4.3 KiB
2023-12-13T07:49:55.065504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length919
Median length839
Mean length103.81132
Min length51

Characters and Unicode

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

Unique530 ?
Unique (%)100.0%

Sample

1st rowMULTILINESTRING ((236418.8 415768.6,236440.5 415752.4))
2nd rowMULTILINESTRING ((239037.5 416178.2,239009.2 416163.2))
3rd rowMULTILINESTRING ((233181.5 417183.0,233153.8 417137.8,233146.6 417119.1,233142.9 417083.6,233154.6 416924.0))
4th rowMULTILINESTRING ((232818.5 416793.4,233046.3 416800.0))
5th rowMULTILINESTRING ((234075.8 418039.5,234078.9 417931.9))
ValueCountFrequency (%)
multilinestring 530
 
14.9%
417340.0,234034.1 3
 
0.1%
416968.4,235850.0 3
 
0.1%
413128.7,239536.2 2
 
0.1%
416458.8,237993.2 2
 
0.1%
415682.3,239305.9 2
 
0.1%
403027.1,240212.2 2
 
0.1%
413818.3,233681.7 2
 
0.1%
417121.7,233349.9 2
 
0.1%
412258.8,240614.7 2
 
0.1%
Other values (2967) 3015
84.6%
2023-12-13T07:49:55.535722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4 5447
 
9.9%
2 5213
 
9.5%
. 4940
 
9.0%
3 4509
 
8.2%
1 4421
 
8.0%
3035
 
5.5%
7 2794
 
5.1%
0 2594
 
4.7%
8 2573
 
4.7%
5 2556
 
4.6%
Other values (15) 16938
30.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 35000
63.6%
Uppercase Letter 7950
 
14.4%
Other Punctuation 6915
 
12.6%
Space Separator 3035
 
5.5%
Open Punctuation 1060
 
1.9%
Close Punctuation 1060
 
1.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 5447
15.6%
2 5213
14.9%
3 4509
12.9%
1 4421
12.6%
7 2794
8.0%
0 2594
7.4%
8 2573
7.4%
5 2556
7.3%
6 2484
7.1%
9 2409
6.9%
Uppercase Letter
ValueCountFrequency (%)
I 1590
20.0%
N 1060
13.3%
T 1060
13.3%
L 1060
13.3%
U 530
 
6.7%
G 530
 
6.7%
R 530
 
6.7%
S 530
 
6.7%
E 530
 
6.7%
M 530
 
6.7%
Other Punctuation
ValueCountFrequency (%)
. 4940
71.4%
, 1975
 
28.6%
Space Separator
ValueCountFrequency (%)
3035
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1060
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1060
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 47070
85.6%
Latin 7950
 
14.4%

Most frequent character per script

Common
ValueCountFrequency (%)
4 5447
11.6%
2 5213
11.1%
. 4940
10.5%
3 4509
9.6%
1 4421
9.4%
3035
 
6.4%
7 2794
 
5.9%
0 2594
 
5.5%
8 2573
 
5.5%
5 2556
 
5.4%
Other values (5) 8988
19.1%
Latin
ValueCountFrequency (%)
I 1590
20.0%
N 1060
13.3%
T 1060
13.3%
L 1060
13.3%
U 530
 
6.7%
G 530
 
6.7%
R 530
 
6.7%
S 530
 
6.7%
E 530
 
6.7%
M 530
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 55020
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 5447
 
9.9%
2 5213
 
9.5%
. 4940
 
9.0%
3 4509
 
8.2%
1 4421
 
8.0%
3035
 
5.5%
7 2794
 
5.1%
0 2594
 
4.7%
8 2573
 
4.7%
5 2556
 
4.6%
Other values (15) 16938
30.8%

지형지물부호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.3 KiB
사업예정지
530 

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 (%)
사업예정지 530
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:49:55.847803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사업예정지 530
100.0%

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

UNIQUE 

Distinct530
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean281.39811
Minimum1
Maximum556
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.8 KiB
2023-12-13T07:49:55.961572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile31.45
Q1143.25
median281.5
Q3421.75
95-th percentile527.55
Maximum556
Range555
Interquartile range (IQR)278.5

Descriptive statistics

Standard deviation160.02368
Coefficient of variation (CV)0.56867361
Kurtosis-1.2058437
Mean281.39811
Median Absolute Deviation (MAD)139.5
Skewness-0.0079857893
Sum149141
Variance25607.578
MonotonicityStrictly increasing
2023-12-13T07:49:56.126016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
372 1
 
0.2%
386 1
 
0.2%
385 1
 
0.2%
384 1
 
0.2%
383 1
 
0.2%
382 1
 
0.2%
381 1
 
0.2%
380 1
 
0.2%
379 1
 
0.2%
Other values (520) 520
98.1%
ValueCountFrequency (%)
1 1
0.2%
2 1
0.2%
3 1
0.2%
4 1
0.2%
5 1
0.2%
6 1
0.2%
7 1
0.2%
8 1
0.2%
9 1
0.2%
10 1
0.2%
ValueCountFrequency (%)
556 1
0.2%
555 1
0.2%
554 1
0.2%
553 1
0.2%
552 1
0.2%
551 1
0.2%
550 1
0.2%
549 1
0.2%
548 1
0.2%
547 1
0.2%

Interactions

2023-12-13T07:49:54.583699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-13T07:49:54.720391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:49:54.804387image/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 ((236418.8 415768.6,236440.5 415752.4))사업예정지1
1MULTILINESTRING ((239037.5 416178.2,239009.2 416163.2))사업예정지2
2MULTILINESTRING ((233181.5 417183.0,233153.8 417137.8,233146.6 417119.1,233142.9 417083.6,233154.6 416924.0))사업예정지3
3MULTILINESTRING ((232818.5 416793.4,233046.3 416800.0))사업예정지4
4MULTILINESTRING ((234075.8 418039.5,234078.9 417931.9))사업예정지5
5MULTILINESTRING ((234297.7 417015.6,234356.1 417015.8))사업예정지6
6MULTILINESTRING ((237751.3 414225.0,237759.9 414233.5))사업예정지7
7MULTILINESTRING ((236171.4 414800.3,236367.8 414605.5))사업예정지8
8MULTILINESTRING ((236957.0 416916.9,237100.6 416890.0,237100.6 416889.5))사업예정지9
9MULTILINESTRING ((241537.6 413794.6,241527.2 413746.6))사업예정지10
지리정보(WKT)지형지물부호굴착위치관리번호
520MULTILINESTRING ((235590.1 413805.7,235475.8 414193.7))사업예정지547
521MULTILINESTRING ((235591.4 413762.0,235568.5 413836.7))사업예정지548
522MULTILINESTRING ((235456.0 414255.2,235446.0 414280.6,235428.6 414288.0))사업예정지549
523MULTILINESTRING ((235420.3 414297.2,235113.0 414405.7))사업예정지550
524MULTILINESTRING ((235729.2 413293.5,235688.6 413433.9))사업예정지551
525MULTILINESTRING ((235732.0 413281.3,235769.2 413140.9))사업예정지552
526MULTILINESTRING ((235414.7 412669.6,235417.4 412677.3,235544.1 412718.6))사업예정지553
527MULTILINESTRING ((235405.2 413352.1,235553.9 413397.8,235548.0 413421.3))사업예정지554
528MULTILINESTRING ((234317.9 414580.2,234442.8 414564.9))사업예정지555
529MULTILINESTRING ((234836.4 414538.2,234853.3 414522.0,234846.7 414502.8,234814.4 414493.8))사업예정지556