Overview

Dataset statistics

Number of variables6
Number of observations241
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.7 KiB
Average record size in memory49.5 B

Variable types

Categorical2
Text2
DateTime1
Numeric1

Dataset

Description충청북도 진천군 물품계약현황은 우리군에서 체결한 물품계약현황으로 관서명, 계약방법, 계약명, 계약금액, 계약일, 계약상대자를 보여주는 데이터임.
Author충청북도 진천군
URLhttps://www.data.go.kr/data/15064044/fileData.do

Alerts

계약관서 has constant value ""Constant
계약방법 is highly imbalanced (81.4%)Imbalance

Reproduction

Analysis started2024-03-14 20:04:16.629753
Analysis finished2024-03-14 20:04:18.163150
Duration1.53 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

계약관서
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
본청
241 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row본청
2nd row본청
3rd row본청
4th row본청
5th row본청

Common Values

ValueCountFrequency (%)
본청 241
100.0%

Length

2024-03-15T05:04:18.383208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T05:04:18.702785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
본청 241
100.0%

계약명
Text

Distinct237
Distinct (%)98.3%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2024-03-15T05:04:19.565770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length55
Median length42
Mean length32.344398
Min length11

Characters and Unicode

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

Unique

Unique233 ?
Unique (%)96.7%

Sample

1st row군청사 사무실 등 사무집기 구매(회계과)
2nd row드림스타트 가족미션 챌린지 프로그램 진행에 따른 설명절 꾸러미(떡국) 구입(가족친화과)
3rd row군정홍보용 촬영 카메라 세트 구입(홍보미디어실)
4th row2023년 설맞이 사회복지시설 위문 물품 구입 집행(주민복지과)
5th rowGPS 측량장비 구입(민원토지과)
ValueCountFrequency (%)
2023년 46
 
3.9%
위한 26
 
2.2%
공공폐수처리시설 21
 
1.8%
구입 19
 
1.6%
관급자재 17
 
1.4%
및 15
 
1.3%
진천군 13
 
1.1%
따른 12
 
1.0%
2023년도 12
 
