Overview

Dataset statistics

Number of variables19
Number of observations130
Missing cells25
Missing cells (%)1.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory19.9 KiB
Average record size in memory157.0 B

Variable types

Categorical15
Text1
Numeric3

Dataset

Description제주특별자치도에서 관리하는 시중 유통식품 안정성 검사 결과와 관련하여 제품명, 분류, 검사결과 (세균수 / 대장균 등)에 대한 정보를 제공합니다.
Author제주특별자치도
URLhttps://www.data.go.kr/data/3084148/fileData.do

Alerts

대장균 검사결과 (정량) has constant value ""Constant
캠피로박터 제주니 콜리 검사결과 (정성) has constant value ""Constant
데이터기준일자 has constant value ""Constant
살균(또는멸균) 유무 is highly overall correlated with 시료량 and 8 other fieldsHigh correlation
지역 is highly overall correlated with 시료량 and 9 other fieldsHigh correlation
성상 is highly overall correlated with 시료량 and 10 other fieldsHigh correlation
식품 소분류 is highly overall correlated with 대장균군 검사결과 (정량) and 12 other fieldsHigh correlation
유통기한 is highly overall correlated with 세균수 검사결과 (정량) and 13 other fieldsHigh correlation
모니터링 일시 is highly overall correlated with 대장균군 검사결과 (정량) and 12 other fieldsHigh correlation
제조원 is highly overall correlated with 대장균군 검사결과 (정량) and 12 other fieldsHigh correlation
보존온도 is highly overall correlated with 시료량 and 8 other fieldsHigh correlation
수거장소 is highly overall correlated with 시료량 and 10 other fieldsHigh correlation
시료량단위 is highly overall correlated with 시료량 and 9 other fieldsHigh correlation
제품명 is highly overall correlated with 세균수 검사결과 (정량) and 13 other fieldsHigh correlation
식품 중분류 is highly overall correlated with 시료량 and 11 other fieldsHigh correlation
세균수 검사결과 (정량) is highly overall correlated with 대장균군 검사결과 (정량) and 2 other fieldsHigh correlation
대장균군 검사결과 (정량) is highly overall correlated with 세균수 검사결과 (정량) and 5 other fieldsHigh correlation
시료량 is highly overall correlated with 지역 and 11 other fieldsHigh correlation
보존온도 is highly imbalanced (60.9%)Imbalance
세균수 검사결과 (정량) has 25 (19.2%) missing valuesMissing
세균수 검사결과 (정량) has 78 (60.0%) zerosZeros
대장균군 검사결과 (정량) has 121 (93.1%) zerosZeros

Reproduction

Analysis started2023-12-12 05:06:31.714531
Analysis finished2023-12-12 05:06:34.692609
Duration2.98 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지역
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
제주시
85 
서귀포시
45 

Length

Max length4
Median length3
Mean length3.3461538
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제주시
2nd row제주시
3rd row제주시
4th row제주시
5th row제주시

Common Values

ValueCountFrequency (%)
제주시 85
65.4%
서귀포시 45
34.6%

Length

2023-12-12T14:06:34.769950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:06:35.203625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제주시 85
65.4%
서귀포시 45
34.6%

시료번호
Text

Distinct119
Distinct (%)91.5%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023-12-12T14:06:35.461731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11.5
Mean length10.346154
Min length7

Characters and Unicode

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

Unique

Unique108 ?
Unique (%)83.1%

Sample

1st row유통'21-22(1)
2nd row유통'21-22(2)
3rd row유통'21-22(3)
4th row유통'21-22(4)
5th row유통'21-22(5)
ValueCountFrequency (%)
서귀포시-03-2-1 2
 
1.5%
서귀포시-03-1-2 2
 
1.5%
서귀포시-03-2-2 2
 
1.5%
서귀포시-03-2-3 2
 
1.5%
서귀포시-03-2-4 2
 
1.5%
서귀포시-03-2-5 2
 
1.5%
서귀포시-03-1-1 2
 
