pandas.read_sql_query(sql, con, index_col=None, coerce_float=True, params=None, parse_dates=None, chunksize=None) [source] Read SQL query into a DataFrame. Returns a DataFrame corresponding to the result set of the query string. Optionally provide an index_col parameter to use one of the columns as the index, otherwise default integer index will be used. Parameters: sql : string SQL query or SQLAlchemy Selectable (select or text object) to be executed. con : SQLAlchemy connectable(engine

Panel.pop(item) [source] Return item and drop from frame. Raise KeyError if not found.

Index.sort(*args, **kwargs) [source]

DataFrame.iterkv(*args, **kwargs) [source] iteritems alias used to get around 2to3. Deprecated

TimedeltaIndex.has_duplicates

DataFrameGroupBy.bfill(limit=None) [source] Backward fill the values Parameters: limit : integer, optional limit of how many values to fill See also pandas.Series.groupby, pandas.DataFrame.groupby, pandas.Panel.groupby

DatetimeIndex.is_leap_year Logical indicating if the date belongs to a leap year

DatetimeIndex.is_monotonic_decreasing return if the index is monotonic decreasing (only equal or decreasing) values.

MultiIndex.labels

DatetimeIndex.to_perioddelta(freq) [source] Calcuates TimedeltaIndex of difference between index values and index converted to PeriodIndex at specified freq. Used for vectorized offsets New in version 0.17.0. Parameters: freq : Period frequency Returns: y : TimedeltaIndex