Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Series
What DataFrames are
DataFrame columns
DataFrame rows
17. Selecting rows with iloc
Filtering rows and columns
Filtering data frames
Sorting rows
Summary

Instruction

Alright, it's time for DataFrame rows now. If you want to select a specific row based on its position, you can use iloc[...]. This is similar to selecting an element from a Python list. iloc stands for integer location. Take a look:

hospitals.iloc[0]
0
Hospital Name Abbeville Area Medical Center
City Abbeville
State SC
Phone Number 8643665011
Hospital overall rating 4

The expression above will select the first row from the hospitals DataFrame. Again, the result will be a Series, so if you need a DataFrame, provide a list of indexes:

hospitals.iloc[[0]]
Hospital Name City State Phone Number Hospital overall rating
0 Abbeville Area Medical Center Abbeville SC 8643665011 4

Exercise

Select the third row of eu_states as a new DataFrame.

Stuck? Here's a hint!

Remember that the third row has an index value of 2.