Skip to content

Instantly share code, notes, and snippets.

@MartinWeiss12
Last active December 18, 2022 00:37
Show Gist options
  • Save MartinWeiss12/2c2b27815137516836da1ff63954beb8 to your computer and use it in GitHub Desktop.
Save MartinWeiss12/2c2b27815137516836da1ff63954beb8 to your computer and use it in GitHub Desktop.
ETL
path = r'' #path of your spotify top tracks excel file
outputPath = '' #path where to output your spotify grid
imageFolderPath = '' #path for the folder that will store album cover images
data = pd.read_excel(path)
rankList = (data['Rank']).tolist()
trackList = (data['Track']).tolist()
streamList = (data['Streams']).tolist()
trackUriList = (data['URI']).tolist()
albumUriList = []
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment