Difference between Loc and iloc in pandas

<<–2/”>a href=”https://exam.pscnotes.com/5653-2/”>p>.loc and .iloc in Pandas.

Introduction

Pandas is a powerful Python library for data analysis and manipulation. Two of its most fundamental tools for data selection and filtering are .loc and .iloc. While both serve the purpose of accessing data within a Pandas DataFrame or Series, they operate on different principles, leading to distinct use cases.

Key Differences between .loc and .iloc

Feature	`.loc`	`.iloc`
Indexing Type	Label-based	Integer Position-based
Inclusivity	Includes the endpoint	Excludes the endpoint
Usage	Selecting rows/columns by their names or labels	Selecting rows/columns by their numerical position
Error Handling	Raises `KeyError` if the label doesn’t exist	Raises `IndexError` if the position is out of bounds

Illustrative Examples

Consider a DataFrame df with the following structure:

   Fruit  Price  Quantity
0  Apple    1.2      15
1  Banana   0.8      20
2  Orange   1.5      10

.loc Example:

df.loc[1, 'Price']  # Output: 0.8
df.loc[0:2, ['Fruit', 'Quantity']]  # Output: (A DataFrame with the specified rows and columns)

.iloc Example:

df.iloc[1, 1]  # Output: 0.8
df.iloc[0:2, [0, 2]]  # Output: (A DataFrame with the specified rows and columns)

Advantages and Disadvantages

Method	Advantages	Disadvantages
`.loc`	* More intuitive when working with labeled data * Allows for slicing with boolean conditions based on labels	* Can be slower if labels are not unique * Requires knowledge of the labels
`.iloc`	* Faster, especially for large datasets * Robust to changes in row or column labels * Simpler for integer-based operations	* Less intuitive for labeled data * Requires awareness of the numerical positions

Similarities between .loc and .iloc

Both are used to select specific subsets of data from a Pandas DataFrame.
Both can be used for slicing (selecting a range of rows or columns).
Both can be used with a single label/position or a list of labels/positions.

FAQs

When should I use .loc over .iloc (or vice-versa)?
Use .loc when working with labeled data and you know the names of the rows or columns you want to select. Use .iloc when you know the numerical positions or when you need to perform integer-based operations.
Can I use .loc and .iloc on a Pandas Series?
Yes, you can use .loc with labels and .iloc with integer positions to select Elements within a Series.
Are there any performance considerations when choosing between .loc and .iloc?
.iloc is generally faster, especially for large datasets, because it directly accesses elements by their numerical position.
Can I chain .loc and .iloc in a single operation?
While technically possible, it’s generally not recommended due to potential for confusion and errors.

Let me know if you’d like more examples or have any further questions!