Overview

Dataset statistics

Number of variables16
Number of observations58
Missing cells283
Missing cells (%)30.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.7 KiB
Average record size in memory135.3 B

Variable types

Numeric2
Text5
DateTime6
Unsupported2
Categorical1

Dataset

Description경상북도개발공사에서 실시한 보상관련 공고에 대한 테이블 보상계획번호, 사업명, 보상공고명, 공고일자 개별통보일자 등 보상 계획 공고에 대한 데이터 포함
URLhttps://www.data.go.kr/data/15120639/fileData.do

Alerts

보상계획번호 is highly overall correlated with 사업코드High correlation
사업코드 is highly overall correlated with 보상계획번호High correlation
공고일자 has 8 (13.8%) missing valuesMissing
개별통보일자 has 24 (41.4%) missing valuesMissing
공람신청시작일자 has 26 (44.8%) missing valuesMissing
공람신청종료일자 has 26 (44.8%) missing valuesMissing
신문공고여부 has 58 (100.0%) missing valuesMissing
보상사무실명 has 36 (62.1%) missing valuesMissing
공람장소명 has 26 (44.8%) missing valuesMissing
공고번호 has 21 (36.2%) missing valuesMissing
비고 has 58 (100.0%) missing valuesMissing
보상계획번호 has unique valuesUnique
신문공고여부 is an unsupported type, check if it needs cleaning or further analysisUnsupported
비고 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 12:57:43.899452
Analysis finished2023-12-12 12:57:46.095486
Duration2.2 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

보상계획번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct58
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6717.5862
Minimum83
Maximum12420
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size654.0 B
2023-12-12T21:57:46.179602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum83
5-th percentile925.4
Q11514.5
median7214.5
Q311163
95-th percentile12417.15
Maximum12420
Range12337
Interquartile range (IQR)9648.5

Descriptive statistics

Standard deviation4460.8038
Coefficient of variation (CV)0.66404861
Kurtosis-1.5370857
Mean6717.5862
Median Absolute Deviation (MAD)4299
Skewness-0.13557668
Sum389620
Variance19898770
MonotonicityNot monotonic
2023-12-12T21:57:46.329508image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3015 1
 
1.7%
10814 1
 
1.7%
2813 1
 
1.7%
6013 1
 
1.7%
8413 1
 
1.7%
8213 1
 
1.7%
11013 1
 
1.7%
11214 1
 
1.7%
1415 1
 
1.7%
5813 1
 
1.7%
Other values (48) 48
82.8%
ValueCountFrequency (%)
83 1
1.7%
86 1
1.7%
429 1
1.7%
1013 1
1.7%
1014 1
1.7%
1015 1
1.7%
1016 1
1.7%
1017 1
1.7%
1019 1
1.7%
1020 1
1.7%
ValueCountFrequency (%)
12420 1
1.7%
12419 1
1.7%
12418 1
1.7%
12417 1
1.7%
12416 1
1.7%
12415 1
1.7%
12414 1
1.7%
12413 1
1.7%
12213 1
1.7%
12013 1
1.7%

사업코드
Real number (ℝ)

HIGH CORRELATION 

Distinct52
Distinct (%)89.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1972340
Minimum1010051
Maximum3100010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size654.0 B
2023-12-12T21:57:46.494005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1010051
5-th percentile1013073.6
Q12016060
median2020016.5
Q32023006.8
95-th percentile3053061
Maximum3100010
Range2089959
Interquartile range (IQR)6946.75

Descriptive statistics

Standard deviation444392.46
Coefficient of variation (CV)0.22531229
Kurtosis2.6217866
Mean1972340
Median Absolute Deviation (MAD)3004
Skewness-0.12177568
Sum1.1439572 × 108
Variance1.9748466 × 1011
MonotonicityNot monotonic
2023-12-12T21:57:46.657211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2016060 3
 
5.2%
2018002 2
 
3.4%
2020017 2
 
3.4%
2015060 2
 
3.4%
2015040 2
 
3.4%
2018003 1
 
1.7%
2020010 1
 
1.7%
2023026 1
 
1.7%
2017007 1
 
1.7%
2018004 1
 
