Data Wrangling with Python

Data is the new oil, but it comes crude. To do anything meaningful - modeling, visualization, machine learning, for predictive analysis – you first need to wrestle and wrangle with data. Data Wrangling with Python teaches you the essentials that will get you up and running with data wrangling in no time.

Overview

For data to be useful and meaningful, it must be curated and refined. Data Wrangling with Python teaches you the core ideas behind these processes and equips you with knowledge of the most popular tools and techniques in the domain.

The course starts with the absolute basics of Python, focusing mainly on data structures. It then delves 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.

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.

Scope

This course teaches concepts by deep-dive on-hand exercises. Throughout the course, you will learn data wrangling with hands-on exercises and activities. You’ll find checklists, best practices, and critical points mentioned throughout the lessons, making things more interesting.

Target Audience

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.

Course Outline

Lesson 1: Introduction to Data Structure using Python

• Python for Data Wrangling

• Lists, Sets, Strings, Tuples, and Dictionaries

Lesson 2: Advanced Operations on Built-In Data Structure

• Advanced Data Structures

• Basic File Operations in Python

Lesson 3: 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

Lesson 4: 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

Lesson 5: 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

Lesson 6: Learning the Hidden Secrets of Data Wrangling

• Advanced List Comprehension and the zip Function

• Data Formatting

Lesson 7: Advanced Web Scraping and Data Gathering

• Basics of Web Scraping and BeautifulSoup libraries

• Reading Data from XML

Lesson 8: RDBMS and SQL

• Refresher of RDBMS and SQL

• Using an RDBMS (MySQL/PostgreSQL/SQLite)

Lesson 9: Application in real life and Conclusion of course

• Applying Your Knowledge to a Real-life Data Wrangling Task

• An Extension to Data Wrangling

Acumen Envision run Technical IT courses that are engaging, creative and with content that sticks.

Super Creative

We don't believe in traditional & acceptable We do believe in Creative, Engaging & Sticky. People are not the same, the way they learn is not the same so a program has to engage all mindsets. We use a complex mix of engaging tools combined first class classroom delivery, and continuous measurement to ensure we produce true mindset and behavioural change.

Skilled Instructors

Without our highly skilled training team all of the pre-course consultancy and technology customisation would just not work. The wealth of experience and real world scenarios that they bring to each classroom module enhances the discussion, engagement and overall delivery. So, whether your people are attending a 1-1 Group or Public Technology program they will receive top level classroom tuition as part of their overall learning experience.

Acumen Envision the Transformation Specialists

Specialist Technical IT Training, Sticky Effective Disruptive, We Deliver First Class Results.

Data Science Training for Data Scientists, Data Analysts, Software Developers or Anyone working in a role or wanting to work with large data sets.

Our Data Science courses cover Data Visualization, Python, Jupyter, R, AI, Machine Learning, Data Wrangling, Excel VBA, Access VBA, Scala, Spark, Power BI, Tableau and much more.

Courses run for Data People by Data Specialists.

What’s Included:

• The latest Data Science course content

• Trainers who enjoy Data Science, delivering courses and talking about real word examples.

• Detailed course work book to take away

• Our Extras Pack for post course learning

• Certificate of completion

• Unlimited Refreshments

Why our content sticks.

• We take time to know our participants with pre course evaluation

• We don’t run large class sizes

• Our courses are delivered by subject matter experts who make the content engaging

• We like Hands on, so you can absorb the theory with practice

• We provide a 1-hour WebEx follow up to see how you are getting on to give any additional advice

Want something different?

• Can I have a course on my own. Yes, you can we can provide a 1:1 course for you either on-site or in centre.

• 1-1 or Group Training for your business, no problem.

We can customise content, combine courses or develop a program around your team or specific need.

• Need us to look at something specific, in a black hole with Excel / Access or need to migrate large amounts of data then please contact us to discuss in more detail. Our training are experts in their own field and spend 40% of their time providing on / off site consultancy.

What happens after I book?

• You will get a booking confirmation once you have placed your order.

• If you are booking a course over a weekend don’t worry one of our team will contact you via email on Monday to double check the details with you and check to see if you would like to book an optional lunch.

• We will send you the link to down load all of the tools and software needed for your course.

• 7 Days before your course date we send a reminder

• The morning of the course the course lecturer will greet you in reception if 1:1 course or in the training room if a group course.

• If you need help with anything don’t panic simply call or email us and we will assist.

Our list of Data Science Courses

• Applied Data Science with Python & Jupyter

• Applied Data Visualization with R and ggplot2

• Artificial Intelligence with Big Data

• Big Data Analysing with Python

• Big Data Processing with Apache Spark

• Data Science for Marketing Analytics

• Data Science Projects with Python

• Data Virtualisation with Python

• Data Wrangling with Python

• Excel – Introduction

• Excel – Advanced

• Excel for Data Analysis with Power Pivot

• Excel – Forecasting Data

• Excel – Sparkline and Mapping Data

• Excel – Visualising Data with Charts

• Excel - Dashboards

• Excel VBA Programming

• Access VBA

• VBA Programming

• Microsoft Power BI Data Analysis Professional

• Microsoft Power BI Data Analysis Practitioner

• Scala and Spark with Big Data Analytics

• Python Programming Introduction

• Python Advanced Programming

• Python API Development

• Python Microservices Development

• Machine Learning with Python

• Applied Unsupervised Learning with Python Libraries

• SQL for Data Analytics

• SQL Query Fundamentals

• Tableau Introduction

• Tableau Advanced

Refund Policy

We will provide a refund for all cancellations received 14 days prior to the event.

We accept name changes up to 3 days before the event at no additional cost , if you are unable to attend.

If for any reason we have to cancel the event we will offer you the option to move onto the next available date, attend an alternative course or we will provide a full refund.

Please note that we are not liable for any travel or accommodation costs relating to your course booking.

We always try to help and be as fair as possible, so please contact us at your earliest convenience if you are unable to attend a course you have booked, so we can look at the options available for you.