Stack Overflow
Stack Overflow

Questions tagged [pivottabler]

9 questions
3
votes
2 answers

adding Calculation row to PivotTable in r

here's my data df=data.frame("indication"=c(1,1,0,0,1,0,1,1),"indication2"=c(1,0,1,0,1,0,0,1),"grade"=c(65,67,80,20,100,91,70,55), "group"=c("blue","red","green","blue","green","blue","red","green")) indication indication2 grade group 1 …
nomi
  • 91
  • 7
1
vote
1 answer

Performance issue creating pivot tables using pivottabler

I'm using a package called pivottabler in R to generate pivot tables in a Shiny dashboard. The report is awesome but it takes a long time to render (10 - 15 min) which is not a good user experience. I'm aware of the different factors that influence…
Micharro
  • 41
  • 3
1
vote
1 answer

Bringing subtotals upfront in pivottabler::qpvt

Wondering how to bring subtotals upfront (First row and/or first column) in pivottabler::qpvt. library(pivottabler) qpvt( dataFrame = bhmtrains , rows = c("=", "TOC") , columns = c("TrainCategory", "PowerType") …
MYaseen208
  • 22,666
  • 37
  • 165
  • 309
1
vote
1 answer

pivottabler: formating numbers with comma

I wonder how to display numbers with comma using qpvt and qhpvt functions from pivottabler R package. library(pivottabler) qpvt(bhmtrains, "TOC", "TrainCategory", "n()") Express Passenger Ordinary Passenger Total Arriva…
MYaseen208
  • 22,666
  • 37
  • 165
  • 309
0
votes
1 answer

Create pivot table in which a subset of column values are summed based on row grouping

I would like to take an .xlsx file of data in columns, and turn it into a pivot table in which a subset of column data is summed based on row groups. I have a table that looks like this: | Class | Instructor | ContactHours| | --------|…
Joneson
  • 1
  • 2
0
votes
0 answers

Pivottabler tallying number of cases in dataset, not their values

I am working through creating pivot tables with the Pivottabler package to summarise frequencies of rock art classes by location. The data I am summarising here are from published papers, and I have it stored in an RDS file created in R, and looks…
Mick Morrison
  • 1
  • 1
0
votes
0 answers

In R, how can {pivottabler} derive correct Month-over-Month Totals?

Hi R and {pivottabler} community, I'm trying to replicate a simple pivot table from Power BI in R, however I found it's kind of tricky to derive the Month-over-Month Totals properly in R using pivottabler. Here is the simple context: here is my raw…
Yuetian Jiang
  • 3
  • 2
0
votes
1 answer

pivottabler: Producing grouped summary statistics for total

Looking for how to produce grouped summary statistics for Total (last row appended) using pivottabler. library(pivottabler) qpvt( dataFrame = bhmtrains , rows = c("TOC", "Status") , columns = "TrainCategory" , calculations…
MYaseen208
  • 22,666
  • 37
  • 165
  • 309
0
votes
1 answer

Converting pivottabler output to dataframe/array?

I'm using the pivottabler package and have finally gotten the table i was looking for. However, I can't do more calculations/table manipulations because the table is in an html widget, not a dataframe. Using as.data.frame() doesn't work- is there…
Shane
  • 1