Overview

Dataset statistics

Number of variables6
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.9 KiB
Average record size in memory50.3 B

Variable types

Categorical5
Numeric1

Alerts

Country_CD has constant value ""Constant
Collection_CH_NM has constant value ""Constant

Reproduction

Analysis started2023-12-10 09:39:02.766845
Analysis finished2023-12-10 09:39:04.907808
Duration2.14 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Social_Data_Collection_Date_YM
Categorical

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2017-01
54 
2017-02
33 
2017-03
13 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2017-01
2nd row2017-01
3rd row2017-01
4th row2017-01
5th row2017-01

Common Values

ValueCountFrequency (%)
2017-01 54
54.0%
2017-02 33
33.0%
2017-03 13
 
13.0%

Length

2023-12-10T18:39:05.085849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:39:05.250201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2017-01 54
54.0%
2017-02 33
33.0%
2017-03 13
 
13.0%

Country_CD
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
VN
100 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowVN
2nd rowVN
3rd rowVN
4th rowVN
5th rowVN

Common Values

ValueCountFrequency (%)
VN 100
100.0%

Length

2023-12-10T18:39:05.469228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:39:05.609683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
vn 100
100.0%

Collection_CH_NM
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
community
100 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowcommunity
2nd rowcommunity
3rd rowcommunity
4th rowcommunity
5th rowcommunity

Common Values

ValueCountFrequency (%)
community 100
100.0%

Length

2023-12-10T18:39:05.764819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:39:05.889581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
community 100
100.0%

Artist_NM
Categorical

Distinct10
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
bts
50 
blackpink
12 
got7
12 
exo
7 
nct
7 
Other values (5)
12 

Length

Max length9
Median length3
Mean length4.38
Min length3

Unique

Unique2 ?
Unique (%)2.0%

Sample

1st rowblackpink
2nd rowblackpink
3rd rowblackpink
4th rowblackpink
5th rowblackpink

Common Values

ValueCountFrequency (%)
bts 50
50.0%
blackpink 12
 
12.0%
got7 12
 
12.0%
exo 7
 
7.0%
nct 7
 
7.0%
everglow 4
 
4.0%
mamamoo 3
 
3.0%
seventeen 3
 
3.0%
jhope 1
 
1.0%
twice 1
 
1.0%

Length

2023-12-10T18:39:06.076176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:39:06.253981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
bts 50
50.0%
blackpink 12
 
12.0%
got7 12
 
12.0%
exo 7
 
7.0%
nct 7
 
7.0%
everglow 4
 
4.0%
mamamoo 3
 
3.0%
seventeen 3
 
3.0%
jhope 1
 
1.0%
twice 1
 
1.0%

Community_KEY_W
Categorical

Distinct49
Distinct (%)49.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
youtube
8 
bts
 
6
blackpink
 
6
mbc
 
5
amp
 
4
Other values (44)
71 

Length

Max length15
Median length9
Mean length5.68
Min length2

Unique

Unique25 ?
Unique (%)25.0%

Sample

1st rowblackpink
2nd rowyoutube
3rd rowbts
4th rowbigbang
5th rowclc

Common Values

ValueCountFrequency (%)
youtube 8
 
8.0%
bts 6
 
6.0%
blackpink 6
 
6.0%
mbc 5
 
5.0%
amp 4
 
4.0%
jisoo 3
 
3.0%
kpop 3
 
3.0%
jinyoung 3
 
3.0%
seohyun 3
 
3.0%
bangtan 3
 
3.0%
Other values (39) 56
56.0%

Length

2023-12-10T18:39:06.479976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
youtube 8
 
8.0%
blackpink 6
 
6.0%
bts 6
 
6.0%
mbc 5
 
5.0%
amp 4
 
4.0%
btsbighit 3
 
3.0%
music 3
 
3.0%
fancam 3
 
3.0%
bangtan 3
 
