Parsing Chase Files and generating fake data

We are back, recapping our previous post we had preprocessed an American Express CSV fjle and loaded it into DuckDB. Today we’ll do the same for Chase credit cards and I’ll share how to generate some fake data to properly demo this functionality.

Parsing Chase CSV’s

I’ll bring back all the snippets I used and I put them into a function for easier use.

Parsing AMEX CSV’s and loading them into DuckDB

In my previous post I laid out the design for an expense tracker in Python. It’s time to start hacking and I’ll preprocess the CSV’s that Amex so graciously provides.

After initializing the repo with Git we’ll install the necessary packages. Always use a virtual environment! I one time broke my python version with unmanaged packages and it took a hot minute to get it back going.

Let’s design some budgeting software

One funny thing about me is that I love credit cards and no, not in the irresponsible way of racking them up. I like gathering as many points as I can for use of flights and hotels. Problem here is that now I have several credit cards amongst multiple companies. All of these companies have websites to navigate the data but it’s impractical to go through all the sites.

Let’s containerize a database!

I wanted a database in my local machine to try out some queries and thought about setting up a little test environment. I didn’t want to go through the process of installing MySQL so let’s make some Docker containers instead.

Docker, the very popular container virtualization solution written in Go. Used as the very building blocks for microservices since it works very well with Kubernetes. I need a small database and don’t care about data persistence for the environment so this is perfect for small POC’s or projects.

Quick & easy intro to silent installs and ODT

I’ve been using Windows for over 15 years and even worked in IT maintaining PC’s during college. This is why I use MacOS and Ubuntu. Jokes aside, Windows has come a long way in getting stuff done with the terminal. PowerShell and WSL makes for a great one-two punch in productivity. I loved it when chocolatey came out and used it immediately on my PC. Although it’s made great progress, there are still times where it reminds me that it’s Windows.