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

DateTime1
Categorical4
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 09:58:48.799757
Analysis finished2023-12-10 09:58:49.858388
Duration1.06 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Survey_Date_DE
Date

Distinct6
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2019-12-16 00:00:00
Maximum2019-12-21 00:00:00
2023-12-10T18:58:50.056867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:58:50.327499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)

Country_CD
Categorical

CONSTANT 

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

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
vn 100
100.0%

Length

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

Common Values (Plot)

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

Artist_NM
Categorical

HIGH CORRELATION 

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

Length

Max length19
Median length13
Mean length10.7
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
BTS(방탄소년단) 6
 
6.0%
MAMAMOO (마마무) 6
 
6.0%
EXO(엑소) 6
 
6.0%
Blackpink 6
 
6.0%
TWICE(트와이스) 6
 
6.0%
WINNER 5
 
5.0%
Stray Kids 5
 
5.0%
(G)I-DLE ((여자)아이들) 5
 
5.0%
Red Velvet(레드벨벳) 5
 
5.0%
ITZY(있지) 5
 
5.0%
Other values (9) 45
45.0%

Length

2023-12-10T18:58:51.676157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
bts(방탄소년단 6
 
4.0%
마마무 6
 
4.0%
exo(엑소 6
 
4.0%
blackpink 6
 
4.0%
twice(트와이스 6
 
4.0%
mamamoo 6
 
4.0%
nct 5
 
3.3%
아이즈원 5
 
3.3%
몬스타엑스 5
 
3.3%
clc 5
 
3.3%
Other values (19) 95
62.9%

Views_CO
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean107296.84
Minimum2462
Maximum676423
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:58:52.039581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2462
5-th percentile4599.9
Q120524.5
median35925
Q3127548.25
95-th percentile491136.35
Maximum676423
Range673961
Interquartile range (IQR)107023.75

Descriptive statistics

Standard deviation155976.38
Coefficient of variation (CV)1.4536904
Kurtosis3.2895902
Mean107296.84
Median Absolute Deviation (MAD)26932
Skewness2.0676553
Sum10729684
Variance2.4328632 × 1010
MonotonicityNot monotonic
2023-12-10T18:58:52.419238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
430025 1
 
1.0%
52092 1
 
1.0%
4711 1
 
1.0%
10133 1
 
1.0%
10676 1
 
1.0%
19077 1
 
1.0%
21117 1
 
1.0%
21188 1
 
1.0%
23575 1
 
1.0%
28411 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
2462 1
1.0%
2877 1
1.0%
3194 1
1.0%
3687 1
1.0%
4370 1
1.0%
4612 1
1.0%
4646 1
1.0%
4711 1
1.0%
4848 1
1.0%
5326 1
1.0%
ValueCountFrequency (%)
676423 1
1.0%
568102 1
1.0%
557900 1
1.0%
553994 1
1.0%
517762 1
1.0%
489735 1
1.0%
451989 1
1.0%
449554 1
1.0%
430025 1
1.0%
425108 1
1.0%

FILE_NAME
Categorical

CONSTANT 

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

Length

Max length23
Median length23
Mean length23
Min length23

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
KC_YOUTUBE_VIEW_VN_2019 100
100.0%

Length

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

Common Values (Plot)

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

Common Values (Plot)

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

Interactions

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

Correlations

2023-12-10T18:58:53.397350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Survey_Date_DEArtist_NMViews_CO
Survey_Date_DE1.0000.0000.325
Artist_NM0.0001.0000.862
Views_CO0.3250.8621.000
2023-12-10T18:58:53.558491image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Views_COArtist_NM
Views_CO1.0000.559
Artist_NM0.5591.000

Missing values

2023-12-10T18:58:49.457238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T18:58:49.719828image/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-16vnBTS(방탄소년단)430025KC_YOUTUBE_VIEW_VN_20192019
12019-12-16vnBlackpink401803KC_YOUTUBE_VIEW_VN_20192019
22019-12-16vnStray Kids348036KC_YOUTUBE_VIEW_VN_20192019
32019-12-16vnTWICE(트와이스)150659KC_YOUTUBE_VIEW_VN_20192019
42019-12-16vnMAMAMOO (마마무)132040KC_YOUTUBE_VIEW_VN_20192019
52019-12-16vnEXO(엑소)99492KC_YOUTUBE_VIEW_VN_20192019
62019-12-16vn(G)I-DLE ((여자)아이들)67049KC_YOUTUBE_VIEW_VN_20192019
72019-12-16vnRed Velvet(레드벨벳)49656KC_YOUTUBE_VIEW_VN_20192019
82019-12-16vnITZY(있지)37129KC_YOUTUBE_VIEW_VN_20192019
92019-12-16vnSEVENTEEN(세븐틴)33822KC_YOUTUBE_VIEW_VN_20192019
Survey_Date_DECountry_CDArtist_NMViews_COFILE_NAMEBASE_YMD
902019-12-20vnSUPER JUNIOR(슈퍼주니어)18248KC_YOUTUBE_VIEW_VN_20192019
912019-12-20vn몬스타엑스11434KC_YOUTUBE_VIEW_VN_20192019
922019-12-20vnCLC9261KC_YOUTUBE_VIEW_VN_20192019
932019-12-20vn오마이걸(OH MY GIRL)4848KC_YOUTUBE_VIEW_VN_20192019
942019-12-20vnNCT2462KC_YOUTUBE_VIEW_VN_20192019
952019-12-21vnBlackpink568102KC_YOUTUBE_VIEW_VN_20192019
962019-12-21vnBTS(방탄소년단)553994KC_YOUTUBE_VIEW_VN_20192019
972019-12-21vnTWICE(트와이스)176938KC_YOUTUBE_VIEW_VN_20192019
982019-12-21vnMAMAMOO (마마무)155377KC_YOUTUBE_VIEW_VN_20192019
992019-12-21vnEXO(엑소)114535KC_YOUTUBE_VIEW_VN_20192019