'How do I take a column of String type decimals in Pyspark and round them to the nearest 50 value?

I have a column in a dataset called "X":

Im trying to make these numbers be interger values that round to nearest 50

Output should be this:

Solution 1:^[1]

I would suggest dividing by 50, rounding to nearest integer and then multiplying again.

no need for user-defined-functions, pyspark.sql.functions module has you covered. see suggested code:

from pyspark.sql.functions import col, round 

df \
.withColumn(
  "results",
  round(col("X").cast("double") / 50) * 50
)

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	walking