Overview

Dataset statistics

Number of variables5
Number of observations185
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.1 KiB
Average record size in memory44.7 B

Variable types

Numeric4
Categorical1

Dataset

Description경기도농수산진흥원 경기도 친환경학교급식 현황
Author경기도농수산진흥원
URLhttps://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=ODHRT65XS20SO9884WNL32121508&infSeq=1

Alerts

학교수 is highly overall correlated with 학생수 and 1 other fieldsHigh correlation
학생수 is highly overall correlated with 학교수High correlation
시군명 is highly overall correlated with 학교수High correlation
학생수 has 2 (1.1%) zerosZeros

Reproduction

Analysis started2023-12-10 22:00:52.506616
Analysis finished2023-12-10 22:00:54.203593
Duration1.7 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지원년도
Real number (ℝ)

Distinct6
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2019.4865
Minimum2017
Maximum2022
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.8 KiB
2023-12-11T07:00:54.252341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2017
5-th percentile2017
Q12018
median2019
Q32021
95-th percentile2022
Maximum2022
Range5
Interquartile range (IQR)3

Descriptive statistics

Standard deviation1.7071082
Coefficient of variation (CV)0.00084531798
Kurtosis-1.2642331
Mean2019.4865
Median Absolute Deviation (MAD)1
Skewness0.0067521432
Sum373605
Variance2.9142186
MonotonicityDecreasing
2023-12-11T07:00:54.381747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
2021 31
16.8%
2020 31
16.8%
2019 31
16.8%
2018 31
16.8%
2017 31
16.8%
2022 30
16.2%
ValueCountFrequency (%)
2017 31
16.8%
2018 31
16.8%
2019 31
16.8%
2020 31
16.8%
2021 31
16.8%
2022 30
16.2%
ValueCountFrequency (%)
2022 30
16.2%
2021 31
16.8%
2020 31
16.8%
2019 31
16.8%
2018 31
16.8%
2017 31
16.8%

시군명
Categorical

HIGH CORRELATION 

Distinct31
Distinct (%)16.8%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
가평군
 
6
고양시
 
6
과천시
 
6
광명시
 
6
광주시
 
6
Other values (26)
155 

Length

Max length4
Median length3
Mean length3.0972973
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가평군
2nd row고양시
3rd row과천시
4th row광명시
5th row광주시

Common Values

ValueCountFrequency (%)
가평군 6
 
3.2%
고양시 6
 
3.2%
과천시 6
 
3.2%
광명시 6
 
3.2%
광주시 6
 
3.2%
구리시 6
 
3.2%
군포시 6
 
3.2%
김포시 6
 
3.2%
남양주시 6
 
3.2%
동두천시 6
 
3.2%
Other values (21) 125
67.6%

Length

2023-12-11T07:00:54.513106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
가평군 6
 
3.2%
양주시 6
 
3.2%
화성시 6
 
3.2%
하남시 6
 
3.2%
포천시 6
 
3.2%
평택시 6
 
3.2%
파주시 6
 
3.2%
이천시 6
 
3.2%
의정부시 6
 
3.2%
의왕시 6
 
3.2%
Other values (21) 125
67.6%

평균급식일수
Real number (ℝ)

Distinct50
Distinct (%)27.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean175.24865
Minimum0
Maximum209
Zeros1
Zeros (%)0.5%
Negative0
Negative (%)0.0%
Memory size1.8 KiB
2023-12-11T07:00:54.649279image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile126
Q1175
median188
Q3191
95-th percentile194
Maximum209
Range209
Interquartile range (IQR)16

Descriptive statistics

Standard deviation29.697804
Coefficient of variation (CV)0.16946096
Kurtosis11.108666
Mean175.24865
Median Absolute Deviation (MAD)4
Skewness-2.7904837
Sum32421
Variance881.95958
MonotonicityNot monotonic
2023-12-11T07:00:54.779023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
192 17
 
9.2%
191 16
 
8.6%
190 16
 
8.6%
189 16
 
8.6%
187 13
 
7.0%
193 11
 
5.9%
186 7
 
3.8%
194 7
 
3.8%
188 7
 
3.8%
126 6
 
3.2%
Other values (40) 69
37.3%
ValueCountFrequency (%)
0 1
 
0.5%
5 1
 
0.5%
113 1
 
0.5%
120 1
 
0.5%
122 1
 
0.5%
123 1
 
0.5%
124 2
 
1.1%
125 1
 
0.5%
126 6
3.2%
127 3
1.6%
ValueCountFrequency (%)
209 1
 
0.5%
197 2
 
1.1%
195 5
 
2.7%
194 7
3.8%
193 11
5.9%
192 17
9.2%
191 16
8.6%
190 16
8.6%
189 16
8.6%
188 7
3.8%

학교수
Real number (ℝ)

HIGH CORRELATION 

