ในฤดูกาลใดและสนามใดที่ผู้เล่นคนใดได้รับบาดเจ็บจาก 'อาการบาดเจ็บที่เท้า' หรือ 'ปัญหาเข่า'?
In which season and which stadium did any player have an injury of 'Foot injury' or 'Knee problem'?
df1 = pd.DataFrame(columns=['name', 'id']); df2 = pd.DataFrame(columns=['game_id', 'injury']); df3 = pd.DataFrame(columns=['season', 'stadium_id', 'id'])
df3[df3['id'].isin(df2[(df2['injury'] == 'Foot injury') | (df2['injury'] == 'Knee problem')]['game_id'])][['season', 'stadium_id']].merge(df1, left_on='stadium_id', right_on='id')[['season', 'name']]