Overview

Dataset statistics

Number of variables5
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 KiB
Average record size in memory44.4 B

Variable types

Categorical2
DateTime1
Text2

Dataset

Description샘플 데이터
Author한양대
URLhttps://bigdata-region.kr/#/dataset/499b3a0c-1e3a-4a18-b9c4-3e389ef305c7

Alerts

CHNNL_CHNNL_PATH has constant value ""Constant
RELATE_CHNNL_COLCT_DE has constant value ""Constant
RELATE_CHNNL_CHNNL_NM has constant value ""Constant
CHNNL_RELATE_CHNNL_NM has unique valuesUnique
RELATE_CHNNL_PATH has unique valuesUnique

Reproduction

Analysis started2023-12-10 13:58:07.647978
Analysis finished2023-12-10 13:58:08.297173
Duration0.65 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

CHNNL_CHNNL_PATH
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA
30 

Length

Max length56
Median length56
Mean length56
Min length56

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowhttps://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA
2nd rowhttps://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA
3rd rowhttps://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA
4th rowhttps://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA
5th rowhttps://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA

Common Values

ValueCountFrequency (%)
https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA 30
100.0%

Length

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

Common Values (Plot)

2023-12-10T22:58:08.695188image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
https://www.youtube.com/channel/uctn6nchey0tar6cy652cfra 30
100.0%

RELATE_CHNNL_COLCT_DE
Date

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2020-09-01 00:00:00
Maximum2020-09-01 00:00:00
2023-12-10T22:58:08.823578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:58:08.969898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)
Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-10T22:58:09.288421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length16.5
Mean length9.3333333
Min length2

Characters and Unicode

Total characters280
Distinct characters125
Distinct categories6 ?
Distinct scripts3 ?
Distinct blocks3 ?
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 rowHY TV
2nd row리그오브레전드 All VOD
3rd row손가락TV
4th rowKoshali production
5th row우크라이나 채널TV
ValueCountFrequency (%)
tv 2
 
3.9%
hy 1
 
2.0%
chio치오 1
 
2.0%
root 1
 
2.0%
to 1
 
2.0%
fruit 1
 
2.0%
청주메주 1
 
2.0%
매스티지헤어-영혼을 1
 
2.0%
담아 1
 
2.0%
아름답게 1
 
2.0%
Other values (40) 40
78.4%
2023-12-10T22:58:09.828274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
21
 
7.5%
o 14
 
5.0%
l 13
 
4.6%
T 10
 
3.6%
V 10
 
3.6%
a 9
 
3.2%
i 8
 
2.9%
u 8
 
2.9%
t 7
 
2.5%
n 7
 
2.5%
Other values (115) 173
61.8%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 100
35.7%
Other Letter 97
34.6%
Uppercase Letter 57
20.4%
Space Separator 21
 
7.5%
Other Punctuation 4
 
1.4%
Dash Punctuation 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
4
 
4.1%
3
 
3.1%
3
 
3.1%
2
 
2.1%
2
 
2.1%
2
 
2.1%
2
 
2.1%
2
 
2.1%
2
 
2.1%
2
 
2.1%
Other values (72) 73
75.3%
Lowercase Letter
ValueCountFrequency (%)
o 14
14.0%
l 13
13.0%
a 9
9.0%
i 8
 
8.0%
u 8
 
8.0%
t 7
 
7.0%
n 7
 
7.0%
m 5
 
5.0%
r 4
 
4.0%
s 4
 
4.0%
Other values (10) 21
21.0%
Uppercase Letter
ValueCountFrequency (%)
T 10
17.5%
V 10
17.5%
H 5
8.8%
A 4
 
7.0%
O 4
 
7.0%
R 3
 
5.3%
Y 3
 
5.3%
L 2
 
3.5%
K 2
 
3.5%
M 2
 
3.5%
Other values (9) 12
21.1%
Other Punctuation
ValueCountFrequency (%)
' 2
50.0%
. 2
50.0%
Space Separator
ValueCountFrequency (%)
21
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 157
56.1%
Hangul 97
34.6%
Common 26
 
9.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
4
 
4.1%
3
 
3.1%
3
 
3.1%
2
 
2.1%
2
 
2.1%
2
 
2.1%
2
 
2.1%
2
 
2.1%
2
 
2.1%
2
 
2.1%
Other values (72) 73
75.3%
Latin
ValueCountFrequency (%)
o 14
 
8.9%
l 13
 
8.3%
T 10
 
6.4%
V 10
 
6.4%
a 9
 
5.7%
i 8
 
5.1%
u 8
 
5.1%
t 7
 
4.5%
n 7
 
4.5%
H 5
 
3.2%
Other values (29) 66
42.0%
Common
ValueCountFrequency (%)
21
80.8%
' 2
 
7.7%
. 2
 
7.7%
- 1
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 183
65.4%
Hangul 93
33.2%
Compat Jamo 4
 
1.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
21
 
11.5%
o 14
 
7.7%
l 13
 
7.1%
T 10
 
