I have a dataset in CSV format that I’m uploading to parabola (eventually will be API) and I need to add a new column (lets call it column B) nd create values based on a previous column (column A)
I.e column A has $$ values from 1,2,100,500,45,200, etc
For column B I want to say: if value (in col A) is between 1-10 then 10 (in col B) if value (in col A) is between 10-50 then 50 (in col B)
Any good tutorials I can watch /read on data transformation? How would I do this and what pieces would I need to use?
Thanks in advance!