1.0%
구입(산림녹지과 9
 
0.8%
Other values (692) 990
83.9%
2024-03-15T05:04:20.937689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
949
 
12.2%
( 342
 
4.4%
) 342
 
4.4%
과 203
 
2.6%
지 158
 
2.0%
설 144
 
1.8%
2 143
 
1.8%
구 117
 
1.5%
산 106
 
1.4%
기 105
 
1.3%
Other values (452) 5186
66.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5719
73.4%
Space Separator 949
 
12.2%
Close Punctuation 358
 
4.6%
Open Punctuation 357
 
4.6%
Decimal Number 301
 
3.9%
Uppercase Letter 76
 
1.0%
Other Punctuation 18
 
0.2%
Lowercase Letter 13
 
0.2%
Dash Punctuation 4
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
과 203
 
3.5%
지 158
 
2.8%
설 144
 
2.5%
구 117
 
2.0%
산 106
 
1.9%
기 105
 
1.8%
자 102
 
1.8%
공 99
 
1.7%
입 98
 
1.7%
사 90
 
1.6%
Other values (401) 4497
78.6%
Uppercase Letter
ValueCountFrequency (%)
S 10
13.2%
T 10
13.2%
C 9
11.8%
E 6
7.9%
M 6
7.9%
V 5
 
6.6%
K 5
 
6.6%
P 5
 
6.6%
I 4
 
5.3%
L 3
 
3.9%
Other values (9) 13
17.1%
Decimal Number
ValueCountFrequency (%)
2 143
47.5%
0 65
21.6%
3 65
21.6%
7 6
 
2.0%
4 6
 
2.0%
1 6
 
2.0%
5 3
 
1.0%
8 3
 
1.0%
9 2
 
0.7%
6 2
 
0.7%
Lowercase Letter
ValueCountFrequency (%)
o 3
23.1%
r 2
15.4%
l 2
15.4%
e 1
 
7.7%
t 1
 
7.7%
n 1
 
7.7%
g 1
 
7.7%
k 1
 
7.7%
i 1
 
7.7%
Open Punctuation
ValueCountFrequency (%)
( 342
95.8%
「 7
 
2.0%
[ 4
 
1.1%
『 4
 
1.1%
Close Punctuation
ValueCountFrequency (%)
) 342
95.5%
」 7
 
2.0%
] 5
 
1.4%
』 4
 
1.1%
Other Punctuation
ValueCountFrequency (%)
· 9
50.0%
, 8
44.4%
/ 1
 
5.6%
Space Separator
ValueCountFrequency (%)
949
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5718
73.4%
Common 1987
 
25.5%
Latin 89
 
1.1%
Han 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
과 203
 
3.6%
지 158
 
2.8%
설 144
 
2.5%
구 117
 
2.0%
산 106
 
1.9%
기 105
 
1.8%
자 102
 
1.8%
공 99
 
1.7%
입 98
 
1.7%
사 90
 
1.6%
Other values (400) 4496
78.6%
Latin
ValueCountFrequency (%)
S 10
 
11.2%
T 10
 
11.2%
C 9
 
10.1%
E 6
 
6.7%
M 6
 
6.7%
V 5
 
5.6%
K 5
 
5.6%
P 5
 
5.6%
I 4
 
4.5%
L 3
 
3.4%
Other values (18) 26
29.2%
Common
ValueCountFrequency (%)
949
47.8%
( 342
 
17.2%
) 342
 
17.2%
2 143
 
7.2%
0 65
 
3.3%
3 65
 
3.3%
· 9
 
0.5%
, 8
 
0.4%
」 7
 
0.4%
「 7
 
0.4%
Other values (13) 50
 
2.5%
Han
ValueCountFrequency (%)
無 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5718
73.4%
ASCII 2045
 
26.2%
None 31
 
0.4%
CJK 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
949
46.4%
( 342
 
16.7%
) 342
 
16.7%
2 143
 
7.0%
0 65
 
3.2%
3 65
 
3.2%
S 10
 
0.5%
T 10
 
0.5%
C 9
 
0.4%
, 8
 
0.4%
Other values (36) 102
 
5.0%
Hangul
ValueCountFrequency (%)
과 203
 
3.6%
지 158
 
2.8%
설 144
 
2.5%
구 117
 
2.0%
산 106
 
1.9%
기 105
 
1.8%
자 102
 
1.8%
공 99
 
1.7%
입 98
 
1.7%
사 90
 
1.6%
Other values (400) 4496
78.6%
None
ValueCountFrequency (%)
· 9
29.0%
」 7
22.6%
「 7
22.6%
』 4
12.9%
『 4
12.9%
CJK
ValueCountFrequency (%)
無 1
100.0%

계약방법
Categorical

IMBALANCE 

Distinct5
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
수의1인견적
226 
수의2인이상견적
 
8
제한경쟁
 
5
지명경쟁
 
1
일반경쟁
 
1

Length

Max length8
Median length6
Mean length6.0082988
Min length4

Unique

Unique2 ?
Unique (%)0.8%

Sample

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

Common Values

ValueCountFrequency (%)
수의1인견적 226
93.8%
수의2인이상견적 8
 
3.3%
제한경쟁 5
 
2.1%
지명경쟁 1
 
0.4%
일반경쟁 1
 
0.4%

Length

2024-03-15T05:04:21.185056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T05:04:21.473700image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
수의1인견적 226
93.8%
수의2인이상견적 8
 
3.3%
제한경쟁 5
 
2.1%
지명경쟁 1
 
0.4%
일반경쟁 1
 
0.4%

계약일자
Date

Distinct138
Distinct (%)57.3%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
Minimum2023-01-06 00:00:00
Maximum2023-12-29 00:00:00
2024-03-15T05:04:21.680304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T05:04:21.943512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

계약금액
Real number (ℝ)

Distinct220
Distinct (%)91.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean45830906
Minimum1980000
Maximum2.3243699 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.2 KiB
2024-03-15T05:04:22.199585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1980000
5-th percentile2860000
Q15260000
median9150000
Q318480000
95-th percentile1.25808 × 108
Maximum2.3243699 × 109
Range2.3223899 × 109
Interquartile range (IQR)13220000

Descriptive statistics

Standard deviation1.9237248 × 108
Coefficient of variation (CV)4.1974401
Kurtosis96.599333
Mean45830906
Median Absolute Deviation (MAD)4995800
Skewness9.2209758
Sum1.1045248 × 1010
Variance3.7007171 × 1016
MonotonicityNot monotonic
2024-03-15T05:04:22.679190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2860000 4
 
1.7%
20000000 3
 
1.2%
7700000 3
 
1.2%
7300000 2
 
0.8%
6200000 2
 
0.8%
5280000 2
 
0.8%
15200000 2
 
0.8%
88000000 2
 
0.8%
18480000 2
 
0.8%
12600000 2
 
0.8%
Other values (210) 217
90.0%
ValueCountFrequency (%)
1980000 1
0.4%
2061600 1
0.4%
2081900 1
0.4%
2100000 1
0.4%
2300000 1
0.4%
2420000 1
0.4%
2500000 1
0.4%
2600000 1
0.4%
2640000 1
0.4%
2770000 1
0.4%
ValueCountFrequency (%)
2324369920 1
0.4%
1503228800 1
0.4%
844349120 1
0.4%
462732090 1
0.4%
390000000 1
0.4%
373190200 1
0.4%
340818530 1
0.4%
289000000 1
0.4%
203000000 1
0.4%
200558520 1
0.4%

계약상대자
Text

Distinct172
Distinct (%)71.4%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2024-03-15T05:04:23.577996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length12
Mean length7.0373444
Min length2

Characters and Unicode

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

Unique

Unique133 ?
Unique (%)55.2%

Sample

1st row중부사무용가구
2nd row진천농협하나로마트
3rd row브로드코어
4th row진천축산업협동조합 벽암지점
5th row한양측량시스템
ValueCountFrequency (%)
주식회사 46
 
15.3%
희성정보통신 13
 
4.3%
오투기획 7
 
2.3%
스카이광고 5
 
1.7%
알파환경식품 3
 
1.0%
좋은날 3
 
1.0%
아주c&d 3
 
1.0%
진천서점 3
 
1.0%
주)네오이엔지 3
 
