5. Subset
Extract the data that meet specific conditions from Data Frame.
Last updated
Extract the data that meet specific conditions from Data Frame.
Last updated
Click the Subset in the Data Analysis category.
Data Frame: Select the data frame you want to use for your work.
Make a copy: Check if you don't want the operation to affect the original data frame.
Method: Select a method to specify which rows or columns the action will be applied to.
Allocate to: Specify the name of the variable where the results of your work will be stored.
Row Subset: Select the rows you want to work with.
Slicing: Extract rows by specifying a range.
Condition: Specify the range of rows based on a condition.
Indexing: Manually select the desired rows.
Column Subset: Select the columns you want to work with.
Indexing: Manually extract the desired columns.
Slicing: Specify the range of columns to extract.
Code View: Preview the code that will be output.
Data View: Preview the output that will be printed.
Run: Print and run the code.