create a new column by adding two or more column

[anandprakashnm]

I have data in following format:-

Student_id  maths_marks English_Marks French_Marks

12                     50                  80                100

13                     80                  90                  95

ad so on...

I want to create a new column "total" = maths_marks + English_Marks + French_Marks for each students.

So new look will be:-

Student_id  maths_marks English_Marks French_Marks  Total

12                     50                  80                100                  230

13                     80                  90                  95                  265

and so on.

[pawel1 · Accepted solution]

New Column

total = score[maths]+score[english]+score[french]