Overview

Dataset statistics

Number of variables6
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.0 KiB
Average record size in memory51.3 B

Variable types

Categorical5
Numeric1

Alerts

Country_CD has constant value ""Constant
FILE_NAME has constant value ""Constant
BASE_YMD has constant value ""Constant
Views_CO is highly overall correlated with Artist_NMHigh correlation
Artist_NM is highly overall correlated with Views_COHigh correlation
Views_CO has unique valuesUnique

Reproduction

Analysis started2023-12-10 10:14:32.324491
Analysis finished2023-12-10 10:14:33.427709
Duration1.1 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Survey_Date_DE
Categorical

Distinct6
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2019-12-16
19 
2019-12-17
19 
2019-12-18
19 
2019-12-19
19 
2019-12-20
19 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2019-12-16
2nd row2019-12-16
3rd row2019-12-16
4th row2019-12-16
5th row2019-12-16

Common Values

ValueCountFrequency (%)
2019-12-16 19
19.0%
2019-12-17 19
19.0%
2019-12-18 19
19.0%
2019-12-19 19
19.0%
2019-12-20 19
19.0%
2019-12-21 5
 
5.0%

Length

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

Common Values (Plot)

2023-12-10T19:14:33.764101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2019-12-16 19
19.0%
2019-12-17 19
19.0%
2019-12-18 19
19.0%
2019-12-19 19
19.0%
2019-12-20 19
19.0%
2019-12-21 5
 
5.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-10T19:14:33.976268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Artist_NM
Categorical

HIGH CORRELATION 

Distinct19
Distinct (%)19.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
BTS(방탄소년단)
 
6
Stray Kids
 
6
MAMAMOO (마마무)
 
6
EXO(엑소)
 
6
TWICE(트와이스)
 
6
Other values (14)
70 

Length

Max length19
Median length13
Mean length10.71
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowBTS(방탄소년단)
2nd rowEXO(엑소)
3rd rowTWICE(트와이스)
4th rowStray Kids
5th rowMAMAMOO (마마무)

Common Values

ValueCountFrequency (%)
BTS(방탄소년단) 6
 
6.0%
Stray Kids 6
 
6.0%
MAMAMOO (마마무) 6
 
6.0%
EXO(엑소) 6
 
6.0%
TWICE(트와이스) 6
 
6.0%
GOT7 5
 
5.0%
Red Velvet(레드벨벳) 5
 
5.0%
SEVENTEEN(세븐틴) 5
 
5.0%
SUPER JUNIOR(슈퍼주니어) 5
 
5.0%
TOMORROW X TOGETHER 5
 
5.0%
Other values (9) 45
45.0%

Length

2023-12-10T19:14:34.344273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
bts(방탄소년단 6
 
3.9%
kids 6
 
3.9%
mamamoo 6
 
3.9%
마마무 6
 
3.9%
exo(엑소 6
 
3.9%
twice(트와이스 6
 
3.9%
stray 6
 
3.9%
오마이걸(oh 5
 
3.3%
nct 5
 
3.3%
winner 5
 
3.3%
Other values (19) 95
62.5%

Views_CO
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean213860.48
Minimum4165
Maximum1501737
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:14:34.652508image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4165
5-th percentile7938.6
Q133862
median84130
Q3143348
95-th percentile1283790.9
Maximum1501737
Range1497572
Interquartile range (IQR)109486

Descriptive statistics

Standard deviation346605.56
Coefficient of variation (CV)1.6207088
Kurtosis5.1821605
Mean213860.48
Median Absolute Deviation (MAD)54071
Skewness2.466564
Sum21386048
Variance1.2013542 × 1011
MonotonicityNot monotonic
2023-12-10T19:14:34.920010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1293062 1
 
1.0%
103146 1
 
1.0%
8683 1
 
1.0%
16893 1
 
1.0%
32864 1
 
1.0%
33967 1
 
1.0%
35813 1
 
1.0%
53721 1
 
1.0%
70694 1
 
1.0%
80697 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
4165 1
1.0%
4177 1
1.0%
4586 1
1.0%
4751 1
1.0%
6164 1
1.0%
8032 1
1.0%
8275 1
1.0%
8382 1
1.0%
8434 1
1.0%
8683 1
1.0%
ValueCountFrequency (%)
1501737 1
1.0%
1348766 1
1.0%
1343791 1
1.0%
1322870 1
1.0%
1293062 1
1.0%
1283303 1
1.0%
943679 1
1.0%
865626 1
1.0%
836445 1
1.0%
781580 1
1.0%

FILE_NAME
Categorical

CONSTANT 

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

Length

Max length23
Median length23
Mean length23
Min length23

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
KC_YOUTUBE_VIEW_ID_2019 100
100.0%

Length

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

Common Values (Plot)

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

BASE_YMD
Categorical

CONSTANT 

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

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2019 100
100.0%

Length

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

Common Values (Plot)

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

Interactions

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

Correlations

2023-12-10T19:14:35.746631image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Survey_Date_DEArtist_NMViews_CO
Survey_Date_DE1.0000.0000.365
Artist_NM0.0001.0000.858
Views_CO0.3650.8581.000
2023-12-10T19:14:35.895738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Survey_Date_DEArtist_NM
Survey_Date_DE1.0000.000
Artist_NM0.0001.000
2023-12-10T19:14:36.045479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Views_COSurvey_Date_DEArtist_NM
Views_CO1.0000.2080.551
Survey_Date_DE0.2081.0000.000
Artist_NM0.5510.0001.000

Missing values

2023-12-10T19:14:33.065575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T19:14:33.339998image/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

Survey_Date_DECountry_CDArtist_NMViews_COFILE_NAMEBASE_YMD
02019-12-16idBTS(방탄소년단)1293062KC_YOUTUBE_VIEW_ID_20192019
12019-12-16idEXO(엑소)943679KC_YOUTUBE_VIEW_ID_20192019
22019-12-16idTWICE(트와이스)377974KC_YOUTUBE_VIEW_ID_20192019
32019-12-16idStray Kids224515KC_YOUTUBE_VIEW_ID_20192019
42019-12-16idMAMAMOO (마마무)147182KC_YOUTUBE_VIEW_ID_20192019
52019-12-16idRed Velvet(레드벨벳)140825KC_YOUTUBE_VIEW_ID_20192019
62019-12-16idSEVENTEEN(세븐틴)117005KC_YOUTUBE_VIEW_ID_20192019
72019-12-16idSUPER JUNIOR(슈퍼주니어)107402KC_YOUTUBE_VIEW_ID_20192019
82019-12-16idTOMORROW X TOGETHER87739KC_YOUTUBE_VIEW_ID_20192019
92019-12-16idIZ*ONE (아이즈원)85370KC_YOUTUBE_VIEW_ID_20192019
Survey_Date_DECountry_CDArtist_NMViews_COFILE_NAMEBASE_YMD
902019-12-20idWINNER32897KC_YOUTUBE_VIEW_ID_20192019
912019-12-20idNCT26877KC_YOUTUBE_VIEW_ID_20192019
922019-12-20idCLC14463KC_YOUTUBE_VIEW_ID_20192019
932019-12-20id오마이걸(OH MY GIRL)8032KC_YOUTUBE_VIEW_ID_20192019
942019-12-20idBlackpink4165KC_YOUTUBE_VIEW_ID_20192019
952019-12-21idBTS(방탄소년단)1348766KC_YOUTUBE_VIEW_ID_20192019
962019-12-21idEXO(엑소)690453KC_YOUTUBE_VIEW_ID_20192019
972019-12-21idTWICE(트와이스)369605KC_YOUTUBE_VIEW_ID_20192019
982019-12-21idMAMAMOO (마마무)163478KC_YOUTUBE_VIEW_ID_20192019
992019-12-21idStray Kids156051KC_YOUTUBE_VIEW_ID_20192019