Overview

Dataset statistics

Number of variables6
Number of observations159
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.2 KiB
Average record size in memory52.8 B

Variable types

Categorical1
DateTime1
Numeric4

Dataset

Description충청남도 학교급식 식재료 공급 체계에 기반한 시스템 통계DB 추출자료로 센터명, 연월, 친환경농산물사용량, 공급액, 일반농산물사용량, 공급액을 개방합니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=426&beforeMenuCd=DOM_000000201001001000&publicdatapk=3071846

Alerts

친환경 농산물 사용량(Kg) is highly overall correlated with 친환경 농산물 공급액(원) and 2 other fieldsHigh correlation
친환경 농산물 공급액(원) is highly overall correlated with 친환경 농산물 사용량(Kg) and 2 other fieldsHigh correlation
일반 농산물 사용량(Kg) is highly overall correlated with 친환경 농산물 사용량(Kg) and 2 other fieldsHigh correlation
일반 농산물 공급액(원) is highly overall correlated with 친환경 농산물 사용량(Kg) and 2 other fieldsHigh correlation
친환경 농산물 사용량(Kg) has unique valuesUnique
친환경 농산물 공급액(원) has unique valuesUnique
일반 농산물 사용량(Kg) has 8 (5.0%) zerosZeros
일반 농산물 공급액(원) has 8 (5.0%) zerosZeros

Reproduction

Analysis started2024-01-09 22:19:35.217318
Analysis finished2024-01-09 22:19:36.708100
Duration1.49 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

센터명
Categorical

Distinct14
Distinct (%)8.8%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
당진
12 
공주
12 
보령
12 
논산
12 
태안
12 
Other values (9)
99 

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 (%)
당진 12
 
7.5%
공주 12
 
7.5%
보령 12
 
7.5%
논산 12
 
7.5%
태안 12
 
7.5%
서산 12
 
7.5%
서천 12
 
7.5%
홍성 12
 
7.5%
아산 12
 
7.5%
청양 12
 
7.5%
Other values (4) 39
24.5%

Length

2024-01-10T07:19:36.757072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
당진 12
 
7.5%
공주 12
 
7.5%
보령 12
 
7.5%
논산 12
 
7.5%
태안 12
 
7.5%
서산 12
 
7.5%
서천 12
 
7.5%
홍성 12
 
7.5%
아산 12
 
7.5%
청양 12
 
7.5%
Other values (4) 39
24.5%

연월
Date

Distinct12
Distinct (%)7.5%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2020-03-01 00:00:00
Maximum2021-02-01 00:00:00
2024-01-10T07:19:36.854465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:36.953332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)

친환경 농산물 사용량(Kg)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct159
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean32372.936
Minimum23
Maximum268882.98
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-01-10T07:19:37.082732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum23
5-th percentile204.29
Q13662.885
median15533.63
Q334398.26
95-th percentile134283.15
Maximum268882.98
Range268859.98
Interquartile range (IQR)30735.375

Descriptive statistics

Standard deviation48884.35
Coefficient of variation (CV)1.5100376
Kurtosis8.3500983
Mean32372.936
Median Absolute Deviation (MAD)13466.42
Skewness2.7419797
Sum5147296.8
Variance2.3896796 × 109
MonotonicityNot monotonic
2024-01-10T07:19:37.224975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
228.5 1
 
0.6%
1370.21 1
 
0.6%
12183.25 1
 
0.6%
5208.79 1
 
0.6%
445.72 1
 
0.6%
1086.05 1
 
0.6%
1924.33 1
 
0.6%
7619.16 1
 
0.6%
36675.44 1
 
0.6%
37639.55 1
 
0.6%
Other values (149) 149
93.7%
ValueCountFrequency (%)
23.0 1
0.6%
74.0 1
0.6%
78.1 1
0.6%
104.0 1
0.6%
110.0 1
0.6%
119.0 1
0.6%
134.0 1
0.6%
156.05 1
0.6%
209.65 1
0.6%
228.5 1
0.6%
ValueCountFrequency (%)
268882.98 1
0.6%
254434.22 1
0.6%
240025.11 1
0.6%
205169.75 1
0.6%
196633.72 1
0.6%
142203.34 1
0.6%
136881.79 1
0.6%
134492.61 1
0.6%
134259.88 1
0.6%
121906.09 1
0.6%

