Overview

Dataset statistics

Number of variables8
Number of observations27
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.8 KiB
Average record size in memory69.9 B

Variable types

Numeric1
Categorical4
Text2
DateTime1

Dataset

Description전라남도 곡성군 농산물 급식소 지원 현황 데이터 입니다. 시도명, 시군구명, 시설구분, 학교 및 시설명, 품목, 주소 등을 포함하고있습니다.
URLhttps://www.data.go.kr/data/3078781/fileData.do

Alerts

시도명 has constant value ""Constant
시군구명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
연번 is highly overall correlated with 구분High correlation
구분 is highly overall correlated with 연번High correlation
품목 is highly imbalanced (77.1%)Imbalance
연번 has unique valuesUnique
학교및시설 has unique valuesUnique

Reproduction

Analysis started2023-10-09 18:53:18.701998
Analysis finished2023-10-09 18:53:19.902803
Duration1.2 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14
Minimum1
Maximum27
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size375.0 B
2023-10-10T03:53:20.033490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.3
Q17.5
median14
Q320.5
95-th percentile25.7
Maximum27
Range26
Interquartile range (IQR)13

Descriptive statistics

Standard deviation7.9372539
Coefficient of variation (CV)0.56694671
Kurtosis-1.2
Mean14
Median Absolute Deviation (MAD)7
Skewness0
Sum378
Variance63
MonotonicityStrictly increasing
2023-10-10T03:53:20.300775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
1 1
 
3.7%
2 1
 
3.7%
27 1
 
3.7%
26 1
 
3.7%
25 1
 
3.7%
24 1
 
3.7%
23 1
 
3.7%
22 1
 
3.7%
21 1
 
3.7%
20 1
 
3.7%
Other values (17) 17
63.0%
ValueCountFrequency (%)
1 1
3.7%
2 1
3.7%
3 1
3.7%
4 1
3.7%
5 1
3.7%
6 1
3.7%
7 1
3.7%
8 1
3.7%
9 1
3.7%
10 1
3.7%
ValueCountFrequency (%)
27 1
3.7%
26 1
3.7%
25 1
3.7%
24 1
3.7%
23 1
3.7%
22 1
3.7%
21 1
3.7%
20 1
3.7%
19 1
3.7%
18 1
3.7%

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
전라남도
27 

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 (%)
전라남도 27
100.0%

Length

2023-10-10T03:53:20.552360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-10-10T03:53:20.754035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전라남도 27
100.0%

시군구명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
곡성군
27 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row곡성군
2nd row곡성군
3rd row곡성군
4th row곡성군
5th row곡성군

Common Values

ValueCountFrequency (%)
곡성군 27
100.0%

Length

2023-10-10T03:53:20.944125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-10-10T03:53:21.147653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
곡성군 27
100.0%

구분
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)18.5%
Missing0
Missing (%)0.0%
Memory size348.0 B
보육시설
11 
초등학교
8 
고등학교
4 
중학교
3 
유치원
 
1

Length

Max length4
Median length4
Mean length3.8518519
Min length3

Unique

Unique1 ?
Unique (%)3.7%

Sample

1st row보육시설
2nd row보육시설
3rd row보육시설
4th row보육시설
5th row보육시설

Common Values

ValueCountFrequency (%)
보육시설 11
40.7%
초등학교 8
29.6%
고등학교 4
 
14.8%
중학교 3
 
11.1%
유치원 1
 
3.7%

Length

2023-10-10T03:53:21.341704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-10-10T03:53:21.567727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
보육시설 11
40.7%
초등학교 8
29.6%
고등학교 4
 
14.8%
중학교 3
 
11.1%
유치원 1
 
3.7%

학교및시설
Text

UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size348.0 B
2023-10-10T03:53:21.945233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length6
Mean length5.5185185
Min length3

Characters and Unicode

Total characters149
Distinct characters49
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique27 ?
Unique (%)100.0%

Sample

1st row삼강어린이집
2nd row과학대어린이집
3rd row예산어린이집
4th row산들어린이집
5th row에덴어린이집
ValueCountFrequency (%)
삼강어린이집 1
 
3.7%
석곡초등학교 1
 
3.7%
한울고 1
 
3.7%
옥과고 1
 
3.7%
곡성고 1
 
3.7%
옥과중 1
 
3.7%
석곡중 1
 
3.7%
곡성중 1
 
3.7%
오산초등학교 1
 
3.7%
입면초등학교 1
 
3.7%
Other values (17) 17
63.0%
2023-10-10T03:53:22.572759image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
어 11
 
7.4%
린 11
 
7.4%
이 11
 
7.4%
집 11
 
7.4%
학 10
 
6.7%
곡 8
 
5.4%
초 8
 
5.4%
등 8
 
5.4%
교 8
 
