can we pass on the split in the prompt

[parikannappan]

Can we do column split like we do in pandas using pandas using prompt , example "str.split('To', expand=True)" .
if yes where do we set the new column name?

[gventuri]

@parikannappan sure thing. I would ask it like this:
split the column "your_column" in 2 columns using "To" as a separator and name the new column "your_new_column"

Please try it out and let me know :)