Python for Data Analysts & Quants training course

Environment Set-up

• The Anaconda distribution as Python Data Science platform
• Overview on Python virtual environment set-up
• Running Python code in Jupyter notebook

Python core concepts

• Built-in data types in Python
• Working with strings, numbers, lists, tuples and dictionaries
• Control flow statements
• Conditional execution with if statements
• Conditional loops with where statements
• Looping over a sequence with for statements
• Defining and using custom functions
• Working with dates and times
• Accessing data on file (CSV, JSON, ...)

Python Data Science libraries

• Working with data in pandas

• Working with table-like data in pandas
• Creating Series and DataFrame objects
• Loading data from file into DataFrame objects
• Adding, removing and updating databases

Retrieving data in pandas

• Querying data to extract specific rows and columns
• Filtering data on specific conditions
• Understanding pandas indexing

Data manipulation in pandas

• Data transformation
• Applying functions to transform individual values
• Applying functions to aggregate values by rows and columns