Overview

Dataset statistics

Number of variables12
Number of observations99
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.9 KiB
Average record size in memory102.3 B

Variable types

Categorical10
Numeric2

Dataset

DescriptionSample
Author(주)제로투원파트너스
URLhttps://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=ZTO010BSICGISOYMILK

Alerts

MT has constant value ""Constant
두유 has constant value ""Constant
전체 has constant value ""Constant
전체.1 has constant value ""Constant
롯데푸드 파스퇴르 has constant value ""Constant
201803 is highly overall correlated with 2 and 1 other fieldsHigh correlation
20 is highly overall correlated with 201803 and 1 other fieldsHigh correlation
2 is highly overall correlated with 201803 and 1 other fieldsHigh correlation
전체.2 is highly overall correlated with 전체.3High correlation
전체.3 is highly overall correlated with 전체.2High correlation
10 has 4 (4.0%) zerosZeros

Reproduction

Analysis started2023-12-10 06:41:24.995553
Analysis finished2023-12-10 06:41:26.550152
Duration1.55 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

MT
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
MT
99 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
MT 99
100.0%

Length

2023-12-10T15:41:26.678379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:41:26.907140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
mt 99
100.0%

201803
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
201803
59 
201802
40 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
201803 59
59.6%
201802 40
40.4%

Length

2023-12-10T15:41:27.082155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:41:27.238020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
201803 59
59.6%
201802 40
40.4%

207
Real number (ℝ)

Distinct86
Distinct (%)86.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean130.59596
Minimum9
Maximum502
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:41:27.437520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum9
5-th percentile24.8
Q166.5
median122
Q3180.5
95-th percentile264.6
Maximum502
Range493
Interquartile range (IQR)114

Descriptive statistics

Standard deviation80.375384
Coefficient of variation (CV)0.61545077
Kurtosis3.3329633
Mean130.59596
Median Absolute Deviation (MAD)57
Skewness1.2108321
Sum12929
Variance6460.2024
MonotonicityNot monotonic
2023-12-10T15:41:27.712783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
144 3
 
3.0%
113 2
 
2.0%
169 2
 
2.0%
177 2
 
2.0%
81 2
 
2.0%
49 2
 
2.0%
134 2
 
2.0%
188 2
 
2.0%
52 2
 
2.0%
245 2
 
2.0%
Other values (76) 78
78.8%
ValueCountFrequency (%)
9 1
1.0%
18 1
1.0%
19 1
1.0%
21 1
1.0%
23 1
1.0%
25 1
1.0%
29 1
1.0%
34 1
1.0%
36 1
1.0%
40 1
1.0%
ValueCountFrequency (%)
502 1
1.0%
294 1
1.0%
292 1
1.0%
276 1
1.0%
270 1
1.0%
264 1
1.0%
256 1
1.0%
245 2
2.0%
244 1
1.0%
239 1
1.0%

10
Real number (ℝ)

ZEROS 

Distinct41
Distinct (%)41.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17.454545
Minimum0
Maximum100
Zeros4
Zeros (%)4.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:41:27.994899image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q16
median13
Q325.5
95-th percentile48.2
Maximum100
Range100
Interquartile range (IQR)19.5

Descriptive statistics

Standard deviation16.94425
Coefficient of variation (CV)0.97076432
Kurtosis4.8743129
Mean17.454545
Median Absolute Deviation (MAD)9
Skewness1.8119184
Sum1728
Variance287.10761
MonotonicityNot monotonic
2023-12-10T15:41:28.223823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=41)
ValueCountFrequency (%)
7 7
 
7.1%
13 7
 
7.1%
6 7
 
7.1%
3 6
 
6.1%
4 5
 
5.1%
8 4
 
4.0%
0 4
 
4.0%
36 3
 
3.0%
17 3
 
3.0%
1 3
 
3.0%
Other values (31) 50
50.5%
ValueCountFrequency (%)
0 4
4.0%
1 3
3.0%
2 3
3.0%
3 6
6.1%
4 5
5.1%
5 3
3.0%
6 7
7.1%
7 7
7.1%
8 4
4.0%
9 2
 
2.0%
ValueCountFrequency (%)
100 1
 
1.0%
59 1
 
1.0%
56 1
 
1.0%
55 1
 
1.0%
50 1
 
1.0%
48 1
 
1.0%
45 3
3.0%
43 1
 
1.0%
42 1
 
1.0%
41 1
 
1.0%

두유
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
두유
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 (%)
두유 99
100.0%

Length

2023-12-10T15:41:28.454410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:41:28.606348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
두유 99
100.0%

전체
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
전체
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 (%)
전체 99
100.0%

Length

2023-12-10T15:41:28.774737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:41:28.926165image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전체 99
100.0%

전체.1
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
전체
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 (%)
전체 99
100.0%

Length

2023-12-10T15:41:29.102055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:41:29.249202image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전체 99
100.0%

2
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
2
59 
1
40 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2 59
59.6%
1 40
40.4%

Length

2023-12-10T15:41:29.417263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:41:29.552455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 59
59.6%
1 40
40.4%

20
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
50
36 
30
34 
20
25 
60
4 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
50 36
36.4%
30 34
34.3%
20 25
25.3%
60 4
 
4.0%

Length

2023-12-10T15:41:29.706695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:41:29.867985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
50 36
36.4%
30 34
34.3%
20 25
25.3%
60 4
 
4.0%

전체.2
Categorical

HIGH CORRELATION 

Distinct14
Distinct (%)14.1%
Missing0
Missing (%)0.0%
Memory size924.0 B
경기도
19 
서울특별시
15 
대구광역시
9 
광주광역시
9 
강원도
8 
Other values (9)
39 

Length

Max length7
Median length5
Mean length4.2121212
Min length2

Unique

Unique1 ?
Unique (%)1.0%

Sample

1st row서울특별시
2nd row서울특별시
3rd row서울특별시
4th row서울특별시
5th row대구광역시

Common Values

ValueCountFrequency (%)
경기도 19
19.2%
서울특별시 15
15.2%
대구광역시 9
9.1%
광주광역시 9
9.1%
강원도 8
8.1%
경상북도 7
 
7.1%
인천광역시 6
 
6.1%
충청남도 6
 
6.1%
울산광역시 5
 
5.1%
전라북도 4
 
4.0%
Other values (4) 11
11.1%

Length

2023-12-10T15:41:30.048753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경기도 19
19.2%
서울특별시 15
15.2%
대구광역시 9
9.1%
광주광역시 9
9.1%
강원도 8
8.1%
경상북도 7
 
7.1%
인천광역시 6
 
6.1%
충청남도 6
 
6.1%
울산광역시 5
 
5.1%
전라북도 4
 
4.0%
Other values (4) 11
11.1%

전체.3
Categorical

HIGH CORRELATION 

Distinct35
Distinct (%)35.4%
Missing0
Missing (%)0.0%
Memory size924.0 B
전체
10 
북구
7 
서구
 
6
도봉구
 
4
전주시
 
3
Other values (30)
69 

Length

Max length3
Median length3
Mean length2.7373737
Min length2

Unique

Unique3 ?
Unique (%)3.0%

Sample

1st row도봉구
2nd row양천구
3rd row서초구
4th row강남구
5th row중구

Common Values

ValueCountFrequency (%)
전체 10
 
10.1%
북구 7
 
7.1%
서구 6
 
6.1%
도봉구 4
 
4.0%
전주시 3
 
3.0%
서초구 3
 
3.0%
강남구 3
 
3.0%
중구 3
 
3.0%
수성구 3
 
3.0%
광산구 3
 
3.0%
Other values (25) 54
54.5%

Length

2023-12-10T15:41:30.247762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
전체 10
 
10.1%
북구 7
 
7.1%
서구 6
 
6.1%
도봉구 4
 
4.0%
남동구 3
 
3.0%
양천구 3
 
3.0%
보령시 3
 
3.0%
천안시 3
 
3.0%
포천시 3
 
