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

Categorical9
Numeric3

Dataset

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

Alerts

MT has constant value ""Constant
201801 has constant value ""Constant
건강식품 has constant value ""Constant
전체 has constant value ""Constant
전체.1 has constant value ""Constant
농협홍삼 한삼인 has constant value ""Constant
서울특별시 is highly overall correlated with 송파구High correlation
송파구 is highly overall correlated with 서울특별시High correlation
3 has 8 (8.1%) zerosZeros

Reproduction

Analysis started2023-12-10 06:41:21.857713
Analysis finished2023-12-10 06:41:23.777904
Duration1.92 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:23.873636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

201801
Categorical

CONSTANT 

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

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
201801 99
100.0%

Length

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

Common Values (Plot)

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

21
Real number (ℝ)

Distinct67
Distinct (%)67.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean57.626263
Minimum1
Maximum331
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:41:24.401620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile9.9
Q127
median51
Q373
95-th percentile133.4
Maximum331
Range330
Interquartile range (IQR)46

Descriptive statistics

Standard deviation45.211879
Coefficient of variation (CV)0.78457073
Kurtosis12.87558
Mean57.626263
Median Absolute Deviation (MAD)23
Skewness2.6813651
Sum5705
Variance2044.114
MonotonicityNot monotonic
2023-12-10T15:41:24.581362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
74 4
 
4.0%
56 3
 
3.0%
38 3
 
3.0%
60 3
 
3.0%
14 3
 
3.0%
49 3
 
3.0%
27 3
 
3.0%
65 3
 
3.0%
62 2
 
2.0%
25 2
 
2.0%
Other values (57) 70
70.7%
ValueCountFrequency (%)
1 1
 
1.0%
8 2
2.0%
9 2
2.0%
10 1
 
1.0%
11 1
 
1.0%
12 1
 
1.0%
14 3
3.0%
15 2
2.0%
17 2
2.0%
20 1
 
1.0%
ValueCountFrequency (%)
331 1
1.0%
174 1
1.0%
156 1
1.0%
139 1
1.0%
137 1
1.0%
133 1
1.0%
130 1
1.0%
120 1
1.0%
119 1
1.0%
111 1
1.0%

3
Real number (ℝ)

ZEROS 

Distinct50
Distinct (%)50.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21.717172
Minimum0
Maximum84
Zeros8
Zeros (%)8.1%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:41:24.764194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q12
median14
Q332.5
95-th percentile70.4
Maximum84
Range84
Interquartile range (IQR)30.5

Descriptive statistics

Standard deviation22.694079
Coefficient of variation (CV)1.0449832
Kurtosis0.20536826
Mean21.717172
Median Absolute Deviation (MAD)13
Skewness1.0741683
Sum2150
Variance515.02123
MonotonicityNot monotonic
2023-12-10T15:41:24.962389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 14
 
14.1%
0 8
 
8.1%
13 5
 
5.1%
2 4
 
4.0%
6 4
 
4.0%
3 3
 
3.0%
32 3
 
3.0%
14 3
 
3.0%
5 3
 
3.0%
10 3
 
3.0%
Other values (40) 49
49.5%
ValueCountFrequency (%)
0 8
8.1%
1 14
14.1%
2 4
 
4.0%
3 3
 
3.0%
4 1
 
1.0%
5 3
 
3.0%
6 4
 
4.0%
7 1
 
1.0%
8 2
 
2.0%
9 1
 
1.0%
ValueCountFrequency (%)
84 1
1.0%
81 1
1.0%
78 1
1.0%
76 1
1.0%
74 1
1.0%
70 1
1.0%
62 1
1.0%
59 1
1.0%
58 1
1.0%
56 2
2.0%

건강식품
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
건강식품
99 

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 (%)
건강식품 99
100.0%

Length

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

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

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

2
Categorical

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

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 81
81.8%
1 18
 
18.2%

Length

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

Common Values (Plot)

2023-12-10T15:41:26.200901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 81
81.8%
1 18
 
18.2%

20
Real number (ℝ)

Distinct6
Distinct (%)6.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean39.69697
Minimum20
Maximum70
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:41:26.354430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20
5-th percentile20
Q130
median40
Q350
95-th percentile70
Maximum70
Range50
Interquartile range (IQR)20

Descriptive statistics

Standard deviation15.613609
Coefficient of variation (CV)0.39331992
Kurtosis-0.96477102
Mean39.69697
Median Absolute Deviation (MAD)10
Skewness0.3795527
Sum3930
Variance243.78479
MonotonicityNot monotonic
2023-12-10T15:41:26.557171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
30 24
24.2%
20 21
21.2%
40 18
18.2%
50 16
16.2%
60 13
13.1%
70 7
 
7.1%
ValueCountFrequency (%)
20 21
21.2%
30 24
24.2%
40 18
18.2%
50 16
16.2%
60 13
13.1%
70 7
 
7.1%
ValueCountFrequency (%)
70 7
 
7.1%
60 13
13.1%
50 16
16.2%
40 18
18.2%
30 24
24.2%
20 21
21.2%

서울특별시
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)9.1%
Missing0
Missing (%)0.0%
Memory size924.0 B
경기도
21 
부산광역시
17 
전라북도
13 
경상남도
10 
서울특별시
10 
Other values (4)
28 

Length

