Balances month by month

MediumCapital Onepivotisinwide tables· 20 XP

A risk analyst is reviewing three cards and wants each card's balance for every month on a single row.

From statements.csv, take cards 1, 2 and 3 and store a table with one row per card_id and one column per statement_month, holding the balance.

Expected answer

Store your answer in result.

Hints, the later steps and the answer come with Pro.

import pandas as pd

statements = pd.read_csv("statements.csv")
result = ...