jeudi 4 novembre 2021

Only multiple if contrains a certain name [duplicate]

I only want to multiple if the column 'Do it?'' contains the word yes in a new column, since I need to sum everything in the end.

data = {'Do it?': ['yes', 'no', 'no', 'no','yes'],'Price': [12,15,10,2,1]}

df = pd.DataFrame(data)

Output:

    Do it?  Price
0   yes     12
1   no      15
2   no      10
3   no      2
4   yes     1

What I've tried

if df['Do it?'] == 'yes':
  df['Result'] = df['Price'] * 10
print(df['Result'].sum())
 
Error : The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().

Aucun commentaire:

Enregistrer un commentaire