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

bookChallenge: Summarize Customer Transactions

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

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

Suggested prompts:

Can you explain this in simpler terms?

What are the main benefits or drawbacks?

Can you give me a real-world example?

close

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

some-alt