Data analysis project

Hi there, I'm working on a data analysis project, I want to know what alteryx tools do the following:

1- replace NaN values with a certain value (other than 0).

2- drop a certain category in a column.

3- add values from one column to another column.

4- Create a new column based on values from another column.

PS: This project is already done using python

Thanks in advance

Preparation

Accepted answers

Was it helpful? do you need more help?

If you are fine with my proposal please mark post as solved.

Have a good day!

Karolina

Below are mine suggestions. You can use few simple Preparation tools:

1- replace NaN values with a certain value (other than 0). - Formula tool : if isnull([Field1]) then "value" else [Field1] endif

2- drop a certain category in a column.: Filter tool : [column] != "certain category"

3- add values from one column to another column: Formula Tool: [Field1]+[Field2]

4- Create a new column based on values from another column: Formula Tool -> add new Column: for example: Field3: [Field1]*2

Let me know if it is helpful,

Karolina

Thank you Karolina!

I'll try your suggestions, I really appreciate it ^^

Thank you again!