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/33d29792-1565-4781-9d1e-64104177c9ab

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 14:24:02.345312
Analysis finished2023-12-10 14:24:02.672457
Duration0.33 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-10T23:24:02.732023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:24:02.826560image/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-10-01 00:00:00
Maximum2020-10-01 00:00:00
2023-12-10T23:24:02.924850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:24:03.035174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

CHNNL_RELATE_CHNNL_NM
Text

UNIQUE 

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

Length

Max length22
Median length14
Mean length9.9666667
Min length2

Characters and Unicode

Total characters299
Distinct characters128
Distinct categories7 ?
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.8%
to 1
 
1.9%
fruit 1
 
1.9%
청주메주 1
 
1.9%
매스티지헤어-영혼을 1
 
1.9%
담아 1
 
1.9%
아름답게 1
 
1.9%
해줄께 1
 
1.9%
hasnajud 1
 
1.9%
alim 1
 
1.9%
Other values (41) 41
78.8%
2023-12-10T23:24:03.584176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
22
 
7.4%
o 17
 
5.7%
T 12
 
4.0%
V 11
 
3.7%
l 11
 
3.7%
a 9
 
3.0%
t 8
 
2.7%
u 8
 
2.7%
n 7
 
2.3%
i 7
 
2.3%
Other values (118) 187
62.5%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 104
34.8%
Other Letter 103
34.4%
Uppercase Letter 63
21.1%
Space Separator 22
 
7.4%
Other Punctuation 4
 
1.3%
Connector Punctuation 2
 
0.7%
Dash Punctuation 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
리 4
 
3.9%
주 3
 
2.9%
인 3
 
2.9%
아 2
 
1.9%
영 2
 
1.9%
로 2
 
1.9%
부 2
 
1.9%
파 2
 
1.9%
여 2
 
1.9%
호 2
 
1.9%
Other values (74) 79
76.7%
Lowercase Letter
ValueCountFrequency (%)
o 17
16.3%
l 11
10.6%
a 9
8.7%
t 8
 
7.7%
u 8
 
7.7%
n 7
 
6.7%
i 7
 
6.7%
e 5
 
4.8%
r 5
 
4.8%
m 5
 
4.8%
Other values (10) 22
21.2%
Uppercase Letter
ValueCountFrequency (%)
T 12
19.0%
V 11
17.5%
H 6
9.5%
O 5
7.9%
Y 4
 
6.3%
A 4
 
6.3%
D 3
 
4.8%
R 3
 
4.8%
L 2
 
3.2%
S 2
 
3.2%
Other values (9) 11
17.5%
Other Punctuation
ValueCountFrequency (%)
. 2
50.0%
' 2
50.0%
Space Separator
ValueCountFrequency (%)
22
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 2
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 167
55.9%
Hangul 103
34.4%
Common 29
 
9.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
리 4
 
3.9%
주 3
 
2.9%
인 3
 
2.9%
아 2
 
1.9%
영 2
 
1.9%
로 2
 
1.9%
부 2
 
1.9%
파 2
 
1.9%
여 2
 
1.9%
호 2
 
1.9%
Other values (74) 79
76.7%
Latin
ValueCountFrequency (%)
o 17
 
10.2%
T 12
 
7.2%
V 11
 
6.6%
l 11
 
6.6%
a 9
 
5.4%
t 8
 
4.8%
u 8
 
4.8%
n 7
 
4.2%
i 7
 
4.2%
H 6
 
3.6%
Other values (29) 71
42.5%
Common
ValueCountFrequency (%)
22
75.9%
. 2
 
6.9%
' 2
 
6.9%
_ 2
 
6.9%
- 1
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 196
65.6%
Hangul 99
33.1%
Compat Jamo 4
 
1.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
22
 
11.2%
o 17
 
8.7%
T 12
 
6.1%
V 11
 
5.6%
l 11
 
5.6%
a 9
 
4.6%
t 8
 
4.1%
u 8
 
4.1%
n 7
 
3.6%
i 7
 
3.6%
Other values (34) 84
42.9%
Hangul
ValueCountFrequency (%)
리 4
 
4.0%
주 3
 
3.0%
인 3
 
3.0%
아 2
 
2.0%
영 2
 
2.0%
로 2
 
2.0%
부 2
 
2.0%
파 2
 
2.0%
여 2
 
2.0%
호 2
 
2.0%
Other values (70) 75
75.8%
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-10T23:24:03.711024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:24:04.061936image/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-10T23:24:04.310929image/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/ucl1itz04v-t6y6wcxytqokw 1
 
3.3%
https://www.youtube.com/channel/ucy2hzbdeankjl1qoubv0kyg 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/ucmesu7trlxjncgfqlgnqt0a 1
 
3.3%
https://www.youtube.com/channel/ucpgihhooqi6xk0d20wvd-ww 1
 
3.3%
https://www.youtube.com/channel/ucorbmcy1cugzdjdrjiudw6g 1
 
3.3%
Other values (20) 20
66.7%
2023-12-10T23:24:04.717861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
/ 120
 
7.1%
w 104
 
6.2%
t 103
 
6.1%
h 76
 
4.5%
o 73
 
4.3%
e 72
 
4.3%
c 72
 
4.3%
u 66
 
3.9%
n 66
 
3.9%
. 60
 
3.6%
Other values (57) 868
51.7%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 1009
60.1%
Uppercase Letter 340
 
20.2%
Other Punctuation 210
 
12.5%
Decimal Number 98
 
5.8%
Connector Punctuation 14
 
0.8%
Dash Punctuation 9
 
0.5%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
w 104
 
10.3%
t 103
 
