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 = 39.34293715)Skewed
번호 has unique valuesUnique

Reproduction

Analysis started2024-01-09 22:28:46.493093
Analysis finished2024-01-09 22:28:47.782739
Duration1.29 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%
Mean5941.9314
Minimum2
Maximum11879
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:28:47.847153image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile598.95
Q12972.5
median5945.5
Q38922.25
95-th percentile11282.05
Maximum11879
Range11877
Interquartile range (IQR)5949.75

Descriptive statistics

Standard deviation3426.5017
Coefficient of variation (CV)0.57666464
Kurtosis-1.2026019
Mean5941.9314
Median Absolute Deviation (MAD)2975.5
Skewness-5.4625869 × 10-5
Sum59419314
Variance11740914
MonotonicityNot monotonic
2024-01-10T07:28:48.237014image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
851 1
 
< 0.1%
2157 1
 
< 0.1%
2161 1
 
< 0.1%
2791 1
 
< 0.1%
2104 1
 
< 0.1%
2300 1
 
< 0.1%
5958 1
 
< 0.1%
7448 1
 
< 0.1%
2043 1
 
< 0.1%
5228 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%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
11 1
< 0.1%
ValueCountFrequency (%)
11879 1
< 0.1%
11878 1
< 0.1%
11875 1
< 0.1%
11874 1
< 0.1%
11873 1
< 0.1%
11872 1
< 0.1%
11871 1
< 0.1%
11870 1
< 0.1%
11869 1
< 0.1%
11868 1
< 0.1%

관서명
Categorical

Distinct22
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
본청
3328 
웅천읍
620 
천북면
596 
주교면
581 
청소면
559 
Other values (17)
4316 

Length

Max length9
Median length3
Mean length2.8743
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row본청
2nd row남포면
3rd row웅천읍
4th row대천3동
5th row본청

Common Values

ValueCountFrequency (%)
본청 3328
33.3%
웅천읍 620
 
6.2%
천북면 596
 
6.0%
주교면 581
 
5.8%
청소면 559
 
5.6%
주산면 540
 
5.4%
청라면 501
 
5.0%
남포면 465
 
4.7%
오천면 440
 
4.4%
미산면 433
 
4.3%
Other values (12) 1937
19.4%

Length

2024-01-10T07:28:48.350779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
본청 3328
33.3%
웅천읍 620
 
6.2%
천북면 596
 
6.0%
주교면 581
 
5.8%
청소면 559
 
5.6%
주산면 540
 
5.4%
청라면 501
 
5.0%
남포면 465
 
4.7%
오천면 440
 
4.4%
미산면 433
 
4.3%
Other values (12) 1937
19.4%

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

Common Values (Plot)

2024-01-10T07:28:48.532715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
수의1인견적 10000
100.0%
Distinct9264
Distinct (%)92.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-01-10T07:28:48.821846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length39
Mean length17.6852
Min length6

Characters and Unicode

Total characters176852
Distinct characters711
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

Unique8814 ?
Unique (%)88.1%

Sample

1st row불법 주정차 무인단속CCTV 이전설치(보령문화의 전당)
2nd row삼현리 도로 보수공사 시행결의(생활민원사업)
3rd row웅천생활문화센터 외벽 도색공사
4th row화산2통 흙카페 앞 마을안길 정비공사
5th row2022년 사방댐사업(관산지구)
ValueCountFrequency (%)
배수로 1793
 
5.0%
정비공사 1646
 
4.6%
공사 1075
 
3.0%
설치공사 979
 
2.7%
마을안길 968
 
2.7%
884
 
2.4%
포장공사 559
 
1.5%
보수공사 556
 
1.5%
시행결의 398
 
1.1%
설치 331
 
0.9%
Other values (7298) 26897
74.5%
2024-01-10T07:28:49.269026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
26086
 
14.8%
10589
 
6.0%
9563
 
5.4%
5538
 
3.1%
4902
 
2.8%
4075
 
2.3%
3428
 
1.9%
3229
 
1.8%
3024
 
1.7%
1 2806
 
1.6%
Other values (701) 103612
58.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 134848
76.2%
Space Separator 26086
 
14.8%
Decimal Number 9540
 
5.4%
Close Punctuation 2545
 
1.4%
Open Punctuation 2543
 
1.4%
Uppercase Letter 542
 
0.3%
Dash Punctuation 474
 
0.3%
Other Punctuation 189
 
0.1%
Lowercase Letter 31
 
< 0.1%
Math Symbol 30
 
< 0.1%
Other values (2) 24
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
10589
 
7.9%
9563
 
7.1%
5538
 
4.1%
4902
 
3.6%
4075
 
3.0%
3428
 
2.5%
3229
 
2.4%
3024
 
2.2%
2773
 
2.1%
2328
 
1.7%
Other values (640) 85399
63.3%
Uppercase Letter
ValueCountFrequency (%)
C 150
27.7%
V 74
13.7%
T 73
13.5%
L 61
11.3%
E 61
11.3%
D 56
 
10.3%
A 13
 
2.4%
P 12
 
2.2%
I 10
 
1.8%
U 7
 
1.3%
Other values (9) 25
 
4.6%
Decimal Number
ValueCountFrequency (%)
1 2806
29.4%
2 2733
28.6%
3 1145
12.0%
4 637
 
6.7%
0 627
 
6.6%
5 432
 
4.5%
6 327
 
3.4%
7 300
 
3.1%
8 298
 
3.1%
9 235
 
2.5%
Other Punctuation
ValueCountFrequency (%)
, 124
65.6%
· 26
 
13.8%
. 26
 
13.8%
/ 5
 
2.6%
; 3
 
1.6%
* 2
 
1.1%
" 2
 
1.1%
: 1
 
0.5%
Lowercase Letter
ValueCountFrequency (%)
c 9
29.0%
v 5
16.1%
t 5
16.1%
z 3
 
9.7%
i 3
 
9.7%
p 3
 
9.7%
a 2
 
6.5%
y 1
 
3.2%
Close Punctuation
ValueCountFrequency (%)
) 2387
93.8%
] 149
 
5.9%
7
 
0.3%
1
 
< 0.1%
1
 
< 0.1%
Open Punctuation
ValueCountFrequency (%)
( 2385
93.8%
[ 149
 
5.9%
7
 
0.3%
1
 
< 0.1%
1
 
< 0.1%
Math Symbol
ValueCountFrequency (%)
~ 29
96.7%
+ 1
 
3.3%
Space Separator
ValueCountFrequency (%)
26086
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 474
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 23
100.0%
Letter Number
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 134848
76.2%
Common 41430
 
23.4%
Latin 574
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
10589
 
7.9%
9563
 
7.1%
5538
 
4.1%
4902
 
3.6%
4075
 
3.0%
3428
 
2.5%
3229
 
2.4%
3024
 
2.2%
2773
 
2.1%
2328
 
1.7%
Other values (640) 85399
63.3%
Common
ValueCountFrequency (%)
26086
63.0%
1 2806
 
6.8%
2 2733
 
6.6%
) 2387
 
5.8%
( 2385
 
5.8%
3 1145
 
2.8%
4 637
 
1.5%
0 627
 
1.5%
- 474
 
1.1%
5 432
 
1.0%
Other values (23) 1718
 
4.1%
Latin
ValueCountFrequency (%)
C 150
26.1%
V 74
12.9%
T 73
12.7%
L 61
10.6%
E 61
10.6%
D 56
 
9.8%
A 13
 
2.3%
P 12
 
2.1%
I 10
 
1.7%
c 9
 
1.6%
Other values (18) 55
 
9.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 134848
76.2%
ASCII 41959
 
23.7%
None 44
 
< 0.1%
Number Forms 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
26086
62.2%
1 2806
 
6.7%
2 2733
 
6.5%
) 2387
 
5.7%
( 2385
 
5.7%
3 1145
 
2.7%
4 637
 
1.5%
0 627
 
1.5%
- 474
 
1.1%
5 432
 
1.0%
Other values (43) 2247
 
5.4%
Hangul
ValueCountFrequency (%)
10589
 
7.9%
9563
 
7.1%
5538
 
4.1%
4902
 
3.6%
4075
 
3.0%
3428
 
2.5%
3229
 
2.4%
3024
 
2.2%
2773
 
2.1%
2328
 
1.7%
Other values (640) 85399
63.3%
None
ValueCountFrequency (%)
· 26
59.1%
7
 
15.9%
7
 
15.9%
1
 
2.3%
1
 
2.3%
1
 
2.3%
1
 
2.3%
Number Forms
ValueCountFrequency (%)
1
100.0%

계약금액
Real number (ℝ)

SKEWED 

Distinct5387
Distinct (%)53.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean10921726
Minimum159000
Maximum1.84759 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:28:49.394898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum159000
5-th percentile1583815
Q14410000
median8300000
Q313525000
95-th percentile19700000
Maximum1.84759 × 109
Range1.847431 × 109
Interquartile range (IQR)9115000

Descriptive statistics

Standard deviation32826993
Coefficient of variation (CV)3.0056597
Kurtosis1979.4271
Mean10921726
Median Absolute Deviation (MAD)4400000
Skewness39.342937
Sum1.0921726 × 1011
Variance1.0776115 × 1015
MonotonicityNot monotonic
2024-01-10T07:28:49.509589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4750000 89
 
0.9%
9500000 55
 
0.5%
2850000 54
 
0.5%
7600000 52
 
0.5%
18000000 47
 
0.5%
9000000 42
 
0.4%
9300000 40
 
0.4%
3800000 39
 
0.4%
5700000 36
 
0.4%
3000000 35
 
0.4%
Other values (5377) 9511
95.1%
ValueCountFrequency (%)
159000 1
 
< 0.1%
165000 1
 
< 0.1%
250000 2
 
< 0.1%
270000 1
 
< 0.1%
300000 2
 
< 0.1%
310000 1
 
< 0.1%
330000 3
< 0.1%
378010 1
 
< 0.1%
400000 7
0.1%
422400 1
 
< 0.1%
ValueCountFrequency (%)
1847590000 1
< 0.1%
1779850000 1
< 0.1%
1118856000 1
< 0.1%
620542000 1
< 0.1%
482079190 1
< 0.1%
400000640 1
< 0.1%
393316680 1
< 0.1%
390505350 1
< 0.1%
350330000 1
< 0.1%
326880000 1
< 0.1%
Distinct1966
Distinct (%)19.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2014-01-21 00:00:00
Maximum2022-09-20 00:00:00
2024-01-10T07:28:49.622792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:28:49.731339image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct1090
Distinct (%)10.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-01-10T07:28:49.947631image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length17
Mean length7.2979
Min length2

Characters and Unicode

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

Unique

Unique394 ?
Unique (%)3.9%

Sample

1st row(주)에너지코리아
2nd row(주)충보건설
3rd row(주)연오도장공사
4th row신보령 주식회사
5th row보령시산림조합
ValueCountFrequency (%)
주식회사 1425
 
12.4%
우리토건(주 206
 
1.8%
신천건설(주 195
 
1.7%
유)네오건설 185
 
1.6%
주)씨제이 180
 
1.6%
주)럭키건설 177
 
1.5%
주)거산 151
 
