Question: convert one column values into row values based on other row values
0
gravatar for newbiebio
3 months ago by
newbiebio60
newbiebio60 wrote:

I have two columns, one column is the name of wells, the other column is the ct values. ex

well    ct
A    10
A    9
A    NA
A    19

Now I want to put the ct values into one row based on well name. Each column is one ct value, NA is a value too. ex

Well ct
A    10   9    NA   19

I tried to used aggregae in r, but it omits NA and put all the values in a vector into one columns,

R • 260 views
ADD COMMENTlink modified 3 months ago by venu3.3k • written 3 months ago by newbiebio60

This is a programming question not a Bioinformatics one!

ADD REPLYlink written 3 months ago by Deepak Tanwar3.3k

It's a thin line, considering that this issue is clearly a bio-application which OP tries to solve informatically...

ADD REPLYlink written 3 months ago by WouterDeCoster14k
2
gravatar for venu
3 months ago by
venu3.3k
Germany
venu3.3k wrote:

An alternate (to R) quick solution

cat file.txt | datamash -H -s -g 1 collapse 2 > result.txt

result.txt

GroupBy(well)   collapse(ct)
A   10,9,NA,19
B   11,12

P.S: datamash & add | tr ',' '\t' at the end of the command if it is nesessary to convert commas into tabs

ADD COMMENTlink modified 3 months ago • written 3 months ago by venu3.3k
Please log in to add an answer.

Help
Access

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 2.3.0
Traffic: 1000 users visited in the last hour