1.0.10 • Published 1 year ago

ts-data-model v1.0.10

Weekly downloads
-
License
ISC
Repository
-
Last release
1 year ago

ts-data-model library

Using the library

To install the library in your project

    yarn add "ts-data-model"

To use the library in your react project

import { DataModel, fromDhis2 } from "ts-data-model"

const x = DataModel({ input: data, adapter: fromDhis2 })

Library Documentation

The ts-data-model libary consists of 4 major modules:

  1. Data Adapters
  2. Data Transformations
  3. Data Formmaters
  4. Utils functions

Mapping

FunctionFunction typeFunctions used in implementation
fromDhis2Data AdapterfindPosition, transpose, fromColumnDict
fromColumnDictData Adapter
fromArrayOfArraysData Adapter
toColumnDictData Formatter
toArrayOfArraysData Formatter
applyData Transformation
mapData TransformationaddColumns, apply
aggData Transformation
joinData TransformationinnerJoin, outerJoin
filterData TransformationbuildFilterFn, evaluateOr, evaluateAnd
addColumnsData Transformation
fillNaNData TransformationdetectNaN
dropNaNData TransformationdetectNaN
selectColumnsData Transformation
renameData Transformation
transposeUtils
findPositionUtils
innerJoinUtils
outerJoinUtils

Mapping diagram

Diagram

Data Adapters

Description: Data adapters are functions that convert output from different sources to the standard data model structure i.e. an array of objects

fromDhis2

Description: function to convert output from a dhis2 analytics query to the standard model structure i.e. an array of objects Example usage

import { DataModel } from "ts-data-model"
 const response = {
    headers: [
                { name: "dx", column: "Data", valueType: "TEXT", type: "java.lang.String", hidden: false, meta: true,},
                { name: "pe", column: "Period", valueType: "TEXT", type: "java.lang.String", hidden: false, meta: true,},
                { name: "ou", column: "Organisation unit", valueType: "TEXT", type: "java.lang.String", hidden: false, meta: true,},
                {name: "value", column: "Value", valueType: "NUMBER", type: "java.lang.Double", hidden: false, meta: false,},
                {name: "factor", column: "Factor", valueType: "NUMBER", type: "java.lang.Double", hidden: false, meta: false,},
                {name: "multiplier", column: "Multiplier", valueType: "NUMBER", type: "java.lang.Double", hidden: false, meta: false,},
                {name: "denominator", column: "Denominator", valueType: "NUMBER", type: "java.lang.Double", hidden: false, meta: false,},
                {name: "divisor", column: "Divisor", valueType: "NUMBER", type: "java.lang.Double", hidden: false, meta: false,},
              ]
    rows:
            [
               ['fbfJHSPpUQD', '202205', 'ARZ4y5i4reU', '18', '0', '0', '0', '0', '0'];
               ['fbfJHSPpUQD', '202201', 'YmmeuGbqOwR', '23', '0', '0', '0', '0', '0']
            ]
  }

const data = new DataModel({ input: response, adapter: fromDhis2 })

fromColumnDict

Description: You can create the data model object from a column dictionary using the fromColumnDict adapter Example usage

import { DataModel } from "ts-data-model"
const d2 = {
  "column 1": ["1", "2"],
  "column 2": ["3", "4"],
}

const data = new DataModel({ input: response, adapter: fromColumnDict })

Data Transformations

Description: functions that operate on a data model object, changing its columns or rows, but returning an object that keeps the structure of the data model. Transformations are categorizd into Aggregators, Selectors, Reducers, Mutators

Aggregators

Transformations implemented: agg Example usage

import { agg } from "ts-data-model"

const aggregations = [
  ["age", "sum"],
  ["age", "mean"],
]

const result = data.agg({ groupBy: ["city", "gender"], aggregations })

Reducers

Transformations implemented: filter Example usage:

import { filter } from "ts-data-model"

const filterCriteria = [
  "city",
  "=",
  ["London", "Paris"],
  "&&",
  "age",
  ">",
  30,
  "&&",
  "age",
  "<=",
  40,
]

const filteredData = data.filterData({ filterCriteria: filterCriteria })

Mutators

Transformations implemented: apply, fillNaN

apply

Example usage

const transformFn = (row) => {
  const bonus = row.salary * 0.1
  return { age: row.age * 2, salary: row.salary + bonus, name: row.name }
}

const transformedData = data.apply({ transformFn: transformFn })

fillNaN

Example usage

data.fillNaN()
1.0.10

1 year ago

1.0.9

1 year ago

1.0.8

1 year ago

1.0.7

1 year ago

1.0.6

1 year ago

1.0.5

1 year ago

1.0.4

1 year ago

1.0.3

1 year ago

1.0.2

1 year ago

1.0.1

1 year ago

1.0.0

1 year ago