1.7%
Other values (42) 42
72.4%
ValueCountFrequency (%)
1010051 1
1.7%
1013020 1
1.7%
1013060 1
1.7%
1013076 1
1.7%
1015011 1
1.7%
1050070 1
1.7%
1060020 1
1.7%
2004410 1
1.7%
2014010 1
1.7%
2015040 2
3.4%
ValueCountFrequency (%)
3100010 1
1.7%
3080010 1
1.7%
3070010 1
1.7%
3050070 1
1.7%
2023027 1
1.7%
2023026 1
1.7%
2023025 1
1.7%
2023024 1
1.7%
2023023 1
1.7%
2023022 1
1.7%
Distinct52
Distinct (%)89.7%
Missing0
Missing (%)0.0%
Memory size596.0 B
2023-12-12T21:57:46.887211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length24
Mean length17.12069
Min length4

Characters and Unicode

Total characters993
Distinct characters158
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique47 ?
Unique (%)81.0%

Sample

1st row경산 도시계획시설(도로)사업(정평동)
2nd row안심~하양 복선전철 건설사업
3rd row자명천(자명지구) 하천재해예방사업
4th row초곡천(초곡2지구) 하천재해예방사업
5th row안림천(대가야,쌍림지구) 하천재해예방사업
ValueCountFrequency (%)
재해복구사업 9
 
6.2%
하천재해예방사업 9
 
6.2%
개설공사 6
 
4.2%
진입도로 5
 
3.5%
도시개발사업 4
 
2.8%
건설사업 4
 
2.8%
조성사업 3
 
2.1%
건설공사 3
 
2.1%
경산지식산업지구 3
 
2.1%
포항초곡지구 3
 
2.1%
Other values (85) 95
66.0%
2023-12-12T21:57:47.267652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
86
 
8.7%
55
 
5.5%
48
 
4.8%
42
 
4.2%
37
 
3.7%
37
 
3.7%
33
 
3.3%
25
 
2.5%
( 23
 
2.3%
) 23
 
2.3%
Other values (148) 584
58.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 811
81.7%
Space Separator 86
 
8.7%
Decimal Number 27
 
2.7%
Open Punctuation 23
 
2.3%
Close Punctuation 23
 
2.3%
Math Symbol 8
 
0.8%
Other Punctuation 7
 
0.7%
Dash Punctuation 6
 
0.6%
Uppercase Letter 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
55
 
6.8%
48
 
5.9%
42
 
5.2%
37
 
4.6%
37
 
4.6%
33
 
4.1%
25
 
3.1%
22
 
2.7%
21
 
2.6%
20
 
2.5%
Other values (130) 471
58.1%
Decimal Number
ValueCountFrequency (%)
1 8
29.6%
2 6
22.2%
3 4
14.8%
7 3
 
11.1%
4 2
 
7.4%
9 2
 
7.4%
6 1
 
3.7%
5 1
 
3.7%
Other Punctuation
ValueCountFrequency (%)
, 5
71.4%
& 1
 
14.3%
· 1
 
14.3%
Uppercase Letter
ValueCountFrequency (%)
R 1
50.0%
D 1
50.0%
Space Separator
ValueCountFrequency (%)
86
100.0%
Open Punctuation
ValueCountFrequency (%)
( 23
100.0%
Close Punctuation
ValueCountFrequency (%)
) 23
100.0%
Math Symbol
ValueCountFrequency (%)
~ 8
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 811
81.7%
Common 180
 
18.1%
Latin 2
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
55
 
6.8%
48
 
5.9%
42
 
5.2%
37
 
4.6%
37
 
4.6%
33
 
4.1%
25
 
3.1%
22
 
2.7%
21
 
2.6%
20
 
2.5%
Other values (130) 471
58.1%
Common
ValueCountFrequency (%)
86
47.8%
( 23
 
12.8%
) 23
 
12.8%
~ 8
 
4.4%
1 8
 
4.4%
2 6
 
3.3%
- 6
 
3.3%
, 5
 
2.8%
3 4
 
2.2%
7 3
 
1.7%
Other values (6) 8
 
4.4%
Latin
ValueCountFrequency (%)
R 1
50.0%
D 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 811
81.7%
ASCII 181
 
