title: Correlation between two successive rows in the same dataframe in the same column_python
body: <p>I have a large dataframe with 36 columns, I want to calculate correlation between two successive rows.
  I tried </p>
  
  <p>data.corrwith(data, axis=0, method='pearson', drop=False) </p>
  
  <p>wrong result:</p>
  
  <p>('Amplitude', 0)     1.0
  ('Amplitude', 1)     1.0
  ('Amplitude', 2)     1.0
  ('Amplitude', 3)     1.0
  ('Amplitude', 4)     1.0
  ('Amplitude', 5)     1.0
  ('Amplitude', 6)     1.0
  ('Amplitude', 7)     1.0
  ('Amplitude', 8)     1.0
  ('Amplitude', 9)     1.0
  ('Amplitude', 10)    1.0
  ('Amplitude', 11)    1.0
  ('Amplitude', 12)    1.0
  ....</p>
  
  <p><a href="https://i.stack.imgur.com/eHwci.png" rel="nofollow noreferrer">enter image description here</a></p>
  
  <p>This is a capture of dataset.</p>
  
  <p>Thank you, </p>