3.0%
seohyun 3
 
3.0%
Other values (39) 56
56.0%

Keyword_FQ
Real number (ℝ)

Distinct23
Distinct (%)23.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.43
Minimum1
Maximum98
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:39:06.673478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q12.75
median4
Q36.25
95-th percentile26.2
Maximum98
Range97
Interquartile range (IQR)3.5

Descriptive statistics

Standard deviation15.111207
Coefficient of variation (CV)1.7925513
Kurtosis20.408661
Mean8.43
Median Absolute Deviation (MAD)2
Skewness4.3648998
Sum843
Variance228.34859
MonotonicityNot monotonic
2023-12-10T18:39:06.878095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
2 22
22.0%
4 19
19.0%
6 12
12.0%
3 11
11.0%
5 8
 
8.0%
7 8
 
8.0%
1 3
 
3.0%
16 2
 
2.0%
13 1
 
1.0%
20 1
 
1.0%
Other values (13) 13
13.0%
ValueCountFrequency (%)
1 3
 
3.0%
2 22
22.0%
3 11
11.0%
4 19
19.0%
5 8
 
8.0%
6 12
12.0%
7 8
 
8.0%
8 1
 
1.0%
9 1
 
1.0%
10 1
 
1.0%
ValueCountFrequency (%)
98 1
1.0%
84 1
1.0%
69 1
1.0%
51 1
1.0%
30 1
1.0%
26 1
1.0%
22 1
1.0%
21 1
1.0%
20 1
1.0%
16 2
2.0%

Interactions

2023-12-10T18:39:04.270097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T18:39:07.019778image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Social_Data_Collection_Date_YMArtist_NMCommunity_KEY_WKeyword_FQ
Social_Data_Collection_Date_YM1.0000.4300.0000.000
Artist_NM0.4301.0000.7150.000
Community_KEY_W0.0000.7151.0000.000
Keyword_FQ0.0000.0000.0001.000
2023-12-10T18:39:07.377875image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Community_KEY_WArtist_NMSocial_Data_Collection_Date_YM
Community_KEY_W1.0000.2410.000
Artist_NM0.2411.0000.275
Social_Data_Collection_Date_YM0.0000.2751.000
2023-12-10T18:39:07.723449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Keyword_FQSocial_Data_Collection_Date_YMArtist_NMCommunity_KEY_W
Keyword_FQ1.0000.0000.0000.000
Social_Data_Collection_Date_YM0.0001.0000.2750.000
Artist_NM0.0000.2751.0000.241
Community_KEY_W0.0000.0000.2411.000

Missing values

2023-12-10T18:39:04.581151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T18:39:04.775289image/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

Social_Data_Collection_Date_YMCountry_CDCollection_CH_NMArtist_NMCommunity_KEY_WKeyword_FQ
02017-01VNcommunityblackpinkblackpink13
12017-01VNcommunityblackpinkyoutube7
22017-01VNcommunityblackpinkbts6
32017-01VNcommunityblackpinkbigbang5
42017-01VNcommunityblackpinkclc4
52017-01VNcommunityblackpinkseohyun4
62017-01VNcommunityblackpinkinsta2
72017-01VNcommunityblackpinkmbc2
82017-01VNcommunitybtsbts69
92017-01VNcommunitybtsyoutube22
Social_Data_Collection_Date_YMCountry_CDCollection_CH_NMArtist_NMCommunity_KEY_WKeyword_FQ
902017-03VNcommunitybtsyoutube21
912017-03VNcommunitybtsarmy7
922017-03VNcommunitybts방탄소년단7
932017-03VNcommunitybtsbtsbighit6
942017-03VNcommunitybtsmbc6
952017-03VNcommunitybtsamp4
962017-03VNcommunitybtssong4
972017-03VNcommunitybtstaeyeon4
982017-03VNcommunitybtstwitter4
992017-03VNcommunitybtsbangtan3