Median

Description

This operation calculates the median value of a set of numbers separated by a specified delimiter. The median is a statistical measure representing the middle value of a sorted dataset. It divides the data into two halves, with 50% of the data points below and 50% above the median.

---

Data types

These are the input/output expected data types for this operation:

Input data

- List of numbers separated by a specified delimiter.

Output data

- The result of the median.

---

Parameters

These are the parameters you need to configure to use this operation (mandatory parameters are marked with a *):

Delimiter*

Choose the delimiter that separates the numbers in your input data:

• Line feed - Select this to have each line of text as a separate value.

• Space - Your numbers are separated by spaces.

• Comma - Your numbers are separated by commas (,)

• Semi-colon - Your numbers are separated by semi-colons (;)

• Colon - Your numbers are separated by colons (:)

• CRLF - Carriage return line feed (CRLF) is a control character that originally referred to moving the carriage on typewriters back to the starting position. In computing, it’s used in classic Mac OS and some Windows-based systems to mark the end of a line. If your input uses \r as the line-ending character, you can set the delimiter to \r to correctly separate values. For example: 100\r200\r300

---

Example

Suppose you want to calculate the median a series of numbers in your input strings. They are separated by commas (,). To do it:

1. In your Pipeline, open the required Action configuration and select the input Field.

2. In the Operation field, choose Median.

3. Set Delimiter to Comma.

4. Give your Output field a name and click Save. You'll get the median of the numbers in your input data. For example:

10, 5, 20, 15, 25 -> 15

You can try out operations with specific values using the Input field above the operation. You can enter the value in the example above and check the result in the Output field.