Hi everybody.

I'm looking for the way to increase the depth value in 0.01 for each index 
group.
Easier to explain with this example:


>my_data=read.table("clipboard", header=TRUE)

Depth   s_name  index
3852    Site_1  144
3852    Site_1  144
3852    Site_1  144
3852    site_A  145
3852    site_A  145
3852    site_A  145
3852    site_A  145
3852    site_B  147
3852    site_B  147
3852    site_B  147
3852    site_B  147
54962   site_C  27
54962   site_C  27
54962   Site_D  217
54962   Site_D  217
54962   Site_D  217
54962   Site_D  217

I'm looking for something like that  (four column)

Depth   s_name  index   Im_looking
3852    Site_1  144     3852.01
3852    Site_1  144     3852.01
3852    Site_1  144     3852.01
3852    site_A  145     3852.02
3852    site_A  145     3852.02
3852    site_A  145     3852.02
3852    site_A  145     3852.02
3852    site_B  147     3852.03
3852    site_B  147     3852.03
3852    site_B  147     3852.03
3852    site_B  147     3852.03
54962   site_C  27      54962.01
54962   site_C  27      54962.01
54962   Site_D  217     54962.02
54962   Site_D  217     54962.02
54962   Site_D  217     54962.02
54962   Site_D  217     54962.02


Currently I found the way to increase the depth but not like I need,

tave = my_data$Depth + (ave(my_data$Depth, my_data$index, FUN=seq_along))/100

Depth   s_name  index   test
3852    Site_1  144     3852.01
3852    Site_1  144     3852.02
3852    Site_1  144     3852.03
3852    site_A  145     3852.01
3852    site_A  145     3852.02
3852    site_A  145     3852.03
3852    site_A  145     3852.04
3852    site_B  147     3852.01
3852    site_B  147     3852.02
3852    site_B  147     3852.03
3852    site_B  147     3852.04
54962   site_C  27      54962.01
54962   site_C  27      54962.02
54962   Site_D  217     54962.01
54962   Site_D  217     54962.02
54962   Site_D  217     54962.03
54962   Site_D  217     54962.04


I'm looking to increase all index group, not just each element.

Thanks in advance,

John Ortiz

______________________________________________
R-help@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.

Reply via email to