Overview

Dataset info

Number of variables15
Number of observations603
Missing cells0 (0.0%)
Duplicate rows0 (0.0%)
Total size in memory70.8 KiB
Average record size in memory120.2 B

Variables types

Numeric11
Categorical3
Boolean0
Date0
URL0
Text (Unique)0
Rejected1
Unsupported0

Warnings

acoustic has 73 (12.1%) zeros Zeros
artist has a high cardinality: 184 distinct values Warning
title has a high cardinality: 584 distinct values Warning
year is highly correlated with Unnamed_0 (ρ = 0.9890313901) Rejected

Variables

acoustic
Numeric

Distinct count75
Unique (%)12.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean14.32669983
Minimum0
Maximum99
Zeros (%)12.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q12
Median6
Q317
95-th percentile63
Maximum99
Range99
Interquartile range15

Descriptive statistics

Standard deviation20.76616531
Coef of variation1.44947305
Kurtosis4.475531056
Mean14.32669983
MAD14.50344188
Skewness2.202628956
Sum8639
Variance431.2336215
Memory size4.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 2.5 8.5 14.5 30.5 49.5 99. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 73 12.1%
 
1 73 12.1%
 
2 62 10.3%
 
4 32 5.3%
 
3 29 4.8%
 
5 27 4.5%
 
8 23 3.8%
 
6 20 3.3%
 
7 19 3.2%
 
10 16 2.7%
 
Other values (65) 229 38.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0 73 12.1%
 
1 73 12.1%
 
2 62 10.3%
 
3 29 4.8%
 
4 32 5.3%
 

Maximum 5 values

ValueCountFrequency (%) 
99 1 0.2%
 
97 1 0.2%
 
92 2 0.3%
 
91 2 0.3%
 
89 1 0.2%
 

artist
Categorical

Distinct count184
Unique (%)30.5%
Missing (%)0.0%
Missing (n)0
Katy Perry
 
17
Justin Bieber
 
16
Rihanna
 
15
Other values (181)
555
Toggle details
ValueCountFrequency (%) 
Katy Perry 17 2.8%
 
Justin Bieber 16 2.7%
 
Rihanna 15 2.5%
 
Maroon 5 15 2.5%
 
Lady Gaga 14 2.3%
 
Bruno Mars 13 2.2%
 
The Chainsmokers 11 1.8%
 
Pitbull 11 1.8%
 
Shawn Mendes 11 1.8%
 
Ed Sheeran 11 1.8%
 
Other values (174) 469 77.8%
 
Max length24
Mean length10.52902156
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

bpm
Numeric

Distinct count104
Unique (%)17.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean118.5456053
Minimum0
Maximum206
Zeros (%)0.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile83
Q1100
Median120
Q3129
95-th percentile166.7
Maximum206
Range206
Interquartile range29

Descriptive statistics

Standard deviation24.79535831
Coef of variation0.2091630326
Kurtosis1.709204364
Mean118.5456053
MAD18.54257733
Skewness0.5370424096
Sum71483
Variance614.8097938
Memory size4.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 74. 89.5 99.5 100.5 ... 120.5 124.5 130.5 151. 206. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
120 47 7.8%
 
100 33 5.5%
 
128 29 4.8%
 
130 27 4.5%
 
125 21 3.5%
 
126 20 3.3%
 
122 16 2.7%
 
95 14 2.3%
 
127 12 2.0%
 
124 12 2.0%
 
Other values (94) 372 61.7%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.2%
 
43 1 0.2%
 
63 1 0.2%
 
65 1 0.2%
 
73 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
206 1 0.2%
 
202 1 0.2%
 
201 1 0.2%
 
192 3 0.5%
 
190 3 0.5%
 

dance
Numeric

Distinct count70
Unique (%)11.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean64.37976783
Minimum0
Maximum97
Zeros (%)0.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile38.1
Q157
Median66
Q373
95-th percentile83
Maximum97
Range97
Interquartile range16

Descriptive statistics

Standard deviation13.37871774
Coef of variation0.2078093505
Kurtosis1.064174766
Mean64.37976783
MAD10.31607578
Skewness-0.6795952695
Sum38821
Variance178.9900883
Memory size4.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 24.5 46.5 54.5 77.5 85.5 97. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
65 25 4.1%
 
67 24 4.0%
 
69 23 3.8%
 
63 23 3.8%
 
72 21 3.5%
 
70 20 3.3%
 
68 19 3.2%
 
75 19 3.2%
 
71 19 3.2%
 
59 18 3.0%
 
Other values (60) 392 65.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.2%
 
23 1 0.2%
 
