Let's Get Ready To Wrangle

Note: These examples are written with the assumption that you have already learned the basics of data wrangling. Excel basics can be found here and Python basics can be found here.

In Depth Examples

These examples will show how to wrangle data from start to finish.

Wrangling in Excel

These examples show you how to "Wrangle by Hand". That is, "manual" wrangling from the Wrangles Task Pane.

• Extracting Meaningful Information From Dirty Data
• Cleaning Dirty Data

Automated Wrangling With Recipes

Recipes allow a series of Wrangles to be defined and run as an automated sequence. That is, they allow you to run several wrangles with just one click.

• Extracting Meaningful Data With a Recipe

How Do I...?

These examples show how to overcome specific problems when wrangling data.

• Make use of the use_labels extract setting
• Merge Lists With Strings
• Remove Words
• Combine Descriptions
• Create a Description Based on My Data
• Filter My Data

Best Practices

These examples outline what we consider to be best practices when wrangling data.

• Trimming Company Names