Top "Pivot-table" questions

A "pivot table" is a method of summarizing data in tabular form.

How to create a pivot table on extremely large dataframes in Pandas

I need to create a pivot table of 2000 columns by around 30-50 million rows from a dataset of around 60 million …

python python-3.x pandas pivot-table
Create comma-delimited values in Excel (using PivotTable)?

Is there a way to generate comma-delimited values in Excel (optimally using a PivotTable)? Consider the following data: Object Color …

excel pivot-table denormalization csv
Sum of Averages in Excel Pivot Table

I am measuring room utilization (time used/time available) from a data dump. Each row contains the available time for …

excel ms-office pivot-table utilization vba
How to join multiple tables including lookup table and return data in rows

I'm trying to display some simple computer game results and make it easy to iterate through the results line by …

mysql sql pivot-table lookup-tables jointable
R Webshot jpeg image is blank

I am trying to get a screenshot image of rPivotTable in Shiny. I am saving the rpivottable using saveWidget() from …

r pivot-table rpivottable
in R, customize names of columns created by dcast.data.table

I am new to reshape2 and data.table and trying to learn the syntax. I have a data.table that …

r data.table pivot-table reshape2
Calculating Weekly Average by user given daily data input in excel pivot table

So I started using Pivot Tables a few weeks ago, but I'm pretty decent at Excel otherwise. I hit an …

excel pivot-table kpi
Seed a pivot table using factories in Laravel

I'm new to Laravel and I'm looking for a good way to seed a pivot table using factories. I don't …

php laravel pivot-table factory laravel-seeding
Excel Pivot Tables - Calculated Fields How to Return Blank Cells

I'm working with pivot tables in excel and historical monthly returns for different mutual funds. I'm trying to calculate the …

excel excel-formula pivot pivot-table calculated-field
download rpivotTable output in shiny

I've found an interesting package rpivotTable. I'd like to create shiny app which includes rpivotTable with the possibility to download …

r download shiny pivot-table rpivottable