26 3 0.5%
 
27 1 0.2%
 
28 3 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
97 2 0.3%
 
96 1 0.2%
 
93 4 0.7%
 
92 1 0.2%
 
91 1 0.2%
 

dB
Numeric

Distinct count14
Unique (%)2.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean-5.578772803
Minimum-60
Maximum-2
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum-60
5-th percentile-8.9
Q1-6
Median-5
Q3-4
95-th percentile-3
Maximum-2
Range58
Interquartile range2

Descriptive statistics

Standard deviation2.798020269
Coef of variation-0.5015476286
Kurtosis237.8051032
Mean-5.578772803
MAD1.42950257
Skewness-12.44969922
Sum-3364
Variance7.828917428
Memory size4.8 KiB
Histogram
Histogram with fixed size bins (bins=14)
Histogram
Histogram with variable size bins (bins=[-60. -11.5 -9.5 -7.5 -6.5 -3.5 -2.5 -2. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
-5 150 24.9%
 
-6 127 21.1%
 
-4 125 20.7%
 
-7 86 14.3%
 
-3 50 8.3%
 
-8 29 4.8%
 
-9 16 2.7%
 
-10 7 1.2%
 
-2 5 0.8%
 
-11 4 0.7%
 
Other values (4) 4 0.7%
 

Minimum 5 values

ValueCountFrequency (%) 
-60 1 0.2%
 
-15 1 0.2%
 
-13 1 0.2%
 
-12 1 0.2%
 
-11 4 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
-2 5 0.8%
 
-3 50 8.3%
 
-4 125 20.7%
 
-5 150 24.9%
 
-6 127 21.1%
 

duration
Numeric

Distinct count144
Unique (%)23.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean224.6749585
Minimum134
Maximum424
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum134
5-th percentile181.1
Q1202
Median221
Q3239.5
95-th percentile284.9
Maximum424
Range290
Interquartile range37.5

Descriptive statistics

Standard deviation34.13005933
Coef of variation0.1519086041
Kurtosis4.179130629
Mean224.6749585
MAD24.93013649
Skewness1.339545933
Sum135479
Variance1164.86095
Memory size4.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[134. 157.5 180.5 197.5 236.5 264.5 287.5 335. 424. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
230 14 2.3%
 
193 13 2.2%
 
213 13 2.2%
 
202 12 2.0%
 
227 12 2.0%
 
228 12 2.0%
 
221 12 2.0%
 
225 12 2.0%
 
200 11 1.8%
 
215 11 1.8%
 
Other values (134) 481 79.8%
 

Minimum 5 values

ValueCountFrequency (%) 
134 1 0.2%
 
148 1 0.2%
 
157 1 0.2%
 
158 1 0.2%
 
159 2 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
424 1 0.2%
 
403 1 0.2%
 
379 1 0.2%
 
354 1 0.2%
 
353 1 0.2%
 

energy
Numeric

Distinct count77
Unique (%)12.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean70.50414594
Minimum0
Maximum98
Zeros (%)0.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile38.1
Q161
Median74
Q382
95-th percentile92
Maximum98
Range98
Interquartile range21

Descriptive statistics

Standard deviation16.31066441
Coef of variation0.2313433372
Kurtosis1.048000589
Mean70.50414594
MAD12.83265266
Skewness-0.9851938659
Sum42514
Variance266.0377735
Memory size4.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 32.5 51.5 66.5 88.5 95.5 98. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
80 26 4.3%
 
81 23 3.8%
 
78 21 3.5%
 
75 21 3.5%
 
79 20 3.3%
 
82 20 3.3%
 
88 17 2.8%
 
71 17 2.8%
 
73 16 2.7%
 
87 16 2.7%
 
Other values (67) 406 67.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.2%
 
4 1 0.2%
 
14 1 0.2%
 
15 1 0.2%
 
17 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
98 2 0.3%
 
96 2 0.3%
 
95 7 1.2%
 
94 7 1.2%
 
93 9 1.5%
 

live
Numeric

Distinct count61
Unique (%)10.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean17.77446103
Minimum0
Maximum74
Zeros (%)0.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile6
Q19
Median12
Q324
95-th percentile42.9
Maximum74
Range74
Interquartile range15

Descriptive statistics

Standard deviation13.10254259
Coef of variation0.7371555499
Kurtosis3.111358274
Mean17.77446103
MAD10.08659302
Skewness1.716039649
Sum10718
Variance171.6766224
Memory size4.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 3.5 7.5 13.5 16.5 38.5 74. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
11 56 9.3%
 
8 52 8.6%
 
9 46 7.6%
 
10 43 7.1%
 
12 39 6.5%
 
13 34 5.6%
 
14 23 3.8%
 
6 21 3.5%
 
16 20 3.3%
 
7 20 3.3%
 
Other values (51) 249 41.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.2%
 
2 1 0.2%
 
3 2 0.3%
 
4 11 1.8%
 
5 15 2.5%
 

Maximum 5 values

ValueCountFrequency (%) 
74 2 0.3%
 
70 1 0.2%
 
69 1 0.2%
 
67 2 0.3%
 
66 1 0.2%
 

popularity
Numeric

Distinct count71
Unique (%)11.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean66.52072968
Minimum0
Maximum99
Zeros (%)0.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile38.1
Q160
Median69
Q376
95-th percentile84
Maximum99
Range99
Interquartile range16

Descriptive statistics

Standard deviation14.51774552
Coef of variation0.2182439307
Kurtosis3.598686733
Mean66.52072968
MAD10.71702296
Skewness-1.427678727
Sum40112
Variance210.764935
Memory size4.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 27.5 49.5 64.5 81.5 86.5 99. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
72 33 5.5%
 
78 27 4.5%
 
73 26 4.3%
 
76 24 4.0%
 
65 23 3.8%
 
69 21 3.5%
 
77 20 3.3%
 
71 20 3.3%
 
66 19 3.2%
 
68 18 3.0%
 
Other values (61) 372 61.7%
 

Minimum 5 values

ValueCountFrequency (%) 
0 5 0.8%
 
7 1 0.2%
 
18 2 0.3%
 
25 1 0.2%
 
27 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
99 1 0.2%
 
97 1 0.2%
 
96 1 0.2%
 
95 1 0.2%
 
93 1 0.2%
 

speech
Numeric

Distinct count39
Unique (%)6.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean8.358208955
Minimum0
Maximum48
Zeros (%)0.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile3
Q14
Median5
Q39
95-th percentile24
Maximum48
Range48
Interquartile range5

Descriptive statistics

Standard deviation7.483162369
Coef of variation0.8953069263
Kurtosis7.096377192
Mean8.358208955
MAD5.020222272
Skewness2.540665853
Sum5040
Variance55.99771905
Memory size4.8 KiB
Histogram
Histogram with fixed size bins (bins=39)
Histogram
Histogram with variable size bins (bins=[ 0. 1.5 3.5 5.5 7.5 11.5 18.5 28.5 48. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
4 117 19.4%
 
5 96 15.9%
 
3 89 14.8%
 
6 57 9.5%
 
7 38 6.3%
 
9 29 4.8%
 
8 28 4.6%
 
10 21 3.5%
 
11 20 3.3%
 
12 12 2.0%
 
Other values (29) 96 15.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.2%
 
3 89 14.8%
 
4 117 19.4%
 
5 96 15.9%
 
6 57 9.5%
 

Maximum 5 values

ValueCountFrequency (%) 
48 1 0.2%
 
45 1 0.2%
 
44 2 0.3%
 
42 1 0.2%
 
39 2 0.3%
 

title
Categorical

Distinct count584
Unique (%)96.8%
Missing (%)0.0%
Missing (n)0
All I Ask
 
2
First Time
 
2
Castle Walls (feat. Christina Aguilera)
 
2
Other values (581)
597
Toggle details
ValueCountFrequency (%) 
All I Ask 2 0.3%
 
First Time 2 0.3%
 
Castle Walls (feat. Christina Aguilera) 2 0.3%
 
Written in the Stars (feat. Eric Turner) 2 0.3%
 
The Hills 2 0.3%
 
I Like It 2 0.3%
 
Hello 2 0.3%
 
Say Something 2 0.3%
 
Runnin' (Lose It All) 2 0.3%
 
Here 2 0.3%
 
Other values (574) 583 96.7%
 
Max length100
Mean length18.32338308
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

top_genre
Categorical

Distinct count50
Unique (%)8.3%
Missing (%)0.0%
Missing (n)0
dance pop
327
pop
 
60
canadian pop
 
34
Other values (47)
182
Toggle details
ValueCountFrequency (%) 
dance pop 327 54.2%
 
pop 60 10.0%
 
canadian pop 34 5.6%
 
barbadian pop 15 2.5%
 
boy band 15 2.5%
 
electropop 13 2.2%
 
british soul 11 1.8%
 
big room 10 1.7%
 
canadian contemporary r&b 9 1.5%
 
neo mellow 9 1.5%
 
Other values (40) 100 16.6%
 
Max length25
Mean length9.225538972
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

Unnamed_0
Numeric

Distinct count603
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean302
Minimum1
Maximum603
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile31.1
Q1151.5
Median302
Q3452.5
95-th percentile572.9
Maximum603
Range602
Interquartile range301

Descriptive statistics

Standard deviation174.2153839
Coef of variation0.5768721322
Kurtosis-1.2
Mean302
MAD150.7495854
Skewness0
Sum182106
Variance30351
Memory size4.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 1. 603.], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
603 1 0.2%
 
207 1 0.2%
 
205 1 0.2%
 
204 1 0.2%
 
203 1 0.2%
 
202 1 0.2%
 
201 1 0.2%
 
200 1 0.2%
 
199 1 0.2%
 
198 1 0.2%
 
Other values (593) 593 98.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1 0.2%
 
2 1 0.2%
 
3 1 0.2%
 
4 1 0.2%
 
5 1 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
603 1 0.2%
 
602 1 0.2%
 
601 1 0.2%
 
600 1 0.2%
 
599 1 0.2%
 

valence
Numeric

Distinct count94
Unique (%)15.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean52.22553897
Minimum0
Maximum98
Zeros (%)0.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile14.1
Q135
Median52
Q369
95-th percentile88
Maximum98
Range98
Interquartile range34

Descriptive statistics

Standard deviation22.51302047
Coef of variation0.4310730136
Kurtosis-0.8220093888
Mean52.22553897
MAD18.71903611
Skewness-0.07390769407
Sum31492
Variance506.8360909
Memory size4.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 7.5 31.5 66.5 88.5 98. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
65 18 3.0%
 
52 17 2.8%
 
45 16 2.7%
 
35 12 2.0%
 
40 12 2.0%
 
59 11 1.8%
 
44 11 1.8%
 
73 11 1.8%
 
74 11 1.8%
 
34 10 1.7%
 
Other values (84) 474 78.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 0.2%
 
4 2 0.3%
 
7 3 0.5%
 
8 5 0.8%
 
9 6 1.0%
 

Maximum 5 values

ValueCountFrequency (%) 
98 1 0.2%
 
97 1 0.2%
 
96 2 0.3%
 
95 3 0.5%
 
94 3 0.5%
 

year
Highly correlated

This variable is highly correlated with Unnamed_0 and should be ignored for analysis

Correlation0.9890313901

Correlations

Pearson's r
Spearman's ρ
Kendall's τ
Phik (φ<sub><em>k</em></sub>)
Cramér's V (φ<sub><em>c</em></sub>)
Recoded

Missing values

Count
Matrix

Sample

First rows

acousticartistbpmdancedBdurationenergylivepopularityspeechtitletop_genreUnnamed_0valenceyear
019Train9767-4217898834Hey, Soul Sisterneo mellow1802010
124Eminem8775-526393528223Love The Way You Liedetroit hip hop2642010
210Kesha12076-320084298014TiK ToKdance pop3712010
30Lady Gaga11970-4295928794Bad Romancedance pop4712010
42Bruno Mars10964-5221849784Just the Way You Arepop5432010
54Justin Bieber6573-521486117714Babycanadian pop6542010
60Taio Cruz12075-4203784779Dynamitedance pop7822010
77OneRepublic14852-62257612774Secretsdance pop8382010
874Alicia Keys9348-82163712763Empire State of Mind (Part II) Broken Downhip pop9142010
913Rihanna12679-4235727734Only Girl (In The World)barbadian pop10612010

Last rows

acousticartistbpmdancedBdurationenergylivepopularityspeechtitletop_genreUnnamed_0valenceyear
59320The Chainsmokers10459-62187034813Call You Mineelectropop594522019
59412Chris Brown9370-726145168115No Guidance (feat. Drake)dance pop595142019
59513Ed Sheeran15272-51628236785Antisocial (with Travis Scott)pop596912019
59616DJ Snake9684-42138067723Taki Taki (feat. Selena Gomez, Ozuna & Cardi B)electronic trap597622019
59717Daddy Yankee9474-3181874765Con Calma - Remixlatin598612019
5981Mark Ronson10461-71766620753Find U Again (feat. Camila Cabello)dance pop599162019
59921Ed Sheeran9575-62067977512Cross Me (feat. Chance the Rapper & PnB Rock)pop600612019
6007DJ Khaled13653-52607697034No Brainer (feat. Justin Bieber, Chance the Rapper & Quavo)dance pop601652019
6011Mark Ronson11460-62177942697Nothing Breaks Like a Heart (feat. Miley Cyrus)dance pop602242019
6026The Chainsmokers15070-92134413676Kills You Slowlyelectropop603232019