Frame

construct a new frame, Note once you have passed the data and column arguments, you no longer own those two items and should not modify them or any of their content

Override:

Array of column names the are predominantly numeric, the values may be number or number like staring \ * @return {[string]} array of column names that are predominantly numeric

Override:

Get an array of row objects

[asObj description]

Return a list of RowObject from the frame

Concatinate frames and return a new frame (does not modify any of the input frames)

The default behavior of this method is to convert numeric strings into and return a new frame will the converted data. It tries to reuse as much of the data as possible

If a conversion list is supplied, each element of the list consists of the following [ testFunc(aValue) -- This takes a value a returns true or false convertFn(aValue) -- and returns the new value ] for each cell we apply the testFunc if false then try the next testFunc in the list if the testFunc return true, the apply the convertFn to the cell value to the new value if non of the testFn succeeds then the cell remains unchanged

Takes a filter function or an array of row indicies and returns a new Frame with the selected rows

same as filter but returns the index of the filtered lines

find a row using the test function fn. The test function recieves a row ia s RowObject facade, see _rowObj method.

similar to an array forEach

similar semantics to SQL groupBy, assumes list has bee sorted by 'groupCols' aFrame.groupBy(['mon',"weekday"], [gbSum('v1','sumV1'), gbCount('weekday', 'numWeekDays'), gbMin('v2', 'minV2'), gbMax('v1','maxV1'), gbMean('v1','meanV1') ])

This is like SQL innerJoin join the rows where value of colFromThis ==

leftJoin similar to sql left join, it is like innerJoin but all the rows of the 'this' are prensnt in the output

Remove all redundent copies of strings, this is the only destructive operation oan aframe while still maintaining functional purity

An alias for the Frame.mapF

Similar to Array.map

Convert several columns into a single column, the elements rae converted to theeir string representation

e.g aFrame.columns = ['name','street','city','state','zip'] but we want to convert it into a ['name', 'address'] so: ['street','city','state','zip'] => ['address']

newFrame = aFrame.mergeCols(null, ['street','city','state','zip'], 'address', ", ");

Like leftJoin, but all th rows of both the left frame (this) and rightFrame ar present in the output

colsMapping can be a

      1. rearranged list of col names from the frame e.g [ 'B', 'A', 'F']
      2. or rearranged list of col names [ 
         ...('columnName' | 'oldName=newName' | 'newColumnName')
         ] 

example of usage: list - Frame with list.data:

       [ [ 'jan', 'mon', 1, 2 ],
         [ 'jan', 'tue', 2, 6 ],
         [ 'jan', 'wed', 3, 4 ],
         [ 'jan', 'thu', undefined, 1 ],
         ...


      list.columns: [ 'mon', 'weekday', 'v1', 'v2' ],

add column 'nurul' with value 123, change 'weekday' to uppercase, 'v1' conver undefined to 0

    // Note the names if mapper are the new column names
    var mapper = {
         nurul: (v, rowObj, i,row) => "123",
         weekday: (v) => v.toUpperCase(),
         v1: (v) => v===undefined?0:v
    };

    list.project([ 'mon', 'weekday','nurul' , 'v1', 'v2' ], mapper);

result:

     [     [ 'jan', 'MON', '123', 1, 2 ],
        [ 'jan', 'TUE', '123', 2, 6 ],
        [ 'jan', 'WED', '123', 3, 4 ],
          'jan', 'THU', '123', 0, 1 ],
        ...

another expample:

       // Note the use. of the now column names
       function toNm(x) { x? (+x) : 0; }
       var mapper1 = {
         nurul: () => "123",
         "Week Day": v => v?v.toUpperCase(): '',
         v1: (v) => v===undefined?0:v,
         v3: (v, rowObj) => toNm(rowObj.v1) + toNm(rowObj.v2) // sum of v1 and v2
      }; 
      list.project([ 'mon=Month', 'weekday=Week Day','nurul' , 'v1', 'v2', 'v3' ], mapper);        

the result is the same as the previous example, but the columns names will now be ['Month', 'Week Day', 'nurul', 'v1', 'v2', 'v3' ]

[project description]

Similar to arry reduce except it works on frames

Rename columns, format for which [ 'oldColumnName=newColumnName' ...]

select a more convinient interface to project, an analog to sql select The primary diffenrence is the setting of new columns or adding new columns has been made more convinient

Example of setting columns [ 'oldColumn', 'oldColumn=newColumnName', ['oldCol1=newColName1', (v,ro) => some-operation], ['oldCol1=newColName1', someValue], ['newCol', someValue], ['newCol2', (v,ro) => someComputedValue] ]

[sort description]

Returns a function that can be used iteratively to project one array to another. This is

Convinience method as an alias for the project method

withIndex add an index column to the befining of the frame or at the end of the frame

Creates a filter function the for the additional join checck Note the primary joining action (primary criterion) is the joinOp which look like this joinOp => 'commonColumnNameInBothFrames' or 'colFram1==colFrame2'

_rowObj This is an code efficient mathod of accessing the element of the 'rowLikeArray' using the columns names of the frame. The RowElement created is a facade to the rowLikeArray, it does not actuall copy the elements of the array to itself. It is just a convinient way of retrieving the elements of the array by name.

e.g. if the this.columns : ['name', 'age', 'sex']

let arr = ['Jane', 21, 'Female']; let ro = this._rowObj(arr,5);

ro.sex is the same as arr[2] == 'Female' ro.name === arr[0] ro._index$ === 5

Finally: arr[2] = 'Male'; ro.sex === 'Male'

Return a string represent of the frame formatted as an HTML table