Two tables merging






Select a file *  Example

Select a file *  Example


  Email me when task completed.

 The number of coins consumed at one time is 0



Function:
Two input tables will be merged into one and 4 different merging types are provided.


Input:
Input two tab delimited text files with headers. If your data is not TAB delimited, you can use Excel to convert it.


Parameters:
4 merging types are provided including inner join, left join, right join and full join.

①Inner join: merge the lines with same row names in two tables.

②Left join: Using table 1 as major table, and table 2 as match table. Default value will be returned for the unmatched lines in table2.

③Right join: Using table 2 as major table, and table 1 as match table. Default value will be returned for the unmatched lines in table1.

④Full join: output all the lines existing in two tables. When one lines of one tables does not exist in another table, default value will be returned.

⑤Default value: when the information is exiting in one tables but missing in another, the defalut value will be filled into the merged table.


Output:
A merged table will be output in txt format. The first line of the table is header.

Example file (right click to download):file1  file2

There are two tables here. Table1 contains the data of gene expression, and table2 contains information of gene annotation. The first column of both tables are gene ID. Through table merging, the gene expression and annotation information will be merged into one table.


Table 1:
geneID root_exp leave_exp
Unigene01 16.4798 3.3122
Unigene02 44.5027 24.1932
Unigene03 86.9566 43.0663
Table 2:
geneID KO_id ko_definition
Unigene02 K10592 E3 ubiquitin-protein ligase HUWE1
Unigene03 K10592 NADH dehydrogenase I subunit 4
Unigene04 K05579 dehydrogenase I subunit 7
Inner join results:
geneID root_exp leave_exp KO_id ko_definition
Unigene02 44.5027 24.1932 K10592 E3 ubiquitin-protein ligase HUWE1
Unigene03 86.9566 43.0663 K10592 NADH dehydrogenase I subunit 4
Left join results:
geneID root_exp leave_exp KO_id ko_definition
Unigene01 16.4798 3.3122 -- --
Unigene02 44.5027 24.1932 K10592 E3 ubiquitin-protein ligase HUWE1
Unigene03 86.9566 43.0663 K10592 NADH dehydrogenase I subunit 4
Right join results:
geneID root_exp leave_exp KO_id ko_definition
Unigene02 44.5027 24.1932 K10592 E3 ubiquitin-protein ligase HUWE1
Unigene03 86.9566 43.0663 K10592 NADH dehydrogenase I subunit 4
Unigene04 -- -- K05579 dehydrogenase I subunit 7
All join results:
geneID root_exp leave_exp KO_id ko_definition
Unigene01 16.4798 3.3122 -- --
Unigene02 44.5027 24.1932 K10592 E3 ubiquitin-protein ligase HUWE1
Unigene03 86.9566 43.0663 K10592 NADH dehydrogenase I subunit 4
Unigene04 -- -- K05579 dehydrogenase I subunit 7