1.5%
버터-2(5 2
 
1.5%
서귀포시-03-1-4 2
 
1.5%
서귀포시-03-1-3 2
 
1.5%
Other values (109) 110
84.6%
2023-12-12T14:06:35.876542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 215
16.0%
2 152
 
11.3%
1 120
 
8.9%
( 80
 
5.9%
) 80
 
5.9%
3 66
 
4.9%
4 51
 
3.8%
' 50
 
3.7%
0 50
 
3.7%
통 50
 
3.7%
Other values (15) 431
32.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 550
40.9%
Other Letter 370
27.5%
Dash Punctuation 215
 
16.0%
Open Punctuation 80
 
5.9%
Close Punctuation 80
 
5.9%
Other Punctuation 50
 
3.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
통 50
13.5%
유 50
13.5%
서 45
12.2%
귀 45
12.2%
시 45
12.2%
포 45
12.2%
물 20
 
5.4%
생 20
 
5.4%
미 20
 
5.4%
터 10
 
2.7%
Other values (3) 20
 
5.4%
Decimal Number
ValueCountFrequency (%)
2 152
27.6%
1 120
21.8%
3 66
12.0%
4 51
 
9.3%
0 50
 
9.1%
5 46
 
8.4%
6 45
 
8.2%
7 20
 
3.6%
Dash Punctuation
ValueCountFrequency (%)
- 215
100.0%
Open Punctuation
ValueCountFrequency (%)
( 80
100.0%
Close Punctuation
ValueCountFrequency (%)
) 80
100.0%
Other Punctuation
ValueCountFrequency (%)
' 50
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 975
72.5%
Hangul 370
 
27.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
통 50
13.5%
유 50
13.5%
서 45
12.2%
귀 45
12.2%
시 45
12.2%
포 45
12.2%
물 20
 
5.4%
생 20
 
5.4%
미 20
 
5.4%
터 10
 
2.7%
Other values (3) 20
 
5.4%
Common
ValueCountFrequency (%)
- 215
22.1%
2 152
15.6%
1 120
12.3%
( 80
 
8.2%
) 80
 
8.2%
3 66
 
6.8%
4 51
 
5.2%
' 50
 
5.1%
0 50
 
5.1%
5 46
 
4.7%
Other values (2) 65
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 975
72.5%
Hangul 370
 
27.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 215
22.1%
2 152
15.6%
1 120
12.3%
( 80
 
8.2%
) 80
 
8.2%
3 66
 
6.8%
4 51
 
5.2%
' 50
 
5.1%
0 50
 
5.1%
5 46
 
4.7%
Other values (2) 65
 
6.7%
Hangul
ValueCountFrequency (%)
통 50
13.5%
유 50
13.5%
서 45
12.2%
귀 45
12.2%
시 45
12.2%
포 45
12.2%
물 20
 
5.4%
생 20
 
5.4%
미 20
 
5.4%
터 10
 
2.7%
Other values (3) 20
 
5.4%

제품명
Categorical

HIGH CORRELATION 

Distinct29
Distinct (%)22.3%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
체다슬라이스치즈
 
10
엔요
 
5
맛있는우유GT
 
5
비피더스명장사과
 
5
프롬바이오 사과
 
5
Other values (24)
100 

Length

Max length24
Median length16
Mean length10.153846
Min length2

Unique

Unique5 ?
Unique (%)3.8%

Sample

1st row건강한 딸기 딸기우유
2nd row건강한 딸기 딸기우유
3rd row건강한 딸기 딸기우유
4th row건강한 딸기 딸기우유
5th row건강한 딸기 딸기우유

Common Values

ValueCountFrequency (%)
체다슬라이스치즈 10
 
7.7%
엔요 5
 
3.8%
맛있는우유GT 5
 
3.8%
비피더스명장사과 5
 
3.8%
프롬바이오 사과 5
 
3.8%
프로바이오틱스에이오 5
 
3.8%
매일생크림 5
 
3.8%
건국우유 5
 
3.8%
식물성아침에버터 5
 
3.8%
오케이쿡 후레쉬버터 5
 
3.8%
Other values (19) 75
57.7%

Length

2023-12-12T14:06:36.033901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
체다슬라이스치즈 10
 
4.2%
부대찌개 10
 
4.2%
맘스쿠킹 5
 
2.1%
신선한크림으로만든휘핑크림 5
 
2.1%
구워먹는치즈오리지널 5
 
2.1%
dairy 5
 
2.1%
whip 5
 
2.1%
whipped 5
 
2.1%
cream 5
 
2.1%
남양 5
 
2.1%
Other values (40) 180
75.0%

식품 중분류
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)7.7%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
치즈류
30 
발효유류
20 
유크림류
15 
가공유류
10 
우유류
10 
Other values (5)
45 

Length

