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

Alerts

MT has constant value ""Constant
주방소모품 has constant value ""Constant
전체 has constant value ""Constant
전체.1 has constant value ""Constant
롯데알미늄 has constant value ""Constant
1 is highly overall correlated with 201804 and 1 other fieldsHigh correlation
201804 is highly overall correlated with 1 and 1 other fieldsHigh correlation
114 is highly overall correlated with 100High correlation
100 is highly overall correlated with 114High correlation
20 is highly overall correlated with 201804 and 1 other fieldsHigh correlation
강원도 is highly overall correlated with 인제군High correlation
인제군 is highly overall correlated with 강원도High correlation
100 has 2 (2.0%) zerosZeros

Reproduction

Analysis started2023-12-10 06:23:55.942090
Analysis finished2023-12-10 06:23:57.713999
Duration1.77 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:23:57.833241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

201804
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
201804
70 
201801
29 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
201804 70
70.7%
201801 29
29.3%

Length

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

Common Values (Plot)

2023-12-10T15:23:58.485162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
201804 70
70.7%
201801 29
29.3%

114
Real number (ℝ)

HIGH CORRELATION 

Distinct79
Distinct (%)79.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean80.939394
Minimum9
Maximum235
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:23:58.678018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum9
5-th percentile12.9
Q148.5
median78
Q3103.5
95-th percentile177.6
Maximum235
Range226
Interquartile range (IQR)55

Descriptive statistics

Standard deviation47.914639
Coefficient of variation (CV)0.59198169
Kurtosis1.3744502
Mean80.939394
Median Absolute Deviation (MAD)28
Skewness1.0343702
Sum8013
Variance2295.8126
MonotonicityNot monotonic
2023-12-10T15:23:58.974155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
86 5
 
5.1%
29 2
 
2.0%
52 2
 
2.0%
100 2
 
2.0%
43 2
 
2.0%
57 2
 
2.0%
12 2
 
2.0%
36 2
 
2.0%
87 2
 
2.0%
80 2
 
2.0%
Other values (69) 76
76.8%
ValueCountFrequency (%)
9 1
1.0%
10 2
2.0%
12 2
2.0%
13 1
1.0%
21 1
1.0%
22 1
1.0%
24 1
1.0%
26 1
1.0%
27 1
1.0%
29 2
2.0%
ValueCountFrequency (%)
235 1
1.0%
227 1
1.0%
221 1
1.0%
196 1
1.0%
183 1
1.0%
177 1
1.0%
160 1
1.0%
150 1
1.0%
144 1
1.0%
141 1
1.0%

100
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct36
Distinct (%)36.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17.040404
Minimum0
Maximum100
Zeros2
Zeros (%)2.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:23:59.245036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q15
median10
Q318.5
95-th percentile63.1
Maximum100
Range100
Interquartile range (IQR)13.5

Descriptive statistics

Standard deviation21.27033
Coefficient of variation (CV)1.2482292
Kurtosis6.3891185
Mean17.040404
Median Absolute Deviation (MAD)6
Skewness2.4912286
Sum1687
Variance452.42692
MonotonicityNot monotonic
2023-12-10T15:23:59.503712image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)
ValueCountFrequency (%)
3 6
 
6.1%
6 6
 
6.1%
2 6
 
6.1%
8 6
 
6.1%
9 6
 
6.1%
1 6
 
6.1%
12 5
 
5.1%
7 4
 
4.0%
13 4
 
4.0%
5 4
 
4.0%
Other values (26) 46
46.5%
ValueCountFrequency (%)
0 2
 
2.0%
1 6
6.1%
2 6
6.1%
3 6
6.1%
4 3
3.0%
5 4
4.0%
6 6
6.1%
7 4
4.0%
8 6
6.1%
9 6
6.1%
ValueCountFrequency (%)
100 3
3.0%
80 1
 
1.0%
73 1
 
1.0%
62 1
 
1.0%
57 1
 
1.0%
51 1
 
1.0%
47 1
 
1.0%
44 1
 
1.0%
37 1
 
1.0%
35 2
2.0%

주방소모품
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:23:59.736241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

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

1
Categorical

HIGH CORRELATION 

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 70
70.7%
2 29
29.3%

Length

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

Common Values (Plot)

2023-12-10T15:24:00.886601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 70
70.7%
2 29
29.3%

20
Categorical

HIGH CORRELATION 

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

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 (%)
20 37
37.4%
30 36
36.4%
40 26
26.3%

Length

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

Common Values (Plot)

2023-12-10T15:24:01.244539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20 37
37.4%
30 36
36.4%
40 26
26.3%

강원도
Categorical

HIGH CORRELATION 

Distinct14
Distinct (%)14.1%
Missing0
Missing (%)0.0%
Memory size924.0 B
서울특별시
17 
충청남도
15 
경기도
15 
부산광역시
14 
전라남도
7 
Other values (9)
31 

Length

Max length5
Median length5
Mean length4.3636364
Min length3

Unique

