HOME
 

Data Analysis Python

StayAhead Training
Course summary
4 days
2,200 GBP excl. VAT
Professional Training
Next available date: 19/10/2020 09:30 - Online courses
Course Dates
London
19/10/2020 09:30 
2,200 GBP
03/11/2020 09:30 
2,200 GBP
25/01/2021 09:30 
2,200 GBP
Online courses
19/10/2020 09:30 
2,200 GBP
03/11/2020 09:30 
2,200 GBP
25/01/2021 09:30 
2,200 GBP

Course description

This course focuses on the extensive features of the Python data analysis workhorse library, Pandas, and its visualisation counterpart Matplotlib. It covers the reading, preparation and manipulation of tabular data from various sources and in various common formats. Most wrangling and manipulation processes are covered. Time series data processing and practical linear regression are also covered. For the programming environment we use JupyterLab on the Anaconda platform. Anaconda is one of the most, if not the most, popular data science platforms.

Approach:

We believe in learning by doing and take a hands-on approach to training. Delegates are provided with all required resources, including data, and are expected to code along with the instructor. The objective is for delegates to reproduce the analysis in our manuals as well as gain a conceptual understanding of the methods.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

Skills Gained

The delegate will learn and acquire skills as follows:

  • Read csv, excel and json format data into Pandas DataFrame objects
  • Fetch data from local files, web url and a relational database
  • Concatinating DataFrames
  • Clean, pivot, group, manipulate and summarise tabular data
  • Understand, read and process time series data
  • Perform single and multiple predictor variable linear regression calculations
  • Plot bar and pie charts, histograms, scatter and line graphs, using Matplotlib
  • Use JupyterLab
Who will the Course Benefit?

This course is designed for anyone with Python programming experience wanting to gain a solid foundation in Python's data analysis libraries. It is a must for aspiring Data Analysts and Scientists. Existing Data Analysts wanting a systematic introduction to Python's Data Analysis tools would also find the course very useful.

Course Objectives

This course aims to provide delegates, who already have Python programming experience, in-depth knowledge of Python's main data analysis and visualization libraries (Pandas and Matplotlib). The knowledge gained will enable delegates to design and develop enterprise level data analytics solutions.

Requirements

Programming:

  • Delegates are expected to have Python programming experience. They should be able to effectively use Python containers (lists, tuples, dictionaries, and sets), construct loops and conditional statements, write functions and create and use classes and objects. Skills and knowledge that can be acquired by taking our Python Programming 1 course

Numeracy:

  • Able to calculate and interpret averages, standard deviations and similar basic statistics
  • Ability to read and understand charts and graphs
  • For linear regression; an understanding of the meaning of a linear graph (or an ability to understand it quickly when explained)
  • Mathematics: GCSE or equivalent
Pre-Requisite Courses
  • Python Programming 1
Notes:
  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.
Data Analysis Python Training Course

Course Contents - DAY 1

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: INTRODUCTION TO DATAFRAMES

  • What is a DataFrame?
  • Loading DataFrames
  • Accessing contents
  • Useful functions
  • Adding and dropping columns and rows

Session 2: INTRODUCTION TO DATAFRAMES (CONTINUED)

  • Fitering and assigning data
  • Missing values and duplicates
  • Arithmetic basics
  • Applymap and apply
Data Analysis Python Training Course

Course Contents - DAY 2

Session 3: COMBINING DATAFRAMES

  • Concatinate
  • Merge
  • Keys to merge on and suffixes for duplicate columns
  • Merge methods
  • Append
  • Join
  • Combine_first: For missing values

Session 4: RESHAPING DATAFRAMES

  • Unstacking and Stacking
  • Pivoting
  • Melting
  • Concatinating files from disk

Session 5: GROUPBY AND AGGREGATION: SPLIT-APPLY-COMBINE

  • Basic GroupBy
  • Hierarchical GroupBy
  • Group by function of Index
Data Analysis Python Training Course

Course Contents - DAY 3

Session 6: GROUPBY AND AGGREGATION: SPLIT-APPLY-COMBINE (CONTINUED)

  • Aggregate by mapping on Index and Columns
  • Aggregate by user-defined functions
  • Aggregate using multiple functions
  • Aggregate using separate function for each column

Session 7: GROUPBY AND AGGREGATION: SPLIT-APPLY-COMBINE (CONTINUED)

  • Transfrom
  • Apply function
  • Pivoting with Aggregation

Session 8: PLOTTING WITH MATPLOTLIB

  • Pie chart
  • Bar chart
  • Histogram
  • Scatter plot
  • Line plot
Data Analysis Python Training Course

Course Contents - DAY 4

Session 9: TIME SERIES DATA

  • Basic Concepts; Datetime, Timestamp, Timedelta, Timezones
  • Pandas to_date() fucntion
  • Date Range
  • What is time series data
  • Reading time series data
  • Missing Dates
  • Partial indexing, Slicing and Selecting
  • Resampling
  • Moving Window functions

