Safe Averages: At Least 426
Scenario
You are a data professional working with finance data. Prepare a reliable result from payments for a review.
Question
Find the average of values at or above 426. Return 0 if none qualify.
Your task
- Inspect the provided data and column names
- Find the average of values at or above 426. Return 0 if none qualify.
- Run your code and compare the result
Intermediate · Record Counting & Average Calculations — question 20 of 30
1. Choose your dataset
Pick an industry and a size. Your code and results change to match.
Safe Averages: At Least 426
Find the average of values at or above 426. Return 0 if none qualify.
Your code cell is below. Press Check my answer to run the cell — the result appears as Out [1].
💡 Explain my whole code, line by line (hover any word in the editor for a tip)
🌈 In short — no coding words
Altogether: this script runs top to bottom, one line at a time, building up the answer step by step.
Dataset & schema
payments
The tiny starter data. Bigger data scrolls.
Fields
| payment_id | region | amount |
|---|---|---|
| P1 | North | 500 |
| P2 | South | 200 |
| P3 | North | 900 |
| P4 | East | 300 |
Finance practice data only.
$ Press “Check my answer” — results appear here.Your next steps
Each item turns green when your answer includes it.
- Keeps qualifying values
- Calculates the requested result
- Prints the result