Pandas Dataframe For Close Matching Rows Based On A Column Value Range

[AnushaC]

Hi All,

I have a CSV file which I read as pandas data frame.


Unnamed: 0 X.1 X mz mzmin mzmax rt rtmin \
1 2 643 643 100.111244 100.109215 100.11216 228.969 213.998

rtmax into ... sample isotopes \
1 236.428 2855.018571 ... 1 NaN

adduct pcgroup Iso1L Iso1U Iso2L Iso2U \
1 NaN 129 101.113373 101.115714 102.116673 102.119014

Iso1LR Iso2LR
1 101.113373035603-101.115714425603 102.116673035603-102.119014425603


Like This

I want now to select the matching rows based on column value Iso1LR & mz. If a close matching row/record is anywhere in the data frame is found based on the range in the Iso1LR is found somewhere in the data frame, I want to take all matching records/rows as a list and take one record with maximum mz value from that list.

Essentially in this file, I want to select all the matching records in the range 101.113373035603-101.115714425603 and so on to check entire CSV file.

Thanks in advance for the help.