Dataset Merger Window

    The window gives you the opportunity to merge two or more datasets (csv files)

    ArrayMiner will generate a csv file with as many experiments as there are in all the selected files.

Example :

Dataset 1
Expalpha Description Expalpha1 Expalpha2
alpha1 neuro 0.5 0.2
alpha2   0.1 -0.3
alpha3 neuro 0.7 -0.1
alpha4 cell cyle   0.7
Dataset2
Expalpha Description Expbeta1 Expbeta2 Expbeta3
beta1 cell cyle 1.2 -0.3 0.4
alpha1 neuro -0.5 0.2 0.2
alpha2 cell division 0.4 0.5 0.7
beta2 cell cyle -0.3 0.8 -0.8

Merged Dataset
Expalpha|Experiment Description Expalpha1|Temp1.csv Expalpha2|Temp1.csv Expbeta1|Temp2.csv Expbeta2|Temp2.csv Expbeta3|Temp2.csv
alpha1 neuro 0.5 0.2 -0.5 0.2 0.2
alpha2 cell division 0.1 -0.3 0.4 0.5 0.7
alpha3 neuro 0.7 -0.1      
alpha4 cell cyle   0.7      
beta1 cell cyle     1.2 -0.3 0.4
beta2 cell cyle     -0.3 0.8 -0.8


Note : Empty (missing) value cells are colored in light cyan.

Merge Procedure

    An array of all gene identifiers present in all files is built. The first gene in array is selected. If a non-empty description field for this gene is found in the first file, then it is taken as the description of the gene, else a non-empty description field is searched in the other files (exemple: alpha2). The experiments values are then added. If a dataset does not contain the gene, the experiment fields of this dataset are filled with empty cells (missing values. Examples: alpha3,alpha4,beta1,beta2). The second gene in the array is selected, and the whole process is repeated until there is no gene left.