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=ZTO010BSICGIMILK

Alerts

MT has constant value ""Constant
흰우유 has constant value ""Constant
전체 has constant value ""Constant
전체.1 has constant value ""Constant
건국대학교건국유업.건국햄(학) 온리프라이스 has constant value ""Constant
2 is highly overall correlated with 201809 and 2 other fieldsHigh correlation
201809 is highly overall correlated with 2 and 2 other fieldsHigh correlation
20 is highly overall correlated with 201809 and 1 other fieldsHigh correlation
서울특별시 is highly overall correlated with 전체.2High correlation
전체.2 is highly overall correlated with 201809 and 2 other fieldsHigh correlation

Reproduction

Analysis started2023-12-10 06:44:00.283164
Analysis finished2023-12-10 06:44:01.918571
Duration1.64 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:44:02.004950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

201809
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
201803
50 
201809
49 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
201803 50
50.5%
201809 49
49.5%

Length

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

Common Values (Plot)

2023-12-10T15:44:02.442791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
201803 50
50.5%
201809 49
49.5%

78
Real number (ℝ)

Distinct45
Distinct (%)45.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean88.969697
Minimum56
Maximum167
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:44:02.614248image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum56
5-th percentile64
Q179
median89
Q397.5
95-th percentile116.3
Maximum167
Range111
Interquartile range (IQR)18.5

Descriptive statistics

Standard deviation16.736526
Coefficient of variation (CV)0.18811491
Kurtosis3.8854047
Mean88.969697
Median Absolute Deviation (MAD)9
Skewness1.0681663
Sum8808
Variance280.11132
MonotonicityNot monotonic
2023-12-10T15:44:02.813210image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=45)
ValueCountFrequency (%)
75 6
 
6.1%
80 6
 
6.1%
97 5
 
5.1%
92 4
 
4.0%
108 4
 
4.0%
99 3
 
3.0%
88 3
 
3.0%
91 3
 
3.0%
95 3
 
3.0%
83 3
 
3.0%
Other values (35) 59
59.6%
ValueCountFrequency (%)
56 1
 
1.0%
57 1
 
1.0%
60 2
 
2.0%
64 2
 
2.0%
66 3
3.0%
69 2
 
2.0%
72 2
 
2.0%
74 1
 
1.0%
75 6
6.1%
76 2
 
2.0%
ValueCountFrequency (%)
167 1
 
1.0%
126 1
 
1.0%
125 1
 
1.0%
119 2
2.0%
116 1
 
1.0%
114 1
 
1.0%
112 1
 
1.0%
108 4
4.0%
105 1
 
1.0%
104 1
 
1.0%

10
Real number (ℝ)

Distinct29
Distinct (%)29.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18.555556
Minimum2
Maximum34
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:44:03.001836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile6.9
Q115
median19
Q323
95-th percentile28.1
Maximum34
Range32
Interquartile range (IQR)8

Descriptive statistics

Standard deviation6.4162139
Coefficient of variation (CV)0.34578398
Kurtosis-0.041229018
Mean18.555556
Median Absolute Deviation (MAD)4
Skewness-0.21369981
Sum1837
Variance41.1678
MonotonicityNot monotonic
2023-12-10T15:44:03.186626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%)
21 11
 
11.1%
19 10
 
10.1%
17 10
 
10.1%
16 10
 
10.1%
25 7
 
7.1%
27 5
 
5.1%
23 4
 
4.0%
13 4
 
4.0%
15 4
 
4.0%
14 3
 
3.0%
Other values (19) 31
31.3%
ValueCountFrequency (%)
2 1
 
1.0%
3 1
 
1.0%
6 3
3.0%
7 1
 
1.0%
8 2
2.0%
9 1
 
1.0%
10 3
3.0%
11 1
 
1.0%
12 2
2.0%
13 4
4.0%
ValueCountFrequency (%)
34 1
 
1.0%
31 1
 
1.0%
30 2
 
2.0%
29 1
 
1.0%
28 2
 
