Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Learn Challenge: Summarize Customer Transactions | Financial Data Analysis for Bankers
Python for Bankers
Section 1. Chapter 3
single

single

bookChallenge: Summarize Customer Transactions

Swipe to show menu

Task

Swipe to start coding

Given a list of customer transactions, your goal is to analyze and summarize the account activity. Each transaction is represented as a dictionary containing the date, amount, and type (either "deposit" or "withdrawal").

  • Create a pandas DataFrame from the provided list of transaction dictionaries.
  • Calculate the total amount deposited by the customer.
  • Calculate the total amount withdrawn by the customer.
  • Determine the ending balance by subtracting total withdrawals from total deposits.
  • Print the total deposits, total withdrawals, and ending balance in a readable format.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 1. Chapter 3
single

single

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

some-alt