Studio provides several conversion functions, allowing you to cast strings to numbers, or numbers to strings.

float

Convert columns identified as string to the float data type. Numbers past the decimal point are preserved. Any non-number character will end the conversion. For example, $14.32 will not successfully convert into a float. 14.32 dollars will convert to a float.

Example

Suppose progress is a column that contains the following data schema:

Convert progress to float in a new column progress_float:

float(progress);

The new column will be converted to float:

int

Convert columns identified as string to the int data type. Numbers before the decimal point are preserved. Any non-number character will end the conversion. For example, $14.32 will not convert into an int. 14.32 dollars will convert to an int.

Example

Suppose progress is a column that contains the following data schema:

Convert progress to int in a new column progress_int:

int(progress);

The new column will be converted to int:

str

Converts columns identified as a number (either int or float) to the string data type.

Example

Suppose progress is a column that contains the following data schema:

Convert progress to string in a new column progress_string:

string(progress) + "% complete";