ภาพยนตร์ล่าสุดจะได้ดาวและปีสูงสุดคือเท่าใด
What is the maximum stars and year for the most recent movie?
df_rating = pd.DataFrame(columns=['stars', 'mID']); df_movie = pd.DataFrame(columns=['year', 'mID'])
df_rating[df_rating['mID'].isin(df_movie[df_movie['year'] == df_movie['year'].max()]['mID'])]['stars'].max(), df_movie[df_movie['year'] == df_movie['year'].max()]['YEAR']