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

Text2
DateTime1
Boolean1

Dataset

Description샘플 데이터
Author한양대
URLhttps://bigdata-region.kr/#/dataset/895bfa6d-526b-471e-b4b9-b7ba63b1e4ec

Alerts

일치정도생성기간일자 has constant value ""Constant
영상ID has unique valuesUnique

Reproduction

Analysis started2023-12-10 13:57:54.029149
Analysis finished2023-12-10 13:57:55.388115
Duration1.36 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

채널ID
Text

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

Length

Max length56
Median length56
Mean length56
Min length56

Characters and Unicode

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

Unique

Unique28 ?
Unique (%)93.3%

Sample

1st rowhttps://www.youtube.com/channel/UC35SH2IZCoDAyjdM_BKNVlA
2nd rowhttps://www.youtube.com/channel/UCuJz-PXNMdWQr6TNM4htENw
3rd rowhttps://www.youtube.com/channel/UCwRFj9gC3meixU8fqKJdgxA
4th rowhttps://www.youtube.com/channel/UCI110BywhJpYRC1XY_rSMiQ
5th rowhttps://www.youtube.com/channel/UCcUJw9EReJ66LYmz9ITRVEA
ValueCountFrequency (%)
https://www.youtube.com/channel/uc5hsw5oy2vfvfsihpib-avq 2
 
6.7%
https://www.youtube.com/channel/uc35sh2izcodayjdm_bknvla 1
 
3.3%
https://www.youtube.com/channel/uczupzw5idaxyp-asj__lvaa 1
 
3.3%
https://www.youtube.com/channel/uc0sfszeosuewxys7okktelq 1
 
3.3%
https://www.youtube.com/channel/uctq7fc7eny5mfwa9qd6cqca 1
 
3.3%
https://www.youtube.com/channel/ucztesxznvjwesizsccsksww 1
 
3.3%
https://www.youtube.com/channel/uczng5cv7kv4oiglgp04tsdg 1
 
3.3%
https://www.youtube.com/channel/uc1wjdw8a3hsqmoqeu79-ylw 1
 
3.3%
https://www.youtube.com/channel/uc6u126xb-cxv4h5_9wy2tga 1
 
3.3%
https://www.youtube.com/channel/uc1algbekttixzbdlx9vkboq 1
 
3.3%
Other values (19) 19
63.3%
2023-12-10T22:57:56.337109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
/ 120
 
7.1%
w 110
 
6.5%
t 98
 
5.8%
e 75
 
4.5%
u 72
 
4.3%
c 70
 
4.2%
o 69
 
4.1%
h 69
 
4.1%
n 65
 
3.9%
. 60
 
3.6%
Other values (57) 872
51.9%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 1006
59.9%
Uppercase Letter 339
 
20.2%
Other Punctuation 210
 
12.5%
Decimal Number 101
 
6.0%
Dash Punctuation 13
 
0.8%
Connector Punctuation 11
 
0.7%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
w 110
 
10.9%
t 98
 
9.7%
e 75
 
7.5%
u 72
 
7.2%
c 70
 
7.0%
o 69
 
6.9%
h 69
 
6.9%
n 65
 
6.5%
p 40
 
4.0%
a 39
 
3.9%
Other values (16) 299
29.7%
Uppercase Letter
ValueCountFrequency (%)
C 42
 
12.4%
U 39
 
11.5%
A 20
 
5.9%
Z 18
 
5.3%
V 18
 
5.3%
S 17
 
5.0%
Q 16
 
4.7%
W 15
 
4.4%
H 15
 
4.4%
M 12
 
3.5%
Other values (16) 127
37.5%
Decimal Number
ValueCountFrequency (%)
5 15
14.9%
7 13
12.9%
9 12
11.9%
0 10
9.9%
3 10
9.9%
1 10
9.9%
6 9
8.9%
2 8
7.9%
8 7
6.9%
4 7
6.9%
Other Punctuation
ValueCountFrequency (%)
/ 120
57.1%
. 60
28.6%
: 30
 
14.3%
Dash Punctuation
ValueCountFrequency (%)
- 13
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 1345
80.1%
Common 335
 
19.9%

Most frequent character per script

Latin
ValueCountFrequency (%)
w 110
 
8.2%
t 98
 
7.3%
e 75
 
5.6%
u 72
 
5.4%
c 70
 
5.2%
o 69
 
5.1%
h 69
 
5.1%
n 65
 
4.8%
C 42
 
3.1%
p 40
 
3.0%
Other values (42) 635
47.2%
Common
ValueCountFrequency (%)
/ 120
35.8%
. 60
17.9%
: 30
 
9.0%
5 15
 
