Overview

Dataset statistics

Number of variables7
Number of observations10000
Missing cells0
Missing cells (%)0.0%
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=15090098

Alerts

계약방법 has constant value ""Constant
계약금액 is highly skewed (γ1 = 41.07801718)Skewed
번호 has unique valuesUnique

Reproduction

Analysis started2024-01-09 22:28:55.889721
Analysis finished2024-01-09 22:28:57.119398
Duration1.23 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%
Mean5928.6037
Minimum2
Maximum11879
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:28:57.180218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile600.95
Q12953.75
median5923.5
Q38874.25
95-th percentile11289.05
Maximum11879
Range11877
Interquartile range (IQR)5920.5

Descriptive statistics

Standard deviation3423.7226
Coefficient of variation (CV)0.57749224
Kurtosis-1.1929656
Mean5928.6037
Median Absolute Deviation (MAD)2960.5
Skewness0.0055874185
Sum59286037
Variance11721876
MonotonicityNot monotonic
2024-01-10T07:28:57.293981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4527 1
 
< 0.1%
9275 1
 
< 0.1%
6747 1
 
< 0.1%
3132 1
 
< 0.1%
6497 1
 
< 0.1%
9254 1
 
< 0.1%
6670 1
 
< 0.1%
3164 1
 
< 0.1%
1220 1
 
< 0.1%
8445 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
11 1
< 0.1%
12 1
< 0.1%
13 1
< 0.1%
ValueCountFrequency (%)
11879 1
< 0.1%
11878 1
< 0.1%
11877 1
< 0.1%
11876 1
< 0.1%
11875 1
< 0.1%
11874 1
< 0.1%
11872 1
< 0.1%
11871 1
< 0.1%
11870 1
< 0.1%
11868 1
< 0.1%

관서명
Categorical

Distinct22
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
본청
3372 
천북면
607 
웅천읍
598 
주교면
576 
청소면
537 
Other values (17)
4310 

Length

Max length9
Median length3
Mean length2.8743
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
본청 3372
33.7%
천북면 607
 
6.1%
웅천읍 598
 
6.0%
주교면 576
 
5.8%
청소면 537
 
5.4%
주산면 536
 
5.4%
청라면 492
 
4.9%
남포면 454
 
4.5%
미산면 432
 
4.3%
오천면 423
 
4.2%
Other values (12) 1973
19.7%

Length

2024-01-10T07:28:57.425916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
본청 3372
33.7%
천북면 607
 
6.1%
웅천읍 598
 
6.0%
주교면 576
 
5.8%
청소면 537
 
5.4%
주산면 536
 
5.4%
청라면 492
 
4.9%
남포면 454
 
4.5%
미산면 432
 
4.3%
오천면 423
 
4.2%
Other values (12) 1973
19.7%

계약방법
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:28:57.526071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:28:57.595802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
수의1인견적 10000
100.0%

계약명
Text

Distinct9262
Distinct (%)92.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-01-10T07:28:57.845171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length38
Mean length17.694
Min length6

Characters and Unicode

Total characters176940
Distinct characters707
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

Unique8801 ?
Unique (%)88.0%

Sample

1st row2017년 가뭄극복 긴급대책 농업용 관정개발(신덕1지구)
2nd row봉당2리 마을안길 정비공사 계약의뢰
3rd row고정1리(400-1) 농로 확포장공사
4th row궁포리 농로포장 및 배수로 정비공사
5th row2014년 조림지풀베기(남부2) 사업
ValueCountFrequency (%)
배수로 1781
 
4.9%
정비공사 1620
 
4.5%
공사 1101
 
3.1%
설치공사 976
 
2.7%
마을안길 961
 
2.7%
및 882
 
2.4%
포장공사 557
 
1.5%
보수공사 555
 
1.5%
시행결의 389
 
1.1%
설치 328
 
0.9%
Other values (7352) 26926
74.6%
2024-01-10T07:28:58.268461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
26076
 
14.7%
사 10612
 
6.0%
공 9558
 
5.4%
리 5527
 
3.1%
수 4889
 
2.8%
로 4035
 
2.3%
정 3437
 
1.9%
장 3272
 
1.8%
설 2995
 
1.7%
1 2798
 
1.6%
Other values (697) 103741
58.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 134969
76.3%
Space Separator 26076
 
14.7%
Decimal Number 9482
 
5.4%
Close Punctuation 2556
 
1.4%
Open Punctuation 2555
 
1.4%
Uppercase Letter 537
 
0.3%
Dash Punctuation 473
 
0.3%
Other Punctuation 201
 
0.1%
Lowercase Letter 35
 
< 0.1%
Math Symbol 30
 
< 0.1%
Other values (2) 26
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 10612
 
7.9%
공 9558
 
7.1%
리 5527
 
4.1%
수 4889
 
3.6%
로 4035
 
3.0%
정 3437
 
2.5%
장 3272
 
2.4%
설 2995
 
2.2%
비 2765
 
2.0%
배 2323
 
1.7%
Other values (637) 85556
63.4%
Uppercase Letter
ValueCountFrequency (%)
C 154
28.7%
V 76
14.2%
T 76
14.2%
E 56
 
10.4%
L 56
 
10.4%
D 52
 
9.7%
P 12
 
2.2%
A 11
 
2.0%
I 9
 
1.7%
U 8
 
1.5%
Other values (9) 27
 
5.0%
Decimal Number
ValueCountFrequency (%)
1 2798
29.5%
2 2716
28.6%
3 1124
11.9%
4 646
 
6.8%
0 614
 
6.5%
5 430
 
4.5%
6 326
 
3.4%
7 301
 
3.2%
8 282
 
3.0%
9 245
 
2.6%
Other Punctuation
ValueCountFrequency (%)
, 132
65.7%
. 27
 
13.4%
· 26
 
12.9%
/ 6
 
3.0%
" 4
 
2.0%
* 2
 
1.0%
; 2
 
1.0%
: 2
 
1.0%
Lowercase Letter
ValueCountFrequency (%)
c 11
31.4%
t 6
17.1%
v 6
17.1%
z 3
 
8.6%
i 3
 
8.6%
p 3
 
8.6%
a 2
 
5.7%
y 1
 
2.9%
Close Punctuation
ValueCountFrequency (%)
) 2399
93.9%
] 148
 
5.8%
」 6
 
0.2%
』 2
 
0.1%
］ 1
 
< 0.1%
Open Punctuation
ValueCountFrequency (%)
( 2398
93.9%
[ 148
 
5.8%
「 6
 
0.2%
『 2
 
0.1%
［ 1
 
< 0.1%
Space Separator
ValueCountFrequency (%)
26076
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 473
100.0%
Math Symbol
ValueCountFrequency (%)
~ 30
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 25
100.0%
Letter Number
ValueCountFrequency (%)
Ⅰ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 134969
76.3%
Common 41398
 
23.4%
Latin 573
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 10612
 
7.9%
공 9558
 
7.1%
리 5527
 
4.1%
수 4889
 
3.6%
로 4035
 
3.0%
정 3437
 
2.5%
장 3272
 
2.4%
설 2995
 
2.2%
비 2765
 
2.0%
배 2323
 
1.7%
Other values (637) 85556
63.4%
Common
ValueCountFrequency (%)
26076
63.0%
1 2798
 
6.8%
2 2716
 
6.6%
) 2399
 
5.8%
( 2398
 
5.8%
3 1124
 
2.7%
4 646
 
1.6%
0 614
 
1.5%
- 473
 
1.1%
5 430
 
1.0%
Other values (22) 1724
 
4.2%
Latin
ValueCountFrequency (%)
C 154
26.9%
V 76
13.3%
T 76
13.3%
E 56
 
9.8%
L 56
 
9.8%
D 52
 
9.1%
P 12
 
2.1%
A 11
 
1.9%
c 11
 
1.9%
I 9
 
1.6%
Other values (18) 60
 
10.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 134969
76.3%
ASCII 41926
 
23.7%
None 44
 
< 0.1%
Number Forms 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
26076
62.2%
1 2798
 
6.7%
2 2716
 
6.5%
) 2399
 
5.7%
( 2398
 
5.7%
3 1124
 
2.7%
4 646
 
1.5%
0 614
 
1.5%
- 473
 
1.1%
5 430
 
1.0%
Other values (42) 2252
 
5.4%
Hangul
ValueCountFrequency (%)
사 10612
 
7.9%
공 9558
 
7.1%
리 5527
 
4.1%
수 4889
 
3.6%
로 4035
 
3.0%
정 3437
 
2.5%
장 3272
 
2.4%
설 2995
 
2.2%
비 2765
 
2.0%
배 2323
 
1.7%
Other values (637) 85556
63.4%
None
ValueCountFrequency (%)
· 26
59.1%
「 6
 
13.6%
」 6
 
13.6%
『 2
 
4.5%
』 2
 
4.5%
］ 1
 
2.3%
［ 1
 
2.3%
Number Forms
ValueCountFrequency (%)
Ⅰ 1
100.0%

계약금액
Real number (ℝ)

SKEWED 

Distinct5407
Distinct (%)54.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11061021
Minimum159000
Maximum2.23495 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:28:58.399730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum159000
5-th percentile1600000
Q14430000
median8245000
Q313540000
95-th percentile19678100
Maximum2.23495 × 109
Range2.234791 × 109
Interquartile range (IQR)9110000

Descriptive statistics

Standard deviation39213034
Coefficient of variation (CV)3.545155
Kurtosis2002.8527
Mean11061021
Median Absolute Deviation (MAD)4363610
Skewness41.078017
Sum1.1061021 × 1011
Variance1.537662 × 1015
MonotonicityNot monotonic
2024-01-10T07:28:58.550304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4750000 92
 
0.9%
9500000 58
 
0.6%
7600000 57
 
0.6%
2850000 51
 
0.5%
18000000 49
 
0.5%
3800000 46
 
0.5%
9300000 45
 
0.4%
9000000 42
 
0.4%
3000000 37
 
0.4%
4700000 34
 
0.3%
Other values (5397) 9489
94.9%
ValueCountFrequency (%)
159000 1
 
< 0.1%
165000 1
 
< 0.1%
250000 1
 
< 0.1%
296290 1
 
< 0.1%
300000 1
 
< 0.1%
310000 1
 
< 0.1%
330000 4
< 0.1%
378010 1
 
< 0.1%
396000 1
 
< 0.1%
400000 6
0.1%
ValueCountFrequency (%)
2234950000 1
< 0.1%
1847590000 1
< 0.1%
1779850000 1
< 0.1%
1118856000 1
< 0.1%
620542000 1
< 0.1%
400000640 1
< 0.1%
393316680 1
< 0.1%
390505350 1
< 0.1%
326880000 1
< 0.1%
302112000 1
< 0.1%

계약일
Date

Distinct1980
Distinct (%)19.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2014-01-21 00:00:00
Maximum2022-09-20 00:00:00
2024-01-10T07:28:58.679286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:28:58.787896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

계약상대자
Text

Distinct1106
Distinct (%)11.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-01-10T07:28:59.002767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length17
Mean length7.3089
Min length2

Characters and Unicode

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

Unique

Unique413 ?
Unique (%)4.1%

Sample

1st row보령지하수개발
2nd row(주)일동건설
3rd row(주)영보산업
4th row삼보산업개발(주)
5th row보령시산림조합
ValueCountFrequency (%)
주식회사 1422
 
12.3%
신천건설(주 202
 
1.8%
우리토건(주 200
 
1.7%
유)네오건설 188
 
1.6%
주)럭키건설 185
 
1.6%
주)씨제이 177
 
1.5%
대한건설(주 144
 
1.2%
주)천마건설엔지니어링 143
 
1.2%
주)거산 142
 
