I’ve had a credit card now for about 2 years, so I thought I would make a cool visualization that shows my relative spend through out the year on a daily basis. I think this plot came out to be relatively cool.
The color in the chart is determined by the percentile rank of spend for that day. This is to help anonymize my information. As you can see my spend was much higher in 2018, especially towards the later bit as I had my summer internship, and started working more. I also spent much more consistently over 2018. My goal for 2018 is to spend much less frequently and in smaller amounts.
I also generated a chart showing how many transactions were posted to my account in a given day. I really wish that the data came with a swipe date, and the post date. Credit cards are weird about when things post, but that’s the name of the game.
So this is some interesting data. It’s also like taking a stroll down memory lane to see where I spent my money.
The data structure of my dataframe is as follows. It contains an aggregate of
a day’s transactions. The
rank column is the percentile rank of the
overall spend for that day. The
count column is how many transactions
posted that day.
I grabbed my data from my American Express card. Their data export tool for transactions is awesome. I highly recommend them. Please use my referral link.