Overview

Dataset statistics

Number of variables5
Number of observations54
Missing cells26
Missing cells (%)9.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.3 KiB
Average record size in memory43.4 B

Variable types

Categorical2
Text3

Alerts

링크명 has constant value ""Constant
시군명 has 26 (48.1%) missing valuesMissing

Reproduction

Analysis started2023-12-10 22:23:58.638632
Analysis finished2023-12-10 22:23:58.957995
Duration0.32 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기준년도
Categorical

Distinct2
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size564.0 B
2023
28 
2022
26 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023
2nd row2023
3rd row2023
4th row2023
5th row2023

Common Values

ValueCountFrequency (%)
2023 28
51.9%
2022 26
48.1%

Length

2023-12-11T07:23:59.022655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:23:59.105090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023 28
51.9%
2022 26
48.1%

시군명
Text

MISSING 

Distinct28
Distinct (%)100.0%
Missing26
Missing (%)48.1%
Memory size564.0 B
2023-12-11T07:23:59.280245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length3
Mean length3.1071429
Min length3

Characters and Unicode

Total characters87
Distinct characters38
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique28 ?
Unique (%)100.0%

Sample

1st row경기도
2nd row고양시
3rd row과천시
4th row광명시
5th row광주시
ValueCountFrequency (%)
고양시 1
 
3.6%
과천시 1
 
3.6%
화성시 1
 
3.6%
하남시 1
 
3.6%
포천시 1
 
3.6%
평택시 1
 
3.6%
파주시 1
 
3.6%
이천시 1
 
3.6%
의정부시 1
 
3.6%
의왕시 1
 
3.6%
Other values (18) 18
64.3%
2023-12-11T07:23:59.657291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
시 28
32.2%
천 5
 
5.7%
주 4
 
4.6%
양 4
 
4.6%
포 3
 
3.4%
성 3
 
3.4%
안 3
 
3.4%
남 3
 
3.4%
의 2
 
2.3%
산 2
 
2.3%
Other values (28) 30
34.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 87
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 28
32.2%
천 5
 
5.7%
주 4
 
4.6%
양 4
 
4.6%
포 3
 
3.4%
성 3
 
3.4%
안 3
 
3.4%
남 3
 
3.4%
의 2
 
2.3%
산 2
 
2.3%
Other values (28) 30
34.5%

Most occurring scripts

ValueCountFrequency (%)
Hangul 87
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 28
32.2%
천 5
 
5.7%
주 4
 
4.6%
양 4
 
4.6%
포 3
 
3.4%
성 3
 
3.4%
안 3
 
3.4%
남 3
 
3.4%
의 2
 
2.3%
산 2
 
2.3%
Other values (28) 30
34.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 87
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
시 28
32.2%
천 5
 
5.7%
주 4
 
4.6%
양 4
 
4.6%
포 3
 
3.4%
성 3
 
3.4%
안 3
 
3.4%
남 3
 
3.4%
의 2
 
2.3%
산 2
 
2.3%
Other values (28) 30
34.5%

자치단체명
Text

Distinct28
Distinct (%)51.9%
Missing0
Missing (%)0.0%
Memory size564.0 B
2023-12-11T07:23:59.846346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length5
Mean length5.0555556
Min length4

Characters and Unicode

Total characters273
Distinct characters39
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2 ?
Unique (%)3.7%

Sample

1st row경기본청
2nd row경기고양시
3rd row경기과천시
4th row경기광명시
5th row경기광주시
ValueCountFrequency (%)
경기본청 2
 
3.7%
경기시흥시 2
 
3.7%
경기하남시 2
 
3.7%
경기포천시 2
 
3.7%
경기평택시 2
 
3.7%
경기파주시 2
 
3.7%
경기이천시 2
 
3.7%
경기의왕시 2
 
3.7%
경기오산시 2
 
3.7%
경기양주시 2
 
3.7%
Other values (18) 34
63.0%
2023-12-11T07:24:00.195927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
경 54
19.8%
기 54
19.8%
시 54
19.8%
천 10
 
3.7%
주 8
 
2.9%
양 8
 
2.9%
성 6
 
2.2%
안 6
 
2.2%
남 6
 
2.2%
포 6
 
2.2%
Other values (29) 61
22.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 273
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
경 54
19.8%
기 54
19.8%
시 54
19.8%
천 10
 
3.7%
주 8
 
2.9%
양 8
 
2.9%
성 6
 
2.2%
안 6
 
2.2%
남 6
 