4.5%
7 13
 
3.9%
- 13
 
3.9%
9 12
 
3.6%
_ 11
 
3.3%
0 10
 
3.0%
3 10
 
3.0%
Other values (5) 41
 
12.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1680
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
/ 120
 
7.1%
w 110
 
6.5%
t 98
 
5.8%
e 75
 
4.5%
u 72
 
4.3%
c 70
 
4.2%
o 69
 
4.1%
h 69
 
4.1%
n 65
 
3.9%
. 60
 
3.6%
Other values (57) 872
51.9%

영상ID
Text

UNIQUE 

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

Length

Max length43
Median length43
Mean length43
Min length43

Characters and Unicode

Total characters1290
Distinct characters68
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=blOaPH8IUkw
2nd rowhttps://www.youtube.com/watch?v=3s1aChLIaGM
3rd rowhttps://www.youtube.com/watch?v=sr39qPTXutM
4th rowhttps://www.youtube.com/watch?v=VHY9d5fB8FI
5th rowhttps://www.youtube.com/watch?v=ChaGcYuFwwM
ValueCountFrequency (%)
https://www.youtube.com/watch?v=bloaph8iukw 1
 
3.3%
https://www.youtube.com/watch?v=3s1achliagm 1
 
3.3%
https://www.youtube.com/watch?v=aaoqvwwabmw 1
 
3.3%
https://www.youtube.com/watch?v=-vcndnsztjq 1
 
3.3%
https://www.youtube.com/watch?v=hktgyea8zcw 1
 
3.3%
https://www.youtube.com/watch?v=suufzph6gi0 1
 
3.3%
https://www.youtube.com/watch?v=0eeej9-bpnw 1
 
3.3%
https://www.youtube.com/watch?v=2njswbx-44w 1
 
3.3%
https://www.youtube.com/watch?v=ukuvbderql8 1
 
3.3%
https://www.youtube.com/watch?v=qkqwhes6kc0 1
 
3.3%
Other values (20) 20
66.7%
2023-12-10T22:57:57.655070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
w 132
 
10.2%
t 124
 
9.6%
/ 90
 
7.0%
c 68
 
5.3%
u 68
 
5.3%
h 64
 
5.0%
o 63
 
4.9%
. 60
 
4.7%
s 43
 
3.3%
a 38
 
2.9%
Other values (58) 540
41.9%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 862
66.8%
Other Punctuation 210
 
16.3%
Uppercase Letter 124
 
9.6%
Decimal Number 51
 
4.0%
Math Symbol 30
 
2.3%
Connector Punctuation 8
 
0.6%
Dash Punctuation 5
 
0.4%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
I 12
 
9.7%
W 8
 
6.5%
E 8
 
6.5%
H 7
 
5.6%
Q 7
 
5.6%
P 7
 
5.6%
G 6
 
4.8%
C 6
 
4.8%
U 6
 
4.8%
M 5
 
4.0%
Other values (16) 52
41.9%
Lowercase Letter
ValueCountFrequency (%)
w 132
15.3%
t 124
14.4%
c 68
 
7.9%
u 68
 
7.9%
h 64
 
7.4%
o 63
 
7.3%
s 43
 
5.0%
a 38
 
4.4%
b 36
 
4.2%
e 36
 
4.2%
Other values (15) 190
22.0%
Decimal Number
ValueCountFrequency (%)
4 9
17.6%
6 8
15.7%
8 8
15.7%
0 7
13.7%
1 6
11.8%
9 4
7.8%
5 4
7.8%
3 2
 
3.9%
2 2
 
3.9%
7 1
 
2.0%
Other Punctuation
ValueCountFrequency (%)
/ 90
42.9%
. 60
28.6%
: 30
 
14.3%
? 30
 
14.3%
Math Symbol
ValueCountFrequency (%)
= 30
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 8
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 986
76.4%
Common 304
 
23.6%

Most frequent character per script

Latin
ValueCountFrequency (%)
w 132
13.4%
t 124
 
12.6%
c 68
 
6.9%
u 68
 
6.9%
h 64
 
6.5%
o 63
 
6.4%
s 43
 
4.4%
a 38
 
3.9%
b 36
 
3.7%
e 36
 
3.7%
Other values (41) 314
31.8%
Common
ValueCountFrequency (%)
/ 90
29.6%
. 60
19.7%
: 30
 
9.9%
? 30
 
9.9%
= 30
 
9.9%
4 9
 
3.0%
6 8
 
2.6%
8 8
 
2.6%
_ 8
 
2.6%
0 7
 
2.3%
Other values (7) 24
 
7.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1290
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
w 132
 
10.2%
t 124
 
