Overview

Dataset statistics

Number of variables7
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.9 KiB
Average record size in memory64.4 B

Variable types

Text1
Categorical2
Numeric4

Dataset

Description샘플 데이터
Author한양대
URLhttps://bigdata-region.kr/#/dataset/ea9800b1-f8a4-4bed-b06c-d5b13c3bcf63

Alerts

참여영상수집일자 has constant value ""Constant
영상영상채널명 has constant value ""Constant
수 is highly overall correlated with 참여영상좋아요수 and 1 other fieldsHigh correlation
참여영상좋아요수 is highly overall correlated with 수 and 1 other fieldsHigh correlation
참여영상싫어요수 is highly overall correlated with 수High correlation
참여영상시청수 is highly overall correlated with 참여영상좋아요수High correlation
참여영상경로명 has unique valuesUnique
참여영상시청수 has unique valuesUnique
수 has 14 (46.7%) zerosZeros
참여영상좋아요수 has 5 (16.7%) zerosZeros
참여영상싫어요수 has 16 (53.3%) zerosZeros

Reproduction

Analysis started2023-12-10 14:19:31.983062
Analysis finished2023-12-10 14:19:35.968495
Duration3.99 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

참여영상경로명
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-10T23:19:36.239531image/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=MNkYC-JQqqU
2nd rowhttps://www.youtube.com/watch?v=pOlTIlpsp9U
3rd rowhttps://www.youtube.com/watch?v=lW5vZIptBEU
4th rowhttps://www.youtube.com/watch?v=-1Zr6SQvPxk
5th rowhttps://www.youtube.com/watch?v=tLwOJBdoMqM
ValueCountFrequency (%)
https://www.youtube.com/watch?v=mnkyc-jqqqu 1
 
3.3%
https://www.youtube.com/watch?v=poltilpsp9u 1
 
3.3%
https://www.youtube.com/watch?v=za74fjxddq0 1
 
3.3%
https://www.youtube.com/watch?v=ff3erqg-ud0 1
 
3.3%
https://www.youtube.com/watch?v=k3rfljgfx-y 1
 
3.3%
https://www.youtube.com/watch?v=tqivsbqgyx8 1
 
3.3%
https://www.youtube.com/watch?v=gofy7oa_uco 1
 
3.3%
https://www.youtube.com/watch?v=ftvaskgjbk4 1
 
3.3%
https://www.youtube.com/watch?v=wyh2hlfjwzi 1
 
3.3%
https://www.youtube.com/watch?v=rl9urllahlc 1
 
3.3%
Other values (20) 20
66.7%
2023-12-10T23:19:36.778875image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
t 127
 
9.8%
w 126
 
9.8%
/ 90
 
7.0%
o 67
 
5.2%
h 63
 
4.9%
c 63
 
4.9%
u 63
 
4.9%
. 60
 
4.7%
p 38
 
2.9%
v 37
 
2.9%
Other values (59) 556
43.1%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 852
66.0%
Other Punctuation 210
 
16.3%
Uppercase Letter 146
 
11.3%
Decimal Number 43
 
3.3%
Math Symbol 30
 
2.3%
Dash Punctuation 8
 
0.6%
Connector Punctuation 1
 
0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
t 127
14.9%
w 126
14.8%
o 67
 
7.9%
h 63
 
7.4%
c 63
 
7.4%
u 63
 
7.4%
p 38
 
4.5%
v 37
 
4.3%
b 36
 
4.2%
m 35
 
4.1%
Other values (16) 197
23.1%
Uppercase Letter
ValueCountFrequency (%)
X 11
 
7.5%
I 10
 
6.8%
L 9
 
6.2%
U 8
 
5.5%
Z 8
 
5.5%
Q 8
 
5.5%
V 6
 
4.1%
Y 6
 
4.1%
C 6
 
4.1%
O 5
 
3.4%
Other values (16) 69
47.3%
Decimal Number
ValueCountFrequency (%)
9 8
18.6%
7 6
14.0%
0 6
14.0%
6 5
11.6%
3 4
9.3%
4 4
9.3%
8 3
 
7.0%
2 3
 
7.0%
1 2
 
4.7%
5 2
 
4.7%
Other Punctuation
ValueCountFrequency (%)
/ 90
42.9%
. 60
28.6%
? 30
 
14.3%
: 30
 
14.3%
Math Symbol
ValueCountFrequency (%)
= 30
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 998
77.4%
Common 292
 
22.6%

Most frequent character per script

Latin
ValueCountFrequency (%)
t 127
 
12.7%
w 126
 
12.6%
o 67
 
6.7%
h 63
 
6.3%
c 63
 
6.3%
u 63
 
6.3%
p 38
 
3.8%
v 37
 
3.7%
b 36
 
3.6%
m 35
 
3.5%
Other values (42) 343
34.4%
Common
ValueCountFrequency (%)
/ 90
30.8%
. 60
20.5%
? 30
 
10.3%
: 30
 
10.3%
= 30
 
10.3%
9 8
 
2.7%
- 8
 
