Overview

Dataset statistics

Number of variables7
Number of observations152
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.6 KiB
Average record size in memory57.9 B

Variable types

Text4
Categorical3

Dataset

DescriptionSample
Author(주)어메이징푸드솔루션
URLhttps://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=AFS00000000000000017

Alerts

FD_INFO_SE_CODE has constant value ""Constant
FD_FILE_SN has constant value ""Constant
FD_CODE has unique valuesUnique
FD_INFO_SJ_CN has unique valuesUnique
FD_INFO_DC_CN has unique valuesUnique
FD_FILE_NM has unique valuesUnique

Reproduction

Analysis started2023-12-10 06:19:11.536269
Analysis finished2023-12-10 06:19:12.287386
Duration0.75 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

FD_CODE
Text

UNIQUE 

Distinct152
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-10T15:19:12.513986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length14
Mean length14
Min length14

Characters and Unicode

Total characters2128
Distinct characters12
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

Unique152 ?
Unique (%)100.0%

Sample

1st rowAF005110120030
2nd rowAF002110130320
3rd rowAF002110130330
4th rowAF002110130350
5th rowAF002110130360
ValueCountFrequency (%)
af005110120030 1
 
0.7%
af003130120020 1
 
0.7%
af004110110360 1
 
0.7%
af003110130120 1
 
0.7%
af003090160080 1
 
0.7%
af003090160050 1
 
0.7%
af003090160010 1
 
0.7%
af003090140200 1
 
0.7%
af003090110240 1
 
0.7%
af003110130690 1
 
0.7%
Other values (142) 142
93.4%
2023-12-10T15:19:13.105678image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 950
44.6%
1 346
 
16.3%
A 152
 
7.1%
F 152
 
7.1%
3 139
 
6.5%
2 114
 
5.4%
4 103
 
4.8%
8 47
 
2.2%
5 41
 
1.9%
6 30
 
1.4%
Other values (2) 54
 
2.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1824
85.7%
Uppercase Letter 304
 
14.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 950
52.1%
1 346
 
19.0%
3 139
 
7.6%
2 114
 
6.2%
4 103
 
5.6%
8 47
 
2.6%
5 41
 
2.2%
6 30
 
1.6%
7 28
 
1.5%
9 26
 
1.4%
Uppercase Letter
ValueCountFrequency (%)
A 152
50.0%
F 152
50.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1824
85.7%
Latin 304
 
14.3%

Most frequent character per script

Common
ValueCountFrequency (%)
0 950
52.1%
1 346
 
19.0%
3 139
 
7.6%
2 114
 
6.2%
4 103
 
5.6%
8 47
 
2.6%
5 41
 
2.2%
6 30
 
1.6%
7 28
 
1.5%
9 26
 
1.4%
Latin
ValueCountFrequency (%)
A 152
50.0%
F 152
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2128
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 950
44.6%
1 346
 
16.3%
A 152
 
7.1%
F 152
 
7.1%
3 139
 
6.5%
2 114
 
5.4%
4 103
 
4.8%
8 47
 
2.2%
5 41
 
1.9%
6 30
 
1.4%
Other values (2) 54
 
2.5%

FD_INFO_SE_CODE
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
FD_MOV
152 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
FD_MOV 152
100.0%

Length

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

Common Values (Plot)

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

FD_FILE_SN
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
1
152 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 152
100.0%

Length

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

Common Values (Plot)

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

FD_INFO_SJ_CN
Text

UNIQUE 

Distinct152
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-10T15:19:14.442535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length22
Mean length18.203947
Min length15

Characters and Unicode

Total characters2767
Distinct characters166
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique152 ?
Unique (%)100.0%

Sample

1st row신장식 파인애플드레싱양상추샐러드 3인분 동영상
2nd row저염식 얼갈이된장무침 3인분 동영상
3rd row저염식 참나물고추장무침 3인분 동영상
4th row저염식 청포묵무침 3인분 동영상
5th row저염식 청경채무침 3인분 동영상
ValueCountFrequency (%)
3인분 152
25.0%
동영상 152
25.0%
저칼로리식 67
11.0%
당뇨식 38
 
6.2%
저염식 33
 
5.4%
신장식 14
 
