PySpark When Otherwise and SQL Case When on DataFrame with Examples
Learn how to use when() and otherwise() functions in PySpark to check multiple conditions in sequence on a DataFrame, similar to SQL's case when and if then else statements. Explore examples and understand how these functions work.
Recommended next
12 questions ready
Start with a quiz
Answer from memory first, then use the existing quiz review flow for anything you miss.
Activities
Quiz12 Questions
Modules
Learn in sequence
Start with the earlier modules and work forward. Each one builds on the last, so the course gets more advanced as you go.
PySpark When Otherwise and SQL Case When on DataFrame with Examples
Quiz • 12 Questions
Materials
List of Questions12 questions
- Question 1
- To assign a NULL value when no conditions are met
- To create a new DataFrame column
- To return a literal value when a condition is met
- To filter a DataFrame based on conditions
- Question 2
- A literal string value of 'default'
- An empty string
- The same value as its input
- A NULL (None) value
- Question 3
- filter()
- CASE WHEN
- select()
- when().otherwise()
- Question 4
- Case When does not need an else clause
- Only the Case When expression can check multiple conditions
- Case When can return multiple values from a single condition
- Case When can use both literal and Column values in its conditions
- Question 5
- It returns the value from the first condition
- It raises an error
- It returns a NULL (None) value
- It returns an empty string
- Question 6
- or_()
- and_()
- then_()
- chain()
- Question 7
- To execute a sequence of conditions and return a value when no conditions are met
- To execute a sequence of conditions and return a value when the first condition is met
- To execute a single condition and return a value when the condition is met
- To execute a sequence of conditions and return a value when all conditions are met
- Question 8
- To execute a sequence of conditions
- To create a temporary view
- To express SQL-like expressions
- To return a value when a condition is met
- Question 9
- Using the IN operator
- Using the LIKE operator
- Using the NOT operator
- Using the AND (&) or OR (|) operators
- Question 10
- SQL Case When is used for temporary views while PySpark SQL Case When is used for DataFrames
- SQL Case When is used for DataFrames while PySpark SQL Case When is used for temporary views
- SQL Case When uses the expr() function while PySpark SQL Case When does not
- SQL Case When uses the expr() function while PySpark SQL Case When uses the when() function
- Question 11
- To update a column
- To delete a column
- To create a new column
- To create a new DataFrame
- Question 12
- It returns a value when the first condition is met
- It returns a value when all conditions are met
- It returns a value when at least one condition is met
- It returns a value when no conditions are met