Python Forum
Thread Rating:
  • 2 Vote(s) - 2.5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
DataFrame Calculation
#1
It is easy to add a new column to store the results of calculation on the same row as below.
I need to add a column df["d"] that will contain the results of calculation with current row i and next row i+1
something like: df["d"][i] = (df["b"][i] - df["a"][i+1]) / df["a"][i+ 1]
I can use "for loop" to do that but wondering if another better way. thanks

import pandas as pd

df = pd.DataFrame({"a": [11,12,13,14,15,16],
                   "b": [15,20,30,20,30,50]})
df["c"] = (df["b"] - df["a"]) / df["a"]
print(df)
Reply


Messages In This Thread
DataFrame Calculation - by ian - Aug-21-2017, 02:43 AM
RE: DataFrame Calculation - by SamSoftwareLtd - Nov-21-2018, 05:38 PM
RE: DataFrame Calculation - by SamSoftwareLtd - Nov-22-2018, 12:10 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  looping calculation in dataframe duncipe 2 2,037 Mar-21-2020, 10:18 AM
Last Post: duncipe

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020