Description
This program is designed to give the participants a strong flavour of using Python for data management and analytics. We would use Anaconda distribution of Python 3 to implement the hands-on aspects of the training. The program has no pre-requisites in programming and will focus exclusively on data manipulation and visualization. We will use 3 – 4 datasets ( excel sheets) extensively to understand how Python 3 can be used to process financial data.

Duration

• 4 Days

Objectives

• Install Anaconda and use Spyder and Jupyter notebook for data manipulation
• Understand the various data types and data structures in Python
• Implement loops and control statements in Python
• Understand the utility of methods and functions
• Understand Iterators, Generators and Decorators
• Understand the role of Numpy Arrays in analytics
• Understand the Pandas library for data management
• Learn to apply visualization techniques using matplotlib, bokeh and plotly

Prerequisites

• Anaconda for Python 3 must be installed
• Basic Python programming is mandatory

Day 1 : Basics of Python Programming

• Introduction
• Objectives
• Spyder and Jupyter notebooks
• Introduction to Data Types and Data Structures
• Numbers
• Strings
• Boolean
• Lists and Tuples
• Sets and Dictionaries

Day 2 : Programming Paradigms in Python

• Operators
• Conditional Statements
• Loops
• Functions
• Methods
• Object Oriented Programming
• Dealing with errors
• Handling files

Day 3 : Data Management in Python

• Numpy Arrays
• Indexing
• Processing Arrays
• Introduction to Pandas
• Merge
• Combine
• Reshape
• Pivot
• Groupby
• Aggregate
• Cross-tabs

Day 4 : Visualization in Python

• Line Plot
• Scatter Plot
• Histogram
• Customizations
• Plotting 2D Arrays
• Statistical Plots using Seaborn
• Dealing with time series
• Introduction to Interactive plots with bokeh
• Introduction to Interactive plots with plotly