mebauer/sodapy-tutorial-nyc-opendata

Socrata Open Data API Tutorial with Python and NYC Open Data.

Socrata Open Data API Tutorial with Python and NYC Open Data

Author: Mark Bauer

Table of Contents

• Introduction
• Tutorials
• Data
• Additional Resources
  • Socrata Open Data API
  • Sodapy
• Say Hello!

Introduction

This project demonstrates how to:

• Use the Socrata Open Data API
• Use sodapy (i.e. the python client for the Socrata API)

And provides:

• Examples of the Socrata Query Language (also known as SoQL)
• A sample analysis notebook using datasets from NYC Open 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.

Tutorials

• Socrata API Basics: socrata-api-basics.ipynb.
• The Socrata Query Language (SoQL): socrata-query-language.ipynb.
• A sample analysis notebook: sample-analysis.ipynb.

Data

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

Additional Resources

Socrata Open Data API

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

Sodapy

• The official Sodapy documentation: https://github.com/xmunoz/sodapy
• SoQL inspiration for this project: https://github.com/xmunoz/sodapy/blob/master/examples/soql_queries.ipynb

Say Hello!

Feel free to reach out for further discussions.

• LinkedIn: markebauer
• GitHub: mebauer
• Portfolio: mebauer.github.io