2.3%
애호박건새우볶음 3
 
0.5%
버섯죽 2
 
0.3%
감자국 2
 
0.3%
감자미역국 2
 
0.3%
Other values (128) 143
23.5%
2023-12-10T15:19:15.180958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
456
16.5%
153
 
5.5%
153
 
5.5%
153
 
5.5%
3 152
 
5.5%
152
 
5.5%
152
 
5.5%
152
 
5.5%
101
 
3.7%
85
 
3.1%
Other values (156) 1058
38.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2157
78.0%
Space Separator 456
 
16.5%
Decimal Number 152
 
5.5%
Close Punctuation 1
 
< 0.1%
Open Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
153
 
7.1%
153
 
7.1%
153
 
7.1%
152
 
7.0%
152
 
7.0%
152
 
7.0%
101
 
4.7%
85
 
3.9%
71
 
3.3%
67
 
3.1%
Other values (152) 918
42.6%
Space Separator
ValueCountFrequency (%)
456
100.0%
Decimal Number
ValueCountFrequency (%)
3 152
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2157
78.0%
Common 610
 
22.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
153
 
7.1%
153
 
7.1%
153
 
7.1%
152
 
7.0%
152
 
7.0%
152
 
7.0%
101
 
4.7%
85
 
3.9%
71
 
3.3%
67
 
3.1%
Other values (152) 918
42.6%
Common
ValueCountFrequency (%)
456
74.8%
3 152
 
24.9%
) 1
 
0.2%
( 1
 
0.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2157
78.0%
ASCII 610
 
22.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
456
74.8%
3 152
 
24.9%
) 1
 
0.2%
( 1
 
0.2%
Hangul
ValueCountFrequency (%)
153
 
7.1%
153
 
7.1%
153
 
7.1%
152
 
7.0%
152
 
7.0%
152
 
7.0%
101
 
4.7%
85
 
3.9%
71
 
3.3%
67
 
3.1%
Other values (152) 918
42.6%

FD_INFO_DC_CN
Text

UNIQUE 

Distinct152
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-10T15:19:15.663470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length22
Mean length18.203947
Min length15

Characters and Unicode

Total characters2767
Distinct characters166
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique152 ?
Unique (%)100.0%

Sample

1st row신장식 파인애플드레싱양상추샐러드 3인분 동영상
2nd row저염식 얼갈이된장무침 3인분 동영상
3rd row저염식 참나물고추장무침 3인분 동영상
4th row저염식 청포묵무침 3인분 동영상
5th row저염식 청경채무침 3인분 동영상
ValueCountFrequency (%)
3인분 152
25.0%
동영상 152
25.0%
저칼로리식 67
11.0%
당뇨식 38
 
6.2%
저염식 33
 
5.4%
신장식 14
 
2.3%
애호박건새우볶음 3
 
0.5%
버섯죽 2
 
0.3%
감자국 2
 
0.3%
감자미역국 2
 
0.3%
Other values (128) 143
23.5%
2023-12-10T15:19:16.345828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
456
16.5%
153
 
5.5%
153
 
5.5%
153
 
5.5%
3 152
 
5.5%
152
 
5.5%
152
 
5.5%
152
 
5.5%
101
 
3.7%
85
 
3.1%
Other values (156) 1058
38.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2157
78.0%
Space Separator 456
 
16.5%
Decimal Number 152
 
5.5%
Close Punctuation 1
 
< 0.1%
Open Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
153
 
7.1%
153
 
7.1%
153
 
7.1%
152
 
7.0%
152
 
7.0%
152
 
7.0%
101
 
4.7%
85
 
3.9%
71
 
3.3%
67
 
3.1%
Other values (152) 918
42.6%
Space Separator
ValueCountFrequency (%)
456
100.0%
Decimal Number
ValueCountFrequency (%)
3 152
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2157
78.0%
Common 610
 
22.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
153
 
7.1%
153
 
7.1%
153
 
7.1%
152
 
7.0%
152
 
7.0%
152
 
7.0%
101
 
4.7%
85
 
3.9%
71
 
3.3%
67
 
3.1%
Other values (152) 918
42.6%
Common
ValueCountFrequency (%)
456
74.8%
3 152
 
24.9%
) 1
 
