Dataset statistics
| Number of variables | 5 |
|---|---|
| Number of observations | 100 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 4.1 KiB |
| Average record size in memory | 42.3 B |
Variable types
| DateTime | 1 |
|---|---|
| Categorical | 3 |
| Numeric | 1 |
Dataset
| Description | Sample |
|---|---|
| Author | 한국문화정보원 |
| URL | https://www.bigdata-culture.kr/bigdata/user/data_market/detail.do?id=b73e7720-6288-11ea-8b67-7b32ce18203a |
Country_CD has constant value "" | Constant |
Collection_CH_NM has constant value "" | Constant |
Reproduction
| Analysis started | 2023-12-10 09:52:48.258376 |
|---|---|
| Analysis finished | 2023-12-10 09:52:48.839978 |
| Duration | 0.58 seconds |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
| Distinct | 12 |
|---|---|
| Distinct (%) | 12.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.0 B |
| Minimum | 2017-01-01 00:00:00 |
|---|---|
| Maximum | 2017-12-01 00:00:00 |
Histogram with fixed size bins (bins=12)
Country_CD
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.0 B |
| id |
|---|
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | id |
|---|---|
| 2nd row | id |
| 3rd row | id |
| 4th row | id |
| 5th row | id |
Common Values
| Value | Count | Frequency (%) |
| id | 100 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| id | 100 |
Collection_CH_NM
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.0 B |
| community |
|---|
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | community |
|---|---|
| 2nd row | community |
| 3rd row | community |
| 4th row | community |
| 5th row | community |
Common Values
| Value | Count | Frequency (%) |
| community | 100 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| community | 100 |
Community_KEY_W
Categorical
| Distinct | 32 |
|---|---|
| Distinct (%) | 32.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.0 B |
| kpop | |
|---|---|
| youtube | |
| bts | |
| suka | |
| saya | |
| Other values (27) |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 4.94 |
| Min length | 3 |
Unique
| Unique | 16 ? |
|---|---|
| Unique (%) | 16.0% |
Sample
| 1st row | kpop |
|---|---|
| 2nd row | youtube |
| 3rd row | bts |
| 4th row | cnblue |
| 5th row | exo |
Common Values
| Value | Count | Frequency (%) |
| kpop | 12 | |
| youtube | 12 | |
| bts | 11 | 11.0% |
| suka | 7 | 7.0% |
| saya | 7 | 7.0% |
| exo | 6 | 6.0% |
| allkpop | 5 | 5.0% |
| btstwt | 4 | 4.0% |
| jackson | 4 | 4.0% |
| song | 3 | 3.0% |
| Other values (22) | 29 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| kpop | 12 | |
| youtube | 12 | |
| bts | 11 | 11.0% |
| suka | 7 | 7.0% |
| saya | 7 | 7.0% |
| exo | 6 | 6.0% |
| allkpop | 5 | 5.0% |
| btstwt | 4 | 4.0% |
| jackson | 4 | 4.0% |
| song | 3 | 3.0% |
| Other values (22) | 29 |
Keyword_FQ
Real number (ℝ)
| Distinct | 39 |
|---|---|
| Distinct (%) | 39.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.53 |
| Minimum | 4 |
|---|---|
| Maximum | 102 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 6 |
| median | 8.5 |
| Q3 | 23.5 |
| 95-th percentile | 79.3 |
| Maximum | 102 |
| Range | 98 |
| Interquartile range (IQR) | 17.5 |
Descriptive statistics
| Standard deviation | 24.33622 |
|---|---|
| Coefficient of variation (CV) | 1.185398 |
| Kurtosis | 2.1018773 |
| Mean | 20.53 |
| Median Absolute Deviation (MAD) | 3.5 |
| Skewness | 1.7818289 |
| Sum | 2053 |
| Variance | 592.25162 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=39)
| Value | Count | Frequency (%) |
| 6 | 14 | |
| 5 | 11 | 11.0% |
| 4 | 11 | 11.0% |
| 7 | 8 | 8.0% |
| 8 | 6 | 6.0% |
| 10 | 4 | 4.0% |
| 11 | 4 | 4.0% |
| 9 | 3 | 3.0% |
| 12 | 3 | 3.0% |
| 85 | 2 | 2.0% |
| Other values (29) | 34 |
| Value | Count | Frequency (%) |
| 4 | 11 | |
| 5 | 11 | |
| 6 | 14 | |
| 7 | 8 | |
| 8 | 6 | |
| 9 | 3 | 3.0% |
| 10 | 4 | 4.0% |
| 11 | 4 | 4.0% |
| 12 | 3 | 3.0% |
| 13 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 102 | 1 | |
| 88 | 1 | |
| 87 | 1 | |
| 85 | 2 | |
| 79 | 1 | |
| 77 | 1 | |
| 73 | 1 | |
| 70 | 1 | |
| 63 | 1 | |
| 62 | 1 |
| Social_Data_Collection_Date_YM | Community_KEY_W | Keyword_FQ | |
|---|---|---|---|
| Social_Data_Collection_Date_YM | 1.000 | 0.000 | 0.000 |
| Community_KEY_W | 0.000 | 1.000 | 0.000 |
| Keyword_FQ | 0.000 | 0.000 | 1.000 |
| Keyword_FQ | Community_KEY_W | |
|---|---|---|
| Keyword_FQ | 1.000 | 0.000 |
| Community_KEY_W | 0.000 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| Social_Data_Collection_Date_YM | Country_CD | Collection_CH_NM | Community_KEY_W | Keyword_FQ | |
|---|---|---|---|---|---|
| 0 | 2017-01 | id | community | kpop | 85 |
| 1 | 2017-01 | id | community | youtube | 36 |
| 2 | 2017-01 | id | community | bts | 25 |
| 3 | 2017-01 | id | community | cnblue | 10 |
| 4 | 2017-01 | id | community | exo | 8 |
| 5 | 2017-01 | id | community | amp | 5 |
| 6 | 2017-01 | id | community | nct | 5 |
| 7 | 2017-01 | id | community | seohyun | 5 |
| 8 | 2017-02 | id | community | kpop | 77 |
| 9 | 2017-02 | id | community | youtube | 63 |
| Social_Data_Collection_Date_YM | Country_CD | Collection_CH_NM | Community_KEY_W | Keyword_FQ | |
|---|---|---|---|---|---|
| 90 | 2017-11 | id | community | exo | 7 |
| 91 | 2017-11 | id | community | jackson | 7 |
| 92 | 2017-12 | id | community | kpop | 102 |
| 93 | 2017-12 | id | community | youtube | 40 |
| 94 | 2017-12 | id | community | bts | 8 |
| 95 | 2017-12 | id | community | fans | 7 |
| 96 | 2017-12 | id | community | btstwt | 6 |
| 97 | 2017-12 | id | community | saya | 6 |
| 98 | 2017-12 | id | community | songs | 6 |
| 99 | 2017-12 | id | community | suka | 6 |