Re: [Jprogramming] How to merge consecutive and non-consecutive data?

2020-06-05 Thread Raul Miller
Note: If I did have to support the textual representation, I would change my B and T to be values which could never appear otherwise. For example: B=:0.12345 T=:9.78654 Then I could use: require'csv' rplc&(',0.12345,';',B,';',9.78654,';',T,';',0.0,';',,') makecsv result to format the resul

Re: [Jprogramming] How to merge consecutive and non-consecutive data?

2020-06-05 Thread Raul Miller
Here is how I would first approach this problem. (I might have to rephrase if the U/. mechanism is too slow on large data sets.) tableA=:".;._2(0 :0)-.'-' 2020-05-04,119.39,121.97 2020-05-05,122.47,124.31 2020-05-06,122.41,124.05 2020-05-07,121.06,123.26 2020-05-08,121.06,123.23 2020-05-11,120.67,

[Jprogramming] How to merge consecutive and non-consecutive data?

2020-06-05 Thread HH PackRat
Another project, another question Below are two tables. Table A is daily stock data showing date, daily low, and daily high (columns 0, 1, 2). Table B is stock pivots only (based on a particular percentage between them), showing date and whether the pivot was a top (T) or a bottom (B) (colum