data-wrangling.md

Data wrangling

Data wrangling, also known as data munging or data cleaning, is the process of transforming and mapping data from one "raw" data form into another format with the intent of making it more appropriate and valuable for a variety of downstream purposes such as analytics.

All of the data manipulation routines can be recorded, saved as macros, and applied to a new dataset. Here are some of the commonly used routines:

• Add New Column
• Anonymize Data
• Categorize Data
• Batch Data Editor
• Change Type
• Aggregate Rows
• Compare Tables
• Extract RegExp
• Filter to Column
• Join Tables
• Impute Missing Values
• Select Duplicates
• Select Missing Values
• Select Random Rows
• Text to Columns

Aggregation

Press Alt+A to open data aggregation tool

See also:

• Macros