1.3%
대한건설(주 142
 
1.2%
보령시산림조합 137
 
1.2%
주)무한건설 134
 
1.2%
Other values (1067) 8595
74.6%
2024-01-10T07:28:50.313786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7831
 
10.7%
( 6089
 
8.3%
) 6067
 
8.3%
5218
 
7.2%
4579
 
6.3%
2187
 
3.0%
1998
 
2.7%
1949
 
2.7%
1728
 
2.4%
1527
 
2.1%
Other values (355) 33806
46.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 59222
81.1%
Open Punctuation 6089
 
8.3%
Close Punctuation 6067
 
8.3%
Space Separator 1527
 
2.1%
Other Punctuation 35
 
< 0.1%
Uppercase Letter 24
 
< 0.1%
Decimal Number 10
 
< 0.1%
Other Symbol 4
 
< 0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
7831
 
13.2%
5218
 
8.8%
4579
 
7.7%
2187
 
3.7%
1998
 
3.4%
1949
 
3.3%
1728
 
2.9%
1318
 
2.2%
1230
 
2.1%
1078
 
1.8%
Other values (332) 30106
50.8%
Uppercase Letter
ValueCountFrequency (%)
N 7
29.2%
E 5
20.8%
S 3
12.5%
C 3
12.5%
V 1
 
4.2%
M 1
 
4.2%
T 1
 
4.2%
R 1
 
4.2%
G 1
 
4.2%
H 1
 
4.2%
Decimal Number
ValueCountFrequency (%)
8 3
30.0%
1 2
20.0%
3 2
20.0%
9 1
 
10.0%
5 1
 
10.0%
2 1
 
10.0%
Other Punctuation
ValueCountFrequency (%)
. 33
94.3%
, 2
 
5.7%
Open Punctuation
ValueCountFrequency (%)
( 6089
100.0%
Close Punctuation
ValueCountFrequency (%)
) 6067
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 59226
81.2%
Common 13729
 