10.2%
h 76
 
7.5%
o 73
 
7.2%
e 72
 
7.1%
c 72
 
7.1%
u 66
 
6.5%
n 66
 
6.5%
m 42
 
4.2%
l 39
 
3.9%
Other values (16) 296
29.3%
Uppercase Letter
ValueCountFrequency (%)
U 41
 
12.1%
C 40
 
11.8%
Q 18
 
5.3%
A 16
 
4.7%
H 15
 
4.4%
Y 15
 
4.4%
R 14
 
4.1%
J 12
 
3.5%
D 12
 
3.5%
P 12
 
3.5%
Other values (16) 145
42.6%
Decimal Number
ValueCountFrequency (%)
9 14
14.3%
2 14
14.3%
0 12
12.2%
7 11
11.2%
1 10
10.2%
4 9
9.2%
6 8
8.2%
3 7
7.1%
5 7
7.1%
8 6
6.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 1349
80.3%
Common 331
 
19.7%

Most frequent character per script

Latin
ValueCountFrequency (%)
w 104
 
7.7%
t 103
 
7.6%
h 76
 
5.6%
o 73
 
5.4%
e 72
 
5.3%
c 72
 
5.3%
u 66
 
4.9%
n 66
 
4.9%
m 42
 
3.1%
U 41
 
3.0%
Other values (42) 634
47.0%
Common
ValueCountFrequency (%)
/ 120
36.3%
. 60
18.1%
: 30
 
9.1%
9 14
 
4.2%
_ 14
 
4.2%
2 14
 
4.2%
0 12
 
3.6%
7 11
 
3.3%
1 10
 
3.0%
- 9
 
2.7%
Other values (5) 37
 
11.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1680
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
/ 120
 
7.1%
w 104
 
6.2%
t 103
 
6.1%
h 76
 
4.5%
o 73
 
4.3%
e 72
 
4.3%
c 72
 
4.3%
u 66
 
3.9%
n 66
 
3.9%
. 60
 
3.6%
Other values (57) 868
51.7%

Correlations

2023-12-10T23:24:04.815005image/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-10T23:24:02.531121image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T23:24:02.637007image/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-10-01HY TV채널김여사 [Travel & Food]https://www.youtube.com/channel/UC1KKeNbMPt2C7IUJeeiRUuA
1https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01리그오브레전드 All VOD채널김여사 [Travel & Food]https://www.youtube.com/channel/UC2RrCh4xamaLC9GlMEqzigw
2https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01손가락TV채널김여사 [Travel & Food]https://www.youtube.com/channel/UCQ2Sisym1oj5p3QN0aFBW6A
3https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01Koshali production채널김여사 [Travel & Food]https://www.youtube.com/channel/UCqm0tZmveU1gQsY0FJhLyJA
4https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01우크라이나 채널TV채널김여사 [Travel & Food]https://www.youtube.com/channel/UCWhGz9d9ciLh0_VboTCQiSw
5https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01허인채널김여사 [Travel & Food]https://www.youtube.com/channel/UCeTm1KS5Mg9Ee_7YiORLEKQ
6https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01FollowTheSun채널김여사 [Travel & Food]https://www.youtube.com/channel/UC8e2h-L0hDwDjV-HqET9NPw
7https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01Relaxing ASMR채널김여사 [Travel & Food]https://www.youtube.com/channel/UCqC2H_OD5jPA6HSDxo_UdYg
8https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01봉쓰TV채널김여사 [Travel & Food]https://www.youtube.com/channel/UC1X7CFN-JHmzRXSTAQLK8HA
9https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01여울Yeoul채널김여사 [Travel & Food]https://www.youtube.com/channel/UCvqGspPd797fKyzQHHFEkOA
CHNNL_CHNNL_PATHRELATE_CHNNL_COLCT_DECHNNL_RELATE_CHNNL_NMRELATE_CHNNL_CHNNL_NMRELATE_CHNNL_PATH
20https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01Hasnajud Alim채널김여사 [Travel & Food]https://www.youtube.com/channel/UCHkaDieY22cakjiRDa0Ty5g
21https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01CHIO치오채널김여사 [Travel & Food]https://www.youtube.com/channel/UCoRbmCy1cUgZdJDRJIuDW6g
22https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01로로TV LOLO채널김여사 [Travel & Food]https://www.youtube.com/channel/UCPgihHoOqi6xk0D20WVd-Ww
23https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01몽부부TV채널김여사 [Travel & Food]https://www.youtube.com/channel/UCmEsU7tRlxJncgFqlgnqT0A
24https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01호주 에밀리Australia Emily채널김여사 [Travel & Food]https://www.youtube.com/channel/UCDE9JRs95tW1AZR_coq_8oA
25https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01유튜브영원채널김여사 [Travel & Food]https://www.youtube.com/channel/UC4UTPKphi-wiRZP7Q8hZ_2g
26https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01행다맘plantmom채널김여사 [Travel & Food]https://www.youtube.com/channel/UC4ip0-GibdsplaGtJAYPFdQ
27https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01최성애 시인TX Poet채널김여사 [Travel & Food]https://www.youtube.com/channel/UCY2hZbdeAnKjl1QouBv0KYg
28https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01Doctor Oedo 거제도여행박사TV채널김여사 [Travel & Food]https://www.youtube.com/channel/UCl1ITZ04v-T6y6WcXYtQoKw
29https://www.youtube.com/channel/UCtN6NCHey0taR6cY652CFRA2020-10-01호야티비_HoYa_TV채널김여사 [Travel & Food]https://www.youtube.com/channel/UCQY8HVdlKvvdZR2BMSDquPA