Overview

Dataset statistics

Number of variables7
Number of observations10000
Missing cells30
Missing cells (%)< 0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory644.5 KiB
Average record size in memory66.0 B

Variable types

Numeric2
Categorical2
Text2
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=15090070

Alerts

계약금액 is highly skewed (γ1 = 25.50045101)Skewed
번호 has unique valuesUnique

Reproduction

Analysis started2024-01-09 20:39:19.123844
Analysis finished2024-01-09 20:39:20.849095
Duration1.73 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%
Mean9275.2624
Minimum1
Maximum18646
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T05:39:20.911907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile967.95
Q14612.75
median9213
Q313936.25
95-th percentile17746.2
Maximum18646
Range18645
Interquartile range (IQR)9323.5

Descriptive statistics

Standard deviation5375.0559
Coefficient of variation (CV)0.57950445
Kurtosis-1.1935317
Mean9275.2624
Median Absolute Deviation (MAD)4662.5
Skewness0.022282425
Sum92752624
Variance28891226
MonotonicityNot monotonic
2024-01-10T05:39:21.051615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4682 1
 
< 0.1%
14144 1
 
< 0.1%
10504 1
 
< 0.1%
7631 1
 
< 0.1%
4952 1
 
< 0.1%
12744 1
 
< 0.1%
17877 1
 
< 0.1%
17999 1
 
< 0.1%
18124 1
 
< 0.1%
1095 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%
7 1
< 0.1%
8 1
< 0.1%
11 1
< 0.1%
14 1
< 0.1%
15 1
< 0.1%
17 1
< 0.1%
ValueCountFrequency (%)
18646 1
< 0.1%
18644 1
< 0.1%
18643 1
< 0.1%
18642 1
< 0.1%
18640 1
< 0.1%
18639 1
< 0.1%
18638 1
< 0.1%
18637 1
< 0.1%
18636 1
< 0.1%
18635 1
< 0.1%

관서명
Categorical

Distinct23
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
본청
4973 
웅천읍
 
457
천북면
 
444
주교면
 
426
주산면
 
407
Other values (18)
3293 

Length

Max length9
Median length6
Mean length2.6663
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row본청
2nd row미산면
3rd row본청
4th row본청
5th row청소면

Common Values

ValueCountFrequency (%)
본청 4973
49.7%
웅천읍 457
 
4.6%
천북면 444
 
4.4%
주교면 426
 
4.3%
주산면 407
 
4.1%
청소면 391
 
3.9%
청라면 371
 
3.7%
남포면 359
 
3.6%
오천면 353
 
3.5%
미산면 329
 
3.3%
Other values (13) 1490
 
14.9%

Length

2024-01-10T05:39:21.204996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
본청 4973
49.7%
웅천읍 457
 
4.6%
천북면 444
 
4.4%
주교면 426
 
4.3%
주산면 407
 
4.1%
청소면 391
 
3.9%
청라면 371
 
3.7%
남포면 359
 
3.6%
오천면 353
 
3.5%
미산면 329
 
3.3%
Other values (13) 1490
 
14.9%

계약방법
Categorical

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
수의1인견적
7291 
수의2인이상견적
2175 
제한경쟁
 
443
일반경쟁
 
91

Length

Max length8
Median length6
Mean length6.3282
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제한경쟁
2nd row수의1인견적
3rd row제한경쟁
4th row수의1인견적
5th row수의1인견적

Common Values

ValueCountFrequency (%)
수의1인견적 7291
72.9%
수의2인이상견적 2175
 
21.8%
제한경쟁 443
 
4.4%
일반경쟁 91
 
0.9%

Length

2024-01-10T05:39:21.351761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:39:21.452460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
수의1인견적 7291
72.9%
수의2인이상견적 2175
 
21.8%
제한경쟁 443
 
4.4%
일반경쟁 91
 
0.9%
Distinct9473
Distinct (%)94.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-01-10T05:39:21.775442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length55
Median length40
Mean length18.3412
Min length6

Characters and Unicode

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

Unique

Unique9104 ?
Unique (%)91.0%

Sample

1st row대천해수욕장 국민여가캠핑장 조성사업(건축)
2nd row도화담1리 용배수로 설치공사
3rd row주렴산 만세운동 정비사업
4th row민원실 옆 도로정비
5th row장곡1리 소규모 배수로 정비공사
ValueCountFrequency (%)
배수로 1489
 
4.2%
정비공사 1479
 
4.1%
공사 895
 
2.5%
설치공사 894
 
2.5%
883
 
2.5%
마을안길 820
 
2.3%
시행결의 588
 
1.6%
보수공사 496
 
1.4%
포장공사 476
 
1.3%
설치 263
 
0.7%
Other values (7996) 27576
76.9%
2024-01-10T05:39:22.285504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
25859
 
14.1%
10642
 
