Skill Up Card - Course Bundles

Pricing is per delegate, giving you huge savings over the cost of individual courses.

  • UK = £2,000 + VAT per Skill Up Card
  • Ireland = €2,400 per Skill Up Card
skill up card logo - Nexus Human

Data Wrangling with Python

4.6 out of 5 rating Last updated 13/11/2024   English

Jump to outline

Click "Enquire" below to find out more about this course

Interested in available dates? Would like to book a private session of this course for your company? Or for any other queries please simply fill out the form below.


Duration

3 Days

18 CPD hours

Overview

By the end of this course, you will be confident in using a diverse array of sources to extract, clean, transform, and format your data efficiently.

Description

In this course you will start with the absolute basics of Python, focusing mainly on data structures. Then you will delve into the fundamental tools of data wrangling like NumPy and Pandas libraries. You'll explore useful insights into why you should stay away from traditional ways of data cleaning, as done in other languages, and take advantage of the specialized pre-built routines in Python.This combination of Python tips and tricks will also demonstrate how to use the same Python backend and extract/transform data from an array of sources including the Internet, large database vaults, and Excel financial tables. To help you prepare for more challenging scenarios, you'll cover how to handle missing or wrong data, and reformat it based on the requirements from the downstream analytics tool. The course will further help you grasp concepts through real-world examples and datasets.

Introduction to Data Structure using Python
  • Python for Data Wrangling
  • Lists, Sets, Strings, Tuples, and Dictionaries
Advanced Operations on Built-In Data Structure
  • Advanced Data Structures
  • Basic File Operations in Python
Introduction to NumPy, Pandas, and Matplotlib
  • NumPy Arrays
  • Pandas DataFrames
  • Statistics and Visualization with NumPy and Pandas
  • Using NumPy and Pandas to Calculate Basic Descriptive Statistics on the DataFrame
Deep Dive into Data Wrangling with Python
  • Subsetting, Filtering, and Grouping
  • Detecting Outliers and Handling Missing Values
  • Concatenating, Merging, and Joining
  • Useful Methods of Pandas
Get Comfortable with a Different Kind of Data Sources
  • Reading Data from Different Text-Based (and Non-Text-Based) Sources
  • Introduction to BeautifulSoup4 and Web Page Parsing
Learning the Hidden Secrets of Data Wrangling
  • Advanced List Comprehension and the zip Function
  • Data Formatting
Advanced Web Scraping and Data Gathering
  • Basics of Web Scraping and BeautifulSoup libraries
  • Reading Data from XML
RDBMS and SQL
  • Refresher of RDBMS and SQL
  • Using an RDBMS (MySQL/PostgreSQL/SQLite)
Application in real life and Conclusion of course
  • Applying Your Knowledge to a Real-life Data Wrangling Task
  • An Extension to Data Wrangling
Additional course details:

Nexus Humans Data Wrangling with Python training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward.

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the Data Wrangling with Python course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

FAQ for the Data Wrangling with Python Course

Available Delivery Options for the Data Wrangling with Python training.
  • Live Instructor Led Classroom Online (Live Online)
  • Traditional Instructor Led Classroom (TILT/ILT)
  • Delivery at your offices in London or anywhere in the UK
  • Private dedicated course as works for your staff.
How many CPD hours does the Data Wrangling with Python training provide?

The 3 day. Data Wrangling with Python training course give you up to 18 CPD hours/structured learning hours. If you need a letter or certificate in a particular format for your association, organisation or professional body please just ask.

What is the correct audience for the Data Wrangling with Python training?

Data Wrangling with Python takes a practical approach to equip beginners with the most essential data analysis tools in the shortest possible time. It contains multiple activities that use real-life business scenarios for you to practice and apply your new skills in a highly relevant context.

Do you provide training for the Data Wrangling with Python.

Yes we provide corporate training, dedicated training and closed classes for the Data Wrangling with Python. This can take place anywhere in Ireland including, Dublin, Cork, Galway, Northern Ireland or live online allowing you to have your teams from across Ireland or further afield to attend a single training event saving travel and delivery expenses.

What is the duration of the Data Wrangling with Python program.

The Data Wrangling with Python training takes place over 3 day(s), with each day lasting approximately 8 hours including small and lunch breaks to ensure that the delegates get the most out of the day.

Why are Nexus Human the best provider for the Data Wrangling with Python?
Nexus Human are recognised as one of the best training companies as they and their trainers have won and hold many awards and titles including having previously won the Small Firms Best Trainer award, national training partner of the year for Ireland on multiple occasions, having trainers in the global top 30 instructor awards in 2012, 2019 and 2021. Nexus Human has also been nominated for the Tech Excellence awards multiple times. Learning Performance institute (LPI) external training provider sponsor 2024.
Is there a discount code for the Data Wrangling with Python training.

Yes, the discount code PENPAL5 is currently available for the Data Wrangling with Python training. Other discount codes may also be available but only one discount code or special offer can be used for each booking. This discount code is available for companies and individuals.

Jump to dates

Training Insurance Included!

When you organise training, we understand that there is a risk that some people may fall ill, become unavailable. To mitigate the risk we include training insurance for each delegate enrolled on our public schedule, they are welcome to sit on the same Public class within 6 months at no charge, if the case arises.

What people say about us


Top

}