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
Numeric2

Dataset

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

Alerts

QU has constant value ""Constant
2018Q1 has constant value ""Constant
화장품 has constant value ""Constant
12.6048 is highly overall correlated with 전체High correlation
전체 is highly overall correlated with 12.6048 and 1 other fieldsHigh correlation
전체.1 is highly overall correlated with 전체High correlation

Reproduction

Analysis started2023-12-10 06:22:14.044391
Analysis finished2023-12-10 06:22:15.280433
Duration1.24 second
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:22:15.605371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

2018Q1
Categorical

CONSTANT 

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

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2018Q1 99
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:22:16.312104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2018q1 99
100.0%

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

Common Values (Plot)

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

전체
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
베이스메이크업
48 
색조메이크업
46 
전체
5 

Length

Max length7
Median length6
Mean length6.2828283
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
베이스메이크업 48
48.5%
색조메이크업 46
46.5%
전체 5
 
5.1%

Length

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

Common Values (Plot)

2023-12-10T15:22:16.976758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
베이스메이크업 48
48.5%
색조메이크업 46
46.5%
전체 5
 
5.1%

전체.1
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)15.2%
Missing0
Missing (%)0.0%
Memory size924.0 B
전체
17 
쿠션/파우더
6 
트윈케익/팩트
6 
파운데이션
6 
블러셔/볼터치
6 
Other values (10)
58 

Length

Max length8
Median length6
Mean length4.8686869
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
전체 17
17.2%
쿠션/파우더 6
 
6.1%
트윈케익/팩트 6
 
6.1%
파운데이션 6
 
6.1%
블러셔/볼터치 6
 
6.1%
메이크업베이스 6
 
6.1%
BB/CC크림 6
 
6.1%
컨실러 6
 
6.1%
립스틱 6
 
6.1%
아이브로우 6
 
6.1%
Other values (5) 28
28.3%

Length

2023-12-10T15:22:17.172101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
전체 17
17.2%
쿠션/파우더 6
 
6.1%
트윈케익/팩트 6
 
6.1%
파운데이션 6
 
6.1%
블러셔/볼터치 6
 
6.1%
메이크업베이스 6
 
6.1%
bb/cc크림 6
 
6.1%
컨실러 6
 
6.1%
립스틱 6
 
6.1%
아이브로우 6
 
6.1%
Other values (5) 28
28.3%

20
Real number (ℝ)

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

Quantile statistics

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

Descriptive statistics

Standard deviation16.985206
Coefficient of variation (CV)0.37872418
Kurtosis-1.2440401
Mean44.848485
Median Absolute Deviation (MAD)10
Skewness0.020140802
Sum4440
Variance288.49722
MonotonicityNot monotonic
2023-12-10T15:22:17.637803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
30 17
17.2%
40 17
17.2%
50 17
17.2%
60 16
16.2%
70 16
16.2%
20 16
16.2%
ValueCountFrequency (%)
20 16
16.2%
30 17
17.2%
40 17
17.2%
50 17
17.2%
60 16
16.2%
70 16
16.2%
ValueCountFrequency (%)
70 16
16.2%
60 16
16.2%
50 17
17.2%
40 17
17.2%
30 17
17.2%
20 16
16.2%

12.6048
Real number (ℝ)

HIGH CORRELATION 

Distinct97
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.178299
Minimum0.001
Maximum29.9317
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:22:17.869404image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.001
5-th percentile0.00922
Q10.0485
median0.1575
Q30.3716
95-th percentile2.56811
Maximum29.9317
Range29.9307
Interquartile range (IQR)0.3231

Descriptive statistics

Standard deviation4.4135793
Coefficient of variation (CV)3.745721
Kurtosis29.430173
Mean1.178299
Median Absolute Deviation (MAD)0.1235
Skewness5.3803436
Sum116.6516
Variance19.479682
MonotonicityNot monotonic
2023-12-10T15:22:18.206307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.1479 2
 
2.0%
0.0094 2
 
2.0%
19.7788 1
 
1.0%
0.2241 1
 
1.0%
0.3417 1
 
1.0%
0.3421 1
 
1.0%
0.5237 1
 
1.0%
0.0447 1
 
1.0%
0.1387 1
 
1.0%
0.1853 1
 
1.0%
Other values (87) 87
87.9%
ValueCountFrequency (%)
0.001 1
1.0%
0.0032 1
1.0%
0.0048 1
1.0%
0.0071 1
1.0%
0.0076 1
1.0%
0.0094 2
2.0%
0.0126 1
1.0%
0.0135 1
1.0%
0.0153 1
1.0%
0.0157 1
1.0%
ValueCountFrequency (%)
29.9317 1
1.0%
25.1484 1
1.0%
19.7788 1
1.0%
9.2117 1
1.0%
3.0245 1
1.0%
2.5174 1
1.0%
2.4831 1
1.0%
2.0769 1
1.0%
1.9026 1
1.0%
1.4362 1
1.0%

Interactions

2023-12-10T15:22:14.623361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:22:14.349512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:22:14.781384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:22:14.473920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:22:18.375183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전체전체.12012.6048
전체1.0000.9230.0000.933
전체.10.9231.0000.0000.000
200.0000.0001.0000.000
12.60480.9330.0000.0001.000
2023-12-10T15:22:18.528122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전체전체.1
전체1.0000.656
전체.10.6561.000
2023-12-10T15:22:18.674829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2012.6048전체전체.1
201.000-0.3780.0000.000
12.6048-0.3781.0000.6770.000
전체0.0000.6771.0000.656
전체.10.0000.0000.6561.000

Missing values

2023-12-10T15:22:14.970010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T15:22:15.185187image/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화장품전체전체.12012.6048
0QU2018Q1화장품전체전체3019.7788
1QU2018Q1화장품전체전체4029.9317
2QU2018Q1화장품전체전체5025.1484
3QU2018Q1화장품전체전체609.2117
4QU2018Q1화장품전체전체703.0245
5QU2018Q1화장품베이스메이크업전체201.1278
6QU2018Q1화장품베이스메이크업전체301.2766
7QU2018Q1화장품베이스메이크업전체401.383
8QU2018Q1화장품베이스메이크업전체501.4362
9QU2018Q1화장품베이스메이크업전체600.6429
QU2018Q1화장품전체전체.12012.6048
89QU2018Q1화장품색조메이크업립라이너200.0207
90QU2018Q1화장품색조메이크업립라이너300.0153
91QU2018Q1화장품색조메이크업립라이너400.0179
92QU2018Q1화장품색조메이크업립라이너500.0203
93QU2018Q1화장품색조메이크업립라이너600.0094
94QU2018Q1화장품색조메이크업립라이너700.0032
95QU2018Q1화장품색조메이크업마스카라200.2602
96QU2018Q1화장품색조메이크업마스카라300.2238
97QU2018Q1화장품색조메이크업마스카라400.253
98QU2018Q1화장품색조메이크업마스카라500.2032