Max length7
Median length5
Mean length3.8846154
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가공유류
2nd row가공유류
3rd row가공유류
4th row가공유류
5th row가공유류

Common Values

ValueCountFrequency (%)
치즈류 30
23.1%
발효유류 20
15.4%
유크림류 15
11.5%
가공유류 10
 
7.7%
우유류 10
 
7.7%
농축유류 10
 
7.7%
버터류 10
 
7.7%
영아용식품 10
 
7.7%
즉석편의식품류 10
 
7.7%
분유류 5
 
3.8%

Length

2023-12-12T14:06:36.196773image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:06:36.374114image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
치즈류 30
23.1%
발효유류 20
15.4%
유크림류 15
11.5%
가공유류 10
 
7.7%
우유류 10
 
7.7%
농축유류 10
 
7.7%
버터류 10
 
7.7%
영아용식품 10
 
7.7%
즉석편의식품류 10
 
7.7%
분유류 5
 
3.8%

식품 소분류
Categorical

HIGH CORRELATION 

Distinct14
Distinct (%)10.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
가공치즈
25 
발효유
15 
가공유
10 
자연치즈
10 
우유
10 
Other values (9)
60 

Length

Max length8
Median length6
Mean length4
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가공유
2nd row가공유
3rd row가공유
4th row가공유
5th row가공유

Common Values

ValueCountFrequency (%)
가공치즈 25
19.2%
발효유 15
11.5%
가공유 10
 
7.7%
자연치즈 10
 
7.7%
우유 10
 
7.7%
가공버터 10
 
7.7%
가공유크림 10
 
7.7%
간편조리세트 10
 
7.7%
농후발효유 5
 
3.8%
유크림 5
 
3.8%
Other values (4) 20
15.4%

Length

2023-12-12T14:06:36.549861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
가공치즈 25
18.5%
발효유 15
11.1%
가공유 10
 
7.4%
자연치즈 10
 
7.4%
우유 10
 
7.4%
가공버터 10
 
7.4%
가공유크림 10
 
7.4%
간편조리세트 10
 
7.4%
농후발효유 5
 
3.7%
유크림 5
 
3.7%
Other values (5) 25
18.5%

성상
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
고체
55 
액체
25 
반유동
25 
페이스트
20 
분말
 
5

Length

Max length4
Median length2
Mean length2.5
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row액체
2nd row액체
3rd row액체
4th row액체
5th row액체

Common Values

ValueCountFrequency (%)
고체 55
42.3%
액체 25
19.2%
반유동 25
19.2%
페이스트 20
 
15.4%
분말 5
 
3.8%

Length

2023-12-12T14:06:36.723680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:06:36.863785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
고체 55
42.3%
액체 25
19.2%
반유동 25
19.2%
페이스트 20
 
15.4%
분말 5
 
3.8%

세균수 검사결과 (정량)
Real number (ℝ)

HIGH CORRELATION  MISSING  ZEROS 

Distinct12
Distinct (%)11.4%
Missing25
Missing (%)19.2%
Infinite0
Infinite (%)0.0%
Mean1391.7143
Minimum0
Maximum27000
Zeros78
Zeros (%)60.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2023-12-12T14:06:36.985082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q35
95-th percentile5520
Maximum27000
Range27000
Interquartile range (IQR)5

Descriptive statistics

Standard deviation5351.267
Coefficient of variation (CV)3.8450902
Kurtosis15.86044
Mean1391.7143
Median Absolute Deviation (MAD)0
Skewness4.1275241
Sum146130
Variance28636059
MonotonicityNot monotonic
2023-12-12T14:06:37.104589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
0 78
60.0%
5 11
 
8.5%
10 4
 
3.1%
24000 3
 
2.3%
3800 2
 
1.5%
4400 1
 
0.8%
4200 1
 
0.8%
5800 1
 
0.8%
15 1
 
0.8%
25000 1
 
0.8%
Other values (2) 2
 
1.5%
(Missing) 25
 
19.2%
ValueCountFrequency (%)
0 78
60.0%
5 11
 
8.5%
10 4
 
3.1%
15 1
 
0.8%
20 1
 
0.8%
3800 2
 
1.5%
4200 1
 
0.8%
4400 1
 
0.8%
5800 1
 
0.8%
24000 3
 
2.3%
ValueCountFrequency (%)
27000 1
 
0.8%
25000 1
 
0.8%
24000 3
2.3%
5800 1
 
0.8%
4400 1
 
