Overview

Dataset statistics

Number of variables7
Number of observations10000
Missing cells18
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=15090098

Alerts

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

Reproduction

Analysis started2024-01-09 22:28:51.196760
Analysis finished2024-01-09 22:28:52.512803
Duration1.32 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%
Mean6847.7661
Minimum1
Maximum13672
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:28:52.569738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile711.95
Q13442.5
median6834
Q310258.25
95-th percentile13001.05
Maximum13672
Range13671
Interquartile range (IQR)6815.75

Descriptive statistics

Standard deviation3945.3548
Coefficient of variation (CV)0.5761521
Kurtosis-1.1973928
Mean6847.7661
Median Absolute Deviation (MAD)3409.5
Skewness0.0039990913
Sum68477661
Variance15565825
MonotonicityNot monotonic
2024-01-10T07:28:52.699131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
768 1
 
< 0.1%
12475 1
 
< 0.1%
4336 1
 
< 0.1%
1825 1
 
< 0.1%
6223 1
 
< 0.1%
3053 1
 
< 0.1%
7271 1
 
< 0.1%
4465 1
 
< 0.1%
12940 1
 
< 0.1%
10079 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%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
11 1
< 0.1%
ValueCountFrequency (%)
13672 1
< 0.1%
13669 1
< 0.1%
13667 1
< 0.1%
13664 1
< 0.1%
13662 1
< 0.1%
13661 1
< 0.1%
13658 1
< 0.1%
13657 1
< 0.1%
13656 1
< 0.1%
13654 1
< 0.1%

관서명
Categorical

Distinct23
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
본청
3325 
웅천읍
651 
천북면
601 
주교면
574 
주산면
533 
Other values (18)
4316 

Length

Max length9
Median length3
Mean length2.8695
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
본청 3325
33.2%
웅천읍 651
 
6.5%
천북면 601
 
6.0%
주교면 574
 
5.7%
주산면 533
 
5.3%
청소면 516
 
5.2%
청라면 506
 
5.1%
남포면 467
 
4.7%
오천면 460
 
4.6%
미산면 441
 
4.4%
Other values (13) 1926
19.3%

Length

2024-01-10T07:28:52.819921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
본청 3325
33.2%
웅천읍 651
 
6.5%
천북면 601
 
6.0%
주교면 574
 
5.7%
주산면 533
 
5.3%
청소면 516
 
5.2%
청라면 506
 
5.1%
남포면 467
 
4.7%
오천면 460
 
4.6%
미산면 441
 
4.4%
Other values (13) 1926
19.3%

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

Common Values (Plot)

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

계약명
Text

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

Length

Max length45
Median length37
Mean length18.1505
Min length7

Characters and Unicode

Total characters181505
Distinct characters716
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

Unique8990 ?
Unique (%)89.9%

Sample

1st row외연도 가고싶은섬 시설물정비공사
2nd row동대2통 마을안길 덧씌우기 공사
3rd row월전2리 마을안길 정비공사
4th row개화리 배수로 정비공사
5th row창동1리 배수로 복개공사
ValueCountFrequency (%)
배수로 1889
 
5.2%
정비공사 1671
 
4.6%
공사 1122
 
3.1%
설치공사 1033
 
2.8%
마을안길 911
 
2.5%
및 907
 
2.5%
시행결의 620
 
1.7%
보수공사 563
 
1.5%
포장공사 561
 
1.5%
설치 335
 
0.9%
Other values (7701) 27028
73.8%
2024-01-10T07:28:53.784834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
26640
 
14.7%
사 10654
 
5.9%
공 9553
 
5.3%
리 5656
 
3.1%
수 4939
 
2.7%
로 4151
 
2.3%
정 3584
 
2.0%
장 3171
 
1.7%
1 3084
 
1.7%
설 3034
 
1.7%
Other values (706) 107039
59.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 136174
75.0%
Space Separator 26640
 
14.7%
Decimal Number 10958
 
6.0%
Close Punctuation 3095
 
1.7%
Open Punctuation 3090
 
1.7%
Dash Punctuation 730
 
0.4%
Uppercase Letter 527
 
0.3%
Other Punctuation 200
 
0.1%
Connector Punctuation 41
 
< 0.1%
Math Symbol 28
 
< 0.1%
Other values (2) 22
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 10654
 
7.8%
공 9553
 
7.0%
리 5656
 
4.2%
수 4939
 
3.6%
로 4151
 
3.0%
정 3584
 
2.6%
장 3171
 
2.3%
설 3034
 