2.2%
포 6
 
2.2%
Other values (29) 61
22.3%

Most occurring scripts

ValueCountFrequency (%)
Hangul 273
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
경 54
19.8%
기 54
19.8%
시 54
19.8%
천 10
 
3.7%
주 8
 
2.9%
양 8
 
2.9%
성 6
 
2.2%
안 6
 
2.2%
남 6
 
2.2%
포 6
 
2.2%
Other values (29) 61
22.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 273
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
경 54
19.8%
기 54
19.8%
시 54
19.8%
천 10
 
3.7%
주 8
 
2.9%
양 8
 
2.9%
성 6
 
2.2%
안 6
 
2.2%
남 6
 
2.2%
포 6
 
2.2%
Other values (29) 61
22.3%

링크명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size564.0 B
계약현황
54 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row계약현황
2nd row계약현황
3rd row계약현황
4th row계약현황
5th row계약현황

Common Values

ValueCountFrequency (%)
계약현황 54
100.0%

Length

2023-12-11T07:24:00.313003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:24:00.397135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
계약현황 54
100.0%

URL
Text

Distinct35
Distinct (%)64.8%
Missing0
Missing (%)0.0%
Memory size564.0 B
2023-12-11T07:24:00.617684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length110
Median length67
Mean length56.37037
Min length24

Characters and Unicode

Total characters3044
Distinct characters61
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

Unique16 ?
Unique (%)29.6%

Sample

1st rowhttps://www.gg.go.kr/bbs/board.do?bsIdx=576&menuId=1581&bcIdx=523#page=1
2nd rowhttp://goyang.go.kr/contract
3rd rowhttps://www.gccity.go.kr/portal/ehojo/contract/list.do?mId=0202050100
4th rowhttps://www.gm.go.kr/pt/disclosure/bidContractInfo/contractInfo/contractList.do?q_optionalYn=N
5th rowhttps://www.gjcity.go.kr/portal/ehojo/contract/list.do?mId=0302030100&token=1684202298256
ValueCountFrequency (%)
https://www.gg.go.kr/bbs/board.do?bsidx=576&menuid=1581&bcidx=523#page=1 2
 
3.7%
https://contract.bucheon.go.kr/basis/situationlist.do 2
 
3.7%
http://goyang.go.kr/contract 2
 
3.7%
http://contract.iansan.net/main/index.jsp 2
 
3.7%
http://www.pocheon.go.kr/contract/index.do 2
 
3.7%
https://www.pyeongtaek.go.kr/pyeongtaek/ehojo/contract/list.do?mid=0109030100 2
 
3.7%
https://www.paju.go.kr/user/gopen/bd_situationlist.do?section=1001 2
 
3.7%
https://www.icheon.go.kr/portal/contractlist.do?key=1660&private_ctrt_yn=n&contract_kind_nm=%eb%ac%bc%ed%92%88 2
 
3.7%
https://www.uiwang.go.kr/uwkoropen0309 2
 
3.7%
https://contract.anyang.go.kr 2
 
3.7%
Other values (25) 34
63.0%
2023-12-11T07:24:00.974119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
t 272
 
8.9%
/ 235
 
7.7%
o 215
 
7.1%
. 199
 
6.5%
w 141
 
4.6%
n 133
 
4.4%
s 121
 
4.0%
r 112
 
3.7%
a 107
 
3.5%
c 105
 
3.4%
Other values (51) 1404
46.1%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 1968
64.7%
Other Punctuation 550
 
18.1%
Decimal Number 246
 
8.1%
Uppercase Letter 210
 
6.9%
Math Symbol 49
 
1.6%
Connector Punctuation 21
 
0.7%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
t 272
13.8%
o 215
 
10.9%
w 141
 
7.2%
n 133
 
6.8%
s 121
 
6.1%
r 112
 
5.7%
a 107
 
5.4%
c 105
 
5.3%
g 96
 
4.9%
p 88
 
4.5%
Other values (14) 578
29.4%
Uppercase Letter
ValueCountFrequency (%)
I 32
15.2%
T 25
11.9%
C 23
11.0%
N 22
10.5%
R 17
8.1%
L 16
7.6%
E 12
 
5.7%
A 10
 
4.8%
P 8
 
3.8%
D 8
 
3.8%
Other values (8) 37
17.6%
Decimal Number
ValueCountFrequency (%)
0 85
34.6%
1 37
15.0%
3 27
 
11.0%
2 23
 
9.3%
7 14
 
5.7%
9 14
 
