SpotipyでAPIを使って、artist_related_artistsを上限の50まで取得して、結果をデータフレームに格納する。

import spotipy
import pandas as pd

spotify = spotipy.Spotify()

def artist_related_artists(artist, limit=50):
    result = spotify.artist_related_artists(artist)
    artists = []
    for item in result['artists']:
        artists.append([artist, item['name']])
    return artists

df = pd.DataFrame(artist_related_artists('Kendrick Lamar'), columns=['artist', 'related_artist'])