This article describes how to add a category for the value attributes using the Displayr API.
Sometimes a variable in a data set will be missing a category (e.g., maybe nobody said "not aware" for Coke). If using a rich data file format, such as an SPSS data file, this is not a problem, as the categories are included in the metadata. However, if using text, CSV, Excel, or SQL query, the value attributes are automatically constructed from the data. If the data does not contain 'will exclude the non-used category', it can be useful to add the category to the value attributes. This post describes how to do this using the API.
This works by coping and modifying the existing variable (you can't change the raw variable itself).
- An Enterprise Displayr license with purchased View hours.
- Before proceeding you should perform everything in the following articles:
Getting Started with the Displayr API
How to Obtain the Document Secret for use in the Displayr API
Step 1: Download the addcategory.zip file
- Click here to download the zip file
- Double-click on it to open it
- Save its contents somewhere on your computer or network
The zip file contains:
- A file called addcategory.QScript which contains a QScript for adding a category to the Gender variable set (note that variable sets are referred to as questions in QScript) and creates a page with a table on it showing a summary of the new variable
- A file called addcategory.py which contains a Python script for running the QScript
Step 2: Edit and run the addcategory.py
- Open the file in a text editor
- On line 20, replace insert-document-secret with the document secret (as described above)
- Save the file
- Run the addcategory.py script using the process in Step 3 of Getting Started with the Displayr API
- Check out the new page for Gender that has been added to your document
How to Get Started with the Displayr API
How to Obtain the Document Secret
How to Merge Data Files Using the Displayr API
Article is closed for comments.