Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
You want to add the same set of new, formula-based columns to your data over and over again.
Store the formulas and column names in a table. Extract them from that table. loop over them trying to make a new column for each pair in your target data table.
adds formulas to a data table from another data table used to store column names and respective formulas
FFpath must point to a file with columns "formula" and "colname" with text of desired formulas and column names
in the order they should evaluate (row 3 can use the column created by row 2, etc)
try( //open setup file and get list of formulas and column names
current data table(dtFF);
dt1 << suppressFormulaEval(true);
try(c=:colname, wait(0);statusmsg("setup file must contain column colname"); throw ("setup file must contain column colname"));
try(c=:formula, wait(0);statusmsg("setup file must contain column formula"); throw("setup file must contain column formula"));
//try to make new cols in dt1 with each of the formulas...
current data table(dt1);
dt1 << suppressFormulaEval(false);
print("DONE ADDING FAVORITE FORMULA COLUMNS");
print("failure, probably to find favorite formulas file with path "||FFpath);
I often pull data with the same columns and format and I want to add the same set of new formula columns each time. This is just a tidbit that makes that easy and makes it easy to share around sets of "favorite formulas" with other users as simple, readable datatables. I use this function version inside a lot of other scripts but I also have an addin version.