Transposing column to row, joining with another file, then sorting columns Post: 302358394

Sponsored Content

Top Forums Shell Programming and Scripting Transposing column to row, joining with another file, then sorting columns Post 302358394 by doobedoo on Friday 2nd of October 2009 11:11:03 AM

10-02-2009

Registered User

Transposing column to row, joining with another file, then sorting columns

Hello!
I am very new to Linux and I do not know where to begin...

I have a column with >64,000 elements (that are not in numberical order) like this:

name
2
5
9
.
.
.
64,000

I would like to transpose this column into a row that will later become the header of a very large file (>1000 rows X >64,000 columns) so that the row looks like:

name 2 5 9 . . . 64,000

Next I need to concatenate this header with the actual data file (data points are letters) so that:

name 2 5 9 . . .64,000
jim A C A . . .T
max T G A . . .T
mary T C T . . .A
.
.
.
kate A C A . . .A

Finally, I need to sort the columns so that they are in numerical order but the name column remains in the first position so that

name 1 2 3 . . .64,000
jim A A A . . .G
max C T A . . .C
mary C T T . . .C
.
.
.
kate A A T . . .G

Can anyone help me with this?

Thanks,
doob

doobedoo

View Public Profile for doobedoo

Find all posts by doobedoo

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Changing the column for a row in a text file and adding another row

Hi, I want to write a shell script which increments a particular column in a row from a text file and then adds another row below the current row with the incremented value . For Eg . if the input file has a row : abc xyz lmn 89 lm nk o p I would like the script to create something like...

2. Shell Programming and Scripting

How to convert 2 column data into multiple columns based on a keyword in a row??

Hi Friends I have the following input data in 2 columns. SNo 1 I1 Value I2 Value I3 Value SNo 2 I4 Value I5 Value I6 Value I7 Value SNo 3 I8 Value I9 Value ............... ................ SNo N

3. Shell Programming and Scripting

Subtracting each row from the first row in a single column file using awk

Hi Friends, I have a single column data like below. 1 2 3 4 5 I need the output like below. 0 1 2 3 4 where each row (including first row) subtracting from first row and the result should print below like the way shown in output file. Thanks Sid

4. Shell Programming and Scripting

Help newbie: transposing column into row (pivot)

5. UNIX for Dummies Questions & Answers

awk to print first row with forth column and last row with fifth column in each file

file with this content awk 'NR==1 {print $4} && NR==2 {print $5}' file The error is shown with syntax error; what can be done

6. UNIX for Dummies Questions & Answers

File joining and sorting

Hi, I'm having some trouble joining these two files for some reason. Here is what they look like: head * I'm using: join -a 1 -1 2 -2 1 f1 f2 -t, > joinfile.out but unfortunately nothing is happening. I did notice that I was having trouble sorting f1 and I'm not sure why using:...

7. Shell Programming and Scripting

Convert row to columns start from nth column

Dear All, We have input like this: 161 57 1378 176 1392 262 1444 441 1548 538 1611 670 1684 241 57 1378 208 1393 269 1447 444 1549 538 1610 677 1700 321 ...

8. Shell Programming and Scripting

Joining files using awk not extracting all columns from File 2

Hello All I'm joining two files using Awk by Left outer join on the file 1 File 1 1 AA 2 BB 3 CC 4 DD File 2 1 IND 100 200 300 2 AUS 400 500 600 5 USA 700 800 900

9. UNIX for Beginners Questions & Answers

Copy columns from one file into another and get sum of column values and row count

I have a file abc.csv, from which I need column 24(PurchaseOrder_TotalCost) to get the sum_of_amounts with date and row count into another file say output.csv abc.csv- UTF-8,,,,,,,,,,,,,,,,,,,,,,,,, ...

10. Shell Programming and Scripting

awk split columns to row after N number of column

I want to split this with every 5 or 50 depend on how much data the file will have. And remove the comma on the end Source file will have 001,0002,0003,004,005,0006,0007,007A,007B,007C,007E,007F,008A,008C Need Output from every 5 tab and remove the comma from end of each row ...

LEARN ABOUT LINUX

envext

ENVEXT(1)						  The Canonical Csound Reference						 ENVEXT(1)

NAME

       envext - Extracts the envelope of a file to a text file. .

SYNTAX

	   envext [-flags] soundfile

	   csound -U envext [-flags] soundfile

INITIALIZATION

       soundfile - Name of the input soundfile.

       The following flags are available for envext (The default values are stated in parenthesis):
	   -o fnam Name of output filename (newenv)
	   -w size (in seconds) of analysis window (0.25)

       The envext utility generates a text file containing time and amplitude pairs by finding the absolute peak within each window.

EXAMPLE

       Using the command (while in the manual directory):

	   csound -U envext examples/mary.wav

       will produce the a text file containing the following:

	     0.000   0.000
	     0.000   0.000
	     0.250   0.000
	     0.500   0.000
	     0.750   0.000
	     1.249   0.170
	     1.499   0.269
	     1.530   0.307
	     1.872   0.263
	     2.056   0.304
	     2.294   0.241
	     2.570   0.216
	     2.761   0.178
	     3.077   0.011
	     3.251   0.001
	     3.500   0.000

       Which shows the time for the peak amplitude within each measured window.

CREDITS

       Author: John ffitch

       1995

AUTHORS

       Barry Vercoe
       MIT Media Lab

	   Author.

       Dan Ellis
       MIT Media Lab,
		 Cambridge
		 Massachussetts

	   Author.

COPYRIGHT

5.07								    06/23/2009								 ENVEXT(1)