使用spotify API中的pandas构建去规格化数据帧的最佳方法

import pandas as pd
import spotipy
from spotipy.oauth2 import SpotifyClientCredentials

client_id = 'YOUR_CLIENT_ID'
client_secret = 'YOUR_CLIENT_SECRET'
client_credentials_manager = SpotifyClientCredentials(client_id=client_id, client_secret=client_secret)
sp = spotipy.Spotify(client_credentials_manager=client_credentials_manager)

results = sp.search(q='YOUR_SEARCH_QUERY', type='YOUR_SEARCH_TYPE', limit=50)

data = []
for item in results['YOUR_SEARCH_TYPE+'s']['items']:
    data.append(item)
df = pd.DataFrame(data)

df_normalized = pd.json_normalize(df['YOUR_COLUMN_NAME'])