5.7%
5 14
 
5.7%
8 14
 
5.7%
6 9
 
3.7%
4 9
 
3.7%
Other Punctuation
ValueCountFrequency (%)
/ 235
42.7%
. 199
36.2%
: 55
 
10.0%
? 29
 
5.3%
& 18
 
3.3%
% 12
 
2.2%
# 2
 
0.4%
Math Symbol
ValueCountFrequency (%)
= 49
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 21
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 2178
71.6%
Common 866
 
28.4%

Most frequent character per script

Latin
ValueCountFrequency (%)
t 272
 
12.5%
o 215
 
9.9%
w 141
 
6.5%
n 133
 
6.1%
s 121
 
5.6%
r 112
 
5.1%
a 107
 
4.9%
c 105
 
4.8%
g 96
 
4.4%
p 88
 
4.0%
Other values (32) 788
36.2%
Common
ValueCountFrequency (%)
/ 235
27.1%
. 199
23.0%
0 85
 
9.8%
: 55
 
6.4%
= 49
 
5.7%
1 37
 
4.3%
? 29
 
3.3%
3 27
 
3.1%
2 23
 
2.7%
_ 21
 
2.4%
Other values (9) 106
12.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3044
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
t 272
 
8.9%
/ 235
 
7.7%
o 215
 
7.1%
. 199
 
6.5%
w 141
 
4.6%
n 133
 
4.4%
s 121
 
4.0%
r 112
 
3.7%
a 107
 
3.5%
c 105
 
3.4%
Other values (51) 1404
46.1%

Correlations

2023-12-11T07:24:01.057494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준년도시군명자치단체명URL
기준년도1.000NaN0.0000.000
시군명NaN1.0001.0001.000
자치단체명0.0001.0001.0001.000
URL0.0001.0001.0001.000

Missing values

2023-12-11T07:23:58.835464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T07:23:58.917606image/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

기준년도시군명자치단체명링크명URL
02023경기도경기본청계약현황https://www.gg.go.kr/bbs/board.do?bsIdx=576&menuId=1581&bcIdx=523#page=1
12023고양시경기고양시계약현황http://goyang.go.kr/contract
22023과천시경기과천시계약현황https://www.gccity.go.kr/portal/ehojo/contract/list.do?mId=0202050100
32023광명시경기광명시계약현황https://www.gm.go.kr/pt/disclosure/bidContractInfo/contractInfo/contractList.do?q_optionalYn=N
42023광주시경기광주시계약현황https://www.gjcity.go.kr/portal/ehojo/contract/list.do?mId=0302030100&token=1684202298256
52023구리시경기구리시계약현황https://www.guri.go.kr/www/selectContractWebList.do?key=291&menuIdx=5350
62023군포시경기군포시계약현황http://www.gunpo.go.kr/www/contents.do?key=4297
72023김포시경기김포시계약현황https://www.gimpo.go.kr/portal/ContractList.do?key=1131&PRIVATE_CTRT_YN=N
82023남양주시경기남양주시계약현황http://gyeyak.nyj.go.kr/
92023동두천시경기동두천시계약현황https://www.ddc.go.kr/ddc/ContractList.do?key=370&PRIVATE_CTRT_YN=N
기준년도시군명자치단체명링크명URL
442022<NA>경기이천시계약현황https://www.icheon.go.kr/portal/contractList.do?key=1660&PRIVATE_CTRT_YN=N&CONTRACT_KIND_NM=%EB%AC%BC%ED%92%88
452022<NA>경기남양주시계약현황http://gyeyak.nyj.go.kr/
462022<NA>경기양주시계약현황https://www.yangju.go.kr/www/contents.do?key=277
472022<NA>경기오산시계약현황https://www.osan.go.kr/portal/bbs/list.do?ptIdx=179&mId=0204010000
482022<NA>경기포천시계약현황http://www.pocheon.go.kr/contract/index.do
492022<NA>경기군포시계약현황http://www.gunpo.go.kr/www/contents.do?key=4297
502022<NA>경기파주시계약현황https://www.paju.go.kr/user/gopen/BD_situationList.do?section=1001
512022<NA>경기안성시계약현황http://www.anseong.go.kr/portal/nara/plan/list.do?mId=0308010000
522022<NA>경기김포시계약현황https://www.gimpo.go.kr/u/15251
532022<NA>경기본청계약현황https://www.gg.go.kr/bbs/board.do?bsIdx=576&menuId=1581&bcIdx=523#page=1