chevron_left
PySpark SQL Functions
Method arrayMethod colMethod collect_listMethod collect_setMethod concatMethod concat_wsMethod countMethod count_distinctMethod countDistinctMethod date_formatMethod dayofmonthMethod dayofweekMethod dayofyearMethod element_atMethod explodeMethod exprMethod firstMethod greatestMethod instrMethod lastMethod leastMethod lengthMethod litMethod lowerMethod maxMethod meanMethod minMethod monthMethod regexp_extractMethod regexp_replaceMethod repeatMethod roundMethod splitMethod to_dateMethod translateMethod trimMethod upperMethod whenMethod year
check_circle
Mark as learned thumb_up
0
thumb_down
0
chat_bubble_outline
0
auto_stories new
settings
PySpark SQL Functions | round method
Machine Learning
chevron_rightPySpark
chevron_rightDocumentation
chevron_rightPySpark SQL Functions
schedule Jul 1, 2022
Last updated local_offer PySpark
Tags tocTable of Contents
expand_more Check out the interactive map of data science
PySpark SQL Functions' round(~)
method rounds the values of the specified column.
Parameters
1. col
| string
or Column
The column to perform rounding on.
2. scale
| int
| optional
If scale is positive, such as scale=2
, then values are rounded to the nearest 2nd decimal. If scale is negative, such as scale=-1
, then values are rounded to the nearest tenth. By default, scale=0
, that is, values are rounded to the nearest integer.
Return Value
A PySpark Column (pyspark.sql.column.Column
).
Examples
Consider the following PySpark DataFrame:
+-----+------+| name|salary|+-----+------+| Alex| 90.4|| Bob| 100.5||Cathy|100.63|+-----+------+
Rounding column values to the nearest integer
To round to the nearest integer:
Notice how 100.5
got rounded up to 101
.
Rounding column values to the nearest first decimal
To round to the nearest 1st decimal:
Rounding column values to the nearest tenth
To round to the nearest tenth:
Published by Isshin Inada
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
Ask a question or leave a feedback...
Official PySpark Documentation
https://spark.apache.org/docs/latest/api/python/reference/api/pyspark.sql.functions.round.html
thumb_up
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!