Overview

Dataset statistics

Number of variables7
Number of observations1932
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory109.6 KiB
Average record size in memory58.1 B

Variable types

Categorical2
DateTime1
Text2
Numeric2

Dataset

Description최근 6년간 식재료 입찰정보를 제공합니다.공고일자, 발주처, 입찰건명, 요구년도, 판단번호, 금액 정보가 수록되어 있습니다.
Author방위사업청
URLhttps://www.data.go.kr/data/15061923/fileData.do

Alerts

구분 has constant value ""Constant
요구년도 is highly overall correlated with 금액High correlation
금액 is highly overall correlated with 요구년도High correlation

Reproduction

Analysis started2023-12-16 15:44:20.071326
Analysis finished2023-12-16 15:44:25.249787
Duration5.18 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size15.2 KiB
식재료
1932 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row식재료
2nd row식재료
3rd row식재료
4th row식재료
5th row식재료

Common Values

ValueCountFrequency (%)
식재료 1932
100.0%

Length

2023-12-16T15:44:25.528862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:44:26.006143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
식재료 1932
100.0%

공고일자
Date

Distinct480
Distinct (%)24.8%
Missing0
Missing (%)0.0%
Memory size15.2 KiB
Minimum2018-01-09 00:00:00
Maximum2023-09-21 00:00:00
2023-12-16T15:44:26.533199image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:44:27.433490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

발주처
Categorical

Distinct39
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size15.2 KiB
해군군수사령부
637 
급식유류계약팀
434 
제3130부대
382 
제1862부대
129 
제2217부대
120 
Other values (34)
230 

Length

Max length12
Median length7
Mean length7.0326087
Min length5

Unique

Unique8 ?
Unique (%)0.4%

Sample

1st row제5378부대
2nd row제17보병사단
3rd row제17보병사단
4th row제17보병사단
5th row제17보병사단

Common Values

ValueCountFrequency (%)
해군군수사령부 637
33.0%
급식유류계약팀 434
22.5%
제3130부대 382
19.8%
제1862부대 129
 
6.7%
제2217부대 120
 
6.2%
제7789부대 63
 
3.3%
제5378부대 56
 
2.9%
제7162부대 12
 
0.6%
제17보병사단 8
 
0.4%
제1989부대 8
 
0.4%
Other values (29) 83
 
4.3%

Length

2023-12-16T15:44:28.721070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
해군군수사령부 637
32.9%
급식유류계약팀 434
22.4%
제3130부대 382
19.7%
제1862부대 129
 
6.7%
제2217부대 120
 
6.2%
제7789부대 63
 
3.3%
제5378부대 56
 
2.9%
제7162부대 12
 
0.6%
제17보병사단 8
 
0.4%
제1989부대 8
 
0.4%
Other values (31) 88
 
4.5%

입찰건명
Text

Distinct945
Distinct (%)48.9%
Missing0
Missing (%)0.0%
Memory size15.2 KiB
2023-12-16T15:44:29.561443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length32
Median length26
Mean length11.73499
Min length1

Characters and Unicode

Total characters22672
Distinct characters425
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

Unique457 ?
Unique (%)23.7%

Sample

1st row'18년 설날 경축특식 구매
2nd row18년 예비군 도시락 제조납품(3권역)
3rd row18년 예비군 도시락 제조납품(4권역)
4th row18년 예비군 도시락 제조납품(2권역)
5th row18년 예비군 도시락 제조납품(1권역)
ValueCountFrequency (%)
구매 763
 
16.1%
부대계약 166
 
3.5%
부대조달 140
 
3.0%
식자재 124
 
2.6%
22년 120
 
2.5%
경축특식 109
 
2.3%
23년 85
 
1.8%
등 79
 
1.7%
제조 40
 
0.8%
23-2차 36
 
0.8%
Other values (915) 3069
64.9%
2023-12-16T15:44:31.225729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2799
 
12.3%
구 809
 
3.6%
매 803
 
3.5%
) 787
 
