import requests
import json
import pandas as pd
newdata = []
data = pd.read_csv(r'C:\Users\薛明昊\Desktop\ancient_data.csv',sep=';')
data = data.T.to_dict().values()
#print(data)
for item in data :
#print(item)
band = item['artist']
original_track = item['track']
#print(band)
headers = {
'Accept': 'application/json',
'Content-Type': 'application/json',
'Authorization': 'Bearer BQD0ZSG-uhSXzb1jjRHZsFCNNqtr8rEk-1wAWllo6XikKGk0a6ePlzZzBd5X-2jIi84HiSZOa6I2T56THmKKIQq7-LEUkPDc4A8NjmBgOuve5jdWsBJI3WYt8gIK1JbczVe4THCdLuAp',
}
params = (('q', band +' '
+ original_track),
('type', 'track'),)
response = requests.get('https://api.spotify.com/v1/search', headers=headers, params=params)
#print(response)
json_data = json.loads(response.text)
#print(json.dumps(json_data, sort_keys=True, indent=3)) # A beautified print of the returndata
#print(json_data)
print(json.dumps(json_data['tracks']['items'][0]['id'], sort_keys=True, indent=3))
#for track_id in json_data['tracks']:
#print(tracks)
#new = (track_id['tracks']['album'])
#print(new)
第七行报错Traceback (most recent call last)
错误没说全吧,下面是不是还有,你截个图
路径错误,检查一下路径
去掉前面的r,改成
C:/Users/薛明昊/Desktop/ancient_data.csv