我有一个数据框架,格式如下:
N1 <- c(1,2,4,3,2,3,4,5,4,3,4,5,4,5,6,8,9)
Start <- c("","Start","","","","","","","Start","","","","Start","","","","")
Stop <- c("","","","","Stop","","","","","","Stop","","","","Stop","","")
我的数据感兴趣的是N1。我想根据下面两列中的“开始”和“停止”位置计算一串数字的平均值。
由“开始”和“停止”定义的字符串如下:
2,4,3,2
4,3,4
4,5,6
所以我的最终结果应该是3种意思:
2.75,3.6,5