18.2%
None 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
86
47.5%
( 23
 
12.7%
) 23
 
12.7%
~ 8
 
4.4%
1 8
 
4.4%
2 6
 
3.3%
- 6
 
3.3%
, 5
 
2.8%
3 4
 
2.2%
7 3
 
1.7%
Other values (7) 9
 
5.0%
Hangul
ValueCountFrequency (%)
55
 
6.8%
48
 
5.9%
42
 
5.2%
37
 
4.6%
37
 
4.6%
33
 
4.1%
25
 
3.1%
22
 
2.7%
21
 
2.6%
20
 
2.5%
Other values (130) 471
58.1%
None
ValueCountFrequency (%)
· 1
100.0%
Distinct47
Distinct (%)81.0%
Missing0
Missing (%)0.0%
Memory size596.0 B
2023-12-12T21:57:47.531995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length38
Median length30
Mean length19.103448
Min length7

Characters and Unicode

Total characters1108
Distinct characters159
Distinct categories8 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique46 ?
Unique (%)79.3%

Sample

1st row경산도시계획시설사업(도로) 보상계획 열람
2nd row현장안내 안내문
3rd row자명천(자명지구) 하천재해예방사업 보상계획 열람 공고
4th row초곡천(초곡2지구)하천재해예방사업 보상계획열람공고
5th row편입토지 제외
ValueCountFrequency (%)
보상계획 30
 
15.7%
열람공고 20
 
10.5%
재해복구사업 9
 
4.7%
열람 9
 
4.7%
하천재해예방사업 7
 
3.7%
공고 7
 
3.7%
개설공사 5
 
2.6%
진입도로 4
 
2.1%
보상계획열람공고 4
 
2.1%
건설사업 4
 
2.1%
Other values (81) 92
48.2%
2023-12-12T21:57:47.947350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
134
 
12.1%
44
 
4.0%
43
 
3.9%
42
 
3.8%
42
 
3.8%
41
 
3.7%
39
 
3.5%
37
 
3.3%
35
 
3.2%
35
 
3.2%
Other values (149) 616
55.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 903
81.5%
Space Separator 134
 
12.1%
Close Punctuation 20
 
1.8%
Open Punctuation 20
 
1.8%
Decimal Number 17
 
1.5%
Math Symbol 8
 
0.7%
Other Punctuation 4
 
0.4%
Dash Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
44
 
4.9%
43
 
4.8%
42
 
4.7%
42
 
4.7%
41
 
4.5%
39
 
4.3%
37
 
4.1%
35
 
3.9%
35
 
3.9%
33
 
3.7%
Other values (132) 512
56.7%
Decimal Number
ValueCountFrequency (%)
2 5
29.4%
1 3
17.6%
7 2
 
11.8%
9 2
 
11.8%
3 2
 
11.8%
6 1
 
5.9%
0 1
 
5.9%
4 1
 
5.9%
Close Punctuation
ValueCountFrequency (%)
) 19
95.0%
1
 
5.0%
Open Punctuation
ValueCountFrequency (%)
( 19
95.0%
1
 
5.0%
Other Punctuation
ValueCountFrequency (%)
, 3
75.0%
· 1
 
25.0%
Space Separator
ValueCountFrequency (%)
134
100.0%
Math Symbol
ValueCountFrequency (%)
~ 8
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 903
81.5%
Common 205
 
18.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
44
 
4.9%
43
 
4.8%
42
 
4.7%
42
 
4.7%
41
 
4.5%
39
 
4.3%
37
 
4.1%
35
 
3.9%
35
 
3.9%
33
 
3.7%
Other values (132) 512
56.7%
Common
ValueCountFrequency (%)
134
65.4%
) 19
 
9.3%
( 19
 
9.3%
~ 8
 
3.9%
2 5
 
2.4%
, 3
 
1.5%
1 3
 
1.5%
- 2
 
1.0%
7 2
 
1.0%
9 2
 
1.0%
Other values (7) 8
 
3.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 903
81.5%
ASCII 202
 
18.2%
None 3
 
0.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
134
66.3%
) 19
 
