JupyterLab support
## Uncomment to install qgrid w/ JupyterLab:
#! jupyter labextension install @jupyter-widgets/jupyterlab-manager
#! jupyter labextension install qgrid
import pandas as pd
import pandas_datareader as pdr
import holoviews as hv
hv.extension('bokeh')
import datetime
start = datetime.date(2008, 1, 1)
end = datetime.date(2018, 1, 1)
datagdp = pdr.data.DataReader(['CPIAUCSL','GDP'], 'fred', start, end)
datagdp
CPIAUCSL | GDP | |
---|---|---|
DATE | ||
2008-01-01 | 212.174 | 14668.445 |
2008-02-01 | 212.687 | NaN |
2008-03-01 | 213.448 | NaN |
2008-04-01 | 213.942 | 14812.974 |
2008-05-01 | 215.208 | NaN |
2008-06-01 | 217.463 | NaN |
2008-07-01 | 219.016 | 14842.983 |
2008-08-01 | 218.690 | NaN |
2008-09-01 | 218.877 | NaN |
2008-10-01 | 216.995 | 14549.949 |
2008-11-01 | 213.153 | NaN |
2008-12-01 | 211.398 | NaN |
2009-01-01 | 211.933 | 14383.885 |
2009-02-01 | 212.705 | NaN |
2009-03-01 | 212.495 | NaN |
2009-04-01 | 212.709 | 14340.417 |
2009-05-01 | 213.022 | NaN |
2009-06-01 | 214.790 | NaN |
2009-07-01 | 214.726 | 14384.145 |
2009-08-01 | 215.445 | NaN |
2009-09-01 | 215.861 | NaN |
2009-10-01 | 216.509 | 14566.511 |
2009-11-01 | 217.234 | NaN |
2009-12-01 | 217.347 | NaN |
2010-01-01 | 217.488 | 14681.063 |
2010-02-01 | 217.281 | NaN |
2010-03-01 | 217.353 | NaN |
2010-04-01 | 217.403 | 14888.600 |
2010-05-01 | 217.290 | NaN |
2010-06-01 | 217.199 | NaN |
... | ... | ... |
2015-08-01 | 237.989 | NaN |
2015-09-01 | 237.467 | NaN |
2015-10-01 | 237.764 | 18287.226 |
2015-11-01 | 238.072 | NaN |
2015-12-01 | 237.827 | NaN |
2016-01-01 | 237.990 | 18325.187 |
2016-02-01 | 237.532 | NaN |
2016-03-01 | 238.022 | NaN |
2016-04-01 | 238.843 | 18538.039 |
2016-05-01 | 239.439 | NaN |
2016-06-01 | 240.074 | NaN |
2016-07-01 | 240.058 | 18729.130 |
2016-08-01 | 240.569 | NaN |
2016-09-01 | 241.017 | NaN |
2016-10-01 | 241.667 | 18905.545 |
2016-11-01 | 242.081 | NaN |
2016-12-01 | 242.784 | NaN |
2017-01-01 | 244.028 | 19057.705 |
2017-02-01 | 244.102 | NaN |
2017-03-01 | 243.717 | NaN |
2017-04-01 | 244.087 | 19250.009 |
2017-05-01 | 243.911 | NaN |
2017-06-01 | 244.032 | NaN |
2017-07-01 | 244.236 | 19500.602 |
2017-08-01 | 245.262 | NaN |
2017-09-01 | 246.392 | NaN |
2017-10-01 | 246.583 | 19754.102 |
2017-11-01 | 247.411 | NaN |
2017-12-01 | 247.910 | NaN |
2018-01-01 | 249.245 | 19956.811 |
121 rows × 2 columns
import qgrid
grid = qgrid.show_grid(datagdp)
grid
QgridWidget(grid_options={'fullWidthRows': True, 'syncColumnCellResize': True, 'forceFitColumns': True, 'defau…
# Holoviews
datagdp.reset_index()
DATE | CPIAUCSL | GDP | |
---|---|---|---|
0 | 2008-01-01 | 212.174 | 14668.445 |
1 | 2008-02-01 | 212.687 | NaN |
2 | 2008-03-01 | 213.448 | NaN |
3 | 2008-04-01 | 213.942 | 14812.974 |
4 | 2008-05-01 | 215.208 | NaN |
5 | 2008-06-01 | 217.463 | NaN |
6 | 2008-07-01 | 219.016 | 14842.983 |
7 | 2008-08-01 | 218.690 | NaN |
8 | 2008-09-01 | 218.877 | NaN |
9 | 2008-10-01 | 216.995 | 14549.949 |
10 | 2008-11-01 | 213.153 | NaN |
11 | 2008-12-01 | 211.398 | NaN |
12 | 2009-01-01 | 211.933 | 14383.885 |
13 | 2009-02-01 | 212.705 | NaN |
14 | 2009-03-01 | 212.495 | NaN |
15 | 2009-04-01 | 212.709 | 14340.417 |
16 | 2009-05-01 | 213.022 | NaN |
17 | 2009-06-01 | 214.790 | NaN |
18 | 2009-07-01 | 214.726 | 14384.145 |
19 | 2009-08-01 | 215.445 | NaN |
20 | 2009-09-01 | 215.861 | NaN |
21 | 2009-10-01 | 216.509 | 14566.511 |
22 | 2009-11-01 | 217.234 | NaN |
23 | 2009-12-01 | 217.347 | NaN |
24 | 2010-01-01 | 217.488 | 14681.063 |
25 | 2010-02-01 | 217.281 | NaN |
26 | 2010-03-01 | 217.353 | NaN |
27 | 2010-04-01 | 217.403 | 14888.600 |
28 | 2010-05-01 | 217.290 | NaN |
29 | 2010-06-01 | 217.199 | NaN |
... | ... | ... | ... |
91 | 2015-08-01 | 237.989 | NaN |
92 | 2015-09-01 | 237.467 | NaN |
93 | 2015-10-01 | 237.764 | 18287.226 |
94 | 2015-11-01 | 238.072 | NaN |
95 | 2015-12-01 | 237.827 | NaN |
96 | 2016-01-01 | 237.990 | 18325.187 |
97 | 2016-02-01 | 237.532 | NaN |
98 | 2016-03-01 | 238.022 | NaN |
99 | 2016-04-01 | 238.843 | 18538.039 |
100 | 2016-05-01 | 239.439 | NaN |
101 | 2016-06-01 | 240.074 | NaN |
102 | 2016-07-01 | 240.058 | 18729.130 |
103 | 2016-08-01 | 240.569 | NaN |
104 | 2016-09-01 | 241.017 | NaN |
105 | 2016-10-01 | 241.667 | 18905.545 |
106 | 2016-11-01 | 242.081 | NaN |
107 | 2016-12-01 | 242.784 | NaN |
108 | 2017-01-01 | 244.028 | 19057.705 |
109 | 2017-02-01 | 244.102 | NaN |
110 | 2017-03-01 | 243.717 | NaN |
111 | 2017-04-01 | 244.087 | 19250.009 |
112 | 2017-05-01 | 243.911 | NaN |
113 | 2017-06-01 | 244.032 | NaN |
114 | 2017-07-01 | 244.236 | 19500.602 |
115 | 2017-08-01 | 245.262 | NaN |
116 | 2017-09-01 | 246.392 | NaN |
117 | 2017-10-01 | 246.583 | 19754.102 |
118 | 2017-11-01 | 247.411 | NaN |
119 | 2017-12-01 | 247.910 | NaN |
120 | 2018-01-01 | 249.245 | 19956.811 |
121 rows × 3 columns
#hv.Table?
tbl = hv.Table(datagdp.reset_index())
tbl
hv.TriSurface(tbl)
:TriSurface [DATE,CPIAUCSL,GDP]