Overview

Dataset statistics

Number of variables6
Number of observations28
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.4 KiB
Average record size in memory52.7 B

Variable types

DateTime1
Categorical3
Text2

Dataset

Description샘플 데이터
Author한양대
URLhttps://bigdata-region.kr/#/dataset/624bba04-c0c3-4cbe-92a4-050c611428b5

Alerts

이용자감성수집일자 has constant value ""Constant
이용자감성채널ID has constant value ""Constant
ID has unique valuesUnique
설명 has unique valuesUnique

Reproduction

Analysis started2023-12-10 14:07:20.548282
Analysis finished2023-12-10 14:07:21.432598
Duration0.88 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct1
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size356.0 B
Minimum2021-01-01 00:00:00
Maximum2021-01-01 00:00:00
2023-12-10T23:07:21.499813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:07:21.610743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

이용자감성채널ID
Categorical

CONSTANT 

Distinct1
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size356.0 B
https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQ
28 

Length

Max length56
Median length56
Mean length56
Min length56

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQ 28
100.0%

Length

2023-12-10T23:07:21.759075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:07:21.862278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
https://www.youtube.com/channel/uc5hsw5oy2vfvfsihpib-avq 28
100.0%
Distinct4
Distinct (%)14.3%
Missing0
Missing (%)0.0%
Memory size356.0 B
https://www.youtube.com/watch?v=Z1owIdkxMxw
16 
https://www.youtube.com/watch?v=Z32ivbYfqnM
https://www.youtube.com/watch?v=Z1Yami73l1c
https://www.youtube.com/watch?v=Z2V4Wusc4tY
 
1

Length

Max length43
Median length43
Mean length43
Min length43

Unique

Unique1 ?
Unique (%)3.6%

Sample

1st rowhttps://www.youtube.com/watch?v=Z1Yami73l1c
2nd rowhttps://www.youtube.com/watch?v=Z1Yami73l1c
3rd rowhttps://www.youtube.com/watch?v=Z1Yami73l1c
4th rowhttps://www.youtube.com/watch?v=Z1Yami73l1c
5th rowhttps://www.youtube.com/watch?v=Z1Yami73l1c

Common Values

ValueCountFrequency (%)
https://www.youtube.com/watch?v=Z1owIdkxMxw 16
57.1%
https://www.youtube.com/watch?v=Z32ivbYfqnM 6
 
21.4%
https://www.youtube.com/watch?v=Z1Yami73l1c 5
 
17.9%
https://www.youtube.com/watch?v=Z2V4Wusc4tY 1
 
3.6%

Length

2023-12-10T23:07:21.990416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:07:22.486548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
https://www.youtube.com/watch?v=z1owidkxmxw 16
57.1%
https://www.youtube.com/watch?v=z32ivbyfqnm 6
 
21.4%
https://www.youtube.com/watch?v=z1yami73l1c 5
 
17.9%
https://www.youtube.com/watch?v=z2v4wusc4ty 1
 
3.6%

ID
Text

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size356.0 B
2023-12-10T23:07:22.835408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length26
Mean length24.714286
Min length20

Characters and Unicode

Total characters692
Distinct characters64
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

Unique28 ?
Unique (%)100.0%

Sample

1st rowUgy6TXaA8qz8YfmggDJ4AaABAg
2nd rowUgyuBguNqYymbCiTsMV4AaABAg
3rd rowUgzALIGvBfOWiU0wuol4AaABAg
4th rowUgz3KtOX6iEdx-y2IVx4AaABAg
5th rowUgzgrdY7V5DZUG66ED54AaABAg
ValueCountFrequency (%)
ugy6txaa8qz8yfmggdj4aaabag 1
 
3.6%
ugyubgunqyymbcitsmv4aaabag 1
 
3.6%
ughmtifph19k1ngcoaec 1
 
3.6%
ugh7ceiiowcfjngcoaec 1
 
3.6%
uggalh3k4xeydngcoaec 1
 
3.6%
ugh5ngf4dp7azngcoaec 1
 
3.6%
uggw61nni7isihgcoaec 1
 
3.6%
ugxscbmc17hrapt1_lb4aaabag 1
 
3.6%
ugzbwn3u3otpikk9awb4aaabag 1
 
3.6%
ugzzcuwx9zgxuaolpan4aaabag 1
 
