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
Numeric2
Text1

Dataset

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

Alerts

MT has constant value ""Constant
201802 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
108 is highly overall correlated with 19High correlation
19 is highly overall correlated with 108High correlation

Reproduction

Analysis started2023-12-10 06:21:10.878862
Analysis finished2023-12-10 06:21:12.683463
Duration1.8 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:21:12.840211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

201802
Categorical

CONSTANT 

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

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
201802 99
100.0%

Length

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

Common Values (Plot)

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

108
Real number (ℝ)

HIGH CORRELATION 

Distinct74
Distinct (%)74.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean141.19192
Minimum8
Maximum488
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:21:13.661661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum8
5-th percentile27.7
Q192.5
median139
Q3176
95-th percentile316.2
Maximum488
Range480
Interquartile range (IQR)83.5

Descriptive statistics

Standard deviation85.380263
Coefficient of variation (CV)0.60471069
Kurtosis3.7831464
Mean141.19192
Median Absolute Deviation (MAD)43
Skewness1.4069065
Sum13978
Variance7289.7893
MonotonicityNot monotonic
2023-12-10T15:21:14.023134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
171 4
 
4.0%
139 3
 
3.0%
145 3
 
3.0%
98 2
 
2.0%
191 2
 
2.0%
96 2
 
2.0%
117 2
 
2.0%
86 2
 
2.0%
193 2
 
2.0%
29 2
 
2.0%
Other values (64) 75
75.8%
ValueCountFrequency (%)
8 1
1.0%
10 1
1.0%
14 1
1.0%
17 1
1.0%
25 1
1.0%
28 1
1.0%
29 2
2.0%
40 2
2.0%
41 1
1.0%
42 1
1.0%
ValueCountFrequency (%)
488 1
1.0%
465 1
1.0%
338 1
1.0%
324 1
1.0%
318 1
1.0%
316 1
1.0%
301 1
1.0%
243 1
1.0%
223 1
1.0%
215 1
1.0%

19
Real number (ℝ)

HIGH CORRELATION 

Distinct47
Distinct (%)47.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean29.121212
Minimum1
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:21:14.364109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3
Q119
median27
Q338
95-th percentile57.1
Maximum100
Range99
Interquartile range (IQR)19

Descriptive statistics

Standard deviation16.760786
Coefficient of variation (CV)0.57555247
Kurtosis2.0930818
Mean29.121212
Median Absolute Deviation (MAD)9
Skewness0.84654021
Sum2883
Variance280.92393
MonotonicityNot monotonic
2023-12-10T15:21:14.710751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%)
33 6
 
6.1%
21 5
 
5.1%
24 5
 
5.1%
25 4
 
4.0%
23 3
 
3.0%
10 3
 
3.0%
31 3
 
3.0%
35 3
 
3.0%
27 3
 
3.0%
26 3
 
3.0%
Other values (37) 61
61.6%
ValueCountFrequency (%)
1 2
2.0%
2 2
2.0%
3 3
3.0%
4 2
2.0%
8 2
2.0%
10 3
3.0%
14 2
2.0%
15 1
 
1.0%
16 3
3.0%
17 3
3.0%
ValueCountFrequency (%)
100 1
1.0%
61 1
1.0%
59 2
2.0%
58 1
1.0%
57 1
1.0%
55 2
2.0%
54 1
1.0%
52 1
1.0%
50 2
2.0%
49 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:21:15.130728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

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

50
Categorical

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
60
45 
50
32 
70
22 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
60 45
45.5%
50 32
32.3%
70 22
22.2%

Length

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

Common Values (Plot)

2023-12-10T15:21:17.077788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
60 45
45.5%
50 32
32.3%
70 22
22.2%

경기도
Categorical

Distinct14
Distinct (%)14.1%
Missing0
Missing (%)0.0%
Memory size924.0 B
경기도
24 
서울특별시
19 
부산광역시
10 
경상북도
8 
강원도
5 
Other values (9)
33 

Length

Max length5
Median length4
Mean length4.1616162
Min length3

Unique

Unique1 ?
Unique (%)1.0%

Sample

1st row경기도
2nd row경기도
3rd row경기도
4th row경기도
5th row경기도

Common Values

ValueCountFrequency (%)
경기도 24
24.2%
서울특별시 19
19.2%
부산광역시 10
10.1%
경상북도 8
 
8.1%
강원도 5
 
5.1%
대전광역시 5
 
5.1%
충청남도 5
 
5.1%
충청북도 4
 
4.0%
전라남도 4
 
4.0%
경상남도 4
 
4.0%
Other values (4) 11
11.1%

Length

2023-12-10T15:21:17.284439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경기도 24
24.2%
서울특별시 19
19.2%
부산광역시 10
10.1%
경상북도 8
 
8.1%
강원도 5
 
5.1%
대전광역시 5
 
5.1%
충청남도 5
 
5.1%
충청북도 4
 
4.0%
전라남도 4
 
4.0%
경상남도 4
 
4.0%
Other values (4) 11
11.1%

