Today we are going to learn how to use iloc to get values from Pandas DataFrame and we are going to compare iloc with loc.
To learn about loc, please check A tip A day – Python Tip #1 – loc.
Using iloc:
- iLoc uses only numbers/indexes (strictly numerical values) to get values from a Pandas DataFrame.
- Apart from numerical values, it accepts boolean arrays similar to Loc
Consider the above dataframe. It has Named index.
If a slice object is given as argument in iloc, then it returns data from starting index upto ending index, but excluding the ending index.
Also the indexes will start from 0 (Not 1).
See that the slice object “0:2” points the indexes from June (Index = 0) till July (Index = 1), but the third row August (Index = 2) was not returned.
Similarly, the index of the second column ‘apples’ is 1 and third columns ‘grapes’ (Index = 2) is returned but ‘pear’ is not returned.
As mentioned above, iloc can accept boolean list / condition statements too.
Loc Vs iLoc:
| Loc | iLoc |
|---|---|
| Strictly label based | Strictly index based |
| Accepts Boolean Array/ Conditions | Accepts Boolean Array/ Conditions |
| Includes both the ranges in slice object. Example: ‘a’:’b | Excludes the end range in slice object as it uses index. Example: 0:3 returns 0,1,2 not 3 |
Today we learned about iloc.
We will meet with a new tip in Python. Thank you! 👍
Like to support? Just click the heart icon ❤️.
Happy Programming!🎈