2.7%
7 6
 
2.1%
0 6
 
2.1%
6 5
 
1.7%
Other values (7) 19
 
6.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1290
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
t 127
 
9.8%
w 126
 
9.8%
/ 90
 
7.0%
o 67
 
5.2%
h 63
 
4.9%
c 63
 
4.9%
u 63
 
4.9%
. 60
 
4.7%
p 38
 
2.9%
v 37
 
2.9%
Other values (59) 556
43.1%

참여영상수집일자
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-10T23:19:37.032721image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

수
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct10
Distinct (%)33.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.1666667
Minimum0
Maximum35
Zeros14
Zeros (%)46.7%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:19:37.315038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q34
95-th percentile8.55
Maximum35
Range35
Interquartile range (IQR)4

Descriptive statistics

Standard deviation6.6232783
Coefficient of variation (CV)2.0915616
Kurtosis19.383273
Mean3.1666667
Median Absolute Deviation (MAD)1
Skewness4.098425
Sum95
Variance43.867816
MonotonicityNot monotonic
2023-12-10T23:19:37.501012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
0 14
46.7%
1 4
 
13.3%
4 2
 
6.7%
5 2
 
6.7%
8 2
 
6.7%
2 2
 
6.7%
3 1
 
3.3%
9 1
 
3.3%
6 1
 
3.3%
35 1
 
3.3%
ValueCountFrequency (%)
0 14
46.7%
1 4
 
13.3%
2 2
 
6.7%
3 1
 
3.3%
4 2
 
6.7%
5 2
 
6.7%
6 1
 
3.3%
8 2
 
6.7%
9 1
 
3.3%
35 1
 
3.3%
ValueCountFrequency (%)
35 1
 
3.3%
9 1
 
3.3%
8 2
 
6.7%
6 1
 
3.3%
5 2
 
6.7%
4 2
 
6.7%
3 1
 
3.3%
2 2
 
6.7%
1 4
 
13.3%
0 14
46.7%

참여영상좋아요수
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct18
Distinct (%)60.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean10.7
Minimum0
Maximum94
Zeros5
Zeros (%)16.7%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:19:37.685299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q12
median6
Q313.75
95-th percentile26.4
Maximum94
Range94
Interquartile range (IQR)11.75

Descriptive statistics

Standard deviation17.540397
Coefficient of variation (CV)1.6392894
Kurtosis18.363688
Mean10.7
Median Absolute Deviation (MAD)4.5
Skewness3.9486858
Sum321
Variance307.66552
MonotonicityNot monotonic
2023-12-10T23:19:37.829178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
2 6
20.0%
0 5
16.7%
7 2
 
6.7%
6 2
 
6.7%
3 2
 
6.7%
16 1
 
3.3%
20 1
 
3.3%
94 1
 
3.3%
14 1
 
3.3%
17 1
 
3.3%
Other values (8) 8
26.7%
ValueCountFrequency (%)
0 5
16.7%
2 6
20.0%
3 2
 
6.7%
5 1
 
3.3%
6 2
 
6.7%
7 2
 
6.7%
8 1
 
3.3%
9 1
 
3.3%
11 1
 
3.3%
13 1
 
3.3%
ValueCountFrequency (%)
94 1
3.3%
30 1
3.3%
22 1
3.3%
20 1
3.3%
18 1
3.3%
17 1
3.3%
16 1
3.3%
14 1
3.3%
13 1
3.3%
11 1
3.3%

참여영상싫어요수
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct7
Distinct (%)23.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.2666667
Minimum0
Maximum12
Zeros16
Zeros (%)53.3%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:19:37.970110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31
95-th percentile4.55
Maximum12
Range12
Interquartile range (IQR)1

Descriptive statistics

Standard deviation2.4202213
Coefficient of variation (CV)1.910701
Kurtosis13.454856
Mean1.2666667
Median Absolute Deviation (MAD)0
Skewness3.355521
Sum38
Variance5.8574713
MonotonicityNot monotonic
2023-12-10T23:19:38.144498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
0 16
53.3%
1 7
23.3%
3 2
 
6.7%
2 2
 
6.7%
4 1
 
3.3%
12 1
 
3.3%
5 1
 
3.3%
ValueCountFrequency (%)
0 16
53.3%
1 7
23.3%
2 2
 
6.7%
3 2
 
6.7%
4 1
 
3.3%
5 1
 
3.3%
12 1
 
3.3%
ValueCountFrequency (%)
12 1
 
3.3%
5 1
 
3.3%
4 1
 
3.3%
3 2
 
6.7%
2 2
 
6.7%
1 7
23.3%
0 16
53.3%

참여영상시청수
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean878.9
Minimum79
Maximum6102
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:19:38.325567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum79
5-th percentile83.7
Q1317
median615.5
Q3987
95-th percentile2043.5
Maximum6102
Range6023
Interquartile range (IQR)670

Descriptive statistics

