แสดงชื่อผู้เล่นและชื่อโค้ชของพวกเขา
Show the names of players and names of their coaches.
df_player = pd.DataFrame(columns=['Player_name', 'Player_ID']); df_coach = pd.DataFrame(columns=['coach_name', 'Coach_ID']); df_player_coach = pd.DataFrame(columns=['Coach_ID', 'Player_ID'])
df_player_coach.merge(df_coach, on='Coach_ID').merge(df_player, on='Player_ID')[['Player_name', 'coach_name']]