Jump to content

How to get delta between rows over multiple colomns


Reut Maller

Recommended Posts

Hello,

I have a column that I want to get the difference (delta) between 2 rows.

firstly I used Insecect and next, but I have more then 1 column that I need to consider this calculation.

This is part of my table:

 

 

 

date

Temp_Oven

chip_SN

Varactor

LO Frequency [GHz]

Frequency Measured

delta

 

 

4/5/2020

25

13

0

10

10.19

-0.01

 

 

4/5/2020

25

13

0

10.2

10.2

-0.01

 

 

4/5/2020

25

13

0

10.2125

10.21

-0.01

 

 

4/5/2020

25

13

0

10.225

10.22

-0.02

 

 

4/5/2020

25

13

0

10.2375

10.24

-0.01

 

 

4/5/2020

25

13

0

10.25

10.25

 

 

 

4/5/2020

25

13

2

10.15

10.15

-0.01

 

 

4/5/2020

25

13

2

10.1625

10.16

-0.01

 

 

4/5/2020

25

13

2

10.175

10.17

-0.02

 

 

4/5/2020

25

13

2

10.1875

10.19

-0.01

 

 

4/5/2020

25

13

2

10.2

10.2

-0.01

 

 

4/5/2020

25

13

2

10.2125

10.21

-0.01

 

 

4/5/2020

25

13

2

10.225

10.22

-0.02

 

 

4/5/2020

25

13

2

10.2375

10.24

-0.01

 

 

4/5/2020

25

13

2

10.25

10.25

 

 

 

 

So, I would liketo get a new column that substract each "Frequency measured" from the next one (see the "delta" column at the table - I did it in excel )

I need to condsider my substraction with these columns (date, Chip_SN,, Temp, Varactor, LO frequency)

Any help will be appreciated!

Reut

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...