How to choose which rows to display from an excel sheet using pandas

Question

I want to be able to choose which rows I want to display when I print data from an excel sheet

data = pd.read_excel("TABLE.xlsx", usecols='D,E,F')

This allows me to choose which columns I want to display, what do I need to add to choose the specific rows?

https://stackoverflow.com/questions/43772362/how-to-print-a-specific-row-of-a-pandas-dataframe — Kuba Zabielski, Apr 08 '23 at 10:20

score 0 · Answer 1 · edited Apr 08 '23 at 12:27

0

# Below code only shows rows where the column 'D' values are greater than 5

data = pd.read_excel("TABLE.xlsx", usecols='D,E,F')
selected_rows = data[data['D'] > 5]

This is for selecting from D column.Similarly, use other indexing based on your requirement.

You can also use other boolean operators (<, >=, <=, ==, !=, etc.) to select rows based on different criteria, and combine multiple conditions using logical operators (& , | , ~ ).

Check this link for more help about boolean indexing Logical operators for Boolean indexing in Pandas

edited Apr 08 '23 at 12:27

Thierry Lathuille

23,663
10
44
50

answered Apr 08 '23 at 11:06

Nirmal Pandey

81
3

Please **don't** use bold text for your answers. – Thierry Lathuille Apr 08 '23 at 12:27

How to choose which rows to display from an excel sheet using pandas

1 Answers1