Skip to content

Convert a String column into a Decimal column

Source code

Description

[Experimental]

Usage

<Expr>$str$to_decimal(..., scale, inference_length = deprecated())

Arguments

… These dots are for future extensions and must be empty.
scale Number of digits after the comma to use for the decimals.
inference_length [Deprecated] Ignored.

Value

A polars expression

Examples

library("polars")

df <- pl$DataFrame(
  numbers = c(
    "40.12", "3420.13", "120134.19", "3212.98",
    "12.90", "143.09", "143.9"
  )
)
df$with_columns(numbers_decimal = pl$col("numbers")$str$to_decimal(scale = 2))

#> shape: (7, 2)
#> ┌───────────┬─────────────────┐
#> │ numbers   ┆ numbers_decimal │
#> │ ---       ┆ ---             │
#> │ str       ┆ decimal[*,2]    │
#> ╞═══════════╪═════════════════╡
#> │ 40.12     ┆ 40.12           │
#> │ 3420.13   ┆ 3420.13         │
#> │ 120134.19 ┆ 120134.19       │
#> │ 3212.98   ┆ 3212.98         │
#> │ 12.90     ┆ 12.90           │
#> │ 143.09    ┆ 143.09          │
#> │ 143.9     ┆ 143.90          │
#> └───────────┴─────────────────┘