format_number

Description

Formats numeric column y to a format like '#,###,###.##', rounded to x decimal places with HALF_EVEN round mode, and returns the result as a string column.

Usage

## S4 method for signature 'Column,numeric'
format_number(y, x)

format_number(y, x)

Arguments

Details

If x is 0, the result has no decimal point or fractional part. If x < 0, the result will be null.

Note

format_number since 1.5.0

See Also

Other string_funcs: ascii, ascii, ascii,Column-method; base64, base64, base64,Column-method; concat_ws, concat_ws, concat_ws,character,Column-method; concat, concat, concat,Column-method; decode, decode, decode,Column,character-method; encode, encode, encode,Column,character-method; format_string, format_string, format_string,character,Column-method; initcap, initcap, initcap,Column-method; instr, instr, instr,Column,character-method; length, length,Column-method; levenshtein, levenshtein, levenshtein,Column-method; locate, locate, locate,character,Column-method; lower, lower, lower,Column-method; lpad, lpad, lpad,Column,numeric,character-method; ltrim, ltrim, ltrim,Column-method; regexp_extract, regexp_extract, regexp_extract,Column,character,numeric-method; regexp_replace, regexp_replace, regexp_replace,Column,character,character-method; reverse, reverse, reverse,Column-method; rpad, rpad, rpad,Column,numeric,character-method; rtrim, rtrim, rtrim,Column-method; soundex, soundex, soundex,Column-method; substring_index, substring_index, substring_index,Column,character,numeric-method; translate, translate, translate,Column,character,character-method; trim, trim, trim,Column-method; unbase64, unbase64, unbase64,Column-method; upper, upper, upper,Column-method

Examples

## Not run: format_number(df$n, 4)