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 regular expression
• 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