2.0%
27 5
5.1%
26 1
 
1.0%
25 7
7.1%
24 3
3.0%
23 4
4.0%

흰우유
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
흰우유
99 

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 (%)
흰우유 99
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:44:03.544049image/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:44:03.679178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:44:03.821764image/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:44:03.984535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:44:04.131001image/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
1
50 
2
49 

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 (%)
1 50
50.5%
2 49
49.5%

Length

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

Common Values (Plot)

2023-12-10T15:44:04.402461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 50
50.5%
2 49
49.5%

20
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)5.1%
Missing0
Missing (%)0.0%
Memory size924.0 B
30
33 
20
25 
40
18 
50
18 
60
5 

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 (%)
30 33
33.3%
20 25
25.3%
40 18
18.2%
50 18
18.2%
60 5
 
5.1%

Length

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

Common Values (Plot)

2023-12-10T15:44:04.691585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
30 33
33.3%
20 25
25.3%
40 18
18.2%
50 18
18.2%
60 5
 
5.1%

서울특별시
Categorical

HIGH CORRELATION 

Distinct14
Distinct (%)14.1%
Missing0
Missing (%)0.0%
Memory size924.0 B
경기도
25 
서울특별시
19 
충청남도
10 
부산광역시
7 
경상북도
7 
Other values (9)
31 

Length

Max length5
Median length4
Mean length4.1515152
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
경기도 25
25.3%
서울특별시 19
19.2%
충청남도 10
 
10.1%
부산광역시 7
 
7.1%
경상북도 7
 
7.1%
대전광역시 6
 
6.1%
충청북도 5
 
5.1%
인천광역시 4
 
4.0%
전라남도 4
 
4.0%
경상남도 4
 
4.0%
Other values (4) 8
 
8.1%

Length

2023-12-10T15:44:04.870866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경기도 25
25.3%
서울특별시 19
19.2%
충청남도 10
 
10.1%
부산광역시 7
 
7.1%
경상북도 7
 
7.1%
대전광역시 6
 
6.1%
충청북도 5
 
5.1%
인천광역시 4
 
4.0%
전라남도 4
 
4.0%
경상남도 4
 
4.0%
Other values (4) 8
 
8.1%

전체.2
Categorical

HIGH CORRELATION 

Distinct37
Distinct (%)37.4%
Missing0
Missing (%)0.0%
Memory size924.0 B
전체
15 
동구
 
4
통영시
 
3
북구
 
3
은평구
 
3
Other values (32)
71 

Length

Max length4
Median length3
Mean length2.8383838
Min length2

Unique

Unique2 ?
Unique (%)2.0%

Sample

1st row성동구
2nd row광진구
3rd row구로구
4th row사하구
5th row금정구

Common Values

ValueCountFrequency (%)
전체 15
 
15.2%
동구 4
 
4.0%
통영시 3
 
3.0%
북구 3
 
3.0%
은평구 3
 
3.0%
강북구 3
 
3.0%
동대문구 3
 
3.0%
영등포구 3
 
3.0%
이천시 3
 
3.0%
시흥시 3
 
3.0%
Other values (27) 56
56.6%

Length

2023-12-10T15:44:05.095643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
전체 15
 
15.2%
동구 4
 
4.0%
이천시 3
 
3.0%
김천시 3
 
3.0%
성남시 3
 
3.0%
고양시 3
 
3.0%
시흥시 3
 
3.0%
수원시 3
 
3.0%
영등포구 3
 
3.0%
동대문구 3
 
3.0%
Other values (27) 56
56.6%

건국대학교건국유업.건국햄(학) 온리프라이스
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
건국대학교건국유업.건국햄(학) 온리프라이스
99 

Length

