.. _usingqgridwithjsdfrst:

=====================
using qgrid with jsdf
=====================


.. only:: html

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


This follows module `qgrid <https://github.com/quantopian/qgrid>`__. You
can find some options at
`SlickGrid/Grid-Options <https://github.com/mleibman/SlickGrid/wiki/Grid-Options>`__.

.. code:: ipython3

    import pyensae
    %load_ext pyensae

.. code:: ipython3

    import pandas
    df = pandas.DataFrame([{"x":2, "y":3},{"x":4, "y":5}])
    df






.. raw:: html

    <div>
    <table border="1" class="dataframe">
      <thead>
        <tr style="text-align: right;">
          <th></th>
          <th>x</th>
          <th>y</th>
        </tr>
      </thead>
      <tbody>
        <tr>
          <th>0</th>
          <td>2</td>
          <td>3</td>
        </tr>
        <tr>
          <th>1</th>
          <td>4</td>
          <td>5</td>
        </tr>
      </tbody>
    </table>
    </div>



.. code:: ipython3

    %jsdf






.. parsed-literal::
    ''



.. code:: ipython3

    %jsdf -h


.. parsed-literal::
    usage: jsdf [-h] [--defaultColumnWidth DEFAULTCOLUMNWIDTH]
                [--enableColumnReorder ENABLECOLUMNREORDER]
                [--multiColumnSort MULTICOLUMNSORT] [--rowHeight ROWHEIGHT]
                [--showHeaderRow SHOWHEADERROW]
                [--forceFitColumns FORCEFITCOLUMNS] [--autoHeight AUTOHEIGHT]
                [--enableCellNavigation ENABLECELLNAVIGATION]
                [--remote_slick REMOTE_SLICK] [--precision PRECISION]
                [--editable EDITABLE]
                df
    display a pandas DataFrame based on module qgrid
    positional arguments:
      df                    dataframe to display
    optional arguments:
      -h, --help            show this help message and exit
      --defaultColumnWidth DEFAULTCOLUMNWIDTH
                            see https://github.com/mleibman/SlickGrid/wiki/Grid-
                            Options
      --enableColumnReorder ENABLECOLUMNREORDER
                            see https://github.com/mleibman/SlickGrid/wiki/Grid-
                            Options
      --multiColumnSort MULTICOLUMNSORT
                            see https://github.com/mleibman/SlickGrid/wiki/Grid-
                            Options
      --rowHeight ROWHEIGHT
                            see https://github.com/mleibman/SlickGrid/wiki/Grid-
                            Options
      --showHeaderRow SHOWHEADERROW
                            see https://github.com/mleibman/SlickGrid/wiki/Grid-
                            Options
      --forceFitColumns FORCEFITCOLUMNS
                            see https://github.com/mleibman/SlickGrid/wiki/Grid-
                            Options
      --autoHeight AUTOHEIGHT
                            see https://github.com/mleibman/SlickGrid/wiki/Grid-
                            Options
      --enableCellNavigation ENABLECELLNAVIGATION
                            see https://github.com/mleibman/SlickGrid/wiki/Grid-
                            Options
      --remote_slick REMOTE_SLICK
                            use remote link for the javascript library or local
      --precision PRECISION
                            see function qgrid.set_defaults
      --editable EDITABLE   make the output editable
    usage: jsdf [-h] [--defaultColumnWidth DEFAULTCOLUMNWIDTH]
                [--enableColumnReorder ENABLECOLUMNREORDER]
                [--multiColumnSort MULTICOLUMNSORT] [--rowHeight ROWHEIGHT]
                [--showHeaderRow SHOWHEADERROW]
                [--forceFitColumns FORCEFITCOLUMNS] [--autoHeight AUTOHEIGHT]
                [--enableCellNavigation ENABLECELLNAVIGATION]
                [--remote_slick REMOTE_SLICK] [--precision PRECISION]
                [--editable EDITABLE]
                df