Transforming the columns

Hi, I have interaction fingerprints that have a certain values. Since I am interested in only few of them I would like to transform ( or if there is any other way to that) columns so that if there is a value in a column different than zero I want that value to be 1 and if it is a zero to be zero. I dont want to filterout columns because i have let say 10 that are important and it is not always the case that the compund has a recorded value in every column, and i want still to keep that one, even if it has 5/10. Later I would like to plot it and visualize the results.

What is the best way to do so?

Thanks! :slight_smile:

Hello @nejraG ,
I think you can set this, as a rule, using this Rule engine node.



This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.