1.2%
주)무한건설 134
 
1.2%
Other values (1081) 8590
74.5%
2024-01-10T07:28:59.314072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 7830
 
10.7%
( 6096
 
8.3%
) 6075
 
8.3%
건 5210
 
7.1%
설 4596
 
6.3%
사 2184
 
3.0%
회 1987
 
2.7%
식 1938
 
2.7%
산 1713
 
2.3%
1527
 
2.1%
Other values (350) 33933
46.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 59325
81.2%
Open Punctuation 6096
 
8.3%
Close Punctuation 6075
 
8.3%
Space Separator 1527
 
2.1%
Other Punctuation 34
 
< 0.1%
Uppercase Letter 27
 
< 0.1%
Other Symbol 4
 
< 0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 7830
 
13.2%
건 5210
 
8.8%
설 4596
 
7.7%
사 2184
 
3.7%
회 1987
 
3.3%
식 1938
 
3.3%
산 1713
 
2.9%
보 1301
 
2.2%
업 1228
 
2.1%
이 1080
 
1.8%
Other values (333) 30258
51.0%
Uppercase Letter
ValueCountFrequency (%)
N 8
29.6%
E 6
22.2%
C 4
14.8%
S 3
 
11.1%
H 1
 
3.7%
M 1
 
3.7%
R 1
 
3.7%
V 1
 
3.7%
T 1
 
3.7%
G 1
 
3.7%
Other Punctuation
ValueCountFrequency (%)
. 33
97.1%
, 1
 
2.9%
Open Punctuation
ValueCountFrequency (%)
( 6096
100.0%
Close Punctuation
ValueCountFrequency (%)
) 6075
100.0%
Space Separator
ValueCountFrequency (%)
1527
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 4
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 59329
81.2%
Common 13733
 
18.8%
Latin 27
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 7830
 
13.2%
건 5210
 
8.8%
설 4596
 
7.7%
사 2184
 
3.7%
회 1987
 
3.3%
식 1938
 
3.3%
산 1713
 
2.9%
보 1301
 
2.2%
업 1228
 