9.4%
( 19
 
9.4%
~ 8
 
4.0%
2 5
 
2.5%
, 3
 
1.5%
1 3
 
1.5%
- 2
 
1.0%
7 2
 
1.0%
9 2
 
1.0%
Other values (4) 5
 
2.5%
Hangul
ValueCountFrequency (%)
44
 
4.9%
43
 
4.8%
42
 
4.7%
42
 
4.7%
41
 
4.5%
39
 
4.3%
37
 
4.1%
35
 
3.9%
35
 
3.9%
33
 
3.7%
Other values (132) 512
56.7%
None
ValueCountFrequency (%)
· 1
33.3%
1
33.3%
1
33.3%

공고일자
Date

MISSING 

Distinct38
Distinct (%)76.0%
Missing8
Missing (%)13.8%
Memory size596.0 B
Minimum2015-06-30 00:00:00
Maximum2023-07-28 00:00:00
2023-12-12T21:57:48.071039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:57:48.191711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=38)

개별통보일자
Date

MISSING 

Distinct31
Distinct (%)91.2%
Missing24
Missing (%)41.4%
Memory size596.0 B
Minimum2015-06-29 00:00:00
Maximum2023-07-27 00:00:00
2023-12-12T21:57:48.301939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:57:48.419732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)
Distinct27
Distinct (%)84.4%
Missing26
Missing (%)44.8%
Memory size596.0 B
Minimum2015-06-30 00:00:00
Maximum2023-07-28 00:00:00
2023-12-12T21:57:48.543956image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:57:48.670733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
Distinct25
Distinct (%)78.1%
Missing26
Missing (%)44.8%
Memory size596.0 B
Minimum2015-07-14 00:00:00
Maximum2023-08-11 00:00:00
2023-12-12T21:57:48.812078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:57:48.939066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)

신문공고여부
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing58
Missing (%)100.0%
Memory size654.0 B

보상사무실명
Text

MISSING 

Distinct18
Distinct (%)81.8%
Missing36
Missing (%)62.1%
Memory size596.0 B
2023-12-12T21:57:49.137710image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length14
Mean length9
Min length2

Characters and Unicode

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

Unique

Unique14 ?
Unique (%)63.6%

Sample

1st row경산보상사무소
2nd row본사 및 시공사 현장사무소
3rd row본사 및 현장사무소
4th row공사
5th row공사 단지개발팀
ValueCountFrequency (%)
공사 7
 
15.2%
본사 7
 
15.2%
3
 
6.5%
현장사무소 3
 
6.5%
시공사 2
 
4.3%
경산통합사무실 2
 
4.3%
사무실 1
 
2.2%
경산보상사무소 1
 
2.2%
영덕사무실 1
 
2.2%
동남권보상사무소(포항 1
 
2.2%
Other values (18) 18
39.1%
2023-12-12T21:57:49.439475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
32
16.2%
24
 
12.1%
15
 
7.6%
10
 
5.1%
9
 
4.5%
9
 
4.5%
8
 
4.0%
7
 
3.5%
7
 
3.5%
6
 
3.0%
Other values (41) 71
35.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 167
84.3%
Space Separator 24
 
12.1%
Decimal Number 3
 
1.5%
Other Punctuation 2
 
1.0%
Close Punctuation 1
 
0.5%
Open Punctuation 1
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
32
19.2%
15
 
9.0%
10
 
6.0%
9
 
5.4%
9
 
5.4%
8
 
4.8%
7
 
4.2%
7
 
4.2%
6
 
3.6%
5
 
3.0%
Other values (34) 59
35.3%
Decimal Number
ValueCountFrequency (%)
3 1
33.3%
1 1
33.3%
5 1
33.3%
Space Separator
ValueCountFrequency (%)
24
100.0%
Other Punctuation
ValueCountFrequency (%)
, 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 167
84.3%
Common 31
 
15.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
32
19.2%
15
 
9.0%
10
 
6.0%
9
 
5.4%
9
 
5.4%
8
 
4.8%
7
 
4.2%
7
 
4.2%
6
 
3.6%
5
 
3.0%
Other values (34) 59
35.3%
Common
ValueCountFrequency (%)
24
77.4%
, 2
 
6.5%
) 1
 
