ChallengeFinancePYTHON+20 XP

Data Analytics case 11: Pivot summaries for Finance

Scenario

You are a data professional. A community bank has an issue: managers want amount per region in one small table. As a Data Analyst, you are tasked to solve it.

Question

Make a pivot table of totals.

Your task

Read the problem
Write your solution in the editor
Press Check my answer
Deliverable: Pivot summary table
On success it is published as its own portfolio project

Pivot summariesData AnalyticsProblem solving

Read the simple theory: Root-cause analysis

Data Analytics · Problem Solving & Root Cause Analysis — question 11 of 30

Finish all 30 to earn a certificate

1. Choose your dataset

Pick an industry and a size. Your code and results change to match.

IndustrySize

📓 DataPro notebookcase-data-analytics-11.ipynbFileEditViewRunKernel: Python 3

[md]

Data Analytics case 11: Pivot summaries for Finance

Make a pivot table of totals.

In [1]:

Your code cell is below. Press Check my answer to run the cell — the result appears as Out [1].

python editorpayments

Snippets

💡 Explain my whole code, line by line (hover any word in the editor for a tip)

🌈 In short — no coding words

📂 Opens the "payments" table→✅ Shows you the answer

Altogether: this script runs top to bottom, one line at a time, building up the answer step by step.

Start typing to see suggestions. Press Enter to use one. Red marks show the line to fix. Drag a bottom corner horizontally and vertically to resize.

Type your code here ↓Tap or click inside the box to start

✍️ Tap here to type

Dataset & schema

payments

IndustryDataset size

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 data only.

attempts: 0

▶ Output terminal

$ Press “Check my answer” — results appear here.

Your next steps

Each item turns green when your answer includes it.

1 left

Pivot table