Slides and materials from my talk for Data Wranglers DC on January 7, 2015
MIT License
This repository contains materials for my talk at the Data Wranglers DC meetup on January 7, 2015.
I've also given prior talks on SQL to the same group:
The talk consists of two major pieces:
Note that the focus of this talk is on data preprocessing tasks (also called wrangling or munging), and not on analysis tasks. The goal of this work is to demonstrate some ways to use PostgreSQL's capabilities in version 9.4 (released December 18, 2014) to process JSON formatted data into tabular datasets amenable to future analysis.
Folders are as follows:
./slides
) in Apple Keynote, PDF and HTML formats./code
) that create the local PostgreSQL database objects demonstrating working with the json
and jsonb
types, including:
I recommend that anyone wishing to understand what I've done and presented here should tackle these pieces in order, starting with the slide deck. The code is best followed in the order presented: demo code, followed by Jobs API code, followed by OpenWeatherMap API code.
This work and the opinions expressed here are my own, and do not purport to represent the views of my current or former employers.