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.
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.