[R] Arrange values on a timeline
    Ralf B 
    ralf.bierig at gmail.com
       
    Wed Jul 14 07:04:39 CEST 2010
    
    
  
I have a set of labels arranged along a timeframe in a. Each label has
a timestamp and marks a state until the next label. The dataframe a
contains 5 such timestamps and 5 associated labels. This means, on a
continious scale between 1-100, there are 5 markers. E.g. 'abc' marks
the timestampls between 10 and 19, 'def' marks the timestamps between
20 and 32, and so on.
a <- data.frame(timestamp=c(3,5,8), mylabel=c("abc","def","ghi"))
b <- data.frame(timestamp=c(1:10))
I would like to assign these labels as an extra collumn 'label' to the
data.frame b which currently only consists of a the timestamp. The
output would then look like this:
       timestamp      label
1     1                    NA
2     2                    NA
3     3                    "abc"
4     4                    "abc"
5     5                    "def"
6     6                    "def"
7     7                    "def"
8     8                    "ghi"
9     9                    "ghi"
10  10                    "ghi"
What is the simplest way to assign these labels based on timestamps to
get this output. The real dataset is several millions of rows...
Thanks,
Ralf
    
    
More information about the R-help
mailing list