kandaa / json.pivot Goto Github PK
View Code? Open in Web Editor NEWThis project forked from z5h/json.pivot
Perform Pivot (sorting & table-building) operations on JSON data.
This project forked from z5h/json.pivot
Perform Pivot (sorting & table-building) operations on JSON data.
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 [email protected]
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.