def jsdf(self, line): """ defines ``%jsdf`` which displays a pandas dataframe into a notebook using qgrid (javascript) .. nbref:: :title: jsdf The magic command ``%jsdf`` displays a dataframe using `qgrid <https://qgrid.readthedocs.io/en/latest/>`_ module. The code is the following:: import qgrid if firt_call: qgrid.nbinstall(overwrite=False) qgrid.set_defaults(remote_js=<remote_slick>, precision=<precision>) self.first_jsdf_call = False df = args.df grid_options = dict(defaultColumnWidth=<defaultColumnWidth>, enableColumnReorder=<enableColumnReorder>, multiColumnSort=<multiColumnSort>, rowHeight=<rowHeight>, showHeaderRow=<showHeaderRow>, forceFitColumns=<forceFitColumns>, autoHeight=<autoHeight>, enableCellNavigation=<enableCellNavigation>) qgrid.show_grid(df, grid_options=grid_options) """ parser = self.get_parser(MagicNotebook.jsdf_parser, "jsdf") args = self.get_args(line, parser) if not hasattr(self, "first_jsdf_call") or self.first_jsdf_call: qgrid.nbinstall(overwrite=False) qgrid.set_defaults(remote_js=args.remote_slick, precision=args.precision) self.first_jsdf_call = False if args is not None: df = args.df grid_options = dict(defaultColumnWidth=args.defaultColumnWidth, enableColumnReorder=args.enableColumnReorder, multiColumnSort=args.multiColumnSort, rowHeight=args.rowHeight, showHeaderRow=args.showHeaderRow, forceFitColumns=args.forceFitColumns, autoHeight=args.autoHeight, enableCellNavigation=args.enableCellNavigation, editable=args.editable) res = qgrid.show_grid(df, grid_options=grid_options) return "" if res is None else res
def jsdf(self, line): """ defines ``%jsdf`` which displays a pandas dataframe into a notebook using qgrid (javascript) .. nbref:: :title: jsdf The magic command ``%jsdf`` displays a dataframe using `qgrid <https://github.com/quantopian/qgrid>`_ module. The code is the following:: import qgrid if firt_call: qgrid.nbinstall(overwrite=False) qgrid.set_defaults(remote_js=<remote_slick>, precision=<precision>) self.first_jsdf_call = False df = args.df grid_options = dict(defaultColumnWidth=<defaultColumnWidth>, enableColumnReorder=<enableColumnReorder>, multiColumnSort=<multiColumnSort>, rowHeight=<rowHeight>, showHeaderRow=<showHeaderRow>, forceFitColumns=<forceFitColumns>, autoHeight=<autoHeight>, enableCellNavigation=<enableCellNavigation>) qgrid.show_grid(df, grid_options=grid_options) """ parser = self.get_parser(MagicNotebook.jsdf_parser, "jsdf") args = self.get_args(line, parser) if not hasattr(self, "first_jsdf_call") or self.first_jsdf_call: qgrid.nbinstall(overwrite=False) qgrid.set_defaults(remote_js=args.remote_slick, precision=args.precision) self.first_jsdf_call = False if args is not None: df = args.df grid_options = dict(defaultColumnWidth=args.defaultColumnWidth, enableColumnReorder=args.enableColumnReorder, multiColumnSort=args.multiColumnSort, rowHeight=args.rowHeight, showHeaderRow=args.showHeaderRow, forceFitColumns=args.forceFitColumns, autoHeight=args.autoHeight, enableCellNavigation=args.enableCellNavigation, editable=args.editable) return qgrid.show_grid(df, grid_options=grid_options)
label=year, ) plt.xlabel("Total Hours Worked") plt.ylabel("Total Amount Produced") plt.legend() # ## Notebook extensions # # Check out http://nbviewer.ipython.org/github/quantopian/qgrid/blob/master/qgrid_demo.ipynb for more (including demo) # # In[ ]: import qgrid # Best practices is to put imports at the top of the Notebook. qgrid.nbinstall(overwrite=True) # In[ ]: qgrid.show_grid(dframe[['MSHA_ID', 'Year', 'Mine_Name', 'Mine_State', 'Mine_County']], remote_js=True) # ## SQL queries # # An updated implementation SQL magic command from Christian Perez at SVDS https://github.com/cfperez/ipython-sql # In[ ]: get_ipython().magic(u'load_ext sql') get_ipython().magic(u'reload_ext sql')
import ipywidgets as widgets except ImportError: from IPython.html import widgets try: import traitlets except ImportError: from IPython.utils import traitlets from . import ( retrieve, LcmsRun, to_dataframe, database, get_chromatogram, get_spectrogram, get_info ) from .object_helpers import format_timestamp try: import qgrid qgrid.nbinstall(overwrite=True) qgrid.set_grid_option('forceFitColumns', False) qgrid.set_grid_option('defaultColumnWidth', 120) except Exception: print('Could not import QGrid') def create_qgrid(objects, options=None): """Create a qgrid from a list of metatlas objects. """ dataframe = to_dataframe(objects) if options: defaults = qgrid.grid.defaults.grid_options options = defaults.update(options) else: options = qgrid.grid.defaults.grid_options
Objects for displaying the results in the IPython notebook. """ __author__ = 'Dan Gunter <*****@*****.**>' __date__ = '8/1/15' # Stdlib import logging # Third-party from IPython.display import display import matplotlib.pyplot as plt import pandas as pd # Qgrid table display try: import qgrid qgrid.nbinstall() except ImportError: qgrid = None from jinja2 import Template # Seaborn graphing try: import seaborn as sns sns.set_style("whitegrid") except ImportError: sns = None # Local from doekbase.data_api.util import get_logger, log_start, log_end _log = get_logger('doekbase.data_api.display')
def load_ipython_extension(ipython): sql_load_ipython_extension(ipython) ipython.register_magics(MemSeeApp) qgrid.nbinstall()
import sys sys.path.insert( 0, '/global/project/projectdirs/metatlas/anaconda/lib/python2.7/site-packages' ) #sys.path.append('/project/projectdirs/metatlas/projects/ms_monitor_tools') import metatlas_get_data_helper_fun as ma_data from metatlas import metatlas_objects as metob from metatlas import h5_query as h5q from metatlas import gui as mgui import numpy as np import os from IPython.display import display try: import ipywidgets as widgets except ImportError: from IPython.html import widgets try: import qgrid qgrid.nbinstall(overwrite=True) qgrid.set_grid_option('defaultColumnWidth', 200) except Exception: print('Could not import QGrid') from datetime import datetime import pandas as pd import json import gspread from oauth2client.client import SignedJwtAssertionCredentials def get_rt_mz_tolerance_from_user():
import sys sys.path.insert(0,'/global/project/projectdirs/metatlas/anaconda/lib/python2.7/site-packages' ) #sys.path.append('/project/projectdirs/metatlas/projects/ms_monitor_tools') import metatlas_get_data_helper_fun as ma_data from metatlas import metatlas_objects as metob from metatlas import h5_query as h5q from metatlas import gui as mgui import numpy as np import os from IPython.display import display try: import ipywidgets as widgets except ImportError: from IPython.html import widgets try: import qgrid qgrid.nbinstall(overwrite=True) qgrid.set_grid_option('defaultColumnWidth', 200) except Exception: print('Could not import QGrid') from datetime import datetime import pandas as pd import json import gspread from oauth2client.client import SignedJwtAssertionCredentials
__author__ = "Dan Gunter <*****@*****.**>" __date__ = "8/1/15" # Stdlib import logging # Third-party from IPython.display import display import matplotlib.pyplot as plt import pandas as pd # Qgrid table display try: import qgrid qgrid.nbinstall() except ImportError: qgrid = None from jinja2 import Template # Seaborn graphing try: import seaborn as sns sns.set_style("whitegrid") except ImportError: sns = None # Local from doekbase.data_api.util import get_logger, log_start, log_end