Difference between revisions of "Orange: Concatenate"

From OnnoWiki
Jump to navigation Jump to search
(Created page with "Sumber: https://docs.biolab.si//3/visual-programming/widgets/data/concatenate.html Concatenates data from multiple sources. Inputs Primary Data: data set that defines...")
 
Line 16: Line 16:
 
The widget concatenates multiple sets of instances (data sets). The merge is “vertical”, in a sense that two sets of 10 and 5 instances yield a new set of 15 instances.
 
The widget concatenates multiple sets of instances (data sets). The merge is “vertical”, in a sense that two sets of 10 and 5 instances yield a new set of 15 instances.
  
../../_images/Concatenate-stamped.png
+
[[File:Concatenate-stamped.png|center|200px|thumb]]
  
 
     Set the attribute merging method.
 
     Set the attribute merging method.
Line 33: Line 33:
 
Below, we used a modified Zoo data set. In the first File widget, we loaded only the animals beginning with the letters A and B and in the second one only the animals beginning with the letter C. Upon concatenation, we observe the new data in the Data Table widget, where we see the complete table with animals from A to C.
 
Below, we used a modified Zoo data set. In the first File widget, we loaded only the animals beginning with the letters A and B and in the second one only the animals beginning with the letter C. Upon concatenation, we observe the new data in the Data Table widget, where we see the complete table with animals from A to C.
  
../../_images/Concatenate-Example.png
+
[[File:Concatenate-Example.png|center|200px|thumb]]
 +
 
  
  

Revision as of 11:32, 21 January 2020

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


Concatenates data from multiple sources.

Inputs

   Primary Data: data set that defines the attribute set
   Additional Data: additional data set

Outputs

   Data: concatenated data

The widget concatenates multiple sets of instances (data sets). The merge is “vertical”, in a sense that two sets of 10 and 5 instances yield a new set of 15 instances.

Concatenate-stamped.png
   Set the attribute merging method.
   Add the identification of source data sets to the output data set.
   Produce a report.
   If Apply automatically is ticked, changes are communicated automatically. Otherwise, click Apply.

If one of the tables is connected to the widget as the primary table, the resulting table will contain its own attributes. If there is no primary table, the attributes can be either a union of all attributes that appear in the tables specified as Additional Tables, or their intersection, that is, a list of attributes common to all the connected tables. Example

As shown below, the widget can be used for merging data from two separate files. Let’s say we have two data sets with the same attributes, one containing instances from the first experiment and the other instances from the second experiment and we wish to join the two data tables together. We use the Concatenate widget to merge the data sets by attributes (appending new rows under existing attributes).

Below, we used a modified Zoo data set. In the first File widget, we loaded only the animals beginning with the letters A and B and in the second one only the animals beginning with the letter C. Upon concatenation, we observe the new data in the Data Table widget, where we see the complete table with animals from A to C.

Concatenate-Example.png




Referensi

Pranala Menarik