Overview
This documentation provides a step-by-step guide on creating custom data transformations in the Data Preparation app. It covers uploading additional data, performing calculations, and tracking transformations applied to the data table
Uploading Additional Data
Begin by downloading the current data table from the app.
Add new columns and calculations as needed.
Ensure each new column has a unique identifier.
For this example, a 'Background Subtraction' column is added with random data.
Re-upload the modified table and select whether to treat the new column as a response or a factor. In this case, select 'Response'.
Column-Based Arithmetic: Log Transformation and Background Subtraction
Perform a log transformation on the response data while subtracting the background values.
Select the group of columns labeled 'Response' for drug 0 and drug 10.
Use the formula:
log({Response} - {Background subtraction})to compute the logged values for each replicate.
Calculating Mean Values
Use the built-in mean transformation for the logged responses.
Independently calculate the mean for drug 0 and drug 10, including background subtraction and log transformation performed separately for each replicate.
The mean values will be displayed at the end of the data table for both drugs.
Calculating Signal Window
Use column-based arithmetic to calculate the signal window by subtracting the mean of drug 10 from drug 0.
Select the appropriate response columns and apply the calculation to get the signal window.
Tracking Transformations
All custom transformations and calculations are logged in the app.
This log serves as a record of changes made to the data table, facilitating collaboration and analysis.