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:16] 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> | ||