Overview

Dataset statistics

Number of variables3
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.5 KiB
Average record size in memory25.3 B

Variable types

Text2
Categorical1

Alerts

제품ID has unique valuesUnique

Reproduction

Analysis started2023-12-10 11:53:26.863654
Analysis finished2023-12-10 11:53:27.511614
Duration0.65 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

제품ID
Text

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T20:53:27.925457image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length7
Mean length7
Min length7

Characters and Unicode

Total characters700
Distinct characters11
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique100 ?
Unique (%)100.0%

Sample

1st rowp000011
2nd rowp000014
3rd rowp000017
4th rowp000018
5th rowp000019
ValueCountFrequency (%)
p000011 1
 
1.0%
p000232 1
 
1.0%
p000260 1
 
1.0%
p000259 1
 
1.0%
p000258 1
 
1.0%
p000256 1
 
1.0%
p000254 1
 
1.0%
p000251 1
 
1.0%
p000247 1
 
1.0%
p000245 1
 
1.0%
Other values (90) 90
90.0%
2023-12-10T20:53:28.791903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 347
49.6%
p 100
 
14.3%
1 54
 
7.7%
2 52
 
7.4%
3 33
 
4.7%
7 26
 
3.7%
5 21
 
3.0%
6 19
 
2.7%
4 19
 
2.7%
8 15
 
2.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 600
85.7%
Lowercase Letter 100
 
14.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 347
57.8%
1 54
 
9.0%
2 52
 
8.7%
3 33
 
5.5%
7 26
 
4.3%
5 21
 
3.5%
6 19
 
3.2%
4 19
 
3.2%
8 15
 
2.5%
9 14
 
2.3%
Lowercase Letter
ValueCountFrequency (%)
p 100
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 600
85.7%
Latin 100
 
14.3%

Most frequent character per script

Common
ValueCountFrequency (%)
0 347
57.8%
1 54
 
9.0%
2 52
 
8.7%
3 33
 
5.5%
7 26
 
4.3%
5 21
 
3.5%
6 19
 
3.2%
4 19
 
3.2%
8 15
 
2.5%
9 14
 
2.3%
Latin
ValueCountFrequency (%)
p 100
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 700
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 347
49.6%
p 100
 
14.3%
1 54
 
7.7%
2 52
 
7.4%
3 33
 
4.7%
7 26
 
3.7%
5 21
 
3.0%
6 19
 
2.7%
4 19
 
2.7%
8 15
 
2.1%

제품명
Text

Distinct98
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T20:53:29.281795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length20.5
Mean length11.54
Min length2

Characters and Unicode

Total characters1154
Distinct characters224
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique96 ?
Unique (%)96.0%

Sample

1st row오키데블랑슈 룸스프레이
2nd row소이 캔들
3rd row본차이나 티라이트캔들- 바닐라
4th row캔들라이트16oz(발삼피어)
5th row바닐라 크림 티
ValueCountFrequency (%)
캔들 8
 
3.6%
인센스 6
 
2.7%
고네쉬 6
 
2.7%
소이캔들 5
 
2.2%
candle 5
 
2.2%
대나무 5
 
2.2%
미모사 5
 
2.2%
소 5
 
2.2%
중 5
 
2.2%
글라스캔들 4
 
1.8%
Other values (136) 171
76.0%
2023-12-10T20:53:30.014333image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
125
 
10.8%
들 55
 
4.8%
캔 54
 
4.7%
스 48
 
4.2%
라 39
 
3.4%
이 37
 
3.2%
트 23
 
2.0%
리 22
 
1.9%
) 19
 
1.6%
( 19
 
1.6%
Other values (214) 713
61.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 791
68.5%
Space Separator 125
 
10.8%
Uppercase Letter 78
 
6.8%
Lowercase Letter 62
 
5.4%
Decimal Number 44
 
3.8%
Close Punctuation 19
 
1.6%
Open Punctuation 19
 
1.6%
Other Punctuation 9
 
0.8%
Dash Punctuation 7
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
들 55
 
7.0%
캔 54
 
6.8%
스 48
 
6.1%
라 39
 
4.9%
이 37
 
4.7%
트 23
 
2.9%
리 22
 
2.8%
소 16
 
2.0%
드 16
 
2.0%
프 11
 
1.4%
Other values (158) 470
59.4%
Lowercase Letter
ValueCountFrequency (%)
o 13
21.0%
z 10
16.1%
l 4
 
6.5%
e 4
 
6.5%
c 3
 
4.8%
a 3
 
4.8%
u 3
 
4.8%
m 3
 
4.8%
i 2
 
3.2%
b 2
 
3.2%
Other values (11) 15
24.2%
Uppercase Letter
ValueCountFrequency (%)
A 13
16.7%
L 8
10.3%
C 8
10.3%
N 7
9.0%
E 7
9.0%
O 6
7.7%
D 6
7.7%
R 4
 
5.1%
G 3
 
3.8%
W 3
 
3.8%
Other values (8) 13
16.7%
Decimal Number
ValueCountFrequency (%)
7 8
18.2%
1 8
18.2%
8 8
18.2%
0 5
11.4%
6 4
9.1%
3 3
 
6.8%
5 3
 
6.8%
9 2
 
4.5%
4 2
 
4.5%
2 1
 
2.3%
Other Punctuation
ValueCountFrequency (%)
* 4
44.4%
. 4
44.4%
& 1
 
11.1%
Space Separator
ValueCountFrequency (%)
125
100.0%
Close Punctuation
ValueCountFrequency (%)
) 19
100.0%
Open Punctuation
ValueCountFrequency (%)
( 19
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 791
68.5%
Common 223
 
19.3%
Latin 140
 
12.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
들 55
 
7.0%
캔 54
 
6.8%
스 48
 
6.1%
라 39
 
4.9%
이 37
 
4.7%
트 23
 
2.9%
리 22
 
2.8%
소 16
 
2.0%
드 16
 
2.0%
프 11
 
1.4%
Other values (158) 470
59.4%
Latin
ValueCountFrequency (%)
o 13
 
9.3%
A 13
 
9.3%
z 10
 
7.1%
L 8
 
5.7%
C 8
 
5.7%
N 7
 
5.0%
E 7
 
5.0%
O 6
 
4.3%
D 6
 
4.3%
R 4
 
2.9%
Other values (29) 58
41.4%
Common
ValueCountFrequency (%)
125
56.1%
) 19
 