3.2%
( 1
 
3.2%
3 1
 
3.2%
1 1
 
3.2%
5 1
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 167
84.3%
ASCII 31
 
15.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
32
19.2%
15
 
9.0%
10
 
6.0%
9
 
5.4%
9
 
5.4%
8
 
4.8%
7
 
4.2%
7
 
4.2%
6
 
3.6%
5
 
3.0%
Other values (34) 59
35.3%
ASCII
ValueCountFrequency (%)
24
77.4%
, 2
 
6.5%
) 1
 
3.2%
( 1
 
3.2%
3 1
 
3.2%
1 1
 
3.2%
5 1
 
3.2%

공람장소명
Text

MISSING 

Distinct28
Distinct (%)87.5%
Missing26
Missing (%)44.8%
Memory size596.0 B
2023-12-12T21:57:49.664431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length18
Mean length13.46875
Min length3

Characters and Unicode

Total characters431
Distinct characters77
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique26 ?
Unique (%)81.2%

Sample

1st row경상보상사무소 및 경산시청
2nd row경산통합사무실
3rd row본사, 포항시 푸른도시사업단 생태하천과, 홈페이지
4th row성주군청 건설안전과, 공사
5th row포항시 및 영천시
ValueCountFrequency (%)
본사 7
 
8.6%
공사 5
 
6.2%
공사홈페이지 5
 
6.2%
경산시청 4
 
4.9%
경주시청 3
 
3.7%
경산시 3
 
3.7%
3
 
3.7%
경산통합사무실 3
 
3.7%
포항시 3
 
3.7%
홈페이지 3
 
3.7%
Other values (40) 42
51.9%
2023-12-12T21:57:50.102746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
49
 
11.4%
36
 
8.4%
, 30
 
7.0%
22
 
5.1%
21
 
4.9%
15
 
3.5%
15
 
3.5%
12
 
2.8%
12
 
2.8%
11
 
2.6%
Other values (67) 208
48.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 352
81.7%
Space Separator 49
 
11.4%
Other Punctuation 30
 
7.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
36
 
10.2%
22
 
6.2%
21
 
6.0%
15
 
4.3%
15
 
4.3%
12
 
3.4%
12
 
3.4%
11
 
3.1%
10
 
2.8%
9
 
2.6%
Other values (65) 189
53.7%
Space Separator
ValueCountFrequency (%)
49
100.0%
Other Punctuation
ValueCountFrequency (%)
, 30
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 352
81.7%
Common 79
 
18.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
36
 
10.2%
22
 
6.2%
21
 
6.0%
15
 
4.3%
15
 
4.3%
12
 
3.4%
12
 
3.4%
11
 
3.1%
10
 
2.8%
9
 
2.6%
Other values (65) 189
53.7%
Common
ValueCountFrequency (%)
49
62.0%
, 30
38.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 352
81.7%
ASCII 79
 
18.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
49
62.0%
, 30
38.0%
Hangul
ValueCountFrequency (%)
36
 
10.2%
22
 
6.2%
21
 
6.0%
15
 
4.3%
15
 
4.3%
12
 
3.4%
12
 
3.4%
11
 
3.1%
10
 
2.8%
9
 
2.6%
Other values (65) 189
53.7%
Distinct5
Distinct (%)8.6%
Missing0
Missing (%)0.0%
Memory size596.0 B
1
43 
<NA>
2
5
 
1
3
 
1

Length

Max length4
Median length1
Mean length1.4137931
Min length1

Unique

Unique2 ?
Unique (%)3.4%

Sample

1st row1
2nd row2
3rd row1
4th row1
5th row2

Common Values

ValueCountFrequency (%)
1 43
74.1%
<NA> 8
 
13.8%
2 5
 
8.6%
5 1
 
1.7%
3 1
 
1.7%

Length

2023-12-12T21:57:50.260648image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:57:50.387207image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 43
74.1%
na 8
 
13.8%
2 5
 
8.6%
5 1
 
1.7%
3 1
 
1.7%

공고번호
Text

MISSING 

Distinct34
Distinct (%)91.9%
Missing21
Missing (%)36.2%
Memory size596.0 B
2023-12-12T21:57:50.595818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length13
Mean length11.891892
Min length7

Characters and Unicode

Total characters440
Distinct characters26
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

Unique31 ?
Unique (%)83.8%

Sample

1st row보상파트-135
2nd row경상북도개발공사 공고 제2020-72
3rd row2021-23
4th row2021-93
5th row제2022-043호
ValueCountFrequency (%)
경상북도개발공사 10
 
17.2%
공고 10
 
17.2%
제2023-03 2
 
3.4%
2019-021 2
 
3.4%
2023-023 2
 
3.4%
제2023-060 1
 
1.7%
제2023-2호 1
 
1.7%
제2021-004호 1
 
1.7%
제2016-71호 1
 
1.7%
2023-057 1
 
1.7%
Other values (27) 27
46.6%
2023-12-12T21:57:51.001591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 80
18.2%
0 69
15.7%
- 37
 
8.4%
3 25
 
5.7%
25
 
5.7%
1 21
 
4.8%
21
 
4.8%
20
 
4.5%
16
 
3.6%
11
 
2.5%
Other values (16) 115
26.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 237
53.9%
Other Letter 145
33.0%
Dash Punctuation 37
 
8.4%
Space Separator 21
 
4.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
25
17.2%
20
13.8%
16
11.0%
11
7.6%
10
 
6.9%
10
 
6.9%
10
 
6.9%
10
 
6.9%
10
 
6.9%
10
 
6.9%
Other values (4) 13
9.0%
Decimal Number
ValueCountFrequency (%)
2 80
33.8%
0 69
29.1%
3 25
 
10.5%
1 21
 
8.9%
5 10
 
4.2%
4 9
 
3.8%
8 7
 
3.0%
7 6
 
2.5%
9 5
 
2.1%
6 5
 
2.1%
Dash Punctuation
ValueCountFrequency (%)
- 37
100.0%
Space Separator
ValueCountFrequency (%)
21
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 295
67.0%
Hangul 145
33.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
25
17.2%
20
13.8%
16
11.0%
11
7.6%
10
 
6.9%
10
 
6.9%
10
 
6.9%
10
 
6.9%
10
 
6.9%
10
 
6.9%
Other values (4) 13
9.0%
Common
ValueCountFrequency (%)
2 80
27.1%
0 69
23.4%
- 37
12.5%
3 25
 
8.5%
1 21
 
7.1%
21
 
7.1%
5 10
 
3.4%
4 9
 
3.1%
8 7
 
2.4%
7 6
 
2.0%
Other values (2) 10
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 295
67.0%
Hangul 145
33.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 80
27.1%
0 69
23.4%
- 37
12.5%
3 25
 
8.5%
1 21
 
7.1%
21
 
7.1%
5 10
 
3.4%
4 9
 
3.1%
8 7
 
2.4%
7 6
 
2.0%
Other values (2) 10
 
3.4%
Hangul
ValueCountFrequency (%)
25
17.2%
20
13.8%
16
11.0%
11
7.6%
10
 
6.9%
10
 
6.9%
10
 
6.9%
10
 
6.9%
10
 
6.9%
10
 
6.9%
Other values (4) 13
9.0%

비고
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing58
Missing (%)100.0%
Memory size654.0 B
Distinct48
Distinct (%)82.8%
Missing0
Missing (%)0.0%
Memory size596.0 B
Minimum2016-11-29 20:56:00
Maximum2023-07-26 20:35:00
2023-12-12T21:57:51.173076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:57:51.318394image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=48)
Distinct48
Distinct (%)82.8%
Missing0
Missing (%)0.0%
Memory size596.0 B
Minimum2016-11-29 20:56:00
Maximum2023-07-26 20:35:00
2023-12-12T21:57:51.463330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:57:51.635972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=48)

