Is there a JS syntax that can be used in the cell rollupObj in this notebook that does not utilize the eval method? rollupObj = { const rollupObj ={}; correlationPairings .forEach(({metric_1, metric_2}) => { rollupObj[`${metric_1}…

A very careful reading of the API documentation for Table Expressions results in the following solution: …At first glance table expressions look like normal JavaScript functions… but hold on! Under the hood, Arquero takes a set of function definitions, maps them to strings, then parses, rewrites, …

Your references ( 1 , 2 ) were extremely helpful in understanding what exactly is going on; Thank You! The ’A few words about table expressions and op…' section in Introducing Arquero really explains the issue. Unfortunately, for my use case, I’m dynamically creating new columns/attributes for the ro…

I think the reason this is difficult is that the data columns are not tidy. If you fold the data into a long format first, the cross-product correlation is relatively straightforward in arquero: the only weird bit is a custom join function to avoid duplicating keys on the left and right. const lo…

[image] bmschmidt: const long = aq .from(data) .fold(aq.not("Date"), {"as": ["company", "price"]}) return long .join(long, (a, b) => op.equal(a.Date, b.Date) && a.company < b.company) .groupby("company_1", "company_2") .rollup( {correlation: op.corr("price_1", "…

The suggestion made by @bmschmidt in this post was generalized and compared to the original pattern in this notebook: Arquero Correlation Speed Test / Mario Delgado / Observable . The difference in time for both analyses is significant; in favor of the dynamic rollup pattern originally introduced in…

Dynamic rollup object for Arquero

Help

severo March 2, 2021, 9:58am 2

Topic		Replies	Views
Get month name in Arquero table Help	6	1031	March 7, 2021
Round to 2 decimals using Arquero Help	4	313	August 30, 2023
Derive Columns in the Data Table Cell Announcements	0	476	June 1, 2023
Creating "Formula" Columns Help	5	1241	September 11, 2023
Table expressions do not support closures Help	2	828	July 31, 2022

Dynamic rollup object for Arquero

Related topics