如何在pandas.core.series.Series中使用(np.busday_count)

问题描述

我想计算两列之间的工作日，类型为pandas.core.series.Series

I want to calculate the business days between two columns type pandas.core.series.Series

在接收日期和完成日期之间#仅在工作日内
我正在尝试使用np.busday_count(接收日期，完成日期，weekmask =星期五星期六")但是我得到了:

between Received date and complete date #business days only
I was trying to use np.busday_count(Received date,complete date,weekmask= "Fri Sat")but I was getting :

这是我数据框的一部分:

Here is part of my dataframe:

     Received   Complete
0  2018-09-10 2018-09-25
1  2018-07-16 2018-08-13
2  2018-07-05 2018-07-11
3  2018-07-05 2018-07-23
4  2018-07-26 2018-08-14
5  2018-07-04 2018-08-28
6  2018-07-05 2018-07-10
7  2018-07-05 2018-07-10
8  2018-07-05 2018-07-22
9  2018-07-05 2018-07-22
10 2018-07-05 2018-07-19

推荐答案

如错误所示，使用转换为'datetime64 [D]' 之前np.busday_count :

As indicated in the error, convert to 'datetime64[D]' before using np.busday_count:

res = np.busday_count(df['Received'].values.astype('datetime64[D]'),
                      df['Complete'].values.astype('datetime64[D]'),
                      weekmask= "Fri Sat")

# array([ 4,  8,  2,  6,  6, 16,  2,  2,  6,  6,  4], dtype=int64)

这篇关于如何在pandas.core.series.Series中使用(np.busday_count)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！