Interactions

2023-12-12T21:57:44.995988image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:57:44.806624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:57:45.090638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:57:44.896468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T21:57:51.785401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
보상계획번호사업코드사업명공고명공고일자개별통보일자공람신청시작일자공람신청종료일자보상사무실명공람장소명계획일련번호코드공고번호입력일시수정일시
보상계획번호1.0000.4850.9170.9910.9911.0001.0000.9800.9970.9810.2301.0001.0001.000
사업코드0.4851.0001.0000.0001.0001.0001.0001.0000.0000.0000.3431.0000.0000.000
사업명0.9171.0001.0000.2330.9600.9740.8910.9270.9270.9710.0000.9660.6490.649
공고명0.9910.0000.2331.0000.8810.9740.9610.9481.0000.9660.0000.9781.0001.000
공고일자0.9911.0000.9600.8811.0001.0001.0001.0000.9440.9930.9631.0000.9550.955
개별통보일자1.0001.0000.9740.9741.0001.0001.0001.0000.9760.9971.0001.0000.9740.974
공람신청시작일자1.0001.0000.8910.9611.0001.0001.0001.0001.0001.0001.0001.0001.0001.000
공람신청종료일자0.9801.0000.9270.9481.0001.0001.0001.0000.9670.9970.0001.0001.0001.000
보상사무실명0.9970.0000.9271.0000.9440.9761.0000.9671.0001.0001.0000.9701.0001.000
공람장소명0.9810.0000.9710.9660.9930.9971.0000.9971.0001.0000.6830.9891.0001.000
계획일련번호코드0.2300.3430.0000.0000.9631.0001.0000.0001.0000.6831.0001.0000.0000.000
공고번호1.0001.0000.9660.9781.0001.0001.0001.0000.9700.9891.0001.0001.0001.000
입력일시1.0000.0000.6491.0000.9550.9741.0001.0001.0001.0000.0001.0001.0001.000
수정일시1.0000.0000.6491.0000.9550.9741.0001.0001.0001.0000.0001.0001.0001.000
2023-12-12T21:57:51.961871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
보상계획번호사업코드계획일련번호코드
보상계획번호1.0000.5740.114
사업코드0.5741.0000.326
계획일련번호코드0.1140.3261.000

