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?