python - 获取带有条件的数据框的下一行

Question

我想通过设置它满足的条件来从数据框中提取下一行值。

我得到了这个数据框:
在:
df = pd.DataFrame.from_csv(file_path)
df['股票名称'] = stock_symbol
打印(df.head())
df = df.reset_index()
输出:

Date   Open    High      Low     ...      Adj Close   Volume  Stock Name                                     ...<br/>
1996-12-12  1.81250  1.8125  1.68750     ...       0.743409  1984400        CALM
1996-12-13  1.71875  1.8125  1.65625     ...       0.777510   996800        CALM
1996-12-16  1.81250  1.8125  1.71875     ...       0.750229   122000        CALM
1996-12-17  1.75000  1.8125  1.75000     ...       0.774094   239200        CALM
1996-12-18  1.81250  1.8125  1.75000     ...       0.791151   216400        CALM

我现在得到了这个代码:
在:
data_from_yahoo=df.loc[df['日期'] == ddate]
data_from_yahoo_next_day=df.loc[df['日期'] == ddate].shift(1)
打印(来自雅虎的数据)
打印(data_from_yahoo_next_day)
输出:

Date       Open  High     ...      Adj Close  Volume  Stock Name
5610 2019-04-01  46.700001  47.0     ...      42.987827  846900        CALM
Date  Open  High  Low  Close  Adj Close  Volume Stock Name
5610  NaT   NaN   NaN  NaN    NaN        NaN     NaN        NaN

现在我想获取“data_from_yahoo”行之后的行，在本例中为第 5611 行。我认为问题出在 data_from_yahoo_next_day=df.loc[df['Date'] == ddate].shift(1) 中。

Answer 1

我相信你需要:

data_from_yahoo_next_day = df[df['Date'].shift(1) == ddate]