Spreadsheet for Data Science

Use JavaScript to work with Spreadsheet data

Build and use JavaScript data science libraries

Examples

Clean text using regular expression

Pick a random cell from table

Shuffle array of values

Calculate month difference using moment.js

DataLib

Summary Statistics (count, unique, median, quartile, quantile, variance, stdev)
Distance and Correlation Measures (dot, rank, cor, cor.rank, cor.dist, dist, dist.mat)
Entropy Measures (entropy, mutual)
Binning, Histograms and Profiles (bins, bins.date, histogram)

jStat

rows, cols, dimensions, row, col, diag, antidiag, tranpose
map, cumreduce, alter, create, zeros, ones, rand, identity, clear, symmetric
utils.calcRdx, utils.isArray, utils.isFunction, utils.isNumber

Excel Formulas

Support for most Excel formulas (ABS, SUM, AVERAGE)