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|
Try this example:

    # example data
    df1 <- read.table(text = "
    Feature	Value
    Gene_1	14.25633934
    Gene_2	16.88394578
    Gene_3	16.01
    Gene_4	13.82329514
    Gene_5	12.96382949
    Normalizer	13.45533012
    ", header = TRUE)
    
    
    # find the row with normaliser, use the value to substract from each row
    df1$Output_value1 <- df1$Value - df1[ df1$Feature == "Normalizer", "Value"]
    
    # then flip the sign (could be skipped, if we flip the substract in above step)
    df1$Output_value2 <- df1$Output_value1 * -1

