Overview

Dataset statistics

Number of variables5
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory488.3 KiB
Average record size in memory50.0 B

Variable types

Text3
Numeric2

Dataset

Description한국농수산식품유통공사 학교급식 2018년 공고
Author한국농수산식품유통공사
URLhttps://data.mafra.go.kr/opendata/data/indexOpenDataDetail.do?data_id=20191011000000001224

Alerts

입찰시작일시 is highly overall correlated with 입찰종료일시High correlation
입찰종료일시 is highly overall correlated with 입찰시작일시High correlation
입찰종료일시 is highly skewed (γ1 = 33.84717928)Skewed
전자입찰번호 has unique valuesUnique

Reproduction

Analysis started2023-12-11 03:29:47.077606
Analysis finished2023-12-11 03:29:48.910578
Duration1.83 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

전자입찰번호
Text

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-11T12:29:49.066390image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length16
Mean length16
Min length16

Characters and Unicode

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

Unique

Unique10000 ?
Unique (%)100.0%

Sample

1st rowE180213-000109-0
2nd rowE180122-000255-0
3rd rowE180108-000057-0
4th rowE180411-000126-0
5th rowE180424-000028-0
ValueCountFrequency (%)
e180213-000109-0 1
 
< 0.1%
e180213-000064-0 1
 
< 0.1%
e180323-000552-0 1
 
< 0.1%
e180515-000579-0 1
 
< 0.1%
e180221-001172-0 1
 
< 0.1%
e180321-003548-0 1
 
< 0.1%
e180516-001907-0 1
 
< 0.1%
e180416-000884-0 1
 
< 0.1%
e180212-000124-0 1
 
< 0.1%
e180319-001605-0 1
 
< 0.1%
Other values (9990) 9990
99.9%
2023-12-11T12:29:49.427639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 50471
31.5%
1 23725
14.8%
- 20000
 
12.5%
8 13422
 
8.4%
2 12182
 
7.6%
E 10000
 
6.2%
3 7428
 
4.6%
4 6494
 
4.1%
5 4513
 
2.8%
9 4256
 
2.7%
Other values (2) 7509
 
4.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 130000
81.2%
Dash Punctuation 20000
 
12.5%
Uppercase Letter 10000
 
6.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 50471
38.8%
1 23725
18.2%
8 13422
 
10.3%
2 12182
 
9.4%
3 7428
 
5.7%
4 6494
 
5.0%
5 4513
 
3.5%
9 4256
 
3.3%
6 3791
 
2.9%
7 3718
 
2.9%
Dash Punctuation
ValueCountFrequency (%)
- 20000
100.0%
Uppercase Letter
ValueCountFrequency (%)
E 10000
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 150000
93.8%
Latin 10000
 
6.2%

Most frequent character per script

Common
ValueCountFrequency (%)
0 50471
33.6%
1 23725
15.8%
- 20000
 
13.3%
8 13422
 
8.9%
2 12182
 
8.1%
3 7428
 
5.0%
4 6494
 
4.3%
5 4513
 
3.0%
9 4256
 
2.8%
6 3791
 
2.5%
Latin
ValueCountFrequency (%)
E 10000
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 160000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 50471
31.5%
1 23725
14.8%
- 20000
 
12.5%
8 13422
 
8.4%
2 12182
 
7.6%
E 10000
 
6.2%
3 7428
 
4.6%
4 6494
 
4.1%
5 4513
 
2.8%
9 4256
 
2.7%
Other values (2) 7509
 
4.7%
Distinct9677
Distinct (%)96.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-11T12:29:49.753576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length71
Median length55
Mean length32.2492
Min length8

Characters and Unicode

Total characters322492
Distinct characters491
Distinct categories12 ?
Distinct scripts3 ?
Distinct blocks7 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique9381 ?
Unique (%)93.8%

Sample

