Add a new column with a function similar to vlookup in ExcelI'm trying to figure out how to add a new column to a table that will populate with data dependent on other data in that row. We have several fermentations in a data frame. Each one has a blank value. I'd like to have the blank value from each fermentation in a new column so that I can subtract it from the treatment value. Also if there's a better way to do this than creating a new column that would be great too! Thanks.
Made up example data:
| Fermentation | Treatment | Value | Fermentation Blank Value |
| A | 1 | 98 | 6 |
| A | 2 | 73 | 6 |
| A | Blank | 6 | 6 |
| B | 1 | 84 | 5 |
| B | 2 | 86 | 5 |
| B | Blank | 5 | 5 |
Automation and ScriptingContent Organization