Max length23
Median length23
Mean length23
Min length23

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:44:05.280127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:44:05.427763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
건국대학교건국유업.건국햄(학 99
50.0%
온리프라이스 99
50.0%

Interactions

2023-12-10T15:44:01.164379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:44:00.941550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:44:01.291981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:44:01.047171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:44:05.530612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2018097810220서울특별시전체.2
2018091.0000.5300.1600.9990.7160.6230.948
780.5301.0000.3150.5300.2790.3340.537
100.1600.3151.0000.1600.0000.0000.597
20.9990.5300.1601.0000.7160.6230.948
200.7160.2790.0000.7161.0000.0000.000
서울특별시0.6230.3340.0000.6230.0001.0000.965
전체.20.9480.5370.5970.9480.0000.9651.000
2023-12-10T15:44:05.696600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2서울특별시전체.220180920
21.0000.4600.7090.9800.838
서울특별시0.4601.0000.6310.4600.000
전체.20.7090.6311.0000.7090.000
2018090.9800.4600.7091.0000.838
200.8380.0000.0000.8381.000
2023-12-10T15:44:05.849918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
7810201809220서울특별시전체.2
781.0000.3720.3860.3860.1700.1440.188
100.3721.0000.1170.1170.0000.0000.214
2018090.3860.1171.0000.9800.8380.4600.709
20.3860.1170.9801.0000.8380.4600.709
200.1700.0000.8380.8381.0000.0000.000
서울특별시0.1440.0000.4600.4600.0001.0000.631
전체.20.1880.2140.7090.7090.0000.6311.000

Missing values

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

MT2018097810흰우유전체전체.1220서울특별시전체.2건국대학교건국유업.건국햄(학) 온리프라이스
0MT201809666흰우유전체전체220서울특별시성동구건국대학교건국유업.건국햄(학) 온리프라이스
1MT2018096621흰우유전체전체220서울특별시광진구건국대학교건국유업.건국햄(학) 온리프라이스
2MT2018096613흰우유전체전체220서울특별시구로구건국대학교건국유업.건국햄(학) 온리프라이스
3MT2018099419흰우유전체전체220부산광역시사하구건국대학교건국유업.건국햄(학) 온리프라이스
4MT2018098230흰우유전체전체220부산광역시금정구건국대학교건국유업.건국햄(학) 온리프라이스
5MT2018097525흰우유전체전체220인천광역시부평구건국대학교건국유업.건국햄(학) 온리프라이스
6MT2018097512흰우유전체전체220인천광역시계양구건국대학교건국유업.건국햄(학) 온리프라이스
7MT2018097520흰우유전체전체220대전광역시유성구건국대학교건국유업.건국햄(학) 온리프라이스
8MT2018098117흰우유전체전체220울산광역시남구건국대학교건국유업.건국햄(학) 온리프라이스
9MT2018097425흰우유전체전체220경기도동두천시건국대학교건국유업.건국햄(학) 온리프라이스
MT2018097810흰우유전체전체.1220서울특별시전체.2건국대학교건국유업.건국햄(학) 온리프라이스
89MT2018031676흰우유전체전체150경기도이천시건국대학교건국유업.건국햄(학) 온리프라이스
90MT2018039324흰우유전체전체150충청북도전체건국대학교건국유업.건국햄(학) 온리프라이스
91MT2018039112흰우유전체전체150경상북도전체건국대학교건국유업.건국햄(학) 온리프라이스
92MT2018038725흰우유전체전체150경상북도김천시건국대학교건국유업.건국햄(학) 온리프라이스
93MT2018035619흰우유전체전체150경상남도통영시건국대학교건국유업.건국햄(학) 온리프라이스
94MT20180312527흰우유전체전체160서울특별시동대문구건국대학교건국유업.건국햄(학) 온리프라이스
95MT2018038617흰우유전체전체160서울특별시강북구건국대학교건국유업.건국햄(학) 온리프라이스
96MT2018039117흰우유전체전체160서울특별시은평구건국대학교건국유업.건국햄(학) 온리프라이스
97MT2018031008흰우유전체전체160서울특별시영등포구건국대학교건국유업.건국햄(학) 온리프라이스
98MT2018039221흰우유전체전체160부산광역시북구건국대학교건국유업.건국햄(학) 온리프라이스