r - 使用grep在R中提取和平均每月数据？-6ren

r - 使用grep在R中提取和平均每月数据？

转载作者：行者123 更新时间：2023-12-04 05:12:50

事先我不得不说，我真的很抱歉格式不正确!我似乎无法掌握它......
我也是 R 菜鸟。

所以，
我有 80 个文件，其中包含 80 条鱼的运动信息；

> head(PAVdata)
   X  meanlat meanlong meandepth mindepth maxdepth depthrange rec numhits            datetime mon      X.1       Y        Z
1 23 58.39601 8.708952  6.493529     5.72     7.47       1.75   4      17 2012-05-11 11:15:00   1 482986.7 6472838 6.493529
2 24 58.39618 8.710993  4.035588     1.76     7.47       5.71   6      34 2012-05-11 11:45:00   1 483106.1 6472855 4.035588
3 25 58.39615 8.710919  6.037692     3.08     8.35       5.27   6      26 2012-05-11 12:15:00   1 483101.8 6472853 6.037692
4 26 58.39556 8.710654  3.987500     2.20     6.16       3.96   5      16 2012-05-11 12:45:00   1 483086.0 6472787 3.987500
5 27 58.39617 8.711363  2.944615     2.20     3.96       1.76   6      26 2012-05-11 13:15:00   1 483127.8 6472855 2.944615
6 28 58.39628 8.710904  2.860000     2.20     3.52       1.32   6      24 2012-05-11 13:45:00   1 483101.0 6472867 2.860000

但感兴趣的列是 日期时间 和 Z ，其中 Z 是深度。

我的目标是；

获取深度的每日和每月平均值

获取每日和每月的最小值和最大值(查看幅度)

到目前为止我尝试过的是；

june<-c(PAVdata$datetime[grep("^2012-07",as.character(PAVdata$datetime))])

这产生了对我来说完全牵强的东西

head(june) [1] 2390 2391 2392 2393 2394 2395

我正在阅读子集和聚合和 POSIXlt 和点击和 动物园并想尝试这些，但我似乎得到了长度差异的错误..

这是 POSIXlt 的尝试；

PAVdata$datetime <- strftime(as.POSIXlt(PAVdata$datetime,format="%Y-%m-%d %H:%M:%S"),format='%b')

june_Monthly_Avg <- ave(PAVdata$Z,PAVdata$datetime,FUN=mean)

head(june_Monthly_Avg) [1] 9.341862 9.341862 9.341862 9.341862 9.341862 9.341862

整个事情由相同的数字组成......
认为我最清楚地使用突击队非常错误。

但后来我尝试了一些更简单的方法；

juni_Monthly_Avg <- ave(PAVdata$Z,PAVdata$datetime,FUN=mean)

head(juni_Monthly_Avg)

[1] 6.493529 4.035588 6.037692 3.987500 2.944615 2.860000

让我困惑的是，看到 6 月份我应该只得到一个值。
到目前为止我估计 grep 看起来最有希望，但我似乎无法理解它。
一直在搜索 R 书和互联网，当然还有几天，我决定在我拔掉所有头发之前(以及在咨询我的主管之前)大声呼救。

谢谢^_^