Distinct162
Distinct (%)87.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean319.74054
Minimum0
Maximum1199
Zeros1
Zeros (%)0.5%
Negative0
Negative (%)0.0%
Memory size1.8 KiB
2023-12-11T07:00:54.900055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile23
Q198
median292
Q3472
95-th percentile819.6
Maximum1199
Range1199
Interquartile range (IQR)374

Descriptive statistics

Standard deviation263.54399
Coefficient of variation (CV)0.82424326
Kurtosis0.76933667
Mean319.74054
Median Absolute Deviation (MAD)194
Skewness1.0431637
Sum59152
Variance69455.432
MonotonicityNot monotonic
2023-12-11T07:00:55.056520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
342 3
 
1.6%
176 3
 
1.6%
292 2
 
1.1%
357 2
 
1.1%
89 2
 
1.1%
372 2
 
1.1%
98 2
 
1.1%
294 2
 
1.1%
320 2
 
1.1%
128 2
 
1.1%
Other values (152) 163
88.1%
ValueCountFrequency (%)
0 1
0.5%
3 1
0.5%
7 1
0.5%
8 1
0.5%
16 1
0.5%
18 1
0.5%
19 1
0.5%
21 2
1.1%
22 1
0.5%
27 1
0.5%
ValueCountFrequency (%)
1199 1
0.5%
1179 1
0.5%
1128 1
0.5%
1096 1
0.5%
981 1
0.5%
898 1
0.5%
865 1
0.5%
839 1
0.5%
825 1
0.5%
821 1
0.5%

학생수
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct184
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean210991.5
Minimum0
Maximum900283
Zeros2
Zeros (%)1.1%
Negative0
Negative (%)0.0%
Memory size1.8 KiB
2023-12-11T07:00:55.180966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile8628.4
Q149580
median169280
Q3330140
95-th percentile560606.4
Maximum900283
Range900283
Interquartile range (IQR)280560

Descriptive statistics

Standard deviation193535.39
Coefficient of variation (CV)0.91726628
Kurtosis1.0540015
Mean210991.5
Median Absolute Deviation (MAD)128218
Skewness1.1321813
Sum39033427
Variance3.7455946 × 1010
MonotonicityNot monotonic
2023-12-11T07:00:55.297132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 2
 
1.1%
4864 1
 
0.5%
184368 1
 
0.5%
102118 1
 
0.5%
238608 1
 
0.5%
44148 1
 
0.5%
34506 1
 
0.5%
249929 1
 
0.5%
56358 1
 
0.5%
330140 1
 
0.5%
Other values (174) 174
94.1%
ValueCountFrequency (%)
0 2
1.1%
2643 1
0.5%
3376 1
0.5%
4761 1
0.5%
4864 1
0.5%
6572 1
0.5%
6964 1
0.5%
7703 1
0.5%
8566 1
0.5%
8878 1
0.5%
ValueCountFrequency (%)
900283 1
0.5%
862162 1
0.5%
840557 1
0.5%
797983 1
0.5%
683854 1
0.5%
610266 1
0.5%
576575 1
0.5%
576335 1
0.5%
569676 1
0.5%
560650 1
0.5%

Interactions

2023-12-11T07:00:53.730938image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:00:52.692621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:00:53.039090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:00:53.388361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:00:53.816878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:00:52.773203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:00:53.121761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:00:53.477922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:00:53.892663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:00:52.854658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:00:53.227704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:00:53.552601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:00:53.969723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:00:52.943944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:00:53.316158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:00:53.633017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T07:00:55.374929image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지원년도시군명평균급식일수학교수학생수
지원년도1.0000.0000.7330.6410.401
시군명0.0001.0000.1560.8850.859
평균급식일수0.7330.1561.0000.3660.246
학교수0.6410.8850.3661.0000.977
학생수0.4010.8590.2460.9771.000
2023-12-11T07:00:55.465182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지원년도평균급식일수학교수학생수시군명
지원년도1.000-0.446-0.360-0.3550.000
평균급식일수-0.4461.0000.4020.3930.056
학교수-0.3600.4021.0000.9760.530
학생수-0.3550.3930.9761.0000.485
시군명0.0000.0560.5300.4851.000

Missing values

2023-12-11T07:00:54.069999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T07:00:54.168055image/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

지원년도시군명평균급식일수학교수학생수
02022가평군185224864
12022고양시1684529446
22022과천시17176572
32022광명시1713725449
42022광주시1614230044
52022구리시185169958
62022군포시1753318117
72022김포시1817052656
82022남양주시1757852339
92022동두천시183218566
지원년도시군명평균급식일수학교수학생수
1752017오산시191294219880
1762017용인시186374310619
1772017의왕시18711982050
1782017의정부시189568379721
1792017이천시189372219546
1802017파주시189564423290
1812017평택시191456296030
1822017포천시18725487313
1832017하남시18616095896
1842017화성시18921256219