This is a test version of Biostars. For the public version, visit https://www.biostars.org.
how to reorder lines in afile based on a list of gene IDS?

I have two files;

File one:

ID  SCORE   PVALUE
A   1   0.1
B   2   0.2
C   3   0.3
D   4   0.4

FIle 2:

ID
C
B
A

Now I want to reorder my file 1, in the sequence as present in file 2.

THanks

reorder
• 2,048 views • link
written by majeedaasim • majeedaasim

And what have you tried to solve this?

• 1 views • link
written by WouterDeCoster WouterDeCoster

Do you want a solution in Perl, Python or R?

• 1 views • link
written by h.mon h.mon

why not trying googling using keywords "r dataframe reorder factor"?

• 1 views • link
written by shenwei356 shenwei356

In R, just set the column as factor with your levels for the dataframe.

For others, storing the levels in a hashmap with incremental numbers as values, then you can sort the rows using corresponding hashmap value.

Want save time? csvtk sort supports sorting by user defined levels.

• 1 views • link
written by shenwei356 shenwei356

0 answers

No answers yet.

Log in to answer this question.

More posts like this