Overview

Dataset statistics

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

Variable types

Categorical2
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

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

Reproduction

Analysis started2024-01-09 22:19:31.582042
Analysis finished2024-01-09 22:19:33.244183
Duration1.66 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

센터명
Categorical

Distinct13
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
천안센터
12 
공주센터
12 
보령센터
12 
아산센터
12 
서산센터
12 
Other values (8)
96 

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 (%)
천안센터 12
 
7.7%
공주센터 12
 
7.7%
보령센터 12
 
7.7%
아산센터 12
 
7.7%
서산센터 12
 
7.7%
논산센터 12
 
7.7%
당진센터 12
 
7.7%
부여센터 12
 
7.7%
서천센터 12
 
7.7%
청양센터 12
 
7.7%
Other values (3) 36
23.1%

Length

2024-01-10T07:19:33.511634image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
천안센터 12
 
7.7%
공주센터 12
 
7.7%
보령센터 12
 
7.7%
아산센터 12
 
7.7%
서산센터 12
 
7.7%
논산센터 12
 
7.7%
당진센터 12
 
7.7%
부여센터 12
 
7.7%
서천센터 12
 
7.7%
청양센터 12
 
7.7%
Other values (3) 36
23.1%

연월
Categorical

Distinct12
Distinct (%)7.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2022-03-01
13 
2022-04-01
13 
2022-05-01
13 
2022-06-01
13 
2022-07-01
13 
Other values (7)
91 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-03-01
2nd row2022-04-01
3rd row2022-05-01
4th row2022-06-01
5th row2022-07-01

Common Values

ValueCountFrequency (%)
2022-03-01 13
8.3%
2022-04-01 13
8.3%
2022-05-01 13
8.3%
2022-06-01 13
8.3%
2022-07-01 13
8.3%
2022-08-01 13
8.3%
2022-09-01 13
8.3%
2022-10-01 13
8.3%
2022-11-01 13
8.3%
2022-12-01 13
8.3%
Other values (2) 26
16.7%

Length

2024-01-10T07:19:33.597296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2022-03-01 13
8.3%
2022-04-01 13
8.3%
2022-05-01 13
8.3%
2022-06-01 13
8.3%
2022-07-01 13
8.3%
2022-08-01 13
8.3%
2022-09-01 13
8.3%
2022-10-01 13
8.3%
2022-11-01 13
8.3%
2022-12-01 13
8.3%
Other values (2) 26
16.7%

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

HIGH CORRELATION  UNIQUE 

Distinct156
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.9021745 × 108
Minimum9015848
Maximum1.1889948 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-01-10T07:19:33.691222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum9015848
5-th percentile24127700
Q160232652
median1.059241 × 108
Q32.1520035 × 108
95-th percentile6.9335018 × 108
Maximum1.1889948 × 109
Range1.1799789 × 109
Interquartile range (IQR)1.549677 × 108

Descriptive statistics

Standard deviation2.188042 × 108
Coefficient of variation (CV)1.1502846
Kurtosis4.8086123
Mean1.9021745 × 108
Median Absolute Deviation (MAD)62471670
Skewness2.1948703
Sum2.9673922 × 1010
Variance4.7875279 × 1016
MonotonicityNot monotonic
2024-01-10T07:19:33.804153image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
862123709 1
 
0.6%
33555934 1
 
0.6%
40273772 1
 
0.6%
59015992 1
 
0.6%
60167775 1
 
0.6%
64623891 1
 
0.6%
65858742 1
 
0.6%
28280228 1
 
0.6%
12578645 1
 
0.6%
31676841 1
 
0.6%
Other values (146) 146
93.6%
ValueCountFrequency (%)
9015848 1
0.6%
10765287 1
0.6%
12578645 1
0.6%
14458414 1
0.6%
14487877 1
0.6%
20353641 1
0.6%
20603711 1
0.6%
22551056 1
0.6%
24653248 1
0.6%
26479095 1
0.6%
ValueCountFrequency (%)
1188994760 1
0.6%
970533020 1
0.6%
894125336 1
0.6%
862123709 1
0.6%
850414736 1
0.6%
841383691 1
0.6%
746523814 1
0.6%
742158241 1
0.6%
677080825 1
0.6%
660002419 1
0.6%

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

