annotate concatenation.R @ 0:c577f13705f2 draft default tip

planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
author workflow4metabolomics
date Wed, 10 Jul 2024 15:20:11 +0000
parents
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
1 if (FALSE) {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
2 rm(list = ls())
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
3
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
4 DM1 <- data.frame(data = c("5d_-kkcùf", "npèt", "5PY4(*3"),
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
5 `j 785` = c(0.356426723610756, 0.801750949101246, 0.875199970420953),
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
6 `y54j 68y4j6` = c(0.380152310071702, 0.535593104115636, 0.0825428101366147),
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
7 `5-6 4` = c(0.0306944207412024, 0.258351312473067, 0.253659010703906),
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
8 hrrrrh = c(0.334137638848017, 0.599475573145688, 0.507762246807195),
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
9 `5h -` = c(0.298147485608469, 0.0763319665667417, 0.856444177031262))
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
10
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
11 DM2 <- data.frame(data = c("5d_-kkcùf", "npèt", "5PY4(*3"),
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
12 `j 785` = c(0.356426723610756, 0.801750949101246, 0.875199970420953),
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
13 `y54j 68y4j6` = c(0.380152310071702, 0.535593104115636, 0.0825428101366147),
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
14 `5-6 4` = c(0.0306944207412024, 0.258351312473067, 0.253659010703906),
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
15 hrrrrh = c(0.334137638848017, 0.599475573145688, 0.507762246807195),
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
16 `5h -` = c(0.298147485608469, 0.0763319665667417, 0.856444177031262))
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
17
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
18 M1 <- data.frame(samplename = c("j 785", "y54j 68y4j6", "5-6 4", "hrrrrh", "5h -"),
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
19 ABD = c(19, 24, 2, 3, "y"), E = c(9, "p0", 45, 24, 29),
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
20 AAA = c("r", "bg", "il", "d", "b"),
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
21 fp = c("pj", "z", "e", "r", "t"),
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
22 uv = c("s", "d", "f", "s", "d"))
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
23
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
24 M2 <- data.frame(samplename = c("j 785", "y54j 68y4j6", "5-6 4", "hrrrrh", "5h -"),
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
25 ABD = c(19, 24, 2, 3, "y"), E = c(9, "ici", 45, 24, 29),
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
26 AAA = c("r", "bg", "il", "d", "b"),
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
27 fp = c("pj", "z", "e", "r", "t"),
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
28 uv = c("s", "d", "f", "s", "d"))
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
29 type <- "sample"
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
30 concatenation <- "unique"
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
31 tab1 <- "tab1"
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
32 tab2 <- "tab2"
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
33 choice_keep <- "oui"
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
34 keep <- 0
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
35 concat(DM1, M1, DM2, M2, type, tab1, tab2, concatenation, choice_keep, keep)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
36 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
37
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
38 #################################################################################################################
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
39
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
40
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
41 concat <- function(DM1, M1, DM2, M2, type, tab1, tab2, concatenation, choice_keep, keep) {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
42
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
43
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
44
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
45 #DM1/DM2 = data.frame containing data Matrix
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
46 #M1/M2 = data.frame containing sample Metadata or variable Metadata
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
47 #type = "sample" or "variable" depending on Metadata content
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
48 #tab1/tab2 = Suffix for Metadata 1/2
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
49 #concatenation = type of concatenation
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
50 #choice_keep = choice of keeping columns with the same no or keeping just one
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
51 #keep = keep the column in M1 or M2
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
52 #returns the concatenated metadata and the two Data Matrix
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
53
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
54 identifiers_1 <- colnames(M1)[1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
55 identifiers_2 <- colnames(M2)[1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
56
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
57 err.stock <- NULL
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
58
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
59 #Concatenation------------------------------------------------------------------
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
60
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
61 #If Metadatas is Sample_Metadata we transpose
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
62 if (type == "sample") {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
63
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
64 rownames(DM1) <- DM1[, 1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
65 corner_DM1 <- colnames(DM1)[1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
66 DM1 <- DM1[, -1, drop = FALSE]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
67 DM1 <- t(DM1)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
68 DM1 <- data.frame(sample = row.names(DM1), DM1, check.names = FALSE)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
69 rownames(DM1) <- NULL
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
70
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
71 rownames(DM2) <- DM2[, 1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
72 corner_DM2 <- colnames(DM2)[1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
73 DM2 <- DM2[, -1, drop = FALSE]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
74 DM2 <- t(DM2)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
75 DM2 <- data.frame(sample = row.names(DM2), DM2, check.names = FALSE)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
76 rownames(DM2) <- NULL
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
77 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
78
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
79 #Add order of sample and Sort by order
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
80
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
81
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
82 M1$order1 <- seq(1, nrow(M1))
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
83 M2$order2 <- seq(nrow(M1) + 1, nrow(M2) + nrow(M1))
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
84
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
85 M1_bf <- M1[order(M1[, 1]), ]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
86 M2_bf <- M2[order(M2[, 1]), ]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
87
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
88
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
89 #Check the variables in common and extract them.
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
90
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
91
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
92 same <- check_features(M1_bf, M2_bf)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
93 same <- same[- which(same == identifiers_1)]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
94
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
95 #Check that shared variables have the same values.
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
96 #If not, they are renamed or deleted according to the parameters chosen by the user.
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
97 result2 <- compare_same_columns(M1_bf, M2_bf, same, choice_keep, keep, tab1, tab2)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
98 M1 <- result2$M1
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
99 M2 <- result2$M2
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
100
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
101 #Unique--------------------------------------------------------------------------
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
102 if (concatenation == "unique") {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
103 #Table match check
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
104 #We verify that the individuals are all the same
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
105 err.stock <- match2_bis(M1, M2, type)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
106 check_err(err.stock)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
107 M_merge <- merge(M1, M2, by = 1)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
108 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
109
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
110
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
111 #Intersection--------------------------------------------------------------------
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
112
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
113 if (concatenation == "intersection") {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
114
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
115 #select individuals in common
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
116 sample_common <- intersect(M1[, 1], M2[, 1])
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
117
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
118 #if the list of individuals in common is null, an error message is sent
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
119 if (length(sample_common) == 0) {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
120 err.stock <- c(err.stock, "\nThere are no individuals in common \n")
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
121 check_err(err.stock)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
122 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
123 #if the list of individuals in common is less than 5, then a Warning message is sent
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
124 if (length(sample_common) < 5) {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
125 cat("\nWarning: Less than 5 individuals in common\n")
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
126 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
127 M_merge <- merge(M1, M2, by = 1)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
128 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
129
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
130 #Union --------------------------------------------------------------------------
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
131 if (concatenation == "union") {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
132
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
133 #select common ids
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
134 id_common <- intersect(M1[, 1], M2[, 1])
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
135
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
136 if (is.null(id_common)) {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
137 cat("\nT Warning : there are no individuals in common\n")
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
138 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
139
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
140 M2_common <- M2[M2[, 1] %in% id_common, ]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
141 #Store rows with individuals belonging only to M2
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
142 M2_specifique <- M2[! M2[, 1] %in% id_common, ]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
143 #Merge the two tables only with the samples not in common
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
144 M_merge <- bind_rows(M1, M2_specifique)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
145 col_names <- colnames(M2_common)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
146 col_names <- col_names[- which(col_names == identifiers_2)]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
147 feature_common <- check_features(M_merge, M2_bf)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
148 #Check if M_merge and M2_bf have columns in common. If so, complete the table with the values not taken.
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
149 if (!is.null(feature_common)) {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
150
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
151 identifiers_3 <- M2_specifique[, 1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
152 #We select the value in M2_bf, the M2 table before undergoing any changes, then insert it in the M_merge table.
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
153 for (feature in feature_common) {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
154 for (id in identifiers_3) {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
155
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
156 index_row <- which(M2_bf[, 1] == id)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
157 index_col <- which(colnames(M2_bf) == feature)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
158 new_value <- M2_bf[index_row, index_col]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
159 index_row <- which(M_merge[, 1] == id)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
160 index_col <- which(colnames(M_merge) == feature)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
161 M_merge[index_row, index_col] <- new_value
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
162
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
163 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
164 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
165 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
166 #Fill in the table with common values
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
167 for (col in col_names) {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
168 for (id in id_common) {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
169 index_row <- which(M2_common[, 1] == id)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
170 index_col <- which(colnames(M2_common) == col)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
171 new_value <- M2_common[index_row, index_col]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
172 index_row <- which(M_merge[, 1] == id)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
173 index_col <- which(colnames(M_merge) == col)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
174 M_merge[index_row, index_col] <- new_value
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
175
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
176 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
177 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
178 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
179 M_merge_sort <- M_merge[order(M_merge$order1, M_merge$order2), ]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
180 M_merge_sort <- M_merge_sort[, - which(colnames(M_merge_sort) == "order1")]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
181 M_merge_sort <- M_merge_sort[, - which(colnames(M_merge_sort) == "order2")]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
182 #DataMatrix ---------------------------------------------------------------------
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
183
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
184 colnames_1 <- colnames(DM1)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
185 colnames_2 <- colnames(DM2)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
186 #Unique -------------------------------------------------------------------------
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
187
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
188 if (concatenation == "unique") {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
189
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
190 if (type == "sample") {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
191
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
192 rownames(DM1) <- DM1[, 1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
193 DM1 <- DM1[, -1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
194 DM1 <- t(DM1)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
195 DM1 <- data.frame(sample = row.names(DM1), DM1, check.names = FALSE)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
196 colnames(DM1)[1] <- corner_DM1
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
197 rownames(DM1) <- NULL
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
198
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
199 rownames(DM2) <- DM2[, 1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
200 DM2 <- DM2[, -1, drop = FALSE]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
201 DM2 <- t(DM2)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
202 DM2 <- data.frame(sample = row.names(DM2), DM2, check.names = FALSE)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
203 colnames(DM2)[1] <- corner_DM2
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
204 rownames(DM2) <- NULL
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
205 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
206 result <- list(M_merge_sort = M_merge_sort, DM1 = DM1, DM2 = DM2)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
207 return(result)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
208 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
209
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
210 #Intersection--------------------------------------------------------------------
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
211
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
212 if (concatenation == "intersection") {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
213
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
214 id_in_common <- intersect(DM1[, 1], DM2[, 1])
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
215
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
216 DM1_filter <- subset(DM1, DM1[, 1] %in% id_in_common)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
217 DM2_filter <- subset(DM2, DM2[, 1] %in% id_in_common)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
218
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
219 if (type == "sample") {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
220
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
221 rownames(DM1_filter) <- DM1_filter[, 1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
222 DM1_filter <- DM1_filter[, -1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
223 DM1_filter <- t(DM1_filter)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
224 DM1_filter <- data.frame(sample = row.names(DM1_filter), DM1_filter, check.names = FALSE)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
225 colnames(DM1_filter)[1] <- corner_DM1
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
226 rownames(DM1_filter) <- NULL
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
227
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
228 rownames(DM2_filter) <- DM2_filter[, 1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
229 DM2_filter <- DM2_filter[, -1, drop = FALSE]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
230 DM2_filter <- t(DM2_filter)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
231 DM2_filter <- data.frame(sample = row.names(DM2_filter), DM2_filter, check.names = FALSE)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
232 colnames(DM2_filter)[1] <- corner_DM2
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
233 rownames(DM2_filter) <- NULL
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
234 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
235 result <- list(M_merge_sort = M_merge_sort, DM1 = DM1_filter, DM2 = DM2_filter)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
236 return(result)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
237 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
238
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
239 #Union --------------------------------------------------------------------------
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
240
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
241 if (concatenation == "union") {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
242
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
243 common_individuals <- intersect(DM1[, 1], DM2[, 1])
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
244 common_columns <- intersect(colnames_1, colnames_2)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
245 #check whether there are individuals or variables in common
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
246 if (is.null(common_individuals) || is.null(common_columns)) {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
247
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
248 comparison_result <- FALSE
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
249 #If the individuals in common take the same values for all variables, then comparison_result=TRUE
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
250 } else {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
251
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
252 DM1_common <- subset(DM1, DM1[, 1] %in% common_individuals)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
253 DM2_common <- subset(DM2, DM2[, 1] %in% common_individuals)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
254 DM1_common <- DM1_common[, common_columns, drop = FALSE]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
255 DM2_common <- DM2_common[, common_columns, drop = FALSE]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
256
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
257 for (col in common_columns) {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
258 comparison_result <- identical(DM1_common$col, DM2_common$col)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
259 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
260
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
261 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
262
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
263 if (comparison_result) {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
264
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
265
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
266 DM1$order1 <- seq(1, nrow(DM1))
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
267 DM2$order2 <- seq(nrow(DM1) + 1, nrow(DM2) + nrow(DM1))
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
268 DM1_sort <- DM1[order(DM1[, 1]), ]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
269 DM2_sort <- DM2[order(DM2[, 1]), ]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
270 id_in_common <- intersect(DM1[, 1], DM2[, 1])
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
271 DM1_filter <- subset(DM1, DM1[, 1] %in% id_in_common)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
272 DM2_filter <- subset(DM2, DM2[, 1] %in% id_in_common)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
273 different_DM2 <- colnames_2[! colnames_2 %in% colnames_1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
274 DM2_specifique <- DM2[! DM2[, 1] %in% id_in_common, ]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
275 #Merge the two tables only with the samples not in common
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
276 DM1_merge <- bind_rows(DM1, DM2_specifique)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
277
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
278
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
279 #Deletion of columns present only in DM2
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
280 DM1_merge <- DM1_merge[, ! names(DM1_merge) %in% different_DM2]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
281 different_DM1 <- colnames_1[! colnames_1 %in% colnames_2]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
282 DM1_specifique <- DM1[! DM1[, 1] %in% id_in_common, ]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
283 #Merge the two tables only with the samples not in common
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
284 DM2_merge <- bind_rows(DM2, DM1_specifique)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
285 #Deletion of columns present only in DM2
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
286 DM2_merge <- DM2_merge[, ! names(DM2_merge) %in% different_DM1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
287 #DM2_merge
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
288
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
289
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
290 DM1_merge_sort <- DM1_merge[order(DM1_merge$order1, DM1_merge$order2), ]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
291 DM1_merge_sort <- DM1_merge_sort[, - which(colnames(DM1_merge_sort) == "order1")]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
292 DM1_merge_sort <- DM1_merge_sort[, - which(colnames(DM1_merge_sort) == "order2")]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
293
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
294 DM2_merge_sort <- DM2_merge[order(DM2_merge$order1, DM2_merge$order2), ]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
295 DM2_merge_sort <- DM2_merge_sort[, - which(colnames(DM2_merge_sort) == "order1")]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
296 DM2_merge_sort <- DM2_merge_sort[, - which(colnames(DM2_merge_sort) == "order2")]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
297
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
298
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
299 if (type == "sample") {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
300
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
301 rownames(DM1_merge_sort) <- DM1_merge_sort[, 1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
302 DM1_merge_sort <- DM1_merge_sort[, -1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
303 DM1_merge_sort <- t(DM1_merge_sort)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
304 DM1_merge_sort <- data.frame(sample = row.names(DM1_merge_sort), DM1_merge_sort, check.names = FALSE)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
305 colnames(DM1_merge_sort)[1] <- corner_DM1
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
306 rownames(DM1_merge_sort) <- NULL
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
307
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
308 rownames(DM2_merge_sort) <- DM2_merge_sort[, 1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
309 DM2_merge_sort <- DM2_merge_sort[, -1, drop = FALSE]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
310 DM2_merge_sort <- t(DM2_merge_sort)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
311 DM2_merge_sort <- data.frame(sample = row.names(DM2_merge_sort), DM2_merge_sort, check.names = FALSE)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
312 colnames(DM2_merge_sort)[1] <- corner_DM2
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
313 rownames(DM2_merge_sort) <- NULL
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
314 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
315
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
316 result <- list(M_merge_sort = M_merge_sort, DM1 = DM1_merge_sort, DM2 = DM2_merge_sort)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
317 return(result)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
318
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
319 } else {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
320 #selects line ids that are in DM2 and not in DM1
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
321 id_diff_1 <- setdiff(DM2[, 1], DM1[, 1])
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
322 #we store them in a dataframe
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
323 row_add_1 <- data.frame(id = id_diff_1)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
324 #renames columns with their names in DM1
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
325 colnames(row_add_1)[1] <- colnames(DM1)[1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
326 #Merge
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
327 DM1_add <- bind_rows(DM1, row_add_1)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
328 id_diff_2 <- setdiff(DM1[, 1], DM2[, 1])
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
329 row_add_2 <- data.frame(id = id_diff_2)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
330 colnames(row_add_2)[1] <- colnames(DM2)[1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
331 DM2_add <- bind_rows(DM2, row_add_2)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
332
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
333 if (type == "sample") {
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
334 rownames(DM1_add) <- DM1_add[, 1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
335 DM1_add <- DM1_add[, -1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
336 DM1_add <- t(DM1_add)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
337 DM1_add <- data.frame(sample = row.names(DM1_add), DM1_add, check.names = FALSE)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
338 colnames(DM1_add)[1] <- corner_DM1
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
339 rownames(DM1_add) <- NULL
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
340 rownames(DM2_add) <- DM2_add[, 1]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
341 DM2_add <- DM2_add[, -1, drop = FALSE]
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
342 DM2_add <- t(DM2_add)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
343 DM2_add <- data.frame(sample = row.names(DM2_add), DM2_add, check.names = FALSE)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
344 colnames(DM2_add)[1] <- corner_DM2
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
345 rownames(DM2_add) <- NULL
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
346 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
347 result <- list(M_merge_sort = M_merge_sort, DM1 = DM1_add, DM2 = DM2_add)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
348 return(result)
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
349
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
350 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
351 }
c577f13705f2 planemo upload for repository https://github.com/workflow4metabolomics/tools-metabolomics commit eba1150dad55ad9eca5e93358d9f75e6b6dba2ec
workflow4metabolomics
parents:
diff changeset
352 }