Data Wrangling with Trifacta
Trifacta Wrangler
| Intermediate
- 13 videos | 49m 40s
- Includes Assessment
- Earns a Badge
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 19sDuring this video, you will learn how to remove units from data and convert to another format. FREE ACCESS
-
3. Formatting Dates4m 57sDuring this video, you will learn how to change date formats to the ISO 8601 standard. FREE ACCESS
-
4. Filtering Rows5m 47sIn this video, you will create filters based on existing data in columns. FREE ACCESS
-
5. Replacing Values4m 55sLearn how to replace values based on a particular criterion. FREE ACCESS
-
6. Counting Matches3m 7sLearn how to count the number of values that match in data. FREE ACCESS
-
7. Splitting Columns3m 55sLearn how to split columns based on a pattern. FREE ACCESS
-
8. Merging Columns2m 31sIn this video, you will learn how to merge multiple columns into one. FREE ACCESS
-
9. Extracting Data2m 58sDuring this video, you will learn how to create a new column by extracting data. FREE ACCESS
-
10. Conditional Aggregation2m 57sFind out how to apply a group by transformation to aggregate with a conditional value. FREE ACCESS
-
11. Reshaping Data5m 12sIn this video, you will apply a number of transforms to reshape your data. FREE ACCESS
-
12. Joining Data3m 52sLearn how to join two data sets into one using a join operation. FREE ACCESS
-
13. Exercise: Wrangling Data2m 39sIn 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.
