Hello all!
I have two data frames as the first one contains gene names (511 lines) and a single column and the second one contains Chromosome,Position,Rsid,Ref,ALT....Gene (187th column) and so on.
I want to compare these two dataframes and keep the rows in second dataframe based on "Gene" column. How can I do this in RStudio?
for example:
df1:
AARD
NOC2L
EPHA10
df2:
info.. info.. info... SAMD11
info.. info.. info.. NOC2L
info.. info.. info.. EPHA10
info.. info.. info.. AARD
new dataframe as output(the one I want):
info.. info.. info.. NOC2L
info.. info.. info.. EPHA10
info.. info.. info.. AARD
Thanks!
•
written
by
aksoyluinci •
2 answers
You can try :
required_df <- df2[df2$genecolumn %in% df1$gene_list_column_name,]
As WouterDeCoster mentioned, from next time post your code and what was the error/result that you were getting.
•
written
by
kishorereddyanekalla •
Really Nice article for refreshing basic data frame concepts and for beginners to start with R data structures. for more information visit at- https://avastsupportnumber.co.uk/blog/fix-avast-error-7005/
Log in to answer this question.
-
Failure in inner_join
written by egascon •
-
how to use make.names commnad in r while using rbind function
written by rheab1230 •
-
R Find which gene a SNP position is in
written by marit.hetland •
-
for loop and sapply for assigning name
written by Bio •
-
Plots for Correlation between two dataframes by row
written by pixie@bioinfo
-
Creating numbered gene sets from a list of genes
written by storm1907 •
-
Saving variable number of objects to .xls file
written by luca •
-
Matching date and condition from different dataframe to get specific score
written by hoc307 •
-
How to associate a row from one data frame with a value in another data frame based on three columns
written by baizm •
-
R programming question: extract all the rows matching Ids
written by MAPK
What have you tried? This seems like a quite basic R subsetting/dataframe slicing question, of which you can find plenty of solutions online.
Well,i tried several methods,though i couldnt extract the whole row in dataframe 2, instead i could extract the names only + when i used the intersect function it gave me error since these datasets are not same in size.
Please share the code even if it is not working, that would help us to understand the problem.
And, this is a basic R question, more suitable at StackOverflow, just
mergecommon gene columns, see:Or use
%in%:If it is single field matching, you can use join in *nix