[
https://issues.apache.org/jira/browse/KNOX-2310?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17068219#comment-17068219
]
ASF subversion and git services commented on KNOX-2310:
-------------------------------------------------------
Commit 46ccd34da21c045c0727d217c281ae0c427dbe1f in knox's branch
refs/heads/master from Larry McCay
[ https://gitbox.apache.org/repos/asf?p=knox.git;h=46ccd34 ]
KNOX-2310 - Add aggregate method to KnoxShellTable (#302)
* KNOX-2310 - Add aggregate method to KnoxShellTable
Change-Id: I60eeeaf0f8d9b2419fd95944b4f394a021a7f308
* KNOX-2310 - Add aggregate method to KnoxShellTable
Change-Id: If44ab0a517f8189d130f34483859187cecda3df9
> Add aggregate method to KnoxShellTable
> --------------------------------------
>
> Key: KNOX-2310
> URL: https://issues.apache.org/jira/browse/KNOX-2310
> Project: Apache Knox
> Issue Type: Improvement
> Components: KnoxShell
> Reporter: Larry McCay
> Assignee: Larry McCay
> Priority: Major
> Fix For: 1.4.0
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> A simple method for producing a meaningful mathematical report of a dataset
> would allow the user to quickly determine some basic metrics of a dataset.
> For instance, given a dataset with time series data across columns, an
> aggregation of:
> * min
> * max
> * mean
> * median
> * mode
> * sum
> for specific columns would provide a way to visualize the changes across time.
> {code}
> knox:000> hopkinsC19.filter() name "Country/Region" equalTo "US" aggregate()
> columns "3/15/20, 3/16/20, 3/17/20, 3/18/20, 3/19/20, 3/20/20, 3/21/20"
> functions "min, max, mean, median, mode, sum" title "Confirmed COVID-19 US
> Cases over the last Week"
> ===> Confirmed COVID-19 US Cases over the last Week
> +----------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
> | | 3/15/20 | 3/16/20 | 3/17/20
> | 3/18/20 | 3/19/20 | 3/20/20 |
> 3/21/20 |
> +----------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
> | min | 0.0 | 0.0 | 1.0
> | 1.0 | 2.0 | 3.0 |
> 3.0 |
> | max | 732.0 | 967.0 | 1706.0
> | 2495.0 | 5365.0 | 8310.0 |
> 11710.0 |
> | mean | 62.482142857142826 | 82.71428571428568 |
> 114.66071428571433 | 138.98214285714295 | 244.23214285714275 |
> 341.0714285714283 | 455.1607142857145 |
> | median | 20.0 | 24.0 | 31.0
> | 40.5 | 56.0 | 79.0 |
> 120.0 |
> | mode | 1.0 | 1.0 | 3.0
> | 18.0 | 44.0 | 14.0 |
> 15.0 |
> | sum | 3499.0 | 4632.0 | 6421.0
> | 7783.0 | 13677.0 | 19100.0 |
> 25489.0 |
> +----------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
