Hello Community members,
A solution to last week’s challenge can be found here.
This week’s challenge was submitted by Patrick Digan (@patrick_digan) . Thank you, Patrick, for submitting this great challenge!
In this challenge, you will explore an important part of the financial system: bank failures. Specifically, you will be working with data provided by the Federal Deposit InsuranceCorporation (FDIC) on the 569 banks that have failed from 2000 to August 2024. The FDIC was established in the 1930s to step in and help with bank failures.
The two datasets provided contain the following information:
- banklist.csv: A list of failed banks that includes information on the city and state where the bank was established, the certification number, whoacquired the failed bank, the closing date, and funds.
- institutions (select data).csv: A dataset with details on each bank’s establishment date (INSDATE) and certification number (CERT).
Your task is to calculate the number of days from a bank’s establishment to the day it closed. Then, determine which bank failed in the shortest number of days between its establishment and closing.
Ready to uncover which bank had the shortest lifespan? Let’s get started.
Need a refresher? Review the following lessons in Academy to gear up:
Good luck!
The Academy Team
Sources:
https://www.fdic.gov/resources/resolutions/bank-failures/failed-bank-list/index.html
Fun stuff
here we go!
quick and easy (did not need to go the yxft way at all - just a join would have been sufficient after parsing the dates)
