[R] Reassign values based on multiple conditions

[John Kane]

I don't see how the data in the three column table you present is enough to produce the four column test.  Should the first table actually show repeated collar usage so that you can use the next incidence of the collar as the end date e.g
1 01/01/2013 
1 02/04/2013 

and so on?

Some actual data might be useful.  
 The easiest way to supply data  is to use the dput() function.  Example with your file named "testfile": 
dput(testfile) 
Then copy the output and paste into your email.  For large data sets, you can just supply a representative sample.  Usually,  dput(head(testfile, 100)) will be sufficient.  

Sorry I'm not more helpful


John Kane
Kingston ON Canada


> -----Original Message-----
> From: cat.e.cowie at gmail.com
> Sent: Fri, 15 Mar 2013 12:46:13 +0800
> To: r-help at r-project.org
> Subject: [R] Reassign values based on multiple conditions
> 
> Hi all,
> 
> I have a simple data frame of three columns - one of numbers (really a
> categorical variable), one of dates and one of data.
> 
> Imagine:
> 
> collar date data
> 1 01/01/2013 x
> 2 02/01/2013 y
> 3 04/01/2013 z
> 4 04/01/2013 a
> 5 07/01/2013 b
> 
> 
> The 'collar' is a GPS collar that's been worn by an animal for a certain
> amount of time, and then may have been worn by a different animal after
> changes when the batteries needed to be changed. When an animal was
> caught
> and the collar battery needed to be changed, a whole new collar had to be
> put on, as these animals (wild boar and red deer!) were not that easy to
> catch. In order to follow the movements of each animal I now need to
> create
> a new column that assigns the 'data' by animal rather than by collar. I
> have a table of dates, e.g....
> 
> animal collar   start_date    end_date
>      1              1  01/01/2013   03/01/2013
>      1              5  04/01/2013   06/01/2013
>      1              3  07/01/2013   09/01/2013
>      2              2  01/01/2013   03/01/2013
>      2              1  04/01/2013   06/01/2013
> 
> I have so far been able to make multi-conditional tests:
> 
> animal1test<- (date>=01/01/13 && date<=03/01/13)
> animal1test2<- (date>=04/01/13 && date<=06/01/13)
> animal2test<- (date>=04/01/13 && date<=06/01/13)
> 
> to use in an 'if else' formula:
> 
>  if(animal1test){
>   collar[1]="animal1"
>   } else if(animal1test2){
>     collar[5]="animal1"
>   }else if(animal2test)
>     collar[1]="animal2"
>     }else "NA"
> 
> As I'm sure you can see, this is completely inelegant, and also not
> working
> for me! Any ideas on how to a achieve this?
> 
> Thanks SO much in advance,
> Cat
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.

____________________________________________________________
GET FREE SMILEYS FOR YOUR IM & EMAIL - Learn more at http://www.inbox.com/smileys
Works with AIM®, MSN® Messenger, Yahoo!® Messenger, ICQ®, Google Talk™ and most webmails