Cross tabulation (Pivot table) utility to convert table data to a pivot table form.
Source (List table)
| os | lang | price |
|---|---|---|
| win | ruby | 123 |
| linux | ruby | 12 |
| mac | php | 270 |
| win | java | 560 |
| win | php | 750 |
| linux | java | 950 |
| win | java | 1200 |
| win | php | 500 |
| mac | php | 10 |
| mac | java | 566 |
| win | ruby | 210 |
>>>
Destination (Pivot table)
| ruby | java | php | |
|---|---|---|---|
| win | 333 | 1760 | 1250 |
| linux | 12 | 950 | 0 |
| mac | 0 | 566 | 280 |
The test code to get the sample table above.
Add this line to your application's Gemfile:
gem 'cross_table'And then execute:
$ bundle
Or install it yourself as:
$ gem install cross_table
require 'cross_table'
cross_tbl = CrossTable.counts_from(
recs: [], # Source List Table(Enumerable)
group_rules: [], # Grouping Rules (Array of Hash)
y_keys: [], # Y-axis Keys (Array)
x_keys: [] # X-axis Keys (Array)
ret_type: nil # Type of returned Pivot table. (nil|:xy_titles|:data_only)
)Sample test code of CrossTable.counts_from
Sample data and group_rule setting
require 'cross_table'
cross_tbl = CrossTable.sums_from(
recs: [], # Source List Table(Enumerable of Hash)
field: :fld_name # Target field name to be summarised
group_rules: [], # Grouping Rules (Array of Hash)
y_keys: [], # Y-axis Keys (Array)
x_keys: [] # X-axis Keys (Array)
ret_type: nil # Type of returned Pivot table. (nil|:xy_titles|:data_only)
)Sample test code of CrossTable.sums_from
Sample data and group_rule setting
require 'cross_table'
cross_tbl = CrossTable.avgs_from(
recs: [], # Source List Table(Enumerable of Hash)
field: :fld_name # Target field name to be summarised
group_rules: [], # Grouping Rules (Array of Hash)
y_keys: [], # Y-axis Keys (Array)
x_keys: [] # X-axis Keys (Array)
ret_type: nil # Type of returned Pivot table. (nil|:xy_titles|:data_only)
)Sample test code of CrossTable.avgs_from
Sample data and group_rule setting
require 'cross_table'
cross_tbl = CrossTable.from(
recs: [], # Source List Table(Enumerable of Hash)
group_rules: [], # Grouping Rules (Array of Hash)
y_keys: [], # Y-axis Keys (Array)
x_keys: [] # X-axis Keys (Array)
ret_type: nil # Type of returned Pivot table. (nil|:xy_titles|:data_only)
&aggr_proc # Proc/block to get a value from the arg "group_recs"
)Sample test code of CrossTable.from to get a Minumum value.
Sample data and group_rule setting
Sample test code of using multilpe keys.
To install this gem onto your local machine, run bundle exec rake install. To release a new version, update the version number in version.rb, and then run bundle exec rake release, which will create a git tag for the version, push git commits and tags, and push the .gem file to rubygems.org.
Bug reports and pull requests are welcome on GitHub at https://github.com/masa-kunikata/cross_table.
The gem is available as open source under the terms of the MIT License.
![dependabot[bot] avatar](https://avatars.githubusercontent.com/in/29110?v=4 "dependabot[bot]")
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent