Foundations of Computer Science (2018-19)
Lecture plan
| # | Who | Date | Topic | Material | Assignments | Solutions | |
|---|---|---|---|---|---|---|---|
| 1 | GDV | 2/10 | Introduction to the Jupyter Notebook, Array, lists, loops | Notebook 1 Notebook 2 Notebook python basics Notebook introduction | |||
| 2 | MP | 5/10 | Print, lists, dictionaries | Exercise, PromessiSposi.txt | Solution Part 1 | ||
| 3 | GDV | 9/10 | Separator-based files. Relational model DBMS. Schemas and instances. Exploring a DB. Constraints, Keys, Indices. Null values. Linux shell. | slides slides | slides slides slides null values | ||
| 4 | MP | 12/10 | Reading files, functions, and libraries. | Same exercise as Lesson 2 | Full solution to ex-01 | ||
| 5 | MP | 19/10 | Regular Expressions | Regex Docs | Exercise, email.txt, numbers.txt, exp_nums.txt | Solution Part 1 Full Solution | |
| 6 | GDV | 23/10 | Select..From..Where on 1 table. Aggregate operators | slides | Northwind 1 | Solution | |
| 7 | MP | 26/10 | Queries on 1 table | NorthWind | Northwind 2 | Solution | |
| 8 | GDV | 6/11 | Pandas: introduction and indexing. | Notebook Notebook | Exercise | Solution | |
| 9 | MP | 9/11 | Pandas: aggregating data | Notebook Docs | Exercise | Solution | |
| 10 | GDV | 13/11 | Pandas: missing data. Hierchical indexing | Notebook missing data Notebook Multindex | Exercise | Solution | |
| 11 | MP | 16/11 | Concatenating and merging tables | Notebook concat Notebook merge | Exercise | Solution | |
| 12 | GDV | 23/11 | Querying more tables in SQL | slides | Exercise | Solution | |
| 13 | GDV | 27/11 | Parsing files. List manipulation: comprehension, zip | slides docs | Exercise | Solution | |
| 14 | MP | 30/11 | Basic shell usage, ssh, ssh tunneling | See “Linux shell commands” at the end of this page and this video for a quick introduction to ssh. | |||
| 15 | GDV | 4/12 | Exercise on list comprehensions | docs | Exercise | Solution | |
| 16 | GDV | 11/12 | Set operations | slides | Exercise | Solution | |
| 17 | MP | 14/12 | Version control, Assertions, Debugging | version control, assertions | |||
| 18 | GDV | 18/12 | Nested queries. Accessing databases | slides | Exercise Exercise | Solution | |
| 19 | MP | 21/12 | Case study | Exercise, fifa18 db | Solution |
Final project
Connect to the Jupyter Notebook
- SSH into the VM. Launch the following commands in the VM
source activate py36byobujupyter-notebook –no-browser- copy the jupyter URL
- On your PC, in the Command Prompt / Linux Terminal:
plink -ssh -L 8888:localhost:8888 -P 63093 studente@dellavedova-lab1328112946001.northeurope.cloudapp.azure.com- On your PC, go the the jupyter URL
Linux shell commands
- ls, cd, pwd
- mv cp nano touch rsync
- redirection pipe cut wc sort head tail
- for history echo
- bash programs, script, filenames with spaces
- grep, find
- fg, bg, ctrl+c, ctrl+z, ps, kill, chmod
License
This work is licensed under a Creative Commons Attribution 4.0 International License.