R merge columns in the same file with identical column names and remove duplicates
Dear all
I have a dataframe containing columns with identical names for some reason. I wish to combine these columns with the same name with removing the duplicates
I tried using merge but I do not want to enter the column names one by one like merge (x, y)
horse sheep horse
A A A
B B
C
This should give
horse sheep
A A
B
C
Is there any way to do this? I googled and found ways to do it 1 by 1 but I have a lot of columns
0 answers
No answers yet.
Log in to answer this question.
More posts like this
-
Extracting observations from one dataframe to populate another
written by Rachel •
-
conditional formating of cells in Excel with values coming from R
written by Francois Piumi •
-
Loop for removing the complete missing rows in a n number of groups of a dataframe in R
written by KABILAN •
-
Merging previously merged object in Seurat
written by fifty_fifty •
-
Matching date and condition from different dataframe to get specific score
written by hoc307 •
-
Plotting linear trend using the ggplot2 for multiple columns elements
written by mohammedtoufiq91
-
Joining multiple columns from different dataframes in R
written by mb314 •
-
Is there any way to merge intervals based on a minimum overlap?
written by VicGB •
-
How to mark significance in R-making boxplot
written by Qingyang Xiao
-
A script for extracting information related to a list of gene names from a file
written by ahmad.iut
Hello Seigfried!
We believe that this post does not fit the main topic of this site.
Not bioinformatics. Please search SO
For this reason we have closed your question. This allows us to keep the site focused on the topics that the community can help with.
If you disagree please tell us why in a reply below, we'll be happy to talk about it.
Cheers!
Thank you for the reply
In my case my terms were basically GO terms which I wanted to reduce (1->3)-beta-D-glucan metabolic process (1->3)-beta-D-glucan metabolic process acetyl-CoA metabolic process fksA fksA AN3817 rhoA rhoA AN3869 sunA sunA AN4923 gelA facA
It was not apparent in the original post. Please edit it and add in relevant information and I'll reopen the question.