I am new to programming in R and Python, however have some basics. I have a technical question about computation. I would like to know if there are any functions for performing subtraction of all features(rows) to a particular value (row) from the same data list. I would like to obtain the output_value1 as shown below and post this, multiply by (-1) to obtain the output_value2.
Please let me know if you need more details.
I have tried performing the same operation in the MS Excel, this is very tedious and time consuming.
I have many large datasets with several hundred rows and columns which becomes more complex to manually perform the same in MS Excel. Hence, I would prefer to write a code and obtain the desired outputs.
|Feature| |Value| |Output_value1| |Output_value2| |Gene_1| |14.25633934| |0.80100922| |-0.80100922| |Gene_2| |16.88394578| |3.42861566| |-3.42861566| |Gene_3| |16.01| |2.55466988| |-2.55466988| |Gene_4| |13.82329514| |0.36796502| |-0.36796502| |Gene_5| |12.96382949| |-0.49150063| |0.49150063| |Normalizer| |13.45533012| |0| |0|