Skip to content

Instantly share code, notes, and snippets.

@MartinWeiss12

MartinWeiss12/spotify-wrapped.py

Last active December 11, 2023 19:44
Show Gist options
  • Save MartinWeiss12/f7586c5e671018ff391488915282d331 to your computer and use it in GitHub Desktop.
Save MartinWeiss12/f7586c5e671018ff391488915282d331 to your computer and use it in GitHub Desktop.
Download ZIP
track_artist DataFrame
Raw
spotify-wrapped.py
cleaned_df = pd.DataFrame(list(zip(
filtered_data['master_metadata_track_name'],
filtered_data['master_metadata_album_album_name'],
filtered_data['master_metadata_album_artist_name'],
filtered_data['spotify_track_uri'])),
columns=['Track', 'Album', 'Artist', 'Track URI']
)
cleaned_df = (
cleaned_df[~cleaned_df[['Track', 'Album', 'Artist', 'Track URI']]
.apply(lambda x: 'None' in x.values, axis=1)]
.reset_index(drop=True)
)
cleaned_df['Track URI'] = cleaned_df['Track URI'].str.replace('spotify:track:', '')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment