Overview

Dataset statistics

Number of variables7
Number of observations99
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.7 KiB
Average record size in memory59.3 B

Variable types

Categorical5
DateTime1
Numeric1

Dataset

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

Alerts

QU has constant value ""Constant
2018Q1 has constant value ""Constant
화장품 has constant value ""Constant
전체 is highly overall correlated with 전체.1High correlation
전체.1 is highly overall correlated with 전체High correlation
75.8534 has 2 (2.0%) zerosZeros

Reproduction

Analysis started2023-12-10 06:34:55.417203
Analysis finished2023-12-10 06:34:56.294983
Duration0.88 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

QU
Categorical

CONSTANT 

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

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
QU 99
100.0%

Length

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

Common Values (Plot)

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

2018Q1
Date

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
Minimum2018-01-01 00:00:00
Maximum2018-01-01 00:00:00
2023-12-10T15:34:56.728836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:34:56.902037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

화장품
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
화장품
99 

Length

Max length3
Median length3
Mean length3
Min length3

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

Common Values (Plot)

2023-12-10T15:34:57.305730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
화장품 99
100.0%

전체
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size924.0 B
스킨케어
26 
색조메이크업
20 
베이스메이크업
16 
유아동스킨케어
16 
클렌징
12 
Other values (2)
9 

Length

Max length7
Median length6
Mean length5.1515152
Min length2

Unique

Unique1 ?
Unique (%)1.0%

Sample

1st row전체
2nd row베이스메이크업
3rd row베이스메이크업
4th row베이스메이크업
5th row베이스메이크업

Common Values

ValueCountFrequency (%)
스킨케어 26
26.3%
색조메이크업 20
20.2%
베이스메이크업 16
16.2%
유아동스킨케어 16
16.2%
클렌징 12
12.1%
선케어 8
 
8.1%
전체 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-10T15:34:57.732744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
스킨케어 26
26.3%
색조메이크업 20
20.2%
베이스메이크업 16
16.2%
유아동스킨케어 16
16.2%
클렌징 12
12.1%
선케어 8
 
8.1%
전체 1
 
1.0%

전체.1
Categorical

HIGH CORRELATION 

Distinct44
Distinct (%)44.4%
Missing0
Missing (%)0.0%
Memory size924.0 B
전체
13 
쿠션/파우더
 
2
아이라이너
 
2
트윈케익/팩트
 
2
파운데이션
 
2
Other values (39)
78 

Length

Max length9
Median length7
Mean length5.1111111
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전체
2nd row전체
3rd row전체
4th row쿠션/파우더
5th row쿠션/파우더

Common Values

ValueCountFrequency (%)
전체 13
 
13.1%
쿠션/파우더 2
 
2.0%
아이라이너 2
 
2.0%
트윈케익/팩트 2
 
2.0%
파운데이션 2
 
2.0%
블러셔/볼터치 2
 
2.0%
메이크업베이스 2
 
2.0%
BB/CC크림 2
 
2.0%
컨실러 2
 
2.0%
립스틱 2
 
2.0%
Other values (34) 68
68.7%

Length

2023-12-10T15:34:57.996291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
전체 13
 
11.7%
유아동 12
 
10.8%
클렌징비누 2
 
1.8%
필링젤/스크럽 2
 
1.8%
크림/젤 2
 
1.8%
에센스/세럼 2
 
1.8%
아이크림/젤 2
 
1.8%
기타스킨케어 2
 
1.8%
마스크팩 2
 
1.8%
립케어 2
 
1.8%
Other values (35) 70
63.1%

2
Categorical

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 50
50.5%
2 49
49.5%

Length

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

Common Values (Plot)

2023-12-10T15:34:58.498873image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 50
50.5%
2 49
49.5%

75.8534
Real number (ℝ)

ZEROS 

Distinct98
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.3004596
Minimum0
Maximum24.1466
Zeros2
Zeros (%)2.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:34:58.727593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.01438
Q10.09715
median0.3364
Q30.92385
95-th percentile5.32941
Maximum24.1466
Range24.1466
Interquartile range (IQR)0.8267

Descriptive statistics

Standard deviation3.2812864
Coefficient of variation (CV)2.5231744
Kurtosis31.81921
Mean1.3004596
Median Absolute Deviation (MAD)0.2976
Skewness5.3139436
Sum128.7455
Variance10.76684
MonotonicityNot monotonic
2023-12-10T15:34:58.974761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 2
 
2.0%
24.1466 1
 
1.0%
0.6507 1
 
1.0%
0.8702 1
 
1.0%
1.957 1
 
1.0%
0.0765 1
 
1.0%
0.3491 1
 
1.0%
0.6473 1
 
1.0%
0.7521 1
 
1.0%
0.5237 1
 
1.0%
Other values (88) 88
88.9%
ValueCountFrequency (%)
0.0 2
2.0%
0.0026 1
1.0%
0.0102 1
1.0%
0.0115 1
1.0%
0.0147 1
1.0%
0.0167 1
1.0%
0.028 1
1.0%
0.0317 1
1.0%
0.0318 1
1.0%
0.0332 1
1.0%
ValueCountFrequency (%)
24.1466 1
1.0%
18.9272 1
1.0%
8.1595 1
1.0%
6.8653 1
1.0%
5.6256 1
1.0%
5.2965 1
1.0%
4.8172 1
1.0%
4.1313 1
1.0%
2.9804 1
1.0%
2.8551 1
1.0%

Interactions

2023-12-10T15:34:55.826323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:34:59.113941image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전체전체.1275.8534
전체1.0000.9330.0000.616
전체.10.9331.0000.0000.000
20.0000.0001.0000.243
75.85340.6160.0000.2431.000
2023-12-10T15:34:59.271402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전체.12전체
전체.11.0000.0000.554
20.0001.0000.000
전체0.5540.0001.000
2023-12-10T15:34:59.422753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
75.8534전체전체.12
75.85341.0000.4240.0000.170
전체0.4241.0000.5540.000
전체.10.0000.5541.0000.000
20.1700.0000.0001.000

Missing values

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

QU2018Q1화장품전체전체.1275.8534
0QU2018Q1화장품전체전체124.1466
1QU2018Q1화장품베이스메이크업전체24.8172
2QU2018Q1화장품베이스메이크업전체11.3074
3QU2018Q1화장품베이스메이크업쿠션/파우더20.2695
4QU2018Q1화장품베이스메이크업쿠션/파우더10.0751
5QU2018Q1화장품베이스메이크업트윈케익/팩트20.4674
6QU2018Q1화장품베이스메이크업트윈케익/팩트10.0972
7QU2018Q1화장품베이스메이크업파운데이션21.8305
8QU2018Q1화장품베이스메이크업파운데이션10.4508
9QU2018Q1화장품베이스메이크업블러셔/볼터치20.7076
QU2018Q1화장품전체전체.1275.8534
89QU2018Q1화장품클렌징클렌징티슈20.3683
90QU2018Q1화장품클렌징클렌징티슈10.0863
91QU2018Q1화장품클렌징필링젤/스크럽20.1266
92QU2018Q1화장품클렌징필링젤/스크럽10.0332
93QU2018Q1화장품클렌징클렌징비누20.9899
94QU2018Q1화장품클렌징클렌징비누10.4297
95QU2018Q1화장품클렌징기타클렌징20.0
96QU2018Q1화장품클렌징기타클렌징10.0
97QU2018Q1화장품클렌징클렌징폼/필링젤22.9804
98QU2018Q1화장품클렌징클렌징폼/필링젤10.9564