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 10:06:14.875776
Analysis finished2023-12-10 10:06:15.761086
Duration0.89 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Social_Data_Collection_Date_YM
Categorical

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2017-01
64 
2017-02
36 

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 64
64.0%
2017-02 36
36.0%

Length

2023-12-10T19:06:15.884332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:06:16.056733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2017-01 64
64.0%
2017-02 36
36.0%

Country_CD
Categorical

CONSTANT 

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

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
US 100
100.0%

Length

2023-12-10T19:06:16.259022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:06:16.432559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
us 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-10T19:06:16.608477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Artist_NM
Categorical

Distinct12
Distinct (%)12.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
bts
38 
everglow
14 
blackpink
9 
exo
8 
got7
8 
Other values (7)
23 

Length

Max length9
Median length8.5
Mean length4.91
Min length3

Unique

Unique1 ?
Unique (%)1.0%

Sample

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

Common Values

ValueCountFrequency (%)
bts 38
38.0%
everglow 14
 
14.0%
blackpink 9
 
9.0%
exo 8
 
8.0%
got7 8
 
8.0%
day6 4
 
4.0%
mamamoo 4
 
4.0%
nct 4
 
4.0%
seventeen 4
 
4.0%
jhope 3
 
3.0%
Other values (2) 4
 
4.0%

Length

2023-12-10T19:06:16.914020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
bts 38
38.0%
everglow 14
 
14.0%
blackpink 9
 
9.0%
exo 8
 
8.0%
got7 8
 
8.0%
day6 4
 
4.0%
mamamoo 4
 
4.0%
nct 4
 
4.0%
seventeen 4
 
4.0%
jhope 3
 
3.0%
Other values (2) 4
 
4.0%

Community_KEY_W
Categorical

Distinct39
Distinct (%)39.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
youtube
12 
kpop
11 
bts
10 
exo
6 
amp
6 
Other values (34)
55 

Length

Max length15
Median length10
Mean length5.37
Min length2

Unique

Unique19 ?
Unique (%)19.0%

Sample

1st rowblackpink
2nd rowyoutube
3rd rowbts
4th rowmamamoo
5th rowawards

Common Values

ValueCountFrequency (%)
youtube 12
 
12.0%
kpop 11
 
11.0%
bts 10
 
10.0%
exo 6
 
6.0%
amp 6
 
6.0%
blackpink 4
 
4.0%
mbc 4
 
4.0%
mamamoo 3
 
3.0%
music 3
 
3.0%
jin 2
 
2.0%
Other values (29) 39
39.0%

Length

2023-12-10T19:06:17.119771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
youtube 12
 
12.0%
kpop 11
 
11.0%
bts 10
 
10.0%
exo 6
 
6.0%
amp 6
 
6.0%
blackpink 4
 
4.0%
mbc 4
 
4.0%
mamamoo 3
 
3.0%
music 3
 
3.0%
twice 2
 
2.0%
Other values (29) 39
39.0%

Keyword_FQ
Real number (ℝ)

Distinct42
Distinct (%)42.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean40.5
Minimum2
Maximum901
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:06:17.318099image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile2
Q15
median13.5
Q325
95-th percentile110.65
Maximum901
Range899
Interquartile range (IQR)20

Descriptive statistics

Standard deviation118.79602
Coefficient of variation (CV)2.9332351
Kurtosis37.776726
Mean40.5
Median Absolute Deviation (MAD)9.5
Skewness5.9348117
Sum4050
Variance14112.495
MonotonicityNot monotonic
2023-12-10T19:06:17.508306image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=42)
ValueCountFrequency (%)
3 10
 
10.0%
12 8
 
8.0%
2 7
 
7.0%
14 6
 
6.0%
5 5
 
5.0%
4 5
 
5.0%
20 4
 
4.0%
25 4
 
4.0%
9 4
 
4.0%
46 3
 
3.0%
Other values (32) 44
44.0%
ValueCountFrequency (%)
2 7
7.0%
3 10
10.0%
4 5
5.0%
5 5
5.0%
6 2
 
2.0%
7 2
 
2.0%
8 2
 
2.0%
9 4
 
4.0%
10 1
 
1.0%
11 2
 
2.0%
ValueCountFrequency (%)
901 1
1.0%
713 1
1.0%
273 1
1.0%
251 1
1.0%
199 1
1.0%
106 1
1.0%
95 1
1.0%
74 1
1.0%
55 1
1.0%
52 1
1.0%

Interactions

2023-12-10T19:06:15.265208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T19:06:17.652791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Social_Data_Collection_Date_YMArtist_NMCommunity_KEY_WKeyword_FQ
Social_Data_Collection_Date_YM1.0000.4830.0000.000
Artist_NM0.4831.0000.0000.000
Community_KEY_W0.0000.0001.0000.000
Keyword_FQ0.0000.0000.0001.000
2023-12-10T19:06:17.796367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Community_KEY_WSocial_Data_Collection_Date_YMArtist_NM
Community_KEY_W1.0000.0000.000
Social_Data_Collection_Date_YM0.0001.0000.355
Artist_NM0.0000.3551.000
2023-12-10T19:06:17.976214image/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.3550.000
Artist_NM0.0000.3551.0000.000
Community_KEY_W0.0000.0000.0001.000

Missing values

2023-12-10T19:06:15.459934image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T19:06:15.687103image/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-01UScommunityblackpinkblackpink35
12017-01UScommunityblackpinkyoutube24
22017-01UScommunityblackpinkbts8
32017-01UScommunityblackpinkmamamoo6
42017-01UScommunityblackpinkawards5
52017-01UScommunityblackpinkexo5
62017-01UScommunitybtsbts713
72017-01UScommunitybtsyoutube199
82017-01UScommunitybtsamp55
92017-01UScommunitybtsmbc46
Social_Data_Collection_Date_YMCountry_CDCollection_CH_NMArtist_NMCommunity_KEY_WKeyword_FQ
902017-02UScommunityeverglowblackpink34
912017-02UScommunityeverglowmmamelon9
922017-02UScommunityeverglowbts5
932017-02UScommunityeverglowygofficialblink4
942017-02UScommunityeverglowamp3
952017-02UScommunityeverglowkpop3
962017-02UScommunityeverglowlisa3
972017-02UScommunityexoexo48
982017-02UScommunityexokpop23
992017-02UScommunityexoyoutube20