0

I'm fairly new to R and have been working to organize and clean my data to prepare for analysis. I'm trying to combine repeated measures data (dataCAL) with one-time initial survey data (dataI) by ID without duplicating the survey data.

I used the following: dataCALc <- dplyr::left_join(dataCAL, dataI, by= "ID")

This joins my data; however, the initial survey data for each ID is copied on multiple rows if there are more than one measurement for that ID in dataCAL. This is useful for some analyses, but problematic for my descriptive stats. I've experimented with filter and distinct in dplyr, but have not yet found a solution.

HiliaryD
  • 1
  • 1
    It's easier to help you if you include a simple [reproducible example](https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example) with sample input and desired output that can be used to test and verify possible solutions. – MrFlick Feb 20 '20 at 19:45

1 Answers1

0

It can be questioned if it is helpful to merge the datasets, but I think you are looking for something like this.

library(plyr)
rbind.fill(dataCAL, datal)
maarvd
  • 1,254
  • 1
  • 4
  • 14