Question: Are there any functions to subtract all features(rows) to a particular value(row) in the same data file?
0
gravatar for mohammedtoufiq91
27 days ago by
mohammedtoufiq910 wrote:

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|

normalization R python matrix • 73 views
ADD COMMENTlink modified 27 days ago by shahryary30 • written 27 days ago by mohammedtoufiq910
Answer: Are there any functions to subtract all features(rows) to a particular value(row
2
gravatar for shahryary
27 days ago by
shahryary30
shahryary30 wrote:

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 COMMENTlink written 27 days ago by shahryary30

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 REPLYlink modified 27 days ago • written 27 days ago by mohammedtoufiq910

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 REPLYlink written 27 days ago by shahryary30

Thank you shahryary.

ADD REPLYlink written 26 days ago by mohammedtoufiq910
Please log in to add an answer.

Help
Access

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 16.09
Traffic: 193 users visited in the last hour