5.4%
고 5
 
3.4%
Other values (39) 58
38.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 149
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
어 11
 
7.4%
린 11
 
7.4%
이 11
 
7.4%
집 11
 
7.4%
학 10
 
6.7%
곡 8
 
5.4%
초 8
 
5.4%
등 8
 
5.4%
교 8
 
5.4%
고 5
 
3.4%
Other values (39) 58
38.9%

Most occurring scripts

ValueCountFrequency (%)
Hangul 149
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
어 11
 
7.4%
린 11
 
7.4%
이 11
 
7.4%
집 11
 
7.4%
학 10
 
6.7%
곡 8
 
5.4%
초 8
 
5.4%
등 8
 
5.4%
교 8
 
5.4%
고 5
 
3.4%
Other values (39) 58
38.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 149
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
어 11
 
7.4%
린 11
 
7.4%
이 11
 
7.4%
집 11
 
7.4%
학 10
 
6.7%
곡 8
 
5.4%
초 8
 
5.4%
등 8
 
5.4%
교 8
 
5.4%
고 5
 
3.4%
Other values (39) 58
38.9%

품목
Categorical

IMBALANCE 

Distinct2
Distinct (%)7.4%
Missing0
Missing (%)0.0%
Memory size348.0 B
백미 외 103개 품목
26 
백미 외 103개 품목
 
1

Length

Max length14
Median length14
Mean length13.962963
Min length13

Unique

Unique1 ?
Unique (%)3.7%

Sample

1st row 백미 외 103개 품목
2nd row 백미 외 103개 품목
3rd row 백미 외 103개 품목
4th row 백미 외 103개 품목
5th row 백미 외 103개 품목

Common Values

ValueCountFrequency (%)
백미 외 103개 품목 26
96.3%
백미 외 103개 품목 1
 
3.7%

Length

2023-10-10T03:53:22.840420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-10-10T03:53:23.045873image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
백미 27
25.0%
외 27
25.0%
103개 27
25.0%
품목 27
25.0%

주소
Text

Distinct26
Distinct (%)96.3%
Missing0
Missing (%)0.0%
Memory size348.0 B
2023-10-10T03:53:23.391687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length22
Mean length20.666667
Min length16

Characters and Unicode

Total characters558
Distinct characters58
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

Unique25 ?
Unique (%)92.6%

Sample

1st row전라남도 곡성군 곡성읍 군청로 36
2nd row전라남도 곡성군 옥과면 옥과리 대학로 113번지
3rd row전라남도 곡성군 곡성읍 읍내33길 23
4th row전라남도 곡성군 곡성읍 읍내리 242-1
5th row전라남도 곡성군 곡성읍 학정리 655-1
ValueCountFrequency (%)
곡성군 28
21.2%
전라남도 27
20.5%
곡성읍 10
 
7.6%
옥과면 6
 
4.5%
석곡면 4
 
3.0%
석곡리 4
 
3.0%
읍내리 2
 
1.5%
옥과리 2
 
1.5%
읍내리297-13 2
 
1.5%
입면 2
 
1.5%
Other values (45) 45
34.1%
2023-10-10T03:53:24.032457image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
105
18.8%
곡 47
 
8.4%
성 38
 
6.8%
군 29
 
5.2%
전 28
 
5.0%
라 27
 
4.8%
도 27
 
4.8%
남 27
 
4.8%
리 23
 
4.1%
1 18
 
3.2%
Other values (48) 189
33.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 358
64.2%
Space Separator 105
 
18.8%
Decimal Number 86
 
15.4%
Dash Punctuation 9
 
1.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
곡 47
13.1%
성 38
10.6%
군 29
 
8.1%
전 28
 
7.8%
라 27
 
7.5%
도 27
 
7.5%
남 27
 
7.5%
리 23
 
6.4%
면 17
 
4.7%
읍 16
 
4.5%
Other values (36) 79
22.1%
Decimal Number
ValueCountFrequency (%)
1 18
20.9%
2 15
17.4%
3 13
15.1%
7 10
11.6%
5 7
 
8.1%
6 6
 
7.0%
4 6
 
7.0%
8 5
 
5.8%
0 3
 
3.5%
9 3
 
3.5%
Space Separator
ValueCountFrequency (%)
105
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 9
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 358
64.2%
Common 200
35.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
곡 47
13.1%
성 38
10.6%
군 29
 
8.1%
전 28
 
7.8%
라 27
 
7.5%
도 27
 
7.5%
남 27
 
7.5%
리 23
 
6.4%
면 17
 
4.7%
읍 16
 
4.5%
Other values (36) 79
22.1%
Common
ValueCountFrequency (%)
105
52.5%
1 18
 
9.0%
2 15
 
7.5%
3 13
 
6.5%
7 10
 
