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:47:54.236609
Analysis finished2023-12-10 09:47:55.272361
Duration1.04 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Social_Data_Collection_Date_YM
Categorical

Distinct4
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2017-01
37 
2017-02
27 
2017-03
24 
2017-04
12 

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 37
37.0%
2017-02 27
27.0%
2017-03 24
24.0%
2017-04 12
 
12.0%

Length

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

Common Values (Plot)

2023-12-10T18:47:55.679834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2017-01 37
37.0%
2017-02 27
27.0%
2017-03 24
24.0%
2017-04 12
 
12.0%

Country_CD
Categorical

CONSTANT 

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

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
au 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T18:47:56.121159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
au 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:47:56.300614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Artist_NM
Categorical

Distinct11
Distinct (%)11.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
bts
42 
got7
14 
everglow
10 
blackpink
9 
twice
8 
Other values (6)
17 

Length

Max length9
Median length3
Mean length4.61
Min length3

Unique

Unique1 ?
Unique (%)1.0%

Sample

1st rowbts
2nd rowgot7
3rd rowtwice
4th rowbts
5th rowexo

Common Values

ValueCountFrequency (%)
bts 42
42.0%
got7 14
 
14.0%
everglow 10
 
10.0%
blackpink 9
 
9.0%
twice 8
 
8.0%
exo 7
 
7.0%
nct 3
 
3.0%
seventeen 2
 
2.0%
mamamoo 2
 
2.0%
jhope 2
 
2.0%

Length

2023-12-10T18:47:56.717911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
bts 42
42.0%
got7 14
 
14.0%
everglow 10
 
10.0%
blackpink 9
 
9.0%
twice 8
 
8.0%
exo 7
 
7.0%
nct 3
 
3.0%
seventeen 2
 
2.0%
mamamoo 2
 
2.0%
jhope 2
 
2.0%

Community_KEY_W
Categorical

Distinct37
Distinct (%)37.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
youtube
9 
blackpink
8 
amp
7 
kpop
7 
music
 
6
Other values (32)
63 

Length

Max length10
Median length8
Mean length5.41
Min length2

Unique

Unique15 ?
Unique (%)15.0%

Sample

1st rowbts
2nd rowjackson
3rd rowtwice
4th rowyoutube
5th rowexo

Common Values

ValueCountFrequency (%)
youtube 9
 
9.0%
blackpink 8
 
8.0%
amp 7
 
7.0%
kpop 7
 
7.0%
music 6
 
6.0%
jackson 6
 
6.0%
bts 5
 
5.0%
twice 4
 
4.0%
exo 3
 
3.0%
blinks 3
 
3.0%
Other values (27) 42
42.0%

Length

2023-12-10T18:47:57.040766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
youtube 9
 
9.0%
blackpink 8
 
8.0%
amp 7
 
7.0%
kpop 7
 
7.0%
music 6
 
6.0%
jackson 6
 
6.0%
bts 5
 
5.0%
twice 4
 
4.0%
blinks 3
 
3.0%
방탄소년단 3
 
3.0%
Other values (27) 42
42.0%

Keyword_FQ
Real number (ℝ)

Distinct24
Distinct (%)24.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean10.22
Minimum1
Maximum98
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:47:57.395644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q12
median4
Q38
95-th percentile40.6
Maximum98
Range97
Interquartile range (IQR)6

Descriptive statistics

Standard deviation17.300423
Coefficient of variation (CV)1.6928007
Kurtosis11.13772
Mean10.22
Median Absolute Deviation (MAD)2
Skewness3.2721201
Sum1022
Variance299.30465
MonotonicityNot monotonic
2023-12-10T18:47:57.662036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
2 31
31.0%
4 14
14.0%
3 10
 
10.0%
8 7
 
7.0%
6 7
 
7.0%
5 6
 
6.0%
12 3
 
3.0%
9 3
 
3.0%
18 2
 
2.0%
14 2
 
2.0%
Other values (14) 15
15.0%
ValueCountFrequency (%)
1 1
 
1.0%
2 31
31.0%
3 10
 
10.0%
4 14
14.0%
5 6
 
6.0%
6 7
 
7.0%
7 1
 
1.0%
8 7
 
7.0%
9 3
 
3.0%
11 1
 
1.0%
ValueCountFrequency (%)
98 1
1.0%
80 1
1.0%
75 1
1.0%
69 1
1.0%
52 1
1.0%
40 1
1.0%
39 1
1.0%
38 1
1.0%
36 1
1.0%
35 1
1.0%

Interactions

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

Correlations

2023-12-10T18:47:57.923500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Social_Data_Collection_Date_YMArtist_NMCommunity_KEY_WKeyword_FQ
Social_Data_Collection_Date_YM1.0000.2860.0000.488
Artist_NM0.2861.0000.8670.000
Community_KEY_W0.0000.8671.0000.000
Keyword_FQ0.4880.0000.0001.000
2023-12-10T18:47:58.281249image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Social_Data_Collection_Date_YMArtist_NMCommunity_KEY_W
Social_Data_Collection_Date_YM1.0000.1660.000
Artist_NM0.1661.0000.429
Community_KEY_W0.0000.4291.000
2023-12-10T18:47:58.494475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Keyword_FQSocial_Data_Collection_Date_YMArtist_NMCommunity_KEY_W
Keyword_FQ1.0000.2280.0000.000
Social_Data_Collection_Date_YM0.2281.0000.1660.000
Artist_NM0.0000.1661.0000.429
Community_KEY_W0.0000.0000.4291.000

Missing values

2023-12-10T18:47:54.927466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T18:47:55.157036image/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-01aucommunitybtsbts69
12017-01aucommunitygot7jackson19
22017-01aucommunitytwicetwice12
32017-01aucommunitybtsyoutube12
42017-01aucommunityexoexo9
52017-01aucommunityeverglowblackpink8
62017-01aucommunityblackpinkblackpink6
72017-01aucommunitygot7youtube6
82017-01aucommunityblackpinkjisoo5
92017-01aucommunityeverglowmmamelon5
Social_Data_Collection_Date_YMCountry_CDCollection_CH_NMArtist_NMCommunity_KEY_WKeyword_FQ
902017-04aucommunitygot7jackson36
912017-04aucommunitygot7youtube18
922017-04aucommunitygot7amp14
932017-04aucommunitybtsamp12
942017-04aucommunitybts방탄소년단11
952017-04aucommunitybtskpop9
962017-04aucommunityeverglowblackpink8
972017-04aucommunitygot7jinyoung8
982017-04aucommunitygot7kpop8
992017-04aucommunitybtsbtstwt7