บทความที่จัดพิมพ์โดย "เจเรมี กิบบอนส์" มีชื่อว่าอะไร?
What are the titles of papers published by "Jeremy Gibbons"?
authorship = pd.DataFrame(columns=['authid', 'paperid']); papers = pd.DataFrame(columns=['title', 'paperid']); authors = pd.DataFrame(columns=['authid', 'fname', 'lname'])
papers.loc[papers['paperid'].isin(authorship.loc[authors[(authors['fname'] == 'Jeremy') & (authors['lname'] == 'Gibbons')]['authid'], 'paperid']), 'title']