Trying to calculate New Joiners and Leavers
up vote
-1
down vote
favorite
Here's the data I'm working with:
I'm trying to calculate the joiner / leaver columns in r using by looking to see if start date is %within% month and headcount == 1 then +1 and similarly with Leavers as -1. For some reason r is not recognizing the %within% function of lubridate.
Anyone have any recommendations of a simpler way to do this?
Sorry this is my 2nd week of using r and am in no way a developer - just learning along the way...
Thanks
r lubridate
edited Nov 20 at 2:22
Matt Ke
6011418
asked Nov 19 at 20:04
Michel_1987
1
add a comment |
up vote
-1
down vote
favorite
Here's the data I'm working with:
I'm trying to calculate the joiner / leaver columns in r using by looking to see if start date is %within% month and headcount == 1 then +1 and similarly with Leavers as -1. For some reason r is not recognizing the %within% function of lubridate.
Anyone have any recommendations of a simpler way to do this?
Sorry this is my 2nd week of using r and am in no way a developer - just learning along the way...
Thanks
r lubridate
edited Nov 20 at 2:22
Matt Ke
6011418
asked Nov 19 at 20:04
Michel_1987
1
Have you loadedlubridatewithlibrary(lubridate)? And have you converted those strings toDateclass?
– Gregor
Nov 19 at 20:05
It's easier to help you if you include a simple reproducible example with sample input and desired output that can be used to test and verify possible solutions. (Pictures of data are not reproducible)
– MrFlick
Nov 19 at 20:08
yeah I loaded the library, however did not convert to date class. Will try that!
– Michel_1987
Nov 19 at 21:35
Please add sample code of your attempt and a sample data set(usingdput(yourdata)
– NelsonGon
Nov 20 at 0:45
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
Here's the data I'm working with:
I'm trying to calculate the joiner / leaver columns in r using by looking to see if start date is %within% month and headcount == 1 then +1 and similarly with Leavers as -1. For some reason r is not recognizing the %within% function of lubridate.
Anyone have any recommendations of a simpler way to do this?
Sorry this is my 2nd week of using r and am in no way a developer - just learning along the way...
Thanks
r lubridate
edited Nov 20 at 2:22
Matt Ke
6011418
asked Nov 19 at 20:04
Michel_1987
1
Here's the data I'm working with:
I'm trying to calculate the joiner / leaver columns in r using by looking to see if start date is %within% month and headcount == 1 then +1 and similarly with Leavers as -1. For some reason r is not recognizing the %within% function of lubridate.
Anyone have any recommendations of a simpler way to do this?
Sorry this is my 2nd week of using r and am in no way a developer - just learning along the way...
Thanks
r lubridate
r lubridate
edited Nov 20 at 2:22
Matt Ke
6011418
asked Nov 19 at 20:04
Michel_1987
1
edited Nov 20 at 2:22
Matt Ke
6011418
asked Nov 19 at 20:04
Michel_1987
1
edited Nov 20 at 2:22
Matt Ke
6011418
edited Nov 20 at 2:22
Matt Ke
6011418
edited Nov 20 at 2:22
Matt Ke
6011418
6011418
asked Nov 19 at 20:04
Michel_1987
1
asked Nov 19 at 20:04
Michel_1987
1
asked Nov 19 at 20:04
Michel_1987
1
1
Have you loadedlubridatewithlibrary(lubridate)? And have you converted those strings toDateclass?
– Gregor
Nov 19 at 20:05
It's easier to help you if you include a simple reproducible example with sample input and desired output that can be used to test and verify possible solutions. (Pictures of data are not reproducible)
– MrFlick
Nov 19 at 20:08
yeah I loaded the library, however did not convert to date class. Will try that!
– Michel_1987
Nov 19 at 21:35
Please add sample code of your attempt and a sample data set(usingdput(yourdata)
– NelsonGon
Nov 20 at 0:45
add a comment |
Have you loadedlubridatewithlibrary(lubridate)? And have you converted those strings toDateclass?
– Gregor
Nov 19 at 20:05
It's easier to help you if you include a simple reproducible example with sample input and desired output that can be used to test and verify possible solutions. (Pictures of data are not reproducible)
– MrFlick
Nov 19 at 20:08
yeah I loaded the library, however did not convert to date class. Will try that!
– Michel_1987
Nov 19 at 21:35
Please add sample code of your attempt and a sample data set(usingdput(yourdata)
– NelsonGon
Nov 20 at 0:45
Have you loaded
lubridate with library(lubridate)? And have you converted those strings to Date class?– Gregor
Nov 19 at 20:05
Have you loaded
lubridate with library(lubridate)? And have you converted those strings to Date class?– Gregor
Nov 19 at 20:05
It's easier to help you if you include a simple reproducible example with sample input and desired output that can be used to test and verify possible solutions. (Pictures of data are not reproducible)
– MrFlick
Nov 19 at 20:08
It's easier to help you if you include a simple reproducible example with sample input and desired output that can be used to test and verify possible solutions. (Pictures of data are not reproducible)
– MrFlick
Nov 19 at 20:08
yeah I loaded the library, however did not convert to date class. Will try that!
– Michel_1987
Nov 19 at 21:35
yeah I loaded the library, however did not convert to date class. Will try that!
– Michel_1987
Nov 19 at 21:35
Please add sample code of your attempt and a sample data set(using
dput(yourdata)– NelsonGon
Nov 20 at 0:45
Please add sample code of your attempt and a sample data set(using
dput(yourdata)– NelsonGon
Nov 20 at 0:45
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53381851%2ftrying-to-calculate-new-joiners-and-leavers%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Have you loaded
lubridatewithlibrary(lubridate)? And have you converted those strings toDateclass?– Gregor
Nov 19 at 20:05
It's easier to help you if you include a simple reproducible example with sample input and desired output that can be used to test and verify possible solutions. (Pictures of data are not reproducible)
– MrFlick
Nov 19 at 20:08
yeah I loaded the library, however did not convert to date class. Will try that!
– Michel_1987
Nov 19 at 21:35
Please add sample code of your attempt and a sample data set(using
dput(yourdata)– NelsonGon
Nov 20 at 0:45