Overview

Dataset statistics

Number of variables4
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.1 KiB
Average record size in memory36.4 B

Variable types

Categorical2
Text1
Boolean1

Dataset

Description샘플 데이터
Author한양대
URLhttps://bigdata-region.kr/#/dataset/3822bd74-332d-43f7-b2d0-9fd68213682a

Alerts

MTCH_DGREE_CREAT_PD_DE has constant value ""Constant
VIDO_ID has unique valuesUnique

Reproduction

Analysis started2023-12-10 13:57:44.816942
Analysis finished2023-12-10 13:57:45.519864
Duration0.7 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

CHNNL_ID
Categorical

Distinct4
Distinct (%)13.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw
12 
https://www.youtube.com/channel/UC-IzDX3TIwWTgOgDpXP_g_A
8 
https://www.youtube.com/channel/UC-AuHoBXFe2e6YQ3fcA2zFA
6 
https://www.youtube.com/channel/UC-DicLNuWtiE1w16X6HkEZw
4 

Length

Max length56
Median length56
Mean length56
Min length56

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowhttps://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw
2nd rowhttps://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw
3rd rowhttps://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw
4th rowhttps://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw
5th rowhttps://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw

Common Values

ValueCountFrequency (%)
https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw 12
40.0%
https://www.youtube.com/channel/UC-IzDX3TIwWTgOgDpXP_g_A 8
26.7%
https://www.youtube.com/channel/UC-AuHoBXFe2e6YQ3fcA2zFA 6
20.0%
https://www.youtube.com/channel/UC-DicLNuWtiE1w16X6HkEZw 4
 
13.3%

Length

2023-12-10T22:57:45.644650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:57:45.835698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
https://www.youtube.com/channel/uc-8r1d-kqrzy_7-eve_w9nw 12
40.0%
https://www.youtube.com/channel/uc-izdx3tiwwtgogdpxp_g_a 8
26.7%
https://www.youtube.com/channel/uc-auhobxfe2e6yq3fca2zfa 6
20.0%
https://www.youtube.com/channel/uc-diclnuwtie1w16x6hkezw 4
 
13.3%

VIDO_ID
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-10T22:57:46.244554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length43
Median length43
Mean length43
Min length43

Characters and Unicode

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

Unique

Unique30 ?
Unique (%)100.0%

Sample

1st rowhttps://www.youtube.com/watch?v=DUagENnWtg0
2nd rowhttps://www.youtube.com/watch?v=Gj_R9rUnpPc
3rd rowhttps://www.youtube.com/watch?v=LafXbi_2JLU
4th rowhttps://www.youtube.com/watch?v=NxFLhQDPczs
5th rowhttps://www.youtube.com/watch?v=OfAljsC35z0
ValueCountFrequency (%)
https://www.youtube.com/watch?v=duagennwtg0 1
 
3.3%
https://www.youtube.com/watch?v=gj_r9runppc 1
 
3.3%
https://www.youtube.com/watch?v=vgmjyoxwn9e 1
 
3.3%
https://www.youtube.com/watch?v=vmp-s9ybcwc 1
 
3.3%
https://www.youtube.com/watch?v=k5d6ftopfjy 1
 
3.3%
https://www.youtube.com/watch?v=avpcfpyfp1c 1
 
3.3%
https://www.youtube.com/watch?v=w4m9re9j_wo 1
 
3.3%
https://www.youtube.com/watch?v=rd6t5gz1dcm 1
 
3.3%
https://www.youtube.com/watch?v=8xocre9zj5e 1
 
3.3%
https://www.youtube.com/watch?v=ydvf0qzrwb8 1
 
3.3%
Other values (20) 20
66.7%
2023-12-10T22:57:46.848361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
t 128
 
9.9%
w 124
 
9.6%
/ 90
 
7.0%
c 69
 
5.3%
o 66
 
5.1%
h 63
 
4.9%
u 61
 
4.7%
. 60
 
4.7%
v 38
 
2.9%
a 38
 
2.9%
Other values (59) 553
42.9%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 846
65.6%
Other Punctuation 210
 
16.3%
Uppercase Letter 139
 
10.8%
Decimal Number 53
 
4.1%
Math Symbol 30
 
2.3%
Connector Punctuation 9
 
0.7%
Dash Punctuation 3
 
0.2%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
t 128
15.1%
w 124
14.7%
c 69
 
8.2%
o 66
 
7.8%
h 63
 
7.4%
u 61
 
7.2%
v 38
 
4.5%
a 38
 
4.5%
s 37
 
4.4%
p 36
 
4.3%
Other values (16) 186
22.0%
Uppercase Letter
ValueCountFrequency (%)
E 9
 
6.5%
D 8
 
5.8%
W 8
 
5.8%
M 8
 
5.8%
J 8
 
5.8%
O 7
 
5.0%
X 7
 
5.0%
C 7
 
5.0%
R 7
 
5.0%
Q 7
 
5.0%
Other values (16) 63
45.3%
Decimal Number
ValueCountFrequency (%)
9 9
17.0%
1 7
13.2%
6 7
13.2%
5 6
11.3%
8 5
9.4%
0 5
9.4%
2 4
7.5%
7 4
7.5%
3 4
7.5%
4 2
 
3.8%
Other Punctuation
ValueCountFrequency (%)
/ 90
42.9%
. 60
28.6%
: 30
 
14.3%
? 30
 
14.3%
Math Symbol
ValueCountFrequency (%)
= 30
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 9
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 985
76.4%
Common 305
 
