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

Alerts

MT has constant value ""Constant
유아용 식품 has constant value ""Constant
전체 has constant value ""Constant
전체.1 has constant value ""Constant
2 has constant value ""Constant
남양유업 아기꼬야 has constant value ""Constant
157 is highly overall correlated with 17 and 1 other fieldsHigh correlation
17 is highly overall correlated with 157 and 1 other fieldsHigh correlation
201809 is highly overall correlated with 157 and 2 other fieldsHigh correlation
20 is highly overall correlated with 201809High correlation
전라북도 is highly overall correlated with 전체.2High correlation
전체.2 is highly overall correlated with 전라북도High correlation

Reproduction

Analysis started2023-12-10 06:17:23.229646
Analysis finished2023-12-10 06:17:24.898407
Duration1.67 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:17:25.023831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:17:25.163413image/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
201809
56 
201803
43 

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 (%)
201809 56
56.6%
201803 43
43.4%

Length

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

Common Values (Plot)

2023-12-10T15:17:25.486787image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
201809 56
56.6%
201803 43
43.4%

157
Real number (ℝ)

HIGH CORRELATION 

Distinct86
Distinct (%)86.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean122.30303
Minimum20
Maximum370
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:17:25.713198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20
5-th percentile32.9
Q168.5
median105
Q3166.5
95-th percentile258
Maximum370
Range350
Interquartile range (IQR)98

Descriptive statistics

Standard deviation71.421493
Coefficient of variation (CV)0.58397157
Kurtosis1.3404576
Mean122.30303
Median Absolute Deviation (MAD)46
Skewness1.0949578
Sum12108
Variance5101.0297
MonotonicityNot monotonic
2023-12-10T15:17:26.011613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
102 3
 
3.0%
151 2
 
2.0%
67 2
 
2.0%
33 2
 
2.0%
59 2
 
2.0%
101 2
 
2.0%
90 2
 
2.0%
128 2
 
2.0%
122 2
 
2.0%
66 2
 
2.0%
Other values (76) 78
78.8%
ValueCountFrequency (%)
20 1
1.0%
28 1
1.0%
30 1
1.0%
31 1
1.0%
32 1
1.0%
33 2
2.0%
36 1
1.0%
37 1
1.0%
38 1
1.0%
47 1
1.0%
ValueCountFrequency (%)
370 1
1.0%
347 1
1.0%
299 1
1.0%
280 1
1.0%
276 1
1.0%
256 1
1.0%
238 1
1.0%
235 1
1.0%
232 1
1.0%
216 1
1.0%

17
Real number (ℝ)

HIGH CORRELATION 

Distinct31
Distinct (%)31.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13.686869
Minimum1
Maximum50
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:17:26.237519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4
Q18.5
median11
Q317.5
95-th percentile31.3
Maximum50
Range49
Interquartile range (IQR)9

Descriptive statistics

Standard deviation8.7325879
Coefficient of variation (CV)0.63802672
Kurtosis3.2966312
Mean13.686869
Median Absolute Deviation (MAD)4
Skewness1.6304954
Sum1355
Variance76.258091
MonotonicityNot monotonic
2023-12-10T15:17:26.472542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)
ValueCountFrequency (%)
9 11
 
11.1%
10 10
 
10.1%
18 6
 
6.1%
14 6
 
6.1%
5 5
 
5.1%
8 5
 
5.1%
13 5
 
5.1%
11 5
 
5.1%
7 4
 
4.0%
12 4
 
4.0%
Other values (21) 38
38.4%
ValueCountFrequency (%)
1 1
 
1.0%
3 3
 
3.0%
4 3
 
3.0%
5 5
5.1%
6 4
 
4.0%
7 4
 
4.0%
8 5
5.1%
9 11
11.1%
10 10
10.1%
11 5
5.1%
ValueCountFrequency (%)
50 1
1.0%
39 1
1.0%
38 1
1.0%
37 1
1.0%
34 1
1.0%
31 1
1.0%
30 1
1.0%
29 1
1.0%
27 1
1.0%
25 1
1.0%

유아용 식품
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
유아용 식품
99 

Length

Max length6
Median length6
Mean length6
Min length6

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

Common Values (Plot)

2023-12-10T15:17:26.836557image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유아용 99
50.0%
식품 99
50.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:17:27.024232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Common Values (Plot)

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

2
Categorical

CONSTANT 

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

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 99
100.0%

Length

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

Common Values (Plot)

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

20
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
30
47 
20
37 
40
15 

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 47
47.5%
20 37
37.4%
40 15
 
15.2%

Length

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

Common Values (Plot)

2023-12-10T15:17:28.137525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
30 47
47.5%
20 37
37.4%
40 15
 
15.2%

전라북도
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)11.1%
Missing0
Missing (%)0.0%
Memory size924.0 B
서울특별시
20 
부산광역시
16 
경기도
16 
전라북도
11 
경상남도
9 
Other values (6)
27 

Length

Max length5
Median length5
Mean length4.3535354
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전라북도
2nd row전라북도
3rd row전라북도
4th row전라남도
5th row전라남도

Common Values

ValueCountFrequency (%)
서울특별시 20
20.2%
부산광역시 16
16.2%
경기도 16
16.2%
전라북도 11
11.1%
경상남도 9
9.1%
인천광역시 8
 
