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
Post a Comment