textLower function

The textLower function changes uppercase characters of a nominal attribute to lowercase.


Parameters

textLower(column,mode,leaveother)

Parameter

Description

column

The nominal attribute to which modify the fonts to lowercase. The column parameter is mandatory.

mode

By default the textLower function changes all fonts to lowercase, and the following are the permitted parameters:

  • mode="a" - changes all fonts to lowercase (default parameter).

  • mode="b" - changes the first font to lowercase.

  • mode="bw" - changes the first font of each string to lowercase.

leaveother

If left empty or not specified, the default leaveother parameter is False.

If the leaveother is False, the function changes all fonts that are not converted in lowercase to uppercase.

If the leaveother is True, the function leaves any lowercase font to lowercase.

The effects of the leaveother parameter are visible only when the mode "b" or mode "bw" are defined.


Example

The following example uses the Adult dataset.

Description

Screenshot

In this example, we want to change the uppercase fonts of a nominal attribute to lowercase.

But we want to change only the first font of each string to lower case, and leave to lowercase fonts that are already lowercase.

To achieve this goal we’re going to use the following formula:

textLower($"education","bw",True)