Calculating the mean of two or more columns - 7.3

Talend Data Preparation User Guide

author
Talend Documentation Team
EnrichVersion
7.3
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Data Quality and Preparation > Cleansing data
EnrichPlatform
Talend Data Preparation

Talend Data Preparation offers a variety of mathematical operations that can be applied to a column, or between several columns, like calculating a mean for example.

This example uses a dataset that lists the number of sales for a specific product, per country and per quarter. In a single action, you will be able to calculate an average of the quarterly number of sale for each country.

Procedure

  1. Use Ctrl + click or Shift + click to select the headers of the four columns containing the sales per quarter, for which you want to calculate the mean.
  2. In the Functions panel, type Mean of columns.
  3. Point you mouse over the function to preview the effects, and click to apply the function.

Results

A new column is created, containing the mean value for the 2018 quarterly sales.

For a list of the other mathematical functions that you can apply on several columns at once, see the Math category of the List of functions.