친환경 농산물 공급액(원)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct159
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.1918801 × 108
Minimum112250
Maximum7.04047 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-01-10T07:19:37.359857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum112250
5-th percentile1914951.6
Q117496110
median63129557
Q31.5946605 × 108
95-th percentile4.6807624 × 108
Maximum7.04047 × 108
Range7.0393475 × 108
Interquartile range (IQR)1.4196994 × 108

Descriptive statistics

Standard deviation1.4625481 × 108
Coefficient of variation (CV)1.2270933
Kurtosis3.1738719
Mean1.1918801 × 108
Median Absolute Deviation (MAD)57639915
Skewness1.8562361
Sum1.8950894 × 1010
Variance2.1390469 × 1016
MonotonicityNot monotonic
2024-01-10T07:19:37.505868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
866694 1
 
0.6%
5235688 1
 
0.6%
51252634 1
 
0.6%
20184491 1
 
0.6%
1887066 1
 
0.6%
4826660 1
 
0.6%
9472083 1
 
0.6%
36150142 1
 
0.6%
162228405 1
 
0.6%
168970817 1
 
0.6%
Other values (149) 149
93.7%
ValueCountFrequency (%)
112250 1
0.6%
328661 1
0.6%
601382 1
0.6%
866694 1
0.6%
1050286 1
0.6%
1185930 1
0.6%
1218200 1
0.6%
1887066 1
0.6%
1918050 1
0.6%
2442000 1
0.6%
ValueCountFrequency (%)
704047002 1
0.6%
604646260 1
0.6%
597450931 1
0.6%
583155592 1
0.6%
528527384 1
0.6%
527713231 1
0.6%
472623182 1
0.6%
468467385 1
0.6%
468032779 1
0.6%
451432238 1
0.6%

일반 농산물 사용량(Kg)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct152
Distinct (%)95.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14956.945
Minimum0
Maximum174965.1
Zeros8
Zeros (%)5.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-01-10T07:19:37.865823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile35.955
Q12401.7318
median7901.4216
Q316045.395
95-th percentile49321.806
Maximum174965.1
Range174965.1
Interquartile range (IQR)13643.663

Descriptive statistics

Standard deviation25925.343
Coefficient of variation (CV)1.7333314
Kurtosis17.607729
Mean14956.945
Median Absolute Deviation (MAD)6208.0293
Skewness3.9189183
Sum2378154.3
Variance6.7212339 × 108
MonotonicityNot monotonic
2024-01-10T07:19:37.974359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 8
 
5.0%
671.11 1
 
0.6%
3062.18 1
 
0.6%
4785.75 1
 
0.6%
4181.26 1
 
0.6%
5386.54 1
 
0.6%
5500.58 1
 
0.6%
1026.19 1
 
0.6%
85.08 1
 
0.6%
1435.0 1
 
0.6%
Other values (142) 142
89.3%
ValueCountFrequency (%)
0.0 8
5.0%
39.95 1
 
0.6%
67.6 1
 
0.6%
71.1 1
 
0.6%
80.7 1
 
0.6%
85.08 1
 
0.6%
108.1 1
 
0.6%
208.7 1
 
0.6%
218.8 1
 
0.6%
306.2 1
 
0.6%
ValueCountFrequency (%)
174965.1 1
0.6%
144258.03 1
0.6%
137467.61 1
0.6%
129354.06 1
0.6%
105933.57 1
0.6%
62355.68 1
0.6%
62186.99 1
0.6%
51879.48 1
0.6%
49037.62 1
0.6%
48301.45 1
0.6%

일반 농산물 공급액(원)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct152
Distinct (%)95.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean93469822
Minimum0
Maximum2.6008329 × 109
Zeros8
Zeros (%)5.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-01-10T07:19:38.087363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile181345.5
Q111860186
median40831766
Q377452919
95-th percentile3.3663802 × 108
Maximum2.6008329 × 109
Range2.6008329 × 109
Interquartile range (IQR)65592732

Descriptive statistics

