Week 4 Videos
Contents
Week 4 Videos¶
Median values¶
Compute the median of each column in the Spotify dataset.
import pandas as pd
df = pd.read_csv("../data/spotify_dataset.csv", na_values=" ")
df = df.dropna()
df.head()
| Index | Highest Charting Position | Number of Times Charted | Week of Highest Charting | Song Name | Streams | Artist | Artist Followers | Song ID | Genre | ... | Danceability | Energy | Loudness | Speechiness | Acousticness | Liveness | Tempo | Duration (ms) | Valence | Chord | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 1 | 8 | 2021-07-23--2021-07-30 | Beggin' | 48,633,449 | Måneskin | 3377762.0 | 3Wrjm47oTz2sjIgck11l5e | ['indie rock italiano', 'italian pop'] | ... | 0.714 | 0.800 | -4.808 | 0.0504 | 0.1270 | 0.3590 | 134.002 | 211560.0 | 0.589 | B |
| 1 | 2 | 2 | 3 | 2021-07-23--2021-07-30 | STAY (with Justin Bieber) | 47,248,719 | The Kid LAROI | 2230022.0 | 5HCyWlXZPP0y6Gqq8TgA20 | ['australian hip hop'] | ... | 0.591 | 0.764 | -5.484 | 0.0483 | 0.0383 | 0.1030 | 169.928 | 141806.0 | 0.478 | C#/Db |
| 2 | 3 | 1 | 11 | 2021-06-25--2021-07-02 | good 4 u | 40,162,559 | Olivia Rodrigo | 6266514.0 | 4ZtFanR9U6ndgddUvNcjcG | ['pop'] | ... | 0.563 | 0.664 | -5.044 | 0.1540 | 0.3350 | 0.0849 | 166.928 | 178147.0 | 0.688 | A |
| 3 | 4 | 3 | 5 | 2021-07-02--2021-07-09 | Bad Habits | 37,799,456 | Ed Sheeran | 83293380.0 | 6PQ88X9TkUIAUIZJHW2upE | ['pop', 'uk pop'] | ... | 0.808 | 0.897 | -3.712 | 0.0348 | 0.0469 | 0.3640 | 126.026 | 231041.0 | 0.591 | B |
| 4 | 5 | 5 | 1 | 2021-07-23--2021-07-30 | INDUSTRY BABY (feat. Jack Harlow) | 33,948,454 | Lil Nas X | 5473565.0 | 27NovPIUIRrOZoCHxABJwK | ['lgbtq+ hip hop', 'pop rap'] | ... | 0.736 | 0.704 | -7.409 | 0.0615 | 0.0203 | 0.0501 | 149.995 | 212000.0 | 0.894 | D#/Eb |
5 rows × 23 columns
df.median()
/Users/christopherdavis/miniconda3/envs/math10s22/lib/python3.7/site-packages/ipykernel_launcher.py:1: FutureWarning: Dropping of nuisance columns in DataFrame reductions (with 'numeric_only=None') is deprecated; in a future version this will raise TypeError. Select only valid columns before calling the reduction.
"""Entry point for launching an IPython kernel.
Index 7.800000e+02
Highest Charting Position 8.000000e+01
Number of Times Charted 4.000000e+00
Artist Followers 6.852509e+06
Popularity 7.300000e+01
Danceability 7.070000e-01
Energy 6.420000e-01
Loudness -5.990000e+00
Speechiness 7.650000e-02
Acousticness 1.610000e-01
Liveness 1.240000e-01
Tempo 1.220120e+02
Duration (ms) 1.935910e+05
Valence 5.120000e-01
dtype: float64
df.median(axis=0)
/Users/christopherdavis/miniconda3/envs/math10s22/lib/python3.7/site-packages/ipykernel_launcher.py:1: FutureWarning: Dropping of nuisance columns in DataFrame reductions (with 'numeric_only=None') is deprecated; in a future version this will raise TypeError. Select only valid columns before calling the reduction.
"""Entry point for launching an IPython kernel.
Index 7.800000e+02
Highest Charting Position 8.000000e+01
Number of Times Charted 4.000000e+00
Artist Followers 6.852509e+06
Popularity 7.300000e+01
Danceability 7.070000e-01
Energy 6.420000e-01
Loudness -5.990000e+00
Speechiness 7.650000e-02
Acousticness 1.610000e-01
Liveness 1.240000e-01
Tempo 1.220120e+02
Duration (ms) 1.935910e+05
Valence 5.120000e-01
dtype: float64
8.000000e+01
80.0
type(8.000000e+01)
float
2e+04
20000.0
df.median(axis=0)
/Users/christopherdavis/miniconda3/envs/math10s22/lib/python3.7/site-packages/ipykernel_launcher.py:1: FutureWarning: Dropping of nuisance columns in DataFrame reductions (with 'numeric_only=None') is deprecated; in a future version this will raise TypeError. Select only valid columns before calling the reduction.
"""Entry point for launching an IPython kernel.
Index 7.800000e+02
Highest Charting Position 8.000000e+01
Number of Times Charted 4.000000e+00
Artist Followers 6.852509e+06
Popularity 7.300000e+01
Danceability 7.070000e-01
Energy 6.420000e-01
Loudness -5.990000e+00
Speechiness 7.650000e-02
Acousticness 1.610000e-01
Liveness 1.240000e-01
Tempo 1.220120e+02
Duration (ms) 1.935910e+05
Valence 5.120000e-01
dtype: float64
str(7.800000e+02)
'780.0'
df.median(axis=0).map(str)
/Users/christopherdavis/miniconda3/envs/math10s22/lib/python3.7/site-packages/ipykernel_launcher.py:1: FutureWarning: Dropping of nuisance columns in DataFrame reductions (with 'numeric_only=None') is deprecated; in a future version this will raise TypeError. Select only valid columns before calling the reduction.
"""Entry point for launching an IPython kernel.
Index 780.0
Highest Charting Position 80.0
Number of Times Charted 4.0
Artist Followers 6852509.0
Popularity 73.0
Danceability 0.707
Energy 0.642
Loudness -5.99
Speechiness 0.0765
Acousticness 0.161
Liveness 0.124
Tempo 122.012
Duration (ms) 193591.0
Valence 0.512
dtype: object
str(7.800000e+02).strip(".0")
'78'
str(7.800000e+02).strip("0").strip(".")
'780'
df.median(axis=0).map(lambda x: str(x))
/Users/christopherdavis/miniconda3/envs/math10s22/lib/python3.7/site-packages/ipykernel_launcher.py:1: FutureWarning: Dropping of nuisance columns in DataFrame reductions (with 'numeric_only=None') is deprecated; in a future version this will raise TypeError. Select only valid columns before calling the reduction.
"""Entry point for launching an IPython kernel.
Index 780.0
Highest Charting Position 80.0
Number of Times Charted 4.0
Artist Followers 6852509.0
Popularity 73.0
Danceability 0.707
Energy 0.642
Loudness -5.99
Speechiness 0.0765
Acousticness 0.161
Liveness 0.124
Tempo 122.012
Duration (ms) 193591.0
Valence 0.512
dtype: object
df.median(axis=0).map(lambda x: str(x).strip("0").strip("."))
/Users/christopherdavis/miniconda3/envs/math10s22/lib/python3.7/site-packages/ipykernel_launcher.py:1: FutureWarning: Dropping of nuisance columns in DataFrame reductions (with 'numeric_only=None') is deprecated; in a future version this will raise TypeError. Select only valid columns before calling the reduction.
"""Entry point for launching an IPython kernel.
Index 780
Highest Charting Position 80
Number of Times Charted 4
Artist Followers 6852509
Popularity 73
Danceability 707
Energy 642
Loudness -5.99
Speechiness 0765
Acousticness 161
Liveness 124
Tempo 122.012
Duration (ms) 193591
Valence 512
dtype: object
df.median(axis=0).map(lambda x: str(x).rstrip("0").rstrip("."))
/Users/christopherdavis/miniconda3/envs/math10s22/lib/python3.7/site-packages/ipykernel_launcher.py:1: FutureWarning: Dropping of nuisance columns in DataFrame reductions (with 'numeric_only=None') is deprecated; in a future version this will raise TypeError. Select only valid columns before calling the reduction.
"""Entry point for launching an IPython kernel.
Index 780
Highest Charting Position 80
Number of Times Charted 4
Artist Followers 6852509
Popularity 73
Danceability 0.707
Energy 0.642
Loudness -5.99
Speechiness 0.0765
Acousticness 0.161
Liveness 0.124
Tempo 122.012
Duration (ms) 193591
Valence 0.512
dtype: object
Which chord has the highest median valence?¶
df.Chord.value_counts()
C#/Db 214
C 155
B 141
G 136
F 131
G#/Ab 130
D 125
A#/Bb 122
F#/Gb 121
A 118
E 112
D#/Eb 40
Name: Chord, dtype: int64
df.Chord == "B"
0 True
1 False
2 False
3 True
4 False
...
1551 False
1552 True
1553 False
1554 False
1555 False
Name: Chord, Length: 1545, dtype: bool
df[df.Chord == "B"]
| Index | Highest Charting Position | Number of Times Charted | Week of Highest Charting | Song Name | Streams | Artist | Artist Followers | Song ID | Genre | ... | Danceability | Energy | Loudness | Speechiness | Acousticness | Liveness | Tempo | Duration (ms) | Valence | Chord | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 1 | 8 | 2021-07-23--2021-07-30 | Beggin' | 48,633,449 | Måneskin | 3377762.0 | 3Wrjm47oTz2sjIgck11l5e | ['indie rock italiano', 'italian pop'] | ... | 0.714 | 0.800 | -4.808 | 0.0504 | 0.1270 | 0.3590 | 134.002 | 211560.0 | 0.589 | B |
| 3 | 4 | 3 | 5 | 2021-07-02--2021-07-09 | Bad Habits | 37,799,456 | Ed Sheeran | 83293380.0 | 6PQ88X9TkUIAUIZJHW2upE | ['pop', 'uk pop'] | ... | 0.808 | 0.897 | -3.712 | 0.0348 | 0.0469 | 0.3640 | 126.026 | 231041.0 | 0.591 | B |
| 23 | 24 | 24 | 31 | 2021-07-23--2021-07-30 | Heat Waves | 15,089,184 | Glass Animals | 1890510.0 | 3USxtqRwSYz57Ewm6wWRMp | ['gauze pop', 'indietronica', 'shiver pop'] | ... | 0.761 | 0.525 | -6.900 | 0.0944 | 0.4400 | 0.0921 | 80.870 | 238805.0 | 0.531 | B |
| 56 | 57 | 57 | 5 | 2021-07-23--2021-07-30 | Meu Pedaço de Pecado | 9,206,366 | João Gomes | 409173.0 | 2kJRlOyrxsy7Ot3c5TZ8Q6 | [] | ... | 0.668 | 0.887 | -4.404 | 0.0564 | 0.3690 | 0.2570 | 151.920 | 157176.0 | 0.907 | B |
| 59 | 60 | 31 | 15 | 2020-02-07--2020-02-14 | Run | 9,017,356 | OneRepublic | 12169108.0 | 2UbVnbE5FH6008mAm6Mmgw | ['dance pop', 'piano rock', 'pop', 'pop rock'] | ... | 0.682 | 0.720 | -8.173 | 0.0381 | 0.3260 | 0.1480 | 117.003 | 169011.0 | 0.673 | B |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 1479 | 1480 | 171 | 1 | 2020-01-24--2020-01-31 | B.I.T.C.H. | 5,215,211 | Megan Thee Stallion | 4794212.0 | 06scTb0zbkxYNgpAB3J9fN | ['houston rap', 'pop', 'pop rap', 'trap queen'] | ... | 0.742 | 0.731 | -4.362 | 0.3060 | 0.0851 | 0.1310 | 174.019 | 183143.0 | 0.547 | B |
| 1527 | 1528 | 133 | 3 | 2019-12-27--2020-01-03 | Calma - Remix | 4,879,713 | Pedro Capó, Farruko | 1353049.0 | 5iwz1NiezX7WWjnCgY5TH4 | ['latin', 'latin pop', 'puerto rican pop'] | ... | 0.826 | 0.773 | -4.218 | 0.0524 | 0.3230 | 0.1430 | 126.899 | 238200.0 | 0.761 | B |
| 1529 | 1530 | 196 | 1 | 2020-01-10--2020-01-17 | Kinda Crazy | 4,866,777 | Selena Gomez | 28931149.0 | 59iGOjPSOcPLGl3vqEStUp | ['dance pop', 'pop', 'post-teen pop'] | ... | 0.691 | 0.446 | -10.304 | 0.0472 | 0.4840 | 0.1830 | 93.030 | 212436.0 | 0.534 | B |
| 1532 | 1533 | 107 | 2 | 2020-01-03--2020-01-10 | Family | 6,145,132 | The Chainsmokers, Kygo | 18195884.0 | 3TKpJrY9q49Mj1JOsM9zGL | ['dance pop', 'edm', 'electropop', 'pop', 'pop... | ... | 0.584 | 0.607 | -6.605 | 0.0356 | 0.4260 | 0.1010 | 117.817 | 194827.0 | 0.374 | B |
| 1552 | 1553 | 196 | 1 | 2019-12-27--2020-01-03 | Cheirosa - Ao Vivo | 4,623,030 | Jorge & Mateus | 15019109.0 | 2PWjKmjyTZeDpmOUa3a5da | ['sertanejo', 'sertanejo universitario'] | ... | 0.528 | 0.870 | -3.123 | 0.0851 | 0.2400 | 0.3330 | 152.370 | 181930.0 | 0.714 | B |
141 rows × 23 columns
df[df.Chord == "B"]["Valence"]
0 0.589
3 0.591
23 0.531
56 0.907
59 0.673
...
1479 0.547
1527 0.761
1529 0.534
1532 0.374
1552 0.714
Name: Valence, Length: 141, dtype: float64
df[df.Chord == "B"]["Valence"].median()
0.543
valence_dictionary = {}
valence_dictionary["B"] = df[df.Chord == "B"]["Valence"].median()
valence_dictionary
{'B': 0.543}
valence_dictionary = {}
for chord in df.Chord.unique():
valence_dictionary[chord] = df[df.Chord == chord]["Valence"].median()
valence_dictionary
{'B': 0.543,
'C#/Db': 0.499,
'A': 0.4895,
'D#/Eb': 0.5395000000000001,
'G#/Ab': 0.537,
'F#/Gb': 0.609,
'C': 0.51,
'D': 0.484,
'A#/Bb': 0.553,
'G': 0.4975,
'E': 0.4225,
'F': 0.528}
max(valence_dictionary.values())
0.609
M = max(valence_dictionary.values())
[chord for chord in df.Chord.unique() if valence_dictionary[chord] == M]
['F#/Gb']
[chord for chord in df.Chord.unique() if valence_dictionary[chord] == M][0]
'F#/Gb'
Visualizing valence values by chord¶
import altair as alt
alt.Chart(df).mark_bar().encode(
x = "Chord",
y = "Valence",
tooltip = ["Valence"]
)
df[df["Chord"]=="A"]["Valence"].max()
0.979
alt.Chart(df).mark_bar().encode(
x = "Chord",
y = "median(Valence)",
color = "count()",
tooltip = ["median(Valence)", "count()"]
)
The same computation using pandas groupby¶
df.groupby("Chord")
<pandas.core.groupby.generic.DataFrameGroupBy object at 0x7fef52770550>
for x,y in df.groupby("Chord"):
print(x)
A
A#/Bb
B
C
C#/Db
D
D#/Eb
E
F
F#/Gb
G
G#/Ab
for x,y in df.groupby("Chord"):
print(y)
Index Highest Charting Position Number of Times Charted \
2 3 1 11
12 13 5 3
32 33 11 10
51 52 52 4
55 56 56 13
... ... ... ...
1535 1536 38 2
1536 1537 125 2
1537 1538 169 2
1541 1542 145 2
1551 1552 195 1
Week of Highest Charting \
2 2021-06-25--2021-07-02
12 2021-07-09--2021-07-16
32 2021-05-28--2021-06-04
51 2021-07-23--2021-07-30
55 2021-07-23--2021-07-30
... ...
1535 2019-12-27--2020-01-03
1536 2019-12-27--2020-01-03
1537 2020-01-03--2020-01-10
1541 2019-12-27--2020-01-03
1551 2019-12-27--2020-01-03
Song Name Streams \
2 good 4 u 40,162,559
12 Permission to Dance 22,062,812
32 favorite crime 12,818,935
51 Tiroteo - Remix 9,781,153
55 Freaks 9,319,465
... ... ...
1535 WHAT TO DO? (feat. Don Toliver) 5,586,351
1536 Writing on the Wall (feat. Post Malone, Cardi ... 5,229,616
1537 VALENTINO 4,935,492
1541 One Kiss (with Dua Lipa) 4,594,157
1551 New Rules 4,630,675
Artist Artist Followers \
2 Olivia Rodrigo 6266514.0
12 BTS 37106176.0
32 Olivia Rodrigo 6266514.0
51 Marc Seguí, Rauw Alejandro, Pol Granch 45362.0
55 Surf Curse 495226.0
... ... ...
1535 JACKBOYS, Travis Scott 437907.0
1536 French Montana 4039037.0
1537 24kGoldn 1276406.0
1541 Calvin Harris 21946934.0
1551 Dua Lipa 27167675.0
Song ID \
2 4ZtFanR9U6ndgddUvNcjcG
12 0LThjFY2iTtNdd4wviwVV2
32 5JCoSi02qi3jJeHdZXMmR8
51 4OwhwvKESFtuu06dTgct7i
55 7EkWXAI1wn8Ii883ecd9xr
... ...
1535 4AO1XhrgJczQ9bNVxdfKQe
1536 7x9nXsowok1JszkVztI5NI
1537 6piAUJJQFD8oHDUr0b7l7q
1541 7ef4DlsgrMEH11cDZd32M6
1551 2ekn2ttSfGqwhhate0LSR0
Genre ... Danceability \
2 ['pop'] ... 0.563
12 ['k-pop', 'k-pop boy group'] ... 0.702
32 ['pop'] ... 0.369
51 [] ... 0.750
55 ['dreamo', 'indie surf', 'surf punk', 'vegas i... ... 0.345
... ... ... ...
1535 ['rap', 'trap'] ... 0.643
1536 ['gangster rap', 'hip hop', 'pop rap', 'rap', ... ... 0.773
1537 ['cali rap'] ... 0.746
1541 ['dance pop', 'edm', 'electro house', 'house',... ... 0.791
1551 ['dance pop', 'pop', 'uk pop'] ... 0.762
Energy Loudness Speechiness Acousticness Liveness Tempo \
2 0.664 -5.044 0.1540 0.335000 0.0849 166.928
12 0.741 -5.330 0.0427 0.005440 0.3370 124.925
32 0.272 -10.497 0.0364 0.866000 0.1470 172.929
51 0.522 -7.018 0.0293 0.282000 0.0743 110.427
55 0.941 -9.918 0.0466 0.000038 0.0511 179.626
... ... ... ... ... ... ...
1535 0.594 -5.191 0.0312 0.069500 0.1150 118.037
1536 0.836 -2.326 0.1530 0.283000 0.0828 112.010
1537 0.717 -4.841 0.1790 0.199000 0.1320 150.964
1541 0.862 -3.240 0.1100 0.037000 0.0814 123.994
1551 0.700 -6.021 0.0694 0.002610 0.1530 116.073
Duration (ms) Valence Chord
2 178147.0 0.688 A
12 187585.0 0.646 A
32 152667.0 0.218 A
51 321556.0 0.601 A
55 147062.0 0.407 A
... ... ... ...
1535 250142.0 0.195 A
1536 201271.0 0.497 A
1537 179133.0 0.523 A
1541 214847.0 0.592 A
1551 209320.0 0.608 A
[118 rows x 23 columns]
Index Highest Charting Position Number of Times Charted \
22 23 1 29
31 32 32 1
41 42 17 10
58 59 34 21
67 68 35 48
... ... ... ...
1519 1520 166 1
1520 1521 131 3
1526 1527 177 3
1539 1540 150 2
1550 1551 190 1
Week of Highest Charting Song Name \
22 2021-03-12--2021-03-19 drivers license
31 2021-07-23--2021-07-30 Don't Go Yet
41 2021-05-21--2021-05-28 jealousy, jealousy
58 2021-04-23--2021-04-30 Beautiful Mistakes (feat. Megan Thee Stallion)
67 2021-01-29--2021-02-05 Sweater Weather
... ... ...
1519 2020-01-10--2020-01-17 A Sweeter Place (feat. Kid Cudi)
1520 2020-01-03--2020-01-10 Stuck In A Dream (feat. Gunna)
1526 2020-01-03--2020-01-10 Death
1539 2019-12-27--2020-01-03 Roller
1550 2019-12-27--2020-01-03 Ne reviens pas
Streams Artist Artist Followers \
22 15,684,978 Olivia Rodrigo 6266514.0
31 13,205,250 Camila Cabello 22683756.0
41 11,287,301 Olivia Rodrigo 6266514.0
58 9,048,966 Maroon 5 32262679.0
67 8,564,017 The Neighbourhood 6662605.0
... ... ... ...
1519 5,291,134 Selena Gomez 28931149.0
1520 5,258,047 Lil Mosey 3818503.0
1526 4,929,396 Trippie Redd, DaBaby 6434201.0
1539 4,732,292 Apache 207 1674348.0
1550 4,676,857 Gradur, Heuss L'enfoiré 1390813.0
Song ID \
22 5wANPM4fQCJwkGd4rN57mH
31 1058fW9H3fZA6QjYCdOBad
41 0MMyJUC3WNnFS1lit5pTjk
58 5zFglKYiknIxks8geR8rcL
67 2QjOHCTQ1Jl3zawyYOpxh6
... ...
1519 4bb94wZVF1cX66vQjNeJTX
1520 7iHHxY2NLlJRAmlAmC4ahQ
1526 3Kd6Wp3lG5HXMB2dlvuy7y
1539 6hw1Sy9wZ8UCxYGdpKrU6M
1550 4TnFANpjVwVKWzkxNzIyFH
Genre ... Danceability \
22 ['pop'] ... 0.561
31 ['dance pop', 'electropop', 'pop', 'post-teen ... ... 0.666
41 ['pop'] ... 0.695
58 ['pop', 'pop rock'] ... 0.713
67 ['modern alternative rock', 'modern rock', 'pop'] ... 0.612
... ... ... ...
1519 ['dance pop', 'pop', 'post-teen pop'] ... 0.583
1520 ['melodic rap', 'rap', 'rap conscient', 'trap'... ... 0.748
1526 ['melodic rap', 'rap', 'trap'] ... 0.802
1539 ['german hip hop'] ... 0.941
1550 ['francoton', 'french hip hop', 'pop urbaine',... ... 0.932
Energy Loudness Speechiness Acousticness Liveness Tempo \
22 0.431 -8.810 0.0578 0.7680 0.1060 143.875
31 0.796 -6.967 0.1030 0.0492 0.0442 110.108
41 0.575 -6.334 0.1160 0.1980 0.0614 163.929
58 0.676 -5.483 0.0270 0.0377 0.1540 99.048
67 0.807 -2.810 0.0336 0.0495 0.1010 124.053
... ... ... ... ... ... ...
1519 0.777 -6.991 0.1850 0.1090 0.1080 190.054
1520 0.648 -6.445 0.0816 0.4840 0.1260 139.952
1526 0.820 -5.969 0.1460 0.0579 0.1490 164.005
1539 0.758 -6.470 0.1700 0.0256 0.1930 128.017
1550 0.778 -3.384 0.0638 0.2120 0.1680 124.996
Duration (ms) Valence Chord
22 242013.0 0.137 A#/Bb
31 164842.0 0.610 A#/Bb
41 173160.0 0.699 A#/Bb
58 227395.0 0.721 A#/Bb
67 240400.0 0.398 A#/Bb
... ... ... ...
1519 263306.0 0.310 A#/Bb
1520 123560.0 0.726 A#/Bb
1526 172196.0 0.613 A#/Bb
1539 157093.0 0.683 A#/Bb
1550 188613.0 0.933 A#/Bb
[122 rows x 23 columns]
Index Highest Charting Position Number of Times Charted \
0 1 1 8
3 4 3 5
23 24 24 31
56 57 57 5
59 60 31 15
... ... ... ...
1479 1480 171 1
1527 1528 133 3
1529 1530 196 1
1532 1533 107 2
1552 1553 196 1
Week of Highest Charting Song Name Streams \
0 2021-07-23--2021-07-30 Beggin' 48,633,449
3 2021-07-02--2021-07-09 Bad Habits 37,799,456
23 2021-07-23--2021-07-30 Heat Waves 15,089,184
56 2021-07-23--2021-07-30 Meu Pedaço de Pecado 9,206,366
59 2020-02-07--2020-02-14 Run 9,017,356
... ... ... ...
1479 2020-01-24--2020-01-31 B.I.T.C.H. 5,215,211
1527 2019-12-27--2020-01-03 Calma - Remix 4,879,713
1529 2020-01-10--2020-01-17 Kinda Crazy 4,866,777
1532 2020-01-03--2020-01-10 Family 6,145,132
1552 2019-12-27--2020-01-03 Cheirosa - Ao Vivo 4,623,030
Artist Artist Followers Song ID \
0 Måneskin 3377762.0 3Wrjm47oTz2sjIgck11l5e
3 Ed Sheeran 83293380.0 6PQ88X9TkUIAUIZJHW2upE
23 Glass Animals 1890510.0 3USxtqRwSYz57Ewm6wWRMp
56 João Gomes 409173.0 2kJRlOyrxsy7Ot3c5TZ8Q6
59 OneRepublic 12169108.0 2UbVnbE5FH6008mAm6Mmgw
... ... ... ...
1479 Megan Thee Stallion 4794212.0 06scTb0zbkxYNgpAB3J9fN
1527 Pedro Capó, Farruko 1353049.0 5iwz1NiezX7WWjnCgY5TH4
1529 Selena Gomez 28931149.0 59iGOjPSOcPLGl3vqEStUp
1532 The Chainsmokers, Kygo 18195884.0 3TKpJrY9q49Mj1JOsM9zGL
1552 Jorge & Mateus 15019109.0 2PWjKmjyTZeDpmOUa3a5da
Genre ... Danceability \
0 ['indie rock italiano', 'italian pop'] ... 0.714
3 ['pop', 'uk pop'] ... 0.808
23 ['gauze pop', 'indietronica', 'shiver pop'] ... 0.761
56 [] ... 0.668
59 ['dance pop', 'piano rock', 'pop', 'pop rock'] ... 0.682
... ... ... ...
1479 ['houston rap', 'pop', 'pop rap', 'trap queen'] ... 0.742
1527 ['latin', 'latin pop', 'puerto rican pop'] ... 0.826
1529 ['dance pop', 'pop', 'post-teen pop'] ... 0.691
1532 ['dance pop', 'edm', 'electropop', 'pop', 'pop... ... 0.584
1552 ['sertanejo', 'sertanejo universitario'] ... 0.528
Energy Loudness Speechiness Acousticness Liveness Tempo \
0 0.800 -4.808 0.0504 0.1270 0.3590 134.002
3 0.897 -3.712 0.0348 0.0469 0.3640 126.026
23 0.525 -6.900 0.0944 0.4400 0.0921 80.870
56 0.887 -4.404 0.0564 0.3690 0.2570 151.920
59 0.720 -8.173 0.0381 0.3260 0.1480 117.003
... ... ... ... ... ... ...
1479 0.731 -4.362 0.3060 0.0851 0.1310 174.019
1527 0.773 -4.218 0.0524 0.3230 0.1430 126.899
1529 0.446 -10.304 0.0472 0.4840 0.1830 93.030
1532 0.607 -6.605 0.0356 0.4260 0.1010 117.817
1552 0.870 -3.123 0.0851 0.2400 0.3330 152.370
Duration (ms) Valence Chord
0 211560.0 0.589 B
3 231041.0 0.591 B
23 238805.0 0.531 B
56 157176.0 0.907 B
59 169011.0 0.673 B
... ... ... ...
1479 183143.0 0.547 B
1527 238200.0 0.761 B
1529 212436.0 0.534 B
1532 194827.0 0.374 B
1552 181930.0 0.714 B
[141 rows x 23 columns]
Index Highest Charting Position Number of Times Charted \
13 14 1 19
17 18 5 14
34 35 4 83
63 64 2 34
64 65 8 24
... ... ... ...
1496 1497 91 1
1502 1503 115 1
1506 1507 155 1
1507 1508 157 1
1546 1547 143 1
Week of Highest Charting Song Name \
13 2021-04-02--2021-04-09 Peaches (feat. Daniel Caesar & Giveon)
17 2021-04-23--2021-04-30 Save Your Tears (with Ariana Grande) (Remix)
34 2020-07-31--2020-08-07 Watermelon Sugar
63 2021-02-26--2021-03-05 Save Your Tears
64 2021-04-02--2021-04-09 Heartbreak Anniversary
... ... ...
1496 2020-01-17--2020-01-24 Woods
1502 2020-01-17--2020-01-24 Still Learning
1506 2020-01-17--2020-01-24 Big Drip
1507 2020-01-17--2020-01-24 Hands
1546 2019-12-27--2020-01-03 JACKBOYS
Streams Artist Artist Followers Song ID \
13 20,294,457 Justin Bieber 48504126.0 4iJyoBOLtHqaGxP12qzhQI
17 18,053,141 The Weeknd 35305637.0 37BZB0z9T8Xu7U3e65qxFy
34 11,996,689 Harry Styles 16112621.0 6UelLqGlWMcVH1E5c4H7lY
63 8,843,110 The Weeknd 35305637.0 37BZB0z9T8Xu7U3e65qxFy
64 8,832,945 Giveon 1398563.0 3FAJ6O0NOHQV8Mc5Ri6ENp
... ... ... ... ...
1496 8,329,349 Mac Miller 6189454.0 3Qa944OTMZkg8DHjET8JQv
1502 7,050,815 Halsey 15663384.0 2Mfv5HaqnI18Q9JRv9hqnn
1506 6,010,373 Ufo361, Future 1700759.0 7HZoWhGQaKg97OsqG7HLOS
1507 5,934,464 Mac Miller 6189454.0 6CrnvqCxBKVWahSiQwOesM
1546 5,363,493 JACKBOYS 437907.0 62zKJrpbLxz6InR3tGyr7o
Genre ... Danceability \
13 ['canadian pop', 'pop', 'post-teen pop'] ... 0.677
17 ['canadian contemporary r&b', 'canadian pop', ... ... 0.650
34 ['pop', 'post-teen pop'] ... 0.548
63 ['canadian contemporary r&b', 'canadian pop', ... ... 0.650
64 ['pop', 'r&b'] ... 0.449
... ... ... ...
1496 ['hip hop', 'pittsburgh rap', 'rap'] ... 0.779
1502 ['dance pop', 'electropop', 'etherpop', 'indie... ... 0.708
1506 ['german cloud rap', 'german hip hop'] ... 0.791
1507 ['hip hop', 'pittsburgh rap', 'rap'] ... 0.739
1546 ['rap', 'trap'] ... 0.413
Energy Loudness Speechiness Acousticness Liveness Tempo \
13 0.696 -6.181 0.1190 0.3210 0.4200 90.030
17 0.825 -4.645 0.0325 0.0215 0.0936 118.091
34 0.816 -4.209 0.0465 0.1220 0.3350 95.390
63 0.825 -4.645 0.0325 0.0215 0.0936 118.091
64 0.465 -8.964 0.0791 0.5240 0.3030 89.087
... ... ... ... ... ... ...
1496 0.362 -10.847 0.0474 0.1350 0.1110 85.011
1502 0.661 -6.543 0.0546 0.0396 0.1130 102.046
1506 0.535 -6.753 0.3110 0.0448 0.1290 158.922
1507 0.627 -8.608 0.1710 0.0459 0.1590 74.962
1546 0.130 -25.166 0.0336 0.9000 0.1110 123.342
Duration (ms) Valence Chord
13 198082.0 0.4640 C
17 191014.0 0.5930 C
34 174000.0 0.5570 C
63 191014.0 0.5930 C
64 198371.0 0.5430 C
... ... ... ...
1496 286387.0 0.4600 C
1502 211784.0 0.3170 C
1506 173785.0 0.4430 C
1507 199981.0 0.5420 C
1546 46837.0 0.0676 C
[155 rows x 23 columns]
Index Highest Charting Position Number of Times Charted \
1 2 2 3
8 9 3 8
9 10 8 10
19 20 20 7
24 25 1 83
... ... ... ...
1521 1522 138 3
1522 1523 176 1
1524 1525 187 1
1530 1531 179 3
1547 1548 156 1
Week of Highest Charting \
1 2021-07-23--2021-07-30
8 2021-06-18--2021-06-25
9 2021-07-02--2021-07-09
19 2021-07-23--2021-07-30
24 2020-06-12--2020-06-19
... ...
1521 2020-01-03--2020-01-10
1522 2020-01-10--2020-01-17
1524 2020-01-10--2020-01-17
1530 2020-01-03--2020-01-10
1547 2019-12-27--2020-01-03
Song Name Streams \
1 STAY (with Justin Bieber) 47,248,719
8 Yonaguni 25,030,128
9 I WANNA BE YOUR SLAVE 24,551,591
19 Need To Know 16,908,917
24 Blinding Lights 15,011,809
... ... ...
1521 Take What You Want (feat. Ozzy Osbourne & Trav... 5,199,618
1522 Tip Toe (feat. A Boogie Wit da Hoodie) 5,150,724
1524 Diamonds (with Normani) 4,981,484
1530 2002 4,831,644
1547 Combatchy (feat. MC Rebecca) 5,149,797
Artist Artist Followers Song ID \
1 The Kid LAROI 2230022.0 5HCyWlXZPP0y6Gqq8TgA20
8 Bad Bunny 36142273.0 2JPLbjOn0wPCngEot2STUS
9 Måneskin 3377762.0 4pt5fDVTg5GhEvEtlz9dKk
19 Doja Cat 8640063.0 3Vi5XqYrmQgOYBajMWSvCi
24 The Weeknd 35305637.0 0VjIjW4GlUZAMYd2vXMi3b
... ... ... ...
1521 Post Malone 33663701.0 7CZyCXKG6d5ALeq41sLzbw
1522 Roddy Ricch 6608815.0 6ztvsy3C6hPjVg9j4x1XKJ
1524 Megan Thee Stallion 4794212.0 0PQsrLxPbOBBwwmXCnGvcF
1530 Anne-Marie 8153871.0 2BgEsaKNfHUdlh97KmvFyo
1547 Anitta, Lexa, Luísa Sonza 10741972.0 2bPtwnrpFNEe8N7Q85kLHw
Genre ... Danceability \
1 ['australian hip hop'] ... 0.591
8 ['latin', 'reggaeton', 'trap latino'] ... 0.644
9 ['indie rock italiano', 'italian pop'] ... 0.750
19 ['dance pop', 'pop'] ... 0.664
24 ['canadian contemporary r&b', 'canadian pop', ... ... 0.514
... ... ... ...
1521 ['dfw rap', 'melodic rap', 'rap'] ... 0.499
1522 ['melodic rap', 'rap', 'trap'] ... 0.757
1524 ['houston rap', 'pop', 'pop rap', 'trap queen'] ... 0.785
1530 ['dance pop', 'pop', 'pop dance', 'post-teen p... ... 0.697
1547 ['funk carioca', 'funk pop', 'pagode baiano', ... ... 0.826
Energy Loudness Speechiness Acousticness Liveness Tempo \
1 0.764 -5.484 0.0483 0.03830 0.1030 169.928
8 0.648 -4.601 0.1180 0.27600 0.1350 179.951
9 0.608 -4.008 0.0387 0.00165 0.1780 132.507
19 0.609 -6.509 0.0707 0.30400 0.0926 130.041
24 0.730 -5.934 0.0598 0.00146 0.0897 171.005
... ... ... ... ... ... ...
1521 0.800 -2.665 0.0502 0.09060 0.1470 139.919
1522 0.673 -8.513 0.1410 0.09500 0.3380 92.958
1524 0.753 -3.841 0.0873 0.18800 0.2650 94.012
1530 0.683 -2.881 0.1170 0.03720 0.1370 96.133
1547 0.730 -3.032 0.0809 0.38300 0.0197 150.134
Duration (ms) Valence Chord
1 141806.0 0.478 C#/Db
8 206710.0 0.440 C#/Db
9 173347.0 0.958 C#/Db
19 210560.0 0.194 C#/Db
24 200040.0 0.334 C#/Db
... ... ... ...
1521 229573.0 0.272 C#/Db
1522 185806.0 0.574 C#/Db
1524 199301.0 0.488 C#/Db
1530 186987.0 0.603 C#/Db
1547 157600.0 0.605 C#/Db
[214 rows x 23 columns]
Index Highest Charting Position Number of Times Charted \
16 17 3 17
28 29 15 23
40 41 41 13
66 67 33 7
82 83 83 2
... ... ... ...
1518 1519 161 1
1534 1535 39 2
1542 1543 192 2
1544 1545 72 1
1553 1554 197 1
Week of Highest Charting \
16 2021-05-21--2021-05-28
28 2021-05-07--2021-05-14
40 2021-07-23--2021-07-30
66 2021-06-25--2021-07-02
82 2021-07-23--2021-07-30
... ...
1518 2020-01-10--2020-01-17
1534 2019-12-27--2020-01-03
1542 2019-12-27--2020-01-03
1544 2019-12-27--2020-01-03
1553 2019-12-27--2020-01-03
Song Name Streams \
16 deja vu 18,571,755
28 Friday (feat. Mufasa & Hypeman) - Dopamine Re-... 14,273,637
40 Miénteme 11,477,024
66 Dinero 8,564,775
82 Bezos I 7,516,291
... ... ...
1518 Let Me Get Me 5,356,671
1534 Had Enough (feat. Quavo & Offset) 5,748,010
1542 Fantasía 4,543,012
1544 GATTI 7,685,470
1553 Havana (feat. Young Thug) 4,620,876
Artist Artist Followers \
16 Olivia Rodrigo 6266514.0
28 Riton, Nightcrawlers 83689.0
40 TINI, Maria Becerra 2936204.0
66 Trinidad Cardona 116817.0
82 Bo Burnham 1042079.0
... ... ...
1518 Selena Gomez 28931149.0
1534 Don Toliver 437907.0
1542 Ozuna 29238936.0
1544 JACKBOYS, Pop Smoke, Travis Scott 437907.0
1553 Camila Cabello 22698747.0
Song ID \
16 6HU7h9RYOaPRFeh0R3UeAr
28 4cG7HUWYHBV6R6tHn1gxrl
40 0cOa970mzTWAxKtltpkpLc
66 3ggtU1ZOKO8ZNiqPNyXGcm
82 0Kdj7nwaYQmvhxnqZaIQuW
... ...
1518 0uFForNKQPvgSCnxlZIhQy
1534 7LGWmZaoS7jZJ5tEi9EcDi
1542 40rXWke6SnXiGkSmaT8ZUr
1544 40mjsnRjCpycdUw3xhS20g
1553 1rfofaqEpACxVEHIZBJe6W
Genre ... Danceability \
16 ['pop'] ... 0.442
28 ['dance pop', 'house', 'pop dance', 'tropical ... ... 0.824
40 ['latin pop', 'pop argentino'] ... 0.850
66 [] ... 0.708
82 ['comic'] ... 0.694
... ... ... ...
1518 ['dance pop', 'pop', 'post-teen pop'] ... 0.826
1534 ['rap', 'trap'] ... 0.750
1542 ['latin', 'puerto rican pop', 'reggaeton', 'tr... ... 0.695
1544 ['rap', 'trap'] ... 0.594
1553 ['dance pop', 'electropop', 'pop', 'post-teen ... ... 0.765
Energy Loudness Speechiness Acousticness Liveness Tempo \
16 0.612 -7.222 0.1120 0.58400 0.3700 180.917
28 0.862 -3.424 0.1260 0.00760 0.3030 122.980
40 0.541 -4.522 0.0674 0.16100 0.2860 92.003
66 0.782 -4.687 0.0674 0.00772 0.1070 119.997
82 0.948 -5.307 0.0361 0.00936 0.1390 115.044
... ... ... ... ... ... ...
1518 0.571 -9.263 0.0426 0.24900 0.2150 121.060
1534 0.789 -4.578 0.1080 0.25300 0.1290 147.957
1542 0.719 -5.938 0.0903 0.22700 0.0884 180.074
1544 0.676 -5.808 0.3440 0.13500 0.1630 143.477
1553 0.523 -4.333 0.0300 0.18400 0.1320 104.988
Duration (ms) Valence Chord
16 215507.0 0.178 D
28 169153.0 0.801 D
40 165275.0 0.916 D
66 160880.0 0.484 D
82 58149.0 0.705 D
... ... ... ...
1518 189145.0 0.475 D
1534 157133.0 0.673 D
1542 175187.0 0.781 D
1544 181145.0 0.472 D
1553 217307.0 0.394 D
[125 rows x 23 columns]
Index Highest Charting Position Number of Times Charted \
4 5 5 1
7 8 2 10
15 16 7 10
21 22 22 5
27 28 18 3
42 43 33 6
49 50 20 11
57 58 31 12
99 100 22 83
101 102 85 5
175 176 72 2
211 212 180 1
247 248 8 37
249 250 11 33
274 275 59 6
293 294 176 6
299 300 71 4
313 314 195 1
444 445 192 1
446 447 153 2
521 522 35 27
595 596 158 1
668 669 123 1
743 744 63 24
785 786 156 15
795 796 85 12
917 918 122 9
976 977 29 2
1003 1004 195 1
1011 1012 129 4
1096 1097 129 4
1114 1115 134 1
1224 1225 80 18
1245 1246 152 13
1265 1266 118 1
1343 1344 167 1
1375 1376 90 10
1409 1410 86 1
1439 1440 161 7
1512 1513 107 1
Week of Highest Charting \
4 2021-07-23--2021-07-30
7 2021-06-18--2021-06-25
15 2021-05-21--2021-05-28
21 2021-07-23--2021-07-30
27 2021-07-09--2021-07-16
42 2021-07-02--2021-07-09
49 2021-06-04--2021-06-11
57 2021-06-04--2021-06-11
99 2020-02-07--2020-02-14
101 2021-07-09--2021-07-16
175 2021-07-16--2021-07-23
211 2021-07-16--2021-07-23
247 2021-02-05--2021-02-12
249 2020-11-20--2020-11-27
274 2021-05-28--2021-06-04
293 2020-10-09--2020-10-16
299 2021-05-21--2021-05-28
313 2021-06-11--2021-06-18
444 2021-04-09--2021-04-16
446 2021-04-02--2021-04-09
521 2020-11-13--2020-11-20
595 2021-01-08--2021-01-15
668 2020-12-18--2020-12-25
743 2020-05-08--2020-05-15
785 2020-02-07--2020-02-14
795 2020-09-11--2020-09-18
917 2020-08-07--2020-08-14
976 2020-07-24--2020-07-31
1003 2020-07-24--2020-07-31
1011 2020-07-03--2020-07-10
1096 2020-06-05--2020-06-12
1114 2020-06-05--2020-06-12
1224 2020-02-07--2020-02-14
1245 2020-01-03--2020-01-10
1265 2020-03-27--2020-04-03
1343 2020-03-06--2020-03-13
1375 2019-12-27--2020-01-03
1409 2020-02-14--2020-02-21
1439 2020-01-31--2020-02-07
1512 2020-01-10--2020-01-17
Song Name Streams \
4 INDUSTRY BABY (feat. Jack Harlow) 33,948,454
7 Todo De Ti 26,951,613
15 traitor 19,480,679
21 Ain't Shit 16,126,897
27 Motley Crew 14,329,162
42 Poblado - Remix 11,283,626
49 Build a Bitch 9,841,998
57 2/Catorce 9,086,979
99 Before You Go 6,813,800
101 Reckless 6,711,375
175 Demeanor (feat. Dua Lipa) 5,245,618
211 Brush Em (feat. Rah Swish) 5,335,271
247 Whoopty 5,013,017
249 Prisoner (feat. Dua Lipa) 5,005,018
274 Poblado 6,893,939
293 In the End 4,910,070
299 GANG GANG (with Lil Wayne) 7,506,580
313 Painting Pictures 5,119,845
444 Don’t You (Taylor’s Version) (From The Vault) 5,197,564
446 WACHA 5,172,999
521 Jeans 5,145,966
595 Sand In My Boots 5,446,609
668 I Saw Mommy Kissing Santa Claus 8,064,361
743 CÓMO SE SIENTE - Remix 5,463,964
785 SLOW DANCING IN THE DARK 4,732,343
795 Caramelo - Remix 5,033,798
917 Alane 4,668,193
976 mad woman 6,796,343
1003 Story of My Life 4,628,772
1011 Past Life (with Selena Gomez) 5,228,433
1096 Na Raba Toma Tapão 4,396,629
1114 Riot 5,163,633
1224 Alone, Pt. II 4,395,061
1245 Takeaway 4,359,727
1265 Boys Will Be Boys 6,015,914
1343 Young & Alive 5,578,323
1375 Quizas 5,112,244
1409 Available 7,473,249
1439 DJ No Pare (feat. Zion, Dalex, Lenny Tavárez) ... 5,148,516
1512 Ring 6,693,229
Artist Artist Followers \
4 Lil Nas X 5473565.0
7 Rauw Alejandro 6080597.0
15 Olivia Rodrigo 6266514.0
21 Doja Cat 8640063.0
27 Post Malone 33651775.0
42 J Balvin, KAROL G, Nicky Jam, Crissin, Totoy E... 29051363.0
49 Bella Poarch 389076.0
57 Rauw Alejandro, Mr. Naisgai 6080597.0
99 Lewis Capaldi 8384096.0
101 Madison Beer 3363988.0
175 Pop Smoke 6837946.0
211 Pop Smoke 6837946.0
247 CJ 180454.0
249 Miley Cyrus 15770302.0
274 Crissin, Totoy El Frio, Natan & Shander 29051363.0
293 Linkin Park 19584111.0
299 Polo G 4840346.0
313 Polo G 4840346.0
444 Taylor Swift 42227614.0
446 KHEA, Duki 3198705.0
521 Justin Quiles 2897862.0
595 Morgan Wallen 2147875.0
668 The Jackson 5 1151360.0
743 Jhay Cortez, Bad Bunny 2435159.0
785 Joji 4759367.0
795 Ozuna, KAROL G, Myke Towers 29238936.0
917 Robin Schulz, Wes 2786366.0
976 Taylor Swift 42227614.0
1003 One Direction 22536304.0
1011 Trevor Daniel 632097.0
1096 Niack 352402.0
1114 XXXTENTACION 29566516.0
1224 Alan Walker, Ava Max 29679430.0
1245 The Chainsmokers, ILLENIUM, Lennon Stella 18195884.0
1265 Dua Lipa 27167675.0
1343 Bazzi 4421378.0
1375 Rich Music LTD, Sech, Dalex, Justin Quiles, Le... 206225.0
1409 Justin Bieber 48544923.0
1439 Justin Quiles, Natti Natasha, Farruko 2897862.0
1512 Selena Gomez 28931149.0
Song ID \
4 27NovPIUIRrOZoCHxABJwK
7 4fSIb4hdOQ151TILNsSEaF
15 5CZ40GBx1sQ9agT82CLQCT
21 5lAnYvAIkSDNXqfo7DyFUm
27 40uMIn2zJLAQhNXghRjBed
42 1WedZeiezCmCEOzLwhx0hV
49 7BoobGhD4x5K96Me0hqC8Q
57 71R8HJxQk5qMiRstrlXN9t
99 2gMXnyrvIjhVBUZwvLZDMP
101 5ajjAnNRh8bxFvaVHzpPjh
175 3DMs7bahbQTnoxCjgP7qoK
211 58aW6yZGFl7rVM7SLfLnLL
247 5vGLcdRuSbUhD8ScwsGSdA
249 5JqZ3oqF00jkT81foAFvqg
274 1WedZeiezCmCEOzLwhx0hV
293 60a0Rd6pjrkxjPbaKzXjfq
299 4VW44pawoOHPUjlN7DX5vk
313 25uBGaikHi0DhMiGMfuXYE
444 4uuEGH5SVuzkkSFjo2DEiY
446 5RmSunLqeDqNWww8LWhAiK
521 3GtnId3Cm1Xa6joCj08nzW
595 0uRrG2jRR5tuifsYIJHEao
668 15sxLiiChE5dCW3Y756oas
743 2tFwfmceQa1Y6nRPhYbEtC
785 0rKtyWc8bvkriBthvHKY8d
795 2uu2aGqA2UblCg581Q7l1g
917 2u6Jm2klS4yvAlbSHlxUwI
976 2QDyYdZyhlP2fp79KZX8Bi
1003 4nVBt6MZDDP6tRVdQTgxJg
1011 7MN8RYSofZsFROBlEOAzXq
1096 0AGS6ZRgzobrazmCi6pYMe
1114 4aOOExMBUyxKnEYb39SrTg
1224 0bMbDctzMmTyK2j74j3nF3
1245 3g0mEQx3NTanacLseoP0Gw
1265 4szI7zRh7kLApCSqiB6R7b
1343 5RsKelNxucrDxgMbZ3vd3W
1375 5Id5B3dxJZhPcV9GzgYZZe
1409 1b6tPXXCV2fSNtR3SKWUQA
1439 1ndyl3wJCFs872XZ3ztPk6
1512 11Ey4yJVeWEsA73KjACkVY
Genre ... Danceability \
4 ['lgbtq+ hip hop', 'pop rap'] ... 0.736
7 ['puerto rican pop', 'trap latino'] ... 0.780
15 ['pop'] ... 0.380
21 ['dance pop', 'pop'] ... 0.855
27 ['dfw rap', 'melodic rap', 'rap'] ... 0.797
42 ['latin', 'reggaeton', 'reggaeton colombiano'] ... 0.813
49 [] ... 0.855
57 ['puerto rican pop', 'trap latino'] ... 0.540
99 ['pop', 'uk pop'] ... 0.459
101 ['alt z', 'dance pop', 'electropop', 'pop', 'p... ... 0.386
175 ['brooklyn drill'] ... 0.675
211 ['brooklyn drill'] ... 0.654
247 ['nyc rap'] ... 0.719
249 ['dance pop', 'pop', 'post-teen pop'] ... 0.781
274 ['latin', 'reggaeton', 'reggaeton colombiano'] ... 0.813
293 ['alternative metal', 'nu metal', 'post-grunge... ... 0.556
299 ['chicago rap'] ... 0.752
313 ['chicago rap'] ... 0.522
444 ['pop', 'post-teen pop'] ... 0.563
446 ['argentine hip hop', 'trap argentino', 'trap ... ... 0.737
521 ['latin', 'reggaeton', 'trap latino'] ... 0.807
595 ['contemporary country'] ... 0.403
668 ['motown', 'soul'] ... 0.583
743 ['latin', 'reggaeton', 'trap latino'] ... 0.807
785 ['alternative r&b', 'viral pop'] ... 0.515
795 ['latin', 'puerto rican pop', 'reggaeton', 'tr... ... 0.754
917 ['dance pop', 'deep euro house', 'deep house',... ... 0.581
976 ['pop', 'post-teen pop'] ... 0.592
1003 ['boy band', 'pop', 'post-teen pop', 'talent s... ... 0.600
1011 ['alternative r&b', 'melodic rap', 'pop rap'] ... 0.575
1096 ['funk carioca'] ... 0.962
1114 ['emo rap', 'miami hip hop'] ... 0.509
1224 ['electro house'] ... 0.670
1245 ['dance pop', 'edm', 'electropop', 'pop', 'pop... ... 0.528
1265 ['dance pop', 'pop', 'uk pop'] ... 0.768
1343 ['dance pop', 'electropop', 'pop', 'post-teen ... ... 0.716
1375 ['latin', 'reggaeton', 'trap latino'] ... 0.727
1409 ['canadian pop', 'pop', 'post-teen pop'] ... 0.702
1439 ['latin', 'reggaeton', 'trap latino'] ... 0.743
1512 ['dance pop', 'pop', 'post-teen pop'] ... 0.873
Energy Loudness Speechiness Acousticness Liveness Tempo \
4 0.704 -7.409 0.0615 0.02030 0.0501 149.995
7 0.718 -3.605 0.0506 0.31000 0.0932 127.949
15 0.339 -7.885 0.0338 0.69100 0.1200 100.607
21 0.488 -4.601 0.2080 0.50600 0.3470 124.097
27 0.631 -3.818 0.0786 0.09040 0.0998 129.915
42 0.809 -5.382 0.0846 0.10200 0.3770 93.005
49 0.463 -7.454 0.0367 0.21700 0.3470 102.931
57 0.455 -5.988 0.2240 0.67500 0.1200 83.876
99 0.575 -4.858 0.0573 0.60400 0.0885 111.881
101 0.426 -6.642 0.0363 0.80700 0.1400 180.104
175 0.608 -6.934 0.1030 0.33600 0.1100 99.865
211 0.724 -6.590 0.3550 0.10600 0.6550 71.696
247 0.648 -7.600 0.1250 0.20000 0.1270 140.201
249 0.670 -3.912 0.0452 0.01030 0.0761 127.990
274 0.809 -5.382 0.0846 0.10200 0.3770 93.005
293 0.864 -5.870 0.0584 0.00958 0.2090 105.143
299 0.563 -8.066 0.2090 0.14600 0.1030 145.050
313 0.466 -8.050 0.4580 0.33100 0.1100 78.430
444 0.473 -11.548 0.0503 0.51400 0.1090 101.934
446 0.634 -4.250 0.0424 0.34500 0.1110 94.927
521 0.656 -4.395 0.1050 0.01650 0.0693 83.943
595 0.537 -6.628 0.0310 0.59000 0.1120 69.877
668 0.712 -8.222 0.0538 0.26300 0.8170 128.897
743 0.606 -8.871 0.0880 0.09460 0.1190 92.988
785 0.479 -7.458 0.0261 0.54400 0.1910 88.964
795 0.796 -3.743 0.1390 0.06200 0.2040 168.045
917 0.799 -6.660 0.1640 0.04190 0.1100 124.002
976 0.699 -8.995 0.0471 0.65500 0.1140 141.916
1003 0.663 -5.802 0.0477 0.22500 0.1190 121.070
1011 0.543 -5.062 0.0529 0.10200 0.1760 159.905
1096 0.787 1.509 0.0554 0.66600 0.1760 130.003
1114 0.542 -8.027 0.4420 0.01900 0.2300 97.767
1224 0.668 -4.306 0.0422 0.53600 0.1330 88.033
1245 0.511 -8.144 0.0324 0.12600 0.1010 100.100
1265 0.486 -5.954 0.0353 0.40800 0.0980 125.021
1343 0.563 -5.486 0.0425 0.32600 0.1190 86.005
1375 0.815 -2.454 0.1530 0.02580 0.2310 176.075
1409 0.608 -6.843 0.0359 0.07360 0.1290 75.012
1439 0.709 -3.922 0.0879 0.04510 0.0809 170.001
1512 0.510 -5.350 0.0661 0.56500 0.0738 110.953
Duration (ms) Valence Chord
4 212000.0 0.8940 D#/Eb
7 199604.0 0.3420 D#/Eb
15 229227.0 0.0849 D#/Eb
21 174253.0 0.6190 D#/Eb
27 184213.0 0.2880 D#/Eb
42 393280.0 0.6460 D#/Eb
49 122773.0 0.8660 D#/Eb
57 212032.0 0.4320 D#/Eb
99 215107.0 0.1830 D#/Eb
101 203385.0 0.2610 D#/Eb
175 184800.0 0.7280 D#/Eb
211 150449.0 0.7170 D#/Eb
247 123263.0 0.6600 D#/Eb
249 169333.0 0.5950 D#/Eb
274 393280.0 0.6460 D#/Eb
293 216880.0 0.4000 D#/Eb
299 178776.0 0.5510 D#/Eb
313 137692.0 0.4590 D#/Eb
444 208609.0 0.4050 D#/Eb
446 206360.0 0.5280 D#/Eb
521 185840.0 0.8900 D#/Eb
595 202133.0 0.4140 D#/Eb
668 181267.0 0.6140 D#/Eb
743 227520.0 0.3040 D#/Eb
785 209274.0 0.2840 D#/Eb
795 233160.0 0.6200 D#/Eb
917 175016.0 0.6620 D#/Eb
976 237258.0 0.5060 D#/Eb
1003 245493.0 0.2860 D#/Eb
1011 186480.0 0.2830 D#/Eb
1096 165231.0 0.9680 D#/Eb
1114 78681.0 0.1510 D#/Eb
1224 179053.0 0.6080 D#/Eb
1245 209880.0 0.3510 D#/Eb
1265 166266.0 0.5190 D#/Eb
1343 160465.0 0.4950 D#/Eb
1375 216067.0 0.6770 D#/Eb
1409 195333.0 0.5970 D#/Eb
1439 258600.0 0.8310 D#/Eb
1512 148776.0 0.8710 D#/Eb
[40 rows x 23 columns]
Index Highest Charting Position Number of Times Charted \
29 30 3 28
33 34 10 15
39 40 1 39
62 63 9 10
75 76 12 11
... ... ... ...
1482 1483 126 4
1497 1498 94 1
1509 1510 168 1
1516 1517 111 3
1523 1524 182 2
Week of Highest Charting Song Name Streams \
29 2021-04-02--2021-04-09 Astronaut In The Ocean 14,174,752
33 2021-05-07--2021-05-14 Pareja Del Año 12,572,307
39 2021-01-01--2021-01-08 DÁKITI 11,524,288
62 2021-05-21--2021-05-28 brutal 8,881,356
75 2021-05-28--2021-06-04 ZITTI E BUONI 7,975,148
... ... ... ...
1482 2019-12-27--2020-01-03 Legends 4,922,369
1497 2020-01-17--2020-01-24 Farewell 8,277,608
1509 2020-01-17--2020-01-24 Blanche 5,656,775
1516 2020-01-03--2020-01-10 Nice To Meet Ya 5,730,427
1523 2020-01-10--2020-01-17 Start Wit Me (feat. Gunna) 5,085,706
Artist Artist Followers Song ID \
29 Masked Wolf 365975.0 3Ofmpyhv5UAQ70mENzB277
33 Sebastian Yatra, Myke Towers 16216789.0 2rCbl9naJYhaxjLsfx88uM
39 Bad Bunny, Jhay Cortez 36142273.0 4MzXwWMhyBbmu6hOcLVD49
62 Olivia Rodrigo 6266514.0 6SRsiMl7w1USE4mFqrOhHC
75 Måneskin 3377762.0 776AftMmFFAWUIEAb3lHhw
... ... ... ...
1482 Juice WRLD 19102888.0 1Knctxx9vGZxpZfF66BIEa
1497 Eminem 46814751.0 74gykWHknHDrg4eMdcmdRq
1509 Maes, Booba 1603670.0 5GyyPRvEwdI4wJSUbzxHQv
1516 Niall Horan 7564659.0 3cphb8kdsjElYR7r5icK3H
1523 Roddy Ricch 6608815.0 7A20WnLkjtZU2d7hIB6Ziu
Genre ... Danceability \
29 ['australian hip hop'] ... 0.778
33 ['colombian pop', 'latin', 'reggaeton', 'regga... ... 0.715
39 ['latin', 'reggaeton', 'trap latino'] ... 0.731
62 ['pop'] ... 0.672
75 ['indie rock italiano', 'italian pop'] ... 0.625
... ... ... ...
1482 ['chicago rap', 'melodic rap'] ... 0.594
1497 ['detroit hip hop', 'hip hop', 'rap'] ... 0.890
1509 ['francoton', 'french hip hop', 'pop urbaine',... ... 0.776
1516 ['dance pop', 'pop', 'post-teen pop'] ... 0.591
1523 ['melodic rap', 'rap', 'trap'] ... 0.886
Energy Loudness Speechiness Acousticness Liveness Tempo \
29 0.695 -6.865 0.0913 0.17500 0.1500 149.996
33 0.622 -5.102 0.0460 0.16300 0.0948 80.015
39 0.573 -10.059 0.0544 0.40100 0.1130 109.928
62 0.526 -6.446 0.0599 0.03110 0.2800 123.999
75 0.939 -3.115 0.0669 0.00138 0.4240 102.999
... ... ... ... ... ... ...
1482 0.798 -5.244 0.0844 0.11500 0.1430 142.049
1497 0.664 -6.625 0.1060 0.00487 0.2570 93.007
1509 0.713 -6.121 0.1430 0.52500 0.3060 127.987
1516 0.841 -4.351 0.0304 0.01190 0.3950 109.034
1523 0.479 -8.054 0.3340 0.07700 0.1350 130.029
Duration (ms) Valence Chord
29 132780.0 0.472 E
33 195053.0 0.808 E
39 205090.0 0.145 E
62 143747.0 0.280 E
75 194787.0 0.644 E
... ... ... ...
1482 191840.0 0.381 E
1497 247733.0 0.467 E
1509 193453.0 0.551 E
1516 158805.0 0.392 E
1523 158692.0 0.408 E
[112 rows x 23 columns]
Index Highest Charting Position Number of Times Charted \
30 31 5 21
47 48 48 3
68 69 69 3
72 73 33 18
74 75 75 4
... ... ... ...
1487 1488 62 1
1495 1496 90 1
1499 1500 100 1
1528 1529 195 1
1554 1555 198 1
Week of Highest Charting Song Name Streams \
30 2021-04-09--2021-04-16 Leave The Door Open 13,963,568
47 2021-07-23--2021-07-30 Entre Nosotros 10,215,216
68 2021-07-23--2021-07-30 Sobrio 8,514,480
72 2021-05-07--2021-05-14 EL MAKINON 8,102,107
74 2021-07-23--2021-07-30 Love Tonight - Edit 8,006,336
... ... ... ...
1487 2020-01-17--2020-01-24 I Can See 10,086,930
1495 2020-01-17--2020-01-24 Never Love Again 8,335,790
1499 2020-01-17--2020-01-24 Alfred - Interlude 8,030,151
1528 2020-01-10--2020-01-17 Cut You Off 4,874,380
1554 2019-12-27--2020-01-03 Surtada - Remix Brega Funk 4,607,385
Artist Artist Followers \
30 Bruno Mars, Anderson .Paak, Silk Sonic 32574754.0
47 Tiago PZK, LIT killah 375865.0
68 Maluma 26769304.0
72 KAROL G, Mariah Angeliq 17775316.0
74 Shouse 27116.0
... ... ...
1487 Mac Miller 6189454.0
1495 Eminem 46814751.0
1499 Eminem 46814751.0
1528 Selena Gomez 28931149.0
1554 Dadá Boladão, Tati Zaqui, OIK 208630.0
Song ID Genre \
30 7MAibcTli4IisCtbHKrGMh ['dance pop', 'pop', 'post-teen pop']
47 6w8yBI2vthyN9UnwO4UBWb ['trap argentino']
68 4HzqWEdAbzcVFDv0pvxV4w ['latin', 'reggaeton', 'reggaeton colombiano']
72 2FSGUA0gFgGeQdprjtGM2M ['latin', 'reggaeton', 'reggaeton colombiano']
74 6OufwUcCqo81guU2jAlDVP ['aussietronica']
... ... ...
1487 3R8CyhJfVjvgIROd5RSGhQ ['hip hop', 'pittsburgh rap', 'rap']
1495 40YbWniIEmqy6s58fYXLUh ['detroit hip hop', 'hip hop', 'rap']
1499 4EmunTy7kNBYQivOa8F6b8 ['detroit hip hop', 'hip hop', 'rap']
1528 4OtHGdb0KqEbaWb6edUnR9 ['dance pop', 'pop', 'post-teen pop']
1554 5F8ffc8KWKNawllr5WsW0r ['brega funk', 'funk carioca']
... Danceability Energy Loudness Speechiness Acousticness Liveness \
30 ... 0.586 0.616 -7.964 0.0324 0.18200 0.0927
47 ... 0.729 0.513 -6.345 0.0455 0.49400 0.1370
68 ... 0.762 0.770 -2.758 0.2230 0.13800 0.1500
72 ... 0.635 0.706 -3.224 0.1250 0.25600 0.1080
74 ... 0.727 0.681 -7.114 0.0265 0.00214 0.0861
... ... ... ... ... ... ... ...
1487 ... 0.699 0.503 -9.922 0.0882 0.39100 0.0996
1495 ... 0.747 0.899 -5.125 0.2460 0.10000 0.4860
1499 ... 0.429 0.231 -20.430 0.4020 0.87800 0.2790
1528 ... 0.855 0.294 -8.676 0.2860 0.30000 0.0910
1554 ... 0.832 0.550 -7.026 0.0587 0.24900 0.1820
Tempo Duration (ms) Valence Chord
30 148.088 242096.0 0.7190 F
47 170.064 192353.0 0.7890 F
68 177.998 201181.0 0.6310 F
72 88.863 209160.0 0.4430 F
74 123.028 241970.0 0.4480 F
... ... ... ... ...
1487 114.860 220853.0 0.0546 F
1495 92.029 177547.0 0.5810 F
1499 74.545 30133.0 0.9140 F
1528 139.745 182017.0 0.8420 F
1554 154.064 152784.0 0.8810 F
[131 rows x 23 columns]
Index Highest Charting Position Number of Times Charted \
10 11 4 43
18 19 14 5
20 21 19 3
25 26 12 10
36 37 3 16
... ... ... ...
1445 1446 101 7
1459 1460 76 3
1461 1462 183 1
1491 1492 72 1
1548 1549 178 1
Week of Highest Charting Song Name Streams \
10 2021-05-07--2021-05-14 Levitating (feat. DaBaby) 23,518,010
18 2021-07-02--2021-07-09 AM Remix 17,617,965
20 2021-07-16--2021-07-23 Volando - Remix 16,606,925
25 2021-05-21--2021-05-28 happier 14,849,078
36 2021-04-16--2021-04-23 RAPSTAR 11,683,383
... ... ... ...
1445 2019-12-27--2020-01-03 Con Altura 4,961,249
1459 2020-01-17--2020-01-24 Kein Wort 5,208,651
1461 2020-01-31--2020-02-07 Wake Up Call (feat. Trippie Redd) 5,029,979
1491 2020-01-17--2020-01-24 Lock It Up (feat. Anderson .Paak) 9,328,951
1548 2019-12-27--2020-01-03 Old Town Road 4,852,004
Artist Artist Followers \
10 Dua Lipa 27142474.0
18 Nio Garcia, J Balvin, Bad Bunny 2123734.0
20 Mora, Bad Bunny, Sech 151486.0
25 Olivia Rodrigo 6266514.0
36 Polo G 4840346.0
... ... ...
1445 ROSALÍA, J Balvin, El Guincho 4769627.0
1459 Juju, Loredana, Miksu / Macloud 486474.0
1461 KSI 2010879.0
1491 Eminem 46814751.0
1548 Lil Nas X 5488666.0
Song ID Genre \
10 463CkQjx2Zk1yXoBuierM9 ['dance pop', 'pop', 'uk pop']
18 05bfbizlM5AX6Mf1RRyMho ['latin', 'reggaeton', 'trap latino']
20 0G2zPzWqVjR68iNPmx2TBe ['reggaeton', 'trap latino']
25 2tGvwE8GcFKwNdAXMnlbfl ['pop']
36 43PGPuHIlVOc04jrZVh9L6 ['chicago rap']
... ... ...
1445 2qG5sZ7Si6sdK74qLxedYM ['r&b en espanol']
1459 1hoLUVBx0ixX3kn0EX0P5n ['frauenrap', 'german hip hop', 'german pop']
1461 5MYzajZVxBaPT2JUSRa99L ['uk hip hop']
1491 1qwMkkRiD5jqLeUUjfgblh ['detroit hip hop', 'hip hop', 'rap']
1548 2YpeDb67231RjR0MgVLzsG ['lgbtq+ hip hop', 'pop rap']
... Danceability Energy Loudness Speechiness Acousticness Liveness \
10 ... 0.702 0.825 -3.787 0.0601 0.00883 0.0674
18 ... 0.743 0.655 -5.015 0.1590 0.11400 0.0764
20 ... 0.659 0.688 -4.649 0.0673 0.20700 0.1130
25 ... 0.395 0.443 -9.720 0.1330 0.76500 0.0839
36 ... 0.789 0.536 -6.862 0.2420 0.41000 0.1290
... ... ... ... ... ... ... ...
1445 ... 0.882 0.689 -4.027 0.1240 0.39000 0.0501
1459 ... 0.746 0.592 -6.861 0.0914 0.46200 0.1870
1461 ... 0.642 0.669 -5.774 0.0486 0.31800 0.1190
1491 ... 0.848 0.745 -3.052 0.2210 0.09490 0.0796
1548 ... 0.878 0.619 -5.560 0.1020 0.05330 0.1130
Tempo Duration (ms) Valence Chord
10 102.977 203064.0 0.915 F#/Gb
18 172.031 261335.0 0.785 F#/Gb
20 153.979 273474.0 0.632 F#/Gb
25 168.924 175933.0 0.338 F#/Gb
36 81.039 165926.0 0.437 F#/Gb
... ... ... ... ...
1445 97.963 161627.0 0.746 F#/Gb
1459 160.065 162094.0 0.629 F#/Gb
1461 156.084 175067.0 0.227 F#/Gb
1491 137.024 170227.0 0.516 F#/Gb
1548 136.041 157067.0 0.639 F#/Gb
[121 rows x 23 columns]
Index Highest Charting Position Number of Times Charted \
26 27 27 3
38 39 39 3
46 47 1 51
54 55 52 9
61 62 26 26
... ... ... ...
1513 1514 111 1
1533 1534 36 2
1543 1544 59 1
1549 1550 187 1
1555 1556 199 1
Week of Highest Charting Song Name \
26 2021-07-23--2021-07-30 Pepas
38 2021-07-23--2021-07-30 911 - Remix
46 2020-10-16--2020-10-23 Mood (feat. iann dior)
54 2021-07-02--2021-07-09 Leave Before You Love Me (with Jonas Brothers)
61 2021-03-26--2021-04-02 Your Love (9PM)
... ... ...
1513 2020-01-10--2020-01-17 Crowded Room (feat. 6LACK)
1533 2019-12-27--2020-01-03 GANG GANG
1543 2019-12-27--2020-01-03 Trampoline
1549 2019-12-27--2020-01-03 Let Me Know (I Wonder Why Freestyle)
1555 2019-12-27--2020-01-03 Lover (Remix) [feat. Shawn Mendes]
Streams Artist Artist Followers \
26 14,809,458 Farruko 10502148.0
38 11,553,846 Sech, Jhay Cortez 8758283.0
46 10,222,056 24kGoldn 1274433.0
54 9,428,494 Marshmello 31541310.0
61 8,935,418 ATB, Topic, A7S 291777.0
... ... ... ...
1513 6,483,001 Selena Gomez 28931149.0
1533 5,898,484 JACKBOYS, Sheck Wes 437907.0
1543 8,896,030 SHAED, ZAYN 139434.0
1549 4,701,532 Juice WRLD 19102888.0
1555 4,595,450 Taylor Swift 42227614.0
Song ID \
26 5fwSHlTEWpluwOM0Sxnh5k
38 27RSJHEA99Y0Vsow7nA37A
46 4jPy3l0RUwlUI9T5XHBW2m
54 4qu63nuBpdn0qHUHuObEj1
61 5YaskwnGDZFDRipaqzbwQx
... ...
1513 2C0hTkdEoikhKzDCJl32QZ
1533 6uJONCdr2rC65BNmCnTBWK
1543 1iQDltZqI7BXnHrFy4Qo1k
1549 3wwo0bJvDSorOpNfzEkfXx
1555 3i9UVldZOE0aD0JnyfAZZ0
Genre ... Danceability \
26 ['latin', 'latin hip hop', 'reggaeton', 'trap ... ... 0.762
38 ['latin', 'panamanian pop', 'reggaeton', 'trap... ... 0.816
46 ['cali rap'] ... 0.701
54 ['brostep', 'edm', 'pop', 'pop dance', 'progre... ... 0.721
61 ['german dance', 'german techno', 'german tran... ... 0.669
... ... ... ...
1513 ['dance pop', 'pop', 'post-teen pop'] ... 0.724
1533 ['rap', 'trap'] ... 0.859
1543 ['electropop', 'pop'] ... 0.619
1549 ['chicago rap', 'melodic rap'] ... 0.635
1555 ['pop', 'post-teen pop'] ... 0.448
Energy Loudness Speechiness Acousticness Liveness Tempo \
26 0.766 -3.955 0.0343 0.00776 0.1280 130.001
38 0.710 -3.728 0.0398 0.16500 0.2920 93.020
46 0.716 -3.671 0.0361 0.17400 0.3240 91.007
54 0.738 -4.770 0.0403 0.00226 0.1180 119.976
61 0.784 -5.603 0.1120 0.19400 0.1150 125.993
... ... ... ... ... ... ...
1513 0.415 -8.408 0.0518 0.76400 0.1030 89.999
1533 0.600 -4.630 0.3010 0.07100 0.3530 123.017
1543 0.459 -5.782 0.0334 0.56000 0.1370 126.803
1549 0.537 -7.895 0.0832 0.17200 0.4180 125.028
1555 0.603 -7.176 0.0640 0.43300 0.0862 205.272
Duration (ms) Valence Chord
26 287120.0 0.442 G
38 208631.0 0.784 G
46 140533.0 0.732 G
54 154983.0 0.637 G
61 150053.0 0.517 G
... ... ... ...
1513 186459.0 0.328 G
1533 244761.0 0.568 G
1543 184280.0 0.498 G
1549 215381.0 0.383 G
1555 221307.0 0.422 G
[136 rows x 23 columns]
Index Highest Charting Position Number of Times Charted \
5 6 1 18
6 7 3 16
11 12 9 9
14 15 2 10
37 38 15 5
... ... ... ...
1501 1502 113 1
1514 1515 119 1
1531 1532 153 3
1540 1541 187 1
1545 1546 128 1
Week of Highest Charting \
5 2021-05-07--2021-05-14
6 2021-05-14--2021-05-21
11 2021-07-02--2021-07-09
14 2021-05-21--2021-05-28
37 2021-06-25--2021-07-02
... ...
1501 2020-01-17--2020-01-24
1514 2020-01-10--2020-01-17
1531 2019-12-27--2020-01-03
1540 2020-01-03--2020-01-10
1545 2019-12-27--2020-01-03
Song Name Streams \
5 MONTERO (Call Me By Your Name) 30,071,134
6 Kiss Me More (feat. SZA) 29,356,736
11 Qué Más Pues? 22,405,111
14 Butter 19,985,713
37 You Right 11,629,418
... ... ...
1501 I Will (feat. KXNG Crooked, Royce Da 5'9" & Jo... 7,115,414
1514 People You Know 6,255,954
1531 Taki Taki (feat. Selena Gomez, Ozuna & Cardi B) 4,816,702
1540 Never Really Over 4,679,948
1545 Candy 5,632,102
Artist Artist Followers Song ID \
5 Lil Nas X 5473565.0 67BtfxlNbhBmCDR2L2l8qd
6 Doja Cat 8640063.0 748mdHapucXQri7IAO8yFK
11 J Balvin, Maria Becerra 29051363.0 6hf0RpxTbOprT5nnwzkk8e
14 BTS 37106176.0 2bgTY4UwhfBYhGT4HUYStN
37 Doja Cat, The Weeknd 8640063.0 0k4d5YPDr1r7FX77VdqWez
... ... ... ...
1501 Eminem 46814751.0 3CJbxqRQ0JNCqboWDNUUeX
1514 Selena Gomez 28931149.0 63mdJr3NMY3wReOkNE6c6W
1531 DJ Snake 7408249.0 0KoiMHhqKLoL4xM54rcWYY
1540 Katy Perry 18936929.0 5PYQUBXc7NYeI1obMKSJK0
1545 Doja Cat 8671649.0 1VJwtWR6z7SpZRwipI12be
Genre ... Danceability \
5 ['lgbtq+ hip hop', 'pop rap'] ... 0.610
6 ['dance pop', 'pop'] ... 0.762
11 ['latin', 'reggaeton', 'reggaeton colombiano'] ... 0.891
14 ['k-pop', 'k-pop boy group'] ... 0.759
37 ['dance pop', 'pop'] ... 0.828
... ... ... ...
1501 ['detroit hip hop', 'hip hop', 'rap'] ... 0.635
1514 ['dance pop', 'pop', 'post-teen pop'] ... 0.695
1531 ['dance pop', 'edm', 'electronic trap', 'pop',... ... 0.842
1540 ['dance pop', 'pop', 'post-teen pop'] ... 0.770
1545 ['dance pop', 'pop'] ... 0.689
Energy Loudness Speechiness Acousticness Liveness Tempo \
5 0.508 -6.682 0.1520 0.29700 0.3840 178.818
6 0.701 -3.541 0.0286 0.23500 0.1230 110.968
11 0.819 -3.964 0.1060 0.02610 0.1730 101.968
14 0.459 -5.187 0.0948 0.00323 0.0906 109.997
37 0.621 -6.414 0.0565 0.01640 0.0845 128.986
... ... ... ... ... ... ...
1501 0.543 -5.941 0.0670 0.04540 0.2720 98.743
1514 0.620 -8.082 0.0521 0.08810 0.1110 150.032
1531 0.801 -4.167 0.2280 0.15700 0.0642 95.881
1540 0.882 -4.792 0.0602 0.19400 0.3160 99.991
1545 0.516 -5.857 0.0444 0.51300 0.1630 124.876
Duration (ms) Valence Chord
5 137876.0 0.758 G#/Ab
6 208867.0 0.742 G#/Ab
11 217773.0 0.768 G#/Ab
14 164442.0 0.695 G#/Ab
37 186173.0 0.436 G#/Ab
... ... ... ...
1501 303000.0 0.036 G#/Ab
1514 194900.0 0.620 G#/Ab
1531 212500.0 0.617 G#/Ab
1540 223523.0 0.385 G#/Ab
1545 190920.0 0.209 G#/Ab
[130 rows x 23 columns]
for x,y in df.groupby("Chord"):
break
x
'A'
y
| Index | Highest Charting Position | Number of Times Charted | Week of Highest Charting | Song Name | Streams | Artist | Artist Followers | Song ID | Genre | ... | Danceability | Energy | Loudness | Speechiness | Acousticness | Liveness | Tempo | Duration (ms) | Valence | Chord | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 3 | 1 | 11 | 2021-06-25--2021-07-02 | good 4 u | 40,162,559 | Olivia Rodrigo | 6266514.0 | 4ZtFanR9U6ndgddUvNcjcG | ['pop'] | ... | 0.563 | 0.664 | -5.044 | 0.1540 | 0.335000 | 0.0849 | 166.928 | 178147.0 | 0.688 | A |
| 12 | 13 | 5 | 3 | 2021-07-09--2021-07-16 | Permission to Dance | 22,062,812 | BTS | 37106176.0 | 0LThjFY2iTtNdd4wviwVV2 | ['k-pop', 'k-pop boy group'] | ... | 0.702 | 0.741 | -5.330 | 0.0427 | 0.005440 | 0.3370 | 124.925 | 187585.0 | 0.646 | A |
| 32 | 33 | 11 | 10 | 2021-05-28--2021-06-04 | favorite crime | 12,818,935 | Olivia Rodrigo | 6266514.0 | 5JCoSi02qi3jJeHdZXMmR8 | ['pop'] | ... | 0.369 | 0.272 | -10.497 | 0.0364 | 0.866000 | 0.1470 | 172.929 | 152667.0 | 0.218 | A |
| 51 | 52 | 52 | 4 | 2021-07-23--2021-07-30 | Tiroteo - Remix | 9,781,153 | Marc Seguí, Rauw Alejandro, Pol Granch | 45362.0 | 4OwhwvKESFtuu06dTgct7i | [] | ... | 0.750 | 0.522 | -7.018 | 0.0293 | 0.282000 | 0.0743 | 110.427 | 321556.0 | 0.601 | A |
| 55 | 56 | 56 | 13 | 2021-07-23--2021-07-30 | Freaks | 9,319,465 | Surf Curse | 495226.0 | 7EkWXAI1wn8Ii883ecd9xr | ['dreamo', 'indie surf', 'surf punk', 'vegas i... | ... | 0.345 | 0.941 | -9.918 | 0.0466 | 0.000038 | 0.0511 | 179.626 | 147062.0 | 0.407 | A |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 1535 | 1536 | 38 | 2 | 2019-12-27--2020-01-03 | WHAT TO DO? (feat. Don Toliver) | 5,586,351 | JACKBOYS, Travis Scott | 437907.0 | 4AO1XhrgJczQ9bNVxdfKQe | ['rap', 'trap'] | ... | 0.643 | 0.594 | -5.191 | 0.0312 | 0.069500 | 0.1150 | 118.037 | 250142.0 | 0.195 | A |
| 1536 | 1537 | 125 | 2 | 2019-12-27--2020-01-03 | Writing on the Wall (feat. Post Malone, Cardi ... | 5,229,616 | French Montana | 4039037.0 | 7x9nXsowok1JszkVztI5NI | ['gangster rap', 'hip hop', 'pop rap', 'rap', ... | ... | 0.773 | 0.836 | -2.326 | 0.1530 | 0.283000 | 0.0828 | 112.010 | 201271.0 | 0.497 | A |
| 1537 | 1538 | 169 | 2 | 2020-01-03--2020-01-10 | VALENTINO | 4,935,492 | 24kGoldn | 1276406.0 | 6piAUJJQFD8oHDUr0b7l7q | ['cali rap'] | ... | 0.746 | 0.717 | -4.841 | 0.1790 | 0.199000 | 0.1320 | 150.964 | 179133.0 | 0.523 | A |
| 1541 | 1542 | 145 | 2 | 2019-12-27--2020-01-03 | One Kiss (with Dua Lipa) | 4,594,157 | Calvin Harris | 21946934.0 | 7ef4DlsgrMEH11cDZd32M6 | ['dance pop', 'edm', 'electro house', 'house',... | ... | 0.791 | 0.862 | -3.240 | 0.1100 | 0.037000 | 0.0814 | 123.994 | 214847.0 | 0.592 | A |
| 1551 | 1552 | 195 | 1 | 2019-12-27--2020-01-03 | New Rules | 4,630,675 | Dua Lipa | 27167675.0 | 2ekn2ttSfGqwhhate0LSR0 | ['dance pop', 'pop', 'uk pop'] | ... | 0.762 | 0.700 | -6.021 | 0.0694 | 0.002610 | 0.1530 | 116.073 | 209320.0 | 0.608 | A |
118 rows × 23 columns
df["Chord"] == "A"
0 False
1 False
2 True
3 False
4 False
...
1551 True
1552 False
1553 False
1554 False
1555 False
Name: Chord, Length: 1545, dtype: bool
(df["Chord"] == "A").sum()
118
for x,y in df.groupby("Chord"):
print(len(y))
118
122
141
155
214
125
40
112
131
121
136
130
df.groupby("Chord").median()
| Index | Highest Charting Position | Number of Times Charted | Artist Followers | Popularity | Danceability | Energy | Loudness | Speechiness | Acousticness | Liveness | Tempo | Duration (ms) | Valence | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Chord | ||||||||||||||
| A | 798.5 | 82.0 | 3.0 | 7805880.0 | 73.0 | 0.6750 | 0.6500 | -5.8445 | 0.06970 | 0.1465 | 0.1255 | 123.0145 | 191842.5 | 0.4895 |
| A#/Bb | 884.0 | 86.5 | 3.0 | 6777818.0 | 72.0 | 0.7080 | 0.6680 | -5.9960 | 0.10250 | 0.1265 | 0.1330 | 122.1920 | 193573.0 | 0.5530 |
| B | 748.0 | 82.0 | 4.0 | 6167871.0 | 73.0 | 0.7460 | 0.6670 | -6.3190 | 0.08380 | 0.1500 | 0.1190 | 120.9980 | 188563.0 | 0.5430 |
| C | 799.0 | 72.0 | 4.0 | 9470311.0 | 73.0 | 0.7020 | 0.6100 | -6.5710 | 0.05390 | 0.2130 | 0.1240 | 124.0260 | 198082.0 | 0.5100 |
| C#/Db | 837.5 | 80.0 | 3.0 | 6777818.0 | 72.0 | 0.7010 | 0.6355 | -5.7950 | 0.09420 | 0.1420 | 0.1195 | 124.9170 | 188493.0 | 0.4990 |
| D | 720.0 | 91.0 | 3.0 | 6837946.0 | 73.0 | 0.6860 | 0.6470 | -5.8310 | 0.06760 | 0.1850 | 0.1320 | 123.0380 | 190779.0 | 0.4840 |
| D#/Eb | 484.5 | 85.5 | 5.0 | 6173555.5 | 77.0 | 0.7090 | 0.6195 | -5.9710 | 0.05785 | 0.2210 | 0.1190 | 108.0480 | 197468.5 | 0.5395 |
| E | 768.5 | 68.0 | 4.0 | 7708667.5 | 73.0 | 0.6895 | 0.6370 | -6.3605 | 0.06560 | 0.1710 | 0.1255 | 117.4280 | 193037.0 | 0.4225 |
| F | 780.0 | 83.0 | 3.0 | 8758283.0 | 72.0 | 0.6870 | 0.6460 | -6.1360 | 0.07720 | 0.1430 | 0.1230 | 117.9670 | 198040.0 | 0.5280 |
| F#/Gb | 594.0 | 74.0 | 6.0 | 5002317.0 | 75.0 | 0.7280 | 0.6780 | -5.5910 | 0.07940 | 0.1170 | 0.1140 | 125.9710 | 195268.0 | 0.6090 |
| G | 862.0 | 78.5 | 3.0 | 7744095.0 | 72.0 | 0.7040 | 0.6355 | -6.1415 | 0.07910 | 0.1450 | 0.1230 | 119.5380 | 198913.0 | 0.4975 |
| G#/Ab | 790.5 | 97.5 | 3.0 | 6634234.0 | 74.0 | 0.7415 | 0.6210 | -5.8725 | 0.08680 | 0.1740 | 0.1255 | 120.0330 | 193446.5 | 0.5370 |
df.groupby("Chord").median()["Valence"]
Chord
A 0.4895
A#/Bb 0.5530
B 0.5430
C 0.5100
C#/Db 0.4990
D 0.4840
D#/Eb 0.5395
E 0.4225
F 0.5280
F#/Gb 0.6090
G 0.4975
G#/Ab 0.5370
Name: Valence, dtype: float64
df.groupby("Chord").median()["Valence"].max()
0.609
df.groupby("Chord").median()["Valence"].argmax()
9
df.groupby("Chord").median()["Valence"].idxmax()
'F#/Gb'