Overview

Dataset statistics

Number of variables7
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory634.8 KiB
Average record size in memory65.0 B

Variable types

Numeric1
Categorical2
Text3
DateTime1

Dataset

Description보령시에서 공사를 수의계약한 정보(관서명, 계약방법 ,계약명, 계약금액, 계약일, 계약상대자)에 관한 현황입니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=327&beforeMenuCd=DOM_000000201001001000&publicdatapk=15090098

Alerts

계약방법 has constant value ""Constant
번호 has unique valuesUnique

Reproduction

Analysis started2024-01-09 22:29:00.215275
Analysis finished2024-01-09 22:29:01.466565
Duration1.25 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5132.3388
Minimum1
Maximum10266
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:29:01.527716image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile509.95
Q12565.75
median5133.5
Q37696.25
95-th percentile9753.05
Maximum10266
Range10265
Interquartile range (IQR)5130.5

Descriptive statistics

Standard deviation2963.2479
Coefficient of variation (CV)0.57736794
Kurtosis-1.2002451
Mean5132.3388
Median Absolute Deviation (MAD)2565.5
Skewness-0.00097873679
Sum51323388
Variance8780837.9
MonotonicityNot monotonic
2024-01-10T07:29:01.649270image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
6558 1
 
< 0.1%
5586 1
 
< 0.1%
1745 1
 
< 0.1%
7556 1
 
< 0.1%
2682 1
 
< 0.1%
6669 1
 
< 0.1%
1933 1
 
< 0.1%
6028 1
 
< 0.1%
6470 1
 
< 0.1%
4576 1
 
< 0.1%
Other values (9990) 9990
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 (%)
10266 1
< 0.1%
10265 1
< 0.1%
10264 1
< 0.1%
10263 1
< 0.1%
10262 1
< 0.1%
10261 1
< 0.1%
10260 1
< 0.1%
10259 1
< 0.1%
10258 1
< 0.1%
10257 1
< 0.1%

관서명
Categorical

Distinct22
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
본청
3432 
웅천읍
602 
천북면
595 
주교면
549 
청소면
539 
Other values (17)
4283 

Length

Max length9
Median length3
Mean length2.8642
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row웅천읍
2nd row주교면
3rd row본청
4th row천북면
5th row청라면

Common Values

ValueCountFrequency (%)
본청 3432
34.3%
웅천읍 602
 
6.0%
천북면 595
 
5.9%
주교면 549
 
5.5%
청소면 539
 
5.4%
주산면 522
 
5.2%
청라면 507
 
5.1%
남포면 456
 
4.6%
오천면 456
 
4.6%
미산면 420
 
4.2%
Other values (12) 1922
19.2%

Length

2024-01-10T07:29:01.759924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
본청 3432
34.3%
웅천읍 602
 
6.0%
천북면 595
 
5.9%
주교면 549
 
5.5%
청소면 539
 
5.4%
주산면 522
 
5.2%
청라면 507
 
5.1%
남포면 456
 
4.6%
오천면 456
 
4.6%
미산면 420
 
4.2%
Other values (12) 1922
19.2%

계약방법
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
수의1인견적
10000 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row수의1인견적
2nd row수의1인견적
3rd row수의1인견적
4th row수의1인견적
5th row수의1인견적

Common Values

ValueCountFrequency (%)
수의1인견적 10000
100.0%

Length

2024-01-10T07:29:01.862538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:29:01.970016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
수의1인견적 10000
100.0%
Distinct9172
Distinct (%)91.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-01-10T07:29:02.270460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length38
Mean length17.3917
Min length6

Characters and Unicode

Total characters173917
Distinct characters702
Distinct categories12 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique8673 ?
Unique (%)86.7%

Sample

1st row관당1리 영농폐비닐 집하장 설치공사
2nd row고정2지구 농업용 관정 수중모터 교체 공사
3rd row침출수처리시설 수질계측기 수선공사
4th row하만1리 버스승강장 설치공사
5th row청라면 가로변 공원화사업
ValueCountFrequency (%)
배수로 1762
 
4.9%
정비공사 1599
 
4.4%
공사 1153
 
3.2%
마을안길 976
 
2.7%
903
 
2.5%
설치공사 901
 
2.5%
보수공사 579
 
1.6%
포장공사 548
 
1.5%
설치 309
 
0.9%
정비 230
 
0.6%
Other values (6981) 27080
75.1%
2024-01-10T07:29:02.803811image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
26040
 
15.0%
10657
 
6.1%
9624
 
5.5%
5414
 
3.1%
4916
 
2.8%
3992
 
2.3%
3338
 
1.9%
3310
 
1.9%
2939
 
1.7%
2765
 
1.6%
Other values (692) 100922
58.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 134397
77.3%
Space Separator 26040
 
