Merge problems in R: Error in fix.by(by.x, x) : ‘by’ must specify uniquely valid columns

I have two tables, both of which are aggregate outputs. I’d like to merge them together – they were both aggregated off the same data, so they have the same column names, but for the sake of edification I thought I’d try the specific by.x and by.y methods in the examples of ?merge.

merge(medA,countA, 
      by = c("manager_id", "manager_name", "grouping"))
## this works

merge(medA,countA, 
  by.x = c(medA$manager_id, medA$manager_name, medA$grouping), 
  by.y = c(countA$manager_id, countA$manager_name, countA$grouping))
## this doesn't? 
## Error in fix.by(by.x, x) : 'by' must specify uniquely valid columns

It isn’t particularly pressing: I can just use the merge that works. But I’m honestly confused why specific by.x and by.y doesn’t work. I’ve googled around for it, but I can’t seem to find similar problems. Any thoughts you guys have would be much appreciated.

Related Posts:

  1. How to merge branch to master?
  2. How do I merge two dictionaries in a single expression (taking union of dictionaries)?
  3. Merging dataframes on index with pandas
  4. The following untracked working tree files would be overwritten by merge, but I don’t care
  5. The following untracked working tree files would be overwritten by merge, but I don’t care
  6. merge one local branch into another local branch
  7. Python: pandas merge multiple dataframes
  8. What is the difference between `git merge` and `git merge –no-ff`?
  9. The following untracked working tree files would be overwritten by merge, but I don’t care
  10. Merge r brings error “‘by’ must specify uniquely valid columns”
  11. Git merge with force overwrite
  12. Updates were rejected because the remote contains work that you do not have locally
  13. Merge / convert multiple PDF files into one PDF
  14. Why does Git say my master branch is “already up to date” even though it is not?
  15. How to resolve git status “Unmerged paths:”?
  16. R: Paste two strings without space
  17. How do you merge two Git repositories?
  18. Git merge reports “Already up-to-date” though there is a difference
  19. How to merge a specific commit in Git
  20. difference between git merge origin/master and git pull
  21. Eclipse EGit Checkout conflict with files: – EGit doesn’t want to continue
  22. What’s a good (free) visual merge tool for Git? (on windows)

Leave a Comment

techhipbettruvabetnorabahisbahis forumutaraftarium24edusedusedueduseduedueduedusedusedus