Standard deviation1124.7895
Coefficient of variation (CV)1.2797696
Kurtosis16.567365
Mean878.9
Median Absolute Deviation (MAD)357.5
Skewness3.7002055
Sum26367
Variance1265151.3
MonotonicityNot monotonic
2023-12-10T23:19:38.512828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
635 1
 
3.3%
907 1
 
3.3%
6102 1
 
3.3%
1697 1
 
3.3%
1332 1
 
3.3%
1080 1
 
3.3%
418 1
 
3.3%
537 1
 
3.3%
562 1
 
3.3%
426 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
79 1
3.3%
81 1
3.3%
87 1
3.3%
113 1
3.3%
124 1
3.3%
148 1
3.3%
242 1
3.3%
297 1
3.3%
377 1
3.3%
418 1
3.3%
ValueCountFrequency (%)
6102 1
3.3%
2075 1
3.3%
2005 1
3.3%
1697 1
3.3%
1332 1
3.3%
1160 1
3.3%
1080 1
3.3%
997 1
3.3%
957 1
3.3%
907 1
3.3%

영상영상채널명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
MBN Entertainment
30 

Length

Max length17
Median length17
Mean length17
Min length17

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowMBN Entertainment
2nd rowMBN Entertainment
3rd rowMBN Entertainment
4th rowMBN Entertainment
5th rowMBN Entertainment

Common Values

ValueCountFrequency (%)
MBN Entertainment 30
100.0%

Length

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

Common Values (Plot)

2023-12-10T23:19:38.914061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
mbn 30
50.0%
entertainment 30
50.0%

Interactions

2023-12-10T23:19:35.098613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:19:32.199759image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:19:32.997616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:19:34.520180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:19:35.251553image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:19:32.323848image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:19:33.679872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:19:34.696849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:19:35.381071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:19:32.467916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:19:34.139499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:19:34.821076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:19:35.507949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:19:32.719182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:19:34.343250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:19:34.974814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T23:19:39.007353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
참여영상경로명수참여영상좋아요수참여영상싫어요수참여영상시청수
참여영상경로명1.0001.0001.0001.0001.000
수1.0001.0000.5870.8750.624
참여영상좋아요수1.0000.5871.0000.5700.947
참여영상싫어요수1.0000.8750.5701.0000.659
참여영상시청수1.0000.6240.9470.6591.000
2023-12-10T23:19:39.174098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수참여영상좋아요수참여영상싫어요수참여영상시청수
수1.0000.5280.5770.493
참여영상좋아요수0.5281.0000.4680.949
참여영상싫어요수0.5770.4681.0000.457
참여영상시청수0.4930.9490.4571.000

Missing values

2023-12-10T23:19:35.695823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T23:19:35.891835image/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

참여영상경로명참여영상수집일자수참여영상좋아요수참여영상싫어요수참여영상시청수영상영상채널명
0https://www.youtube.com/watch?v=MNkYC-JQqqU2020-09-013160635MBN Entertainment
1https://www.youtube.com/watch?v=pOlTIlpsp9U2020-09-0112231160MBN Entertainment
2https://www.youtube.com/watch?v=lW5vZIptBEU2020-09-010131659MBN Entertainment
3https://www.youtube.com/watch?v=-1Zr6SQvPxk2020-09-01020297MBN Entertainment
4https://www.youtube.com/watch?v=tLwOJBdoMqM2020-09-01020242MBN Entertainment
5https://www.youtube.com/watch?v=LjGXVmiDzh42020-09-0100081MBN Entertainment
6https://www.youtube.com/watch?v=pWwXiOmNHiw2020-09-01021124MBN Entertainment
7https://www.youtube.com/watch?v=kZqxgVSQQeU2020-09-01000148MBN Entertainment
8https://www.youtube.com/watch?v=90X3SbSmdz82020-09-0100079MBN Entertainment
9https://www.youtube.com/watch?v=0GIQdKK2V0o2020-09-01000113MBN Entertainment
참여영상경로명참여영상수집일자수참여영상좋아요수참여영상싫어요수참여영상시청수영상영상채널명
20https://www.youtube.com/watch?v=Pu69V7NHjiw2020-09-0123002075MBN Entertainment
21https://www.youtube.com/watch?v=rL9URLLAHlc2020-09-0112012005MBN Entertainment
22https://www.youtube.com/watch?v=WYH2hLFjWZI2020-09-01431426MBN Entertainment
23https://www.youtube.com/watch?v=fTVasKgjbK42020-09-01650562MBN Entertainment
24https://www.youtube.com/watch?v=gofy7OA_uco2020-09-01863537MBN Entertainment
25https://www.youtube.com/watch?v=tqIvsbQgyX82020-09-01120418MBN Entertainment
26https://www.youtube.com/watch?v=k3rfLjGfX-Y2020-09-0101101080MBN Entertainment
27https://www.youtube.com/watch?v=FF3erQG-UD02020-09-0121701332MBN Entertainment
28https://www.youtube.com/watch?v=za74fjXDDq02020-09-0101411697MBN Entertainment
29https://www.youtube.com/watch?v=93ZbCRg6IZE2020-09-01359456102MBN Entertainment