Course details

Trifacta for Data Wrangling: Wrangling Data

Trifacta for Data Wrangling: Wrangling Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Data wrangling, an increasingly popular tool among today's top firms, has become more complex as data become even more unstructured and varied in their source. In this 13-video Skillsoft Aspire course, you will learn how to simplify the task by organizing and cleaning disparate data to present your data in the best format possible with Trifacta, which accelerates data wrangling to enhance productivity for data scientists. Learn to reshape data, look up data, and pivot data. Explore essential methods for wrangling data, including how to use Trifacta to standardize, format, filter, and extract data. Also covered are other key topics: how to split and merge columns; utilize conditional aggregation; apply transforms to reshape data; and join two data sets into one by using join operations. In the concluding exercise, learners will be asked to start by loading a data set into Trifacta; to replace any missing values, if necessary; and to use a row filter operation, use a group by operation, and use an aggregate function in the group by operation.



Expected Duration (hours)
0.8

Lesson Objectives

Trifacta for Data Wrangling: Wrangling Data

  • Course Overview
  • remove units from data and covert to another format
  • change date formats to the ISO 8601 standard
  • create filters based on existing column data
  • replace values based on a particular criteria
  • count the number of matches for values in data
  • split columns based on a pattern
  • merge multiple columns into one
  • create a new column from extracted data
  • apply a group by transformation to aggregate with a conditional value
  • apply a number of transforms to reshape data
  • join two data sets into one using a join operation
  • apply data wrangling functions using Trifacta
  • Course Number:
    it_dstrdwdj_01_enus

    Expertise Level
    Intermediate