df.columns = df.columns.str.replace('^([^_]+)$', '\\1_team').str.split('_',
    expand=True)
df1 = df.stack(level=0).groupby('team').tail(1)
Search for the last occurence in multiple columns in a dataframe