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.8 KiB
Average record size in memory101.3 B

Variable types

Categorical9
Numeric3

Dataset

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

Alerts

원예용품 has constant value ""Constant
전체 has constant value ""Constant
전체.1 has constant value ""Constant
삼호유리 has constant value ""Constant
2 is highly overall correlated with 20 and 2 other fieldsHigh correlation
MT is highly overall correlated with 20 and 2 other fieldsHigh correlation
201801 is highly overall correlated with 20 and 2 other fieldsHigh correlation
36 is highly overall correlated with 3High correlation
3 is highly overall correlated with 36High correlation
20 is highly overall correlated with MT and 2 other fieldsHigh correlation
전체.2 is highly overall correlated with 전체.3High correlation
전체.3 is highly overall correlated with 전체.2High correlation
3 has 2 (2.0%) zerosZeros

Reproduction

Analysis started2023-12-10 06:46:28.420726
Analysis finished2023-12-10 06:46:30.062955
Duration1.64 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

MT
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
MT
88 
QU
11 

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 88
88.9%
QU 11
 
11.1%

Length

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

Common Values (Plot)

2023-12-10T15:46:30.247283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
mt 88
88.9%
qu 11
 
11.1%

201801
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
201801
72 
201901
16 
2018Q4
11 

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 72
72.7%
201901 16
 
16.2%
2018Q4 11
 
11.1%

Length

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

Common Values (Plot)

2023-12-10T15:46:30.482058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
201801 72
72.7%
201901 16
 
16.2%
2018q4 11
 
11.1%

36
Real number (ℝ)

HIGH CORRELATION 

Distinct71
Distinct (%)71.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean72.717172
Minimum1
Maximum221
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:46:30.642881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile14.6
Q142
median64
Q394.5
95-th percentile165.1
Maximum221
Range220
Interquartile range (IQR)52.5

Descriptive statistics

Standard deviation45.210402
Coefficient of variation (CV)0.62172937
Kurtosis1.1348991
Mean72.717172
Median Absolute Deviation (MAD)24
Skewness1.0400244
Sum7199
Variance2043.9804
MonotonicityNot monotonic
2023-12-10T15:46:30.819272image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
78 4
 
4.0%
68 3
 
3.0%
79 3
 
3.0%
63 3
 
3.0%
47 2
 
2.0%
126 2
 
2.0%
66 2
 
2.0%
60 2
 
2.0%
112 2
 
2.0%
34 2
 
2.0%
Other values (61) 74
74.7%
ValueCountFrequency (%)
1 1
1.0%
3 2
2.0%
10 1
1.0%
11 1
1.0%
15 1
1.0%
16 1
1.0%
19 2
2.0%
20 1
1.0%
25 2
2.0%
26 1
1.0%
ValueCountFrequency (%)
221 1
1.0%
213 1
1.0%
175 1
1.0%
173 1
1.0%
166 1
1.0%
165 1
1.0%
160 1
1.0%
154 1
1.0%
147 1
1.0%
144 1
1.0%

3
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct29
Distinct (%)29.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11.929293
Minimum0
Maximum81
Zeros2
Zeros (%)2.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:46:31.016989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q15
median7
Q314
95-th percentile43.2
Maximum81
Range81
Interquartile range (IQR)9

Descriptive statistics

Standard deviation14.318001
Coefficient of variation (CV)1.2002389
Kurtosis8.2657968
Mean11.929293
Median Absolute Deviation (MAD)4
Skewness2.7371486
Sum1181
Variance205.00515
MonotonicityNot monotonic
2023-12-10T15:46:31.159534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%)
6 12
 
12.1%
5 12
 
12.1%
7 8
 
8.1%
3 7
 
7.1%
4 6
 
6.1%
2 5
 
5.1%
16 4
 
4.0%
9 4
 
4.0%
1 4
 
4.0%
14 4
 
