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

DateTime1
Categorical3
Text1
Numeric1

Alerts

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

Reproduction

Analysis started2023-12-10 10:09:13.771487
Analysis finished2023-12-10 10:09:14.934881
Duration1.16 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Social_Data_Collection_Date_YM
Date

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2017-01-01 00:00:00
Maximum2017-02-01 00:00:00
2023-12-10T19:09:15.036532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:09:15.315843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=2)

Country_CD
Categorical

CONSTANT 

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

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
ID 100
100.0%

Length

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

Common Values (Plot)

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

Common Values (Plot)

2023-12-10T19:09:16.103089image/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
43 
blackpink
16 
exo
9 
everglow
8 
got7
7 
Other values (7)
17 

Length

Max length9
Median length3
Mean length4.87
Min length3

Unique

Unique1 ?
Unique (%)1.0%

Sample

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

Common Values

ValueCountFrequency (%)
bts 43
43.0%
blackpink 16
 
16.0%
exo 9
 
9.0%
everglow 8
 
8.0%
got7 7
 
7.0%
nct 4
 
4.0%
seventeen 3
 
3.0%
winner 3
 
3.0%
jhope 2
 
2.0%
mamamoo 2
 
2.0%
Other values (2) 3
 
3.0%

Length

2023-12-10T19:09:16.319022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
bts 43
43.0%
blackpink 16
 
16.0%
exo 9
 
9.0%
everglow 8
 
8.0%
got7 7
 
7.0%
nct 4
 
4.0%
seventeen 3
 
3.0%
winner 3
 
3.0%
jhope 2
 
2.0%
mamamoo 2
 
2.0%
Other values (2) 3
 
3.0%

Community_KEY_W
Text

Distinct50
Distinct (%)50.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T19:09:16.754285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length9
Mean length5.65
Min length2

Characters and Unicode

Total characters565
Distinct characters40
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique26 ?
Unique (%)26.0%

Sample

1st rowblackpink
2nd rowjisoo
3rd rowmbc
4th rowamp
5th rowblackpinks
ValueCountFrequency (%)
youtube 9
 
9.0%
kpop 6
 
6.0%
amp 6
 
6.0%
bts 5
 
5.0%
blackpink 4
 
4.0%
mbc 4
 
4.0%
album 3
 
3.0%
btstwt 3
 
3.0%
exo 3
 
3.0%
army 3
 
3.0%
Other values (40) 54
54.0%
2023-12-10T19:09:17.365569image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
o 51
 
9.0%
a 47
 
8.3%
n 38
 
6.7%
t 36
 
6.4%
b 35
 
6.2%
m 34
 
6.0%
s 34
 
6.0%
i 31
 
5.5%
u 30
 
5.3%
e 30
 
5.3%
Other values (30) 199
35.2%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 544
96.3%
Other Letter 21
 
3.7%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
o 51
 
9.4%
a 47
 
8.6%
n 38
 
7.0%
t 36
 
6.6%
b 35
 
6.4%
m 34
 
6.2%
s 34
 
6.2%
i 31
 
5.7%
u 30
 
5.5%
e 30
 
5.5%
Other values (14) 178
32.7%
Other Letter
ValueCountFrequency (%)
탄 2
 
9.5%
소 2
 
9.5%
년 2
 
9.5%
단 2
 
9.5%
방 2
 
9.5%
랙 1
 
4.8%
봄 1
 
4.8%
크 1
 
4.8%
핑 1
 
4.8%
대 1
 
4.8%
Other values (6) 6
28.6%

Most occurring scripts

ValueCountFrequency (%)
Latin 544
96.3%
Hangul 21
 
3.7%

Most frequent character per script

Latin
ValueCountFrequency (%)
o 51
 
9.4%
a 47
 
8.6%
n 38
 
7.0%
t 36
 
6.6%
b 35
 
6.4%
m 34
 
6.2%
s 34
 
6.2%
i 31
 
5.7%
u 30
 
5.5%
e 30
 
5.5%
Other values (14) 178
32.7%
Hangul
ValueCountFrequency (%)
탄 2
 
9.5%
소 2
 
9.5%
년 2
 
9.5%
단 2
 
