• jared@discsanddata.com
  • Siem Reap, Cambodia

These posts are the most datalicious...

Decision Time: SQL

Writing this a good bit late but whatevs… So as my Learn SQL Basics for Data Science Specialization (UC Davis, Coursera) began to wind down, it came time to decide, what’s next? I realized that I really like SQL. And even though not all the classes in the Learn SQL Specialization were wonderful (looking at you Spark), I decided I […]

My SQL for Data Science Capstone Project: Country Data and Olympic Success (Part 3)

So, when we left off we were looking at population, GDP per capita, and urbanization metrics. Nothing jumped out except the urbanization… (tl;dr the first five posts in this series… I’m looking at connections between population and economic metrics and country success at the olympics. To start at the beginning, check out part 1.) (Standard warning in all my posts. I’m […]

My SQL for Data Science Capstone Project: Country Data and Olympic Success (Part 2d)(aka “Numerous Devious Plots Discovered”)

Ok. So I have my main working tables, Athletes and Countries, (finally) done… (tl;dr the first four posts in this series… I’m looking at connections between population and economic metrics and country success at the olympics. To start at the beginning, check out part 1.) (Standard warning in all my posts. I’m a beginner. Nothing below should be taken as the […]

My SQL for Data Science Capstone Project: Country Data and Olympic Success (Part 2c)(aka “Where is Dow Jones?”)

OK. So I just figured out what to do about countries being called different names across datasets are two Congos are now “Congo (Kinshasa)” and “Congo (Brazzaville)”. I worry though, I’ll have to deal with this issue again… (tl;dr the first three posts in this series… I’m looking at connections between population and economic metrics and country success at the […]

My SQL for Data Science Capstone Project: Country Data and Olympic Success (Part 2b)(aka “A Tale of Two Congos”)

And back to work. When we left off I had just built the Countries DATAFRAME… (tl;dr the first two posts in this series… I’m looking at connections between population and economic metrics and country success at the olympics. To start at the beginning, check out part 1.) (Standard warning in all my posts. I’m a beginner. Nothing below should be […]

Making Pandasql Happen in Jupyter

(Standard warning in all my posts. I’m a beginner. Nothing below should be taken as the best way of doing things, a good way of doing things, or even a right way of doing things. If you think you know better than me, you probably do. Please comment with better practices) So, I was working on my first week’s assignment […]

Decision Time: Python

So, with pandemic kicking in, I decided to do what most people in the world decided to do, study Python and start playing disc golf. My disc golf career is of to a spectacular start, but you’re probably not here to read about that. Many newbies, including myself, who wanted to study Python and were either not afraid of paying […]