Revenue by Region With pandas
Advanced · Write the code · from 50 Python Practice Problems with Instant Answer Checking (Beginner to Advanced)
From the lesson: 50 Python Practice Problems with Instant Answer Checking (Beginner to Advanced)
Fifty problems, each with a code editor and real tests. Write your solution, press Check, and see exactly which cases pass. Stuck? Hints reveal one at a time, and the solution unlocks once you have checked at least once. Your code and progress are saved in this browser.
Read the lessonEach row of a sales DataFrame has region, price and qty. Write revenue_by_region(df) that returns a Series of total revenue (price * qty) per region, sorted from highest to lowest and rounded to 2 decimals. Do not modify df.
import pandas as pd
def revenue_by_region(df):
pass
Solution unlocks after your first Check
What Check runs
Your code runs first, then each of these lines. The output must match exactly.
| Runs | Expected output |
|---|---|
| df = pd.DataFrame({ "region": ["North", "South", "North", "East", "South"], "price": [10.0, 20.0, 5.5, 100.0, 1.25], "qty": [3, 2, 10, 1, 4], }) print(revenue_by_region(df).to_dict()) | {'East': 100.0, 'North': 85.0, 'South': 45.0} |
More practice problems
- FizzBuzzBeginner
- Reverse the WordsBeginner
- Count the VowelsBeginner
- Palindrome CheckBeginner
- Sum of DigitsBeginner
- Largest Number Without max()Beginner
- Remove Duplicates, Keep the OrderBeginner
- Second Largest ValueBeginner
- Most Common CharacterBeginner
- Are They Anagrams?Beginner
- Factorial, With a Proper ErrorBeginner
- Is It Prime?Beginner
- Letter GradeBeginner
- Title Case Without .title()Beginner
- Common ElementsBeginner
- Flatten a List of ListsBeginner
- Merge Two InventoriesBeginner
- Invert a DictionaryBeginner
- Password Strength CheckBeginner
- Average of Messy InputBeginner
- Fibonacci GeneratorIntermediate
- Sieve of EratosthenesIntermediate
- Caesar CipherIntermediate
- Top Words in a TextIntermediate
- Group the AnagramsIntermediate
- Balanced BracketsIntermediate
- Run-Length EncodingIntermediate
- Binary SearchIntermediate
- Merge Two Sorted ListsIntermediate
- Rotate a ListIntermediate
- Deep FlattenIntermediate
- Roman NumeralsIntermediate
- Longest Common PrefixIntermediate
- Parse a Log Line With RegexIntermediate
- A Bank Account ClassIntermediate
- Two SumAdvanced
- Longest Substring Without RepeatsAdvanced
- Merge Overlapping IntervalsAdvanced
- Top K Frequent ElementsAdvanced
- Maximum Subarray (Kadane)Advanced
- Coin Change (Dynamic Programming)Advanced
- Longest Increasing SubsequenceAdvanced
- Shortest Path in a Graph (BFS)Advanced
- LRU CacheAdvanced
- Trie for AutocompleteAdvanced
- Write a Memoize DecoratorAdvanced
- A Retry Decorator With ArgumentsAdvanced
- A Context Manager That Cleans UpAdvanced
- Leaderboard With a DataclassAdvanced