Hi,
I have data that is structured like the following:
location team score
away ny 100
home la 80
away chi 95
home det 85
But I would like to transform the pairs of data to be structured like this:
away_team home_team away_score home_score
ny la 100 80
chi det 95 85
Does anyone know how to do this? Thanks!
I have data that is structured like the following:
location team score
away ny 100
home la 80
away chi 95
home det 85
But I would like to transform the pairs of data to be structured like this:
away_team home_team away_score home_score
ny la 100 80
chi det 95 85
Does anyone know how to do this? Thanks!