Introduction

During winter break I came across two somewhat hidden features of my Mac that led me into a rabbit hole of data querying and analysis. I was able to access a hidden database of my text messages (i.e. iMessage) by using SQLite3 in terminal. This meant a lot for me; I could visualize and analyze my data to identify texting habits and hopefully learn something about myself.

Below are the steps I took to get to the following graph, using SQLite3 and Python with the seaborn library. This was a fun learning experience and I recommend trying it out. Actual code files can be found on GitHub:

#data-analysis #texting #python #sql #apple