
        
        
            
                
                
                    df = pd.DataFrame({"A":["a","b","c","d"],"B":["e","f","g","h"],"C":["i","j","k","l"]}, index=[6,7,8,9])
df
                
            
               A  B  C
6  a  e  i
7  b  f  j
8  c  g  k
9  d  h  l

Basic usage

To shift down by 2 rows:


        
        
            
                
                
                    df.slice_shift(2)
                
            
               A  B  C
8  a  e  i
9  b  f  j

Notice how only the values are shifted down, while the index is left as is. Since indexes 6 and 7 no longer have valid values, those rows are stripped away.

To contrast this with the shift(~) method:


        
        
            
                
                
                    df.shift(2)
                
            
               A    B    C
6  NaN  NaN  NaN
7  NaN  NaN  NaN
8  a    e    i
9  b    f    j

The takeaway here is that, instead of throwing away indexes 6 and 7, shift(~) simply fill their values with NaN.

Shifting upwards

To shift up by 2 rows:


        
        
            
                
                
                    df.slice_shift(-2)
                
            
               A  B  C
0  c  g  k
1  d  h  l

Mutating behaviour

Consider the same DataFrame as above:


        
        
            
                
                
                    df = pd.DataFrame({"A":["a","b","c","d"],"B":["e","f","g","h"],"C":["i","j","k","l"]}, index=[6,7,8,9])
df
                
            
               A  B  C
6  a  e  i
7  b  f  j
8  c  g  k
9  d  h  l

Performing the shift and storing the returned DataFrame in x:


        
        
            
                
                
                    x = df.slice_shift(2)
x
                
            
               A  B  C
8  a  e  i
9  b  f  j

If we modify x, then the original df is mutated as well:


        
        
            
                
                
                    x.iloc[0,0] = "Z"
df
                
            
               A  B  C
6  Z  e  i
7  b  f  j
8  c  g  k
9  d  h  l