df1 = df.stack(level=0).groupby('team').tail(1)
df2 = df.stack(level=0).join(df1.score, rsuffix='_last').unstack(level=1)
df2.columns = [(x + '_' + y) for x, y in df2.columns]
df2
Search for the last occurence in multiple columns in a dataframe