In [44]: df['gdp'] = df['gdp'].shift(-1)In [45]: dfOut[45]: y gdp cap0 1 3 51 2 7 92 8 4 23 3 7 74 6 NaN 7In [46]: df[:-1] Out[46]: y gdp cap0 1 3 51 2 7 92 8 4 23 3 7 7

In [44]: df['gdp'] = df['gdp'].shift(-1)In [45]: dfOut[45]: y gdp cap0 1 3 51 2 7 92 8 4 23 3 7 74 6 NaN 7In [46]: df[:-1] Out[46]: y gdp cap0 1 3 51 2 7 92 8 4 23 3 7 7