8.1%
전라남도 6
 
6.1%
대구광역시 4
 
4.0%
충청북도 4
 
4.0%
대전광역시 3
 
3.0%

Length

2023-12-10T15:17:28.323836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
서울특별시 20
20.2%
부산광역시 16
16.2%
경기도 16
16.2%
전라북도 11
11.1%
경상남도 9
9.1%
인천광역시 8
 
8.1%
전라남도 6
 
6.1%
대구광역시 4
 
4.0%
충청북도 4
 
4.0%
대전광역시 3
 
3.0%

전체.2
Categorical

HIGH CORRELATION 

Distinct26
Distinct (%)26.3%
Missing0
Missing (%)0.0%
Memory size924.0 B
전체
21 
중구
11 
송파구
 
4
노원구
 
4
연수구
 
4
Other values (21)
55 

Length

Max length4
Median length3
Mean length2.7272727
Min length2

Unique

Unique1 ?
Unique (%)1.0%

Sample

1st row익산시
2nd row정읍시
3rd row남원시
4th row전체
5th row목포시

Common Values

ValueCountFrequency (%)
전체 21
21.2%
중구 11
 
11.1%
송파구 4
 
4.0%
노원구 4
 
4.0%
연수구 4
 
4.0%
사상구 4
 
4.0%
동래구 4
 
4.0%
강서구 4
 
4.0%
거제시 3
 
3.0%
남원시 3
 
3.0%
Other values (16) 37
37.4%

Length

2023-12-10T15:17:28.576892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
전체 21
21.2%
중구 11
 
11.1%
송파구 4
 
4.0%
노원구 4
 
4.0%
연수구 4
 
4.0%
사상구 4
 
4.0%
동래구 4
 
4.0%
강서구 4
 
4.0%
양산시 3
 
3.0%
의정부시 3
 
3.0%
Other values (16) 37
37.4%

남양유업 아기꼬야
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:17:28.809339image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:17:28.976662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
남양유업 99
50.0%
아기꼬야 99
50.0%

Interactions

2023-12-10T15:17:24.122818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:17:23.815583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:17:24.269332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:17:23.988601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:17:29.452512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2018091571720전라북도전체.2
2018091.0000.6170.6030.3330.0000.000
1570.6171.0000.8650.5280.2340.394
170.6030.8651.0000.5380.4160.000
200.3330.5280.5381.0000.0000.000
전라북도0.0000.2340.4160.0001.0000.954
전체.20.0000.3940.0000.0000.9541.000
2023-12-10T15:17:29.647309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
20전라북도전체.2201809
201.0000.0000.0000.532
전라북도0.0001.0000.6860.000
전체.20.0000.6861.0000.000
2018090.5320.0000.0001.000
2023-12-10T15:17:29.860156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
1571720180920전라북도전체.2
1571.0000.8180.6160.2310.1220.154
170.8181.0000.5850.2700.1980.000
2018090.6160.5851.0000.5320.0000.000
200.2310.2700.5321.0000.0000.000
전라북도0.1220.1980.0000.0001.0000.686
전체.20.1540.0000.0000.0000.6861.000

Missing values

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

MT20180915717유아용 식품전체전체.1220전라북도전체.2남양유업 아기꼬야
0MT20180921622유아용 식품전체전체220전라북도익산시남양유업 아기꼬야
1MT2018098511유아용 식품전체전체220전라북도정읍시남양유업 아기꼬야
2MT2018091167유아용 식품전체전체220전라북도남원시남양유업 아기꼬야
3MT20180913410유아용 식품전체전체220전라남도전체남양유업 아기꼬야
4MT20180918918유아용 식품전체전체220전라남도목포시남양유업 아기꼬야
5MT201809665유아용 식품전체전체220경상북도칠곡군남양유업 아기꼬야
6MT20180934738유아용 식품전체전체220경상남도김해시남양유업 아기꼬야
7MT20180925629유아용 식품전체전체220경상남도거제시남양유업 아기꼬야
8MT2018091518유아용 식품전체전체220경상남도양산시남양유업 아기꼬야
9MT20180910916유아용 식품전체전체230서울특별시중구남양유업 아기꼬야
MT20180915717유아용 식품전체전체.1220전라북도전체.2남양유업 아기꼬야
89MT2018031009유아용 식품전체전체230서울특별시송파구남양유업 아기꼬야
90MT201803909유아용 식품전체전체230부산광역시전체남양유업 아기꼬야
91MT2018038310유아용 식품전체전체230부산광역시중구남양유업 아기꼬야
92MT2018031059유아용 식품전체전체230부산광역시동래구남양유업 아기꼬야
93MT201803768유아용 식품전체전체230부산광역시사상구남양유업 아기꼬야
94MT201803638유아용 식품전체전체230대구광역시전체남양유업 아기꼬야
95MT2018039010유아용 식품전체전체230인천광역시전체남양유업 아기꼬야
96MT201803709유아용 식품전체전체230인천광역시연수구남양유업 아기꼬야
97MT2018035519유아용 식품전체전체230대전광역시중구남양유업 아기꼬야
98MT201803859유아용 식품전체전체230경기도전체남양유업 아기꼬야