import qgrid
import pandas as pd
df = pd.DataFrame([1,2,3,4])
!{sys.executable} -m pip install qgrid==1.0
!jupyter nbextension enable --py --sys-prefix qgrid
Requirement already satisfied: qgrid==1.0 in /Users/minrk/conda/lib/python3.6/site-packages
Requirement already satisfied: ipywidgets>=7.0.0 in /Users/minrk/conda/lib/python3.6/site-packages (from qgrid==1.0)
Requirement already satisfied: notebook>=4.0.0 in /Users/minrk/conda/lib/python3.6/site-packages (from qgrid==1.0)
Requirement already satisfied: pandas>=0.18.0 in /Users/minrk/conda/lib/python3.6/site-packages (from qgrid==1.0)
Requirement already satisfied: widgetsnbextension~=3.1.0 in /Users/minrk/conda/lib/python3.6/site-packages (from ipywidgets>=7.0.0->qgrid==1.0)
Requirement already satisfied: ipykernel>=4.5.1 in /Users/minrk/conda/lib/python3.6/site-packages (from ipywidgets>=7.0.0->qgrid==1.0)
Requirement already satisfied: nbformat>=4.2.0 in /Users/minrk/conda/lib/python3.6/site-packages (from ipywidgets>=7.0.0->qgrid==1.0)
Requirement already satisfied: traitlets>=4.3.1 in /Users/minrk/dev/ip/traitlets (from ipywidgets>=7.0.0->qgrid==1.0)
Requirement already satisfied: ipython>=4.0.0; python_version >= "3.3" in /Users/minrk/conda/lib/python3.6/site-packages (from ipywidgets>=7.0.0->qgrid==1.0)
Requirement already satisfied: Send2Trash in /Users/minrk/conda/lib/python3.6/site-packages (from notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: ipython-genutils in /Users/minrk/conda/lib/python3.6/site-packages (from notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: jupyter-client>=5.2.0 in /Users/minrk/dev/jpy/client (from notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: jupyter-core>=4.4.0 in /Users/minrk/conda/lib/python3.6/site-packages (from notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: terminado>=0.8.1 in /Users/minrk/conda/lib/python3.6/site-packages (from notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: tornado>=4 in /Users/minrk/conda/lib/python3.6/site-packages (from notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: jinja2 in /Users/minrk/conda/lib/python3.6/site-packages (from notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: nbconvert in /Users/minrk/conda/lib/python3.6/site-packages (from notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: python-dateutil>=2 in /Users/minrk/conda/lib/python3.6/site-packages (from pandas>=0.18.0->qgrid==1.0)
Requirement already satisfied: pytz>=2011k in /Users/minrk/conda/lib/python3.6/site-packages (from pandas>=0.18.0->qgrid==1.0)
Requirement already satisfied: numpy>=1.9.0 in /Users/minrk/conda/lib/python3.6/site-packages (from pandas>=0.18.0->qgrid==1.0)
Requirement already satisfied: jsonschema!=2.5.0,>=2.4 in /Users/minrk/conda/lib/python3.6/site-packages (from nbformat>=4.2.0->ipywidgets>=7.0.0->qgrid==1.0)
Requirement already satisfied: six in /Users/minrk/conda/lib/python3.6/site-packages (from traitlets>=4.3.1->ipywidgets>=7.0.0->qgrid==1.0)
Requirement already satisfied: decorator in /Users/minrk/conda/lib/python3.6/site-packages (from traitlets>=4.3.1->ipywidgets>=7.0.0->qgrid==1.0)
Requirement already satisfied: prompt-toolkit<2.0.0,>=1.0.4 in /Users/minrk/conda/lib/python3.6/site-packages (from ipython>=4.0.0; python_version >= "3.3"->ipywidgets>=7.0.0->qgrid==1.0)
Requirement already satisfied: pexpect; sys_platform != "win32" in /Users/minrk/conda/lib/python3.6/site-packages (from ipython>=4.0.0; python_version >= "3.3"->ipywidgets>=7.0.0->qgrid==1.0)
Requirement already satisfied: pygments in /Users/minrk/conda/lib/python3.6/site-packages (from ipython>=4.0.0; python_version >= "3.3"->ipywidgets>=7.0.0->qgrid==1.0)
Requirement already satisfied: pickleshare in /Users/minrk/conda/lib/python3.6/site-packages (from ipython>=4.0.0; python_version >= "3.3"->ipywidgets>=7.0.0->qgrid==1.0)
Requirement already satisfied: jedi>=0.10 in /Users/minrk/conda/lib/python3.6/site-packages (from ipython>=4.0.0; python_version >= "3.3"->ipywidgets>=7.0.0->qgrid==1.0)
Requirement already satisfied: simplegeneric>0.8 in /Users/minrk/conda/lib/python3.6/site-packages (from ipython>=4.0.0; python_version >= "3.3"->ipywidgets>=7.0.0->qgrid==1.0)
Requirement already satisfied: appnope; sys_platform == "darwin" in /Users/minrk/conda/lib/python3.6/site-packages (from ipython>=4.0.0; python_version >= "3.3"->ipywidgets>=7.0.0->qgrid==1.0)
Requirement already satisfied: setuptools>=18.5 in /Users/minrk/conda/lib/python3.6/site-packages (from ipython>=4.0.0; python_version >= "3.3"->ipywidgets>=7.0.0->qgrid==1.0)
Requirement already satisfied: pyzmq>=13 in /Users/minrk/dev/zmq/pyzmq (from jupyter-client>=5.2.0->notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: ptyprocess; os_name != "nt" in /Users/minrk/conda/lib/python3.6/site-packages (from terminado>=0.8.1->notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: MarkupSafe>=0.23 in /Users/minrk/conda/lib/python3.6/site-packages (from jinja2->notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: testpath in /Users/minrk/conda/lib/python3.6/site-packages (from nbconvert->notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: bleach in /Users/minrk/conda/lib/python3.6/site-packages (from nbconvert->notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: pandocfilters>=1.4.1 in /Users/minrk/conda/lib/python3.6/site-packages (from nbconvert->notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: mistune>=0.7.4 in /Users/minrk/conda/lib/python3.6/site-packages (from nbconvert->notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: entrypoints>=0.2.2 in /Users/minrk/conda/lib/python3.6/site-packages (from nbconvert->notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: wcwidth in /Users/minrk/conda/lib/python3.6/site-packages (from prompt-toolkit<2.0.0,>=1.0.4->ipython>=4.0.0; python_version >= "3.3"->ipywidgets>=7.0.0->qgrid==1.0)
Requirement already satisfied: parso==0.1.1 in /Users/minrk/conda/lib/python3.6/site-packages (from jedi>=0.10->ipython>=4.0.0; python_version >= "3.3"->ipywidgets>=7.0.0->qgrid==1.0)
Requirement already satisfied: py in /Users/minrk/conda/lib/python3.6/site-packages (from pyzmq>=13->jupyter-client>=5.2.0->notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: cffi in /Users/minrk/conda/lib/python3.6/site-packages (from pyzmq>=13->jupyter-client>=5.2.0->notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: html5lib!=1.0b1,!=1.0b2,!=1.0b3,!=1.0b4,!=1.0b5,!=1.0b6,!=1.0b7,!=1.0b8,>=0.99999999pre in /Users/minrk/conda/lib/python3.6/site-packages (from bleach->nbconvert->notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: pycparser in /Users/minrk/conda/lib/python3.6/site-packages (from cffi->pyzmq>=13->jupyter-client>=5.2.0->notebook>=4.0.0->qgrid==1.0)
Requirement already satisfied: webencodings in /Users/minrk/conda/lib/python3.6/site-packages (from html5lib!=1.0b1,!=1.0b2,!=1.0b3,!=1.0b4,!=1.0b5,!=1.0b6,!=1.0b7,!=1.0b8,>=0.99999999pre->bleach->nbconvert->notebook>=4.0.0->qgrid==1.0)
Enabling notebook extension qgrid/extension...
- Validating: OK
from qgrid import QGridWidget
t = np.linspace(0, 10)
y = [np.cumsum(np.random.random(1000) - 0.5) for i in range(3)]
df = pd.DataFrame(np.array(y).T)
df
0 | 1 | 2 | |
---|---|---|---|
0 | 0.333949 | 0.475551 | -0.306645 |
1 | 0.015503 | 0.586132 | -0.349792 |
2 | 0.486536 | 0.960837 | -0.156864 |
3 | 0.878724 | 1.408980 | 0.159328 |
4 | 1.322874 | 1.526520 | 0.260915 |
5 | 1.734925 | 1.072508 | -0.190041 |
6 | 1.874889 | 0.972800 | -0.172778 |
7 | 1.653385 | 1.103378 | 0.256690 |
8 | 1.714677 | 0.760815 | 0.529833 |
9 | 2.107615 | 0.761361 | 0.146749 |
10 | 2.095004 | 0.589975 | 0.020162 |
11 | 1.708214 | 0.682541 | -0.281811 |
12 | 2.078758 | 0.441951 | -0.731385 |
13 | 2.273706 | 0.237521 | -0.486248 |
14 | 2.305114 | -0.081200 | -0.638772 |
15 | 2.171938 | 0.343744 | -0.212291 |
16 | 1.877927 | 0.136157 | 0.239262 |
17 | 2.192460 | 0.140419 | -0.077881 |
18 | 2.421209 | 0.223222 | -0.075812 |
19 | 2.549125 | 0.484310 | -0.399322 |
20 | 2.532122 | 0.685405 | 0.091298 |
21 | 2.961182 | 0.783840 | 0.409883 |
22 | 3.435686 | 1.137183 | 0.225609 |
23 | 3.681976 | 1.446645 | 0.015950 |
24 | 3.298916 | 1.603651 | 0.297169 |
25 | 3.056766 | 1.914212 | 0.735913 |
26 | 3.530409 | 1.619377 | 0.469720 |
27 | 3.400197 | 1.969184 | 0.438327 |
28 | 3.195704 | 2.159822 | 0.636513 |
29 | 2.929998 | 1.677955 | 0.264947 |
... | ... | ... | ... |
970 | 4.378442 | -2.698279 | 8.942705 |
971 | 4.063079 | -2.990265 | 8.876758 |
972 | 4.075945 | -3.299159 | 8.598442 |
973 | 4.314706 | -3.106364 | 8.512634 |
974 | 4.644562 | -3.510818 | 8.119822 |
975 | 4.681597 | -3.738403 | 7.656170 |
976 | 5.031129 | -3.572536 | 7.466963 |
977 | 4.921125 | -3.488925 | 7.045623 |
978 | 5.170727 | -3.683036 | 6.958648 |
979 | 5.211292 | -3.602480 | 6.994424 |
980 | 5.161630 | -4.010141 | 7.219399 |
981 | 5.125531 | -4.299932 | 7.439370 |
982 | 5.048376 | -4.330526 | 7.685285 |
983 | 4.568967 | -4.292447 | 7.509606 |
984 | 4.427899 | -3.929169 | 7.776290 |
985 | 4.029266 | -3.853195 | 8.058451 |
986 | 3.551645 | -4.180580 | 7.777890 |
987 | 3.844049 | -4.482581 | 7.379536 |
988 | 4.130953 | -4.581161 | 7.654446 |
989 | 3.719873 | -4.535555 | 7.596517 |
990 | 4.122977 | -4.536245 | 7.684231 |
991 | 4.387077 | -4.511833 | 8.001052 |
992 | 4.654050 | -4.606983 | 7.820341 |
993 | 4.476456 | -4.183136 | 8.172173 |
994 | 4.857828 | -4.531300 | 8.262196 |
995 | 5.038849 | -4.802517 | 8.257849 |
996 | 4.987918 | -4.561570 | 8.731099 |
997 | 4.762001 | -4.062299 | 8.828838 |
998 | 5.099760 | -4.426994 | 9.255954 |
999 | 4.912254 | -4.422692 | 9.122696 |
1000 rows × 3 columns
w = QGridWidget(df=df)
w
Failed to display Jupyter Widget of type QgridWidget
.
If you're reading this message in the Jupyter Notebook or JupyterLab Notebook, it may mean that the widgets JavaScript is still loading. If this message persists, it likely means that the widgets JavaScript library is either not installed or not enabled. See the Jupyter Widgets Documentation for setup instructions.
If you're reading this message in another frontend (for example, a static rendering on GitHub or NBViewer), it may mean that your frontend doesn't currently support widgets.