Image for post
Image for post

The brilliant people at Knight Lab (more specifically Joon Park and Cathy He) created this really fun SQL murder mystery. I decided to solve it and share my investigation with you.

Spoiler alert: the murderer will be revealed at the end of this article. So if you do not want to know who did it, stop reading!

The Setup

A crime has taken place and the detective needs your help. The detective gave you the crime scene report, but you somehow lost it. You vaguely remember that the crime was a ​murder​ that occurred sometime on ​Jan.15, …


With so much of today’s communication happening online, natural language processing (NLP) can play a crucial role in helping us gather information from online posts. While learning about NLP, I used Reddit’s API to collect online submission data and see how it can be used to derive insights for a fictitious company. For the purpose of this article, I will focus on the data cleaning and exploratory data analysis (EDA).

The Data

We gathered submissions from 2 subreddits: the OCD (Obsessive Compulsive Disorder) subreddit and the autism (ASD) subreddit. The OCD and ASD subreddits were specifically chosen because they are two disorders…


Image for post
Image for post

As I reached the end of my data science immersive program, I had the opportunity to pick any data science problem and solve it from start to finish. I had 2 goals: use real life data and discover actionable insights that could help a business. Due to the COVID-19 pandemic my summer travel plans had been turned upside down and I started thinking about what all those cancellations meant for the hotel industry. I found a dataset of real hotel reservations and after a little bit of digging realized that cancellations are a significant issue for the hotel industry even…


On March 25th 2020, I posted a story sharing about the start of my journey into data science. At that time, I had just finished my first week of a Data Science Immersive program at General Assembly. Today marks the beginning of the 10th out of 12 weeks. As I near the end of this bootcamp, I wanted to reflect on what I’ve learned so far and what is still to come.

In March I had mentioned that while my previous research had brought insights about the past, I had never built a model that could make predictions about the…


As I enter week 6 of my data science immersive program, I keep noticing similarities between what I am learning now and what I have applied during my time as a clinical research assistant and while doing academic research. So for anyone in the academic or clinical research field thinking about a switch to data science, here are 10 things you didn’t know you’ve already learned!

To illustrate some of the similarities we will use my senior year psychopathology capstone research project (for the academic research side) and one of General Assembly’s lab exercise (for the data science side).

1. The Workflow

At…


In October 2019, I graduated from Teachers College Columbia University with a masters in Neuroscience and Education. Like every recent graduate, I had one question to answer: what’s next? As a good little scientist, I decided to take inspiration from the scientific method.

For those of you who need a reminder, the scientific method goes like this:

  • Step 1: Make an observation
  • Step 2: Ask a question
  • Step 3: Construct a hypothesis
  • Step 4: Make a prediction
  • Step 5: Design an experiment to test the hypothesis
  • Step 6: Reflect on the results, refine the hypothesis (and most likely start the…

J Kelman

On a journey to shift from neuroscience to data science.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store