Overview

Dataset statistics

Number of variables8
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.7 KiB
Average record size in memory68.3 B

Variable types

Categorical6
Numeric2

Dataset

DescriptionSample
Author써머스플랫폼
URLhttps://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=SMPBRANDAGE

Alerts

PRDUCT_LCLAS_NM has constant value ""Constant
PRDUCT_MLSFC_NM has constant value ""Constant
YM has constant value ""Constant
QU_SE_VALUE has constant value ""Constant
TOTAL_BRAND_RATE is highly overall correlated with PRDUCT_BRAND_NMHigh correlation
PRDUCT_BRAND_NM is highly overall correlated with TOTAL_BRAND_RATEHigh correlation

Reproduction

Analysis started2023-12-10 06:19:20.315055
Analysis finished2023-12-10 06:19:21.742905
Duration1.43 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

PRDUCT_LCLAS_NM
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
계절가전
100 

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 (%)
계절가전 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:19:22.010093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
계절가전 100
100.0%

PRDUCT_MLSFC_NM
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
공기청정기_에어워셔
100 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row공기청정기_에어워셔
2nd row공기청정기_에어워셔
3rd row공기청정기_에어워셔
4th row공기청정기_에어워셔
5th row공기청정기_에어워셔

Common Values

ValueCountFrequency (%)
공기청정기_에어워셔 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:19:22.347318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공기청정기_에어워셔 100
100.0%

YM
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
202007
100 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
202007 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:19:22.667733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
202007 100
100.0%

QU_SE_VALUE
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
20203Q
100 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
20203Q 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:19:23.077948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20203q 100
100.0%

EMPLYR_AGE
Categorical

Distinct11
Distinct (%)11.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
35~39세
15 
30~34세
14 
40~44세
14 
25~29세
12 
20~24세
10 
Other values (6)
35 

Length

Max length6
Median length6
Mean length5.97
Min length5

Unique

Unique1 ?
Unique (%)1.0%

Sample

1st row20~24세
2nd row25~29세
3rd row30~34세
4th row35~39세
5th row40~44세

Common Values

ValueCountFrequency (%)
35~39세 15
15.0%
30~34세 14
14.0%
40~44세 14
14.0%
25~29세 12
12.0%
20~24세 10
10.0%
45~49세 10
10.0%
50~54세 10
10.0%
60~64세 6
 
6.0%
55~59세 6
 
6.0%
65세이상 2
 
2.0%

Length

2023-12-10T15:19:23.228357image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
35~39세 15
15.0%
30~34세 14
14.0%
40~44세 14
14.0%
25~29세 12
12.0%
20~24세 10
10.0%
45~49세 10
10.0%
50~54세 10
10.0%
60~64세 6
 
6.0%
55~59세 6
 
6.0%
65세이상 2
 
2.0%

PRDUCT_BRAND_NM
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)17.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
샤오미
11 
한일전기
9 
동우
9 
위닉스
9 
힘펠
9 
Other values (12)
53 

Length

Max length5
Median length4
Mean length3.27
Min length2

Unique

Unique1 ?
Unique (%)1.0%

Sample

1st row퓨리케어
2nd row퓨리케어
3rd row퓨리케어
4th row퓨리케어
5th row퓨리케어

Common Values

ValueCountFrequency (%)
샤오미 11
11.0%
한일전기 9
9.0%
동우 9
9.0%
위닉스 9
9.0%
힘펠 9
9.0%
퓨리케어 8
 
8.0%
다이슨 7
 
7.0%
블루스카이 7
 
7.0%
삼지아이티 5
 
5.0%
오엘라 5
 
5.0%
Other values (7) 21
21.0%

Length

2023-12-10T15:19:23.437057image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
샤오미 11
11.0%
동우 9
9.0%
위닉스 9
9.0%
힘펠 9
9.0%
한일전기 9
9.0%
퓨리케어 8
 
8.0%
다이슨 7
 
7.0%
블루스카이 7
 
7.0%
삼성전자 5
 
5.0%
삼지아이티 5
 
5.0%
Other values (7) 21
21.0%

AGE_RATE
Real number (ℝ)

Distinct99
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean16.7263
Minimum0.27
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T15:19:23.645497image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.27
5-th percentile1.067
Q15.195
median10.225
Q323.2375
95-th percentile47.3235
Maximum100
Range99.73
Interquartile range (IQR)18.0425

Descriptive statistics

Standard deviation16.925004
Coefficient of variation (CV)1.0118797
Kurtosis5.6011989
Mean16.7263
Median Absolute Deviation (MAD)7.48
Skewness2.0049794
Sum1672.63
Variance286.45575
MonotonicityNot monotonic
2023-12-10T15:19:23.871564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2.66 2
 
2.0%
6.17 1
 
1.0%
2.67 1
 
1.0%
12.13 1
 
1.0%
9.85 1
 
1.0%
1.63 1
 
1.0%
2.02 1
 
1.0%
1.08 1
 
1.0%
10.2 1
 
1.0%
10.22 1
 
1.0%
Other values (89) 89
89.0%
ValueCountFrequency (%)
0.27 1
1.0%
0.29 1
1.0%
0.3 1
1.0%
0.74 1
1.0%
0.82 1
1.0%
1.08 1
1.0%
1.38 1
1.0%
1.48 1
1.0%
1.63 1
1.0%
1.83 1
1.0%
ValueCountFrequency (%)
100.0 1
1.0%
64.52 1
1.0%
63.65 1
1.0%
53.8 1
1.0%
48.53 1
1.0%
47.26 1
1.0%
46.59 1
1.0%
46.2 1
1.0%
42.51 1
1.0%
40.6 1
1.0%

