Pandas - Populate an empty column

Asked Jul 03 '20 at 22:21

Active Jul 03 '20 at 22:24

Viewed 12 times

I am trying to iterate through some dataframe values, and populate an empty column as I do it, like so:

df_team_matches['Result'] = ""
results = []

for row in df_team_matches.itertuples():
    goals = row.Goals
    conceded = row.GoalsConceded
    if goals > conceded:
        result = 'win'
        results.append(result)
    elif goals < conceded:
        result = 'defeat'
        results.append(result)
    elif goals == conceded:
        result = 'draw'
        results.append(result)
    
df_team_matches['Result'] = results

The above works, but it seems to my a bit cumbersome.

Is there a cleaner, faster way of achieving the same result using some pandas method?

edited Jul 03 '20 at 22:24

asked Jul 03 '20 at 22:21

8-Bit Borges

9,643
29
101
198

1

AH, scratch that, you probably want ["conditional column creation"](https://stackoverflow.com/questions/19913659/pandas-conditional-creation-of-a-series-dataframe-column/19913845) – cs95 Jul 03 '20 at 22:23
sorry, I meant populate an empty column, have edited the question. – 8-Bit Borges Jul 03 '20 at 22:23
Check my edited comment please? – cs95 Jul 03 '20 at 22:24
did it. thank you! – 8-Bit Borges Jul 03 '20 at 22:26

Pandas - Populate an empty column

0 Answers0