Python code for extracting values from an Excel database?
Hello..
I have a big database in an Excel format (around 50,000 records) of sequence accession codes and corresponding numerical values, and I need a piece of python code for extracting the highest 30 numerical values.. Can someone help me with that please? (I have very very beginner level at Python)..
Thanks in advance!
• 1,334 views
•
link
0 answers
No answers yet.
Log in to answer this question.
Look at pandas which is very good at working with excel sheets as a starting point:
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html
EDIT: Sorry I meant this to be a reply I don't know how to delete as answer :/
Thanks, I will definitely check it out..
If you have an excel file, why don't you just use the function of excel to sort columns?
Well, I wanted to write a code that would extract the accession codes corresponding to the highest values and download the sequences in FASTA format directly (by linking it to the Gencode database)..