DSSG Pandas, Geopandas, SQL Tutorial

Last update: July 2019

Authors:

Run this tutorial on mybinder.org!

Concepts

What is jupyterhub/jupyterlab and how is it used with conda and python to setup a computational environment
How do we organize and analyze tabular data with software such as SQL, pandas
Spatial attributes (such as points, lines, and polygons) in tabular data permits unique analysis with geopandas

Create a computational environment with conda
Perform basic data loading, manipulation, and visualization in a jupyter notebook with python packages
Learn basic SQL syntax for database querying, understand reasons to use SQL instead of other storage formats like .csv files

Name		Name	Last commit message	Last commit date
Latest commit History 9 Commits
binder		binder
data		data
renderered-notebooks		renderered-notebooks
.gitignore		.gitignore
1-Intro-Jupyter-notebooks.ipynb		1-Intro-Jupyter-notebooks.ipynb
2-intro-geopandas.ipynb		2-intro-geopandas.ipynb
3-SQL-and-Pandas.ipynb		3-SQL-and-Pandas.ipynb
LICENSE		LICENSE
README.md		README.md