1st row2018년 3월 진접초 급식물품(수산물) 소액수의 전자견적 제출 공고
2nd row동광산업과학고등학교 2018년도 3월~5월 학교급식용 식재료(축산물) 공동구매 소액수의
3rd row2018년 2월 가야초등학교 학교급식용 식재료(농공수산품) 구매 소액수의 전자견적제출공고
4th row산남중학교 2018년 5월 학교급식물품(농산물) 소액수의 견적 요청
5th row산서초등학교 축산물 소액수의
ValueCountFrequency (%)
소액수의 7803
 
13.2%
공고 3476
 
5.9%
2018년 3354
 
5.7%
구매 1689
 
2.8%
견적 1598
 
2.7%
견적제출 1395
 
2.4%
제출 1362
 
2.3%
4월 1316
 
2.2%
3월 1296
 
2.2%
5월 1279
 
2.2%
Other values (7647) 34721
58.6%
2023-12-11T12:29:50.246178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
49462
 
15.3%
11769
 
3.6%
11363
 
3.5%
10613
 
3.3%
9225
 
2.9%
9101
 
2.8%
8872
 
2.8%
8736
 
2.7%
8464
 
2.6%
8336
 
2.6%
Other values (481) 186551
57.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 225596
70.0%
Space Separator 49462
 
15.3%
Decimal Number 30936
 
9.6%
Close Punctuation 5820
 
1.8%
Open Punctuation 5815
 
1.8%
Other Punctuation 3798
 
1.2%
Math Symbol 725
 
0.2%
Dash Punctuation 225
 
0.1%
Uppercase Letter 102
 
< 0.1%
Connector Punctuation 10
 
< 0.1%
Other values (2) 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
11769
 
5.2%
11363
 
5.0%
10613
 
4.7%
9225
 
4.1%
9101
 
4.0%
8872
 
3.9%
8736
 
3.9%
8464
 
3.8%
8336
 
3.7%
7707
 
3.4%
Other values (439) 131410
58.3%
Decimal Number
ValueCountFrequency (%)
2 5931
19.2%
1 5835
18.9%
0 5751
18.6%
8 5661
18.3%
3 2231
 
7.2%
5 2131
 
6.9%
4 2053
 
6.6%
6 1130
 
3.7%
7 171
 
0.6%
9 42
 
0.1%
Other Punctuation
ValueCountFrequency (%)
, 2605
68.6%
. 1127
29.7%
· 30
 
0.8%
/ 10
 
0.3%
: 9
 
0.2%
; 5
 
0.1%
& 4
 
0.1%
# 4
 
0.1%
2
 
0.1%
' 2
 
0.1%
Uppercase Letter
ValueCountFrequency (%)
A 39
38.2%
B 26
25.5%
G 18
17.6%
C 6
 
5.9%
T 4
 
3.9%
H 3
 
2.9%
P 3
 
2.9%
E 3
 
2.9%
Math Symbol
ValueCountFrequency (%)
~ 702
96.8%
> 9
 
1.2%
< 9
 
1.2%
5
 
0.7%
Close Punctuation
ValueCountFrequency (%)
) 5093
87.5%
] 727
 
