Data Wrangling with Trifacta

Trifacta Wrangler    |    Intermediate
  • 13 videos | 49m 40s
  • Includes Assessment
  • Earns a Badge
Rating 4.3 of 8 users Rating 4.3 of 8 users (8)
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 1m 33s
  • 5m 19s
    During this video, you will learn how to remove units from data and convert to another format. FREE ACCESS
  • Locked
    3.  Formatting Dates
    4m 57s
    During this video, you will learn how to change date formats to the ISO 8601 standard. FREE ACCESS
  • Locked
    4.  Filtering Rows
    5m 47s
    In this video, you will create filters based on existing data in columns. FREE ACCESS
  • Locked
    5.  Replacing Values
    4m 55s
    Learn how to replace values based on a particular criterion. FREE ACCESS
  • Locked
    6.  Counting Matches
    3m 7s
    Learn how to count the number of values that match in data. FREE ACCESS
  • Locked
    7.  Splitting Columns
    3m 55s
    Learn how to split columns based on a pattern. FREE ACCESS
  • Locked
    8.  Merging Columns
    2m 31s
    In this video, you will learn how to merge multiple columns into one. FREE ACCESS
  • Locked
    9.  Extracting Data
    2m 58s
    During this video, you will learn how to create a new column by extracting data. FREE ACCESS
  • Locked
    10.  Conditional Aggregation
    2m 57s
    Find out how to apply a group by transformation to aggregate with a conditional value. FREE ACCESS
  • Locked
    11.  Reshaping Data
    5m 12s
    In this video, you will apply a number of transforms to reshape your data. FREE ACCESS
  • Locked
    12.  Joining Data
    3m 52s
    Learn how to join two data sets into one using a join operation. FREE ACCESS
  • Locked
    13.  Exercise: Wrangling Data
    2m 39s
    In this video, you will learn how to apply data wrangling functions using Trifacta. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 79 users Rating 4.4 of 79 users (79)
Rating 4.5 of 197 users Rating 4.5 of 197 users (197)
Rating 4.0 of 40 users Rating 4.0 of 40 users (40)