duplicate row values for same ID
up vote
0
down vote
favorite
I have looked at the various threads and sadly the answers provided are not working. I am merging two files. Both files have common column names. I want the two data sets to merge for the same time point, however when I use the command s3<-merge(s1,s2,all=TRUE), it gives me a file as follows:
I would like the duplicate time points to be removed.
If I use s3<-merge(s1,s2,all.x=TRUE), then none of the data from s2 gets merged.
When reading the data file I am using s2<-read.csv('X.csv',stringsAsFactors=FALSE).
I don't know where I am going wrong.
r rstudio
edited Nov 19 at 23:45
Mihai Chelaru
2,14071022
asked Nov 19 at 19:11
v1983
61
add a comment |
up vote
0
down vote
favorite
I have looked at the various threads and sadly the answers provided are not working. I am merging two files. Both files have common column names. I want the two data sets to merge for the same time point, however when I use the command s3<-merge(s1,s2,all=TRUE), it gives me a file as follows:
I would like the duplicate time points to be removed.
If I use s3<-merge(s1,s2,all.x=TRUE), then none of the data from s2 gets merged.
When reading the data file I am using s2<-read.csv('X.csv',stringsAsFactors=FALSE).
I don't know where I am going wrong.
r rstudio
edited Nov 19 at 23:45
Mihai Chelaru
2,14071022
asked Nov 19 at 19:11
v1983
61
2
Please edit your question to include reproducible data and code.
– Jan Boyer
Nov 19 at 19:14
How aboutmerge(merge(df1, df2, by='id', all=T), df3, by='id', all=T)? or usecbindmethod.
– kon_u
Nov 20 at 10:36
actually let me re phrase - so ultimately what i want is this - for the same ID, i want to time match different columns
– v1983
2 days ago
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have looked at the various threads and sadly the answers provided are not working. I am merging two files. Both files have common column names. I want the two data sets to merge for the same time point, however when I use the command s3<-merge(s1,s2,all=TRUE), it gives me a file as follows:
I would like the duplicate time points to be removed.
If I use s3<-merge(s1,s2,all.x=TRUE), then none of the data from s2 gets merged.
When reading the data file I am using s2<-read.csv('X.csv',stringsAsFactors=FALSE).
I don't know where I am going wrong.
r rstudio
edited Nov 19 at 23:45
Mihai Chelaru
2,14071022
asked Nov 19 at 19:11
v1983
61
I have looked at the various threads and sadly the answers provided are not working. I am merging two files. Both files have common column names. I want the two data sets to merge for the same time point, however when I use the command s3<-merge(s1,s2,all=TRUE), it gives me a file as follows:
I would like the duplicate time points to be removed.
If I use s3<-merge(s1,s2,all.x=TRUE), then none of the data from s2 gets merged.
When reading the data file I am using s2<-read.csv('X.csv',stringsAsFactors=FALSE).
I don't know where I am going wrong.
r rstudio
r rstudio
edited Nov 19 at 23:45
Mihai Chelaru
2,14071022
asked Nov 19 at 19:11
v1983
61
edited Nov 19 at 23:45
Mihai Chelaru
2,14071022
asked Nov 19 at 19:11
v1983
61
edited Nov 19 at 23:45
Mihai Chelaru
2,14071022
edited Nov 19 at 23:45
Mihai Chelaru
2,14071022
edited Nov 19 at 23:45
Mihai Chelaru
2,14071022
2,14071022
asked Nov 19 at 19:11
v1983
61
asked Nov 19 at 19:11
v1983
61
asked Nov 19 at 19:11
v1983
61
61
2
Please edit your question to include reproducible data and code.
– Jan Boyer
Nov 19 at 19:14
How aboutmerge(merge(df1, df2, by='id', all=T), df3, by='id', all=T)? or usecbindmethod.
– kon_u
Nov 20 at 10:36
actually let me re phrase - so ultimately what i want is this - for the same ID, i want to time match different columns
– v1983
2 days ago
add a comment |
2
Please edit your question to include reproducible data and code.
– Jan Boyer
Nov 19 at 19:14
How aboutmerge(merge(df1, df2, by='id', all=T), df3, by='id', all=T)? or usecbindmethod.
– kon_u
Nov 20 at 10:36
actually let me re phrase - so ultimately what i want is this - for the same ID, i want to time match different columns
– v1983
2 days ago
2
2
Please edit your question to include reproducible data and code.
– Jan Boyer
Nov 19 at 19:14
Please edit your question to include reproducible data and code.
– Jan Boyer
Nov 19 at 19:14
How about
merge(merge(df1, df2, by='id', all=T), df3, by='id', all=T)? or use cbind method.– kon_u
Nov 20 at 10:36
How about
merge(merge(df1, df2, by='id', all=T), df3, by='id', all=T)? or use cbind method.– kon_u
Nov 20 at 10:36
actually let me re phrase - so ultimately what i want is this - for the same ID, i want to time match different columns
– v1983
2 days ago
actually let me re phrase - so ultimately what i want is this - for the same ID, i want to time match different columns
– v1983
2 days ago
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',
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%2f53381141%2fduplicate-row-values-for-same-id%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%2f53381141%2fduplicate-row-values-for-same-id%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
2
Please edit your question to include reproducible data and code.
– Jan Boyer
Nov 19 at 19:14
How about
merge(merge(df1, df2, by='id', all=T), df3, by='id', all=T)? or usecbindmethod.– kon_u
Nov 20 at 10:36
actually let me re phrase - so ultimately what i want is this - for the same ID, i want to time match different columns
– v1983
2 days ago