R programming: Merge tables
Hi Guys,
Is there a way to reorder the column of two tables, table1 and table2, according to the column names in the list (in the same order) and merge them into one table result.table.
list<-c("MAPK", "BCL2", "ALB", "MAPKK", "MEKK", "JUNK", "STR", "BRCA1")
table1
MAPK MAPKK MEKK JUNK STR
5 5 6 7 9
3 4 5 7 8
table2
BCL2 ALB BRCA1
4 4 3
4 4 3
result.table
MAPK BCL2 ALB MAPKK MEKK JUNK STR BRCA1
5 4 4 5 6 7 9 3
3 4 4 4 5 7 8 3
Thank you!
1 answer
#combine the tables
hold <- cbind(table1, table2)
#order by 'list'
result.table <- hold[ , list]
This assumes that table1 and table2 are data frames with column names as indicated in 'list.'
• 0 views
•
link
updated
by
Ram
•
written
by
Brice Sarver
•
written
by
Brice Sarver
Sorry, typed too quickly. This is it.
• 0 views
•
link
written
by
Brice Sarver
Log in to answer this question.
More posts like this
-
Understanding Uncommon Genotype Formats in VCF Files Generated by nf-core RNAvar Pipeline
written by ASid •
-
How to use R's loop to get the part of the aggregate matrix other than the many subset matrices?
written by Chilly •
-
How can I analyze this data in Deseq?
written by MAPK
-
Count columns and delet specific one
written by salvatore_d •
-
Merging data coloum wise in R
written by David_emir
-
Unlisting lists inside data frame and collapsing their values in R
written by arronar
-
Comparing samtools,gatk and varscan against gold standard 1000G snps and need to decide the best me…
written by bioinforesearchquestions
-
how to compare sets using python (dealing with PDB file)
written by Jason Lin •
-
Creating A Granges Object From Rleviewslist
written by george.bask •
-
How To Generate A Motif Object Directly For A Count Matrix In Biopython
written by cauyrd •
