This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
how_to:studio:calculator [2015/06/29 16:18] 132.168.72.206 |
how_to:studio:calculator [2015/06/30 10:00] (current) 132.168.72.237 |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Calculator ====== | ====== Calculator ====== | ||
- | Calculator let you write python scripts to manipulate freely viewed data. | + | Calculator lets you write python scripts to manipulate freely viewed data. |
1) To open the calculator, click on the calculator icon (not available on all views for the moment) | 1) 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 === | === Script to calculate a log column === | ||
+ | <code> | ||
#### Algorithm to calculate the logarithm of a column #### | #### Algorithm to calculate the logarithm of a column #### | ||
Line 31: | Line 31: | ||
# number of rows of the column | # number of rows of the column | ||
- | nb = len(specificSCCol) | + | nb = len(specificSCCol) |
# loop on the data of the column | # loop on the data of the column | ||
Line 47: | Line 47: | ||
# add the created column to the table t | # add the created column to the table t | ||
t.addColumn(specificSCCol) | 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]) ) | ||
+ | |||
+ | pvalueCol.setColumnName("pvalue") | ||
+ | ttdCol.setColumnName("ttd") | ||
+ | t.addColumn(pvalueCol) | ||
+ | t.addColumn(ttdCol) | ||
+ | </code> | ||