Stack Overflow
Stack Overflow

Questions tagged [pivottable.js]

PivotTable.js is a Javascript Pivot Table (aka Pivot Grid, Pivot Chart, Cross-Tab) implementation with drag'n'drop, written by Nicolas Kruchten.

PivotTable.js is a Javascript Pivot Table library with drag'n'drop functionality built on top of jQuery/jQueryUI and originally written in CoffeeScript by Nicolas Kruchten.

PivotTable.js' basic function is to turn a data set into a summary table and then optionally add a true 2-d drag'n'drop UI to allow a user to manipulate this summary table, turning it into a pivot table, very similar to the one found in older versions of Microsoft Excel with a bunch of extra developer-oriented features and some visualization effects.

Source & documentation: https://github.com/nicolaskruchten/pivottable

Examples: http://nicolas.kruchten.com/pivottable/examples/index.html

78 questions
8
votes
1 answer

D3 Treemap v3 to v4

I am new to D3 and I am trying to convert a D3 Treemap from V3 to V4. I have already read some information update the updated code but I can´t figure out to get it working. The treemap is from the Pivottable.js D3 renderer. This is the part. …
Peter
  • 345
  • 1
  • 13
6
votes
2 answers

Adding responsiveness to pivottable

I have been using (http://nicolas.kruchten.com/pivottable) pivottable.js in one of my application. The table has been rendered fine but I am facing issues while adding responsiveness to my UI. The table don't shrink to the div sizes defined for…
Saurabh
  • 159
  • 4
  • 17
5
votes
0 answers

R rpivotTable add Plotly chart renderers

I want to add Plotly chart renderers to the rpivotTable() function from the R package rpivotTable. I followed the instructions given in the Javascript Pivot Table Wiki to add optional extra renderers. Unfortunatey, following these instructions will…
Andreas Kitsche
  • 51
  • 2
5
votes
3 answers

How to apply filters dynamically in nicolaskruchten pivottable.js

I am using nicolaskruchten pivottable, for displaying my data using: $('#output').pivot([ {country: "USA", city: "Boston"}, {country: "USA", city: "NYC"}, {country: "UK", city: "London"}, ], { rows: ["country"], cols:…
Mayur
  • 1,123
  • 3
  • 22
  • 38
4
votes
0 answers

Creating aggregators in rpivotTable

I'm starting to use the rpivotTable function: library(rpivotTable) rpivotTable(mtcars, rows="gear", col="cyl", aggregatorName="Average", vals="mpg", rendererName="Bar Chart") With this code I have the average mpg by cyl and gear. What if I would…
dax90
  • 1,088
  • 14
  • 29
4
votes
1 answer

pivottable display html in table

I am trying to use https://github.com/nicolaskruchten/pivottable, basically I want to show image in the table. What I've done so far is ; but it wont display the image as img tag instead it considers it as string
Ktt
  • 469
  • 3
  • 8
  • 18
3
votes
1 answer

Save configuration of pivottablejs in Jupyter notebook

I am using google Colab (Jupyter python notebook on a server) to run the pivot table. This code: pivot_ui(d1,outfile_path='pivottablejs.html') HTML('pivottablejs.html') Results in this blank pivot: Which I can manipulate to get this desired…
Johnny V
  • 1,108
  • 14
  • 21
3
votes
4 answers

How do I re render the entire React Pivot Table UI component when I change the selection in select tag?

I am new to react js and I am trying to create a pivot table using React Pivot table. I want to be able to select a data set using a select drop down menu and update the state and re render the full table whenever there is a change in the drop down…
Yash Nigam
  • 117
  • 1
  • 8
3
votes
3 answers

PivotTable.js conditionally change color on text

So I'm working with PivotTable.js which has been a great help at work. Right now though, I'm trying to get a filter going to change the color of cells or font within the cell depending on the value. For example, if I have an array of dates in my…
jdlam
  • 223
  • 3
  • 11
2
votes
1 answer

pivottable.js display introduces NULL values that don't exist in the source pandas Dataframe

I believe I'm using pivottable.js (in a Jupyter notebook) correctly, but please let me know if that's not the case. In this example, I'm creating almost the simplest pandas dataframe possible: test_data = DataFrame([['a', 'b'], ['b', 'a']],…
nick_montpetit
  • 51
  • 2
2
votes
1 answer

displaying data in Jupyter pivottable.js

I have a pandas DataFrame with 3 columns : product, region, and cost. I want to display a pivot table using pivottable.js in a Jupyter notebook such that product are rows, region are columns and cost are values. I have tried : from pivottablejs…
M. Page
  • 2,694
  • 2
  • 20
  • 35
2
votes
1 answer

Displaying average value in total column using PivotTable.js

I am using pivotable.js library, in this pivotable.js I want show average values of all cells in the total column instead of total of all cell values. Please have a look at the image below, which show how I want to display values in in…
niran
  • 1,920
  • 8
  • 34
  • 60
2
votes
1 answer

Reproduce example pivottable.js in jupyter notebook

I am trying to reproduce the example of pivottable.js in jupyter notebook (here https://github.com/nicolaskruchten/jupyter_pivottablejs/tree/master/example) but I get an error : Code (df is a pandas dataframe from a mps.csv in link above) from…
Sandra
  • 23
  • 5
2
votes
1 answer

pivottablejs does not display any result in the jupyter notebook

pivottablejs does not display any result in the jupyter notebook. Clicking on the hyperlink(pop out), displays an empty page. from pivottablejs import pivot_ui from IPython.display import IFrame from IPython.core.display import display import…
Hackerds
  • 1,195
  • 2
  • 16
  • 34
2
votes
1 answer

How to create fixed table headers using pivottable.js

I am using a JavaScript plugin (pivottable.js) to create pivot tables to display large data on a django site. I want to add a fixed/sticky table head that stays at the top of my div while I scroll down. Due to the creation of the tables in the…
M. Salzman
  • 23
  • 6
1
2 3 4 5 6