Unique2 ?
Unique (%)2.0%

Sample

1st row충청북도
2nd row충청남도
3rd row충청남도
4th row충청남도
5th row충청남도

Common Values

ValueCountFrequency (%)
서울특별시 17
17.2%
충청남도 15
15.2%
경기도 15
15.2%
부산광역시 14
14.1%
전라남도 7
7.1%
인천광역시 7
7.1%
대전광역시 7
7.1%
충청북도 4
 
4.0%
울산광역시 4
 
4.0%
대구광역시 3
 
3.0%
Other values (4) 6
 
6.1%

Length

2023-12-10T15:24:01.442665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
서울특별시 17
17.2%
충청남도 15
15.2%
경기도 15
15.2%
부산광역시 14
14.1%
전라남도 7
7.1%
인천광역시 7
7.1%
대전광역시 7
7.1%
충청북도 4
 
4.0%
울산광역시 4
 
4.0%
대구광역시 3
 
3.0%
Other values (4) 6
 
6.1%

인제군
Categorical

HIGH CORRELATION 

Distinct37
Distinct (%)37.4%
Missing0
Missing (%)0.0%
Memory size924.0 B
전체
8 
부평구
 
3
구로구
 
3
광진구
 
3
성동구
 
3
Other values (32)
79 

Length

Max length4
Median length3
Mean length2.9090909
Min length2

Unique

Unique6 ?
Unique (%)6.1%

Sample

1st row충주시
2nd row전체
3rd row아산시
4th row서산시
5th row당진시

Common Values

ValueCountFrequency (%)
전체 8
 
8.1%
부평구 3
 
3.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) 64
64.6%

Length

2023-12-10T15:24:01.708449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
전체 8
 
8.1%
금정구 3
 
3.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) 64
64.6%

롯데알미늄
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:24:01.992796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:24:02.208582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
롯데알미늄 99
100.0%

Interactions

2023-12-10T15:23:56.907658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:23:56.629942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:23:57.038703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:23:56.772076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:24:02.314499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
201804114100120강원도인제군
2018041.0000.2710.1600.9990.5610.0000.000
1140.2711.0000.6530.2710.0000.0000.537
1000.1600.6531.0000.1600.0000.4110.834
10.9990.2710.1601.0000.5610.0000.000
200.5610.0000.0000.5611.0000.2060.000
강원도0.0000.0000.4110.0000.2061.0000.987
인제군0.0000.5370.8340.0000.0000.9871.000
2023-12-10T15:24:02.503591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
인제군강원도201201804
인제군1.0000.7470.0000.0000.000
강원도0.7471.0000.1030.0000.000
200.0000.1031.0000.8250.825
10.0000.0000.8251.0000.975
2018040.0000.0000.8250.9751.000
2023-12-10T15:24:02.701838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
114100201804120강원도인제군
1141.0000.6200.1970.1970.0000.0000.171
1000.6201.0000.1790.1790.0220.1770.384
2018040.1970.1791.0000.9750.8250.0000.000
10.1970.1790.9751.0000.8250.0000.000
200.0000.0220.8250.8251.0000.1030.000
강원도0.0000.1770.0000.0000.1031.0000.747
인제군0.1710.3840.0000.0000.0000.7471.000

Missing values

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

MT201804114100주방소모품전체전체.1120강원도인제군롯데알미늄
0MT201804293주방소모품전체전체120충청북도충주시롯데알미늄
1MT2018047911주방소모품전체전체120충청남도전체롯데알미늄
2MT2018046018주방소모품전체전체120충청남도아산시롯데알미늄
3MT201804296주방소모품전체전체120충청남도서산시롯데알미늄
4MT2018047713주방소모품전체전체120충청남도당진시롯데알미늄
5MT20180411335주방소모품전체전체120충청남도홍성군롯데알미늄
6MT201804455주방소모품전체전체120전라남도여수시롯데알미늄
7MT201804196100주방소모품전체전체120전라남도영암군롯데알미늄
8MT2018048612주방소모품전체전체130서울특별시전체롯데알미늄
9MT20180415073주방소모품전체전체130서울특별시종로구롯데알미늄
MT201804114100주방소모품전체전체.1120강원도인제군롯데알미늄
89MT201801938주방소모품전체전체220경기도안성시롯데알미늄
90MT20180111014주방소모품전체전체220강원도전체롯데알미늄
91MT201801120주방소모품전체전체220충청북도충주시롯데알미늄
92MT20180113212주방소모품전체전체220충청남도전체롯데알미늄
93MT20180114113주방소모품전체전체220충청남도아산시롯데알미늄
94MT201801539주방소모품전체전체220충청남도서산시롯데알미늄
95MT20180123516주방소모품전체전체220충청남도당진시롯데알미늄
96MT2018019413주방소모품전체전체220충청남도홍성군롯데알미늄
97MT2018019712주방소모품전체전체220전라남도여수시롯데알미늄
98MT20180114480주방소모품전체전체220전라남도영암군롯데알미늄