Max length5
Median length4
Mean length4.1818182
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row부산광역시
2nd row부산광역시
3rd row인천광역시
4th row인천광역시
5th row경기도

Common Values

ValueCountFrequency (%)
경기도 21
21.2%
부산광역시 17
17.2%
전라북도 13
13.1%
경상남도 10
10.1%
서울특별시 10
10.1%
인천광역시 9
9.1%
충청북도 9
9.1%
전라남도 7
 
7.1%
대구광역시 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T15:41:27.067276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 21
21.2%
부산광역시 17
17.2%
전라북도 13
13.1%
경상남도 10
10.1%
서울특별시 10
10.1%
인천광역시 9
9.1%
충청북도 9
9.1%
전라남도 7
 
7.1%
대구광역시 3
 
3.0%

송파구
Categorical

HIGH CORRELATION 

Distinct19
Distinct (%)19.2%
Missing0
Missing (%)0.0%
Memory size924.0 B
전체
38 
김해시
7 
송파구
7 
청주시
7 
평택시
6 
Other values (14)
34 

Length

Max length4
Median length3
Mean length2.6363636
Min length2

Unique

Unique6 ?
Unique (%)6.1%

Sample

1st row전체
2nd row사상구
3rd row전체
4th row연수구
5th row전체

Common Values

ValueCountFrequency (%)
전체 38
38.4%
김해시 7
 
7.1%
송파구 7
 
7.1%
청주시 7
 
7.1%
평택시 6
 
6.1%
익산시 6
 
6.1%
사상구 6
 
6.1%
동래구 5
 
5.1%
안양시 3
 
3.0%
양산시 2
 
2.0%
Other values (9) 12
 
12.1%

Length

2023-12-10T15:41:27.338378image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
전체 38
38.4%
송파구 7
 
7.1%
청주시 7
 
7.1%
김해시 7
 
7.1%
평택시 6
 
6.1%
익산시 6
 
6.1%
사상구 6
 
6.1%
동래구 5
 
5.1%
안양시 3
 
3.0%
제천시 2
 
2.0%
Other values (9) 12
 
12.1%

농협홍삼 한삼인
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
농협홍삼 한삼인
99 

Length

Max length8
Median length8
Mean length8
Min length8

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

Common Values (Plot)

2023-12-10T15:41:27.717229image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
농협홍삼 99
50.0%
한삼인 99
50.0%

Interactions

2023-12-10T15:41:23.060180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:41:22.315090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:41:22.712432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:41:23.197954image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:41:22.444640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:41:22.834854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:41:23.324626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:41:22.576362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:41:22.928425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:41:27.831407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
213220서울특별시송파구
211.0000.2960.1180.1990.1750.000
30.2961.0000.0000.1360.4590.000
20.1180.0001.0000.6540.0000.000
200.1990.1360.6541.0000.0000.000
서울특별시0.1750.4590.0000.0001.0000.921
송파구0.0000.0000.0000.0000.9211.000
2023-12-10T15:41:28.407353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2송파구서울특별시
21.0000.0000.000
송파구0.0001.0000.652
서울특별시0.0000.6521.000
2023-12-10T15:41:28.561105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
213202서울특별시송파구
211.0000.2500.0090.2030.0590.000
30.2501.000-0.1330.0000.2250.000
200.009-0.1331.0000.4680.0000.000
20.2030.0000.4681.0000.0000.000
서울특별시0.0590.2250.0000.0001.0000.652
송파구0.0000.0000.0000.0000.6521.000

Missing values

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

MT201801213건강식품전체전체.1220서울특별시송파구농협홍삼 한삼인
0MT201801212건강식품전체전체220부산광역시전체농협홍삼 한삼인
1MT2018011755건강식품전체전체220부산광역시사상구농협홍삼 한삼인
2MT2018011376건강식품전체전체220인천광역시전체농협홍삼 한삼인
3MT2018012681건강식품전체전체220인천광역시연수구농협홍삼 한삼인
4MT2018016613건강식품전체전체220경기도전체농협홍삼 한삼인
5MT2018013725건강식품전체전체220경기도평택시농협홍삼 한삼인
6MT2018017429건강식품전체전체220충청북도청주시농협홍삼 한삼인
7MT2018011433건강식품전체전체220충청북도제천시농협홍삼 한삼인
8MT2018015632건강식품전체전체220전라북도전체농협홍삼 한삼인
9MT2018016327건강식품전체전체220전라북도익산시농협홍삼 한삼인
MT201801213건강식품전체전체.1220서울특별시송파구농협홍삼 한삼인
89MT201801140건강식품전체전체130서울특별시중구농협홍삼 한삼인
90MT201801780건강식품전체전체130서울특별시강서구농협홍삼 한삼인
91MT201801606건강식품전체전체130서울특별시송파구농협홍삼 한삼인
92MT201801282건강식품전체전체130부산광역시전체농협홍삼 한삼인
93MT2018011003건강식품전체전체130부산광역시동래구농협홍삼 한삼인
94MT2018013178건강식품전체전체130부산광역시사상구농협홍삼 한삼인
95MT201801381건강식품전체전체130대구광역시전체농협홍삼 한삼인
96MT2018011562건강식품전체전체130인천광역시전체농협홍삼 한삼인
97MT20180117432건강식품전체전체130경기도전체농협홍삼 한삼인
98MT201801741건강식품전체전체130경기도안양시농협홍삼 한삼인