2.2%
비 2788
 
2.0%
배 2481
 
1.8%
Other values (646) 86163
63.3%
Uppercase Letter
ValueCountFrequency (%)
C 136
25.8%
V 68
12.9%
T 67
12.7%
E 66
12.5%
L 61
11.6%
D 59
11.2%
A 13
 
2.5%
P 13
 
2.5%
I 12
 
2.3%
F 6
 
1.1%
Other values (9) 26
 
4.9%
Decimal Number
ValueCountFrequency (%)
1 3084
28.1%
2 2949
26.9%
3 1300
11.9%
4 763
 
7.0%
0 678
 
6.2%
5 543
 
5.0%
6 485
 
4.4%
8 430
 
3.9%
7 398
 
3.6%
9 328
 
3.0%
Lowercase Letter
ValueCountFrequency (%)
c 4
19.0%
p 3
14.3%
z 3
14.3%
i 3
14.3%
e 2
9.5%
v 2
9.5%
t 2
9.5%
y 1
 
4.8%
a 1
 
4.8%
Other Punctuation
ValueCountFrequency (%)
, 130
65.0%
· 27
 
13.5%
. 25
 
12.5%
/ 8
 
4.0%
" 4
 
2.0%
* 2
 
1.0%
: 2
 
1.0%
; 2
 
1.0%
Close Punctuation
ValueCountFrequency (%)
) 2872
92.8%
] 213
 
6.9%
」 8
 
0.3%
』 2
 
0.1%
Open Punctuation
ValueCountFrequency (%)
( 2867
92.8%
[ 213
 
6.9%
「 8
 
0.3%
『 2
 
0.1%
Math Symbol
ValueCountFrequency (%)
~ 27
96.4%
+ 1
 
3.6%
Space Separator
ValueCountFrequency (%)
26640
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 730
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 41
100.0%
Letter Number
ValueCountFrequency (%)
Ⅰ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 136174
75.0%
Common 44782
 
24.7%
Latin 549
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 10654
 
7.8%
공 9553
 
7.0%
리 5656
 
4.2%
수 4939
 
3.6%
로 4151
 
3.0%
정 3584
 
2.6%
장 3171
 
2.3%
설 3034
 
2.2%
비 2788
 
2.0%
배 2481
 
1.8%
Other values (646) 86163
63.3%
Common
ValueCountFrequency (%)
26640
59.5%
1 3084
 
6.9%
2 2949
 
6.6%
) 2872
 
6.4%
( 2867
 
6.4%
3 1300
 
2.9%
4 763
 
1.7%
- 730
 
1.6%
0 678
 
1.5%
5 543
 
1.2%
Other values (21) 2356
 
5.3%
Latin
ValueCountFrequency (%)
C 136
24.8%
V 68
12.4%
T 67
12.2%
E 66
12.0%
L 61
11.1%
D 59
10.7%
A 13
 
2.4%
P 13
 
2.4%
I 12
 
2.2%
F 6
 
1.1%
Other values (19) 48
 
8.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 136174
75.0%
ASCII 45283
 
24.9%
None 47
 
< 0.1%
Number Forms 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
26640
58.8%
1 3084
 
6.8%
2 2949
 
6.5%
) 2872
 
6.3%
( 2867
 
6.3%
3 1300
 
2.9%
4 763
 
1.7%
- 730
 
1.6%
0 678
 
1.5%
5 543
 
1.2%
Other values (44) 2857
 
6.3%
Hangul
ValueCountFrequency (%)
사 10654
 
7.8%
공 9553
 
7.0%
리 5656
 
4.2%
수 4939
 
3.6%
로 4151
 
3.0%
정 3584
 
2.6%
장 3171
 
2.3%
설 3034
 
2.2%
비 2788
 
2.0%
배 2481
 
1.8%
Other values (646) 86163
63.3%
None
ValueCountFrequency (%)
· 27
57.4%
「 8
 
17.0%
」 8
 
17.0%
』 2
 
4.3%
『 2
 
4.3%
Number Forms
ValueCountFrequency (%)
Ⅰ 1
100.0%

계약금액
Real number (ℝ)

SKEWED 

Distinct5453
Distinct (%)54.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean10827388
Minimum110000
Maximum1.77985 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T07:28:53.911406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum110000
5-th percentile1625000
Q14500000
median8400000
Q313773975
95-th percentile19700000
Maximum1.77985 × 109
Range1.77974 × 109
Interquartile range (IQR)9273975

Descriptive statistics

Standard deviation30602153
Coefficient of variation (CV)2.8263652
Kurtosis1769.7998
Mean10827388
Median Absolute Deviation (MAD)4460000
Skewness37.510343
Sum1.0827388 × 1011
Variance9.364918 × 1014
MonotonicityNot monotonic
2024-01-10T07:28:54.032756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4750000 97
 
1.0%
9500000 54
 
0.5%
2850000 51
 
0.5%
7600000 46
 
0.5%
9300000 43
 
0.4%
9000000 41
 
0.4%
3800000 40
 
0.4%
18000000 37
 
0.4%
19800000 35
 
0.4%
13500000 33
 
0.3%
Other values (5443) 9523
95.2%
ValueCountFrequency (%)
110000 1
< 0.1%
159000 1
< 0.1%
165000 1
< 0.1%
231000 1
< 0.1%
250000 2
< 0.1%
270000 1
< 0.1%
280000 1
< 0.1%
296290 1
< 0.1%
300000 2
< 0.1%
310000 1
< 0.1%
ValueCountFrequency (%)
1779850000 1
< 0.1%
1315460000 1
< 0.1%
1118856000 1
< 0.1%
1039916000 1
< 0.1%
620542000 1
< 0.1%
390505350 1
< 0.1%
350330000 1
< 0.1%
326880000 1
< 0.1%
292000000 1
< 0.1%
275376160 1
< 0.1%

계약일
Date

Distinct2168
Distinct (%)21.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2014-01-13 00:00:00
Maximum2023-11-03 00:00:00
2024-01-10T07:28:54.146674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:28:54.256911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

계약상대자
Text

Distinct1143
Distinct (%)11.5%
Missing18
Missing (%)0.2%
Memory size156.2 KiB
2024-01-10T07:28:54.443940image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length17
Mean length7.3563414
Min length2

Characters and Unicode

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

Unique

Unique432 ?
Unique (%)4.3%

Sample

1st row(주)수림나무병원
2nd row산수개발(주)
3rd row혜성건설
4th row(주)진성건설
5th row삼보건설 주식회사
ValueCountFrequency (%)
주식회사 1610
 
13.8%
신천건설(주 198
 
1.7%
우리토건(주 190
 
1.6%
주)럭키건설 173
 
1.5%
유)네오건설 173
 
1.5%
주)씨제이 163
 
1.4%
대한건설(주 150
 
1.3%
주)거산 137
 
1.2%
주)천마건설엔지니어링 137
 
