按年份查找第一次出现的值 [英] Finding first occurrence of value by year

问题描述

我有一个包含几个监测点降水数据的数据集:

I have a dataset with precipitation data in few monitoring sites:

structure(list(date = structure(1:10, .Label = c("2010-01-01", 
"2010-01-02", "2010-01-03", "2010-01-04", "2010-01-05", "2010-01-06", 
"2010-01-07", "2010-01-08", "2011-01-01", "2011-01-02"), class = "factor"), 
    site1 = c(0, 0, 0, 0, 0, 0, 0, 0, 0, 0), site2 = c(0.7, 0, 
    1.4, 0, 0, 0, 2.2, 0, 0, 2.2), site3 = c(0, 0, 0, 0, 0, 1.3, 
    0.6, 0, 1.3, 0.6), site4 = c(0L, 0L, 0L, 0L, 0L, 0L, 2L, 
    0L, 0L, 2L), site5 = c(0, 0, 0, 0, 0, 0, 0, 0, 0, 0), site6 = c(0, 
    0, 0, 0, 0, 0, 0, 0, 0, 0), site7 = c(0, 0, 0, 1, 0, 4, 3, 
    1, 4, 3), site8 = c(0, 0, 0, 0, 0, 0, 0, 0, 0, 0)), .Names = c("date", 
"site1", "site2", "site3", "site4", "site5", "site6", "site7", 
"site8"), class = "data.frame", row.names = c(NA, -10L))

我需要在每个站点中找到每年第一次出现大于 0 的任何值.我不知道该怎么做.结果应该是这样的[数据框很好]:

I need to find first occurrence of any value higher than 0 in every year at every sites. I have no idea how to do it. Result should look like this [data frame is good]:

year    site1  site2  site3  site4  site5  site6  site7  site8
2001    01-02  01-02  01-02  01-02  01-01  02-02  01-01  01-02 
2002    01-03  01-02  02-02  01-02  01-02  01-03  01-02  04-02 
2003    01-02  01-05  01-02  01-02  05-02  01-02  01-07  01-02 
2004    05-02  01-02  01-02  07-02  01-02  05-02  01-02  01-06 

如何在 R 中做到这一点?

How to do that in R?

谢谢，J.

推荐答案

这个怎么样?

mydata <- read.table(text="date site1 site2 site3 site4 site5 site6 site7 site8
2010-01-01 0.0 0.7 0.0 0 0.0 0.0 0.0 0.0
2010-01-02 0.0 0.0 0.0 0 0.0 0.0 0.0 0.0
2010-01-03 0.0 1.4 0.0 0 0.0 0.0 0.0 0.0
2010-01-04 0.0 0.0 0.0 0 0.0 0.0 1.0 0.0
2010-01-05 0.0 0.0 0.0 0 0.0 0.0 0.0 0.0
2010-01-06 0.0 0.0 1.3 0 0.0 0.0 4.0 0.0
2010-01-07 0.0 2.2 0.6 2 0.0 0.0 3.0 0.0
2010-01-08 0.0 0.0 0.0 0 0.0 0.0 1.0 0.0
2011-01-01 0.0 0.0 1.3 0 0.0 0.0 4.0 0.0
2011-01-02 0.0 2.2 0.6 2 0.0 0.0 3.0 0.0",h=T)

year <- format(as.Date(mydata$date),"%Y")
rownames(mydata) <- mydata[,1]
my.first <- function(x) head(names(x)[x],1)
do.call("rbind",(by(mydata[,-1]>0,year, function(x) apply(x,2,my.first))))

应该输出哪个(假设行按日期排序):

Which should output (assuming rows are ordered by date):

     site1       site2        site3        site4        site5       site6       site7        site8      
2010 Character,0 "2010-01-01" "2010-01-06" "2010-01-07" Character,0 Character,0 "2010-01-04" Character,0
2011 Character,0 "2011-01-02" "2011-01-01" "2011-01-02" Character,0 Character,0 "2011-01-01" Character,0

这篇关于按年份查找第一次出现的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！