수원시
Text

Distinct56
Distinct (%)56.6%
Missing0
Missing (%)0.0%
Memory size924.0 B
2023-12-10T15:21:17.629144image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length3
Mean length2.8585859
Min length2

Characters and Unicode

Total characters283
Distinct characters65
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique32 ?
Unique (%)32.3%

Sample

1st row성남시
2nd row고양시
3rd row시흥시
4th row하남시
5th row이천시
ValueCountFrequency (%)
전체 13
 
13.1%
남구 4
 
4.0%
고양시 3
 
3.0%
동구 3
 
3.0%
김천시 3
 
3.0%
성남시 3
 
3.0%
이천시 3
 
3.0%
시흥시 3
 
3.0%
영등포구 2
 
2.0%
안산시 2
 
2.0%
Other values (46) 60
60.6%
2023-12-10T15:21:18.234023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
구 42
 
14.8%
시 41
 
14.5%
전 13
 
4.6%
체 13
 
4.6%
천 12
 
4.2%
동 9
 
3.2%
성 9
 
3.2%
군 8
 
2.8%
남 8
 
2.8%
영 7
 
2.5%
Other values (55) 121
42.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 283
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 42
 
14.8%
시 41
 
14.5%
전 13
 
4.6%
체 13
 
4.6%
천 12
 
4.2%
동 9
 
3.2%
성 9
 
3.2%
군 8
 
2.8%
남 8
 
2.8%
영 7
 
2.5%
Other values (55) 121
42.8%

Most occurring scripts

ValueCountFrequency (%)
Hangul 283
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 42
 
14.8%
시 41
 
14.5%
전 13
 
4.6%
체 13
 
4.6%
천 12
 
4.2%
동 9
 
3.2%
성 9
 
3.2%
군 8
 
2.8%
남 8
 
2.8%
영 7
 
2.5%
Other values (55) 121
42.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 283
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
구 42
 
14.8%
시 41
 
14.5%
전 13
 
4.6%
체 13
 
4.6%
천 12
 
4.2%
동 9
 
3.2%
성 9
 
3.2%
군 8
 
2.8%
남 8
 
2.8%
영 7
 
2.5%
Other values (55) 121
42.8%

아모레퍼시픽 려
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:21:18.441465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:21:18.583669image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
아모레퍼시픽 99
50.0%
려 99
50.0%

Interactions

2023-12-10T15:21:11.850881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:21:11.501194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:21:12.000834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:21:11.692621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:21:18.682491image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
1081950경기도수원시
1081.0000.6720.1390.0000.851
190.6721.0000.2740.4530.877
500.1390.2741.0000.5930.000
경기도0.0000.4530.5931.0000.943
수원시0.8510.8770.0000.9431.000
2023-12-10T15:21:18.861647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
50경기도
501.0000.382
경기도0.3821.000
2023-12-10T15:21:19.028735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
1081950경기도
1081.0000.7380.0520.000
190.7381.0000.1740.208
500.0520.1741.0000.382
경기도0.0000.2080.3821.000

Missing values

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

MT20180210819헤어용품전체전체.1250경기도수원시아모레퍼시픽 려
0MT20180215123헤어용품전체전체250경기도성남시아모레퍼시픽 려
1MT20180215829헤어용품전체전체250경기도고양시아모레퍼시픽 려
2MT20180218333헤어용품전체전체250경기도시흥시아모레퍼시픽 려
3MT20180231836헤어용품전체전체250경기도하남시아모레퍼시픽 려
4MT201802623헤어용품전체전체250경기도이천시아모레퍼시픽 려
5MT20180217117헤어용품전체전체250경기도연천군아모레퍼시픽 려
6MT201802403헤어용품전체전체250강원도횡성군아모레퍼시픽 려
7MT20180216418헤어용품전체전체250강원도평창군아모레퍼시픽 려
8MT20180219830헤어용품전체전체250충청북도전체아모레퍼시픽 려
9MT201802171헤어용품전체전체250전라남도광양시아모레퍼시픽 려
MT20180210819헤어용품전체전체.1250경기도수원시아모레퍼시픽 려
89MT20180284헤어용품전체전체260대구광역시서구아모레퍼시픽 려
90MT2018024116헤어용품전체전체260인천광역시미추홀구아모레퍼시픽 려
91MT20180219348헤어용품전체전체260인천광역시부평구아모레퍼시픽 려
92MT20180214535헤어용품전체전체260인천광역시계양구아모레퍼시픽 려
93MT2018027320헤어용품전체전체260대전광역시서구아모레퍼시픽 려
94MT20180214327헤어용품전체전체260대전광역시유성구아모레퍼시픽 려
95MT20180217159헤어용품전체전체260울산광역시남구아모레퍼시픽 려
96MT201802423헤어용품전체전체260경기도동두천시아모레퍼시픽 려
97MT20180218724헤어용품전체전체260경기도안산시아모레퍼시픽 려
98MT20180221555헤어용품전체전체260경기도의왕시아모레퍼시픽 려