0.8%
4200 1
 
0.8%
3800 2
1.5%
20 1
 
0.8%
15 1
 
0.8%
10 4
3.1%

대장균군 검사결과 (정량)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct7
Distinct (%)5.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean32.269231
Minimum0
Maximum860
Zeros121
Zeros (%)93.1%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2023-12-12T14:06:37.207430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile5
Maximum860
Range860
Interquartile range (IQR)0

Descriptive statistics

Standard deviation161.02158
Coefficient of variation (CV)4.9899418
Kurtosis21.984204
Mean32.269231
Median Absolute Deviation (MAD)0
Skewness4.8608037
Sum4195
Variance25927.95
MonotonicityNot monotonic
2023-12-12T14:06:37.317791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
0 121
93.1%
5 3
 
2.3%
810 2
 
1.5%
840 1
 
0.8%
860 1
 
0.8%
850 1
 
0.8%
10 1
 
0.8%
ValueCountFrequency (%)
0 121
93.1%
5 3
 
2.3%
10 1
 
0.8%
810 2
 
1.5%
840 1
 
0.8%
850 1
 
0.8%
860 1
 
0.8%
ValueCountFrequency (%)
860 1
 
0.8%
850 1
 
0.8%
840 1
 
0.8%
810 2
 
1.5%
10 1
 
0.8%
5 3
 
2.3%
0 121
93.1%

대장균 검사결과 (정량)
Categorical

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
0
130 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 130
100.0%

Length

2023-12-12T14:06:37.441680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:06:37.548299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 130
100.0%

캠피로박터 제주니 콜리 검사결과 (정성)
Categorical

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
음성
130 

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 (%)
음성 130
100.0%

Length

2023-12-12T14:06:37.650002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:06:37.755257image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
음성 130
100.0%

시료량
Real number (ℝ)

HIGH CORRELATION 

Distinct22
Distinct (%)16.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean475.11538
Minimum1
Maximum1200
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2023-12-12T14:06:37.856604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile100
Q1300
median449
Q3560
95-th percentile1000
Maximum1200
Range1199
Interquartile range (IQR)260

Descriptive statistics

Standard deviation273.2166
Coefficient of variation (CV)0.57505316
Kurtosis0.5915087
Mean475.11538
Median Absolute Deviation (MAD)139
Skewness0.83435584
Sum61765
Variance74647.312
MonotonicityNot monotonic
2023-12-12T14:06:37.998723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%)
500 10
 
7.7%
400 10
 
7.7%
450 10
 
7.7%
250 10
 
7.7%
440 5
 
3.8%
870 5
 
3.8%
680 5
 
3.8%
170 5
 
3.8%
100 5
 
3.8%
200 5
 
3.8%
Other values (12) 60
46.2%
ValueCountFrequency (%)
1 5
3.8%
100 5
3.8%
170 5
3.8%
200 5
3.8%
250 10
7.7%
300 5
3.8%
320 5
3.8%
360 5
3.8%
400 10
7.7%
440 5
3.8%
ValueCountFrequency (%)
1200 5
3.8%
1000 5
3.8%
900 5
3.8%
870 5
3.8%
680 5
3.8%
600 5
3.8%
560 5
3.8%
540 5
3.8%
500 10
7.7%
464 5
3.8%

시료량단위
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
g
80 
ml
45 
kg
 
5

Length

Max length2
Median length1
Mean length1.3846154
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowml
2nd rowml
3rd rowml
4th rowml
5th rowml

Common Values

ValueCountFrequency (%)
g 80
61.5%
ml 45
34.6%
kg 5
 
3.8%

Length

2023-12-12T14:06:38.157385image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:06:38.271870image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
g 80
61.5%
ml 45
34.6%
kg 5
 
3.8%

모니터링 일시
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)11.5%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2021-10-22
15 
2021-02-04
10 
2021-03-29
10 
2021-06-10
10 
2021-07-14
10 
Other values (10)
75 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-02-04
2nd row2021-02-04
3rd row2021-02-04
4th row2021-02-04
5th row2021-02-04

Common Values

ValueCountFrequency (%)
2021-10-22 15
11.5%
2021-02-04 10
 
7.7%
2021-03-29 10
 
7.7%
2021-06-10 10
 
7.7%
2021-07-14 10
 
7.7%
2021-07-30 10
 
7.7%
2021-09-29 10
 
7.7%
2021-03-18 10
 
