Unconfigured Ad

Collapse
X
Collapse
 
  • Page of 1
  • 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
      Multiomic Liquid Biopsy: What DNA/RNA Panels Reveal That DNA Alone Can’t
      by SEQadmin2



      Tumors contain complex mixtures of cell populations that evolve in response to treatment and host-specific factors. Tissue biopsies provide only static snapshots of a tumor’s state. But what if we could follow that evolution over time using a minimally invasive technique?

      Liquid biopsies can detect tumor-derived material circulating in the bloodstream, providing a way to study treatment response, detect emerging resistance, and discover new biomarkers. Circulating      ...
      Today, 09:55 AM
    • SEQadmin2
      New Genomics Technologies Take Aim at Long-Standing Limits
      by SEQadmin2


      Researchers using sequencing and genomics tools often have to make trade-offs. They can choose between speed or scale, short reads or long-range information, or targeted panels or a view of the whole transcriptome. New technologies that have been released this year are built to address those tough choices.

      We asked six companies the same four questions to learn about their latest products. The new technologies bring a lot to the table, including rethinking sequencing      ...
      09-28-2026, 10:25 AM
    View All

    ad_right_rmr

    Collapse

    News

    Collapse
    Topics Statistics Last Post
    Study Finds Chromatin Motion Holds Steady Until Cells Face Stress by SEQadmin2
    Started by SEQadmin2, Today, 05:39 AM
    0 responses
    10 views
    0 reactions
    		 Last Post SEQadmin2
    by SEQadmin2
    Today, 05:39 AM  
    Larger Datasets Reveal Additional Switches That Control Gene Expression by SEQadmin2
    Started by SEQadmin2, Yesterday, 09:56 AM
    0 responses
    12 views
    0 reactions
    		 Last Post SEQadmin2
    by SEQadmin2
    Yesterday, 09:56 AM  
    Computational Tool Captures How Chromatin Folds at Scale by SEQadmin2
    Started by SEQadmin2, 10-09-2026, 11:14 AM
    0 responses
    25 views
    0 reactions
    		 Last Post SEQadmin2
    by SEQadmin2
    10-09-2026, 11:14 AM  
    Spatial Transcriptomics and Metabolite Mapping Combined on a Single Tissue Slide by SEQadmin2
    Started by SEQadmin2, 09-29-2026, 09:51 AM
    0 responses
    77 views
    0 reactions
    		 Last Post SEQadmin2
    by SEQadmin2
    09-29-2026, 09:51 AM  
    View All
    Working...