Weekly Challenges

AYXAcademy

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:

Joining Data

Diving into Expressions

Good luck!

The Academy Team

Download Start File

Download Solution File

Sources:

https://www.fdic.gov/resources/resolutions/bank-failures/failed-bank-list/index.html

https://banks.data.fdic.gov/docs/#/History/getHistory

BS_THE_ANALYST

Fun stuff

Spoiler

This is interesting, I did datetimediff with a date column and a string column and it's seemingly quite happy. It must internally cast the columns as dates to handle this situation, very cool. I also tried another test with two string columns, datetimediff worked perfectly well (note the string columns are in the ISO format)
Screenshot 2025-02-17 154945.png

This is interesting, I did datetimediff with a date column and a string column and it's seemingly quite happy. It must internally cast the columns as dates to handle this situation, very cool. I also tried another test with two string columns, datetimediff worked perfectly well (note the string columns are in the ISO format)