Unconfigured Ad

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • shubk
    Junior Member
    • Aug 2018
    • 5

    #1

    How to start a new column after every nth row?

    Hi have a file(comma separated) with 3 columns. I want to start new column after every 4th row
    Input:
    col1,col2,col3
    1,disease1,high
    1,disease2,low
    1,disease3,high
    col1,col2,col3
    2,disease1,low
    2,disease2,low
    2,disease3,high

    Expected output:
    col1,col2,col3,col1,col2,col3
    1,disease1,high,2,disease1,low
    1,disease2,low,2,disease2,low
    1,disease3,high,2,disease3,high
  • finswimmer
    Member
    • Oct 2016
    • 60

    #2
    This should be possible with some unix commands and datamash.

    Code:
    cat input.txt|paste - - - -|datamash transpose --output-delimiter , > output.txt
    This will for lines into one line. Than we use datamash to transpose this new table.

    fin swimmer

    Comment

    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
      ...
      10-14-2026, 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

    ad_right_rmr

    Collapse

    News

    Collapse

    Topics Statistics Last Post
    Started by SEQadmin2, 10-22-2026, 11:13 AM
    0 responses
    26 views
    0 reactions
    Last Post SEQadmin2  
    Started by SEQadmin2, 10-22-2026, 10:48 AM
    0 responses
    20 views
    0 reactions
    Last Post SEQadmin2  
    Started by SEQadmin2, 10-15-2026, 10:52 AM
    0 responses
    36 views
    0 reactions
    Last Post SEQadmin2  
    Started by SEQadmin2, 10-14-2026, 05:39 AM
    0 responses
    43 views
    0 reactions
    Last Post SEQadmin2  
    Working...