Skip to content

Instantly share code, notes, and snippets.

@irenecasado
Last active January 30, 2022 22:02
Show Gist options
  • Save irenecasado/cfa2903ed78827a508a2d0f94c8ffd3c to your computer and use it in GitHub Desktop.
Save irenecasado/cfa2903ed78827a508a2d0f94c8ffd3c to your computer and use it in GitHub Desktop.
~> mkdir code
~> cd code
~/code> curl -s --output banklist.csv https://www.fdic.gov/resources/resolutions/bank-failures/failed-bank-list/banklist.csv
~/code> touch ca_failed_banks.csv
~/code> head -1 banklist.csv
Bank Name�,City�,State�,Cert�,Acquiring Institution�,Closing Date�,Fund
~/code> head -1 banklist.csv > ca_failed_banks.csv
~/code> cat ca_failed_banks.csv
~/code> grep CA banklist.csv >> ca_failed_banks.csv
~/code> ROW_COUNT=`wc -l < ca_failed_banks.csv | xargs`
~/code> NUM_BANKS=$(($ROW_COUNT - 1))
~/code> echo "There are ${NUM_BANKS} failed banks in California"
# There are 41 failed banks in California.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment