Reut Maller Posted May 4, 2020 Share Posted May 4, 2020 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now