Unconfigured Ad

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • AnushaC
    Member
    • Sep 2013
    • 78
    #1

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

    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.
    Tags: None
Previous template Next

Latest Articles

Collapse
  • SEQadmin2
    Nine Things a Sample Prep Scientist Thinks About Before Sequencing
    by SEQadmin2


    I’m not a sequencing expert. I’m a purification scientist who uses NGS to evaluate workflows my group develops. With this perspective, we think about the sample first and the NGS workflow second. The sequencer is an exceptionally honest reporter, but it can only report on what you give it, so whether you get clean, interpretable data from an NGS workflow is largely determined before you begin.

    Here are nine questions we think about, in roughly the order they matter, before...
    06-18-2026, 07:11 AM
  • SEQadmin2
    From Collection to Sequencing: Why Sample Preparation and Preservation Define Sequencing Data
    by SEQadmin2


    Data variability is still an issue in sequencing technologies despite the advances in reproducibility and accuracy of these platforms. But the problem does not originate in the sequencing itself, but in the previous steps, before the sample reaches the sequencer.

    The first step is collection, followed by preservation and sample preparation for analysis. Most scientists overlook those steps, but not being careful might just be skewing the experiment’s results.
    ...
    06-02-2026, 10:05 AM
View All

ad_right_rmr

Collapse

News

Collapse
Topics Statistics Last Post
Large-Scale Protein Screen Uncovers Hidden Regulators of Alternative Polyadenylation by SEQadmin2
Started by SEQadmin2, Yesterday, 11:10 AM
0 responses
8 views
0 reactions
 Last Post SEQadmin2
by SEQadmin2
Yesterday, 11:10 AM  
Whole-Genome Sequencing Traces Faroe Islands Ancestry to a North Atlantic Founder Population by SEQadmin2
Started by SEQadmin2, 06-17-2026, 06:09 AM
0 responses
43 views
0 reactions
 Last Post SEQadmin2
by SEQadmin2
06-17-2026, 06:09 AM  
Sequencing the Two-Toed Sloth Genome Reveals Jumping Genes Tied to Its Extreme Metabolism by SEQadmin2
Started by SEQadmin2, 06-09-2026, 11:58 AM
0 responses
104 views
0 reactions
 Last Post SEQadmin2
by SEQadmin2
06-09-2026, 11:58 AM  
A New Method Makes Hantavirus Genome Analysis Faster and More Accessible by SEQadmin2
Started by SEQadmin2, 06-05-2026, 10:09 AM
0 responses
125 views
0 reactions
 Last Post SEQadmin2
by SEQadmin2
06-05-2026, 10:09 AM  
View All
Working...