This is a test version of Biostars. For the public version, visit https://www.biostars.org.
searching for information in a file and saving to another- sequence access code

Hey, I'm a begginer looking for an idea to solve the problem. I have a list of sequence access numbers. I want to search for each of them in an excel file (where there are many other sequences) and save the information about them in a new excel file. Does anyone have an idea what to do here?

python phylogenetic tree excel sequence
• 1,536 views • link
updated by Mensur Dlakic Mensur Dlakic • written by Alexandra • Alexandra

I want to search for each of them in an excel file

enter image description here

• 0 views • link
written by Pierre Lindenbaum Pierre Lindenbaum

Is there a script that automatically inserts this image each time Excel or excel are mentioned in a message? If so, hopefully you will let others use it from time to time. Also, it may be a good idea to mix it up with an image that says Download Python.

• 0 views • link
written by Mensur Dlakic Mensur Dlakic

1 answer

I want to search for each of them in an excel file (where there are many other sequences) and save the information about them in a new excel file.

you want tools like sort , join and also look at "shell redirection"

see how to combine two bed files using the same ID information for an example.

• 0 views • link
written by Pierre Lindenbaum Pierre Lindenbaum

Log in to answer this question.

More posts like this