These are the exercise files used for WSQ - Python Programming for Finances course.
The course outline can be found in
https://www.tertiarycourses.com.sg/wsq-python-programming-finance.html
Topic 1 Introduction to Python Programming
- Business requirements and objectives
- Applications of Python programming to meet business requirements
- Install Python and Setup Python IDE
Topic 2: Data Types and Operators
- Data Types
- Operators
Topic 3 Problem Solving with Control Structures
- Problem solving with conditional and loop techniques
- Coding using comprehensions
Topic 4 Scripting with Function and Lambda
- Create Python functions to meet business use cases
- Lambda function and its applications
Topic 5 Import and Process Finance Data
- Data analysis using Pandas package
- DataFrame and Series data structures
- Import finance data
- Filter and slice finance data
- Clean missing data
Topic 6 Aggregate and Visualize Finance Data
- Join finance data with concat, append and merge
- Aggregate data with groupby and pivot table
- Assess codes to identify gaps
- Test and visualize finance data
Topic 7 Analyze Finance Data
- Improve codes with pipe and apply
- Applications of statistics
- Analyse finance data to track any changes
Mode of Assessment
- Written Assessment (Q&A)
- Practical Performance