5.0%
- 9
 
4.5%
5 7
 
3.5%
6 6
 
3.0%
4 6
 
3.0%
8 5
 
2.5%
Other values (2) 6
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 358
64.2%
ASCII 200
35.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
105
52.5%
1 18
 
9.0%
2 15
 
7.5%
3 13
 
6.5%
7 10
 
5.0%
- 9
 
4.5%
5 7
 
3.5%
6 6
 
3.0%
4 6
 
3.0%
8 5
 
2.5%
Other values (2) 6
 
3.0%
Hangul
ValueCountFrequency (%)
곡 47
13.1%
성 38
10.6%
군 29
 
8.1%
전 28
 
7.8%
라 27
 
7.5%
도 27
 
7.5%
남 27
 
7.5%
리 23
 
6.4%
면 17
 
4.7%
읍 16
 
4.5%
Other values (36) 79
22.1%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
Minimum2023-04-03 00:00:00
Maximum2023-04-03 00:00:00
2023-10-10T03:53:24.232457image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-10-10T03:53:24.399490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-10-10T03:53:19.266600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-10-10T03:53:24.553622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분학교및시설품목주소
연번1.0000.9671.0000.0001.000
구분0.9671.0001.0000.0000.000
학교및시설1.0001.0001.0001.0001.000
품목0.0000.0001.0001.0001.000
주소1.0000.0001.0001.0001.000
2023-10-10T03:53:24.739184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
품목구분
품목1.0000.000
구분0.0001.000
2023-10-10T03:53:24.910865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분품목
연번1.0000.6070.000
구분0.6071.0000.000
품목0.0000.0001.000

Missing values

2023-10-10T03:53:19.524184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-10-10T03:53:19.799417image/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

연번시도명시군구명구분학교및시설품목주소데이터기준일자
01전라남도곡성군보육시설삼강어린이집백미 외 103개 품목전라남도 곡성군 곡성읍 군청로 362023-04-03
12전라남도곡성군보육시설과학대어린이집백미 외 103개 품목전라남도 곡성군 옥과면 옥과리 대학로 113번지2023-04-03
23전라남도곡성군보육시설예산어린이집백미 외 103개 품목전라남도 곡성군 곡성읍 읍내33길 232023-04-03
34전라남도곡성군보육시설산들어린이집백미 외 103개 품목전라남도 곡성군 곡성읍 읍내리 242-12023-04-03
45전라남도곡성군보육시설에덴어린이집백미 외 103개 품목전라남도 곡성군 곡성읍 학정리 655-12023-04-03
56전라남도곡성군보육시설석곡어린이집백미 외 103개 품목전라남도 곡성군 석곡면 석곡리 1302023-04-03
67전라남도곡성군보육시설늘푸른어린이집백미 외 103개 품목전라남도 곡성군 석곡면 석곡리 2412023-04-03
78전라남도곡성군보육시설죽림어린이집백미 외 103개 품목전라남도 곡성군 옥과면 죽림리 118-42023-04-03
89전라남도곡성군보육시설한빛어린이집백미 외 103개 품목전라남도 곡성군 옥과면 죽림리125-182023-04-03
910전라남도곡성군보육시설아해뜰어린이집백미 외 103개 품목전라남도 곡성군 곡성읍 학교로 152023-04-03
연번시도명시군구명구분학교및시설품목주소데이터기준일자
1718전라남도곡성군초등학교죽곡초등학교백미 외 103개 품목전라남도 곡성군 죽곡면 태평리 6142023-04-03
1819전라남도곡성군초등학교입면초등학교백미 외 103개 품목전라남도 곡성군 입면 송전리 5732023-04-03
1920전라남도곡성군초등학교오산초등학교백미 외 103개 품목전라남도 곡성군 오산면 봉동리2023-04-03
2021전라남도곡성군중학교곡성중백미 외 103개 품목전라남도 곡성군 곡성읍 읍내리726-12023-04-03
2122전라남도곡성군중학교석곡중백미 외 103개 품목전라남도 곡성군 석곡면 석곡리 2702023-04-03
2223전라남도곡성군중학교옥과중백미 외 103개 품목전라남도 곡성군 옥과면 율사리 2712023-04-03
2324전라남도곡성군고등학교곡성고백미 외 103개 품목전라남도 곡성군 곡성읍 읍내리 446-12023-04-03
2425전라남도곡성군고등학교옥과고백미 외 103개 품목전라남도 곡성군 옥과면 옥과리 2852023-04-03
2526전라남도곡성군고등학교한울고백미 외 103개 품목전라남도 곡성군 목사동면 주목로 7132023-04-03
2627전라남도곡성군고등학교전남조리과학고백미 외 103개 품목전라남도 곡성군 곡성읍 교촌리 222023-04-03