3.0%
광명시 3
 
3.0%
Other values (25) 54
54.5%

롯데푸드 파스퇴르
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
롯데푸드 파스퇴르
99 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row롯데푸드 파스퇴르
2nd row롯데푸드 파스퇴르
3rd row롯데푸드 파스퇴르
4th row롯데푸드 파스퇴르
5th row롯데푸드 파스퇴르

Common Values

ValueCountFrequency (%)
롯데푸드 파스퇴르 99
100.0%

Length

2023-12-10T15:41:30.447932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:41:30.581273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
롯데푸드 99
50.0%
파스퇴르 99
50.0%

Interactions

2023-12-10T15:41:25.797132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:41:25.566133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:41:25.914618image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:41:25.675289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:41:30.670645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
20180320710220전체.2전체.3
2018031.0000.2440.2000.9991.0000.0000.000
2070.2441.0000.6270.2440.2590.3690.000
100.2000.6271.0000.2000.2190.2650.704
20.9990.2440.2001.0001.0000.0000.000
201.0000.2590.2191.0001.0000.0000.000
전체.20.0000.3690.2650.0000.0001.0000.979
전체.30.0000.0000.7040.0000.0000.9791.000
2023-12-10T15:41:30.856948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
20180320전체.22전체.3
2018031.0000.9900.0000.9790.000
200.9901.0000.0000.9900.000
전체.20.0000.0001.0000.0000.692
20.9790.9900.0001.0000.000
전체.30.0000.0000.6920.0001.000
2023-12-10T15:41:31.026121image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
20710201803220전체.2전체.3
2071.0000.2010.2530.2530.1760.1340.000
100.2011.0000.1600.1600.1070.0000.215
2018030.2530.1601.0000.9790.9900.0000.000
20.2530.1600.9791.0000.9900.0000.000
200.1760.1070.9900.9901.0000.0000.000
전체.20.1340.0000.0000.0000.0001.0000.692
전체.30.0000.2150.0000.0000.0000.6921.000

Missing values

2023-12-10T15:41:26.103887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T15:41:26.426491image/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

MT20180320710두유전체전체.1220전체.2전체.3롯데푸드 파스퇴르
0MT20180311726두유전체전체220서울특별시도봉구롯데푸드 파스퇴르
1MT2018039628두유전체전체220서울특별시양천구롯데푸드 파스퇴르
2MT20180323941두유전체전체220서울특별시서초구롯데푸드 파스퇴르
3MT20180326420두유전체전체220서울특별시강남구롯데푸드 파스퇴르
4MT2018032348두유전체전체220대구광역시중구롯데푸드 파스퇴르
5MT20180350259두유전체전체220대구광역시북구롯데푸드 파스퇴르
6MT2018035316두유전체전체220대구광역시수성구롯데푸드 파스퇴르
7MT20180312226두유전체전체220인천광역시남동구롯데푸드 파스퇴르
8MT2018035910두유전체전체220인천광역시서구롯데푸드 파스퇴르
9MT2018031996두유전체전체220광주광역시서구롯데푸드 파스퇴르
MT20180320710두유전체전체.1220전체.2전체.3롯데푸드 파스퇴르
89MT2018021383두유전체전체150경상북도포항시롯데푸드 파스퇴르
90MT201802254두유전체전체150경상북도경주시롯데푸드 파스퇴르
91MT20180215622두유전체전체150경상북도안동시롯데푸드 파스퇴르
92MT201802526두유전체전체150경상북도성주군롯데푸드 파스퇴르
93MT2018021444두유전체전체150경상남도전체롯데푸드 파스퇴르
94MT2018021974두유전체전체150경상남도창원시롯데푸드 파스퇴르
95MT2018021106두유전체전체160전체전체롯데푸드 파스퇴르
96MT201802631두유전체전체160서울특별시도봉구롯데푸드 파스퇴르
97MT20180212421두유전체전체160서울특별시양천구롯데푸드 파스퇴르
98MT2018027356두유전체전체160서울특별시동작구롯데푸드 파스퇴르