NReco.PivotData
1.4.2
dotnet add package NReco.PivotData --version 1.4.2
NuGet\Install-Package NReco.PivotData -Version 1.4.2
<PackageReference Include="NReco.PivotData" Version="1.4.2" />
paket add NReco.PivotData --version 1.4.2
#r "nuget: NReco.PivotData, 1.4.2"
// Install NReco.PivotData as a Cake Addin
#addin nuget:?package=NReco.PivotData&version=1.4.2
// Install NReco.PivotData as a Cake Tool
#tool nuget:?package=NReco.PivotData&version=1.4.2
PivotData OLAP library: in-memory multidimensional dataset for data aggregations (count, sum, avg, min, max, count unique, median, mode or custom function), OLAP queries (roll-ups, slice and dice, transformations), pivot table data model.
Source code and examples: https://github.com/nreco/pivotdata
Usage conditions, online demo: https://www.nrecosite.com/pivot_data_library_net.aspx
Get started: https://www.nrecosite.com/pivotdata/cube-basics.aspx
Product | Versions |
---|---|
.NET | net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows net7.0 net7.0-android net7.0-ios net7.0-maccatalyst net7.0-macos net7.0-tvos net7.0-windows |
.NET Core | netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1 |
.NET Standard | netstandard2.0 netstandard2.1 |
.NET Framework | net45 net451 net452 net46 net461 net462 net463 net47 net471 net472 net48 net481 |
MonoAndroid | monoandroid |
MonoMac | monomac |
MonoTouch | monotouch |
Tizen | tizen40 tizen60 |
Xamarin.iOS | xamarinios |
Xamarin.Mac | xamarinmac |
Xamarin.TVOS | xamarintvos |
Xamarin.WatchOS | xamarinwatchos |
-
.NETFramework 4.5
- No dependencies.
-
.NETStandard 2.0
- No dependencies.
-
.NETStandard 2.1
- No dependencies.
NuGet packages (1)
Showing the top 1 NuGet packages that depend on NReco.PivotData:
Package | Downloads |
---|---|
NReco.PivotData.Extensions
PivotData Toolkit (extends NReco.PivotData OLAP library): advanced components for pivot table reports generation (HTML, JSON, CSV, Excel, PDF, DataTable), formatting wrappers (percentages, differences, running total, heatmap, topN/pagination/groups expand-collapse), CSV/JSON/SQL input data loaders, web-based reports builder for end-users. More details: https://www.nrecosite.com/pivot_data_library_net.aspx |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
1.4.2 | 1,679 | 2/2/2023 |
1.4.1 | 2,104 | 8/26/2022 |
1.4.0 | 1,247 | 7/13/2022 |
1.3.8 | 32,129 | 5/27/2020 |
1.3.7 | 161,096 | 7/18/2018 |
1.3.6 | 46,285 | 4/6/2018 |
1.3.5 | 1,856 | 2/26/2018 |
1.3.4 | 18,395 | 2/1/2017 |
1.3.3 | 25,960 | 10/18/2016 |
1.3.2 | 2,228 | 8/14/2016 |
1.3.1 | 1,815 | 7/5/2016 |
1.3.0 | 3,288 | 5/10/2016 |
1.2.6 | 2,482 | 2/4/2016 |
1.2.5 | 1,373 | 1/13/2016 |
1.2.4 | 1,332 | 12/11/2015 |
1.2.3 | 1,711 | 9/30/2015 |
v.1.4.2 changes:
- PivotTable now skips Key.Empty keys when calculates ColumnKeys/RowKeys (github issue #11)
v.1.4.1 changes:
- AverageAggregator (and SumAggregator) now returns null instead of zero if count=0 (like SQL AVG/SUM)
v.1.4.0 changes:
- added netstandard2.1 build
- added PivotData.ProcessDataAsync methods (available only in netstandard2.1 build)
v.1.3.8 changes:
- removed builds for legacy targets (only netstandard20 and net45 are included)
- PivotTable class: fixed issue with sort-by-value for single-measure that is FormulaAggregator
- PivotTable class: fixed issue with sort-by-value when aggregator value is IList (ListAggregator, ListUniqueAggregator)
- PivotTable class: added ability to set custom IComparer for values (ValuesComparer property)
- PivotData class: fixed issue in ValueKey comparison for numeric dimension keys (cases like int vs long).
v.1.3.7 changes:
- fixed PivotDataState serialization issue with Key.Empty
- PivotData class: XOR-based hash function for keys replaced with sum-based to avoid collisions
- performance optimization: less array allocations in PivotData.ProcessData method and PivotTable class
v.1.3.6 changes:
- added ModeAggregator (calculates value that appears most often)
- fixed issue with slow sub-totals calculation in some cases
- always use InvariantCulture for numbers parsing