Hi, 


I have 6 columns in my dataframe (test)

A B C D E F
a b c d 40 30
a f a b 20 10
x m y m 50 30

If character value in column A matches with that in column C, it gets the percentage in column E, similarly if value in column B matches the value in D, it gets the percentage in F column. If it doesn't match, it gets 0 percentage.


How can I do that ?

thanks

	[[alternative HTML version deleted]]

