python - 在 pandas df 中查找 timedelta 对象的均值和标准差

Question

我想通过 dataframe 计算银行 timedelta 的 mean 和 standard deviation如下所示的两列。当我运行代码(也如下所示)时，出现以下错误:

pandas.core.base.DataError: No numeric types to aggregate

我的数据框:

   bank                          diff
   Bank of Japan                 0 days 00:00:57.416000
   Reserve Bank of Australia     0 days 00:00:21.452000
   Reserve Bank of New Zealand  55 days 12:39:32.269000
   U.S. Federal Reserve          8 days 13:27:11.387000

我的代码:

means = dropped.groupby('bank').mean()
std = dropped.groupby('bank').std()

Answer 1

Pandas mean() 等聚合方法支持numeric_only=False参数。

dropped.groupby('bank').mean(numeric_only=False)

在这里找到:Aggregations for Timedelta values in the Python DataFrame