> dput(head(PAVdata))
structure(list(X = 23:28, meanlat = c(58.3960117647059, 58.3961761764706, 
58.3961507692308, 58.395558125, 58.3961726923077, 58.3962804166667
), meanlong = c(8.70895176470588, 8.71099294117647, 8.71091923076923, 
8.71065375, 8.71136346153846, 8.71090416666667), meandepth = c(6.49352941176471, 
4.03558823529412, 6.03769230769231, 3.9875, 2.94461538461538, 
2.86), mindepth = c(5.72, 1.76, 3.08, 2.2, 2.2, 2.2), maxdepth = c(7.47, 
7.47, 8.35, 6.16, 3.96, 3.52), depthrange = c(1.75, 5.71, 5.27, 
3.96, 1.76, 1.32), rec = c(4L, 6L, 6L, 5L, 6L, 6L), numhits = c(17L, 
34L, 26L, 16L, 26L, 24L), datetime = structure(1:6, .Label = c("2012-06-01 00:15:00", "2012-06-01 00:45:00", 
"2012-06-01 01:15:00", "2012-06-01 01:45:00", "2012-06-01 02:15:00", 
"2012-06-01 02:45:00", "2012-06-01 03:15:00", "2012-06-01 03:45:00", 
"2012-06-01 04:15:00", "2012-06-01 04:45:00", "2012-06-01 05:45:00", 
"2012-06-01 06:15:00", "2012-06-01 06:45:00", "2012-06-01 07:15:00", 
"2012-06-01 07:45:00", "2012-06-01 08:15:00", "2012-06-01 08:45:00", 
"2012-06-01 09:45:00", "2012-06-01 10:15:00", "2012-06-01 10:45:00", 
"2012-06-01 11:15:00", "2012-06-01 11:45:00", "2012-06-01 12:15:00", 
"2012-06-01 12:45:00", "2012-06-01 13:15:00", "2012-06-01 13:45:00", 
"2012-06-01 14:45:00", "2012-06-01 15:15:00", "2012-06-01 15:45:00", 
"2012-06-01 16:15:00", "2012-06-01 16:45:00", "2012-06-01 17:45:00", 
"2012-06-01 18:15:00", "2012-06-01 18:45:00", "2012-06-01 19:15:00", 
"2012-06-01 19:45:00", "2012-06-01 20:15:00", "2012-06-01 20:45:00", 
"2012-06-01 21:15:00", "2012-06-01 22:15:00", "2012-06-01 22:45:00", 
"2012-06-01 23:15:00", "2012-06-01 23:45:00", "2012-06-02 00:15:00", 
"2012-06-02 00:45:00", "2012-06-02 01:15:00", "2012-06-02 01:45:00", 
"2012-06-02 02:15:00", "2012-06-02 02:45:00", "2012-06-02 03:15:00", 
"2012-06-02 03:45:00", "2012-06-02 04:15:00", "2012-06-02 04:45:00", 
"2012-06-02 05:15:00", "2012-06-02 05:45:00", "2012-06-02 06:15:00", 
"2012-06-02 06:45:00", "2012-06-02 07:15:00", "2012-06-02 07:45:00", 
"2012-06-02 08:15:00", "2012-06-02 08:45:00", "2012-06-02 09:15:00", 
"2012-06-02 09:45:00", "2012-06-02 10:15:00", "2012-06-02 10:45:00", 
"2012-06-02 11:15:00", "2012-06-02 11:45:00", "2012-06-02 12:15:00", 
"2012-06-02 13:15:00", "2012-06-02 13:45:00", "2012-06-02 14:15:00", 
"2012-06-02 14:45:00", "2012-06-02 15:15:00", "2012-06-02 15:45:00", 
"2012-06-02 16:15:00", "2012-06-02 16:45:00", "2012-06-02 17:15:00", 
"2012-06-02 18:15:00", "2012-06-02 19:15:00", "2012-06-02 19:45:00", 
"2012-06-02 20:15:00", "2012-06-02 20:45:00", "2012-06-02 21:15:00", 
"2012-06-02 21:45:00", "2012-06-02 22:15:00", "2012-06-02 22:45:00", 
"2012-06-02 23:15:00", "2012-06-02 23:45:00", "2012-06-03 00:15:00", 
"2012-06-03 00:45:00", "2012-06-03 01:15:00", "2012-06-03 01:45:00", 
"2012-06-03 02:15:00", "2012-06-03 02:45:00", "2012-06-03 03:15:00", 
"2012-06-03 03:45:00", "2012-06-03 04:15:00", "2012-06-03 04:45:00", 
"2012-06-03 05:15:00", "2012-06-03 05:45:00", "2012-06-03 06:15:00", 
"2012-06-03 06:45:00", "2012-06-03 07:15:00", "2012-06-03 07:45:00", 
"2012-06-03 08:15:00", "2012-06-03 08:45:00", "2012-06-03 09:15:00", 
"2012-06-03 09:45:00", "2012-06-03 10:15:00", "2012-06-03 10:45:00", 
"2012-06-03 11:15:00", "2012-06-03 11:45:00", "2012-06-03 12:15:00", 
"2012-06-03 12:45:00", "2012-06-03 13:15:00", "2012-06-03 13:45:00", 
"2012-06-03 14:15:00", "2012-06-03 15:45:00", "2012-06-03 16:15:00", 
"2012-06-03 16:45:00", "2012-06-03 17:15:00", "2012-06-03 17:45:00", 
"2012-06-03 18:15:00", "2012-06-03 18:45:00", "2012-06-03 19:15:00", 
"2012-06-03 19:45:00", "2012-06-03 20:15:00", "2012-06-03 20:45:00", 
"2012-06-03 21:15:00", "2012-06-03 21:45:00", "2012-06-03 22:15:00", 
"2012-06-03 22:45:00", "2012-06-03 23:15:00", "2012-06-03 23:45:00", 
"2012-06-04 00:15:00", "2012-06-04 00:45:00", "2012-06-04 01:15:00", 
"2012-06-04 01:45:00", "2012-06-04 02:15:00", "2012-06-04 02:45:00", 
"2012-06-04 03:15:00", "2012-06-04 03:45:00", "2012-06-04 04:45:00", 
"2012-06-04 05:15:00", "2012-06-04 05:45:00", "2012-06-04 06:15:00", 
"2012-06-04 06:45:00", "2012-06-04 07:15:00", "2012-06-04 07:45:00", 
"2012-06-04 08:15:00", "2012-06-04 08:45:00", "2012-06-04 09:15:00", 
"2012-06-04 09:45:00", "2012-06-04 10:15:00", "2012-06-04 10:45:00", 
"2012-06-04 11:15:00", "2012-06-04 11:45:00", "2012-06-04 12:15:00", 
"2012-06-04 12:45:00", "2012-06-04 13:15:00", "2012-06-04 13:45:00", 
"2012-06-04 14:15:00", "2012-06-04 14:45:00", "2012-06-04 15:15:00", 
"2012-06-04 15:45:00", "2012-06-04 16:15:00", "2012-06-04 16:45:00", 
"2012-06-04 17:15:00", "2012-06-04 17:45:00", "2012-06-04 18:15:00", 
"2012-06-04 18:45:00", "2012-06-04 19:15:00", "2012-06-04 19:45:00", 
"2012-06-04 20:15:00", "2012-06-04 20:45:00", "2012-06-04 21:15:00", 
"2012-06-04 21:45:00", "2012-06-04 22:15:00", "2012-06-04 22:45:00", 
"2012-06-04 23:15:00", "2012-06-04 23:45:00", "2012-06-05 00:15:00", 
"2012-06-05 00:45:00", "2012-06-05 01:15:00", "2012-06-05 01:45:00", 
"2012-06-05 02:15:00", "2012-06-05 02:45:00", "2012-06-05 03:15:00", 
"2012-06-05 03:45:00", "2012-06-05 04:15:00", "2012-06-05 04:45:00", 
"2012-06-05 05:15:00", "2012-06-05 05:45:00", "2012-06-05 06:15:00", 
"2012-06-05 06:45:00", "2012-06-05 07:15:00", "2012-06-05 07:45:00", 
"2012-06-05 08:15:00", "2012-06-05 08:45:00", "2012-06-05 09:15:00", 
"2012-06-05 09:45:00", "2012-06-05 10:15:00", "2012-06-05 10:45:00", 
"2012-06-05 11:15:00", "2012-06-05 11:45:00", "2012-06-05 12:15:00", 
"2012-06-05 12:45:00", "2012-06-05 13:15:00", "2012-06-05 13:45:00", 
"2012-06-05 14:15:00", "2012-06-05 14:45:00", "2012-06-05 15:15:00", 
"2012-06-05 15:45:00", "2012-06-05 16:15:00", "2012-06-05 16:45:00", 
"2012-06-05 17:15:00", "2012-06-05 17:45:00", "2012-06-05 18:15:00", 
"2012-06-05 18:45:00", "2012-06-05 19:15:00", "2012-06-05 19:45:00", 
"2012-06-05 20:15:00", "2012-06-05 20:45:00", "2012-06-05 21:15:00", 
"2012-06-05 21:45:00", "2012-06-05 22:15:00", "2012-06-05 22:45:00", 
"2012-06-05 23:15:00", "2012-06-05 23:45:00", "2012-06-06 00:15:00", 
"2012-06-06 00:45:00", "2012-06-06 01:15:00", "2012-06-06 01:45:00", 
"2012-06-06 02:15:00", "2012-06-06 02:45:00", "2012-06-06 03:15:00", 
"2012-06-06 03:45:00", "2012-06-06 04:15:00", "2012-06-06 04:45:00", 
"2012-06-06 05:15:00", "2012-06-06 05:45:00", "2012-06-06 06:45:00", 
"2012-06-06 07:15:00", "2012-06-06 07:45:00", "2012-06-06 08:15:00", 
"2012-06-06 08:45:00", "2012-06-06 09:45:00", "2012-06-06 10:15:00", 
"2012-06-06 10:45:00", "2012-06-06 11:15:00", "2012-06-06 11:45:00", 
"2012-06-06 12:15:00", "2012-06-06 12:45:00", "2012-06-06 13:15:00", 
"2012-06-06 13:45:00", "2012-06-06 14:15:00", "2012-06-06 14:45:00", 
"2012-06-06 15:15:00", "2012-06-06 15:45:00", "2012-06-06 16:15:00", 
"2012-06-06 16:45:00", "2012-06-06 17:15:00", "2012-06-06 17:45:00", 
"2012-06-06 18:15:00", "2012-06-06 18:45:00", "2012-06-06 19:15:00", 
"2012-06-06 19:45:00", "2012-06-06 20:15:00", "2012-06-06 20:45:00", 
"2012-06-06 21:45:00", "2012-06-06 22:15:00", "2012-06-06 22:45:00", 
"2012-06-06 23:15:00", "2012-06-06 23:45:00", "2012-06-07 00:15:00", 
"2012-06-07 00:45:00", "2012-06-07 01:15:00", "2012-06-07 01:45:00", 
"2012-06-07 02:15:00", "2012-06-07 02:45:00", "2012-06-07 03:15:00", 
"2012-06-07 03:45:00", "2012-06-07 04:15:00", "2012-06-07 04:45:00", 
"2012-06-07 05:15:00", "2012-06-07 05:45:00", "2012-06-07 06:15:00", 
"2012-06-07 06:45:00", "2012-06-07 07:15:00", "2012-06-07 07:45:00", 
"2012-06-07 08:15:00", "2012-06-07 08:45:00", "2012-06-07 09:15:00", 
"2012-06-07 09:45:00", "2012-06-07 10:15:00", "2012-06-07 10:45:00", 
"2012-06-07 11:15:00", "2012-06-07 11:45:00", "2012-06-07 12:15:00", 
"2012-06-07 12:45:00", "2012-06-07 13:15:00", "2012-06-07 13:45:00", 
"2012-06-07 14:15:00", "2012-06-07 14:45:00", "2012-06-07 15:15:00", 
"2012-06-07 15:45:00", "2012-06-07 16:15:00", "2012-06-07 16:45:00", 
"2012-06-07 17:15:00", "2012-06-07 17:45:00", "2012-06-07 18:15:00", 
"2012-06-07 18:45:00", "2012-06-07 19:15:00", "2012-06-07 19:45:00", 
"2012-06-07 20:15:00", "2012-06-07 20:45:00", "2012-06-07 21:15:00", 
"2012-06-07 21:45:00", "2012-06-07 22:15:00", "2012-06-07 22:45:00", 
"2012-06-07 23:15:00", "2012-06-07 23:45:00", "2012-06-08 00:15:00", 
"2012-06-08 00:45:00", "2012-06-08 01:15:00", "2012-06-08 01:45:00", 
"2012-06-08 02:15:00", "2012-06-08 02:45:00", "2012-06-08 03:15:00", 
"2012-06-08 03:45:00", "2012-06-08 04:15:00", "2012-06-08 04:45:00", 
"2012-06-08 05:15:00", "2012-06-08 05:45:00", "2012-06-08 06:15:00", 
"2012-06-08 06:45:00", "2012-06-08 07:15:00", "2012-06-08 07:45:00", 
"2012-06-08 08:15:00", "2012-06-08 08:45:00", "2012-06-08 09:15:00", 
"2012-06-08 09:45:00", "2012-06-08 10:15:00", "2012-06-08 10:45:00", 
"2012-06-08 11:15:00", "2012-06-08 11:45:00", "2012-06-08 12:15:00", 
"2012-06-08 12:45:00", "2012-06-08 13:15:00", "2012-06-08 13:45:00", 
"2012-06-08 14:15:00", "2012-06-08 14:45:00", "2012-06-08 15:15:00", 
"2012-06-08 15:45:00", "2012-06-08 16:15:00", "2012-06-08 16:45:00", 
"2012-06-08 17:15:00", "2012-06-08 17:45:00", "2012-06-08 18:15:00", 
"2012-06-08 18:45:00", "2012-06-08 19:15:00", "2012-06-08 19:45:00", 
"2012-06-08 20:15:00", "2012-06-08 20:45:00", "2012-06-08 21:15:00", 
"2012-06-08 21:45:00", "2012-06-08 22:15:00", "2012-06-08 22:45:00", 
"2012-06-08 23:15:00", "2012-06-08 23:45:00", "2012-06-09 00:15:00", 
"2012-06-09 00:45:00", "2012-06-09 01:15:00", "2012-06-09 01:45:00", 
"2012-06-09 02:15:00", "2012-06-09 02:45:00", "2012-06-09 03:15:00", 
"2012-06-09 03:45:00", "2012-06-09 04:15:00", "2012-06-09 04:45:00", 
"2012-06-09 05:15:00", "2012-06-09 05:45:00", "2012-06-09 06:45:00", 
"2012-06-09 07:15:00", "2012-06-09 07:45:00", "2012-06-09 08:15:00", 
"2012-06-09 08:45:00", "2012-06-09 09:15:00", "2012-06-09 09:45:00", 
"2012-06-09 10:15:00", "2012-06-09 10:45:00", "2012-06-09 11:15:00", 
"2012-06-09 11:45:00", "2012-06-09 12:15:00", "2012-06-09 12:45:00", 
"2012-06-09 13:15:00", "2012-06-09 13:45:00", "2012-06-09 14:15:00", 
"2012-06-09 14:45:00", "2012-06-09 15:15:00", "2012-06-09 15:45:00", 
"2012-06-09 16:15:00", "2012-06-09 16:45:00", "2012-06-09 17:15:00", 
"2012-06-09 17:45:00", "2012-06-09 18:15:00", "2012-06-09 18:45:00", 
"2012-06-09 19:15:00", "2012-06-09 19:45:00", "2012-06-09 20:15:00", 
"2012-06-09 20:45:00", "2012-06-09 21:15:00", "2012-06-09 21:45:00", 
"2012-06-09 22:15:00", "2012-06-09 22:45:00", "2012-06-09 23:15:00", 
"2012-06-09 23:45:00", "2012-06-10 00:15:00", "2012-06-10 00:45:00", 
"2012-06-10 01:15:00", "2012-06-10 01:45:00", "2012-06-10 02:15:00", 
"2012-06-10 02:45:00", "2012-06-10 03:15:00", "2012-06-10 03:45:00", 
"2012-06-10 04:15:00", "2012-06-10 04:45:00", "2012-06-10 05:15:00", 
"2012-06-10 05:45:00", "2012-06-10 06:15:00", "2012-06-10 06:45:00", 
"2012-06-10 07:15:00", "2012-06-10 07:45:00", "2012-06-10 08:15:00", 
"2012-06-10 08:45:00", "2012-06-10 09:15:00", "2012-06-10 09:45:00", 
"2012-06-10 10:15:00", "2012-06-10 10:45:00", "2012-06-10 11:15:00", 
"2012-06-10 11:45:00", "2012-06-10 12:15:00", "2012-06-10 12:45:00", 
"2012-06-10 13:15:00", "2012-06-10 13:45:00", "2012-06-10 14:15:00", 
"2012-06-10 14:45:00", "2012-06-10 15:15:00", "2012-06-10 15:45:00", 
"2012-06-10 16:15:00", "2012-06-10 16:45:00", "2012-06-10 17:15:00", 
"2012-06-10 17:45:00", "2012-06-10 18:15:00", "2012-06-10 18:45:00", 
"2012-06-10 19:15:00", "2012-06-10 19:45:00", "2012-06-10 20:15:00", 
"2012-06-10 20:45:00", "2012-06-10 21:15:00", "2012-06-10 21:45:00", 
"2012-06-10 22:15:00", "2012-06-10 22:45:00", "2012-06-10 23:15:00", 
"2012-06-10 23:45:00", 
"2012-07-01 00:15:00", "2012-07-01 00:45:00", "2012-07-01 01:15:00", 
"2012-07-01 01:45:00", "2012-07-01 02:15:00", "2012-07-01 02:45:00", 
"2012-07-01 03:15:00", "2012-07-01 03:45:00", "2012-07-01 04:15:00", 
"2012-07-01 04:45:00", "2012-07-01 05:15:00", "2012-07-01 05:45:00", 
"2012-07-01 06:15:00", "2012-07-01 06:45:00", "2012-07-01 07:15:00", 
"2012-07-01 07:45:00", "2012-07-01 08:15:00", "2012-07-01 08:45:00", 
"2012-07-01 09:15:00", "2012-07-01 09:45:00", "2012-07-01 10:15:00", 
"2012-07-01 10:45:00", "2012-07-01 11:15:00", "2012-07-01 11:45:00", 
"2012-07-01 12:15:00", "2012-07-01 12:45:00", "2012-07-01 13:15:00", 
"2012-07-01 13:45:00", "2012-07-01 14:15:00", "2012-07-01 14:45:00", 
"2012-07-01 15:15:00", "2012-07-01 15:45:00", "2012-07-01 16:15:00", 
"2012-07-01 16:45:00", "2012-07-01 17:15:00", "2012-07-01 17:45:00", 
"2012-07-01 18:15:00", "2012-07-01 18:45:00", "2012-07-01 19:15:00", 
"2012-07-01 19:45:00", "2012-07-01 20:15:00", "2012-07-01 20:45:00", 
"2012-07-01 21:15:00", "2012-07-01 21:45:00", "2012-07-01 22:15:00", 
"2012-07-01 22:45:00", "2012-07-01 23:15:00", "2012-07-01 23:45:00", 
"2012-07-02 00:15:00", "2012-07-02 00:45:00", "2012-07-02 01:15:00", 
"2012-07-02 01:45:00", "2012-07-02 02:15:00", "2012-07-02 02:45:00", 
"2012-07-02 03:15:00", "2012-07-02 03:45:00", "2012-07-02 04:15:00", 
"2012-07-02 04:45:00", "2012-07-02 05:15:00", "2012-07-02 05:45:00", 
"2012-07-02 06:15:00", "2012-07-02 06:45:00", "2012-07-02 07:15:00", 
"2012-07-02 07:45:00", "2012-07-02 08:15:00", "2012-07-02 08:45:00", 
"2012-07-02 09:15:00", "2012-07-02 09:45:00", "2012-07-02 10:15:00", 
"2012-07-02 10:45:00", "2012-07-02 11:15:00", "2012-07-02 11:45:00", 
"2012-07-02 12:15:00", "2012-07-02 12:45:00", "2012-07-02 13:15:00", 
"2012-07-02 13:45:00", "2012-07-02 14:15:00", "2012-07-02 14:45:00", 
"2012-07-02 15:15:00", "2012-07-02 15:45:00", "2012-07-02 16:15:00", 
"2012-07-02 16:45:00", "2012-07-02 17:15:00", "2012-07-02 17:45:00", 
"2012-07-02 18:15:00", "2012-07-02 18:45:00", "2012-07-02 19:15:00", 
"2012-07-02 19:45:00", "2012-07-02 20:15:00", "2012-07-02 20:45:00", 
"2012-07-02 21:15:00", "2012-07-02 21:45:00", "2012-07-02 22:15:00", 
"2012-07-02 22:45:00", "2012-07-02 23:15:00", "2012-07-02 23:45:00", 
"2012-07-03 00:15:00", "2012-07-03 00:45:00", "2012-07-03 01:15:00", 
"2012-07-03 01:45:00", "2012-07-03 02:15:00", "2012-07-03 02:45:00", 
"2012-07-03 03:15:00", "2012-07-03 03:45:00", "2012-07-03 04:15:00", 
"2012-07-03 04:45:00", "2012-07-03 05:15:00", "2012-07-03 05:45:00", 
"2012-07-03 06:15:00", "2012-07-03 06:45:00", "2012-07-03 07:15:00", 
"2012-07-03 07:45:00", "2012-07-03 08:15:00", "2012-07-03 08:45:00", 
"2012-07-03 09:15:00", "2012-07-03 09:45:00", "2012-07-03 10:15:00", 
"2012-07-03 10:45:00", "2012-07-03 11:15:00", "2012-07-03 11:45:00", 
"2012-07-03 12:15:00", "2012-07-03 12:45:00", "2012-07-03 13:15:00", 
"2012-07-03 13:45:00", "2012-07-03 14:15:00", "2012-07-03 15:15:00", 
"2012-07-03 15:45:00", "2012-07-03 16:15:00", "2012-07-03 16:45:00", 
"2012-07-03 17:15:00", "2012-07-03 17:45:00", "2012-07-03 18:15:00", 
"2012-07-03 18:45:00", "2012-07-03 19:15:00", "2012-07-03 19:45:00", 
"2012-07-03 20:15:00", "2012-07-03 20:45:00", "2012-07-03 21:15:00", 
"2012-07-03 21:45:00", "2012-07-03 22:15:00", "2012-07-03 22:45:00", 
"2012-07-03 23:15:00", "2012-07-03 23:45:00", "2012-07-04 00:15:00", 
"2012-07-04 00:45:00", "2012-07-04 01:15:00", "2012-07-04 01:45:00", 
"2012-07-04 02:15:00", "2012-07-04 02:45:00", "2012-07-04 03:15:00", 
"2012-07-04 03:45:00", "2012-07-04 04:15:00", "2012-07-04 04:45:00", 
"2012-07-04 05:15:00", "2012-07-04 05:45:00", "2012-07-04 06:15:00", 
"2012-07-04 06:45:00", "2012-07-04 07:15:00", "2012-07-04 07:45:00", 
"2012-07-04 08:45:00", "2012-07-04 09:15:00", "2012-07-04 09:45:00", 
"2012-07-04 10:15:00", "2012-07-04 10:45:00", "2012-07-04 11:15:00", 
"2012-07-04 11:45:00", "2012-07-04 12:15:00", "2012-07-04 12:45:00", 
"2012-07-04 13:15:00", "2012-07-04 13:45:00", "2012-07-04 14:15:00", 
"2012-07-04 14:45:00", "2012-07-04 15:15:00", "2012-07-04 15:45:00", 
"2012-07-04 16:15:00", "2012-07-04 16:45:00", "2012-07-04 17:15:00", 
"2012-07-04 17:45:00", "2012-07-04 18:15:00", "2012-07-04 18:45:00", 
"2012-07-04 19:15:00", "2012-07-04 19:45:00", "2012-07-04 20:15:00", 
"2012-07-04 20:45:00", "2012-07-04 21:15:00", "2012-07-04 21:45:00", 
"2012-07-04 22:15:00", "2012-07-04 22:45:00", "2012-07-04 23:15:00", 
"2012-07-04 23:45:00", "2012-07-05 00:15:00", "2012-07-05 00:45:00", 
"2012-07-05 01:15:00", "2012-07-05 01:45:00", "2012-07-05 02:15:00", 
"2012-07-05 02:45:00", "2012-07-05 03:15:00", "2012-07-05 03:45:00", 
"2012-07-05 04:15:00", "2012-07-05 04:45:00", "2012-07-05 05:15:00", 
"2012-07-05 05:45:00", "2012-07-05 06:15:00", "2012-07-05 06:45:00", 
"2012-07-05 07:15:00", "2012-07-05 07:45:00", "2012-07-05 08:15:00", 
"2012-07-05 08:45:00", "2012-07-05 09:15:00", "2012-07-05 09:45:00", 
"2012-07-05 10:15:00", "2012-07-05 10:45:00", "2012-07-05 11:15:00", 
"2012-07-05 11:45:00", "2012-07-05 12:15:00", "2012-07-05 12:45:00", 
"2012-07-05 13:15:00", "2012-07-05 13:45:00", "2012-07-05 14:15:00", 
"2012-07-05 14:45:00", "2012-07-05 15:15:00", "2012-07-05 15:45:00", 
"2012-07-05 16:45:00", "2012-07-05 17:15:00", "2012-07-05 17:45:00", 
"2012-07-05 18:15:00", "2012-07-05 18:45:00", "2012-07-05 19:15:00", 
"2012-07-05 19:45:00", "2012-07-05 20:15:00", "2012-07-05 20:45:00", 
"2012-07-05 21:15:00", "2012-07-05 21:45:00", "2012-07-05 22:15:00", 
"2012-07-05 22:45:00", "2012-07-05 23:15:00", "2012-07-05 23:45:00", 
"2012-07-06 00:15:00", "2012-07-06 00:45:00", "2012-07-06 01:15:00", 
"2012-07-06 01:45:00", "2012-07-06 02:15:00", "2012-07-06 02:45:00", 
"2012-07-06 03:15:00", "2012-07-06 03:45:00", "2012-07-06 04:15:00", 
"2012-07-06 04:45:00", "2012-07-06 05:15:00", "2012-07-06 05:45:00", 
"2012-07-06 06:15:00", "2012-07-06 06:45:00", "2012-07-06 07:15:00", 
"2012-07-06 07:45:00", "2012-07-06 08:15:00", "2012-07-06 08:45:00", 
"2012-07-06 09:15:00", "2012-07-06 09:45:00", "2012-07-06 10:15:00", 
"2012-07-06 10:45:00", "2012-07-06 11:15:00", "2012-07-06 11:45:00", 
"2012-07-06 12:15:00", "2012-07-06 12:45:00", "2012-07-06 13:15:00", 
"2012-07-06 13:45:00", "2012-07-06 14:15:00", "2012-07-06 14:45:00", 
"2012-07-06 15:15:00", "2012-07-06 15:45:00", "2012-07-06 16:15:00", 
"2012-07-06 16:45:00", "2012-07-06 17:15:00", "2012-07-06 17:45:00", 
"2012-07-06 18:15:00", "2012-07-06 18:45:00", "2012-07-06 19:15:00", 
"2012-07-06 19:45:00", "2012-07-06 20:15:00", "2012-07-06 20:45:00", 
"2012-07-06 21:15:00", "2012-07-06 21:45:00", "2012-07-06 22:15:00", 
"2012-07-06 22:45:00", "2012-07-06 23:15:00", "2012-07-06 23:45:00", 
"2012-07-07 00:15:00", "2012-07-07 00:45:00", "2012-07-07 01:15:00", 
"2012-07-07 01:45:00", "2012-07-07 02:15:00", "2012-07-07 02:45:00", 
"2012-07-07 03:15:00", "2012-07-07 03:45:00", "2012-07-07 04:15:00", 
"2012-07-07 04:45:00", "2012-07-07 05:15:00", "2012-07-07 05:45:00", 
"2012-07-07 06:15:00", "2012-07-07 06:45:00", "2012-07-07 07:15:00", 
"2012-07-07 07:45:00", "2012-07-07 08:15:00", "2012-07-07 08:45:00", 
"2012-07-07 09:15:00", "2012-07-07 09:45:00", "2012-07-07 10:15:00", 
"2012-07-07 10:45:00", "2012-07-07 11:45:00", "2012-07-07 12:15:00", 
"2012-07-07 12:45:00", "2012-07-07 13:15:00", "2012-07-07 13:45:00", 
"2012-07-07 14:15:00", "2012-07-07 14:45:00", "2012-07-07 15:15:00", 
"2012-07-07 15:45:00", "2012-07-07 16:15:00", "2012-07-07 16:45:00", 
"2012-07-07 17:15:00", "2012-07-07 17:45:00", "2012-07-07 18:15:00", 
"2012-07-07 18:45:00", "2012-07-07 19:15:00", "2012-07-07 19:45:00", 
"2012-07-07 20:15:00", "2012-07-07 20:45:00", "2012-07-07 21:15:00", 
"2012-07-07 21:45:00", "2012-07-07 22:15:00", "2012-07-07 22:45:00", 
"2012-07-07 23:15:00", "2012-07-07 23:45:00", "2012-07-08 00:15:00", 
"2012-07-08 00:45:00", "2012-07-08 01:15:00", "2012-07-08 01:45:00", 
"2012-07-08 02:15:00", "2012-07-08 02:45:00", "2012-07-08 03:15:00", 
"2012-07-08 03:45:00", "2012-07-08 04:15:00", "2012-07-08 04:45:00", 
"2012-07-08 05:15:00", "2012-07-08 05:45:00", "2012-07-08 06:15:00", 
"2012-07-08 06:45:00", "2012-07-08 07:45:00", "2012-07-08 08:15:00", 
"2012-07-08 08:45:00", "2012-07-08 09:15:00", "2012-07-08 09:45:00", 
"2012-07-08 10:15:00", "2012-07-08 10:45:00", "2012-07-08 11:15:00", 
"2012-07-08 11:45:00", "2012-07-08 12:15:00", "2012-07-08 12:45:00", 
"2012-07-08 13:15:00", "2012-07-08 13:45:00", "2012-07-08 14:15:00", 
"2012-07-08 14:45:00", "2012-07-08 15:15:00", "2012-07-08 16:15:00", 
"2012-07-08 16:45:00", "2012-07-08 17:15:00", "2012-07-08 17:45:00", 
"2012-07-08 18:15:00", "2012-07-08 18:45:00", "2012-07-08 19:15:00", 
"2012-07-08 19:45:00", "2012-07-08 20:15:00", "2012-07-08 20:45:00", 
"2012-07-08 21:15:00", "2012-07-08 21:45:00", "2012-07-08 22:15:00", 
"2012-07-08 22:45:00", "2012-07-08 23:15:00", "2012-07-08 23:45:00", 
"2012-07-09 00:15:00", "2012-07-09 00:45:00", "2012-07-09 01:15:00", 
"2012-07-09 01:45:00", "2012-07-09 02:15:00", "2012-07-09 02:45:00", 
"2012-07-09 03:15:00", "2012-07-09 03:45:00", "2012-07-09 04:15:00", 
"2012-07-09 04:45:00", "2012-07-09 05:15:00", "2012-07-09 05:45:00", 
"2012-07-09 06:15:00", "2012-07-09 06:45:00", "2012-07-09 07:15:00", 
"2012-07-09 07:45:00", "2012-07-09 08:15:00", "2012-07-09 08:45:00", 
"2012-07-09 09:15:00", "2012-07-09 09:45:00", "2012-07-09 10:15:00", 
"2012-07-09 10:45:00", "2012-07-09 11:15:00", "2012-07-09 11:45:00", 
"2012-07-09 12:15:00", "2012-07-09 12:45:00", "2012-07-09 13:15:00", 
"2012-07-09 13:45:00", "2012-07-09 14:15:00", "2012-07-09 14:45:00", 
"2012-07-09 15:15:00", "2012-07-09 15:45:00", "2012-07-09 16:15:00", 
"2012-07-09 16:45:00", "2012-07-09 17:15:00", "2012-07-09 17:45:00", 
"2012-07-09 18:15:00", "2012-07-09 18:45:00", "2012-07-09 19:15:00", 
"2012-07-09 19:45:00", "2012-07-09 20:15:00", "2012-07-09 21:15:00", 
"2012-07-09 21:45:00", "2012-07-09 22:15:00", "2012-07-09 22:45:00", 
"2012-07-09 23:15:00", "2012-07-09 23:45:00", "2012-07-10 00:15:00", 
"2012-07-10 00:45:00", "2012-07-10 01:15:00", "2012-07-10 01:45:00", 
"2012-07-10 02:15:00", "2012-07-10 02:45:00", "2012-07-10 03:15:00", 
"2012-07-10 03:45:00", "2012-07-10 04:15:00", "2012-07-10 04:45:00", 
"2012-07-10 05:15:00", "2012-07-10 05:45:00", "2012-07-10 06:15:00", 
"2012-07-10 06:45:00", "2012-07-10 07:15:00", "2012-07-10 07:45:00", 
"2012-07-10 08:15:00", "2012-07-10 08:45:00", "2012-07-10 09:15:00", 
"2012-07-10 09:45:00", "2012-07-10 10:15:00", "2012-07-10 10:45:00", 
"2012-07-10 11:15:00", "2012-07-10 11:45:00", "2012-07-10 12:15:00", 
"2012-07-10 12:45:00", "2012-07-10 13:15:00", "2012-07-10 13:45:00", 
"2012-07-10 14:15:00", "2012-07-10 14:45:00", "2012-07-10 15:15:00", 
"2012-07-10 15:45:00", "2012-07-10 16:15:00", "2012-07-10 17:15:00", 
"2012-07-10 17:45:00", "2012-07-10 18:15:00", "2012-07-10 18:45:00", 
"2012-07-10 19:15:00", "2012-07-10 19:45:00", "2012-07-10 20:15:00", 
"2012-07-10 20:45:00", "2012-07-10 21:15:00", "2012-07-10 21:45:00", 
"2012-07-10 22:15:00", "2012-07-10 22:45:00", "2012-07-10 23:15:00", 
"2012-07-10 23:45:00"), class = "factor"), mon = c(1L, 1L, 1L, 
1L, 1L, 1L), X.1 = c(482986.747312444, 483106.142664631, 483101.821796104, 
483086.019405256, 483127.799620954, 483101.003261731), Y = c(6472837.55691427, 
6472855.34802117, 6472852.53770682, 6472786.61976395, 6472854.86710904, 
6472866.97636095), Z = c(6.49352941176471, 4.03558823529412, 
6.03769230769231, 3.9875, 2.94461538461538, 2.86)), .Names = c("X", 
"meanlat", "meanlong", "meandepth", "mindepth", "maxdepth", "depthrange", 
"rec", "numhits", "datetime", "mon", "X.1", "Y", "Z"), row.names = c(NA, 
6L), class = "data.frame")
>

