计算R中两个日期之间的工作日数

pod7payv  于 2023-02-17  发布在  其他
关注(0)|答案(7)|浏览(213)

我试着写一个R函数来计算两个日期之间的工作日数。例如，Nweekdays（'01/30/2011'，'02/04/2011'）将等于5。
类似于this question。谢谢！
/edit：@J. Winchester的答案很棒，但我想知道是否有人能想到一种方法来矢量化这个，这样它就可以在2列日期上工作。谢谢！/edit 2：再次感谢！

r

7条答案

按热度按时间
brgchamk

brgchamk1#

Date1 <- as.Date("2011-01-30")
Date2 <- as.Date("2011-02-04")    
sum(!weekdays(seq(Date1, Date2, "days")) %in% c("Saturday", "Sunday"))

编辑：而扎克说，让有Vectorize：）

Dates1 <- as.Date("2011-01-30") + rep(0, 10)
Dates2 <- as.Date("2011-02-04") + seq(0, 9)
Nweekdays <- Vectorize(function(a, b) 
  sum(!weekdays(seq(a, b, "days")) %in% c("Saturday", "Sunday")))
Nweekdays(Dates1, Dates2)
赞(0）分享  回复(0）举报  2023-02-17
k10s72fa

k10s72fa2#

这些修改的函数考虑了正或负的日期差异，而可接受的解决方案考虑了正的日期差异。

library("dplyr")

e2 <- structure(list(date.pr = structure(c(16524, 16524, 16524, 16524, 16524, 16524, 16524, 16524, 16524, 16524, 16545, 5974), class = "Date"), 
                     date.po = structure(c(16524, 16525, 16526, 16527, 16528, 16529, 16530, 16531, 16538, 16545, 16524, 15974), class = "Date")), 
                .Names = c("date.1", "date.2"), class = c("tbl_df", "data.frame"), row.names = c(NA, -12L))

1.区域设置相关解决方案：Nweekdays()函数改编自@J. Won.的解决方案，适用于locale = "English_United States.1252"

Nweekdays <- Vectorize(
  function(a, b) 
  {
    ifelse(a < b, 
           return(sum(!weekdays(seq(a, b, "days")) %in% c("Saturday", "Sunday")) - 1), 
           return(sum(!weekdays(seq(b, a, "days")) %in% c("Saturday", "Sunday")) - 1))
  })

a.英语区域设置

> Sys.setlocale(category="LC_ALL", locale = "English_United States.1252")
[1] "LC_COLLATE=English_United States.1252;LC_CTYPE=English_United States.1252;LC_MONETARY=English_United States.1252;LC_NUMERIC=C;LC_TIME=English_United States.1252"

> Sys.getlocale()
[1] "LC_COLLATE=English_United States.1252;LC_CTYPE=English_United States.1252;LC_MONETARY=English_United States.1252;LC_NUMERIC=C;LC_TIME=English_United States.1252"

> e2 %>%
    mutate(wkd1 = format(date.1, "%A"),
           wkd2 = format(date.2, "%A"),
           ndays_with_wkends = ifelse((date.2 > date.1), (date.2 - date.1), (date.1 - date.2)), 
           ndays_no_wkends = Nweekdays(date.1, date.2))

Source: local data frame [12 x 6]

       date.1     date.2   wkd1      wkd2 ndays_with_wkends ndays_no_wkends
       (date)     (date)  (chr)     (chr)             (dbl)           (dbl)
1  2015-03-30 2015-03-30 Monday    Monday                 0               0
2  2015-03-30 2015-03-31 Monday   Tuesday                 1               1
3  2015-03-30 2015-04-01 Monday Wednesday                 2               2
4  2015-03-30 2015-04-02 Monday  Thursday                 3               3
5  2015-03-30 2015-04-03 Monday    Friday                 4               4
6  2015-03-30 2015-04-04 Monday  Saturday                 5               4
7  2015-03-30 2015-04-05 Monday    Sunday                 6               4
8  2015-03-30 2015-04-06 Monday    Monday                 7               5
9  2015-03-30 2015-04-13 Monday    Monday                14              10
10 2015-03-30 2015-04-20 Monday    Monday                21              15
11 2015-04-20 2015-03-30 Monday    Monday                21              15
12 1986-05-11 2013-09-26 Sunday  Thursday             10000            7143

B.中文环境

> Sys.setlocale(category="LC_ALL", locale = "chinese")
[1] "LC_COLLATE=Chinese (Simplified)_People's Republic of China.936;LC_CTYPE=Chinese (Simplified)_People's Republic of China.936;LC_MONETARY=Chinese (Simplified)_People's Republic of China.936;LC_NUMERIC=C;LC_TIME=Chinese (Simplified)_People's Republic of China.936"

> Sys.getlocale()
[1] "LC_COLLATE=Chinese (Simplified)_People's Republic of China.936;LC_CTYPE=Chinese (Simplified)_People's Republic of China.936;LC_MONETARY=Chinese (Simplified)_People's Republic of China.936;LC_NUMERIC=C;LC_TIME=Chinese (Simplified)_People's Republic of China.936"

> e2 %>%
    mutate(wkd1 = format(date.1, "%A"),
           wkd2 = format(date.2, "%A"),
           ndays_with_wkends = ifelse((date.2 > date.1), (date.2 - date.1), (date.1 - date.2)), 
           ndays_no_wkends = Nweekdays(date.1, date.2))

Source: local data frame [12 x 6]

       date.1     date.2   wkd1   wkd2 ndays_with_wkends ndays_no_wkends
       (date)     (date)  (chr)  (chr)             (dbl)           (dbl)
1  2015-03-30 2015-03-30 ÐÇÆÚÒ» ÐÇÆÚÒ»                 0               0
2  2015-03-30 2015-03-31 ÐÇÆÚÒ» ÐÇÆÚ¶þ                 1               1
3  2015-03-30 2015-04-01 ÐÇÆÚÒ» ÐÇÆÚÈý                 2               2
4  2015-03-30 2015-04-02 ÐÇÆÚÒ» ÐÇÆÚËÄ                 3               3
5  2015-03-30 2015-04-03 ÐÇÆÚÒ» ÐÇÆÚÎå                 4               4
6  2015-03-30 2015-04-04 ÐÇÆÚÒ» ÐÇÆÚÁù                 5               5
7  2015-03-30 2015-04-05 ÐÇÆÚÒ» ÐÇÆÚÈÕ                 6               6
8  2015-03-30 2015-04-06 ÐÇÆÚÒ» ÐÇÆÚÒ»                 7               7
9  2015-03-30 2015-04-13 ÐÇÆÚÒ» ÐÇÆÚÒ»                14              14
10 2015-03-30 2015-04-20 ÐÇÆÚÒ» ÐÇÆÚÒ»                21              21
11 2015-04-20 2015-03-30 ÐÇÆÚÒ» ÐÇÆÚÒ»                21              21
12 1986-05-11 2013-09-26 ÐÇÆÚÈÕ ÐÇÆÚËÄ             10000           10000

2.区域独立解决方案：Nweekdays()函数改编自@Sacha Epskamp的解决方案，它适用于所有区域，但@Sacha Epskamp使用c(0,6)剔除周末，这与此解决方案使用c(2,3)提取周末不同。

Nweekdays <- Vectorize(
  function(a, b) {
           return(sum(!(((as.numeric(b:a)) %% 7) %in% c(2,3))) - 1) # 2: Saturday and 3: Sunday
  })

a.英语区域设置

> Sys.setlocale(category="LC_ALL", locale = "English_United States.1252")
[1] "LC_COLLATE=English_United States.1252;LC_CTYPE=English_United States.1252;LC_MONETARY=English_United States.1252;LC_NUMERIC=C;LC_TIME=English_United States.1252"

> Sys.getlocale()
[1] "LC_COLLATE=English_United States.1252;LC_CTYPE=English_United States.1252;LC_MONETARY=English_United States.1252;LC_NUMERIC=C;LC_TIME=English_United States.1252"

> e2 %>%
    mutate(wkd1 = format(date.1, "%A"),
           wkd2 = format(date.2, "%A"),
           ndays_with_wkends = ifelse((date.2 > date.1), (date.2 - date.1), (date.1 - date.2)), 
           ndays_no_wkends = Nweekdays(date.1, date.2))

Source: local data frame [12 x 6]

       date.1     date.2   wkd1      wkd2 ndays_with_wkends ndays_no_wkends
       (date)     (date)  (chr)     (chr)             (dbl)           (dbl)
1  2015-03-30 2015-03-30 Monday    Monday                 0               0
2  2015-03-30 2015-03-31 Monday   Tuesday                 1               1
3  2015-03-30 2015-04-01 Monday Wednesday                 2               2
4  2015-03-30 2015-04-02 Monday  Thursday                 3               3
5  2015-03-30 2015-04-03 Monday    Friday                 4               4
6  2015-03-30 2015-04-04 Monday  Saturday                 5               4
7  2015-03-30 2015-04-05 Monday    Sunday                 6               4
8  2015-03-30 2015-04-06 Monday    Monday                 7               5
9  2015-03-30 2015-04-13 Monday    Monday                14              10
10 2015-03-30 2015-04-20 Monday    Monday                21              15
11 2015-04-20 2015-03-30 Monday    Monday                21              15
12 1986-05-11 2013-09-26 Sunday  Thursday             10000            7143

B.中文环境

> Sys.setlocale(category="LC_ALL", locale = "chinese")
[1] "LC_COLLATE=Chinese (Simplified)_People's Republic of China.936;LC_CTYPE=Chinese (Simplified)_People's Republic of China.936;LC_MONETARY=Chinese (Simplified)_People's Republic of China.936;LC_NUMERIC=C;LC_TIME=Chinese (Simplified)_People's Republic of China.936"

> Sys.getlocale()
[1] "LC_COLLATE=Chinese (Simplified)_People's Republic of China.936;LC_CTYPE=Chinese (Simplified)_People's Republic of China.936;LC_MONETARY=Chinese (Simplified)_People's Republic of China.936;LC_NUMERIC=C;LC_TIME=Chinese (Simplified)_People's Republic of China.936"

> e2 %>%
    mutate(wkd1 = format(date.1, "%A"),
           wkd2 = format(date.2, "%A"),
           ndays_with_wkends = ifelse((date.2 > date.1), (date.2 - date.1), (date.1 - date.2)), 
           ndays_no_wkends = Nweekdays(date.1, date.2))

Source: local data frame [12 x 6]

       date.1     date.2   wkd1   wkd2 ndays_with_wkends ndays_no_wkends
       (date)     (date)  (chr)  (chr)             (dbl)           (dbl)
1  2015-03-30 2015-03-30 ÐÇÆÚÒ» ÐÇÆÚÒ»                 0               0
2  2015-03-30 2015-03-31 ÐÇÆÚÒ» ÐÇÆÚ¶þ                 1               1
3  2015-03-30 2015-04-01 ÐÇÆÚÒ» ÐÇÆÚÈý                 2               2
4  2015-03-30 2015-04-02 ÐÇÆÚÒ» ÐÇÆÚËÄ                 3               3
5  2015-03-30 2015-04-03 ÐÇÆÚÒ» ÐÇÆÚÎå                 4               4
6  2015-03-30 2015-04-04 ÐÇÆÚÒ» ÐÇÆÚÁù                 5               4
7  2015-03-30 2015-04-05 ÐÇÆÚÒ» ÐÇÆÚÈÕ                 6               4
8  2015-03-30 2015-04-06 ÐÇÆÚÒ» ÐÇÆÚÒ»                 7               5
9  2015-03-30 2015-04-13 ÐÇÆÚÒ» ÐÇÆÚÒ»                14              10
10 2015-03-30 2015-04-20 ÐÇÆÚÒ» ÐÇÆÚÒ»                21              15
11 2015-04-20 2015-03-30 ÐÇÆÚÒ» ÐÇÆÚÒ»                21              15
12 1986-05-11 2013-09-26 ÐÇÆÚÈÕ ÐÇÆÚËÄ             10000            7143
赞(0）分享  回复(0）举报  2023-02-17
ugmeyewa

ugmeyewa3#

我写了这一个，但另一个答案更好：）

Nweekdays <- function(a,b)
{
dates <- as.Date(as.Date(a,"%m/%d/%y",origin="1900-01-01"):as.Date(b,"%m/%d/%y",origin="1900-01-01"),origin="1900-01-01")
days <- format(dates,"%w")[c(-1,-length(dates))]
return(sum(!days%in%c(0,6)))
}

Nweekdays('01/30/2011','02/04/2011')
[1] 3

EDIT：计算两个指定日期之间有多少个工作日。

编辑：

根据J. Winchester的建议，这一职能可简化为：

Nweekdays <- function(a,b)
{
dates <- as.numeric((as.Date(a,"%m/%d/%y")):(as.Date(b,"%m/%d/%y")))
dates <- dates[- c(1,length(dates))]
return(sum(!dates%%7%in%c(0,6)))
}

一些结果：

> Nweekdays('01/30/2011','02/04/2011')
[1] 4
> 
> Nweekdays('01/30/2011','01/30/2011')
[1] 0
> 
> Nweekdays('01/30/2011','01/25/2011')
[1] 3

注意，这与语言环境无关。（关于这个主题，我如何更改语言环境呢？）

赞(0）分享  回复(0）举报  2023-02-17
wnavrhmk

wnavrhmk4#

使用Lubridate解决这个问题，您可以创建如下函数：

library(lubridate)

WorkingDays_function <- function(StartDate,EndDate){
startDate <- dmy(StartDate)
endDate <- dmy(EndDate)

#Now build a sequence between the dates:
myDates <-seq(from = startDate, to = endDate, by = "days")

#Week starts on Sunday (1) so to exclude Sun (1) and Sat (7)
#use > 1 & < 7  
working_days <- sum(wday(myDates)>1 & wday(myDates)<7)

print(working_days)
}

WorkingDays_function("11/07/2019","20/07/2019")
赞(0）分享  回复(0）举报  2023-02-17
z31licg0

z31licg05#

J.Win的答案是好的，但是使用lubridate可以更快一些。

require(lubridate)
count_weekdays<- Vectorize(function(from,to) sum(!wday(seq(from, to, "days")) %in% c(1,7)))

以下是我的机器的时间结果：

> v1<- seq(from = ymd(19000101), to = ymd(20000101), by='month')
> v2<- seq(from = ymd(20000101), to = ymd(21000101), by='month')

> require(tictoc)

> tic(); out<- Nweekdays(v1,v2); toc();
293.06 sec elapsed

> tic(); out<- count_weekdays(v1,v2); toc();
9.95 sec elapsed

大约快30倍。如果你做了很多月经，这是有意义的。

赞(0）分享  回复(0）举报  2023-02-17
um6iljoc

um6iljoc6#

我使用以下方法-首先是一个助手：

weekDays <- function(UPPER = TRUE) {
    days <- c('MONDAY', 'TUESDAY', 'WEDNESDAY',
      'THURSDAY', 'FRIDAY', 'SATURDAY', 
      'SUNDAY')
    if(!UPPER) return(.Internal(tolower(days))) 
    days
}

......现在是主要功能：

NumWeekDays <- function(dd, Xdays = c('saturday', 'sunday')) {
    # a function to count the number of non-Xdays in a month
    # >
    # first check if Xdays is of correct format
    stopifnot( all(.Internal(tolower(Xdays)) %in% weekDays(UP = FALSE)))
    # >
    # a helper function to find the number of non-X days between two dates
    NonXDays <- function(startDate, endDate, Xdays) {
        sum(!(.Internal(tolower(weekdays(seq(startDate, endDate, 'day')))) %in% 
              .Internal(tolower(Xdays))))
    }
    startDate <- as.Date(as.yearmon(index(dd)), frac = 0)
    endDate <- as.Date(as.yearmon(index(dd)), frac = 1)
    vapply(1:nrow(dd), 
           FUN = function(i) NonXDays(startDate[i], 
                                      endDate[i], 
                                      Xdays = c('saturday', 'sunday')), 
           FUN.VALUE = numeric(1))
}

示例：

set.seed(1)
dx <- apply.monthly(xts(rnorm(600), order.by = Sys.Date() + 1:600), mean)

R> NumWeekDays(dx)
 [1] 23 21 22 23 20 23 22 20 22 22 21 22 23 21 22 22 21 23 21 21
赞(0）分享  回复(0）举报  2023-02-17
nsc4cvqm

nsc4cvqm7#

这样应该更快

wkDaysCnt = function(endDate, startDate) {
    startDays = c("Monday"=5, "Tuesday"=4, "Wednesday"=3, "Thursday"=2, "Friday"=1, "Saturday"=0, "Sunday"=0)
    endDays   = c("Monday"=1, "Tuesday"=2, "Wednesday"=3, "Thursday"=4, "Friday"=5, "Saturday"=5, "Sunday"=5)
    tDays = as.numeric(difftime(endDate, startDate, units="days"))+1
    sdc1 = startDays[weekdays(startDate)]

    sdc2  = ifelse((tDays >= sdc1), sdc1, tDays)
    edc   = endDays[weekdays(endDate)] * (tDays > sdc1+2)

    ret = sdc2 + edc + (5 * round((tDays - sdc2 - edc - 1) / 7) ) - 1
    ret[ret < 0] = 0
    names(ret) = NULL

    return(ret)
}
赞(0）分享  回复(0）举报  2023-02-17
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备2022004421号-2 NULL123 https://www.null123.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com