Creating a python dataframe by parsing JSON API response
The only major thing I would change is that: 

if len(item['vendors']) != 0


Is the same as:

if item['vendors']


Because an empty list will return back as False. If you want to try it out: 

a = []
bool(a)      # False
b = [1,2,3]
bool(b)      # True


I would also be careful with what you have because those dictionaries that you are converting might have more than one value, in which case you would miss them. This is the line that I am referring to:

    paths = [item['paths'][0]['path_label'] for item in data]