Gregg Powell
2021-Jun-13 21:28 UTC
[R] Need to compare two columns in two data.frames and return all rows from df where rows values are missing
This is even complicated to write into a question.... Have two data.frames (A and B) data.frame A and B each have a name column. Want to compare A and B data.frame to each other based on the values in the 'names' columns - for every name that appears in dataframe A? but not B, I want to copy the corresponding rows to a third dataframe C, and for every name that appears in B but not A, I want to copy the corresponding rows to a fourth dataframe D. I can then row bind the dataframes C and D together and get a complete list of all the rows that were missing in either A or B. try as I might - I can't get this to work. Can someone help P-L-E-A-S-E!!!! Thanks, Gregg Powell AZ, USA -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 509 bytes Desc: OpenPGP digital signature URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20210613/3f8c5da8/attachment.sig>
Gregg Powell
2021-Jun-13 21:30 UTC
[R] Need to compare two columns in two data.frames and return all rows from df where rows values are missing
This is even complicated to write into a question.... Have two data.frames (A and B) data.frame A and B each have a name column. Want to compare A and B data.frame to each other based on the values in the 'names' columns - for every name that appears in dataframe A? but not B, I want to copy the corresponding rows to a third dataframe C, and for every name that appears in B but not A, I want to copy the corresponding rows to a fourth dataframe D. I can then row bind the dataframes C and D together and get a complete list of all the rows that were missing in either A or B. try as I might - I can't get this to work. Can someone help P-L-E-A-S-E!!!! Thanks, Gregg Powell AZ, USA -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 509 bytes Desc: OpenPGP digital signature URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20210613/96ea49b3/attachment.sig>
Bert Gunter
2021-Jun-13 22:53 UTC
[R] Need to compare two columns in two data.frames and return all rows from df where rows values are missing
As always, a reprex would considerably improve the chances of a useful reply... See the posting guide linked below. Bert Gunter "The trouble with having an open mind is that people keep coming along and sticking things into it." -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip ) On Sun, Jun 13, 2021 at 2:28 PM Gregg Powell via R-help < r-help at r-project.org> wrote:> This is even complicated to write into a question.... > > Have two data.frames (A and B) > > data.frame A and B each have a name column. Want to compare A and B > data.frame to each other based on the values in the 'names' columns - for > every name that appears in dataframe A but not B, I want to copy the > corresponding rows to a third dataframe C, and for every name that appears > in B but not A, I want to copy the corresponding rows to a fourth dataframe > D. I can then row bind the dataframes C and D together and get a complete > list of all the rows that were missing in either A or B. > > try as I might - I can't get this to work. Can someone help P-L-E-A-S-E!!!! > > Thanks, > Gregg Powell > AZ, USA______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >[[alternative HTML version deleted]]