Update Values with loc
Intermediate · Write the code · from Pandas Indexing: loc, iloc, Boolean Indexing, and Selection
From the lesson: Pandas Indexing: loc, iloc, Boolean Indexing, and Selection
You have a DataFrame with thousands of rows. You need row 42. You need every customer from Texas. You need the salary in the third row, second column. Pandas gives you three different ways to grab exactly the data you want - and confusing them is one of the most common beginner mistakes.
Read the lessonUse loc to set the 'status' column to 'pass' for all rows where score >= 70, and 'fail' for rows where score < 70. Print the status column as a list.
import pandas as pd
df = pd.DataFrame({
'name': ['Alice', 'Bob', 'Charlie'],
'score': [85, 60, 72]
})
# Set status based on score
More Pandas Indexing exercises
- Select with locIntermediate
- Select with ilocIntermediate
- Filter with Boolean IndexingIntermediate
- Multiple ConditionsIntermediate
- Fix the Bug: Boolean FilterIntermediate
All Python exercises · 50 practice problems · Data Science & Machine Learning quiz