5.8%
9418
 
5.1%
4957
 
2.7%
4623
 
2.5%
3874
 
2.1%
3236
 
1.8%
) 3215
 
1.8%
( 3208
 
1.7%
3182
 
1.7%
Other values (713) 111198
60.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 138295
75.4%
Space Separator 25859
 
14.1%
Decimal Number 10970
 
6.0%
Close Punctuation 3391
 
1.8%
Open Punctuation 3384
 
1.8%
Dash Punctuation 681
 
0.4%
Uppercase Letter 445
 
0.2%
Other Punctuation 260
 
0.1%
Math Symbol 64
 
< 0.1%
Lowercase Letter 30
 
< 0.1%
Other values (2) 33
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
10642
 
7.7%
9418
 
6.8%
4957
 
3.6%
4623
 
3.3%
3874
 
2.8%
3236
 
2.3%
3182
 
2.3%
2915
 
2.1%
2604
 
1.9%
2492
 
1.8%
Other values (648) 90352
65.3%
Uppercase Letter
ValueCountFrequency (%)
C 115
25.8%
V 56
12.6%
E 55
12.4%
T 55
12.4%
L 51
11.5%
D 49
11.0%
S 13
 
2.9%
A 8
 
1.8%
I 8
 
1.8%
P 8
 
1.8%
Other values (8) 27
 
6.1%
Other Punctuation
ValueCountFrequency (%)
, 159
61.2%
· 45
 
17.3%
. 35
 
13.5%
" 6
 
2.3%
/ 6
 
2.3%
* 2
 
0.8%
: 2
 
0.8%
; 2
 
0.8%
1
 
0.4%
@ 1
 
0.4%
Decimal Number
ValueCountFrequency (%)
2 3033
27.6%
1 2953
26.9%
3 1203
 
11.0%
0 945
 
8.6%
4 697
 
6.4%
5 530
 
4.8%
6 474
 
4.3%
8 421
 
3.8%
7 375
 
3.4%
9 339
 
3.1%
Lowercase Letter
ValueCountFrequency (%)
c 6
20.0%
p 4
13.3%
i 4
13.3%
z 4
13.3%
v 3
10.0%
e 3
10.0%
t 3
10.0%
a 1
 
3.3%
o 1
 
3.3%
s 1
 
3.3%
Close Punctuation
ValueCountFrequency (%)
) 3215
94.8%
] 165
 
4.9%
6
 
0.2%
4
 
0.1%
1
 
