Data analysis project

[Sirius]

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

[KarolinaRoza]

Hi @Sirius,

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

[Sirius]

Thank you Karolina!

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

Thank you again!

[KarolinaRoza · Accepted solution]

Hi @Sirius,

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