Course
|
Alteryx

Web Scraping

In this course, we will cross-reference information on one website with geo-data available through an API from a different source. Through this case study, we will learn how to investigate websites to find relevant information, manipulate this data using Alteryx tools and integrate multiple sources to generate an enhanced dataset.
2 HOURS
Advanced
9 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Clean data with RegEx
Convert not standard characters with RegEx
Import API data
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
helping to build
data, Tech & ai skills in
g2-badgebritish-airwaysjotunamazon-logopwc-logoford-logo
Course
|
Alteryx

Web Scraping

In this course, we will cross-reference information on one website with geo-data available through an API from a different source. Through this case study, we will learn how to investigate websites to find relevant information, manipulate this data using Alteryx tools and integrate multiple sources to generate an enhanced dataset.
2 HOURS
Advanced
9 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Clean data with RegEx
Convert not standard characters with RegEx
Import API data
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

What’s Included

9 Lessons
Introduction to Web Scraping
5 MINS
LESSON
Introduction to Web Scraping
Exercise

In this lesson, we will introduce the concept of web scraping, and inspect the Chicago Point website to determine which information we would like to incorporate.

Downloading Web Data to Alteryx
5 MINS
LESSON
Downloading Web Data to Alteryx
Exercise

Learn how to connect Alteryx to a website containing the information and download the required data.

Starting the Parsing Process
6 MINS
LESSON
Starting the Parsing Process
Exercise

In this lesson, we will use the RegEx tool to parse data from the Chicago Point website.

Cleaning Data with RegEx
9 MINS
LESSON
Cleaning Data with RegEx
Exercise

We'll continue where we left off in the previous lesson and run through how to use the RegEx tool to clean the backgammon tournament data.

Converting Non-Standard Characters
7 MINS
LESSON
Converting Non-Standard Characters
Exercise

Cross-referencing website data that includes special characters, such as letters with accents, can present mismatch issues. In this lesson we will reference another website to convert such characters into a standard format, facilitating downstream analysis.

Generating Geocoordinates
5 MINS
LESSON
Generating Geocoordinates
Exercise

Learn how to utilize the Google Maps Geocoding API on the Google Developers Console to generate longitude-latitude coordinates for a sample of our data.

Importing API Data
6 MINS
LESSON
Importing API Data
Exercise

In this lesson, we will test our API data to ensure that it is correct, and download API data for all entries in the dataset.

Creating Map Points
6 MINS
LESSON
Creating Map Points
Exercise

In this lesson, we will further clean the dataset and create map points for each unique tournament entry in the dataset.

Generating the Report
5 MINS
LESSON
Generating the Report
Exercise

In this final lesson on web scraping, we will combine the different datasets we have downloaded and cleaned, into a single report incorporating map points and segmented by country.

LESSON
Exercise

LESSON
Exercise

LESSON
Exercise

See More
See Less
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives?  Book some time with one of our consultants today.
Contact Information
Looking to speak to someone directly?
01 700 9000
info@kubicle.com
Dublin, Ireland
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Plus Size YourLearning with Academies+
THE PLATFORM OF CHOICE FOR 1M+ USERS

A Learner Experience Designed to Deliver Transformation

Testimonials

How Leading Teams Use Kubicle to Upskill & Excel

Heineken Case Study
ADL Logo