Пример #1
0
    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
Пример #2
0
    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)
Пример #3
0
                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')
Пример #4
0
    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
Пример #5
0
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')
Пример #6
0
def load_ipython_extension(ipython):
    sql_load_ipython_extension(ipython)
    ipython.register_magics(MemSeeApp)
    qgrid.nbinstall()
Пример #7
0
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():
Пример #8
0
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
Пример #9
0
__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
Пример #10
0
def load_ipython_extension(ipython):
    sql_load_ipython_extension(ipython)
    ipython.register_magics(MemSeeApp)
    qgrid.nbinstall()