Python Courses

The Introduction to Data Manipulation course focuses on Python’s powerful pandas library. This hands-on training will provide students with the fundamentals of data analysis in Python and the pandas library.

Dates

What will this training cover?

  • Python set up: Ensuring Python set up on machine or online access via Microsoft Azure Notebooks. Python environment set up including installation of required libraries.
  • Pandas library Introduction: Overview of Pandas/Numpy and the Jupyter notebook environment for creating and sharing documents.
  • Pandas Data Structures: Series and DataFrames
  • Input & Output: Text files, Excel files, clipboard, HTML, JSON, SQL.
  • Data Manipulation: Merging, Filtering, Concatenating, Reshaping, Pivoting, etc
  • Working with Dates and Times: Formatting data for commonality
  • Visualisation
  • Top tips and tricks

What will this training teach you to do?

  • Analyse data quickly and easily in Python using the Pandas library
  • Confidence using the Jupyter Notebook as an environment for data exploration including data cleaning, transformation and data visualization
  • Import, build and manipulate DataFrames to structure your data for manipulation and analysis
  • Gain a skillset in Python

Who is this training for?

This course is suitable for those who have basic programming knowledge and provides a practical introduction to Python for data manipulation. Tailored towards web/data analysts, this course is perfect for those involved in the analysis and management of data.

In particular, if you are tasked with regular reporting, or find yourself deep in Microsoft Excel spreadsheets, this course aims at providing the foundations for users wanting to make the leap from analysis in Excel to Python.

The Introduction to Python for data manipulation training is aimed primarily at data/web analysts but is suitable for anyone wanting to advance their knowledge of how to start utilising Python in their workflow. Students should be familiar with basic data analysis concepts and have some basic programming knowledge.

The Introduction to Python for Web Analysts course covers core fundamentals of the language from the perspective of a Web Analyst. This hands-on training will provide familiarity with Python and confidence to start using this programming language to help aggregate and visualise data.

This course will take you through the introductory concepts of Python to provide an overview of terminology, tools, packages and data structures that can be applied in an analytics environment.

Dates

What will this training cover?

  • Installing Python: How to set up Python on your machine/ online access via Microsoft Azure Notebooks.
  • Introduction: Python Interpreter/Jupyter notebooks, Language introduction, Structure, Statements, Resources
  • Python Object & Data Structure Basics: Data Types including numbers, sequences and Dictionaries, Variables, Expressions & Operators
  • Control Flow Statements: Controlling the order in which a program’s code executes including if, while and for statements
  • Functions: Grouping statements into reusable function calls
  • Regular Expressions: Powerful tool for text manipulation
  • Modules and Packages: Intro to modules and libraries, including Pandas
  • Input/Output with Basic Text Files: Reading & writing to CSV files
  • Top tips and tricks

What will this training teach you to do?

  • An understanding and overview of the Python 3 fundamentals
  • Creating, reading and writing to files
  • Understand the different sources of data that can be handled via Python
  • Iteration through strings, lists and ranges to speed up queries
  • Build reusable functions allowing you to call code repeatedly using a single short command
  • How to use conditional statements and loops to set up control flow logic within your code
  • Understand how modules and libraries provide standardized solutions for many problems that occur in everyday programming, and where to find the most relevant ones.

Who is this training for?

This course is suitable for those who have no programming experience and provides a practical introduction to both Python and programming in general. Tailored towards web analysts, this course is a great introduction to the Python language and explores how it can be used to streamline reporting and analysis.

WHY TRAIN WITH MEZZO LABS?

  • One-day classroom-based training course in central London
  • Small groups of maximum 10 attendees
  • Expert GA trainer
  • Hands-on practical exercises and interactive quizzes
  • Training materials shared after the course
  • 3 months of post-course email-based support
  • Excellent coffee, artisan sandwiches and plenty of snacks through the day

LOCATION

OLD STREET, LONDON

VIEW MAP

PRICE

PRICE AVAILABLE ON REQUEST