pandas 将功能应用于按天分组的数据 [英] pandas apply function to data grouped by day
本文介绍了 pandas 将功能应用于按天分组的数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个像这样的数据集:
I have a dataset that looks like this:
date,value1,value2
2016-01-01 00:00:00,3,0
2016-01-01 01:00:00,0,0
2016-01-01 02:00:00,0,0
2016-01-01 03:00:00,0,0
2016-01-01 04:00:00,0,0
2016-01-01 05:00:00,0,0
2016-01-01 06:00:00,0,0
2016-01-01 07:00:00,0,2
2016-01-01 08:00:00,3,11
2016-01-01 09:00:00,14,14
2016-01-01 10:00:00,12,13
2016-01-01 11:00:00,11,13
2016-01-01 12:00:00,11,9
2016-01-01 13:00:00,17,21
2016-01-01 14:00:00,9,22
2016-01-01 15:00:00,10,9
2016-01-01 16:00:00,11,9
2016-01-01 17:00:00,8,8
2016-01-01 18:00:00,4,2
2016-01-01 19:00:00,5,7
2016-01-01 20:00:00,5,5
2016-01-01 21:00:00,3,4
2016-01-01 22:00:00,2,4
2016-01-01 23:00:00,2,4
2016-01-02 00:00:00,0,0
2016-01-02 01:00:00,0,0
2016-01-02 02:00:00,0,0
2016-01-02 03:00:00,0,0
2016-01-02 04:00:00,0,0
2016-01-02 05:00:00,0,0
2016-01-02 06:00:00,1,0
2016-01-02 07:00:00,0,0
2016-01-02 08:00:00,0,0
2016-01-02 09:00:00,0,0
2016-01-02 10:00:00,0,0
2016-01-02 11:00:00,0,0
2016-01-02 12:00:00,0,0
2016-01-02 13:00:00,1,0
2016-01-02 14:00:00,0,0
2016-01-02 15:00:00,0,0
2016-01-02 16:00:00,0,0
2016-01-02 17:00:00,0,0
2016-01-02 18:00:00,0,0
2016-01-02 19:00:00,0,0
2016-01-02 20:00:00,1,0
2016-01-02 21:00:00,0,0
2016-01-02 22:00:00,0,0
2016-01-02 23:00:00,0,0
我想做的是每天计算出value1和value2之间的均方根值.所以基本上,我想运行该函数31次(每天一次),输入将是一天中的24个条目(每小时一个)我尝试使用
What I want to do is calculate the rmse between value1 and value2 per day. So basically, I want to run the function 31 times (once per day), and the input would be the 24 entries of the day (one every hour) I tried using
rmse(df.groupby([df.index.day]).mean().value1,
df.groupby([df.index.day]).mean().value2)
但是它给了我一个单一的值,我想要的是一张每天均方根值的列表,例如
but it gave me a single value, and what I want is a list with the rmse of each day, such as
daily_rmse = [rmse01_01, rmse01_02, ..., rmse01_31]
推荐答案
使用 sklearn
的 mean_squared_error
from sklearn.metrics import mean_squared_error
df.groupby(df.date.dt.date).apply(
lambda x: mean_squared_error(x.value1, x.value2) ** .5)
date
2016-01-01 3.494043
2016-01-02 0.377964
dtype: float64
这篇关于 pandas 将功能应用于按天分组的数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文