Latest
Open
RNA-Seq
ChIP-Seq
SNP
Assembly
Tutorials
Tools
Jobs
Forum
Planet
All »
Home
Log In
Question: How to add column to table with awk
0
gravatar for linelr
6 months ago by
linelr • 10
Norwegian University of Life Sciences
linelr • 10 wrote:

Hi Biostars community

I have a file with positions of methylated cytosines , but I want to add a new column to this file with the position+1 value (as if it was a dinucleotide).

I have used awk to print our the new value, but I need to add this new column to my file.

My file looks like this

NC_001960.1 1067
NC_001960.1 1068
NC_001960.1 1069
NC_001960.1 1133

And I do this with awk: awk -v s=1 '{print $(NF)+s}' test Which gives me this output:

1068

1069

1070

1134

And I´d like to add this as the third column in the above file

NC_001960.1 1067 1068
NC_001960.1 1068 1069
NC_001960.1 1069 1070
NC_001960.1 1133 1134

Is it possible to do this with awk or with some other method?

bash shell unix awk bed-files • 368 views
ADD COMMENT • link •
modified 6 months ago by Shalu Jhanwar • 480 • written 6 months ago by linelr • 10
3
gravatar for rpolicastro
6 months ago by
rpolicastro ♦ 3.2k
rpolicastro ♦ 3.2k wrote:

You can just slightly modify your awk command.

awk -v s=1 '{print $0,$(NF)+s}' test

NC_001960.1 1067 1068
NC_001960.1 1068 1069
NC_001960.1 1069 1070
NC_001960.1 1133 1134
ADD COMMENT • link modified 6 months ago • written 6 months ago by rpolicastro ♦ 3.2k

Allright, that was so easy I´m almost embarrassed :) thanks a bunch!

ADD REPLY • link written 6 months ago by linelr • 10
1

If an answer was helpful, you should upvote it; if the answer resolved your question, you should mark it as accepted. You can accept more than one if they work.
Upvote|Bookmark|Accept

ADD REPLY • link written 6 months ago by GenoMax ♦ 94k
2
gravatar for Shalu Jhanwar
6 months ago by
Shalu Jhanwar • 480
Switzerland
Shalu Jhanwar • 480 wrote:

Yes, it's possible to append a column in the using the code below:

awk -v s=1 '{print $0,$(NF)+s}' test

Where test file is

NC_001960.1 1067

NC_001960.1 1068

NC_001960.1 1069

NC_001960.1 1133

The output of the code is:

NC_001960.1 1067 1068

NC_001960.1 1068 1069

NC_001960.1 1069 1070

NC_001960.1 1133 1134
ADD COMMENT • link written 6 months ago by Shalu Jhanwar • 480

thank you for taking time answering me!

ADD REPLY • link written 6 months ago by linelr • 10
Please log in to add an answer.

Similar posts • Search »

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