GRA 4142 Data Management and Python Programming
Examples of course material
Notebooks and slides
-
Week 1
01-Introduction.pdf
01-Variables-numeric-types-strings-input.ipynb -
Week 2
02-Conditional-execution-loops-functions.ipynb
02-Exercises.pdf
02-Exercises-solutions.ipynb -
Week 3
03-Lists-dictionaries-files-exceptions.ipynb
03-Exercises.pdf
shakespeare_sonnets.txt
03-Exercises-solutions.ipynb -
Week 4
04-NumPy-Matplotlib.ipynb
04-Exercises.pdf
04-Exercises-solutions.ipynb
04-Exercises-solutions-simpler.ipynb -
Week 5
05-Introduction-to-Pandas.ipynb
weather.csv
weather_precipitation.csv
05-Exercises.ipynb
complaints.csv
melbourne.csv
TSLA.csv
05-Exercises-solutions.ipynb -
Week 6
06-Pandas-cleaning-grouping-multi-level-indexes.ipynb
weather.csv
weather_unclean.csv
06-Exercises.ipynb
06-Exercises-solutions.ipynb
fashion.csv
parks.csv
species.csv -
Week 7, 8 and 9
07-Intro-to-relational-databases.pdf
07-SQL.pdf
07-SQL-exercises.pdf
07-SQL-exercises-solutions-part1.pdf
07-SQL-exercises-solutions-part2.pdf
07-SQL-exercises-solutions.pdf -
SQL vs Pandas
SQL-vs-Pandas.pdf -
Week 10 (optional session)
week10-extra.ipynb -
Week 10
10-Creating-and-populating-a-relational-database.ipynb
isqlite3.py
10-Relational-model.pdf
In-class-exercise.pdf
In-class-exercise-solution-task-2.png
In-class-exercise-solution-task-2.sql -
Week 11 (optional session)
Normalization-optional.pdf
Exercises-solutions.txt -
Week 11
11-Programming-with-databases.ipynb
11-In-class-exercises.ipynb
11-In-class-exercises-solutions.ipynb
sqltutorial.db -
Week 12 (optional session)
ER-model.pdf
In-class-exercises-solution.png -
Week 12
12-Indexes-and-transactions.pdf
