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:45:50.367206
Analysis finished2023-12-10 09:45:51.200217
Duration0.83 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Social_Data_Collection_Date_YM
Categorical

Distinct6
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2017-02
19 
2017-05
19 
2017-03
18 
2017-04
17 
2017-01
16 

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-02 19
19.0%
2017-05 19
19.0%
2017-03 18
18.0%
2017-04 17
17.0%
2017-01 16
16.0%
2017-06 11
11.0%

Length

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

Common Values (Plot)

2023-12-10T18:45:51.522335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2017-02 19
19.0%
2017-05 19
19.0%
2017-03 18
18.0%
2017-04 17
17.0%
2017-01 16
16.0%
2017-06 11
11.0%

Country_CD
Categorical

CONSTANT 

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

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
us 100
100.0%

Length

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

Common Values (Plot)

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

Common Values (Plot)

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

Community_KEY_W
Categorical

Distinct35
Distinct (%)35.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
kpop
 
6
bts
 
6
amp
 
6
fans
 
6
youtube
 
6
Other values (30)
70 

Length

Max length9
Median length6
Mean length4.85
Min length3

Unique

Unique15 ?
Unique (%)15.0%

Sample

1st rowkpop
2nd rowyoutube
3rd rowexo
4th rowalbum
5th rowjackson

Common Values

ValueCountFrequency (%)
kpop 6
 
6.0%
bts 6
 
6.0%
amp 6
 
6.0%
fans 6
 
6.0%
youtube 6
 
6.0%
jackson 6
 
6.0%
song 5
 
5.0%
songs 5
 
5.0%
idols 5
 
5.0%
exo 4
 
4.0%
Other values (25) 45
45.0%

Length

2023-12-10T18:45:52.506373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
kpop 6
 
6.0%
amp 6
 
6.0%
fans 6
 
6.0%
youtube 6
 
6.0%
jackson 6
 
6.0%
bts 6
 
6.0%
song 5
 
5.0%
songs 5
 
5.0%
idols 5
 
5.0%
exo 4
 
4.0%
Other values (25) 45
45.0%

Keyword_FQ
Real number (ℝ)

Distinct35
Distinct (%)35.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean31.02
Minimum4
Maximum434
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:45:52.736173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4
5-th percentile5
Q16
median10
Q321
95-th percentile219.5
Maximum434
Range430
Interquartile range (IQR)15

Descriptive statistics

Standard deviation68.195497
Coefficient of variation (CV)2.1984364
Kurtosis17.279545
Mean31.02
Median Absolute Deviation (MAD)4
Skewness4.0620082
Sum3102
Variance4650.6259
MonotonicityNot monotonic
2023-12-10T18:45:52.967719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
6 12
 
12.0%
5 10
 
10.0%
7 9
 
9.0%
10 8
 
8.0%
9 7
 
7.0%
8 6
 
6.0%
4 4
 
4.0%
25 3
 
3.0%
15 3
 
3.0%
13 3
 
3.0%
Other values (25) 35
35.0%
ValueCountFrequency (%)
4 4
 
4.0%
5 10
10.0%
6 12
12.0%
7 9
9.0%
8 6
6.0%
9 7
7.0%
10 8
8.0%
11 3
 
3.0%
12 3
 
3.0%
13 3
 
3.0%
ValueCountFrequency (%)
434 1
1.0%
323 1
1.0%
254 1
1.0%
246 1
1.0%
229 1
1.0%
219 1
1.0%
61 2
2.0%
59 2
2.0%
51 1
1.0%
48 1
1.0%

Interactions

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

Correlations

2023-12-10T18:45:53.136125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Social_Data_Collection_Date_YMCommunity_KEY_WKeyword_FQ
Social_Data_Collection_Date_YM1.0000.0000.088
Community_KEY_W0.0001.0000.000
Keyword_FQ0.0880.0001.000
2023-12-10T18:45:53.441164image/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:45:53.618826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Keyword_FQSocial_Data_Collection_Date_YMCommunity_KEY_W
Keyword_FQ1.0000.0220.000
Social_Data_Collection_Date_YM0.0221.0000.000
Community_KEY_W0.0000.0001.000

Missing values

2023-12-10T18:45:50.894906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T18:45:51.094446image/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-01uscommunitykpop254
12017-01uscommunityyoutube61
22017-01uscommunityexo29
32017-01uscommunityalbum24
42017-01uscommunityjackson21
52017-01uscommunitybts19
62017-01uscommunityamp14
72017-01uscommunitymusic11
82017-01uscommunitysongs10
92017-01uscommunityidols9
Social_Data_Collection_Date_YMCountry_CDCollection_CH_NMCommunity_KEY_WKeyword_FQ
902017-06uscommunityyoutube61
912017-06uscommunitykorean48
922017-06uscommunityjackson41
932017-06uscommunityamp25
942017-06uscommunityfans19
952017-06uscommunitybts16
962017-06uscommunityidols15
972017-06uscommunityalbum12
982017-06uscommunitysong10
992017-06uscommunitytwitter10