Python for Data Analysts

16 sessions of 4 academic hours - from SQL and SAS to Python, pandas and NumPy

From SQL and SAS to Python

Every topic starts from what you already do in SQL or SAS - CASE WHEN, GROUP BY, JOIN, DATA step, PROC SORT - and shows the Python way.

Press Run under any example, change the code with Edit, and see the output right away. Python runs in your browser, with pandas and NumPy.

Each lecture has practice tasks you run with Python. Every task checks itself and prints OK or FAIL.

Session	Topic
1	Introduction, syntax, data types and variables
2	Conditional statements and loops
3	Lists (basics), tuples and sets
4	Functions
5	Lists (advanced)
6	Dictionaries
7	Text processing
8	Regular expressions
9	Error handling and file handling
10	Modules, packages, Git and GitHub
11	OOP: first steps, classes and objects
12	OOP in practice: nomenclatures
13	Working with databases
14	NumPy and introduction to pandas
15	pandas: selection, aggregation, joins
16	pandas: reports and the final project