Code, data, and materials for my SQL Python workshop at Frauenloop, Berlin, October 7, 2019.
Technical requirements
- Python 3.7.4 (not tested with lower Python versions)
- requirements.txt
Please follow this guide to get python, anaconda environments, and an IDE set up.
-
How to use jupyter notebooks. In basics_pandas.ipynb we have an example of how to read, manipulate, and save a dataset. You can extend this notebook our create your own to e.g. expore data under
/data. -
Using pandas to explore data. Examples and exercises are provided in exercises_airbnb_listings.md based on the code in airbnb_listings.py.
-
SQL language, by playing with our mock movie rental service data. The doc exercises_movie_rentals.md together with the script movie_rentals.py walk you through an example of creating and querying a sqlite database. Some introductory notes about databases and RDBMSes can also be consulted.
-
(advanced) Install and use the GeoPandas library to work with geospatial data. We will follow airbnb_geopandas.md and airbnb_geopandas.py.