Articles in this section

How to Merge Data Files Using the Displayr API

  • Updated
Follow

This article describes how to use Displayr's API to merge two data files and import the updated data file into an existing Displayr document. 

In this example, the API merges a data set saved in a Displayr document containing 699 respondents with another data set containing 20 respondents. Finally, the API updates the Displayr document with the merged data set containing 719 respondents. 

mceclip0.png

Requirements

Method

  1. Click here to download the appenddata zip file.
  2. Double-click on the file to open it.

  3. The zip file contains a data file (PhoneExtra.sav) and a Python script for merging (appenddata.py). 

    Save both files somewhere on your computer or network.
  4. Open the appenddata.py file using a text editor (eg Notepad if using Windows).
  5. OPTIONAL: On line 6, update host_name if you are an Enterprise user with a region-specific server location. This can be copied from your Displayr URL.
  6. On line 26, replace insert-document-secret with the document secret. 
  7. On line 29 replace current-file-name with the name of the file used in the document; in this example, it's called Phone.sav. You can find the name of the data set in the Data Sets tree of your existing Document. 
  8. On line 32 replace extra-data-file-name with the name of the file containing the additional data; in this example, it's called PhoneExtra.sav.
  9. Save and close the file.
  10. Run the script, as described in How to Get Started with the Displayr API.

See Also

How to Get Started with the Displayr API

How to Obtain the Document Secret for Use in the Displayr API

How to Import Data via the Displayr API

 

Related articles