1.0%
와이에스기업 3
 
1.0%
Other values (173) 211
70.3%
2024-03-15T05:04:25.040742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 110
 
6.5%
사 74
 
4.4%
이 61
 
3.6%
60
 
3.5%
( 56
 
3.3%
) 56
 
3.3%
식 56
 
3.3%
회 55
 
3.2%
스 36
 
2.1%
기 27
 
1.6%
Other values (249) 1105
65.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1505
88.7%
Space Separator 60
 
3.5%
Open Punctuation 56
 
3.3%
Close Punctuation 56
 
3.3%
Uppercase Letter 16
 
0.9%
Other Punctuation 3
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 110
 
7.3%
사 74
 
4.9%
이 61
 
4.1%
식 56
 
3.7%
회 55
 
3.7%
스 36
 
2.4%
기 27
 
1.8%
성 24
 
1.6%
보 22
 
1.5%
신 22
 
1.5%
Other values (235) 1018
67.6%
Uppercase Letter
ValueCountFrequency (%)
C 4
25.0%
D 3
18.8%
R 2
12.5%
P 1
 
6.2%
F 1
 
6.2%
T 1
 
6.2%
G 1
 
6.2%
S 1
 
6.2%
E 1
 
6.2%
M 1
 
6.2%
Space Separator
ValueCountFrequency (%)
60
100.0%
Open Punctuation
ValueCountFrequency (%)
( 56
100.0%
Close Punctuation
ValueCountFrequency (%)
) 56
100.0%
Other Punctuation
ValueCountFrequency (%)
& 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1505
88.7%
Common 175
 
10.3%
Latin 16
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 110
 
7.3%
사 74
 
4.9%
이 61
 
4.1%
식 56
 
3.7%
회 55
 
3.7%
스 36
 
2.4%
기 27
 
1.8%
성 24
 
1.6%
보 22
 
1.5%
신 22
 
1.5%
Other values (235) 1018
67.6%
Latin
ValueCountFrequency (%)
C 4
25.0%
D 3
18.8%
R 2
12.5%
P 1
 
6.2%
F 1
 
6.2%
T 1
 
6.2%
G 1
 
6.2%
S 1
 
6.2%
E 1
 
6.2%
M 1
 
