[R] Count number of Fridays in a month
Duncan Murdoch
murdoch.duncan at gmail.com
Fri Oct 10 14:16:09 CEST 2014
On 10/10/2014 8:10 AM, Abhinaba Roy wrote:
> Hi Duncan,
>
> I have converted the string to a POSIXIt object using
>
> > strptime('31-may-2014',format="%d-%b-%Y")
>
> But could not figure out the way forward.
>
> Could you please elaborate a bit?
Try this:
?POSIXlt
Duncan Murdoch
>
> On Fri, Oct 10, 2014 at 5:14 PM, Duncan Murdoch
> <murdoch.duncan at gmail.com <mailto:murdoch.duncan at gmail.com>> wrote:
>
> On 10/10/2014, 7:28 AM, Abhinaba Roy wrote:
> > Hi R helpers,
> >
> > I want to write a function which will
> >
> > 1. Count the number of fridays in the current month ( to extract
> month from
> > given date) and also the number of fridays in the preceeding month
> >
> > 2. Calculate the ratio of the number of fridays in current month
> to the
> > number of fridays in the precceding month
> >
> > 3. Return a integer value calculated as
> > ifelse(ratio>1,1,ifesle(ration<1,-1),0)
> >
> > The date which is passed is in the format *'31-may-2014'*
> >
> > So, given the date '31-may-2014'
> >
> > Number of fridays in May2014 = 5
> > Number of fridays in Apr2014 = 4
> >
> > Ratio = 5/4 >1
> > Hence, the function will return a value 1
> >
> > I want to call the function by passing '31-may-2014' as an argument
> >
> > How can this be done in R?
> >
> > Any help will be appreciated
>
> Convert your string to a POSIXlt object using as.POSIXlt. Then
> you can
> extract year, month and weekday from the result, and go from there.
> (The only unobvious part is figuring out how many days are in each
> month, but there are questions online giving various ways to do this.)
>
> Duncan Murdoch
>
>
More information about the R-help
mailing list