I want to merge 81 data frames. Each data frame consists of an snpID column, which is more or less similar across the data frames. In the merged data frame, I want the 2nd column to be the 2nd column of the 1st data frame, the 3rd column to be the 2nd column of the 2nd data frame, and so on, until the 2nd column of the 81st data frame.

I have two data frames corresponding to a specific individual. What I want is to merge these data frames into one in such a way that the first column of both data frames will be merged, considering their similarity. The second column will correspond to the count of the first data frame, and the third column will correspond to the count of the second data frame. How do i do this in rstudio?