Text Column
Create new text-based columns
The Text Column tool is often used and very simple. It is used to create new text columns by combining existing columns, adding prefixes, etc.
You can get the length (i.e. the number of characters) of your columns using this syntax [column].str.lengths()
Configuration
The Text Column tool consists of two required input.
Input Column Name
The Text Column tool will create a new column. Use this input to name it.
You can overwrite existing columns simple by inputting an existing column name. Check out the last example below.
Input Column
Input how you want to create your new column and/or what it should contain. Remember to use double-quotes around text values.
Start typing a column name to reference it - for example firstName
When To Use
There are tons of use cases for the Text Column tool. This tool is your go-to whenever you need to create some custom text columns.
- You have two (or more) columns that you would like to concatenate
- To add prefixes or suffixes to your columns
- Creating fixed values - maybe you just need to create a new column with a fixed value, like a reference date