title: DataFrame how to perform calculations (please see the attached photo)
body: <p><a href="https://i.stack.imgur.com/FH65A.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FH65A.png" alt="index calculation"></a></p>
  
  <p>As you can see the calculations under column D follow a specific pattern 
  i.e. prior value * (1+the rate%/365)</p>
  
  <p>so in cell D2 you have 100*(1+8%/365)
  D3 will be 100.021918*(1+8.06%/365)</p>
  
  <p>is there an easy way to do that in python as I don't want to use excel for that purpose....and I have daily data going back 30 years.</p>