Session 10: LINEAR REGRESSION

  • What is linear regression?
  • Simple Linear regression
  • Multiple Regression

This course focuses on the extensive features of the Python data analysis workhorse library, Pandas, and its visualisation counterpart Matplotlib. It covers the reading, preparation and manipulation of tabular data from various sources and in various common formats. Most wrangling and manipulation processes are covered. Time series data processing and practical linear regression are also covered. For the programming environment we use JupyterLab on the Anaconda platform. Anaconda is one of the most, if not the most, popular data science platforms.

Approach:

We believe in learning by doing and take a hands-on approach to training. Delegates are provided with all required resources, including data, and are expected to code along with the instructor. The objective is for delegates to reproduce the analysis in our manuals as well as gain a conceptual understanding of the methods.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

Skills Gained

The delegate will learn and acquire skills as follows:

  • Read csv, excel and json format data into Pandas DataFrame objects
  • Fetch data from local files, web url and a relational database
  • Concatinating DataFrames
  • Clean, pivot, group, manipulate and summarise tabular data
  • Understand, read and process time series data
  • Perform single and multiple predictor variable linear regression calculations
  • Plot bar and pie charts, histograms, scatter and line graphs, using Matplotlib
  • Use JupyterLab
Who will the Course Benefit?

This course is designed for anyone with Python programming experience wanting to gain a solid foundation in Python's data analysis libraries. It is a must for aspiring Data Analysts and Scientists. Existing Data Analysts wanting a systematic introduction to Python's Data Analysis tools would also find the course very useful.

Course Objectives

This course aims to provide delegates, who already have Python programming experience, in-depth knowledge of Python's main data analysis and visualization libraries (Pandas and Matplotlib). The knowledge gained will enable delegates to design and develop enterprise level data analytics solutions.

Requirements

Programming:

  • Delegates are expected to have Python programming experience. They should be able to effectively use Python containers (lists, tuples, dictionaries, and sets), construct loops and conditional statements, write functions and create and use classes and objects. Skills and knowledge that can be acquired by taking our Python Programming 1 course

Numeracy:

  • Able to calculate and interpret averages, standard deviations and similar basic statistics
  • Ability to read and understand charts and graphs
  • For linear regression; an understanding of the meaning of a linear graph (or an ability to understand it quickly when explained)
  • Mathematics: GCSE or equivalent
Pre-Requisite Courses
  • Python Programming 1
Notes:
  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.
Data Analysis Python Training Course

Course Contents - DAY 1

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: INTRODUCTION TO DATAFRAMES

  • What is a DataFrame?
  • Loading DataFrames
  • Accessing contents
  • Useful functions
  • Adding and dropping columns and rows

Session 2: INTRODUCTION TO DATAFRAMES (CONTINUED)

  • Fitering and assigning data
  • Missing values and duplicates
  • Arithmetic basics
  • Applymap and apply
Data Analysis Python Training Course

Course Contents - DAY 2

Session 3: COMBINING DATAFRAMES

  • Concatinate
  • Merge
  • Keys to merge on and suffixes for duplicate columns
  • Merge methods
  • Append
  • Join
  • Combine_first: For missing values

Session 4: RESHAPING DATAFRAMES

  • Unstacking and Stacking
  • Pivoting
  • Melting
  • Concatinating files from disk

Session 5: GROUPBY AND AGGREGATION: SPLIT-APPLY-COMBINE

  • Basic GroupBy
  • Hierarchical GroupBy
  • Group by function of Index
Data Analysis Python Training Course

Course Contents - DAY 3

Session 6: GROUPBY AND AGGREGATION: SPLIT-APPLY-COMBINE (CONTINUED)

  • Aggregate by mapping on Index and Columns
  • Aggregate by user-defined functions
  • Aggregate using multiple functions
  • Aggregate using separate function for each column

Session 7: GROUPBY AND AGGREGATION: SPLIT-APPLY-COMBINE (CONTINUED)

  • Transfrom
  • Apply function
  • Pivoting with Aggregation

Session 8: PLOTTING WITH MATPLOTLIB

  • Pie chart
  • Bar chart
  • Histogram
  • Scatter plot
  • Line plot
Data Analysis Python Training Course

Course Contents - DAY 4

Session 9: TIME SERIES DATA

  • Basic Concepts; Datetime, Timestamp, Timedelta, Timezones
  • Pandas to_date() fucntion
  • Date Range
  • What is time series data
  • Reading time series data
  • Missing Dates
  • Partial indexing, Slicing and Selecting
  • Resampling
  • Moving Window functions

Session 10: LINEAR REGRESSION

  • What is linear regression?
  • Simple Linear regression
  • Multiple Regression

This course focuses on the extensive features of the Python data analysis workhorse library, Pandas, and its visualisation counterpart Matplotlib. It covers the reading, preparation and manipulation of tabular data from various sources and in various common formats. Most wrangling and manipulation processes are covered. Time series data processing and practical linear regression are also covered. For the programming environment we use JupyterLab on the Anaconda platform. Anaconda is one of the most, if not the most, popular data science platforms.

