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:31]
lornage [Input]
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 ====
Line 51: Line 53:
 ''​Group by column:''​ c1 \\  ''​Group by column:''​ c1 \\ 
 ''​Ignore case while grouping?:''​ YES \\  ''​Ignore case while grouping?:''​ YES \\ 
-**Operations**\\ ​ 
 Operation 1 \\  Operation 1 \\ 
 ''​Type:''​ Minimum \\  ''​Type:''​ Minimum \\ 
Line 58: Line 59:
  
 With file_group.txt containing: \\  With file_group.txt containing: \\ 
-{{:workgroup:​doc_groupinput.png?​195|}}+{{:doc:​doc_groupinput.png?​195|}}
  
 ==== Output ==== ==== Output ====
 +{{:​doc:​doc_groupoutput.png?​95|}}
  
-{{:workgroup:​doc_groupoutput.png?​95|}}+__**EXAMPLE 2:**__ 
 +==== Input ====
  
 +''​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
  
 +With file_group.txt containing: \\ 
 +{{:​doc:​doc_groupinput.png?​195|}}
  
 +==== Output ====
  
-Example of **concatenation**: ​{{:workgroup:​doc_conca.png?​95|}}+{{:doc:​doc_conca.png?​115|}}
 ===== Edited on ===== ===== Edited on =====
 July 23rd, 2014  July 23rd, 2014 
doc/group.1406298694.txt.gz · Last modified: 2014/07/25 16:31 by lornage