แสดงชื่อคู่ชายและหญิงในงานแต่งงานทั้งหมดหลังปี 2557
Show the pair of male and female names in all weddings after year 2014
wedding = pd.DataFrame(columns=['male_id', 'female_id', 'year']); people = pd.DataFrame(columns=['name', 'people_id'])
pd.merge(pd.merge(wedding[wedding['year'] > 2014], people, left_on='male_id', right_on='people_id'), people, left_on='female_id', right_on='people_id', suffixes=(' male', ' female'))[['name male', 'name female']]