|
i have a file like is with a delimiter ","
id,name,type,cp_id,status,price
23,raj,normal,32,success,30
23,raj,normal,32,success,30
23,raj,normal,32,failure,30
24,jey,normal,42,failure,30
24,jey,normal,42,failure,30
24,jey,normal,42,success,30
i want my output to consist of four new columns which are (success,failure,number(total\3*3),number_2(number/price*100)
like dis.
id,name,type,cp_id,success,failure,total,price,number(total\3*3),number_2(number/price*100)
23,raj,normal,32,2,1,3,30,3,30
24,jey,normal,42,1,2,3,30,3,0
anyone can show interest to solve it for me cos i m struck cos i m just able to produce till sucess,failure.
|