3.5%
( 787
 
3.5%
식 746
 
3.3%
2 692
 
3.1%
부 426
 
1.9%
대 369
 
1.6%
품 348
 
1.5%
Other values (415) 14106
62.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 16307
71.9%
Space Separator 2799
 
12.3%
Decimal Number 1500
 
6.6%
Close Punctuation 787
 
3.5%
Open Punctuation 787
 
3.5%
Other Punctuation 235
 
1.0%
Dash Punctuation 178
 
0.8%
Uppercase Letter 32
 
0.1%
Connector Punctuation 22
 
0.1%
Math Symbol 17
 
0.1%
Other values (2) 8
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 809
 
5.0%
매 803
 
4.9%
식 746
 
4.6%
부 426
 
2.6%
대 369
 
2.3%
품 348
 
2.1%
년 317
 
1.9%
조 314
 
1.9%
스 298
 
1.8%
자 285
 
1.7%
Other values (387) 11592
71.1%
Decimal Number
ValueCountFrequency (%)
2 692
46.1%
3 287
19.1%
1 216
 
14.4%
0 69
 
4.6%
9 61
 
4.1%
8 58
 
3.9%
4 51
 
3.4%
5 35
 
2.3%
6 16
 
1.1%
7 15
 
1.0%
Other Punctuation
ValueCountFrequency (%)
' 152
64.7%
, 25
 
10.6%
. 24
 
10.2%
/ 21
 
8.9%
· 13
 
5.5%
Uppercase Letter
ValueCountFrequency (%)
B 12
37.5%
L 9
28.1%
A 7
21.9%
S 4
 
12.5%
Math Symbol
ValueCountFrequency (%)
~ 16
94.1%
+ 1
 
5.9%
Space Separator
ValueCountFrequency (%)
2799
100.0%
Close Punctuation
ValueCountFrequency (%)
) 787
100.0%
Open Punctuation
ValueCountFrequency (%)
( 787
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 178
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 22
100.0%
Final Punctuation
ValueCountFrequency (%)
’ 6
100.0%
Initial Punctuation
ValueCountFrequency (%)
‘ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 16307
71.9%
Common 6333
 
27.9%
Latin 32
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 809
 
5.0%
매 803
 
4.9%
식 746
 
4.6%
부 426
 
2.6%
대 369
 
2.3%
품 348
 
2.1%
년 317
 
1.9%
조 314
 
1.9%
스 298
 
1.8%
자 285
 
1.7%
Other values (387) 11592
71.1%
Common
ValueCountFrequency (%)
2799
44.2%
) 787
 
12.4%
( 787
 
12.4%
2 692
 
10.9%
3 287
 
4.5%
1 216
 
3.4%
- 178
 
2.8%
' 152
 
2.4%
0 69
 
1.1%
9 61
 
1.0%
Other values (14) 305
 
4.8%
Latin
ValueCountFrequency (%)
B 12
37.5%
L 9
28.1%
A 7
21.9%
S 4
 
12.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 16307
71.9%
ASCII 6344
 
28.0%
None 13
 
0.1%
Punctuation 8
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2799
44.1%
) 787
 
