Shulou(Shulou.com)06/01 Report--

Editor to share with you how Python pandas calculates the growth rate and cumulative growth rate of each line. I hope you will gain something after reading this article. Let's discuss it together.

Read data:

FacebookDf=pd.read_excel (ringing D:\ jupyter\ Untitled Folder\ Facebook 2017 stock data .xlsx', index_col='Date') FacebookDf.tail ()

Calculate the percentage of growth of the current row over the previous line (the growth rate of each row)

# .pct _ change () returns the percentage of change, and the first line returns Nan because there is nothing to compare. Fill in apply (lambda x: format (x,'. 2%')) to convert the decimal point to the percentage FacebookDf ['pct_change'] = FacebookDf [' Close']. Pct_change (1) .fillna (0) .apply (lambda x: format (x,'. 2%')) FacebookDf ['pct_change'] .head ()

Calculate the percentage of growth of the current row over the first row (cumulative percentage)

Close1=FacebookDf.loc ['2017-01-03] # apply (lambda x: (x-Close1) / Close1) calculates the cumulative growth rate # apply (lambda x: format (x,'. 2%') converts the decimal point to a percentage FacebookDf ['sum_pct_change'] = FacebookDf [' Close'] .apply (lambda x: (x-Close1) / Close1) .apply (lambda x: format (x,'.2%') FacebookDf ['sum_pct_change'] .head ()

After reading this article, I believe you have a certain understanding of "how Python pandas calculates the growth rate and cumulative growth rate of each line". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.