描述时间序列 pandas 中的间隙

我正在尝试编写一个函数，该函数采用连续的时间序列并返回一个数据结构，该数据结构描述数据中任何缺失的间隙（例如带有“开始”和“结束”列的 DF）。对于时间序列来说，这似乎是一个相当常见的问题，但是尽管使用了 groupby、diff 等，并进行了探索，但我还没有能够想出比下面更好的方法。

对我来说，优先考虑的是使用矢量化操作来保持效率。必须有一个使用矢量化操作的更明显的解决方案——不是吗？感谢各位的帮助。

import pandas as pd


def get_gaps(series):
    """
    @param series: a continuous time series of data with the index's freq set
    @return: a series where the index is the start of gaps, and the values are
         the ends
    """
    missing = series.isnull()
    different_from_last = missing.diff()

    # any row not missing while the last was is a gap end        
    gap_ends = series[~missing & different_from_last].index

    # count the start as different from the last
    different_from_last[0] = True

    # any row missing while the last wasn't is a gap start
    gap_starts = series[missing & different_from_last].index        

    # check and remedy if series ends with missing data
    if len(gap_starts) > len(gap_ends):
         gap_ends = gap_ends.append(series.index[-1:] + series.index.freq)

    return pd.Series(index=gap_starts, data=gap_ends)

根据记录，Pandas==0.13.1，Numpy==1.8.1，Python 2.7

这个问题可以转化为查找列表中的连续数字。找到该系列中所有为空的索引，如果（3,4,5,6）的运行都为空，则只需提取开始和结束（3,6）

import numpy as np
import pandas as pd
from operator import itemgetter
from itertools import groupby


# create an example 
data = [2, 3, 4, 5, 12, 13, 14, 15, 16, 17]
s = pd.series( data, index=data)
s = s.reindex(xrange(18))
print find_gap(s)  


def find_gap(s): 
    """ just treat it as a list
    """ 
    nullindex = np.where( s.isnull())[0]
    ranges = []
    for k, g in groupby(enumerate(nullindex), lambda (i,x):i-x):
        group = map(itemgetter(1), g)
        ranges.append((group[0], group[-1]))
    startgap, endgap = zip(* ranges) 
    return pd.series( endgap, index= startgap )

参考 ：识别列表中的连续数字组 https://stackoverflow.com/questions/2154249/identify-groups-of-continuous-numbers-in-a-list