Skip to main content

How to find jumps in values in dataframe using pandas

Input :

B      0   15000.000000  698.617126  -0.745298

B      1   17000.000000  647.001708  -0.269421

B      2   18000.000000  649.572265  -0.097540

B      4   19000.000000  665.282775   0.008724

B      5   20000.000000  690.836975  -0.011101

I have a data frame with 5 columns, in the 1st column, there is a jump in the 3rd row, instead of the value 3 it is 4 and in column 2 there is a jump in the 1st row, instead of 16000 it is 17000. How to mark these values. Also, how find this jump with a specified value in each column?

Expected output:

considering 1st column. display the index number when the difference from 1 row to the next row is not 1. example: in the 1st column above, the difference of the value of 1st and 2nd row is 2 instead of 1.

output:

0     nan     nan       nan        nan

1     1      2000      -51.61      0.47628

2     2      1000       2.57       0.171881


source https://stackoverflow.com/questions/73430470/how-to-find-jumps-in-values-in-dataframe-using-pandas

Comments