3.6%
Other values (18) 18
64.3%
2023-12-10T23:07:23.573514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
A 80
 
11.6%
g 64
 
9.2%
U 33
 
4.8%
B 32
 
4.6%
a 29
 
4.2%
4 26
 
3.8%
x 16
 
2.3%
C 16
 
2.3%
o 14
 
2.0%
w 14
 
2.0%
Other values (54) 368
53.2%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 318
46.0%
Lowercase Letter 277
40.0%
Decimal Number 88
 
12.7%
Dash Punctuation 6
 
0.9%
Connector Punctuation 3
 
0.4%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
A 80
25.2%
U 33
 
10.4%
B 32
 
10.1%
C 16
 
5.0%
N 14
 
4.4%
Y 11
 
3.5%
E 11
 
3.5%
I 11
 
3.5%
V 10
 
3.1%
W 9
 
2.8%
Other values (16) 91
28.6%
Lowercase Letter
ValueCountFrequency (%)
g 64
23.1%
a 29
 
10.5%
x 16
 
5.8%
o 14
 
5.1%
w 14
 
5.1%
i 13
 
4.7%
z 13
 
4.7%
h 12
 
4.3%
y 11
 
4.0%
u 9
 
3.2%
Other values (16) 82
29.6%
Decimal Number
ValueCountFrequency (%)
4 26
29.5%
1 10
 
11.4%
6 10
 
11.4%
7 8
 
9.1%
3 7
 
8.0%
9 7
 
8.0%
0 6
 
6.8%
8 6
 
6.8%
5 5
 
5.7%
2 3
 
3.4%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 595
86.0%
Common 97
 
14.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
A 80
 
13.4%
g 64
 
10.8%
U 33
 
5.5%
B 32
 
5.4%
a 29
 
4.9%
x 16
 
2.7%
C 16
 
2.7%
o 14
 
2.4%
w 14
 
2.4%
N 14
 
2.4%
Other values (42) 283
47.6%
Common
ValueCountFrequency (%)
4 26
26.8%
1 10
 
10.3%
6 10
 
10.3%
7 8
 
8.2%
3 7
 
7.2%
9 7
 
7.2%
- 6
 
6.2%
0 6
 
6.2%
8 6
 
6.2%
5 5
 
5.2%
Other values (2) 6
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 692
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
A 80
 
11.6%
g 64
 
9.2%
U 33
 
4.8%
B 32
 
4.6%
a 29
 
4.2%
4 26
 
3.8%
x 16
 
2.3%
C 16
 
2.3%
o 14
 
2.0%
w 14
 
2.0%
Other values (54) 368
53.2%

설명
Text

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size356.0 B
2023-12-10T23:07:24.088042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length463
Median length40.5
Mean length62.642857
Min length3

Characters and Unicode

Total characters1754
Distinct characters357
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique28 ?
Unique (%)100.0%

Sample

1st row썩은내가 진동하는 언론 그리고 자유일국당 사람이 아닌 악마집단들
2nd row차 트렁크에 박스채로 몇백억씩 사기쳐서 도적질한 차떼기 도적놈들인 자한당 개10쌕끼들을 개작두로 모가지를 썰어서 죽창으로 오장육부를 도려내어 광화문 광장에서 부관참시해야 이 나라가 사는 길이다. 아주 질이 나쁜놈들이다..
3rd row김정은 보다 더 나쁜 사람
4th row정치검찰 기레기들 편파보도 거짓보도 허위보도 토착왜구 TV조선 모두아웃
5th row딸 마약검사도 했어야 하는거 아닌가요? 마약 구매를한 돈은 어디서 ?
ValueCountFrequency (%)
민주당 4
 
1.0%
공부 3
 
0.8%
3
 
0.8%
정의당 3
 
0.8%
민주당과 2
 
0.5%
정의 2
 
0.5%
정당 2
 
0.5%
평화 2
 
0.5%
좋은 2
 
0.5%
정의당을 2
 
0.5%
Other values (349) 361
93.5%
2023-12-10T23:07:25.047335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
368
 
21.0%
52
 
3.0%
41
 
2.3%
. 37
 
2.1%
33
 
1.9%
33
 
1.9%
30
 
1.7%
28
 
1.6%
22
 
1.3%
22
 
1.3%
Other values (347) 1088
62.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1301
74.2%
Space Separator 368
 
21.0%
Other Punctuation 64
 