7.7%
2021-04-20 10
 
7.7%
2022-03-29 10
 
7.7%
Other values (5) 25
19.2%

Length

2023-12-12T14:06:38.383794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2021-10-22 15
11.5%
2021-02-04 10
 
7.7%
2021-03-29 10
 
7.7%
2021-06-10 10
 
7.7%
2021-07-14 10
 
7.7%
2021-07-30 10
 
7.7%
2021-09-29 10
 
7.7%
2021-03-18 10
 
7.7%
2021-04-20 10
 
7.7%
2022-03-29 10
 
7.7%
Other values (5) 25
19.2%

유통기한
Categorical

HIGH CORRELATION 

Distinct25
Distinct (%)19.2%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2021-06-18
 
10
2021-10-29
 
5
2021-04-07
 
5
2021-04-08
 
5
2021-07-20
 
5
Other values (20)
100 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-02-11
2nd row2021-02-11
3rd row2021-02-11
4th row2021-02-11
5th row2021-02-11

Common Values

ValueCountFrequency (%)
2021-06-18 10
 
7.7%
2021-10-29 5
 
3.8%
2021-04-07 5
 
3.8%
2021-04-08 5
 
3.8%
2021-07-20 5
 
3.8%
2021-12-29 5
 
3.8%
2022-01-01 5
 
3.8%
2021-12-14 5
 
3.8%
2022-02-18 5
 
3.8%
2021-02-23 5
 
3.8%
Other values (15) 75
57.7%

Length

2023-12-12T14:06:38.536734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2021-06-18 10
 
7.7%
2021-02-11 5
 
3.8%
2022-03-06 5
 
3.8%
2023-06-15 5
 
3.8%
2022-07-04 5
 
3.8%
2022-09-09 5
 
3.8%
2022-06-04 5
 
3.8%
2021-09-25 5
 
3.8%
2021-07-02 5
 
3.8%
2021-04-26 5
 
3.8%
Other values (15) 75
57.7%

제조원
Categorical

HIGH CORRELATION 

Distinct22
Distinct (%)16.9%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
동원F&B 수원공장
10 
롯데푸드주식회사천안공장
10 
서울우유거창공장
10 
㈜동언F&B강진공장
10 
동원F&B 강진공장
 
5
Other values (17)
85 

Length

Max length44
Median length12.5
Mean length10.576923
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row동원F&B 수원공장
2nd row동원F&B 수원공장
3rd row동원F&B 수원공장
4th row동원F&B 수원공장
5th row동원F&B 수원공장

Common Values

ValueCountFrequency (%)
동원F&B 수원공장 10
 
7.7%
롯데푸드주식회사천안공장 10
 
7.7%
서울우유거창공장 10
 
7.7%
㈜동언F&B강진공장 10
 
7.7%
동원F&B 강진공장 5
 
3.8%
㈜남양유업 나주공장 5
 
3.8%
㈜푸드밀 F1 5
 
3.8%
롯데푸드㈜ 5
 
3.8%
매일유업㈜평택공장 5
 
3.8%
학교법인건국대학교건국유업 5
 
3.8%
Other values (12) 60
46.2%

Length

2023-12-12T14:06:38.731729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
동원f&b 15
 
7.5%
롯데푸드주식회사천안공장 10
 
5.0%
서울우유거창공장 10
 
5.0%
㈜동언f&b강진공장 10
 
5.0%
강진공장 10
 
5.0%
수원공장 10
 
5.0%
서울우유협동조합 10
 
5.0%
limited 5
 
2.5%
co-operative 5
 
2.5%
dairy 5
 
2.5%
Other values (22) 110
55.0%

살균(또는멸균) 유무
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
살균
85 
미표시
25 
살균
15 
멸균
 
5

Length

Max length3
Median length2
Mean length2.3076923
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row살균
2nd row살균
3rd row살균
4th row살균
5th row살균

Common Values

ValueCountFrequency (%)
살균 85
65.4%
미표시 25
 
19.2%
살균 15
 
11.5%
멸균 5
 
3.8%

Length

2023-12-12T14:06:38.905750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:06:39.041998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
살균 100
76.9%
미표시 25
 
19.2%
멸균 5
 
3.8%

보존온도
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
냉장
120 
실온
 
10

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 (%)
냉장 120
92.3%
실온 10
 
7.7%

Length

2023-12-12T14:06:39.255699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:06:39.380200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
냉장 120
92.3%
실온 10
 
