ค้นหาชื่อนักศึกษาที่อาศัยอยู่ในหอพักที่มีสิ่งอำนวยความสะดวกมากที่สุด
Find the first name of students who are living in the dorm that has most number of amenities.
df_dorm_amenity = pd.DataFrame(columns=['amenid']); df_lives_in = pd.DataFrame(columns=['stuid', 'dormid']); df_dorm = pd.DataFrame(columns=['dormid']); df_student = pd.DataFrame(columns=['fname', 'stuid']); df_has_amenity = pd.DataFrame(columns=['dormid', 'amenid'])
df_student[df_student['stuid'].isin(df_lives_in[df_lives_in['dormid'].isin(df_has_amenity[df_has_amenity['amenid'].isin(df_dorm_amenity['amenid'])]['dormid'].value_counts().idxmax())]['stuid'])]['fname']