15.0%
Decimal Number 8143
 
4.7%
Close Punctuation 2137
 
1.2%
Open Punctuation 2133
 
1.2%
Uppercase Letter 561
 
0.3%
Dash Punctuation 261
 
0.2%
Other Punctuation 181
 
0.1%
Math Symbol 32
 
< 0.1%
Lowercase Letter 24
 
< 0.1%
Other values (2) 8
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
10657
 
7.9%
9624
 
7.2%
5414
 
4.0%
4916
 
3.7%
3992
 
3.0%
3338
 
2.5%
3310
 
2.5%
2939
 
2.2%
2765
 
2.1%
2393
 
1.8%
Other values (632) 85049
63.3%
Uppercase Letter
ValueCountFrequency (%)
C 157
28.0%
T 78
13.9%
V 78
13.9%
E 66
11.8%
L 65
11.6%
D 61
 
10.9%
P 12
 
2.1%
A 10
 
1.8%
I 8
 
1.4%
U 7
 
1.2%
Other values (8) 19
 
3.4%
Decimal Number
ValueCountFrequency (%)
1 2543
31.2%
2 2494
30.6%
3 1004
 
12.3%
0 545
 
6.7%
4 499
 
6.1%
5 300
 
3.7%
6 229
 
2.8%
8 195
 
2.4%
7 184
 
2.3%
9 150
 
1.8%
Other Punctuation
ValueCountFrequency (%)
, 118
65.2%
. 29
 
16.0%
· 23
 
12.7%
/ 4
 
2.2%
" 2
 
1.1%
* 2
 
1.1%
: 2
 
1.1%
; 1
 
0.6%
Lowercase Letter
ValueCountFrequency (%)
c 7
29.2%
v 4
16.7%
t 4
16.7%
a 2
 
8.3%
z 2
 
8.3%
i 2
 
8.3%
p 2
 
8.3%
y 1
 
4.2%
Close Punctuation
ValueCountFrequency (%)
) 2022
94.6%
] 106
 
5.0%
6
 
0.3%
2
 
0.1%
1
 
< 0.1%
Open Punctuation
ValueCountFrequency (%)
( 2018
94.6%
[ 106
 
5.0%
6
 
0.3%
2
 
0.1%
1
 
< 0.1%
Math Symbol
ValueCountFrequency (%)
~ 31
96.9%
+ 1
 
3.1%
Space Separator
ValueCountFrequency (%)
26040
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 261
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 7
100.0%
Letter Number
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 134397
77.3%
Common 38934
 
22.4%
Latin 586
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
10657
 
7.9%
9624
 
7.2%
5414
 
4.0%
4916
 
3.7%
3992
 
3.0%
3338
 
2.5%
3310
 
2.5%
2939
 
2.2%
2765
 
2.1%
2393
 
1.8%
Other values (632) 85049
63.3%
Common
ValueCountFrequency (%)
26040
66.9%
1 2543
 
6.5%
2 2494
 
6.4%
) 2022
 
5.2%
( 2018
 
5.2%
3 1004
 
2.6%
0 545
 
1.4%
4 499
 
1.3%
5 300
 
0.8%
- 261
 
0.7%
Other values (23) 1208
 
3.1%
Latin
ValueCountFrequency (%)
C 157
26.8%
T 78
13.3%
V 78
13.3%
E 66
11.3%
L 65
11.1%
D 61
 
10.4%
P 12
 
2.0%
A 10
 
1.7%
I 8
 
1.4%
U 7
 
1.2%
Other values (17) 44
 
7.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 134397
77.3%
ASCII 39478
 
22.7%
None 41
 
< 0.1%
Number Forms 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
26040
66.0%
1 2543
 
6.4%
2 2494
 
6.3%
) 2022
 
5.1%
( 2018
 
5.1%
3 1004
 
2.5%
0 545
 
1.4%
4 499
 
1.3%
5 300
 
0.8%
- 261
 
0.7%
Other values (42) 1752
 
4.4%
Hangul
ValueCountFrequency (%)
10657
 
7.9%
9624
 
7.2%
5414
 
4.0%
4916
 
3.7%
3992
 
3.0%
3338
 
2.5%
3310
 
2.5%
2939
 
2.2%
2765
 
2.1%
2393
 
1.8%
Other values (632) 85049
63.3%
None
ValueCountFrequency (%)
· 23
56.1%
6
 
14.6%
6
 
14.6%
2
 
4.9%
2
 
4.9%
1
 
2.4%
1
 
2.4%
Number Forms
ValueCountFrequency (%)
1
100.0%
Distinct5308
Distinct (%)53.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-01-10T07:29:03.068993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length9
Mean length9.3492
Min length7

Characters and Unicode

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

Unique

Unique4109 ?
Unique (%)41.1%

Sample

1st row2,360,000
2nd row1,300,000
3rd row7,490,000
4th row7,050,000
5th row18,476,000
ValueCountFrequency (%)
4,750,000 103
 
1.0%
2,850,000 64
 
0.6%
9,500,000 59
 
0.6%
7,600,000 56
 
0.6%
9,000,000 49
 
0.5%
9,300,000 46
 
0.5%
3,800,000 46
 
0.5%
18,000,000 42
 
0.4%
3,000,000 42
 
0.4%
4,400,000 37
 
0.4%
Other values (5298) 9456
94.6%
2024-01-10T07:29:03.465851image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 38245
40.9%
, 19811
21.2%
1 6526
 
7.0%
5 3818
 
4.1%
4 3806
 
4.1%
2 3803
 
4.1%
3 3563
 
3.8%
9 3551
 
3.8%
7 3543
 
3.8%
8 3530
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 73681
78.8%
Other Punctuation 19811
 
21.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 38245
51.9%
1 6526
 
8.9%
5 3818
 
5.2%
4 3806
 
5.2%
2 3803
 
5.2%
3 3563
 
4.8%
9 3551
 
4.8%
7 3543
 
4.8%
8 3530
 
4.8%
6 3296
 
4.5%
Other Punctuation
ValueCountFrequency (%)
, 19811
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 93492
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 38245
40.9%
, 19811
21.2%
1 6526
 
7.0%
5 3818
 
4.1%
4 3806
 
4.1%
2 3803
 
4.1%
3 3563
 
3.8%
9 3551
 
3.8%
7 3543
 
3.8%
8 3530
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 93492
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 38245
40.9%
, 19811
21.2%
1 6526
 
7.0%
5 3818
 
4.1%
4 3806
 
4.1%
2 3803
 
4.1%
3 3563
 
3.8%
9 3551
 
3.8%
7 3543
 
3.8%
8 3530
 
3.8%
Distinct1781
Distinct (%)17.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2014-01-13 00:00:00
Maximum2021-09-23 00:00:00
2024-01-10T07:29:03.607784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:29:03.734915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct1061
Distinct (%)10.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-01-10T07:29:03.940105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length17
Mean length7.2647
Min length2

Characters and Unicode

Total characters72647
Distinct characters361
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique392 ?
Unique (%)3.9%

Sample

1st row한내산업개발주식회사
2nd row엘지수중펌프
3rd row(주)성일전기
4th row예렘주식회사
5th row산석조경
ValueCountFrequency (%)
주식회사 1238
 
10.9%
우리토건(주 213
 
1.9%
신천건설(주 202
 
1.8%
유)네오건설 190
 
1.7%
주)럭키건설 190
 
1.7%
주)씨제이 176
 
1.6%
주)무한건설 165
 
1.5%
주)거산 159
 
1.4%
대한건설(주 154
 
1.4%
주)천마건설엔지니어링 144
 
1.3%
Other values (1042) 8515
75.0%
2024-01-10T07:29:04.268326image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7738
 
10.7%
( 6238
 
8.6%
) 6213
 
8.6%
5206
 
7.2%
4576
 
6.3%
1991
 
2.7%
1787
 
2.5%
1767
 
2.4%
1739
 
2.4%
1346
 
1.9%
Other values (351) 34046
46.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 58789
80.9%
Open Punctuation 6238
 
8.6%
Close Punctuation 6213
 
8.6%
Space Separator 1346
 
1.9%
Other Punctuation 26
 
< 0.1%
Uppercase Letter 24
 
< 0.1%
Decimal Number 10
 
< 0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
7738
 
13.2%
5206
 
8.9%
4576
 
7.8%
1991
 
3.4%
1787
 
3.0%
1767
 
3.0%
1739
 
3.0%
1292
 
2.2%
1250
 
2.1%
1063
 
1.8%
Other values (329) 30380
51.7%
Uppercase Letter
ValueCountFrequency (%)
N 7
29.2%
E 5
20.8%
S 3
12.5%
C 3
12.5%
G 1
 
4.2%
R 1
 
4.2%
H 1
 
4.2%
M 1
 
4.2%
V 1
 
4.2%
T 1
 
4.2%
Decimal Number
ValueCountFrequency (%)
8 3
30.0%
3 2
20.0%
1 2
20.0%
9 1
 
10.0%
5 1
 
10.0%
2 1
 
10.0%
Other Punctuation
ValueCountFrequency (%)
. 24
92.3%
, 2
 
7.7%
Open Punctuation
ValueCountFrequency (%)
( 6238
100.0%
Close Punctuation
ValueCountFrequency (%)
) 6213
100.0%
Space Separator
ValueCountFrequency (%)
1346
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 58789
80.9%
Common 13834
 