TOTAL_BRAND_RATE
Real number (ℝ)

HIGH CORRELATION 

Distinct17
Distinct (%)17.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.3069
Minimum0.85
Maximum25.89
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T15:19:24.056879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.85
5-th percentile0.8785
Q11.16
median2.86
Q311
95-th percentile25.89
Maximum25.89
Range25.04
Interquartile range (IQR)9.84

Descriptive statistics

Standard deviation6.9577646
Coefficient of variation (CV)1.1031988
Kurtosis2.4791822
Mean6.3069
Median Absolute Deviation (MAD)1.78
Skewness1.7441388
Sum630.69
Variance48.410488
MonotonicityDecreasing
2023-12-10T15:19:24.248556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
11.67 11
11.0%
2.36 9
9.0%
3.77 9
9.0%
1.08 9
9.0%
2.67 9
9.0%
25.89 8
 
8.0%
9.02 7
 
7.0%
11.0 7
 
7.0%
1.16 5
 
5.0%
1.13 5
 
5.0%
Other values (7) 21
21.0%
ValueCountFrequency (%)
0.85 5
5.0%
0.88 2
 
2.0%
0.97 1
 
1.0%
1.08 9
9.0%
1.1 2
 
2.0%
1.13 5
5.0%
1.16 5
5.0%
2.36 9
9.0%
2.67 9
9.0%
2.86 4
4.0%
ValueCountFrequency (%)
25.89 8
8.0%
11.67 11
11.0%
11.0 7
7.0%
9.02 7
7.0%
6.35 4
 
4.0%
3.77 9
9.0%
2.89 3
 
3.0%
2.86 4
 
4.0%
2.67 9
9.0%
2.36 9
9.0%

Interactions

2023-12-10T15:19:21.020761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:19:20.664473image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:19:21.182848image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:19:20.826804image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:19:24.382801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
EMPLYR_AGEPRDUCT_BRAND_NMAGE_RATETOTAL_BRAND_RATE
EMPLYR_AGE1.0000.0000.2160.000
PRDUCT_BRAND_NM0.0001.0000.8091.000
AGE_RATE0.2160.8091.0000.000
TOTAL_BRAND_RATE0.0001.0000.0001.000
2023-12-10T15:19:24.494401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
EMPLYR_AGEPRDUCT_BRAND_NM
EMPLYR_AGE1.0000.000
PRDUCT_BRAND_NM0.0001.000
2023-12-10T15:19:24.969018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
AGE_RATETOTAL_BRAND_RATEEMPLYR_AGEPRDUCT_BRAND_NM
AGE_RATE1.000-0.1720.0960.482
TOTAL_BRAND_RATE-0.1721.0000.0000.940
EMPLYR_AGE0.0960.0001.0000.000
PRDUCT_BRAND_NM0.4820.9400.0001.000

Missing values

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

PRDUCT_LCLAS_NMPRDUCT_MLSFC_NMYMQU_SE_VALUEEMPLYR_AGEPRDUCT_BRAND_NMAGE_RATETOTAL_BRAND_RATE
0계절가전공기청정기_에어워셔20200720203Q20~24세퓨리케어6.1725.89
1계절가전공기청정기_에어워셔20200720203Q25~29세퓨리케어11.3325.89
2계절가전공기청정기_에어워셔20200720203Q30~34세퓨리케어32.025.89
3계절가전공기청정기_에어워셔20200720203Q35~39세퓨리케어8.425.89
4계절가전공기청정기_에어워셔20200720203Q40~44세퓨리케어10.2125.89
5계절가전공기청정기_에어워셔20200720203Q45~49세퓨리케어21.3125.89
6계절가전공기청정기_에어워셔20200720203Q50~54세퓨리케어4.6325.89
7계절가전공기청정기_에어워셔20200720203Q60~64세퓨리케어5.9525.89
8계절가전공기청정기_에어워셔20200720203Q20세미만샤오미0.2711.67
9계절가전공기청정기_에어워셔20200720203Q20~24세샤오미7.7911.67
PRDUCT_LCLAS_NMPRDUCT_MLSFC_NMYMQU_SE_VALUEEMPLYR_AGEPRDUCT_BRAND_NMAGE_RATETOTAL_BRAND_RATE
90계절가전공기청정기_에어워셔20200720203Q55~59세동우3.381.08
91계절가전공기청정기_에어워셔20200720203Q60~64세동우2.661.08
92계절가전공기청정기_에어워셔20200720203Q35~39세발뮤다100.00.97
93계절가전공기청정기_에어워셔20200720203Q25~29세클라윈드46.20.88
94계절가전공기청정기_에어워셔20200720203Q50~54세클라윈드53.80.88
95계절가전공기청정기_에어워셔20200720203Q20~24세삼지아이티16.630.85
96계절가전공기청정기_에어워셔20200720203Q25~29세삼지아이티12.020.85
97계절가전공기청정기_에어워셔20200720203Q30~34세삼지아이티9.20.85
98계절가전공기청정기_에어워셔20200720203Q35~39세삼지아이티26.80.85
99계절가전공기청정기_에어워셔20200720203Q40~44세삼지아이티7.950.85