7.7%

수거장소
Categorical

HIGH CORRELATION 

Distinct14
Distinct (%)10.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
㈜이마트제주점
25 
제스코마트 본관
20 
이마트제주점
10 
하나로마트제주점
10 
나우리마트
10 
Other values (9)
55 

Length

Max length13
Median length10
Mean length7.6923077
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제스코마트 본관
2nd row제스코마트 본관
3rd row제스코마트 본관
4th row제스코마트 본관
5th row제스코마트 본관

Common Values

ValueCountFrequency (%)
㈜이마트제주점 25
19.2%
제스코마트 본관 20
15.4%
이마트제주점 10
 
7.7%
하나로마트제주점 10
 
7.7%
나우리마트 10
 
7.7%
홈플러스㈜서귀포점 10
 
7.7%
㈜이마트서귀포점 10
 
7.7%
대정월마트 5
 
3.8%
플러스마트2호점 5
 
3.8%
스타월드식자재마트서귀포점 5
 
3.8%
Other values (4) 20
15.4%

Length

2023-12-12T14:06:39.544061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
㈜이마트제주점 25
16.7%
제스코마트 20
13.3%
본관 20
13.3%
이마트제주점 10
 
6.7%
하나로마트제주점 10
 
6.7%
나우리마트 10
 
6.7%
홈플러스㈜서귀포점 10
 
6.7%
㈜이마트서귀포점 10
 
6.7%
대정월마트 5
 
3.3%
플러스마트2호점 5
 
3.3%
Other values (5) 25
16.7%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023-06-30
130 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-06-30
2nd row2023-06-30
3rd row2023-06-30
4th row2023-06-30
5th row2023-06-30

Common Values

ValueCountFrequency (%)
2023-06-30 130
100.0%

Length

2023-12-12T14:06:39.715094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:06:39.824700image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-06-30 130
100.0%

Interactions