19.0%
Latin 24
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
7738
 
13.2%
5206
 
8.9%
4576
 
7.8%
1991
 
3.4%
1787
 
3.0%
1767
 
3.0%
1739
 
3.0%
1292
 
2.2%
1250
 
2.1%
1063
 
1.8%
Other values (329) 30380
51.7%
Common
ValueCountFrequency (%)
( 6238
45.1%
) 6213
44.9%
1346
 
9.7%
. 24
 
0.2%
8 3
 
< 0.1%
, 2
 
< 0.1%
3 2
 
< 0.1%
1 2
 
< 0.1%
9 1
 
< 0.1%
5 1
 
< 0.1%
Other values (2) 2
 
< 0.1%
Latin
ValueCountFrequency (%)
N 7
29.2%
E 5
20.8%
S 3
12.5%
C 3
12.5%
G 1
 
4.2%
R 1
 
4.2%
H 1
 
4.2%
M 1
 
4.2%
V 1
 
4.2%
T 1
 
4.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 58789
80.9%
ASCII 13858
 
19.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
7738
 
13.2%
5206
 
8.9%
4576
 
7.8%
1991
 
3.4%
1787
 
3.0%
1767
 
3.0%
1739
 
3.0%
1292
 
2.2%
1250
 
2.1%
1063
 
1.8%
Other values (329) 30380
51.7%
ASCII
ValueCountFrequency (%)
( 6238
45.0%
) 6213
44.8%
1346
 
9.7%
. 24
 
0.2%
N 7
 
0.1%
E 5
 
< 0.1%
8 3
 
< 0.1%
S 3
 
< 0.1%
C 3
 
< 0.1%
, 2
 
< 0.1%
Other values (12) 14
 
0.1%

Interactions

2024-01-10T07:29:01.197409image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T07:29:04.422054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호관서명
번호1.0000.222
관서명0.2221.000
2024-01-10T07:29:04.564475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호관서명
번호1.0000.084
관서명0.0841.000

Missing values

2024-01-10T07:29:01.312220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T07:29:01.415165image/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

번호관서명계약방법계약명계약금액계약일계약상대자
37086558웅천읍수의1인견적관당1리 영농폐비닐 집하장 설치공사2,360,0002018-12-24한내산업개발주식회사
61314135주교면수의1인견적고정2지구 농업용 관정 수중모터 교체 공사1,300,0002017-05-10엘지수중펌프
82881978본청수의1인견적침출수처리시설 수질계측기 수선공사7,490,0002015-07-01(주)성일전기
9618648천북면수의1인견적하만1리 버스승강장 설치공사7,050,0002014-05-12예렘주식회사
46725594청라면수의1인견적청라면 가로변 공원화사업18,476,0002018-04-19산석조경
51685098청소면수의1인견적청소면사무소 LED조명 교체 공사5,100,0002018-01-22태성전설(주)
47635503남포면수의1인견적용두해변 구조장비(구조보트) 수리1,350,0002018-04-02웨이브러너
56024664청소면수의1인견적신송3리 소규모 배수로 정비공사1,970,0002017-08-30(주)무한건설
90881178문화체육관리사업소수의1인견적종합경기장 저수조 탱크 보수공사3,274,0002014-12-18(주)성준건설
53024964주교면수의1인견적주교면사무소 청사 청호교체 공사21,739,6102017-11-24연합건설산업(주)
번호관서명계약방법계약명계약금액계약일계약상대자
76602606본청수의1인견적대천해수욕장 연안보수공사6,238,4002016-03-21(주)우진건설
90551211문화체육관리사업소수의1인견적대천방조제 노후 가로등 교체공사18,400,0002015-01-27(주)거성전력
23147952본청수의1인견적관산소하천 정비사업18,860,0002020-01-29(주)유정건설
9481785천북면수의1인견적벼 병해충 방제지원 헬기 포트장 설치공사3,300,0002014-06-05(주)청원건설
39916275본청수의1인견적옥현리 959-1번지 수해복구(농업용취입보)8,100,0002018-10-26보령건설중기(주)
85771689오천면수의1인견적소성1리 배수로 뚜껑 교체공사1,567,5002015-04-24(주)무한건설
83501916주산면수의1인견적삼곡1리 농로포장 공사18,277,0002015-06-19우리토건(주)
8739393본청수의1인견적2021년 임도신설(작업) 공사97,399,0002021-03-02보령시산림조합
20558211주포면수의1인견적봉당1리(634-14) 배수로 설치공사9,400,0002020-03-02휴코건설주식회사
16928574주포면수의1인견적주포면 청사 석면철거 및 텍스설치공사(지정폐기물-철거)14,500,0002020-05-11주식회사 선