Standard deviation2.3838715 × 108
Coefficient of variation (CV)2.5504183
Kurtosis78.89795
Mean93469822
Median Absolute Deviation (MAD)30205298
Skewness7.9792298
Sum1.4861702 × 1010
Variance5.6828432 × 1016
MonotonicityNot monotonic
2024-01-10T07:19:38.195158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 8
 
5.0%
3059972 1
 
0.6%
15888745 1
 
0.6%
30210597 1
 
0.6%
26496537 1
 
0.6%
29091822 1
 
0.6%
32076055 1
 
0.6%
8001123 1
 
0.6%
614414 1
 
0.6%
5086910 1
 
0.6%
Other values (142) 142
89.3%
ValueCountFrequency (%)
0 8
5.0%
201495 1
 
0.6%
297506 1
 
0.6%
483110 1
 
0.6%
502715 1
 
0.6%
553661 1
 
0.6%
614414 1
 
0.6%
933596 1
 
0.6%
1089369 1
 
0.6%
1226856 1
 
0.6%
ValueCountFrequency (%)
2600832883 1
0.6%
925494716 1
0.6%
610394427 1
0.6%
585252139 1
0.6%
580588172 1
0.6%
517629606 1
0.6%
436131732 1
0.6%
416705905 1
0.6%
327741591 1
0.6%
301431860 1
0.6%

Interactions

2024-01-10T07:19:36.294832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:35.406509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:35.683781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:35.985548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:36.362219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:35.469588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:35.750804image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:36.062714image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:36.431077image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:35.542844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:35.826829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:36.143232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:36.501339image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:35.616723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:35.913250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:36.222152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T07:19:38.267039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
센터명연월친환경 농산물 사용량(Kg)친환경 농산물 공급액(원)일반 농산물 사용량(Kg)일반 농산물 공급액(원)
센터명1.0000.0000.5730.5700.5410.338
연월0.0001.0000.1580.3790.2660.162
친환경 농산물 사용량(Kg)0.5730.1581.0000.8400.7130.705
친환경 농산물 공급액(원)0.5700.3790.8401.0000.7820.830
일반 농산물 사용량(Kg)0.5410.2660.7130.7821.0000.884
일반 농산물 공급액(원)0.3380.1620.7050.8300.8841.000
2024-01-10T07:19:38.372878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
친환경 농산물 사용량(Kg)친환경 농산물 공급액(원)일반 농산물 사용량(Kg)일반 농산물 공급액(원)센터명
친환경 농산물 사용량(Kg)1.0000.9700.8640.9210.279
친환경 농산물 공급액(원)0.9701.0000.8820.9380.266
일반 농산물 사용량(Kg)0.8640.8821.0000.9600.267
일반 농산물 공급액(원)0.9210.9380.9601.0000.177
센터명0.2790.2660.2670.1771.000

Missing values

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

센터명연월친환경 농산물 사용량(Kg)친환경 농산물 공급액(원)일반 농산물 사용량(Kg)일반 농산물 공급액(원)
0당진2020-03-01228.58666941435.05086910
1당진2020-04-011370.2152356884166.432916533319
2당진2020-05-019559.51370269698187.582935870730
3당진2020-06-0143610.6616590270718281.071678846260
4당진2020-07-01196633.7270404700221834.2786105240620
5당진2020-08-0124533.278513134311060.152553493958
6당진2020-09-0130744.5913119961017032.712995218030
7당진2020-10-0131256.3617222686030824.19126451160
8당진2020-11-0133070.6818085016840564.1832149653534
9당진2020-12-0116251.758091271421220.343295816718
센터명연월친환경 농산물 사용량(Kg)친환경 농산물 공급액(원)일반 농산물 사용량(Kg)일반 농산물 공급액(원)
149부여2020-11-0121271.19881840808995.107444300038
150부여2020-12-0121096.33917885647689.558741663566
151부여2021-01-015875.8291178202332.6513700986
152부여2021-02-012895.0110079621431.71945970
153금산2020-07-01110.036300000.00
154금산2020-08-0174.024420000.00
155금산2020-09-01134.044220000.00
156금산2020-10-01104.034320000.00
157금산2020-11-01119.012182000.00
158금산2020-12-01325.093640000.00