Chapter 3. ETL and Data Manipulation: Filtering, Aggregation, Join, and Concatenation

The goal of this section is to introduce some commonly used data manipulation operations. Data Manipulation is often also called ETL (Extract, Transform, Load) and includes all operations to bring the data to the shape you need to display information or to feed and train an analytics model.

Classic data manipulation operations include: row and column filtering, aggregation, join and concatenation, string manipulation, mathematical formulas, and more.