4.0%
Other values (19) 33
33.3%
ValueCountFrequency (%)
0 2
 
2.0%
1 4
 
4.0%
2 5
5.1%
3 7
7.1%
4 6
6.1%
5 12
12.1%
6 12
12.1%
7 8
8.1%
8 4
 
4.0%
9 4
 
4.0%
ValueCountFrequency (%)
81 1
 
1.0%
69 1
 
1.0%
57 1
 
1.0%
50 1
 
1.0%
45 1
 
1.0%
43 3
3.0%
28 1
 
1.0%
25 1
 
1.0%
24 2
2.0%
21 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:46:31.352164image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

2023-12-10T15:46:31.925965image/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
88 
1
11 

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 88
88.9%
1 11
 
11.1%

Length

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

Common Values (Plot)

2023-12-10T15:46:32.195801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 88
88.9%
1 11
 
11.1%

20
Real number (ℝ)

HIGH CORRELATION 

Distinct6
Distinct (%)6.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean41.313131
Minimum20
Maximum70
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:46:32.332904image/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 deviation16.453178
Coefficient of variation (CV)0.39825541
Kurtosis-1.0428186
Mean41.313131
Median Absolute Deviation (MAD)10
Skewness0.34668179
Sum4090
Variance270.70707
MonotonicityNot monotonic
2023-12-10T15:46:32.463318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
30 23
23.2%
20 19
19.2%
40 18
18.2%
50 16
16.2%
70 12
12.1%
60 11
11.1%
ValueCountFrequency (%)
20 19
19.2%
30 23
23.2%
40 18
18.2%
50 16
16.2%
60 11
11.1%
70 12
12.1%
ValueCountFrequency (%)
70 12
12.1%
60 11
11.1%
50 16
16.2%
40 18
18.2%
30 23
23.2%
20 19
19.2%

전체.2
Categorical

HIGH CORRELATION 

Distinct12
Distinct (%)12.1%
Missing0
Missing (%)0.0%
Memory size924.0 B
경상남도
16 
광주광역시
11 
울산광역시
11 
경기도
11 
강원도
10 
Other values (7)
40 

Length

Max length7
Median length5
Mean length4.2020202
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대구광역시
2nd row인천광역시
3rd row광주광역시
4th row울산광역시
5th row울산광역시

Common Values

ValueCountFrequency (%)
경상남도 16
16.2%
광주광역시 11
11.1%
울산광역시 11
11.1%
경기도 11
11.1%
강원도 10
10.1%
전체 8
8.1%
인천광역시 7
7.1%
대구광역시 6
 
6.1%
제주특별자치도 6
 
6.1%
충청남도 5
 
5.1%
Other values (2) 8
8.1%

Length

2023-12-10T15:46:32.646885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경상남도 16
16.2%
광주광역시 11
11.1%
울산광역시 11
11.1%
경기도 11
11.1%
강원도 10
10.1%
전체 8
8.1%
인천광역시 7
7.1%
대구광역시 6
 
6.1%
제주특별자치도 6
 
6.1%
충청남도 5
 
5.1%
Other values (2) 8
8.1%

전체.3
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)17.2%
Missing0
Missing (%)0.0%
Memory size924.0 B
전체
26 
서구
13 
북구
11 
창원시
7 
구리시
6 
Other values (12)
36 

Length

Max length4
Median length2
Mean length2.5151515
Min length2

Unique

Unique4 ?
Unique (%)4.0%

Sample

1st row북구
2nd row서구
3rd row서구
4th row전체
5th row북구

Common Values

ValueCountFrequency (%)
전체 26
26.3%
서구 13
13.1%
북구 11
11.1%
창원시 7
 
7.1%
구리시 6
 
6.1%
원주시 6
 
6.1%
천안시 5
 
5.1%
춘천시 4
 
4.0%
광산구 4
 
4.0%
김포시 4
 
4.0%
Other values (7) 13
13.1%

Length

