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:50:45.491222
Analysis finished2023-12-10 09:50:46.285662
Duration0.79 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-04
11 
2017-09
11 
2017-02
10 
2017-10
10 
2017-12
10 
Other values (7)
48 

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-04 11
11.0%
2017-09 11
11.0%
2017-02 10
10.0%
2017-10 10
10.0%
2017-12 10
10.0%
2017-05 9
9.0%
2017-11 9
9.0%
2017-01 7
7.0%
2017-08 7
7.0%
2017-03 6
6.0%
Other values (2) 10
10.0%

Length

2023-12-10T18:50:46.408052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2017-04 11
11.0%
2017-09 11
11.0%
2017-02 10
10.0%
2017-10 10
10.0%
2017-12 10
10.0%
2017-05 9
9.0%
2017-11 9
9.0%
2017-01 7
7.0%
2017-08 7
7.0%
2017-03 6
6.0%
Other values (2) 10
10.0%

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

Common Values (Plot)

2023-12-10T18:50:46.819255image/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
NEWS
100 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
NEWS 100
100.0%

Length

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

Common Values (Plot)

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

News_KEY_W
Categorical

Distinct32
Distinct (%)32.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
kpop
12 
korean
12 
korea
11 
album
9 
music
8 
Other values (27)
48 

Length

Max length15
Median length9
Mean length5.31
Min length3

Unique

Unique19 ?
Unique (%)19.0%

Sample

1st rowalbum
2nd rowkorean
3rd rowkorea
4th rowfans
5th rowkpop

Common Values

ValueCountFrequency (%)
kpop 12
12.0%
korean 12
12.0%
korea 11
11.0%
album 9
 
9.0%
music 8
 
8.0%
fans 6
 
6.0%
bts 6
 
6.0%
seoul 4
 
4.0%
twitter 4
 
4.0%
facebook 3
 
3.0%
Other values (22) 25
25.0%

Length

2023-12-10T18:50:47.387906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
kpop 12
12.0%
korean 12
12.0%
korea 11
11.0%
album 9
 
9.0%
music 8
 
8.0%
fans 6
 
6.0%
bts 6
 
6.0%
seoul 4
 
4.0%
twitter 4
 
4.0%
facebook 3
 
3.0%
Other values (22) 25
25.0%

Keyword_FQ
Real number (ℝ)

Distinct42
Distinct (%)42.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28.1
Minimum8
Maximum123
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:50:47.625560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum8
5-th percentile8.95
Q113.5
median21
Q331.25
95-th percentile68.75
Maximum123
Range115
Interquartile range (IQR)17.75

Descriptive statistics

Standard deviation22.579825
Coefficient of variation (CV)0.80355248
Kurtosis5.7838045
Mean28.1
Median Absolute Deviation (MAD)9
Skewness2.2202989
Sum2810
Variance509.84848
MonotonicityNot monotonic
2023-12-10T18:50:48.306487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=42)
ValueCountFrequency (%)
22 7
 
7.0%
10 6
 
6.0%
9 6
 
6.0%
19 5
 
5.0%
21 5
 
5.0%
8 5
 
5.0%
29 5
 
5.0%
18 4
 
4.0%
12 4
 
4.0%
11 4
 
4.0%
Other values (32) 49
49.0%
ValueCountFrequency (%)
8 5
5.0%
9 6
6.0%
10 6
6.0%
11 4
4.0%
12 4
4.0%
14 2
 
2.0%
15 2
 
2.0%
16 3
3.0%
17 3
3.0%
18 4
4.0%
ValueCountFrequency (%)
123 1
1.0%
121 1
1.0%
100 1
1.0%
88 1
1.0%
83 1
1.0%
68 1
1.0%
58 2
2.0%
55 2
2.0%
54 2
2.0%
53 2
2.0%

Interactions

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

Correlations

2023-12-10T18:50:48.496663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Social_Data_Collection_Date_YMNews_KEY_WKeyword_FQ
Social_Data_Collection_Date_YM1.0000.0000.574
News_KEY_W0.0001.0000.000
Keyword_FQ0.5740.0001.000
2023-12-10T18:50:48.666759image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Social_Data_Collection_Date_YMNews_KEY_W
Social_Data_Collection_Date_YM1.0000.000
News_KEY_W0.0001.000
2023-12-10T18:50:48.888358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Keyword_FQSocial_Data_Collection_Date_YMNews_KEY_W
Keyword_FQ1.0000.2740.000
Social_Data_Collection_Date_YM0.2741.0000.000
News_KEY_W0.0000.0001.000

Missing values

2023-12-10T18:50:45.949718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T18:50:46.150166image/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_NMNews_KEY_WKeyword_FQ
02017-01idNEWSalbum29
12017-01idNEWSkorean27
22017-01idNEWSkorea26
32017-01idNEWSfans22
42017-01idNEWSkpop20
52017-01idNEWSdrama16
62017-01idNEWSjaejoong16
72017-02idNEWSkorean28
82017-02idNEWSkorea20
92017-02idNEWSalbum19
Social_Data_Collection_Date_YMCountry_CDCollection_CH_NMNews_KEY_WKeyword_FQ
902017-12idNEWSkpop121
912017-12idNEWSbts83
922017-12idNEWSkorean68
932017-12idNEWSkorea58
942017-12idNEWSfans54
952017-12idNEWSmusic49
962017-12idNEWSseoul44
972017-12idNEWStwitter43
982017-12idNEWSjonghyun42
992017-12idNEWSsinger38