data science Archives - Jeff Everhart

Query Timeout in MySQL Workbench | Error Code: 2013. Lost connection to MySQL server during query

This is kind of a silly and duplicative post, but I spent too much time searching for the right answer, so maybe this will help the right course of action bubble to the top faster in the future. The Issue I was trying to run a query on my local SQL install (whatever MAMP manages […]

Read More

Visualizing Geographic Data with D3

I’m not sure the power of visualizing data can be understated in the modern world. After all, we have more data than we’ve every had before, and we at least seem to understand the world we live in less and less. For example, this image below displays population density in Virginia census tracts, but what […]

Read More

Command Line: Download Files with cURL Command

I’m not sure how I didn’t know about this command sooner since I use cURL for a few other tasks. I’ve been using WGET to download remote files, but I recently stumbled across this new little shortcut that should save me a few seconds here or there. If you’d rather just watch a short video, […]

Read More

Building A Simple Heat Map with D3

Heat maps are a great way to analyze frequency in a data set. Beautiful and creative things happen when you are stuck in an airport for four hours. I’ve been wanting to explore heat map visualizations for awhile now, so when I had some time to kill flying back from SXSW, I decided to take […]

Read More

Tech Tip: Randomizing Data in Microsoft Excel

Excel is a powerful data analysis tool. In this blog post, we will look at how to use the =RAND() function in Microsoft Excel to randomize a column of data. Randomizing data in Microsoft Excel could be important for a number of reasons, especially if you are trying to do any type of anonymous analysis. […]

Read More