6.2%
Common
ValueCountFrequency (%)
60
34.3%
( 56
32.0%
) 56
32.0%
& 3
 
1.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1505
88.7%
ASCII 191
 
11.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 110
 
7.3%
사 74
 
4.9%
이 61
 
4.1%
식 56
 
3.7%
회 55
 
3.7%
스 36
 
2.4%
기 27
 
1.8%
성 24
 
1.6%
보 22
 
1.5%
신 22
 
1.5%
Other values (235) 1018
67.6%
ASCII
ValueCountFrequency (%)
60
31.4%
( 56
29.3%
) 56
29.3%
C 4
 
2.1%
& 3
 
1.6%
D 3
 
1.6%
R 2
 
1.0%
P 1
 
0.5%
F 1
 
0.5%
T 1
 
0.5%
Other values (4) 4
 
2.1%

Interactions

2024-03-15T05:04:17.223395image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T05:04:25.193254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
계약방법계약금액
계약방법1.0000.000
계약금액0.0001.000
2024-03-15T05:04:25.466082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
계약금액계약방법
계약금액1.0000.000
계약방법0.0001.000

Missing values

2024-03-15T05:04:17.616277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T05:04:18.026656image/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

계약관서계약명계약방법계약일자계약금액계약상대자
0본청군청사 사무실 등 사무집기 구매(회계과)수의1인견적2023-01-0616606000중부사무용가구
1본청드림스타트 가족미션 챌린지 프로그램 진행에 따른 설명절 꾸러미(떡국) 구입(가족친화과)수의1인견적2023-01-103933000진천농협하나로마트
2본청군정홍보용 촬영 카메라 세트 구입(홍보미디어실)수의1인견적2023-01-1113750000브로드코어
3본청2023년 설맞이 사회복지시설 위문 물품 구입 집행(주민복지과)수의1인견적2023-01-118456500진천축산업협동조합 벽암지점
4본청GPS 측량장비 구입(민원토지과)수의1인견적2023-01-1120000000한양측량시스템
5본청진천·음성 광역폐기물 재활용선별시설 증설사업 물품(간판 등) 구입(식산업자원과)수의1인견적2023-01-1618372000싸인아트
6본청「양화 풍수해생활권 종합정비사업」관급자재(혼합쇄석 및 잡석) 구입(이월확정)제한경쟁2023-01-16155008040주식회사 보정골재
7본청2023년 주요업무계획 책자 제작(기획감사실)수의1인견적2023-01-176370000오투기획
8본청2023년 주요 진천군정 소책자 제작(기획감사실)수의1인견적2023-01-175600000오투기획
9본청진천·음성 광역폐기물 재활용선별시설 증설 장비(지게차) 구입(식산업자원과)수의1인견적2023-01-1949200000삼성클라크지게차
계약관서계약명계약방법계약일자계약금액계약상대자
231본청희망복지지원단 취약계층 건강지원 특화사업 진행을 위한 물품 구입(가정용혈압기 외 1종)(주민복지과)수의1인견적2023-12-182860000대영의료기
232본청2024년 갑진년 연하장 제작(행정지원과)수의1인견적2023-12-196600000오투기획
233본청제설 차량(충북06고9048) 윈터 타이어 구입(회계과)수의1인견적2023-12-207000000국희카공업사
234본청진천 스토리창작클러스터 도어락 구입 계약 집행수의2인이상견적2023-12-215270000열쇠박사
235본청2024년도 직원업무수첩 제작(행정지원과)수의1인견적2023-12-2218450000오투기획
236본청정보통신시설 운영 관련 소모품 구입(허브, 흡착기)수의1인견적2023-12-224086000희성정보통신
237본청충북혁신도시 복합혁신센터 공연장 안내데스크 구입(투자전략실)수의1인견적2023-12-272500000봉인테리어
238본청제설제(소금) 응급 구입(건설교통과)수의1인견적2023-12-2718480000알파환경식품
239본청진천·음성 광역폐기물 침출수처리시설 처리수배관 세척설비 구입(식산업자원과)수의1인견적2023-12-2950000000아세아프로텍
240본청참숯힐빙센터 전통숯가마 집진시설 제작설치 사업(산림녹지과)수의1인견적2023-12-29289000000(쭈)케이에프