1.2%
주)무한건설 121
 
1.0%
Other values (1119) 8637
73.9%
2024-01-10T07:28:55.000916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 7950
 
10.8%
( 5917
 
8.1%
) 5896
 
8.0%
건 5252
 
7.2%
설 4643
 
6.3%
사 2419
 
3.3%
회 2242
 
3.1%
식 2181
 
3.0%
1707
 
2.3%
산 1691
 
2.3%
Other values (356) 33533
45.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 59841
81.5%
Open Punctuation 5917
 
8.1%
Close Punctuation 5896
 
8.0%
Space Separator 1707
 
2.3%
Other Punctuation 32
 
< 0.1%
Uppercase Letter 20
 
< 0.1%
Decimal Number 10
 
< 0.1%
Other Symbol 7
 
< 0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 7950
 
13.3%
건 5252
 
8.8%
설 4643
 
7.8%
사 2419
 
4.0%
회 2242
 
3.7%
식 2181
 
3.6%
산 1691
 
2.8%
보 1255
 
2.1%
업 1229
 
2.1%
이 1098
 
1.8%
Other values (334) 29881
49.9%
Uppercase Letter
ValueCountFrequency (%)
N 6
30.0%
C 4
20.0%
E 4
20.0%
H 1
 
5.0%
W 1
 
5.0%
A 1
 
5.0%
V 1
 
5.0%
T 1
 
5.0%
S 1
 
5.0%
Decimal Number
ValueCountFrequency (%)
8 3
30.0%
3 2
20.0%
1 2
20.0%
2 1
 
10.0%
9 1
 
10.0%
5 1
 
10.0%
Other Punctuation
ValueCountFrequency (%)
. 31
96.9%
, 1
 
3.1%
Open Punctuation
ValueCountFrequency (%)
( 5917
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5896
100.0%
Space Separator
ValueCountFrequency (%)
1707
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 7
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 59848
81.5%
Common 13563
 
18.5%
Latin 20
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 7950
 
13.3%
건 5252
 
8.8%
설 4643
 
7.8%
사 2419
 
4.0%
회 2242
 
3.7%
식 2181
 
3.6%
산 1691
 
2.8%
보 1255
 
2.1%
업 1229
 
2.1%
이 1098
 
1.8%
Other values (335) 29888
49.9%
Common
ValueCountFrequency (%)
( 5917
43.6%
) 5896
43.5%
1707
 
12.6%
. 31
 
0.2%
8 3
 
< 0.1%
3 2
 
< 0.1%
1 2
 
< 0.1%
- 1
 
< 0.1%
2 1
 
< 0.1%
9 1
 
< 0.1%
Other values (2) 2
 
< 0.1%
Latin
ValueCountFrequency (%)
N 6
30.0%
C 4
20.0%
E 4
20.0%
H 1
 
5.0%
W 1
 
5.0%
A 1
 
5.0%
V 1
 
5.0%
T 1
 
5.0%
S 1
 
5.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 59841
81.5%
ASCII 13583
 
18.5%
None 7
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 7950
 
13.3%
건 5252
 
8.8%
설 4643
 
7.8%
사 2419
 
4.0%
회 2242
 
3.7%
식 2181
 
3.6%
산 1691
 
2.8%
보 1255
 
2.1%
업 1229
 
2.1%
이 1098
 
1.8%
Other values (334) 29881
49.9%
ASCII
ValueCountFrequency (%)
( 5917
43.6%
) 5896
43.4%
1707
 
12.6%
. 31
 
0.2%
N 6
 
< 0.1%
C 4
 
< 0.1%
E 4
 
< 0.1%
8 3
 
< 0.1%
3 2
 
< 0.1%
1 2
 
< 0.1%
Other values (11) 11
 
0.1%
None
ValueCountFrequency (%)
㈜ 7
100.0%

Interactions

2024-01-10T07:28:52.113341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:28:51.940603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:28:52.213498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:28:52.024693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T07:28:55.080477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호관서명계약금액
번호1.0000.2380.013
관서명0.2381.0000.000
계약금액0.0130.0001.000
2024-01-10T07:28:55.149071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호계약금액관서명
번호1.0000.0290.090
계약금액0.0291.0000.000
관서명0.0900.0001.000

Missing values

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

번호관서명계약방법계약명계약금액계약일계약상대자
767768본청수의1인견적외연도 가고싶은섬 시설물정비공사98000002014-05-30(주)수림나무병원
1136611367대천3동수의1인견적동대2통 마을안길 덧씌우기 공사79920002022-05-10산수개발(주)
70827083남포면수의1인견적월전2리 마을안길 정비공사46000002019-04-18혜성건설
92479248본청수의1인견적개화리 배수로 정비공사169722502021-01-11(주)진성건설
86558656남포면수의1인견적창동1리 배수로 복개공사29200002020-05-21삼보건설 주식회사
48434844청소면수의1인견적성연1리 마을안길 덧씌우기공사88000002017-11-08주식회사 도화
59115912청라면수의1인견적내현2리 마을안길 아스콘 덧씌우기공사141730002018-06-21(주)도화
612613미산면수의1인견적봉성리 농로확포장 공사비62950002014-05-01에스아이건설(주)
98949895주산면수의1인견적화평1리 농가진입로 포장공사65740002021-05-17아성산업개발
76867687본청수의1인견적청라터널 터널등 정비공사119350002019-10-17대양이엔지
번호관서명계약방법계약명계약금액계약일계약상대자
1091910920미산면수의1인견적풍계리배수로정비(지역)68860002022-03-07조우건설(주)
63526353청소면수의1인견적정전2리 배수로 정비공사 준공금70900002018-11-08태성종합건설
70357036청소면수의1인견적신송1리 배수로 정비공사 준공금47000002019-04-15(주)홍광산업
16221623대천1동수의1인견적죽정2통 정자설치공사94000002015-04-01(주)씨제이
65136514청라면수의1인견적청라면 장현리 도로가각정리 및 덮개설치공사 준공금16500002018-12-10조우건설
44264427본청수의1인견적근로자 종합복지관 발코니 타일 교체공사38500002017-06-22이레건축
1338613387본청수의1인견적관산리(451-16) 배수로 설치공사125100002023-07-11신천건설(주)
93179318천북면수의1인견적하만1리 수로관 설치공사54900002021-02-17동방건설 주식회사
53665367대천2동수의1인견적대천17통 중앙시장길 포장 및 배수로 정비47260002018-03-13(주)정명건설
61076108오천면수의1인견적녹도리 배수로 정비공사33200002018-08-14영진건설(주)