18.8%
Latin 24
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
7831
 
13.2%
5218
 
8.8%
4579
 
7.7%
2187
 
3.7%
1998
 
3.4%
1949
 
3.3%
1728
 
2.9%
1318
 
2.2%
1230
 
2.1%
1078
 
1.8%
Other values (333) 30110
50.8%
Common
ValueCountFrequency (%)
( 6089
44.4%
) 6067
44.2%
1527
 
11.1%
. 33
 
0.2%
8 3
 
< 0.1%
, 2
 
< 0.1%
1 2
 
< 0.1%
3 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%
V 1
 
4.2%
M 1
 
4.2%
T 1
 
4.2%
R 1
 
4.2%
G 1
 
4.2%
H 1
 
4.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 59219
81.1%
ASCII 13753
 
18.8%
None 4
 
< 0.1%
Compat Jamo 3
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
7831
 
13.2%
5218
 
8.8%
4579
 
7.7%
2187
 
3.7%
1998
 
3.4%
1949
 
3.3%
1728
 
2.9%
1318
 
2.2%
1230
 
2.1%
1078
 
1.8%
Other values (329) 30103
50.8%
ASCII
ValueCountFrequency (%)
( 6089
44.3%
) 6067
44.1%
1527
 
11.1%
. 33
 
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%
None
ValueCountFrequency (%)
4
100.0%
Compat Jamo
ValueCountFrequency (%)
1
33.3%
1
33.3%
1
33.3%

Interactions

2024-01-10T07:28:47.406703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:28:47.241772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:28:47.493751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:28:47.317693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T07:28:50.395984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호관서명계약금액
번호1.0000.2380.025
관서명0.2381.0000.000
계약금액0.0250.0001.000
2024-01-10T07:28:50.476299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호계약금액관서명
번호1.0000.0080.090
계약금액0.0081.0000.000
관서명0.0900.0001.000

Missing values

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

번호관서명계약방법계약명계약금액계약일계약상대자
850851본청수의1인견적불법 주정차 무인단속CCTV 이전설치(보령문화의 전당)70290002014-06-27(주)에너지코리아
1149411495남포면수의1인견적삼현리 도로 보수공사 시행결의(생활민원사업)13200002022-05-30(주)충보건설
38413842웅천읍수의1인견적웅천생활문화센터 외벽 도색공사91000002017-03-08(주)연오도장공사
95009501대천3동수의1인견적화산2통 흙카페 앞 마을안길 정비공사131780002021-03-16신보령 주식회사
1109011091본청수의1인견적2022년 사방댐사업(관산지구)1423880002022-03-23보령시산림조합
1059110592주교면수의1인견적[생활민원] 신대2리 배수로 정비공사19140002021-12-27보령건설중기
68956896본청수의1인견적시청사 분전함 등 내부 교체공사179700002019-03-19장원전기 주식회사
250251대천5동수의1인견적남곡3통 배수로 정비공사(2)121500002014-03-08(주)씨제이
67266727웅천읍수의1인견적수부1리 마을(관정) 도로포장공사87000002019-03-05(주)진성건설
54595460본청수의1인견적도로표지판 정비공사110000002018-03-26대신종합건축
번호관서명계약방법계약명계약금액계약일계약상대자
77387739청라면수의1인견적소양1리 배수로 정비공사 시행결의52000002019-10-28(주)씨제이
94899490대천1동수의1인견적죽정1통 보강토 블럭쌓기 공사123178502021-03-16(주)동진건설
1122611227본청수의1인견적2022 충청남도체육대회 궁도장 사면보강공사106200002022-04-15지에이치건설 주식회사
7576본청수의1인견적관창3리 배수로 정비공사138000002014-02-25(주)청원건설
26542655미산면수의1인견적청사 페인트 도색76000002016-03-25미래로페인트
47654766미산면수의1인견적내평리 공동작업장 주차장 포장공사93100002017-10-25도화건설
18121813본청수의1인견적대천해수욕장 물놀이 안전부표 설치용역192377202015-05-26세종해양개발
57905791본청수의1인견적2018년 향토숲 관리사업100000002018-05-31주식회사 보령영림공사
97099710대천1동수의1인견적대천12통 마을안길 하수도 정비공사117740002021-04-12동방건설 주식회사
25522553대천1동수의1인견적건강교실 샤워장 보수공사123435002016-03-14남강건설산업(주)