I have a file with holidays by country. I create a new date file . In IF statement I compare, if the country and date from holiday file are in my new date file. If the statement is true, I consider those days in date file as Sundays (1).

Seems, that my code ignores country column in comparison, because in output file 14th of July, which is a holiday in France, becomes a holiday for every country


# check whether there are dates within the prediction period that are a holiday, and set them to sunday (sunday is day 1). 
inputdata$wkday <- ifelse(as.character(inputdata$Date) %in% as.character(Holidays$Date) &
                            as.numeric(inputdata$clubctryISO) %in% as.numeric(Holidays$country_shortname),1,inputdata$wkday)

0 Answers