< 0.1%
Open Punctuation
ValueCountFrequency (%)
( 3208
94.8%
[ 165
 
4.9%
6
 
0.2%
4
 
0.1%
1
 
< 0.1%
Math Symbol
ValueCountFrequency (%)
~ 62
96.9%
+ 2
 
3.1%
Space Separator
ValueCountFrequency (%)
25859
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 681
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 29
100.0%
Letter Number
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 138295
75.4%
Common 44638
 
24.3%
Latin 479
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
10642
 
7.7%
9418
 
6.8%
4957
 
3.6%
4623
 
3.3%
3874
 
2.8%
3236
 
2.3%
3182
 
2.3%
2915
 
2.1%
2604
 
1.9%
2492
 
1.8%
Other values (648) 90352
65.3%
Common
ValueCountFrequency (%)
25859
57.9%
) 3215
 
7.2%
( 3208
 
7.2%
2 3033
 
6.8%
1 2953
 
6.6%
3 1203
 
2.7%
0 945
 
2.1%
4 697
 
1.6%
- 681
 
1.5%
5 530
 
1.2%
Other values (26) 2314
 
5.2%
Latin
ValueCountFrequency (%)
C 115
24.0%
V 56
11.7%
E 55
11.5%
T 55
11.5%
L 51
10.6%
D 49
10.2%
S 13
 
2.7%
A 8
 
1.7%
I 8
 
1.7%
P 8
 
1.7%
Other values (19) 61
12.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 138292
75.4%
ASCII 45045
 
24.6%
None 68
 
< 0.1%
Number Forms 4
 
< 0.1%
Compat Jamo 3
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
25859
57.4%
) 3215
 
7.1%
( 3208
 
7.1%
2 3033
 
6.7%
1 2953
 
6.6%
3 1203
 
2.7%
0 945
 
2.1%
4 697
 
1.5%
- 681
 
1.5%
5 530
 
1.2%
Other values (46) 2721
 
6.0%
Hangul
ValueCountFrequency (%)
10642
 
7.7%
9418
 
6.8%
4957
 
3.6%
4623
 
3.3%
3874
 
2.8%
3236
 
2.3%
3182
 
2.3%
2915
 
2.1%
2604
 
1.9%
2492
 
1.8%
Other values (647) 90349
65.3%
None
ValueCountFrequency (%)
· 45
66.2%
6
 
8.8%
6
 
8.8%
4
 
5.9%
4
 
5.9%
1
 
1.5%
1
 
1.5%
1
 
1.5%
Number Forms
ValueCountFrequency (%)
4
100.0%
Compat Jamo
ValueCountFrequency (%)
3
100.0%

계약금액
Real number (ℝ)

SKEWED 

Distinct6956
Distinct (%)69.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean51331329
Minimum165000
Maximum1.5638007 × 1010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T05:39:22.495892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum165000
5-th percentile1884950
Q15509500
median12055000
Q324662750
95-th percentile1.4027525 × 108
Maximum1.5638007 × 1010
Range1.5637842 × 1010
Interquartile range (IQR)19153250

Descriptive statistics

Standard deviation3.5614414 × 108
Coefficient of variation (CV)6.9381438
Kurtosis825.67784
Mean51331329
Median Absolute Deviation (MAD)7426500
Skewness25.500451
Sum5.1331329 × 1011
Variance1.2683865 × 1017
MonotonicityNot monotonic
2024-01-10T05:39:22.653835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4750000 57
 
0.6%
9500000 38
 
0.4%
2850000 37
 
0.4%
18000000 32
 
0.3%
4900000 31
 
0.3%
3800000 31
 
0.3%
7600000 31
 
0.3%
9300000 27
 
0.3%
9400000 27
 
0.3%
9000000 27
 
0.3%
Other values (6946) 9662
96.6%
ValueCountFrequency (%)
165000 1
 
< 0.1%
250000 2
< 0.1%
270000 1
 
< 0.1%
280000 1
 
< 0.1%
299880 1
 
< 0.1%
300000 2
< 0.1%
330000 3
< 0.1%
392000 1
 
< 0.1%
396000 1
 
< 0.1%
400000 3
< 0.1%
ValueCountFrequency (%)
15638007000 1
< 0.1%
13025797000 1
< 0.1%
11240400000 1
< 0.1%
10053717000 1
< 0.1%
8627360420 1
< 0.1%
8063556000 1
< 0.1%
7784983400 1
< 0.1%
6022403600 1
< 0.1%
5716584000 1
< 0.1%
5573179000 1
< 0.1%
Distinct2190
Distinct (%)21.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2014-01-13 00:00:00
Maximum2023-11-01 00:00:00
2024-01-10T05:39:22.787747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:39:22.917824image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct1493
Distinct (%)15.0%
Missing30
Missing (%)0.3%
Memory size156.2 KiB
2024-01-10T05:39:23.153312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length16
Mean length7.4738215
Min length2

Characters and Unicode

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

Unique

Unique702 ?
Unique (%)7.0%

Sample

1st row웅진종합건설
2nd row동대수도건설
3rd row(주)다윗
4th row(주)대풍
5th row조우건설
ValueCountFrequency (%)
주식회사 1782
 
15.0%
유)네오건설 160
 
1.4%
신천건설(주 159
 
1.3%
주)씨제이 146
 
1.2%
우리토건(주 143
 
1.2%
주)럭키건설 129
 
1.1%
대한건설(주 123
 
1.0%
보령시산림조합 122
 
1.0%
에스에이치건설 117
 
1.0%
주)천마건설엔지니어링 111
 
0.9%
Other values (1463) 8857
74.7%
2024-01-10T05:39:23.588017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
8130
 
10.9%
( 5930
 
8.0%
) 5917
 
7.9%
5192
 
7.0%
4668
 
6.3%
2618
 
3.5%
2424
 
3.3%
2364
 
3.2%
1879
 
2.5%
1749
 
2.3%
Other values (350) 33643
45.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 60743
81.5%
Open Punctuation 5930
 
8.0%
Close Punctuation 5917
 
7.9%
Space Separator 1879
 
2.5%
Other Punctuation 29
 
< 0.1%
Uppercase Letter 10
 
< 0.1%
Other Symbol 6
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
8130
 
13.4%
5192
 
8.5%
4668
 
7.7%
2618
 
4.3%
2424
 
4.0%
2364
 
3.9%
1749
 
2.9%
1214
 
2.0%
1185
 
2.0%
1126
 
1.9%
Other values (334) 30073
49.5%
Uppercase Letter
ValueCountFrequency (%)
E 2
20.0%
N 2
20.0%
C 2
20.0%
M 1
10.0%
S 1
10.0%
B 1
10.0%
H 1
10.0%
Other Punctuation
ValueCountFrequency (%)
. 24
82.8%
, 2
 
6.9%
! 1
 
3.4%
@ 1
 
3.4%
# 1
 
3.4%
Open Punctuation
ValueCountFrequency (%)
( 5930
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5917
100.0%
Space Separator
ValueCountFrequency (%)
1879
100.0%
Other Symbol
ValueCountFrequency (%)
6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 60749
81.5%
Common 13755
 
18.5%
Latin 10
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
8130
 
13.4%
5192
 
8.5%
4668
 
7.7%
2618
 
4.3%
2424
 
4.0%
2364
 
3.9%
1749
 
2.9%
1214
 
2.0%
1185
 
2.0%
1126
 
1.9%
Other values (335) 30079
49.5%
Common
ValueCountFrequency (%)
( 5930
43.1%
) 5917
43.0%
1879
 
13.7%
. 24
 
0.2%
, 2
 
< 0.1%
! 1
 
< 0.1%
@ 1
 
< 0.1%
# 1
 
< 0.1%
Latin
ValueCountFrequency (%)
E 2
20.0%
N 2
20.0%
C 2
20.0%
M 1
10.0%
S 1
10.0%
B 1
10.0%
H 1
10.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 60743
81.5%
ASCII 13765
 
18.5%
None 6
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
8130
 
13.4%
5192
 
8.5%
4668
 
7.7%
2618
 
4.3%
2424
 
4.0%
2364
 
3.9%
1749
 
2.9%
1214
 
2.0%
1185
 
2.0%
1126
 
1.9%
Other values (334) 30073
49.5%
ASCII
ValueCountFrequency (%)
( 5930
43.1%
) 5917
43.0%
1879
 
13.7%
. 24
 
0.2%
E 2
 
< 0.1%
, 2
 
< 0.1%
N 2
 
< 0.1%
C 2
 
< 0.1%
M 1
 
< 0.1%
S 1
 
< 0.1%
Other values (5) 5
 
< 0.1%
None
ValueCountFrequency (%)
6
100.0%

Interactions

2024-01-10T05:39:20.454212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:39:20.263547image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:39:20.558766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:39:20.349883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T05:39:23.686041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호관서명계약방법계약금액
번호1.0000.2240.1270.000
관서명0.2241.0000.5530.000
계약방법0.1270.5531.0000.319
계약금액0.0000.0000.3191.000
2024-01-10T05:39:23.771955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
계약방법관서명
계약방법1.0000.327
관서명0.3271.000
2024-01-10T05:39:23.848630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호계약금액관서명계약방법
번호1.0000.0420.0840.076
계약금액0.0421.0000.0000.196
관서명0.0840.0001.0000.327
계약방법0.0760.1960.3271.000

Missing values

2024-01-10T05:39:20.690045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:39:20.798303image/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

번호관서명계약방법계약명계약금액계약일계약상대자
46814682본청제한경쟁대천해수욕장 국민여가캠핑장 조성사업(건축)2147800002017-02-03웅진종합건설
1057110572미산면수의1인견적도화담1리 용배수로 설치공사152991002019-11-19동대수도건설
99909991본청제한경쟁주렴산 만세운동 정비사업1175444802019-06-25(주)다윗
33653366본청수의1인견적민원실 옆 도로정비200000002016-03-24(주)대풍
74077408청소면수의1인견적장곡1리 소규모 배수로 정비공사21000002018-04-18조우건설
1657916580본청수의1인견적원산도 생활체육시설 보수보강공사90700002022-11-08주식회사동서에코글로벌
42264227본청수의1인견적증산1리 농로포장공사120530002016-08-30명문토건
90589059성주면수의1인견적성주5리 배수로 확장공사 대금 지급117570002019-03-12송주건설 주식회사
12451246문화체육관리사업소수의1인견적종합경기장 시설물보수.수리52000002014-10-06김재훈
1442214423본청제한경쟁주교면 생활문화플랫폼 신축공사(건축)10000000002021-12-21주식회사태정씨앤디
번호관서명계약방법계약명계약금액계약일계약상대자
97529753청라면수의1인견적황룡2리(마쟁이)농로포장공사65900002019-05-22삼보산업개발(주)
47664767본청수의1인견적시청사 석면천정 철거공사192569702017-02-17주식회사 선
94889489본청제한경쟁창동리 마을진입로 개설공사(도급)1944630402019-04-23합자회사 한솔
15531554오천면수의1인견적오천 회이포 경로당 주차장 사리부설 공사7001502015-02-25삼삼건기(복양수)
1730217303본청수의2인이상견적벽남소하천 정비사업418000002023-03-08디테일 주식회사
67566757성주면수의1인견적성주면 구 출장소 지붕교체 및 리모델링공사 지정폐기물 철거35600002018-02-21삼홍조경건설
1581815819본청수의2인이상견적요트경기장 합숙소 지붕개량공사328040002022-06-16주식회사 삼부종합건설
1475714758주산면수의1인견적증산4리(155-1) 배수로 정비공사129130002022-03-02조우건설(주)
1360013601남포면수의1인견적신흥1리 마을안길 확포장공사132260002021-05-28(주)럭키건설
68376838청소면수의1인견적야현2리 마을주차장 조성공사75000002018-02-26아성산업개발