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

Variables

Social_Data_Collection_Date_YM
Categorical

Distinct19
Distinct (%)19.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2017-11
9 
2018-01
8 
2017-05
8 
2017-10
7 
2018-04
7 
Other values (14)
61 

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-02
5th row2017-02

Common Values

ValueCountFrequency (%)
2017-11 9
 
9.0%
2018-01 8
 
8.0%
2017-05 8
 
8.0%
2017-10 7
 
7.0%
2018-04 7
 
7.0%
2017-08 7
 
7.0%
2018-06 6
 
6.0%
2017-07 6
 
6.0%
2017-12 6
 
6.0%
2018-02 5
 
5.0%
Other values (9) 31
31.0%

Length

2023-12-10T18:54:05.636194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2017-11 9
 
9.0%
2017-05 8
 
8.0%
2018-01 8
 
8.0%
2017-10 7
 
7.0%
2018-04 7
 
7.0%
2017-08 7
 
7.0%
2018-06 6
 
6.0%
2017-07 6
 
6.0%
2017-12 6
 
6.0%
2018-05 5
 
5.0%
Other values (9) 31
31.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:54:05.869388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:54:06.049392image/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:54:06.232658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Community_KEY_W
Categorical

Distinct29
Distinct (%)29.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
kpop
19 
youtube
14 
bts
14 
music
7 
jackson
5 
Other values (24)
41 

Length

Max length10
Median length8
Mean length4.97
Min length3

Unique

Unique14 ?
Unique (%)14.0%

Sample

1st rowkpop
2nd rowyoutube
3rd rowkorean
4th rowkpop
5th rowfan

Common Values

ValueCountFrequency (%)
kpop 19
19.0%
youtube 14
14.0%
bts 14
14.0%
music 7
 
7.0%
jackson 5
 
5.0%
btstwt 4
 
4.0%
song 3
 
3.0%
korean 3
 
3.0%
fan 3
 
3.0%
idols 3
 
3.0%
Other values (19) 25
25.0%

Length

2023-12-10T18:54:06.641593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
kpop 19
19.0%
bts 14
14.0%
youtube 14
14.0%
music 7
 
7.0%
jackson 5
 
5.0%
btstwt 4
 
4.0%
song 3
 
3.0%
korean 3
 
3.0%
fan 3
 
3.0%
idols 3
 
3.0%
Other values (19) 25
25.0%

Keyword_FQ
Real number (ℝ)

Distinct29
Distinct (%)29.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11.72
Minimum2
Maximum66
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:54:06.880613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile2
Q13
median4.5
Q310.25
95-th percentile46
Maximum66
Range64
Interquartile range (IQR)7.25

Descriptive statistics

Standard deviation14.61636
Coefficient of variation (CV)1.2471297
Kurtosis2.8044094
Mean11.72
Median Absolute Deviation (MAD)1.5
Skewness1.9249697
Sum1172
Variance213.63798
MonotonicityNot monotonic
2023-12-10T18:54:07.134134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%)
4 24
24.0%
3 19
19.0%
5 7
 
7.0%
2 7
 
7.0%
6 6
 
6.0%
7 4
 
4.0%
10 4
 
4.0%
50 2
 
2.0%
46 2
 
2.0%
39 2
 
2.0%
Other values (19) 23
23.0%
ValueCountFrequency (%)
2 7
 
7.0%
3 19
19.0%
4 24
24.0%
5 7
 
7.0%
6 6
 
6.0%
7 4
 
4.0%
8 2
 
2.0%
9 2
 
2.0%
10 4
 
4.0%
11 1
 
1.0%
ValueCountFrequency (%)
66 1
1.0%
59 1
1.0%
50 2
2.0%
46 2
2.0%
41 1
1.0%
40 1
1.0%
39 2
2.0%
38 1
1.0%
37 1
1.0%
36 1
1.0%

Interactions

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

Correlations

2023-12-10T18:54:07.307777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Social_Data_Collection_Date_YMCommunity_KEY_WKeyword_FQ
Social_Data_Collection_Date_YM1.0000.0000.540
Community_KEY_W0.0001.0000.000
Keyword_FQ0.5400.0001.000
2023-12-10T18:54:07.616554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Community_KEY_WSocial_Data_Collection_Date_YM
Community_KEY_W1.0000.000
Social_Data_Collection_Date_YM0.0001.000
2023-12-10T18:54:07.838232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Keyword_FQSocial_Data_Collection_Date_YMCommunity_KEY_W
Keyword_FQ1.0000.2190.000
Social_Data_Collection_Date_YM0.2191.0000.000
Community_KEY_W0.0000.0001.000

Missing values

2023-12-10T18:54:05.261400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T18:54:05.430578image/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-01aucommunitykpop27
12017-01aucommunityyoutube7
22017-01aucommunitykorean2
32017-02aucommunitykpop29
42017-02aucommunityfan3
52017-03aucommunitykpop25
62017-03aucommunityjackson4
72017-03aucommunityyoutube4
82017-04aucommunitykpop23
92017-04aucommunityfanmeeting3
Social_Data_Collection_Date_YMCountry_CDCollection_CH_NMCommunity_KEY_WKeyword_FQ
902018-05aucommunitytwitter5
912018-05aucommunityidol4
922018-05aucommunitybtstwt3
932018-06aucommunitykpop50
942018-06aucommunityyoutube10
952018-06aucommunitybts5
962018-06aucommunityidol5
972018-06aucommunityidols4
982018-06aucommunityarmy3
992018-07aucommunitykpop31