本文介绍了R中每小时间隔的汇总时间列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我在R中有以下格式的df。以每小时的时间间隔为基础进行汇总的最简单方法是什么,当前是每分钟

I have a df in R in the following format. What could be the easiest way to aggregate this on an hourly time interval basis, currently it is every minute

                 theTime24 Amount
988 2015-02-04 23:53:00      2
989 2015-02-04 23:55:00      1
990 2015-02-04 23:56:00      3
991 2015-02-04 23:57:00      2
992 2015-02-04 23:58:00      1
993 2015-02-04 23:59:00      2


推荐答案

(由于回答的用户(@ user20650)将其添加为评论,所以我

(Since the user (@user20650) who answered added it as a comment, I am answering my own question)

aggregate(Amount ~ format(as.POSIXct(countByCountryTime$theTime24), "%Y-%m-%d %H"), data=countByCountryTime, sum)

这篇关于R中每小时间隔的汇总时间列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-23 15:32