2023-12-10T15:46:32.863251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
전체 26
26.3%
서구 13
13.1%
북구 11
11.1%
창원시 7
 
7.1%
구리시 6
 
6.1%
원주시 6
 
6.1%
천안시 5
 
5.1%
김포시 4
 
4.0%
광산구 4
 
4.0%
춘천시 4
 
4.0%
Other values (7) 13
13.1%

삼호유리
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
삼호유리
99 

Length

Max length5
Median length5
Mean length5
Min length5

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

Common Values (Plot)

2023-12-10T15:46:33.153729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
삼호유리 99
100.0%

Interactions

2023-12-10T15:46:29.527418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:46:28.928694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:46:29.238575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:46:29.614166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:46:29.028560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:46:29.334264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:46:29.703352image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:46:29.141633image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:46:29.426710image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:46:33.233985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
MT201801363220전체.2전체.3
MT1.0001.0000.2210.0000.9970.8790.0000.083
2018011.0001.0000.0000.0001.0000.8800.0000.357
360.2210.0001.0000.7390.2210.3840.3140.000
30.0000.0000.7391.0000.0000.3160.0000.000
20.9971.0000.2210.0001.0000.8790.0000.083
200.8790.8800.3840.3160.8791.0000.0000.000
전체.20.0000.0000.3140.0000.0000.0001.0000.960
전체.30.0830.3570.0000.0000.0830.0000.9601.000
2023-12-10T15:46:33.386185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전체.32MT201801전체.2
전체.31.0000.0550.0550.1860.772
20.0551.0000.9480.9950.000
MT0.0550.9481.0000.9950.000
2018010.1860.9950.9951.0000.000
전체.20.7720.0000.0000.0001.000
2023-12-10T15:46:33.521718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
36320MT2018012전체.2전체.3
361.0000.6580.2100.2430.1200.2430.1600.058
30.6581.0000.2500.0000.0000.0000.0000.000
200.2100.2501.0000.6770.5790.6770.0000.000
MT0.2430.0000.6771.0000.9950.9480.0000.055
2018010.1200.0000.5790.9951.0000.9950.0000.186
20.2430.0000.6770.9480.9951.0000.0000.055
전체.20.1600.0000.0000.0000.0000.0001.0000.772
전체.30.0580.0000.0000.0550.1860.0550.7721.000

Missing values

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

MT201801363원예용품전체전체.1220전체.2전체.3삼호유리
0MT201801476원예용품전체전체220대구광역시북구삼호유리
1MT201801959원예용품전체전체220인천광역시서구삼호유리
2MT201801674원예용품전체전체220광주광역시서구삼호유리
3MT2018015324원예용품전체전체220울산광역시전체삼호유리
4MT20180112581원예용품전체전체220울산광역시북구삼호유리
5MT20180110550원예용품전체전체220경기도구리시삼호유리
6MT201801585원예용품전체전체220강원도춘천시삼호유리
7MT201801200원예용품전체전체220충청남도천안시삼호유리
8MT201801423원예용품전체전체220경상남도전체삼호유리
9MT201801657원예용품전체전체220경상남도창원시삼호유리
MT201801363원예용품전체전체.1220전체.2전체.3삼호유리
89MT20190117516원예용품전체전체220전라북도군산시삼호유리
90MT201901713원예용품전체전체220경상남도전체삼호유리
91MT201901492원예용품전체전체220경상남도창원시삼호유리
92MT201901664원예용품전체전체230전체전체삼호유리
93MT201901516원예용품전체전체230부산광역시부산진구삼호유리
94MT201901413원예용품전체전체230부산광역시기장군삼호유리
95MT201901192원예용품전체전체230대구광역시북구삼호유리
96MT201901789원예용품전체전체230인천광역시중구삼호유리
97MT201901676원예용품전체전체230인천광역시서구삼호유리
98MT201901382원예용품전체전체230광주광역시서구삼호유리