Mdthbs

My Friend James

What exactly is Apple Cider

Is it right to use the ideas of non-winning designers in a design contest?

What is the justification for Dirac's large numbers hypothesis?

How can electricity be positive when electrons are negative?

Infinitely many primes

Fantasy Military Arms and Armor: the Dwarven Grand Armory

SQL Always On COPY ONLY backups - what's the point if I cant restore the AG from these backups?

How to create large inductors (1H) for audio use?

Why did Boris Johnson call for new elections?

Why are some hotels asking you to book through Booking.com instead of matching the price at the front desk?

Are there mathematical concepts that exist in the fourth dimension, but not in the third dimension?

What's in a druid's grove?

Could this estimate of the size and mass of the Chicxulub Impactor be accurate?

Balm of the Summer Court fey energy dice usage limits

What are some countries where you can be imprisoned for reading or owning a Bible?

What is the purpose of the rotating plate in front of the lock?

Why did Tony's Arc Reactor do this?

Why does the seven segment display have decimal point at the right?

Old sci fi book, addictive soft drinks

How can I hint that my character isn't real?

What are the map units that WGS84 uses?

If I have an accident, should I file a claim with my car insurance company?

Euro sign in table with siunitx

command to summarize a cluster of entries in a table

Parsing a text-file table and aggregating informationGet row data for non-matching column valuesawk script to rearrange similar rowsSelect every two rows if they begin with the same nameremove duplicate entries in one column and linearize the values in multiple rows to a single rowReplace each unique value in all columns with a unique identifiercompute sum up each 2 rows and replace them with another value if the sum is less than a specific valueconditional replacement of rows with a numberMerge multiple CSV files with partially matching key columnReplace block of text with sed, awk, perl or vim

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

-1

I have a table that shows how many ASVs(columns) are clustered in one OTU(rows). Each ASV is represented by a value of 1.

#OTUID    ASV_1    ASV_2    ASV_3    ASV_4    ASV_5    ASV_6    ASV_7    ASV_8    ASV_9    ASV_10

OTU1    1    0    0    1    0    0    0    0    0    1

OTU2    0    1    0    0    1    0    0    0    0    0

OTU3    0    0    0    0    0    1    0    1    1    0

I want to summarize the table to the following;

#OTUID    ASVs

OTU1    ASV_1, ASV_4, ASV_10

OTU2    ASV_2, ASV_5

OTU3    ASV_6, ASV_8, ASV_9

kindly help.

linux bash perl

share|improve this question

edited 35 mins ago

alex kiarie

asked 59 mins ago

alex kiariealex kiarie

2755 bronze badges

add a comment | 

-1

I have a table that shows how many ASVs(columns) are clustered in one OTU(rows). Each ASV is represented by a value of 1.

#OTUID    ASV_1    ASV_2    ASV_3    ASV_4    ASV_5    ASV_6    ASV_7    ASV_8    ASV_9    ASV_10

OTU1    1    0    0    1    0    0    0    0    0    1

OTU2    0    1    0    0    1    0    0    0    0    0

OTU3    0    0    0    0    0    1    0    1    1    0

I want to summarize the table to the following;

#OTUID    ASVs

OTU1    ASV_1, ASV_4, ASV_10

OTU2    ASV_2, ASV_5

OTU3    ASV_6, ASV_8, ASV_9

kindly help.

linux bash perl

share|improve this question

edited 35 mins ago

alex kiarie

asked 59 mins ago

alex kiariealex kiarie

2755 bronze badges

add a comment | 

I have a table that shows how many ASVs(columns) are clustered in one OTU(rows). Each ASV is represented by a value of 1.

#OTUID    ASV_1    ASV_2    ASV_3    ASV_4    ASV_5    ASV_6    ASV_7    ASV_8    ASV_9    ASV_10

OTU1    1    0    0    1    0    0    0    0    0    1

OTU2    0    1    0    0    1    0    0    0    0    0

OTU3    0    0    0    0    0    1    0    1    1    0

I want to summarize the table to the following;

#OTUID    ASVs

OTU1    ASV_1, ASV_4, ASV_10

OTU2    ASV_2, ASV_5

OTU3    ASV_6, ASV_8, ASV_9

kindly help.

linux bash perl

share|improve this question

edited 35 mins ago

alex kiarie

asked 59 mins ago

alex kiariealex kiarie

2755 bronze badges

#OTUID    ASV_1    ASV_2    ASV_3    ASV_4    ASV_5    ASV_6    ASV_7    ASV_8    ASV_9    ASV_10

OTU1    1    0    0    1    0    0    0    0    0    1

OTU2    0    1    0    0    1    0    0    0    0    0

OTU3    0    0    0    0    0    1    0    1    1    0

#OTUID    ASVs

OTU1    ASV_1, ASV_4, ASV_10

OTU2    ASV_2, ASV_5

OTU3    ASV_6, ASV_8, ASV_9

share|improve this question

edited 35 mins ago

alex kiarie

asked 59 mins ago

alex kiariealex kiarie

2755 bronze badges

share|improve this question

edited 35 mins ago

alex kiarie

asked 59 mins ago

alex kiariealex kiarie

2755 bronze badges

asked 59 mins ago

alex kiariealex kiarie

2755 bronze badges

asked 59 mins ago

alex kiariealex kiarie

2755 bronze badges