2023-12-12T14:06:33.961688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:06:33.404879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:06:33.687336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:06:34.055565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:06:33.493494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:06:33.780637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:06:34.143938image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:06:33.585277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:06:33.867946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T14:06:39.908778image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지역제품명식품 중분류식품 소분류성상세균수 검사결과 (정량)대장균군 검사결과 (정량)시료량시료량단위모니터링 일시유통기한제조원살균(또는멸균) 유무보존온도수거장소
지역1.0000.9720.7630.8520.5260.2190.0860.6210.1381.0001.0001.0000.8870.0001.000
제품명0.9721.0001.0001.0001.0000.8481.0000.9961.0000.9980.9990.9990.9931.0000.998
식품 중분류0.7631.0001.0000.9930.9900.5850.3420.8500.9650.9751.0000.9960.7990.9660.951
식품 소분류0.8521.0000.9931.0000.9850.6160.8010.9131.0000.9500.9960.9960.8381.0000.978
성상0.5261.0000.9900.9851.0000.1840.1280.7500.9130.9741.0000.9900.4880.6340.850
세균수 검사결과 (정량)0.2190.8480.5850.6160.1841.0001.0000.2210.0510.5920.9010.7420.2010.0000.455
대장균군 검사결과 (정량)0.0861.0000.3420.8010.1281.0001.0000.3370.0600.6951.0001.0000.0000.0000.466
시료량0.6210.9960.8500.9130.7500.2210.3371.0000.8550.9420.9970.9900.7331.0000.947
시료량단위0.1381.0000.9651.0000.9130.0510.0600.8551.0000.9111.0001.0000.3110.4490.769
모니터링 일시1.0000.9980.9750.9500.9740.5920.6950.9420.9111.0001.0000.9980.9780.5870.994
유통기한1.0000.9991.0000.9961.0000.9011.0000.9971.0001.0001.0000.9981.0001.0001.000
제조원1.0000.9990.9960.9960.9900.7421.0000.9901.0000.9980.9981.0001.0001.0000.998
살균(또는멸균) 유무0.8870.9930.7990.8380.4880.2010.0000.7330.3110.9781.0001.0001.0000.2790.986
보존온도0.0001.0000.9661.0000.6340.0000.0001.0000.4490.5871.0001.0000.2791.0000.591
수거장소1.0000.9980.9510.9780.8500.4550.4660.9470.7690.9941.0000.9980.9860.5911.000
2023-12-12T14:06:40.138399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
살균(또는멸균) 유무지역성상식품 소분류유통기한모니터링 일시제조원보존온도수거장소시료량단위제품명식품 중분류
살균(또는멸균) 유무1.0000.6900.4150.6260.9130.9060.9260.1840.9110.2980.8700.607
지역0.6901.0000.6300.6660.9060.9480.9190.0000.9520.2270.8390.581
성상0.4150.6301.0000.9270.9170.7520.9010.7530.6290.9560.8990.839
식품 소분류0.6260.6660.9271.0000.9210.7330.9300.9520.7010.9560.9330.950
유통기한0.9130.9060.9170.9211.0000.9560.9570.9060.9510.9090.9540.935
모니터링 일시0.9060.9480.7520.7330.9561.0000.9480.5110.9520.6480.9160.813
제조원0.9260.9190.9010.9300.9570.9481.0000.9190.9480.9220.9520.925
보존온도0.1840.0000.7530.9520.9060.5110.9191.0000.4430.6930.8880.815
수거장소0.9110.9520.6290.7010.9510.9520.9480.4431.0000.5790.9100.786
시료량단위0.2980.2270.9560.9560.9090.6480.9220.6930.5791.0000.8920.941
제품명0.8700.8390.8990.9330.9540.9160.9520.8880.9100.8921.0000.917
식품 중분류0.6070.5810.8390.9500.9350.8130.9250.8150.7860.9410.9171.000
2023-12-12T14:06:40.317611image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
세균수 검사결과 (정량)대장균군 검사결과 (정량)시료량지역제품명식품 중분류식품 소분류성상시료량단위모니터링 일시유통기한제조원살균(또는멸균) 유무보존온도수거장소
세균수 검사결과 (정량)1.0000.621-0.4080.2640.5660.2720.3610.0670.0320.3410.5740.4620.1630.0000.261
대장균군 검사결과 (정량)0.6211.000-0.2600.0550.8880.2530.6180.1540.0980.6120.9060.9190.0000.0000.347
시료량-0.408-0.2601.0000.6090.8900.6020.6920.5490.5580.7460.9190.8950.5610.9720.786
지역0.2640.0550.6091.0000.8390.5810.6660.6300.2270.9480.9060.9190.6900.0000.952
제품명0.5660.8880.8900.8391.0000.9170.9330.8990.8920.9160.9540.9520.8700.8880.910
식품 중분류0.2720.2530.6020.5810.9171.0000.9500.8390.9410.8130.9350.9250.6070.8150.786
식품 소분류0.3610.6180.6920.6660.9330.9501.0000.9270.9560.7330.9210.9300.6260.9520.701
성상0.0670.1540.5490.6300.8990.8390.9271.0000.9560.7520.9170.9010.4150.7530.629
시료량단위0.0320.0980.5580.2270.8920.9410.9560.9561.0000.6480.9090.9220.2980.6930.579
모니터링 일시0.3410.6120.7460.9480.9160.8130.7330.7520.6481.0000.9560.9480.9060.5110.952
유통기한0.5740.9060.9190.9060.9540.9350.9210.9170.9090.9561.0000.9570.9130.9060.951
제조원0.4620.9190.8950.9190.9520.9250.9300.9010.9220.9480.9571.0000.9260.9190.948
살균(또는멸균) 유무0.1630.0000.5610.6900.8700.6070.6260.4150.2980.9060.9130.9261.0000.1840.911
보존온도0.0000.0000.9720.0000.8880.8150.9520.7530.6930.5110.9060.9190.1841.0000.443
수거장소0.2610.3470.7860.9520.9100.7860.7010.6290.5790.9520.9510.9480.9110.4431.000

Missing values

2023-12-12T14:06:34.312682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T14:06:34.576608image/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

