< Go back to Python for Data Analysts & Quants training course
Editor (add & remove topics to suit your needs)
INSTALLATION & PACKAGING
Installation, packaging and virtualisation of Python using Conda.
We'll set up Python using the Anaconda distribution, a free and enterprise-ready Python distribution that includes hundreds of the most popular Python packages for science, math, engineering and data analysis.
Anaconda comes with Conda, a cross-platform tool for managing packages and virtual environments. We'll also set up Jupyter, a web-based interactive environment where users can organise, write and run their Python code in notebooks.
PYTHON CORE CONCEPTS & BEST PRACTICE
Introduction to Python basic concepts, data structures and control flow structures.
Overview of how Python is used for Data Science and Data Analytics projects.
Notions of Object-Oriented Programming and Functional Programming, applied to the design of Python applications and analysis pipelines using best practices.
Python DATA SCIENCE TOOLS
We'll explore the most important Python tools for Data Science.
NumPy, short for Numerical Python, is one of the main building blocks for scientific computing in Python. It provides high speed manipulation of multi-dimensional arrays and it's used by higher level libraries (like pandas) to support sophisticated analytics with high speed computation.
Pandas is a highly performant library for data manipulation and data analysis in Python.
It's built on top of NumPy and optimised for performance, while offering a high-level interface.
We'll discuss how to create and manipulate Series and DataFrame objects in pandas, accessing data from multiple sources, cleaning and transforming data sets to get them in the right shape for advanced analysis.
ACCESSING & PREPARING DATA
Data can come in multiple formats and from multiple sources. We'll examine how to read and write data from local files in different formats, and how to access data from remote source.
Data cleaning and data preparation are the first steps in a data analysis project, so we'll discuss how to perform data transformation to get ready for further analysis.
With our data in the right shape, we're ready to analyse them in order to extract useful insights.
We'll perform the computation of summary information and basic statistics from data sets.
We'll approach split-apply-combine operations with Data Frames, in order to perform advanced transformations and reshaping our data with pandas.
We'll query our Data Frames using the powerful group-by method.
Data analysis benefits from the visualisation of data. If a picture if worth a thousand words,
complex data structures can be easier to understand and analyse using effective visualisation
Communicating the results with non-technical users is also a challenge that
visualisation techniques help to overcome.
The Anaconda distribution as Python Data Science platform
Overview on Python virtual environment set-up
Running code in Jupyter notebook
Python core concepts
Core data types in Python
Control flow statements
Defining and using custom functions
The Python standard library
Working with data:
- Iteration and list comprehensions
- Accessing raw data on file (CSV, JSON, ...)
- Working with dates and times
Basics of Object-Oriented Programming in Python
Python Data Science libraries
- Working with NumPy arrays
- Essential operations with NumPy arrays
- Stats and linear algebra with NumPy
- Working with table-like data in pandas
- Essential operations with Series and DataFrame object
- Loading data from file into DataFrame objects
- Summary statistics over DataFrame objects
- Data aggregation queries (groupby() method)
- Exploratory analysis of new datasets
- Data visualisation over DataFrames
- Join/merge operations with DataFrames
- Working with text data in DataFrames
- Working with relational databases in Python
- Overview on SQLAlchemy for database interaction
- Integration of pandas and SQL
Python packaging: using and creating custom libraries
Unit testing: tools to perform unit testing in Python
Interaction with web services
Audience & Requirements
Duration, location and dates
If you have a course length in mind, please select from the list
More than 5 days
Where would you like the course to be held?
On your site
At our London offices
Please quote for both options
Where is your site located?
If you have a date and location in mind, enter them here....
Complete the form oppositebelow to get your quote >>>
GET A CUSTOM COURSE QUOTE
Complete this form for an instant quote Or for more information call 0800 028 6400
Subscribe to our Newsletter – Receive the latest info on Tech courses & insights Subscribe