23.6%

Most frequent character per script

Latin
ValueCountFrequency (%)
t 128
 
13.0%
w 124
 
12.6%
c 69
 
7.0%
o 66
 
6.7%
h 63
 
6.4%
u 61
 
6.2%
v 38
 
3.9%
a 38
 
3.9%
s 37
 
3.8%
p 36
 
3.7%
Other values (42) 325
33.0%
Common
ValueCountFrequency (%)
/ 90
29.5%
. 60
19.7%
: 30
 
9.8%
? 30
 
9.8%
= 30
 
9.8%
_ 9
 
3.0%
9 9
 
3.0%
1 7
 
2.3%
6 7
 
2.3%
5 6
 
2.0%
Other values (7) 27
 
8.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1290
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
t 128
 
9.9%
w 124
 
9.6%
/ 90
 
7.0%
c 69
 
5.3%
o 66
 
5.1%
h 63
 
4.9%
u 61
 
4.7%
. 60
 
4.7%
v 38
 
2.9%
a 38
 
2.9%
Other values (59) 553
42.9%

MTCH_DGREE_CREAT_PD_DE
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2020-09-01
30 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2020-09-01
2nd row2020-09-01
3rd row2020-09-01
4th row2020-09-01
5th row2020-09-01

Common Values

ValueCountFrequency (%)
2020-09-01 30
100.0%

Length

2023-12-10T22:57:47.233315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:57:47.465218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020-09-01 30
100.0%

MTCH_DGREE
Boolean

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size162.0 B
True
17 
False
13 
ValueCountFrequency (%)
True 17
56.7%
False 13
43.3%
2023-12-10T22:57:47.620145image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T22:57:47.751436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
CHNNL_IDVIDO_IDMTCH_DGREE
CHNNL_ID1.0001.0000.534
VIDO_ID1.0001.0001.000
MTCH_DGREE0.5341.0001.000
2023-12-10T22:57:48.040795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
MTCH_DGREECHNNL_ID
MTCH_DGREE1.0000.347
CHNNL_ID0.3471.000
2023-12-10T22:57:48.192335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
CHNNL_IDMTCH_DGREE
CHNNL_ID1.0000.347
MTCH_DGREE0.3471.000

Missing values

2023-12-10T22:57:45.232998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T22:57:45.424721image/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

CHNNL_IDVIDO_IDMTCH_DGREE_CREAT_PD_DEMTCH_DGREE
0https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nwhttps://www.youtube.com/watch?v=DUagENnWtg02020-09-01N
1https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nwhttps://www.youtube.com/watch?v=Gj_R9rUnpPc2020-09-01Y
2https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nwhttps://www.youtube.com/watch?v=LafXbi_2JLU2020-09-01Y
3https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nwhttps://www.youtube.com/watch?v=NxFLhQDPczs2020-09-01N
4https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nwhttps://www.youtube.com/watch?v=OfAljsC35z02020-09-01N
5https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nwhttps://www.youtube.com/watch?v=SOfR93ea2Zo2020-09-01Y
6https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nwhttps://www.youtube.com/watch?v=WEtTaG75AGI2020-09-01N
7https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nwhttps://www.youtube.com/watch?v=agGnRrX_-Dw2020-09-01Y
8https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nwhttps://www.youtube.com/watch?v=bQQDWloM9sM2020-09-01N
9https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nwhttps://www.youtube.com/watch?v=cU-olu5kgVM2020-09-01N
CHNNL_IDVIDO_IDMTCH_DGREE_CREAT_PD_DEMTCH_DGREE
20https://www.youtube.com/channel/UC-DicLNuWtiE1w16X6HkEZwhttps://www.youtube.com/watch?v=THwsQnXFjpk2020-09-01Y
21https://www.youtube.com/channel/UC-DicLNuWtiE1w16X6HkEZwhttps://www.youtube.com/watch?v=yDVF0QZrwb82020-09-01Y
22https://www.youtube.com/channel/UC-IzDX3TIwWTgOgDpXP_g_Ahttps://www.youtube.com/watch?v=8XOCre9zJ5E2020-09-01Y
23https://www.youtube.com/channel/UC-IzDX3TIwWTgOgDpXP_g_Ahttps://www.youtube.com/watch?v=RD6t5Gz1dCM2020-09-01N
24https://www.youtube.com/channel/UC-IzDX3TIwWTgOgDpXP_g_Ahttps://www.youtube.com/watch?v=W4M9RE9J_Wo2020-09-01Y
25https://www.youtube.com/channel/UC-IzDX3TIwWTgOgDpXP_g_Ahttps://www.youtube.com/watch?v=avPcfpYFp1c2020-09-01Y
26https://www.youtube.com/channel/UC-IzDX3TIwWTgOgDpXP_g_Ahttps://www.youtube.com/watch?v=k5D6fTOPFJY2020-09-01Y
27https://www.youtube.com/channel/UC-IzDX3TIwWTgOgDpXP_g_Ahttps://www.youtube.com/watch?v=vMp-S9YbCWc2020-09-01Y
28https://www.youtube.com/channel/UC-IzDX3TIwWTgOgDpXP_g_Ahttps://www.youtube.com/watch?v=vgMJyOXWN9E2020-09-01N
29https://www.youtube.com/channel/UC-IzDX3TIwWTgOgDpXP_g_Ahttps://www.youtube.com/watch?v=y1SwFH6RB_A2020-09-01Y