Approach:

We believe in learning by doing and take a hands-on approach to training. Delegates are provided with all required resources, including data, and are expected to code along with the instructor. The objective is for delegates to reproduce the analysis in our manuals as well as gain a conceptual understanding of the methods.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

Skills Gained

The delegate will learn and acquire skills as follows:

  • Read csv, excel and json format data into Pandas DataFrame objects
  • Fetch data from local files, web url and a relational database
  • Concatinating DataFrames
  • Clean, pivot, group, manipulate and summarise tabular data
  • Understand, read and process time series data
  • Perform single and multiple predictor variable linear regression calculations
  • Plot bar and pie charts, histograms, scatter and line graphs, using Matplotlib
  • Use JupyterLab
Who will the Course Benefit?

This course is designed for anyone with Python programming experience wanting to gain a solid foundation in Python's data analysis libraries. It is a must for aspiring Data Analysts and Scientists. Existing Data Analysts wanting a systematic introduction to Python's Data Analysis tools would also find the course very useful.

Course Objectives

This course aims to provide delegates, who already have Python programming experience, in-depth knowledge of Python's main data analysis and visualization libraries (Pandas and Matplotlib). The knowledge gained will enable delegates to design and develop enterprise level data analytics solutions.

Requirements

Programming:

  • Delegates are expected to have Python programming experience. They should be able to effectively use Python containers (lists, tuples, dictionaries, and sets), construct loops and conditional statements, write functions and create and use classes and objects. Skills and knowledge that can be acquired by taking our Python Programming 1 course

Numeracy:

  • Able to calculate and interpret averages, standard deviations and similar basic statistics
  • Ability to read and understand charts and graphs
  • For linear regression; an understanding of the meaning of a linear graph (or an ability to understand it quickly when explained)
  • Mathematics: GCSE or equivalent
Pre-Requisite Courses
  • Python Programming 1
Notes:
  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.
Data Analysis Python Training Course

Course Contents - DAY 1

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: INTRODUCTION TO DATAFRAMES

  • What is a DataFrame?
  • Loading DataFrames
  • Accessing contents
  • Useful functions
  • Adding and dropping columns and rows

Session 2: INTRODUCTION TO DATAFRAMES (CONTINUED)

  • Fitering and assigning data
  • Missing values and duplicates
  • Arithmetic basics
  • Applymap and apply
Data Analysis Python Training Course

Course Contents - DAY 2

Session 3: COMBINING DATAFRAMES

  • Concatinate
  • Merge
  • Keys to merge on and suffixes for duplicate columns
  • Merge methods
  • Append
  • Join
  • Combine_first: For missing values

Session 4: RESHAPING DATAFRAMES

  • Unstacking and Stacking
  • Pivoting
  • Melting
  • Concatinating files from disk

Session 5: GROUPBY AND AGGREGATION: SPLIT-APPLY-COMBINE

  • Basic GroupBy
  • Hierarchical GroupBy
  • Group by function of Index
Data Analysis Python Training Course

Course Contents - DAY 3

Session 6: GROUPBY AND AGGREGATION: SPLIT-APPLY-COMBINE (CONTINUED)

  • Aggregate by mapping on Index and Columns
  • Aggregate by user-defined functions
  • Aggregate using multiple functions
  • Aggregate using separate function for each column

Session 7: GROUPBY AND AGGREGATION: SPLIT-APPLY-COMBINE (CONTINUED)

  • Transfrom
  • Apply function
  • Pivoting with Aggregation

Session 8: PLOTTING WITH MATPLOTLIB

  • Pie chart
  • Bar chart
  • Histogram
  • Scatter plot
  • Line plot
Data Analysis Python Training Course

Course Contents - DAY 4

Session 9: TIME SERIES DATA

  • Basic Concepts; Datetime, Timestamp, Timedelta, Timezones
  • Pandas to_date() fucntion
  • Date Range
  • What is time series data
  • Reading time series data
  • Missing Dates
  • Partial indexing, Slicing and Selecting
  • Resampling
  • Moving Window functions

Session 10: LINEAR REGRESSION

  • What is linear regression?
  • Simple Linear regression
  • Multiple Regression

Expenses

£2,200.00

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

About provider

StayAhead Training: Linux, Oracle, SQL, Professional IT Courses

Live Virtual Training with our live Course Instructor is offered for all our courses.  Take the course from the comfort of your office, home or any location of your choice, nationally and internationally.  Public schedule and Closed Company courses.  Flexibility...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Data Analysis Python.

  Contact the provider

  Get more information

  Register your interest

Contact info

StayAhead Training

6 Long Lane, Barbican
EC1A 9HF London

 Show phone number
www.stayahead.com


Request information

Find out more about this Data Analysis Python course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here