How to import specific columns and rows from Excel using Pandas

Question

My excel has many columns and rows data. But I want to import specific columns and rows data.

My code:

L_pos_org = pd.read_excel('EXCELFILE.xlsx',sheet_name='Sheet1',na_values=['NA'],usecols = "M:U")

Above code extract the columns that I want but it also extracts all rows.

In above excel file, I am trying to extract the data of Columns M:U and rows 106:114.

How to extract this?

Evan VanderZee · Accepted Answer · 2019-05-18 04:51:45Z

2

Looking at the documentation here, it seems that with a recent enough version of Pandas you could extract a specific block of rows using the parameters skiprows and nrows. I think the command would look something like

pd.read_excel('EXCELFILE.xlsx',sheet_name='Sheet1',header=None,na_values=['NA'],usecols="M:U",skiprows=range(105),nrows=9)

answered May 18, 2019 at 4:51

Evan VanderZee

8778 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to import specific columns and rows from Excel using Pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related