Update column values in a data frame from lagged records of same column
Need to update dispatched_seq column value from its previous existing value. To elaborate, my input data is:
And my output data need to be :
I am looking for a solution using vectored operations like dplyr,apply etc. The data is more i.e around 10 million records.
r dplyr
asked Nov 22 at 9:34
Anil Kumar
708
add a comment |
Need to update dispatched_seq column value from its previous existing value. To elaborate, my input data is:
And my output data need to be :
I am looking for a solution using vectored operations like dplyr,apply etc. The data is more i.e around 10 million records.
r dplyr
asked Nov 22 at 9:34
Anil Kumar
708
1
zoo::na.locfgoogle
– Andre Elrico
Nov 22 at 9:37
@AndreElrico Thank you. It helped a lot.
– Anil Kumar
Nov 22 at 10:01
1
to help you even more: Before usingzoo::na.locfreplace in colDispatched_seqNA with "NA_placeholder", "empty cells" with NA-Object. Then usezoo::na.locf. Now turn "NA_placeholder" back into NA-Object.
– Andre Elrico
Nov 22 at 10:04
add a comment |
Need to update dispatched_seq column value from its previous existing value. To elaborate, my input data is:
And my output data need to be :
I am looking for a solution using vectored operations like dplyr,apply etc. The data is more i.e around 10 million records.
r dplyr
asked Nov 22 at 9:34
Anil Kumar
708
Need to update dispatched_seq column value from its previous existing value. To elaborate, my input data is:
And my output data need to be :
I am looking for a solution using vectored operations like dplyr,apply etc. The data is more i.e around 10 million records.
r dplyr
r dplyr
asked Nov 22 at 9:34
Anil Kumar
708
asked Nov 22 at 9:34
Anil Kumar
708
asked Nov 22 at 9:34
Anil Kumar
708
asked Nov 22 at 9:34
Anil Kumar
708
asked Nov 22 at 9:34
Anil Kumar
708
708
1
zoo::na.locfgoogle
– Andre Elrico
Nov 22 at 9:37
@AndreElrico Thank you. It helped a lot.
– Anil Kumar
Nov 22 at 10:01
1
to help you even more: Before usingzoo::na.locfreplace in colDispatched_seqNA with "NA_placeholder", "empty cells" with NA-Object. Then usezoo::na.locf. Now turn "NA_placeholder" back into NA-Object.
– Andre Elrico
Nov 22 at 10:04
add a comment |
1
zoo::na.locfgoogle
– Andre Elrico
Nov 22 at 9:37
@AndreElrico Thank you. It helped a lot.
– Anil Kumar
Nov 22 at 10:01
1
to help you even more: Before usingzoo::na.locfreplace in colDispatched_seqNA with "NA_placeholder", "empty cells" with NA-Object. Then usezoo::na.locf. Now turn "NA_placeholder" back into NA-Object.
– Andre Elrico
Nov 22 at 10:04
1
1
zoo::na.locf google– Andre Elrico
Nov 22 at 9:37
zoo::na.locf google– Andre Elrico
Nov 22 at 9:37
@AndreElrico Thank you. It helped a lot.
– Anil Kumar
Nov 22 at 10:01
@AndreElrico Thank you. It helped a lot.
– Anil Kumar
Nov 22 at 10:01
1
1
to help you even more: Before using
zoo::na.locf replace in col Dispatched_seq NA with "NA_placeholder", "empty cells" with NA-Object. Then use zoo::na.locf. Now turn "NA_placeholder" back into NA-Object.– Andre Elrico
Nov 22 at 10:04
to help you even more: Before using
zoo::na.locf replace in col Dispatched_seq NA with "NA_placeholder", "empty cells" with NA-Object. Then use zoo::na.locf. Now turn "NA_placeholder" back into NA-Object.– Andre Elrico
Nov 22 at 10:04
add a comment |
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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%2f53427790%2fupdate-column-values-in-a-data-frame-from-lagged-records-of-same-column%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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%2f53427790%2fupdate-column-values-in-a-data-frame-from-lagged-records-of-same-column%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
1
zoo::na.locfgoogle– Andre Elrico
Nov 22 at 9:37
@AndreElrico Thank you. It helped a lot.
– Anil Kumar
Nov 22 at 10:01
1
to help you even more: Before using
zoo::na.locfreplace in colDispatched_seqNA with "NA_placeholder", "empty cells" with NA-Object. Then usezoo::na.locf. Now turn "NA_placeholder" back into NA-Object.– Andre Elrico
Nov 22 at 10:04