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

DateTime1
Categorical3
Numeric1

Alerts

Collection_CH_NM has constant value ""Constant

Reproduction

Analysis started2023-12-10 09:52:29.571495
Analysis finished2023-12-10 09:52:30.467372
Duration0.9 seconds
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-10T18:52:30.613267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:52:30.831295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=2)

Collection_CH_NM
Categorical

CONSTANT 

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

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
Twitter 100
100.0%

Length

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

Common Values (Plot)

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

Artist_NM
Categorical

Distinct13
Distinct (%)13.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
blackpink
19 
exo
11 
twice
11 
BTS
10 
nct
10 
Other values (8)
39 

Length

Max length9
Median length7
Mean length5.54
Min length3

Unique

Unique1 ?
Unique (%)1.0%

Sample

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

Common Values

ValueCountFrequency (%)
blackpink 19
19.0%
exo 11
11.0%
twice 11
11.0%
BTS 10
10.0%
nct 10
10.0%
seventeen 8
8.0%
mamamoo 7
 
7.0%
day6 6
 
6.0%
winner 6
 
6.0%
got7 5
 
5.0%
Other values (3) 7
 
7.0%

Length

2023-12-10T18:52:31.959548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
blackpink 19
19.0%
exo 11
11.0%
twice 11
11.0%
bts 10
10.0%
nct 10
10.0%
seventeen 8
8.0%
mamamoo 7
 
7.0%
day6 6
 
6.0%
winner 6
 
6.0%
got7 5
 
5.0%
Other values (3) 7
 
7.0%

Twitter_KEY_W
Categorical

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

Length

Max length10
Median length9
Mean length5.04
Min length3

Unique

Unique24 ?
Unique (%)24.0%

Sample

1st rowblackpink
2nd rowyoutube
3rd rowblackpinks
4th rowjisoo
5th rowamp

Common Values

ValueCountFrequency (%)
youtube 12
 
12.0%
amp 11
 
11.0%
bts 9
 
9.0%
kpop 8
 
8.0%
exo 6
 
6.0%
blackpink 5
 
5.0%
music 5
 
5.0%
mbc 5
 
5.0%
jackson 3
 
3.0%
jisoo 2
 
2.0%
Other values (29) 34
34.0%

Length

2023-12-10T18:52:32.257009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
youtube 12
 
12.0%
amp 11
 
11.0%
bts 9
 
9.0%
kpop 8
 
8.0%
exo 6
 
6.0%
blackpink 5
 
5.0%
music 5
 
5.0%
mbc 5
 
5.0%
jackson 3
 
3.0%
twice 2
 
2.0%
Other values (29) 34
34.0%

Keyword_FQ
Real number (ℝ)

Distinct88
Distinct (%)88.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean522.93
Minimum2
Maximum13279
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:52:32.589556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile6.95
Q137.75
median85.5
Q3283
95-th percentile1467.7
Maximum13279
Range13277
Interquartile range (IQR)245.25

Descriptive statistics

Standard deviation1788.7065
Coefficient of variation (CV)3.4205467
Kurtosis39.177593
Mean522.93
Median Absolute Deviation (MAD)73
Skewness6.1122182
Sum52293
Variance3199471
MonotonicityNot monotonic
2023-12-10T18:52:32.905793image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
41 3
 
3.0%
22 2
 
2.0%
10 2
 
2.0%
45 2
 
2.0%
320 2
 
2.0%
87 2
 
2.0%
6 2
 
2.0%
83 2
 
2.0%
2 2
 
2.0%
17 2
 
2.0%
Other values (78) 79
79.0%
ValueCountFrequency (%)
2 2
2.0%
4 1
1.0%
6 2
2.0%
7 1
1.0%
8 1
1.0%
9 1
1.0%
10 2
2.0%
11 1
1.0%
12 1
1.0%
13 1
1.0%
ValueCountFrequency (%)
13279 1
1.0%
11325 1
1.0%
4316 1
1.0%
2438 1
1.0%
1500 1
1.0%
1466 1
1.0%
1407 1
1.0%
1216 1
1.0%
1137 1
1.0%
969 1
1.0%

Interactions

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

Correlations

2023-12-10T18:52:33.082578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Social_Data_Collection_Date_YMArtist_NMTwitter_KEY_WKeyword_FQ
Social_Data_Collection_Date_YM1.0000.6470.0000.090
Artist_NM0.6471.0000.7480.039
Twitter_KEY_W0.0000.7481.0000.000
Keyword_FQ0.0900.0390.0001.000
2023-12-10T18:52:33.257153image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Artist_NMTwitter_KEY_W
Artist_NM1.0000.247
Twitter_KEY_W0.2471.000
2023-12-10T18:52:33.414874image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Keyword_FQArtist_NMTwitter_KEY_W
Keyword_FQ1.0000.0000.000
Artist_NM0.0001.0000.247
Twitter_KEY_W0.0000.2471.000

Missing values

2023-12-10T18:52:30.211937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T18:52:30.390477image/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_YMCollection_CH_NMArtist_NMTwitter_KEY_WKeyword_FQ
02017-01Twitterblackpinkblackpink1407
12017-01Twitterblackpinkyoutube320
22017-01Twitterblackpinkblackpinks293
32017-01Twitterblackpinkjisoo286
42017-01Twitterblackpinkamp272
52017-01Twitterblackpinkmbc190
62017-01Twitterblackpinklisa153
72017-01TwitterBTSbts11325
82017-01TwitterBTSyoutube1500
92017-01TwitterBTSmbc1216
Social_Data_Collection_Date_YMCollection_CH_NMArtist_NMTwitter_KEY_WKeyword_FQ
902017-02Twitterblackpinkdoyoung102
912017-02Twitterblackpinkjennie87
922017-02Twitterblackpinkbts83
932017-02Twitterblackpinkawards76
942017-02TwitterBTSbts13279
952017-02TwitterBTSyoutube2438
962017-02TwitterBTSamp812
972017-02TwitterBTSmusic547
982017-02Twitterday6song27
992017-02Twitterday6삁六ㅼ뼱23