Missing values

2023-12-12T21:57:45.230844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:57:45.473191image/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.
2023-12-12T21:57:45.995560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

보상계획번호사업코드사업명공고명공고일자개별통보일자공람신청시작일자공람신청종료일자신문공고여부보상사무실명공람장소명계획일련번호코드공고번호비고입력일시수정일시
030152018003경산 도시계획시설(도로)사업(정평동)경산도시계획시설사업(도로) 보상계획 열람2018-06-202018-06-19<NA><NA><NA>경산보상사무소경상보상사무소 및 경산시청1<NA><NA>2018-06-18 14:362018-06-18 14:36
138132018002안심~하양 복선전철 건설사업현장안내 안내문2019-01-15<NA><NA><NA><NA><NA>경산통합사무실2보상파트-135<NA>2019-01-16 13:102019-01-16 13:10
266132020022자명천(자명지구) 하천재해예방사업자명천(자명지구) 하천재해예방사업 보상계획 열람 공고2020-10-282020-10-282020-10-282020-11-13<NA>본사 및 시공사 현장사무소본사, 포항시 푸른도시사업단 생태하천과, 홈페이지1경상북도개발공사 공고 제2020-72<NA>2020-10-23 17:562020-10-23 17:56
370152020018초곡천(초곡2지구) 하천재해예방사업초곡천(초곡2지구)하천재해예방사업 보상계획열람공고2021-05-262021-05-26<NA><NA><NA><NA><NA>12021-23<NA>2021-05-17 14:132021-05-17 14:13
474142020017안림천(대가야,쌍림지구) 하천재해예방사업편입토지 제외2021-08-04<NA><NA><NA><NA><NA><NA>2<NA><NA>2021-07-29 11:422021-07-29 11:42
580142021006도청신도시구역 내 지방도927호선 개설공사도청신도시구역 내 지방도927호선 개설공사 보상계획열람공고2021-10-222021-10-22<NA><NA><NA><NA><NA>12021-93<NA>2021-10-20 9:172021-10-20 9:17
686132021007성주~김천간 지방도 건설공사성주~김천(금산~칠선)간 도로건설공사2022-07-112022-07-082022-07-112022-07-27<NA><NA>성주군청 건설안전과, 공사1제2022-043호<NA>2022-06-28 9:052022-06-28 9:05
7108132022006자호천 재해복구사업자호천 재해복구사업 보상계획 공고2023-04-192023-04-192023-04-192023-05-04<NA>본사 및 현장사무소포항시 및 영천시1제2023-25호<NA>2023-04-10 15:212023-04-10 15:21
8118132016070신한울원자력 3,4호기 건설사업(추가부지)신한울 3,4호기 건설사업 추가부지 보상계획 열람 공고2023-06-192023-06-152023-06-192023-07-03<NA><NA>울진군,경상북도개발공사,울진보상사무소1경상북도개발공사 2023-040호<NA>2023-06-12 19:492023-06-12 19:49
9120131013060경산상림 재활산업특화단지 조성사업경산상림 재활산업특화단지 조성사업 보상계획 열람공고2023-07-072023-07-052023-07-072023-07-24<NA>공사경산시청, 공사홈페이지1제2023-048호<NA>2023-06-30 21:392023-06-30 21:39
보상계획번호사업코드사업명공고명공고일자개별통보일자공람신청시작일자공람신청종료일자신문공고여부보상사무실명공람장소명계획일련번호코드공고번호비고입력일시수정일시
48124192023024감존천 재해복구사업태풍 힌남로(감존천) 재해복구사업 보상계획열람 공고2023-07-282023-07-27<NA><NA><NA><NA>공사홈페이지, 경주시홈페이지12023-057<NA>2023-07-26 20:282023-07-26 20:28
49832016060경산지식산업지구 진입도로 개설공사경산지식산업지구 진입도로 개설공사 보상계획 열람공고2016-10-102016-10-062016-10-102016-10-24<NA>하양보상사무실본사 보상분양처, 하양사무실1제2016-71호<NA>2016-11-29 20:562016-11-29 20:56
5068152020017안림천(대가야,쌍림지구) 하천재해예방사업안림천(대가야지구, 쌍림지구) 하천재해예방사업 보상계획열람 안내2021-01-252021-01-252021-01-252021-02-10<NA>본사 및 시공사 현장사무소본사, 고령군 건설과, 홈페이지1제2021-004호<NA>2021-01-15 12:492021-01-15 12:49
51102132021002경상북도 가축유전자원 분산센터 건립사업구미 가축유전자원분산센터 건립사업 보상계획 통지2023-02-062023-02-062023-02-062023-02-20<NA><NA><NA>1<NA><NA>2023-02-01 16:172023-02-01 16:17
5294132016060경산지식산업지구 진입도로 개설공사경산지식산업지구 진입도로 개설공사 보상계획(사직단 추가편입) 열람2023-01-312023-01-272023-01-302023-02-20<NA><NA>경산시 게시판, 공사홈페이지3제2023-2호<NA>2022-11-07 12:592022-11-07 12:59
53112132023006오계~대창간 도로확포장공사(3구간-도비)오계~대창간 도로확포장공사2023-05-162023-05-152023-05-172023-05-30<NA>공사우리공사 본사, 영천시청건설과1경상북도개발공사 공고 제2023-03<NA>2023-05-08 21:212023-05-08 21:21
54116132023011대천(서면·운대지구) 하천재해예방사업대천(서면·운대지구) 하천재해예방사업2023-05-252023-05-242023-05-252023-06-08<NA><NA>경주시청, 본사, 서면행정복지센터1제2023-035호<NA>2023-05-19 10:552023-05-19 10:55
55122132020008상원~청하간 도로건설공사상원~청하간 도로건설공사2023-07-122023-07-112023-07-122023-07-26<NA>동남권보상사무소(포항)포항시1제2023-51호<NA>2023-07-04 19:072023-07-04 19:07
5618132015040포항초곡지구 도시개발사업(진입도로)20인 이하 보상계획공고 생략2015-06-30<NA><NA><NA><NA>공사 영덕사무실공사 영덕사무실2<NA><NA>2017-02-27 13:472017-02-27 13:47
57862015060천지원자력발전소 건설사업천지원자력발전소 건설사업 보상계획 열람공고2015-11-182015-11-162015-11-182015-12-08<NA>영덕보상사무실영덕보상사무실, 새마을경제과1<NA><NA>2016-11-30 16:212016-11-30 16:21