How to fill a new column using some specific conditions

Question

Table Details with new column position

I have this table in which contain two columns (1st = names, 2nd =Positions*). I want add a 3rd column titled"GeneName" which should have the values according to $position column. As if the position value falls in any of the undermentioned class related GeneName should be written in the new column. 3 names to be filled in the new column are NIb, VPg and CI. Conditions are

NIb = from position 1014 to 2410
VPg = 3660 to 5563 and 
CI  = 5718 to 6282

Please see the image attached for better understanding.

I cannot understand your table. What do you mean with level values according to the position column? — Enrique, Oct 19 '16 at 10:15
CI, Nib and VPg are the values to be entered in the new column according the numeric values of position colum. Please see the image attached. — Stat Bio, Oct 19 '16 at 10:22
Are there positions that don't fall in any of the three classes? — Sven Hohenstein, Oct 22 '16 at 12:57
yes. There were but if-else statement worked just fine. I excluded those values which didn't fell in any category. — Stat Bio, Nov 08 '16 at 10:52

Stat Bio · Answer 1 · 2016-10-20T09:03:02.643

0

I did this using ifelse statement multiple times.

fg$GeneName<-ifelse(fg$position_by_miRanda>=1014 & fg$position_by_miRanda<=2410,"NIb",fg$GeneName)

fg$GeneName<-ifelse(fg$position_by_miRanda>=3660 & fg$position_by_miRanda<=5563,"CI",fg$GeneName)

fg$GeneName<-ifelse(fg$position_by_miRanda>=5718 & fg$position_by_miRanda<=6282,"VPg",fg$GeneName)

edited Oct 20 '16 at 09:03

answered Oct 20 '16 at 06:54

Stat Bio

1
1
2

1

You don't need to assign every condition separately. You can do a [nested ifelse](http://stackoverflow.com/questions/18012222/nested-ifelse-statement-in-r) – Sotos Oct 20 '16 at 09:08

How to fill a new column using some specific conditions

1 Answers1