User Tools

Site Tools


doc:group

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
doc:group [2014/07/25 16:30]
lornage [General comments (Warning/Tips)]
doc:group [2014/11/28 17:05] (current)
slegras
Line 5: Line 5:
 2.0.0 2.0.0
 ===== Keywords ===== ===== Keywords =====
 +Group, Common field, Operation
  
 ===== Summary ===== ===== Summary =====
Line 14: Line 15:
 ===== General comments (Warning/​Tips) ===== ===== General comments (Warning/​Tips) =====
  
-If your data is not TAB delimited, use Text Manipulation->​Convert.+If your data is not tab-delimited, use Text Manipulation->​Convert.
 ===== Input ===== ===== Input =====
   * **Select data:​**select the input file. It must be TAB delimited.   * **Select data:​**select the input file. It must be TAB delimited.
Line 22: Line 23:
   * **Ignore case while grouping?:​** you case choose either YES or NO.   * **Ignore case while grouping?:​** you case choose either YES or NO.
  
-  * **Operations** : click on add new Operation. You can add one or several operations. ​  +  * **Operations** : click on add new operation. You can add one or several operations. ​  
       * **Type:**       * **Type:**
         * **Mean**         * **Mean**
Line 32: Line 33:
         * **Count:** counts the elements in the specified column and returns an integer ​         * **Count:** counts the elements in the specified column and returns an integer ​
         * **Count Distinct:** counts the number of unique entries         * **Count Distinct:** counts the number of unique entries
-        * **Concatenate:​** takes each item in the specified column and build a comma delimited list.+        * **Concatenate:​** takes each item in the specified column and build a comma-delimited list.
         * **Concatenate Distinct:** does the same as //​Concatenate//​ but with no repeat.         * **Concatenate Distinct:** does the same as //​Concatenate//​ but with no repeat.
         * **Randomly pick** ​         * **Randomly pick** ​
Line 45: Line 46:
 The output is a grouped tab-delimited dataset. The output is a grouped tab-delimited dataset.
 ===== Example ===== ===== Example =====
 +__**EXAMPLE 1:**__ \\ 
 **Usage Example:** localizing the beginning position on chromosomes. ​ **Usage Example:** localizing the beginning position on chromosomes. ​
 ==== Input ==== ==== Input ====
  
-''​Select data:''​ file_group.txt+''​Select data:''​ file_group.txt ​\\  
 +''​Group by column:''​ c1 \\  
 +''​Ignore case while grouping?:''​ YES \\  
 +Operation 1 \\  
 +''​Type:''​ Minimum \\  
 +''​On column:''​ c2 \\  
 +''​Round result to nearest integer?:''​ YES
  
-''​Group by column:''​ c1+With file_group.txt containing\\  
 +{{:​doc:​doc_groupinput.png?​195|}}
  
-''​Ignore case while grouping?:''​ YES+==== Output ==== 
 +{{:doc:​doc_groupoutput.png?​95|}}
  
-**Operations** +__**EXAMPLE 2:**__ 
- +==== Input ====
-Operation 1 +
- +
-''​Type:''​ Minimum +
- +
-''​On column:''​ c2+
  
 +''​Select data:''​ file_group.txt \\ 
 +''​Group by column:''​ c1 \\ 
 +''​Ignore case while grouping?:''​ YES \\ 
 +Operation 1 \\ 
 +''​Type:''​ Concatenate \\ 
 +''​On column:''​ c2 \\ 
 ''​Round result to nearest integer?:''​ YES ''​Round result to nearest integer?:''​ YES
  
 With file_group.txt containing: \\  With file_group.txt containing: \\ 
-{{:workgroup:​doc_groupinput.png?​195|}}+{{:doc:​doc_groupinput.png?​195|}}
  
 ==== Output ==== ==== Output ====
  
-{{:workgroup:​doc_groupoutput.png?​95|}} +{{:doc:​doc_conca.png?​115|}}
- +
- +
- +
- +
-Example of **concatenation**:​ {{:​workgroup:​doc_conca.png?​95|}}+
 ===== Edited on ===== ===== Edited on =====
 July 23rd, 2014  July 23rd, 2014 
doc/group.1406298604.txt.gz · Last modified: 2014/07/25 16:30 by lornage