# importing the zipfile module
from zipfile import ZipFile
# loading the temp.zip and creating a zip object
with ZipFile("spotify-top-50-playlist-songs-anxods.zip", 'r') as zObject:
# Extracting all the members of the zip
# into a specific location.
zObject.extractall("spotify-top-50")Lecture 3.1 : Introduction to Pandas
0. Load the dataset
global_50_path = "spotify-top-50/data/spotify-streaming-top-50-world.csv"1. Read the dataset
!pip install pandasimport pandas as pdglobal_50_df = pd.read_csv(global_50_path)#to write (except the index)
# global_50_df.to_csv('temp_file.csv',index=False)global_50_df| date | position | song | artist | popularity | duration_ms | album_type | total_tracks | release_date | is_explicit | album_cover_url | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2023-05-18 | 1 | Ella Baila Sola | Eslabon Armado | 89 | 165671 | album | 16 | 2023-04-28 | False | https://i.scdn.co/image/ab67616d0000b273dfddf1... |
| 1 | 2023-05-18 | 2 | un x100to | Grupo Frontera & Bad Bunny | 99 | 194563 | single | 1 | 2023-04-17 | False | https://i.scdn.co/image/ab67616d0000b273716c0b... |
| 2 | 2023-05-18 | 3 | La Bebe - Remix | Yng Lvcas & Peso Pluma | 99 | 234352 | single | 2 | 2023-03-17 | True | https://i.scdn.co/image/ab67616d0000b273a04be3... |
| 3 | 2023-05-18 | 4 | Cupid - Twin Ver. | FIFTY FIFTY | 97 | 174253 | single | 3 | 2023-02-24 | False | https://i.scdn.co/image/ab67616d0000b27337c0b3... |
| 4 | 2023-05-18 | 5 | Flowers | Miley Cyrus | 91 | 200600 | album | 13 | 2023-03-10 | False | https://i.scdn.co/image/ab67616d0000b27358039b... |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 1795 | 2023-06-22 | 46 | Heat Waves | Glass Animals | 93 | 238805 | album | 16 | 2020-08-07 | False | https://i.scdn.co/image/ab67616d0000b273712701... |
| 1796 | 2023-06-22 | 47 | Frágil | Yahritza Y Su Esencia & Grupo Frontera | 93 | 160517 | single | 1 | 2023-04-07 | False | https://i.scdn.co/image/ab67616d0000b27357ed58... |
| 1797 | 2023-06-22 | 48 | PRC | Peso Pluma & Natanael Cano | 95 | 184066 | single | 1 | 2023-01-23 | True | https://i.scdn.co/image/ab67616d0000b2737be314... |
| 1798 | 2023-06-22 | 49 | Dance The Night (From Barbie The Album) | Dua Lipa | 92 | 176579 | single | 1 | 2023-05-25 | False | https://i.scdn.co/image/ab67616d0000b2737dd3ba... |
| 1799 | 2023-06-22 | 50 | All My Life (feat. J. Cole) | Lil Durk | 84 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
1800 rows × 11 columns
global_50_df.columnsIndex(['date', 'position', 'song', 'artist', 'popularity', 'duration_ms',
'album_type', 'total_tracks', 'release_date', 'is_explicit',
'album_cover_url'],
dtype='object')Who is the top artist of the day
date = '2023-06-22'
global_50_df[(global_50_df['date']==date) & (global_50_df['position']==1)]| date | position | song | artist | popularity | duration_ms | album_type | total_tracks | release_date | is_explicit | album_cover_url | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1750 | 2023-06-22 | 1 | Ella Baila Sola | Eslabon Armado | 93 | 165671 | album | 16 | 2023-04-28 | False | https://i.scdn.co/image/ab67616d0000b273dfddf1... |
2. Create a dataframe
Synatx is pd.DataFrame(data, index, columns)
pd.DataFrame(['csc380','csv'])| 0 | |
|---|---|
| 0 | csc380 |
| 1 | csv |
pd.DataFrame(['csc380','csv'], ['csc380','pandas'])| 0 | |
|---|---|
| csc380 | csc380 |
| pandas | csv |
pd.DataFrame([['csc380','csv'], ['csc380','pandas']])| 0 | 1 | |
|---|---|---|
| 0 | csc380 | csv |
| 1 | csc380 | pandas |
pd.DataFrame([['csc380','csv'], ['csc380','pandas']], columns=['class','method'])| class | method | |
|---|---|---|
| 0 | csc380 | csv |
| 1 | csc380 | pandas |
pd.DataFrame(['csv','pandas'],['P','P'],['CSC380'])| CSC380 | |
|---|---|
| P | csv |
| P | pandas |
sample_df = pd.DataFrame(['csv','pandas'],['P','P'],['CSC380']).reset_index()
sample_df| index | CSC380 | |
|---|---|---|
| 0 | P | csv |
| 1 | P | pandas |
sample_df.drop('index',axis = 'columns',inplace=True)
sample_df| CSC380 | |
|---|---|
| 0 | csv |
| 1 | pandas |
sample_df['random_count'] = [89,52]
sample_df| CSC380 | random_count | |
|---|---|---|
| 0 | csv | 89 |
| 1 | pandas | 52 |
We explored creating dataframes using list, you can use other formats too. Below is a dict.
pd.DataFrame([
{
'class': 'csc380',
'method' : 'csv'
},
{
'class': 'csc380',
'method':'pandas'
}
])| class | method | |
|---|---|---|
| 0 | csc380 | csv |
| 1 | csc380 | pandas |
3. Simple Operations
sample_df['random_count'] = sample_df['random_count'] - 10
sample_df| CSC380 | random_count | |
|---|---|---|
| 0 | csv | 79 |
| 1 | pandas | 42 |
sample_df['CSC380'] = sample_df['CSC380'].apply(lambda x : x.upper())
sample_df| CSC380 | random_count | |
|---|---|---|
| 0 | CSV | 79 |
| 1 | PANDAS | 42 |
global_50_df.shape(1800, 11)4. Head, tail and sample
global_50_df.head()global_50_df.tail(3)global_50_df.sample(5)5. [ ],iloc,loc
global_50_df[2:5]| date | position | song | artist | popularity | duration_ms | album_type | total_tracks | release_date | is_explicit | album_cover_url | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 2023-05-18 | 3 | La Bebe - Remix | Yng Lvcas & Peso Pluma | 99 | 234352 | single | 2 | 2023-03-17 | True | https://i.scdn.co/image/ab67616d0000b273a04be3... |
| 3 | 2023-05-18 | 4 | Cupid - Twin Ver. | FIFTY FIFTY | 97 | 174253 | single | 3 | 2023-02-24 | False | https://i.scdn.co/image/ab67616d0000b27337c0b3... |
| 4 | 2023-05-18 | 5 | Flowers | Miley Cyrus | 91 | 200600 | album | 13 | 2023-03-10 | False | https://i.scdn.co/image/ab67616d0000b27358039b... |
global_50_df.iloc[15:19]| date | position | song | artist | popularity | duration_ms | album_type | total_tracks | release_date | is_explicit | album_cover_url | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 15 | 2023-05-18 | 16 | BESO | ROSALÍA & Rauw Alejandro | 96 | 194543 | single | 3 | 2023-03-24 | False | https://i.scdn.co/image/ab67616d0000b2734d6cf0... |
| 16 | 2023-05-18 | 17 | Die For You (with Ariana Grande) - Remix | The Weeknd | 88 | 232857 | album | 21 | 2023-03-14 | False | https://i.scdn.co/image/ab67616d0000b2738ad8f5... |
| 17 | 2023-05-18 | 18 | PRC | Peso Pluma & Natanael Cano | 96 | 184066 | single | 1 | 2023-01-23 | True | https://i.scdn.co/image/ab67616d0000b2737be314... |
| 18 | 2023-05-18 | 19 | Calm Down (with Selena Gomez) | Rema | 78 | 239317 | album | 22 | 2023-04-27 | False | https://i.scdn.co/image/ab67616d0000b273963265... |
global_50_df.loc[15:19]| date | position | song | artist | popularity | duration_ms | album_type | total_tracks | release_date | is_explicit | album_cover_url | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 15 | 2023-05-18 | 16 | BESO | ROSALÍA & Rauw Alejandro | 96 | 194543 | single | 3 | 2023-03-24 | False | https://i.scdn.co/image/ab67616d0000b2734d6cf0... |
| 16 | 2023-05-18 | 17 | Die For You (with Ariana Grande) - Remix | The Weeknd | 88 | 232857 | album | 21 | 2023-03-14 | False | https://i.scdn.co/image/ab67616d0000b2738ad8f5... |
| 17 | 2023-05-18 | 18 | PRC | Peso Pluma & Natanael Cano | 96 | 184066 | single | 1 | 2023-01-23 | True | https://i.scdn.co/image/ab67616d0000b2737be314... |
| 18 | 2023-05-18 | 19 | Calm Down (with Selena Gomez) | Rema | 78 | 239317 | album | 22 | 2023-04-27 | False | https://i.scdn.co/image/ab67616d0000b273963265... |
| 19 | 2023-05-18 | 20 | Yandel 150 | Yandel | 90 | 216148 | album | 17 | 2023-01-13 | True | https://i.scdn.co/image/ab67616d0000b273b2aec0... |
global_50_subset_df = global_50_df.sample(10)
global_50_subset_df| date | position | song | artist | popularity | duration_ms | album_type | total_tracks | release_date | is_explicit | album_cover_url | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1588 | 2023-06-18 | 39 | Tá OK | DENNIS & MC Kevin o Chris | 89 | 92093 | single | 1 | 2023-05-04 | False | https://i.scdn.co/image/ab67616d0000b2736b19d4... |
| 93 | 2023-05-19 | 44 | Por las Noches | Peso Pluma | 93 | 239845 | single | 1 | 2021-06-11 | False | https://i.scdn.co/image/ab67616d0000b273427d9a... |
| 1367 | 2023-06-14 | 18 | Classy 101 | Feid & Young Miko | 96 | 195986 | single | 1 | 2023-03-31 | True | https://i.scdn.co/image/ab67616d0000b27329ebee... |
| 213 | 2023-05-22 | 14 | PRC | Peso Pluma & Natanael Cano | 96 | 184066 | single | 1 | 2023-01-23 | True | https://i.scdn.co/image/ab67616d0000b2737be314... |
| 124 | 2023-05-20 | 25 | Like Crazy | Jimin | 93 | 212241 | single | 6 | 2023-03-24 | False | https://i.scdn.co/image/ab67616d0000b2732b4607... |
| 1043 | 2023-06-07 | 44 | Bye | Peso Pluma | 86 | 212976 | single | 1 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b27310c8a0... |
| 938 | 2023-06-05 | 39 | Frágil | Yahritza Y Su Esencia & Grupo Frontera | 91 | 160517 | single | 1 | 2023-04-07 | False | https://i.scdn.co/image/ab67616d0000b27357ed58... |
| 65 | 2023-05-19 | 16 | Die For You (with Ariana Grande) - Remix | The Weeknd | 88 | 232857 | album | 21 | 2023-03-14 | False | https://i.scdn.co/image/ab67616d0000b2738ad8f5... |
| 1168 | 2023-06-10 | 19 | See You Again (feat. Kali Uchis) | Tyler, The Creator | 95 | 180386 | album | 14 | 2017-07-21 | True | https://i.scdn.co/image/ab67616d0000b2738940ac... |
| 1277 | 2023-06-12 | 28 | See You Again (feat. Kali Uchis) | Tyler, The Creator | 95 | 180386 | album | 14 | 2017-07-21 | True | https://i.scdn.co/image/ab67616d0000b2738940ac... |
global_50_subset_df[3:5]| date | position | song | artist | popularity | duration_ms | album_type | total_tracks | release_date | is_explicit | album_cover_url | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 213 | 2023-05-22 | 14 | PRC | Peso Pluma & Natanael Cano | 96 | 184066 | single | 1 | 2023-01-23 | True | https://i.scdn.co/image/ab67616d0000b2737be314... |
| 124 | 2023-05-20 | 25 | Like Crazy | Jimin | 93 | 212241 | single | 6 | 2023-03-24 | False | https://i.scdn.co/image/ab67616d0000b2732b4607... |
global_50_subset_df.iloc[3:5]| date | position | song | artist | popularity | duration_ms | album_type | total_tracks | release_date | is_explicit | album_cover_url | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 213 | 2023-05-22 | 14 | PRC | Peso Pluma & Natanael Cano | 96 | 184066 | single | 1 | 2023-01-23 | True | https://i.scdn.co/image/ab67616d0000b2737be314... |
| 124 | 2023-05-20 | 25 | Like Crazy | Jimin | 93 | 212241 | single | 6 | 2023-03-24 | False | https://i.scdn.co/image/ab67616d0000b2732b4607... |
global_50_subset_df.loc[3:5]KeyError: 3global_50_df.iloc[5:15]['song','artist']KeyError: ('song', 'artist')global_50_df.iloc[5:15][['song','artist']]| song | artist | |
|---|---|---|
| 5 | Daylight | David Kushner |
| 6 | Kill Bill | SZA |
| 7 | Tattoo | Loreen |
| 8 | As It Was | Harry Styles |
| 9 | TQG | KAROL G |
| 10 | Cha Cha Cha | Käärijä |
| 11 | Classy 101 | Feid & Young Miko |
| 12 | Acróstico | Shakira |
| 13 | Creepin' (with The Weeknd & 21 Savage) | Metro Boomin |
| 14 | See You Again (feat. Kali Uchis) | Tyler, The Creator |
6. Dataframes and Series
global_50_df.iloc[5:15]['song']5 Daylight
6 Kill Bill
7 Tattoo
8 As It Was
9 TQG
10 Cha Cha Cha
11 Classy 101
12 Acróstico
13 Creepin' (with The Weeknd & 21 Savage)
14 See You Again (feat. Kali Uchis)
Name: song, dtype: objectglobal_50_df.iloc[5:15]['song'].to_frame()| song | |
|---|---|
| 5 | Daylight |
| 6 | Kill Bill |
| 7 | Tattoo |
| 8 | As It Was |
| 9 | TQG |
| 10 | Cha Cha Cha |
| 11 | Classy 101 |
| 12 | Acróstico |
| 13 | Creepin' (with The Weeknd & 21 Savage) |
| 14 | See You Again (feat. Kali Uchis) |
7. Conditionals
Q : What are the top 50 artists of June 5th 2023?
date = '2023-06-05'
global_50_df[global_50_df['date']== date]| date | position | song | artist | popularity | duration_ms | album_type | total_tracks | release_date | is_explicit | album_cover_url | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 900 | 2023-06-05 | 1 | Ella Baila Sola | Eslabon Armado | 92 | 165671 | album | 16 | 2023-04-28 | False | https://i.scdn.co/image/ab67616d0000b273dfddf1... |
| 901 | 2023-06-05 | 2 | Peso Pluma: Bzrp Music Sessions, Vol. 55 | Bizarrap & Peso Pluma | 89 | 188361 | single | 1 | 2023-06-01 | True | https://i.scdn.co/image/ab67616d0000b273155830... |
| 902 | 2023-06-05 | 3 | WHERE SHE GOES | Bad Bunny | 96 | 231704 | single | 1 | 2023-05-18 | True | https://i.scdn.co/image/ab67616d0000b273ab5c9c... |
| 903 | 2023-06-05 | 4 | La Bebe - Remix | Yng Lvcas & Peso Pluma | 99 | 234352 | single | 2 | 2023-03-17 | True | https://i.scdn.co/image/ab67616d0000b273a04be3... |
| 904 | 2023-06-05 | 5 | un x100to | Grupo Frontera & Bad Bunny | 100 | 194563 | single | 1 | 2023-04-17 | False | https://i.scdn.co/image/ab67616d0000b273716c0b... |
| 905 | 2023-06-05 | 6 | Flowers | Miley Cyrus | 91 | 200600 | album | 13 | 2023-03-10 | False | https://i.scdn.co/image/ab67616d0000b27358039b... |
| 906 | 2023-06-05 | 7 | Cupid - Twin Ver. | FIFTY FIFTY | 98 | 174253 | single | 3 | 2023-02-24 | False | https://i.scdn.co/image/ab67616d0000b27337c0b3... |
| 907 | 2023-06-05 | 8 | TQM | Fuerza Regida | 91 | 158965 | single | 1 | 2023-05-19 | True | https://i.scdn.co/image/ab67616d0000b273832ea5... |
| 908 | 2023-06-05 | 9 | As It Was | Harry Styles | 92 | 167303 | album | 13 | 2022-05-20 | False | https://i.scdn.co/image/ab67616d0000b2732e8ed7... |
| 909 | 2023-06-05 | 10 | Daylight | David Kushner | 97 | 212953 | single | 1 | 2023-04-14 | False | https://i.scdn.co/image/ab67616d0000b27395ca6a... |
| 910 | 2023-06-05 | 11 | Kill Bill | SZA | 94 | 153946 | album | 23 | 2022-12-08 | False | https://i.scdn.co/image/ab67616d0000b2730c471c... |
| 911 | 2023-06-05 | 12 | Sprinter | Dave & Central Cee | 81 | 229133 | single | 1 | 2023-06-01 | True | https://i.scdn.co/image/ab67616d0000b273e3a09a... |
| 912 | 2023-06-05 | 13 | Classy 101 | Feid & Young Miko | 96 | 195986 | single | 1 | 2023-03-31 | True | https://i.scdn.co/image/ab67616d0000b27329ebee... |
| 913 | 2023-06-05 | 14 | TQG | KAROL G | 96 | 197933 | album | 17 | 2023-02-24 | True | https://i.scdn.co/image/ab67616d0000b27382de1c... |
| 914 | 2023-06-05 | 15 | El Azul | Junior H & Peso Pluma | 95 | 187225 | single | 1 | 2023-02-10 | False | https://i.scdn.co/image/ab67616d0000b27333ed35... |
| 915 | 2023-06-05 | 16 | Calm Down (with Selena Gomez) | Rema | 81 | 239317 | album | 22 | 2023-04-27 | False | https://i.scdn.co/image/ab67616d0000b273963265... |
| 916 | 2023-06-05 | 17 | Popular (with Playboi Carti & Madonna) | The Weeknd & Playboi Carti & Madonna | 79 | 215466 | single | 1 | 2023-06-02 | True | https://i.scdn.co/image/ab67616d0000b273eac1ac... |
| 917 | 2023-06-05 | 18 | BESO | ROSALÍA & Rauw Alejandro | 96 | 194543 | single | 3 | 2023-03-24 | False | https://i.scdn.co/image/ab67616d0000b2734d6cf0... |
| 918 | 2023-06-05 | 19 | Dance The Night (From Barbie The Album) | Dua Lipa | 88 | 176579 | single | 1 | 2023-05-25 | False | https://i.scdn.co/image/ab67616d0000b2737dd3ba... |
| 919 | 2023-06-05 | 20 | PRC | Peso Pluma & Natanael Cano | 95 | 184066 | single | 1 | 2023-01-23 | True | https://i.scdn.co/image/ab67616d0000b2737be314... |
| 920 | 2023-06-05 | 21 | Yandel 150 | Yandel | 90 | 216148 | album | 17 | 2023-01-13 | True | https://i.scdn.co/image/ab67616d0000b273b2aec0... |
| 921 | 2023-06-05 | 22 | Anti-Hero | Taylor Swift | 94 | 200690 | album | 13 | 2022-10-21 | False | https://i.scdn.co/image/ab67616d0000b273bb54dd... |
| 922 | 2023-06-05 | 23 | Creepin' (with The Weeknd & 21 Savage) | Metro Boomin | 95 | 221520 | album | 15 | 2022-12-02 | True | https://i.scdn.co/image/ab67616d0000b27313e54d... |
| 923 | 2023-06-05 | 24 | See You Again (feat. Kali Uchis) | Tyler, The Creator | 95 | 180386 | album | 14 | 2017-07-21 | True | https://i.scdn.co/image/ab67616d0000b2738940ac... |
| 924 | 2023-06-05 | 25 | Cruel Summer | Taylor Swift | 93 | 178426 | album | 18 | 2019-08-23 | False | https://i.scdn.co/image/ab67616d0000b273e787cf... |
| 925 | 2023-06-05 | 26 | All My Life (feat. J. Cole) | Lil Durk | 83 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 926 | 2023-06-05 | 27 | Last Night | Morgan Wallen | 89 | 163854 | album | 36 | 2023-03-03 | True | https://i.scdn.co/image/ab67616d0000b273705079... |
| 927 | 2023-06-05 | 28 | Die For You (with Ariana Grande) - Remix | The Weeknd | 88 | 232857 | album | 21 | 2023-03-14 | False | https://i.scdn.co/image/ab67616d0000b2738ad8f5... |
| 928 | 2023-06-05 | 29 | I'm Good (Blue) | David Guetta & Bebe Rexha | 94 | 175238 | single | 2 | 2022-08-26 | True | https://i.scdn.co/image/ab67616d0000b273933c03... |
| 929 | 2023-06-05 | 30 | Angels Like You | Miley Cyrus | 93 | 196453 | album | 15 | 2020-11-27 | False | https://i.scdn.co/image/ab67616d0000b2738cffb7... |
| 930 | 2023-06-05 | 31 | Say Yes To Heaven | Lana Del Rey | 90 | 209156 | single | 2 | 2023-05-19 | False | https://i.scdn.co/image/ab67616d0000b273aa2770... |
| 931 | 2023-06-05 | 32 | Bye | Peso Pluma | 85 | 212976 | single | 1 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b27310c8a0... |
| 932 | 2023-06-05 | 33 | Acróstico | Shakira | 92 | 170785 | single | 1 | 2023-05-11 | False | https://i.scdn.co/image/ab67616d0000b273bd6bbd... |
| 933 | 2023-06-05 | 34 | Angel Pt. 1 (feat. Jimin of BTS, JVKE & Muni L... | Fast & Furious: The Fast Saga & Jimin & BTS | 87 | 175802 | single | 2 | 2023-05-17 | False | https://i.scdn.co/image/ab67616d0000b273445afb... |
| 934 | 2023-06-05 | 35 | AMG | Natanael Cano & Peso Pluma & Gabito Ballesteros | 94 | 174942 | single | 1 | 2022-11-24 | True | https://i.scdn.co/image/ab67616d0000b273fbf10e... |
| 935 | 2023-06-05 | 36 | Boy's a Liar Pt. 2 | PinkPantheress & Ice Spice | 95 | 131013 | single | 2 | 2023-02-03 | False | https://i.scdn.co/image/ab67616d0000b27342c5ba... |
| 936 | 2023-06-05 | 37 | I Wanna Be Yours | Arctic Monkeys | 94 | 183956 | album | 12 | 2013-09-09 | False | https://i.scdn.co/image/ab67616d0000b2734ae1c4... |
| 937 | 2023-06-05 | 38 | Los del Espacio | LIT killah | 77 | 338000 | single | 1 | 2023-06-01 | False | https://i.scdn.co/image/ab67616d0000b27352c8b9... |
| 938 | 2023-06-05 | 39 | Frágil | Yahritza Y Su Esencia & Grupo Frontera | 91 | 160517 | single | 1 | 2023-04-07 | False | https://i.scdn.co/image/ab67616d0000b27357ed58... |
| 939 | 2023-06-05 | 40 | Annihilate (Spider-Man: Across the Spider-Vers... | Metro Boomin | 78 | 231746 | album | 13 | 2023-06-02 | False | https://i.scdn.co/image/ab67616d0000b2736ed9ae... |
| 940 | 2023-06-05 | 41 | Die For You | The Weeknd | 91 | 260253 | album | 18 | 2016-11-24 | False | https://i.scdn.co/image/ab67616d0000b273a04841... |
| 941 | 2023-06-05 | 42 | I Ain't Worried | OneRepublic | 55 | 148120 | album | 18 | 2023-02-15 | False | https://i.scdn.co/image/ab67616d0000b273fedd3d... |
| 942 | 2023-06-05 | 43 | Calling (Spider-Man: Across the Spider-Verse) ... | Metro Boomin | 77 | 219453 | album | 13 | 2023-06-02 | False | https://i.scdn.co/image/ab67616d0000b2736ed9ae... |
| 943 | 2023-06-05 | 44 | People | Libianca | 93 | 184791 | single | 1 | 2022-12-06 | False | https://i.scdn.co/image/ab67616d0000b273fc342f... |
| 944 | 2023-06-05 | 45 | Tattoo | Loreen | 93 | 183374 | single | 1 | 2023-02-25 | False | https://i.scdn.co/image/ab67616d0000b2732b0ba8... |
| 945 | 2023-06-05 | 46 | Tá OK | DENNIS & MC Kevin o Chris | 82 | 92093 | single | 1 | 2023-05-04 | False | https://i.scdn.co/image/ab67616d0000b2736b19d4... |
| 946 | 2023-06-05 | 47 | La Bachata | Manuel Turizo | 87 | 162637 | album | 15 | 2023-03-17 | False | https://i.scdn.co/image/ab67616d0000b2734dd995... |
| 947 | 2023-06-05 | 48 | Moonlight | Kali Uchis | 87 | 187723 | album | 15 | 2023-03-03 | False | https://i.scdn.co/image/ab67616d0000b27381fccd... |
| 948 | 2023-06-05 | 49 | Por las Noches | Peso Pluma | 93 | 239845 | single | 1 | 2021-06-11 | False | https://i.scdn.co/image/ab67616d0000b273427d9a... |
| 949 | 2023-06-05 | 50 | Starboy | The Weeknd | 93 | 230453 | album | 18 | 2016-11-25 | True | https://i.scdn.co/image/ab67616d0000b2734718e2... |
Q : What are the top 5 artists of June 5th 2023?
date = '2023-06-05'
global_50_df[(global_50_df['date']== date) & (global_50_df['position']<6)]| date | position | song | artist | popularity | duration_ms | album_type | total_tracks | release_date | is_explicit | album_cover_url | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 900 | 2023-06-05 | 1 | Ella Baila Sola | Eslabon Armado | 92 | 165671 | album | 16 | 2023-04-28 | False | https://i.scdn.co/image/ab67616d0000b273dfddf1... |
| 901 | 2023-06-05 | 2 | Peso Pluma: Bzrp Music Sessions, Vol. 55 | Bizarrap & Peso Pluma | 89 | 188361 | single | 1 | 2023-06-01 | True | https://i.scdn.co/image/ab67616d0000b273155830... |
| 902 | 2023-06-05 | 3 | WHERE SHE GOES | Bad Bunny | 96 | 231704 | single | 1 | 2023-05-18 | True | https://i.scdn.co/image/ab67616d0000b273ab5c9c... |
| 903 | 2023-06-05 | 4 | La Bebe - Remix | Yng Lvcas & Peso Pluma | 99 | 234352 | single | 2 | 2023-03-17 | True | https://i.scdn.co/image/ab67616d0000b273a04be3... |
| 904 | 2023-06-05 | 5 | un x100to | Grupo Frontera & Bad Bunny | 100 | 194563 | single | 1 | 2023-04-17 | False | https://i.scdn.co/image/ab67616d0000b273716c0b... |
8. Unique()
Who are the artists who have entered top 50 spotify playlist? ( over the entire time of the dataset)
global_50_df['artist'].to_list()['Eslabon Armado',
'Grupo Frontera & Bad Bunny',
'Yng Lvcas & Peso Pluma',
'FIFTY FIFTY',
'Miley Cyrus',
'David Kushner',
'SZA',
'Loreen',
'Harry Styles',
'KAROL G',
'Käärijä',
'Feid & Young Miko',
'Shakira',
'Metro Boomin',
'Tyler, The Creator',
'ROSALÍA & Rauw Alejandro',
'The Weeknd',
'Peso Pluma & Natanael Cano',
'Rema',
'Yandel',
'Junior H & Peso Pluma',
'PinkPantheress & Ice Spice',
'Taylor Swift',
'The Weeknd',
'Arctic Monkeys',
'Lil Durk & J. Cole',
'Morgan Wallen',
'David Guetta & Bebe Rexha',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'd4vd',
'Miley Cyrus',
'JVKE',
'Stephen Sanchez & Em Beihold',
'Jimin',
'Kali Uchis',
'Taylor Swift',
'Bizarrap & Shakira',
'Sam Smith',
'Tom Odell',
'The Weeknd',
'Peso Pluma',
'Alessandra',
'Ozuna',
'Libianca',
'OneRepublic',
'Manuel Turizo',
'Eminem',
'Yahritza Y Su Esencia & Grupo Frontera',
'JISOO',
'Chino Pacas',
'Eslabon Armado',
'Grupo Frontera & Bad Bunny',
'FIFTY FIFTY',
'Yng Lvcas & Peso Pluma',
'Miley Cyrus',
'David Kushner',
'SZA',
'Harry Styles',
'Loreen',
'KAROL G',
'Shakira',
'Feid & Young Miko',
'Käärijä',
'Metro Boomin',
'ROSALÍA & Rauw Alejandro',
'The Weeknd',
'Rema',
'Tyler, The Creator',
'Yandel',
'Peso Pluma & Natanael Cano',
'Junior H & Peso Pluma',
'PinkPantheress & Ice Spice',
'Taylor Swift',
'The Weeknd',
'David Guetta & Bebe Rexha',
'Morgan Wallen',
'Arctic Monkeys',
'Lil Durk & J. Cole',
'Miley Cyrus',
'JVKE',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'd4vd',
'Bizarrap & Shakira',
'Tom Odell',
'Kali Uchis',
'Stephen Sanchez & Em Beihold',
'Sam Smith',
'The Weeknd',
'Taylor Swift',
'Jimin',
'Libianca',
'Ozuna',
'OneRepublic',
'Peso Pluma',
'Manuel Turizo',
'Eminem',
'Alessandra',
'Coldplay',
'Yahritza Y Su Esencia & Grupo Frontera',
'Chino Pacas',
'Eslabon Armado',
'Grupo Frontera & Bad Bunny',
'Yng Lvcas & Peso Pluma',
'FIFTY FIFTY',
'Miley Cyrus',
'David Kushner',
'SZA',
'Harry Styles',
'Shakira',
'KAROL G',
'Feid & Young Miko',
'Loreen',
'ROSALÍA & Rauw Alejandro',
'Metro Boomin',
'The Weeknd',
'Yandel',
'Rema',
'Tyler, The Creator',
'Peso Pluma & Natanael Cano',
'Junior H & Peso Pluma',
'Käärijä',
'PinkPantheress & Ice Spice',
'Fast & Furious: The Fast Saga',
'Taylor Swift',
'Jimin',
'Morgan Wallen',
'Lil Durk & J. Cole',
'The Weeknd',
'Arctic Monkeys',
'David Guetta & Bebe Rexha',
'Miley Cyrus',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'd4vd',
'JVKE',
'Stephen Sanchez & Em Beihold',
'Bizarrap & Shakira',
'Kali Uchis',
'Tom Odell',
'The Weeknd',
'Sam Smith',
'Ozuna',
'Taylor Swift',
'OneRepublic',
'Manuel Turizo',
'Peso Pluma',
'Libianca',
'Coldplay',
'Yahritza Y Su Esencia & Grupo Frontera',
'Eminem',
'Lil Mabu',
'Bad Bunny',
'Eslabon Armado',
'Grupo Frontera & Bad Bunny',
'Yng Lvcas & Peso Pluma',
'FIFTY FIFTY',
'Miley Cyrus',
'Lana Del Rey',
'David Kushner',
'Fast & Furious: The Fast Saga & Jimin & BTS',
'SZA',
'Shakira',
'Harry Styles',
'Feid & Young Miko',
'KAROL G',
'Loreen',
'ROSALÍA & Rauw Alejandro',
'Yandel',
'Rema',
'Peso Pluma & Natanael Cano',
'Metro Boomin',
'Junior H & Peso Pluma',
'The Weeknd',
'Tyler, The Creator',
'PinkPantheress & Ice Spice',
'Käärijä',
'Morgan Wallen',
'Lil Durk & J. Cole',
'Taylor Swift',
'David Guetta & Bebe Rexha',
'Post Malone',
'The Weeknd',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'Arctic Monkeys',
'Miley Cyrus',
'Bizarrap & Shakira',
'Jimin',
'Ozuna',
'Peso Pluma',
'The Weeknd',
'Manuel Turizo',
'JVKE',
'Taylor Swift',
'd4vd',
'Tom Odell',
'Stephen Sanchez & Em Beihold',
'Kali Uchis',
'OneRepublic',
'Sam Smith',
'Libianca',
'Eladio Carrion',
'Eslabon Armado',
'Bad Bunny',
'Grupo Frontera & Bad Bunny',
'Yng Lvcas & Peso Pluma',
'FIFTY FIFTY',
'Miley Cyrus',
'SZA',
'David Kushner',
'Harry Styles',
'Shakira',
'KAROL G',
'Fast & Furious: The Fast Saga & Jimin & BTS',
'Feid & Young Miko',
'Peso Pluma & Natanael Cano',
'Junior H & Peso Pluma',
'Lana Del Rey',
'ROSALÍA & Rauw Alejandro',
'Yandel',
'Rema',
'Loreen',
'Metro Boomin',
'The Weeknd',
'PinkPantheress & Ice Spice',
'Tyler, The Creator',
'Fuerza Regida',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'Morgan Wallen',
'Taylor Swift',
'David Guetta & Bebe Rexha',
'Arctic Monkeys',
'Lil Durk & J. Cole',
'The Weeknd',
'Käärijä',
'Miley Cyrus',
'Peso Pluma',
'Bizarrap & Shakira',
'Yahritza Y Su Esencia & Grupo Frontera',
'Taylor Swift',
'OneRepublic',
'Manuel Turizo',
'The Weeknd',
'd4vd',
'Ozuna',
'Stephen Sanchez & Em Beihold',
'JVKE',
'Eden Muñoz & Junior H',
'Libianca',
'Kali Uchis',
'Tom Odell',
'Jimin',
'Eslabon Armado',
'Bad Bunny',
'Grupo Frontera & Bad Bunny',
'Yng Lvcas & Peso Pluma',
'FIFTY FIFTY',
'Miley Cyrus',
'David Kushner',
'SZA',
'Harry Styles',
'Fast & Furious: The Fast Saga & Jimin & BTS',
'KAROL G',
'Feid & Young Miko',
'Shakira',
'Junior H & Peso Pluma',
'Peso Pluma & Natanael Cano',
'Tyler, The Creator',
'The Weeknd',
'Rema',
'Fuerza Regida',
'Metro Boomin',
'Lana Del Rey',
'PinkPantheress & Ice Spice',
'ROSALÍA & Rauw Alejandro',
'Loreen',
'Yandel',
'Morgan Wallen',
'Arctic Monkeys',
'Taylor Swift',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'Miley Cyrus',
'The Weeknd',
'Lil Durk & J. Cole',
'd4vd',
'Taylor Swift',
'David Guetta & Bebe Rexha',
'The Weeknd',
'JVKE',
'Stephen Sanchez & Em Beihold',
'OneRepublic',
'Tom Odell',
'Peso Pluma',
'Kali Uchis',
'Jimin',
'Libianca',
'Yahritza Y Su Esencia & Grupo Frontera',
'Chino Pacas',
'Bizarrap & Shakira',
'Coldplay',
'Käärijä',
'Manuel Turizo',
'Bad Bunny',
'Eslabon Armado',
'Grupo Frontera & Bad Bunny',
'FIFTY FIFTY',
'Yng Lvcas & Peso Pluma',
'Miley Cyrus',
'David Kushner',
'SZA',
'Harry Styles',
'Fast & Furious: The Fast Saga & Jimin & BTS',
'Shakira',
'KAROL G',
'Feid & Young Miko',
'Tyler, The Creator',
'Metro Boomin',
'ROSALÍA & Rauw Alejandro',
'Rema',
'Fuerza Regida',
'The Weeknd',
'Loreen',
'Lana Del Rey',
'PinkPantheress & Ice Spice',
'Arctic Monkeys',
'Yandel',
'Junior H & Peso Pluma',
'Peso Pluma & Natanael Cano',
'Morgan Wallen',
'Taylor Swift',
'Lil Durk & J. Cole',
'The Weeknd',
'Miley Cyrus',
'Taylor Swift',
'David Guetta & Bebe Rexha',
'd4vd',
'The Weeknd',
'Stephen Sanchez & Em Beihold',
'Tom Odell',
'Libianca',
'Kali Uchis',
'JVKE',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'OneRepublic',
'Beyoncé & Kendrick Lamar',
'Peso Pluma',
'Yahritza Y Su Esencia & Grupo Frontera',
'Sam Smith',
'Jimin',
'Coldplay',
'Bizarrap & Shakira',
'Manuel Turizo',
'Eslabon Armado',
'Bad Bunny',
'Grupo Frontera & Bad Bunny',
'FIFTY FIFTY',
'Yng Lvcas & Peso Pluma',
'Miley Cyrus',
'David Kushner',
'SZA',
'Harry Styles',
'Shakira',
'KAROL G',
'Fast & Furious: The Fast Saga & Jimin & BTS',
'Feid & Young Miko',
'Metro Boomin',
'Rema',
'ROSALÍA & Rauw Alejandro',
'Tyler, The Creator',
'The Weeknd',
'Fuerza Regida',
'Junior H & Peso Pluma',
'Yandel',
'Loreen',
'Peso Pluma & Natanael Cano',
'PinkPantheress & Ice Spice',
'Arctic Monkeys',
'Lil Durk & J. Cole',
'Miley Cyrus',
'Morgan Wallen',
'Taylor Swift',
'Lana Del Rey',
'The Weeknd',
'Taylor Swift',
'David Guetta & Bebe Rexha',
'd4vd',
'ENHYPEN',
'Tom Odell',
'Kali Uchis',
'Libianca',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'JVKE',
'Stephen Sanchez & Em Beihold',
'The Weeknd',
'OneRepublic',
'Manuel Turizo',
'Beyoncé & Kendrick Lamar',
'Sam Smith',
'Bizarrap & Shakira',
'Yahritza Y Su Esencia & Grupo Frontera',
'Coldplay',
'Peso Pluma',
'Eslabon Armado',
'Bad Bunny',
'Grupo Frontera & Bad Bunny',
'Yng Lvcas & Peso Pluma',
'FIFTY FIFTY',
'Miley Cyrus',
'David Kushner',
'SZA',
'Harry Styles',
'KAROL G',
'Feid & Young Miko',
'Shakira',
'Fast & Furious: The Fast Saga & Jimin & BTS',
'Metro Boomin',
'ROSALÍA & Rauw Alejandro',
'Rema',
'The Weeknd',
'Tyler, The Creator',
'Fuerza Regida',
'Yandel',
'Junior H & Peso Pluma',
'PinkPantheress & Ice Spice',
'Peso Pluma & Natanael Cano',
'Loreen',
'Arctic Monkeys',
'Taylor Swift',
'Miley Cyrus',
'Lil Durk & J. Cole',
'Morgan Wallen',
'The Weeknd',
'David Guetta & Bebe Rexha',
'Taylor Swift',
'Lana Del Rey',
'd4vd',
'Tom Odell',
'The Weeknd',
'Libianca',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'Stephen Sanchez & Em Beihold',
'Kali Uchis',
'JVKE',
'OneRepublic',
'Manuel Turizo',
'Bizarrap & Shakira',
'Sam Smith',
'Yahritza Y Su Esencia & Grupo Frontera',
'Coldplay',
'Peso Pluma',
'Ozuna',
'Eden Muñoz & Junior H',
'Eslabon Armado',
'Bad Bunny',
'Yng Lvcas & Peso Pluma',
'Grupo Frontera & Bad Bunny',
'FIFTY FIFTY',
'Miley Cyrus',
'David Kushner',
'SZA',
'Harry Styles',
'KAROL G',
'Feid & Young Miko',
'Fast & Furious: The Fast Saga & Jimin & BTS',
'Shakira',
'Fuerza Regida',
'Metro Boomin',
'Rema',
'ROSALÍA & Rauw Alejandro',
'Yandel',
'Junior H & Peso Pluma',
'Tyler, The Creator',
'The Weeknd',
'PinkPantheress & Ice Spice',
'Peso Pluma & Natanael Cano',
'Taylor Swift',
'The Weeknd',
'Arctic Monkeys',
'Morgan Wallen',
'Lil Durk & J. Cole',
'Loreen',
'Miley Cyrus',
'David Guetta & Bebe Rexha',
'Tina Turner',
'Tina Turner',
'd4vd',
'Lana Del Rey',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'Libianca',
'Taylor Swift',
'The Weeknd',
'Tom Odell',
'JVKE',
'Kali Uchis',
'Peso Pluma',
'OneRepublic',
'Bizarrap & Shakira',
'Stephen Sanchez & Em Beihold',
'Manuel Turizo',
'Sam Smith',
'Ozuna',
'Yahritza Y Su Esencia & Grupo Frontera',
'Eslabon Armado',
'Bad Bunny',
'Yng Lvcas & Peso Pluma',
'Grupo Frontera & Bad Bunny',
'Taylor Swift',
'Taylor Swift',
'FIFTY FIFTY',
'Taylor Swift',
'Miley Cyrus',
'David Kushner',
'SZA',
'Harry Styles',
'KAROL G',
'Lil Durk',
'Feid & Young Miko',
'Taylor Swift',
'Fuerza Regida',
'Rema',
'Shakira',
'Dua Lipa',
'Metro Boomin',
'ROSALÍA & Rauw Alejandro',
'Junior H & Peso Pluma',
'Yandel',
'The Weeknd',
'Fast & Furious: The Fast Saga & Jimin & BTS',
'Tyler, The Creator',
'Morgan Wallen',
'PinkPantheress & Ice Spice',
'Peso Pluma & Natanael Cano',
'David Guetta & Bebe Rexha',
'Loreen',
'Taylor Swift',
'The Weeknd',
'Arctic Monkeys',
'Miley Cyrus',
'Lana Del Rey',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'd4vd',
'Libianca',
'OneRepublic',
'Peso Pluma',
'Manuel Turizo',
'The Weeknd',
'JVKE',
'Tom Odell',
'Kali Uchis',
'Ozuna',
'Bizarrap & Shakira',
'Stephen Sanchez & Em Beihold',
'Eslabon Armado',
'Yng Lvcas & Peso Pluma',
'Grupo Frontera & Bad Bunny',
'Bad Bunny',
'FIFTY FIFTY',
'Miley Cyrus',
'Harry Styles',
'SZA',
'David Kushner',
'KAROL G',
'Feid & Young Miko',
'Fuerza Regida',
'Rema',
'Taylor Swift',
'Taylor Swift',
'Junior H & Peso Pluma',
'Shakira',
'Lil Durk',
'ROSALÍA & Rauw Alejandro',
'Metro Boomin',
'Yandel',
'Peso Pluma & Natanael Cano',
'The Weeknd',
'Tyler, The Creator',
'Morgan Wallen',
'PinkPantheress & Ice Spice',
'Taylor Swift',
'David Guetta & Bebe Rexha',
'Fast & Furious: The Fast Saga & Jimin & BTS',
'Arctic Monkeys',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'Dua Lipa',
'The Weeknd',
'Taylor Swift',
'Taylor Swift',
'Miley Cyrus',
'Loreen',
'Libianca',
'OneRepublic',
'd4vd',
'Peso Pluma',
'Manuel Turizo',
'Bizarrap & Shakira',
'Ozuna',
'Lana Del Rey',
'Yahritza Y Su Esencia & Grupo Frontera',
'Kali Uchis',
'The Weeknd',
'JVKE',
'Stephen Sanchez & Em Beihold',
'Eslabon Armado',
'Yng Lvcas & Peso Pluma',
'Bad Bunny',
'Grupo Frontera & Bad Bunny',
'FIFTY FIFTY',
'Miley Cyrus',
'SZA',
'Harry Styles',
'David Kushner',
'Fuerza Regida',
'KAROL G',
'Junior H & Peso Pluma',
'Feid & Young Miko',
'Taylor Swift',
'Rema',
'The Weeknd',
'Metro Boomin',
'Fast & Furious: The Fast Saga & Jimin & BTS',
'Tyler, The Creator',
'Peso Pluma & Natanael Cano',
'Morgan Wallen',
'Yandel',
'Taylor Swift',
'Miley Cyrus',
'PinkPantheress & Ice Spice',
'Arctic Monkeys',
'ROSALÍA & Rauw Alejandro',
'Lil Durk',
'Shakira',
'The Weeknd',
'd4vd',
'Lana Del Rey',
'Taylor Swift',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'David Guetta & Bebe Rexha',
'Libianca',
'Peso Pluma',
'Dua Lipa',
'OneRepublic',
'Kali Uchis',
'JVKE',
'Loreen',
'Stephen Sanchez & Em Beihold',
'The Weeknd',
'Yahritza Y Su Esencia & Grupo Frontera',
'Taylor Swift',
'Tom Odell',
'Manuel Turizo',
'Bizarrap & Shakira',
'Jimin',
'Eslabon Armado',
'Bad Bunny',
'Yng Lvcas & Peso Pluma',
'FIFTY FIFTY',
'Grupo Frontera & Bad Bunny',
'Miley Cyrus',
'David Kushner',
'SZA',
'Harry Styles',
'KAROL G',
'Feid & Young Miko',
'Fuerza Regida',
'Taylor Swift',
'Rema',
'Metro Boomin',
'The Weeknd',
'Fast & Furious: The Fast Saga & Jimin & BTS',
'Tyler, The Creator',
'Miley Cyrus',
'Morgan Wallen',
'ROSALÍA & Rauw Alejandro',
'Junior H & Peso Pluma',
'Arctic Monkeys',
'Lil Durk',
'The Weeknd',
'Yandel',
'Shakira',
'PinkPantheress & Ice Spice',
'Lana Del Rey',
'Taylor Swift',
'David Guetta & Bebe Rexha',
'd4vd',
'Taylor Swift',
'Peso Pluma & Natanael Cano',
'Libianca',
'OneRepublic',
'Dua Lipa',
'Kali Uchis',
'Loreen',
'Tom Odell',
'JVKE',
'Stephen Sanchez & Em Beihold',
'The Weeknd',
'Jimin',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'Coldplay',
'Peso Pluma',
'Manuel Turizo',
'Sam Smith',
'Bizarrap & Shakira',
'Eslabon Armado',
'Bad Bunny',
'Yng Lvcas & Peso Pluma',
'Grupo Frontera & Bad Bunny',
'FIFTY FIFTY',
'Miley Cyrus',
'David Kushner',
'SZA',
'Harry Styles',
'Feid & Young Miko',
'KAROL G',
'Fuerza Regida',
'Rema',
'Taylor Swift',
'Metro Boomin',
'The Weeknd',
'Lil Durk',
'Tyler, The Creator',
'ROSALÍA & Rauw Alejandro',
'Junior H & Peso Pluma',
'Fast & Furious: The Fast Saga & Jimin & BTS',
'Miley Cyrus',
'Yandel',
'Lana Del Rey',
'The Weeknd',
'Morgan Wallen',
'Arctic Monkeys',
'PinkPantheress & Ice Spice',
'Shakira',
'David Guetta & Bebe Rexha',
'Taylor Swift',
'Dua Lipa',
'd4vd',
'Peso Pluma & Natanael Cano',
'Libianca',
'Taylor Swift',
'Loreen',
'Kali Uchis',
'JVKE',
'Tom Odell',
'OneRepublic',
'Stephen Sanchez & Em Beihold',
'The Weeknd',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'Jimin',
'Manuel Turizo',
'Peso Pluma',
'Sam Smith',
'Ozuna',
'Coldplay',
'Eslabon Armado',
'Bad Bunny',
'Yng Lvcas & Peso Pluma',
'Grupo Frontera & Bad Bunny',
'FIFTY FIFTY',
'Miley Cyrus',
'David Kushner',
'SZA',
'Harry Styles',
'Feid & Young Miko',
'KAROL G',
'Fuerza Regida',
'Rema',
'Metro Boomin',
'Taylor Swift',
'Junior H & Peso Pluma',
'The Weeknd',
'ROSALÍA & Rauw Alejandro',
'Tyler, The Creator',
'Fast & Furious: The Fast Saga & Jimin & BTS',
'Lil Durk',
'Miley Cyrus',
'Yandel',
'Lana Del Rey',
'Arctic Monkeys',
'Morgan Wallen',
'The Weeknd',
'Shakira',
'David Guetta & Bebe Rexha',
'Dua Lipa',
'Peso Pluma & Natanael Cano',
'Taylor Swift',
'd4vd',
'Libianca',
'PinkPantheress & Ice Spice',
'Loreen',
'Kali Uchis',
'OneRepublic',
'Tom Odell',
'JVKE',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'Jimin',
'Stephen Sanchez & Em Beihold',
'The Weeknd',
'Peso Pluma',
'Manuel Turizo',
'Ozuna',
'Sam Smith',
'Peso Pluma',
'Bizarrap & Shakira',
'Bizarrap & Peso Pluma',
'Eslabon Armado',
'Bad Bunny',
'Yng Lvcas & Peso Pluma',
'Grupo Frontera & Bad Bunny',
'FIFTY FIFTY',
'Miley Cyrus',
'David Kushner',
'Fuerza Regida',
'SZA',
'Harry Styles',
'Feid & Young Miko',
'KAROL G',
'Rema',
'Dua Lipa',
'ROSALÍA & Rauw Alejandro',
'Junior H & Peso Pluma',
'Taylor Swift',
'Lana Del Rey',
'Tyler, The Creator',
'Metro Boomin',
'Peso Pluma & Natanael Cano',
'Fast & Furious: The Fast Saga & Jimin & BTS',
'Lil Durk',
'The Weeknd',
'Shakira',
'Yandel',
'Miley Cyrus',
'Arctic Monkeys',
'Morgan Wallen',
'Taylor Swift',
'David Guetta & Bebe Rexha',
'PinkPantheress & Ice Spice',
'Peso Pluma',
'The Weeknd',
'Libianca',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'OneRepublic',
'Kali Uchis',
'Loreen',
'd4vd',
'Tom Odell',
'The Weeknd',
'JVKE',
'Stephen Sanchez & Em Beihold',
'Jimin',
'Manuel Turizo',
'Yahritza Y Su Esencia & Grupo Frontera',
'Bizarrap & Quevedo',
'Sam Smith',
'Bizarrap & Peso Pluma',
'Eslabon Armado',
'Bad Bunny',
'Yng Lvcas & Peso Pluma',
'Grupo Frontera & Bad Bunny',
'Miley Cyrus',
'FIFTY FIFTY',
'Fuerza Regida',
'Dave & Central Cee',
'The Weeknd & Playboi Carti & Madonna',
'David Kushner',
'Harry Styles',
'SZA',
'Feid & Young Miko',
'KAROL G',
'Rema',
'Dua Lipa',
'ROSALÍA & Rauw Alejandro',
'Junior H & Peso Pluma',
'Metro Boomin',
'Taylor Swift',
'Tyler, The Creator',
'Yandel',
'Lana Del Rey',
'Peso Pluma & Natanael Cano',
'Taylor Swift',
'Lil Durk',
'Fast & Furious: The Fast Saga & Jimin & BTS',
'The Weeknd',
'Miley Cyrus',
'Morgan Wallen',
'David Guetta & Bebe Rexha',
'Shakira',
'Metro Boomin',
'PinkPantheress & Ice Spice',
'Arctic Monkeys',
'Peso Pluma',
'The Weeknd',
'Libianca',
'Loreen',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'Stray Kids',
'OneRepublic',
'Metro Boomin',
'LIT killah',
'Kali Uchis',
'Yahritza Y Su Esencia & Grupo Frontera',
'Tom Odell',
'Jimin',
'The Weeknd',
'Eslabon Armado',
'Bizarrap & Peso Pluma',
'Bad Bunny',
'Yng Lvcas & Peso Pluma',
'Grupo Frontera & Bad Bunny',
'Miley Cyrus',
'FIFTY FIFTY',
'Fuerza Regida',
'Harry Styles',
'David Kushner',
'SZA',
'Dave & Central Cee',
'Feid & Young Miko',
'KAROL G',
'Junior H & Peso Pluma',
'Rema',
'The Weeknd & Playboi Carti & Madonna',
'ROSALÍA & Rauw Alejandro',
'Dua Lipa',
'Peso Pluma & Natanael Cano',
'Yandel',
'Taylor Swift',
'Metro Boomin',
'Tyler, The Creator',
'Taylor Swift',
'Lil Durk',
'Morgan Wallen',
'The Weeknd',
'David Guetta & Bebe Rexha',
'Miley Cyrus',
'Lana Del Rey',
'Peso Pluma',
'Shakira',
'Fast & Furious: The Fast Saga & Jimin & BTS',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'PinkPantheress & Ice Spice',
'Arctic Monkeys',
'LIT killah',
'Yahritza Y Su Esencia & Grupo Frontera',
'Metro Boomin',
'The Weeknd',
'OneRepublic',
'Metro Boomin',
'Libianca',
'Loreen',
'DENNIS & MC Kevin o Chris',
'Manuel Turizo',
'Kali Uchis',
'Peso Pluma',
'The Weeknd',
'Eslabon Armado',
'Bizarrap & Peso Pluma',
'Bad Bunny',
'Grupo Frontera & Bad Bunny',
'Yng Lvcas & Peso Pluma',
'FIFTY FIFTY',
'Miley Cyrus',
'Fuerza Regida',
'David Kushner',
'Harry Styles',
'SZA',
'Dave & Central Cee',
'Feid & Young Miko',
'Junior H & Peso Pluma',
'Rema',
'KAROL G',
'Tyler, The Creator',
'Peso Pluma & Natanael Cano',
'Metro Boomin',
'Miley Cyrus',
'Taylor Swift',
'Taylor Swift',
'Dua Lipa',
'Lana Del Rey',
'The Weeknd',
'Fast & Furious: The Fast Saga & Jimin & BTS',
'ROSALÍA & Rauw Alejandro',
'The Weeknd & Playboi Carti & Madonna',
'Arctic Monkeys',
'Yandel',
'Morgan Wallen',
'Metro Boomin',
'Lil Durk',
'Metro Boomin',
'The Weeknd',
'PinkPantheress & Ice Spice',
'David Guetta & Bebe Rexha',
'Natanael Cano & Peso Pluma & Gabito Ballesteros',
'Peso Pluma',
'LIT killah',
'Post Malone',
'Kali Uchis',
'Yahritza Y Su Esencia & Grupo Frontera',
'Libianca',
'Shakira',
'Metro Boomin',
'Jimin',
'OneRepublic',
'The Weeknd',
'Peso Pluma',
...]top_50_artists_of_all_time = global_50_df['artist'].unique()9. Length, Average, Median
top_50_artists_of_all_timearray(['Eslabon Armado', 'Grupo Frontera & Bad Bunny',
'Yng Lvcas & Peso Pluma', 'FIFTY FIFTY', 'Miley Cyrus',
'David Kushner', 'SZA', 'Loreen', 'Harry Styles', 'KAROL G',
'Käärijä', 'Feid & Young Miko', 'Shakira', 'Metro Boomin',
'Tyler, The Creator', 'ROSALÍA & Rauw Alejandro', 'The Weeknd',
'Peso Pluma & Natanael Cano', 'Rema', 'Yandel',
'Junior H & Peso Pluma', 'PinkPantheress & Ice Spice',
'Taylor Swift', 'Arctic Monkeys', 'Lil Durk & J. Cole',
'Morgan Wallen', 'David Guetta & Bebe Rexha',
'Natanael Cano & Peso Pluma & Gabito Ballesteros', 'd4vd', 'JVKE',
'Stephen Sanchez & Em Beihold', 'Jimin', 'Kali Uchis',
'Bizarrap & Shakira', 'Sam Smith', 'Tom Odell', 'Peso Pluma',
'Alessandra', 'Ozuna', 'Libianca', 'OneRepublic', 'Manuel Turizo',
'Eminem', 'Yahritza Y Su Esencia & Grupo Frontera', 'JISOO',
'Chino Pacas', 'Coldplay', 'Fast & Furious: The Fast Saga',
'Lil Mabu', 'Bad Bunny', 'Lana Del Rey',
'Fast & Furious: The Fast Saga & Jimin & BTS', 'Post Malone',
'Eladio Carrion', 'Fuerza Regida', 'Eden Muñoz & Junior H',
'Beyoncé & Kendrick Lamar', 'ENHYPEN', 'Tina Turner', 'Lil Durk',
'Dua Lipa', 'Bizarrap & Peso Pluma', 'Bizarrap & Quevedo',
'Dave & Central Cee', 'The Weeknd & Playboi Carti & Madonna',
'Stray Kids', 'LIT killah', 'DENNIS & MC Kevin o Chris',
'Halsey & SUGA', 'Sky Rompiendo & Feid & Myke Towers', 'BTS',
'J Hus & Drake', 'Saiko & Feid & Quevedo', 'Glass Animals',
'Doja Cat'], dtype=object)len(top_50_artists_of_all_time)75Q : How long are the song usually?
Average , Median
global_50_df.columnsIndex(['date', 'position', 'song', 'artist', 'popularity', 'duration_ms',
'album_type', 'total_tracks', 'release_date', 'is_explicit',
'album_cover_url'],
dtype='object')global_50_df.duration_ms.mean()
global_50_df.duration_ms.median()194563.0Who are the artists with explicit music that were in the top 50 daily spotify playlists?
global_50_df[global_50_df['is_explicit']]['artist'].unique()array(['Yng Lvcas & Peso Pluma', 'KAROL G', 'Feid & Young Miko',
'Metro Boomin', 'Tyler, The Creator', 'Peso Pluma & Natanael Cano',
'Yandel', 'Lil Durk & J. Cole', 'Morgan Wallen',
'David Guetta & Bebe Rexha',
'Natanael Cano & Peso Pluma & Gabito Ballesteros', 'Tom Odell',
'The Weeknd', 'Eminem', 'Chino Pacas', 'Lil Mabu', 'Bad Bunny',
'Post Malone', 'Eladio Carrion', 'Fuerza Regida',
'Beyoncé & Kendrick Lamar', 'Taylor Swift', 'Lil Durk',
'Peso Pluma', 'Bizarrap & Peso Pluma', 'Dave & Central Cee',
'The Weeknd & Playboi Carti & Madonna', 'Halsey & SUGA',
'Sky Rompiendo & Feid & Myke Towers', 'Saiko & Feid & Quevedo',
'Doja Cat'], dtype=object)10. Value Counts, Sort Values
the artists with explicit music that were in the top 50 daily spotify playlists, How many spots did they take?
global_50_df[global_50_df['is_explicit']]['artist'].value_counts()Yng Lvcas & Peso Pluma 36
The Weeknd 36
Feid & Young Miko 36
Metro Boomin 36
Tyler, The Creator 36
Peso Pluma & Natanael Cano 36
Yandel 36
Morgan Wallen 36
David Guetta & Bebe Rexha 36
KAROL G 36
Bad Bunny 33
Fuerza Regida 32
Tom Odell 29
Natanael Cano & Peso Pluma & Gabito Ballesteros 22
Lil Durk 20
Bizarrap & Peso Pluma 20
Dave & Central Cee 19
The Weeknd & Playboi Carti & Madonna 14
Sky Rompiendo & Feid & Myke Towers 13
Lil Durk & J. Cole 10
Peso Pluma 10
Taylor Swift 10
Doja Cat 5
Chino Pacas 3
Halsey & SUGA 3
Eminem 3
Beyoncé & Kendrick Lamar 2
Eladio Carrion 1
Post Malone 1
Saiko & Feid & Quevedo 1
Lil Mabu 1
Name: artist, dtype: int64Mean duration of songs by each artist
global_50_df[['artist','duration_ms']].groupby('artist').mean()| duration_ms | |
|---|---|
| artist | |
| Alessandra | 147979.0 |
| Arctic Monkeys | 183956.0 |
| BTS | 229953.0 |
| Bad Bunny | 231704.0 |
| Beyoncé & Kendrick Lamar | 260962.0 |
| ... | ... |
| Tyler, The Creator | 180386.0 |
| Yahritza Y Su Esencia & Grupo Frontera | 160517.0 |
| Yandel | 216148.0 |
| Yng Lvcas & Peso Pluma | 234352.0 |
| d4vd | 242484.0 |
75 rows × 1 columns
global_50_df[['artist','duration_ms']].groupby('artist').mean().sort_values(by='duration_ms')| duration_ms | |
|---|---|
| artist | |
| Lil Mabu | 88304.0 |
| DENNIS & MC Kevin o Chris | 92093.0 |
| Chino Pacas | 112087.0 |
| PinkPantheress & Ice Spice | 131013.0 |
| Alessandra | 147979.0 |
| ... | ... |
| Coldplay | 266773.0 |
| Doja Cat | 277043.0 |
| Tina Turner | 280020.0 |
| Saiko & Feid & Quevedo | 288000.0 |
| LIT killah | 338000.0 |
75 rows × 1 columns
global_50_df[['artist','duration_ms']].groupby('artist').mean().sort_values(by='duration_ms').head(5)| duration_ms | |
|---|---|
| artist | |
| Lil Mabu | 88304.0 |
| DENNIS & MC Kevin o Chris | 92093.0 |
| Chino Pacas | 112087.0 |
| PinkPantheress & Ice Spice | 131013.0 |
| Alessandra | 147979.0 |
global_50_df[['artist','duration_ms']].groupby('artist').mean().sort_values(by='duration_ms').tail(5)| duration_ms | |
|---|---|
| artist | |
| Coldplay | 266773.0 |
| Doja Cat | 277043.0 |
| Tina Turner | 280020.0 |
| Saiko & Feid & Quevedo | 288000.0 |
| LIT killah | 338000.0 |
11. str.startswith
Q : Who are the artists whose name starts with Lil
global_50_df[global_50_df['artist'].str.startswith('Lil')]['artist'].unique()array(['Lil Durk & J. Cole', 'Lil Mabu', 'Lil Durk'], dtype=object)Q : Spots that the above artists took?
lil_artists = global_50_df[global_50_df['artist'].str.startswith('Lil')]['artist'].unique().tolist()global_50_df[global_50_df['artist'].isin(lil_artists)]| date | position | song | artist | popularity | duration_ms | album_type | total_tracks | release_date | is_explicit | album_cover_url | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 25 | 2023-05-18 | 26 | All My Life (feat. J. Cole) | Lil Durk & J. Cole | 84 | 223878 | single | 1 | 2023-05-12 | True | https://i.scdn.co/image/ab67616d0000b2737c173b... |
| 77 | 2023-05-19 | 28 | All My Life (feat. J. Cole) | Lil Durk & J. Cole | 85 | 223878 | single | 1 | 2023-05-12 | True | https://i.scdn.co/image/ab67616d0000b2737c173b... |
| 126 | 2023-05-20 | 27 | All My Life (feat. J. Cole) | Lil Durk & J. Cole | 86 | 223878 | single | 1 | 2023-05-12 | True | https://i.scdn.co/image/ab67616d0000b2737c173b... |
| 149 | 2023-05-20 | 50 | MATHEMATICAL DISRESPECT | Lil Mabu | 85 | 88304 | single | 1 | 2023-05-05 | True | https://i.scdn.co/image/ab67616d0000b273a56e7d... |
| 176 | 2023-05-21 | 27 | All My Life (feat. J. Cole) | Lil Durk & J. Cole | 87 | 223878 | single | 1 | 2023-05-12 | True | https://i.scdn.co/image/ab67616d0000b2737c173b... |
| 230 | 2023-05-22 | 31 | All My Life (feat. J. Cole) | Lil Durk & J. Cole | 87 | 223878 | single | 1 | 2023-05-12 | True | https://i.scdn.co/image/ab67616d0000b2737c173b... |
| 281 | 2023-05-23 | 32 | All My Life (feat. J. Cole) | Lil Durk & J. Cole | 88 | 223878 | single | 1 | 2023-05-12 | True | https://i.scdn.co/image/ab67616d0000b2737c173b... |
| 328 | 2023-05-24 | 29 | All My Life (feat. J. Cole) | Lil Durk & J. Cole | 88 | 223878 | single | 1 | 2023-05-12 | True | https://i.scdn.co/image/ab67616d0000b2737c173b... |
| 375 | 2023-05-25 | 26 | All My Life (feat. J. Cole) | Lil Durk & J. Cole | 89 | 223878 | single | 1 | 2023-05-12 | True | https://i.scdn.co/image/ab67616d0000b2737c173b... |
| 427 | 2023-05-26 | 28 | All My Life (feat. J. Cole) | Lil Durk & J. Cole | 89 | 223878 | single | 1 | 2023-05-12 | True | https://i.scdn.co/image/ab67616d0000b2737c173b... |
| 477 | 2023-05-27 | 28 | All My Life (feat. J. Cole) | Lil Durk & J. Cole | 89 | 223878 | single | 1 | 2023-05-12 | True | https://i.scdn.co/image/ab67616d0000b2737c173b... |
| 513 | 2023-05-28 | 14 | All My Life (feat. J. Cole) | Lil Durk | 72 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 567 | 2023-05-29 | 18 | All My Life (feat. J. Cole) | Lil Durk | 77 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 627 | 2023-05-30 | 28 | All My Life (feat. J. Cole) | Lil Durk | 79 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 673 | 2023-05-31 | 24 | All My Life (feat. J. Cole) | Lil Durk | 80 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 716 | 2023-06-01 | 17 | All My Life (feat. J. Cole) | Lil Durk | 81 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 770 | 2023-06-02 | 21 | All My Life (feat. J. Cole) | Lil Durk | 82 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 823 | 2023-06-03 | 24 | All My Life (feat. J. Cole) | Lil Durk | 82 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 876 | 2023-06-04 | 27 | All My Life (feat. J. Cole) | Lil Durk | 83 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 925 | 2023-06-05 | 26 | All My Life (feat. J. Cole) | Lil Durk | 83 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 982 | 2023-06-06 | 33 | All My Life (feat. J. Cole) | Lil Durk | 84 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 1027 | 2023-06-07 | 28 | All My Life (feat. J. Cole) | Lil Durk | 84 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 1077 | 2023-06-08 | 28 | All My Life (feat. J. Cole) | Lil Durk | 84 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 1131 | 2023-06-09 | 32 | All My Life (feat. J. Cole) | Lil Durk | 84 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 1185 | 2023-06-10 | 36 | All My Life (feat. J. Cole) | Lil Durk | 84 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 1244 | 2023-06-11 | 45 | All My Life (feat. J. Cole) | Lil Durk | 84 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 1398 | 2023-06-14 | 49 | All My Life (feat. J. Cole) | Lil Durk | 84 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 1444 | 2023-06-15 | 45 | All My Life (feat. J. Cole) | Lil Durk | 84 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 1493 | 2023-06-16 | 44 | All My Life (feat. J. Cole) | Lil Durk | 84 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 1540 | 2023-06-17 | 41 | All My Life (feat. J. Cole) | Lil Durk | 84 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
| 1799 | 2023-06-22 | 50 | All My Life (feat. J. Cole) | Lil Durk | 84 | 223878 | album | 21 | 2023-05-26 | True | https://i.scdn.co/image/ab67616d0000b2736234c2... |
global_50_df[global_50_df['artist'].isin(lil_artists)].shape(31, 11)12. Identifying and removing duplicates
Q : Unique songs by artists whose names starts with lil
lil_artists_songs_df = global_50_df[global_50_df['artist'].isin(lil_artists)][['artist','song']]
lil_artists_songs_df| artist | song | |
|---|---|---|
| 25 | Lil Durk & J. Cole | All My Life (feat. J. Cole) |
| 77 | Lil Durk & J. Cole | All My Life (feat. J. Cole) |
| 126 | Lil Durk & J. Cole | All My Life (feat. J. Cole) |
| 149 | Lil Mabu | MATHEMATICAL DISRESPECT |
| 176 | Lil Durk & J. Cole | All My Life (feat. J. Cole) |
| 230 | Lil Durk & J. Cole | All My Life (feat. J. Cole) |
| 281 | Lil Durk & J. Cole | All My Life (feat. J. Cole) |
| 328 | Lil Durk & J. Cole | All My Life (feat. J. Cole) |
| 375 | Lil Durk & J. Cole | All My Life (feat. J. Cole) |
| 427 | Lil Durk & J. Cole | All My Life (feat. J. Cole) |
| 477 | Lil Durk & J. Cole | All My Life (feat. J. Cole) |
| 513 | Lil Durk | All My Life (feat. J. Cole) |
| 567 | Lil Durk | All My Life (feat. J. Cole) |
| 627 | Lil Durk | All My Life (feat. J. Cole) |
| 673 | Lil Durk | All My Life (feat. J. Cole) |
| 716 | Lil Durk | All My Life (feat. J. Cole) |
| 770 | Lil Durk | All My Life (feat. J. Cole) |
| 823 | Lil Durk | All My Life (feat. J. Cole) |
| 876 | Lil Durk | All My Life (feat. J. Cole) |
| 925 | Lil Durk | All My Life (feat. J. Cole) |
| 982 | Lil Durk | All My Life (feat. J. Cole) |
| 1027 | Lil Durk | All My Life (feat. J. Cole) |
| 1077 | Lil Durk | All My Life (feat. J. Cole) |
| 1131 | Lil Durk | All My Life (feat. J. Cole) |
| 1185 | Lil Durk | All My Life (feat. J. Cole) |
| 1244 | Lil Durk | All My Life (feat. J. Cole) |
| 1398 | Lil Durk | All My Life (feat. J. Cole) |
| 1444 | Lil Durk | All My Life (feat. J. Cole) |
| 1493 | Lil Durk | All My Life (feat. J. Cole) |
| 1540 | Lil Durk | All My Life (feat. J. Cole) |
| 1799 | Lil Durk | All My Life (feat. J. Cole) |
lil_artists_songs_df[['artist','song']].duplicated()25 False
77 True
126 True
149 False
176 True
230 True
281 True
328 True
375 True
427 True
477 True
513 False
567 True
627 True
673 True
716 True
770 True
823 True
876 True
925 True
982 True
1027 True
1077 True
1131 True
1185 True
1244 True
1398 True
1444 True
1493 True
1540 True
1799 True
dtype: boollil_artists_songs_df[lil_artists_songs_df[['artist','song']].duplicated() != True]| artist | song | |
|---|---|---|
| 25 | Lil Durk & J. Cole | All My Life (feat. J. Cole) |
| 149 | Lil Mabu | MATHEMATICAL DISRESPECT |
| 513 | Lil Durk | All My Life (feat. J. Cole) |
lil_artists_songs_df.drop_duplicates()| artist | song | |
|---|---|---|
| 25 | Lil Durk & J. Cole | All My Life (feat. J. Cole) |
| 149 | Lil Mabu | MATHEMATICAL DISRESPECT |
| 513 | Lil Durk | All My Life (feat. J. Cole) |