This article describes how to delete observations, also known as cases or respondents, from a data set.
Requirements
- A Displayr document with an imported data file in your Data Sets tree.
- To edit, insert or delete data, you will need to first select your data set in the Data Sets tree and set the Unique identifier in the object inspector to your unique ID variable or [Use case number].
Method - Removing cases from the raw data using an existing filter
- Select the name of your data set from the Data Sets tree.
- Go to the object inspector > Properties > GENERAL > Unique identifier and select a variable with unique values, or select [Use case number].
-
Select any variables in your Data Sets tree that you wish to view as raw data, and right-click > View in Data Editor.
-
Select your filter variable in the Filter dropdown so that all the rows selected by the filter will appear in green. Here, we have applied our North filter while showing our Location (S3) data:
-
Right-click the row header > Delete Row(s) Matching Filter to delete these cases from your data set.
- OPTIONAL: You can return deleted cases to your data set by going back to the Data Editor and right-clicking the row header > Undelete All Rows.
Method - Removing cases from the raw data using the raw data editor
- Select the name of your data set from the Data Sets tree.
- Go to the object inspector > Properties > GENERAL > Unique identifier and select a variable with unique values, or select [Use case number].
- Select one or more variables (or combined variable set) in the Data Sets tree, then right-click and select View in Data Editor.
-
To delete an individual row:
- Click the row header and select Delete Row(s). For example:
To delete multiple rows, Ctrl-click each row individually to add them, or Shift-click to select a range of rows, and then right-click in a selected row and select Delete Row(s).
- Click the row header and select Delete Row(s). For example:
- OPTIONAL: You can return deleted cases to your data set by going back to the Data Editor and right-clicking the row header > Undelete All Rows.
Next
How to Tag a Variable as a Filter
How to Delete Variables from Your Data Set
Comments
0 comments
Article is closed for comments.