最佳答案

你看起来你托盘很多东西，但你没有以好的方式尝试一件事。

例如使用 POSIXlt , 这里是你的 PAVdata 对象

ll <- as.POSIXlt(dat$datetime)
dat$hours <- ll$hour              ## I create a variable hour
dat$days <- ll$mday               ## I create a variable day
dat$months <- ll$mon              ## I create a variable month

现在我可以使用这个变量按组平均。

这里使用 plyr 的解决方案包。

 ddply(dat,.(months,days),summarise, m =  mean(meandepth))    ## I group by months and days
  months days        m
1      4   11 4.393154
> ddply(dat,.(months,days,hours),summarise, m =  mean(meandepth)) 
  months days hours        m
1      4   11    11 5.264558
2      4   11    12 5.012596
3      4   11    13 2.902308

无论您使用什么，请尝试以好的方式使用一件事。通常在 R 中有很多方法可以做这样的事情。

关于r - 使用grep在R中提取和平均每月数据？，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/14673844/

文章推荐： PHP按价格值对多维数组排序

文章推荐： image-processing - 特征检测器和描述符的比较

文章推荐： ecmascript-6 - 接受一个解构对象作为箭头函数的唯一参数

文章推荐： asp.net-mvc-3 - ReleaseView 什么时候被调用？

