Overview

Dataset statistics

Number of variables7
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory634.8 KiB
Average record size in memory65.0 B

Variable types

Numeric1
Text2
DateTime3
Categorical1

Dataset

Description학교급식전자조달시스템(https://school.eat.co.kr:442/index.jsp)을 통해 수집된 학교급식 입찰현황 - 입찰명, 입찰상태, 공고일 등 * 학교급식전자조달시스템: 학교가 급식재료를 구하기 위하여 업체를 선정하고 계약을 체결하는 급식재료 전문 전자조달 시스템
URLhttps://www.data.go.kr/data/15070124/fileData.do

Alerts

계약방법 is highly imbalanced (93.1%)Imbalance
전자입찰일련번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 08:38:47.248700
Analysis finished2023-12-12 08:38:48.524201
Duration1.28 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%
Mean1925336.4
Minimum1883270
Maximum1966670
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T17:38:48.607665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1883270
5-th percentile1887622.5
Q11904451.8
median1925413.5
Q31946258.2
95-th percentile1962851.1
Maximum1966670
Range83400
Interquartile range (IQR)41806.5

Descriptive statistics

Standard deviation24116.621
Coefficient of variation (CV)0.012525926
Kurtosis-1.1958629
Mean1925336.4
Median Absolute Deviation (MAD)20900
Skewness-0.0073010611
Sum1.9253364 × 1010
Variance5.8161141 × 108
MonotonicityNot monotonic
2023-12-12T17:38:48.748447image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1913475 1
 
< 0.1%
1913189 1
 
< 0.1%
1945296 1
 
< 0.1%
1922792 1
 
< 0.1%
1897862 1
 
< 0.1%
1892979 1
 
< 0.1%
1935347 1
 
< 0.1%
1926407 1
 
< 0.1%
1952932 1
 
< 0.1%
1927469 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
1883270 1
< 0.1%
1883295 1
< 0.1%
1883297 1
< 0.1%
1883306 1
< 0.1%
1883308 1
< 0.1%
1883318 1
< 0.1%
1883323 1
< 0.1%
1883345 1
< 0.1%
1883347 1
< 0.1%
1883349 1
< 0.1%
ValueCountFrequency (%)
1966670 1
< 0.1%
1966668 1
< 0.1%
1966667 1
< 0.1%
1966663 1
< 0.1%
1966654 1
< 0.1%
1966652 1
< 0.1%
1966649 1
< 0.1%
1966638 1
< 0.1%
1966628 1
< 0.1%
1966627 1
< 0.1%

입찰명
Text

Distinct9735
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T17:38:49.058409image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length75
Median length55
Mean length32.9648
Min length5

Characters and Unicode

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

Unique

Unique9489 ?
Unique (%)94.9%

Sample

1st row구서초등학교 2022년 4월 학교급식품(농수공잡곡류) 소액수의 공고
2nd row부남초 파천초 청송고 농산물류 수산물류 가공식품류 육류 김치류 곡류 종합계약 소액수의[재입찰]
3rd row대덕소프트웨어마이스터고등학교 2022년 5월 육류 소액수의 견적제출 공고
4th row동성고등학교 4월 급식 식재료(김치)
5th row마북초등학교 2022년 3월 급식물품(G마크 우수축산물) 구매 소액수의 견적 제출 공고(긴급)
ValueCountFrequency (%)
소액수의 7617
 
11.8%
2022년 4178
 
6.5%
공고 3664
 
5.7%
구매 1922
 
3.0%
견적 1567
 
2.4%
학교급식 1483
 
2.3%
견적제출 1479
 
2.3%
5월 1467
 
2.3%
3월 1456
 
2.3%
6월 1443
 
2.2%
Other values (7240) 38259
59.3%
2023-12-12T17:38:49.690228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
54758
 
16.6%
2 19062
 
5.8%
학 12089
 
3.7%
수 11176
 
3.4%
교 10961
 
3.3%
식 9862
 
3.0%
의 9066
 
2.8%
소 8784
 
2.7%
액 8543
 
2.6%
고 8491
 
2.6%
Other values (485) 176856
53.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 227204
68.9%
Space Separator 54758
 
16.6%
Decimal Number 34179
 
10.4%
Close Punctuation 5727
 
1.7%
Open Punctuation 5719
 
1.7%
Other Punctuation 999
 
0.3%
Math Symbol 667
 
0.2%
Dash Punctuation 178
 
0.1%
Uppercase Letter 164
 
< 0.1%
Lowercase Letter 30
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
학 12089
 
5.3%
수 11176
 
4.9%
교 10961
 
4.8%
식 9862
 
4.3%
의 9066
 
4.0%
소 8784
 
3.9%
액 8543
 
3.8%
고 8491
 
3.7%
월 8432
 
3.7%
공 8379
 
3.7%
Other values (438) 131421
57.8%
Decimal Number
ValueCountFrequency (%)
2 19062
55.8%
0 6310
 
18.5%
3 2029
 
5.9%
5 2020
 
5.9%
6 1980
 
5.8%
4 1944
 
5.7%
7 381
 
1.1%
8 205
 
0.6%
1 170
 
0.5%
9 78
 
0.2%
Uppercase Letter
ValueCountFrequency (%)
B 56
34.1%
A 51
31.1%
G 35
21.3%
C 8
 
4.9%
P 3
 
1.8%
T 3
 
1.8%
H 3
 
1.8%
E 3
 
1.8%
M 1
 
0.6%
O 1
 
0.6%
Other Punctuation
ValueCountFrequency (%)
. 919
92.0%
· 29
 
2.9%
& 14
 
1.4%
; 14
 
1.4%
: 8
 
0.8%
/ 7
 
0.7%
# 4
 
0.4%
' 3
 
0.3%
* 1
 
0.1%
Lowercase Letter
ValueCountFrequency (%)
t 10
33.3%
g 7
23.3%
l 5
16.7%
n 4
 
13.3%
o 3
 
10.0%
m 1
 
3.3%
Close Punctuation
ValueCountFrequency (%)
) 5049
88.2%
] 675
 
