Spotify API从自己的Spotify数据获取TRACK_URI或TRACK_ID

Question

[在此处输入图像描述] [1]我有一个数据框架，其中包括我自己从Spotify（https://www.spotify.com/de/account/privacy/）请求的数据，我有.json数据，我已经转换为.csv，那是我的流史（包括MSPlay，时间戳，艺术家，脚部名称）。我想将TRACK_ID或URI添加到数据框架中。这对于曲目名称和ArtistName与Spotify API的匹配有可能吗？因为API现在对我来说很复杂。

现在，我想添加一个带有URI/TRACK_ID的新列，然后获得歌曲的音频功能。正如我已经说过的那样，我不知道是否有可能以这种方式获得URI。 [1]： https://i.sstatic.net/s2ugh.png

CLIENT_ID = '' 
CLIENT_SECRET = ''

client_credentials_manager = SpotifyClientCredentials(client_id=cid, client_secret=secret) 
sp = spotipy.Spotify(client_credentials_manager=client_credentials_manager)

AUTH_URL ="https://accounts.spotify.com/api/token"
auth_response = requests.post(AUTH_URL, {
    'grant_type': 'client_credentials',
    'client_id': CLIENT_ID,
    'client_secret': CLIENT_SECRET,
})

#Convert response to JSON
auth_response_data = auth_response.json()

#Save the access token
access_token = auth_response_data['access_token']

#Need to pass access token into header to send properly formed GET request to API server
headers = {
    'Authorization': 'Bearer {token}'.format(token=access_token)
}
sp=spotipy.Spotify(auth_manager=SpotifyClientCredentials(client_id="CLIENT_ID",client_secret="CLIENT_SECRET"))

BASE_URL = 'https://api.spotify.com/v1/'




df.to_csv(StreamingHistoryEditedComplete.csv)

new_df['songArtistID'] = new_df['artistName'] + ":" + new_df['trackName']