Course materials for Python and SQL: intro / SQL platforms - UW
dr Jakub Michańków, email: j.michankow@uw.edu.pl
Online, at meeting link below.
Group 1: 23th Jan 2025, 13:15
Group 4: 23th Jan 2025, 15:00
https://meet.google.com/rfw-gtmc-ytv
- Introdution and course organization, environment setup (github, jupyter, colab/kaggle)
- Basics, flow control and text files
- Functions and objects
- Numpy (algebra) and Pandas (data handling)
- Intro to SQL part 1
- Data visualization (matplotlib and Seaborn)
- Python for web apps (XML, JSON, scrapping)
- Intro to SQL part 2
- Project and presentation (60%)
- Written test (40%)
- Final grade: 0.6 * project score + 0.4 * test score + extra pts
To pass the course you need at least 60% total AND at least 20.5%(51%) from the test.
- Project proposal: 31st October - choose the topic and and members of your team (3-4 people), send via email.
- Presetations: 28th November - Around 5 mins, the presentation needs to include slides with title page (including authors), information on why you chose you topic, how you want to solve the problem, short description of the tools you are going to use and short description of each team member responsibilities.
- Project delivery: 16th of January - Practical project will be a progam of your design, built with Python and any SQL language.
- Test: 23rd of January
Use of generative AI is allowed only to help you with your coding. Any parts of the code that have been generated need to clearly marked by comments in the code, where you need to state the scope of the support the type of AI model and its version.
Plagiarism is not tolerated in any form (including self-plagiarism). You are not allowed to copy parts from one project to another and you always need to provide an exact source.
- 03.10.2024 - Intro - Download and install Python, download and install VSCode. Try to run a simple code, e.g.
print(2+2). - 10.10.2024 - Python basics. Lecture 1 notebook, Exercise 1 Notebook
- 17.10.2024 - Flow control. Lecture 2 notebook, Exercise 2 Notebook
- 24.10.2024 - Functions and objects. Lecture 3 notebook, Exercise 3 Notebook
- 31.10.2024 - Numpy. Lecture 4 notebook, Exercise 4 Notebook
- 07 & 14.11.2024 - Pandas. Lecture 5 notebook, Exercise 5 Notebook
- 21.11.2024 - SQL part 1 Lecture 6 notebook, Exercise 6 Notebook
- 05.12.2024 - Visualizations Lecture 7_1 notebook, Exercise 7 Notebook
- 12.12.2024 - Seaborn, Plotly Lecture 7_2 notebook
- 19.12.2024 - SQL pt 2 Lecture 8 notebook
- 09.01.2025 (asynchronous) - Lecture 9 notebook, Exercise 9 Notebook
- 16.01.2025 - Web scraping Lecture 10 notebook, Exercise 10 Notebook
- 23.01.2025 - Final test
Classes on 09.01 are synchronous only, meaning that there wont be an online meeting on this day.