Skip to content
/ json.pivot Public

Perform Pivot (sorting & table-building) operations on JSON data.

Notifications You must be signed in to change notification settings

z5h/json.pivot

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 

Repository files navigation

json.pivot

*What:* 
A JavaScript function for performing "pivot table"-like operations on JSON data.

*How:* 
call pivot(data, rowNames, columnNames, userOptions)
  data - an array of *homogeneous json objects. (* at least share some common fields that we're interested in)
  rowNames - an array of property names, each one is a property of all objects in data 
  colNames - an array of property names, each one is a property of all objects in data 
  (colNames and rowNames should not contain any similar values)
  userOptions - to be documented later. leave it null or peek at the code


Example:
var data = [
  {subject : 1, day : 1, value : 31.25, treatment : 'A' },
  {subject : 1, day : 2, value : 31.25, treatment : 'C' },
  {subject : 1, day : 3, value : 33.12, treatment : 'B' },
  {subject : 2, day : 1, value : 25.87, treatment : 'C' },
  {subject : 2, day : 2, value : 26.63, treatment : 'A' },
  {subject : 2, day : 3, value : 26.00, treatment : 'B' },
  {subject : 3, day : 1, value : 23.75, treatment : 'C' },
  {subject : 3, day : 2, value : 26.13, treatment : 'B' },
  {subject : 3, day : 3, value : 24.87, treatment : 'A' },
  {subject : 4, day : 1, value : 28.75, treatment : 'A' },
  {subject : 4, day : 2, value : 29.63, treatment : 'B' },
  {subject : 4, day : 3, value : 29.87, treatment : 'C' },
  {subject : 5, day : 1, value : 24.50, treatment : 'C' },
  {subject : 5, day : 2, value : 28.63, treatment : 'A' },
  {subject : 5, day : 3, value : 28.37, treatment : 'B' },
  {subject : 6, day : 1, value : 31.25, treatment : 'B' },
  {subject : 6, day : 2, value : 30.63, treatment : 'A' },
  {subject : 6, day : 3, value : 29.37, treatment : 'C' },
  {subject : 7, day : 1, value : 25.50, treatment : 'B' },
  {subject : 7, day : 2, value : 23.87, treatment : 'C' },
  {subject : 7, day : 3, value : 24.00, treatment : 'A' },
  {subject : 8, day : 1, value : 28.50, treatment : 'B' },
  {subject : 8, day : 2, value : 27.87, treatment : 'C' },
  {subject : 8, day : 3, value : 30.12, treatment : 'A' },
  {subject : 9, day : 1, value : 25.13, treatment : 'A' },
  {subject : 9, day : 2, value : 27.00, treatment : 'B' },
  {subject : 9, day : 3, value : 24.63, treatment : 'C' }
];

var result = pivot(data, ['subject'], ['day','treatment'], {});

result is an array of rows, of columns of data.
In this case, rows are sorted by subject, columns are sorted by day, then treatment.
result.rowHeaders containes information about the row headers.
result.columnHeaders containes information about the column headers.

result[row][column] will return undefined if no data exists in that slot,
otherwise it will contain an array of all data that fell in that slot.

Something like this is perfectly legal too:
var result = pivot(data, ['treatment'], [], {});

It aggregates/sorts the data based on treatment.

-Mark Bolusmjak
bolusmjak@gmail.com

About

Perform Pivot (sorting & table-building) operations on JSON data.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published