Overview

Dataset statistics

Number of variables5
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.1 KiB
Average record size in memory42.3 B

Variable types

Categorical4
Numeric1

Alerts

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

Reproduction

Analysis started2023-12-10 09:58:53.944348
Analysis finished2023-12-10 09:58:54.689844
Duration0.75 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Social_Data_Collection_Date_YM
Categorical

Distinct22
Distinct (%)22.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2018-10
 
6
2017-03
 
6
2017-08
 
6
2017-11
 
6
2018-05
 
6
Other values (17)
70 

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-02

Common Values

ValueCountFrequency (%)
2018-10 6
 
6.0%
2017-03 6
 
6.0%
2017-08 6
 
6.0%
2017-11 6
 
6.0%
2018-05 6
 
6.0%
2018-03 6
 
6.0%
2017-05 5
 
5.0%
2018-08 5
 
5.0%
2017-07 5
 
5.0%
2018-04 5
 
5.0%
Other values (12) 44
44.0%

Length

2023-12-10T18:58:54.830618image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2018-10 6
 
6.0%
2017-08 6
 
6.0%
2017-11 6
 
6.0%
2018-05 6
 
6.0%
2018-03 6
 
6.0%
2017-03 6
 
6.0%
2017-05 5
 
5.0%
2018-08 5
 
5.0%
2017-07 5
 
5.0%
2018-04 5
 
5.0%
Other values (12) 44
44.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:58:55.101464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:58:55.294996image/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:58:55.528751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Community_KEY_W
Categorical

Distinct33
Distinct (%)33.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
kpop
22 
youtube
22 
bts
10 
btstwt
6 
allkpop
 
3
Other values (28)
37 

Length

Max length12
Median length10
Mean length5.58
Min length3

Unique

Unique21 ?
Unique (%)21.0%

Sample

1st rowkpop
2nd rowyoutube
3rd rowclc
4th rowseohyun
5th rowkpop

Common Values

ValueCountFrequency (%)
kpop 22
22.0%
youtube 22
22.0%
bts 10
 
10.0%
btstwt 6
 
6.0%
allkpop 3
 
3.0%
drama 3
 
3.0%
jackson 3
 
3.0%
army 2
 
2.0%
incheon 2
 
2.0%
btob 2
 
2.0%
Other values (23) 25
25.0%

Length

2023-12-10T18:58:55.890298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
kpop 22
22.0%
youtube 22
22.0%
bts 10
 
10.0%
btstwt 6
 
6.0%
allkpop 3
 
3.0%
drama 3
 
3.0%
jackson 3
 
3.0%
btob 2
 
2.0%
mbc 2
 
2.0%
music 2
 
2.0%
Other values (23) 25
25.0%

Keyword_FQ
Real number (ℝ)

Distinct27
Distinct (%)27.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12.44
Minimum2
Maximum125
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:58:56.108878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile2
Q14
median6.5
Q314
95-th percentile42.35
Maximum125
Range123
Interquartile range (IQR)10

Descriptive statistics

Standard deviation18.385502
Coefficient of variation (CV)1.4779342
Kurtosis17.792033
Mean12.44
Median Absolute Deviation (MAD)3.5
Skewness3.8798434
Sum1244
Variance338.02667
MonotonicityNot monotonic
2023-12-10T18:58:56.348709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
4 16
16.0%
2 13
13.0%
3 8
 
8.0%
5 8
 
8.0%
8 6
 
6.0%
15 6
 
6.0%
6 5
 
5.0%
12 4
 
4.0%
9 4
 
4.0%
7 4
 
4.0%
Other values (17) 26
26.0%
ValueCountFrequency (%)
2 13
13.0%
3 8
8.0%
4 16
16.0%
5 8
8.0%
6 5
 
5.0%
7 4
 
4.0%
8 6
 
6.0%
9 4
 
4.0%
10 2
 
2.0%
11 3
 
3.0%
ValueCountFrequency (%)
125 1
1.0%
86 1
1.0%
83 1
1.0%
58 1
1.0%
49 1
1.0%
42 1
1.0%
33 1
1.0%
31 2
2.0%
29 1
1.0%
28 1
1.0%

Interactions

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

Correlations

2023-12-10T18:58:56.563746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Social_Data_Collection_Date_YMCommunity_KEY_WKeyword_FQ
Social_Data_Collection_Date_YM1.0000.0000.000
Community_KEY_W0.0001.0000.000
Keyword_FQ0.0000.0001.000
2023-12-10T18:58:56.742365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Community_KEY_WSocial_Data_Collection_Date_YM
Community_KEY_W1.0000.000
Social_Data_Collection_Date_YM0.0001.000
2023-12-10T18:58:56.900763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Keyword_FQSocial_Data_Collection_Date_YMCommunity_KEY_W
Keyword_FQ1.0000.0000.000
Social_Data_Collection_Date_YM0.0001.0000.000
Community_KEY_W0.0000.0001.000

Missing values

2023-12-10T18:58:54.432866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T18:58:54.611307image/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_NMCommunity_KEY_WKeyword_FQ
02017-01vncommunitykpop14
12017-01vncommunityyoutube6
22017-01vncommunityclc4
32017-01vncommunityseohyun3
42017-02vncommunitykpop5
52017-02vncommunitytwices2
62017-02vncommunityyoutube2
72017-03vncommunityjacksons12
82017-03vncommunityjyp12
92017-03vncommunitykpop12
Social_Data_Collection_Date_YMCountry_CDCollection_CH_NMCommunity_KEY_WKeyword_FQ
902018-09vncommunitykpop29
912018-09vncommunityyoutube7
922018-09vncommunitybts6
932018-09vncommunityidol4
942018-10vncommunitykpop33
952018-10vncommunityyoutube8
962018-10vncommunitymelon5
972018-10vncommunitymusic5
982018-10vncommunityawards4
992018-10vncommunitydrama4