Filtering materials of two columns in R
I have a two column dataset as given below. I want to add a third column which will contain all genes from column 1 and 2, but none of the genes should repeat. How can I do this in R?
ID ID2
Gene1 Gene3
Gene1 Gene5
Gene2 Gene7
Gene2 Gene4
Gene3 Gene6
Gene3 Gene8
1 answer
Select the two columns (df['ID'], df['ID2']), combine them to a vector (e.g. c()), use the unique() function two remove duplicates. But adding the new vector to the data.frame using cbind will not be possible since it has different length than the original dataframe
Log in to answer this question.
More posts like this
-
expanding a table by duplicating rows of a specific pattern
written by Assa Yeroslaviz
-
How to extract only the specific fasta sequences by matching the ID's to a different source files ?
written by pinn
-
filtering out lines (rows) based on repeated zero values with awk in linux
written by rgescudero •
-
TOPGO- how to do GO enrichment using a custom go database?
written by ahmad.iut
-
Formatting problem gene table conversion
written by lessismore
-
MapInspect data input
written by mrgyadav •
-
Replace tip names in a newick file
written by tlorin
-
MDS plots with R
written by Biogeek
-
How to prepare GSEA Pre-Ranked input file
written by biorepine
-
Mapping Pathways To Genes
written by juncheng
please add an example of column 3
The example of column 3 is given below. It contains all characters of col 1 and 2 but genes names do not repeat