5.5%
V 10
 
5.5%
a 9
 
4.9%
i 8
 
4.4%
u 8
 
4.4%
t 7
 
3.8%
n 7
 
3.8%
Other values (33) 76
41.5%
Hangul
ValueCountFrequency (%)
4
 
4.3%
3
 
3.2%
3
 
3.2%
2
 
2.2%
2
 
2.2%
2
 
2.2%
2
 
2.2%
2
 
2.2%
2
 
2.2%
2
 
2.2%
Other values (68) 69
74.2%
Compat Jamo
ValueCountFrequency (%)
1
25.0%
1
25.0%
1
25.0%
1
25.0%

RELATE_CHNNL_CHNNL_NM
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
채널김여사 [Travel & Food]
30 

Length

Max length21
Median length21
Mean length21
Min length21

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row채널김여사 [Travel & Food]
2nd row채널김여사 [Travel & Food]
3rd row채널김여사 [Travel & Food]
4th row채널김여사 [Travel & Food]
5th row채널김여사 [Travel & Food]

Common Values

ValueCountFrequency (%)
채널김여사 [Travel & Food] 30
100.0%

Length

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

Common Values (Plot)

2023-12-10T22:58:10.187019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
채널김여사 30
25.0%
travel 30
25.0%
30
25.0%
food 30
25.0%

RELATE_CHNNL_PATH
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-10T22:58:10.641589image/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

Unique30 ?
Unique (%)100.0%

Sample

1st rowhttps://www.youtube.com/channel/UC1KKeNbMPt2C7IUJeeiRUuA
2nd rowhttps://www.youtube.com/channel/UC2RrCh4xamaLC9GlMEqzigw
3rd rowhttps://www.youtube.com/channel/UCQ2Sisym1oj5p3QN0aFBW6A
4th rowhttps://www.youtube.com/channel/UCqm0tZmveU1gQsY0FJhLyJA
5th rowhttps://www.youtube.com/channel/UCWhGz9d9ciLh0_VboTCQiSw
ValueCountFrequency (%)
https://www.youtube.com/channel/uc1kkenbmpt2c7iujeeiruua 1
 
3.3%
https://www.youtube.com/channel/uc2rrch4xamalc9glmeqzigw 1
 
3.3%
https://www.youtube.com/channel/uc4ip0-gibdsplagtjaypfdq 1
 
3.3%
https://www.youtube.com/channel/uc4utpkphi-wirzp7q8hz_2g 1
 
3.3%
https://www.youtube.com/channel/ucde9jrs95tw1azr_coq_8oa 1
 
3.3%
https://www.youtube.com/channel/uc7o6rsajo3dv5ywwnhj3ebw 1
 
3.3%
https://www.youtube.com/channel/ucmesu7trlxjncgfqlgnqt0a 1
 
3.3%
https://www.youtube.com/channel/ucpgihhooqi6xk0d20wvd-ww 1
 
3.3%
https://www.youtube.com/channel/ucorbmcy1cugzdjdrjiudw6g 1
 
3.3%
https://www.youtube.com/channel/uchkadiey22cakjirda0ty5g 1
 
3.3%
Other values (20) 20
66.7%
2023-12-10T22:58:11.257294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
/ 120
 
7.1%
w 106
 
6.3%
t 103
 
6.1%
h 78
 
4.6%
e 74
 
4.4%
o 73
 
4.3%
c 71
 
4.2%
n 67
 
4.0%
u 65
 
3.9%
. 60
 
3.6%
Other values (57) 863
51.4%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 1016
60.5%
Uppercase Letter 332
 
19.8%
Other Punctuation 210
 
12.5%
Decimal Number 99
 
5.9%
Connector Punctuation 14
 
0.8%
Dash Punctuation 9
 
0.5%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
w 106
 
10.4%
t 103
 
10.1%
h 78
 
7.7%
e 74
 
7.3%
o 73
 
7.2%
c 71
 
7.0%
n 67
 
6.6%
u 65
 
6.4%
m 42
 
4.1%
a 39
 
3.8%
Other values (16) 298
29.3%
Uppercase Letter
ValueCountFrequency (%)
U 41
 
12.3%
C 40
 
12.0%
Q 17
 
5.1%
A 16
 
4.8%
Y 15
 
4.5%
H 14
 
4.2%
R 14
 
4.2%
E 13
 
3.9%
D 13
 
3.9%
J 13
 
3.9%
Other values (16) 136
41.0%
Decimal Number
ValueCountFrequency (%)
9 14
14.1%
2 14
14.1%
7 13
13.1%
0 11
11.1%
3 9
9.1%
1 9
9.1%
5 9
9.1%
4 8
8.1%
6 7
7.1%
8 5
 
5.1%
Other Punctuation
ValueCountFrequency (%)
/ 120
57.1%
. 60
28.6%
: 30
 
14.3%
Connector Punctuation
ValueCountFrequency (%)
_ 14
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 9
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 1348
80.2%
Common 332
 
19.8%

Most frequent character per script