12.5%
Open Punctuation
ValueCountFrequency (%)
( 5088
87.5%
[ 727
 
12.5%
Lowercase Letter
ValueCountFrequency (%)
a 1
50.0%
e 1
50.0%
Space Separator
ValueCountFrequency (%)
49462
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 225
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 10
100.0%
Other Symbol
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 225596
70.0%
Common 96792
30.0%
Latin 104
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
11769
 
5.2%
11363
 
5.0%
10613
 
4.7%
9225
 
4.1%
9101
 
4.0%
8872
 
3.9%
8736
 
3.9%
8464
 
3.8%
8336
 
3.7%
7707
 
3.4%
Other values (439) 131410
58.3%
Common
ValueCountFrequency (%)
49462
51.1%
2 5931
 
6.1%
1 5835
 
6.0%
0 5751
 
5.9%
8 5661
 
5.8%
) 5093
 
5.3%
( 5088
 
5.3%
, 2605
 
2.7%
3 2231
 
2.3%
5 2131
 
2.2%
Other values (22) 7004
 
7.2%
Latin
ValueCountFrequency (%)
A 39
37.5%
B 26
25.0%
G 18
17.3%
C 6
 
5.8%
T 4
 
3.8%
H 3
 
2.9%
P 3
 
2.9%
E 3
 
2.9%
a 1
 
1.0%
e 1
 
1.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 225593
70.0%
ASCII 96858
30.0%
None 30
 
< 0.1%
Math Operators 5
 
< 0.1%
Compat Jamo 3
 
< 0.1%
Punctuation 2
 
< 0.1%
Misc Symbols 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
49462
51.1%
2 5931
 
6.1%
1 5835
 
6.0%
0 5751
 
5.9%
8 5661
 
5.8%
) 5093
 
5.3%
( 5088
 
5.3%
, 2605
 
2.7%
3 2231
 
2.3%
5 2131
 
2.2%
Other values (28) 7070
 
7.3%
Hangul
ValueCountFrequency (%)
11769
 
5.2%
11363
 
5.0%
10613
 
4.7%
9225
 
4.1%
9101
 
4.0%
8872
 
3.9%
8736
 
3.9%
8464
 
3.8%
8336
 
3.7%
7707
 
3.4%
Other values (437) 131407
58.2%
None
ValueCountFrequency (%)
· 30
100.0%
Math Operators
ValueCountFrequency (%)
5
100.0%
Compat Jamo
ValueCountFrequency (%)
2
66.7%
1
33.3%
Punctuation
ValueCountFrequency (%)
2
100.0%
Misc Symbols
ValueCountFrequency (%)
1
100.0%
Distinct4818
Distinct (%)48.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-11T12:29:50.527151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length17
Mean length6.8702
Min length4

Characters and Unicode

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

Unique

Unique2172 ?
Unique (%)21.7%

Sample

1st row진접초등학교
2nd row동광산업과학고등학교
3rd row가야초등학교
4th row산남중학교
5th row산서초등학교
ValueCountFrequency (%)
전주영생고등학교 14
 
0.1%
순창북중학교 11
 
0.1%
서전주중학교 10
 
0.1%
용인고등학교 10
 
0.1%
덕암고등학교 10
 
0.1%
동명초등학교 10
 
0.1%
지평선중학교 10
 
0.1%
정주고등학교 10
 
0.1%
대전여자중학교 9
 
0.1%
정의여자고등학교 9
 
0.1%
Other values (4811) 9903
99.0%
2023-12-11T12:29:50.941038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
10206
 
14.9%
10018
 
14.6%
7450
 
10.8%
4228
 
6.2%
3412
 
5.0%
2498
 
3.6%
1182
 
1.7%
1166
 
1.7%
920
 
1.3%
915
 
1.3%
Other values (391) 26707
38.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 68692
> 99.9%
Space Separator 6
 
< 0.1%
Close Punctuation 2
 
< 0.1%
Open Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
10206
 
14.9%
10018
 
14.6%
7450
 
10.8%
4228
 
6.2%
3412
 
5.0%
2498
 
3.6%
1182
 
1.7%
1166
 
1.7%
920
 
1.3%
915
 
1.3%
Other values (388) 26697
38.9%
Space Separator
ValueCountFrequency (%)
6
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 68692
> 99.9%
Common 10
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
10206
 
14.9%
10018
 
14.6%
7450
 
10.8%
4228
 
6.2%
3412
 
5.0%
2498
 
3.6%
1182
 
1.7%
1166
 
1.7%
920
 
1.3%
915
 
1.3%
Other values (388) 26697
38.9%
Common
ValueCountFrequency (%)
6
60.0%
) 2
 
20.0%
( 2
 
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 68692
> 99.9%
ASCII 10
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
10206
 
14.9%
10018
 
14.6%
7450
 
10.8%
4228
 
6.2%
3412
 
5.0%
2498
 
3.6%
1182
 
1.7%
1166
 
1.7%
920
 
1.3%
915
 
1.3%
Other values (388) 26697
38.9%
ASCII
ValueCountFrequency (%)
6
60.0%
) 2
 
20.0%
( 2
 
20.0%

입찰시작일시
Real number (ℝ)

HIGH CORRELATION 

Distinct1496
Distinct (%)15.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.018033 × 1013
Minimum2.0180102 × 1013
Maximum2.0180518 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T12:29:51.099776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0180102 × 1013
5-th percentile2.0180202 × 1013
Q12.018022 × 1013
median2.0180321 × 1013
Q32.0180419 × 1013
95-th percentile2.0180517 × 1013
Maximum2.0180518 × 1013
Range4.1604 × 108
Interquartile range (IQR)1.9897 × 108

Descriptive statistics

Standard deviation1.1143668 × 108
Coefficient of variation (CV)5.5220445 × 10-6
Kurtosis-0.98064146
Mean2.018033 × 1013
Median Absolute Deviation (MAD)99053000
Skewness0.066825511
Sum2.018033 × 1017
Variance1.2418133 × 1016
MonotonicityNot monotonic
2023-12-11T12:29:51.249571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20180214150000 92
 
0.9%
20180320100000 86
 
0.9%
20180214160000 79
 
0.8%
20180219160000 74
 
0.7%
20180418150000 73
 
0.7%
20180321160000 73
 
0.7%
20180420160000 69
 
0.7%
20180518140000 69
 
0.7%
20180320150000 68
 
0.7%
20180517160000 67
 
0.7%
Other values (1486) 9250
92.5%
ValueCountFrequency (%)
20180102103000 1
 
< 0.1%
20180102120000 1
 
< 0.1%
20180102130000 1
 
< 0.1%
20180102140000 2
 
< 0.1%
20180102150000 1
 
< 0.1%
20180102151000 1
 
< 0.1%
20180102161000 1
 
< 0.1%
20180102170000 1
 
< 0.1%
20180103090000 3
< 0.1%
20180103130000 5
0.1%
ValueCountFrequency (%)
20180518143000 3
 
< 0.1%
20180518142000 1
 
< 0.1%
20180518140500 1
 
< 0.1%
20180518140000 69
0.7%
20180518133000 2
 
< 0.1%
20180518130000 30
0.3%
20180518122500 1
 
< 0.1%
20180518120000 28
0.3%
20180518114000 1
 
< 0.1%
20180518113500 1
 
< 0.1%

입찰종료일시
Real number (ℝ)

HIGH CORRELATION  SKEWED 

Distinct997
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0180338 × 1013
Minimum2.0180104 × 1013
Maximum2.0190228 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T12:29:51.403092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0180104 × 1013
5-th percentile2.0180208 × 1013
Q12.0180223 × 1013
median2.0180326 × 1013
Q32.0180424 × 1013
95-th percentile2.0180524 × 1013
Maximum2.0190228 × 1013
Range1.012402 × 1010
Interquartile range (IQR)2.0101 × 108

Descriptive statistics

Standard deviation1.7883856 × 108
Coefficient of variation (CV)8.8620203 × 10-6
Kurtosis1869.5121
Mean2.0180338 × 1013
Median Absolute Deviation (MAD)99957250
Skewness33.847179
Sum2.0180338 × 1017
Variance3.1983231 × 1016
MonotonicityNot monotonic
2023-12-11T12:29:51.591336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20180326100000 270
 
2.7%
20180425100000 235
 
2.4%
20180424100000 229
 
2.3%
20180226100000 214
 
2.1%
20180222100000 203
 
2.0%
20180223100000 201
 
2.0%
20180327100000 195
 
1.9%
20180323100000 184
 
1.8%
20180423100000 165
 
1.7%
20180426100000 163
 
1.6%
Other values (987) 7941
79.4%
ValueCountFrequency (%)
20180104080000 2
 
< 0.1%
20180104103000 1
 
< 0.1%
20180104140000 1
 
< 0.1%
20180105090000 1
 
< 0.1%
20180105100000 1
 
< 0.1%
20180105163000 1
 
< 0.1%
20180108073000 1
 
< 0.1%
20180108090000 1
 
< 0.1%
20180108100000 5
0.1%
20180108120000 5
0.1%
ValueCountFrequency (%)
20190228100000 1
 
< 0.1%
20190228080000 1
 
< 0.1%
20180822080000 1
 
< 0.1%
20180630140000 1
 
< 0.1%
20180531120000 1
 
< 0.1%
20180531100000 1
 
< 0.1%
20180528140000 2
 
< 0.1%
20180528120000 1
 
< 0.1%
20180528100000 6
0.1%
20180528090000 2
 
< 0.1%

Interactions

2023-12-11T12:29:48.501521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:29:48.307262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:29:48.592632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T12:29:48.400950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T12:29:51.689960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
입찰시작일시입찰종료일시
입찰시작일시1.0000.000
입찰종료일시0.0001.000
2023-12-11T12:29:51.771913image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
입찰시작일시입찰종료일시
입찰시작일시1.0000.993
입찰종료일시0.9931.000

Missing values

2023-12-11T12:29:48.707518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T12:29:48.832764image/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

전자입찰번호입찰명거래처명입찰시작일시입찰종료일시
10311E180213-000109-02018년 3월 진접초 급식물품(수산물) 소액수의 전자견적 제출 공고진접초등학교2018021316000020180221140000
3281E180122-000255-0동광산업과학고등학교 2018년도 3월~5월 학교급식용 식재료(축산물) 공동구매 소액수의동광산업과학고등학교2018012410000020180130100000
505E180108-000057-02018년 2월 가야초등학교 학교급식용 식재료(농공수산품) 구매 소액수의 전자견적제출공고가야초등학교2018010817000020180112100000
51989E180411-000126-0산남중학교 2018년 5월 학교급식물품(농산물) 소액수의 견적 요청산남중학교2018041113000020180418110000
71469E180424-000028-0산서초등학교 축산물 소액수의산서초등학교2018042409000020180426090000
15215E180213-002230-02018년도 3~4월 학교급식용 김치류 구매 소액수의 전자견적제출 공고백석고등학교2018021509000020180221180000
16305E180219-000872-0강서공업고등학교 3월 급식식재료(곡류) 소액수의 견적공고강서공업고등학교2018021912000020180222120000
13547E180214-002272-0동국대학교사범대학부속금산중학교 공산품류 소액수의-중식동국대학교사범대학부속금산중학교2018021415000020180219150000
28554E180219-002446-1[긴급][재공고] 2018년 3월 정일초등학교 학교급식 수산물 소액수의정일초등학교2018022316000020180227100000
47753E180322-001732-0남원도통초등학교 공산품류 소액수의남원도통초등학교2018032217000020180327090000
전자입찰번호입찰명거래처명입찰시작일시입찰종료일시
69753E180416-000205-12018학년도 5월 봉암초등학교 학교급식용식재료(김치류) 소액수의 견적요청[재입찰]봉암초등학교2018042311000020180425110000
26167E180221-002177-02018. 3월 함평여자중학교 급식용식재료 농,수,공산품 소액수의 안내공고함평여자중학교2018022209000020180226100000
60476E180418-002104-0공항고등학교 5월분 식재료(축산물) 소액수의 견적 제출 공고공항고등학교2018041815000020180423150000
56666E180417-000716-02018. 5월 내동초등학교 급식용(농수공산품)구매 소액수의 전자 공고내동초등학교2018041714000020180423140000
36983E180319-003719-0한라초등학교 빵류 소액수의한라초등학교2018031918200020180326090000
63819E180419-001928-0의정부서초등학교 2018년 5월분 급식용식재료(공산품) 소액수의 견적 제출 공고의정부서초등학교2018041915000020180425100000
18145E180219-002402-0초량초등학교 20118년 3월 닭오리 소액수의 공고초량초등학교2018021916000020180223090000
5379E180207-000006-0인천남중학교 (3-4월분) 김치류 소액수의 견적공고인천남중학교2018020715000020180213090000
31621E180315-000552-0살레시오고등학교 2018년 4월 수산물 소액수의 견적 시행 공고살레시오고등학교2018031516000020180321090000
32140E180313-000215-02018학년도 대전과학고등학교 우유구매(단가) 견적제출공고대전과학고등학교2018031612000020180320100000