3.6%
Decimal Number 13
 
0.7%
Modifier Symbol 2
 
0.1%
Open Punctuation 2
 
0.1%
Close Punctuation 2
 
0.1%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
52
 
4.0%
41
 
3.2%
33
 
2.5%
33
 
2.5%
30
 
2.3%
28
 
2.2%
22
 
1.7%
22
 
1.7%
21
 
1.6%
20
 
1.5%
Other values (329) 999
76.8%
Decimal Number
ValueCountFrequency (%)
1 6
46.2%
6 1
 
7.7%
4 1
 
7.7%
5 1
 
7.7%
7 1
 
7.7%
0 1
 
7.7%
3 1
 
7.7%
2 1
 
7.7%
Other Punctuation
ValueCountFrequency (%)
. 37
57.8%
! 18
28.1%
? 6
 
9.4%
; 3
 
4.7%
Uppercase Letter
ValueCountFrequency (%)
T 1
50.0%
V 1
50.0%
Space Separator
ValueCountFrequency (%)
368
100.0%
Modifier Symbol
ValueCountFrequency (%)
^ 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1301
74.2%
Common 451
 
25.7%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
52
 
4.0%
41
 
3.2%
33
 
2.5%
33
 
2.5%
30
 
2.3%
28
 
2.2%
22
 
1.7%
22
 
1.7%
21
 
1.6%
20
 
1.5%
Other values (329) 999
76.8%
Common
ValueCountFrequency (%)
368
81.6%
. 37
 
8.2%
! 18
 
4.0%
? 6
 
1.3%
1 6
 
1.3%
; 3
 
0.7%
^ 2
 
0.4%
( 2
 
0.4%
) 2
 
0.4%
6 1
 
0.2%
Other values (6) 6
 
1.3%
Latin
ValueCountFrequency (%)
T 1
50.0%
V 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1283
73.1%
ASCII 453
 
25.8%
Compat Jamo 18
 
1.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
368
81.2%
. 37
 
8.2%
! 18
 
4.0%
? 6
 
1.3%
1 6
 
1.3%
; 3
 
0.7%
^ 2
 
0.4%
( 2
 
0.4%
) 2
 
0.4%
6 1
 
0.2%
Other values (8) 8
 
1.8%
Hangul
ValueCountFrequency (%)
52
 
4.1%
41
 
3.2%
33
 
2.6%
33
 
2.6%
30
 
2.3%
28
 
2.2%
22
 
1.7%
22
 
1.7%
21
 
1.6%
20
 
1.6%
Other values (318) 981
76.5%
Compat Jamo
ValueCountFrequency (%)
3
16.7%
3
16.7%
3
16.7%
2
11.1%
1
 
5.6%
1
 
5.6%
1
 
5.6%
1
 
5.6%
1
 
5.6%
1
 
5.6%
Distinct3
Distinct (%)10.7%
Missing0
Missing (%)0.0%
Memory size356.0 B
보통
14 
좋아요
10 
싫어요

Length

Max length3
Median length2.5
Mean length2.5
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row좋아요
2nd row보통
3rd row보통
4th row좋아요
5th row싫어요

Common Values

ValueCountFrequency (%)
보통 14
50.0%
좋아요 10
35.7%
싫어요 4
 
14.3%

Length

2023-12-10T23:07:25.485320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:07:25.793691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
보통 14
50.0%
좋아요 10
35.7%
싫어요 4
 
14.3%

Correlations

2023-12-10T23:07:25.964757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
이용자감성영상IDID설명이용자감성분류
이용자감성영상ID1.0001.0001.0000.000
ID1.0001.0001.0001.000
설명1.0001.0001.0001.000
이용자감성분류0.0001.0001.0001.000
2023-12-10T23:07:26.157480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
이용자감성영상ID이용자감성분류
이용자감성영상ID1.0000.000
이용자감성분류0.0001.000
2023-12-10T23:07:26.370672image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
이용자감성영상ID이용자감성분류
이용자감성영상ID1.0000.000
이용자감성분류0.0001.000

Missing values

