我必須在我的計算機(jī)上手動插入一些信息,因此我必須檢查所有數(shù)據(jù)是否輸入正確。我想要的輸出應(yīng)該是這樣的:奇數(shù)表示一個間隔的開始,偶數(shù)表示結(jié)束(仍然包括在內(nèi))。2015-03-02 15:00:45,12015-03-02 15:05:00,182015-03-02 17:00:45,192015-03-02 17:04:30,342015-03-02 17:44:15,332015-03-02 17:46:15,412015-03-17 15:00:45,12015-03-17 15:05:00,182015-03-17 17:00:45,192015-03-17 17:04:30,342015-03-17 17:44:15,332015-03-17 17:46:15,41使用此方法,我們可以查看數(shù)據(jù)事務(wù)和重新鍵入是否有效。我到這里的嘗試都不起作用,因為它們沒有正確地設(shè)置所有斷點。mintime = pd.to_datetime(tiere.loc[(tiere.timestamp.shift(-1)-tiere.timestamp)>"00:01:00","timestamp"].values[0:],format="%Y-%m-%d %H:%M:%S").sort_values()#add to time max and get unique timestamps and sort them works only if tiere resample is NOT ON!!!maxtime = pd.to_datetime(tiere.loc[(tiere.timestamp-tiere.timestamp.shift(1))>"00:01:00","timestamp"].values[0:],format="%Y-%m-%d %H:%M:%S").sort_values()#add to time min and get unique timestamps and sort them. works only if tiere resample is NOT ON!!!min2 = (pd.to_datetime(tiere.loc[(tiere.timestamp.shift(1)-tiere.timestamp)>"00:01:00","timestamp"].values[0:],format="%Y-%m-%d %H:%M:%S").sort_values())#add to time max and get unique timestamps and sort them works only if tiere resample is NOT ON!!!max2 = (pd.to_datetime(tiere.loc[(tiere.timestamp-tiere.timestamp.shift(-1))>"00:01:00","timestamp"].values[0:],format="%Y-%m-%d %H:%M:%S").sort_values())breakpoints = mintime.union(mintimestamp_tiere).union(min2).union(maxtime).union(maxtimestamp_tiere).union(forgottentimedates).union(max2).delete(7)
添加回答
舉報
0/150
提交
取消