Difference between revisions of "Orange: Select Rows"

From OnnoWiki
Jump to navigation Jump to search
Line 3: Line 3:
 
Selects data instances based on conditions over data features.
 
Selects data instances based on conditions over data features.
  
Inputs
+
==Input
  
    Data: input dataset
+
Data: input dataset
  
Outputs
+
==Output==
  
    Matching Data: instances that match the conditions
+
Matching Data: instances that match the conditions
 
+
Non-Matching Data: instances that do not match the conditions
    Non-Matching Data: instances that do not match the conditions
+
Data: data with an additional column showing whether a instance is selected
 
 
    Data: data with an additional column showing whether a instance is selected
 
  
 
This widget selects a subset from an input dataset, based on user-defined conditions. Instances that match the selection rule are placed in the output Matching Data channel.
 
This widget selects a subset from an input dataset, based on user-defined conditions. Instances that match the selection rule are placed in the output Matching Data channel.
Line 23: Line 21:
 
[[File:SelectRows-stamped.png|center|600px|thumb]]
 
[[File:SelectRows-stamped.png|center|600px|thumb]]
  
    Conditions you want to apply, their operators and related values
+
# Conditions you want to apply, their operators and related values
 
+
# Add a new condition to the list of conditions.
    Add a new condition to the list of conditions.
+
# Add all the possible variables at once.
 
+
# Remove all the listed variables at once.
    Add all the possible variables at once.
+
# Information on the input dataset and information on instances that match the condition(s)
 
+
# Purge the output data.
    Remove all the listed variables at once.
+
# When the Send automatically box is ticked, all changes will be automatically communicated to other widgets.
 
+
# Produce a report.
    Information on the input dataset and information on instances that match the condition(s)
 
 
 
    Purge the output data.
 
 
 
    When the Send automatically box is ticked, all changes will be automatically communicated to other widgets.
 
 
 
    Produce a report.
 
  
 
Any change in the composition of the condition will update the information pane (Data Out).
 
Any change in the composition of the condition will update the information pane (Data Out).
  
 
If Send automatically is selected, then the output is updated on any change in the composition of the condition or any of its terms.
 
If Send automatically is selected, then the output is updated on any change in the composition of the condition or any of its terms.
Example
+
 
 +
==Contoh==
  
 
In the workflow below, we used the Zoo data from the File widget and fed it into the Select Rows widget. In the widget, we chose to output only two animal types, namely fish and reptiles. We can inspect both the original dataset and the dataset with selected rows in the Data Table widget.
 
In the workflow below, we used the Zoo data from the File widget and fed it into the Select Rows widget. In the widget, we chose to output only two animal types, namely fish and reptiles. We can inspect both the original dataset and the dataset with selected rows in the Data Table widget.

Revision as of 10:20, 10 January 2020

Sumber: https://docs.biolab.si//3/visual-programming/widgets/data/selectrows.html

Selects data instances based on conditions over data features.

==Input

Data: input dataset

Output

Matching Data: instances that match the conditions
Non-Matching Data: instances that do not match the conditions
Data: data with an additional column showing whether a instance is selected

This widget selects a subset from an input dataset, based on user-defined conditions. Instances that match the selection rule are placed in the output Matching Data channel.

Criteria for data selection are presented as a collection of conjunct terms (i.e. selected items are those matching all the terms in ‘Conditions’).

Condition terms are defined through selecting an attribute, selecting an operator from a list of operators, and, if needed, defining the value to be used in the condition term. Operators are different for discrete, continuous and string attributes.

SelectRows-stamped.png
  1. Conditions you want to apply, their operators and related values
  2. Add a new condition to the list of conditions.
  3. Add all the possible variables at once.
  4. Remove all the listed variables at once.
  5. Information on the input dataset and information on instances that match the condition(s)
  6. Purge the output data.
  7. When the Send automatically box is ticked, all changes will be automatically communicated to other widgets.
  8. Produce a report.

Any change in the composition of the condition will update the information pane (Data Out).

If Send automatically is selected, then the output is updated on any change in the composition of the condition or any of its terms.

Contoh

In the workflow below, we used the Zoo data from the File widget and fed it into the Select Rows widget. In the widget, we chose to output only two animal types, namely fish and reptiles. We can inspect both the original dataset and the dataset with selected rows in the Data Table widget.

SelectRows-Example.png

In the next example, we used the data from the Titanic dataset and similarly fed it into the Box Plot widget. We first observed the entire dataset based on survival. Then we selected only first class passengers in the Select Rows widget and fed it again into the Box Plot. There we could see all the first class passengers listed by their survival rate and grouped by gender.

SelectRows-Workflow.png



Refensi

Pranala Menarik