UPCOMING WEBINAR: Run Research Your Way With AI Skills Register now >>

Articles in this section

How to Merge Data Sets With Different Cases/Records via the Displayr Cloud Drive Using R

  • Updated
Follow

This article describes how to merge two data files into a single data set.

Requirements

  • A professional user license.
  • If the relevant files are located within a Displayr Cloud Drive folder with configured access, ensure your document also has access to this folder by including the user groups that can access it in either the permissions of the document's folder or the document itself. See How to Manage User Groups and Permissions in Displayr and How to Use the Displayr Cloud Drive for more details.
  • A Displayr document with two loaded data sets in your Data Sources tree that have the same structure and column names for the data to merge, but different records
  • A raw data table for each data set as per the steps outlined in How to Create a Raw Data Table From Variable(s)

mceclip0.png

Method

Step 1: Export data sets to the Cloud Drive

1. In the toolbar, go to Calculation 26UI_Calculation.png > Custom Code.

2. Click on the page to place the custom calculation.

3. Use the R code below to save both files to the Cloud Drive as ".rds" files:

library(flipAPI)
QSaveData(wave1,"data.wave1.rds")
QSaveData(wave2,"data.wave2.rds")

In this example, my raw data tables are called wave1 and wave2, with the saved rds files exported as data.wave1.rds and data.wave1.rds, respectively.

Step 2: Import and merge data sets from the Cloud Drive

1. Go to Data Sources > Plus (+) > R to add a new R data set.

2. Enter a name for the data set under Name.

3. Update and input the below R code where it states "Enter your R code here":

library(flipAPI)
w1 = QLoadData("data.wave1.rds")
w2 = QLoadData("data.wave2.rds")

merged = merge(w1,w2,all=TRUE)

This code loads both previously exported data sets and then merges them together using the merge function. Note, you must have the exact same format and column name when merging cases into the same column of data. By using the all=TRUE argument, it ensures the merge will also add any additional columns of data between the files.

3. Give the merged file a Name and click OK.

4. R doesn’t have the same level of metadata as some file types, like SSS and SAV. For example, variables in an R data frame do not have the concept of both Name and Label. Remember to add such information after you have added your data set.

Next

How to Use the Displayr Cloud Drive

How to Access the Displayr Cloud Drive Using R

How to Create a Raw Data Table From Variable(s)

Related articles