Differences

This shows you the differences between two versions of the page.

--- how_to:studio:calculator [2015/06/29 16:19]
132.168.72.206
+++ how_to:studio:calculator [2015/06/30 10:00] (current)
132.168.72.237
@@ Line 1: / Line 1: @@
 ====== Calculator ======
-Calculator let you write python scripts to manipulate freely viewed data.
+Calculator lets you write python scripts to manipulate freely viewed data.
 ) To open the calculator, click on the calculator icon (not available on all views for the moment)
@@ Line 20: / Line 20: @@
 === Script to calculate a log column ===
+<code>
+#### Algorithm to calculate the logarithm of a column ####
- #### Algorithm to calculate the logarithm of a column ####
+# get the Table 3 which corresponds to table newSC Quanti Protein Set
+t = Table.get(3)
- # get the Table 3 which corresponds to table newSC Quanti Protein Set
+# get the constant column 10 of the table t ( Specific SC column)
- t = Table.get(3)
+# mutable() is called to be able to modify data
+specificSCCol = t[10].mutable()
- # get the constant column 10 of the table t ( Specific SC column)
+# number of rows of the column
- # mutable() is called to be able to modify data
- specificSCCol = t[10].mutable()
- # number of rows of the column
  nb = len(specificSCCol)
- # loop on the data of the column
+# loop on the data of the column
- for i in range (0,nb):
+for i in range (0,nb):
     # calculate the log (NaN values for errors)
     v = specificSCCol[i]
@@ Line 42: / Line 42: @@
          specificSCCol[i] = math.log(v)
- # set the column name which will be used to the user
+# set the column name which will be used to the user
- specificSCCol.setColumnName("log(specificSC)")
+specificSCCol.setColumnName("log(specificSC)")
+# add the created column to the table t
+t.addColumn(specificSCCol)
+</code>
+=== Script to perform a difference and a mean between two columns ===
+<code>
+#### Algorithm to perform a difference and a mean between two columns ####
+t = Table.get(9)
+colAbundance1 = t[3]
+colAbundance2 = t[5]
+# difference between two columns
+colDiff = colAbundance1-colAbundance2
+# set the name of the column
+colDiff.setColumnName("diff")
+# mean between two columns
+colMean = (colAbundance1+colAbundance2)/2
+# set the name of the column
+colMean.setColumnName("mean")
+# add columns to the table
+t.addColumn(colDiff)
+t.addColumn(colMean)
+</code>
+=== Script to perform a perform a pvalue and a ttd on a XIC quantitation table ===
+<code>
+#### Algorithm to perform a pvalue and a ttd on abundances column of a XIC quantitation ####
+t = Table.get(1)
+pvalueCol = Stats.pvalue( (t[2], t[3]), (t[4],t[5]) )
+ttdCol = Stats.ttd( (t[2], t[3]), (t[4],t[5]) )
- # add the created column to the table t
+pvalueCol.setColumnName("pvalue")
- t.addColumn(specificSCCol)
+ttdCol.setColumnName("ttd")
+t.addColumn(pvalueCol)
+t.addColumn(ttdCol)
+</code>

Proline

User Tools

Site Tools

Differences

Page Tools