draperjames

"""
DataFrameTable
==============

Quick and Dirty Qt app to view pandas DataFrames.  Includes sorting and
filterting.

Based on qtpandas in pandas sandbox module, by Jev Kuznetsov

Usage:

draperjames

def multiRegExOr(term_list):
    """Returns a singles string of "OR"ed regex terms from a given list.

    Parameters
    ----------
    term_list: list
        List of regular expressions.

    Returns
    -------

draperjames

%env BOKEH_RESOURCES=inline ipython notebook
from bokeh.io import show, output_notebook
from bokeh.plotting import ColumnDataSource, figure
from bokeh.models import HoverTool, Range1d

output_notebook()
fig = figure(tools=[HoverTool(tooltips=[("html", "@html{safe}")])])

fig.quad(left="left", top="top", bottom="bottom", right="right",
         source=ColumnDataSource({"left": [1,3], "bottom": [1,3],

draperjames

# -*- coding: utf-8 -*-
"""
LICENSE: BSD (same as pandas)
example use of pandas with oracle mysql postgresql sqlite
    - updated 9/18/2012 with better column name handling; couple of bug fixes.
    - used ~20 times for various ETL jobs.  Mostly MySQL, but some Oracle. 

    to do:  
            save/restore index (how to check table existence? just do select count(*)?), 
            finish odbc, 

draperjames

import traitlets
from IPython.display import display
from ipywidgets import widgets
from tkinter import Tk, filedialog


class SelectFilesButton(widgets.Button):
    """A file widget that leverages tkinter.filedialog."""

    def __init__(self, *args, **kwargs):

draperjames

from datetime import datetime
from ipywidgets import widgets
from dominate import tags

def timestamp():
    """Return a ipywidget timestamp."""
    ts = tags.h4("{:%I:%M:%S %p %A %B %d %Y}".format(datetime.now()))
    ts_widget = widgets.HTML(ts.render())
    return ts_widget

draperjames

draperjames

draperjames

draperjames