samedi 9 juin 2018

ifelse Statement in R Not Working - Incorrect Column Result

I have a df:

Year | Stage | Home.Team.Name | Home.Team.Goals | Away.Team.Name | Away.Team.Goals

1998 | Group A| Brazil..................| 2............................ | Scotland............... | 1

and so on.

What I'm trying to do is create a new column based off the result of each game. So the winners name appears in a new column. The code I currently have is:

RecentWorldCups$Game.Winner <- ifelse(RecentWorldCups$Home.Team.Goals>RecentWorldCups$Away.Team.Goals, RecentWorldCups$Home.Team.Name,
                                      ifelse(RecentWorldCups$Away.Team.Goals>RecentWorldCups$Home.Team.Goals, RecentWorldCups$Away.Team.Name,
                                             "Draw"))

The result of this is that it gives me a number (perhaps a factor number?) instead of the name of the team.

Anyone able to help? Cheers

Aucun commentaire:

Enregistrer un commentaire