11.8%
］ 2
 
< 0.1%
」 1
 
< 0.1%
Open Punctuation
ValueCountFrequency (%)
( 5041
88.1%
[ 675
 
11.8%
［ 2
 
< 0.1%
「 1
 
< 0.1%
Space Separator
ValueCountFrequency (%)
54758
100.0%
Math Symbol
ValueCountFrequency (%)
~ 667
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 178
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 23
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 227204
68.9%
Common 102250
31.0%
Latin 194
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
학 12089
 
5.3%
수 11176
 
4.9%
교 10961
 
4.8%
식 9862
 
4.3%
의 9066
 
4.0%
소 8784
 
3.9%
액 8543
 
3.8%
고 8491
 
3.7%
월 8432
 
3.7%
공 8379
 
3.7%
Other values (438) 131421
57.8%
Common
ValueCountFrequency (%)
54758
53.6%
2 19062
 
18.6%
0 6310
 
6.2%
) 5049
 
4.9%
( 5041
 
4.9%
3 2029
 
2.0%
5 2020
 
2.0%
6 1980
 
1.9%
4 1944
 
1.9%
. 919
 
0.9%
Other values (21) 3138
 
3.1%
Latin
ValueCountFrequency (%)
B 56
28.9%
A 51
26.3%
G 35
18.0%
t 10
 
5.2%
C 8
 
4.1%
g 7
 
3.6%
l 5
 
2.6%
n 4
 
2.1%
o 3
 
1.5%
P 3
 
1.5%
Other values (6) 12
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 227198
68.9%
ASCII 102409
31.1%
None 35
 
< 0.1%
Compat Jamo 6
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
54758
53.5%
2 19062
 
18.6%
0 6310
 
6.2%
) 5049
 
4.9%
( 5041
 
4.9%
3 2029
 
2.0%
5 2020
 
2.0%
6 1980
 
1.9%
4 1944
 
1.9%
. 919
 
0.9%
Other values (32) 3297
 
3.2%
Hangul
ValueCountFrequency (%)
학 12089
 
5.3%
수 11176
 
4.9%
교 10961
 
4.8%
식 9862
 
4.3%
의 9066
 
4.0%
소 8784
 
3.9%
액 8543
 
3.8%
고 8491
 
3.7%
월 8432
 
3.7%
공 8379
 
3.7%
Other values (437) 131415
57.8%
None
ValueCountFrequency (%)
· 29
82.9%
［ 2
 
5.7%
］ 2
 
5.7%
「 1
 
2.9%
」 1
 
2.9%
Compat Jamo
ValueCountFrequency (%)
ㆍ 6
100.0%

입찰시작일
Date

Distinct132
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-01-02 00:00:00
Maximum2022-06-22 00:00:00
2023-12-12T17:38:49.837840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:38:49.982450image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

계약방법
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
소액수의
9834 
제한경쟁
 
115
일반경쟁
 
48
지명경쟁
 
3

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row소액수의
2nd row소액수의
3rd row소액수의
4th row소액수의
5th row소액수의

Common Values

ValueCountFrequency (%)
소액수의 9834
98.3%
제한경쟁 115
 
1.1%
일반경쟁 48
 
0.5%
지명경쟁 3
 
< 0.1%

Length

2023-12-12T17:38:50.446766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:38:50.563947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
소액수의 9834
98.3%
제한경쟁 115
 
1.1%
일반경쟁 48
 
0.5%
지명경쟁 3
 
< 0.1%

구매사명
Text

Distinct4722
Distinct (%)47.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T17:38:50.810833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length21
Mean length6.8904
Min length3

Characters and Unicode

Total characters68904
Distinct characters415
Distinct categories6 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2045 ?
Unique (%)20.4%

Sample

1st row구서초등학교
2nd row부남초등학교
3rd row대덕소프트웨어마이스터고등학교
4th row동성고등학교
5th row마북초등학교
ValueCountFrequency (%)
지평선중학교 15
 
0.1%
제주대학교사범대학부설고등학교 12
 
0.1%
한솔초등학교 12
 
0.1%
삼호중학교 10
 
0.1%
명덕고등학교 10
 
0.1%
군산제일고등학교 9
 
0.1%
인상고등학교 9
 
0.1%
대신고등학교 9
 
0.1%
모산초등학교 9
 
0.1%
고창중학교 9
 
0.1%
Other values (4718) 9912
99.0%
2023-12-12T17:38:51.288664image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
학 10037
 
14.6%
교 9866
 
14.3%
등 7371
 
10.7%
초 4238
 
6.2%
고 3291
 
4.8%
중 2448
 
3.6%
대 1361
 
2.0%
전 1200
 
1.7%
산 1020
 
1.5%
천 915
 
1.3%
Other values (405) 27157
39.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 68841
99.9%
Decimal Number 35
 
0.1%
Space Separator 16
 
< 0.1%
Open Punctuation 5
 
< 0.1%
Close Punctuation 5
 
< 0.1%
Other Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
학 10037
 
14.6%
교 9866
 
14.3%
등 7371
 
10.7%
초 4238
 
6.2%
고 3291
 
4.8%
중 2448
 
3.6%
대 1361
 
2.0%
전 1200
 
1.7%
산 1020
 
1.5%
천 915
 
1.3%
Other values (392) 27094
39.4%
Decimal Number
ValueCountFrequency (%)
2 10
28.6%
7 6
17.1%
8 6
17.1%
3 6
17.1%
1 3
 
8.6%
9 2
 
5.7%
6 1
 
2.9%
5 1
 
2.9%
Other Punctuation
ValueCountFrequency (%)
· 1
50.0%
. 1
50.0%
Space Separator
ValueCountFrequency (%)
16
100.0%
Open Punctuation
ValueCountFrequency (%)
( 5
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 68841
99.9%
Common 63
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
학 10037
 
14.6%
교 9866
 
14.3%
등 7371
 
10.7%
초 4238
 
6.2%
고 3291
 
4.8%
중 2448
 
3.6%
대 1361
 
2.0%
전 1200
 
1.7%
산 1020
 
1.5%
천 915
 
1.3%
Other values (392) 27094
39.4%
Common
ValueCountFrequency (%)
16
25.4%
2 10
15.9%
7 6
 
9.5%
8 6
 
9.5%
3 6
 
9.5%
( 5
 
7.9%
) 5
 
7.9%
1 3
 
4.8%
9 2
 
3.2%
6 1
 
1.6%
Other values (3) 3
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 68841
99.9%
ASCII 62
 
0.1%
None 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
학 10037
 
14.6%
교 9866
 
14.3%
등 7371
 
10.7%
초 4238
 
6.2%
고 3291
 
4.8%
중 2448
 
3.6%
대 1361
 
2.0%
전 1200
 
1.7%
산 1020
 
1.5%
천 915
 
1.3%
Other values (392) 27094
39.4%
ASCII
ValueCountFrequency (%)
16
25.8%
2 10
16.1%
7 6
 
9.7%
8 6
 
9.7%
3 6
 
9.7%
( 5
 
8.1%
) 5
 
8.1%
1 3
 
4.8%
9 2
 
3.2%
6 1
 
1.6%
Other values (2) 2
 
3.2%
None
ValueCountFrequency (%)
· 1
100.0%

공고일자
Date

Distinct129
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-01-02 00:00:00
Maximum2022-06-21 00:00:00
2023-12-12T17:38:51.443884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:38:51.602705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

등록일자
Date

Distinct136
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-01-02 00:00:00
Maximum2022-06-15 00:00:00
2023-12-12T17:38:51.789962image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:38:51.952283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-12T17:38:48.175658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T17:38:52.060632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전자입찰일련번호계약방법
전자입찰일련번호1.0000.041
계약방법0.0411.000
2023-12-12T17:38:52.158300image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전자입찰일련번호계약방법
전자입찰일련번호1.0000.024
계약방법0.0241.000

Missing values

2023-12-12T17:38:48.315526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:38:48.453648image/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

전자입찰일련번호입찰명입찰시작일계약방법구매사명공고일자등록일자
295011913475구서초등학교 2022년 4월 학교급식품(농수공잡곡류) 소액수의 공고2022-03-18소액수의구서초등학교2022-03-182022-03-18
227411906526부남초 파천초 청송고 농산물류 수산물류 가공식품류 육류 김치류 곡류 종합계약 소액수의[재입찰]2022-02-23소액수의부남초등학교2022-02-232022-02-23
565291940998대덕소프트웨어마이스터고등학교 2022년 5월 육류 소액수의 견적제출 공고2022-04-20소액수의대덕소프트웨어마이스터고등학교2022-04-202022-04-20
337331917795동성고등학교 4월 급식 식재료(김치)2022-03-21소액수의동성고등학교2022-03-212022-03-21
104621894008마북초등학교 2022년 3월 급식물품(G마크 우수축산물) 구매 소액수의 견적 제출 공고(긴급)2022-02-16소액수의마북초등학교2022-02-162022-02-16
66591890136대전동서초등학교 2022학년도 3월분 급식재료(육류) 소액수의 공고2022-02-15소액수의대전동서초등학교2022-02-152022-02-14
524781936896전주효천초등학교 수산물 소액수의2022-04-19소액수의전주효천초등학교2022-04-192022-04-19
6976019544942022년 6월 하천초 무동초 학교급식 육류 및 가금류 구매 소액수의 견적제출 안내 공고2022-05-18소액수의하천초등학교2022-05-182022-05-18
524991936917전주효천초등학교 일반농산물 소액수의2022-04-19소액수의전주효천초등학교2022-04-192022-04-19
149581898594운리초 2022년 3월 학교급식 식재료(공산품) 구매 수의계약 안내공고2022-02-17소액수의운리초등학교2022-02-172022-02-17
전자입찰일련번호입찰명입찰시작일계약방법구매사명공고일자등록일자
3261919166562022.4월분 전주만수초등학교 육류 소액수의2022-03-18소액수의전주만수초등학교2022-03-182022-03-18
967918932122022년 3월 경안고등학교 EAT 김치 구매의 건2022-02-16소액수의경안고등학교2022-02-162022-02-16
411981925383[긴급]2022년 4월분 학교급식 식재료(축산물) 구매2022-03-28소액수의혜성여자고등학교2022-03-252022-03-25
200251903752풍기중학교 부식 소액수의2022-02-21소액수의풍기중학교2022-02-212022-02-21
1706619007352022학년도 3월 서울강일초등학교 급식식재료 다자간 수의시담 공고(김치류)2022-02-18소액수의서울강일초등학교2022-02-182022-02-18
285761912519해오름유치원 남호초 묵호초 농산물류 종합계약 소액수의2022-03-17소액수의해오름유치원2022-03-172022-03-17
668541951555대구율빛유치원 6월 급식용 육류 구매2022-05-18소액수의대구율빛유치원2022-05-172022-05-17
212671905016청호초 청봉초 가공식품류 종합계약 소액수의2022-02-21소액수의청호초등학교2022-02-212022-02-21
16431884966남정초등학교 소액수의2022-01-19소액수의남정초등학교2022-01-192022-01-18
1648419001432022년 3월 군산풍문초등학교 김치류 소액수의[변경공고]2022-02-18소액수의군산풍문초등학교2022-02-182022-02-18