Exploratory
Search…
Exploratory
Introduction
Product Features
Data Import
Data Wrangling
Command Line mode for faster and more flexible data interaction in Exploratory
Select / Remove Columns
Reorder Columns
Create New Calculation
Create New Calculation for Multiple Columns
Summarize (Aggregate)
Group
Filter
Rename
Arrange (Sort)
Top / Bottom N
Join
Merge
Gather
Spread
Pivot
Expand
Complete
Separate
Unite
Bind Rows
Bind Columns
Keep Only Unique Rows
Keep Only Duplicated Rows
Slice
Drop NA
Sample
Impute NA
Fill
Create Buckets
Assign New Values to Existing Values - Recode
Assign New Values by Setting Conditions - Case When
Work with Categories
Data Type Conversion
Row as header
Ungroup
Unnest
Separate List Items into Columns (Unnest Wider)
Separate List Items into Rows (Unnest Longer)
Hoist
Remove Empty Rows
Remove Empty Columns
Clean Column Names
Window Calculation
Add Row
Text Wrangling
Visualization
Analytics
Statistics
Machine Learning
Text Analysis
Extend with R
Setup
Diagnostics
Keyboard shortcuts
Powered By GitBook
Assign New Values by Setting Conditions - Case When
You can assign new values to a column by setting conditions with easy-to-use dialog UI.

How to Access?

  • From Column Menu on Character Column, select "Replace Values" -> "By Setting Conditions".

How to Use?

Set Condition and New Values

To assign new value, you need to set a condition. For example, if you want to assign 100 for the case where BusinessTravel column value is "Non-Travel" like below screenshoot,
then you can click the condition and set it in the Filter like dialog.

Set New Values

To set a new value for each condition, click the New Value field and then Enter New Value Dialog popup. Enter value and click OK.
Previous
Assign New Values to Existing Values - Recode
Next
Work with Categories
Last modified 1mo ago
Copy link
Contents
How to Access?
How to Use?
Set Condition and New Values
Set New Values