xxxxxxxxxx
df2 = df.withColumn("col4", func.round(df["col3"]).cast('integer'))
xxxxxxxxxx
select cast('10' as decimal(5,2)) AS decimal_value
/* or */
select TRY_CAST('10' as decimal(5,1)) AS decimal_value
/* or */
SELECT CONVERT(DECIMAL(7,2),12 ) AS decimal_value
xxxxxxxxxx
SELECT CAST(9 as DECIMAL(4,2));
# prints 9.00
# DECIMAL(precission (or total significant figures), number of decimal places)