지역시료번호제품명식품 중분류식품 소분류성상세균수 검사결과 (정량)대장균군 검사결과 (정량)대장균 검사결과 (정량)캠피로박터 제주니 콜리 검사결과 (정성)시료량시료량단위모니터링 일시유통기한제조원살균(또는멸균) 유무보존온도수거장소데이터기준일자
0제주시유통'21-22(1)건강한 딸기 딸기우유가공유류가공유액체000음성500ml2021-02-042021-02-11동원F&B 수원공장살균냉장제스코마트 본관2023-06-30
1제주시유통'21-22(2)건강한 딸기 딸기우유가공유류가공유액체000음성500ml2021-02-042021-02-11동원F&B 수원공장살균냉장제스코마트 본관2023-06-30
2제주시유통'21-22(3)건강한 딸기 딸기우유가공유류가공유액체000음성500ml2021-02-042021-02-11동원F&B 수원공장살균냉장제스코마트 본관2023-06-30
3제주시유통'21-22(4)건강한 딸기 딸기우유가공유류가공유액체000음성500ml2021-02-042021-02-11동원F&B 수원공장살균냉장제스코마트 본관2023-06-30
4제주시유통'21-22(5)건강한 딸기 딸기우유가공유류가공유액체000음성500ml2021-02-042021-02-11동원F&B 수원공장살균냉장제스코마트 본관2023-06-30
5제주시유통'21-23(1)구워먹는 치즈 오리지널치즈류자연치즈고체38008100음성300g2021-02-042021-04-20동원F&B 강진공장살균냉장제스코마트 본관2023-06-30
6제주시유통'21-23(2)구워먹는 치즈 오리지널치즈류자연치즈고체44008100음성300g2021-02-042021-04-20동원F&B 강진공장살균냉장제스코마트 본관2023-06-30
7제주시유통'21-23(3)구워먹는 치즈 오리지널치즈류자연치즈고체38008400음성300g2021-02-042021-04-20동원F&B 강진공장살균냉장제스코마트 본관2023-06-30
8제주시유통'21-23(4)구워먹는 치즈 오리지널치즈류자연치즈고체42008600음성300g2021-02-042021-04-20동원F&B 강진공장살균냉장제스코마트 본관2023-06-30
9제주시유통'21-23(5)구워먹는 치즈 오리지널치즈류자연치즈고체58008500음성300g2021-02-042021-04-20동원F&B 강진공장살균냉장제스코마트 본관2023-06-30
지역시료번호제품명식품 중분류식품 소분류성상세균수 검사결과 (정량)대장균군 검사결과 (정량)대장균 검사결과 (정량)캠피로박터 제주니 콜리 검사결과 (정성)시료량시료량단위모니터링 일시유통기한제조원살균(또는멸균) 유무보존온도수거장소데이터기준일자
120제주시23미생물-1(1)의정부식 부대찌개즉석편의식품류간편조리세트고체000음성680g2023-06-132023-06-15㈜신세게푸드 이천 2공장미표시냉장㈜이마트신제주점2023-06-30
121제주시23미생물-1(2)의정부식 부대찌개즉석편의식품류간편조리세트고체000음성680g2023-06-132023-06-15㈜신세게푸드 이천 2공장미표시냉장㈜이마트신제주점2023-06-30
122제주시23미생물-1(3)의정부식 부대찌개즉석편의식품류간편조리세트고체000음성680g2023-06-132023-06-15㈜신세게푸드 이천 2공장미표시냉장㈜이마트신제주점2023-06-30
123제주시23미생물-1(4)의정부식 부대찌개즉석편의식품류간편조리세트고체000음성680g2023-06-132023-06-15㈜신세게푸드 이천 2공장미표시냉장㈜이마트신제주점2023-06-30
124제주시23미생물-1(5)의정부식 부대찌개즉석편의식품류간편조리세트고체000음성680g2023-06-132023-06-15㈜신세게푸드 이천 2공장미표시냉장㈜이마트신제주점2023-06-30
125제주시제주-06-1-1오뎅식당 부대찌개 밀키트즉석편의식품류간편조리세트고체000음성870g2023-06-142023-06-17㈜프레시지미표시냉장이마트㈜서귀포점2023-06-30
126제주시제주-06-1-2오뎅식당 부대찌개 밀키트즉석편의식품류간편조리세트고체000음성870g2023-06-142023-06-17㈜프레시지미표시냉장이마트㈜서귀포점2023-06-30
127제주시제주-06-1-3오뎅식당 부대찌개 밀키트즉석편의식품류간편조리세트고체000음성870g2023-06-142023-06-17㈜프레시지미표시냉장이마트㈜서귀포점2023-06-30
128제주시제주-06-1-4오뎅식당 부대찌개 밀키트즉석편의식품류간편조리세트고체000음성870g2023-06-142023-06-17㈜프레시지미표시냉장이마트㈜서귀포점2023-06-30
129제주시제주-06-1-5오뎅식당 부대찌개 밀키트즉석편의식품류간편조리세트고체000음성870g2023-06-142023-06-17㈜프레시지미표시냉장이마트㈜서귀포점2023-06-30