.. _pivottablejsrst:

============
pivottablejs
============


.. only:: html

    **Links:** :download:`notebook <pivottablejs.ipynb>`, :downloadlink:`html <pivottablejs2html.html>`, :download:`PDF <pivottablejs.pdf>`, :download:`python <pivottablejs.py>`, :downloadlink:`slides <pivottablejs.slides.html>`, :githublink:`GitHub|_doc/notebooks/pivottablejs.ipynb|*`


pivottable from a notebook with pivottablejs.

.. code:: ipython3

    import pandas
    df = pandas.DataFrame([dict(a="a", b="b", x=1.0, y=2.0),
                           dict(a="aa", b="bb", x=10.0, y=20.0)])
    df






.. raw:: html

    <div>
    <table border="1" class="dataframe">
      <thead>
        <tr style="text-align: right;">
          <th></th>
          <th>a</th>
          <th>b</th>
          <th>x</th>
          <th>y</th>
        </tr>
      </thead>
      <tbody>
        <tr>
          <th>0</th>
          <td>a</td>
          <td>b</td>
          <td>1.0</td>
          <td>2.0</td>
        </tr>
        <tr>
          <th>1</th>
          <td>aa</td>
          <td>bb</td>
          <td>10.0</td>
          <td>20.0</td>
        </tr>
      </tbody>
    </table>
    </div>



.. code:: ipython3

    from pivottablejs import pivot_ui
    pivot_ui(df, height=200)






.. raw:: html


    <iframe
        width="100%"
        height="200"
        src="pivottablejs.html"
        frameborder="0"
        allowfullscreen
    ></iframe>