9.5%
방 2
 
9.5%
랙 1
 
4.8%
봄 1
 
4.8%
크 1
 
4.8%
핑 1
 
4.8%
대 1
 
4.8%
Other values (6) 6
28.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 544
96.3%
Hangul 21
 
3.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
o 51
 
9.4%
a 47
 
8.6%
n 38
 
7.0%
t 36
 
6.6%
b 35
 
6.4%
m 34
 
6.2%
s 34
 
6.2%
i 31
 
5.7%
u 30
 
5.5%
e 30
 
5.5%
Other values (14) 178
32.7%
Hangul
ValueCountFrequency (%)
탄 2
 
9.5%
소 2
 
9.5%
년 2
 
9.5%
단 2
 
9.5%
방 2
 
9.5%
랙 1
 
4.8%
봄 1
 
4.8%
크 1
 
4.8%
핑 1
 
4.8%
대 1
 
4.8%
Other values (6) 6
28.6%

Keyword_FQ
Real number (ℝ)

Distinct37
Distinct (%)37.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28.96
Minimum2
Maximum478
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:09:17.771885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile2
Q16
median12
Q322.5
95-th percentile88.75
Maximum478
Range476
Interquartile range (IQR)16.5

Descriptive statistics

Standard deviation68.218147
Coefficient of variation (CV)2.355599
Kurtosis33.403519
Mean28.96
Median Absolute Deviation (MAD)6
Skewness5.5611408
Sum2896
Variance4653.7156
MonotonicityNot monotonic
2023-12-10T19:09:18.019966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=37)
ValueCountFrequency (%)
5 8
 
8.0%
8 7
 
7.0%
16 7
 
7.0%
2 6
 
6.0%
4 6
 
6.0%
14 5
 
5.0%
11 5
 
5.0%
6 5
 
5.0%
9 4
 
4.0%
18 4
 
4.0%
Other values (27) 43
43.0%
ValueCountFrequency (%)
2 6
6.0%
3 3
 
3.0%
4 6
6.0%
5 8
8.0%
6 5
5.0%
7 2
 
2.0%
8 7
7.0%
9 4
4.0%
10 3
 
3.0%
11 5
5.0%
ValueCountFrequency (%)
478 1
1.0%
453 1
1.0%
180 1
1.0%
117 1
1.0%
103 1
1.0%
88 1
1.0%
86 1
1.0%
79 1
1.0%
74 1
1.0%
51 2
2.0%

Interactions

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

Correlations

2023-12-10T19:09:18.170219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Social_Data_Collection_Date_YMArtist_NMCommunity_KEY_WKeyword_FQ
Social_Data_Collection_Date_YM1.0000.5620.0000.025
Artist_NM0.5621.0000.3790.000
Community_KEY_W0.0000.3791.0000.000
Keyword_FQ0.0250.0000.0001.000
2023-12-10T19:09:18.406131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Keyword_FQArtist_NM
Keyword_FQ1.0000.000
Artist_NM0.0001.000

Missing values

2023-12-10T19:09:14.543044image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T19:09:14.787208image/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-01IDcommunityblackpinkblackpink88
12017-01IDcommunityblackpinkjisoo51
22017-01IDcommunityblackpinkmbc24
32017-01IDcommunityblackpinkamp14
42017-01IDcommunityblackpinkblackpinks12
52017-01IDcommunityblackpink블랙핑크11
62017-01IDcommunityblackpinkawards9
72017-01IDcommunityblackpinklisa9
82017-01IDcommunityblackpinkyoutube9
92017-01IDcommunitybtsbts478
Social_Data_Collection_Date_YMCountry_CDCollection_CH_NMArtist_NMCommunity_KEY_WKeyword_FQ
902017-02IDcommunitybtsmcountdown8
912017-02IDcommunitybtsmelon8
922017-02IDcommunitybtsexo7
932017-02IDcommunitybtsgfriend6
942017-02IDcommunitybtsjin6
952017-02IDcommunityday6youtube4
962017-02IDcommunityeverglowblackpink18
972017-02IDcommunityeverglowmmamelon6
982017-02IDcommunityeverglowfansign5
992017-02IDcommunityeverglowkpop3