8.5%
( 19
 
8.5%
7 8
 
3.6%
1 8
 
3.6%
8 8
 
3.6%
- 7
 
3.1%
0 5
 
2.2%
6 4
 
1.8%
* 4
 
1.8%
Other values (7) 16
 
7.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 791
68.5%
ASCII 363
31.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
125
34.4%
) 19
 
5.2%
( 19
 
5.2%
o 13
 
3.6%
A 13
 
3.6%
z 10
 
2.8%
7 8
 
2.2%
L 8
 
2.2%
1 8
 
2.2%
8 8
 
2.2%
Other values (46) 132
36.4%
Hangul
ValueCountFrequency (%)
들 55
 
7.0%
캔 54
 
6.8%
스 48
 
6.1%
라 39
 
4.9%
이 37
 
4.7%
트 23
 
2.9%
리 22
 
2.8%
소 16
 
2.0%
드 16
 
2.0%
프 11
 
1.4%
Other values (158) 470
59.4%

신고번호
Categorical

Distinct43
Distinct (%)43.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
C-A09B-A301003-A150
14 
B071S095-1001
9 
C-A09B-R004010-A150
8 
C-A09B-R003019-A150
7 
C-A09B-S001124-A160
6 
Other values (38)
56 

Length

Max length20
Median length19
Mean length17.58
Min length13

Unique

Unique28 ?
Unique (%)28.0%

Sample

1st rowC-A09B-T033001-A150
2nd rowB072A251-4001
3rd rowC-A09B-R003019-A150
4th rowB071S095-1001
5th rowC-A09B-H0020001-A160

Common Values

ValueCountFrequency (%)
C-A09B-A301003-A150 14
 
14.0%
B071S095-1001 9
 
9.0%
C-A09B-R004010-A150 8
 
8.0%
C-A09B-R003019-A150 7
 
7.0%
C-A09B-S001124-A160 6
 
6.0%
F-A09B-H044001-A150 5
 
5.0%
C-A09B-H0020001-A160 4
 
4.0%
C-A09B-R011001-A150 4
 
4.0%
D-A09B-A207001-A150 3
 
3.0%
E-A09B-D002001-A150 2
 
2.0%
Other values (33) 38
38.0%

Length

2023-12-10T20:53:30.291421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
c-a09b-a301003-a150 14
 
14.0%
b071s095-1001 9
 
9.0%
c-a09b-r004010-a150 8
 
8.0%
c-a09b-r003019-a150 7
 
7.0%
c-a09b-s001124-a160 6
 
6.0%
f-a09b-h044001-a150 5
 
5.0%
c-a09b-h0020001-a160 4
 
4.0%
c-a09b-r011001-a150 4
 
4.0%
d-a09b-a207001-a150 3
 
3.0%
c-a09b-t003089-a150 2
 
2.0%
Other values (33) 38
38.0%

Correlations

2023-12-10T20:53:30.441246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
제품ID제품명신고번호
제품ID1.0001.0001.000
제품명1.0001.0000.000
신고번호1.0000.0001.000

Missing values

2023-12-10T20:53:27.316244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T20:53:27.456342image/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

제품ID제품명신고번호
0p000011오키데블랑슈 룸스프레이C-A09B-T033001-A150
1p000014소이 캔들B072A251-4001
2p000017본차이나 티라이트캔들- 바닐라C-A09B-R003019-A150
3p000018캔들라이트16oz(발삼피어)B071S095-1001
4p000019바닐라 크림 티C-A09B-H0020001-A160
5p000031컴퍼트 소 미모사C-A09B-A301003-A150
6p000033캔들F-A09B-P001001-A150
7p000039해늘 단 벚꽃C-A09B-R011001-A150
8p000047템플 스테이C-A09B-H0020001-A160
9p000055루트캔들 씨킹밸런스F-A09B-S035001-A15
제품ID제품명신고번호
90p000312Light up my lifeF-A09B-H024001-A150
91p000317캔들C-A09B-F026002-A150
92p000319캔들라이트18oz(그레이프프루)B071S095-1001
93p000320글라스캔들 6.8*8 릴리 캔들맨B074R014-4001
94p0003219온스 미모사C-A09B-A301003-A150
95p000324캔들라이트3oz초(프로스트스노우)B071S095-1001
96p000326소이캔들B071A154-4001
97p000327해늘 단 솔C-A09B-R011001-A150
98p000330베리 마리C-A09B-H0020001-A160
99p000332러스틱캔들 7*10 체리 캔들맨B074R074-5001