[R] add identifier column by row

arun smartpink111 at yahoo.com
Tue May 21 22:37:10 CEST 2013


May be this helps:

dat<- read.table(text="
ID      Var
1          1
2          4
3        6
4        7
5          7
6          8
7       9     
",sep="",header=TRUE)
 dat$Date<-cumsum(seq_len(nrow(dat))%%2)
 dat
#  ID Var Date
#1  1   1    1
#2  2   4    1
#3  3   6    2
#4  4   7    2
#5  5   7    3
#6  6   8    3
#7  7   9    4
A.K.


----- Original Message -----
From: Ye Lin <yelin at lbl.gov>
To: R help <r-help at r-project.org>
Cc: 
Sent: Tuesday, May 21, 2013 4:16 PM
Subject: [R] add identifier column by row

I want to add identifier column (Date) to a time series data frame. I want
to name the "Date" column be from 1 to 30 every 1440 rows.

Say I have a data like this (I simply my actual data here):

$dat

ID       Var
1          1
2          4
3         6
4         7
5          7
6          8

How can I add identifier column (Date) from 1 to 3 every 2 rows and have
output like this:

ID       Var  Date
1          1      1
2          4     1
3         6      2
4         7      2
5          7     3
6          8      3

Thanks,

    [[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.




More information about the R-help mailing list