How do I create a new column to an existing data frame which is the product of other columns?
Use the below code

df['Fruits_total'] = df[['Apples','Lemon','Banana']].sum(axis=1)


axis = 1, shows that you are summing up the rows. This is what you missed in your code.