pavelkomarov / exportify

Export Spotify playlists using the Web API. Analyze them in the Jupyter notebook.
https://exportify.net
MIT License
210 stars 24 forks source link

Why there are two CSV formats? #36

Closed brunobastosg closed 1 year ago

brunobastosg commented 1 year ago

Every week I download the Discover Weekly playlist using Exportify.

Sometimes, the CSV is like this (18 columns):

"Track URI","Track Name","Artist URI(s)","Artist Name(s)","Album URI","Album Name","Album Artist URI(s)","Album Artist Name(s)","Album Release Date","Album Image URL","Disc Number","Track Number","Track Duration (ms)","Track Preview URL","Explicit","Popularity","Added By","Added At"
"spotify:track:6SUAy45EiUMI7YmExYb0Bd","Glueland","spotify:artist:73N7cGNNww6Uod1d3IiBKP","Do Nothing","spotify:album:5hDLsYgo29dLQtDnY03toa","THE EP'S","spotify:artist:73N7cGNNww6Uod1d3IiBKP","Do Nothing","2021-09-24","https://i.scdn.co/image/ab67616d0000b273209d8e1c0cc5c82607a056fc","1","6","162295","","false","3","spotify:user:","2022-08-08T02:00:00Z"

But other times it is like this (23 columns):

Spotify ID,Artist IDs,Track Name,Album Name,Artist Name(s),Release Date,Duration (ms),Popularity,Added By,Added At,Genres,Danceability,Energy,Key,Loudness,Mode,Speechiness,Acousticness,Instrumentalness,Liveness,Valence,Tempo,Time Signature
4CQwIJsYFk80DBWlwsDJGo,"29Wmfm1CojrjQ3aQP0FI65","Alabaster","Sleeping Through The War","All Them Witches",2017-02-24,417533,44,spotify:user:,2022-08-15T02:00:00Z,"blues rock,indie rock,modern blues rock,neo-psychedelic,space rock",0.513,0.887,0,-6.569,0,0.0566,0.135,0.00207,0.0997,0.512,117.481,4

The common columns among both formats are:

Why is that? Is there any way to always download in the same format?

pavelkomarov commented 1 year ago

Are you using my version some times and watsonbox’s at others? Mine shouldn’t have Disc Number. It’s possible one of the data joins is getting skipped? But then the whole query should fail.

brunobastosg commented 1 year ago

Oh, that's probably it. My bad. I didn't know there were two different versions. I always type "exportify" in the address bar and click the first link that appears.

Thank you!