Hi All

I have a column/variable called time difference.  It has a whole list of
numbers from 0 through to the hundreds eg 236.  I want to assign a
corresponding "name" to each variable from a predefined list: Month or
less, 1 -2 months, 2-3 months etc

So the result would look something like:

Time Difference               Month

1                                              Month or less

365                                         1-2 years

52                                           2-3 months

Etc

 

I have tried using if elseif (as shown below), but it kept coming up
with the error:

Error:

In if (curvedata$Date.difference == "NULL") { :

  the condition has length > 1 and only the first element will be used

2: In if (curvedata$Date.difference <= 29) { :

  the condition has length > 1 and only the first element will be used

3: In if (curvedata$Date.difference <= 59) { :

  the condition has length > 1 and only the first element will be used

 

If Else Statement:

month <-if (curvedata$Date.difference =="NULL") {Month <-0}  ifelse

(curvedata$Date.difference <=29) {Month <-"month or less"} else if

(curvedata$Date.difference <=59) {Month <-"1-2 months"} else if

(curvedata$Date.difference <=89) {Month <-"2-3 months"} else if

(curvedata$Date.difference <=119) {Month <-"3-4 months"} else if

(curvedata$Date.difference <=149) {Month <-"4-5 months"} else if

(curvedata$Date.difference <=179) {Month <-"5-6 months"} else if

(curvedata$Date.difference <=209) {Month <-"6-7 months"} else if

(curvedata$Date.difference <=239) {Month <-"7-8 months"} else if

(curvedata$Date.difference <=269) {Month <-"8-9 months"} else if

(curvedata$Date.difference <=299) {Month <-"9-10 months"} else if

(curvedata$Date.difference <=329) {Month <-"10-11 months"} else if

(curvedata$Date.difference <=359) {Month <-"11-12 months"} else if

(curvedata$Date.difference <=719) {Month <-"1-2 years"} else 

{Month <-"More than 2 years"}

 

I'm pretty new to R, so any help would be appreciated.

Thanks

Jessica

_________________________________

Jessica Cathro | Business Analyst | Executive Education 
London Business School | Regent's Park | London NW1 4SA | United Kingdom
Switchboard +44 (0)20 7000 7000| Direct line +44 (0)20 7000 7383 |
Email jcathro@london.edu <mailto:jcathro@london.edu> 

www.london.edu <http://www.london.edu/>  | London experience. World
impact.


______________________________________________________________________

This email has been scanned by the MessageLabs Email Security System
on behalf of the London Business School community.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
	[[alternative HTML version deleted]]