12.4%
( 787
 
12.4%
2 692
 
10.9%
3 287
 
4.5%
1 216
 
3.4%
- 178
 
2.8%
' 152
 
2.4%
0 69
 
1.1%
9 61
 
1.0%
Other values (15) 316
 
5.0%
Hangul
ValueCountFrequency (%)
구 809
 
5.0%
매 803
 
4.9%
식 746
 
4.6%
부 426
 
2.6%
대 369
 
2.3%
품 348
 
2.1%
년 317
 
1.9%
조 314
 
1.9%
스 298
 
1.8%
자 285
 
1.7%
Other values (387) 11592
71.1%
None
ValueCountFrequency (%)
· 13
100.0%
Punctuation
ValueCountFrequency (%)
’ 6
75.0%
‘ 2
 
25.0%

요구년도
Real number (ℝ)

HIGH CORRELATION 

Distinct6
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2020.6454
Minimum2018
Maximum2023
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size17.1 KiB
2023-12-16T15:44:31.956280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2018
5-th percentile2018
Q12019
median2021
Q32022
95-th percentile2023
Maximum2023
Range5
Interquartile range (IQR)3

Descriptive statistics

Standard deviation1.7878307
Coefficient of variation (CV)0.000884782
Kurtosis-1.3495963
Mean2020.6454
Median Absolute Deviation (MAD)1
Skewness-0.25834488
Sum3903887
Variance3.1963386
MonotonicityNot monotonic
2023-12-16T15:44:32.590026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
2022 484
25.1%
2018 392
20.3%
2023 326
16.9%
2021 312
16.1%
2019 227
11.7%
2020 191
 
9.9%
ValueCountFrequency (%)
2018 392
20.3%
2019 227
11.7%
2020 191
 
9.9%
2021 312
16.1%
2022 484
25.1%
2023 326
16.9%
ValueCountFrequency (%)
2023 326
16.9%
2022 484
25.1%
2021 312
16.1%
2020 191
 
9.9%
2019 227
11.7%
2018 392
20.3%

판단번호
Text

Distinct1558
Distinct (%)80.6%
Missing0
Missing (%)0.0%
Memory size15.2 KiB
2023-12-16T15:44:34.246247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length8
Mean length4.484472
Min length2

Characters and Unicode

Total characters8664
Distinct characters21
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1240 ?
Unique (%)64.2%

Sample

1st row458
2nd row818
3rd row819
4th row817
5th row816
ValueCountFrequency (%)
1190 5
 
0.3%
1f65a 4
 
0.2%
8287 4
 
0.2%
1d66a 4
 
0.2%
1e66a 4
 
0.2%
4348 4
 
0.2%
1830a 4
 
0.2%
1f66a 4
 
0.2%
1d65a 4
 
0.2%
1e65a 3
 
0.2%
Other values (1548) 1892
97.9%
2023-12-16T15:44:36.476820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 1528
17.6%
2 969
11.2%
3 863
10.0%
4 792
9.1%
5 749
8.6%
0 689
8.0%
6 660
7.6%
8 602
 
6.9%
9 580
 
6.7%
7 553
 
6.4%
Other values (11) 679
7.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 7985
92.2%
Uppercase Letter 637
 
7.4%
Other Punctuation 21
 
0.2%
Math Symbol 21
 
0.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 1528
19.1%
2 969
12.1%
3 863
10.8%
4 792
9.9%
5 749
9.4%
0 689
8.6%
6 660
8.3%
8 602
 
7.5%
9 580
 
7.3%
7 553
 
6.9%
Uppercase Letter
ValueCountFrequency (%)
A 171
26.8%
F 150
23.5%
D 150
23.5%
E 139
21.8%
B 10
 
1.6%
C 8
 
1.3%
G 5
 
0.8%
J 3
 
0.5%
H 1
 
0.2%
Other Punctuation
ValueCountFrequency (%)
. 21
100.0%
Math Symbol
ValueCountFrequency (%)
+ 21
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 8027
92.6%
Latin 637
 
7.4%

Most frequent character per script

Common
ValueCountFrequency (%)
1 1528
19.0%
2 969
12.1%
3 863
10.8%
4 792
9.9%
5 749
9.3%
0 689
8.6%
6 660
8.2%
8 602
 
7.5%
9 580
 
7.2%
7 553
 
6.9%
Other values (2) 42
 
0.5%
Latin
ValueCountFrequency (%)
A 171
26.8%
F 150
23.5%
D 150
23.5%
E 139
21.8%
B 10
 
1.6%
C 8
 
1.3%
G 5
 
0.8%
J 3
 
0.5%
H 1
 
0.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 8664
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 1528
17.6%
2 969
11.2%
3 863
10.0%
4 792
9.1%
5 749
8.6%
0 689
8.0%
6 660
7.6%
8 602
 
6.9%
9 580
 
6.7%
7 553
 
6.4%
Other values (11) 679
7.8%

금액
Real number (ℝ)

HIGH CORRELATION 

Distinct1371
Distinct (%)71.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.4760462 × 108
Minimum172854
Maximum1.9155722 × 1010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size17.1 KiB
2023-12-16T15:44:37.559560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum172854
5-th percentile3672000
Q117896000
median59118550
Q32.8004762 × 108
95-th percentile3.6474655 × 109
Maximum1.9155722 × 1010
Range1.9155549 × 1010
Interquartile range (IQR)2.6215162 × 108

Descriptive statistics

Standard deviation1.7604514 × 109
Coefficient of variation (CV)2.7184046
Kurtosis31.764926
Mean6.4760462 × 108
Median Absolute Deviation (MAD)52199750
Skewness4.9988935
Sum1.2511721 × 1012
Variance3.0991892 × 1018
MonotonicityNot monotonic
2023-12-16T15:44:38.590721image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
22500000.0 6
 
0.3%
48230000.0 6
 
0.3%
230135675.0 5
 
0.3%
125523000.0 5
 
0.3%
5548000000.0 5
 
0.3%
57480000.0 4
 
0.2%
981000.0 4
 
0.2%
55098000.0 4
 
0.2%
15300000.0 4
 
0.2%
50590500.0 4
 
0.2%
Other values (1361) 1885
97.6%
ValueCountFrequency (%)
172854.0 1
 
0.1%
663617.0 1
 
0.1%
682086.0 2
0.1%
704446.0 1
 
0.1%
739667.0 1
 
0.1%
787500.0 1
 
0.1%
840000.0 2
0.1%
981000.0 4
0.2%
1061940.0 3
0.2%
1086480.0 4
0.2%
ValueCountFrequency (%)
19155722050.0 1
0.1%
18773390250.0 1
0.1%
16605910082.0 1
0.1%
14868154767.0 1
0.1%
14605512876.0 1
0.1%
13646473596.0 1
0.1%
11849056300.0 2
0.1%
11688275280.0 1
0.1%
11608366707.0 2
0.1%
11498924120.0 2
0.1%

Interactions

2023-12-16T15:44:22.795702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:44:21.791830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:44:23.440238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:44:22.164088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-16T15:44:39.175623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
발주처요구년도금액
발주처1.0000.8050.428
요구년도0.8051.0000.325
금액0.4280.3251.000
2023-12-16T15:44:39.635478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
요구년도금액발주처
요구년도1.000-0.5380.489
금액-0.5381.0000.160
발주처0.4890.1601.000

Missing values

2023-12-16T15:44:24.297576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-16T15:44:25.036795image/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식재료2018-01-09제5378부대'18년 설날 경축특식 구매2018458163347000.0
1식재료2018-01-15제17보병사단18년 예비군 도시락 제조납품(3권역)2018818412290000.0
2식재료2018-01-15제17보병사단18년 예비군 도시락 제조납품(4권역)2018819426030000.0
3식재료2018-01-15제17보병사단18년 예비군 도시락 제조납품(2권역)2018817444864000.0
4식재료2018-01-15제17보병사단18년 예비군 도시락 제조납품(1권역)2018816680496000.0
5식재료2018-01-15제7789부대설날 경축특식(과자세트) 제조 / 구매20181063125523000.0
6식재료2018-01-15제7789부대3·1절 경축특식(조각케익 세트) 제조 / 구매20181066125523000.0
7식재료2018-01-17제7789부대발효유(짜먹는 발효유)20181162616200000.0
8식재료2018-01-17제7789부대빙과류(샌드형)20181164575120000.0
9식재료2018-01-17제7789부대견과류201811531263210000.0
구분공고일자발주처입찰건명요구년도판단번호금액
1922식재료2023-08-22제3130부대23-4차 부대계약 식자재 납품(식육가공품류)(제조)202336638104084870.0
1923식재료2023-08-22제3130부대23-4차 부대계약 식자재 납품(부식)2023366392213254480.0
1924식재료2023-08-24제3130부대'23년 국군의날 경축특식 에그타르트(제조)20233704496285000.0
1925식재료2023-08-29제3130부대23-4차 부대계약 식자재 납품(식육가공품류)(제조)202336638104084870.0
1926식재료2023-09-05제3130부대23-4차 부대계약 식자재 납품(식육가공품류)202338762104084877.0
1927식재료2023-09-05제3130부대23-4차 부대계약 식자재 납품(빵류)202338752117396024.0
1928식재료2023-09-07제7162부대23.10월 부대계약 부식 냉동빵·상온보관용빵(B143)20233907937477380.0
1929식재료2023-09-14제3130부대'23년 4분기 부대계약 증식(컵밥 등 5종)20234025294626400.0
1930식재료2023-09-19제3130부대'23년 4분기 부대계약 증식(컵밥 등 5종)20234025294626400.0
1931식재료2023-09-21해군군수사령부LA갈비 등 3종 구매202340435120660000.0