Permalink
Switch branches/tags
Nothing to show
Find file Copy path
d308a6f Aug 29, 2017
1 contributor

Users who have contributed to this file

27 lines (14 sloc) 1.29 KB

ETL with Python and MySQL

ETL with Python Training - Taught during Data Warehousing course - Tel Aviv University 2017

The Training is planned for ~2 hours and contains 4 notebook files:

Data files:

  • drinks.json - drinks consumption data (source)

  • drinks.zip - zipped json file (used for a zip file example in ETL notebook)

  • assuming you have default build-in world schema of MySQL (for mysql-io exercise). If not you can get it by running CreateWorld.sql - dump of sql scripy for creating world schema for mysql-io exercise.

  • file1.csv/file2.csv/flie3.csv - csv examples for csv library

  • simpsons_phone_book.csv - csv example for sniffer