[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