2.1%
이 1080
 
1.8%
Other values (334) 30262
51.0%
Latin
ValueCountFrequency (%)
N 8
29.6%
E 6
22.2%
C 4
14.8%
S 3
 
11.1%
H 1
 
3.7%
M 1
 
3.7%
R 1
 
3.7%
V 1
 
3.7%
T 1
 
3.7%
G 1
 
3.7%
Common
ValueCountFrequency (%)
( 6096
44.4%
) 6075
44.2%
1527
 
11.1%
. 33
 
0.2%
- 1
 
< 0.1%
, 1
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 59322
81.2%
ASCII 13760
 
18.8%
None 4
 
< 0.1%
Compat Jamo 3
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 7830
 
13.2%
건 5210
 
8.8%
설 4596
 
7.7%
사 2184
 
3.7%
회 1987
 
3.3%
식 1938
 
3.3%
산 1713
 
2.9%
보 1301
 
2.2%
업 1228
 
2.1%
이 1080
 
1.8%
Other values (330) 30255
51.0%
ASCII
ValueCountFrequency (%)
( 6096
44.3%
) 6075
44.1%
1527
 
11.1%
. 33
 
0.2%
N 8
 
0.1%
E 6
 
< 0.1%
C 4
 
< 0.1%
S 3
 
< 0.1%
H 1
 
< 0.1%
M 1
 
< 0.1%
Other values (6) 6
 
< 0.1%
None
ValueCountFrequency (%)
㈜ 4
100.0%
Compat Jamo
ValueCountFrequency (%)
ㄹ 1
33.3%
ㅓ 1
33.3%
ㅅ 1
33.3%

Interactions

2024-01-10T07:28:56.799876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:28:56.611992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:28:56.881722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:28:56.704964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T07:28:59.395401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호관서명계약금액
번호1.0000.2350.025
관서명0.2351.0000.000
계약금액0.0250.0001.000
2024-01-10T07:28:59.464993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호계약금액관서명
번호1.0000.0160.089
계약금액0.0161.0000.000
관서명0.0890.0001.000

Missing values

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

번호관서명계약방법계약명계약금액계약일계약상대자
45264527천북면수의1인견적2017년 가뭄극복 긴급대책 농업용 관정개발(신덕1지구)135400002017-07-14보령지하수개발
23802381본청수의1인견적봉당2리 마을안길 정비공사 계약의뢰146630002016-02-18(주)일동건설
62856286주교면수의1인견적고정1리(400-1) 농로 확포장공사50800002018-11-01(주)영보산업
76427643본청수의1인견적궁포리 농로포장 및 배수로 정비공사180530002019-10-08삼보산업개발(주)
797798본청수의1인견적2014년 조림지풀베기(남부2) 사업1397797802014-06-10보령시산림조합
40334034남포면수의1인견적읍내천 유지보수공사67200002017-04-13(주)광종건설
750751대천2동수의1인견적대천32통 쉼터 지붕설치 공사50000002014-05-27대흥우드산업(주)
75107511본청수의1인견적한내초등학교앞 인도정비공사46013302019-08-13에스에이치건설 주식회사
1169511696본청수의1인견적파손시설물(문자전광판) 철거공사6300002022-07-08삼원환경산업(주)
24472448대천1동수의1인견적죽정1통 배수로 설치공사35150002016-02-29(주)무한건설
번호관서명계약방법계약명계약금액계약일계약상대자
1185411855대천4동수의1인견적명천2통 정자 이전 설치공사(생활민원사업)106600002022-09-07주식회사 디에이치건설
23592360성주면수의1인견적청사 블라인드 교체공사39600002016-02-12현대커텐,지업사
695696문화체육관리사업소수의1인견적보령문화의전당 옥외안내간판 설치공사148980002014-05-19해오름주식회사
57315732청라면수의1인견적옥계1리(시궁골) 마을진입로 정비공사79320002018-05-18(주)동진건설
1067410675대천5동수의1인견적생앵산 등산로 정비공사40670002022-02-16부국건설(주)
1118211183대천4동수의1인견적흥곡천 산책로 장미터널 조성공사197900002022-04-07우성(주)
813814웅천읍수의1인견적무창포해수욕장 수상안전 부표 설치 공사95000002014-06-13한국해양구조단보령시지역대
10641065미산면수의1인견적옥현리 마을안길 및 배수로 정비 공사비69890002014-11-12천마건설E.N
89188919천북면수의1인견적천북면사무소 화장실 장애인 편의시설 설치52250002020-08-25보령건축크리닉
76817682본청수의1인견적청라209호(명대계곡) 주차장 정비공사92800002019-10-17한내기업(주)