df1.merge(df2,left_on='name1', right_on='name2').merge(df3,left_on='name1', right_on='name3')
.drop(columns=['name2', 'name3']).rename(columns={'name1':'name'})
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter