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
Examples
A Static Column
A Static Column
I just want to create column with the value something throughout my dataset
Combining First and Last Name
Combining First and Last Name
I want to combine my first name and last name column to create a full name column. I want to add a space between the first and last name.
Adding a Prefix
Adding a Prefix
I want to add a prefix to my purchase IDs so that I can Combine it with my ERP data. I also want to overwrite my existing purchaseID column.
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
Examples
A Static Column
A Static Column
I just want to create column with the value something throughout my dataset
Combining First and Last Name
Combining First and Last Name
I want to combine my first name and last name column to create a full name column. I want to add a space between the first and last name.
Adding a Prefix
Adding a Prefix
I want to add a prefix to my purchase IDs so that I can Combine it with my ERP data. I also want to overwrite my existing purchaseID column.