renatadaou/sodapy-tutorial-nyc-opendata

Sodapy Tutorial Using NYC Open Data.

Sodapy Tutorial Using NYC Open Data

Author: Mark Bauer

Introduction

This project demonstrates how to:

• use sodapy (i.e. the python client for the Socrata API)
• provides examples of the Socrata Query Language (also known as SoQL)
• sample analysis notebook using 311 data

Inspiration for this project came from the sodapy GitHub page. Much of what I learned about sodapy, as well as working with the Socrata API, came from these developers. I encourage you to review the official sodapy GitHub page to have a better and more complete understanding of sodapy (e.g. installation, requirements, available methods, basic SoQL queries, etc.). This tutorial is meant to complement the official sodapy docs.

Data

The dataset used in this project is 311 Service Requests from 2010 to Present from NYC Open Data.

Tutorials

The sodapy tutorial notebook can be found here sodapy-basics.ipynb.

The Socrata Query Language (SoQL) notebook can be found here socrata-query-language.ipynb.

A sample analysis notebook can be found here analysis.ipynb.

Additional Resources

Sodapy

The official sodapy docs: https://github.com/xmunoz/sodapy
PyPI: https://pypi.org/project/sodapy/
Inspiration for this project: https://github.com/xmunoz/sodapy/blob/master/examples/soql_queries.ipynb

Socrata Open Data API

The official Socrata Open Data API docs: https://dev.socrata.com/
Queries using SODA: https://dev.socrata.com/docs/queries/