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 10:09:28.826322
Analysis finished2023-12-10 10:09:29.513685
Duration0.69 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Social_Data_Collection_Date_YM
Categorical

Distinct12
Distinct (%)12.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2017-05
12 
2017-10
10 
2017-11
10 
2017-01
9 
2017-03
9 
Other values (7)
50 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique1 ?
Unique (%)1.0%

Sample

1st row2017-01
2nd row2017-01
3rd row2017-01
4th row2017-01
5th row2017-01

Common Values

ValueCountFrequency (%)
2017-05 12
12.0%
2017-10 10
10.0%
2017-11 10
10.0%
2017-01 9
9.0%
2017-03 9
9.0%
2017-06 9
9.0%
2017-07 9
9.0%
2017-08 9
9.0%
2017-04 8
8.0%
2017-09 8
8.0%
Other values (2) 7
7.0%

Length

2023-12-10T19:09:29.645998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2017-05 12
12.0%
2017-10 10
10.0%
2017-11 10
10.0%
2017-01 9
9.0%
2017-03 9
9.0%
2017-06 9
9.0%
2017-07 9
9.0%
2017-08 9
9.0%
2017-04 8
8.0%
2017-09 8
8.0%
Other values (2) 7
7.0%

Country_CD
Categorical

CONSTANT 

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

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
gb 100
100.0%

Length

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

Common Values (Plot)

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

Common Values (Plot)

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

Community_KEY_W
Categorical

Distinct31
Distinct (%)31.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
kpop
12 
youtube
11 
bts
11 
amp
9 
jackson
8 
Other values (26)
49 

Length

Max length10
Median length9
Mean length4.84
Min length3

Unique

Unique17 ?
Unique (%)17.0%

Sample

1st rowkpop
2nd rowyoutube
3rd rowbts
4th rowamp
5th rowalbums

Common Values

ValueCountFrequency (%)
kpop 12
12.0%
youtube 11
11.0%
bts 11
11.0%
amp 9
 
9.0%
jackson 8
 
8.0%
songs 6
 
6.0%
fans 5
 
5.0%
exo 4
 
4.0%
idols 4
 
4.0%
song 4
 
4.0%
Other values (21) 26
26.0%

Length

2023-12-10T19:09:30.528891image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
kpop 12
12.0%
bts 11
11.0%
youtube 11
11.0%
amp 9
 
9.0%
jackson 8
 
8.0%
songs 6
 
6.0%
fans 5
 
5.0%
exo 4
 
4.0%
idols 4
 
4.0%
song 4
 
4.0%
Other values (21) 26
26.0%

Keyword_FQ
Real number (ℝ)

Distinct30
Distinct (%)30.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean16.66
Minimum2
Maximum187
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:09:30.738250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile2
Q14
median5
Q312.25
95-th percentile87
Maximum187
Range185
Interquartile range (IQR)8.25

Descriptive statistics

Standard deviation30.370181
Coefficient of variation (CV)1.82294
Kurtosis12.132388
Mean16.66
Median Absolute Deviation (MAD)2
Skewness3.3024762
Sum1666
Variance922.34788
MonotonicityNot monotonic
2023-12-10T19:09:30.966888image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
4 20
20.0%
3 17
17.0%
5 9
 
9.0%
2 7
 
7.0%
8 6
 
6.0%
6 6
 
6.0%
12 3
 
3.0%
9 3
 
3.0%
14 2
 
2.0%
17 2
 
2.0%
Other values (20) 25
25.0%
ValueCountFrequency (%)
2 7
 
7.0%
3 17
17.0%
4 20
20.0%
5 9
9.0%
6 6
 
6.0%
7 2
 
2.0%
8 6
 
6.0%
9 3
 
3.0%
10 1
 
1.0%
11 1
 
1.0%
ValueCountFrequency (%)
187 1
1.0%
129 1
1.0%
104 1
1.0%
102 1
1.0%
87 2
2.0%
82 1
1.0%
75 1
1.0%
69 1
1.0%
66 1
1.0%
40 1
1.0%

Interactions

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

Correlations

2023-12-10T19:09:31.112226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Social_Data_Collection_Date_YMCommunity_KEY_WKeyword_FQ
Social_Data_Collection_Date_YM1.0000.0000.665
Community_KEY_W0.0001.0000.000
Keyword_FQ0.6650.0001.000
2023-12-10T19:09:31.278574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Social_Data_Collection_Date_YMCommunity_KEY_W
Social_Data_Collection_Date_YM1.0000.000
Community_KEY_W0.0001.000
2023-12-10T19:09:31.431127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Keyword_FQSocial_Data_Collection_Date_YMCommunity_KEY_W
Keyword_FQ1.0000.3450.000
Social_Data_Collection_Date_YM0.3451.0000.000
Community_KEY_W0.0000.0001.000

Missing values

2023-12-10T19:09:29.264331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T19:09:29.442396image/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-01gbcommunitykpop187
12017-01gbcommunityyoutube9
22017-01gbcommunitybts7
32017-01gbcommunityamp5
42017-01gbcommunityalbums3
52017-01gbcommunitymusic3
62017-01gbcommunitybigbang2
72017-01gbcommunityidols2
82017-01gbcommunityjackson2
92017-02gbcommunitykpop87
Social_Data_Collection_Date_YMCountry_CDCollection_CH_NMCommunity_KEY_WKeyword_FQ
902017-11gbcommunityjackson17
912017-11gbcommunitybts14
922017-11gbcommunityyoutube13
932017-11gbcommunityfan11
942017-11gbcommunityamp10
952017-11gbcommunityfans9
962017-11gbcommunitybtstwt5
972017-11gbcommunityexo5
982017-11gbcommunitysongs4
992017-12gbcommunitykpop129