Combine columns with the same header in one file Post: 303044494

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

combine the values from the first two columns within a file

Hello everybody, I have a text file containing 10,000 rows and 5000 columns. The values are separated by a tab. Ex. file_ex.ped 1 mike 0 0 2 1 A A G G C T A G 1 jack 0 0 2 2 T A G T C A A C 1 Mary 0 0 1 2 A T G C A T G C ... I would like a out put file 1 mike 0 0 2 1 AA GG CT AG 1...

2. Shell Programming and Scripting

How to combine 2 files into 1 file with 2 columns

Hi Guys, I want to combine 2 files and and put together in 1 file and make two columns out it. See below desired output. Any help will be much appreciated. inputfile1.txt 12345 67890 24580 inputfile2.txt AAAAA BBBBB CCCCC

3. UNIX for Dummies Questions & Answers

How to combine 2 files with 6 columns?

This may seem obvious but I am having problems doing this as columns get converted to rows when i try to write a script. I have 2 files text1.txt and text2.txt each of which have 6 columns of numbers separated by a space. I need to combine the 2 files so that the output file text3.txt maintains...

4. Shell Programming and Scripting

Extract header data from one file and combine it with data from another file

Hi, Great minds, I have some files, in fact header files, of CTD profiler, I tried a lot C programming, could not get output as I was expected, because my programming skills are very poor, finally, joined unix forum with the hope that, I may get what I want, from you people, Here I have attached...

5. Shell Programming and Scripting

Combine columns from many files but keep them aligned in columns-shorter left column issue

Hello everyone, I searched the forum looking for answers to this but I could not pinpoint exactly what I need as I keep having trouble. I have many files each having two columns and hundreds of rows. first column is a string (can have many words) and the second column is a number.The files are...

6. Shell Programming and Scripting

Make copy of text file with columns removed (based on header)

Hello, I have some tab delimited text files with a three header rows. The headers look like, (sorry the tabs look so messy). index group Name input input input input input input input input input input input...

7. Shell Programming and Scripting

Combine columns - awk

Need some help with this ... please 60644,NJ090237_0263_GRP,NJ090237_0263_VIEW,NJ090237_0263_PSGRP,NJ090237_0263_GOLD_CSGRP,,06E:0_08E:0_09E:0_11E:0,0CE5,TDEV,34,VP_TIER...

8. Shell Programming and Scripting

Combine Columns

Input NJ090237_0263_GRP,NJ090237_0263_VIEW,NJ090237_0263_PSGRP,NJ090237_0263_GOLD_CSGRP,06E:0_08E:0_09E:0_11E:0,0CE5 NJ090237_0264_GRP,NJ090237_0263_VIEW,NJ090237_0264_PSGRP,NJ090237_0263_GOLD_CSGRP,06E:0_08E:0_09E:0_11E:0,0CE5...

9. Shell Programming and Scripting

Find columns in a file based on header and print to new file

Hello, I have to fish out some specific columns from a file based on the header value. I have the list of columns I need in a different file. I thought I could read in the list of headers I need, # file with header names of required columns in required order headers_file=$2 # read contents...

10. UNIX for Beginners Questions & Answers

How to print multiple required columns dynamically in a file using the header name?

Hi All, i am trying to print required multiple columns dynamically from a fie. But i am able to print only one column at a time. i am new to shell script, please help me on this issue. i am using below script awk -v COLT=$1 ' NR==1 { for (i=1; i<=NF; i++) { ...

LEARN ABOUT DEBIAN

numsum

NUMSUM(1)						User Contributed Perl Documentation						 NUMSUM(1)

NAME

       numsum - numsum program file

SYNOPSIS

       numsum [-iIcdhrsvxy] <FILE>

       | numsum [-iIcdhrsvxy]	(Input on STDIN from pipeline.)

       numsum [-iIcdhrsvxy]	(Input on STDIN.  Use Ctrl-D to stop.)

DESCRIPTION

       numsum will take all the numbers on stdin and return the sum of those numbers.  Currently it only processes the first number on each line.
       Besides positive numbers, it also handles negative numbers and numbers with decimals.

OPTIONS

	   -i  Only return the integer portion of the final sum.
	   -I  Only return the decimal portion of the final sum.

	   -c	   Print out the sum of each column.
	   -r	   Print out the sum of each row.

	   -x <n>  Specify a comma seperated list of columns to print.
	   -y <n>  Specify a comma seperated list of rows to print.

	   -s <string> Specify a string to use as a seperator for columns.
		       This defaults to be consecutive whitespace (s+).

	   -h  Help: You're looking at it.
	   -V  Increase verbosity.
	   -d  Debug mode.  For developers
	   -q  Quiet mode, don't print any warnings.

EXAMPLES

       Simply add up the numbers in a file.
	   $ numsum numbers.txt
	   4315

       Enter your own numbers on STDIN. The last number is the answer.
	   $ numsum
	   4
	   21
	   98
	   100
	   223

       Use it in a command pipeline.
	   $ ls -1s | grep .mp3 | numsum -c -x 5
	   72288

       Add up the total byte count in a http log file.
	   $ cat access_log | awk {'print $10'} numsum

	   or

	   numsum -c -x 10 access_log

       Add up the columns of numbers of a file.

	   $ cat columns
	   1 6 11 16 21
	   2 7 12 17 22
	   3 8 13 18 23
	   4 9 14 19 24
	   5 10 15 20 25
	   $ numsum -c columns
	   15 40 65 90 115

       Add up the 1st, 2nd and 5th columns only.

	   $ numsum -c -x 1,2,5 columns
	   15 40 115

       Add up the rows of numbers of a file.

	    $ numsum -r columns
	    55
	    60
	    65
	    70
	    75

       Add up the 2nd and 4th rows.

	    $ numsum -r -y 2,4 columns
	    60
	    70

SEE ALSO

       numaverage(1), numbound(1), numinterval(1), numnormalize(1), numgrep(1), numprocess(1), numrandom(1), numrange(1), numround(1)

COPYRIGHT

       numsum is part of the num-utils package, which is copyrighted by Suso Banderas and released under the GPL license.  Please read the COPYING
       and LICENSE files that came with the num-utils package

	 Developers can read the GOALS file and contact me about providing
       submitions or help for the project.

MORE INFO

       More info on numsum can be found at:

       http://suso.suso.org/programs/num-utils/

perl v5.10.1							    2009-10-31								 NUMSUM(1)