PySpark
keyboard_arrow_down 147 guides
chevron_leftPySpark Column
check_circle
Mark as learned thumb_up
1
thumb_down
0
chat_bubble_outline
0
Comment auto_stories Bi-column layout
settings
PySpark Column | otherwise method
schedule Aug 12, 2023
Last updated local_offer
Tags PySpark
tocTable of Contents
expand_more Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!
Start your free 7-days trial now!
Examples
Basic usage
Consider the following PySpark DataFrame:
+-----+---+| name|age|+-----+---+| Alex| 20|| Bob| 24||Cathy| 22|+-----+---+
To replace the name Alex
with Doge
, and others with Eric
:
+-----------------------------------------------+|CASE WHEN (name = Alex) THEN Doge ELSE Eric END|+-----------------------------------------------+| Doge|| Eric|| Eric|+-----------------------------------------------+
Note that we can replace our existing column with the new column like so:
Published by Isshin Inada
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
Comment
Citation
Ask a question or leave a feedback...
Official PySpark Documentation
https://spark.apache.org/docs/latest/api/python/reference/api/pyspark.sql.Column.otherwise.html
thumb_up
1
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!