Latin
ValueCountFrequency (%)
w 106
 
7.9%
t 103
 
7.6%
h 78
 
5.8%
e 74
 
5.5%
o 73
 
5.4%
c 71
 
5.3%
n 67
 
5.0%
u 65
 
4.8%
m 42
 
3.1%
U 41
 
3.0%
Other values (42) 628
46.6%
Common
ValueCountFrequency (%)
/ 120
36.1%
. 60
18.1%
: 30
 
9.0%
9 14
 
4.2%
2 14
 
4.2%
_ 14
 
4.2%
7 13
 
3.9%
0 11
 
3.3%
3 9
 
2.7%
1 9
 
2.7%
Other values (5) 38
 
11.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1680
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
/ 120
 
7.1%
w 106
 
6.3%
t 103
 
6.1%
h 78
 
4.6%
e 74
 
4.4%
o 73
 
4.3%
c 71
 
4.2%
n 67
 
4.0%
u 65
 
3.9%
. 60
 
3.6%
Other values (57) 863
51.4%

Correlations

2023-12-10T22:58:11.460008image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
CHNNL_RELATE_CHNNL_NMRELATE_CHNNL_PATH
CHNNL_RELATE_CHNNL_NM1.0001.000
RELATE_CHNNL_PATH1.0001.000

Missing values

2023-12-10T22:58:08.027000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T22:58:08.201208image/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_CHNNL_PATHRELATE_CHNNL_COLCT_DECHNNL_RELATE_CHNNL_NMRELATE_CHNNL_CHNNL_NMRELATE_CHNNL_PATH
0https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01HY TV채널김여사 [Travel & Food]https://www.youtube.com/channel/UC1KKeNbMPt2C7IUJeeiRUuA
1https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01리그오브레전드 All VOD채널김여사 [Travel & Food]https://www.youtube.com/channel/UC2RrCh4xamaLC9GlMEqzigw
2https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01손가락TV채널김여사 [Travel & Food]https://www.youtube.com/channel/UCQ2Sisym1oj5p3QN0aFBW6A
3https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01Koshali production채널김여사 [Travel & Food]https://www.youtube.com/channel/UCqm0tZmveU1gQsY0FJhLyJA
4https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01우크라이나 채널TV채널김여사 [Travel & Food]https://www.youtube.com/channel/UCWhGz9d9ciLh0_VboTCQiSw
5https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01허인채널김여사 [Travel & Food]https://www.youtube.com/channel/UCeTm1KS5Mg9Ee_7YiORLEKQ
6https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01FollowTheSun채널김여사 [Travel & Food]https://www.youtube.com/channel/UC8e2h-L0hDwDjV-HqET9NPw
7https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01Mila Vlog채널김여사 [Travel & Food]https://www.youtube.com/channel/UCBjyDG2sh-rpt7e5EXzvYKQ
8https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01Relaxing ASMR채널김여사 [Travel & Food]https://www.youtube.com/channel/UCqC2H_OD5jPA6HSDxo_UdYg
9https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01봉쓰TV채널김여사 [Travel & Food]https://www.youtube.com/channel/UC1X7CFN-JHmzRXSTAQLK8HA
CHNNL_CHNNL_PATHRELATE_CHNNL_COLCT_DECHNNL_RELATE_CHNNL_NMRELATE_CHNNL_CHNNL_NMRELATE_CHNNL_PATH
20https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01매스티지헤어-영혼을 담아 아름답게 해줄께채널김여사 [Travel & Food]https://www.youtube.com/channel/UCvnHgPgqPtuKTZjMh49YZmQ
21https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01Hasnajud Alim채널김여사 [Travel & Food]https://www.youtube.com/channel/UCHkaDieY22cakjiRDa0Ty5g
22https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01CHIO치오채널김여사 [Travel & Food]https://www.youtube.com/channel/UCoRbmCy1cUgZdJDRJIuDW6g
23https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01로로TV LOLO채널김여사 [Travel & Food]https://www.youtube.com/channel/UCPgihHoOqi6xk0D20WVd-Ww
24https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01몽부부TV채널김여사 [Travel & Food]https://www.youtube.com/channel/UCmEsU7tRlxJncgFqlgnqT0A
25https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01슈퍼미니카채널김여사 [Travel & Food]https://www.youtube.com/channel/UC7O6RsAjo3Dv5YwwnhJ3ebw
26https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01호주 에밀리Australia Emily채널김여사 [Travel & Food]https://www.youtube.com/channel/UCDE9JRs95tW1AZR_coq_8oA
27https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01유튜브영원채널김여사 [Travel & Food]https://www.youtube.com/channel/UC4UTPKphi-wiRZP7Q8hZ_2g
28https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01행다맘plantmom채널김여사 [Travel & Food]https://www.youtube.com/channel/UC4ip0-GibdsplaGtJAYPFdQ
29https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-09-01최성애 시인TX Poet채널김여사 [Travel & Food]https://www.youtube.com/channel/UCY2hZbdeAnKjl1QouBv0KYg