Question

Are there any functions to subtract all features(rows) to a particular value(row) in the same data file?

0

Entering edit mode

mohammedtoufiq91 ▴ 10

@mohammedtoufiq91-17679

Last seen 21 days ago

United States

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 outputvalue1 as shown below and post this, multiply by (-1) to obtain the outputvalue2.

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|

R python normalization matrix • 1.3k views

ADD COMMENT • link updated 5.4 years ago by shahryary ▴ 30 • written 5.4 years ago by mohammedtoufiq91 ▴ 10

score 2 · Accepted Answer · 2019-08-21

2

Entering edit mode

shahryary ▴ 30

@shahryary-20561

Last seen 5.4 years ago

You can do it easily in R.

df<-fread("yourfile")
df$Output_value2 <- ( df$Output_value1 * -1)

Note: for large data-set try to use "data.table" package to read/write.

ADD COMMENT • link 5.4 years ago shahryary ▴ 30

0

Entering edit mode

Thank you. But if I have hundreds of values/sample columns arranged in the data file , for instance as given below:

 |Feature| |Value1| |Value2| |Value3| |Value4| |Value5| |Value...n|

How could this be done to obtain the output in the single table? df1$Outputvalue1, df1$Outputvalue2, df1$Outputvalue3, df1$Outputvalue4, ........df1$Output_valueN

Here, df1$Output_value = difference between (Feature [1 to 5] - Feature [Normalizer])

Basically, Initially I would like to obtain the df1$Outputvalue from 1,.....N table and then multiply by (-1) in the next step i.e df$Outputvalue2.

ADD REPLY • link 5.4 years ago mohammedtoufiq91 ▴ 10

0

Entering edit mode

Well, as I understand you have many columns that you want to multiply in -1 and write result as new column.

So, here you can do it for every column and add the result as new column.

i <- 1
for (i in seq_len(length(df[,2:6]))){
    cur.colname <- colnames(df)[i]     # name of current column 
    df$tmp<-( df[,i:i] * -1 )          # multiply in -1 
    # adding new value as new column
    colnames(df)[names(df)=="tmp"] <- paste0("Value_",cur.colname)       
}

df[,2:6] is index of your columns.

ADD REPLY • link 5.4 years ago shahryary ▴ 30

0

Entering edit mode

Thank you shahryary.

ADD REPLY • link 5.4 years ago mohammedtoufiq91 ▴ 10