It's gonna be easy!
Let's assume the DataFrame you show above is called "metadata_df". Do the following:
# Reduce the columns to only those that matter for metadata push
metadata_df = metadata_df[['ID', 'Type_x', 'Name', 'Description', 'Build Path']]
# Rename the columns to the correct names for pushing
metadata_df = metadata_df.rename(columns={'Type_x': 'Type', 'Build Path': 'Path'})
# Filter out the asset rows, we don't need them
metadata_df = metadata_df[metadata_df['Type'] != 'Asset']
# Mark everything as a "Reference" so that SPy builds "jump tags" for them
metadata_df['Reference'] = True
# https://www.youtube.com/watch?v=dPfTiX2i4Vk
spy.push(metadata=metadata_df)