Who should attend?
This course would suit anyone with an interest in Python, but particularly those who would like to use it to analyse and present information on big datasets. We teach the Python language from first principles, meaning no prior coding experience is necessary. The course is not heavy on mathematical content either, so to remain accessible for attendees from many backgrounds.
Python is arguably the fastest growing programming language in the world, for good reason. Due to its simplicity, open-source nature, large community, and wealth of application, Python can be used to solve business problems in many sectors, not least in finance. The objective of this 2-day workshop is to gain confidence in the main elements of Python programming and its application to basic financial data science problems. The first day of the course is spent acquiring a suite of Python language skills. The second day applies Python and Python packages (libraries) to some data science projects, including importing, cleaning, enrichment, transformation, visualization and output of large financial datasets.
- Learn to write, test and debug Python 3 code with confidence, including working with Containers, Conditionals & Loops, Functions & Modules and Error Handling.
- Learn the fundamentals of some of the most widely used Python packages; including NumPy, Pandas and Matplotlib, then apply them to Data Analysis and Data Visualization projects.
- Design and code a Graphical User Interface (GUI) to run a loan calculator program.
Day 1 - Learning the Language
- The Anaconda Distribution & Spyder IDE
- The Python 3 Language
- Core Syntax
- Lists (Arrays)
- Conditionals and Loops
- Functions (User-defined)
- Error Handling
Day 2: Basic Data Science Projects with Python Libraries
Project 1 (Pandas): Data Analysis
- File Parsing large csv files into Pandas DataFrames
- Reading & Locating / Slicing Data
- Print Display Options
- Data Cleaning
- Data Type Assignments
- Data Transformation: Manipulating DataFrames
- Removing (Dropping), Renaming Columns
- Adding Calculated Columns
- Sorting & Filtering Data
- Producing Summary Statistics
- Outputting the Manipulated Data to Excel
- Demo: The advantage of Python over Excel in working with Big Data
Project 2 (Matplotlib, NumPy, Pandas): Data Visualization
- Visualizing various types of custom data, with and without DataFrames
- Plotting Charts
- Chart Types: Line / Time Series, Scatter / Regression, Pie etc
- Adding Titles, Labels, Legends, Markers etc
- Adding Controls e.g. Sliders, Zooms etc
- Creating Subplots
- Saving charts as high-quality PNG images for use in Word, PowerPoint etc
Project 3 (NumPy, PyQt5Designer): Loan Calculator
- Building a Graphical User Interface (GUI) for user input, using the PyQt5Designer
- Coding the calculator with NumPy time value of money functions
"I like that the public courses are supported by online training. I can learn at my own pace and time, which has helped increase my confidence in the work that I do." ~ research analyst, global financial institution