r - 计算 R 中的 R 平方内、R 平方之间或整体 R 平方
我正在从 Stata 迁移到 R(plm 包)，以便进行面板模型计量经济学。在 Stata 中，面板模型(例如随机效应)通常报告组内、组间和整体 R 平方。 I have found plm 随机效应
r - Revolution R 中的模块是开源的。 R 许可证是否意味着我可以免费使用随附的 R 软件包？
关闭。这个问题不符合Stack Overflow guidelines .它目前不接受答案。想改进这个问题？将问题更新为 on-topic对于堆栈溢出。 6年前关闭。 Improve this qu
r - 如何从 R 中的用户输入中读取向量并将其用于进一步处理 [R]
我想要求用户输入整数值列表。用户可以输入单个值或一组多个值，如 1 2 3(spcae 或逗号分隔)然后使用输入的数据进行进一步计算。我正在使用下面的代码 EXP <- as.integer(rea
r - R 中的分类变量 - R 选择哪一个作为引用？
当 R 使用分类变量执行回归时，它实际上是虚拟编码。也就是说，省略了一个级别作为基础或引用，并且回归公式包括所有其他级别的虚拟变量。但是，R 选择了哪一个作为引用，以及我如何影响这个选择？具有四个级
r - 制作数据框或排名调整后的 R 平方 - R
这个问题基本上是我之前问过的问题的延伸:How to only print (adjusted) R-squared of regression model? 我想建立一个线性回归模型来预测具有 15
r - 将已安装的 R 包传输到另一台计算机上的 R
我在一台安装了多个软件包的 Linux 计算机上安装了 R。现在我正在另一台 Linux 计算机上设置 R。从他们的存储库安装 R 很容易，但我将不得不使用安装许多包 install.package
r - R 中字符的对象大小 - R 全局字符串池如何工作？
我正在阅读 Hadley 的高级 R 编程，当它讨论字符的内存大小时，它说: R has a global string pool. This means that each unique strin
r - 是否写入 "ui.R + server.R"或 "app.R"
我们可以将 Shiny 代码写在两个单独的文件中，"ui.R"和 "server.R" , 或者我们可以将两个模块写入一个文件 "app.R"并调用函数shinyApp() 这两种方法中的任何一种在性
r - 在 .R 文件中保存 R 对象(代码)(R 遗传编程)
我正在使用 R 通过 RGP 包进行遗传编程。环境创造了解决问题的功能。我想将这些函数保存在它们自己的 .R 源文件中。我这辈子都想不通怎么办。我尝试过的一种方法是: bf_str = print(b
r - 如何让 R 在编辑后自动加载我的 .r 文件？
假设我创建了一个函数“function.r”，在编辑该函数后我必须通过 source('function.r') 重新加载到我的全局环境中。无论如何，每次我进行编辑时，我是否可以避免将其重新加载到我的
r - 是否可以在命令行中将代码通过管道传递给 R 或 R 脚本？
例如，test.R 是一个单行文件: $ cat test.R # print('Hello, world!') 我们可以通过Rscript test.R 或R CMD BATCH test.R 来
r - 我可以使用 R 笔记本作为 R 包小插图吗？
我知道我可以使用 Rmd 来构建包插图，但想知道是否可以更具体地使用 R Notebooks 来制作包插图。如果是这样，我需要将 R Notebooks 编写为包小插图有什么不同吗？我正在使用最新版本
r - 在 R 运行时更新 R 包
我正在考虑使用 R 包的共享库进行 R 的站点安装。多台计算机将访问该库，以便每个人共享相同的设置。问题是我注意到有时您无法更新包，因为另一个 R 实例正在锁定库。我不能要求每个人都关闭它的 R
r - 如何从命令行向 R 提供表达式但阻止 R 立即退出？
我知道如何从命令行启动 R 并执行表达式(例如， R -e 'print("hello")' )或从文件中获取输入(例如， R -f filename.r )。但是，在这两种情况下，R 都会运行文件中
r - 从另一个 .r 文件中编辑 .r 文件
我正在尝试使我当前的项目可重现，因此我正在创建一个主文档(最终是一个 .rmd 文件)，用于调用和执行其他几个文档。这样我自己和其他调查员只需要打开和运行一个文件。当前设置分为三层:主文件、2 个读
r - 是否有任何简单的方法可以在 R 中制作不需要安装 R 的桌面应用程序
关闭。这个问题不符合Stack Overflow guidelines .它目前不接受答案。想改进这个问题？将问题更新为 on-topic对于堆栈溢出。 5年前关闭。 Improve this qu
r - 如何在 R 包的手册中包含 Authors@R？
我的 R 包中有以下描述文件 Package: blah Title: What the Package Does (one line, title case) Version: 0.0.0.9000
r - 将 R 代码转换为 R 风格
有没有办法更有效地编写以下语句？accel 是一个数据框。 accel[[2]]<- accel[[2]]-weighted.mean(accel[[2]]) accel[[3]]<- accel[[
r - 安装 R 包时，R 如何检查系统外部依赖项？
例如，在尝试安装 R 包时 curl作为 usethis 的依赖项: * installing *source* package ‘curl’ ... ** package ‘curl’ succes
r - 在 R 包中包含 R 脚本
我想将一些软件作为一个包共享，但我的一些脚本似乎并不能很自然地作为函数运行。例如，考虑以下代码块，其中“raw.df”是一个包含离散和连续类型变量的数据框。函数“count.unique”和“squa

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

r - 使用grep在R中提取和平均每月数据？