PHPackages xp-forge/pivot - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Utility & Helpers](/categories/utility) 4. / 5. xp-forge/pivot ActiveLibrary[Utility & Helpers](/categories/utility) xp-forge/pivot ============== Pivot table v3.2.0(2y ago)131BSD-3-ClausePHPPHP >=7.0.0 Since May 18Pushed 2y ago1 watchersCompare [ Source](https://github.com/xp-forge/pivot)[ Packagist](https://packagist.org/packages/xp-forge/pivot)[ Docs](http://xp-framework.net/)[ RSS](/packages/xp-forge-pivot/feed)WikiDiscussions master Synced 1mo ago READMEChangelog (8)Dependencies (3)Versions (9)Used By (0) Pivot table =========== [](#pivot-table) [![Build status on GitHub](https://github.com/xp-forge/pivot/workflows/Tests/badge.svg)](https://github.com/xp-forge/pivot/actions)[![XP Framework Module](https://raw.githubusercontent.com/xp-framework/web/master/static/xp-framework-badge.png)](https://github.com/xp-framework/core)[![BSD Licence](https://raw.githubusercontent.com/xp-framework/web/master/static/licence-bsd.png)](https://github.com/xp-framework/core/blob/master/LICENCE.md)[![Requires PHP 7.0+](https://raw.githubusercontent.com/xp-framework/web/master/static/php-7_0plus.svg)](http://php.net/)[![Supports PHP 8.0+](https://raw.githubusercontent.com/xp-framework/web/master/static/php-8_0plus.svg)](http://php.net/)[![Latest Stable Version](https://camo.githubusercontent.com/0ffe0adc5aef66d9a0387b4189740bf473694f614147120c81b6e747048a15bd/68747470733a2f2f706f7365722e707567782e6f72672f78702d666f7267652f7069766f742f76657273696f6e2e706e67)](https://packagist.org/packages/xp-forge/pivot) Working with [pivot tables](https://en.wikipedia.org/wiki/Pivot_table) Example ------- [](#example) Given the following input, e.g. from a logfile: ``` 2015-05-10 00:00:09 OK: 304 100 bytes 2015-05-10 00:00:48 GOOD: 200 102 bytes (ETag: 214ceb4b-980-3a7bbd9630480) 2015-05-10 03:00:49 ERROR: 404 512 bytes (Not found) 2015-05-11 00:00:17 OK: 304 102 bytes 2015-05-11 02:01:01 ERROR: 500 0 bytes (Internal Server Error) 2015-05-11 02:01:02 ERROR: 500 256 bytes (Internal Server Error) ... ``` We will parse this using `sscanf()`, transforming the lines into arrays like the following: ``` ["2015-05-10", "00:00:48", "GOOD", 200, 95, "ETag: 214ceb4b-980-3a7bbd9630480"] ``` We can the load this into our pivot table using the array offsets (*if we had a map, we could use its string keys; for objects we'll pass references to the getters and for more complex situations we can pass closures*). Putting it together, we get the following: ``` use io\streams\{TextReader, FileInputStream}; use util\data\PivotCreation; $pivot= (new PivotCreation()) ->groupingBy(2) // category ->groupingBy(3) // code ->spreadingBy(0) // date ->summing(4, 'bytes') // bytes ->create() ); $reader= new TextReader(new FileInputStream('measures.log')); while (null !== ($line= $reader->readLine())) { $pivot->add(sscanf($line, '%[0-9-] %[0-9:] %[^:]: %d %d bytes (%[^)])')); } ``` The resulting table will look something like this (using "b:" as an abbreviation for *bytes* - this becomes relevant once we sum on multiple columns): ``` .------------------------------------------------------- ~ ---------------------------. | || Columns | | | ||--------------------------------- ~ -| | | Category | Count || 2015-05-10 | 2015-05-11 |- ~ -| Sum | Average | |-----------|--------||---------------|---------------|- ~ -|------------|------------| | OK | 2 || 1, b:100 | 1, b:102 |- ~ -| b:202 | b:101 | | GOOD | 1 || 1, b:102 | |- ~ -| b:102 | b:102 | | ERROR | 3 || 2, b:512 | 1, b:256 |- ~ -| b:768 | b:256 | | ^- client | ^- 1 || ^- 1, b:512 | |- ~ -| ^- b:512 | ^- b:512 | | ^- 404 | ^- 1 || ^- 1, b:512 | |- ~ -| ^- b:512 | ^- b:512 | | ^- server | ^- 2 || ^- 1, b:0 | ^- 1, b:256 |- ~ -| ^- b:256 | ^- b:128 | | ^- 500 | ^- 2 || ^- 1, b:0 | ^- 1, b:256 |- ~ -| ^- b:256 | ^- b:128 | |-----------|--------||---------------|---------------|- ~ -|------------|------------| | Total | 6 || b:714 | b:358 |- ~ -| b:1072 | b:178.7 | `------------------------------------------------------- ~ ---------------------------´ ``` ### Accessing values in a pivot [](#accessing-values-in-a-pivot) The number of records grouped by the grouping columns can be retrieved via `count()`. The aggregates can be accessed by passing the category to the respective methods. ``` $count= $pivot->count('OK'); // 2 $count= $pivot->count(); // 6 $count= $pivot->records('2015-05-10', 'OK'); // 1 $count= $pivot->records('2015-05-10'); // 4 $transferred= $pivot->column('2015-05-10', 'OK')['bytes']; // 100 $transferred= $pivot->column('2015-05-10')['bytes']; // 714 $transferred= $pivot->sum('OK')['bytes']; // 202 $transferred= $pivot->sum()['bytes']; // 1072 $average= $pivot->average('OK')['bytes']; // 101.0 $average= $pivot->average()['bytes']; // 178.7 ``` ### Drill down [](#drill-down) We can dril down by the categories we grouped on by using the `rows()` method. To calculate the distribution of categories in percent of the total, we'll use the `count()` method. ``` $rows= $pivot->rows(); // ['OK', 'GOOD', 'ERROR'] // OK: 2 / 6 = 33.3% // GOOD: 1 / 6 = 16.7% // ERROR: 3 / 6 = 50.0% $total= $pivot->count(); foreach ($rows as $cat) { $count= $pivot->count($cat); printf("%s: %d / %d = %.1f%%\n", $cat, $count, $total, $count / $total * 100); } // client: 1 // server: 2 foreach ($pivot->rows('ERROR') as $code) { printf("ERROR %s: %dx\n", $row, $pivot->count('ERROR', $code)); } ``` It can also interesting to see a development over time, so we'll drill down based on the columsn instead. ``` $columns= $pivot->columns(); // ['2015-05-10', '2015-05-11'] // 2015-05-10: 714 / 1072 bytes = 66.6% // 2015-05-11: 358 / 1072 bytes = 33.4% $total= $pivot->total()['bytes']; foreach ($columns as $date) { $bytes= $pivot->column($date)['bytes']; printf("%s: %d / %d bytes = %.1f%%\n", $date, $bytes, $total, $bytes / $total * 100); } ``` ### Health Score 28 — LowBetter than 54% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity9 Limited adoption so far Community7 Small or concentrated contributor base Maturity63 Established project with proven stability Bus Factor1 Top contributor holds 100% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~461 days Recently: every ~545 days Total 8 Last Release 785d ago Major Versions v0.1.0 → v1.0.02016-02-21 v1.1.0 → v2.0.02018-04-02 v2.0.1 → v3.0.02020-04-11 PHP version history (4 changes)v0.1.0PHP >=5.4.0 v1.0.0PHP >=5.5.0 v2.0.0PHP >=5.6.0 v3.0.0PHP >=7.0.0 ### Community Maintainers ![](https://www.gravatar.com/avatar/07d18d882c8b4aaf3466432f64018214f2771eda333202175431ee7233795376?d=identicon)[thekid](/maintainers/thekid) --- Top Contributors [![thekid](https://avatars.githubusercontent.com/u/696742?v=4)](https://github.com/thekid "thekid (44 commits)") --- Tags pivot-tablesxp-frameworkmodulexp ### Embed Badge ![Health badge](/badges/xp-forge-pivot/health.svg) ``` [![Health](https://phpackages.com/badges/xp-forge-pivot/health.svg)](https://phpackages.com/packages/xp-forge-pivot) ``` PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)