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 09:58:16.728079
Analysis finished2023-12-10 09:58:17.582416
Duration0.85 seconds
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-10T18:58:17.727161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:58:17.979128image/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
gb
100 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
gb 100
100.0%

Length

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

Common Values (Plot)

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

Artist_NM
Categorical

HIGH CORRELATION 

Distinct19
Distinct (%)19.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
BTS(방탄소년단)
 
6
EXO(엑소)
 
6
MAMAMOO (마마무)
 
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 rowTWICE(트와이스)
4th rowEXO(엑소)
5th rowMAMAMOO (마마무)

Common Values

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

Length

2023-12-10T18:58:18.679968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
bts(방탄소년단 6
 
4.0%
mamamoo 6
 
4.0%
마마무 6
 
4.0%
blackpink 6
 
4.0%
twice(트와이스 6
 
4.0%
exo(엑소 6
 
4.0%
iz*one 5
 
3.3%
super 5
 
3.3%
junior(슈퍼주니어 5
 
3.3%
nct 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%
Mean28028.82
Minimum1235
Maximum190279
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:58:18.985805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1235
5-th percentile2134.05
Q15443.75
median13273.5
Q330537.5
95-th percentile145761.55
Maximum190279
Range189044
Interquartile range (IQR)25093.75

Descriptive statistics

Standard deviation40441.039
Coefficient of variation (CV)1.4428377
Kurtosis6.4403071
Mean28028.82
Median Absolute Deviation (MAD)8965.5
Skewness2.5858274
Sum2802882
Variance1.6354777 × 109
MonotonicityNot monotonic
2023-12-10T18:58:19.286764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
145744 1
 
1.0%
15356 1
 
1.0%
2218 1
 
1.0%
2834 1
 
1.0%
3055 1
 
1.0%
5159 1
 
1.0%
5597 1
 
1.0%
8742 1
 
1.0%
10132 1
 
1.0%
11430 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
1235 1
1.0%
1275 1
1.0%
1290 1
1.0%
1305 1
1.0%
1356 1
1.0%
2175 1
1.0%
2218 1
1.0%
2440 1
1.0%
2512 1
1.0%
2573 1
1.0%
ValueCountFrequency (%)
190279 1
1.0%
186995 1
1.0%
161498 1
1.0%
153486 1
1.0%
146095 1
1.0%
145744 1
1.0%
104383 1
1.0%
91482 1
1.0%
88856 1
1.0%
83742 1
1.0%

FILE_NAME
Categorical

CONSTANT 

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

Length

Max length23
Median length23
Mean length23
Min length23

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
KC_YOUTUBE_VIEW_GB_2019 100
100.0%

Length

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

Common Values (Plot)

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

Common Values (Plot)

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

Interactions

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

Correlations

2023-12-10T18:58:20.299114image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Survey_Date_DEArtist_NMViews_CO
Survey_Date_DE1.0000.0000.062
Artist_NM0.0001.0000.887
Views_CO0.0620.8871.000
2023-12-10T18:58:20.457065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Survey_Date_DEArtist_NM
Survey_Date_DE1.0000.000
Artist_NM0.0001.000
2023-12-10T18:58:20.635793image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Views_COSurvey_Date_DEArtist_NM
Views_CO1.0000.0170.580
Survey_Date_DE0.0171.0000.000
Artist_NM0.5800.0001.000

Missing values

2023-12-10T18:58:17.285237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T18:58:17.497855image/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-16gbBTS(방탄소년단)145744KC_YOUTUBE_VIEW_GB_20192019
12019-12-16gbBlackpink67842KC_YOUTUBE_VIEW_GB_20192019
22019-12-16gbTWICE(트와이스)41421KC_YOUTUBE_VIEW_GB_20192019
32019-12-16gbEXO(엑소)34818KC_YOUTUBE_VIEW_GB_20192019
42019-12-16gbMAMAMOO (마마무)29585KC_YOUTUBE_VIEW_GB_20192019
52019-12-16gbStray Kids21058KC_YOUTUBE_VIEW_GB_20192019
62019-12-16gbGOT716964KC_YOUTUBE_VIEW_GB_20192019
72019-12-16gbRed Velvet(레드벨벳)16340KC_YOUTUBE_VIEW_GB_20192019
82019-12-16gb몬스타엑스14181KC_YOUTUBE_VIEW_GB_20192019
92019-12-16gbTOMORROW X TOGETHER12512KC_YOUTUBE_VIEW_GB_20192019
Survey_Date_DECountry_CDArtist_NMViews_COFILE_NAMEBASE_YMD
902019-12-20gbSUPER JUNIOR(슈퍼주니어)5163KC_YOUTUBE_VIEW_GB_20192019
912019-12-20gbIZ*ONE (아이즈원)3121KC_YOUTUBE_VIEW_GB_20192019
922019-12-20gbWINNER2953KC_YOUTUBE_VIEW_GB_20192019
932019-12-20gbNCT2175KC_YOUTUBE_VIEW_GB_20192019
942019-12-20gb오마이걸(OH MY GIRL)1290KC_YOUTUBE_VIEW_GB_20192019
952019-12-21gbBTS(방탄소년단)186995KC_YOUTUBE_VIEW_GB_20192019
962019-12-21gbBlackpink91482KC_YOUTUBE_VIEW_GB_20192019
972019-12-21gbTWICE(트와이스)49636KC_YOUTUBE_VIEW_GB_20192019
982019-12-21gbMAMAMOO (마마무)36989KC_YOUTUBE_VIEW_GB_20192019
992019-12-21gbEXO(엑소)34956KC_YOUTUBE_VIEW_GB_20192019