Wrangle data¶

DataRobot's wrangling capabilities provide a seamless, scalable, and secure way to access and transform data for modeling. In Workbench, "wrangle" is a visual interface for executing data cleaning at the source, whether that's the Data Registry in DataRobot or leveraging the compute environment and distributed architecture of your external data source. Why wrangle data in DataRobot?

• It's fully integrated in Workbench—find the right datasets, apply transformations, and see the effects of those transformations on your dataset in realtime in one place.
• It's pushed down—when using a data connection, leverage the scale of your cloud data warehouse or lake.
• It's secure—limiting data movement means faster results, better performance, and enhanced security.

You can launch the data wrangler from the following areas in a Use Case:

• When selecting a dataset from a data connection, click Open in Wrangler in the top-right corner.
• On the Data assets tile, from the Actions menu next to a dataset.
• On the data explore page, from the Data actions dropdown.

When you wrangle a dataset, DataRobot pulls a uniform random sample of 10000 rows and calculates exploratory data insights on that sample, all while connected to your data source. Then, you build a recipe of operations you want to apply to the entire dataset—the transformations are first applied to the live sample to make sure it's being done correctly. When the recipe is ready to be published, it's pushed down to the data source where it's executed to materialize an output dataset.

See the associated considerations for important information about wrangling data in DataRobot.

This section covers the following topics: