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,0907922
asked Nov 19 at 19:11
v1983
1
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,0907922
asked Nov 19 at 19:11
v1983
1
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
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,0907922
asked Nov 19 at 19:11
v1983
1
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,0907922
asked Nov 19 at 19:11
v1983
1
edited Nov 19 at 23:45
Mihai Chelaru
2,0907922
asked Nov 19 at 19:11
v1983
1
edited Nov 19 at 23:45
Mihai Chelaru
2,0907922
edited Nov 19 at 23:45
Mihai Chelaru
2,0907922
edited Nov 19 at 23:45
Mihai Chelaru
2,0907922
2,0907922
asked Nov 19 at 19:11
v1983
1
asked Nov 19 at 19:11
v1983
1
asked Nov 19 at 19:11
v1983
1
1
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
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
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
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%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