2023-12-10T23:07:21.167401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T23:07:21.356666image/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이용자감성영상IDID설명이용자감성분류
02021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z1Yami73l1cUgy6TXaA8qz8YfmggDJ4AaABAg썩은내가 진동하는 언론 그리고 자유일국당 사람이 아닌 악마집단들좋아요
12021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z1Yami73l1cUgyuBguNqYymbCiTsMV4AaABAg차 트렁크에 박스채로 몇백억씩 사기쳐서 도적질한 차떼기 도적놈들인 자한당 개10쌕끼들을 개작두로 모가지를 썰어서 죽창으로 오장육부를 도려내어 광화문 광장에서 부관참시해야 이 나라가 사는 길이다. 아주 질이 나쁜놈들이다..보통
22021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z1Yami73l1cUgzALIGvBfOWiU0wuol4AaABAg김정은 보다 더 나쁜 사람보통
32021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z1Yami73l1cUgz3KtOX6iEdx-y2IVx4AaABAg정치검찰 기레기들 편파보도 거짓보도 허위보도 토착왜구 TV조선 모두아웃좋아요
42021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z1Yami73l1cUgzgrdY7V5DZUG66ED54AaABAg딸 마약검사도 했어야 하는거 아닌가요? 마약 구매를한 돈은 어디서 ?싫어요
52021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z1owIdkxMxwUgwWtWHBjC2sBLvHwJx4AaABAg열린우리당 에게도 기회한번 주시지요.보통
62021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z1owIdkxMxwUgwez-9hMCu1TbxjYoN4AaABAg이름만 정의! 정의 없는 정당! 반정당!!!좋아요
72021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z1owIdkxMxwUgwv7bHjNSq06yY_u0F4AaABAg정의당이 욕심이 넘 ㅤㄴㅏㄶ아요. 녹색당. 청년당 같은 작은 정당은 어쩌란 날입니까? 말도 아난 것을 주장중이내요.보통
82021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z1owIdkxMxwUgxx36DaYVwi2-woPTB4AaABAg나민지인데 정의당에표줄일1도엄써!보통
92021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z1owIdkxMxwUgx1ki1b0x10xBknG6t4AaABAg총수님!! 열린민주당과도 얼른 인터뷰하시고 널리 알려주세요. 시간이 촉박합니다!!보통
이용자감성수집일자이용자감성채널ID이용자감성영상IDID설명이용자감성분류
182021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z1owIdkxMxwUgzNVUE04l4j7ZmNbAZ4AaABAg심대표 실망이네 얼굴에 욕심좀 버리쇼싫어요
192021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z1owIdkxMxwUgzZCuwx9ZGXUAolPAN4AaABAg근데 왜 열린민주당은 섭외안하나요 ㅠ 대놓고 민주당이라 그런거?보통
202021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z1owIdkxMxwUgzbwN3U3OTPikk9awB4AaABAg열린민주당에 몰표될수도 있겠다. 민주당 참여 안한다면보통
212021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z2V4Wusc4tYUgxScBmc17HRAPT1_lB4AaABAg평화 항구적인 평화!좋아요
222021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z32ivbYfqnMUggW61NNi7IsiHgCoAEC사회자진짜 개못하네 듣기싫어 뭘자꾸 이상한 농담쳐던지냐 재미도없는데 좀 날카로운질문을 던지던가 이준석 좀더 질문하게 기회좀주지 날카로ㅤㅇㅝㅅ는데싫어요
232021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z32ivbYfqnMUgh5nGf4dP7AZngCoAEC시장님....예방주사 맞고 갑시다. 지금이 녹취록 오픈할 기회 입니다. 높이 오를수록 떨어질때 상처는 큰법입니다. 대선직전 범야권에 미칠 영향을 생각하세요. 역대 선거에서 했던 과오를 반복하지 마세요.좋아요
242021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z32ivbYfqnMUggaLh3K4XEYdngCoAEC이재명 시장 좋아요!! 박씨는 대본 보고 읽는거 우주의 기운 이야기하는거 대답피하는것 밖에 못하는데;;(근데 이재명 시장님 몸쫌 흔들지마요 ㅠㅠ정신 사나움)좋아요
252021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z32ivbYfqnMUgh7cEiIoWcfjngCoAEC사회자 왜저러는거야...보통
262021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z32ivbYfqnMUghMtiFph19K1ngCoAEC난세에 영웅이 나온다더니...보통
272021-01-01https://www.youtube.com/channel/UC5HSw5OY2vfVFSihpiB-AVQhttps://www.youtube.com/watch?v=Z32ivbYfqnMUghNqf5XMsVYO3gCoAEC우리시장님 항상화이팅!!!!!좋아요