我试图把所有的曲目从两个播放列表到一个CSV文件。但是,在两个播放列表中,即使我在每次查询中将偏移量参数增加了100,也会返回两个播放列表的前100首歌曲。所以页面从未改变过。有什么问题吗?
import spotipy, json, csv
from spotipy.oauth2 import SpotifyClientCredentials
client_credentials_manager = SpotifyClientCredentials(client_id=client_id, client_secret=client_secret)
sp = spotipy.Spotify(client_credentials_manager=client_credentials_manager)
data_file = open('data.csv', 'w')
writer = csv.writer(data_file)
writer.writerow(['track_num', 'track_id', 'track_name', 'first_artist'] + ['liked'])
playlist_ids = [
'xxxxxxxxxxxxxxxxxxxxxxx', # playlist 1
'yyyyyyyyyyyyyyyyyyyyyyy' # playlist 2
]
for playlist_id in playlist_ids:
offset_n = 0
total = 100
while offset_n < total:
tracks_response = sp.playlist_tracks(playlist_id, offset=offset_n)
tracks_json = json.dumps(tracks_response)
tracks_data = json.loads(tracks_json)
if offset_n == 0:
total = tracks_data['tracks']['total']
for track in tracks_data['tracks']['items']:
track_id = track['track']['id']
track_name = track['track']['name']
first_artist = track['track']['artists'][0]['name']
if playlist_id == playlist_ids[0]:
writer.writerow([row_num, track_id, track_name, first_artist] + [1])
else:
writer.writerow([row_num, track_id, track_name, first_artist] + [0])
offset_n += 100
data_file.close()发布于 2022-06-02 06:37:15
playlist_tracks方法返回分页结果,其中包含播放列表轨道的详细信息。因此,您需要遍历所有页面才能获得完整的数据。
您可以将此示例用作引用:
def get_all_tracks_from_playlist(playlist_id)
tracks_response = sp.playlist_tracks(playlist_id)
tracks = tracks_response["items"]
while tracks_response["next"]:
tracks_response = sp.next(tracks_response)
tracks.extend(tracks_response["items"])
return tracks关于您在注释中提到的ReadTimeout异常:
Spotify客户端接受requests_timeout和retries作为参数,根据文档,默认值是requests_timeout=5,retries=3可以扩展它们,因为您希望减少获得ReadTimeout异常的机会。
首先,您可以将请求超时加倍到10秒,并将重试更改为5:
sp = spotipy.Spotify(client_credentials_manager=client_credentials_manager, requests_timeout=10, retries=5)https://stackoverflow.com/questions/72435998
复制相似问题