Class Information

Algorithms, SQL and Python modules for data analytics

  • Module Instructor: Stelios Sotiriadis
  • Time: Tuesday and Wednesday at 1:30-5:00pm
  • Wednesday 21 November at 1:30-3:00pm class will be at Birkbeck, 43 Gordon Square, Room GOR B04
  • Tuesday 27 November at 1:30-3:00pm class will be at Birkbeck, Malet street, Room G13 Rooms:
    • Tuesday's classes are in MAL 404
    • Wednesday's classes are in MAL 404
  • Teaching Assistant: Manni Singh, Dimitris Kargatzis
  • Solutions to exercises: Link to code

November Monday 5 Tuesday 6 Wednesday 7 Thursday 8 Friday 9
Office hours: 12pm-1pm

Class/lab: 1:30pm-5pm

Monday 12 Tuesday 13 Wednesday 14 Thursday 15 Friday 16
Office hours: 1pm-3pm Office hours: 12pm-1pm

Class/lab: 1:30pm-5pm

Office hours: 12pm-1pm

Class/lab: 1:30pm-5pm

Monday 19 Tuesday 20 Wednesday 21 Thursday 22 Friday 23
Office hours: 1pm-3pm Office hours: 12pm-1pm

NO CLASS!

Office hours: 12pm-1pm

Class: 1:30pm-3pm Lab: 3:00pm-5pm

Monday 26 Tuesday 27 Wednesday 28 Thursday 29 Friday 30
Office hours: 1pm-3pm Office hours: 12pm-1pm

Class: 1:30pm-3pm Lab: 3pm-5pm

Office hours: 12pm-1pm

Class/lab: 1:30pm-5pm

December Monday 3 Tuesday 4 Wednesday 5 Thursday 6 Friday 7
Office hours: 1pm-3pm Office hours: 12pm-1pm

Class/lab: 1:30pm-5pm

Office hours: 12pm-1pm

Class/lab: 1:30pm-5pm

Monday 10 Tuesday 11 Wednesday 12 Thursday 13 Friday 14
Office hours: 1pm-3pm Office hours: 12pm-1pm

Class/lab: 1:30pm-5pm

Office hours: 12pm-1pm

Class/lab: 1:30pm-5pm

Class material

Material (pdf and ppsx formats) will be available before each lecture.

# Date Content Resources Room Material
Class 1 13 Nov 2018 Welcome to Programming with Data! Sorting & searching algorithms MAL 404 (CSC)
Lab 1 13 Nov 2018 Python & lab tools, Python recap Python recap: Chapter 1 (Joel Grus's Book)

MAL 404 (CSC)
Class 2 14 Nov 2018 Sorting, Binary search & Random numbers Binary search Interpolation search MAL 404 (CSC)
Lab 2 14 Nov 2018 Random numbers & benchmarking Random library MAL 404 (CSC)
Class 3 14 Nov 2018 Optimal stopping and probabilities Secretary problem MAL 404(CSC)
Lab 3 13 Nov 2018 Plotting and Probabilities Pyplot

MAL 404 (CSC)
Class 4 21 Nov 2018 Ethics I 43 Gordon Square, Room GOR B04
Lab 4 21 Nov 2018 Probabilities Probability problem MAL 404 (CSC)
Class 5 27 Nov 2018 Ethics II Malet street, Room G13
Lab 5 27 Nov 2018 Greedy algorithms Knapsack fractional Knapsack 0-1

MAL 404 (CSC)
Class 6 28 Nov 2018 Relational Databases I SQL w3schools MAL 404 (CSC)
Lab 6 28 Nov 2018 Gradient Descent J. Grus: Gradient Descent MAL 404 (CSC)
Class 7 4 Dec 2018 Relational Databases II SQL w3schools MAL 404 (CSC)
Lab 7 5 Dec 2018 SQLite and Pandas SQLite tutorial Pandas

MAL 404 (CSC)
Class 8 5 Dec 2018 Dynamic Programming GeeksforGeeks DP MAL 404 (CSC)
Lab 8 5 Dec 2018 Database design and SQL ER Model MAL 404 (CSC)
Class 9 11 Dec 2018 P and NP P vs. NP: Complexity zoo MAL 404 (CSC)
Lab 9 11 Dec 2018 Git and Transactional systems W3Schools SQL MAL 404 (CSC)
Class 10 12 Dec 2018 NP Complete, Probabilistic, Approximation algorithms QuickSort using Random Pivoting MAL 404 (CSC)
Lab 10 12 Dec 2018 DB design activity W3Schools SQL MAL 404 (CSC)