HIGH CORRELATION  UNIQUE 

Distinct156
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean38452.448
Minimum1028.23
Maximum216049.87
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-01-10T07:19:33.918931image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1028.23
5-th percentile5030.5075
Q111127.698
median22770.88
Q350548.65
95-th percentile136810.59
Maximum216049.87
Range215021.64
Interquartile range (IQR)39420.952

Descriptive statistics

Standard deviation43169.682
Coefficient of variation (CV)1.1226771
Kurtosis4.3616447
Mean38452.448
Median Absolute Deviation (MAD)13127.375
Skewness2.1362067
Sum5998581.8
Variance1.8636215 × 109
MonotonicityNot monotonic
2024-01-10T07:19:34.021669image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
158180.68 1
 
0.6%
7544.99 1
 
0.6%
9562.71 1
 
0.6%
13790.62 1
 
0.6%
14022.68 1
 
0.6%
15255.78 1
 
0.6%
14994.2 1
 
0.6%
6332.94 1
 
0.6%
3191.6 1
 
0.6%
7469.98 1
 
0.6%
Other values (146) 146
93.6%
ValueCountFrequency (%)
1028.23 1
0.6%
2036.53 1
0.6%
2170.71 1
0.6%
2399.95 1
0.6%
3191.6 1
0.6%
3807.24 1
0.6%
4495.74 1
0.6%
4990.33 1
0.6%
5043.9 1
0.6%
5176.28 1
0.6%
ValueCountFrequency (%)
216049.87 1
0.6%
195877.38 1
0.6%
185164.67 1
0.6%
184846.81 1
0.6%
175566.3 1
0.6%
158180.68 1
0.6%
142020.6 1
0.6%
140509.11 1
0.6%
135577.75 1
0.6%
135018.91 1
0.6%

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

HIGH CORRELATION  UNIQUE 

Distinct156
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.2557972 × 108
Minimum97826
Maximum1.0393987 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-01-10T07:19:34.126334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum97826
5-th percentile10114334
Q137732611
median76822968
Q31.2905383 × 108
95-th percentile5.4506341 × 108
Maximum1.0393987 × 109
Range1.0393008 × 109
Interquartile range (IQR)91321221

Descriptive statistics

Standard deviation1.6472468 × 108
Coefficient of variation (CV)1.311714
Kurtosis10.682355
Mean1.2557972 × 108
Median Absolute Deviation (MAD)42419356
Skewness3.0943646
Sum1.9590436 × 1010
Variance2.7134219 × 1016
MonotonicityNot monotonic
2024-01-10T07:19:34.243851image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
643017484 1
 
0.6%
37287201 1
 
0.6%
16904472 1
 
0.6%
38878213 1
 
0.6%
36162808 1
 
0.6%
41119679 1
 
0.6%
54308746 1
 
0.6%
8153448 1
 
0.6%
97826 1
 
0.6%
34230168 1
 
0.6%
Other values (146) 146
93.6%
ValueCountFrequency (%)
97826 1
0.6%
3157931 1
0.6%
3873582 1
0.6%
5580217 1
0.6%
5909277 1
0.6%
7030718 1
0.6%
8153448 1
0.6%
8810236 1
0.6%
10549033 1
0.6%
11142332 1
0.6%
ValueCountFrequency (%)
1039398656 1
0.6%
877359671 1
0.6%
717389661 1
0.6%
704515016 1
0.6%
643017484 1
0.6%
604978202 1
0.6%
567639852 1
0.6%
557460666 1
0.6%
540930992 1
0.6%
444525785 1
0.6%

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

HIGH CORRELATION  UNIQUE 

Distinct156
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23646.517
Minimum19.95
Maximum212006.32
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-01-10T07:19:34.360476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19.95
5-th percentile1508.09
Q17079.345
median13922.835
Q322086.635
95-th percentile122381.92
Maximum212006.32
Range211986.37
Interquartile range (IQR)15007.29

Descriptive statistics

Standard deviation35077.559
Coefficient of variation (CV)1.4834133
Kurtosis12.057321
Mean23646.517
Median Absolute Deviation (MAD)7453.585
Skewness3.3461963
Sum3688856.7
Variance1.2304352 × 109
MonotonicityNot monotonic
2024-01-10T07:19:34.468459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
138274.1 1
 
