I have a csv file in which I would like to make some calculation.

My csv looks something like this:

In the background, I add the variable N = 10

And I would like to add a new column to the same csv file with a calculation using the formula

Something like N 1 * Value 1 of its own line N 1 * Value 2 of the previous line

To get something like this:

I tried something like

out = df.groupby(['Time']) out = %N 1 * df['Value1'] %N 1 * df['Value2']

But it doesn't quite work

CodePudding user response：

import pandas as pd

df = pd.DataFrame(
    [['10:00:00', 4, 1], ['10:00:01', 5, 0]],
    columns=['Time', 'Value1', 'Value2']
)

N = 10
df['Value3'] = (N   1) * (df.Value1   df.Value2.shift(1))
print(df)

prints