Imagine a spreadsheet with columns A, B, C. Suppose A are observations, and B = B(A), C = C(A, B) are defined by excel formulas involving the previous columns.
This is a pretty common scenario in excel. I was just wondering - is there any way to express these relationships between columns in Julia, and automatically generate the excel formulas? Perhaps through a custom ExcelNumber type <: Real, as in autodiff? Or with macros?
It also brings up the idea of a symbolic DataFrame with derived columns, not sure whether that exists in Julia either.
Has anyone heard of anything like this?