0.2%
( 1
 
0.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2157
78.0%
ASCII 610
 
22.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
456
74.8%
3 152
 
24.9%
) 1
 
0.2%
( 1
 
0.2%
Hangul
ValueCountFrequency (%)
153
 
7.1%
153
 
7.1%
153
 
7.1%
152
 
7.0%
152
 
7.0%
152
 
7.0%
101
 
4.7%
85
 
3.9%
71
 
3.3%
67
 
3.1%
Other values (152) 918
42.6%
Distinct4
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
/S003/MOV
67 
/S004/MOV
38 
/S006/MOV
33 
/S005/MOV
14 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row/S005/MOV
2nd row/S006/MOV
3rd row/S006/MOV
4th row/S006/MOV
5th row/S006/MOV

Common Values

ValueCountFrequency (%)
/S003/MOV 67
44.1%
/S004/MOV 38
25.0%
/S006/MOV 33
21.7%
/S005/MOV 14
 
9.2%

Length

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

Common Values (Plot)

2023-12-10T15:19:16.803138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
s003/mov 67
44.1%
s004/mov 38
25.0%
s006/mov 33
21.7%
s005/mov 14
 
9.2%

FD_FILE_NM
Text

UNIQUE 

Distinct152
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-10T15:19:17.146841image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length20
Mean length20
Min length20

Characters and Unicode

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

Unique

Unique152 ?
Unique (%)100.0%

Sample

1st rowAF005011120060_1.mp4
2nd rowAF002110130320_1.mov
3rd rowAF002110130330_1.mov
4th rowAF002110130350_1.mov
5th rowAF002110130360_1.mov
ValueCountFrequency (%)
af005011120060_1.mp4 1
 
0.7%
af003130120020_1.mov 1
 
0.7%
af004110110360_1.mp4 1
 
0.7%
af003110130120_1.mov 1
 
0.7%
af003090160080_1.mov 1
 
0.7%
af003090160050_1.mov 1
 
0.7%
af003090160010_1.mov 1
 
0.7%
af003090140200_1.mov 1
 
0.7%
af003090110240_1.mov 1
 
0.7%
af003110130690_1.mov 1
 
0.7%
Other values (142) 142
93.4%
2023-12-10T15:19:17.721078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 954
31.4%
1 499
16.4%
4 186
 
6.1%
A 152
 
5.0%
_ 152
 
5.0%
F 152
 
5.0%
. 152
 
5.0%
m 152
 
5.0%
3 137
 
4.5%
2 114
 
3.8%
Other values (8) 390
12.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2059
67.7%
Lowercase Letter 373
 
12.3%
Uppercase Letter 304
 
10.0%
Connector Punctuation 152
 
5.0%
Other Punctuation 152
 
5.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 954
46.3%
1 499
24.2%
4 186
 
9.0%
3 137
 
6.7%
2 114
 
5.5%
8 47
 
2.3%
5 40
 
1.9%
6 31
 
1.5%
7 26
 
1.3%
9 25
 
1.2%
Lowercase Letter
ValueCountFrequency (%)
m 152
40.8%
p 83
22.3%
o 69
18.5%
v 69
18.5%
Uppercase Letter
ValueCountFrequency (%)
A 152
50.0%
F 152
50.0%
Connector Punctuation
ValueCountFrequency (%)
_ 152
100.0%
Other Punctuation
ValueCountFrequency (%)
. 152
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2363
77.7%
Latin 677
 
22.3%

Most frequent character per script

Common
ValueCountFrequency (%)
0 954
40.4%
1 499
21.1%
4 186
 
7.9%
_ 152
 
6.4%
. 152
 
6.4%
3 137
 
5.8%
2 114
 
4.8%
8 47
 
2.0%
5 40
 
1.7%
6 31
 
1.3%
Other values (2) 51
 
2.2%
Latin
ValueCountFrequency (%)
A 152
22.5%
F 152
22.5%
m 152
22.5%
p 83
12.3%
o 69
10.2%
v 69
10.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3040
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 954
31.4%
1 499
16.4%
4 186
 
6.1%
A 152
 
5.0%
_ 152
 
5.0%
F 152
 
5.0%
. 152
 
5.0%
m 152
 
5.0%
3 137
 
4.5%
2 114
 
3.8%
Other values (8) 390
12.8%

Missing values

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

FD_CODEFD_INFO_SE_CODEFD_FILE_SNFD_INFO_SJ_CNFD_INFO_DC_CNFD_INFO_STRE_COURS_NMFD_FILE_NM
0AF005110120030FD_MOV1신장식 파인애플드레싱양상추샐러드 3인분 동영상신장식 파인애플드레싱양상추샐러드 3인분 동영상/S005/MOVAF005011120060_1.mp4
1AF002110130320FD_MOV1저염식 얼갈이된장무침 3인분 동영상저염식 얼갈이된장무침 3인분 동영상/S006/MOVAF002110130320_1.mov
2AF002110130330FD_MOV1저염식 참나물고추장무침 3인분 동영상저염식 참나물고추장무침 3인분 동영상/S006/MOVAF002110130330_1.mov
3AF002110130350FD_MOV1저염식 청포묵무침 3인분 동영상저염식 청포묵무침 3인분 동영상/S006/MOVAF002110130350_1.mov
4AF002110130360FD_MOV1저염식 청경채무침 3인분 동영상저염식 청경채무침 3인분 동영상/S006/MOVAF002110130360_1.mov
5AF002110130370FD_MOV1저염식 무생채 3인분 동영상저염식 무생채 3인분 동영상/S006/MOVAF002110130370_1.mov
6AF002080120010FD_MOV1저염식 브로콜리견과류볶음 3인분 동영상저염식 브로콜리견과류볶음 3인분 동영상/S006/MOVAF002080120010_1.mov
7AF002090140010FD_MOV1저염식 곤약감자조림 3인분 동영상저염식 곤약감자조림 3인분 동영상/S006/MOVAF002090140010_1.mov
8AF002120110010FD_MOV1저염식 저염겉절이 3인분 동영상저염식 저염겉절이 3인분 동영상/S006/MOVAF002120110010_1.mov
9AF002110130080FD_MOV1저염식 아욱된장무침 3인분 동영상저염식 아욱된장무침 3인분 동영상/S006/MOVAF002110130080_1.mov
FD_CODEFD_INFO_SE_CODEFD_FILE_SNFD_INFO_SJ_CNFD_INFO_DC_CNFD_INFO_STRE_COURS_NMFD_FILE_NM
142AF004080150010FD_MOV1당뇨식 감자어묵볶음 3인분 동영상당뇨식 감자어묵볶음 3인분 동영상/S004/MOVAF004080150010_1.mp4
143AF004090120010FD_MOV1당뇨식 감자메추리알조림 3인분 동영상당뇨식 감자메추리알조림 3인분 동영상/S004/MOVAF004090120010_1.mp4
144AF004090130010FD_MOV1당뇨식 돼지고기장조림 3인분 동영상당뇨식 돼지고기장조림 3인분 동영상/S004/MOVAF004090130010_1.mp4
145AF004080120120FD_MOV1당뇨식 감자채볶음 3인분 동영상당뇨식 감자채볶음 3인분 동영상/S004/MOVAF004080120120_1.mp4
146AF004080120150FD_MOV1당뇨식 감자풋고추볶음 3인분 동영상당뇨식 감자풋고추볶음 3인분 동영상/S004/MOVAF004080120150_1.mp4
147AF005080120050FD_MOV1신장식 표고피망볶음 3인분 동영상신장식 표고피망볶음 3인분 동영상/S005/MOVAF005080120050_1.mp4
148AF005080120060FD_MOV1신장식 무볶음 3인분 동영상신장식 무볶음 3인분 동영상/S005/MOVAF005080120060_1.mp4
149AF005070140010FD_MOV1신장식 파프리카후라이 3인분 동영상신장식 파프리카후라이 3인분 동영상/S005/MOVAF005010140010_1.mp4
150AF005070110110FD_MOV1신장식 오징어전 3인분 동영상신장식 오징어전 3인분 동영상/S005/MOVAF005007110010_1.mp4
151AF005110120270FD_MOV1신장식 당근샐러드 3인분 동영상신장식 당근샐러드 3인분 동영상/S005/MOVAF005011120010_1.mp4