9.6%
/ 90
 
7.0%
c 68
 
5.3%
u 68
 
5.3%
h 64
 
5.0%
o 63
 
4.9%
. 60
 
4.7%
s 43
 
3.3%
a 38
 
2.9%
Other values (58) 540
41.9%

일치정도생성기간일자
Date

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2021-04-01 00:00:00
Maximum2021-04-01 00:00:00
2023-12-10T22:57:57.869245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:57:58.015739image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

일치정도
Boolean

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size162.0 B
True
25 
False
5 
ValueCountFrequency (%)
True 25
83.3%
False 5
 
16.7%
2023-12-10T22:57:58.155556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T22:57:58.250636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
채널ID영상ID일치정도
채널ID1.0001.0001.000
영상ID1.0001.0001.000
일치정도1.0001.0001.000

Missing values

2023-12-10T22:57:55.183446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T22:57:55.330271image/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영상ID일치정도생성기간일자일치정도
0https://www.youtube.com/channel/UC35SH2IZCoDAyjdM_BKNVlAhttps://www.youtube.com/watch?v=blOaPH8IUkw2021-04-01Y
1https://www.youtube.com/channel/UCuJz-PXNMdWQr6TNM4htENwhttps://www.youtube.com/watch?v=3s1aChLIaGM2021-04-01Y
2https://www.youtube.com/channel/UCwRFj9gC3meixU8fqKJdgxAhttps://www.youtube.com/watch?v=sr39qPTXutM2021-04-01Y
3https://www.youtube.com/channel/UCI110BywhJpYRC1XY_rSMiQhttps://www.youtube.com/watch?v=VHY9d5fB8FI2021-04-01N
4https://www.youtube.com/channel/UCcUJw9EReJ66LYmz9ITRVEAhttps://www.youtube.com/watch?v=ChaGcYuFwwM2021-04-01Y
5https://www.youtube.com/channel/UCCWWpm3ZkHVckG0TMUpkGaAhttps://www.youtube.com/watch?v=PamJGLjy8_w2021-04-01Y
6https://www.youtube.com/channel/UChvW17RMwGk6UzbVu8ia5HAhttps://www.youtube.com/watch?v=vj_ws_uos002021-04-01Y
7https://www.youtube.com/channel/UCK2JegInDWoDtwEpjh4HzLghttps://www.youtube.com/watch?v=G_6dWIITMIU2021-04-01Y
8https://www.youtube.com/channel/UCWiS4vemV0wcxuxYPx9Z62ghttps://www.youtube.com/watch?v=VkC8e-xSsJ42021-04-01Y
9https://www.youtube.com/channel/UCKrhdGv0KuMwFejjCp5JZIghttps://www.youtube.com/watch?v=1781IEkOqCk2021-04-01Y
채널ID영상ID일치정도생성기간일자일치정도
20https://www.youtube.com/channel/UCOCsbaumol8qfClvZItt7-whttps://www.youtube.com/watch?v=H6pRSVSW5_E2021-04-01Y
21https://www.youtube.com/channel/UCC0hHIP7cqZZWNgKa1Ni9iwhttps://www.youtube.com/watch?v=QkQWHES6Kc02021-04-01N
22https://www.youtube.com/channel/UC1AlGbEktTiXzBdLx9vkBoQhttps://www.youtube.com/watch?v=ukuvbDerQl82021-04-01Y
23https://www.youtube.com/channel/UC6u126XB-cXV4H5_9WY2TgAhttps://www.youtube.com/watch?v=2nJswbX-44w2021-04-01Y
24https://www.youtube.com/channel/UC1wjdW8A3HSQMoQeu79-yLwhttps://www.youtube.com/watch?v=0EeEj9-BPnw2021-04-01Y
25https://www.youtube.com/channel/UCZNg5CV7KV4oIgLGP04TSdghttps://www.youtube.com/watch?v=suufzPh6gI02021-04-01N
26https://www.youtube.com/channel/UCzteSXznVjwESizsCcSKSWwhttps://www.youtube.com/watch?v=HktGyea8zcw2021-04-01Y
27https://www.youtube.com/channel/UCtQ7Fc7Eny5MfWa9QD6CqcAhttps://www.youtube.com/watch?v=-vCNDnsztjQ2021-04-01N
28https://www.youtube.com/channel/UC0sfSZeoSUeWxys7OKkTelQhttps://www.youtube.com/watch?v=AaoqVwWAbmw2021-04-01Y
29https://www.youtube.com/channel/UCVMVuH8-OLHjFx-uW_Po-RQhttps://www.youtube.com/watch?v=4gr5cHUveDA2021-04-01Y