Python code for extracting values from an Excel database?

0

Entering edit mode

5.6 years ago

d.awwad19 • 0

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!

Python sequence • 945 views

ADD COMMENT • link updated 5.6 years ago by curious ▴ 820 • written 5.6 years ago by d.awwad19 • 0

1

Entering edit mode

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 :/

ADD REPLY • link 5.6 years ago by curious ▴ 820

0

Entering edit mode

Thanks, I will definitely check it out..

ADD REPLY • link 5.6 years ago by d.awwad19 • 0

0

Entering edit mode

If you have an excel file, why don't you just use the function of excel to sort columns?

ADD REPLY • link 5.6 years ago by finswimmer 16k

0

Entering edit mode

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)..

ADD REPLY • link 5.6 years ago by d.awwad19 • 0

Login before adding your answer.