0.6%
7165.78 1
 
0.6%
3046.19 1
 
0.6%
6112.74 1
 
0.6%
5826.96 1
 
0.6%
7212.12 1
 
0.6%
8509.52 1
 
0.6%
1271.1 1
 
0.6%
19.95 1
 
0.6%
7029.38 1
 
0.6%
Other values (146) 146
93.6%
ValueCountFrequency (%)
19.95 1
0.6%
354.88 1
0.6%
439.49 1
0.6%
719.03 1
0.6%
1209.84 1
0.6%
1271.1 1
0.6%
1276.8 1
0.6%
1415.12 1
0.6%
1539.08 1
0.6%
1857.77 1
0.6%
ValueCountFrequency (%)
212006.32 1
0.6%
205543.83 1
0.6%
139337.76 1
0.6%
138274.1 1
0.6%
137169.31 1
0.6%
136439.19 1
0.6%
131309.96 1
0.6%
129544.41 1
0.6%
119994.42 1
0.6%
86025.85 1
0.6%

Interactions

2024-01-10T07:19:32.740226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:31.791009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:32.079558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:32.409992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:32.826291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:31.860353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:32.173829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:32.498548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:32.904674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:31.925854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:32.249014image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:32.578649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:32.986224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:31.996242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:32.335403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:19:32.660396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T07:19:34.538791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
센터명연월친환경 농산물 공급액(원)친환경 농산물 사용량(Kg)일반 농산물 공급액(원)일반 농산물 사용량(Kg)
센터명1.0000.0000.7160.7520.7490.765
연월0.0001.0000.0000.1310.0000.000
친환경 농산물 공급액(원)0.7160.0001.0000.9770.8740.843
친환경 농산물 사용량(Kg)0.7520.1310.9771.0000.8900.849
일반 농산물 공급액(원)0.7490.0000.8740.8901.0000.937
일반 농산물 사용량(Kg)0.7650.0000.8430.8490.9371.000
2024-01-10T07:19:34.619158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연월센터명
연월1.0000.000
센터명0.0001.000
2024-01-10T07:19:34.685908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
친환경 농산물 공급액(원)친환경 농산물 사용량(Kg)일반 농산물 공급액(원)일반 농산물 사용량(Kg)센터명연월
친환경 농산물 공급액(원)1.0000.9840.9250.9060.3940.000
친환경 농산물 사용량(Kg)0.9841.0000.9360.9270.4310.060
일반 농산물 공급액(원)0.9250.9361.0000.9810.4390.000
일반 농산물 사용량(Kg)0.9060.9270.9811.0000.4740.000
센터명0.3940.4310.4390.4741.0000.000
연월0.0000.0600.0000.0000.0001.000

Missing values

2024-01-10T07:19:33.090639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T07:19:33.198705image/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천안센터2022-03-01862123709158180.68643017484138274.1
1천안센터2022-04-01850414736175566.3604978202131309.96
2천안센터2022-05-01894125336184846.81557460666137169.31
3천안센터2022-06-01841383691185164.67567639852136439.19
4천안센터2022-07-01490201940105072.59540930992119994.42
5천안센터2022-08-0144711432796182.2444452578586025.85
6천안센터2022-09-0154935388793225.131039398656212006.32
7천안센터2022-10-01611608489112195.23877359671205543.83
8천안센터2022-11-01970533020195877.38717389661139337.76
9천안센터2022-12-011188994760216049.87704515016129544.41
센터명연월친환경 농산물 공급액(원)친환경 농산물 사용량(Kg)일반 농산물 공급액(원)일반 농산물 사용량(Kg)
146태안센터2022-05-016041845611002.926475645411242.85
147태안센터2022-06-015546094313647.07517361217751.99
148태안센터2022-07-01437975349606.64359591874723.11
149태안센터2022-08-01315901026393.11295913393468.06
150태안센터2022-09-016392921212767.25620774416573.96
151태안센터2022-10-015926047710069.39591920767755.23
152태안센터2022-11-016837585411761.18547270337885.96
153태안센터2022-12-017824127912614.89525262377728.36
154태안센터2023-01-01144584142399.95111423321415.12
155태안센터2023-02-01144878771028.233157931354.88